PSPTIAURECDFNVW |
index back |
---|---|
RecDefn Decode View |
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 2020, www.go-faster.co.uk | PeopleTools 8.58 PTRef generated on 21-DEC-20 |