RECURNAMEDefault Value: 1
PRCSRECUR(SQL Table) |
Index Back |
|---|---|
Recurrence DefnThis record is used to define recurrences. Recurrences allow process requests to repeat at a specified date/time. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | RECURTYPE | Number(1,0) | SMALLINT NOT NULL | Recurrence Type |
| 2 | RECURNAME |
Character(30) | VARCHAR2(30) NOT NULL | Recurrence Name |
| 3 | VERSION | Number(10,0) | DECIMAL(10) NOT NULL | Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference |
| 4 | DAYOFMONTH | Number(2,0) | SMALLINT NOT NULL | Day of Month |
| 5 | RUN1STWEEK | Number(1,0) | SMALLINT NOT NULL | Run 1st Week |
| 6 | RUN2NDWEEK | Number(1,0) | SMALLINT NOT NULL | Run 2nd Week |
| 7 | RUN3RDWEEK | Number(1,0) | SMALLINT NOT NULL | Run 3rd Week |
| 8 | RUN4THWEEK | Number(1,0) | SMALLINT NOT NULL | Run 4th Week |
| 9 | RUN5THWEEK | Number(1,0) | SMALLINT NOT NULL | Run 5th Week |
| 10 | RUN6THWEEK | Number(1,0) | SMALLINT NOT NULL | Run 6th Week |
| 11 | RUNSUNDAY | Number(1,0) | SMALLINT NOT NULL | Run Sunday |
| 12 | RUNMONDAY | Number(1,0) | SMALLINT NOT NULL | Run Monday |
| 13 | RUNTUESDAY | Number(1,0) | SMALLINT NOT NULL | Run Tuesday |
| 14 | RUNWEDNESDAY | Number(1,0) | SMALLINT NOT NULL | Run Wednesday |
| 15 | RUNTHURSDAY | Number(1,0) | SMALLINT NOT NULL | Run Thursday |
| 16 | RUNFRIDAY | Number(1,0) | SMALLINT NOT NULL | Run Friday |
| 17 | RUNSATURDAY | Number(1,0) | SMALLINT NOT NULL | Run Saturday |
| 18 | RECURDAYSPCL | Number(1,0) | SMALLINT NOT NULL | Recurrence Special Days |
| 19 | PTRECUREVERY | Number(2,0) | SMALLINT NOT NULL |
Recurrence
Default Value: 1 |
| 20 | BEGINDTTM | DateTime(26) | TIMESTAMP | Begin Date/Time |
| 21 | REPEATRECURRENCE | Number(5,0) | INTEGER NOT NULL | Repeat Recurrence |
| 22 | REPEATUNIT | Number(1,0) | SMALLINT NOT NULL | Repeat Unit |
| 23 | DURATION | Number(5,0) | INTEGER NOT NULL | Recurrence Duration |
| 24 | DURATIONUNIT | Number(1,0) | SMALLINT NOT NULL | Recurrence Duration Unit |
| 25 | INITIATEWHEN | Number(1,0) | SMALLINT NOT NULL | Initiate When |
| 26 | RECURDESCR | Character(30) | VARCHAR2(30) NOT NULL | Recurrence Description |
| 27 | 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. |
| 28 | 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. |
| 29 | ENDDTTM | DateTime(26) | TIMESTAMP | End Date/Time |
| 30 | RECUR_USECURRDATE | Number(1,0) | SMALLINT NOT NULL | Use Current Date/Time |