HP_CNTRACT_LIST

(SQL Table)
 Index Back

Contract List

HP_CNTRACT_LIST contains all employees contracts and their corresponding contract status with recalculation indicator.

  • Parent Record Of CONTRACT HP_CONTPAY_PARM

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
    3 HP_CONTRACT_NUM Number(7,0) INTEGER NOT NULL Contract Number
    4 HP_CONTRACT_STATUS Character(1) VARCHAR2(1) NOT NULL Contract Status
    A=Active
    C=Complete
    5 HP_RECALC_CONTRACT Character(1) VARCHAR2(1) NOT NULL Recalculate Contract Indicator
    N=No
    Y=Yes

    Default Value: N