PSPTTSTCMD_VW

index back

Test Framework Commands View


SELECT PTTST_NAME , PTTST_CMD_ID , PTTST_LANG_CD , SEQNBR , PTTST_CMD_STATUS , 0 PTTST_OBJECTTYPE , 'Record' PTTST_OBJECTDESC , RECNAME PTTST_OBJECTNAME , ' ' FROM PSPTTSTCOMMAND WHERE RECNAME <> ' ' UNION SELECT PTTST_NAME , PTTST_CMD_ID , PTTST_LANG_CD , SEQNBR , PTTST_CMD_STATUS , 2 PTTST_OBJECTTYPE , 'Field' PTTST_OBJECTDESC , FIELDNAME PTTST_OBJECTNAME , ' ' FROM PSPTTSTCOMMAND WHERE FIELDNAME <> ' ' UNION SELECT PTTST_NAME , PTTST_CMD_ID , PTTST_LANG_CD , SEQNBR , PTTST_CMD_STATUS , 4 PTTST_OBJECTTYPE , 'Translate' PTTST_OBJECTDESC , FIELDNAME PTTST_OBJECTNAME , ' ' FROM PSPTTSTCOMMAND WHERE FIELDNAME <> ' ' UNION SELECT PTTST_NAME , PTTST_CMD_ID , PTTST_LANG_CD , SEQNBR , PTTST_CMD_STATUS , 5 PTTST_OBJECTTYPE , 'Page' PTTST_OBJECTDESC , PNLNAME PTTST_OBJECTNAME , ' ' FROM PSPTTSTCOMMAND WHERE PNLNAME <> ' ' UNION SELECT PTTST_NAME , PTTST_CMD_ID , PTTST_LANG_CD , SEQNBR , PTTST_CMD_STATUS , 6 PTTST_OBJECTTYPE , 'Menu' PTTST_OBJECTDESC , MENUNAME PTTST_OBJECTNAME , ' ' FROM PSPTTSTCOMMAND WHERE MENUNAME <> ' ' UNION SELECT PTTST_NAME , PTTST_CMD_ID , PTTST_LANG_CD , SEQNBR , PTTST_CMD_STATUS , 7 PTTST_OBJECTTYPE , 'Component' PTTST_OBJECTDESC , PNLGRPNAME PTTST_OBJECTNAME , MARKET FROM PSPTTSTCOMMAND WHERE PNLGRPNAME <> ' '

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
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_OBJECTTYPENumber(5,0)INTEGER NOT NULLObject Type
PTTST_OBJECTDESCCharacter(50)VARCHAR2(50) NOT NULLObject
PTTST_OBJECTNAMECharacter(50)VARCHAR2(50) NOT NULLObject Name
MARKETCharacter(3)VARCHAR2(3) NOT NULLMarket translate values
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19