SFS Data Warehouse

WISDM is not the only way to get SFS data. SFS data views are also available.

  • WISDM Data View Setup & Security - (Word | HTML) this document provides information that users need to know in gaining access and using the WISDM Data Views (21-Jun-04)
  • Financial Data View Authorization Form - this form can be used to request access to the WISDM data views (8-Feb-07)
  • Hyperion Setup for WISDM Data View Access - (Word | HTML) this document provides instructions for connecting to the WISDM data base (13-June-07)
  • Setting up an ODBC connection to the WISDM Database - (Word | HTML) this document provides instructions for setting up an ODBC connection to the WISDM database. They pertain to the Windows 2000 operating system (18-Jun-04).
  • Data View Documentation - Detail documentation is available for each of the WISDM data views.
    • Detail Accounting Transactions (Word | Html) (25-June-07)
    • Summary Accounting Data (Word | Html) (18-June-04)
    • ESIS Award Accounting Data (Word | Html) (03-May-07)
    • Prior_Year_Fund Balance (Word| Html) (18-June-04)
    • Detail Payroll Transactions (Word | Html) (3-Jun-05)
    • Detail GL and Payroll Transactions (Word | Html) (25-June-07)