PeopleSoft Correction Mode

JointLantic

6 years ago

PeopleSoft Correction Mode

PeopleSoft Correction Mode

Mode of Correction: Select to update any rows (history, current, and future) in an effective-dated record. Use only with effective-dated records. This information is translated to correct history at runtime.

You can check all %mode PeopleSoft by SQL

SELECT a.CLASSID, a.MENUNAME, a.BARNAME, a.BARITEMNAME, a.PNLITEMNAME, a.DISPLAYONLY
, a.AUTHORIZEDACTIONS 
,(SELECT b.PAGEACCESSDESCR FROM PSPGEACCESSDESC b WHERE b.AUTHORIZEDACTIONS= a.AUTHORIZEDACTIONS ) PAGEACCESSDESCR

FROM PSAUTHITEM a

ORDER BY CLASSID ,<span style="color: inherit; font-size: inherit;">MENUNAME</span>

SELECT a.CLASSID, a.MENUNAME, a.BARNAME, a.BARITEMNAME, a.PNLITEMNAME, a.DISPLAYONLY

, a.AUTHORIZEDACTIONS

,(SELECT b.PAGEACCESSDESCR FROM PSPGEACCESSDESC b WHERE b.AUTHORIZEDACTIONS= a.AUTHORIZEDACTIONS ) PAGEACCESSDESCR

FROM PSAUTHITEM a

ORDER BY CLASSID ,<span style="color: inherit; font-size: inherit;">MENUNAME</span>