RECURNAMEDefault: 1
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 |