WRK_TAX_GRSDED

#	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(5,0)	INTEGER NOT NULL	Page Nbr
6	LINE_NUM	Number(3,0)	SMALLINT NOT NULL	Line Nbr
7	SEPCHK	Number(2,0)	SMALLINT NOT NULL	Separate check number.
8	STATE	Character(6)	VARCHAR2(6) NOT NULL	State
9	LOCALITY	Character(10)	VARCHAR2(10) NOT NULL	Locality
10	TAX_CLASS	Character(3)	VARCHAR2(3) NOT NULL	Tax Balance Class
11	WORK_PSD_CD	Character(6)	VARCHAR2(6) NOT NULL	Locality
12	RES_PSD_CD	Character(6)	VARCHAR2(6) NOT NULL	Locality
13	TAX_GRS_COMPNT	Character(5)	VARCHAR2(5) NOT NULL	Taxable gross component ID.
14	OTHER_RATE_ID	Character(4)	VARCHAR2(4) NOT NULL	This is used as the record key for Other Benefits Rate Data that recategorize rates from parent record Benefit Rate Data. SSCH=Children - SS Rate SSEE=Employee - SS Rate SSSP=Spouse - SS Rate
15	DEDCD	Character(6)	VARCHAR2(6) NOT NULL	Deduction Code
16	DED_CLASS	Character(1)	VARCHAR2(1) NOT NULL	Deduction Classification A=After-Tax B=Before-Tax L=QC Taxable Benefit N=Nontaxable Benefit P=Nontaxable Btax Benefit T=Taxable Benefit Default Value: A
17	TAX_GRS_EFFECT	Character(1)	VARCHAR2(1) NOT NULL	Tax Gross Effect A=Adds To N=No Effect S=Subtracts From Default Value: A
18	TAX_GRS_ADJ	Signed Number(15,2)	DECIMAL(13,2) NOT NULL	Taxable Gross Adjustment
19	TAX_GRS_ADJAPL	Signed Number(15,2)	DECIMAL(13,2) NOT NULL	Applied Tax Gross Adjustment