MODEL_PAY_TAX

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PY_MOD_OPRID	Character(30)	VARCHAR2(30) NOT NULL	PayCheck Modeler User Id
2	PY_MOD_EMPLID	Character(11)	VARCHAR2(11) NOT NULL	PayCheck Modeler Employee ID
3	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company Prompt Table: COMPANY_TBL
4	PAYGROUP	Character(3)	VARCHAR2(3) NOT NULL	Pay Group Prompt Table: PAYGROUP_TBL
5	PAY_END_DT	Date(10)	DATE NOT NULL	Pay Period End Date Prompt Table: PAY_CALENDAR
6	OFF_CYCLE	Character(1)	VARCHAR2(1) NOT NULL	Off Cycle ? Y/N Table Edit Default Value: Y
7	PAGE_NUM	Number(5,0)	INTEGER NOT NULL	Page Nbr
8	LINE_NUM	Number(3,0)	SMALLINT NOT NULL	Line Nbr
9	SEPCHK	Number(2,0)	SMALLINT NOT NULL	Separate check number.
10	STATE	Character(6)	VARCHAR2(6) NOT NULL	State
11	LOCALITY	Character(10)	VARCHAR2(10) NOT NULL	Locality
12	TAX_CLASS	Character(3)	VARCHAR2(3) NOT NULL	Tax Balance Class Prompt Table: PY_TAX_CLASS
13	WORK_PSD_CD	Character(6)	VARCHAR2(6) NOT NULL	Locality
14	RES_PSD_CD	Character(6)	VARCHAR2(6) NOT NULL	Locality
15	RESIDENT	Character(1)	VARCHAR2(1) NOT NULL	Resident Y/N Table Edit
16	NLGRS_CUR	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	Current No Limit Gross
17	TXGRS_CUR	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	Current Taxable Gross
18	TAX_CUR	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	Current Tax
19	TXGRS_AGG	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	Tax Gross Aggregate
20	TAX_AGG	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	Tax Aggregate
21	TAX_SUPP_CUR	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	Current Supp Tax
22	TAX_NOT_TAKEN	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	Tax Not Taken
23	TIPS_CUR	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	Current Tips subject to tax
24	TIPS_DELAYED	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	Current Tips Delayed for W/H
25	AP_STATUS	Character(1)	VARCHAR2(1) NOT NULL	AP Status S=Sent to AP X=Extracted
26	GVT_SCHEDULE_NO	Character(14)	VARCHAR2(14) NOT NULL	Schedule Number
27	GVT_PAY_ID_LINE_1	Character(40)	VARCHAR2(40) NOT NULL	Payment ID Line 1
28	GVT_PAY_ID_LINE_2	Character(40)	VARCHAR2(40) NOT NULL	Payment ID Line 2
29	GVT_ECS_LTD_INDIC	Character(1)	VARCHAR2(1) NOT NULL	LTD Pay Indicator
30	GVT_ECS_OFF_ACCT	Character(16)	VARCHAR2(16) NOT NULL	Account Symbol
31	GVT_RITS_DT	Date(10)	DATE	Track processing date of Occ Cycle RITS deductions
32	GVT_TSP_SEQ_YR	Number(2,0)	SMALLINT NOT NULL	TSP Voucher Number
33	GVT_TSP_SEQ_NO	Number(4,0)	SMALLINT NOT NULL	Voucher Seq Nbr