PSPTIAURECFLDVW

(SQL View)
 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 PeopleSoft Field Type Database Column Type Description
1 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
2 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
3 USEEDIT Number(10,0) DECIMAL(10) NOT NULL Field Use and Edit Flags- USEEDIT reference
4 PTIA_UEKEY Character(1) VARCHAR2(1) NOT NULL Use Edit - Key
5 PTIA_UEDUPLKEY Character(1) VARCHAR2(1) NOT NULL Use Edit - Duplicate Order Key
6 PTIA_UESYSTEM Character(1) VARCHAR2(1) NOT NULL Use Edit - System Maintained
7 PTIA_UEAUDFLDADD Character(1) VARCHAR2(1) NOT NULL Use Edit - Audit Field Add
8 PTIA_UEALTKEY Character(1) VARCHAR2(1) NOT NULL Use Edit - Alternate Srch Key
9 PTIA_UELISTITEM Character(1) VARCHAR2(1) NOT NULL Use Edit - List Box Item
10 PTIA_UEDESCKEY Character(1) VARCHAR2(1) NOT NULL Use Edit - Descending Key
11 PTIA_UEAUDFLDCHG Character(1) VARCHAR2(1) NOT NULL Use Edit - Audit Field Change
12 PTIA_UEREQUIRED Character(1) VARCHAR2(1) NOT NULL Use Edit - Required Field
13 PTIA_UEEDITXLAT Character(1) VARCHAR2(1) NOT NULL Use Edit - Translate Tbl Edit
14 PTIA_UEAUDFLDDEL Character(1) VARCHAR2(1) NOT NULL Use Edit - Audit Field Delete
15 PTIA_UESEARCHKEY Character(1) VARCHAR2(1) NOT NULL Use Edit - Search Key
16 PTIA_UERESNDTEDIT Character(1) VARCHAR2(1) NOT NULL Use Edit - Reasonable Dt Edit
17 PTIA_UEYESNO Character(1) VARCHAR2(1) NOT NULL Use Edit - Yes/No Edit
18 PTIA_UEEDITTABLE Character(1) VARCHAR2(1) NOT NULL Use Edit - Table Edit
19 PTIA_UEAUTOUPDATE Character(1) VARCHAR2(1) NOT NULL Use Edit - Auto Update
20 PTIA_UEGETFNMPRMPT Character(1) VARCHAR2(1) NOT NULL Use Edit - Get File Name Prmpt
21 PTIA_UEGETDNMPRMPT Character(1) VARCHAR2(1) NOT NULL Use Edit - Get Dir Name Prompt
22 PTIA_UEFROMSRCHFLD Character(1) VARCHAR2(1) NOT NULL Use Edit - From Search Field
23 PTIA_UETHRUSRCHFLD Character(1) VARCHAR2(1) NOT NULL Use Edit - Through Srch Field
24 PTIA_UEONEZERO Character(1) VARCHAR2(1) NOT NULL Use Edit - One/Zero Table Edit
25 PTIA_UEDISADVSRCH Character(1) VARCHAR2(1) NOT NULL Use Edit - Disable Adv Search
26 PTIA_UEFILEREF Character(1) VARCHAR2(1) NOT NULL Use Edit - File Reference
27 PTIA_UEUSEDFLTLBL Character(1) VARCHAR2(1) NOT NULL Use Edit - Default Label
28 PTIA_UEDEFSRCHFLD Character(1) VARCHAR2(1) NOT NULL Use Edit - Default Search Fld
29 PTIA_UETRANSLATE Character(1) VARCHAR2(1) NOT NULL Use Edit - Translate
30 PTIA_UETRIGGRMAINT Character(1) VARCHAR2(1) NOT NULL Use Edit - Trigger Maintained
31 PTIA_UEPRMPTSRCHED Character(1) VARCHAR2(1) NOT NULL Use Edit - Prompt Srch Events
32 PTIA_UESEARCHEDIT Character(1) VARCHAR2(1) NOT NULL Use Edit - Search Edit
33 PTIA_UETYPEAHDPRMP Character(1) VARCHAR2(1) NOT NULL Use Edit - Type Ahead Prompt
34 PTIA_UETYPEAHDSRCH Character(1) VARCHAR2(1) NOT NULL Use Edit - Type Ahead Srch Rec
35 PTIA_UEPERSISTDATA Character(1) VARCHAR2(1) NOT NULL Use Edit - Persist Data