Finance Reporting Views

FTVFUND_CURRENT_REC_V (webfocus_view_owner) - Fund information - This is simply a copy of FTVFUND with logic to only get active fund records.

FTVORGN_CURRENT_REC_V (webfocus_view_owner) - Organization Information - This is a copy of FTVORGN with logic to only get greatest effective dated record (i.e. the most up to date record).

BS_ORGN_HIERARCHY_MGR_QRY (webfocus_view_owner in prod)  - Organization Hierarchy - This shows the full roll up of organizations from level 5 (department) to level 1 (division).  We don't really use level 4.  And I don't have a better name for level 3.  It includes the organization name, chart, and each entity's fund manager.

BS_FUND_HIERARCH_MGR_QRY (webfocus_view_owner in prod) - Fund Hierarchy - This shows the full roll up of funds, their chart, fund name, financial manager, and default organization.  We don't really use the roll up of funds for reporting.  But the other details provided make this a useful view.

BS_DATES (webfocus_view_owner) - Generic Dates - If you HDATE the key field and HDATE a date field from Banner, joining them together, you can easily get things like the week of the year, quarter, fiscal year, fiscal quarter, and a host of other date information that could make some reports easier to write.

The "Finance Manager" tables are refreshed on the hour (i.e. this is everything on this list: https://banneraux.appstate.edu:9013/metadata/Finance_ODS_index.html). These tables, not being materialized, can take a while to return results depending on which one you use and how much data you are trying to pull. However, they are as up to date as the last hour refresh.

The materialized views (ASU_OPERATING_LEDGER_MV, ASU_GENERAL_LEDGER_MV) are on a separate schedule. These will return results quicker as they have already run through the functions that build the data. However, their daily periodic refreshes take longer because of that. Data can be incomplete if you query during the refreshes.

The new schedule for these two materialized views is as follows:
ASU_OPERATING_LEDGER_MV:
3:45 a.m.; 11:45 a.m.; 5:45 p.m.

ASU_GENERAL_LEDGER_MV:
4:45 a.m.; 10:45 a.m.; 6:45 p.m.