EODP_PROCESS_NAMEN=Disabled
Y=Enabled
F=Full
I=Incremental
R=Reset
Default Value: F
R=Run Now
S=Schedule
Default Value: R
O=One Time
R=Recurrence
Prompt Table:
EODP_QRY_RECUR
Set Control Field: RECURNAME
EODP_QRYMSK_RUN(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EODP_PROCESS_NAME |
Character(12) | VARCHAR2(12) NOT NULL | Process Name |
| 2 | EODP_QRY_MASKING | Character(1) | VARCHAR2(1) NOT NULL |
Enable/Disable Query Masking
N=Disabled Y=Enabled |
| 3 | EODP_REFRESH_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Query Masking refresh mode
F=Full I=Incremental R=Reset Default Value: F |
| 4 | EODP_RUN_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Query Sync Run type
R=Run Now S=Schedule Default Value: R |
| 5 | EODP_SCHEDULE_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Query Masking Schedule type
O=One Time R=Recurrence |
| 6 | EODP_START_DATE | Date(10) | DATE | Start Date |
| 7 | EODP_START_TIME | Time(15) | TIMESTAMP | Start Time |
| 8 | EODP_RUNRECURRANCE | Character(30) | VARCHAR2(30) NOT NULL |
Process Scheduler Process Run Recurrence
Prompt Table:
EODP_QRY_RECUR
|
| 9 | EODP_LASTUPDOPRID | Character(30) | VARCHAR2(30) NOT NULL | Specifies the User ID which made the last update to an entry. |
| 10 | EODP_LASTUPDDTTM | DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. |
| 11 | EODP_NEXT_RUN_DTTM | DateTime(26) | TIMESTAMP | Next Run Date/Time |