RUNCNTLIDUSERIDN=Disabled
Y=Enabled
F=Full
I=Incremental
R=Reset
R=Run Now
S=Schedule
O=One Time
R=Recurrence
C=Completed
E=Error
P=Processing
EODP_QRMSK_CTRL(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | RUNCNTLID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 2 | USERID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID |
| 3 | EODP_LASTRUN_DTTM | DateTime(26) | TIMESTAMP | Last Run On |
| 4 | EODP_QRY_MASKING | Character(1) | VARCHAR2(1) NOT NULL |
Enable/Disable Query Masking
N=Disabled Y=Enabled |
| 5 | EODP_REFRESH_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Query Masking refresh mode
F=Full I=Incremental R=Reset |
| 6 | EODP_RUN_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Query Sync Run type
R=Run Now S=Schedule |
| 7 | EODP_SCHEDULE_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Query Masking Schedule type
O=One Time R=Recurrence |
| 8 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 9 | EODP_PRCS_STS | Character(1) | VARCHAR2(1) NOT NULL |
Sensitive Data Framework: Processing Status for Generate References AE
C=Completed E=Error P=Processing |
| 10 | EODP_ENDDTTM | DateTime(26) | TIMESTAMP | End Date/Time |
| 11 | EODP_LASTUPDOPRID | Character(30) | VARCHAR2(30) NOT NULL | Specifies the User ID which made the last update to an entry. |
| 12 | EODP_LASTUPDDTTM | DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. |