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 NameField TypeColumn TypeDescription
PTTST_NAMECharacter(30)VARCHAR2(30) NOT NULLTest Name (see PSPTTSTDEFN).
PTTST_CMD_IDNumber(5,0)INTEGER NOT NULLScr Command ID
PTTST_LANG_CDCharacter(3)VARCHAR2(3) NOT NULLLanguage Code

Default: ENG

SEQNBRNumber(5,0)INTEGER NOT NULLSequence Number
PTTST_CMD_STATUSCharacter(1)VARCHAR2(1) NOT NULLCMD Status
A=Active
I=Inactive
N=No Data
X=N/A

Default: A

PTTST_CMD_TYPENumber(5,0)INTEGER NOT NULLTest Cmd Type
PTTST_CMD_OBJ_TYPENumber(5,0)INTEGER NOT NULLTst Cmd Object Type
PTTST_CMD_OBJ_IDCharacter(250)VARCHAR2(250) NOT NULLScr Cmd Object ID
PTTST_CMD_RECOGCharacter(254)VARCHAR2(254) NOT NULLCommand Recognition
PTTST_CMDPARAMETRSCharacter(254)VARCHAR2(254) NOT NULLCommand Param
PTTST_CMD_PARAMCharacter(254)VARCHAR2(254) NOT NULLScroll Number
MENUNAMECharacter(30)VARCHAR2(30) NOT NULLMenu Name (see PSMENUDEFN).
PNLGRPNAMECharacter(18)VARCHAR2(18) NOT NULLComponent Name
MARKETCharacter(3)VARCHAR2(3) NOT NULLMarket translate values
PNLNAMECharacter(30)VARCHAR2(30) NOT NULLPage Name (see PSPNLDEFN).
PTTST_PAGEFIELD_NMCharacter(40)VARCHAR2(40) NOT NULLTest Record & Field
PTTST_CMD_UPDCharacter(1)VARCHAR2(1) NOT NULLCMD Update
RECNAMECharacter(15)VARCHAR2(15) NOT NULLRecord (Table) Name (see PSRECDEFN).
FIELDNAMECharacter(18)VARCHAR2(18) NOT NULLField Name (see PSDBFIELD).
LBLTEXTCharacter(60)VARCHAR2(60) NOT NULLLabel Text
DESCRLONGLong CharacterCLOBLong Description
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19