Table Data dictionary report - payroll_depts

Generated: 2019-01-22 5:56:34 AM
Server: PostgreSQL 9.3 (localhost:5432)
Database: datadict
Schema: public
Notes:

Table for Payroll Departments

Columns

Name Data type Not Null? Primary key? Default Comment
id integer Yes Yes nextval('payroll_depts_id_seq'::regclass) Unique identifier
gl_division character varying(3) Yes No General Ledger Division for this payroll department
wages character varying(24) No No General Ledger account to use for Wages expense
ei_expense character varying(24) No No General Ledger account to use for Empoyment Insurance Expense
cpp_expense character varying(24) No No General Ledger account to use for CPP expense
wcb_expense character varying(24) No No General Ledger account to use for WCB expense
advances_receivable character varying(24) No No General Ledger account to use for Advances paid to employees
ei_payable character varying(24) No No General Ledger account to use for Employement Insurance payable
cpp_payable character varying(24) No No General Ledger account to use for CPP payable
wcb_payable character varying(24) No No General Ledger account to use for WCB payable
income_tax_payable character varying(24) No No General Ledger account to use for Income Tax payable
pension_payable character varying(24) No No General Ledger account to use for Pension payable
union_dues_payable character varying(24) No No General Ledger account to use for Union dues payable
vacation_payable character varying(24) No No General Ledger account to use for Vacation payable
clearing character varying(24) No No General Ledger account to use for Payroll clearing or bank account
qpp_expense character varying(24) No No General Ledger account to use for QPP expense
csst_expense character varying(24) No No General Ledger account to use for CSST expense
qhip_expense character varying(24) No No General Ledger account to use for QHIP expense
qpp_payable character varying(24) No No General Ledger account to use for QPP payable
csst_payable character varying(24) No No General Ledger account to use for CSST payable
qhip_payable character varying(24) No No General Ledger account to use for QHIP payable
qc_tax_payable character varying(24) No No General Ledger account to use for QC tax payable
ppip_expense character varying(24) No No General Ledger account to use for PPIP expense
ppip_payable character varying(24) No No General Ledger account to use for PPIP payable
code character varying(10) No No User set code for this department
description character varying(30) No No User set description for this department
vacation_expense character varying(24) No No General Ledger account to use for Vacation pay expense
_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

Constraints

Name Type Definition Comment
payroll_dept_pkey Primary key (id)

Report generated by pgAdmin3 LTS by BigSQL