EODP_ROLRECF_VW

(SQL View)
 Index Back

Data Privacy Query Masking

Defining the Query Record access as part of Data Privacy Query Masking

SELECT A.ROLENAME ,A.EODP_ROLEDESCR ,A.RECNAME ,A.FIELDNAME ,A.EODP_ACCESS_CD , (CASE WHEN ( SELECT 'X' FROM PSPIIBYPASS B WHERE B.ROLENAME= A.ROLENAME AND B.RECNAME = A.RECNAME AND B.FIELDNAME = A.FIELDNAME) = 'X' THEN 'Y' ELSE 'N' END) ,A.EODP_LASTUPDOPRID ,A.EODP_LASTUPDDTTM FROM PS_EODP_ROLRECFLD A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 ROLENAME Character(30) VARCHAR2(30) NOT NULL The name of a Role in the Role Definition Table (see PSROLEDEFN).

Prompt Table: PSROLEDEFN

2 EODP_ROLEDESCR Character(50) VARCHAR2(50) NOT NULL Role Description
3 EODP_RECORDNAME Character(15) VARCHAR2(15) NOT NULL Record Name
4 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
5 EODP_ACCESS_CD Character(1) VARCHAR2(1) NOT NULL Access Code
N=Not Authorized
Y=Authorized
6 EODP_SYNC_STATUS Character(1) VARCHAR2(1) NOT NULL Query Authorized Roles Sync Status
N=No
Y=Yes
7 EODP_LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry.
8 EODP_LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry.