HRS_OFF_DTL_HST

(SQL Table)
 Index Back

Employmt Offers to Applicants

Use OFFER to record details about job offers made to applicants for employment. This data is used in the Recruitment module.

  • Parent record: HRS_RCMNT

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PSARCH_ID Character(8) VARCHAR2(8) NOT NULL Archive ID (see PSARCHTEMPLATE).
    2 PSARCH_BATCHNUM Number(30,0) DECIMAL(30) NOT NULL Archive Batch Number
    3 HRS_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL Person Id
    4 HRS_RCMNT_ID Number(15,0) DECIMAL(15) NOT NULL App Tracking Recruitment ID
    5 HRS_OFF_ID Number(15,0) DECIMAL(15) NOT NULL Offer ID
    6 OFFER_COMPONENT Character(7) VARCHAR2(7) NOT NULL Offer Component

    Prompt Table: HRS_OFF_CMPNT

    7 OFFER_AMT Number(19,6) DECIMAL(18,6) NOT NULL Offer Amount
    8 SEQUENCE_NUMBER Number(2,0) SMALLINT NOT NULL Sequence Number
    9 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Prompt Table: CURRENCY_CD_TBL

    10 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
    11 ERNCD Character(3) VARCHAR2(3) NOT NULL Earnings Code
    12 EARNS_AMT Signed Number(12,2) DECIMAL(10,2) NOT NULL Earnings Amount
    13 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
    14 HRS_ROW_ADD_DTTM DateTime(26) TIMESTAMP Row Added DateTime
    15 HRS_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Added Operator Id
    16 HRS_ROW_UPD_DTTM DateTime(26) TIMESTAMP Row Updated DateTime
    17 HRS_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Updated Operator Id