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.