PSPTIAUDBFLDVW

index back

DBField Decode View

Decode of the AUXFLAGMASK field on PSDBFIELD.
SELECT FIELDNAME , AUXFLAGMASK , CASE (%Sql(PSPTIA_USEEDIT_BIT, AUXFLAGMASK, 0)) WHEN 1 THEN 'Y' ELSE 'N' END , CASE (%Sql(PSPTIA_USEEDIT_BIT, AUXFLAGMASK, 16)) WHEN 1 THEN 'Y' ELSE 'N' END FROM PSDBFIELD

PeopleSoft Field NameField TypeColumn TypeDescription
FIELDNAMECharacter(18)VARCHAR2(18) NOT NULLField Name (see PSDBFIELD).
AUXFLAGMASKNumber(10,0)DECIMAL(10) NOT NULLAuxiliary Flag Mask bit values
PTIA_AFMCHARTFIELDCharacter(1)VARCHAR2(1) NOT NULLAux Flg Msk - Chartfield
PTIA_AFMENCRYPTFLDCharacter(1)VARCHAR2(1) NOT NULLAux Flg Msk - Encrypt Field
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19