SID_Admissions
- Michael Harvey (Deactivated)
This page documents the SID_Admissions reporting table, which is used to contain a summary of admitted students at the undergraduate and graduate levels.
This table is loaded either from SID_Enrollments, or from SID_Applicants_Admits (for any applicant data NOT in the SID_Enrollments table).
| TableName | COLUMN_NAME | data_type | MaxLength | Source_System | Source_Table | Source_Column_Name | Notes_Logic | Meta Mart Description |
| dbo.SID_Admissions | termid | varchar | 8 | SID | SID_ENROLLMENTS SID_Admissions | TERMID TERMID | ** See documentation for SID table for details ** | |
| dbo.SID_Admissions | bench | varchar | 1 | Literal | Via Query SID_Admissions | E' BENCH | Via stored procedure PROC_SID_LoadAdmissions | |
| dbo.SID_Admissions | uid | varchar | 9 | SID | SID_ENROLLMENTS SID_Admissions | UID UID | ** See documentation for SID table for details ** | |
| dbo.SID_Admissions | homecampus | varchar | 4 | SID | SID_ENROLLMENTS SID_Admissions | homecampus homecampus | ** See documentation for SID table for details ** | |
| dbo.SID_Admissions | college_rpt | varchar | 2 | SID | SID_ENROLLMENTS SID_Admissions | college_rpt college_rpt | ** See documentation for SID table for details ** | |
| dbo.SID_Admissions | dept | varchar | 4 | SID | SID_ENROLLMENTS SID_Admissions | dept dept | ** See documentation for SID table for details ** | |
| dbo.SID_Admissions | major | varchar | 5 | SID | SID_ENROLLMENTS SID_Admissions | major major | ** See documentation for SID table for details ** | |
| dbo.SID_Admissions | admt_code | varchar | 2 | SID | SID_ENROLLMENTS SID_Admissions | admt_code admt_code | ** See documentation for SID table for details ** | |
| dbo.SID_Admissions | final_adm_action | varchar | 1 | Literal | Via Query SID_Admissions | A' final_adm_action | Via stored procedure PROC_SID_LoadAdmissions | |
| dbo.SID_Admissions | ethnic | char | 1 | SID | SID_ENROLLMENTS SID_Admissions | ethnic ethnicity | ** See documentation for SID table for details ** | |
| dbo.SID_Admissions | gender | char | 1 | SID | SID_ENROLLMENTS SID_Admissions | gender gender | ** See documentation for SID table for details ** | |
| dbo.SID_Admissions | stu_lvltyp | varchar | 3 | Literal | Via Query SID_Admissions | ENR' Calculated: 'ADM' , 'APP' | Via stored procedure PROC_SID_LoadAdmissions based on final_adm_Action | |
| dbo.SID_Admissions | stu_recent_adm_typ_rpt | varchar | 1 | SID | SID_ENROLLMENTS SID_Admissions | stu_recent_adm_typ_rpt stu_typ_rpt | ** See documentation for SID table for details ** | |
| dbo.SID_Admissions | stu_type | varchar | 233 | SID | sid_title_typestudent SID_Admissions | SortOrder + ' - ' + typestudent_title SortOrder + ' - ' + typestudent_title | Concatenated value via stored procedure PROC_SID_LoadAdmissions | |
| dbo.SID_Admissions | stu_class_level_rpt | varchar | 1 | SID | SID_ENROLLMENTS SID_Admissions | stu_class_level_rpt stu_class_level_rpt | ** See documentation for SID table for details ** | |
| dbo.SID_Admissions | cip_student | varchar | 6 | SID | SID_ENROLLMENTS SID_Admissions | cip_student cip_student | ** See documentation for SID table for details ** | |
| dbo.SID_Admissions | lvltype | varchar | 1 | SID | SID_ENROLLMENTS SID_Admissions | Calculated: 1,2,3,4 Calculated: 1, 2, 4 | As per inst_class_lvl_stu and stu_class_level_rpt '1' = undergraduates; '2' = graduate level; '4' = professional programs | ** See documentation for SID table for details ** |
| dbo.SID_Admissions | Timestamp | datetime | SQL | Database | Timestamp | |||
| dbo.SID_Admissions | CITZ_CODE | varchar | 2 | SID | SID_ENROLLMENTS SID_Admissions | CITIZENSHIP_CODE CITZ_CODE | ** See documentation for SID table for details ** | |
| dbo.SID_Admissions | CONC_CODE | varchar | 4 | SID | SID_ENROLLMENTS SID_Admissions | Calculated: MajorConcentration CONC_CODE | ** See documentation for SID table for details ** | |
| dbo.SID_Admissions | DEGC_CODE_SOUGHT | varchar | 6 | SID | SID_ENROLLMENTS SID_Admissions | DEGC_CODE DEGC_CODE_SOUGHT | ** See documentation for SID table for details ** |