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