# View: Record of Employment Header

RotoID: CT0054
Table: CTROEH
DLL: CTROEH

## Compositions: 1

RotoID | Table | Title | DLL
--- | --- | --- | ---
CT0055 | CTROED | Record of Employment Detail | CTROED

## Keys: 1

Title | Fields
--- | ---
Employee | EMPLOYEE

## Fields: 68

Field | Index | Type | Title | Attributes | Presentation
--- | --- | --- | --- | --- | ---
EMPLOYEE | 1 | String*12 | Employee ID | E A K R | Mask: %-12N
AMENDEDNBR | 2 | String*20 | Amended or Replaced Serial No. | E A |
RREFERNBR | 3 | String*20 | 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 | CCRA 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 | Employee Name | E A |
EADDRESS1 | 16 | String*60 | Employee Address 1 | E A |
EADDRESS2 | 17 | String*60 | Employee Address 2 | E A |
EADDRESS3 | 18 | String*60 | Employee Address 3 | E A |
EADDRESS4 | 19 | String*60 | Employee Address 4 | E A |
ECITY | 20 | String*30 | Employee Address City | E A |
EPROVINCE | 21 | String*30 | Employee Address Province | E A |
COUNTRY | 22 | String*30 | Employee Country | E A |
EPOSTALC | 23 | String*20 | Employee Postal Code | E A | Mask: %-3N %-3N
POSITION | 24 | String*25 | 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 Worked | E A |
UIPAYTO | 28 | Date | EI Premiums Payable up to | E A |
PPENDDATE | 29 | Date | Final Pay 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 Pay | E A |
HOLDATE2 | 36 | Date | Holiday 2 Date | E A |
HOLPAY2 | 37 | BCD*10.3 | Holiday 2 Pay | E A |
HOLDATE3 | 38 | Date | Holiday 3 Date | E A |
HOLPAY3 | 39 | BCD*10.3 | Holiday 3 Pay | E A |
OMONEY1D | 40 | String*15 | Other Money 1 Description | E A |
OMONEY1 | 41 | BCD*10.3 | Other Money 1 | E A |
OMONEY2D | 42 | String*15 | Other Money 2 Description | E A |
OMONEY2 | 43 | BCD*10.3 | Other Money 2 | E A |
OMONEY3D | 44 | String*15 | Other Money 3 Description | E A |
OMONEY3 | 45 | BCD*10.3 | Other Money 3 | E A |
ALLOCATED | 46 | Integer | Allocated Details | E A |
SICKSTART | 47 | Date | Payment Start Date for Sick | E A |
SICKLENGTH | 48 | Integer | Sick Leave Length | E A |
BEWEEKS | 49 | Boolean | Sick Leave Weeks/Days | E A |
SICKAMT | 50 | BCD*10.3 | Amount of Sick Benifits | E A |
ROEREASONS | 51 | Integer | Reasons for Issuing | E A | List: 14 entries
1 | = | A - Shortage of work
2 | = | B - Strike or lock-out
3 | = | C - Return to school
4 | = | D - Illness or injury
5 | = | E - Quit
6 | = | F - Maternity
7 | = | G - Retirement
8 | = | H - Work Sharing
9 | = | J - Apprentice training
10 | = | M - Dismissal
11 | = | N - Leave of absence
13 | = | P - Parental
14 | = | Z - Compassionate Care
12 | = | K - Other
ROEREASON | 52 | String*1 | Reason for Issuing This ROE | E A | Mask: %1A
CONTACT | 53 | String*60 | For further Info. Contact | E A |
TELEPHONE | 54 | String*30 | Phone No. to Contact | E A | Mask: (%-3C) %-3C-%-4C %-20C
RECALLDATE | 55 | Date | Expected Date of Recall | E A |
NOTRETURN | 56 | Boolean | Not Returning | E A |
UNKNOWN | 57 | Boolean | Unknown Date | E A |
COMMENTS | 58 | String*200 | 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 |
NEXTESEQ | 100 | Long | Next Unique Entry Sequence | E A C |
PROCESSCMD | 101 | Integer | Process Command Code | E A C | List: 2 entries
0 | = | No Action
1 | = | Calculate Insurable Earnings

This page was generated on 2006-Sep-07

Copyright © 2001–2005 Sage Accpac International, Inc.