USEEEDIT

back

Field Use and Edit Flags

Bit Number Bit Value Set (Not Set) Value Comment
0 1 Key Value This column will be a part of the PeopleSoft key index (PS_<recname>).
1 2 Duplicate (unique) key The PeopleSoft key index will be NONUNIQUE if any one field in the key is given duplicate attribute.
2 4 System Maintained Field  
3 8 Audit fieldóadd.  
4 16 Alternate search key This field is not part of the primary key but can be used to query the data in a record locator. The field will appear in the alternate search key indexes.
5 32 List box item. This column will appear in the result set of component record locator dialog or list of values. Up to PeopleTools 7.x, an index was created on all list columns.
6 64 Ascending (descending) key field. Controls order of the column in the ORDER BY clauses of SQL generated by the PIA. Up to PeopleTools 8.14, the indexes were also built with the order specified on the field.
7 128 Audit fieldóchange.  
8 256 Required field Date and Long columns will have NOT NULL constraints. The PeopleSoft application will not allow 0 for Number columns or blank character fields.
9 512 X/Lat Look-up value for field in table XLATTABLE.
10 1024 Audit fieldódelete.  
11 2048 Keys - search  
12 4096 Edits - Reasonable Date  
13 8192 Edits - Yes/No Field will only accept a Y/N response that is mapped to specified database values.
14 16384 Prompt table edit enabled.  
15 32768 Auto Update  
16 65536   unknown
17 131072   unknown
18 262144 From search field.  
19 524288 To search field.  
20 1048576 1/0 Table Edit  
21 2097152 Disable advanced search options.  
22 4194304   unknown
23 8388608 Regular field (sub-record) Indicates if the field is a sub-record or not. This value is not disaplyed on Record Field Properties dialog box.
24 16777216 Default search field  
25 33554432   unknown
26 67108864   unknown
27 134217728 Keys - Allow Search Events for Prompt Dialogs Introduced in PeopleTools 8.50
28 268435456 Keys - Search Edit  
29 536870912 Edits - Display in Autocomplete Window Introduced in PeopleTools 8.50
30 1073741824 Autocomplete - Enable Autocomplete when used in Search Record Introduced in PeopleTools 8.50
31 2147483648 Menu - Persist in Menu Introduced in PeopleTools 8.51
back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools Table Reference
PTRef