CAN_YE_T4_VW(SQL View) |
Index Back |
---|---|
Canadian YE Empl T4 Slip ViewView of CAN_YE_SLIP table for online panel displaying T4 supplementary slip data only. |
SELECT company ,emplid ,calendar_year ,sequence_number ,taxform_id ,wage_loss_plan ,province ,can_ye_slip_seq ,reporting_id ,employment_code ,ye_slip_process FROM PS_CAN_YE_SLIP WHERE taxform_id = 'T' |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL | Company |
2 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
3 | CALENDAR_YEAR | Number(4,0) | SMALLINT NOT NULL | Calendar Year |
4 | SEQUENCE_NUMBER | Number(2,0) | SMALLINT NOT NULL | Sequence Number |
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 |
6 | WAGE_LOSS_PLAN | Character(3) | VARCHAR2(3) NOT NULL | Wage Loss Replacement Plan |
7 | PROVINCE | Character(6) | VARCHAR2(6) NOT NULL | Province |
8 | CAN_YE_SLIP_SEQ | Number(2,0) | SMALLINT NOT NULL | This is the Canadian year-end slip sequence number. For T4 and T4A, they have a slip sequence number of 0 (default value). As for RL-1 and RL-2, if a box amount exceeds maximum box amount allowed by MRQ, additional slip will have incremental slip number. |
9 | REPORTING_ID | Character(16) | VARCHAR2(16) NOT NULL | Tax Reporting ID |
10 | EMPLOYMENT_CODE | Character(2) | VARCHAR2(2) NOT NULL |
Employment Code
11=Placement Agency-Self-Employed 12=Taxi Driver/Psgr-Carry Vehicle 13=Barber or Hairdresser 14=Withdrawal-Deferred Salary Pln 15=Seasonal Agricultural Wrkr Pgm 16=Detached EE-Soc Sec Agreement 17=Fisher |
11 | YE_SLIP_PROCESS | Character(1) | VARCHAR2(1) NOT NULL |
Slip Process Type
A=Amended C=Cancelled D=Delete N=Newly Reissued O=Original |