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 Name Field Type Column Type Description
FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
AUXFLAGMASK Number(10,0) DECIMAL(10) NOT NULL Auxiliary Flag Mask bit values
PTIA_AFMCHARTFIELD Character(1) VARCHAR2(1) NOT NULL Aux Flg Msk - Chartfield
PTIA_AFMENCRYPTFLD Character(1) VARCHAR2(1) NOT NULL Aux Flg Msk - Encrypt Field
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19