This page (revision-14) was last changed on 26-Nov-2021 10:22 by Meg McFarland

This page was created on 26-Nov-2021 10:22 by UnknownAuthor

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Page revision history

Version Date Modified Size Author Changes ... Change note
14 26-Nov-2021 10:22 6 KB Meg McFarland to previous
13 26-Nov-2021 10:22 6 KB mmcfarland to previous | to last
12 26-Nov-2021 10:22 6 KB mmcfarland to previous | to last
11 26-Nov-2021 10:22 7 KB mmcfarland to previous | to last
10 26-Nov-2021 10:22 7 KB mmcfarland to previous | to last
9 26-Nov-2021 10:22 7 KB mmcfarland to previous | to last
8 26-Nov-2021 10:22 7 KB mmcfarland to previous | to last
7 26-Nov-2021 10:22 3 KB kparrott to previous | to last
6 26-Nov-2021 10:22 3 KB kparrott to previous | to last
5 26-Nov-2021 10:22 3 KB JMyers to previous | to last
4 26-Nov-2021 10:22 2 KB JMyers to previous | to last
3 26-Nov-2021 10:22 2 KB JMyers to previous | to last
2 26-Nov-2021 10:22 4 KB JMyers to previous | to last
1 26-Nov-2021 10:22 46 bytes UnknownAuthor to last

Page References

Incoming links Outgoing links

Version management

Difference between version and

