SPB_SHIFT

(SQL Table)
Index Back

Shift

Shifts

  • Related Language Record: SPB_SHIFT_LANG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: OPR_DEF_TBL_FS.SETID

    Prompt Table: SP_SETID_NONVW

    2 SHIFT_ID Character(10) VARCHAR2(10) NOT NULL Shift ID
    3 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    4 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    5 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description
    6 START_TIME Time(15) TIMESTAMP Start of Shift
    7 END_TIME Time(15) TIMESTAMP End of Shift
    8 SHIFT_PAY Character(1) VARCHAR2(1) NOT NULL Shift Pay
    A=Add to Work Order Rate
    P=Add % of Work Order Rate
    S=Substitute Work Order Rate
    9 SHIFT_PCT Signed Number(7,2) DECIMAL(5,2) NOT NULL Shift Percent
    10 SP_PAY_RATE Number(15,4) DECIMAL(14,4) NOT NULL pay rate
    11 SP_FIXED_COST Number(15,4) DECIMAL(14,4) NOT NULL fixed costs
    12 SP_VNDR_MARKUP Number(15,4) DECIMAL(14,4) NOT NULL vendor markup
    13 SP_3RDPARTY_MARKUP Number(15,4) DECIMAL(14,4) NOT NULL third party markup amount
    14 SPB_SHIFT_RT Signed Number(16,4) DECIMAL(14,4) NOT NULL Shift Rate
    15 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Prompt Table: CURRENCY_CD_TBL

    16 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
    MHR=Muti Hourly
    PER=Percentage
    SQF=Square Footage

    Prompt Table: SPF_UOM_VW