PTBR_ETYPE (SQL Table)	Index Back
Element Type

PTBR_ETYPE

(SQL Table)

Element Type

Related Language Record: PTBR_ETYPE_LN

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PTBR_ETYPE_ID Character(30) VARCHAR2(30) NOT NULL Element Type

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

3 DESCRLONG Long Character CLOB Long Description

4 OBJECTOWNERID Character(4) VARCHAR2(4) NOT NULL Object owner identifier
Default Value: PTPP_OPTIONS.OBJECTOWNERID

5 ACTIVE_FLAG Character(1) VARCHAR2(1) NOT NULL Active Flag
A=Active
I=Inactive
Default Value: A

6 PACKAGEID Character(30) VARCHAR2(30) NOT NULL Package Name (see PSDIAGREG).
Prompt Table: PTBR_APPPKG_PVW

7 QUALIFYPATH Character(127) VARCHAR2(127) NOT NULL Qualified Package/Class Path
Prompt Table: PTBR_APPPATHPVW

8 APPCLASSID Character(30) VARCHAR2(30) NOT NULL Application Class ID
Prompt Table: PTBR_APPCLASPVW

9 CREATEDTTM DateTime(26) TIMESTAMP DateTime of Query Creation

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

11 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.

12 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.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PTBR_ETYPE_ID	Character(30)	VARCHAR2(30) NOT NULL	Element Type
2	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
3	DESCRLONG	Long Character	CLOB	Long Description
4	OBJECTOWNERID	Character(4)	VARCHAR2(4) NOT NULL	Object owner identifier Default Value: PTPP_OPTIONS.OBJECTOWNERID
5	ACTIVE_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Active Flag A=Active I=Inactive Default Value: A
6	PACKAGEID	Character(30)	VARCHAR2(30) NOT NULL	Package Name (see PSDIAGREG). Prompt Table: PTBR_APPPKG_PVW
7	QUALIFYPATH	Character(127)	VARCHAR2(127) NOT NULL	Qualified Package/Class Path Prompt Table: PTBR_APPPATHPVW
8	APPCLASSID	Character(30)	VARCHAR2(30) NOT NULL	Application Class ID Prompt Table: PTBR_APPCLASPVW
9	CREATEDTTM	DateTime(26)	TIMESTAMP	DateTime of Query Creation
10	CREATEOPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID
11	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.
12	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.