PY_IN_ADT_ER_TB

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	PY_TAX_YEAR	Number(4,0)	SMALLINT NOT NULL	Represents the year for personal income tax purposes.
3	W2_REPORTING_CO	Character(3)	VARCHAR2(3) NOT NULL	W-2 Reporting Company
4	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
5	TAXFORM_ID	Character(1)	VARCHAR2(1) NOT NULL	Tax Form Identification A=T4A Slip B=Business Payrolls Survey - CAN C=WCB Assessable Earnings E=Record of Employment F=940 - Annual Employer's FUTA I=W-2VI J=W-2cVI M=W-2GU N=W-2cGU P=W-2PR Q=W-2cPR R=RL-1 Slip S=W-2AS T=T4 Slip U=W-2cAS V=RL-2 Slip W=W-2 X=W-2c Y=1099-R Z=1042-S
6	SEQUENCE_NUMBER	Number(2,0)	SMALLINT NOT NULL	Sequence Number
7	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
8	STATE	Character(6)	VARCHAR2(6) NOT NULL	State
9	ERROR_DESCR	Character(254)	VARCHAR2(254) NOT NULL	Error description
10	PY_W2_CMP_DESCR	Character(254)	VARCHAR2(254) NOT NULL	W-2 company description
11	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
12	PAYGROUP	Character(3)	VARCHAR2(3) NOT NULL	Pay Group
13	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
14	PY_DEPT_DESCR	Character(100)	VARCHAR2(100) NOT NULL	Department description
15	PY_PAYGROUP_DESCR	Character(100)	VARCHAR2(100) NOT NULL	Paygroup Description
16	PY_BUS_DESCR	Character(100)	VARCHAR2(100) NOT NULL	Business Unit description
17	TAXFORM_ID_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Taxform ID Description
18	LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.