HRS_OFF_CMPNT

(SQL Table)
 Index Back

Offer Component Table

This record is used in HR Recruit to store multiple offer components.

  • Related Language Record: HRS_OFF_C_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OFFER_COMPONENT Character(7) VARCHAR2(7) NOT NULL Offer Component
    2 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    3 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

    Default Value: HRS_OFF_CMPNT.DESCR

    6 OFFER_TYPE Character(7) VARCHAR2(7) NOT NULL Offer Type

    Prompt Table: HRS_OFF_TYPES

    7 OFFER_FREQUENCY Character(1) VARCHAR2(1) NOT NULL Indicates the offer amount frequency.
    A=Annual
    B=Biweekly
    C=Contract
    D=Daily
    F=Every Four Weeks
    H=Hourly
    M=Monthly
    O=One-Time
    Q=Quarterly
    S=Semimonthly
    W=Weekly
    8 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Prompt Table: CURRENCY_CD_TBL

    9 MONETARY_IND Character(1) VARCHAR2(1) NOT NULL Monetary Indicator
    L=Leaves
    M=Meal Vouchers
    N=Non Cash
    S=Stock Options
    Y=Cash

    Default Value: Y

    10 HRS_ROW_ADD_DTTM DateTime(26) TIMESTAMP Row Added DateTime
    11 HRS_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Added Operator Id
    12 HRS_ROW_UPD_DTTM DateTime(26) TIMESTAMP Row Updated DateTime
    13 HRS_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Updated Operator Id