At line 1 changed one line
[{TableOfContents }]
!!!RPYEC - CANADIAN PAYROLL YEAR END SUMMARY
At line 3 changed 3 lines
!!!CANADIAN PAYROLL YEAR END SUMMARY
----
!!Report Parameters & Filters
This report extracts information from YTD according to the Form Code on IDFDV and produces the Summary Total Report by government registration. \\This process also stores the results by GVT Run Number for each employee in the Government Reporting table.
At line 7 changed 22 lines
||Report Parameters||
Form Code
Period Type
Period End Date
As of Date
Govt Form Option
Retain Amend/Reject...
Sort Level By
Sort People By
Sort By Active/Inactive
Combine Fed Regist
Directory Name
File Name
Trace Level
Regist/Set Up Audit
Print Employee Detail
Trial Print Only
Create Trace File
Create Data Dump
Process Remittance
Update Remittance
User Comment
!!RPYEC Report Parameters & Filters
At line 7 added 23 lines
__Report Parameters__
||Field||Description
|Form Code|Mandatory. Enter the current year Form Code, defined on IDFDV. \\__NOTE__: Always use current year form code, such as HL$CAN-T4-20YY. \\DO NOT use a prior year form code as the Identifiers may be obsolete. \\LOV available
|Period Type|Mandatory. Enter the [Period Type|X_IDFD_PERIOD_TYPE], such as Month or Year. LOV available
|Period End Date|Mandatory. Enter the end date of the reporting period. LOV Available
|As of Date|Mandatory. Enter the start date of the reporting period. LOV Available
|Govt Form Option|Mandatory. Defines the type of form to be run. Options are: \\* 01: New forms only \\* 02: All normal forms \\* 03: Duplicate forms \\* 04: Amended forms \\* 05: Rejected forms \\* 06: Cancelled forms. \\ [Govt Form Option|X_GVT_FORM_OPTION] LOV available
|Retain Amend/Reject Form|Optional. Should the original forms be retained when issuing an amended or replacement form that was rejected by the Government? \\[Yes/No|X_YES_NO] LOV
|Sort Level By|Mandatory. How should the employees be grouped for sorting? \\[Sort Level By|X_T4_SORT_LEVEL] LOV available
|Sort People By|Mandatory. How should the employees on the report be sorted? \\[Sort People By|X_PERSON_SORT] LOV available
|Sort by Active/Inactive|Optional. Should the employees on the report be sorted by their status?\\ [Sort By|X_W2_SORT_ACTIVE] LOV available
|Combine Fed Regist|Optional. Should all the selected Federal Registrations reporting be combined? \\If a Province code is defined in the report filters, users can combine the Federal Registration Numbers with the Provincial Registration Numbers so that employees are grouped together for the same Provincial Registration Numbers. \\ [Yes/No|X_YES_NO] LOV
|Directory Name|
|File Name|
|Trace Level|Optional. Defines the level of detail to be printed on the report. Users should always run RPYEC with the Trace Level set to 'Exceptions Only' for all employees, unless required for tracing or debugging. \\ \\If there is problem in RPYEC and a user needs to determine which employee has the problem, the user should run RPYEC with the Trace Level set to Program Trace. This will print a list of processed employees to determine which employee has the problem. \\ \\When the Trace Level is set to Program Trace, the Select Statements for Federal, State and Local levels are also written as Trace messages. Users can review the select statements by running RMEX for the RPYEC Execution ID. \\ \\ After determining which employee has the problem, users should run RPYEC for one employee with the Trace Level set to Utility Trace to determine the problem in detail. [Trace Level|X_TRACE_LEVEL] LOV available.
|Regist/Set Up Audit|Optional. Defines whether to print exceptions that may exist from set up. Options are: \\* 00 Do not print, run \\* 01: Print, do not run \\* 02: Print and run \\* 03: Excp and run. \\ [Print and Run|X_PRINT_AND_RUN] LOV available
|Print Employee Detail|Optional. Defines whether to print the report with employee’s detailed information. \\ [Yes/No|X_YES_NO] LOV available
|Trial Print Only|Optional. Defines if the Print Stage field on the IPGH form will be updated when the T4s are printed. \\When set to Yes, the field will not be updated. When set to No, the Print Stage will be changed to Forms Printed.\\ [Yes/No|X_YES_NO] LOV
|Create Trace File|
|Create Data Dump|
|Process Remittance|Optional. To generate monthly remittances.\\ [Yes/No|X_YES_NO] LOV
|Update Remittance|Optional. To update monthly remittances.\\ [Yes/No|X_YES_NO] LOV
|User Comment|Optional. Users can enter text that will print on the header of the report.
At line 31 added 10 lines
__Report Filters__
||Field||Description
|Entity|Optional. To define and report on a specific Entity.\\ LOV available
|Federal Regist Set|Optional. To define and report on a specific Federal Registration Set, defined on IDGV. \\LOV available
|Federal Regist Number|Optional. Defines the Employer Identification Number, defined on IDGV. \\LOV available
|People List|Optional. To define and report on the people in the defined list.\\ LOV available
|Person|Optional. Enter the Person Code of the employee you are testing with. \\ LOV available
|Select Province|Optional. To define and report on a specific Province.\\ LOV available
|Province Regist Set|Optional. To define and report on a specific Provincial Registration Set, defined on IDGV. Not required for Annual reporting. \\LOV available
|Prov Regist Number|Optional. To define and report on a specific Province Registration Number.\\ LOV available
At line 32 changed 20 lines
|Report Type|Mandatory,[Report Type|X_WRS_REPORT_TYPE] lexicon available\\Annual or EE Transaction Report
|Report Date|Mandatory, Date, LOV available\\The ‘Report Date' is the date printed in the file.
|Action Begin Date/Action End Date|Mandatory, Date, LOV available\\The ‘Action' date range will be used to determine which pay components within the element to report on.
|Directory Name|Optional, text\\Must be a directory on the server for which the current user (as signed onto the client’s network) has write capability. For example the entry ‘C:\TEMP’ accesses the ‘TEMP’ directory on the server, not the local directory for the computer terminal being used.
|Media File Name|Optional, Text\\This field displays the file name of the data being uploaded.
|Write or Append|Mandatory, [Write or Append|X_WRITE_APPEND] available\\If the file already exists should the current information overwrite it or append to it?
|Entity|Mandatory, LOV available\\Limits the process to the entity specified.
|Fiscal Hours Element|Mandatory, LOV available\\This field allows you specify the fiscal hours pay element for the report.
|Fiscal Earn Element|Mandatory, LOV available\\This field allows you specify the fiscal earnings pay element for the report.
|Calendar Hours Element|Mandatory, LOV available\\This field allows you specify the calendar hours element for the report.
|Calendar Earn Element|Mandatory, LOV available\\This field allows you specify the calendar earnings element for the report.
|EERC Element|Mandatory, LOV available\\This field allows you specify the EERC pay element for the report.
|BAC Element|Mandatory, LOV available\\This field allows you specify the BAC pay element for the report.
|Add'l Contrib Fix Elem|Optional, LOV available\\This field allows you specify the additional contributions fixed element for the report.
|Add'l Contrib Var Elem|Optional, LOV available\\This field allows you specify the additional contributions variable element for the report.
|Tax Def Add'l Fix Elem|Optional, LOV available\\This field allows you specify the tax deferred additional fixed element for the report.
|Tax Def Add'l Var Elem|Optional, LOV available\\This field allows you specify the tax deferred additional variable element for the report.
|ER Add'l Fix Elem|Optional, LOV available\\This field allows you specify the employer additional fixed element for the report.
|ER Add'l Var Elem|Optional, LOV available\\This field allows you specify the employer additional variable element for the report.
|Exception Level|Optional, LOV available\\A ‘trace’ report of exception messages may be produced to assist in the testing phase. If necessary, choose from 0 – 9 (highest) level of trace. Please note that this is a voluminous report and will cause very slow performance.
__RPYEC Notes__\\
* The RPYEC process produces a Summary Total Report by Government Registrations. Users must balance this report to the RPREGT report. \\
At line 53 changed 9 lines
||Report Filters||
Entity
Federal Regist Set
Federal Regist Number
People List
Person
Select Province
Prov Regist Set
Prov Regist Number
* Each RPYEC run generates one Government Run Number (GVT Run).\\
At line 47 added one line
* All employees processed by the RPYEC run belong to this GVT Run Number. At end of RPYEC, the Government Reporting Statistics are printed with the generated GVT Run Number. After RPYEC is run, users can go into the IPGR (Government Run) form to view the details by the GVT Run number. \\
At line 64 changed 10 lines
|People List Code|Optional, LOV available\\This field limits the process to the people list specified.
|Person|Optional, LOV available\\This field limits the process to persons specified.
|Department|Optional, LOV available\\This field limits the process to the departments specified.
|Org Level Type|Optional, LOV available\\This field limits the process to the organization level types specified.
|Org Level|Optional, LOV available\\This field limits the process to the organization levels specified.
|Authorization Area|Optional, LOV available\\This field limits the process to the authorization areas specified.
|Unit|Optional, LOV available\\This field limits the process to the units specified.
|Group|Optional, LOV available\\This field limits the process to the groups specified.
|Payroll|Optional, LOV available\\This field limits the process to the payrolls specified.
|Status|Optional, LOV available\\This field limits the process to the statuses specified.
* On the IPGR form, the employee’s detail government reporting information can be viewed. Alternately, users can go directly to the IPGH (Government Header) form by employee to view this information. \\
At line 75 changed 2 lines
----
[{If var='loginstatus' contains 'authenticated'
* Users can process many RPYEC runs for different sets of employees. This generates multiple GVT Run numbers. Users can run one RPGRC (Government Reporting) run to pick up all GVT Runs to generate one Print Form file for printing and one government interface file. \\
At line 78 changed 2 lines
![Discussion|Edit:Internal.RPYEC]
[{InsertPage page='Internal.RPYEC' default='Click to create a new discussion page'}]
* Employee’s Government Header information are re-generated by subsequent RPYEC runs if the Government Header has not been filed to the government. The same IPGH information is removed automatically when a new IPGH is re-generated. \\
At line 81 changed one line
}]
* At the end of each run, the RPYEC process removes any GVT Run Number that does not have GVT Header associated with it. \\
* Users can run the RPYEC process concurrently for different sets of employees. \\
* At the beginning of the RPYEC run, the Execution Run Log is stamped with the Execution Start Date. At the end of RPYEC run, the Execution End Date is stamped. \\
* For concurrent RPYEC runs that have not been finished with the Execution End Date, any other concurrent RPYEC runs will not remove the GVT Run Number, even if there are no GVT Headers.