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 NameField TypeColumn TypeDescription
RECNAMECharacter(15)VARCHAR2(15) NOT NULLRecord (Table) Name (see PSRECDEFN).
RECUSENumber(5,0)INTEGER NOT NULLRecord Use. Audit Option bit values
AUXFLAGMASKNumber(10,0)DECIMAL(10) NOT NULLAuxiliary Flag Mask bit values
PTIA_RUAUDITRECADDCharacter(1)VARCHAR2(1) NOT NULLRec Use - Audit Rec Add
PTIA_RUAUDITRECCHGCharacter(1)VARCHAR2(1) NOT NULLRec Use - Audit Rec Chng
PTIA_RUAUDITRECDELCharacter(1)VARCHAR2(1) NOT NULLRec Use - Audit Rec Del
PTIA_RUAUDITRECSELCharacter(1)VARCHAR2(1) NOT NULLRec Use - Audit Rec Selective
PTIA_RUAESTATERECCharacter(1)VARCHAR2(1) NOT NULLRec Use - AE State Rec
PTIA_RUTEMPRECCharacter(1)VARCHAR2(1) NOT NULLRec Use - Temporary Rec
PTIA_AFMRECTOOLSCharacter(1)VARCHAR2(1) NOT NULLAux Flg Msk - PTools Rec
PTIA_AFMRECTOOLSMGCharacter(1)VARCHAR2(1) NOT NULLAux Flg Msk - PTools Rec Mgd
PTIA_AFMRECSYNCS2UCharacter(1)VARCHAR2(1) NOT NULLAux Flg Msk - Sync Srvr to Usr
PTIA_AFMRECSYNCU2SCharacter(1)VARCHAR2(1) NOT NULLAux Flg Msk - Sync Usr to Srvr
PTIA_AFMDYNVWAPPNDCharacter(1)VARCHAR2(1) NOT NULLAux Flg Msk - Dyn View Append
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19