This appendix contains these topics:
Section A.1, "Technical Overview of Pre-Payroll Processing,"
Section A.3, "Technical Overview of Payroll Journal Entries,"
The following table presents a technical overview of the pre-payroll processing step of the payroll cycle.
| Step | Explanation | Tables Read | Tables Updated |
|---|---|---|---|
| Payroll Processing Control (P062001) | Selects timecards based on pay cycle, group, and home company. Assigns lockout code. Creates autopay transactions. | F060116 F06210 F06106 F06116 | F060116 F06116 F06210xxx F0609 |
| DBA Calculation (P062011) | Calculates all user defined deductions and all benefits/accruals requested (based on gross pay).*
(See * on the following page.) |
F0609 F06116 F06210 F06146 F06145 F069116 | F0609 F0605 |
| Vertex Workfile Build (P062031) | Calculates current and YTD wages for all tax authorities. | F060116 F06116 F0609 F06136 F06017 | F06126 |
| Payroll Tax Calculation (J06VTXXML) | Module calls Vertex Q Series program (VprtXML) and calculates all applicable payroll taxes. | F06126 | F06126 |
| Net Deduction Calculation (P062021) | Calculates all user defined deductions that are based on net pay to generate the following reports:
|
F069116 F06126 F06116 F0609 F06107 | F0609 F06126 |
| Merge Interim Checks (P062041) | Merges qualifying employee interim checks into pay cycle work files to generate the following reports:
|
F06126I F06350I | F06126 F06350I F063502I F0609 F06116 |
| Paycheck Workfile Build (P063501) | Calculates detailed transactions used to generate various reports and files, including:
If the Paycheck Transparency details are provided using the Paycheck Transparency function while processing pre-payroll, this program also validates the paycheck transparency details and updates the paycheck workfile with the paycheck details. |
F065016 F06116 F0609 F06126 F06136 F06146 | F063501 F063502 |
| Time and Pay Register (P063001) | Reports on time entered and included in the payroll cycle. | F06116 F060116 | |
| Payroll Register (P063012 and P063013) | Reports that detail employee gross-to-net, available in detail or summary format. | F060116 F063501 F06136 F06146 F06126 F065106 | |
| Federal Tax Distribution Summary (P063170) | Optional report of current, MTD, QTD, and YTD taxes. | F063501 F06136 | |
| Update Status Flag (P062101) | Moves 1 to data field PPST on Pay Cycle Review/Reset. | F06210 F060116 | F06210 F060116 |
* Pre-Payroll Processing calculates benefits defined with a Y (Yes) in the Calculate in Pre-Payroll field on the DBA Setup screen. The system calculates benefits with N (No) in the Calculate in Pre-Payroll field during the Journal Entries Payroll Cycle step.
The following chart presents a technical overview of the print payments step of the payroll cycle.
| Step | Explanation | Tables Read | Tables Updated |
|---|---|---|---|
| Auto Deposit Selection (P062301) | Include automatic deposits in the version to display Auto Deposit Selection. | Data area: Net Pay Instructions in version library | |
| Auto Deposit DREAM Writer Version Processing (P98300) | Include automatic deposits to display the versions available for the Auto Deposit External File Build job. | ||
| Auto Deposit Batch Job (J065501) | If auto deposits are included, this job is submitted and performs the following:
1. Creates the Bank deposit Tape Workfile (P065501) |
F063501 F065506 | F065506 F065516 |
| Print Net Pay Instructions (P06230) | Controls the printing of Net Pay Instructions as necessary. | F063501 | F063501 |
The following chart presents a technical overview of the payroll journal entries step of the payroll cycle.
| Step | Explanation | Tables Read | Tables Updated |
|---|---|---|---|
| Benefit/Accrual Calculation (P062012) | Calculates remaining benefits and accruals associated with the employee. | F060116 F0609 F06146 F06145 | F0609 |
| Paycheck Workfile Supplemental (P063503) | Calculates remaining detailed transactions to be used to generate various reports and files. | F0609 | F063501 F063502 |
| Establish Batch for Payroll Journals (P062902) | Creates a batch of payroll journal entries. | F06210 | F06210 F0011 |
| Workers Compensation/ General Liability Journal Entries (P062902) | Calculates workers compensation and general liability premiums and generates all payroll journal entries for those employees being processed. Creates a member equal to the batch number within your production physical file. | F06116 F0609 F06126 F063501 | F06290 F0624 (Optional) |
| Payroll Intercompany Settlements (P062907) | Determines if Intercompany Settlements should be created based upon the employee's home company and where that employee's journal entries were posted. | F06290 | F06290 |
| Summarize Detail Journal Entries (P06228) | Summarizes all detailed journal entry transactions to the level requested. Creates a member equal to the batch number within the production physical file. | F06290 F06901 | F06395 |
| Journal Batch Proof/Edit (P06229) | Creates the Journal Batch Proof report and edits for error conditions. | F06395 F0901 | F0011 |
| A/P Integration (J06498JQ) | Determines whether accounts payable integration is in effect, based on the A/P flag in company constants. | ||
| A/P Batch Setup (P064901) | Creates batch header for the current payroll cycle, deletes the previous batch header, and clears the work files if you reran an existing payroll ID. | F06210 F06491 F06492 F06490 | F06210 F06491 F06492 F06490 |
| A/P Detail Workfile Build (P06490) | Builds the A/P voucher detail work file. | F069096 F06210 F06926 F06927 F069086 F069016 F06904 F063501 F0609 F060116 | F06490 |
| A/P Summary Workfile Build (P064902) | Builds the A/P voucher summary file. | F06927 F069086 F0626 F06490 | F06492 F06491 |
| A/P Journal Voucher Creation (P064904) | Creates the batch proof journal entries for A/P vouchers. | F06490 | F06290 |
| A/P Journal Compression (P064228) | Summarizes journal entries and prints the Journal Batch Proof report (P06229). Updates the A/P status flag (P062101). | F06914 F069116 F06290 F06395 | F06395 F06210 |
| Update Status Flag (P062101) | Moves 1 to the Status Code field for Journal Entries on the Pay Cycle Review/Reset screen. | F06210 | F06210 |
The following chart presents a technical overview of the Final Update step of the Payroll Cycle.
| Step | Explanation | Tables Read | Tables Updated |
|---|---|---|---|
| Update employee history tables (P063901) | Updates the employee history files and prints the Employee Update Report (R063901). Deletes all work file records, except F06126 and F063501, which are held in the PAYRLxxx library. Also updates the auto deposit pre-note flag in the Employee Master table. | F06116 F0609 F06126 F063501 F06126I F06350I F08370 F08371 | F06136 F06146 F06145 F06156 F06166 F06148 F0618 F0619 F0623 F06053 F060531 F0626 F06107 F0607 F06106 F06226 F06216 |
| Update General Ledger (P06395) | Generates General Ledger transactions. | F06395 | F0911 |
| Post General Ledger (P09870) | Updates balance records in General Ledger. | F0911 | F0902 |
| Update Integrity table (P063911) | Updates Payroll Integrity table. | F063501 | F0620 F06502 |
| Update Employee Master (P06394) | Updates future changes to Employee Master data. | F06042 | F060116 |