DED_LINE

(SQL Table)
 Index Back

Deduction Line

This record contains the deduction line information for the Payroll Interface Product.

  • Parent record: PAY_CALENDAR

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

    Prompt Table: COMPANY_TBL

    2 PAYGROUP Character(3) VARCHAR2(3) NOT NULL Pay Group

    Prompt Table: PAYGROUP_TBL

    3 PAY_END_DT Date(10) DATE NOT NULL Pay Period End Date

    Prompt Table: PAY_CALENDAR

    4 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PERSON

    5 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
    6 PAY_LINE_STATUS Character(1) VARCHAR2(1) NOT NULL Payline Calculation Status
    C=Calculated
    E=Calculation Error
    F=Confirmed
    I=Initial Load
    P=Pay in Progress
    U=Updated by User
    V=Reversing Check