SID Enrollments

Owned by Michael Harvey (Deactivated)
Last updated: Sept 25, 2018

 

This page documents data-items in the SID Enrollments table, while providing Meta Mart description of the columns and links to the source tables/views in Meta Mart.

 

TableNameCOLUMN_NAMEdata_typeMaxLengthSource_SystemSource_TableSource_Column_NameNotes_LogicMeta Mart Description
dbo.SID_EnrollmentsTERMIDvarchar8DWHOUSEENROLLMENTS_VWDEMO_TIME_FRAME Academic term (YYYYMM) in which the demographic data is reported.
dbo.SID_EnrollmentsBENCHvarchar1Run-time parameterN/A@BENCH' (B, F, D, E)Entered/passed at run-time in ETL 
dbo.SID_EnrollmentsUIDvarchar9DWHOUSEENROLLMENTS_VW  USF_ID or 'UP' + OASIS_PIDM(OASIS_PIDM starting at position 7 in field, if USF_ID is NULL)This field holds the OASIS U-ID.
dbo.SID_EnrollmentsFEE_CLASS_KINDvarchar1DWHOUSEENROLLMENTS_VW  FEE_CLASS_KIND 01107 - Fee Classification - Kind
dbo.SID_EnrollmentsHOMECAMPUSvarchar4DWHOUSEENROLLMENTS_VW  U_RESV_2 

University defined information

*Multi-purpose field depending on table/function

dbo.SID_EnrollmentsCOLLEGEvarchar2DWHOUSEHUB_ENROLLMENTS_CURR_V  COLL_CODE_ORG Student College code.
dbo.SID_EnrollmentsMAJORvarchar5DWHOUSEHUB_ENROLLMENTS_CURR_V  Derived from: MAJR_CODE or DSS_MAJOR

IF MAJR_CODE IS NULL

use DSS_MAJOR

Student Major code /

USF Major code

dbo.SID_EnrollmentsGENDERchar1DWHOUSE PERSON_DEMO_VWGENDER 01048 - Gender
dbo.SID_EnrollmentsETHNICchar1DWHOUSE PERSON_DEMO_VWRACE_ETHNICITYCalculated values: O, H, X, M, I, A, B, P, W, X

01044 - Racial/Ethnic Group

*Based on ethnic flags

