| id |
integer |
Yes |
Yes |
nextval('employee_roes_id_seq'::regclass) |
Unique identifier |
| employee_id |
integer |
Yes |
No |
|
Employee identifier - links to employees.id |
| serial_no |
character varying(9) |
No |
No |
|
Record of Employement serial number from CRA. |
| reference_no |
character varying(26) |
No |
No |
|
Employee reference number |
| pay_period_type |
character varying(1) |
No |
No |
|
Pay period type as per CRA specs; B = bi-weekly E = semi-monthly non standard H = thirteen pay periods per year M = monthly O = monthly non-standard S = semi-monthly W = weekly |
| first_name |
character varying(20) |
No |
No |
|
Employee first name |
| initials |
character varying(4) |
No |
No |
|
Employee initials |
| last_name |
character varying(28) |
No |
No |
|
Employee last name |
| line1 |
character varying(35) |
No |
No |
|
Employee address line 1 |
| city |
character varying(35) |
No |
No |
|
Emplayee address city |
| province_country |
character varying(35) |
No |
No |
|
Employee address, province and country |
| postal_code |
character varying(10) |
No |
No |
|
Employee address postal code |
| first_day |
date |
No |
No |
|
Employee first day worked |
| last_day |
date |
No |
No |
|
Employee last day paid |
| final_pay_period |
date |
No |
No |
|
Final pay period end date |
| occupation |
character varying(40) |
No |
No |
|
Employee occupation |
| expected_recall |
character varying(1) |
No |
No |
|
Expect recall code; N = Not returning R = Returning U = Unknown |
| expected_recall_date |
date |
No |
No |
|
Expected recall date |
| insurable_hours |
integer |
No |
No |
|
Insurable hours |
| separation_code |
character varying(3) |
No |
No |
|
Separation code as per CRA spec |
| contact_first_name |
character varying(20) |
No |
No |
|
Employer contact first name |
| contact_last_name |
character varying(28) |
No |
No |
|
Employer contact last name |
| contact_area_code |
character varying(3) |
No |
No |
|
Employer contact phone area code |
| contact_phone |
character varying(7) |
No |
No |
|
Employer contact phone number |
| contact_extension |
character varying(8) |
No |
No |
|
Employer contact phone extension |
| language |
character varying(1) |
No |
No |
|
Preferred language; E = English F = French |
| vacation_pay_code |
character varying(1) |
No |
No |
|
Vacation pay code as per CRA spec; 1 = included with each pay 2 = paid because no longer working 3 = paid for vacation leave period 4 = anniversary |
| vacation_start_date |
date |
No |
No |
|
Vacation start date |
| vacation_end_date |
date |
No |
No |
|
Vacation end date |
| vacation_amount |
numeric(8,2) |
No |
No |
|
Vacation pay amount |
| comments |
character varying(160) |
No |
No |
|
Report comments |
| remitted |
date |
No |
No |
|
Report remitted date |
| _modified_by |
character varying(3) |
No |
No |
|
User initials that modified this record |
| _created_by |
character varying(3) |
No |
No |
|
User initials that created this record |
| _modified |
timestamp without time zone |
No |
No |
|
UTC Date and time record was last modified |
| _dbversion |
integer |
No |
No |
|
Program version that last modified this record |
| _created |
timestamp without time zone |
No |
No |
|
UTC Date and time record was created |