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