PSPTIAURECFLDVW

index back

RecFld Decode View

Decode of the USEEDIT field on PSRECFIELDDB.
SELECT RECNAME , FIELDNAME , USEEDIT , CASE (%Sql(PSPTIA_USEEDIT_BIT, USEEDIT, 0)) WHEN 1 THEN 'Y' ELSE 'N' END , CASE (%Sql(PSPTIA_USEEDIT_BIT, USEEDIT, 1)) WHEN 1 THEN 'Y' ELSE 'N' END , CASE (%Sql(PSPTIA_USEEDIT_BIT, USEEDIT, 2)) WHEN 1 THEN 'Y' ELSE 'N' END , CASE (%Sql(PSPTIA_USEEDIT_BIT, USEEDIT, 3)) WHEN 1 THEN 'Y' ELSE 'N' END , CASE (%Sql(PSPTIA_USEEDIT_BIT, USEEDIT, 4)) WHEN 1 THEN 'Y' ELSE 'N' END , CASE (%Sql(PSPTIA_USEEDIT_BIT, USEEDIT, 5)) WHEN 1 THEN 'Y' ELSE 'N' END , CASE (%Sql(PSPTIA_USEEDIT_BIT, USEEDIT, 6)) WHEN 1 THEN 'Y' ELSE 'N' END , CASE (%Sql(PSPTIA_USEEDIT_BIT, USEEDIT, 7)) WHEN 1 THEN 'Y' ELSE 'N' END , CASE (%Sql(PSPTIA_USEEDIT_BIT, USEEDIT, 8)) WHEN 1 THEN 'Y' ELSE 'N' END , CASE (%Sql(PSPTIA_USEEDIT_BIT, USEEDIT, 9)) WHEN 1 THEN 'Y' ELSE 'N' END , CASE (%Sql(PSPTIA_USEEDIT_BIT, USEEDIT, 10)) WHEN 1 THEN 'Y' ELSE 'N' END , CASE (%Sql(PSPTIA_USEEDIT_BIT, USEEDIT, 11)) WHEN 1 THEN 'Y' ELSE 'N' END , CASE (%Sql(PSPTIA_USEEDIT_BIT, USEEDIT, 12)) WHEN 1 THEN 'Y' ELSE 'N' END , CASE (%Sql(PSPTIA_USEEDIT_BIT, USEEDIT, 13)) WHEN 1 THEN 'Y' ELSE 'N' END , CASE (%Sql(PSPTIA_USEEDIT_BIT, USEEDIT, 14)) WHEN 1 THEN 'Y' ELSE 'N' END , CASE (%Sql(PSPTIA_USEEDIT_BIT, USEEDIT, 15)) WHEN 1 THEN 'Y' ELSE 'N' END , CASE (%Sql(PSPTIA_USEEDIT_BIT, USEEDIT, 16)) WHEN 1 THEN 'Y' ELSE 'N' END , CASE (%Sql(PSPTIA_USEEDIT_BIT, USEEDIT, 17)) WHEN 1 THEN 'Y' ELSE 'N' END , CASE (%Sql(PSPTIA_USEEDIT_BIT, USEEDIT, 18)) WHEN 1 THEN 'Y' ELSE 'N' END , CASE (%Sql(PSPTIA_USEEDIT_BIT, USEEDIT, 19)) WHEN 1 THEN 'Y' ELSE 'N' END , CASE (%Sql(PSPTIA_USEEDIT_BIT, USEEDIT, 20)) WHEN 1 THEN 'Y' ELSE 'N' END , CASE (%Sql(PSPTIA_USEEDIT_BIT, USEEDIT, 21)) WHEN 1 THEN 'Y' ELSE 'N' END , CASE (%Sql(PSPTIA_USEEDIT_BIT, USEEDIT, 22)) WHEN 1 THEN 'Y' ELSE 'N' END , CASE (%Sql(PSPTIA_USEEDIT_BIT, USEEDIT, 23)) WHEN 1 THEN 'Y' ELSE 'N' END , CASE (%Sql(PSPTIA_USEEDIT_BIT, USEEDIT, 24)) WHEN 1 THEN 'Y' ELSE 'N' END , CASE (%Sql(PSPTIA_USEEDIT_BIT, USEEDIT, 25)) WHEN 1 THEN 'Y' ELSE 'N' END , CASE (%Sql(PSPTIA_USEEDIT_BIT, USEEDIT, 26)) WHEN 1 THEN 'Y' ELSE 'N' END , CASE (%Sql(PSPTIA_USEEDIT_BIT, USEEDIT, 27)) WHEN 1 THEN 'Y' ELSE 'N' END , CASE (%Sql(PSPTIA_USEEDIT_BIT, USEEDIT, 28)) WHEN 1 THEN 'Y' ELSE 'N' END , CASE (%Sql(PSPTIA_USEEDIT_BIT, USEEDIT, 29)) WHEN 1 THEN 'Y' ELSE 'N' END , CASE (%Sql(PSPTIA_USEEDIT_BIT, USEEDIT, 30)) WHEN 1 THEN 'Y' ELSE 'N' END , CASE (%Sql(PSPTIA_USEEDIT_BIT, USEEDIT, 31)) WHEN 1 THEN 'Y' ELSE 'N' END FROM PSRECFIELDDB

