RECURNAMERECUR_DATE1=Next Calculated Date
2=Next Specified Date
3=Next Business Day
Default Value: 1
1=before
2=after
PRCSRECUREXEMPT(SQL Table) |
Index Back |
|---|---|
Process Schdlr Recurring DateThis Process Scheduler table contains all dates used for recurrence definition. It can contain two types of dates 1) Exception Date - Date where a request will not be run 2) Run Date - Specific date where a request should run |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | RECURNAME |
Character(30) | VARCHAR2(30) NOT NULL | Recurrence Name |
| 2 | RECUR_DATE |
Date(10) | DATE | Run Date (From) |
| 3 | RECURUNTIL | Date(10) | DATE | date field to hold Process Scheduler Recurrence Definition Run/Exception Until date |
| 4 | RECURUNTILYEAR | Number(4,0) | SMALLINT NOT NULL | Number field to hold the Until year for Process Scheduler Recurrence Definition Run/Exception items. |
| 5 | RECURDESCR | Character(30) | VARCHAR2(30) NOT NULL | Recurrence Description |
| 6 | RESCHEDOPTIONTYPE | Character(4) | VARCHAR2(4) NOT NULL |
for rescheduling the Process Scheduler Recurrence Definiton run date
1=Next Calculated Date 2=Next Specified Date 3=Next Business Day Default Value: 1 |
| 7 | ADJUSTDAYS | Number(3,0) | SMALLINT NOT NULL | To hold # days before/after exception date for Process Scheduler Recurrence Definition |
| 8 | ADJUSTOPTION | Character(4) | VARCHAR2(4) NOT NULL |
To hold before/after run date exception setting for Process Scheduler Recurrence Definition
1=before 2=after |