search

US-EPA-CAMD / easey-ui

Project Management repo for EPA Clean Air Markets Division (CAMD) Business Suite of applications
MIT License
0 stars 0 forks source link

Migrate existing submissions data #5796

Open JanellC opened 1 year ago

JanellC commented 1 year ago

Currently the system does not have the existing submissions data. Need to pull over and archive previous submissions data in cloud.gov. This data is also needed in order to show previously submitted by and submitted dates in the ecmps ui and on reports.

Convert the Oracle Submission_Log and Submission_Stage_Log tables to Postgres and add them to the EM Module Informatica ETL.

submission_log.txt submission_stage_log.txt

NOTE: A view may need to be created to join/union previously submitted data with the new submission_set and submission_queue data.

JanellC commented 1 year ago

@JanellC add more context on why we are doing this work

ibarra-michelle commented 1 year ago

@JanellC can we talk about this ticket DSU Thursday? We need to add more details, thanks.

JanellC commented 1 year ago

@jwhitehead77 add information on what needs to be completed here. DPC will complete this work