Description
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. | | |