PSPTTSTCOMMAND(SQL Table) |
Index Back |
---|---|
PsTestFw Test Commands |
# | 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_CMD_ID | 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 |