PRCSRECURDATE

(SQL Table)
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 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