Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

 

This page documents data-items in the SID Enrollments table.

 

TableNameCOLUMN_NAMEdata_typeMaxLengthSource_SystemSource_TableSource_Column_NameNotes_LogicMeta_Mart_Link
dbo.SID_EnrollmentsTERMIDvarchar8DWHOUSEENROLLMENTS_VWDEMO_TIME_FRAME  
dbo.SID_EnrollmentsBENCHvarchar1Run-time parameterN/A@BENCH' (B, F, D, E)Entered/passed at run-time in ETL 
dbo.SID_EnrollmentsUIDvarchar9DWHOUSEENROLLMENTS_VWUSF_ID or 'UP' + OASIS_PIDM (starting at position 7 in field, if USF_ID is NULL)  
dbo.SID_EnrollmentsFEE_CLASS_KINDvarchar1DWHOUSEENROLLMENTS_VWFEE_CLASS_KIND  
dbo.SID_EnrollmentsHOMECAMPUSvarchar4DWHOUSEENROLLMENTS_VWU_RESV_2  
dbo.SID_EnrollmentsCOLLEGEvarchar2DWHOUSEHUB_ENROLLMENTS_CURR_V  COLL_CODE_ORG  
dbo.SID_EnrollmentsMAJORvarchar5DWHOUSEHUB_ENROLLMENTS_CURR_V  Derived from: MAJR_CODE or DSS_MAJORIF MAJR_CODE IS NULL use DSS_MAJOR 
dbo.SID_EnrollmentsGENDERchar1DWHOUSE PERSON_DEMO_VWGENDER  
dbo.SID_EnrollmentsETHNICchar1DWHOUSE PERSON_DEMO_VWRACE_ETHNICITYCalculated values: O, H, X, M, I, A, B, P, W, X 
dbo.SID_EnrollmentsNATION_CITIZvarchar5DWHOUSEENROLLMENTS_VWNATION_CITIZ or 'ZZ' if column is NULL  
dbo.SID_EnrollmentsSTATE_ADMvarchar2DWHOUSEENROLLMENTS_VWSTATE_ADM  
dbo.SID_EnrollmentsCOUNTY_OF_RESvarchar4DWHOUSEENROLLMENTS_VWCOUNTY_OF_RES  
dbo.SID_EnrollmentsNAT_MERIT_SCH_INDvarchar1DWHOUSEENROLLMENTS_VWNAT_MERIT_SCH_IND  
dbo.SID_EnrollmentsDISPLACED_STU_INDvarchar1DWHOUSEENROLLMENTS_VWDISPLACED_STU_IND  
dbo.SID_EnrollmentsINST_DISPLACED_FROMvarchar8DWHOUSEENROLLMENTS_VWINST_DISPLACED_FROM  
dbo.SID_EnrollmentsHS_ETS_CDvarchar6DWHOUSEENROLLMENTS_VWHS_ETS_CD  
dbo.SID_EnrollmentsLAST_SECONDARY_DTvarchar6DWHOUSEENROLLMENTS_VWLAST_SECONDARY_DT  
dbo.SID_EnrollmentsDUAL_ENROLL_INDvarchar1DWHOUSEENROLLMENTS_VWDUAL_ENROLL_IND  
dbo.SID_EnrollmentsLAST_INST_CDvarchar8DWHOUSEENROLLMENTS_VWLAST_INST_CD  
dbo.SID_EnrollmentsLAST_POSTSEC_DTvarchar6DWHOUSEENROLLMENTS_VWLAST_POSTSEC_DT  
dbo.SID_EnrollmentsSTU_ENTRY_TYPvarchar1DWHOUSEENROLLMENTS_VWSTU_ENTRY_TYP  
dbo.SID_EnrollmentsSTU_ENTRY_DTvarchar6DWHOUSEENROLLMENTS_VWSTU_ENTRY_DT  
dbo.SID_EnrollmentsSTU_RECENT_ADM_TYPvarchar1DWHOUSEENROLLMENTS_VWSTU_RECENT_ADM_TYP  
dbo.SID_EnrollmentsSTU_RECENT_ADM_DTvarchar6DWHOUSEENROLLMENTS_VWSTU_RECENT_ADM_DT  
dbo.SID_EnrollmentsFIRST_GEN_INDvarchar1DWHOUSEENROLLMENTS_VWFIRST_GEN_IND  
dbo.SID_EnrollmentsFEE_CLASS_RESvarchar1DWHOUSEENROLLMENTS_VWFEE_CLASS_RES  
dbo.SID_EnrollmentsCLAST_INDvarchar1DWHOUSEENROLLMENTS_VWCLAST_IND  
dbo.SID_EnrollmentsMAX_CRED_TEACH_FLGvarchar1DWHOUSEENROLLMENTS_VWMAX_CRED_TEACH_FLG  
dbo.SID_EnrollmentsMAX_CRED_RESEARCH_FLGvarchar1DWHOUSEENROLLMENTS_VWMAX_CRED_RESEARCH_FLG  
dbo.SID_EnrollmentsDOC_CANDIDACY_FLGvarchar1DWHOUSEENROLLMENTS_VWDOC_CANDIDACY_FLG  
dbo.SID_EnrollmentsSTU_CLASS_LEVELvarchar1DWHOUSEENROLLMENTS_VWSTU_CLASS_LEVEL  
dbo.SID_EnrollmentsCIP_STUDENTvarchar6DWHOUSEENROLLMENTS_VWCIP_STUDENT  
dbo.SID_EnrollmentsDEG_HIGHEST_HELDvarchar1DWHOUSEENROLLMENTS_VWDEG_HIGHEST_HELD  
dbo.SID_EnrollmentsINST_GRNT_HIDEG_CDvarchar8DWHOUSEENROLLMENTS_VWINST_GRNT_HIDEG_CD  
dbo.SID_EnrollmentsDEG_LEVEL_SOUGHTvarchar1DWHOUSEENROLLMENTS_VWDEG_LEVEL_SOUGHT  
dbo.SID_EnrollmentsDOC_CLASSvarchar1DWHOUSEENROLLMENTS_VWDOC_CLASS  
dbo.SID_EnrollmentsBE_CDvarchar1DWHOUSEENROLLMENTS_VWBE_CD  
dbo.SID_EnrollmentsFIRSTYR_FIRSTPROF_FLGvarchar1DWHOUSEENROLLMENTS_VWFIRSTYR_FIRSTPROF_FLG  
dbo.SID_EnrollmentsTERMINATION_CDvarchar1DWHOUSEENROLLMENTS_VWTERMINATION_CD  
dbo.SID_EnrollmentsEXT_PGM_FLGvarchar1DWHOUSEENROLLMENTS_VWEXT_PGM_FLG  
dbo.SID_EnrollmentsVISA_TYPvarchar3DWHOUSEENROLLMENTS_VWVISA_TYP  
dbo.SID_EnrollmentsINST_CLASS_LVL_STUvarchar1DWHOUSEENROLLMENTS_VWINST_CLASS_LVL_STU  
dbo.SID_EnrollmentsFULL_PART_TIME_INDvarchar1DWHOUSEENROLLMENTS_VWFULL_PART_TIME_IND  
dbo.SID_EnrollmentsCURR_TERM_CRS_LOADnumeric DWHOUSEENROLLMENTS_VWCURR_TERM_CRS_LOAD  
dbo.SID_EnrollmentsCUM_HRS_ACCEPT_TRNnumeric DWHOUSEENROLLMENTS_VWCUM_HRS_ACCEPT_TRN  
dbo.SID_EnrollmentsGPA_INST_HRSnumeric DWHOUSEENROLLMENTS_VWGPA_INST_HRS  
dbo.SID_EnrollmentsGPA_INST_GRD_PTSnumeric DWHOUSEENROLLMENTS_VWGPA_INST_GRD_PTS  
dbo.SID_EnrollmentsTOT_HRS_DEG_LVLnumeric DWHOUSEENROLLMENTS_VWTOT_HRS_DEG_LVL  
dbo.SID_EnrollmentsGPA_TERM_CRED_HRSnumeric DWHOUSEENROLLMENTS_VWGPA_TERM_CRED_HRS  
dbo.SID_EnrollmentsGPA_TERM_HRSnumeric DWHOUSEENROLLMENTS_VWGPA_TERM_HRS  
dbo.SID_EnrollmentsGPA_TERM_GRD_PTSnumeric DWHOUSEENROLLMENTS_VWGPA_TERM_GRD_PTS  
dbo.SID_EnrollmentsFLA_PUBLIC_HS_FLGvarchar1???All NULL 
dbo.SID_EnrollmentsIPEDS_GRADSTU_FLGvarchar1DWHOUSEENROLLMENTS_VWCalculated: Y, X, N As per STU_CLASS_LECVEL flag 
dbo.SID_EnrollmentsWAIVER_HR_GRAD_STUnumeric ???All NULL 
dbo.SID_EnrollmentsGPA_TERMnumeric DWHOUSEENROLLMENTS_VWCalculated: GPA_TERM_GRD_PTS/GPA_TERM_CRED_HRS  
dbo.SID_EnrollmentsGPA_CUMnumeric DWHOUSEENROLLMENTS_VWCalculated:  (GPA_INST_GRD_PTS + GPA_TERM_GRD_PTS)  / GPA_INST_HRS GPA_TERM_GRD_PTS 
dbo.SID_EnrollmentsCITIZENSHIP_CODEchar1DWHOUSE HUB_PERSON_CURRENT_VCITZ_CODE  
dbo.SID_EnrollmentsHONORSchar1PROD_ROJoin: SGBSTDN, SGRSATT, STVTERM,  SFRSTCR…Calculated: N , YDefault = N; Y if found in Honors attribute 
dbo.SID_EnrollmentsREPT_INSTvarchar4DWHOUSEENROLLMENTS_VWREPT_INST  
dbo.SID_EnrollmentsFATHER_HI_GRADEvarchar1DWHOUSEHUB_ENROLLMENTS_CURR_V  FATHER_HI_GRADE  
dbo.SID_EnrollmentsMOTHER_HI_GRADEvarchar1DWHOUSEHUB_ENROLLMENTS_CURR_V  MOTHER_HI_GRADE  
dbo.SID_EnrollmentsOASIS_PIDMfloat DWHOUSEENROLLMENTS_VWOASIS_PIDM  
dbo.SID_EnrollmentsADMT_CODEvarchar2DWHOUSEHUB_ENROLLMENTS_CURR_V  ADMT_CODE  
dbo.SID_EnrollmentsStu_Class_Level_Rptvarchar1DWHOUSEENROLLMENTS_VWCalculated: N, BPer columns:  STU_CLASS_LEVEL / INST_CLASS_LVL_STU / deg_level_sought / STU_RECENT_ADM_TYP 
dbo.SID_EnrollmentsStu_Recent_Adm_Typ_Rptvarchar1DWHOUSEENROLLMENTS_VWCalculated: B or STU_RECENT_ADM_TYPPer column: STU_ADM_TYP 
dbo.SID_EnrollmentsDeptvarchar4DWHOUSEHUB_ENROLLMENTS_CURR_V  DEPT_CODEExcpetion logic as per MAJOR & COLLEGE 
dbo.SID_EnrollmentsCollege_Rptvarchar2DWHOUSEHUB_ENROLLMENTS_CURR_V  Calculated: ED, EP, 00Per columns: COLLEGE, DEPT, FEE_CLASS_KIND, STU_CLASS_LEVEL_RPT 
dbo.SID_EnrollmentsTimestampdatetime SQL DatabaseTimestamp  
dbo.SID_EnrollmentsMilitary_Statusnvarchar1DWHOUSEENROLLMENTS_VWMilitary_Status  
dbo.SID_EnrollmentsVet_Benefitsnvarchar2DWHOUSEENROLLMENTS_VWVet_Benefits  
dbo.SID_EnrollmentsExcess_Credit_Hrsnumeric DWHOUSEENROLLMENTS_VWExcess_Credit_Hrs  
dbo.SID_EnrollmentsINTO_FLGvarchar5DWHOUSEHUB_ENROLLMENTS_CURR_V  INTO_FLG  
dbo.SID_EnrollmentsFlag_Prepaid_Tuitionvarchar5PROD_ROSGRSATTsgrsatt_atts_code  
dbo.SID_EnrollmentsINTO_Groupvarchar5PROD_ROSGRSATTsgrsatt_atts_code  
dbo.SID_EnrollmentsFlag_Housingvarchar1PROD_ROSPRADDRCalculated: Y, X, N Based on JOIN and DATE RANGE Logic 
dbo.SID_EnrollmentsMajorConcentrationvarchar50DWHOUSEHUB_ENROLLMENTS_CURR_V  Derived from: MAJR_CODE or DSS_MAJOR + CONC1If MAJOR_CODE IS NULL use DSS_MAJOR + CONC1 
dbo.SID_EnrollmentsCUM_HRS_ACCEPT_TRN_PRIORnumeric DWHOUSEENROLLMENTS_VWCUM_HRS_ACCEPT_TRN_PRIOR  
dbo.SID_EnrollmentsCUM_HRS_EARNED_TRN_AFTERnumeric DWHOUSEENROLLMENTS_VWCUM_HRS_EARNED_TRN_AFTER  
dbo.SID_EnrollmentsDEGC_CODEvarchar10DWHOUSEHUB_ENROLLMENTS_CURR_V  DEGC_CODE  
  • No labels