TESTI_DFLD(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Character(30) | VARCHAR2(30) NOT NULL |
BTF Test Case
Prompt Table: TEST_CASE |
|
| 2 | Character(15) | VARCHAR2(15) NOT NULL |
Compare Difference Record
Prompt Table: RECDEFN_VW |
|
| 3 | Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). | |
| 4 | FIELDNUM | Number(4,0) | SMALLINT NOT NULL | Field Number |
| 5 | LABEL_VALUE | Character(30) | VARCHAR2(30) NOT NULL | Value |
| 6 | DISPLAY_WIDTH | Number(5,0) | INTEGER NOT NULL | Display Width |
| 7 | KEY_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Key Field
Y/N Table Edit |
| 8 | VISIBLE_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Visible
Y/N Table Edit Default Value: Y |