Add Presidential tables for 2008 and 2012

[fecjjeng]

What we’re after

Jerry will added 2008 and 2012 presidential tables and updated Informatica workflow to populate our internal databases (FECP).
This ticket is for tasks required to add presidential 2008 and 2102 tables and updated related views to include 2008 and 2012 presidential tables in Postgresql databases.

New tables needed:
disclosure.pres_ca_cm_sched_a_join_08d
disclosure.pres_nml_ca_cm_link_08d
disclosure.pres_ca_cm_sched_state_08d
disclosure.pres_ca_cm_sched_link_sum_08d
disclosure.pres_nml_sched_a_08d
disclosure.pres_nml_sched_b_08d
disclosure.pres_f3p_totals_ca_cm_link_08d
disclosure.pres_nml_f3p_totals_08d
disclosure.pres_nml_form_3p_08d

disclosure.pres_ca_cm_sched_a_join_12d
disclosure.pres_nml_ca_cm_link_12d
disclosure.pres_ca_cm_sched_state_12d
disclosure.pres_ca_cm_sched_link_sum_12d
disclosure.pres_nml_sched_a_12d
disclosure.pres_nml_sched_b_12d
disclosure.pres_f3p_totals_ca_cm_link_12d
disclosure.pres_nml_f3p_totals_12d
disclosure.pres_nml_form_3p_12d

Existing views need to be updated to include these two cycles:
public.ofec_presidential_coverage_date_vw
public.ofec_presidential_by_candidate_vw
public.ofec_presidential_by_state_vw
public.ofec_presidential_financial_summary_vw
public.ofec_presidential_by_size_vw

Related ticket(s)

(Include the tickets that either came before, after, or are happening in tandem with this new ticket)

• [ ]

Action item(s)

(These are the smaller tasks that should happen in order to complete this work)

• [ ]

Completion criteria

(What does the end state look like - as long as this task(s) is done, this work is complete)

• Add presidential 2008 and 2012 base tables
• Updated related views to include 2008 and 2012 presidential tables
• Created DMS tasks to pull presidential 2008 and 2012 data from FECP database to Aurora postgresql database on demand.

References/resources/technical considerations

(Is there sample code or a screenshot you can include to highlight a particular issue? Here is where you reinforce why this work is important)

[fecjjeng]

Jerry had added 2008 and 2012 presidential tables and populate these tables in our internal databases (FECP) on 6/23/2023, upon approval of RFC 1949 (for 2008 tables) and RFC 1950 (for 2012 tables).