11 System Table Overview

Following are the control, permanent, and workfile tables that the system uses for processing year-end forms.

This chapter includes the following topics:

11.1 Control Table

The system uses the following control table from the production library when processing year-end forms.

11.1.1 F07720 - T4 Relevé Control Parameter File

This table contains the following information:

  • Workfile build selections by version

  • Special handling code selections

  • Version reset control flags

11.2 Permanent Tables

The system uses the following permanent tables from the production library when processing year-end forms.

11.2.1 F07727 - Canadian Pension Information File

This table contains pension information for printing T4A forms. The system uses the following logical tables:

  • F07727LA - Logical by year, company, address number, tax area, and tax ID

  • F07727LB - Logical by year, address number, company, tax area, and tax ID

  • F07727LC - Logical by year, social insurance number, company, tax area, and tax ID

11.2.2 F07730 - T4 Archival File

This table contains the archived history for T4 data. The system uses the following logical tables:

  • F07730LA - Logical by version ID and T4 serial number

  • F07730LB - Logical by year, company, address number, tax area, tax ID, payroll ID, and T4/Relevé amended flag

  • F07730LD - Logical by year and address number

  • F07730LE - Logical by payroll ID, T4/Relevé amended flag, year, company, address number, tax area, and tax ID

  • F07730LF - Logical by payroll ID, T4/Relevé amended flag, and T4 control number

  • F07730LI - Logical by year, company, tax ID, tax area, address number, payroll ID, and amended flag

11.2.3 F07731 - Relevé 1 (Provincial) Archival File

This table contains the archived history for Relevé 1 data. The system uses the following logical tables:

  • F07731LA - Logical by version ID and Relevé 1 serial number

  • F07731LB - Logical by year, company, address number, tax area, tax ID, payroll ID, and T4/Relevé amended flag

  • F07731LD - Logical by year and address number

  • F07731LE - Logical by payroll ID, T4/Relevé amended flag, year, company, address number, tax area, and tax ID

  • F07731LF - Logical by payroll ID, T4/Relevé amended flag, and T4 serial number

  • F07731LG - Logical by year, tax ID, company, address number, negative amount flag, secondary print flag, tax type, and tax area

  • F07731LH - Logical by year, address number, and company

11.2.4 F07732 - T4A Archival File

This table contains the archived history for T4A data. The system uses the following logical tables:

  • F07732LA - Logical by version ID and T4A serial number

  • F07732LD - Logical by year and address number

  • F07732LE - Logical by version ID, amended flag, year, company, address number, tax area, and tax ID

  • F07732LF - Logical by payroll ID, Relevé amended flag, and T4A serial number

11.2.5 F07733 - Relevé 2 Archival File

This table contains the archived history for Relevé 2 data. The system uses the following logical tables:

  • F07733LA - Logical by year, address number, T4/Relevé amended flag, tax area, tax ID, and company

  • F07733LB - Logical by address number, amended flag, tax area, tax ID, and company

  • F07733LC - Logical by version ID and Relevé 2 serial number

  • F07733LD - Logical by version ID, amended flag, and Relevé 2 serial number

  • F07733LE - Logical by year and address number

  • F07733LG - Logical by version ID, amended flag, year, company, address number, tax area, and tax ID

11.2.6 F07734 - NR4 Archival File

This table contains the archived history for NR4 data. The system uses the following logical tables:

  • F07734LA - Logical by year, company, address number, tax area, tax ID, version ID, and amended flag

  • F07734LB - Logical by address number, tax area, year, tax ID, and company

  • F07734LC - Logical by address number, version ID, and amended flag

  • F07734LD - Logical by version ID, amended flag, year, company, address number, tax area, and tax ID

  • F07734LE - Logical by year and address number

  • F07734LF - Logical by payroll ID, T4/Relevé amended flag, and NR4 serial number

11.2.7 F07740 - T4 Adjustments Archival File

This table contains adjustment information for T4 data. The system uses the following logical tables:

  • F07740LA - Logical by version ID, year, company, address number, tax area, and tax ID

  • F07740LB - Logical by year and address number

11.2.8 F07741 - Relevé 1 Adjustment Archival File

This table contains adjustment information for Relevé 1 data. The system uses the following logical tables:

  • F07741LA - Logical by version ID, year, company, address number, tax area, and tax ID

  • F07741LB - Logical by year and address number

11.2.9 F07742 - T4A Adjustment Archival File

The system uses the F07742LA logical table, logical by version ID, year, company, address number, tax area, and tax ID to store adjustment information for T4A data.

11.2.10 F07743 - Relevé 2 Adjustment Archival File

This table contains adjustment information for Relevé 2 data. The system uses the following logical tables:

  • F07743LA - Logical by version ID, year, company, address number, tax area, and tax ID

  • F07743LB - Logical by year, address number, tax area, tax ID, and company

  • F07743LC - Logical by version ID, year, company, address number, tax area, and tax ID

11.2.11 F07744 - NR4 Adjustment Archival File

The system uses the F07744LA logical table, logical by version ID, year, company, address number, tax area, and tax ID to store adjustment information for NR4 data.

11.3 Workfile Tables

