Weekly Status 02-28-2014

This week:

1. Store Procedure dumps:
   1. 1. dbDWH_script_20140224.sql
      2. dbLoadDWH_script_20140224.sql
   Spread sheet update
   1. 1. OIR metadata combined.xlsx
2. lessons and issues:
   1. 1. SOME Tables not found in SP dump.
      2. can't locate insert / uodate statement sometimes.
      3. SOME Tables has columns extracted from multiple tables.
      4. stop searching after identifying the non-dimensional table source.
      5. no need to record sid (identity columns).
      6. need to check OIR database to locate origin of the database or the column definition.
         
         
         

1. Update Status:

   1. 1. processed tables:

         TB_Dim_CalifResidency

         TB_Dim_College_Enrollment

         TB_Dim_ClassStanding

         TB_Dim_CollegeDepartment

         TB_Dim_College

         TB_Dim_ClassStanding

         TB_Dim_AmericanHistory

         TB_Dim_AmericanInstitutions

         TB_Dim_Course_MeetingTime

         Course_MeetingTimeEnd

         Course_MeetingTimeStart

         TB_Dim_CollegeDepartmentCourse

         TB_Dim_Course_MeetingDay

      2. table not yet processed

         TB_Dim_CIP
         TB_Dim_ClassStanding
         TB_Dim_ActiveStudentFlag	can't locate insert /update
         TB_Dim_AcademicOrProfessional	can't locate insert /update
         TB_Dim_Student_NewFlag_SQL	not found in SP
         TB_Dim_Time_Acad_Bridge	can't locate insert /update
         TB_Dim_AcademicOrProfessional	can't locate insert /update