position control & labor data mart
The Position Control & Labor data mart consists of 5 star schemas (that in turn are made up of 5 fact tables and 38 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
position control & labor faculty advances star schema
Click on a FACT or DIMENSION in the following diagram to view the individual columns, as well as associated metadata:
