PTGPLT_DATATYPE

PeopleSoft Field Name	Field Type	Column Type	Description
PTPPB_DATATYPE_ID	Character(30)	VARCHAR2(30) NOT NULL	Data Type
DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
DESCRLONG	Long Character	CLOB	Long Description
APPCLASSID	Character(30)	VARCHAR2(30) NOT NULL	Application Class ID
PACKAGEID	Character(30)	VARCHAR2(30) NOT NULL	Package Name (see PSDIAGREG).
QUALIFYPATH	Character(127)	VARCHAR2(127) NOT NULL	Qualified Package/Class Path
PTPPB_SRCH_APCLASS	Character(30)	VARCHAR2(30) NOT NULL	Application Class ID
PTPPB_SRCH_AP_PKG	Character(30)	VARCHAR2(30) NOT NULL	Package Name
PTPPB_SRCH_AP_PATH	Character(127)	VARCHAR2(127) NOT NULL	Qualified Package/Class Path
PAGE_NAME	Character(18)	VARCHAR2(18) NOT NULL	Page Name Prompt Table: PTPPB_PAGE_PVW
ACTIVE_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Active Flag A=Active I=Inactive Default: A
CREATEDTTM	DateTime(26)	TIMESTAMP	DateTime of Query Creation
CREATEOPRID	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.
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.

index back

(c)David Kurtz 2020, www.go-faster.co.uk

PeopleTools 8.58 PTRef generated on 21-DEC-20