Go To View:  RETURN TO BANNER COMP META DATA REPORTS LIST


Finance Composite View Meta Data Reports

Target Reports:

Composite ViewDescription
AF_ACCOUNT_ATTRIBUTES_ODS
Source composite view contains all the attributes (sets, types, values) associated with an account code.
AF_ACCOUNT_HIERARCHY
Source composite view contains the account hierarchy.
AF_ACCOUNT_HIERARCHY_FISCAL
Source composite view contains the account hierarchy by fiscal year and fiscal period. The composite view build is controlled by a parameter setting with an Internal Group = 'ODS EXTRACT PARAMETERS', Internal Code 1 = 'HIERARCHY_FISCAL'. The External Code should be set to the first fiscal year that was posted in the system or to the first fiscal year that you want the original hierarchy to display. The Description value will control how far out to build the view for a fiscal year/period as of today. If the value is set to 2, the system builds the fiscal year/periods 2 years past today's date.
AF_ACCOUNT_INDEX
Source composite view contains account index.
AF_ACCOUNT_TYPE_ATTRIBUTES_ODS
Source composite view contains all the attributes (sets, types, values) associated with an account type code.
AF_ACTIVITY_ATTRIBUTES_ODS
Source composite view contains all the attributes (sets, types, values) associated with an activity code.
AF_ATTRIBUTE_SETS_ODS
Source composite view contains all the attributes (types, values) associated with a chart of accounts code and set code.
AF_BUDGET_AVAILABILITY_LEDGER
Source composite view contains detailed information on available budget.
AF_BUDGET_DETAIL
Source composite view contains detailed budget information, including change history.
AF_CHART_ATTRIBUTES_ODS
Source composite view contains all the attributes (sets, types, values) associated with a chart of accounts code.
AF_CHECKS
Source composite view contains information about a processed check from accounts payable.
AF_CLAUSE
Contains text lines associated to a clause number.One row per clause per each line of text.
AF_ENCUMBRANCE
Source composite view contains general information on encumbrance item.
AF_ENCUMBRANCE_ACCOUNTING
AF_ENCUMBRANCE_LEDGER
Source composite view contains encumbrance ledger information.
AF_ENDOWMENT
Source composite view contains endowment funds and their associated information including associated pool.
AF_ENDOWMENT_ATTRIBUTES
Source composite view contains information on the user defined attributes for endowments.
AF_ENDOWMENT_DIST
Source composite view contains endowment distribution and its associated information.
AF_ENDOWMENT_MARKET_VALUES
Source composite view contains information on the purchase price for endowment pools by period and actual valuation and unitization dates.
AF_ENDOWMENT_UNITS
Source composite view contains endowment fund unitization history.
AF_FISCAL_PERIOD
This view returns rows of fiscal periods for each fiscal year.1 row per fiscal year per fiscal period.
AF_FIXED_ASSET_ADJUSTMENT
Source composite view contains detailed information on the adjustments of fixed assets.
AF_FIXED_ASSET_ATTRIBUTES
Source composite view contains detailed information on fixed assets user defined attributes.
AF_FIXED_ASSET_DEPRECIATION
Source composite view contains detailed information on fixed assets depreciation and capitalization information.
AF_FIXED_ASSET_FUNDING_SOURCE
Source composite view contains detailed information on fixed assets fund source accounting.
AF_FIXED_ASSET_ITEM
Source composite view contains detailed information on fixed assets items.
AF_FUND_ATTRIBUTES_ODS
Source composite view contains all the attributes (sets, types, values) associated with a fund code.
AF_FUND_HIERARCHY
Source composite view contains the fund hierarchy.
AF_FUND_HIERARCHY_FISCAL
Source composite view contains the fund hierarchy by fiscal year and fiscal period. The composite view build is controlled by a parameter setting with an Internal Group = 'ODS EXTRACT PARAMETERS', Internal Code 1 = 'HIERARCHY_FISCAL'. The External Code should be set to the first fiscal year that was posted in the system or to the first fiscal year that you want the original hierarchy to display. The Description value will control how far out to build the view for a fiscal year/period as of today. If the value is set to 2, the system builds the fiscal year/periods 2 years past today's date.
AF_FUND_TYPE_ATTRIBUTES_ODS
Source composite view contains all the attributes (sets, types, values) associated with a fund type code.
AF_GENERAL_LEDGER
Source composite view contains general ledger information.
AF_GRANT
Source composite view contains grants and their associated information.
AF_GRANT_ATTRIBUTES_ODS
Source composite view contains all the user defined attributes associated with a grant code.
AF_GRANT_BILLING_DETAIL
Source composite view contains research accounting billing transaction details.
AF_GRANT_DEFERRED_COST
Contains details behind the postings for grant deferred costs of indirect cost, cost share and revenue. The source document information and posting document information that supports the calculations of the costs.Multiple rows per grant ID.
AF_GRANT_EVENT
Source composite view contains grant events and associated information.One row per grant ID per grant event.
AF_GRANT_EVENT_STATUS
Source composite view contains grant events status periods and associated information.One row per grant id per grant event per grant event sequence number.
AF_GRANT_FUND
Source composite view contains funds assigned to grants and their associated information.
AF_GRANT_LEDGER
Source composite view contains detailed grant activity information by grant period.
AF_GRANT_PERSONNEL
Source composite view contains grant personnel and associated information.
AF_INVOICE
Source composite view contains information on invoices.
AF_INVOICE_ACCOUNTING
Source composite view contains accounting information for an invoice.
AF_INVOICE_CHECK
Source composite view contains check information for invoices.
AF_INVOICE_ITEM
Source composite view contains item level detailed information on invoices.
AF_INVOICE_TAX_RATE
Source composite view contains tax rate information for invoices.
AF_LOCATION_ATTRIBUTES_ODS
Source composite view contains all the attributes (sets, types, values) associated with a location code.
AF_LOCATION_HIERARCHY
Source composite view contains the location hierarchy. The composite view build is controlled by a parameter setting with an Internal Group = 'ODS EXTRACT PARAMETERS', Internal Code 1 = 'HIERARCHY_FISCAL'. The External Code should be set to the first fiscal year that was posted in the system or to the first fiscal year that you want the original hierarchy to display. The Description value will control how far out to build the view for a fiscal year/period as of today. If the value is set to 2, the system builds the fiscal year/periods 2 years past today's date.
AF_LOCATION_HIERARCHY_FISCAL
Source composite view contains the location hierarchy by fiscal year and fiscal period.
AF_OPERATING_LEDGER
Source composite view contains detailed information for the operating ledger.
AF_ORGANIZATION_ATTRIBUTES_ODS
Source composite view contains all the attributes (sets, types, values) associated with an organization code.
AF_ORGANIZATION_HIERARCHY
Source composite view contains the organization hierarchy.
AF_ORGN_HIERARCHY_FISCAL
Source composite view contains the organization hierarchy by fiscal year and fiscal period. The composite view build is controlled by a parameter setting with an Internal Group = 'ODS EXTRACT PARAMETERS', Internal Code 1 = 'HIERARCHY_FISCAL'. The External Code should be set to the first fiscal year that was posted in the system or to the first fiscal year that you want the original hierarchy to display. The Description value will control how far out to build the view for a fiscal year/period as of today. If the value is set to 2, the system builds the fiscal year/periods 2 years past today's date.
AF_PROGRAM_ATTRIBUTES_ODS
Source composite view contains all the attributes (sets, types, values) associated with a program code.
AF_PROGRAM_HIERARCHY
Source composite view contains the program hierarchy.
AF_PROGRAM_HIERARCHY_FISCAL
Source composite view contains the program hierarchy by fiscal year and fiscal period. The composite view build is controlled by a parameter setting with an Internal Group = 'ODS EXTRACT PARAMETERS', Internal Code 1 = 'HIERARCHY_FISCAL'. The External Code should be set to the first fiscal year that was posted in the system or to the first fiscal year that you want the original hierarchy to display. The Description value will control how far out to build the view for a fiscal year/period as of today. If the value is set to 2, the system builds the fiscal year/periods 2 years past today's date.
AF_PROPOSAL
Source composite view contains information for each proposal.
AF_PURCHASE_ORDER
Source composite view contains cumulative information for purchase orders.
AF_PURCHASE_ORDER_ACCOUNTING
Source composite view contains cumulative accounting information for purchase orders.
AF_PURCHASE_ORDER_ITEM
Source composite view contains the cumulative line item detail for each purchase order.
AF_PURCHASE_ORDER_TAX_RATE
Source composite view contains cumulative tax rate information for purchase orders.
AF_RECEIVED_ITEM
Source composite view contains information on received/returned items.
AF_RETURNED_ITEM
Contains returned purchase order item information.
AF_TEXT
Source composite view contains detailed information on text lines associated with documents/entities.
AF_TRANSACTION_HISTORY
Source composite view contains all source detail transactions used to update the ledgers.
AF_VALIDATION
Source composite view contains a number of the source systems' validation table records. This view was meant to be used with reporting tools to create list of values as well as for cleansing purposes in the Enterprise Data Warehouse.
AF_VENDOR
Source composite view contains information on all vendors.One row per vendor.
AF_VENDOR_TAXABLE_REPORTING
Contains taxable income paid to a vendor that is reportable to a federal government such as tax id, name, address, reportable amount, income type, souce of income document, check number, bank, any monies withheld for federal or state.One row per vendor uid per vendor tax id per tax year per check number per bank code per document.

