GPDE_GR_EE1

(SQL Table)
Index Back

Payee Garnishment Assignment

Payee Garnishment Assignment

  • Related Language Record: GPDE_GR_EE1_LNG
  • Parent Record Of GPDE_GR_AR_VW GPDE_GR_EE2 GPDE_GR_EE_NRVW
  • # 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 GPDE_GR_TYPE Character(1) VARCHAR2(1) NOT NULL Garnishment Type
    1=General Garnishment
    2=Support Garnishment
    5 GPDE_GR_ID Character(20) VARCHAR2(20) NOT NULL Garnishment Identificator
    6 GPDE_GR_COURT_NAME Character(20) VARCHAR2(20) NOT NULL Garnishment Identificator
    7 GPDE_GR_RECEIVE_DT DateTime(26) TIMESTAMP Garnishment Received Date

    Default Value: %date

    8 DESCR1_GER Character(30) VARCHAR2(30) NOT NULL Description