PY_TD1_QIT_F_VW (SQL View)	Index Back
TD1 Quebec Tax View TD1 Quebec Employee Tax view

PY_TD1_QIT_F_VW

(SQL View)

TD1 Quebec Tax View

TD1 Quebec Employee Tax view

SELECT DISTINCT A.EMPLID , A.COMPANY , A.SPECIAL_QIT_STATUS ,A.QIT_NET_CLAIM_AMT ,A.NON_INDEX_AMT ,A.QIT_PRESCR_AREA ,A.QIT_TAX_CREDITS ,A.QIT_SPECIAL_LTRS ,A.QIT_OTHER_DEDUCTS , A.QPIP_EXEMPT , A.SUBJECT_CPP , A.QC_HLTH_EXMPT ,A.QIT_ADDL_AMT ,A.QIT_ADDL_PCT ,A.QIT_ANNUAL_COMM ,A.QIT_ANNUAL_EXP FROM PS_CAN_TAX_DATA A , PS_JOB B , PS_COMPANY_TBL C WHERE A.EMPLID = B.EMPLID AND B.COMPANY = C.COMPANY AND A.EFFDT = ( SELECT MIN(A1.EFFDT) FROM PS_CAN_TAX_DATA A1 WHERE A1.EMPLID = A.EMPLID AND A1.COMPANY = A.COMPANY AND A1.EFFDT > %CurrentDateIn) AND C.EFFDT = ( SELECT MAX(C1.EFFDT) FROM PS_COMPANY_TBL C1 WHERE C1.COMPANY = C.COMPANY AND C1.EFFDT <= %CurrentDateIn)

Parent record: PAY_LINE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

2 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
Prompt Table: COMPANY_TBL

3 SPECIAL_QIT_STATUS Character(1) VARCHAR2(1) NOT NULL Special QIT Status
E=Exempt (not subject to QIT)
G=Maintain gross
N=None

4 QIT_NET_CLAIM_AMT Number(10,2) DECIMAL(9,2) NOT NULL QIT Net Claim Amount

5 NON_INDEX_AMT Number(10,2) DECIMAL(9,2) NOT NULL Non-Indexed Amount

6 QIT_PRESCR_AREA Number(10,2) DECIMAL(9,2) NOT NULL QIT Prescribed Area

7 QIT_TAX_CREDITS Number(10,2) DECIMAL(9,2) NOT NULL QIT Other Tax Credits

8 QIT_SPECIAL_LTRS Number(10,2) DECIMAL(9,2) NOT NULL QIT Special Letters

9 QIT_OTHER_DEDUCTS Number(10,2) DECIMAL(9,2) NOT NULL QIT Other Deductions

10 QPIP_EXEMPT Character(1) VARCHAR2(1) NOT NULL Exempt from QPIP Premiums
N=QPIP Payable
Y=Exempt From QPIP Premiums

11 SUBJECT_CPP Character(1) VARCHAR2(1) NOT NULL Subject to CPP indicator.

12 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

13 QIT_ADDL_AMT Number(8,2) DECIMAL(7,2) NOT NULL QIT Additional Amount

14 QIT_ADDL_PCT Number(6,3) DECIMAL(5,3) NOT NULL QIT Additional Percentage

15 QIT_ANNUAL_COMM Number(10,2) DECIMAL(9,2) NOT NULL MR19-CV Estimated Commissions

16 QIT_ANNUAL_EXP Number(10,2) DECIMAL(9,2) NOT NULL MR19-CV Estimated Expenses

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company Prompt Table: COMPANY_TBL
3	SPECIAL_QIT_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Special QIT Status E=Exempt (not subject to QIT) G=Maintain gross N=None
4	QIT_NET_CLAIM_AMT	Number(10,2)	DECIMAL(9,2) NOT NULL	QIT Net Claim Amount
5	NON_INDEX_AMT	Number(10,2)	DECIMAL(9,2) NOT NULL	Non-Indexed Amount
6	QIT_PRESCR_AREA	Number(10,2)	DECIMAL(9,2) NOT NULL	QIT Prescribed Area
7	QIT_TAX_CREDITS	Number(10,2)	DECIMAL(9,2) NOT NULL	QIT Other Tax Credits
8	QIT_SPECIAL_LTRS	Number(10,2)	DECIMAL(9,2) NOT NULL	QIT Special Letters
9	QIT_OTHER_DEDUCTS	Number(10,2)	DECIMAL(9,2) NOT NULL	QIT Other Deductions
10	QPIP_EXEMPT	Character(1)	VARCHAR2(1) NOT NULL	Exempt from QPIP Premiums N=QPIP Payable Y=Exempt From QPIP Premiums
11	SUBJECT_CPP	Character(1)	VARCHAR2(1) NOT NULL	Subject to CPP indicator.
12	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
13	QIT_ADDL_AMT	Number(8,2)	DECIMAL(7,2) NOT NULL	QIT Additional Amount
14	QIT_ADDL_PCT	Number(6,3)	DECIMAL(5,3) NOT NULL	QIT Additional Percentage
15	QIT_ANNUAL_COMM	Number(10,2)	DECIMAL(9,2) NOT NULL	MR19-CV Estimated Commissions
16	QIT_ANNUAL_EXP	Number(10,2)	DECIMAL(9,2) NOT NULL	MR19-CV Estimated Expenses