USER_FIELD_1EFFDTDefault Value: %date
A=Active
I=Inactive
Default Value: A
Default Value: TL_USER_FIELD_1.DESCR
TL_USER_FIELD_1(SQL Table) |
Index Back |
|---|---|
User Field Table 1TL User Field Tables are edit tables for the User Fields. These fields are used in the Task Sub Record for Task Validation. No other edits are performed against this table. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | USER_FIELD_1 |
Character(10) | VARCHAR2(10) NOT NULL | User Field 1 |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 3 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL |
Short Description
Default Value: TL_USER_FIELD_1.DESCR |