...
| Code Block |
|---|
| language | sql |
|---|
| theme | Eclipse |
|---|
| title | 3. Update status of selected proposal |
|---|
|
update eps_proposal set status_code='6' where proposal_number='1234'; |
Side Note: Besides updating status_code for the proposal, we may also need to make sure the proposal's document status matches the new proposal status_code. For example, if we change the proposal status to 'cancelled', we also need to make sure the document status is set to 'cancelled'. In document table 'krew_doc_hdr_t', column 'doc_hdr_id' is the document number.
| Code Block |
|---|
| language | sql |
|---|
| theme | Eclipse |
|---|
| title | Find document number for PD proposal |
|---|
|
select proposal_number, document_number, status_code from eps_proposal where proposal_number='1234'; |
| Code Block |
|---|
| language | sql |
|---|
| theme | Eclipse |
|---|
| title | update PD proposal document status |
|---|
|
update krew_doc_hdr_t set doc_hdr_stat_cd='S' where doc_hdr_id='486290'; |
Remove Previous Grants.gov Tracking ID from PD
Request: Cannot remove previous Grants.gov tracking ID from proposal
...
| Code Block |
|---|
| language | sql |
|---|
| theme | Eclipse |
|---|
| title | 2. Insert a new grant prefix |
|---|
|
insert into ps_grant_prefix values ('ABC', sysdate, 'admin', 1, sys_guid()); |
Error in Fund Source / Grants Integration - Change the status from Error so that the row processes again.
Request: User error occurred for some reason in the fund/grant and the user wants the proposal to be "reset" so that PeopleSoft processes it again.
Example Ticket: INC0917104
| Code Block |
|---|
| language | sql |
|---|
| theme | Eclipse |
|---|
| title | 1. Reset PS return status on TUPS_GRANT |
|---|
|
update KCSO.TUPS_GRANT set PS_RETURN_STATUS = ' ' where award_number='103786-00001' and ps_ras_transaction_id = '000000037066' and PS_RETURN_STATUS = 'E'; |
Add/Update PeopleSoft Accountant Code assignments
...