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.
TableName | COLUMN_NAME | data_type | MaxLength | Source_System | Source_Table | Source_Column_Name | Notes_Logic | Meta Mart Description |
dbo.SID_Enrollments | TERMID | varchar | 8 | DWHOUSE | ENROLLMENTS_VW | DEMO_TIME_FRAME | ||
dbo.SID_Enrollments | BENCH | varchar | 1 | Run-time parameter | N/A | @BENCH' (B, F, D, E) | Entered/passed at run-time in ETL | |
dbo.SID_Enrollments | UID | varchar | 9 | DWHOUSE | ENROLLMENTS_VW | USF_ID or 'UP' + OASIS_PIDM | (OASIS_PIDM starting at position 7 in field, if USF_ID is NULL) | |
dbo.SID_Enrollments | FEE_CLASS_KIND | varchar | 1 | DWHOUSE | ENROLLMENTS_VW | FEE_CLASS_KIND | ||
dbo.SID_Enrollments | HOMECAMPUS | varchar | 4 | DWHOUSE | ENROLLMENTS_VW | U_RESV_2 | ||
dbo.SID_Enrollments | COLLEGE | varchar | 2 | DWHOUSE | HUB_ENROLLMENTS_CURR_V | COLL_CODE_ORG | ||
dbo.SID_Enrollments | MAJOR | varchar | 5 | DWHOUSE | HUB_ENROLLMENTS_CURR_V | Derived from: MAJR_CODE or DSS_MAJOR | IF MAJR_CODE IS NULL use DSS_MAJOR | |
dbo.SID_Enrollments | GENDER | char | 1 | DWHOUSE | PERSON_DEMO_VW | GENDER | ||
dbo.SID_Enrollments | ETHNIC | char | 1 | DWHOUSE | PERSON_DEMO_VW | RACE_ETHNICITY | Calculated values: O, H, X, M, I, A, B, P, W, X | |
dbo.SID_Enrollments | NATION_CITIZ | varchar | 5 | DWHOUSE | ENROLLMENTS_VW | NATION_CITIZ or 'ZZ' if column is NULL | ||
dbo.SID_Enrollments | STATE_ADM | varchar | 2 | DWHOUSE | ENROLLMENTS_VW | STATE_ADM | ||
dbo.SID_Enrollments | COUNTY_OF_RES | varchar | 4 | DWHOUSE | ENROLLMENTS_VW | COUNTY_OF_RES | ||
dbo.SID_Enrollments | NAT_MERIT_SCH_IND | varchar | 1 | DWHOUSE | ENROLLMENTS_VW | NAT_MERIT_SCH_IND | ||
dbo.SID_Enrollments | DISPLACED_STU_IND | varchar | 1 | DWHOUSE | ENROLLMENTS_VW | DISPLACED_STU_IND | ||
dbo.SID_Enrollments | INST_DISPLACED_FROM | varchar | 8 | DWHOUSE | ENROLLMENTS_VW | INST_DISPLACED_FROM | ||
dbo.SID_Enrollments | HS_ETS_CD | varchar | 6 | DWHOUSE | ENROLLMENTS_VW | HS_ETS_CD | ||
dbo.SID_Enrollments | LAST_SECONDARY_DT | varchar | 6 | DWHOUSE | ENROLLMENTS_VW | LAST_SECONDARY_DT | ||
dbo.SID_Enrollments | DUAL_ENROLL_IND | varchar | 1 | DWHOUSE | ENROLLMENTS_VW | DUAL_ENROLL_IND | ||
dbo.SID_Enrollments | LAST_INST_CD | varchar | 8 | DWHOUSE | ENROLLMENTS_VW | LAST_INST_CD | ||
dbo.SID_Enrollments | LAST_POSTSEC_DT | varchar | 6 | DWHOUSE | ENROLLMENTS_VW | LAST_POSTSEC_DT | ||
dbo.SID_Enrollments | STU_ENTRY_TYP | varchar | 1 | DWHOUSE | ENROLLMENTS_VW | STU_ENTRY_TYP | ||
dbo.SID_Enrollments | STU_ENTRY_DT | varchar | 6 | DWHOUSE | ENROLLMENTS_VW | STU_ENTRY_DT | ||
dbo.SID_Enrollments | STU_RECENT_ADM_TYP | varchar | 1 | DWHOUSE | ENROLLMENTS_VW | STU_RECENT_ADM_TYP | ||
dbo.SID_Enrollments | STU_RECENT_ADM_DT | varchar | 6 | DWHOUSE | ENROLLMENTS_VW | STU_RECENT_ADM_DT | ||
dbo.SID_Enrollments | FIRST_GEN_IND | varchar | 1 | DWHOUSE | ENROLLMENTS_VW | FIRST_GEN_IND | ||
dbo.SID_Enrollments | FEE_CLASS_RES | varchar | 1 | DWHOUSE | ENROLLMENTS_VW | FEE_CLASS_RES | ||
dbo.SID_Enrollments | CLAST_IND | varchar | 1 | DWHOUSE | ENROLLMENTS_VW | CLAST_IND | ||
dbo.SID_Enrollments | MAX_CRED_TEACH_FLG | varchar | 1 | DWHOUSE | ENROLLMENTS_VW | MAX_CRED_TEACH_FLG | ||
dbo.SID_Enrollments | MAX_CRED_RESEARCH_FLG | varchar | 1 | DWHOUSE | ENROLLMENTS_VW | MAX_CRED_RESEARCH_FLG | ||
dbo.SID_Enrollments | DOC_CANDIDACY_FLG | varchar | 1 | DWHOUSE | ENROLLMENTS_VW | DOC_CANDIDACY_FLG | ||
dbo.SID_Enrollments | STU_CLASS_LEVEL | varchar | 1 | DWHOUSE | ENROLLMENTS_VW | STU_CLASS_LEVEL | ||
dbo.SID_Enrollments | CIP_STUDENT | varchar | 6 | DWHOUSE | ENROLLMENTS_VW | CIP_STUDENT | ||
dbo.SID_Enrollments | DEG_HIGHEST_HELD | varchar | 1 | DWHOUSE | ENROLLMENTS_VW | DEG_HIGHEST_HELD | ||
dbo.SID_Enrollments | INST_GRNT_HIDEG_CD | varchar | 8 | DWHOUSE | ENROLLMENTS_VW | INST_GRNT_HIDEG_CD | ||
dbo.SID_Enrollments | DEG_LEVEL_SOUGHT | varchar | 1 | DWHOUSE | ENROLLMENTS_VW | DEG_LEVEL_SOUGHT | ||
dbo.SID_Enrollments | DOC_CLASS | varchar | 1 | DWHOUSE | ENROLLMENTS_VW | DOC_CLASS | ||
dbo.SID_Enrollments | BE_CD | varchar | 1 | DWHOUSE | ENROLLMENTS_VW | BE_CD | ||
dbo.SID_Enrollments | FIRSTYR_FIRSTPROF_FLG | varchar | 1 | DWHOUSE | ENROLLMENTS_VW | FIRSTYR_FIRSTPROF_FLG | ||
dbo.SID_Enrollments | TERMINATION_CD | varchar | 1 | DWHOUSE | ENROLLMENTS_VW | TERMINATION_CD | ||
dbo.SID_Enrollments | EXT_PGM_FLG | varchar | 1 | DWHOUSE | ENROLLMENTS_VW | EXT_PGM_FLG | ||
dbo.SID_Enrollments | VISA_TYP | varchar | 3 | DWHOUSE | ENROLLMENTS_VW | VISA_TYP | ||
dbo.SID_Enrollments | INST_CLASS_LVL_STU | varchar | 1 | DWHOUSE | ENROLLMENTS_VW | INST_CLASS_LVL_STU | ||
dbo.SID_Enrollments | FULL_PART_TIME_IND | varchar | 1 | DWHOUSE | ENROLLMENTS_VW | FULL_PART_TIME_IND | ||
dbo.SID_Enrollments | CURR_TERM_CRS_LOAD | numeric | DWHOUSE | ENROLLMENTS_VW | CURR_TERM_CRS_LOAD | |||
dbo.SID_Enrollments | CUM_HRS_ACCEPT_TRN | numeric | DWHOUSE | ENROLLMENTS_VW | CUM_HRS_ACCEPT_TRN | |||
dbo.SID_Enrollments | GPA_INST_HRS | numeric | DWHOUSE | ENROLLMENTS_VW | GPA_INST_HRS | |||
dbo.SID_Enrollments | GPA_INST_GRD_PTS | numeric | DWHOUSE | ENROLLMENTS_VW | GPA_INST_GRD_PTS | |||
dbo.SID_Enrollments | TOT_HRS_DEG_LVL | numeric | DWHOUSE | ENROLLMENTS_VW | TOT_HRS_DEG_LVL | |||
dbo.SID_Enrollments | GPA_TERM_CRED_HRS | numeric | DWHOUSE | ENROLLMENTS_VW | GPA_TERM_CRED_HRS | |||
dbo.SID_Enrollments | GPA_TERM_HRS | numeric | DWHOUSE | ENROLLMENTS_VW | GPA_TERM_HRS | |||
dbo.SID_Enrollments | GPA_TERM_GRD_PTS | numeric | DWHOUSE | ENROLLMENTS_VW | GPA_TERM_GRD_PTS | |||
dbo.SID_Enrollments | FLA_PUBLIC_HS_FLG | varchar | 1 | ? | ? | ? | All NULL | |
dbo.SID_Enrollments | IPEDS_GRADSTU_FLG | varchar | 1 | DWHOUSE | ENROLLMENTS_VW | Calculated: Y, X, N | As per STU_CLASS_LECVEL flag | |
dbo.SID_Enrollments | WAIVER_HR_GRAD_STU | numeric | ? | ? | ? | All NULL | ||
dbo.SID_Enrollments | GPA_TERM | numeric | DWHOUSE | ENROLLMENTS_VW | Calculated: GPA_TERM_GRD_PTS/GPA_TERM_CRED_HRS | |||
dbo.SID_Enrollments | GPA_CUM | numeric | DWHOUSE | ENROLLMENTS_VW | Calculated: (GPA_INST_GRD_PTS + GPA_TERM_GRD_PTS) / GPA_INST_HRS GPA_TERM_GRD_PTS | |||
dbo.SID_Enrollments | CITIZENSHIP_CODE | char | 1 | DWHOUSE | HUB_PERSON_CURRENT_V | CITZ_CODE | ||
dbo.SID_Enrollments | HONORS | char | 1 | PROD_RO | Join: SGBSTDN, SGRSATT, STVTERM, SFRSTCR… | Calculated: N , Y | Default = N; Y if found in Honors attribute | |
dbo.SID_Enrollments | REPT_INST | varchar | 4 | DWHOUSE | ENROLLMENTS_VW | REPT_INST | ||
dbo.SID_Enrollments | FATHER_HI_GRADE | varchar | 1 | DWHOUSE | HUB_ENROLLMENTS_CURR_V | FATHER_HI_GRADE | ||
dbo.SID_Enrollments | MOTHER_HI_GRADE | varchar | 1 | DWHOUSE | HUB_ENROLLMENTS_CURR_V | MOTHER_HI_GRADE | ||
dbo.SID_Enrollments | OASIS_PIDM | float | DWHOUSE | ENROLLMENTS_VW | OASIS_PIDM | |||
dbo.SID_Enrollments | ADMT_CODE | varchar | 2 | DWHOUSE | HUB_ENROLLMENTS_CURR_V | ADMT_CODE | ||
dbo.SID_Enrollments | Stu_Class_Level_Rpt | varchar | 1 | DWHOUSE | ENROLLMENTS_VW | Calculated: N, B | Per columns: STU_CLASS_LEVEL / INST_CLASS_LVL_STU / deg_level_sought / STU_RECENT_ADM_TYP | |
dbo.SID_Enrollments | Stu_Recent_Adm_Typ_Rpt | varchar | 1 | DWHOUSE | ENROLLMENTS_VW | Calculated: B or STU_RECENT_ADM_TYP | Per column: STU_ADM_TYP | |
dbo.SID_Enrollments | Dept | varchar | 4 | DWHOUSE | HUB_ENROLLMENTS_CURR_V | DEPT_CODE | Excpetion logic as per MAJOR & COLLEGE | |
dbo.SID_Enrollments | College_Rpt | varchar | 2 | DWHOUSE | HUB_ENROLLMENTS_CURR_V | Calculated: ED, EP, 00 | Per columns: COLLEGE, DEPT, FEE_CLASS_KIND, STU_CLASS_LEVEL_RPT | |
dbo.SID_Enrollments | Timestamp | datetime | SQL | Database | Timestamp | |||
dbo.SID_Enrollments | Military_Status | nvarchar | 1 | DWHOUSE | ENROLLMENTS_VW | Military_Status | ||
dbo.SID_Enrollments | Vet_Benefits | nvarchar | 2 | DWHOUSE | ENROLLMENTS_VW | Vet_Benefits | ||
dbo.SID_Enrollments | Excess_Credit_Hrs | numeric | DWHOUSE | ENROLLMENTS_VW | Excess_Credit_Hrs | |||
dbo.SID_Enrollments | INTO_FLG | varchar | 5 | DWHOUSE | HUB_ENROLLMENTS_CURR_V | INTO_FLG | ||
dbo.SID_Enrollments | Flag_Prepaid_Tuition | varchar | 5 | PROD_RO | SGRSATT | sgrsatt_atts_code | ||
dbo.SID_Enrollments | INTO_Group | varchar | 5 | PROD_RO | SGRSATT | sgrsatt_atts_code | ||
dbo.SID_Enrollments | Flag_Housing | varchar | 1 | PROD_RO | SPRADDR | Calculated: Y, X, N | Based on JOIN and DATE RANGE Logic | |
dbo.SID_Enrollments | MajorConcentration | varchar | 50 | DWHOUSE | HUB_ENROLLMENTS_CURR_V | Derived from: MAJR_CODE or DSS_MAJOR + CONC1 | If MAJOR_CODE IS NULL use DSS_MAJOR + CONC1 | |
dbo.SID_Enrollments | CUM_HRS_ACCEPT_TRN_PRIOR | numeric | DWHOUSE | ENROLLMENTS_VW | CUM_HRS_ACCEPT_TRN_PRIOR | |||
dbo.SID_Enrollments | CUM_HRS_EARNED_TRN_AFTER | numeric | DWHOUSE | ENROLLMENTS_VW | CUM_HRS_EARNED_TRN_AFTER | |||
dbo.SID_Enrollments | DEGC_CODE | varchar | 10 | DWHOUSE | HUB_ENROLLMENTS_CURR_V | DEGC_CODE |