| 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 |