PT_GPLT_CATG - Grouplet Wizard Category - PeopleTools Table Reference

PT_GPLT_CATG	index back
Grouplet Wizard Category

PeopleSoft Field Name Field Type Column Type Description

PT_GPLT_CATG_ID Character(30) VARCHAR2(30) NOT NULL Category ID

DESCR Character(30) VARCHAR2(30) NOT NULL Description

DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254

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

PeopleSoft Field Name	Field Type	Column Type	Description
PT_GPLT_CATG_ID	Character(30)	VARCHAR2(30) NOT NULL	Category ID
DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
DESCR254	Character(254)	VARCHAR2(254) NOT NULL	Description of length 254
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.