Finance Data Warehouse (OBIEE)
A data warehouse is an online repository for information. The Finance Data Warehouse contains data from the PeopleSoft Financial system (CFS) and allows end users to view, filter and search for information. It is updated nightly providing data current as of close of business (COB) the night before.
Financial data from fiscal year 2007 onwards can be accessed in the Campus Portal under Titan Online > Business Intelligence > OBIEE–BI Dashboard.
Liability Accounts Core Guide - Desk Manual
Accessing Financial Information (OBIEE 12c – BI/Dashboards) - Presentation
Actuals Detail (between Accounting Periods) Report has Account Category
as one of the report filters; Account Category groups accounts with the same first three characters with the exception of transfers accounts.
Fields that are Specific to the Actuals Detail Report
(Between Accounting Periods)
Field | Description |
---|---|
Doc Src | Identifies the source of the transaction |
Journal ID | Identification number associated with the accounting transaction; the first few characters or prefix further identifies the source of the transaction |
Reference | Line reference for the transaction if entered; may denote a Purchase Order or Work Order number, CASHNet Item Code, or other identifying information |
Reference 1 | Additional references information for the transaction; for HCM transactions, this includes FTE statistics amount if applicable; for Accounts Payable transactions (Doc Src = VCH), this includes the PO ID associated with the transaction |
Reference 2 | Additional reference information for the transaction |
Fiscal Year | Financial year (07/01 to 06/30); denoted by the first calendar year of the fiscal period during which the transactions occurred (Ex. 2020 - 2021 = Fiscal Year 2020) |
Accounting Period |
Period for which financial statements are prepared; CSUF follows the calendar month
|
Actuals | Transaction amount |
Doc Src | Journal ID Prefix |
Journal Description & Source of Data |
Contact |
---|---|---|---|
ABN | 0000 (no prefix) |
Axx = Entries originating in Accounting Services & Financial Reporting (Expenditure Transfer Requests) Sxx = Entries originating in Student Financial Services Last 2 characters of Doc Src represent the initials of the accountant who processed the entry |
Betty Neri Ext. 4485 |
ADH | Dawit Haile Ext. 4244 |
||
AEM | Estrella Mangahas Ext. 5386 |
||
AJC | Justin Chan Ext. 8371 |
||
ALG | Lynn Gañac Ext. 8474 |
||
ANL | Nathan Le Ext. 4524 |
||
ASN | Sarah Nguyen Ext. 7756 |
||
ATL | Tony Lee Ext. 2044 |
||
AWL | Winnie Lin Ext. 4246 |
||
ALO | ALO | Allocations are sytem generated entries that distribute monetary amounts across departments or any other ChartField defined in PeopleSoft General Ledger (CFS) | Lynn Gañac Ext. 8474 |
BIL | BI | Amounts invoiced to outside entities or CSUF Auxiliary Organizations | Nathan Le Ext. 4524 |
CSU | Various | Service Providers' chargeback transactions (COP, PCD, PHY, etc.) | Service Provider Contact List |
CRS | Deposits fed from CASHNet system | asfr@fullerton.edu | |
HCM | HRA | Salary adjustments (LCD) fed from the Human Resources PeopleSoft system |
ASFR will coordinate with the appropriate department |
HRL | Salary expenses (LCD) fed from the Human Resource Peoplesoft system | ||
OBL | OBL | Obligation (accrual entry that is usually reversed on the first day of the following month) | |
SFS | SFS | Fees, other revenues, and refunds fed from the Student Administration PeopleSoft system | ASFR will coordinate with the appropriate department |
VCH | APV | Amounts invoiced by vendors and travel charges | ap@fullerton.edu |
APC | Closure of an "APV" voucher (invoice) |