Even if a data element has been selected in the prior

Last Updated: 11/02/2006
Page 24 of 38

Financial Data Warehouse
Training Guide
Ledger Data Extracts
The Budget Ledger
Extracts are run against the budget ledger data for any month or sequence of months in the current or a
prior fiscal year.
Data elements included in the extract are selected by the user from a list of values. Possible elements
include the agency, the account type, the fund, the fiscal period, the transaction line description, the
organization, the object code, the posting date, the transaction amount, the transaction code and/or the
transaction number. Many additional data elements are available. Those listed are the default values.
Last Updated: 11/02/2006
Page 25 of 38

Financial Data Warehouse
Training Guide
Data elements that may be used as search criteria include the fund, the agency, the organization, and the
account type as the default search criteria elements. Additional search elements include the
appropriation unit, the budget year, the transaction line description, the object code, the posting date, the
revenue source code, the transaction amount, the transaction code, the transaction date, and/or the
transaction number.
The General Ledger
Extracts are run against the general ledger data for any month or sequence of months in the current or a
prior fiscal year.
Data elements included in the extract are selected by the user from a list of values. Possible elements
include the agency, account type, the fund, the fiscal period, the transaction line description, the
organization, the object code, posting date, sub-object code, the transaction amount, the transaction
code, the transaction number, the vendor name, and the vendor number. Many additional data elements
are available. Those listed are the default values.
Data elements that may be used as search criteria include the fund, the agency, the organization, and the
account type as the default search criteria elements. Additional elements include the activity code, the
appropriation unit, the balance sheet account, the budget year, the transaction line description, the object
code, the posting date, the reference transaction code, the reference transaction number, the revenue
source code, the sub-object, the sub-revenue source code, the transaction amount, the transaction code,
the transaction date, the transaction number, the vendor name, and/or the vendor number. Many other
data elements are available.
Fixed Assets Custom Query
Fixed Assets Custom Query is designed to provide an easy, intuitive method to select data elements to
include in an extract, enter various search criteria, extract the data in a format that is compatible with
Microsoft EXCEL, and download the extract to your PC.