PTIASPPKGDUPVW - Duplicate Package View - PeopleTools Table Reference

PTIASPPKGDUPVW	index back
Duplicate Package View

This view displays the package names which include non-applied BUG in the creating package.

SELECT DISTINCT A.PTIASPPKGNAME , A.PTIASPPKGGUID , A.USERID , B.LASTUPDDTTM FROM PS_PTIASPPKGBUGS A , PS_PTIASPPKGS B WHERE A.PTIASPPKGGUID = B.PTIASPPKGGUID

PeopleSoft Field Name Field Type Column Type Description

PTIASPPKGGUID Character(36) VARCHAR2(36) NOT NULL Unique Identifier

PTIASPPKGNAME Character(30) VARCHAR2(30) NOT NULL Package Name

USERID Character(30) VARCHAR2(30) NOT NULL A user's ID

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.

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

PeopleSoft Field Name	Field Type	Column Type	Description
PTIASPPKGGUID	Character(36)	VARCHAR2(36) NOT NULL	Unique Identifier
PTIASPPKGNAME	Character(30)	VARCHAR2(30) NOT NULL	Package Name
USERID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID
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.