GARN_SCHED

(SQL Table)
 Index Back

EE Garnishment Schedule

Defines garnishment schedules by pay frequency for an employee.

  • Parent record: GARN_SPEC

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PERSON

    2 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

    Prompt Table: COMPANY_TBL

    3 GARNID Character(6) VARCHAR2(6) NOT NULL Garnish ID

    Prompt Table: GARN_SPEC

    4 PAY_FREQUENCY Character(5) VARCHAR2(5) NOT NULL Pay Frequency
    A=Annual
    B=Biweekly
    D=Daily
    M=Monthly
    Q=Quarterly
    S=Semimonthly
    W=Weekly

    Default Value: W

    Prompt Table: GRN_FREQ_TBL_VW

    5 PAY_PERIOD Character(1) VARCHAR2(1) NOT NULL Pay Period
    1=First
    2=Second
    3=Third
    4=Fourth
    5=Fifth

    Default Value: 1

    6 GARN_DED_CALC Character(1) VARCHAR2(1) NOT NULL Garnish Deduction Calc Routine
    G=Greater of %DE or Amount
    H=Greater of %Gross or Amount
    M=Maximum Allowed
    P=% DE + Amount
    R=% Gross + Amount
    S=No exempt; %DE + Amt
    T=No exempt; % of Gross

    Default Value: P

    7 GARN_DED_PCT Number(6,2) DECIMAL(5,2) NOT NULL Garnish Deduct DE Percent
    8 GARN_DED_AMT Number(9,2) DECIMAL(8,2) NOT NULL Garnish Flat Deduction Amount
    9 CMPNY_FEE_PCT Number(6,2) DECIMAL(5,2) NOT NULL Company's Voucher Fee Percent
    10 CMPNY_FEE_AMT Number(9,2) DECIMAL(8,2) NOT NULL Company's Voucher Fee Amount
    11 PAYEE_FEE_PCT Number(6,2) DECIMAL(5,2) NOT NULL Payee's Voucher Fee Percent
    12 PAYEE_FEE_AMT Number(9,2) DECIMAL(8,2) NOT NULL Payee's Voucher Fee Amount