EODP_PVT_REF_VW

(SQL View)
 Index Back

Analytic Reference Page vw

View to display Pivot results in Page

SELECT PR.PTPG_PGRIDNAME ,PR.PTPG_DSVALUE , PR.RECNAME , PR.FIELDNAME ,PR.PTPG_DSTYPE ,RF.EODP_CTGRY_CD , RF.EODP_CLFNCD ,RF.EODP_PERS_IDFR , RF.EODP_SNSTV ,PR.EODP_IS_PGLT ,PR.EODP_PGLT_SEC ,PR.EODP_IS_TILE ,PR.EODP_IS_TIL_SEC ,PC.OBJECTOWNERID FROM PS_EODP_PIVOT_REF PR LEFT OUTER JOIN PSPGCORE PC ON PC.PTPG_PGRIDNAME = PR.PTPG_PGRIDNAME , PS_EODP_RECFLDDB RF WHERE PR.RECNAME = RF.RECNAME AND PR.FIELDNAME = RF.FIELDNAME

# 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_CTGRY_CD Character(6) VARCHAR2(6) NOT NULL Category Code

Prompt Table: EODP_CTGRY_CODE

7 EODP_CLFNCD Number(3,0) SMALLINT NOT NULL Classification Code

Prompt Table: EODP_CLSFCN_VW

8 EODP_PERS_IDFR Character(1) VARCHAR2(1) NOT NULL Personal Identifier
A=All
N=No
Y=Yes

Y/N Table Edit

Default Value: N

9 EODP_SNSTV Character(1) VARCHAR2(1) NOT NULL Sensitive
A=All
N=No
Y=Yes

Y/N Table Edit

Default Value: N

10 EODP_IS_PGLT Character(1) VARCHAR2(1) NOT NULL Published As Pagelet
N=No
Y=Yes
11 EODP_PGLT_SEC Character(1) VARCHAR2(1) NOT NULL Secured
N=No
Y=Yes
12 EODP_IS_TILE Character(1) VARCHAR2(1) NOT NULL Published As Tile
N=No
Y=Yes
13 EODP_IS_TIL_SEC Character(1) VARCHAR2(1) NOT NULL Secured
N=No
Y=Yes
14 OBJECTOWNERID Character(4) VARCHAR2(4) NOT NULL Object owner identifier