...
| Code Block | ||||||
|---|---|---|---|---|---|---|
| ||||||
delete from ps_accountant_codes where accountant_code='99'; |
Add Federal Sponsor Mapping Info
| Code Block | ||||||
|---|---|---|---|---|---|---|
| ||||||
insert into ps_sponsor_mappings(sponsor_code, fed_agency, reporting_agency, display_acronym, mapping_level, update_timestamp, update_user, ver_nbr, obj_id) values
('000000', 'DOD', 'DOD', 'DOD>USMA>', 1, sysdate, 'admin', 1, sys_guid());
-- First parameter is the six-digit sponsor code
-- Second parameter is the Federal Agency code
-- Third parameter is the Reporting Agency code
-- Fourth parameter is the Display Acronym
-- Other parameters can be left with the provided values |