Versions Compared

Old Version 2

changes.mady.by.user Michael Harvey

Saved on

compared with

New Version 3

changes.mady.by.user Michael Harvey

Saved on

Key

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

...

TableNameCOLUMN_NAMEdata_typeMaxLengthSource_SystemSource_TableSource_Column_NameNotes_LogicMeta _ Mart _LinkDescription
dbo.SID_Courses_TakenTERMIDvarchar8DWHOUSE COURSES COURSES_TAKEN_VWDEMO_TIME_FRAME  Academic term (YYYYMM) in which the demographic data is reported.
dbo.SID_Courses_TakenBENCHvarchar1Run-time parameterN/A@BENCH' (B, F, D, E)

Entered / passed at run-time

in ETL

dbo.SID_Courses_TakenUIDvarchar9DWHOUSE COURSES COURSES_TAKEN_VWUSF_ID  
dbo.SID_Courses_TakenFEE_CLASS_KINDvarchar1DWHOUSE COURSES COURSES_TAKEN_VWFEE_CLASS_KIND  
dbo.SID_Courses_TakenSEGMENT_SEQnumeric DWHOUSE COURSES COURSES_TAKEN_VW SEGMENT_SEQ  
dbo.SID_Courses_TakenCRS_PREFIXvarchar3DWHOUSE COURSES COURSES_TAKEN_VW CRS_PREFIX  
dbo.SID_Courses_TakenCRS_NBRvarchar4DWHOUSE COURSES COURSES_TAKEN_VW CRS_NBR  
dbo.SID_Courses_TakenCRS_INDvarchar1DWHOUSE COURSES COURSES_TAKEN_VW CRS_IND  
dbo.SID_Courses_TakenCRS_SECTN_NBRvarchar6DWHOUSE COURSES COURSES_TAKEN_VW CRS_SECTN_NBR  
dbo.SID_Courses_TakenSTU_SECTN_CREDnumeric DWHOUSE COURSES COURSES_TAKEN_VW STU_SECTN_CRED  
dbo.SID_Courses_TakenREF_NUMvarchar5DWHOUSE COURSES COURSES_TAKEN_VW U_RESV_1

5 characters starting

in position 15

dbo.SID_Courses_TakenSESSION_IDvarchar1DWHOUSEHUB_CRSE_TAKEN_CURR_VSESSION_ID  
dbo.SID_Courses_TakenCIP_CRSvarchar6DWHOUSE COURSES COURSES_TAKEN_VW CIP_CRS  
dbo.SID_Courses_TakenCAMPUS_Fvarchar4DWHOUSE COURSES COURSES_TAKEN_VW U_RESV_2

Set to '0001' if = '0038'

(Health Science Funded)

dbo.SID_Courses_TakenCAMPUS_CDvarchar4DWHOUSE COURSES COURSES_TAKEN_VW CAMPUS_CD  
dbo.SID_Courses_TakenSITE_NBRvarchar4DWHOUSE COURSES COURSES_TAKEN_VW SITE_NBR  
dbo.SID_Courses_TakenCRS_SECTN_LOC_CNTYvarchar4DWHOUSE COURSES COURSES_TAKEN_VW CRS_SECTN_LOC_CNTY  
dbo.SID_Courses_TakenBE_CDvarchar1DWHOUSE COURSES COURSES_TAKEN_VW BE_CD  
dbo.SID_Courses_TakenCONT_COOP_ED_INDvarchar1DWHOUSE COURSES COURSES_TAKEN_VW CONT_COOP_ED_IND  
dbo.SID_Courses_TakenGRADE_AWARDEDvarchar2DWHOUSE COURSES COURSES_TAKEN_VW GRADE_AWARDED  
dbo.SID_Courses_TakenSTU_SECTN_FUND_CDvarchar1DWHOUSE COURSES COURSES_TAKEN_VW STU_SECTN_FUND_CD  
dbo.SID_Courses_TakenCOLLEGEvarchar2DWHOUSE COURSES COURSES_TAKEN_VW COLLEGE  
dbo.SID_Courses_TakenCRS_SECTN_TYP_PRIvarchar1DWHOUSE COURSES COURSES_TAKEN_VW CRS_SECTN_TYP_PRI  
dbo.SID_Courses_TakenPRELIM_FILE_FLGvarchar1DWHOUSE COURSES COURSES_TAKEN_VW PRELIM_FILE_FLG  
dbo.SID_Courses_TakenINST_OUTSIDE_INDvarchar2DWHOUSE COURSES COURSES_TAKEN_VW INST_OUTSIDE_IND  
dbo.SID_Courses_TakenDEPT_ID_CRSvarchar9DWHOUSE COURSES COURSES_TAKEN_VW DEPT_ID_CRS  
dbo.SID_Courses_TakenHRS_SURCHARGEnumeric DWHOUSEHUB_CRSE_TAKEN_CURR_VHRS_SURCHARGE  
dbo.SID_Courses_TakenDIFF_TUITION_FLGvarchar1DWHOUSE COURSES COURSES_TAKEN_VW DIFF_TUITION_FLG  
dbo.SID_Courses_TakenCRS_LEVEL_CLASSvarchar2DWHOUSEHUB_CRSE_TAKEN_CURR_VCalculated: 1,2,3,L,R,UDerived from CRS_NBR 
dbo.SID_Courses_TakenST_FUND_CRED_HRSnumeric DWHOUSEHUB_CRSE_TAKEN_CURR_VST_FUND_CRED_HRS  
dbo.SID_Courses_TakenREPT_INSTvarchar4LiteralVia QueryUSF 

Stored 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  

...