GPDE_GR_EE_NRAD

(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 GP_PKG_ID Character(10) VARCHAR2(10) NOT NULL Field used for element packaging
    2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    3 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
    4 GPDE_GR_SEQ Number(3,0) SMALLINT NOT NULL Garnishment Priority
    5 EFFDT Date(10) DATE Effective Date
    6 GPDE_GR_PRE Character(1) VARCHAR2(1) NOT NULL Pre-Garnishment
    7 GPDE_GR_STATUS Character(1) VARCHAR2(1) NOT NULL Garnishment Status
    A=Active
    I=Inactive
    8 ENTRY_TYPE_ELEM Character(3) VARCHAR2(3) NOT NULL entry type element
    9 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number
    10 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
    11 GPDE_GR_AMT Signed Number(14,2) DECIMAL(12,2) NOT NULL Garnishment Amount
    12 GPDE_GR_MX_AMT Signed Number(14,2) DECIMAL(12,2) NOT NULL Maximum Garnishment Amount
    13 GPDE_GR_INTRST_RT Number(6,2) DECIMAL(5,2) NOT NULL Interest Rate
    14 GPDE_GR_PIN_IR_NUM Number(8,0) INTEGER NOT NULL Interest Rate - Garnishment
    15 GPDE_GR_PRC_FEE Number(6,2) DECIMAL(5,2) NOT NULL Garnishment Processing Fee
    16 GPDE_GR_PIN_PF_NUM Number(8,0) INTEGER NOT NULL Garnishment Processing Fee
    17 GPDE_GR_OVERWRITE Character(1) VARCHAR2(1) NOT NULL Dependents Overwrite
    18 GPDE_GR_DEPEND_NBR Character(1) VARCHAR2(1) NOT NULL Number of Dependents
    19 GPDE_GR_DEPEND_AMT Signed Number(14,2) DECIMAL(12,2) NOT NULL Exemption Amount
    20 GPDE_GR_DEPEND_PCT Number(3,0) SMALLINT NOT NULL Exemption Percent
    21 GPDE_GR_MIN_AMT Signed Number(14,2) DECIMAL(12,2) NOT NULL Minimum Income Amt (Par. 850f)
    22 GPDE_GR_MIN_PCT Number(13,2) DECIMAL(12,2) NOT NULL Minimum Income Percent
    23 GPDE_GR_OTH_INCOME Signed Number(14,2) DECIMAL(12,2) NOT NULL Other Income (Par. 850e)
    24 GPDE_GR_ARREARS Signed Number(14,2) DECIMAL(12,2) NOT NULL Arrears
    25 GPDE_GR_DIST_PCT Number(3,0) SMALLINT NOT NULL Uniform Priority Distribution