Page Comparison

...

Code Block

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

Add/Update PeopleSoft Accountant Code assignments

Code Block

language	sql
theme	Eclipse
title	1. View current accountant code assignments

select accountant_code, user_id from ps_accountant_codes;

Code Block

language	sql
theme	Eclipse
title	2a. Assign a new user to an existing accountant code

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

Code Block

language	sql
theme	Eclipse
title	2b. Create a new accountant code for the given user

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

Code Block

language	sql
theme	Eclipse
title	2c. Remove an existing accountant code

delete from ps_accountant_codes where accountant_code='99';

...