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

Permanent Tables

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

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

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

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

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

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

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

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

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

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.

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

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.