Connect flattened tables
Current Students (CURRENT_STUDENTS) - provides one row of data for student course filtered from ACAD table
| Field | Data | Description |
|---|---|---|
| EMPLID | VARCHAR(11) | Student USN |
| ACAD_CAREER | VARCHAR(4) | Academic Career |
| ACAD_PROG | VARCHAR(5) | Academic Program |
| ACAD_PLAN | VARCHAR(10) | Primary Academic Plan |
| ACAD_PLAN_EXTRA | VARCHAR(10) | Secondary Academic Plan |
| MATRIC_TERM | VARCHAR(4) | Matriculation Term |
Contact details (CONTACT_DETAILS) - provides one row of data relating to student contact details from EMAL and PHN tables
| Field | Data | Description |
|---|---|---|
| EMPLID | VARCHAR(11) | Student USN |
| PREF_EMAL | VARCHAR(70) | Preferred Email Address |
| CRS_EMAL | VARCHAR(70) | CRS Id Email Address |
| EXTL_EMAL | VARCHAR(70) | External Email Address |
| OTHR_EMAL | VARCHAR(70) | Other Email Address |
| PREF_PHN | VARCHAR(24) | Preferred Phone Number |
| HOME_PHN | VARCHAR(24) | Home Phone Number |
| CELL_PHN | VARCHAR(24) | Mobile Phne Number |
| MAIN_PHN | VARCHAR(24) | Main Phone Number |