dbo.SID_EnrollmentsNATION_CITIZvarchar5DWHOUSEENROLLMENTS_VW  NATION_CITIZ or 'ZZ' if column is NULL 01110 - Nation of Citizenship
dbo.SID_EnrollmentsSTATE_ADMvarchar2DWHOUSEENROLLMENTS_VW  STATE_ADM 01111 - State Code at Time of Admission
dbo.SID_EnrollmentsCOUNTY_OF_RESvarchar4DWHOUSEENROLLMENTS_VW  COUNTY_OF_RES 01055 - County of Residence, SUS
dbo.SID_EnrollmentsNAT_MERIT_SCH_INDvarchar1DWHOUSEENROLLMENTS_VW  NAT_MERIT_SCH_IND 01407 - National Merit Scholar Indicator
dbo.SID_EnrollmentsDISPLACED_STU_INDvarchar1DWHOUSEENROLLMENTS_VW  DISPLACED_STU_IND 01809 - Displaced Student Indicator
dbo.SID_EnrollmentsINST_DISPLACED_FROMvarchar8DWHOUSEENROLLMENTS_VW  INST_DISPLACED_FROM 01810 - Institution Displaced From (built from old 5-digit code by prefixing one zero and suffixing two zeroes)
dbo.SID_EnrollmentsHS_ETS_CDvarchar6DWHOUSEENROLLMENTS_VW  HS_ETS_CD 01069 - High School Code
dbo.SID_EnrollmentsLAST_SECONDARY_DTvarchar6DWHOUSEENROLLMENTS_VW  LAST_SECONDARY_DT 01169 - Date of Last Attendance YYYYMM
dbo.SID_EnrollmentsDUAL_ENROLL_INDvarchar1DWHOUSEENROLLMENTS_VW  DUAL_ENROLL_INDICATOR 01074 - Indicates a non-degree seeking student who is undertaking course work at a secondary and post-secondary educational institution during the same term. Qualified students in sixth through twelfth grade are eligible to undertake dual enrollment courses. This excludes Early Admits because they are seeking a degree.
dbo.SID_EnrollmentsLAST_INST_CDvarchar8DWHOUSEENROLLMENTS_VW  LAST_INST_CD 01067 - Last Institution Code (built from old 5-digit code by prefixing one zero and suffixing two zeroes)
dbo.SID_EnrollmentsLAST_POSTSEC_DTvarchar6DWHOUSEENROLLMENTS_VW  LAST_POSTSEC_DT 01169 - Date of Last Attendance YYYYMM
dbo.SID_EnrollmentsSTU_ENTRY_TYPvarchar1DWHOUSEENROLLMENTS_VW  STU_ENTRY_TYP 01068 - Type of Student at Date of Entry
dbo.SID_EnrollmentsSTU_ENTRY_DTvarchar6DWHOUSEENROLLMENTS_VW  STU_ENTRY_DT 01064 - Student Date of Entry
dbo.SID_EnrollmentsSTU_RECENT_ADM_TYPvarchar1DWHOUSEENROLLMENTS_VW  STU_RECENT_ADM_TYP 01413 - Type of Student at Time of Most Recent Admission
dbo.SID_EnrollmentsSTU_RECENT_ADM_DTvarchar6DWHOUSEENROLLMENTS_VW  STU_RECENT_ADM_DT 01420 - Date of Most Recent Admission
dbo.SID_EnrollmentsFIRST_GEN_INDvarchar1DWHOUSEENROLLMENTS_VW  FIRST_GEN_IND 01812 - First Generation Indicator
dbo.SID_EnrollmentsFEE_CLASS_RESvarchar1DWHOUSEENROLLMENTS_VW  FEE_CLASS_RES 01106 - Fee Classification - Residency
dbo.SID_EnrollmentsCLAST_INDvarchar1DWHOUSEENROLLMENTS_VW  CLAST_IND 01244 - College Level Academic Skills Test Flag
dbo.SID_EnrollmentsMAX_CRED_TEACH_FLGvarchar1DWHOUSEENROLLMENTS_VW  MAX_CRED_TEACH_FLG 01057 - Maximum Credit in Supervised Teaching
dbo.SID_EnrollmentsMAX_CRED_RESEARCH_FLGvarchar1DWHOUSEENROLLMENTS_VW  MAX_CRED_RESEARCH_FLG 01058 - Maximum Credit in Supervised Research
dbo.SID_EnrollmentsDOC_CANDIDACY_FLGvarchar1DWHOUSEENROLLMENTS_VW  DOC_CANDIDACY_FLG 01059 - Doctoral Candidacy Flag
dbo.SID_EnrollmentsSTU_CLASS_LEVELvarchar1DWHOUSEENROLLMENTS_VW  STU_CLASS_LEVEL 01060 - Student Classification Leve
dbo.SID_EnrollmentsCIP_STUDENTvarchar6DWHOUSEENROLLMENTS_VW  CIP_STUDENT 01062 - Student Program Category
dbo.SID_EnrollmentsDEG_HIGHEST_HELDvarchar1DWHOUSEENROLLMENTS_VW  DEG_HIGHEST_HELD 01112 - Degree - Highest Level Held
dbo.SID_EnrollmentsINST_GRNT_HIDEG_CDvarchar8DWHOUSEENROLLMENTS_VW  INST_GRNT_HIDEG_CD 01411 - Institution Granting Highest Degree (built from old 5-digit code by prefixing one zero and suffixing two zeroes)
dbo.SID_EnrollmentsDEG_LEVEL_SOUGHTvarchar1DWHOUSEENROLLMENTS_VW  DEG_LEVEL_SOUGHT 01053 - Degree - Level Sought
dbo.SID_EnrollmentsDOC_CLASSvarchar1DWHOUSEENROLLMENTS_VW  DOC_CLASS IPEDS Reclassificaiton of First-Professional Degree Level Sought
dbo.SID_EnrollmentsBE_CDvarchar1DWHOUSEENROLLMENTS_VW  BE_CD 01065 - Student Budget Entity
dbo.SID_EnrollmentsFIRSTYR_FIRSTPROF_FLGvarchar1DWHOUSEENROLLMENTS_VW  FIRSTYR_FIRSTPROF_FLG 01269 - First Year First Professional Flag
dbo.SID_EnrollmentsTERMINATION_CDvarchar1DWHOUSEENROLLMENTS_VW  TERMINATION_CD 01071 - Termination Code
dbo.SID_EnrollmentsEXT_PGM_FLGvarchar1DWHOUSEENROLLMENTS_VW  EXT_PGM_FLG 01408 - Extended Program Flag
dbo.SID_EnrollmentsVISA_TYPvarchar3DWHOUSEENROLLMENTS_VW  VISA_TYP 01408 - Extended Program Flag
dbo.SID_EnrollmentsINST_CLASS_LVL_STUvarchar1DWHOUSEENROLLMENTS_VW  INST_CLASS_LVL_STU 01267 - Institutional Classification Level of Student
dbo.SID_EnrollmentsFULL_PART_TIME_INDvarchar1DWHOUSEENROLLMENTS_VW  FULL_PART_TIME_IND 01458 - FTIC Full-Time Indicator-Entering Term
dbo.SID_EnrollmentsCURR_TERM_CRS_LOADnumeric DWHOUSEENROLLMENTS_VW  CURR_TERM_CRS_LOAD 01063 - Current Term Course Load
dbo.SID_EnrollmentsCUM_HRS_ACCEPT_TRNnumeric DWHOUSEENROLLMENTS_VW  CUM_HRS_ACCEPT_TRN 01061 - Cumulative Hours Accepted (Transfer)
dbo.SID_EnrollmentsGPA_INST_HRSnumeric DWHOUSEENROLLMENTS_VW  GPA_INST_HRS 01085 - Institutional Hours for GPA
dbo.SID_EnrollmentsGPA_INST_GRD_PTSnumeric DWHOUSEENROLLMENTS_VW  GPA_INST_GRD_PTS 01086 - Total Institutional Grade Points
dbo.SID_EnrollmentsTOT_HRS_DEG_LVLnumeric DWHOUSEENROLLMENTS_VW  TOT_HRS_DEG_LVL 01087 - Total Hours Earned at Current Student Degree Level
dbo.SID_EnrollmentsGPA_TERM_CRED_HRSnumeric DWHOUSEENROLLMENTS_VW  GPA_TERM_CRED_HRS 01088 - Term Credit Hours for GPA
dbo.SID_EnrollmentsGPA_TERM_HRSnumeric DWHOUSEENROLLMENTS_VW  GPA_TERM_HRS 01089 - Term Credit Hours Earned
dbo.SID_EnrollmentsGPA_TERM_GRD_PTSnumeric DWHOUSEENROLLMENTS_VW  GPA_TERM_GRD_PTS 1086 - Total Institutional Grade Points
dbo.SID_EnrollmentsFLA_PUBLIC_HS_FLGvarchar1*Unknown*Unknown*UnknownAll data values are NULL 
dbo.SID_EnrollmentsIPEDS_GRADSTU_FLGvarchar1DWHOUSEENROLLMENTS_VW  Calculated: Y, X, N As per STU_CLASS_LEVEL flag01060 - Student Classification Level
dbo.SID_EnrollmentsWAIVER_HR_GRAD_STUnumeric *Unknown*Unknown*UnknownAll data values are NULL 
dbo.SID_EnrollmentsGPA_TERMnumeric DWHOUSEENROLLMENTS_VW  Calculated: GPA_TERM_GRD_PTS/GPA_TERM_CRED_HRS 

