System Tables

This table describes the tables used in processing year-end forms:

Table	Usage
F77100 - Canadian Year-End Control	This table contains information about the year-end ID and information about the status of these processes: Workfile build Form print Magnetic media build Audit reports Archive
F77101 - Canadian Year-End Print	This table contains information about year-end reporting, including audit reports, forms, and magnetic media, for each year-end ID.
F77105 - Year End Limits Setup	This table stores the maximum EI and pensionable earnings by year-end ID and tax year.
F77180 - Canadian Year-End Form Setup	This table contains information about the boxes that have been set up on year-end forms.
F77190 - Special Handling Setup	This table contains information about the pay types, deductions, benefits, accruals (PDBAs) that have been set up to populate boxes on year-end forms.
F77200 - Canadian Employee Year-End Form Header	This table contains the amounts that were retrieved from the Tax History table (F0713) for each employee during the workfile builds.
F77201T - Negative Amount Print	This table is used during printing of the Negative Amount Report (R77102A). This table should be empty when no print jobs are running.
F77210 - Canadian Employee Year-End Form Detail	This table contains the special handling amounts that were retrieved from the Tax Area Transaction History table (F06148) for each employee during the workfile builds.
F77220 - Employee Special Handling Detail	This table contains information about the PDBA codes and amounts that were retrieved for each employee through special handling.
F77230 - Employee Pension Maintenance	This table contains pension information for former employees and non-employees, including whether the pension information should print on a T4 or T4A form.
F0713SAV - Backup Copy of F0713 For Tax Ledger Repost	This table is a copy of the Tax History table (F0713) before the Tax Ledger Repost.