PSPTTSTCMDLBLVW

(SQL View)
 Index Back

PsTestFw Test Commands

This view will return the commands and the labels for the fields in the page

SELECT C.PTTST_NAME , C.PTTST_CMD_ID , C.PTTST_LANG_CD , C.SEQNBR , C.PTTST_CMD_STATUS , C.PTTST_CMD_TYPE , C.PTTST_CMD_OBJ_TYPE , C.PTTST_CMD_OBJ_ID , C.PTTST_CMD_RECOG , C.PTTST_CMDPARAMETRS , C.PTTST_CMD_PARAM , C.MENUNAME , C.PNLGRPNAME , C.MARKET , C.PNLNAME , C.PTTST_PAGEFIELD_NM , C.PTTST_CMD_UPD , C.RECNAME , C.FIELDNAME , LF.LONGNAME , C.DESCRLONG FROM PSPTTSTCOMMAND C LEFT JOIN ( SELECT P.PNLNAME , F.LABEL_ID , P.RECNAME , F.FIELDNAME , F.LONGNAME FROM PSPNLFIELD P LEFT JOIN PSDBFLDLABL F ON F.FIELDNAME = P.FIELDNAME AND F.LABEL_ID = P.LABEL_ID WHERE 1 = ( SELECT COUNT(*) FROM PSPNLFIELD P2 WHERE P.PNLNAME = P2.PNLNAME AND P.RECNAME = P2.RECNAME AND P.FIELDNAME = P2.FIELDNAME) ) LF ON C.PNLNAME = LF.PNLNAME AND C.RECNAME = LF.RECNAME AND C.FIELDNAME = LF.FIELDNAME

# 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 LBLTEXT Character(60) VARCHAR2(60) NOT NULL Label Text
21 DESCRLONG Long Character CLOB Long Description