|
|
||||||
|
|
||||||
Properties
| Property | Value |
| Table Name | dbo_DimCurriculum |
| Database Table Name | DimCurriculum |
| Schema | dbo |
| Friendly Name | DimCurriculum |
| Table Type | Table |
| Query Definition | |
| Description |
Columns
Column Name |
Friendly Name |
Data Type |
Computed Column Expression |
Description |
|
 |
CurriculumSK |
CurriculumSK |
System.Int32 | ||
 |
ReferenceNumberAK |
ReferenceNumberAK |
System.Int32 | ||
|
ReferenceNumber |
ReferenceNumber |
System.Int32 | ||
|
Term |
Term |
System.String(6) | ||
|
TermTitle |
TermTitle |
System.String(30) | ||
|
CourseId |
CourseId |
System.String(10) | ||
|
CurrentTerm |
CurrentTerm |
System.String(6) | ||
|
CurrentCourseId |
CurrentCourseId |
System.String(10) | ||
|
CourseIdPrefix |
CourseIdPrefix |
System.String(3) | ||
|
ClassTitle |
ClassTitle |
System.String(25) | ||
|
CourseTypeCode |
CourseTypeCode |
System.String(3) | ||
|
CourseType |
CourseType |
System.String(30) | ||
|
CreditNonCreditVocational |
CreditNonCreditVocational |
System.String(15) | ||
|
CreditTypeCode |
CreditTypeCode |
System.String(3) | ||
|
CreditType |
CreditType |
System.String(30) | ||
|
CreditNonCredit |
CreditNonCredit |
System.String(15) | ||
|
ICSCode |
ICSCode |
System.String(5) | ||
|
InstructionalClassification |
InstructionalClassification |
System.String(30) | ||
|
DivisionCode |
DivisionCode |
System.String(4) | ||
|
Division |
Division |
System.String(60) | ||
|
DepartmentCode |
DepartmentCode |
System.String(4) | ||
|
Department |
Department |
System.String(60) | ||
|
CampusCode |
CampusCode |
System.String(3) | ||
|
Campus |
Campus |
System.String(50) | ||
|
CenterCode |
CenterCode |
System.String(4) | ||
|
Center |
Center |
System.String(50) | ||
|
MinimumClassSize |
MinimumClassSize |
System.Int16 | ||
|
MaximumClassSize |
MaximumClassSize |
System.Int16 | ||
|
ClassStatusCode |
ClassStatusCode |
System.String(3) | ||
|
ClassStatus |
ClassStatus |
System.String(30) | ||
|
TimeBlockCode |
TimeBlockCode |
System.String(3) | ||
|
TimeBlock |
TimeBlock |
System.String(30) | ||
|
DeliveryMethod |
DeliveryMethod |
System.String(30) | ||
|
PrimaryInstructorId |
PrimaryInstructorId |
System.Decimal | ||
|
PrimaryInstructorFullName |
PrimaryInstructorFullName |
System.String(50) | ||
|
PrimaryInstructorLastName |
PrimaryInstructorLastName |
System.String(50) | ||
|
PrimaryInstructorFirstName |
PrimaryInstructorFirstName |
System.String(30) | ||
|
PrimaryInstructorMiddleInitial |
PrimaryInstructorMiddleInitial |
System.String(20) | ||
|
SessionCode |
SessionCode |
System.String(4) | ||
|
Session |
Session |
System.String(30) | ||
|
Honors |
Honors |
System.String(3) | ||
|
WeekendCollege |
WeekendCollege |
System.String(3) | ||
|
DualEnrollment |
DualEnrollment |
System.String(3) | ||
|
IndependentStudy |
IndependentStudy |
System.String(3) | ||
|
Apprenticeship |
Apprenticeship |
System.String(3) | ||
|
VirtualCollege |
VirtualCollege |
System.String(3) | ||
|
Online100Percent |
Online100Percent |
System.String(3) | ||
|
WebEnabled |
WebEnabled |
System.String(3) | ||
|
WebBlended |
WebBlended |
System.String(3) | ||
|
ScheduleInformation |
ScheduleInformation |
System.String(250) | ||
|
RowIsCurrent |
RowIsCurrent |
System.String(1) | ||
|
RowStartDate |
RowStartDate |
System.DateTime | ||
|
RowEndDate |
RowEndDate |
System.DateTime | ||
|
CampusSort |
System.String(50) | CASE WHEN Campus = 'N/A' THEN 'zzz' ELSE Campus END |
Campus Sort field to put N/A at end. |
|
|
PrimaryInstructorType |
System.String(10) | |||
|
ICSCategoryCode |
System.String(3) | |||
|
InstructionalClassificationCategory |
System.String(30) | |||
|
TermCourseIdCount |
System.Int16 | |||
|
IsTermCourseIdCountGE10 |
System.String(3) | |||
|
IsCourseRepeatable |
System.String(3) | |||
|
CourseNumberTimesForCredit |
System.Int16 | |||
|
CourseLevel |
System.String(10) | |||
|
CreditNonCreditVocationalTest |
System.String(15) | |||
|
DivisionDescription |
System.String(50) | |||
|
DepartmentDescription |
System.String(50) |
Parent Relations
Table Name |
Using Column |
Friendly Name |
Table Type |
Is Logical |
Description |
Child Relations
Table Name |
Using Column |
Friendly Name |
Table Type |
Is Logical |
Description |
CurriculumSK |
FactStudentTotalFeesForClass |
Table |
False |
||
CurriculumSK |
FactStudentFeesPaid |
Table |
False |
||
CurriculumSK |
FactStudentGrades |
Table |
False |
||
CurriculumSK |
FactEnrollmentActivity |
Table |
False |
||
CurriculumSK |
FactEnrollmentSnapshot |
Table |
False |
||
CurriculumSK |
FactPriorEnrollmentSnapshot |
Table |
False |
||
CurriculumSK |
FactEOTEnrollmentSnapshot |
Table |
False |
||
CurriculumSK |
FactActiveEnrollmentSnapshot |
Table |
False |
| Powered by BI Documenter |
