1. Canadian Payroll Year-End Processing (T4) Guide
  2. Workfile Tables

Workfile Tables

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

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

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

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

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

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

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.

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.

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.

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

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.

T07760X - T4 XML File

This table contains XML information for T4 forms.

T07765X - T4A XML File

This table contains XML information for T4A forms.

T07770X - Relevé 1 XML File

This table contains XML information for Relevé 1 forms.

T07775X - Relevé 2 XML File

This table contains XML information for Relevé 2 forms.

T07761 - T4 XML Audit File

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

T07766 - T4A XML Audit File

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

T07771 - Relevé 1 XML Audit File

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

T07776 - Relevé 2 XML Audit File

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