...

Update PD Proposal Status

Request: "Please update proposal number 1234 to the 'Approved & Submitted' status."

Example Ticket: INC0712970

select * from proposal_state;

...

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

Request: Proposal encounters an error during routing referencing an invalid fiscal year. ("Fiscal year must be between X and Y")

Example Ticket: INC0729118

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

...

Remove Previous Grants.gov Tracking ID from PD

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

Example Ticket: INC0712387

select * from s2s_app_submission where proposal_number='1234';

...

Institutional Proposal (IP)

...

Update IP Status

Request: "Please update the status of IP ####### to 'Not Funded'."

select * from proposal_status;

...

Fix Award Stuck in 'Pending' State (Edit button doesn't appear)

Request: "Edit button does not appear for award 100000-00001."

Example Ticket: INC0728472

select award_number, sequence_number, award_id, award_sequence_status from award where award_number='100000-00001' order by sequence_number;

...

Add New State to State Table

Request: "Please add the states of (country) to the RAS state table."

Example Ticket: INC0718617

insert into krlc_st_t values ('SS', 'CC', sys_guid(), 1, 'State Name', 'Y'); 
-- Replace SS with two-digit state/province abbreviation; these are used in S2S submissions so they should match the official designations.
-- Replace CC with the two-digit country abbreviation (found in the Country maintenance table)
-- Replace State Name with the name of the state/province; this is what will display in the drop-down. Be careful about copy-pasting special characters as they may not show up correctly.

Grant Admin permissions to a user (full access)

exec give_user_admin_permissions('efitzp01'); -- Replace with user's UTLN

PeopleSoft Integration

...

Add New PeopleSoft Grant Prefix

...

delete from ps_accountant_codes where accountant_code='99';

Grant Admin permissions to a user (full access)

exec give_user_admin_permissions('efitzp01'); -- Replace with user's UTLN