id |
integer |
Yes |
Yes |
nextval('payroll_timecard_additions_id_seq'::regclass) |
Unique identifier |
timecard_id |
integer |
Yes |
No |
|
Timecard for these records - links to timecards.id |
employee_addition_id |
integer |
No |
No |
|
Employee source this record - links to employee_additons.id |
name |
character varying(60) |
No |
No |
|
Name or description |
account |
character varying(24) |
No |
No |
|
GL Account posted to |
type |
character varying(1) |
Yes |
No |
|
Record type; B = Benefit D = Deduction |
tax |
boolean |
Yes |
No |
false |
Tax flag; False = Not taxable True = Taxable |
ei |
boolean |
Yes |
No |
false |
Employment Insurance flag; False = no EI calculated True = calculate EI |
cpp |
boolean |
Yes |
No |
false |
CPP/QPP flag; False = no pension calculated True = calculate pension |
wcb |
boolean |
Yes |
No |
false |
WCB flag; False = no Worker's Compensation calculated True = calculate Worker's Compensation |
user_flag |
boolean |
Yes |
No |
false |
User override flag; False = Employee or Payroll department calculations used True = Employee did an override on the amounts |
total |
numeric(15,2) |
Yes |
No |
0 |
Amount of Benefit / Deduction calculated |
_dbversion |
integer |
No |
No |
|
Program version that last modified 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 |
_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 |