EODP_RECPROD_VW (SQL View)	Index Back
Record Product View Data Privacy Framework: Record Product View

EODP_RECPROD_VW

(SQL View)

Record Product View

Data Privacy Framework: Record Product View

SELECT A.RECNAME ,A.OBJECTOWNERID ,COALESCE(B.EODP_PRODUCT_CD ,A.OBJECTOWNERID) FROM PSRECDEFN A LEFT OUTER JOIN PS_EODP_PROD_DEFN B ON A.OBJECTOWNERID=B.OBJECTOWNERID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 OBJECTOWNERID Character(4) VARCHAR2(4) NOT NULL Object owner identifier

3 EODP_PRODUCT_CD Character(4) VARCHAR2(4) NOT NULL PeopleSoft Product Code. Created for Sensitive Data Framework

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN).
2	OBJECTOWNERID	Character(4)	VARCHAR2(4) NOT NULL	Object owner identifier
3	EODP_PRODUCT_CD	Character(4)	VARCHAR2(4) NOT NULL	PeopleSoft Product Code. Created for Sensitive Data Framework