PTPPB_HEADER

(SQL Table)

Related Language Record: PTPPB_HDR_LANG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PTPPB_HEADER_ID Character(30) VARCHAR2(30) NOT NULL Header ID

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

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

4 PTPPB_TEXT_TYPE Character(3) VARCHAR2(3) NOT NULL Text Type
MSG=Message Catalog Entry
TXT=Freeform Text/HTML

5 HTMLAREA Long Character CLOB HTML Area

6 MSGSET Number(5,0) INTEGER NOT NULL Message Set Number

7 MSGNUM Number(5,0) INTEGER NOT NULL Message Number

8 PTPPB_CONTENT_SRC Character(3) VARCHAR2(3) NOT NULL Image Source
EXT=External Source
SYS=System Catalog

9 PTPPB_IMGSRC Character(250) VARCHAR2(250) NOT NULL Image Source
Prompt Table: %EDITTABLE2

10 PTPPB_IMGALIGN Character(2) VARCHAR2(2) NOT NULL Alignment
LT=Left
RT=Right

11 PTPPB_IMGHEIGHT Number(3,0) SMALLINT NOT NULL Height

12 PTPPB_IMGWIDTH Number(3,0) SMALLINT NOT NULL Width

13 PTPPB_IMGALT Character(100) VARCHAR2(100) NOT NULL Float Over Text

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

15 CREATEDTTM DateTime(26) TIMESTAMP DateTime of Query Creation

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

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

18 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_HEADER_ID	Character(30)	VARCHAR2(30) NOT NULL	Header ID
2	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
3	DESCR254	Character(254)	VARCHAR2(254) NOT NULL	Description of length 254
4	PTPPB_TEXT_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Text Type MSG=Message Catalog Entry TXT=Freeform Text/HTML
5	HTMLAREA	Long Character	CLOB	HTML Area
6	MSGSET	Number(5,0)	INTEGER NOT NULL	Message Set Number
7	MSGNUM	Number(5,0)	INTEGER NOT NULL	Message Number
8	PTPPB_CONTENT_SRC	Character(3)	VARCHAR2(3) NOT NULL	Image Source EXT=External Source SYS=System Catalog
9	PTPPB_IMGSRC	Character(250)	VARCHAR2(250) NOT NULL	Image Source Prompt Table: %EDITTABLE2
10	PTPPB_IMGALIGN	Character(2)	VARCHAR2(2) NOT NULL	Alignment LT=Left RT=Right
11	PTPPB_IMGHEIGHT	Number(3,0)	SMALLINT NOT NULL	Height
12	PTPPB_IMGWIDTH	Number(3,0)	SMALLINT NOT NULL	Width
13	PTPPB_IMGALT	Character(100)	VARCHAR2(100) NOT NULL	Float Over Text
14	ACTIVE_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Active Flag A=Active I=Inactive Default Value: A
15	CREATEDTTM	DateTime(26)	TIMESTAMP	DateTime of Query Creation
16	CREATEOPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID
17	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.
18	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.