collectorJob

Overview

The collectorJob processes files uploaded into the gl/collectorXML and gl/collector directory. These files usually come from Interdepartmental Billing units. If the files pass validation, they are converted to the General Ledger file format and placed in the staging/gl/originEntry directory for processing by the scrubberJob. 

 Collector files go through the same validation and Pre-Scrubber processes described in the scrubberJob.

For information about using the file batch upload function, see General Ledger Upload Functions.

Parameters

The following parameters are used by the collectorJob and when a file is uploaded via the online Collector Flat File Upload or the Collector XML Upload. 

• DOCUMENT_TYPES: Document types that require credits, debits and total balance as part of the collectorJob.

• DUPLICATE_HEADER_IND:  When set to Y the collectorJob will check for duplicated headers.

• EMAIL_SUBJECT_ERROR: Subject line used when the collectorJob sends an email notifying the user identified in the collector file that entries were not processed.

• EMAIL_SUBJECT_FAILURE: Subject line used when the collectorJob sends an email notifying the user identified in the collector file that the file failed to load.

• EMAIL_SUBJECT_SUCCESS: Subject line used when the collectorJob sends an email notifying the user identified in the collector file that the file was successfully uploaded.

Reports and Files

Collector files go through the same validation and Pre-Scrubber processes described for the scrubberJob.

Directory	Name	Description
staging/gl/originEntry	col_expaccts.date/time.data	Expired and closed accounts identified during data validation by the collectorJob.
staging/gl/originEntry	col_glbackup	Backup of the collector files in the origin entry directory that will be processed by the collectorJob.
staging/gl/originEntry	col_scrberr1	Error transactions identified by the collectorJob, prior to the Demerger process.
staging/gl/originEntry	col_scrberr2	Error transactions identified by the collectorJob plus valid transactions for the same document type, origin code, and document number pulled by the Demerger. These entries are not passed on to the scrubberJob. This is the most common file used by the General Ledger Correction Process document to correct errors.
staging/gl/originEntry	col_scrbout1	Valid entries identified by the collectorJob prior to the Demerger process.
staging/gl/originEntry	col_scrbout2	Valid entries after the Demerger process pulled entries for any documents with errors.
staging/gl/originEntry	col_sorterr1	Sorted col_scrberr2 file.
staging/gl/originEntry	col_sortscrb	Sorted backup data used for validation in the collectorJob and used to create the gl_glentry_coll.data and .done files for processing by the scrubberJob.
staging/gl/originEntry	gl_glentry_coll.data	Collector files converted into the General Ledger Format. A .done file is also created and when the .data file is processed, the .done file is deleted.
reports/gl	collector_date/time.txt	Summary of all files processed by the collector, a list of all errors from collector transactions, statistics for records read and in error, and an input summary of all valid transactions by balance type, origin code, fiscal year and period code.