PSPTIAUDBFLDVW

(SQL View)
 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 PeopleSoft Field Type Database Column Type Description
1 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
2 AUXFLAGMASK Number(10,0) DECIMAL(10) NOT NULL Auxiliary Flag Mask bit values
3 PTIA_AFMCHARTFIELD Character(1) VARCHAR2(1) NOT NULL Aux Flg Msk - Chartfield
4 PTIA_AFMENCRYPTFLD Character(1) VARCHAR2(1) NOT NULL Aux Flg Msk - Encrypt Field