People Soft Record Field Properties : The USEEDIT field values & it’s properties PSRECFIELD.USEEDIT. Bit Value Flag. 0 1 Key 1 2 Duplicate Order Key 2 4 System Maintained 3 8 Audit Field Add 4 16 Alternate Search Key 5 32. Record field Required property stores in which Peopletools table? Hi UseEdit field stores the different values in the format given below.
Understanding the USEEDIT field in PSRECFIELD. USEEDIT is a binary number stored as a Decimal. I forget the term right now but each bit represents a field attribute such as List field, Required etc.
- PSRECFIELD DBA_TAB_COLUMNS. PeopleSoft Field Name Corresponding Oracle Column Name; RECNAME: TABLE_NAME: Unique name of record within PeopleSoft. USEEDIT : see table: USEEDIT2 .
- USEEDIT Values: Return to Index: Bit Number Bit Value Set (Not Set) Value. The PeopleSoft key index will be NONUNIQUE if any one field in the key is given duplicate attribute. 2: 4.
- Has anyone written a query or SQR to translate the values that are contained int the psrecfield.useedit field? We are beginning our.
Key. - -2 2 Duplicate Order Key. System Maintained. Audit Field Add. - -5 1. Alternate Search Key. List Box Item. - -7 6. Descending Key. - -8 1.
Audit Field Change. Required. - -1. 0 5. Translate Table Edit. Audit Field Delete. Search Key. - -1. Reasonable Date Edit. Yes/No Edit. - -1.
Prompt Table Edit. Auto- Update. - -1.
See this article for more tips on translating bit fields such as RECUSE and USEEDIT if you are on another database platform. One problem you may run into is that not every field is audited in the audit record. The following. People Soft Record Field Properties : The USEEDIT field values & it’s properties PSRECFIELD.USEEDIT Bit Value Flag 0 1 Key 1 2 Duplicate Order Key 2 4 System Maintained 3 8 Audit Field Add. Peoplesoft /Fieldtype in Data Dictionary. Advertisement. Expert. I would like to loop through the fields in a record and based on the field type. WHEN A.USEEDIT & 256 > 0 THEN 'YES' ELSE 'NO' END AS REQ.
![Useedit Field Peoplesoft Useedit Field Peoplesoft](http://www.peoplesoftpages.com/WordPress/wp-content/uploads/2014/09/Mass-upload-Photo-520x245.png)
Unknown. - -1. 8 1. Unknown. - -1. 9 2. From Search Field. Through Search Field.
Table Edit. - -2. Disable Advanced Search Options. Unknown. - -2. 4 8. Unknown. - -2. 5 1. Default Search Field. Unknown. - -2. 7 6.
Unknown. - -2. 8 1. Unknown. - -2. 9 2.
Search Edit. - -3. Unknown. - -3. 1 1.
Unknown. SELECT A. FIELDNAME. FROM PSRECFIELDDB A. Oracle: WHERE bitand(A.
USEEDIT, 5. 12) > 0. SQL Server: WHERE A.
USEEDIT & 5. 12 > 0. DB2: WHERE (USEEDIT/5. USEEDIT/5. 12)/2. WHERE (USEEDIT/5.
USEEDIT/5. 12)/2. AND A. FIELDNAME not in (SELECT FIELDNAME FROM PSXLATITEM). GROUP BY A. FIELDNAME. ORDER BY A. FIELDNAME.
This finds all fields marked as a XLAT field, that actually aren't : \ 5. SELECT A. FIELDNAME. FROM PSRECFIELDDB A. WHERE bitand(A. USEEDIT, 5. AND A. FIELDNAME not in (SELECT FIELDNAME FROM PSXLATITEM). GROUP BY A. FIELDNAME. ORDER BY A. FIELDNAMEAlso handy.
SELECT A. RECNAME, A. FIELDNAMEFROM PSRECFIELDDB AWHERE bitand(A. USEEDIT, 5. 12) > 0. AND A. FIELDNAME not in (SELECT FIELDNAME FROM PSXLATITEM)ORDER BY A. RECNAME; ___Following is a snippet of code I have blatantly copied from a fantastic Blog I found while researching the problem. SELECTA. RECNAME,A.
FIELDNAME,CASEWHEN B. FIELDTYPE = 0 THEN'CHAR'WHEN B. FIELDTYPE = 1 THEN'LONG CHAR'WHEN B.
FIELDTYPE = 2 THEN'NUMBER'WHEN B. FIELDTYPE = 3 THEN'SIGNED NBR'WHEN B. FIELDTYPE = 4 THEN'DATE'WHEN B. FIELDTYPE = 5 THEN'TIME'WHEN B. FIELDTYPE = 6 THEN'DATETIME'WHEN B. FIELDTYPE = 7. OR B. FIELDTYPE = 8 THEN'IMAGE'ELSE NULLEND AS FIELDTYPE,CASEWHEN B.
FIELDTYPE = 2. OR B. FIELDTYPE = 3 THENTRIM(TO_CHAR(B.
LENGTH)) || '.' || TO_CHAR(B. DECIMALPOS)ELSE TO_CHAR(B. LENGTH)END AS FLDLEN,CASEWHEN bitand(A. USEEDIT, 2. 56) > 0 THEN'YES'ELSE 'NO'END AS REQ,CASEWHEN bitand(A.
USEEDIT, 1) > 0 THEN'KEY'WHEN bitand(A. USEEDIT, 2) > 0 THEN'DUP'WHEN bitand(A. USEEDIT, 1. 6) > 0 THEN'ALT'ELSE NULLEND AS KEY_TYPE,CASEWHEN bitand(A. USEEDIT, 6. 4) > 0 THEN'DESC'WHEN ( bitand(A. USEEDIT, 1) > 0. OR bitand(A. USEEDIT, 2) > 0.
OR bitand(A. USEEDIT, 1. AND bitand(A. USEEDIT, 6. THEN'ASC'ELSE NULLEND AS DIR,CASEWHEN bitand(A. USEEDIT, 2. 04. 8) > 0 THEN'YES'ELSE 'NO'END AS SRCH,CASEWHEN bitand(A. USEEDIT, 3. 2) > 0 THEN'YES'ELSE 'NO'END AS LIST,CASEWHEN bitand(A. USEEDIT, 4) > 0 THEN'YES'ELSE 'NO'END AS SYS,CASEWHEN TRIM(A.
DEFRECNAME) = '' THENA. DEFFIELDNAMEELSETRIM(A. DEFRECNAME) || '.' || A. DEFFIELDNAMEEND AS DEFAULT_VALUE,CASEWHEN bitand(A. USEEDIT, 8) > 0.
AND bitand(A. USEEDIT, 1. AND bitand(A. USEEDIT, 1. THEN'A'WHEN bitand(A.
USEEDIT, 8) > 0. AND bitand(A. USEEDIT, 1. AND bitand(A. USEEDIT, 1. THEN'AC'WHEN bitand(A. USEEDIT, 8) > 0. AND bitand(A. USEEDIT, 1.
AND bitand(A. USEEDIT, 1. THEN'ACD'WHEN bitand(A. USEEDIT, 8) = 0. AND bitand(A. USEEDIT, 1. 28) > 0. AND bitand(A. USEEDIT, 1. THEN'C'WHEN bitand(A.
USEEDIT, 8) = 0. AND bitand(A. USEEDIT, 1. 28) > 0. AND bitand(A. USEEDIT, 1. THEN'CD'WHEN bitand(A.
USEEDIT, 8) = 0. AND bitand(A. USEEDIT, 1. 28) = 0. AND bitand(A. USEEDIT, 1. THEN'D'ELSE NULLEND AS AUDT,CASEWHEN bitand(A. USEEDIT, 1. 63. 84) > 0 THEN'PROMPT'WHEN bitand(A. USEEDIT, 5. 12) > 0 THEN'XLAT'WHEN bitand(A. USEEDIT, 8. 19. 2) > 0 THEN'Y/N'ELSE NULLEND AS EDIT,A.
EDITTABLE AS PROMPT_TABLE,A. SETCNTRLFLD AS SET_CONTROL_FLD,CASEWHEN bitand(A.
USEEDIT, 4. 09. 6) > 0 THEN'YES'ELSE 'NO'END AS REASONABLE_DT,CASEWHEN bitand(A. USEEDIT, 3. 27. 68) > 0 THEN'YES'ELSE 'NO'END AS AUTO_UPDT,CASEWHEN bitand(A. USEEDIT, 2. 62. 14. THEN'FROM'WHEN bitand(A. USEEDIT, 5. 24. 28. THEN'THROUGH'ELSE NULLEND AS SEARCH_FIELD,CASEWHEN A.
SUBRECORD = 'Y' THEN'YES'ELSE 'NO'END AS SUBRECORD,A. LASTUPDDTTM,A. LASTUPDOPRIDFROM PSRECFIELD A,PSDBFIELD BWHERE A.
RECNAME = : 1. AND A. FIELDNAME = B. FIELDNAMEORDER BY FIELDNUM.