View: Record of Employment Header

RotoID: CT0054
Table: CTROEH
Protocol: Header
DLL:CTROEH

Compositions: 1

RotoID Tables Title DLL
CT0055 CTROED Record of Employment Detail CTROED

Keys: 1

Title Fields
Employee EMPLOYEE

Fields: 128

Field Index Type Title Attributes Presentation
EMPLOYEE 1 String*12 Employee ID E A K R  Mask: %-12N
AMENDEDNBR 2 String*9 Amended or Replaced Serial No. E A 
RREFERNBR 3 String*26 Employer Payroll Reference No. E A 
COMPANYNAM 4 String*60 Company Name E A 
CADDRESS1 5 String*60 Company Address 1 E A 
CADDRESS2 6 String*60 Company Address 2 E A 
CADDRESS3 7 String*60 Company Address 3 E A 
CADDRESS4 8 String*60 Company Address 4 E A 
CCITY 9 String*30 Company Address City E A 
CPROVINCE 10 String*30 Company Address Province E A 
CPOSTALC 11 String*20 Company Postal Code E A  Mask: %-20c
RCTID 12 String*20 CRA Business No. (BN) E A  Mask: %-15N
LANGUAGE 13 Integer Communication Preferred in E A  List:2 entries
1 = English
2 = French
PAYFREQ 14 Integer Pay Period Type E A  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 15 String*60 INTERNAL USE - Employee Name E A 
EADDRESS1 16 String*60 INTERNAL USE - Employee Address 1 E A 
EADDRESS2 17 String*60 INTERNAL USE - Employee Address 2 E A 
EADDRESS3 18 String*60 INTERNAL USE - Employee Address 3 E A 
EADDRESS4 19 String*60 INTERNAL USE - Employee Address 4 E A 
ECITY 20 String*30 INTERNAL USE - Employee Address City E A 
EPROVINCE 21 String*30 INTERNAL USE - Employee Address Province E A 
COUNTRY 22 String*30 Employee Country E A 
EPOSTALC 23 String*10 Employee Postal Code E A  Mask: %-10c
POSITION 24 String*40 Employee Occupation E A 
SIN 25 String*11 Social Insurance Number E A  Mask: %-3d-%-3d-%-3d
FIRSTDAY 26 Date First Day Worked E A 
LASTDAY 27 Date Last Day for Which Paid E A 
UIPAYTO 28 Date EI Premiums Payable up to E A 
PPENDDATE 29 Date Final Period Ending Date E A 
ALLMAX 30 Boolean Maximum for Each Pay Period E A 
UITOTEARN 31 BCD*10.3 Total Insurable Earnings E A 
INSWEEKS 32 Integer Insurable Weeks E A 
VACPAY 33 BCD*10.3 Vacation Pay E A 
HOLDATE1 34 Date Holiday 1 Date E A 
HOLPAY1 35 BCD*10.3 Holiday 1 Amount E A 
HOLDATE2 36 Date Holiday 2 Date E A 
HOLPAY2 37 BCD*10.3 Holiday 2 Amount E A 
HOLDATE3 38 Date Holiday 3 Date E A 
HOLPAY3 39 BCD*10.3 Holiday 3 Amount E A 
OMONEY1D 40 String*15 INTERNAL USE - Other Monies 1 Description E A 
OMONEY1 41 BCD*10.3 Other Monies 1 Amount E A 
OMONEY2D 42 String*15 INTERNAL USE - Other Monies 2 Description E A 
OMONEY2 43 BCD*10.3 Other Monies 2 Amount E A 
OMONEY3D 44 String*15 INTERNAL USE - Other Monies 3 Description E A 
OMONEY3 45 BCD*10.3 Other Monies 3 Amount E A 
ALLOCATED 46 Integer Allocated Details E A 
SICKSTART 47 Date Special Payment 1 Start Date E A 
SICKLENGTH 48 Integer INTERNAL USE - Sick Leave Length E A 
BEWEEKS 49 Integer Special Payment 1 Period E A 
SICKAMT 50 BCD*10.3 Special Payment 1 Amount E A 
ROEREASONS 51 Integer Reasons for Issuing E A  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 52 String*3 Reason for Issuing This ROE E A  Mask: %3N
CONTACT 53 String*60 INTERNAL USE - For further Info. Contact E A 
TELEPHONE 54 String*30 Contact Telephone No. E A  Mask: %-3C-%-4C
RECALLDATE 55 Date Expected Date of Recall E A 
NOTRETURN 56 Boolean INTERNAL USE - Not Returning E A 
UNKNOWN 57 Boolean INTERNAL USE - Unknown Date E A 
COMMENTS 58 String*160 Comments E A 
ISSUERNAME 59 String*60 Issuer Name E A 
ISSUEPHONE 60 String*30 Issuer's Phone No. E A  Mask: (%-3C) %-3C-%-4C %-20C
ISSUEDATE 61 Date Date of Issue E A 
WHICHCNTRY 62 Integer Which Country E A 
UITOTHRS 63 BCD*4.3 EI Total Hrs E A 
UI96EARN 64 BCD*10.3 Insurable Earnings for 1996 E A 
BUSEUIDTL 65 Boolean Print Insurable Earnings Detail? E A X 
ROE53WEEKS 66 Boolean 53 weeks ROE? E A 
USERID 67 String*8 User ID E A 
SICKEND 68 Date Special Payment 1 End Date E A 
VACPAYCODE 69 Integer Vacation Pay type E A  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 70 Date Vacation Pay Start Date E A X 
VACEND 71 Date Vacation Pay End Date E A 
OMONEY1C 72 Integer Other Monies 1 Code E A  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 73 Integer Other Monies 2 Code E A  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 74 Integer Other Monies 3 Code E A  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 75 Date Other Monies 1 Start Date E A 
OMONEY1EN 76 Date Other Monies 1 End Date E A 
OMONEY2ST 77 Date Other Monies 2 Start Date E A 
OMONEY2EN 78 Date Other Monies 2 End Date E A 
OMONEY3ST 79 Date Other Monies 3 Start Date E A 
OMONEY3EN 80 Date Other Monies 3 End Date E A 
HOLDATE4 81 Date Holiday 4 Date E A 
HOLPAY4 82 BCD*10.3 Holiday 4 Amount E A 
HOLDATE5 83 Date Holiday 5 Date E A 
HOLPAY5 84 BCD*10.3 Holiday 5 Amount E A 
HOLDATE6 85 Date Holiday 6 Date E A 
HOLPAY6 86 BCD*10.3 Holiday 6 Amount E A 
HOLDATE7 87 Date Holiday 7 Date E A 
HOLPAY7 88 BCD*10.3 Holiday 7 Amount E A 
HOLDATE8 89 Date Holiday 8 Date E A 
HOLPAY8 90 BCD*10.3 Holiday 8 Amount E A 
HOLDATE9 91 Date Holiday 9 Date E A 
HOLPAY9 92 BCD*10.3 Holiday 9 Amount E A 
HOLDATE10 93 Date Holiday 10 Date E A 
HOLPAY10 94 BCD*10.3 Holiday 10 Amount E A 
SICKTYPE 95 Integer Special Payment 1 type E A  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 96 Integer Special Payment 2 type E A  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 97 Integer Special Payment 3 type E A  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 98 Integer Special Payment 4 type E A  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 99 Date Special Payment 2 Start Date E A 
SICKEND2 100 Date Special Payment 2 End Date E A 
SICKLEN2 101 Integer INTERNAL USE - Sick Leave 2 Length E A 
BEWEEKS2 102 Integer Special Payment 2 Period E A 
SICKAMT2 103 BCD*10.3 Special Payment 2 Amount E A 
SICKSTART3 104 Date Special Payment 3 Start Date E A 
SICKEND3 105 Date Special Payment 3 End Date E A 
SICKLEN3 106 Integer INTERNAL USE - Sick Leave 3 Length E A 
BEWEEKS3 107 Integer Special Payment 3 Period E A 
SICKAMT3 108 BCD*10.3 Special Payment 3 Amount E A 
SICKSTART4 109 Date Special Payment 4 Start Date E A 
SICKEND4 110 Date Special Payment 4 End Date E A 
SICKLEN4 111 Integer INTERNAL USE - Sick Leave 4 Length E A 
BEWEEKS4 112 Integer Special Payment 4 Period E A 
SICKAMT4 113 BCD*10.3 Special Payment 4 Amount E A 
PRINTLANG 114 Integer Print Language E A  List:2 entries
1 = English
2 = French
RECALLOPTS 115 Integer Recall Options E A  List:3 entries
0 = U - Unknown
1 = N - Not Returning
2 = Y - Expected date of recall (specify the date below)
AREACODE 116 String*3 Area Code E A 
EXTENSION 117 String*8 Extension E A 
EMPFNAME 118 String*20 Employee First Name E A  Mask: %-20c
EMPLNAME 119 String*28 Employee Last Name E A  Mask: %-28c
EMPINITIAL 120 String*4 Employee's name, including an initial E A  Mask: %-4c
EMPADDR1 121 String*35 Employee Address 1 E A 
EMPADDR2 122 String*35 Employee Address 2 E A 
EMPADDR3 123 String*35 Employee Address 3 E A 
CNTCTFNAME 124 String*20 Contact person's First Name E A 
CNTCTLNAME 125 String*28 Contact person's Last Name E A 
NEXTESEQ 140 Long Next Unique Entry Sequence E A C 
PROCESSCMD 141 Integer Process Command Code E A C  List:2 entries
0 = No Action
1 = Calculate Insurable Earnings
PP1INSEARN 142 BCD*10.3 INTERNAL USE E A 

This page was generated on 2021-Nov-24

© 2021 Sage Software, Inc. All rights reserved. Reproduction of part or all of the contents in any form is prohibited unless for personal use. None of the content of this article may be copied or otherwise incorporated into any other document, publication or other work in any form (whether written, electronic or other format).

Sage Software, Inc. makes no warranties, representations or undertakings about any of the content of articles (including, without limitation, any as to the quality, accuracy, completeness or fitness for any particular purpose of such content).