select * from proposal_state;

select proposal_number, status_code from eps_proposal where proposal_number='1234';

update eps_proposal set status_code='6' where proposal_number='1234';

select proposal_number, document_number, status_code from eps_proposal where proposal_number='1234';

update krew_doc_hdr_t set doc_hdr_stat_cd='S' where doc_hdr_id='486290';

select * from s2s_app_submission where proposal_number='1234';

update s2s_app_submission set GG_TRACKING_ID=null where proposal_number='1234';

update eps_proposal set program_announcement_title='DoD Peer Reviewed Alzheimer''s, Research Partnership Award' where proposal_number='5997'; -- The double apostrophe in Alzheimer''s results in a single apostrophe in the final output
update s2s_opportunity set opportunity_title='DoD Peer Reviewed Alzheimer''s, Research Partnership Award' where proposal_number='5997';

select proposal_number, budget_id, final_version_flag, status_code from eps_proposal_budget_ext where proposal_number='1234'; -- Status code of 1 = Complete, 2 = Incomplete

select * from eps_prop_idc_rate where budget_id='2345';

 update eps_prop_idc_rate set fiscal_year='2020' where budget_id='2345' and unrecovered_fna_id='3';

exec add_delegate_central_admin('mgoldb10');

select * from proposal_status;

select proposal_number, proposal_id, proposal_sequence_status, status_code from proposal where proposal_sequence_status='ACTIVE' and proposal_number='00173838';

update proposal set status_code='5' where proposal_sequence_status='ACTIVE' and proposal_number='00173838';

select award_number, sequence_number, award_id, award_sequence_status from award where award_number='100000-00001' order by sequence_number;

update award set award_sequence_status='ACTIVE' where award_sequence_status='PENDING' and award_id='111111';

-- Only run this on awards that don't have Time & Money already entered! If the award has dates and dollars, the problem is something else (and running this will overwrite the existing date data)
update award_amount_info set obligation_expiration_date=final_expiration_date where award_number='102734-00001';

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.

exec remove_inactive_unit_perms('efitzp01'); -- Replace with user's UTLN

exec give_user_admin_permissions('efitzp01'); -- Replace with user's UTLN

select * from ps_grant_prefix order by grant_prefix;

insert into ps_grant_prefix values ('ABC', sysdate, 'admin', 1, sys_guid());

update KCSO.TUPS_GRANT set PS_RETURN_STATUS = ' '  where award_number='103786-00001' and ps_ras_transaction_id = '000000037066' and PS_RETURN_STATUS = 'E';

select accountant_code, user_id from ps_accountant_codes order by to_number(accountant_code);

update ps_accountant_codes set user_id='efitzp01' where accountant_code='99';

insert into ps_accountant_codes values ('99', 'efitzp01', sysdate, 'admin', 1, sys_guid());

delete from ps_accountant_codes where accountant_code='99';

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