Examples of Delivered COA Inferences

Key Fields

Page

Inferred Fields

Fiscal Year

Fund

Department

Activity

Function

This page allows you to define a Fund as well as an optional Program to infer.

Activity Inference (ACTINF)

Fund

Program

Fiscal Year

Fund

Department

Unit

Object

This inference page is one loaded by the creation of a budget line on certain budget structure and levels so that the powerful inference happens. While it could infer any Budget Fiscal Year, the intention (and automatic population) is to infer only the special year of 9999.

Appropriation and BFY Inference (APBYINF)

Appropriation

Budget Fiscal Year

Fiscal Year

Fund

Department

Unit

Object

Activity

This inference page is one loaded by the creation of a budget line on certain budget structure and levels so that the powerful inference happens. While it could infer any Budget Fiscal Year, the intention (and automatic population) is to infer only the special year of 9999.

Appropriation and BFY Inference with Activity (APBYINF2)

Appropriation

Budget Fiscal Year

Budget Fiscal Year

Fund

Department

Unit

Object

This inference page is one loaded by the creation of a budget line on certain budget structure and levels so that the powerful inference happens.

Appropriation Inference (APPRINF)

Appropriation

Budget Fiscal Year

Fund

Department

Unit

Object

Activity

This inference page is one loaded by the creation of a budget line on certain budget structure and levels so that the powerful inference happens.

Appropriation Inference with Activity (APPRINF2)

Appropriation

Fiscal Year

Department

Function

Object Type

This page allows you to define an Appropriation to infer and is not populated with the creation of a budget line.

Appropriation Unit Inference (APPRUINF)

Appropriation

Budget Fiscal Year

Fund

Department

Unit

Revenue

This inference page is one loaded by the creation of a budget line on certain budget structure and levels so that the powerful inference happens.

Revenue Source Appropriation Inference (RSAPRINF)

Appropriation

Fiscal Year

Department

Unit

Sub Unit

This inference page allows the inference of the Appropriation based on the combination of Department, Unit, and Sub Unit. This inference will only populate a blank field as it is not a powerful one.

Unit Sub Unit Appropriation Inference (USAPPINF)

Appropriation

Fiscal Year

Fund

Department

Appropriation

This inference page is one loaded by the creation of a budget line on certain budget structure and levels so that a powerful inference happens. While it could infer any Budget Fiscal Year, the intention (and automatic population) is to infer only the special year of 9999.

Budget Fiscal Year Inference (BFYINF)

Budget Fiscal Year

Fiscal Year

Fund

Department

Unit

Revenue

This inference page is one loaded by the creation of a budget line on certain budget structures and levels so that a powerful inference happens with BFY 9999 so that users do not have to enter the year to match a revenue budget line. While it could infer any Budget Fiscal Year, the intention (and automatic population) is to infer only the special year of 9999.

Revenue BFY Inference (BFYINFRV)

Budget Fiscal Year

Fund

Sub Fund

This inference page allows the inference of the multi-year BFY value of 9999 when one of the inferences pages created through budget line creation is not used.

Budget Fiscal Year Inference by Fund and Sub Fund (BFYINFSF)

Budget Fiscal Year

Object

This inference page allows the inference of Appropriation from Object when one of the inferences pages created through budget line creation is not used.

Object Appropriation Inference (APOBJINF)

Appropriation

Revenue

This inference page allows the inference of Appropriation from Revenue when one of the inferences pages created through budget line creation is not used.

Revenue Appropriation Inference (APREVINF)

Appropriation

Budget Fiscal Year

Fund

Sub Fund

Department

Unit

Revenue

This inference page is one loaded by the creation of a budget line on certain budget structure and levels so that the powerful inference happens.

Sub Fund Revenue Source Appropriation Inference (SFRAPINF)

Appropriation

Budget Fiscal Year

Fund

Sub Fund

Department

Unit

Object

This inference page is one loaded by the creation of a budget line on certain budget structure and levels so that the powerful inference happens.

Sub Fund Object Appropriation Inference (SFOAPINF)

Appropriation

Fiscal Year

Fund

Sub Fund

Department

Unit

Object

This inference page is one loaded by the creation of a budget line on certain budget structure and levels so that the powerful inference happens. While it could infer any Budget Fiscal Year, the intention (and automatic population) is to infer only the special year of 9999.

Sub Fund Object Appropriation and BFY Inference (SFOABINF)

Appropriation

Budget Fiscal Year

Fiscal Year

Department

Location

Activity Category

This page allows you to define a Unit to infer.

District/Location Unit Inference (DILOUINF)

Unit

Transaction Code

Fiscal Year

Fund

