Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Master Data can be described as the key business information that supports the transactions.
Master Data describes the customers, products, parts, employees, materials, suppliers, sites, etc involved in the transactions. It is commonly referred to
as Places (locations, geography, sites, etc.), Parties (persons, customers, suppliers, employees, etc.) and Things (products, items, material, vehicles, etc.).

Master data in the context of Course Exchange.

The following diagram is the DB schema for course exchange.




Drilling into the schema, there are data sets that are not only specific to Course Exchange but are also useful in other applications such as CCCApply, MyPath and Common Assessment.

Some of these data sets include

  • Districts
  • Schools (Colleges)
  • Persons (Students)
  • Terms

Apply currently requires colleges to maintain an Apply specific tables for Districts, Colleges and Terms.  College Staff typically enter this data in their own College SIS, then re-enter the exact same data in the Apply Administrator Application.  What this means is that we now maintain multiple sets of duplicate master data at the colleges and in the Apply database.