PAY_TAX

#	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	SEPCHK	Number(1,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(1)	VARCHAR2(1) 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	RESIDENT	Character(1)	VARCHAR2(1) NOT NULL	Resident Y/N Table Edit
14	NLGRS_CUR	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	Current No Limit Gross
15	TXGRS_CUR	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	Current Taxable Gross
16	TAX_CUR	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	Current Tax
17	TXGRS_AGG	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	Tax Gross Aggregate
18	TAX_AGG	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	Tax Aggregate
19	TAX_SUPP_CUR	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	Current Supp Tax
20	TAX_NOT_TAKEN	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	Tax Not Taken
21	TIPS_CUR	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	Current Tips subject to tax
22	TIPS_DELAYED	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	Current Tips Delayed for W/H
23	AP_STATUS	Character(1)	VARCHAR2(1) NOT NULL	AP Status S=Sent to AP X=Extracted
24	GVT_SCHEDULE_NO	Character(14)	VARCHAR2(14) NOT NULL	Schedule Number
25	GVT_PAY_ID_LINE_1	Character(40)	VARCHAR2(40) NOT NULL	Payment ID Line 1
26	GVT_PAY_ID_LINE_2	Character(40)	VARCHAR2(40) NOT NULL	Payment ID Line 2
27	GVT_ECS_LTD_INDIC	Character(1)	VARCHAR2(1) NOT NULL	LTD Pay Indicator
28	GVT_ECS_OFF_ACCT	Character(16)	VARCHAR2(16) NOT NULL	Account Symbol
29	GVT_RITS_DT	Date(10)	DATE	Track processing date of Occ Cycle RITS deductions
30	GVT_TSP_SEQ_YR	Number(2,0)	SMALLINT NOT NULL	TSP Voucher Number
31	GVT_TSP_SEQ_NO	Number(4,0)	SMALLINT NOT NULL	Voucher Seq No