PTPPB_DISP_FRMT

(SQL Table)

Related Language Record: PTPPB_DFMT_LANG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PTPPB_DISPFRMT_ID Character(30) VARCHAR2(30) NOT NULL Display Format ID

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

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

4 IMAGE_NAME Character(30) VARCHAR2(30) NOT NULL The name of images used in Personalizations explanations.
Prompt Table: PTPPB_IMGCAT_VW

5 ORDERNO Number(5,0) INTEGER NOT NULL Sort Order

6 APPCLASSID Character(30) VARCHAR2(30) NOT NULL Application Class ID

7 PACKAGEID Character(30) VARCHAR2(30) NOT NULL Package Name (see PSDIAGREG).

8 QUALIFYPATH Character(127) VARCHAR2(127) NOT NULL Qualified Package/Class Path

9 PTPPB_TRANSFRM_TYP Character(30) VARCHAR2(30) NOT NULL Transformation Type
Prompt Table: PTPPB_TXFRMTYPE
Set Control Field: PTPPB_TRANSFRM_TYP

10 PAGE_NAME Character(18) VARCHAR2(18) NOT NULL Page Name
Prompt Table: PTPPB_PAGE_PVW

11 PTPPB_IS_CUSTOM Character(1) VARCHAR2(1) NOT NULL Custom
Y/N Table Edit
Default Value: N

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

13 CREATEDTTM DateTime(26) TIMESTAMP DateTime of Query Creation

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

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

16 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	PTPPB_DISPFRMT_ID	Character(30)	VARCHAR2(30) NOT NULL	Display Format ID
2	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
3	DESCR254	Character(254)	VARCHAR2(254) NOT NULL	Description of length 254
4	IMAGE_NAME	Character(30)	VARCHAR2(30) NOT NULL	The name of images used in Personalizations explanations. Prompt Table: PTPPB_IMGCAT_VW
5	ORDERNO	Number(5,0)	INTEGER NOT NULL	Sort Order
6	APPCLASSID	Character(30)	VARCHAR2(30) NOT NULL	Application Class ID
7	PACKAGEID	Character(30)	VARCHAR2(30) NOT NULL	Package Name (see PSDIAGREG).
8	QUALIFYPATH	Character(127)	VARCHAR2(127) NOT NULL	Qualified Package/Class Path
9	PTPPB_TRANSFRM_TYP	Character(30)	VARCHAR2(30) NOT NULL	Transformation Type Prompt Table: PTPPB_TXFRMTYPE Set Control Field: PTPPB_TRANSFRM_TYP
10	PAGE_NAME	Character(18)	VARCHAR2(18) NOT NULL	Page Name Prompt Table: PTPPB_PAGE_PVW
11	PTPPB_IS_CUSTOM	Character(1)	VARCHAR2(1) NOT NULL	Custom Y/N Table Edit Default Value: N
12	ACTIVE_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Active Flag A=Active I=Inactive Default Value: A
13	CREATEDTTM	DateTime(26)	TIMESTAMP	DateTime of Query Creation
14	CREATEOPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID
15	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.
16	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.