PeopleSoft Field NameField TypeColumn TypeDescription
RECNAMECharacter(15)VARCHAR2(15) NOT NULLRecord (Table) Name (see PSRECDEFN).
FIELDNAMECharacter(18)VARCHAR2(18) NOT NULLField Name (see PSDBFIELD).
USEEDITNumber(10,0)DECIMAL(10) NOT NULLField Use and Edit Flags- USEEDIT reference
PTIA_UEKEYCharacter(1)VARCHAR2(1) NOT NULLUse Edit - Key
PTIA_UEDUPLKEYCharacter(1)VARCHAR2(1) NOT NULLUse Edit - Duplicate Order Key
PTIA_UESYSTEMCharacter(1)VARCHAR2(1) NOT NULLUse Edit - System Maintained
PTIA_UEAUDFLDADDCharacter(1)VARCHAR2(1) NOT NULLUse Edit - Audit Field Add
PTIA_UEALTKEYCharacter(1)VARCHAR2(1) NOT NULLUse Edit - Alternate Srch Key
PTIA_UELISTITEMCharacter(1)VARCHAR2(1) NOT NULLUse Edit - List Box Item
PTIA_UEDESCKEYCharacter(1)VARCHAR2(1) NOT NULLUse Edit - Descending Key
PTIA_UEAUDFLDCHGCharacter(1)VARCHAR2(1) NOT NULLUse Edit - Audit Field Change
PTIA_UEREQUIREDCharacter(1)VARCHAR2(1) NOT NULLUse Edit - Required Field
PTIA_UEEDITXLATCharacter(1)VARCHAR2(1) NOT NULLUse Edit - Translate Tbl Edit
PTIA_UEAUDFLDDELCharacter(1)VARCHAR2(1) NOT NULLUse Edit - Audit Field Delete
PTIA_UESEARCHKEYCharacter(1)VARCHAR2(1) NOT NULLUse Edit - Search Key
PTIA_UERESNDTEDITCharacter(1)VARCHAR2(1) NOT NULLUse Edit - Reasonable Dt Edit
PTIA_UEYESNOCharacter(1)VARCHAR2(1) NOT NULLUse Edit - Yes/No Edit
PTIA_UEEDITTABLECharacter(1)VARCHAR2(1) NOT NULLUse Edit - Table Edit
PTIA_UEAUTOUPDATECharacter(1)VARCHAR2(1) NOT NULLUse Edit - Auto Update
PTIA_UEGETFNMPRMPTCharacter(1)VARCHAR2(1) NOT NULLUse Edit - Get File Name Prmpt
PTIA_UEGETDNMPRMPTCharacter(1)VARCHAR2(1) NOT NULLUse Edit - Get Dir Name Prompt
PTIA_UEFROMSRCHFLDCharacter(1)VARCHAR2(1) NOT NULLUse Edit - From Search Field
PTIA_UETHRUSRCHFLDCharacter(1)VARCHAR2(1) NOT NULLUse Edit - Through Srch Field
PTIA_UEONEZEROCharacter(1)VARCHAR2(1) NOT NULLUse Edit - One/Zero Table Edit
PTIA_UEDISADVSRCHCharacter(1)VARCHAR2(1) NOT NULLUse Edit - Disable Adv Search
PTIA_UEFILEREFCharacter(1)VARCHAR2(1) NOT NULLUse Edit - File Reference
PTIA_UEUSEDFLTLBLCharacter(1)VARCHAR2(1) NOT NULLUse Edit - Default Label
PTIA_UEDEFSRCHFLDCharacter(1)VARCHAR2(1) NOT NULLUse Edit - Default Search Fld
PTIA_UETRANSLATECharacter(1)VARCHAR2(1) NOT NULLUse Edit - Translate
PTIA_UETRIGGRMAINTCharacter(1)VARCHAR2(1) NOT NULLUse Edit - Trigger Maintained
PTIA_UEPRMPTSRCHEDCharacter(1)VARCHAR2(1) NOT NULLUse Edit - Prompt Srch Events
PTIA_UESEARCHEDITCharacter(1)VARCHAR2(1) NOT NULLUse Edit - Search Edit
PTIA_UETYPEAHDPRMPCharacter(1)VARCHAR2(1) NOT NULLUse Edit - Type Ahead Prompt
PTIA_UETYPEAHDSRCHCharacter(1)VARCHAR2(1) NOT NULLUse Edit - Type Ahead Srch Rec
PTIA_UEPERSISTDATACharacter(1)VARCHAR2(1) NOT NULLUse Edit - Persist Data
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19