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 the SID_Courses_Taken table which represents a composite of data from the Warehouse and Production Banner systems. 

 

 

TableNameCOLUMN_NAMEdata_typeMaxLengthSource_SystemSource_TableSource_Column_NameMetaMart_DescriptionNotes_LogicMeta_Mart_Link
dbo.SID_Courses_TakenTERMIDvarchar8DWHOUSE COURSES_TAKEN_VWDEMO_TIME_FRAME   
dbo.SID_Courses_TakenBENCHvarchar1Run-time parameterN/A@BENCH' (B, F, D, E)N/AEntered / passed through at run-time in ETL
dbo.SID_Courses_TakenUIDvarchar9DWHOUSE COURSES_TAKEN_VWUSF_ID   
dbo.SID_Courses_TakenFEE_CLASS_KINDvarchar1DWHOUSE COURSES_TAKEN_VWFEE_CLASS_KIND   
dbo.SID_Courses_TakenSEGMENT_SEQnumeric DWHOUSE COURSES_TAKEN_VWSEGMENT_SEQ   
dbo.SID_Courses_TakenCRS_PREFIXvarchar3DWHOUSE COURSES_TAKEN_VWCRS_PREFIX   
dbo.SID_Courses_TakenCRS_NBRvarchar4DWHOUSE COURSES_TAKEN_VWCRS_NBR   
dbo.SID_Courses_TakenCRS_INDvarchar1DWHOUSE COURSES_TAKEN_VWCRS_IND   
dbo.SID_Courses_TakenCRS_SECTN_NBRvarchar6DWHOUSE COURSES_TAKEN_VWCRS_SECTN_NBR   
dbo.SID_Courses_TakenSTU_SECTN_CREDnumeric DWHOUSE COURSES_TAKEN_VWSTU_SECTN_CRED   
dbo.SID_Courses_TakenREF_NUMvarchar5DWHOUSE COURSES_TAKEN_VWU_RESV_1 5 characters starting in position 15
dbo.SID_Courses_TakenSESSION_IDvarchar1DWHOUSEHUB_CRSE_TAKEN_CURR_VSESSION_ID   
dbo.SID_Courses_TakenCIP_CRSvarchar6DWHOUSE COURSES_TAKEN_VWCIP_CRS   
dbo.SID_Courses_TakenCAMPUS_Fvarchar4DWHOUSE COURSES_TAKEN_VWU_RESV_2 Set to '0001' if = '0038' (Health Science Funded)
dbo.SID_Courses_TakenCAMPUS_CDvarchar4DWHOUSE COURSES_TAKEN_VWCAMPUS_CD   
dbo.SID_Courses_TakenSITE_NBRvarchar4DWHOUSE COURSES_TAKEN_VWSITE_NBR   
dbo.SID_Courses_TakenCRS_SECTN_LOC_CNTYvarchar4DWHOUSE COURSES_TAKEN_VWCRS_SECTN_LOC_CNTY   
dbo.SID_Courses_TakenBE_CDvarchar1DWHOUSE COURSES_TAKEN_VWBE_CD   
dbo.SID_Courses_TakenCONT_COOP_ED_INDvarchar1DWHOUSE COURSES_TAKEN_VWCONT_COOP_ED_IND   
dbo.SID_Courses_TakenGRADE_AWARDEDvarchar2DWHOUSE COURSES_TAKEN_VWGRADE_AWARDED   
dbo.SID_Courses_TakenSTU_SECTN_FUND_CDvarchar1DWHOUSE COURSES_TAKEN_VWSTU_SECTN_FUND_CD   
dbo.SID_Courses_TakenCOLLEGEvarchar2DWHOUSE COURSES_TAKEN_VWCOLLEGE   
dbo.SID_Courses_TakenCRS_SECTN_TYP_PRIvarchar1DWHOUSE COURSES_TAKEN_VWCRS_SECTN_TYP_PRI   
dbo.SID_Courses_TakenPRELIM_FILE_FLGvarchar1DWHOUSE COURSES_TAKEN_VWPRELIM_FILE_FLG   
dbo.SID_Courses_TakenINST_OUTSIDE_INDvarchar2DWHOUSE COURSES_TAKEN_VWINST_OUTSIDE_IND   
dbo.SID_Courses_TakenDEPT_ID_CRSvarchar9DWHOUSE COURSES_TAKEN_VWDEPT_ID_CRS   
dbo.SID_Courses_TakenHRS_SURCHARGEnumeric DWHOUSEHUB_CRSE_TAKEN_CURR_VHRS_SURCHARGE   
dbo.SID_Courses_TakenDIFF_TUITION_FLGvarchar1DWHOUSE COURSES_TAKEN_VWDIFF_TUITION_FLG   
dbo.SID_Courses_TakenCRS_LEVEL_CLASSvarchar2DWHOUSEHUB_CRSE_TAKEN_CURR_VCalculated: 1,2,3,L,R,U Derived from CRS_NBR 
dbo.SID_Courses_TakenST_FUND_CRED_HRSnumeric DWHOUSEHUB_CRSE_TAKEN_CURR_VST_FUND_CRED_HRS   
dbo.SID_Courses_TakenREPT_INSTvarchar4LiteralVia QueryUSF N/AStored Procedure - Proc-DataLoad_SID
dbo.SID_Courses_TakenCRSE_DEPT_CODEvarchar4DWHOUSEHUB_CRSE_TAKEN_CURR_VCRSE_DEPT_CODE   
dbo.SID_Courses_TakenOVRR_DEPT_CODEvarchar4DWHOUSEHUB_CRSE_TAKEN_CURR_VOVRR_DEPT_CODE   
dbo.SID_Courses_TakenOPERATING_UNITvarchar8DWHOUSEHUB_CRSE_TAKEN_CURR_VOPERATING_UNIT   
dbo.SID_Courses_TakenFUND_CODEvarchar5DWHOUSEHUB_CRSE_TAKEN_CURR_VFUND_CODE   
dbo.SID_Courses_TakenDEPTIDvarchar10DWHOUSEHUB_CRSE_TAKEN_CURR_VDEPTID    
dbo.SID_Courses_TakenPRODUCTvarchar6DWHOUSEHUB_CRSE_TAKEN_CURR_VPRODUCT   
dbo.SID_Courses_TakenCHARTFIELD1varchar50DWHOUSEHUB_CRSE_TAKEN_CURR_VCHARTFIELD1   
dbo.SID_Courses_TakenPROJECT_IDvarchar15DWHOUSEHUB_CRSE_TAKEN_CURR_VPROJECT_ID   
dbo.SID_Courses_TakenSTAFF_WAIVED_HRSnumeric DWHOUSEHUB_CRSE_TAKEN_CURR_VSTAFF_WAIVED_HRS   
dbo.SID_Courses_TakenOASIS_PIDMfloat DWHOUSEHUB_CRSE_TAKEN_CURR_VOASIS_PIDM   
dbo.SID_Courses_TakenSRNvarchar20DWHOUSEHUB_CRSE_TAKEN_CURR_VDEPT_ID_CRS   
dbo.SID_Courses_TakenFee_Class_Resvarchar1DWHOUSEENROLLMENTS_VW Fee_Class_Res Load indirectly from SID_Enrollments
dbo.SID_Courses_TakenBldg_Code_Orgnvarchar50DWHOUSEHUB_CRSE_TAKEN_CURR_VBldg_Code_Org   
  • No labels