Page Comparison

...

Code Block

language	sql
title	1. View proposal status values

select * from proposal_state;

Code Block

language	sql
title	2. View status of selected proposal

select proposal_number, status_code from eps_proposal where proposal_number='1234';

Code Block

language	sql
title	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

Code Block

language	sql
title	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

Code Block

language	sql
title	2. View Unrecovered F&A lines for selected budget ID

select * from eps_prop_idc_rate where budget_id='2345';

Code Block

language	sql
title	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';

Version	Old Version 2	New Version 3
Changes made by	Chris Smith	Chris Smith
Saved on	May 22, 2019	May 22, 2019

Versions Compared

Key

Fix Fiscal Year on PD Unrecovered F&A