laborBalancingJob and laborBalancingHistorySyncJob

Overview

Similar to the General Ledger process described in the posterBalancingJob an automated balancing process and report helps verify balance and entry transactions processed through the Kuali Financials Labor Ledger. 

The job uses parameters to determine which fiscal years to include and how many failures to print on the report, refer to Labor Parameters for additional information. 

The job also generates a report, called laborBalancing, located in the reports/ld directory. It is described in detail below. 

laborPosterBalancingJob

The first time the laborPosterBalancingJob runs it populates entry, encumbrance and balance history tables that future runs of the job will use. From then on, each time the job updates the history tables, it includes entries from the most recent batch cycle.

The job compares the calculated history table amounts and row counts back to the production Labor Ledger counts and balances. Discrepancies are reported along with summary statistics for row counts and errors.

laborPosterBalancingHistorySyncJob

The laborPosterBalancingHistorySyncJob is unscheduled and can be run to sync the history tables with production tables. This job is normally run after errors are detected and resolved. When there are errors, the labor scrubber and poster batch reports can be used to determine where the problem(s) might lie. 

Labor Ledger Balancing Report

The Labor Ledger Balancing Report (reports/ld/laborBalancing) lists errors found while comparing the history labor tables with the production labor tables. It also lists the files it uses for the comparison and row count statistics.

Comparison Errors

An error section is displayed for each history table that failed to balance. Detail is displayed for each error, up to the number specified in COMPARISON_FAILURES parameter.  The report includes the total number of errors, but details are shown only up to the number of errors specified in this parameter. 

Files used to update the history tables

Files used from the most recent batch cycle to update the history labor ledger tables in order to compare with production labor ledger tables. 

Statistics

Statistics are described below.

Labor Ledger Balancing Report information

Statistic Label	Description
FISCAL YEARS INCLUDED IN BALANCING	Specifies the years included in the automated labor comparisons. The PAST_FISCAL_YEARS parameter controls the number of past fiscal years included.
HISTORY TABLES INITIALIZED—UPDATES SKIPPED	If this is the first run of the laborBalancingJob, the value is Yes. This value indicates that the history tables required for future runs of the automated balancing report have been created. During subsequent balancing (after the tables have been initialized), the value is No.
OBSOLETE HISTORY DELETED	If a given fiscal year in the history tables is not in the range of years included in balancing, this value identifies the fiscal years that have been removed. If no fiscal years were removed, the value is No.
UPDATES SKIPPED DUE TO OUT OF RANGE FISCAL YEAR	If the most recent Labor nightly batch cycle included entries for fiscal years that are not in the range of years to be included in balancing, this value indicates how many updates to the balancing tables were skipped due to out-of-range fiscal year entries.
LLEN AMOUNT FAILURES (LaborEntryHistory)	The number of entries in the production Labor Ledger Entry table that failed to match those in the history Labor Entry table.
LLBL AMOUNT FAILURES (LaborBalanceHistory)	The number of entries in the production Labor Ledger Balance table that failed to match those in the historyLabor Balance table.
LLEN SUM (ROW COUNT) - CALC. (LaborEntryHistory)	The calculated row count from the Labor Entry History table. This number equals the number of entries in the history table prior to the most recent batch cycle plus the number of entries from the most recent batch cycle.
LLEN ROW COUNT - PROD.	The number of rows in the production Labor Ledger Entry table. This number should match the LLEN SUM CALC row count from the history table.
LLBL ROW COUNT - CALC. (LaborBalanceHistory)	The calculated row count from the Labor Balance History table. This number equals the number of previous History table balance entries plus the number from the most recent batch cycle.
LLBL ROW COUNT - PROD.	The number of rows in the Labor Ledger Balance table. This number should match the LLBL ROW COUNT calculated from the history tables.