How to Feed Labor Ledger Transactions

Input Files (from Payroll System)

You must create a data file (flat file) and the recon file from the payroll system. The recon file contains the totals amount and count of the payroll records contained in the data file. 

Recon File Format (.recon file)

The first line (c line) contains the total number of records

The second line (s line) contains the absolute total amount fed

The third line (e line) contains the total number of lines contained in the recon file excluding this line.

c ld_ldgr_entr_t 0000000001;
s trn_ldgr_entr_amt         000000000000100.00;
e 02;

Flat File Feed Format (.data file)

Processing the Data File

There are two ways to process files.  One is to use the Labor Enterprise Feeder Batch Upload screen and the other is to FTP the files directly to the enterpriseFeed directory.

Labor Enterprise Feeder Batch Upload

The Labor Enterprise Feeder Batch Upload screen is available from the Administration menu.  Upload the Data File and Recon File to this screen with a unique File Set Identifier and click add.  The .done file is created automatically when the files are uploaded successfully.

Labor Enterprise Feeder

FTP the data file, recon file, and the .done file (0 byte file) to the staging directory called staging/ld/enterpriseFeed.  The data file, recon file, and the done files should have the same base name (e.g. File1.data, File1.recon, and File1.done).

Viewing Uploaded Files

The files are viewable from the Batch File menu of the Administration menu.

Submit the laborEnterpriseFeedJob from the batch menu.

The laborEnterpriseFeederJob produces files called d_ldentry_entp.data and d_ldentry_entp.done in the staging/ld/originEntry directory and two reports in the reports directory. Be sure to review labor_enterprise_feed_yyyymmdd-hh-mi-ss.txt file for any errors.

The reports can be retrieved from the Batch File Menu.

Labor Scrubber and Labor Poster Job

After successful completion of laborrEnterpriseFeederJob, process the enterprise feeder output file with the laborScrubber and laborPosterJob.  Upon successful completion of these jobs, you will be able to see the transactions from the Labor Ledger View screen from the Main Menu.

Labor Feed Job

To post the labor data in GL, you need to run the Labor Feed Job at the completion of labor poster job. The Labor Feed Job extracts summarized labor transactions and store them in a file in the GL staging directory for the next GL Scrubber processing.

Summarization of Labor Ledger Transaction to GL Transactions

The Labor Ledger transactions are summarized into the GL transactions when they are fed into the GL Scrubber. The summarization occurs on the following 22 separate fields.   If the rows don’t match on all these criteria the rows will not combine and you will end up in seeing the same detailed transaction in the GL Entry Table.

1. UNIVERSITY_FISCAL_YEAR
2. UNIVERSITY_FISCAL_PERIOD_CODE
3. CHART_OF_ACCOUNTS_CODE
4. ACCOUNT_NUMBER
5. SUB_ACCOUNT_NUMBER
6. FINANCIAL_BALANCE_TYPE_CODE
7. FINANCIAL_OBJECT_CODE
8. FINANCIAL_SUB_OBJECT_CODE
9. FINANCIAL_OBJECT_TYPE_CODE
10. FINANCIAL_DOCUMENT_TYPE_CODE
11. DOCUMENT_NUMBER
12. ORGANIZATION_DOCUMENT_NUMBER
13. FINANCIAL_SYSTEM_ORIGINATION_CODE
14. PROJECT_CODE
15. ORGANIZATION_REFERENCE_ID
16. TRANSACTION_LEDGER_ENTRY_DESC
17. REFERENCE_FINANCIAL_DOCUMENT_TYPE_CODE
18. REFERENCE_FINANCIAL_SYSTEM_ORIGINATION_CODE
19. REFERENCE_FINANCIAL_DOCUMENT_NUMBER
20. FINANCIAL_DOCUMENT_REVERSAL_DATE
21. TRANSACTION_ENCUMBRANCE_UPDT_CD
22. TRANSACTION_DEBIT_CREDIT_CODE

Sample Transaction File