...
| 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
...