GPDE_GR_EE2

(SQL Table)
Index Back

Payee Garnishment Assignment

Payee Garnishment Assignment

  • Parent record: GPDE_GR_EE1
  • # 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 Rcd Nbr
    3 GPDE_GR_SEQ Number(3,0) SMALLINT NOT NULL Garnishment Priority

    Default Value: 1

    4 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    5 GPDE_GR_PRE Character(1) VARCHAR2(1) NOT NULL Pre-Garnishment

    Y/N Table Edit

    Default Value: N

    6 GPDE_GR_STATUS Character(1) VARCHAR2(1) NOT NULL Garnishment Status
    A=Active
    I=Inactive

    Default Value: A

    7 ENTRY_TYPE_ELEM Character(3) VARCHAR2(3) NOT NULL entry type element

    Prompt Table: GPDE_GR_PROMPT

    8 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number

    Prompt Table: GPDE_GR_PNM1_VW

    9 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Default Value: OPR_DEF_TBL_HR.EXCHNG_TO_CURRENCY

    Prompt Table: CURRENCY_CD_TBL

    10 GPDE_GR_AMT Signed Number(14,2) DECIMAL(12,2) NOT NULL Garnishment Amount
    11 GPDE_GR_MX_AMT Signed Number(14,2) DECIMAL(12,2) NOT NULL Maximum Garnishment Amount
    12 GPDE_GR_INTRST_RT Number(6,2) DECIMAL(5,2) NOT NULL Interest Rate
    13 GPDE_GR_PIN_IR_NUM Number(8,0) INTEGER NOT NULL Interest Rate - Garnishment

    Prompt Table: GPDE_GR_PNM2_VW

    14 GPDE_GR_PRC_FEE Number(6,2) DECIMAL(5,2) NOT NULL Garnishment Processing Fee
    15 GPDE_GR_PIN_PF_NUM Number(8,0) INTEGER NOT NULL Garnishment Processing Fee

    Prompt Table: GPDE_GR_PNM3_VW

    16 GPDE_GR_OVERWRITE Character(1) VARCHAR2(1) NOT NULL Dependents Overwrite

    Y/N Table Edit

    Default Value: N

    17 GPDE_GR_DEPEND_NBR Character(1) VARCHAR2(1) NOT NULL Number of Dependents

    Default Value: 0

    Prompt Table: GPDE_GR_ALLW_VW

    18 GPDE_GR_DEPEND_AMT Signed Number(14,2) DECIMAL(12,2) NOT NULL Exemption Amount
    19 GPDE_GR_DEPEND_PCT Number(3,0) SMALLINT NOT NULL Exemption Percent
    20 GPDE_GR_MIN_AMT Signed Number(14,2) DECIMAL(12,2) NOT NULL Minimum Income Amt (Par. 850f)
    21 GPDE_GR_MIN_PCT Number(13,2) DECIMAL(12,2) NOT NULL Minimum Income Percent
    22 GPDE_GR_OTH_INCOME Signed Number(14,2) DECIMAL(12,2) NOT NULL Other Income (Par. 850e)
    23 GPDE_GR_ARREARS Signed Number(14,2) DECIMAL(12,2) NOT NULL Arrears
    24 GPDE_GR_DIST_PCT Number(3,0) SMALLINT NOT NULL Uniform Priority Distribution