Table: dim_application_student

Type: Dimension Columns: 8

Description

Application student information. The data grain is student within an application.

Columns

Column Name Description
application_student_key

Surrogate key integer corresponding to the application student

student_first_name

The application student's first name

student_last_name

The application student's last name

student_full_name

The full name of the application student

date_of_birth

The application student's date of birth

student_id

Unique identifier for the student

slicer_application_student_key

A key for grouping students with the same full name together; connects to dim_slicer_application_student

business_id

Unique identifier for the business