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 one line
!!!CANADIAN PAYROLL YEAR END SUMMARY
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 5 changed one line
The RPYEC form allows you to print out a summary of Canadian payroll year end.
!!RPYEC Report Parameters & Filters
At line 7 changed 20 lines
----
!!Report Parameters & Filters
||Report Parameters||
|Form Code|Mandatory, LOV available\\This field allows you to chose the form for the report.
|Period Type|Mandatory, [Period Type|X_IDFD_PERIOD_TYPE] lexicon available
|Period End Date|Mandatory,Date, LOV Available
|As of Date|Mandatory,Date, LOV Available
|Govt Form Option|Mandatory, [Govt Form Option|X_GVT_FORM_OPTION] lexicon available
|Retain Amend/Reject Form|Optional, [Yes/No|X_YES_NO] lexicon available
|Sort Level By|Mandatory, [Sort Level By|X_T4_SORT_LEVEL] lexicon available
|Sort People By|Mandatory, [Sort People By|X_PERSON_SORT] lexicon available
|Sort by Active/Inactive|Optional, [Sort By|X_W2_SORT_ACTIVE] lexicon available
|Combine Fed Regist|Optional, [Yes/No|X_YES_NO] lexicon available
|Directory Name|Optional,Text\\This field allows you to provide a directory name.
|File Name|Optional,Text\\This field allows you to provide a file name.
|Trace Level|Optional, [Trace Level|X_TRACE_LEVEL] lexicon available. This field defines the exception level (report messages) required.
|Regist/Set Up Audit|
|Print Employee Detail|Optional, Lexicon available\\If <Yes> then the employee details will be displayed on the report, otherwise no details will display on the report.
|Trial Print Only|Optional, Lexicon available\\You may choose to run the report in a trial mode to see results
__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
At line 29 changed 3 lines
|Process Remittance|
|Update Remittance|
|User Comment|Optional, Text\\This field holds the user-supplied comment which will appear in the header of all pages of the report.
|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 33 changed 9 lines
||Report Filters||
|Entity|Optional, Multiple selections, LOV available\\This field limits the report to the specified entities.
|Federal Regist Set|Optional, Multiple selections, LOV available\\This field limits the report to the specified federal registration sets.
|Federal Regist Number|Optional, Multiple selections, LOV available\\This field limits the report to the specified federal registration numbers.
|People List|Optional, Multiple selections, LOV available\\This field limits the report to the specified people lists.
|Person|Optional, Multiple selections, LOV available\\This field limits the report to the specified persons.
|Select Province|Optional, Multiple selections, LOV available\\This field limits the report to the specified provinces.
|Province Regist Set|Optional, Multiple selections, LOV available\\This field limits the report to the specified province registration sets.
|Prov Regist Number|Optional, Multiple selections, LOV available\\This field limits the report to the specified province registration numbers.
__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 43 changed 2 lines
----
[{If var='loginstatus' contains 'authenticated'
__RPYEC Notes__\\
* The RPYEC process produces a Summary Total Report by Government Registrations. Users must balance this report to the RPREGT report. \\
At line 46 changed 2 lines
![Discussion|Edit:Internal.RPYEC]
[{InsertPage page='Internal.RPYEC' default='Click to create a new discussion page'}]
* Each RPYEC run generates one Government Run Number (GVT Run).\\
At line 49 changed 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. \\
* 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. \\
* 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. \\
* 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 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.