Data Source View Table

Property	Value
Table Name	dbo_DimTerm
Database Table Name	DimTerm
Schema	dbo
Friendly Name	DimTerm
Table Type	Table
Query Definition
Description

Column Name	Friendly Name	Data Type	Computed Column Expression	Description
TermSK	TermSK	System.Int32
TermAK	TermAK	System.Int32
TermStartDate	TermStartDate	System.DateTime
TermEndDate	TermEndDate	System.DateTime
TermTitle	TermTitle	System.String(30)
AcademicYearCode	AcademicYearCode	System.String(7)
AcademicYear	AcademicYear	System.String(30)
TermYear	TermYear	System.String(4)
TermTypeCode	TermTypeCode	System.String(3)
TermType	TermType	System.String(15)
ActiveTerm	ActiveTerm	System.String(3)
DefaultTerm	DefaultTerm	System.String(3)
RelativeDay	RelativeDay	System.Int32
PriorYearTerm	PriorYearTerm	System.String(6)
RowIsCurrent	RowIsCurrent	System.String(1)
RowStartDate	RowStartDate	System.DateTime
RowEndDate	RowEndDate	System.DateTime
StateReportingTermYear		System.String(4)
StateReportingTermSequence		System.Byte

Table Name

Using Column

Friendly Name

Table Type

Is Logical

Description

Table Name	Using Column	Friendly Name	Table Type	Is Logical	Description
FactApplicationStatus	ApplicationTermSK	FactApplicationStatus	Table	False
FactStudentTotalFeesForClass	TermSK	FactStudentTotalFeesForClass	Table	False
FactStudentTotalFees	TermSK	FactStudentTotalFees	Table	False
FactStudentFeesPaid	TermSK	FactStudentFeesPaid	Table	False
FactProgramRetentionSnapshot	ProgramRetentionTrackingTermSK	FactProgramRetentionSnapshot	Table	False
FactProgramRetentionSnapshot	ProgramRetentionCohortTermSK	FactProgramRetentionSnapshot	Table	False
FactInstitutionalRetentionSnapshot	InstitutionalRetentionTrackingTermSK	FactInstitutionalRetentionSnapshot	Table	False
FactInstitutionalRetentionSnapshot	InstitutionalRetentionCohortTermSK	FactInstitutionalRetentionSnapshot	Table	False
FactStudentSuccess_TermSnapshot	StudentSuccessCohortTermSK	FactStudentSuccess_TermSnapshot	Table	False
FactStudentSuccess_TermSnapshot	TrackingTermSK	FactStudentSuccess_TermSnapshot	Table	False
FactStudentSuccess_FirstYearSnapshot	FirstYearTermSK	FactStudentSuccess_FirstYearSnapshot	Table	False
FactStudentSuccess_FirstYearSnapshot	StudentSuccessCohortTermSK	FactStudentSuccess_FirstYearSnapshot	Table	False
FactStudentGraduation	GraduationTermSK	FactStudentGraduation	Table	False
FactStudentGrades	TermSK	FactStudentGrades	Table	False
FactEnrollmentActivity	TermSK	FactEnrollmentActivity	Table	False
FactEnrollmentSnapshot	TermSK	FactEnrollmentSnapshot	Table	False
FactPriorEnrollmentSnapshot	ActiveTermSK	FactPriorEnrollmentSnapshot	Table	False
FactPriorEnrollmentSnapshot	PriorTermSK	FactPriorEnrollmentSnapshot	Table	False
FactEOTEnrollmentSnapshot	ActiveTermSK	FactEOTEnrollmentSnapshot	Table	False
FactEOTEnrollmentSnapshot	EOTTermSK	FactEOTEnrollmentSnapshot	Table	False
FactActiveEnrollmentSnapshot	TermSK	FactActiveEnrollmentSnapshot	Table	False