| id |
integer |
Yes |
Yes |
nextval('employee_t4s_id_seq'::regclass) |
Unique identifier |
| employee_id |
integer |
Yes |
No |
|
Employee identifier - links to employees.id |
| year |
integer |
Yes |
No |
|
Year of the T4 |
| province |
character varying(2) |
No |
No |
|
Province |
| cpp_exempt |
boolean |
Yes |
No |
false |
CPP Exempttion flag; FALSE = No TRUE = Yes |
| ei_exempt |
boolean |
Yes |
No |
false |
Employment Insurance exemption flag; FALSE = No TRUE = Yes |
| ppip_exempt |
boolean |
Yes |
No |
false |
Provincial Parental Insurance Plan exemption flag; FALSE = No TRUE = Yes |
| employment_code |
integer |
No |
No |
|
Employement code as per CRA |
| employment_income |
numeric(15,2) |
No |
No |
|
Adjusted Income |
| cpp_contributions |
numeric(15,2) |
No |
No |
|
Adjusted Canada Pension Plan contribution |
| qpp_contributions |
numeric(15,2) |
No |
No |
|
Adjusted Quebec Pension Plan contribution |
| ei_premiums |
numeric(15,2) |
No |
No |
|
Adjusted Employment Insurance premiums |
| rpp_contributions |
numeric(15,2) |
No |
No |
|
Adjusted Registered Pension Plan contribution |
| pension_adjustment |
numeric(15,2) |
No |
No |
|
Adjusted Pension adjustment |
| ppip_premiums |
numeric(15,2) |
No |
No |
|
Adjusted Provincial Parental Insurance Plan premiums |
| tax_deducted |
numeric(15,2) |
No |
No |
|
Adjusted Income Tax deducted |
| insurable_earnings |
numeric(15,2) |
No |
No |
|
Adjusted Insurable earnings |
| pensionable_earnings |
numeric(15,2) |
No |
No |
|
Adjusted Pensionable earnings |
| union_dues |
numeric(15,2) |
No |
No |
|
Adjusted Union dues |
| charitable_donations |
numeric(15,2) |
No |
No |
|
Adjusted charitable donations |
| rpp_registration |
character varying(30) |
No |
No |
|
Registered Pension Plan registration number |
| ppip_insurable_earnings |
numeric(15,2) |
No |
No |
|
Adjusted Provincial Parental Insurance Plan insurable earnings |
| other_boxes |
character varying[] |
No |
No |
'{NULL,NULL,NULL,NULL,NULL,NULL}'::character varying[] |
Other field descriptions 1 - 6 when set on the T4 |
| other_amounts |
numeric(15,2)[] |
No |
No |
'{0,0,0,0,0,0}'::numeric[] |
Other Adjusted field 1 - 6 amouts when selected on the T4 |
| remitted |
date |
No |
No |
|
Remitted date |
| _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 |
| _created_by |
character varying(3) |
No |
No |
|
User initials that created this record |
| _modified |
timestamp without time zone |
No |
No |
|
UTC Date and time this record was last modified |
| _modified_by |
character varying(3) |
No |
No |
|
User initials that last modified this record |
| last_name |
character varying(30) |
No |
No |
|
Employee's last name as printed on T4 |
| first_name |
character varying(30) |
No |
No |
|
Employee's first name as printied on T4 |
| initials |
character varying(5) |
No |
No |
|
Employee's initials as printed on T4 |
| suggested_cpp_exempt |
boolean |
No |
No |
|
Canada Pension Plan exempt flag as copied from employee table |
| suggested_ei_exempt |
boolean |
No |
No |
|
Employement Insurance exempt flag as copied from employee table |
| suggested_ppip_exempt |
boolean |
No |
No |
|
Provincial Parental Insrance Plan exempt flag as copied from employee table |
| suggested_employment_income |
numeric(15,2) |
No |
No |
|
Calculated Income from timecards |
| suggested_cpp_contributions |
numeric(15,2) |
No |
No |
|
Calculated Canada Pension Plan contributions |
| suggested_qpp_contributions |
numeric(15,2) |
No |
No |
|
Calculated Quebec Pension Plan contributions |
| suggested_ei_premiums |
numeric(15,2) |
No |
No |
|
Calculated Employment Insurance premiums |
| suggested_rpp_contributions |
numeric(15,2) |
No |
No |
|
Calculated Registered Pension Plan contributions |
| suggested_pension_adjustment |
numeric(15,2) |
No |
No |
|
Calculated pension adjustment |
| suggested_ppip_premiums |
numeric(15,2) |
No |
No |
|
Calculated Provincial Parential Insurance Plan premiums |
| suggested_tax_deducted |
numeric(15,2) |
No |
No |
|
Calculated Income tax deducted |
| suggested_insurable_earnings |
numeric(15,2) |
No |
No |
|
Calculated insurable earnings |
| suggested_pensionable_earnings |
numeric(15,2) |
No |
No |
|
Calculated pensionable earnings |
| suggested_union_dues |
numeric(15,2) |
No |
No |
|
Calculated union dues |
| suggested_charitable_donations |
numeric(15,2) |
No |
No |
|
Calculated charitabe donations, not currently used |
| suggested_ppip_insurable_earnings |
numeric(15,2) |
No |
No |
|
Calculated Provincial Parental Insurance Plan insurable earnings |
| suggested_other_amounts |
numeric(15,2)[] |
No |
No |
'{0,0,0,0,0,0}'::numeric[] |
Not used |
| status |
character varying(1) |
No |
No |
|
Staus of T4; A = Amended C = Cancelled O = Original |