PSPTTSTPRJTSTVW

index back

SELECT T.PTTST_NAME , T.PTTST_PARENTFOLDER , T.LASTUPDOPRID , T.LASTUPDDTTM , T.VERSION , P.PROJECTNAME , P.UPGRADEACTION , 'N' FROM %Table(PSPTTSTDEFN) T , %Table(PSPROJECTITEM) P WHERE P.OBJECTTYPE = 104 AND P.OBJECTVALUE1 = T.PTTST_NAME

PeopleSoft Field Name Field Type Column Type Description
PTTST_NAME Character(30) VARCHAR2(30) NOT NULL Test Name (see PSPTTSTDEFN).
PTTST_PARENTFOLDER Character(200) VARCHAR2(200) NOT NULL Test Parent Folder
LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
VERSION Number(10,0) DECIMAL(10) NOT NULL Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference
PROJECTNAME Character(30) VARCHAR2(30) NOT NULL Project Name (see PSPROJECTDEFN).
UPGRADEACTION Number(1,0) SMALLINT NOT NULL Upgrade Action
PTTST_DELETE Character(1) VARCHAR2(1) NOT NULL Delete
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19