| id |
integer |
Yes |
Yes |
nextval('timecards_id_seq'::regclass) |
Unique identifier |
| 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 |
| union_dues |
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 |
| pensionable |
numeric(15,2) |
No |
No |
|
Pensionable amount |
| taxable_amt |
numeric(15,2) |
No |
No |
|
Taxable amount |
| ppip_insurable |
numeric(15,2) |
No |
No |
|
Provincial Parental Insurance Plan insurable amount |
| ppip |
numeric(15,2) |
No |
No |
|
Provincial Parental Insurance Plan amount |
| ppip_employer_rate |
numeric(15,5) |
No |
No |
|
Provincial Parental Insurance Plan employer rate |
| ppip_rate |
numeric(15,5) |
No |
No |
|
Provincial 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 |
| udf_data |
hstore |
No |
No |
''::hstore |
User defined data for this record |
| dept_id |
integer |
No |
No |
|
Payroll department used by this record - links to payroll_depts.id |
| employee_id |
integer |
No |
No |
|
Employee on this record - links to employees.id |
| wcb_rate |
numeric(5,3) |
No |
No |
|
WCB rate used when calculating this timecard |
| retain_vacation_pay |
boolean |
No |
No |
|
Vaction pay was retained on this timecard; False = Vacation pay was paid on the record True = Vacation pay was accrued on the timecard |
| reversal |
boolean |
Yes |
No |
false |
Reversal flag; False = This is an original timecard True = This timecard is a reversal or has been reversed |
| net_pay |
numeric(15,2) |
Yes |
No |
|
Net pay on this timecard |
| total_deductions |
numeric(15,2) |
No |
No |
|
Total Deductions on this timecard |
| total_benefits |
numeric(15,2) |
No |
No |
|
Total benefits on this Timecard |