01090 - Term Grade Points Earned

01088 - Term Credit Hours for GPA

dbo.SID_EnrollmentsGPA_CUMnumeric DWHOUSEENROLLMENTS_VW  Calculated:  (GPA_INST_GRD_PTS + GPA_TERM_GRD_PTS)  / GPA_INST_HRS GPA_TERM_GRD_PTS

01090 - Term Grade Points Earned

01090 - Term Grade Points Earned

01085 - Institutional Hours for GPA

dbo.SID_EnrollmentsCITIZENSHIP_CODEchar1DWHOUSE HUB_PERSON_CURRENT_VCITZ_CODE The current citizenship code for the person on OASIS or GEMS
dbo.SID_EnrollmentsHONORSchar1PROD_ROJoin: SGBSTDN, SGRSATT, STVTERM,  SFRSTCR …Calculated: N , YDefault = N; Y if found in Honors attribute 
dbo.SID_EnrollmentsREPT_INSTvarchar4DWHOUSEENROLLMENTS_VW  REPT_INST 01045 - Reporting Institution
dbo.SID_EnrollmentsFATHER_HI_GRADEvarchar1DWHOUSEHUB_ENROLLMENTS_CURR_V  FATHER_HI_GRADE Highest grade level completed by father.
dbo.SID_EnrollmentsMOTHER_HI_GRADEvarchar1DWHOUSEHUB_ENROLLMENTS_CURR_V  MOTHER_HI_GRADE Highest grade level completed by mother.
dbo.SID_EnrollmentsOASIS_PIDMfloat DWHOUSEENROLLMENTS_VW  OASIS_PIDM This field holds the OASIS internal identification number.
dbo.SID_EnrollmentsADMT_CODEvarchar2DWHOUSEHUB_ENROLLMENTS_CURR_V  ADMT_CODE Admission Type.
dbo.SID_EnrollmentsStu_Class_Level_Rptvarchar1DWHOUSEENROLLMENTS_VW  Calculated: N, BPer columns:  STU_CLASS_LEVEL / INST_CLASS_LVL_STU / deg_level_sought / STU_RECENT_ADM_TYP

