laborEncumbranceAdjustmentJob

Overview

The laborEncumbranceAdjustmentJob generates salary encumbrance transactions based on the salary information provided by the institutions payroll system. Encumbrance entries are calculated by comparing the current internal encumbrance stored in the labor ledger against the full encumbrance amount being sent by the institutions payroll at the employee and position level.

The input file and the output file are in the Labor Ledger Flat File Format. 

• The input file is placed in the staging/ld/encumbranceAdjustment directory and is processed by the laborEncumbranceAdjustmentJob which creates .data, .recon and .done files that are placed in the staging/ld/enterpriseFeed directory. These files are processed by the laborEnterpriseFeedJob. Transactions are created based on the following: 

• • Find a matching record in the Labor Ledger Balance Table based on the Fiscal Year, Balance Type (IE), Employee ID and position number.

    • If a match is not found, create an encumbrance transaction.

    • If a match is found and the accounting string (Chart, Account, Sub-Account, Object and Sub-Object) is different, liquidate the previous encumbrance and establish the new encumbrance using the new accounting string.

    • If the labor ledger balance annual amount is less than the payroll transaction amount, create an encumbrance transaction for the difference.

    • If the encumbrance transaction exists in the Labor Ledger from the previous run and the corresponding full encumbrance does not exist then the entire line of encumbrance will be liquidated in the Labor Ledger.

Parameters

The following parameters are used by the laborEncumbranceAdjustmentJob:

• ORIGINATION_CODE: Origination code used on the labor ledger entries created by the LaborCalculateEncumbranceAdjustmentsJob.

Reports and Files

Directory	Name	Description
reports/ld	laborEncumbranceAdjustmentReport-<datetimestamp>.txt	Summarizes the input and output processed and created by the laborEncumbranceAdjustmentJob
staging/ld/encumbranceAdjustment	name of file dropped by the institution	Location where the encumbrance input file is placed.
staging/ld/enterpriseFeed	ENCUMBRANCE_DATA_<userid>_<datetimestamp>.dat	Input file processed by the laborEncumbranceAdjustmentJob
staging/ld/enterpriseFeed	ld_encumb_out-<datetimestamp>.data ld_encumb_out-<datetimestamp>.recon ld_encumb_out-<datetimestamp>.done	Output files created by laborEncumbranceAdjustmentJob and processed by laborEnterpriseFeedJob. The .done file is deleted after processing.
staging/ld/enterpriseFeed	ld_encumb_err-<datetimestamp>.data	Error file of any transactions that could not be processed by the laborEncumbranceAdjustmentJob.