Update Status:

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
all tables with TB_DIM_TIME prefix or embedded time sub-string	manually created no source identified. TB_Dim_Course_MeetingTime Acad TB_Dim_Time_Acad TB_Dim_Student_FullTimeStaus_SQL TB_Dim_Time_Acad_Bridge TB_Dim_Time_Calendar TB_Dim_Time_Calendar_Month TB_Dim_Time_Cohort vw_Dim_Time_Acad_Active_Enrollment vw_Dim_Time_Acad_Active_Enrollment_Month
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

Browser not supported