...
| Code Block | ||||||
|---|---|---|---|---|---|---|
| ||||||
update award set award_sequence_status='ACTIVE' where award_sequence_status='PENDING' and award_id='111111'; |
Add New State to State Table
| Code Block | ||||||
|---|---|---|---|---|---|---|
| ||||||
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. |
Add New PeopleSoft Grant Prefix
| Code Block | ||||||
|---|---|---|---|---|---|---|
| ||||||
select * from ps_grant_prefix order by grant_prefix; |
...