Table: Record of Employment Header

Table: CTROEH
View: CT0054
Record Length: 1956

Flags: A R 

Keys: 1

Title Flags Fields

Employee EMPLOYEE

Fields: 129

Field Type Title Presentation

EMPLOYEE String*12 Employee ID Mask: %-12N
AUDTDATE Date
AUDTTIME Time
AUDTUSER String*8
AUDTORG String*6
AMENDEDNBR String*9 Amended or Replaced Serial No.
RREFERNBR String*26 Employer Payroll Reference No.
COMPANYNAM String*60 Company Name
CADDRESS1 String*60 Company Address 1
CADDRESS2 String*60 Company Address 2
CADDRESS3 String*60 Company Address 3
CADDRESS4 String*60 Company Address 4
CCITY String*30 Company Address City
CPROVINCE String*30 Company Address Province
CPOSTALC String*20 Company Postal Code Mask: %-20c
RCTID String*20 CRA Business No. (BN) Mask: %-15N
LANGUAGE Integer Communication Preferred in List:2 entries
1 = English
2 = French
PAYFREQ Integer Pay Period Type List:8 entries
2 = Daily
3 = Weekly
4 = Biweekly
5 = Semimonthly
10 = 22 pay periods
9 = 13 pay periods
6 = Monthly
8 = 10 pay periods
EMPNAME String*60 INTERNAL USE - Employee Name
EADDRESS1 String*60 INTERNAL USE - Employee Address 1
EADDRESS2 String*60 INTERNAL USE - Employee Address 2
EADDRESS3 String*60 INTERNAL USE - Employee Address 3
EADDRESS4 String*60 INTERNAL USE - Employee Address 4
ECITY String*30 INTERNAL USE - Employee Address City
EPROVINCE String*30 INTERNAL USE - Employee Address Province
COUNTRY String*30 Employee Country
EPOSTALC String*10 Employee Postal Code Mask: %-10c
POSITION String*40 Employee Occupation
SIN String*11 Social Insurance Number Mask: %-3d-%-3d-%-3d
FIRSTDAY Date First Day Worked
LASTDAY Date Last Day for Which Paid
UIPAYTO Date EI Premiums Payable up to
PPENDDATE Date Final Period Ending Date
ALLMAX Boolean Maximum for Each Pay Period
UITOTEARN BCD*10.3 Total Insurable Earnings
INSWEEKS Integer Insurable Weeks
VACPAY BCD*10.3 Vacation Pay
HOLDATE1 Date Holiday 1 Date
HOLPAY1 BCD*10.3 Holiday 1 Amount
HOLDATE2 Date Holiday 2 Date
HOLPAY2 BCD*10.3 Holiday 2 Amount
HOLDATE3 Date Holiday 3 Date
HOLPAY3 BCD*10.3 Holiday 3 Amount
OMONEY1D String*15 INTERNAL USE - Other Monies 1 Description
OMONEY1 BCD*10.3 Other Monies 1 Amount
OMONEY2D String*15 INTERNAL USE - Other Monies 2 Description
OMONEY2 BCD*10.3 Other Monies 2 Amount
OMONEY3D String*15 INTERNAL USE - Other Monies 3 Description
OMONEY3 BCD*10.3 Other Monies 3 Amount
ALLOCATED Integer Allocated Details
SICKSTART Date Special Payment 1 Start Date
SICKLENGTH Integer INTERNAL USE - Sick Leave Length
BEWEEKS Integer Special Payment 1 Period
SICKAMT BCD*10.3 Special Payment 1 Amount
ROEREASONS Integer Reasons for Issuing List:30 entries
1 = A00 - Shortage of work/End of contract or season
2 = A01 - Employer bankruptcy or receivership
3 = B00 - Strike or lock-out
4 = D00 - Illness or injury
5 = E00 - Quit
6 = E02 - Quit/Follow spouse
7 = E03 - Quit/Return to school
8 = E04 - Quit/Health reasons
9 = E05 - Quit/Voluntary retirement
10 = E06 - Quit/Take another job
11 = E09 - Quit/Employer relocation
12 = E10 - Quit/Care for a dependant
13 = E11 - Quit/To become self-employed
14 = F00 - Maternity
15 = G00 - Mandatory Retirement
16 = G07 - Retirement/Approved workforce reduction
17 = H00 - Work Sharing
18 = J00 - Apprentice training
19 = K00 - Other
20 = K12 - Other/Change of payroll frequency
21 = K13 - Other/Change of ownership
22 = K14 - Other/Requested by Employment Insurance
23 = K15 - Other/Canadian Forces - Queen's Regulations/Orders
24 = K16 - Other/At the employee's request
25 = K17 - Other/Change of Service Provider
26 = M00 - Dismissal
27 = M08 - Dismissal/Terminated within probationary period
28 = N00 - Leave of absence
29 = P00 - Parental
30 = Z00 - Compassionate Care
ROEREASON String*3 Reason for Issuing This ROE Mask: %3N
CONTACT String*60 INTERNAL USE - For further Info. Contact
TELEPHONE String*30 Contact Telephone No. Mask: %-3C-%-4C
RECALLDATE Date Expected Date of Recall
NOTRETURN Boolean INTERNAL USE - Not Returning
UNKNOWN Boolean INTERNAL USE - Unknown Date
COMMENTS String*160 Comments
ISSUERNAME String*60 Issuer Name
ISSUEPHONE String*30 Issuer's Phone No. Mask: (%-3C) %-3C-%-4C %-20C
ISSUEDATE Date Date of Issue
WHICHCNTRY Integer Which Country
UITOTHRS BCD*4.3 EI Total Hrs
UI96EARN BCD*10.3 Insurable Earnings for 1996
BUSEUIDTL Boolean Print Insurable Earnings Detail?
ROE53WEEKS Boolean 53 weeks ROE?
USERID String*8 User ID
SICKEND Date Special Payment 1 End Date
VACPAYCODE Integer Vacation Pay type List:5 entries
0 =
1 = Included with each pay
2 = Paid because no longer working
3 = Paid for a vacation leave period
4 = Anniversary (Paid on a specific date each year)
VACSTART Date Vacation Pay Start Date
VACEND Date Vacation Pay End Date
OMONEY1C Integer Other Monies 1 Code List:23 entries
0 =
1 = B05 - Bonus (Holiday)
2 = B06 - Bonus (Production/Incentive)
3 = B07 - Bonus (Event)
4 = B08 - Bonus (Staying/Contract complete/End of season)
5 = B09 - Bonus (Separation or retirement)
6 = B10 - Bonus (Closure)
7 = B11 - Bonus (Other)
8 = E00 - Severance pay
9 = G00 - Gratuities
10 = H00 - Honorariums
11 = I00 - Sick leave credits
12 = J00 - Retroactive pay adjustment
13 = O00 - Other
14 = Q00 - Profit sharing
15 = R00 - Retiring allowance / Retirement leave credits
16 = S00 - Settlement pay
17 = T00 - Payout of banked overtime
18 = U12 - SUB Maternity/Parental/Compassionate Care/Parents of Critically Ill Children
19 = U13 - SUB Layoff
20 = U14 - SUB Illness
21 = U15 - SUB Training
22 = Y00 - Pay in lieu of notice
OMONEY2C Integer Other Monies 2 Code List:23 entries
0 =
1 = B05 - Bonus (Holiday)
2 = B06 - Bonus (Production/Incentive)
3 = B07 - Bonus (Event)
4 = B08 - Bonus (Staying/Contract complete/End of season)
5 = B09 - Bonus (Separation or retirement)
6 = B10 - Bonus (Closure)
7 = B11 - Bonus (Other)
8 = E00 - Severance pay
9 = G00 - Gratuities
10 = H00 - Honorariums
11 = I00 - Sick leave credits
12 = J00 - Retroactive pay adjustment
13 = O00 - Other
14 = Q00 - Profit sharing
15 = R00 - Retiring allowance / Retirement leave credits
16 = S00 - Settlement pay
17 = T00 - Payout of banked overtime
18 = U12 - SUB Maternity/Parental/Compassionate Care/Parents of Critically Ill Children
19 = U13 - SUB Layoff
20 = U14 - SUB Illness
21 = U15 - SUB Training
22 = Y00 - Pay in lieu of notice
OMONEY3C Integer Other Monies 3 Code List:23 entries
0 =
1 = B05 - Bonus (Holiday)
2 = B06 - Bonus (Production/Incentive)
3 = B07 - Bonus (Event)
4 = B08 - Bonus (Staying/Contract complete/End of season)
5 = B09 - Bonus (Separation or retirement)
6 = B10 - Bonus (Closure)
7 = B11 - Bonus (Other)
8 = E00 - Severance pay
9 = G00 - Gratuities
10 = H00 - Honorariums
11 = I00 - Sick leave credits
12 = J00 - Retroactive pay adjustment
13 = O00 - Other
14 = Q00 - Profit sharing
15 = R00 - Retiring allowance / Retirement leave credits
16 = S00 - Settlement pay
17 = T00 - Payout of banked overtime
18 = U12 - SUB Maternity/Parental/Compassionate Care/Parents of Critically Ill Children
19 = U13 - SUB Layoff
20 = U14 - SUB Illness
21 = U15 - SUB Training
22 = Y00 - Pay in lieu of notice
OMONEY1ST Date Other Monies 1 Start Date
OMONEY1EN Date Other Monies 1 End Date
OMONEY2ST Date Other Monies 2 Start Date
OMONEY2EN Date Other Monies 2 End Date
OMONEY3ST Date Other Monies 3 Start Date
OMONEY3EN Date Other Monies 3 End Date
HOLDATE4 Date Holiday 4 Date
HOLPAY4 BCD*10.3 Holiday 4 Amount
HOLDATE5 Date Holiday 5 Date
HOLPAY5 BCD*10.3 Holiday 5 Amount
HOLDATE6 Date Holiday 6 Date
HOLPAY6 BCD*10.3 Holiday 6 Amount
HOLDATE7 Date Holiday 7 Date
HOLPAY7 BCD*10.3 Holiday 7 Amount
HOLDATE8 Date Holiday 8 Date
HOLPAY8 BCD*10.3 Holiday 8 Amount
HOLDATE9 Date Holiday 9 Date
HOLPAY9 BCD*10.3 Holiday 9 Amount
HOLDATE10 Date Holiday 10 Date
HOLPAY10 BCD*10.3 Holiday 10 Amount
SICKTYPE Integer Special Payment 1 type List:5 entries
0 =
1 = Paid Sick Leave
2 = Wage Loss Indemnity (Not EI Insurable)
3 = Wage Loss Indemnity (EI Insurable)
4 = Paid Maternity/Parental/Compassionate Care/Parents of Critically Ill Children Leave
SICKTYPE2 Integer Special Payment 2 type List:5 entries
0 =
1 = Paid Sick Leave
2 = Wage Loss Indemnity (Not EI Insurable)
3 = Wage Loss Indemnity (EI Insurable)
4 = Paid Maternity/Parental/Compassionate Care/Parents of Critically Ill Children Leave
SICKTYPE3 Integer Special Payment 3 type List:5 entries
0 =
1 = Paid Sick Leave
2 = Wage Loss Indemnity (Not EI Insurable)
3 = Wage Loss Indemnity (EI Insurable)
4 = Paid Maternity/Parental/Compassionate Care/Parents of Critically Ill Children Leave
SICKTYPE4 Integer Special Payment 4 type List:5 entries
0 =
1 = Paid Sick Leave
2 = Wage Loss Indemnity (Not EI Insurable)
3 = Wage Loss Indemnity (EI Insurable)
4 = Paid Maternity/Parental/Compassionate Care/Parents of Critically Ill Children Leave
SICKSTART2 Date Special Payment 2 Start Date
SICKEND2 Date Special Payment 2 End Date
SICKLEN2 Integer INTERNAL USE - Sick Leave 2 Length
BEWEEKS2 Integer Special Payment 2 Period
SICKAMT2 BCD*10.3 Special Payment 2 Amount
SICKSTART3 Date Special Payment 3 Start Date
SICKEND3 Date Special Payment 3 End Date
SICKLEN3 Integer INTERNAL USE - Sick Leave 3 Length
BEWEEKS3 Integer Special Payment 3 Period
SICKAMT3 BCD*10.3 Special Payment 3 Amount
SICKSTART4 Date Special Payment 4 Start Date
SICKEND4 Date Special Payment 4 End Date
SICKLEN4 Integer INTERNAL USE - Sick Leave 4 Length
BEWEEKS4 Integer Special Payment 4 Period
SICKAMT4 BCD*10.3 Special Payment 4 Amount
PRINTLANG Integer Print Language List:2 entries
1 = English
2 = French
RECALLOPTS Integer Recall Options List:3 entries
0 = U - Unknown
1 = N - Not Returning
2 = Y - Expected date of recall (specify the date below)
AREACODE String*3 Area Code
EXTENSION String*8 Extension
EMPFNAME String*20 Employee First Name Mask: %-20c
EMPLNAME String*28 Employee Last Name Mask: %-28c
EMPINITIAL String*4 Employee's name, including an initial Mask: %-4c
EMPADDR1 String*35 Employee Address 1
EMPADDR2 String*35 Employee Address 2
EMPADDR3 String*35 Employee Address 3
CNTCTFNAME String*20 Contact person's First Name
CNTCTLNAME String*28 Contact person's Last Name