Financial Data Store — FDS

The FDS contains historical FY'12 FAS monthly balances and current data starting from July 1, 2012. With the exception of the Budget/COB data updated intra-day, all other data is one day old.

The main source of data for the FDS is the financial system, Accounting and Reporting at Columbia (ARC), and Labor Accounting (LA). The ARC and FFE security model is applied. Data in the FDS is categorized into subject areas (GL, KK, AP, etc.) and designed into data models. A data dictionary is available for each data model, refer to FDS Job Aids and Tools section.

The following information about FDS is available:

• Available Data
• Data Source Details
• FDS Data Flow
• FDS Load and Blackout Period
• FDS Data Models
• FDS Job Aids and Tools

Available Data

• ARC COA (Chart of Accounts)
• eProcurement (ePro), requisitioning only
• FAS-to-ARC COA (crosswalk)
• General Ledger (GL) with Commitment Control (KK)
• Payables (AP)
• Project Costing (PC)
• Purchasing (PO)

Data Source Details

FDS Data Flow

The following diagram shows the daily data flow from the various source systems, ARC and PAC/LA, into the FDS.

FDS Load and Blackout Period

The FDS Load and Blackout Period is a daily period of time, 12AM - 6:59 a.m., when the FDS is ‘Unavailable’ to the user community for 'On-line' access. During this blackout period the FDS is loaded and refreshed with current data. The load and refresh process is a two step process. First, data from the source systems, ARC and PAC/LA, is loaded into the FDS Staging environment.  In this process the data is loaded and validated for completeness. The second step in the process is the refresh of the FDS Target environment, which occurs only on successful completion of the FDS Staging load process. The FDS Target environment contains the FDS Reporting tables. An unsucessful load/refresh process of the FDS will result in ‘two day old’ data available in the FDS Reporting tables. A successful load of the FDS environment will contain a ‘day old’ data. The blackout period also facilitates FDS Batch Reporting and File Extract processes. The daily status of the FDS will be communicated via:

• ARC Portal
• Finance Gateway
• Service Now Alerts

To assist the user with familiarization of the Financial Data Store (FDS), Enterprise Business Intelligence Solutions (EBIS) has developed the following data models.

FDS Data Dictionary documents the FDS tables, column attributes and descriptions.

• Entity Descriptions
• Attribute Definition

FDS Data Models

FDS Data Models document the relationship among the tables represented via the following functional modules:

• FDS Chartfields Xwalk
• FDS Chartfield/Reporting Secure Views Design
• FDS General Ledger (GL) Data Model
  • FDS GL
  • FDS GL Header/Line Table and External Accounting Stage Table
  • FDS GL Journal Data
  • FDS GL Secured Views
  • FDS GL Summary Tables and Views
  • FDS GL with Current Chartfields
• FDS KK (Commitment Control)
  • KK Extract Views
  • KK Budget Security Views
  • KK Transaction Tables
  • FDS KK Budget Summary Table
• FDS LA (Labor Accounting)
  • LA Secure Views
• FDS PC (Project Costing)
  • FDS Project Costing
  • FDS Project and Activity Attributes
  • FDS Project Resource Secure and Extract Views
• FDS Procurement (PO)
  • Accounts Payable
  • Accounts Payable Secure Views
  • Accounts Payable Extract Views for Facilities
  • Procurement (PO)
  • PO Extract Views for Facilities
  • PO and Requisition Secure Views
  • Vendor Tables
• Trees are a graphic representation of a hierarchy or reporting structure based on a GL Chartfield. A tree can specify how the data should be summarized or 'rolled-up' for reporting purposes.
  • ARC (PeopleSoft) Trees
  • Security Trees

FDS Job Aids and Tools

To assist the user with familiarization of the Financial Data Store, Enterprise Business Intelligence Solutions (EBIS) has developed the following job-aids and tools:

Business Objects Supported OS and Minimum PC Requirements: documents CUIT's  SAP/Business Objects supported browsers, operating systems and minimum pc requirements.  Please check regularly for latest updates.

ARC/FDS Reports Data Grid: cross-reference matrix which documents the ARC and FDS reports (from ARC Portal's Quicklinks) and the selected Tables/views/calculated fields reported on by Report Type grouping. 

FDS Business Objects (BO) Report Limits and Scheduling Recommendations: documents report limits and report scheduling recommendations as per Accenture audit.  

FDS Environments Mapping: Source and Target Databases as of April 2014

FDS LA Table Loads and Impacted FDS Reports: documents LA tables, load frequency (daily/monthly, etc.), type of data loaded and FDS Reports which use these tables.

FDS KK 2 Hour Refresh Process: documents intra-day Commitment Control (KK) refresh process.

FDS Security Roles Mapping: a matrix which documents the tables and views used to set up an individual's 'FDS Security Role'.

Internal Error: Clearing Browser Cache Job Aid: the purpose of this job aid is to provide you with 'how to' steps in clearing your computer's cache once an 'internal error' has been encountered (IE, Firefox and Chrome).

Additional information and job aids about ARC data can be found at the ARC Tool Kit page.