| id |
integer |
Yes |
Yes |
nextval('employees_id_seq'::regclass) |
|
| employee_no |
character varying(6) |
No |
No |
|
Employee number |
| name |
character varying(60) |
No |
No |
|
Employee name |
| sin |
character varying(9) |
No |
No |
|
Social Insurance number |
| birth_date |
date |
No |
No |
|
Date of birth |
| hire_date |
date |
No |
No |
|
Date hired |
| term_date |
date |
No |
No |
|
Date terminated |
| review_date |
date |
No |
No |
|
Next review date |
| job_title |
character varying(60) |
No |
No |
|
Job title |
| health_number |
character varying(30) |
No |
No |
|
Health number |
| rsp_deduction_type |
character varying(1) |
No |
No |
'$'::character varying |
RSP deduction type. $ = Amount % = Percentage |
| union_number |
character varying(30) |
No |
No |
|
Union ID number |
| language_code |
character varying(1) |
No |
No |
'E'::character varying |
Language code E = English F = French |
| notes |
text |
No |
No |
|
|
| union_dues_type |
character varying(1) |
No |
No |
'$'::character varying |
Union dues type $ = Amount % = Percentage |
| tax_credits |
numeric(15,2) |
No |
No |
0 |
Federal Tax credit amount |
| other_tax_credits |
numeric(15,2) |
No |
No |
0 |
Other claim amount |
| prov_claim_amt |
numeric(15,2) |
No |
No |
0 |
Provincial claim amount |
| remote_allow |
numeric(15,2) |
No |
No |
0 |
Remote allowance |
| alimony |
numeric(15,2) |
No |
No |
0 |
Alimony amount |
| elected |
numeric(15,2) |
No |
No |
0 |
Elected extra tax amount |
| expense_claim |
numeric(15,2) |
No |
No |
0 |
Estimated Expense amount for commissioned employees |
| union_dues |
numeric(15,2) |
No |
No |
0 |
Union dues amount |
| rsp_deduction |
numeric(15,2) |
No |
No |
0 |
RSP deduction amount |
| td1_line_6_9 |
numeric(15,2) |
No |
No |
0 |
|
| estimated_pay |
numeric(15,2) |
No |
No |
0 |
Estimated pay amount for commissioned employees |
| tax_table |
character varying(2) |
No |
No |
'ZZ'::character varying |
The province code the employees tax will be charged on. |
| periods |
smallint |
No |
No |
24 |
The number of pay periods the employee is paid per year |
| last_pay_period |
smallint |
No |
No |
0 |
Last period number the employee was paid |
| wcb_rate |
numeric(5,3) |
No |
No |
0 |
WCB rate for this employee |
| wcb_assessable |
numeric(15,2) |
No |
No |
0 |
Amount per year that WCB is assessable |
| ei_rate |
numeric(5,3) |
No |
No |
0 |
EI rate for this employee |
| retain_vacation_pay |
boolean |
No |
No |
|
Retain employees vacation TRUE = Yes FALSE = No |
| vacation_pay_rate |
numeric(5,2) |
No |
No |
0 |
Percentage this employee gets for vacation pay |
| regular_rate |
numeric(9,2) |
No |
No |
0 |
Employees regular hourly rate |
| overtime_rate |
numeric(9,2) |
No |
No |
0 |
Employees overtime hourly rate |
| premium_rate |
numeric(9,2) |
No |
No |
0 |
Employees premium hourly rate |
| salary |
numeric(15,2) |
No |
No |
0 |
Salary per pay period |
| vacation_owed |
numeric(15,2) |
No |
No |
0 |
Vacation owed |
| bank |
character varying(3) |
No |
No |
|
Bank institution number for EFT |
| branch |
character varying(5) |
No |
No |
|
Bank account branch (transit) for EFT |
| account |
character varying(31) |
No |
No |
|
Bank account number for EFT |
| dept_code |
smallint |
No |
No |
|
Employees dept - Used to set the GL accounts posted to |
| status |
character varying(1) |
No |
No |
'A'::character varying |
Employees status A = Active T = Terminated L = On leave |
| gender |
character varying(1) |
No |
No |
|
Gender M = Male F = Female |
| ytd_salary_dlrs |
numeric(15,2) |
No |
No |
0 |
Year to date salary |
| ytd_advance_dlrs |
numeric(15,2) |
No |
No |
0 |
Year to date advance |
| ytd_comm_dlrs |
numeric(15,2) |
No |
No |
0 |
Year to date commission |
| ytd_regular_dlrs |
numeric(15,2) |
No |
No |
0 |
Year to date regular pay |
| ytd_otime_dlrs |
numeric(15,2) |
No |
No |
0 |
Year to date overtime pay |
| ytd_premium_dlrs |
numeric(15,2) |
No |
No |
0 |
Year to date premium pay |
| ytd_sick_dlrs |
numeric(15,2) |
No |
No |
0 |
Year to date sick pay |
| ytd_vac_dlrs |
numeric(15,2) |
No |
No |
0 |
Year to date vacation pay |
| ytd_other_dlrs |
numeric(15,2) |
No |
No |
0 |
Year to date other pay |
| ytd_ppip_insurable |
numeric(15,2) |
No |
No |
0 |
Year to date PIPP insurable |
| ytd_ppip |
numeric(15,2) |
No |
No |
0 |
Year to date PPIP |
| ytd_fed_tax |
numeric(15,2) |
No |
No |
0 |
Year to date federal tax |
| ytd_prv_tax |
numeric(15,2) |
No |
No |
0 |
Year to date provincial tax |
| ytd_munic_tax |
numeric(15,2) |
No |
No |
0 |
|
| ytd_uic |
numeric(15,2) |
No |
No |
0 |
Year to date EI |
| ytd_cpp |
numeric(15,2) |
No |
No |
0 |
Year to date CPP |
| ytd_union |
numeric(15,2) |
No |
No |
0 |
Year to date Union dues |
| ytd_rsp |
numeric(15,2) |
No |
No |
0 |
Year to date RSP |
| ytd_wcb |
numeric(15,2) |
No |
No |
0 |
Year to date WCB |
| ytd_qhip |
numeric(15,2) |
No |
No |
0 |
Year to date QHIP |
| ytd_insurable |
numeric(15,2) |
No |
No |
0 |
Year to date insurable |
| ytd_vac_paid |
numeric(15,2) |
No |
No |
0 |
Year to date vacation paid |
| lst_salary_dlrs |
numeric(15,2) |
No |
No |
0 |
Last year's salary paid |
| lst_advance_dlrs |
numeric(15,2) |
No |
No |
0 |
Last year's advance |
| lst_comm_dlrs |
numeric(15,2) |
No |
No |
0 |
Last year's commission |
| lst_regular_dlrs |
numeric(15,2) |
No |
No |
0 |
Last year's regular pay |
| lst_otime_dlrs |
numeric(15,2) |
No |
No |
0 |
Last year's overtime pay |
| lst_premium_dlrs |
numeric(15,2) |
No |
No |
0 |
Last year's premium pay |
| lst_sick_dlrs |
numeric(15,2) |
No |
No |
0 |
Last year's sick pay |
| lst_vac_dlrs |
numeric(15,2) |
No |
No |
0 |
Last year's vacation pay |
| lst_other_dlrs |
numeric(15,2) |
No |
No |
0 |
Last year's other pay |
| lst_ppip_insurable |
numeric(15,2) |
No |
No |
0 |
Last year's PPIP insurable |
| lst_ppip |
numeric(15,2) |
No |
No |
0 |
Last year's PPIP |
| lst_fed_tax |
numeric(15,2) |
No |
No |
0 |
Last year's federal tax |
| lst_prv_tax |
numeric(15,2) |
No |
No |
0 |
Last year's provincial tax |
| lst_munic_tax |
numeric(15,2) |
No |
No |
0 |
|
| lst_uic |
numeric(15,2) |
No |
No |
0 |
Last year's EI |
| lst_cpp |
numeric(15,2) |
No |
No |
0 |
Last year's CPP |
| lst_union |
numeric(15,2) |
No |
No |
0 |
Last year's union dues |
| lst_rsp |
numeric(15,2) |
No |
No |
0 |
Last year's RSP |
| lst_wcb |
numeric(15,2) |
No |
No |
0 |
Last year's WCB |
| lst_qhip |
numeric(15,2) |
No |
No |
0 |
Last year's QHIP |
| lst_insurable |
numeric(15,2) |
No |
No |
0 |
Last year's insurable |
| lst_vac_paid |
numeric(15,2) |
No |
No |
0 |
Last year's vacation paid |
| ppip_exempt |
boolean |
No |
No |
|
Employee is PPIP exempt TRUE = Yes FALSE or blank = No |
| cpp_exempt |
boolean |
No |
No |
|
Employee is CPP exempt TRUE = Yes FALSE or blank = No |
| image_path |
character varying(512) |
No |
No |
|
|
| advance_bal |
numeric(15,2) |
No |
No |
0 |
Current balance of employee advance |
| direct_deposit_method |
character varying(1) |
No |
No |
'E'::character varying |
|
| direct_deposit |
boolean |
No |
No |
|
Employee pays with direct deposit TRUE = Yes FALSE = No |
| _dbversion |
integer |
No |
No |
|
|
| _created |
timestamp without time zone |
No |
No |
|
|
| _created_by |
character varying(3) |
No |
No |
|
|
| _modified |
timestamp without time zone |
No |
No |
|
|
| _modified_by |
character varying(3) |
No |
No |
|
|
| benefit_type |
character varying(1)[] |
No |
No |
'{$,$,$,$,$,$,$,$,$,$}'::character varying[] |
Array field containing method to calculate benefits $ = Amount % = Percentage |
| benefit_amount |
numeric(15,2)[] |
No |
No |
'{0,0,0,0,0,0,0,0,0,0}'::numeric[] |
Array field containing benefit amount or percentage |
| benefit_tax_flag |
boolean[] |
No |
No |
'{f,f,f,f,f,f,f,f,f,f}'::boolean[] |
Array field to determine if benefit is taxable f = No t = Yes |
| benefit_ei_flag |
boolean[] |
No |
No |
'{f,f,f,f,f,f,f,f,f,f}'::boolean[] |
Array field to determine if EI is charged on benefit f = No t = Yes |
| benefit_cpp_flag |
boolean[] |
No |
No |
'{f,f,f,f,f,f,f,f,f,f}'::boolean[] |
Array field to determine if CPP is charged on benefit f = No t = Yes |
| benefit_wcb_flag |
boolean[] |
No |
No |
'{f,f,f,f,f,f,f,f,f,f}'::boolean[] |
Array field to determine if WCB is charged on benefit f = No t = Yes |
| deduction_type |
character varying(1)[] |
No |
No |
'{$,$,$,$,$,$,$,$,$,$}'::character varying[] |
Array field containing method to calculate deductions $ = Amount % = Percentage |
| deduction_amount |
numeric(15,2)[] |
No |
No |
'{0,0,0,0,0,0,0,0,0,0}'::numeric[] |
Amount or percentage of the deduction |
| deduction_tax_flag |
boolean[] |
No |
No |
'{f,f,f,f,f,f,f,f,f,f}'::boolean[] |
Array field to determine if deduction is taxable f = No t = Yes |
| deduction_ei_flag |
boolean[] |
No |
No |
'{f,f,f,f,f,f,f,f,f,f}'::boolean[] |
Array field to determine if EI is charged on the deduction f = No t = Yes |
| deduction_cpp_flag |
boolean[] |
No |
No |
'{f,f,f,f,f,f,f,f,f,f}'::boolean[] |
Array field to determine if CPP is charged on the deduction f = No t = Yes |
| deduction_wcb_flag |
boolean[] |
No |
No |
'{f,f,f,f,f,f,f,f,f,f}'::boolean[] |
Array field to determine if WCB is charged on the deduction f = No t = Yes |
| deduction_tax05_flag |
boolean[] |
No |
No |
'{f,f,f,f,f,f,f,f,f,f}'::boolean[] |
Array field to determine if deduction 5 is taxable f = No t = Yes |
| deduction_tax06_flag |
boolean[] |
No |
No |
'{f,f,f,f,f,f,f,f,f,f}'::boolean[] |
Array field to determine if deduction 6 is taxable f = No t = Yes |
| deduction_tax07_flag |
boolean[] |
No |
No |
'{f,f,f,f,f,f,f,f,f,f}'::boolean[] |
Array field to determine if deduction 7 is taxable f = No t = Yes |
| deduction_tax08_flag |
boolean[] |
No |
No |
'{f,f,f,f,f,f,f,f,f,f}'::boolean[] |
Array field to determine if deduction 8 is taxable f = No t = Yes |
| deduction_tax09_flag |
boolean[] |
No |
No |
'{f,f,f,f,f,f,f,f,f,f}'::boolean[] |
Array field to determine if deduction 9 is taxable f = No t = Yes |
| deduction_tax10_flag |
boolean[] |
No |
No |
'{f,f,f,f,f,f,f,f,f,f}'::boolean[] |
Array field to determine if deduction 10 is taxable f = No t = Yes |
| ytd_benefits |
numeric(15,2)[] |
No |
No |
'{0,0,0,0,0,0,0,0,0,0}'::numeric[] |
Year to date benefits |
| ytd_deductions |
numeric(15,2)[] |
No |
No |
'{0,0,0,0,0,0,0,0,0,0}'::numeric[] |
Year to date deductions |
| lst_benefits |
numeric(15,2)[] |
No |
No |
'{0,0,0,0,0,0,0,0,0,0}'::numeric[] |
Last year's benefits |
| lst_deductions |
numeric(15,2)[] |
No |
No |
'{0,0,0,0,0,0,0,0,0,0}'::numeric[] |
Last year's deductions |
| ytd_pensionable |
numeric(15,2) |
No |
No |
0 |
Year to date pensionable |
| lst_pensionable |
numeric(15,2) |
No |
No |
0 |
Last year's pensionable |
| udf_data |
hstore |
No |
No |
''::hstore |
hstore field containing user defined field data |