PRCSRECUR |
index back |
---|---|
Recurrence Defn |
PeopleSoft Field Name | Field Type | Column Type | Description |
---|---|---|---|
RECURTYPE | Number(1,0) | SMALLINT NOT NULL | Recurrence Type |
RECURNAME | Character(30) | VARCHAR2(30) NOT NULL | Recurrence Name |
VERSION | Number(10,0) | DECIMAL(10) NOT NULL | Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference |
DAYOFMONTH | Number(2,0) | SMALLINT NOT NULL | Day of Month |
RUN1STWEEK | Number(1,0) | SMALLINT NOT NULL | Run 1st Week |
RUN2NDWEEK | Number(1,0) | SMALLINT NOT NULL | Run 2nd Week |
RUN3RDWEEK | Number(1,0) | SMALLINT NOT NULL | Run 3rd Week |
RUN4THWEEK | Number(1,0) | SMALLINT NOT NULL | Run 4th Week |
RUN5THWEEK | Number(1,0) | SMALLINT NOT NULL | Run 5th Week |
RUN6THWEEK | Number(1,0) | SMALLINT NOT NULL | Run 6th Week |
RUNSUNDAY | Number(1,0) | SMALLINT NOT NULL | Run Sunday |
RUNMONDAY | Number(1,0) | SMALLINT NOT NULL | Run Monday |
RUNTUESDAY | Number(1,0) | SMALLINT NOT NULL | Run Tuesday |
RUNWEDNESDAY | Number(1,0) | SMALLINT NOT NULL | Run Wednesday |
RUNTHURSDAY | Number(1,0) | SMALLINT NOT NULL | Run Thursday |
RUNFRIDAY | Number(1,0) | SMALLINT NOT NULL | Run Friday |
RUNSATURDAY | Number(1,0) | SMALLINT NOT NULL | Run Saturday |
RECURDAYSPCL | Number(1,0) | SMALLINT NOT NULL | Recurrence Special Days |
PTRECUREVERY | Number(2,0) | SMALLINT NOT NULL |
Recurrence
Default: 1 |
BEGINDTTM | DateTime(26) | TIMESTAMP | Begin Date/Time |
REPEATRECURRENCE | Number(5,0) | INTEGER NOT NULL | Repeat Recurrence |
REPEATUNIT | Number(1,0) | SMALLINT NOT NULL | Repeat Unit |
DURATION | Number(5,0) | INTEGER NOT NULL | Recurrence Duration |
DURATIONUNIT | Number(1,0) | SMALLINT NOT NULL | Recurrence Duration Unit |
INITIATEWHEN | Number(1,0) | SMALLINT NOT NULL | Initiate When |
RECURDESCR | Character(30) | VARCHAR2(30) NOT NULL | Recurrence Description |
LASTUPDDTTM | DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |
LASTUPDOPRID | Character(30) | VARCHAR2(30) NOT NULL | Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |
ENDDTTM | DateTime(26) | TIMESTAMP | End Date/Time |
RECUR_USECURRDATE | Number(1,0) | SMALLINT NOT NULL | Use Current Date/Time |
index back | (c)David Kurtz 2020, www.go-faster.co.uk | PeopleTools 8.58 PTRef generated on 21-DEC-20 |