R_TAX810ME

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
2	EMPLOYER_ID_SUT	Character(20)	VARCHAR2(20) NOT NULL	Employer ID (SUT).
3	EMPLOYER_ID_SWT	Character(20)	VARCHAR2(20) NOT NULL	Employer ID (SWT).
4	NATIONAL_ID	Character(20)	VARCHAR2(20) NOT NULL	National ID
5	STATE	Character(6)	VARCHAR2(6) NOT NULL	State
6	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
7	LAST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Last Name
8	FIRST_NAME	Character(30)	VARCHAR2(30) NOT NULL	First Name
9	MIDDLE_INITIAL	Character(1)	VARCHAR2(1) NOT NULL	The employee's middle initial
10	NLGRS_QTD	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	No Limit Gross QTD
11	TXGRS_QTD	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	Taxable Gross QTD
12	TAX_QTD	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	Tax QTD
13	TAXABLE_GROSS	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	Taxable Gross amount
14	UI_MONTH1	Character(1)	VARCHAR2(1) NOT NULL	Employment Month 1
15	UI_MONTH2	Character(1)	VARCHAR2(1) NOT NULL	Employment Month 2
16	UI_MONTH3	Character(1)	VARCHAR2(1) NOT NULL	Employment Month 3
17	SEX	Character(1)	VARCHAR2(1) NOT NULL	Gender F=Female M=Male U=Unknown X=Indeterminate/Intersex/Unspec