Chain Jobs

The chain jobs are listed alphabetically in the table below. For detailed information on the jobs (such as when to run, input, output, and process parameters) refer to the associated run sheet in the following guide: CGI Advantage Cost Accounting Run Sheets or any other run sheet specified.

Job Name

Description

Cost Accounting Archive

This system process is used to remove system setup and processing details from the application for cost accounting entities (defined at the Major Program, Program, and Task Order chart of accounts) that have completed for enough time to meet statutory requirements and procedures for data retention. The run sheet is a Utilities Run Sheet.

Cost Allocation

This system process is documented in the Cost Allocation User Guide.

Cost Allocation Multi Process

This system process is documented in the Cost Allocation User Guide.

Credit Memo Multi Thread Chain

This system process allows you to generate Journal Vouchers to transfer funds from the central fund to the Federal grant fund to cover the difference between draw amount and disbursement amount for credit memo transactions. The process also reverses these adjustments by generating another Journal Voucher when the credit memo is adjusted as part of subsequent disbursement to the vendor through AD Chain.

Encumbrance Reclassification

This system process is used to re-evaluate the impact of an encumbrance that has likely been recorded against a part of a Major Program’s funding structure that is not where new transactions are updating because of funding changes or the encumbrance aging. The process backs-out and reprocesses all outstanding encumbrance balances in a fashion similar to what occurs during Reclassification.

FHWA Cleanup

This system process is run to fix certain issues with the electronic file created for FHWA when it has been rejected from FMIS so that just the corrected is sent back instead of re-running the Reimbursement Output Process. If this cleanup results in any records moved from Reimbursement History to Reimbursement Request, then the original Receivables created will be modified and a new file will be created.

FHWA FMIS Extract Process

This process generates the project extract (XML) for obligating the project in FHWA FMIS application. The FHWA FMIS Extract process identifies submitted budget transactions and queries for Project information in several setup tables. The data is further organized to build the final FHWA FMIS XML files.

FMIS Load Process

This process parses the data from FMIS received through XML file and loads the same to FMIS database tables. The process also advances workflow for the associated budget transactions from workflow level to final.

Internal Costing

This system process is documented in the Internal Costing User Guide.

Overhead Rate

This system process selects those direct costs eligible for overhead for those Major Programs allowed overhead by one or more funding sources. To those costs a pre-defined percentage is applied and Charge transactions generated to record the overhead for the next reimbursement selection.

Program Asset Generation

This system process performs to primary tasks. The first is the selection of costs eligible for capitalization that are then recorded in online inquiries for review. The second is taking those reviewed records online and creating Fixed Asset transactions that increase, change the Fixed Asset Type, or cancel Fixed Asset Components.

Reclassification

This system process locates reimbursement budget line conditions where there is other funding available than where there is current spending, and then submits modification transactions, determined from the Funding Split Log, where posting lines backout of where they were originally recorded and rebook under new funding. The other funding can be completely new funding (e.g. new funding profile) or in a Funding Priority prior to the one currently being spent from.

Reimbursable Expense Adjustment

A process exists within Advantage Financial which helps to prevent the creation of a reimbursement request that exceeds the reimbursement limits by:

  • Providing a reporting mechanism to identify those reimbursable Funding Line budgets with an awarded amount that does not reflect Funding Line setup and where the amount of costs at the Funding Line level exceeds the awarded percentage.

  • Creating a corrective transaction if the Awarded amount has been exceeded in a manner that provides a complete audit trail and is reflected in the reimbursement request.

Reimbursement

This process, also known as Reimbursement Selection and Generation, reviews accounting activity since the last run and existing activity in suspense using the Reimbursement Selection Parameter ID specified (see System Processing under Reference Pages). The eligible activity for Back End Split Major Programs is placed on Charge transactions to record that split. The eligible activity for Front End Split Major Programs is transferred for later Reimbursement Output processing. Any new suspended activity is logged as such for later review.

Reimbursement Output

This system process performs a series of tasks. The first is the creation of Receivable, Cash Receipt, and Internal Exchange Transactions to record reimbursement accounting for both regular reimbursement and Streamlined Task Order Billing. Those transactions are then logged on the Reimbursement History inquiry page.

The second is the generation of electronic billing files for external customers. Currently, the FHWA electronic file is the only file produced. All the selected records in the current run and corrected records (that is, the records rejected by FHWA (FMIS) from any previous Reimbursement cycle) are summarized based on FHWA attributes and copied to the current (new) FHWA Electronic file.

Reimbursement Request Recycling

This system process is run when a portion of a reimbursement request has been denied. The portion that was denied is identified in a Reimbursement Request Recycling record so the process can move the records to Reimbursement Hold until corrective actions are taken. Additionally, modifications of transactions created from Reimbursement Output are processed.

Update Assistance Listing Numbers

This system process updates existing records in, and adds records to the Assistance Listing Number reference page based on data published at https://sam.gov/content/assistance-listings. The expected input file is the comma-separated value (CSV) file provided daily at ftp://ftp.cfda.gov.

Warrant Reclassification

This process allows you to reclassify warrant payable balances to match the Reimbursement Reclassified posting of a disbursement. This process should be used if the standard warrant disbursement model is used in conjunction with front-end split.