GARN_EXEMPT_TBL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	STATE_GARN_LAW	Character(6)	VARCHAR2(6) NOT NULL	Garnish Law Source Prompt Table: STATE_NAMES_VW
2	GARN_RULE_ID	Character(10)	VARCHAR2(10) NOT NULL	Garnish Rule ID Prompt Table: GARN_RULE_TBL
3	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
4	GARN_EX_CALC	Character(1)	VARCHAR2(1) NOT NULL	Garnish Exempt Calc Routine C=General Calculation D=Based on Standard Deduction E=General Calc with Entered Amt H=Based on Minimum Hourly Wage O=Exemption override on payline R=Garnish Exempt Calc Routine Default Value: R
5	GARN_VAR_FREQUENCY	Character(1)	VARCHAR2(1) NOT NULL	Garnishment variable frequency. D=Daily M=Monthly W=Weekly Default Value: M
6	GARN_EX_HRS	Number(6,2)	DECIMAL(5,2) NOT NULL	Garnishment exemption hours.
7	PY_GARN_EX_HRS2	Number(6,2)	DECIMAL(5,2) NOT NULL	Exemption Hours.
8	GARN_EX_PCT	Number(6,2)	DECIMAL(5,2) NOT NULL	Garnishment exemption percent.
9	PY_GARN_EX_PCT2	Number(6,2)	DECIMAL(5,2) NOT NULL	Exemption Percent.
10	PY_GARN_EX_PCT3	Number(6,2)	DECIMAL(5,2) NOT NULL	Exemption Percent.
11	PY_GARN_EX_PCT4	Number(6,2)	DECIMAL(5,2) NOT NULL	Exemption Percent.
12	GARN_EX_AMT	Number(9,2)	DECIMAL(8,2) NOT NULL	Garnishment exemption amount.
13	PY_GARN_EX_AMT2	Number(9,2)	DECIMAL(8,2) NOT NULL	Exemption Amount.
14	PY_GARN_EX_AMT3	Number(9,2)	DECIMAL(8,2) NOT NULL	Exemption Amount.
15	GARN_EX_DEP_EXCL	Number(3,0)	SMALLINT NOT NULL	Garnishment dependents excluded.
16	GARN_EX_DEP_AMT	Number(9,2)	DECIMAL(8,2) NOT NULL	Garnishment exemption amount per dependent.
17	GARN_EX_ALW_AMT	Number(9,2)	DECIMAL(8,2) NOT NULL	Garnishment exemption amount per allowance.
18	GARN_EX_MIN	Number(9,2)	DECIMAL(8,2) NOT NULL	Garnishment exemption minimum.
19	GARN_EX_MAX	Number(9,2)	DECIMAL(8,2) NOT NULL	Garnishment exemption maximum.