| id |
integer |
Yes |
Yes |
nextval('timecards_id_seq'::regclass) |
Unique identifier |
| employee_no |
character varying(6) |
No |
No |
|
Employee number - links to employees.employee_no |
| year |
smallint |
No |
No |
|
Payroll year for timecard |
| week_no |
smallint |
No |
No |
|
Payroll week number |
| sub_week |
smallint |
No |
No |
|
Additional timecard number for the week; 0 = Original timecard 1 = First additional timecard 2 = Second additonal timecard |
| date |
date |
No |
No |
|
Pay date |
| cheque_no |
character varying(10) |
No |
No |
|
Cheque number assigned to timecard when printed |
| trans_no |
character varying(10) |
No |
No |
|
General Ledger transaction number - links to gl_transaction.trans_no |
| fed_tax |
numeric(15,2) |
No |
No |
|
Federal tax amount, includes provincial tax except in Quebec |
| prv_tax |
numeric(15,2) |
No |
No |
|
Quebec Provincial tax amount |
| munic_tax |
numeric(15,2) |
No |
No |
|
Not used |
| uic |
numeric(15,2) |
No |
No |
|
Employment Insurance amount |
| cpp |
numeric(15,2) |
No |
No |
|
Canada Pension Plan amount |
| tc_union |
numeric(15,2) |
No |
No |
|
Union dues amount |
| rsp |
numeric(15,2) |
No |
No |
|
Registered Savings Plan amount |
| wcb |
numeric(15,2) |
No |
No |
|
Workers Compensation Board or Provincial Work Safe amount |
| qhip |
numeric(15,2) |
No |
No |
|
Quebec Health Insurance Plan amount |
| insurable_dlrs |
numeric(15,2) |
No |
No |
|
Insurable amount |
| vac_paid |
numeric(15,2) |
No |
No |
|
Vacation paid amount |
| vac_amount |
numeric(15,2) |
No |
No |
|
Vacation amount |
| uic_rate |
numeric(5,3) |
No |
No |
|
Employement Insurance rate |
| cpp_emp_rate |
numeric(3,2) |
No |
No |
|
Canada Pension Plan employer multipler rate |
| reversal_flag |
character varying(1) |
No |
No |
|
Timecard Reversal flag; R = Yes |
| pensionable |
numeric(15,2) |
No |
No |
|
Pensionable amount |
| taxable_amt |
numeric(15,2) |
No |
No |
|
Taxable amount |
| ppip_insurable |
numeric(15,2) |
No |
No |
|
Provoncial Parental Insurance Plan insurable amount |
| ppip |
numeric(15,2) |
No |
No |
|
Provoncial Parental Insurance Plan amount |
| ppip_employer_rate |
numeric(15,5) |
No |
No |
|
Provoncial Parental Insurance Plan employer rate |
| ppip_rate |
numeric(15,5) |
No |
No |
|
Provoncial Parental Insurance Plan rate |
| _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 |
| benefits |
numeric(15,2)[] |
No |
No |
'{0,0,0,0,0,0,0,0,0,0}'::numeric[] |
Benefit 1 -1 0 amount |
| deductions |
numeric(15,2)[] |
No |
No |
'{0,0,0,0,0,0,0,0,0,0}'::numeric[] |
Deduction 1 - 10 amount |
| udf_data |
hstore |
No |
No |
''::hstore |
User defined data for this record |