Update PD Proposal Status
1. View proposal status values
select * from proposal_state;
2. View status of selected proposal
select proposal_number, status_code from eps_proposal where proposal_number='1234';
3. Update status of selected proposal
update eps_proposal set status_code='6' where proposal_number='1234';
Fix Fiscal Year on PD Unrecovered F&A
1. Find budget ID for selected proposal
select proposal_number, budget_id, final_version_flag, status_code from eps_proposal_budget_ext where proposal_number='1234'; -- Status code of 1 = Complete, 2 = Incomplete
2. View Unrecovered F&A lines for selected budget ID
select * from eps_prop_idc_rate where budget_id='2345';
3. Update Fiscal Year value for selected UF&A line
update eps_prop_idc_rate set fiscal_year='2020' where budget_id='2345' and unrecovered_fna_id='3';