Versions Compared

Version Old Version 6 New Version 7
Changes made by

Chris Smith

Chris Smith

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Code Block
languagesql
themeEclipse
title2. If no ACTIVE version, set the PENDING version to ACTIVE
update award set award_sequence_status='ACTIVE' where award_sequence_status='PENDING' and award_id='111111';


Add New PeopleSoft Grant Prefix

Code Block
languagesql
themeEclipse
title1. View current grant prefixes
select * from ps_grant_prefix order by grant_prefix;
Code Block
languagesql
themeEclipse
titleInsert a new grant prefix
insert into ps_grant_prefix values ('ABC', sysdate, 'admin', 1, sys_guid());