PRCSRECUREXEMPT

index back

Process Schdlr Recurring Date

This 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 Field Type Column Type Description
RECURNAME Character(30) VARCHAR2(30) NOT NULL Recurrence Name
RECUR_DATE Date(10) DATE Run Date (From)
RECURUNTIL Date(10) DATE date field to hold Process Scheduler Recurrence Definition Run/Exception Until date
RECURUNTILYEAR Number(4,0) SMALLINT NOT NULL Number field to hold the Until year for Process Scheduler Recurrence Definition Run/Exception items.
RECURDESCR Character(30) VARCHAR2(30) NOT NULL Recurrence Description
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: 1

ADJUSTDAYS Number(3,0) SMALLINT NOT NULL To hold # days before/after exception date for Process Scheduler Recurrence Definition
ADJUSTOPTION Character(4) VARCHAR2(4) NOT NULL To hold before/after run date exception setting for Process Scheduler Recurrence Definition
1=before
2=after
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19