Oregon State University has three Data Warehouse models:
Information Services supports these models, administers access to the data, and supports Departmental Computing Administrators (DCAs) with troubleshooting installation and other technical problems.
It is particularly important that Human Resources paperwork be completed for new employees. An employee must be set up in Banner by the Office of Human Resources before we can process the Request for Access form. This is true of transferred personnel as well. Even if they had Banner or Data Warehouse access previously, their old account has to be terminated when we start processing the form for their new department. Be aware that it can take a few days to process the form and that they will not be able to access systems during that time.
OSU's Finance Information System (FIS) Data Warehouse contains data extracted from Banner FIS and reorganized a bit to enhance accessibility. It is designed primarily for ad hoc querying and unofficial reporting by accounting staff in the various departments at OSU. The data is organized on a fiscal year basis.
The FIS Data Warehouse contains the following general subject areas (since FY 96, except as noted):
The data are refreshed nightly, except for the Payroll Ledger, which is refreshed a couple of times a month, whenever payroll expenses are posted.
The Operating Ledger contains a summary of all revenues and expenses. The Transaction Ledger only contains detail for three types of transaction documents: Invoices (INV), Journal Voucher (JV), and Cancelled Checks (CKC). Fixed Asset Adjustment documents are not included in the Transaction Ledger at this time, even though they can affect revenues and expenses. So, for example, 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, are excluded from the Transaction Ledger, but are summarized in the Operating Ledger. These are the primary reasons for reconciling items between the two ledgers.
The FIS Data Warehouse Default Pay Object was designed to help departments predict how much salary expense will be charged to each accounting distribution (FOAPAL) for each employee for each pay period in the current fiscal year.
Although encumbrances in FIS show the OPE component, the default pay model does not.
Employees with jobs that are active or on leave at some point during the current fiscal year, who have a default earn code, plus those in employee class CD, classified full-time hourly will be included. That’s everyone except hourly paid employees and unpaid appointments, including classified part-time hourly, temporary support staff, academic wage hourly appointments, student workers, and courtesy and emeritus appointments (employee classes CE, TS, UW, XA, and XX). Student positions with a job suffix of 55 will display because these jobs are salaried.
The default pay data is calculated and loaded into the FIS warehouse nightly. Encumbrances are only calculated and loaded into FIS once a month, near the end of the month. Any changes made to a job or its labor distribution in HR will be reflected in the default pay data the next workday, but won't affect encumbrances until they are recalculated near the end of the month.
In addition, encumbrances are calculated somewhat differently from the default pay. Both are calculated using the job detail records, default earn codes, and default labor distributions from the jobs records, but the encumbrance process uses the first day of the next month to start encumbering, while the default pay process uses the actual personnel effective date.
Because of this, you may see some differences between default pay amounts and encumbrance amounts for employees whose job begins midmonth. This will really be apparent for those employees who begin work on September 16. Their encumbrances posted in FIS will not include the time period between September 16 and October 1.
Actual pay amounts do not show. The Default Pay Object is not a record of actual gross wages paid in prior months. The default pay looks at the job record (viewable in NYIJOBS) that was in effect for the month in question. The default labor distribution for that record was incorrect, requiring the correction in PYAHOUR. Once a month has passed, the pay can be redistributed, but the job record cannot be changed and the default pay cannot be corrected. Past months should be ignored.
Default pay can only be loaded based on what has been entered into Banner. If the information you are looking for is not there, it was not in Banner as of the time the warehouse loaded. Or, it could be a data entry error. Look in NYIJOBS to see if the changes you requested have been entered. Inputting paperwork for the current month takes priority over future-dated actions. Future-dated actions are input as soon as possible after that, however system limitations only provide the Office of Human Resources with about two weeks per month when input may occur.
Pay increases are generally entered by payroll at the beginning of the month in which they became effective. They will not show up as default pay until that month.
Sabbatical will display on the employee position, with an "11" suffix, unless the employee has also signed up for the 9-12-month option. In these cases, it will display on the "00" suffix. In both cases, it should display with a 10123 account code.
The pay is charged to departments across the same 9 month period that the appointment covers, so those are the months where default pay will be projected.
OSU's Human Resource Information System (HRIS) data warehouse contains data extracted from Banner HRIS and reorganized to enhance accessibility. It is designed primarily for ad hoc querying and unofficial reporting by staff in the various departments at OSU.
The HRIS Data Warehouse contains the following general subject areas (current or last known status since 1/99, except as noted):
These data are refreshed nightly, except for the Pay and Benefits objects, which are refreshed each weekend, and occasionally during the week as necessary.
In addition to the HRIS DW Pay object organizing data by Calendar Year (CY) and the FIS DW Payroll Ledger organizing data by Fiscal Year (FY), they also differ because in the HRIS DW data is shown by pay period, and in the FIS DW, data is shown by fiscal period. Initially both amounts are usually the same. However, any manual checks or adjustments and redistributions will cause reconciling items. If you process an adjustment in November that corrects September's pay, in the HRIS DW Pay object the correction will show up in pay period 9 September, but in the FIS DW Payroll Ledger it will show up in fiscal period 5 November.
The SIS Data Warehouse provides a method for advisors and academic departments to access information about students and courses at OSU in a graphical and business-oriented way. The front-end tool used to access information in the SIS Data Warehouse is Hummingbird BI, a product from Hummingbird Ltd.
The Accounts Receivable (AR) Data Warehouse is designed to provide a method for department accountants to access detail and summary information for person and non-person accounts.
The Financial Aid Data Warehouse is designed to provide a method for the Financial Aid department to access detail about financial aid applications that have been completed by students, financial aid awards that have been granted, tracking requirements, and financial aid status.
Access to this data model is restricted. Any questions should be directed to the Office of Financial Aid and Scholarships, 541-737-4494.