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 |