EMPLIDPY_TD1_PRV_F_VW(SQL View) |
Index Back |
|---|---|
TD1 Province Tax ViewTD1 Employee provincve Tax View |
| SELECT A.EMPLID , A.COMPANY , B.PROVINCE ,C.DESCR ,B.CIT_NET_CLAIM_AMT ,B.TD1_ADJUST ,B.CIT_PRESCR_AREA ,B.CIT_TAX_CREDITS ,B.CIT_SPECIAL_LTRS ,B.CIT_FACTOR_Y ,B.CIT_FACTOR_TH ,B.LCF_AMT ,B.CIT_F_FACTOR_EE ,B.PIT_K3P_AMOUNT ,B.NON_INDEX_AMT FROM PS_CAN_TAX_DATA A ,PS_CAN_TAX_PRVDATA B ,PS_STATE_TBL C WHERE A.EMPLID = B.EMPLID AND A.COMPANY = B.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 A.EFFDT = B.EFFDT AND B.PROVINCE = C.STATE AND C.COUNTRY = 'CAN' |
| # | 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 |
| 3 | PROVINCE | Character(6) | VARCHAR2(6) NOT NULL | Province |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | CIT_NET_CLAIM_AMT | Number(10,2) | DECIMAL(9,2) NOT NULL | CIT Net Claim Amount |
| 6 | TD1_ADJUST | Number(10,2) | DECIMAL(9,2) NOT NULL | TD1 Adjustment |
| 7 | CIT_PRESCR_AREA | Number(10,2) | DECIMAL(9,2) NOT NULL | CIT Prescibed Area Deduction |
| 8 | CIT_TAX_CREDITS | Number(10,2) | DECIMAL(9,2) NOT NULL | CIT Other Federal Tax Credits |
| 9 | CIT_SPECIAL_LTRS | Number(10,2) | DECIMAL(9,2) NOT NULL | Special Letters |
| 10 | CIT_FACTOR_Y | Number(10,2) | DECIMAL(9,2) NOT NULL | CIT Y Factor |
| 11 | CIT_FACTOR_TH | Number(10,2) | DECIMAL(9,2) NOT NULL | CIT TH Factor |
| 12 | LCF_AMT | Number(8,2) | DECIMAL(7,2) NOT NULL | Labour Sponsored Shares Amount |
| 13 | CIT_F_FACTOR_EE | Number(10,2) | DECIMAL(9,2) NOT NULL | RPP/RRSP Limit |
| 14 | PIT_K3P_AMOUNT | Number(10,2) | DECIMAL(9,2) NOT NULL | Other Provincial Credits (K3P) |
| 15 | NON_INDEX_AMT | Number(10,2) | DECIMAL(9,2) NOT NULL | Non-Indexed Amount |