Proposal Development (PD)
...
Update PD Proposal Status
| Code Block | ||||||
|---|---|---|---|---|---|---|
| ||||||
select * from proposal_state; |
...
| Code Block | ||||||
|---|---|---|---|---|---|---|
| ||||||
update s2s_app_submission set GG_TRACKING_ID=null where proposal_number='1234'; |
Institutional Proposal (IP)
...
Update IP Status
| Code Block | ||||||
|---|---|---|---|---|---|---|
| ||||||
select * from proposal_status; |
...
| Code Block | ||||||
|---|---|---|---|---|---|---|
| ||||||
update proposal set status_code='5' where proposal_sequence_status='ACTIVE' and proposal_number='00173838'; |
Award
...
Fix Award Stuck in 'Pending' State (Edit button doesn't appear)
...
| Code Block | ||||||
|---|---|---|---|---|---|---|
| ||||||
update award set award_sequence_status='ACTIVE' where award_sequence_status='PENDING' and award_id='111111'; |
Maintenance Tables
...
Add New State to State Table
...