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.