Versions Compared

Old Version 1

changes.mady.by.user Michael Harvey

Saved on

compared with

New Version 2

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_NameMetaMart_DescriptionNotes_LogicMeta_Mart_Link
dbo.SID_Instructional_ActivityTERMIDvarchar8DWHOUSEINSTRUCTIONAL_ACTIVITY_VW REPT_TIME_FRAME   
dbo.SID_Instructional_ActivityBENCHvarchar1Run-time parameterN/A@BENCH' (B, F, D, E)N/AEntered / passed through at run-time in ETL
dbo.SID_Instructional_ActivitySESSION_IDvarchar1DWHOUSEINSTRUCTIONAL_ACTIVITY_VW SESSION_ID   
dbo.SID_Instructional_ActivityCRS_PREFIXvarchar3DWHOUSEINSTRUCTIONAL_ACTIVITY_VW CRS_PREFIX   
dbo.SID_Instructional_ActivityCRS_NBRvarchar4DWHOUSEINSTRUCTIONAL_ACTIVITY_VW CRS_NBR   
dbo.SID_Instructional_ActivityCRS_INDvarchar1DWHOUSEINSTRUCTIONAL_ACTIVITY_VW CRS_IND   
dbo.SID_Instructional_ActivityCRS_SECTN_NBRvarchar6DWHOUSEINSTRUCTIONAL_ACTIVITY_VW CRS_SECTN_NBR   
dbo.SID_Instructional_ActivityREF_NUMvarchar5DWHOUSEHUB_INSTRUCT_ACT_CURR_V  COURSE_CRN_NUMBER   
dbo.SID_Instructional_ActivityCAMPUS_Fvarchar4DWHOUSEHUB_INSTRUCT_ACT_CURR_V  OPERATING_UNIT Calculated: 0001,0003,0004,0012
dbo.SID_Instructional_ActivityCRS_SECTN_TYP_PRIvarchar1DWHOUSEINSTRUCTIONAL_ACTIVITY_VW CRS_SECTN_TYP_PRI   
dbo.SID_Instructional_ActivityVAR_CRED_FLGvarchar1DWHOUSEINSTRUCTIONAL_ACTIVITY_VW VAR_CRED_FLG   
dbo.SID_Instructional_ActivityCIP_CRSvarchar6DWHOUSEINSTRUCTIONAL_ACTIVITY_VW CIP_CRS   
dbo.SID_Instructional_ActivityBE_CD_CRSvarchar1DWHOUSEINSTRUCTIONAL_ACTIVITY_VW BE_CD_CRS   
dbo.SID_Instructional_ActivityDEPT_ID_CRSvarchar9DWHOUSEINSTRUCTIONAL_ACTIVITY_VW DEPT_ID_CRS   
dbo.SID_Instructional_ActivitySECTN_ENROLL_CREDnumeric DWHOUSEINSTRUCTIONAL_ACTIVITY_VW SECTN_ENROLL_CRED   
dbo.SID_Instructional_ActivityCRS_CRED_HRSnumeric DWHOUSEINSTRUCTIONAL_ACTIVITY_VW CRS_CRED_HRS   
dbo.SID_Instructional_ActivityACT_SECTN_INSTR_HRSnumeric DWHOUSEINSTRUCTIONAL_ACTIVITY_VW ACT_SECTN_INSTR_HRS   
dbo.SID_Instructional_ActivityDELIVERY_INDvarchar1DWHOUSEINSTRUCTIONAL_ACTIVITY_VW DELIVERY_IND   
dbo.SID_Instructional_ActivityTECH_IND_PRIMARYvarchar1DWHOUSEINSTRUCTIONAL_ACTIVITY_VW TECH_IND_PRIMARY   
dbo.SID_Instructional_ActivityTECH_IND_SECONDARYvarchar1DWHOUSEINSTRUCTIONAL_ACTIVITY_VW TECH_IND_SECONDARY   
dbo.SID_Instructional_ActivityTECH_IND_TERTIARYvarchar1DWHOUSEINSTRUCTIONAL_ACTIVITY_VW TECH_IND_TERTIARY   
dbo.SID_Instructional_ActivityCOUNTRY_CDvarchar5DWHOUSEINSTRUCTIONAL_ACTIVITY_VW COUNTRY_CD   
dbo.SID_Instructional_ActivitySECTN_HEADCNT_ENROLnumeric DWHOUSEHUB_INSTRUCT_ACT_CURR_V  ENRL_COUNT Calculated from Courses Taken
dbo.SID_Instructional_ActivityTOTAL_CRS_CRED_HRSnumeric DWHOUSE COURSES_TAKEN_VWSTU_SECTN_FUND_CD Calculated from Courses Taken
dbo.SID_Instructional_ActivityFNDBL_CRS_CRED_HRSnumeric DWHOUSEHUB_CRSE_TAKEN_CURR_VST_FUND_CRED_HRS Calculated from Courses Taken
dbo.SID_Instructional_ActivityFNDBL_GRAD_DOC_HRSnumeric DWHOUSEHUB_CRSE_TAKEN_CURR_VST_FUND_CRED_HRS Calculated from Courses Taken
dbo.SID_Instructional_ActivityDOC_STU_GRAD_HRSnumeric DWHOUSE COURSES_TAKEN_VWSTU_SECTN_CRED   
dbo.SID_Instructional_ActivityREPT_INSTvarchar4DWHOUSEINSTRUCTIONAL_ACTIVITY_VW REPT_INST   
dbo.SID_Instructional_ActivityXLST_GROUPvarchar2DWHOUSEHUB_INSTRUCT_ACT_CURR_V  XLST_GROUP   
dbo.SID_Instructional_ActivityOPERATING_UNITvarchar8DWHOUSEHUB_INSTRUCT_ACT_CURR_V  OPERATING_UNIT   
dbo.SID_Instructional_ActivityFUND_CODEvarchar5DWHOUSEHUB_INSTRUCT_ACT_CURR_V  FUND_CODE   
dbo.SID_Instructional_ActivityDEPTIDvarchar10DWHOUSEHUB_INSTRUCT_ACT_CURR_V  DEPTID   
dbo.SID_Instructional_ActivityPRODUCTvarchar6DWHOUSEHUB_INSTRUCT_ACT_CURR_V  PRODUCT   
dbo.SID_Instructional_ActivityCHARTFIELD1varchar10DWHOUSEHUB_INSTRUCT_ACT_CURR_V  CHARTFIELD1   
dbo.SID_Instructional_ActivityPROJECT_IDvarchar15DWHOUSEHUB_INSTRUCT_ACT_CURR_V  PROJECT_ID   
dbo.SID_Instructional_ActivitySRNvarchar20DWHOUSEHUB_CRSE_TAKEN_CURR_VDEPT_ID_CRS   
dbo.SID_Instructional_ActivityCourse_Titlevarchar500DWHOUSEHUB_INSTRUCT_ACT_CURR_V  COURSE_TITLE_NAME   
dbo.SID_Instructional_ActivityEff_Sectiondecimal DWHOUSE COURSE_MEETINGS_VWCalculated: 1.0 / Count of course meetings?Indirectly from SID_Course_Meetings via SPROC PROC_DataLoad_GenerateEffCourseSections
dbo.SID_Instructional_ActivityTimestampdatetime SQL DatabaseTimestamp   
dbo.SID_Instructional_ActivityDelivery_Methd_Indnvarchar2DWHOUSEINSTRUCTIONAL_ACTIVITY_VW Delivery_Methd_Ind   
dbo.SID_Instructional_ActivityFlag_Online_Coursevarchar1DWHOUSEINSTRUCTIONAL_ACTIVITY_VW Calculated: Y or N Derived from TECH_IND_PRIMARY, TECH_IND_SECONDARY, TECH_IND_TERTIARY
dbo.SID_Instructional_ActivityFlag_FKL_Coursevarchar1PROD_ROSSRATTRCalculated: Y or N Derived from ATTR_CODE
dbo.SID_Instructional_ActivityUSF_Identifiersvarchar50PROD_ROSSRATTRCalculated: USF_Identifiers + 'W' Derived from ATTR_CODE
dbo.SID_Instructional_ActivityFNDBL_CRS_CRED_HRS_AARnumeric DWHOUSE COURSES_TAKEN_VWSTU_SECTN_CRED Calculated from Courses Taken