WRK_GARN_OVRD

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company Prompt Table: COMPANY_TBL
2	PAYGROUP	Character(3)	VARCHAR2(3) NOT NULL	Pay Group Prompt Table: PAYGROUP_TBL
3	PAY_END_DT	Date(10)	DATE NOT NULL	Pay Period End Date Prompt Table: PAY_CALENDAR
4	OFF_CYCLE	Character(1)	VARCHAR2(1) NOT NULL	Off Cycle ? Y/N Table Edit
5	PAGE_NUM	Number(4,0)	SMALLINT NOT NULL	Page #
6	LINE_NUM	Number(2,0)	SMALLINT NOT NULL	Line #
7	ADDL_NBR	Number(3,0)	SMALLINT NOT NULL	Additional Pay Line #
8	SEPCHK	Number(1,0)	SMALLINT NOT NULL	Separate check number.
9	GARNID	Character(6)	VARCHAR2(6) NOT NULL	Garnish ID Prompt Table: GARN_SPEC
10	GARN_ONE_TIME_CD	Character(1)	VARCHAR2(1) NOT NULL	Garnish Override One Time Code O=Override Garnishment Amounts R=Refund Garnishment Amount S=Suspend Garnishment
11	GARN_PRIORITY	Number(3,0)	SMALLINT NOT NULL	Garnish Priority
12	GARN_DED_CALC	Character(1)	VARCHAR2(1) NOT NULL	Garnish Deduction Calc Routine G=Greater of %DE or Amount H=Greater of %Gross or Amount M=Maximum Allowed P=% DE + Amount R=% Gross + Amount S=No exempt; %DE + Amt T=No exempt; % of Gross
13	GARN_DED_PCT	Number(6,2)	DECIMAL(5,2) NOT NULL	Garnish Deduct DE Percent
14	GARN_DED_AMT	Number(9,2)	DECIMAL(8,2) NOT NULL	Garnish Flat Deduction Amount
15	CMPNY_FEE_PCT	Number(6,2)	DECIMAL(5,2) NOT NULL	Company's Voucher Fee Percent
16	CMPNY_FEE_AMT	Number(9,2)	DECIMAL(8,2) NOT NULL	Company's Voucher Fee Amount
17	PAYEE_FEE_PCT	Number(6,2)	DECIMAL(5,2) NOT NULL	Payee's Voucher Fee Percent
18	PAYEE_FEE_AMT	Number(9,2)	DECIMAL(8,2) NOT NULL	Payee's Voucher Fee Amount
19	PY_GARN_EXEMPT	Character(1)	VARCHAR2(1) NOT NULL	Yes/No field to indicate whether exemption amount should be calculated for a Tax levy garnishment or not Y/N Table Edit Default Value: N