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 and process :
   
   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.
      7. scan backward up the row to check errors and make correction when necessary.
         
         
         

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

         TB_Dim_CollegeDepartmentCourseClassType

      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 dump
         TB_Dim_Time_Acad_Bridge	can't locate insert /update
         TB_Dim_AcademicOrProfessional	can't locate insert /update