03-28-14 Spread sheet table tracking

Update Status:

1. 1. 1. processed tables:

         TB_Dim_CIP

         TB_Dim_CIPSeries

         TB_Dim_CalifResidency

         TB_Dim_College_Enrollment

         TB_Dim_ClassStanding

         TB_Dim_College

         TB_Dim_CollegeDepartment

         TB_Dim_CollegeMajor

         TB_Dim_ClassStanding

         TB_Dim_AmericanHistory

         TB_Dim_AmericanInstitutions

         TB_Dim_Course_MeetingTime

         Course_MeetingTimeEnd

         Course_MeetingTimeStart

         TB_Dim_CollegeDepartmentCourse

         TB_Dim_CollegeDepartmentCourseSection

         TB_Dim_CollegeMajor

         TB_Dim_Course_MeetingDay

         TB_Dim_CollegeDepartmentCourseClassType

         TB_Dim_College_Enrollment

         TB_Dim_DegreeType

         TB_Dim_EnrollmentStatus

         TB_Dim_EntryLevelWriting

         TB_Dim_EthnicCodes2009

         TB_Dim_Gender

         TB_Dim_HomeLocation

         TB_Dim_LawStudentLevel

         TB_Dim_LawStudentTransfer

         TB_Dim_ProbationStatus

         TB_Dim_Program

         TB_Dim_School

         TB_Dim_SmrHomeUCCampus

         TB_Dim_Student

         TB_Dim_UCStudentStatus

         TB_Dim_Visa

         TB_Fct_CWE_00_Base_Acad_College_Dept_Course_Class_Level_Section_Class_Standing

         TB_Fct_CWE_00_Base_Acad_Dept_Course_Building_MeetingDay

         TB_Fct_CWE_01_Acad_College_Dept_Course_Class_Level_Section

         TB_Fct_Enrrollment_00_Base_College_Major_Student_Monthly_Enrolled

         TB_Fct_Enrrollment_00_Base_College_Major_Student_Monthly_Ext01

         TB_Fct_Enrrollment_01_College_Major_Monthly_Enrolled_Count_TYLY_Ext01

         TB_Fct_SOC_Enrrollment_12_Base_College_Major_Course_Student_Monthly

         tblEOTSOCCourseMeetingData

          

         table not yet processed or not completed

         Table	Ken	Durendal
         TB_Dim_AcademicOrProfessional	column source not found AcademicOrProfessionalDesc	Manually created: SELECT DISTINCT   [AcademicOrProfessional] FROM [dbLoadDWH].[dbo].[tblSIFMajor_ESB]
         TB_Dim_Student_NewFlag_SQL	can't locate insert /update source in SP dump	[DataMart].[usp_ETL_SIS_020b_Load_3rdWeek_EOT_Students_From_dbProduction]    SELECT DISTINCT       [NewStudentFlag]  FROM [dbProduction].[dbo].[tbl3rdWeekStudents]
         TB_Dim_Time_Acad_Bridge	can't locate insert /update source in SP dump	Time dimension -- manually created
         TB_Dim_AcademicOrProfessional	can't locate insert /update source in SP dump	Manually created: SELECT DISTINCT   [AcademicOrProfessional] FROM [dbLoadDWH].[dbo].[tblSIFMajor_ESB]
         TB_Dim_CollegeDepartmentCourse_Enrollment	column source not found CourseFixVarUnits ActiveRecordFlag	ActiveRecordFlag_ Manually added CourseFixVarUnits _ SELECT [FixedVariableUnits] FROM [dbLoadDWH].[dbo].[tblSOCScheduleofClasses_ESB]
         TB_Dim_Course_MeetingBuildingRoom	column source not found MeetingRoomStandardFlag	usp_ETL_SOC_220_Fact_Meeting_Building SELECT  DISTINCT RoomStandardFlag FROM [dbProduction].[dbo].[tbl3rdWeekCourseMeetingData]
         TB_Dim_School_Addresses	can't locate insert /update source in SP dump
         TB_Dim_LawStudentLevel	not found in  SP dump
         TB_DIM_STUDENT	COLUMN PhoneNumber01, PhoneNumber02, PhoneNumber03 source not found.
         TB_Dim_CollegeDepartmentCourseSectionSize	column source not found SectionSizeSort SectionSizeCode
         TB_Dim_CollegeMajor_Enrollment	can't locate insert /update source in SP dump	Time dimension -- manually created
         NetPayerTuitionStatus_SQL	not found in  SP dump
         TB_Dim_RegistrationStatus	can't locate insert /update source in SP dump
         TB_Dim_School_Addresses	can't locate insert /update source in SP dump
         TB_Dim_Student	can find the following column source: emailaddress02, emailaddress03, PhoneNumber01, PhoneNumber02, PhoneNumber03, Sat2Name1, MISSING DATA Sat2Nam2, MISSING DATA Sat2Name3, MISSING DATA LawStudentTransferDesc MISSING DATA
         TB_Dim_Student_ActiveFlag_SQL	not found in  SP dump
         TB_Dim_Student_FullTimeStaus_SQL	not found in  SP dump
         TB_Dim_Student_NetPayerWaiver_SQL	not found in  SP dump
         TB_Fct_SIS_Students_Primary	column source not found: CurrentUnitsAttemptedTotal_3rd CurrentUnitsAttemptedTotal_EOT CurrentUnitsCompletedTotal_3rd CurrentUnitsCompletedTotal_EOT CurrentUnitsGradCourses CurrentUnitsLDCourses CurrentUnitsUDCourses DAY_KEY Eth2009CodeSIS Dimensions______________________ EmailAddress1 Facts______________________ Rec Count StudentCount_3rd StudentCount_EOT StudentID_3rd StudentID_EOT Measures_________________________
         m_Student_NewFlag_SQL	not found in  SP dump
         TB_Dim_Time_Acad_Bridge	can't locate insert /update source in SP dump
         TB_Dim_Time_Calendar	can't locate insert /update source in SP dump	time dimension manually created
         TB_Dim_Time_Calendar_Month	can't locate insert /update source in SP dump	time dimension manually created
         TB_Dim_Time_Calendar_Month_Bridge	not found in  SP dump	time dimension manually created
         TB_Dim_Time_Cohort	can't locate insert /update source in SP dump	time dimension manually created
         TB_Fct_Enrrollment_01_College_Major_Daily_Enrolled_Count	not found in  SP dump
         TB_Fct_SIS_Students_Primary	column RecCount source not found.
         TB_Fct_Enrrollment_00_Base_College_Major_Student_Monthly_Enrolled	column hours, hours LY, COURSEACTUAL UNITS can't find source.
         vw_Dim_Time_Acad_Active_Enrollment	unsupported/ data missing
         vw_Dim_Time_Acad_Active_Enrollment_Month	can't find source in SP dump
         TB_Fct_SIS_Students_Primary	column source not found CurrentUnitsAttemptedTotal_3rd CurrentUnitsAttemptedTotal_EOT CurrentUnitsCompletedTotal_3rd CurrentUnitsCompletedTotal_EOT CurrentUnitsUDCourses Dimensions______________________ Facts______________________ Measures_________________________ Rec Count StudentCount_3rd StudentCount_EOT StudentID_3rd
         TB_Fct_CWE_00_Base_Acad_College_Dept_Course_Class_Level_Section_Class_Standing	column source not found SectionSize TaughtBySameCollege AcadTermAndCalYrForReporting ActiveStudentFlag ClassStandingExt Dimensions______________________ Fact____________________________ Measures________________________ MONTH_KEY PrimaryMajorStudentCount PrimaryMajorStudentID StudentCount StudentCount_Misc01 StudentCount_Misc02 StudentCount_Misc03 StudentCount_Misc04 StudentCount_Misc05
         TB_Fct_SOC_Enrrollment_10_Base_College_Major_Course_Student	AcademicOrProfessional AcadTermAndCalYrForReporting Units CourseFixVarUnits CourseMinUnits DAY_KEY Dimensions__Extension_01__________ Fact____________________________ Measures________________________ PrimaryMajorStudentCount StudentCount_Assessed StudentCount_Misc01 StudentCount_Misc02 StudentCount_Misc03 StudentCount_Misc04 StudentCount_Misc05 StudentCount_Registered Dimensions__Extension_01__________ PrimaryMajorStudentCount StudentCount StudentCount_Assessed StudentCount_Enrolled StudentCount_FeePaid