SID_Admissions

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).

 

TableNameCOLUMN_NAMEdata_typeMaxLengthSource_SystemSource_TableSource_Column_NameNotes_LogicMeta Mart Description
dbo.SID_Admissionstermidvarchar8SID

SID_ENROLLMENTS

SID_Admissions

TERMID 

TERMID

 ** See documentation for SID table for details **
dbo.SID_Admissionsbenchvarchar1Literal 

Via Query

SID_Admissions

E'

BENCH 

Via stored procedure PROC_SID_LoadAdmissions 
dbo.SID_Admissionsuidvarchar9SID

SID_ENROLLMENTS

SID_Admissions

UID

UID

 ** See documentation for SID table for details **
dbo.SID_Admissionshomecampusvarchar4SID

SID_ENROLLMENTS

SID_Admissions

homecampus

homecampus

 ** See documentation for SID table for details **
dbo.SID_Admissionscollege_rptvarchar2SID

SID_ENROLLMENTS

SID_Admissions

college_rpt

college_rpt

 ** See documentation for SID table for details **
dbo.SID_Admissionsdeptvarchar4SID

SID_ENROLLMENTS

SID_Admissions

dept

dept

 ** See documentation for SID table for details **
dbo.SID_Admissionsmajorvarchar5SID

SID_ENROLLMENTS

SID_Admissions

major

major

 ** See documentation for SID table for details **
dbo.SID_Admissionsadmt_codevarchar2SID

SID_ENROLLMENTS

SID_Admissions

admt_code

admt_code

 ** See documentation for SID table for details **
dbo.SID_Admissionsfinal_adm_actionvarchar1Literal 

Via Query

SID_Admissions

A'

final_adm_action

Via stored procedure PROC_SID_LoadAdmissions 
dbo.SID_Admissionsethnicchar1SID

SID_ENROLLMENTS

SID_Admissions

ethnic

ethnicity

 ** See documentation for SID table for details **
dbo.SID_Admissionsgenderchar1SID

SID_ENROLLMENTS

SID_Admissions

gender

gender

 ** See documentation for SID table for details **
dbo.SID_Admissionsstu_lvltypvarchar3Literal 

Via Query

SID_Admissions

ENR'

Calculated: 'ADM' , 'APP'

Via stored procedure PROC_SID_LoadAdmissions

based on final_adm_Action

 
dbo.SID_Admissionsstu_recent_adm_typ_rptvarchar1SID

SID_ENROLLMENTS

SID_Admissions

stu_recent_adm_typ_rpt

stu_typ_rpt

 ** See documentation for SID table for details **
dbo.SID_Admissionsstu_typevarchar233SID

sid_title_typestudent

SID_Admissions

SortOrder + ' - ' + typestudent_title

SortOrder + ' - ' + typestudent_title

Concatenated value via stored procedure PROC_SID_LoadAdmissions 
dbo.SID_Admissionsstu_class_level_rptvarchar1SID

SID_ENROLLMENTS

SID_Admissions

stu_class_level_rpt

stu_class_level_rpt

 ** See documentation for SID table for details **
dbo.SID_Admissionscip_studentvarchar6SID

SID_ENROLLMENTS

SID_Admissions

cip_student

cip_student

 ** See documentation for SID table for details **
dbo.SID_Admissionslvltypevarchar1SID

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_AdmissionsTimestampdatetime SQL DatabaseTimestamp  
dbo.SID_AdmissionsCITZ_CODEvarchar2SID

SID_ENROLLMENTS

SID_Admissions

CITIZENSHIP_CODE

CITZ_CODE

 ** See documentation for SID table for details **
dbo.SID_AdmissionsCONC_CODEvarchar4SID

SID_ENROLLMENTS

SID_Admissions

Calculated: MajorConcentration

CONC_CODE

 ** See documentation for SID table for details **
dbo.SID_AdmissionsDEGC_CODE_SOUGHTvarchar6SID

SID_ENROLLMENTS

SID_Admissions

DEGC_CODE

DEGC_CODE_SOUGHT

 ** See documentation for SID table for details **