Page Comparison

...

Code Block

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

...

Remove Previous Grants.gov Tracking ID from PD

Code Block

language	sql
theme	Eclipse
title	1. View Grants.gov info for selected proposal

select * from s2s_app_submission where proposal_number='1234';

Code Block

language	sql
theme	Eclipse
title	2. Remove value for GG Tracking ID from selected proposal

update s2s_app_submission set GG_TRACKING_ID=null where proposal_number='1234';

...