PSPTTSTCMDLBLVW

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 Field Type Column Type Description
PTTST_NAME Character(30) VARCHAR2(30) NOT NULL Test Name (see PSPTTSTDEFN).
PTTST_CMD_ID Number(5,0) INTEGER NOT NULL Scr Command ID
PTTST_LANG_CD Character(3) VARCHAR2(3) NOT NULL Language Code

Default: ENG

SEQNBR Number(5,0) INTEGER NOT NULL Sequence Number
PTTST_CMD_STATUS Character(1) VARCHAR2(1) NOT NULL CMD Status
A=Active
I=Inactive
N=No Data
X=N/A

Default: A

PTTST_CMD_TYPE Number(5,0) INTEGER NOT NULL Test Cmd Type
PTTST_CMD_OBJ_TYPE Number(5,0) INTEGER NOT NULL Tst Cmd Object Type
PTTST_CMD_OBJ_ID Character(250) VARCHAR2(250) NOT NULL Scr Cmd Object ID
PTTST_CMD_RECOG Character(254) VARCHAR2(254) NOT NULL Command Recognition
PTTST_CMDPARAMETRS Character(254) VARCHAR2(254) NOT NULL Command Param
PTTST_CMD_PARAM Character(254) VARCHAR2(254) NOT NULL Scroll Number
MENUNAME Character(30) VARCHAR2(30) NOT NULL Menu Name (see PSMENUDEFN).
PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name
MARKET Character(3) VARCHAR2(3) NOT NULL Market translate values
PNLNAME Character(30) VARCHAR2(30) NOT NULL Page Name (see PSPNLDEFN).
PTTST_PAGEFIELD_NM Character(40) VARCHAR2(40) NOT NULL Test Record & Field
PTTST_CMD_UPD Character(1) VARCHAR2(1) NOT NULL CMD Update
RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
LBLTEXT Character(60) VARCHAR2(60) NOT NULL Label Text
DESCRLONG Long Character CLOB Long Description
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19