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 |