ROLENAMEPrompt Table: PSROLEDEFN
EODP_ROLEDESCRRECNAMEPrompt Table: EODP_RECORDLIST
FIELDNAMEPrompt Table:
EODP_FIELDSLIST
Set Control Field: RECNAME
N=Not Authorized
Y=Authorized
EODP_ROLRECFLD(SQL Table) |
Index Back |
|---|---|
Data Privacy Query MaskingDefining the Query Record access as part of Data Privacy Query Masking |
| # | 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 | RECNAME |
Character(15) | VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
Prompt Table: EODP_RECORDLIST |
| 4 | FIELDNAME |
Character(18) | VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
Prompt Table:
EODP_FIELDSLIST
|
| 5 | EODP_ACCESS_CD | Character(1) | VARCHAR2(1) NOT NULL |
Access Code
N=Not Authorized Y=Authorized |
| 6 | EODP_LASTUPDOPRID | Character(30) | VARCHAR2(30) NOT NULL | Specifies the User ID which made the last update to an entry. |
| 7 | EODP_LASTUPDDTTM | DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. |