PRCSRECUR

index back

Recurrence Defn

This record is used to define recurrences. Recurrences allow process requests to repeat at a specified date/time.

  • Related language record: PRCSRECURLANG
  • PeopleSoft Field NameField TypeColumn TypeDescription
    RECURTYPENumber(1,0)SMALLINT NOT NULLRecurrence Type
    RECURNAMECharacter(30)VARCHAR2(30) NOT NULLRecurrence Name
    VERSIONNumber(10,0)DECIMAL(10) NOT NULLVersion. Internal PeopleTools version for controlling caching of object. - Version/Table reference
    DAYOFMONTHNumber(2,0)SMALLINT NOT NULLDay of Month
    RUN1STWEEKNumber(1,0)SMALLINT NOT NULLRun 1st Week
    RUN2NDWEEKNumber(1,0)SMALLINT NOT NULLRun 2nd Week
    RUN3RDWEEKNumber(1,0)SMALLINT NOT NULLRun 3rd Week
    RUN4THWEEKNumber(1,0)SMALLINT NOT NULLRun 4th Week
    RUN5THWEEKNumber(1,0)SMALLINT NOT NULLRun 5th Week
    RUN6THWEEKNumber(1,0)SMALLINT NOT NULLRun 6th Week
    RUNSUNDAYNumber(1,0)SMALLINT NOT NULLRun Sunday
    RUNMONDAYNumber(1,0)SMALLINT NOT NULLRun Monday
    RUNTUESDAYNumber(1,0)SMALLINT NOT NULLRun Tuesday
    RUNWEDNESDAYNumber(1,0)SMALLINT NOT NULLRun Wednesday
    RUNTHURSDAYNumber(1,0)SMALLINT NOT NULLRun Thursday
    RUNFRIDAYNumber(1,0)SMALLINT NOT NULLRun Friday
    RUNSATURDAYNumber(1,0)SMALLINT NOT NULLRun Saturday
    RECURDAYSPCLNumber(1,0)SMALLINT NOT NULLRecurrence Special Days
    BEGINDTTMDateTime(26)TIMESTAMPBegin Date/Time
    REPEATRECURRENCENumber(5,0)INTEGER NOT NULLRepeat Recurrence
    REPEATUNITNumber(1,0)SMALLINT NOT NULLRepeat Unit
    DURATIONNumber(5,0)INTEGER NOT NULLRecurrence Duration
    DURATIONUNITNumber(1,0)SMALLINT NOT NULLRecurrence Duration Unit
    INITIATEWHENNumber(1,0)SMALLINT NOT NULLInitiate When
    RECURDESCRCharacter(30)VARCHAR2(30) NOT NULLRecurrence Description
    LASTUPDDTTMDateTime(26)TIMESTAMPSpecifies 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.
    LASTUPDOPRIDCharacter(30)VARCHAR2(30) NOT NULLSpecifies 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.
    ENDDTTMDateTime(26)TIMESTAMPEnd Date/Time
    RECUR_USECURRDATENumber(1,0)SMALLINT NOT NULLUse Current Date/Time
    index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19