The Analytics Middle Tier basic deployment loads a set of dimensional views that are common to many different use cases. These are called the "core collection" views. While most of these dimensional views have been created initially to support theEarly Warning Systemuse case, they can be useful for custom fact views that address different questions.
Where it makes sense, aLastModifiedDatecolumn exists so that ETL tools can perform partial data loads (e.g., to import all records modified since the last import date and time). Because a view frequently combines data from multiple tables that each have their ownLastModifiedDate, the view selects the most recent of all available datetime stamps to display as its own.
Primary key fields on each table are sometimes surrogate keys — combining each natural key field into a single string — or they are the integer identifiers from a table, where such exist. Whenever a source table has aUniqueIdkey column, that column is used as the primary key field, for example, Student.StudentUniqueIdbecomesStudentKey. The more generic nameKeyhelps data analysts more quickly understand the model.