Viewing Key-Related Characteristics and Default Values
Use Display mode shows key-related characteristics and default values for fields that determine how fields are used in a record. The use characteristics might differ for fields that are used in more than one record definition. Double-click the field to access the Record Field Properties dialog box in which you define these parameters.
| Field or Control | Description |
|---|---|
|
Key |
Indicates whether the field is a key to the record definition. Key fields are included in an index that is automatically created during the table build process. The word Not in this column indicates that this field cannot be used as a chart field. You can set this parameter only through PeopleCode using the SetDBFieldNotUsed function. See PeopleCode Language Reference: SetDBFieldNotUsed function. |
|
Ordr (order) |
Indicates the order of key fields in the index. You can configure this order from the Index dialog box. It is reflected in this column. |
|
Dir (direction) |
Indicates the order in which the key field indexes are created in the database: ascending or descending. |
|
CurC (currency control) |
The currency format for this field is controlled by the currency code in another field. |
|
Srch (search) |
Indicates a search key, that is, a field for which one is prompted from a search record dialog box. |
|
List |
Indicates a list box item, that is, whether the values for the field appear in the search record list box. |
|
Sys (system) |
Indicates that the system generates and maintains the field. |
|
Audt (audit) |
Specifies whether additions, changes, or deletions to data in this field are written to the standard PeopleTools Audit Tables (PSAUDIT and PSAUDITEXT). |
|
InAutoComp |
Indicates that the field is used as an autocomplete field and appears in the autocomplete window. |
|
EnAutoComp for Srch Record |
Specifies whether autocomplete is enabled in a search record. |
|
Default |
Represents the default value that is used to initialize the field. |