PTTST_NAMEPTTST_SRCNAMEPTTST_SRCTYPECTQ=Connected Query
EXL=Excel Source
NMQ=Normal Query
PTTST_BOUNDNAMEPTTST_FIELDNAMEPSPTTSTFIELDMAP(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PTTST_NAME |
Character(30) | VARCHAR2(30) NOT NULL | Test Name (see PSPTTSTDEFN). |
| 2 | PTTST_CASE_NAME | Character(30) | VARCHAR2(30) NOT NULL | Test Case Name |
| 3 | PTTST_SRCNAME |
Character(50) | VARCHAR2(50) NOT NULL | DataLoader Name |
| 4 | PTTST_SRCTYPE |
Character(3) | VARCHAR2(3) NOT NULL |
DataLoader Type
CTQ=Connected Query EXL=Excel Source NMQ=Normal Query |
| 5 | PTTST_BOUNDNAME |
Character(254) | VARCHAR2(254) NOT NULL | Bound Source Name |
| 6 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |
| 7 | PTTST_FIELDNAME |
Character(254) | VARCHAR2(254) NOT NULL | Field Name |
| 8 | PTTST_FIELDID | Number(5,0) | INTEGER NOT NULL | Field ID |
| 9 | PTTST_MAPPEDNAME | Character(254) | VARCHAR2(254) NOT NULL | Mapped Variable Name |