PSPTIAURECDFNVW

index back

RecDefn Decode View

Decode of the RECUSE and AUXFLAGMASK fields on PSRECDEFN.
SELECT RECNAME , AUXFLAGMASK , RECUSE , CASE (%Sql(PSPTIA_USEEDIT_BIT, RECUSE, 0)) WHEN 1 THEN 'Y' ELSE 'N' END , CASE (%Sql(PSPTIA_USEEDIT_BIT, RECUSE, 1)) WHEN 1 THEN 'Y' ELSE 'N' END , CASE (%Sql(PSPTIA_USEEDIT_BIT, RECUSE, 2)) WHEN 1 THEN 'Y' ELSE 'N' END , CASE (%Sql(PSPTIA_USEEDIT_BIT, RECUSE, 3)) WHEN 1 THEN 'Y' ELSE 'N' END , CASE (%Sql(PSPTIA_USEEDIT_BIT, RECUSE, 4)) WHEN 1 THEN 'Y' ELSE 'N' END , CASE (%Sql(PSPTIA_USEEDIT_BIT, RECUSE, 5)) WHEN 1 THEN 'Y' ELSE 'N' END , CASE (%Sql(PSPTIA_USEEDIT_BIT, AUXFLAGMASK, 16)) WHEN 1 THEN 'Y' ELSE 'N' END , CASE (%Sql(PSPTIA_USEEDIT_BIT, AUXFLAGMASK, 17)) WHEN 1 THEN 'Y' ELSE 'N' END , CASE (%Sql(PSPTIA_USEEDIT_BIT, AUXFLAGMASK, 19)) WHEN 1 THEN 'Y' ELSE 'N' END , CASE (%Sql(PSPTIA_USEEDIT_BIT, AUXFLAGMASK, 20)) WHEN 1 THEN 'Y' ELSE 'N' END , CASE (%Sql(PSPTIA_USEEDIT_BIT, AUXFLAGMASK, 21)) WHEN 1 THEN 'Y' ELSE 'N' END FROM PSRECDEFN

PeopleSoft Field Name Field Type Column Type Description
RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
RECUSE Number(5,0) INTEGER NOT NULL Record Use. Audit Option bit values
AUXFLAGMASK Number(10,0) DECIMAL(10) NOT NULL Auxiliary Flag Mask bit values
PTIA_RUAUDITRECADD Character(1) VARCHAR2(1) NOT NULL Rec Use - Audit Rec Add
PTIA_RUAUDITRECCHG Character(1) VARCHAR2(1) NOT NULL Rec Use - Audit Rec Chng
PTIA_RUAUDITRECDEL Character(1) VARCHAR2(1) NOT NULL Rec Use - Audit Rec Del
PTIA_RUAUDITRECSEL Character(1) VARCHAR2(1) NOT NULL Rec Use - Audit Rec Selective
PTIA_RUAESTATEREC Character(1) VARCHAR2(1) NOT NULL Rec Use - AE State Rec
PTIA_RUTEMPREC Character(1) VARCHAR2(1) NOT NULL Rec Use - Temporary Rec
PTIA_AFMRECTOOLS Character(1) VARCHAR2(1) NOT NULL Aux Flg Msk - PTools Rec
PTIA_AFMRECTOOLSMG Character(1) VARCHAR2(1) NOT NULL Aux Flg Msk - PTools Rec Mgd
PTIA_AFMRECSYNCS2U Character(1) VARCHAR2(1) NOT NULL Aux Flg Msk - Sync Srvr to Usr
PTIA_AFMRECSYNCU2S Character(1) VARCHAR2(1) NOT NULL Aux Flg Msk - Sync Usr to Srvr
PTIA_AFMDYNVWAPPND Character(1) VARCHAR2(1) NOT NULL Aux Flg Msk - Dyn View Append
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19