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 Name Field Type Column Type Description
RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
USEEDIT Number(10,0) DECIMAL(10) NOT NULL Field Use and Edit Flags- USEEDIT reference
PTIA_UEKEY Character(1) VARCHAR2(1) NOT NULL Use Edit - Key
PTIA_UEDUPLKEY Character(1) VARCHAR2(1) NOT NULL Use Edit - Duplicate Order Key
PTIA_UESYSTEM Character(1) VARCHAR2(1) NOT NULL Use Edit - System Maintained
PTIA_UEAUDFLDADD Character(1) VARCHAR2(1) NOT NULL Use Edit - Audit Field Add
PTIA_UEALTKEY Character(1) VARCHAR2(1) NOT NULL Use Edit - Alternate Srch Key
PTIA_UELISTITEM Character(1) VARCHAR2(1) NOT NULL Use Edit - List Box Item
PTIA_UEDESCKEY Character(1) VARCHAR2(1) NOT NULL Use Edit - Descending Key
PTIA_UEAUDFLDCHG Character(1) VARCHAR2(1) NOT NULL Use Edit - Audit Field Change
PTIA_UEREQUIRED Character(1) VARCHAR2(1) NOT NULL Use Edit - Required Field
PTIA_UEEDITXLAT Character(1) VARCHAR2(1) NOT NULL Use Edit - Translate Tbl Edit
PTIA_UEAUDFLDDEL Character(1) VARCHAR2(1) NOT NULL Use Edit - Audit Field Delete
PTIA_UESEARCHKEY Character(1) VARCHAR2(1) NOT NULL Use Edit - Search Key
PTIA_UERESNDTEDIT Character(1) VARCHAR2(1) NOT NULL Use Edit - Reasonable Dt Edit
PTIA_UEYESNO Character(1) VARCHAR2(1) NOT NULL Use Edit - Yes/No Edit
PTIA_UEEDITTABLE Character(1) VARCHAR2(1) NOT NULL Use Edit - Table Edit
PTIA_UEAUTOUPDATE Character(1) VARCHAR2(1) NOT NULL Use Edit - Auto Update
PTIA_UEGETFNMPRMPT Character(1) VARCHAR2(1) NOT NULL Use Edit - Get File Name Prmpt
PTIA_UEGETDNMPRMPT Character(1) VARCHAR2(1) NOT NULL Use Edit - Get Dir Name Prompt
PTIA_UEFROMSRCHFLD Character(1) VARCHAR2(1) NOT NULL Use Edit - From Search Field
PTIA_UETHRUSRCHFLD Character(1) VARCHAR2(1) NOT NULL Use Edit - Through Srch Field
PTIA_UEONEZERO Character(1) VARCHAR2(1) NOT NULL Use Edit - One/Zero Table Edit
PTIA_UEDISADVSRCH Character(1) VARCHAR2(1) NOT NULL Use Edit - Disable Adv Search
PTIA_UEFILEREF Character(1) VARCHAR2(1) NOT NULL Use Edit - File Reference
PTIA_UEUSEDFLTLBL Character(1) VARCHAR2(1) NOT NULL Use Edit - Default Label
PTIA_UEDEFSRCHFLD Character(1) VARCHAR2(1) NOT NULL Use Edit - Default Search Fld
PTIA_UETRANSLATE Character(1) VARCHAR2(1) NOT NULL Use Edit - Translate
PTIA_UETRIGGRMAINT Character(1) VARCHAR2(1) NOT NULL Use Edit - Trigger Maintained
PTIA_UEPRMPTSRCHED Character(1) VARCHAR2(1) NOT NULL Use Edit - Prompt Srch Events
PTIA_UESEARCHEDIT Character(1) VARCHAR2(1) NOT NULL Use Edit - Search Edit
PTIA_UETYPEAHDPRMP Character(1) VARCHAR2(1) NOT NULL Use Edit - Type Ahead Prompt
PTIA_UETYPEAHDSRCH Character(1) VARCHAR2(1) NOT NULL Use Edit - Type Ahead Srch Rec
PTIA_UEPERSISTDATA Character(1) VARCHAR2(1) NOT NULL Use Edit - Persist Data
index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
PTRef generated on 21-DEC-20