Code Block

language	sql
theme	Eclipse
title	3. Update status of selected proposal

update eps_proposal set status_code='6' where proposal_number='1234';

Remove Previous Grants.gov Tracking ID from PD

Request: Cannot remove previous Grants.gov tracking ID from proposal

Example Ticket: INC0712387

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';

Fix Missing/Invalid Fiscal Year on PD Unrecovered F&A

...

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';

Request: Cannot remove previous Grants.gov tracking ID from proposal

Example Ticket: INC0712387

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';

...