This page (revision-64) was last changed on 19-Mar-2024 10:20 by Kevin Higgs

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

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
64 19-Mar-2024 10:20 113 KB Kevin Higgs to previous
63 19-Mar-2024 10:13 63 KB Kevin Higgs to previous | to last
62 19-Mar-2024 10:05 63 KB Kevin Higgs to previous | to last
61 19-Mar-2024 10:04 63 KB Kevin Higgs to previous | to last

Page References

Incoming links Outgoing links
UPPHF
UPPHF

Version management

Difference between version and

At line 62 added 113 lines
!!Processing Information
!Qualify Process
From the selection criteria, UPPHF selects pay runs according to user specified From/To Pay Period, Entity, and Payroll.
A pay run's Pay Period End date or Pay Issue date must be on the day of or prior to the user specified ‘As of’ date.
Pay runs with a Pay Run Stage of '70 - Closed' or '80 - Journalized' will be processed.
All pay headers of the qualified pay runs will be processed, pay headers may further be selected by Department, Org Level, Unit, Group, Person code etc.
As each pay header is processed, the associated database tables for this pay header will be loaded.
;:''e.g. Entity, Payroll, Unit, Group, Employment, Assignment of Pay Header, Department of Assignment, Position/Job of Assignment, Authorization Area of the applicable assignments, Organization Level of the department, Pay Period, Tax Jurisdiction, etc.''
The pay header is then further qualified by using the [IDIF] record type, 'Qualify Record'. If the 'Qualify Record' returns the value of 'BYPASS', then this pay header will be bypassed.
After the pay header is qualified, then the UPPHF Interface Level parameter is checked.
!Interface Level 01 - Pay Headers
For the interface level of ' 01 - Pay Headers', the pay header and its associated pay amounts will be processed.
Each pay header's information will be loaded.
;:''e.g.the pay header assignment, assignment's department, cost centers, position, job, authorization, organization level of department, etc.''
If the [IDIF] numeric field specifies that an element (pph value) is to be used, then the Element code should be specified in the [IDIF] Constant Value field. UPPHF calls the Element function for this element to obtain the element amount.
If the [IDIF] numeric field specifies to 'Accumulate' and/or to 'Calculate Total', then the amount will be accumulated or totaled.
If the [IDIF] field specifies a sort sequence, then the Variable Name value is also used for sorting purpose. The [IDIF] Record Type 'Detail Record' (or Rec#30 - 69) information for this pay header will then be saved in an internal PL/SQL table.
With all the pay header information, UPPHF searches from the internal PL/SQL table to group the same information together.
If the Interface File layout specifies any field that is to be reported at the employee level, e.g. Employee Name, Pay Number etc, then UPPHF will write the internal PL/SQL table to Execution Run Log table with Trace Level = '7' with the Sort Data in the context 2 field.
If the Interface File layout does not specify any field that is to be reported at the employee level, then the internal PL/SQL internal table will be used for all employees. At the end of UPPHF run, it will write the internal PL/SQL table to Execution Run Log table with Trace Level = '7' with the Sort Data in the context 2 field. Then the Execution Run Log with Trace Level '7' will be re-read and sorted by context 2 field to write to the interface file.
If the sort sequence is not used in IDIF record type 'Detail Record' (or Rec# 30-69), then UPPHF will not write to Execution Run Log, it will directly read from the PL/SQL table and write to interface file.
After UPPHF is run, you should verify from the interface directory the Interface File layout
!Interface Level 02 - Pay Headers + Pay Lines
For interface level '02 - Pay Headers + Pay Lines', all pay lines of this pay header will be processed.
Each pay line's information will be loaded.
;:''e.g. Pay line assignment, department, cost centers, position, job, authorization, organization level of department, etc. This may be different than the pay header's assignment, department, etc.''
As each pay line is processed, all of its associated pay line details will be processed.
As each pay line detail is processed, the pay component and amount of this pay line detail is retrieved.
With one pay component and amount from one pay line detail, UPPHF will process [IDIF] record type 'Detail Record' (or Record # 30 - 69 if the record type does not exist).
The [IDIF] record type 'Detail Record' (or Record# 30 - 69) Variable Names can reference to the loaded pay line detail or pay header information. e.g. Pay Period, Department, Cost Centers,etc.
If the [IDIF] numeric field specifies to retrieve a pay component value, then the pay line detail amount will be used.
If the [IDIF] numeric field specifies to use an element, then the Element code is specified in the constant value and UPPHF checks if the Pay Line Detail pay component is in this element to include the pay line detail amount or not.
If the [IDIF] numeric field specifies to 'Accumulate' and/or to 'Calculate Total', then this Pay Line Detail amount will be accumulated or totaled.
If the [IDIF] field specifies a sort sequence, then the variable name result is also used for sorting purpose.
Then the [IDIF] record type 'Detail Record' (or Rec#30 - 69) information for this pay line detail will be saved in an internal PL/SQL table.
As the next pay line detail record is processed, UPPHF will search from the internal PL/SQL table to group the same information together.
After all pay line details and pay lines are processed for one pay header, then the pay amounts of this pay header will be processed.
As each pay amount is processed, it will subtract the amount that has been processed by the pay line details and then process the remaining amount with [IDIF] the record type 'Detail Record' (or Record # 30-69).
With the pay amount information, UPPHF searches from the internal PL/SQL table to group the same information together.
After all pay amounts are processed for one pay header, UPPHF will process the internal PL/SQL table and write to the interface file.
If the Interface File layout specifies any field that is to be reported at the employee level (e.g. Employee Name, Pay Number, etc.) then UPPHF will write the internal PL/SQL table to Execution Run Log table with Trace Level = '7' with the Sort Data in the context 2 field.
If the Interface File layout does not specify the field that is to be reported at the employee level, then the internal PL/SQL internal table will be used for all employees. At the end of UPPHF run, it will write the internal PL/SQL table to Execution Run Log table with Trace Level = '7' with the Sort Data in the context 2 field.
Then the execution run log with Trace Level '7' will be re-read and sorted by the context 2 field to write to the interface file.
If the sort sequence is not used in the [IDIF] record type 'Detail Record' (or Rec# 30-69), then UPPHF will not write to execution run log, it will directly read from PL/SQL table and write to interface file.
After UPPHF is run, you should verify the Interface File layout from the interface directory.
!Interface Level 10 - Journal Entries
For the Interface Level '10 - Journal Entries', UPPHF will first process the IDIF record type 'Detail Record' for the pay header and then process IDIF record type 'Detail Level 1' for all the pay header's related journal entries.
__Record Type__: Interface File Record
__Detail Record__: This is an optional field and may generate a Header record for the pay header.
__Detail Level 1__: This is a mandatory field and will generate one entry per Journal Detail record. In this way you may generate interface records in following sequence:
;:''Pay header employee related info
;:''Journal Detail
;:''Journal Detail
;:''Journal Details
;:''Pay header employee related info
;:''Journal Detail
;:''Journal Detail
;:''Journal Detail
;:''Journal Detail
;:.'' etc''
As each journal detail is processed, UPPHF saves the IDIF information using the internal PL/ SQL table in the same manner as the '01 - Pay Headers' processing. After all journal entries are processed for one pay header, UPPHF will then process the internal PL/SQL table and write to the interface file.
!Pay Header Summary
After the interface level is processed for these levels and before writing to the Interface File, UPPHF will process [IDIF] Record Type '17-Pay Header Summary' to generate pay header related summary information for this pay header.
!Update Record
When UPPHF is run in non-trial mode, Record Type '92-Update Record' will be processed at the appropriate levels to check if the User Defined Fields (UDF) are to be updated for the associated Data Base tables.
----
This page (revision-64) was last changed on 19-Mar-2024 10:20 by Kevin HiggsTop