PI_TAX_DETAIL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PI_RUN_NUM	Number(4,0)	SMALLINT NOT NULL	Payroll Interface Run Number
2	PI_SYSTEM_ID	Character(4)	VARCHAR2(4) NOT NULL	Payroll Interface System ID
3	PI_CONFIG_ID	Character(6)	VARCHAR2(6) NOT NULL	PI Configuration ID
4	PI_PAY_GROUP1	Character(6)	VARCHAR2(6) NOT NULL	PI Paygroup 1
5	PI_PAY_GROUP2	Character(6)	VARCHAR2(6) NOT NULL	PI Paygroup 2
6	PI_EMPLID	Character(20)	VARCHAR2(20) NOT NULL	Payroll Interface EMPLID
7	PAY_END_DT	Date(10)	DATE	Pay Period End Date
8	PI_CHECK_NBR	Character(10)	VARCHAR2(10) NOT NULL	Payroll Check Number
9	PI_TAX_TYPE	Character(6)	VARCHAR2(6) NOT NULL	Payroll Tax Type
10	PI_TAX_CD	Character(6)	VARCHAR2(6) NOT NULL	Payroll Tax Code
11	SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence
12	PI_TAX_DISTR	Character(10)	VARCHAR2(10) NOT NULL	Payroll Tax Distribution
13	PI_COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Payroll Country
14	PI_STATE	Character(6)	VARCHAR2(6) NOT NULL	Payroll State Code
15	PI_LOCALITY	Character(10)	VARCHAR2(10) NOT NULL	Payroll Locality Code
16	PI_TAX_CUR	Signed Number(20,3)	DECIMAL(18,3) NOT NULL	Current Tax
17	PI_TXGRS_CUR	Signed Number(20,3)	DECIMAL(18,3) NOT NULL	Current Taxable Gross
18	PI_TAX_YTD	Signed Number(20,3)	DECIMAL(18,3) NOT NULL	Tax YTD
19	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code