The system uses the following workfile tables from your T4LIBxxx library when processing year-end forms.

11.3.1 T07730 - T4 Workfile

This table contains one record per T4 form. The system uses the following logical tables:

  • T07730LA - Logical by version ID and T4 serial number

  • T07730LB - Logical by year, company, address number, tax area, and tax ID

  • T07730LD - Logical by year and address number

  • T07730LE - Logical by payroll ID, T4/Relevé amended flag, year, company, address number, and tax ID

  • T07730LF - Logical by payroll ID, T4/Relevé amended flag, and T4 serial number

  • T07730LH - Logical by year, address number, tax ID, and province (Québec only)

  • T07730LI - Logical by year, company, tax ID, tax area, address number, payroll ID, and amended flag

11.3.2 T07731 - Relevé 1 Workfile

This table contains one record per Relevé 1 form. The system uses the following logical tables:

  • T07731LA - Logical by version ID and Relevé 1 serial number

  • T07731LB - Logical by year, company, address number, tax area, tax ID, and amended flag

  • T07731LD - Logical by year and address number

  • T07731LE - Logical by version ID, amended flag, year, company, address number, tax area, and tax ID

  • T07731LF - Logical by payroll ID, T4/Relevé amended flag, and T4A serial number

  • T07731LG - Logical by year, tax ID, company, address number, negative amount flag, secondary print flag, tax type, and tax area

  • T07731LH - Logical by year, address number, and company

11.3.3 T07732 - T4A Workfile

This table contains one record per T4A form. The system uses the following logical tables:

  • T07732LA - Logical by version ID and T4A serial number

  • T07732LB - Logical by year, company, address number, tax area, tax ID, and amended flag

  • T07732LC - Logical by version ID and T4A serial number

  • T07732LD - Logical by year and address number

  • T07732LE - Logical by version ID, amended flag, year, company, address number, tax area, and tax ID

  • T07732LF - Logical by payroll ID, T4/Relevé amended flag, and T4A serial number

  • T07732LG - Logical by address number, tax area (work), tax ID, home company, and type of form

11.3.4 T07733 - Relevé 2 Workfile

This table contains one record per Relevé 2 form. The system uses the following logical tables:

  • T07733LA - Logical by address number, tax area, year, tax ID, and company

  • T07733LB - Logical by year, address number, amended flag, tax area, tax ID, and company

  • T07733LC - Logical by version and Relevé 2 serial number

  • T07733LD - Logical by version ID, amended flag, and Relevé 2 serial number

  • T07733LE - Logical by year and address number

  • T07733LG - Logical by version ID, amended flag, year, company, address number, tax area, and tax ID

11.3.5 T07734 - NR4 Workfile

This table contains one record per NR4 form. The system uses the following logical tables:

  • T07734LA - Logical by year, company, address number, tax area, tax ID, version ID, and amended flag

  • T07734LB - Logical by address number, tax area, year, tax ID, and company

  • T07734LC - Logical by address number, version, and amended flag

  • T07734LD - Logical by version, amended flag, year, company, address number, tax area, and tax ID

  • T07734LE - Logical by year and address number

  • T07734LF - Logical by T4/Relevé amended flag and NR4 serial number

  • T07734LG - Logical by version ID and NR4 serial number

11.3.6 T07740 - T4 Adjustments Workfile

The T07740LA, a logical table by version ID, year, company, address number, tax area, and tax ID contains adjustment information for T4 data.

11.3.7 T07741 - Relevé 1 Adjustment Workfile

The T07741LA, a logical table by version ID, year, company, address number, tax area, and tax ID contains adjustment information for Relevé 1 data.

11.3.8 T07742 - T4A Adjustment Workfile

The T07742LA, a logical table by version ID, year, company, tax area, and tax ID contains adjustment information for T4A data.

11.3.9 T07743 - Relevé 2 Adjustment Workfile

This table contains adjustment information for Relevé 2 data. The system uses the following logical tables:

  • T07743LA - Logical by version ID, year, company, address number, tax area, and tax ID

  • T07743LB - Logical by year, address number, tax area, tax ID, and company

  • T07743LC - Logical by version ID, year, company, address number, tax area, and tax ID

11.3.10 T07744 - NR4 Adjustment Workfile

The T07744LA, a logical table by version ID, year, company, address number, tax area, and tax ID contains adjustment information for NR4 data.

11.3.11 T07760X - T4 XML File

This table contains XML information for T4 forms.

11.3.12 T07765X - T4A XML File

This table contains XML information for T4A forms.

11.3.13 T07770X - Relevé 1 XML File

This table contains XML information for Relevé 1 forms.

11.3.14 T07775X - Relevé 2 XML File

This table contains XML information for Relevé 2 forms.

11.3.15 T07761 - T4 XML Audit File

This table contains XML file information in sequential format for the XML audit Report.

11.3.16 T07766 - T4A XML Audit File

This table contains XML file information in sequential format for the XML Audit Report.

11.3.17 T07771 - Relevé 1 XML Audit File

This table contains XML file information in sequential format for the XML Audit Report.

11.3.18 T07776 - Relevé 2 XML Audit File

This table contains XML file information in sequential format for the XML Audit Report.