Overview

The following article is a start guide for those using SAH-AR-DetailCodeAccountingNarrow-View.
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 and Detail Code Distribution.

• Includes CCOA from Oracle as columns.

• No transaction information and no Student PIDs.

Pre-Joined Data

• Includes CCOA fields from Oracle as columns

Active Detail Codes

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

Steps to Take

Key Fields to Display

• SIS Detail Code Dist

• SIS Detail Code

• SIS Detail Code Index

• SIS Dist Percent

• CCOA Fields

Key Fields to Filter on

• SIS Detail Code Dist

• 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.