Open jwchumley opened 5 years ago
@jwchumley I've created staging.ref_party_type on FECPTST. We'll need to vet the committee lists. I think there are a few more state party committees approved by AO last year that need to be added. There are a number of committees that we need to confirm when they were active. You'll find some rows with fec_election_yr = 9999. We'll need to change those to real election years.
This is a place holder. For now I'm tracking the committees to see if this is still a problem. If it is still a problem we will create a table to hold these committees and create a script that uses the table to maintain the org_tp. Here are the details for the table data.
National Party Committees - These need to be identifiable for things like data summaries. State Party Committees - These also need to be identifiable for separate treatement Inaugural Committees - These file form 13 so the website front end needs to display them differently from form 3X filers Host Committees - These file form 4 so the website front end needs to display them differently from form 3X filers. Convention Committees - These have no special display issues but should be able to be identified as separate from other committees for summary purposes.
Solution: Create a Party_type table that includes a column for Party_type as follows: N - National Party Committee S- State Party Committee I - Inaugural Committee K - Convention Committee H - Host Committee
Update nightly process scripts so that form 1 and 1z don't change the org_type for committees in the table. to update the org_type with these codes for the committees in the table