Skip to content

create fec_fitem_sched_a/b_2027_2028 partition tables and related objects #6700

Description

@fecjjeng

What we’re after

With new cycle 2025_2026 partition for tables disclosure.fec_fitem_sched_a/b for the new cyclde (disclosure.fec_fitem_sched_a/b_2027_2028). The tables were already created when encountered the incoming data for cycle 2027/2028 so we will not miss any incoming data. However, official migration script is need to add these to the version controlled base of the database structure.

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)

  • Create migration script to "officially" add these partition tables disclosure.fec_fitem_sched_a/b_2027_2028 and indexes
  • Modify DMS tasks to include these new tables in existing migration tasks

Completion criteria

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

  • partition tables disclosure.fec_fitem_sched_a/b_2027_2028 "officially" added with proper indexes as the other partition tables.
  • tables disclosure.fec_fitem_sched_a/b_2027_2028 added to DMS transfer tasks

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)

Activity

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

Type

No type

Projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions