FS_BTF_OBJ_AET(SQL Table) |
Index Back |
|---|---|
BTF Test Object State Record |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | TEST_OBJECT | Character(30) | VARCHAR2(30) NOT NULL | Test Objects |
| 3 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |
| 4 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
Prompt Table: RECDEFN_VW |
| 5 | RECNAME_SOURCE | Character(15) | VARCHAR2(15) NOT NULL |
Source Record
Prompt Table: RECDEFN_VW |
| 6 | RECNAME_EXPECT | Character(15) | VARCHAR2(15) NOT NULL |
Expected Result Record
Prompt Table: RECDEFN_VW |
| 7 | RECNAME_COMPARE | Character(15) | VARCHAR2(15) NOT NULL |
Compare Difference Record
Prompt Table: RECDEFN_VW |
| 8 | BASETABLE_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Base Table
Y/N Table Edit Default Value: N |
| 9 | COMPARISON_BASIS | Character(1) | VARCHAR2(1) NOT NULL |
Comparison Basis
E=Expected Results P=Process Instance Default Value: P |
| 10 | RECNAME_BASE | Character(15) | VARCHAR2(15) NOT NULL | Base record name |
| 11 | RECNAME_BASE_S | Character(15) | VARCHAR2(15) NOT NULL | Base record name |
| 12 | COMPARE_RESULT | Character(1) | VARCHAR2(1) NOT NULL | Compare Result |
| 13 | TEST_CASE | Character(30) | VARCHAR2(30) NOT NULL | BTF Test Case |
| 14 | USE_SRC_CRITERIA | Character(1) | VARCHAR2(1) NOT NULL |
Used in BTF
Y/N Table Edit Default Value: N |
| 15 | QRYNAME_RESULTS | Character(30) | VARCHAR2(30) NOT NULL |
Query Name
Prompt Table: TEST_QRY_VW |
| 16 | QRYNAME | Character(30) | VARCHAR2(30) NOT NULL |
Query Name
Prompt Table: TEST_QRY_VW |