Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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 QueryENR'Via stored procedure PROC_SID_LoadAdmissions 
dbo.SID_Admissionsstu_recent_adm_typ_rptvarchar1SID

SID_ENROLLMENTS

SID_Admissions

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

sid_title_typestudent

 

SortOrder + ' - ' + typestudent_titleConcatenated value via stored procedure PROC_SID_LoadAdmissions 
dbo.SID_Admissionsstu_class_level_rptvarchar1SID

SID_ENROLLMENTS

SID_Admissions

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

SID_ENROLLMENTS

SID_Admissions

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

SID_ENROLLMENTS

SID_Admissions

Calculated: 1,2,3,4As per inst_class_lvl_stu and stu_class_level_rpt** 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

CONC_CODE

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 **