GPDE_GR_EEONRVW

(SQL View)
 Index Back

Export View - EE Garn Override

Export View for Individual Payee Garnishment Override concerning Earnings and Deductions.

SELECT EMPLID , EMPL_RCD , GPDE_GR_SEQ , EFFDT , ENTRY_TYPE_ELEM , GPDE_PIN_NUM_ED + 50000000 , GPDE_PIN_NUM_AC + 50000000 , GPDE_PIN_NUM_VR + 50000000 , GPDE_GR_OVRD_PCT FROM PS_GPDE_GR_EE_OVRD

# 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 Record
3 GPDE_GR_SEQ Number(3,0) SMALLINT NOT NULL Garnishment Priority

Default Value: 1

4 EFFDT Date(10) DATE Effective Date

Default Value: %date

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

Prompt Table: GP_ENT_OVRD4_VW

6 GPDE_PIN_NUM_ED Number(8,0) INTEGER NOT NULL PIN Number Deduction

Prompt Table: %RECNAME_EDIT

7 GPDE_PIN_NUM_AC Number(8,0) INTEGER NOT NULL PIN Number Accumulator

Prompt Table: GPDE_GR_AC_VW

8 GPDE_PIN_NUM_VR Number(8,0) INTEGER NOT NULL Variable for Garnishment Earning/Deduction Override Handling.

Prompt Table: GPDE_GR_VR_VW

9 GPDE_GR_OVRD_PCT Number(3,0) SMALLINT NOT NULL Earning/Deduction Percent Override