SPA_TRULE_SEQ

(SQL Table)
Index Back

Time Reporting Rule:Sequence

Time Reporting Rule Sequencing Record

  • Parent record: SPA_TRULE_DFN
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    2 SPA_TIME_RULE_ID Character(10) VARCHAR2(10) NOT NULL Time Reporting Rule ID
    3 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    4 SPA_RULE_STEP Number(4,0) SMALLINT NOT NULL Rule Step

    Default Value: 1

    5 SPA_RULE_SEQ Number(3,0) SMALLINT NOT NULL Rule Sequence

    Default Value: 10

    6 SPA_RULE_SCOPE Character(3) VARCHAR2(3) NOT NULL Rule Scope
    ACT=Activity
    DAT=Date
    DOW=Day of Week
    HOL=Holiday Schedule
    PER=Time Period
    7 SPA_RULE_TYPE Character(3) VARCHAR2(3) NOT NULL Rule Type
    AMT=Amount
    CLK=Clock
    LST=TRC List
    QTY=Time Quantity

    Default Value: QTY