Versions Compared

Old Version 1

changes.mady.by.user Michael Harvey

Saved on

compared with

New Version Current

changes.mady.by.user Michael Harvey

Saved on

Key

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

...

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 _LinkDescription
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 PERSON_DEMO_VWGENDER  01048 - Gender
dbo.SID_EnrollmentsETHNICchar1DWHOUSE PERSON 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_INDINDICATOR  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_LECVEL LEVEL flag 01060 - 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 HUB_PERSON_CURRENT_VCITZ_CODE  The current citizenship code for the person on OASIS or GEMS
dbo.SID_EnrollmentsHONORSchar1PROD_ROJoin: SGBSTDN, SGRSATT, STVTERM,  SFRSTCR… 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_TYPPer column: STU_ADM_TYP  01413 - Type of Student at Time of Most Recent Admission
dbo.SID_EnrollmentsDeptvarchar4DWHOUSEHUB_ENROLLMENTS_CURR_V  DEPT_CODEExcpetion Some exception logic downstream as per MAJOR & COLLEGE Department 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 Logic Address 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.