Sub Fund

This inference page is not ready by all types of transactions and is used solely in the Treasury Accounting area of CGI Advantage to supply organizational chart of accounts for the Pool Fund Investment Earnings (PFIE) transaction and the journal voucher transactions created by the Cash Sweep and Income Allocation system processes.

Infer Department and Unit (INFDU)

Department

Unit

Fiscal Year

Department

Department Object

This inference page is allows for the powerful inference of the system-wide Object based on a Department Object when there is a 1:1 or 1:n relationship between Object and Department Object.

Object Inference (OBJINF)

Object

Fiscal Year

Department

Object

This inference page allows for the weak inference of the Department Object based on the system-wide Object when there is a 1:1 or 1:n relationship between Department Object and Object. The travel transactions are a common area for use of this page as there is only the inference of an Object from an Expense Type.

Department Object Inference (DOBJINF)

Department Object

Fiscal Year

Department

Department Revenue Source

This inference page is allows for the powerful inference of the system-wide Revenue Source based on a Department Revenue Source when there is a 1:1 or 1:n relationship between Revenue Source and Department Revenue Source.

Revenue Source Inference (RSRCINF)

Revenue Source

Fiscal Year

Department

Unit

Transaction Category

This inference page allows the inference of one or more chart of account fields based on organizational information and the type of transaction. This inference will only populate a blank field as it is not a powerful one.

Organizational Inference (ORGINF)

Fund

Sub Fund

Function

 Activity

Program

Location

Fiscal Year

Department

Unit

This inference page allows the inference of one or more chart of account fields based on organizational information, without respect to the Transaction Category as with the Organizational Inference (ORGINF) page.  This inference will only populate a blank field as it is not a powerful one. The system will read ORGINF before it reads ORGINF2, meaning that if the same COA fields are used on matching records on both pages, the value to be inferred from ORGINF will be placed on a transaction. When there are matching records, only COA fields used on ORGINF2 that are not used on ORGINF will be placed on a transaction.

Organizational Inference 2 (ORGINF2)

Appropriation

Function

Activity

Program

Budget Fiscal Year

Fund

Department

Unit

This inference page allows for the powerful inference of Appropriation based on the combination of Department, Unit, and Fund. This inference page is one loaded by the creation of a budget line on certain budget structures and levels so that the powerful inference happens.

Organizational Appropriation Inference (ORGAPINF)

Appropriation

Fiscal Year

Department

Function

This inference page allows the inference of one or more chart of account fields based on function. Of note, a field for Function Type is available and inferred to define Configurable Rules stating what fields should be completed to provide controls when needed that vary by ‘type of function’.

Function Inference (FUNCINF)

All COA

Debt ID

Budget Fiscal Year

Budget Fiscal Year

Appropriation Unit

This inference page is one loaded by the creation of a budget line on certain budget structure and levels so that the powerful inference happens.

Fund Sub Fund Inference (FSFINF)

Fund and Sub Fund

Accounting Template ID

This page is used to create templates of chart of account elements. Unlike other smaller more targeted inferences, this one has all chart of accounts plus Debt ID, Fiscal Year, and Budget Fiscal Year. The Accounting Template is the very last inference done on a transaction and values are inferred only into blank fields. Budget Fiscal Year and Fiscal Year are exceptions in that they are powerful inferences and happen only on a new transaction line and only happen if there is no reference to another line.

Please be aware that templates with a year defined to them where the year is not part of the Template ID, changing that year to the following year will mean that users will have to manually make updates on transactions to match the prior year for accruals that have no reference.  A year worked into the Template ID enables two different records with different COA.  With this latter method, interfaces will have to be updated with the new value and know to use the old value when impacting the prior year.

Accounting templates are also found on other reference data pages to facilitate data entry such as Internal Vendor Accounting (IVAD) and Procurement User (USER) to name a few.

The first Department field is not a key field, so that the same Accounting Template ID can be used with multiple Departments, but exists for row-level security and row filtering.

The page contains a number of additional fields that are initially hidden but can be made visible:

• A set of fields tracking who and when a template was created by and created on as well as a pair of fields tracking last modification.

• There are five flags available to classify templates as needed for interfaces.

• Two active dates are available to define a date range when interfacing templates to a 3rd party system such as a payroll system. The dates can also be used to track any event necessary with a template and not an active range. Because the dates are open to any use, there are no edits other than a valid date, so if used as active dates, a Configurable Validation should be added to ensure the ‘to’ is after the ‘from’. Furthermore, the application will view a template as invalid if used out of those dates.

Accounting Template (ACTPL)

All COA

Debt ID

Budget Fiscal Year

Fiscal Year