VALID_SET_IDPrompt Table: TL_VALID_SET
VALID_DEFN_IDPrompt Table: TL_VALID_DEFN
Y/N Table Edit
Default Value: Y
Y/N Table Edit
Default Value: Y
TL_VALID_ITEM(SQL Table) |
Index Back |
|---|---|
Validation ItemReolves the M:M relationship between Validation Set and Validation Definition. TL_VALID_SET ---< TL_VALID_ITEM >--- TL_VALID_DEFN Where: TL_VALID_SET: Validation Set TL_VALID_ITEM: This entity TL_VALID_DEFN: Validation Definition |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | VALID_SET_ID |
Character(10) | VARCHAR2(10) NOT NULL |
Validation Set
Prompt Table: TL_VALID_SET |
| 2 | VALID_DEFN_ID |
Character(10) | VARCHAR2(10) NOT NULL |
Validation ID
Prompt Table: TL_VALID_DEFN |
| 3 | TL_VALID_ST | Character(1) | VARCHAR2(1) NOT NULL |
Submit Time
Y/N Table Edit Default Value: Y |
| 4 | TL_VALID_TA | Character(1) | VARCHAR2(1) NOT NULL |
Time Admin
Y/N Table Edit Default Value: Y |