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. |
Comments
0 comments
Please sign in to leave a comment.