PSPTTSTMURESULT(SQL Table) |
Index Back |
---|
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | PTTST_PARENTFOLDER | Character(200) | VARCHAR2(200) NOT NULL | Test Parent Folder |
2 | PTTST_NAME | Character(30) | VARCHAR2(30) NOT NULL | Test Name (see PSPTTSTDEFN). |
3 | PTTST_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Test Type
F=Folder H=Shell Test L=Library S=Test |
4 | PTTST_CMD_ID | Number(5,0) | INTEGER NOT NULL | Scr Command ID |
5 | SEQNBR | Number(5,0) | INTEGER NOT NULL | Sequence Number |
6 | PTTST_CMD_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
CMD Status
A=Active I=Inactive N=No Data X=N/A Default Value: A |
7 | PTTST_CMD_TYPE | Number(5,0) | INTEGER NOT NULL | Test Cmd Type |
8 | PTTST_CMD_OBJ_TYPE | Number(5,0) | INTEGER NOT NULL | Tst Cmd Object Type |
9 | PTTST_CMD_RECOG | Character(254) | VARCHAR2(254) NOT NULL | Command Recognition |
10 | PTTST_CMDPARAMETRS | Character(254) | VARCHAR2(254) NOT NULL | Command Param |
11 | MENUNAME | Character(30) | VARCHAR2(30) NOT NULL | Menu Name (see PSMENUDEFN). |
12 | PNLGRPNAME | Character(18) | VARCHAR2(18) NOT NULL | Component Name |
13 | MARKET | Character(3) | VARCHAR2(3) NOT NULL | Market |
14 | PNLNAME | Character(30) | VARCHAR2(30) NOT NULL | Page Name (see PSPNLDEFN). |
15 | PTTST_PAGEFIELD_NM | Character(40) | VARCHAR2(40) NOT NULL | Test Record & Field |
16 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name (see PSRECDEFN). |
17 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
18 | PTTST_CASE_NAME | Character(30) | VARCHAR2(30) NOT NULL | Test Case Name |
19 | PTTST_CMD_VALUE | Character(254) | VARCHAR2(254) NOT NULL | Script Value |