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 NameField TypeColumn TypeDescription
RECURNAMECharacter(30)VARCHAR2(30) NOT NULLRecurrence Name
RECUR_DATEDate(10)DATERun Date (From)
RECURUNTILDate(10)DATEdate field to hold Process Scheduler Recurrence Definition Run/Exception Until date
RECURUNTILYEARNumber(4,0)SMALLINT NOT NULLNumber field to hold the Until year for Process Scheduler Recurrence Definition Run/Exception items.
RECURDESCRCharacter(30)VARCHAR2(30) NOT NULLRecurrence Description
RESCHEDOPTIONTYPECharacter(4)VARCHAR2(4) NOT NULLfor rescheduling the Process Scheduler Recurrence Definiton run date
1=Next Calculated Date
2=Next Specified Date
3=Next Business Day

Default: 1

ADJUSTDAYSNumber(3,0)SMALLINT NOT NULLTo hold # days before/after exception date for Process Scheduler Recurrence Definition
ADJUSTOPTIONCharacter(4)VARCHAR2(4) NOT NULLTo 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.ukPeopleTools 8.54
PTRef generated on 09-JUN-19