PSPTTSTCOMMAND(SQL Table) |
Index Back |
|---|---|
PsTestFw Test Commands |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Character(30) | VARCHAR2(30) NOT NULL | Test Name (see PSPTTSTDEFN). | |
| 2 | Number(5,0) | INTEGER NOT NULL | Scr Command ID | |
| 3 | PTTST_LANG_CD | Character(3) | VARCHAR2(3) NOT NULL |
Language Code
Default Value: ENG |
| 4 | SEQNBR | Number(5,0) | INTEGER NOT NULL | Sequence Number |
| 5 | PTTST_CMD_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
CMD Status
A=Active I=Inactive N=No Data X=N/A Default Value: A |
| 6 | PTTST_CMD_TYPE | Number(5,0) | INTEGER NOT NULL | Test Cmd Type |
| 7 | PTTST_CMD_OBJ_TYPE | Number(5,0) | INTEGER NOT NULL | Tst Cmd Object Type |
| 8 | PTTST_CMD_OBJ_ID | Character(250) | VARCHAR2(250) NOT NULL | Scr Cmd Object ID |
| 9 | PTTST_CMD_RECOG | Character(254) | VARCHAR2(254) NOT NULL | Command Recognition |
| 10 | PTTST_CMDPARAMETRS | Character(254) | VARCHAR2(254) NOT NULL | Command Param |
| 11 | PTTST_CMD_PARAM | Character(254) | VARCHAR2(254) NOT NULL | Scroll Number |
| 12 | MENUNAME | Character(30) | VARCHAR2(30) NOT NULL | Menu Name (see PSMENUDEFN). |
| 13 | PNLGRPNAME | Character(18) | VARCHAR2(18) NOT NULL | Component Name |
| 14 | MARKET | Character(3) | VARCHAR2(3) NOT NULL | Market |
| 15 | PNLNAME | Character(30) | VARCHAR2(30) NOT NULL | Page Name (see PSPNLDEFN). |
| 16 | PTTST_PAGEFIELD_NM | Character(40) | VARCHAR2(40) NOT NULL | Test Record & Field |
| 17 | PTTST_CMD_UPD | Character(1) | VARCHAR2(1) NOT NULL | CMD Update |
| 18 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name (see PSRECDEFN). |
| 19 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
| 20 | DESCRLONG | Long Character | CLOB | Long Description |