financial analysis data mart
The Financial Analysis data mart consists of 5 star schemas (that in turn are made up of 5 fact tables and 26 dimensions, many of which are conformed dimensions).
general ledger star schemas
operating ledger star schemas
monthly snapshots
actual transactions
budget transactions
commitment transactions
position control star schemas
position & labor salary history
position & labor ytd salary snapshot
position & labor actual transactions
position & labor commitment transactions
position & labor faculty advances
operating ledger monthly snapshots star schema
Click on a FACT or DIMENSION in the following diagram to view the individual columns, as well as associated metadata:
