Migrate off dimcmteproperties

[LindsayYoung]

Warehouse	Postgres
dimcmteproperties	disclosure.fec_vsum_f1

This might be the tricky one to make sure we have the same fields

"We're also still using dimcmteproperties, since I didn't see another place to get treasurer name and address, custodian name and address, fax number, leadership pac, lobbyist registrant pac flag, and party committee type. Are those fields available in FECP? Or can we drop them?"
see full conversation: https://github.com/18F/openFEC/issues/1327

[jontours]

The only table in the database that contains these fields in the database is disclosure.nml_form_1. @PaulClark2 @jwchumley It seems that replacing dimcmteproperties with fec_vsum_f1 is a valid mapping to support migrating off that data warehouse table. Can this please be confirmed? Thanks.

[PaulClark2]

Yes, that should work.

fec_vsum_f1 will not include information from nml_form_1z

@jwchumley can you think of another way to replace dimcmteproperties?

[jontours]

@PaulClark2 We are about to merge this into the release and forgot about the column expire_date in dimcmteproperties, is that column deprecated? Is it important to still have?

[PaulClark2]

I don't think it's important. We can determine the valid date range for a Form 1 based on it's receipt date and the receipt date of the F1 that amends (if it's amended).

[jontours]

Thanks @PaulClark2