Table of Contents

• Overview

• Critical Concepts

  • Unique to this View

  • Pre-Joined Data

  • Active Detail Codes

  • Questions about Codes

• Steps to Take

  • Key Fields to Display

  • Key Fields to Filter on

  • Granularity

Overview

The following article is a start guide for those using SAH-AR-DetailCodeAccounting-Wide View.

This view is a pivoted version of the SAH-AR-DetailCodeAccountingNarrow-View based on the SIS Detail Code Dist.

Either SAH-AR-DetailCodeAccountingNarrow-View or SAH-AR-DetailCodeAccountingWide-View can be used to translate between SIS and FIS accounting codes. The wide view only has CCOA segments, and each segment is a separate data item for each "leg" of the detail code. The narrow view includes PPM segments (task, expenditure type).

Critical Concepts

Unique to this View

• One row per Detail Code.

• SIS Detail Code Distribution information included as columns.

• CCOA fields from Oracle included as columns - if you need more CCOA fields go to SAH-AR-DetailCodeAccountingNarrow-View.

• No transaction information and no Student PIDs.

Pre-Joined Data

• SIS Detail Code Distribution information included as columns.

• FINAH CCOA fields from Oracle included as columns.

Active Detail Codes

Active Detail Codes have a SIS Detail Code End Date = 2999-12-31

Questions about Codes

• If you have questions about business processes or what codes mean or how they are used, please email studentARgovernance@ucsd.edu.

Steps to Take

Key Fields to Display

• SIS Detail Code

• SIS Process Type / Code

• SIS Category Type / Code

• CCOA fields for the SIS Detail Code Dist of your choice
  
  

Key Fields to Filter on

• SIS Detail Code

Granularity

Granularity is the scale or level of detail present in a set of data.  It identifies where levels of uniqueness exists in the data.  The data lives in the view at the lowest level, but each BI tool totals the levels differently.

• One row per Detail Code.