PSPTIAURECDFNVW

(SQL View)
 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 PeopleSoft Field Type Database Column Type Description
1 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
2 RECUSE Number(5,0) INTEGER NOT NULL Record Use. Audit Option bit values
3 AUXFLAGMASK Number(10,0) DECIMAL(10) NOT NULL Auxiliary Flag Mask bit values
4 PTIA_RUAUDITRECADD Character(1) VARCHAR2(1) NOT NULL Rec Use - Audit Rec Add
5 PTIA_RUAUDITRECCHG Character(1) VARCHAR2(1) NOT NULL Rec Use - Audit Rec Chng
6 PTIA_RUAUDITRECDEL Character(1) VARCHAR2(1) NOT NULL Rec Use - Audit Rec Del
7 PTIA_RUAUDITRECSEL Character(1) VARCHAR2(1) NOT NULL Rec Use - Audit Rec Selective
8 PTIA_RUAESTATEREC Character(1) VARCHAR2(1) NOT NULL Rec Use - AE State Rec
9 PTIA_RUTEMPREC Character(1) VARCHAR2(1) NOT NULL Rec Use - Temporary Rec
10 PTIA_AFMRECTOOLS Character(1) VARCHAR2(1) NOT NULL Aux Flg Msk - PTools Rec
11 PTIA_AFMRECTOOLSMG Character(1) VARCHAR2(1) NOT NULL Aux Flg Msk - PTools Rec Mgd
12 PTIA_AFMRECSYNCS2U Character(1) VARCHAR2(1) NOT NULL Aux Flg Msk - Sync Srvr to Usr
13 PTIA_AFMRECSYNCU2S Character(1) VARCHAR2(1) NOT NULL Aux Flg Msk - Sync Usr to Srvr
14 PTIA_AFMDYNVWAPPND Character(1) VARCHAR2(1) NOT NULL Aux Flg Msk - Dyn View Append