Table Data dictionary report - payroll_timecard_additions

Generated: 2019-01-21 9:47:26 AM
Server: PostgreSQL 9.3 (localhost:5432)
Database: datadict
Schema: public
Notes:

Table for for benefits and deductions recorded on the timecard

Columns

Name Data type Not Null? Primary key? Default Comment
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

Constraints

Name Type Definition Comment
payroll_timecard_additions_pkey Primary key (id)
payroll_timecard_additions_employee_addition_id_fkey Foreign key (employee_addition_id) REFERENCES public.payroll_employee_additions (id) MATCH SIMPLE ON UPDATE NO ACTION ON DELETE SET NULL
payroll_timecard_additions_timecard_id_fkey Foreign key (timecard_id) REFERENCES public.payroll_timecards (id) MATCH SIMPLE ON UPDATE NO ACTION ON DELETE CASCADE

Report generated by pgAdmin3 LTS by BigSQL