PSPTTSTLOG_OPTS(SQL Table) |
Index Back |
|---|---|
PsTestFw Log Exec Options |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Character(30) | VARCHAR2(30) NOT NULL | Test Name (see PSPTTSTDEFN). | |
| 2 | Number(8,0) | INTEGER NOT NULL | Script Log ID | |
| 3 | PTTST_EXOP_NAME | Character(100) | VARCHAR2(100) NOT NULL | Name |
| 4 | PTTST_EXOP_PROMPT | Character(1) | VARCHAR2(1) NOT NULL |
Exec Opt Prompt
N=No Y=Yes |
| 5 | PTTST_EXOP_APP_URL | Character(254) | VARCHAR2(254) NOT NULL | Application URL |
| 6 | PTTST_EXOP_APP_USR | Character(30) | VARCHAR2(30) NOT NULL | User ID |
| 7 | PTTST_EXOP_APP_SVR | Character(10) | VARCHAR2(10) NOT NULL | Process Server |
| 8 | PTTST_EXOP_VERBOSE | Character(1) | VARCHAR2(1) NOT NULL |
Verbose
N=No Y=Yes |
| 9 | PTTST_EXOP_NO_SAVE | Character(1) | VARCHAR2(1) NOT NULL |
Skip Save
N=No Y=Yes |
| 10 | PTTST_EXOP_NO_RUN | Character(1) | VARCHAR2(1) NOT NULL |
Skip Run Request
N=No Y=Yes |
| 11 | PTTST_EXOP_DT_FORM | Character(10) | VARCHAR2(10) NOT NULL | Date Format |
| 12 | PTTST_PVKEY_USE | Number(2,0) | SMALLINT NOT NULL | PVKeyUse |
| 13 | PTTST_EXOP_PT_PATH | Character(254) | VARCHAR2(254) NOT NULL | PTools Path |
| 14 | PTTST_EXOP_DB_NAME | Character(20) | VARCHAR2(20) NOT NULL | DB Name |
| 15 | PTTST_EXOP_DB_USER | Character(20) | VARCHAR2(20) NOT NULL | DB User |
| 16 | PTTST_EXOP_DB_SVR | Character(48) | VARCHAR2(48) NOT NULL | Server Name |
| 17 | PTTST_EXOP_DB_PLAT | Character(10) | VARCHAR2(10) NOT NULL | DB Platform |