CORE - Frequently Asked Questions
Why is the data from the Operating Ledger and the Transaction Ledger sometimes not equal for my index?
When the data comes from a source that attempts to match the old FIS Data Warehouse Transaction Ledger, it only contains detail for three types of transaction documents: Invoices (INV), Journal Voucher (JV), and Cancelled Checks (CKC). Revenues and expenses recorded on Fixed Asset Adjustment documents were not included in the old FIS Data Warehouse Transaction Ledger, so if you have revenues from the sale of fixed assets, or depreciation expense, those will be in the Operating Ledger but not the Transaction Ledger. Additionally, most Facilities and Administration Costs (formerly referred to as Indirect Costs), which are automatically calculated on certain transactions, were excluded from the old FIS Data Warehouse Transaction Ledger, but are summarized in the Operating Ledger. These are the primary reasons for reconciling items between the two ledgers.
What is CORE?
CORE = Cooperative Open Reporting Environment
The CORE initiative, launched in May 2013, is a new way of working at Oregon State University; the development of a university-wide reporting environment that supports the OSU strategic plan and operations. The Business Intelligence Center (BIC) Team is responsible for CORE and ensuring the university community has access to consistent and timely data for analysis and reporting.
CORE is a web based interface from which users access the CORE Library of Reports. CORE is built on an open data architecture design concept, allowing access to data across traditional data silos. The CORE data warehouse is the primary data source used in development of reports. CORE data warehouse normalizes views of multiple OSU data sources including Banner and the Operational Data Store (ODS), Institutional Research (IR) data warehouse, and other sources of record and sources of differentiation.
CORE uReports are designed to be a single source access point for OSU data and information. The report data is exportable to Excel and CSV for further analysis if desired.
How often does the data refresh in ODS and CORE date warehouse?
Most of the information in ODS and the CORE data warehouse refreshes nightly. If you have a need for a real time report, you will need to use Appworx.
How do I get access to CORE?
Access is granted based on your position classification or job profile, as determined by the appropriate Data Steward. Access levels may incorporate overrides for certain Banner security classes. If your supervisor determines a need for you to have access beyond your default security level, contact the BIC Team for assistance.
Does CORE replace Appworx?
No. CORE reports replace the standard administrative reports found in BI Query. Both the uReport and the CORE data warehouse pull data from ODS, the data is not real-time but refreshed nightly. For real time data, it is necessary to access Appworx, which pulls data directly from Banner tables.