PY_TD1_MAIN

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence
2	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
3	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
4	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
5	COMPANY_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Company Descr
6	TD1_FORM_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Form Type C=Commision F=Federal I=Indiana L=Local S=Province
7	TD1_JURISDICTION	Character(20)	VARCHAR2(20) NOT NULL	TD1 Jurisdiction
8	TD1_STATE_DESCR	Character(100)	VARCHAR2(100) NOT NULL	State Description
9	PY_DESCR40	Character(40)	VARCHAR2(40) NOT NULL	Company
10	STATE	Character(6)	VARCHAR2(6) NOT NULL	State
11	TD1_TAX_STATUS	Character(15)	VARCHAR2(15) NOT NULL	Tax Status
12	RESIDENT	Character(1)	VARCHAR2(1) NOT NULL	Resident
13	TD1_ADDL_AMT	Signed Number(9,2)	DECIMAL(7,2) NOT NULL	Additional Amount
14	TD1_ADDL_PCT	Number(6,3)	DECIMAL(5,3) NOT NULL	Additional Percentage
15	TD1_OTHER	Character(1)	VARCHAR2(1) NOT NULL	Other Amount M=Multiple Jobs
16	TD1_APPR_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Approver Status for TD1 A=Approved D=Denied P=Pending Approval
17	SESSION_ID_TD1	Character(36)	VARCHAR2(36) NOT NULL	Session Id
18	ORDERNO	Number(5,0)	INTEGER NOT NULL	Sort Order
19	TD1_MULTI_JOBS	Character(1)	VARCHAR2(1) NOT NULL	Multiple Jobs Indicator
20	STATUS_INDIAN	Character(1)	VARCHAR2(1) NOT NULL	Status Indian Y/N Table Edit
21	CIT_PRESCR_AREA	Number(10,2)	DECIMAL(9,2) NOT NULL	CIT Prescibed Area Deduction
22	PCT_EXEMPT	Number(3,0)	SMALLINT NOT NULL	Field to define the percentage of taxable gross that is exempt from income tax.
23	CIT_ADDL_AMT	Number(8,2)	DECIMAL(7,2) NOT NULL	CIT Additional Amount
24	CIT_ADDL_PCT	Number(6,3)	DECIMAL(5,3) NOT NULL	CIT Additional Percentage
25	CIT_NET_CLAIM_AMT	Number(10,2)	DECIMAL(9,2) NOT NULL	CIT Net Claim Amount
26	TD1_ADJUST	Number(10,2)	DECIMAL(9,2) NOT NULL	TD1 Adjustment
27	CIT_ANNUAL_COMM	Number(10,2)	DECIMAL(9,2) NOT NULL	TD1X Estimated Commissions
28	CIT_ANNUAL_EXP	Number(10,2)	DECIMAL(9,2) NOT NULL	TD1X Estimated Expenses
29	SPECIAL_CIT_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Special CIT Status E=Exempt (not subject to CIT) G=Maintain gross N=None
30	CIT_TAX_CREDITS	Number(10,2)	DECIMAL(9,2) NOT NULL	CIT Other Federal Tax Credits
31	CIT_SPECIAL_LTRS	Number(10,2)	DECIMAL(9,2) NOT NULL	Special Letters
32	CIT_FACTOR_Y	Number(10,2)	DECIMAL(9,2) NOT NULL	CIT Y Factor
33	CIT_FACTOR_TH	Number(10,2)	DECIMAL(9,2) NOT NULL	CIT TH Factor
34	LCF_AMT	Number(8,2)	DECIMAL(7,2) NOT NULL	Labour Sponsored Shares Amount
35	CIT_F_FACTOR_EE	Number(10,2)	DECIMAL(9,2) NOT NULL	RPP/RRSP Limit
36	PIT_K3P_AMOUNT	Number(10,2)	DECIMAL(9,2) NOT NULL	Other Provincial Credits (K3P)
37	NON_INDEX_AMT	Number(10,2)	DECIMAL(9,2) NOT NULL	Non-Indexed Amount
38	QIT_OTHER_DEDUCTS	Number(10,2)	DECIMAL(9,2) NOT NULL	QIT Other Deductions
39	QPIP_EXEMPT	Character(1)	VARCHAR2(1) NOT NULL	Exempt from QPIP Premiums N=QPIP Payable Y=Exempt From QPIP Premiums
40	SUBJECT_CPP	Character(1)	VARCHAR2(1) NOT NULL	Subject to CPP indicator.
41	QC_HLTH_EXMPT	Character(1)	VARCHAR2(1) NOT NULL	Field used to identify whether or not an employee is exempt from the calculation of Quebec Health Tax during a Canadian Payroll Calculation
42	SPECIAL_QIT_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Special QIT Status E=Exempt (not subject to QIT) G=Maintain gross N=None