Page Comparison

...

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_10_Base_College_Major_Course_StudentTB_Fct_SOC_Enrrollment_12_Base_College_Major_Course_Student_Monthly

   tblEOTSOCCourseMeetingData

    

   table not yet processed or not completed

   TB_Dim_AcademicOrProfessional	column source not found AcademicOrProfessionalDesc
   TB_Dim_Student_NewFlag_SQL	can't locate insert /update source in SP dump
   TB_Dim_Time_Acad_Bridge	can't locate insert /update source in SP dump
   TB_Dim_AcademicOrProfessional	can't locate insert /update source in SP dump
   TB_Dim_CollegeDepartmentCourse_Enrollment	column source not found CourseFixVarUnits ActiveRecordFlag
   TB_Dim_Course_MeetingBuildingRoom	column source not found MeetingRoomStandardFlag
   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
   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 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
   TB_Dim_Time_Calendar_Month	can't locate insert /update source in SP dump
   TB_Dim_Time_Calendar_Month_Bridge	not found in  SP dump
   TB_Dim_Time_Cohort	can't locate insert /update source in SP dump
   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.	tblCollegeCode	can't locate insert /update source in SP dump
   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 CollegeCodeByCourseCode Dimensions______________________ Fact____________________________ FullTimeStatusFlag 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____________________________ MajorCount 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