EODP_PIVOT_REF

(SQL Table)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PTPG_PGRIDNAME Character(30) VARCHAR2(30) NOT NULL Pivot Grid Name (see PSPGCORE).

2 PTPG_DSVALUE Character(30) VARCHAR2(30) NOT NULL Data Source Value

3 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

4 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

5 PTPG_DSTYPE Character(30) VARCHAR2(30) NOT NULL Data Source Type (see PSPGDTYPE).

6 EODP_IS_PGLT Character(1) VARCHAR2(1) NOT NULL Published As Pagelet
N=No
Y=Yes

7 EODP_IS_TILE Character(1) VARCHAR2(1) NOT NULL Published As Tile
N=No
Y=Yes

8 EODP_IS_TIL_SEC Character(1) VARCHAR2(1) NOT NULL Secured
N=No
Y=Yes

9 EODP_PGLT_SEC Character(1) VARCHAR2(1) NOT NULL Secured
N=No
Y=Yes

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

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.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PTPG_PGRIDNAME	Character(30)	VARCHAR2(30) NOT NULL	Pivot Grid Name (see PSPGCORE).
2	PTPG_DSVALUE	Character(30)	VARCHAR2(30) NOT NULL	Data Source Value
3	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN).
4	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD).
5	PTPG_DSTYPE	Character(30)	VARCHAR2(30) NOT NULL	Data Source Type (see PSPGDTYPE).
6	EODP_IS_PGLT	Character(1)	VARCHAR2(1) NOT NULL	Published As Pagelet N=No Y=Yes
7	EODP_IS_TILE	Character(1)	VARCHAR2(1) NOT NULL	Published As Tile N=No Y=Yes
8	EODP_IS_TIL_SEC	Character(1)	VARCHAR2(1) NOT NULL	Secured N=No Y=Yes
9	EODP_PGLT_SEC	Character(1)	VARCHAR2(1) NOT NULL	Secured N=No Y=Yes
10	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.
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.