PTIASPPKGTESTVW

index back

SELECT DISTINCT PTIASPPKGGUID ,PTIATESTNAME ,PTIATESTDESC ,PTIATESTCRIT1 ,PTIATESTCRIT2 ,PTIATESTCRIT3 ,PTIATESTCRIT4 ,PTIATESTPKGINCLUDE FROM PS_PTIASPPKGTEST

PeopleSoft Field Name Field Type Column Type Description
PTIASPPKGGUID Character(36) VARCHAR2(36) NOT NULL Unique Identifier
PTIATESTNAME Character(30) VARCHAR2(30) NOT NULL Test Name
PTIATESTDESC Character(254) VARCHAR2(254) NOT NULL Description
PTIATESTCRIT1 Number(10,0) DECIMAL(10) NOT NULL Test Criteria 1

Default: 1

PTIATESTCRIT2 Number(10,0) DECIMAL(10) NOT NULL Test Criteria 2

Default: 1

PTIATESTCRIT3 Number(10,0) DECIMAL(10) NOT NULL Test Criteria 3

Default: 1

PTIATESTCRIT4 Number(10,0) DECIMAL(10) NOT NULL Test Criteria 4

Default: 1

PTIATESTPKGINCLUDE Character(1) VARCHAR2(1) NOT NULL Include in Package
N=No
Y=Yes

Default: Y

index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
PTRef generated on 21-DEC-20