GARN_RULE

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERSON
2	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company Prompt Table: COMPANY_TBL
3	GARNID	Character(6)	VARCHAR2(6) NOT NULL	Garnishment id. Prompt Table: GARN_SPEC
4	STATE_GARN_LAW	Character(6)	VARCHAR2(6) NOT NULL	Garnish Law Source Prompt Table: %RECNAME_EDIT
5	GARN_RULE_ID	Character(10)	VARCHAR2(10) NOT NULL	Garnish Rule ID Prompt Table: GARN_RULE_TBL
6	GARN_DED_SW	Character(1)	VARCHAR2(1) NOT NULL	Garnishment Deduction SW
7	GARN_EX_AMT	Number(9,2)	DECIMAL(8,2) NOT NULL	Garnishment exemption amount.
8	PY_GARN_EX_AMT2	Number(9,2)	DECIMAL(8,2) NOT NULL	Exemption Amount.
9	PY_GARN_EX_AMT3	Number(9,2)	DECIMAL(8,2) NOT NULL	Exemption Amount.
10	GARN_EX_PCT	Number(6,2)	DECIMAL(5,2) NOT NULL	Garnishment exemption percent.
11	PY_GARN_EX_PCT2	Number(6,2)	DECIMAL(5,2) NOT NULL	Exemption Percent.
12	PY_GARN_EX_PCT3	Number(6,2)	DECIMAL(5,2) NOT NULL	Exemption Percent.
13	PY_GARN_EX_PCT4	Number(6,2)	DECIMAL(5,2) NOT NULL	Exemption Percent.
14	GARN_EX_HRS	Number(6,2)	DECIMAL(5,2) NOT NULL	Garnishment exemption hours.
15	PY_GARN_EX_HRS2	Number(6,2)	DECIMAL(5,2) NOT NULL	Exemption Hours.
16	GARN_VAR_FREQUENCY	Character(1)	VARCHAR2(1) NOT NULL	Garnishment variable frequency. D=Daily M=Monthly W=Weekly Default Value: M Prompt Table: GRN_VAR_FREQ_VW
17	GARN_DEP_EX_CNT	Number(3,0)	SMALLINT NOT NULL	Garnish Dependent/Exempt Count
18	GARN_ALLOW_CNT	Number(3,0)	SMALLINT NOT NULL	Garnish Allowance Count
19	GARN_EX_MIN	Number(9,2)	DECIMAL(8,2) NOT NULL	Garnishment exemption minimum.
20	GARN_EX_MAX	Number(9,2)	DECIMAL(8,2) NOT NULL	Garnishment exemption maximum.
21	FORM_668W_YR	Character(4)	VARCHAR2(4) NOT NULL	Form 668-W Effective Year