GPDE_GR_RFNRAD

(SQL Table)
Index Back

Variable Reference Table

Reference Table for Garnishment

# 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_PIN_NUM_DD Number(8,0) INTEGER NOT NULL PIN Number Deduction
7 GPDE_PIN_NUM_AC Number(8,0) INTEGER NOT NULL PIN Number Accumulator
8 GPDE_GR_PIN_IR_NUM Number(8,0) INTEGER NOT NULL Interest Rate - Garnishment
9 GPDE_GR_PIN_PF_NUM Number(8,0) INTEGER NOT NULL Garnishment Processing Fee