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.

 Business Intelligence Banner

Liability Accounts Core Guide - Desk ManualPDF File

Accessing Financial Information (OBIEE 12c – BI/Dashboards) - PresentationPDF File

 
Actuals Detail (between Accounting Periods) Report has Account Category PDF File Opens in new window 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)

List of fields
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

  • 1 - July
  • 2 - August
  • 3 - September
  • 4 - October
  • 5 - November
  • 6 - December
  • 7 - January
  • 8 - February
  • 9 - March
  • 10 - April
  • 11 - May
  • 12 - June
Actuals Transaction amount
List of descriptions and data sources
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
AJZ Jane Zacchia
Ext. 8356
ALG Lynn Gañac
Ext. 8474
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 Winnie Lin
Ext. 4246
CSU Various  Service Providers' chargeback transactions (COP, PCD, PHY, etc.) Service Provider Contact ListPDF File Opens in new window
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)

asfr@fullerton.edu 

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)