01060 - Student Classification Level

01267 - Institutional Classification Level of Student

01053 - Degree - Level Sought

01413 - Type of Student at Time of Most Recent Admission

dbo.SID_EnrollmentsStu_Recent_Adm_Typ_Rptvarchar1DWHOUSEENROLLMENTS_VW  Calculated: B or STU_RECENT_ADM_TYP 01413 - Type of Student at Time of Most Recent Admission
dbo.SID_EnrollmentsDeptvarchar4DWHOUSEHUB_ENROLLMENTS_CURR_V  DEPT_CODESome exception logic downstream as per MAJOR & COLLEGEDepartment Code.
dbo.SID_EnrollmentsCollege_Rptvarchar2DWHOUSEHUB_ENROLLMENTS_CURR_V  Calculated: ED, EP, 00Per columns: COLLEGE, DEPT, FEE_CLASS_KIND, STU_CLASS_LEVEL_RPT

College, Department,
Residency code, Student Classification Level,

Etc.

dbo.SID_EnrollmentsTimestampdatetime SQL DatabaseTimestamp  
dbo.SID_EnrollmentsMilitary_Statusnvarchar1DWHOUSEENROLLMENTS_VW  Military_Status Military Status
dbo.SID_EnrollmentsVet_Benefitsnvarchar2DWHOUSEENROLLMENTS_VW  Vet_Benefits Veteran's Benefits Chapter
dbo.SID_EnrollmentsExcess_Credit_Hrsnumeric DWHOUSEENROLLMENTS_VW  Excess_Credit_Hrs Excess Credit Hours
dbo.SID_EnrollmentsINTO_FLGvarchar5DWHOUSEHUB_ENROLLMENTS_CURR_V  INTO_FLG Flag to indicate INTO student
dbo.SID_EnrollmentsFlag_Prepaid_Tuitionvarchar5PROD_ROSGRSATTsgrsatt_atts_code The student attributes for the person and term.
dbo.SID_EnrollmentsINTO_Groupvarchar5PROD_ROSGRSATT  sgrsatt_atts_code The student attributes for the person and term.
dbo.SID_EnrollmentsFlag_Housingvarchar1PROD_ROSPRADDRCalculated: Y, X, N Based on JOIN and DATE RANGE LogicAddress Repeating Table
dbo.SID_EnrollmentsMajorConcentrationvarchar50DWHOUSEHUB_ENROLLMENTS_CURR_V  Derived from: MAJR_CODE or DSS_MAJOR + CONC1If MAJOR_CODE IS NULL use DSS_MAJOR + CONC1

Student Major code.

USF Major code + Primary Concentration 1

dbo.SID_EnrollmentsCUM_HRS_ACCEPT_TRN_PRIORnumeric DWHOUSEENROLLMENTS_VW  CUM_HRS_ACCEPT_TRN_PRIOR 02085 - Cumulative Hours Earned (Transfer) prior to High School Graduation
dbo.SID_EnrollmentsCUM_HRS_EARNED_TRN_AFTERnumeric DWHOUSEENROLLMENTS_VW  CUM_HRS_EARNED_TRN_AFTER 02086 - Cumulative Hours Earned (Transfer) after High School Graduation
dbo.SID_EnrollmentsDEGC_CODEvarchar10DWHOUSEHUB_ENROLLMENTS_CURR_V  DEGC_CODE Student degree code.