Source Reports:

CALCULATION
CALCULATION
CONSTANT
FAB1099
FABBKTP
FABCHKS
FABINCK
FABINVH
FABRUIV
FARINTX
FARINVA
FARINVC
FBBBLIN
FBRAUDT
FFBADJH
FFBMAST
FFRADJA
FFRADJD
FFRFUSN
FFRMASA
FFRMASF
FFVACON
FFVACQM
FFVDISP
FFVSDAT
FFVTTST
FGBBAVL
FGBENCD
FGBENCH
FGBENCP
FGBGENL
FGBOPAL
FGBTRND
FGBTRNH
FNBDSTH
FNBUNTH
FNREUSN
FNRUCTR
FNVENDW
FNVPOOL
FNVSDAT
FOB1099
FOBCLAU
FOBTEXT
FORCLAU
FPBPOHD
FPBRCDT
FPBRCHD
FPBRTRN
FPRAGRD
FPRBIDD
FPRPODA
FPRPODT
FPRPOTX
FPRRCDT
FPRREQD
FPRRTRN
FRBEVNG
FRBGBIL
FRBGRNT
FRBPROP
FRRBDET
FRREVNG
FRRGLOC
FRRGRNH
FRRGRNL
FRRGRPI
FRRGUSN
FRRMEML
FRRPLOC
FRRPRPI
FRVBASI
FRVBFRM
FRVCFDA
FRVCSTA
FRVCSTD
FRVCSTR
FRVEVNT
FRVFUND
FRVINDA
FRVINDD
FRVINDR
FRVPMSC
FRVSDAT
FTRACTA
FTRACVA
FTRATTS
FTRATTV
FTRATYA
FTRFNDA
FTRFTYA
FTRLCNA
FTRORGA
FTRPRGA
FTVACCI
FTVACCT
FTVACTL
FTVACTV
FTVASTY
FTVATTS
FTVATTT
FTVATYP
FTVBUYR
FTVCOAS
FTVCOMM
FTVCTYP
FTVDEPR
FTVDISC
FTVDTYP
FTVFMGR
FTVFOBS
FTVFSPD
FTVFSYR
FTVFTRM
FTVFTYP
FTVFUND
FTVHRSN
FTVITYP
FTVLOCN
FTVOBPH
FTVOBUD
FTVORGN
FTVPCLS
FTVPROG
FTVPROJ
FTVRCMT
FTVRRSN
FTVRUCL
FTVSDAT
FTVSHIP
FTVTGRP
FTVTRAT
FTVUOMS
FTVVEND
FTVVENT
FTVVTYP
FUNCTION
FUNCTION
NA
SPRADDR
SPRIDEN
STVCNTY
STVNATN
STVSTAT


Ver: