Table Data dictionary report - employee_t4s

Generated: 2018-10-17 8:05:29 AM
Server: PostgreSQL 9.3 (localhost:5432)
Database: datadict_donotremove
Schema: public
Notes:

Table for Employee T4 records

Columns

Name Data type Not Null? Primary key? Default Comment
id integer Yes Yes nextval('employee_t4s_id_seq'::regclass) Unique identifier
employee_id integer Yes No Employee identifier - links to employees.id
year integer Yes No Year of the T4
province character varying(2) No No Province
cpp_exempt boolean Yes No false CPP Exempttion flag; FALSE = No TRUE = Yes
ei_exempt boolean Yes No false Employment Insurance exemption flag; FALSE = No TRUE = Yes
ppip_exempt boolean Yes No false Provincial Parental Insurance Plan exemption flag; FALSE = No TRUE = Yes
employment_code integer No No Employement code as per CRA
employment_income numeric(15,2) No No Adjusted Income
cpp_contributions numeric(15,2) No No Adjusted Canada Pension Plan contribution
qpp_contributions numeric(15,2) No No Adjusted Quebec Pension Plan contribution
ei_premiums numeric(15,2) No No Adjusted Employment Insurance premiums
rpp_contributions numeric(15,2) No No Adjusted Registered Pension Plan contribution
pension_adjustment numeric(15,2) No No Adjusted Pension adjustment
ppip_premiums numeric(15,2) No No Adjusted Provincial Parental Insurance Plan premiums
tax_deducted numeric(15,2) No No Adjusted Income Tax deducted
insurable_earnings numeric(15,2) No No Adjusted Insurable earnings
pensionable_earnings numeric(15,2) No No Adjusted Pensionable earnings
union_dues numeric(15,2) No No Adjusted Union dues
charitable_donations numeric(15,2) No No Adjusted charitable donations
rpp_registration character varying(30) No No Registered Pension Plan registration number
ppip_insurable_earnings numeric(15,2) No No Adjusted Provincial Parental Insurance Plan insurable earnings
other_boxes character varying[] No No '{NULL,NULL,NULL,NULL,NULL,NULL}'::character varying[] Other field descriptions 1 - 6 when set on the T4
other_amounts numeric(15,2)[] No No '{0,0,0,0,0,0}'::numeric[] Other Adjusted field 1 - 6 amouts when selected on the T4
remitted date No No Remitted date
_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
last_name character varying(30) No No Employee's last name as printed on T4
first_name character varying(30) No No Employee's first name as printied on T4
initials character varying(5) No No Employee's initials as printed on T4
suggested_cpp_exempt boolean No No Canada Pension Plan exempt flag as copied from employee table
suggested_ei_exempt boolean No No Employement Insurance exempt flag as copied from employee table
suggested_ppip_exempt boolean No No Provincial Parental Insrance Plan exempt flag as copied from employee table
suggested_employment_income numeric(15,2) No No Calculated Income from timecards
suggested_cpp_contributions numeric(15,2) No No Calculated Canada Pension Plan contributions
suggested_qpp_contributions numeric(15,2) No No Calculated Quebec Pension Plan contributions
suggested_ei_premiums numeric(15,2) No No Calculated Employment Insurance premiums
suggested_rpp_contributions numeric(15,2) No No Calculated Registered Pension Plan contributions
suggested_pension_adjustment numeric(15,2) No No Calculated pension adjustment
suggested_ppip_premiums numeric(15,2) No No Calculated Provincial Parential Insurance Plan premiums
suggested_tax_deducted numeric(15,2) No No Calculated Income tax deducted
suggested_insurable_earnings numeric(15,2) No No Calculated insurable earnings
suggested_pensionable_earnings numeric(15,2) No No Calculated pensionable earnings
suggested_union_dues numeric(15,2) No No Calculated union dues
suggested_charitable_donations numeric(15,2) No No Calculated charitabe donations, not currently used
suggested_ppip_insurable_earnings numeric(15,2) No No Calculated Provincial Parental Insurance Plan insurable earnings
suggested_other_amounts numeric(15,2)[] No No '{0,0,0,0,0,0}'::numeric[] Not used
status character varying(1) No No Staus of T4; A = Amended C = Cancelled O = Original

Constraints

Name Type Definition Comment
employee_t4s_pkey Primary key (id)
employee_t4s_employee_id_fkey Foreign key (employee_id) REFERENCES public.employees (id) MATCH SIMPLE ON UPDATE NO ACTION ON DELETE NO ACTION

Report generated by pgAdmin3 LTS by BigSQL