Table - dbo.DimCurriculum

Column Name	Data Type	Allow Nulls	Row Guid	Fulltext Indexed	Identity	Default	Description / Computed Formula
Apprenticeship	varchar(3)	False	False	False			Indication the class is participating in an apprenticeship programs. Values are Yes, No and N/A.
Campus	varchar(50)	False	False	False			Descriptive name for the campus where the class is held.
CampusCode	varchar(3)	False	False	False			Code which indicates the campus of the class.
Center	varchar(50)	False	False	False			Descriptive name for the center, where the class is held.
CenterCode	varchar(4)	False	False	False			Code which indicates the center of the class, where being held.
ClassStatus	varchar(30)	False	False	False			Descriptive name for the current class status.
ClassStatusCode	varchar(3)	False	False	False			Code which indicates the current status of the class.
ClassTitle	varchar(25)	False	False	False			The descriptive title for the class.
CourseId	varchar(10)	False	False	False			Code identifier for the Course, for the class.
CourseIdPrefix	varchar(3)	False	False	False			First three characters of the Course ID.
CourseLevel	varchar(10)	False	False	False			Value will be determined based on the Credit Type and the table setting in 'SITE-PARAM' generic table the 'DA-UPPL' entry. If the Credit Type of the Class is greater than 3 and less than 14, then the Course Level will be Lower. If the Class Type is N or T, the Course Level will be Lower. If the 4th character in the COURSE_ID is equal to one of the indicated values on the parameter, then the CourseLevel should be set to 'Upper'. All other courses will be set to 'Lower'.
CourseNumberTimesForCredit	smallint(5, 0)	False	False	False			Number of times a course can be repeated for credit.
CourseType	varchar(30)	False	False	False			Descriptive name of the Type of Course.
CourseTypeCode	varchar(3)	False	False	False			Code which identifies the Type of Course.
CreditNonCredit	varchar(15)	False	False	False			Indicates if the class is credit or non credit The valid values are 'Credit' and 'NonCredit'.
CreditNonCreditVocational	varchar(15)	False	False	False			Indicates the credit category for the class. The valid values are 'Credit', 'NonCredit' and 'Vocational'.
CreditNonCreditVocationalTest	varchar(15)	False	False	False			A descriptive value indicating of whether the class is a Test, Vocational, Credit or Non-Credit class.
CreditType	varchar(30)	False	False	False			Descriptive name of the Credit Type of the class.
CreditTypeCode	varchar(3)	False	False	False			Code which indicates the Credit Type of the class.
CurrentCourseId	varchar(10)	False	False	False			The current Course ID for the course for the class.
CurrentTerm	varchar(6)	False	False	False			Current Term for the Current course for the class.
CurriculumSK	int(10, 0)	False	False	False	(1 / 1)		Unique identifier for the class in the data warehouse, in numeric format.
DeliveryMethod	varchar(30)	False	False	False			Indication as to the Delivery Method aspect of the class. The valid values are 'Conventional' and 'Distance Learning'.
Department	varchar(60)	False	False	False			Descriptive name of the Department.
DepartmentCode	varchar(4)	False	False	False			Code which indicates the Department that is administratively responsible for the class.
DepartmentDescription	varchar(50)	False	False	False			A descriptive value of the Department associated with the Class
Division	varchar(60)	False	False	False			Descriptive name of the Division.
DivisionCode	varchar(4)	False	False	False			Code which indicates the Division that is administratively responsible for the class.
DivisionDescription	varchar(50)	False	False	False			A descriptive value of the Division associated with the Class
DualEnrollment	varchar(3)	False	False	False			Indication the class has a Dual Enrollment component. Values are Yes, No and N/A.
Honors	varchar(3)	False	False	False			Indication that the class has an Honors component. Values are Yes, No and N/A.
ICSCategoryCode	varchar(3)	False	False	False			Code for the ICS Category, which is the first three digits of the ICS Code.
ICSCode	varchar(5)	False	False	False			Code which indicates the type of Instructional Classification of the class.
IndependentStudy	varchar(3)	False	False	False			Indication the class is for independent and directed study. Values are Yes, No and N/A.
InstructionalClassification	varchar(30)	False	False	False			Descriptive name of the Instructional Classification.
InstructionalClassificationCategory	varchar(30)	False	False	False			Descriptive name of the ICSCategoryCode.
IsCourseRepeatable	varchar(3)	False	False	False			Indicator for courses which are repeatable for credit. All non-credit and test classes are repeatable.
IsTermCourseIdCountGE10	varchar(3)	False	False	False			Indicator for courses which have 10 or more classes in the term.
MaximumClassSize	smallint(5, 0)	False	False	False			Maximum number of students who are permitted to enroll in the class.
MinimumClassSize	smallint(5, 0)	False	False	False			Minimum number of students who need to be enrolled in a class in order to continue with the class.
Online100Percent	varchar(3)	False	False	False			Indication that the class room experience is completely an on-line interaction, there is no class room component. Values are Yes, No and N/A.
PrimaryInstructorFirstName	varchar(30)	False	False	False			First name of the class primary instructor.
PrimaryInstructorFullName	varchar(50)	False	False	False			Full Name for the primary class instructor: last name, first name followed by the middle initial.
PrimaryInstructorId	numeric(9, 0)	False	False	False			Code which identifies an employee, the person ID, as assigned in the source system, for the primary instructor of the class.
PrimaryInstructorLastName	varchar(50)	False	False	False			Last name of the class primary instructor.
PrimaryInstructorMiddleInitial	varchar(20)	False	False	False			Middle initial of the primary class instructor.
PrimaryInstructorType	varchar(10)	False	False	False			The type of the Primary Instructor for the class, indicates if the primary instructor is Faculty or Adjunct.
ReferenceNumber	int(10, 0)	False	False	False			Class reference number, assigned by the source application.
ReferenceNumberAK	int(10, 0)	False	False	False			Class identifier assigned by the source application and used by the Data Warehouse as the Business Key. The class reference number.
RowEndDate	datetime(23, 3)	True	False	False			The effective end date-time for the current Curriculum row.
RowIsCurrent	char(1)	False	False	False			Indicator if the row is the most current representation of the curriculum. The valid values are 'N' or 'Y'.
RowStartDate	datetime(23, 3)	False	False	False			The effective start date-time for the current Curriculum row.
ScheduleInformation	varchar(250)	False	False	False			Future.
Session	varchar(30)	False	False	False			Descriptive name for the session.
SessionCode	varchar(4)	False	False	False			Code which identifies the session to which the class is attached and held.
Term	varchar(6)	False	False	False			The term when the class starts, used as the administrative term for the class. The format is YYYYTT and sample values are 20111, 20113 and 20122.
TermCourseIdCount	smallint(5, 0)	False	False	False			The number of classes for a course in a term.
TermTitle	varchar(30)	False	False	False			The title of the term. The title consists of a literal description of the term, followed by the word 'Term' and then the academic year in the format of YYYY (Fall Term 2012).
TimeBlock	varchar(30)	False	False	False			Descriptive name for the time block of the class.
TimeBlockCode	varchar(3)	False	False	False			Code which indicates the Time Block of the class, as a broad characterization of when the class meets.
VirtualCollege	varchar(3)	False	False	False			Indication that the class is participating in the Virtual College. Values are Yes, No and N/A.
WebBlended	varchar(3)	False	False	False			Indication that the class room experience has both class room and online components. Values are Yes, No and N/A.
WebEnabled	varchar(3)	False	False	False			Indication that the class room experience is enhanced or supplemented with web based material. Values are Yes, No and N/A.
WeekendCollege	varchar(3)	False	False	False			Indication that the class is categorized as participating in the Weekend College program. Values are Yes, No and N/A.

Name

Insert

Update

Delete

Instead

Name	Clustered	Columns
IDX_ReferenceNumberAK	False	ReferenceNumberAK
PK_DimCurriculum	True	CurriculumSK

Name

Columns

Referenced Table

Referenced Columns

Checked

Name	Type
dbo.FactActiveEnrollmentSnapshot	Table
dbo.FactEnrollmentActivity	Table
dbo.FactEnrollmentSnapshot	Table
dbo.FactEOTEnrollmentSnapshot	Table
dbo.FactPriorEnrollmentSnapshot	Table
dbo.FactStudentFeesPaid	Table
dbo.FactStudentGrades	Table
dbo.FactStudentTotalFeesForClass	Table

Name	Type
dbo.FactActiveEnrollmentSnapshot	TABLE
dbo.FactEnrollmentActivity	TABLE
dbo.FactEnrollmentSnapshot	TABLE
dbo.FactEOTEnrollmentSnapshot	TABLE
dbo.FactPriorEnrollmentSnapshot	TABLE
dbo.FactStudentFeesPaid	TABLE
dbo.FactStudentGrades	TABLE
dbo.FactStudentTotalFeesForClass	TABLE

Object	Property	Value
DimCurriculum	MS_Description	The Curriculum Dimension contains one row per 'class' held or administered by the institution, it is an occurance or instance of a Course.
Apprenticeship	MS_Description	Indication the class is participating in an apprenticeship programs. Values are Yes, No and N/A.
Campus	MS_Description	Descriptive name for the campus where the class is held.
CampusCode	MS_Description	Code which indicates the campus of the class.
Center	MS_Description	Descriptive name for the center, where the class is held.
CenterCode	MS_Description	Code which indicates the center of the class, where being held.
ClassStatus	MS_Description	Descriptive name for the current class status.
ClassStatusCode	MS_Description	Code which indicates the current status of the class.
ClassTitle	MS_Description	The descriptive title for the class.
CourseId	MS_Description	Code identifier for the Course, for the class.
CourseIdPrefix	MS_Description	First three characters of the Course ID.
CourseLevel	MS_Description	Value will be determined based on the Credit Type and the table setting in 'SITE-PARAM' generic table the 'DA-UPPL' entry. If the Credit Type of the Class is greater than 3 and less than 14, then the Course Level will be Lower. If the Class Type is N or T, the Course Level will be Lower. If the 4th character in the COURSE_ID is equal to one of the indicated values on the parameter, then the CourseLevel should be set to 'Upper'. All other courses will be set to 'Lower'.
CourseNumberTimesForCredit	MS_Description	Number of times a course can be repeated for credit.
CourseType	MS_Description	Descriptive name of the Type of Course.
CourseTypeCode	MS_Description	Code which identifies the Type of Course.
CreditNonCredit	MS_Description	Indicates if the class is credit or non credit The valid values are 'Credit' and 'NonCredit'.
CreditNonCreditVocational	MS_Description	Indicates the credit category for the class. The valid values are 'Credit', 'NonCredit' and 'Vocational'.
CreditNonCreditVocationalTest	MS_Description	A descriptive value indicating of whether the class is a Test, Vocational, Credit or Non-Credit class.
CreditType	MS_Description	Descriptive name of the Credit Type of the class.
CreditTypeCode	MS_Description	Code which indicates the Credit Type of the class.
CurrentCourseId	MS_Description	The current Course ID for the course for the class.
CurrentTerm	MS_Description	Current Term for the Current course for the class.
CurriculumSK	MS_Description	Unique identifier for the class in the data warehouse, in numeric format.
DeliveryMethod	MS_Description	Indication as to the Delivery Method aspect of the class. The valid values are 'Conventional' and 'Distance Learning'.
Department	MS_Description	Descriptive name of the Department.
DepartmentCode	MS_Description	Code which indicates the Department that is administratively responsible for the class.
DepartmentDescription	MS_Description	A descriptive value of the Department associated with the Class
Division	MS_Description	Descriptive name of the Division.
DivisionCode	MS_Description	Code which indicates the Division that is administratively responsible for the class.
DivisionDescription	MS_Description	A descriptive value of the Division associated with the Class
DualEnrollment	MS_Description	Indication the class has a Dual Enrollment component. Values are Yes, No and N/A.
Honors	MS_Description	Indication that the class has an Honors component. Values are Yes, No and N/A.
ICSCategoryCode	MS_Description	Code for the ICS Category, which is the first three digits of the ICS Code.
ICSCode	MS_Description	Code which indicates the type of Instructional Classification of the class.
IndependentStudy	MS_Description	Indication the class is for independent and directed study. Values are Yes, No and N/A.
InstructionalClassification	MS_Description	Descriptive name of the Instructional Classification.
InstructionalClassificationCategory	MS_Description	Descriptive name of the ICSCategoryCode.
IsCourseRepeatable	MS_Description	Indicator for courses which are repeatable for credit. All non-credit and test classes are repeatable.
IsTermCourseIdCountGE10	MS_Description	Indicator for courses which have 10 or more classes in the term.
MaximumClassSize	MS_Description	Maximum number of students who are permitted to enroll in the class.
MinimumClassSize	MS_Description	Minimum number of students who need to be enrolled in a class in order to continue with the class.
Online100Percent	MS_Description	Indication that the class room experience is completely an on-line interaction, there is no class room component. Values are Yes, No and N/A.
PrimaryInstructorFirstName	MS_Description	First name of the class primary instructor.
PrimaryInstructorFullName	MS_Description	Full Name for the primary class instructor: last name, first name followed by the middle initial.
PrimaryInstructorId	MS_Description	Code which identifies an employee, the person ID, as assigned in the source system, for the primary instructor of the class.
PrimaryInstructorLastName	MS_Description	Last name of the class primary instructor.
PrimaryInstructorMiddleInitial	MS_Description	Middle initial of the primary class instructor.
PrimaryInstructorType	MS_Description	The type of the Primary Instructor for the class, indicates if the primary instructor is Faculty or Adjunct.
ReferenceNumber	MS_Description	Class reference number, assigned by the source application.
ReferenceNumberAK	MS_Description	Class identifier assigned by the source application and used by the Data Warehouse as the Business Key. The class reference number.
RowEndDate	MS_Description	The effective end date-time for the current Curriculum row.
RowIsCurrent	MS_Description	Indicator if the row is the most current representation of the curriculum. The valid values are 'N' or 'Y'.
RowStartDate	MS_Description	The effective start date-time for the current Curriculum row.
ScheduleInformation	MS_Description	Future.
Session	MS_Description	Descriptive name for the session.
SessionCode	MS_Description	Code which identifies the session to which the class is attached and held.
Term	MS_Description	The term when the class starts, used as the administrative term for the class. The format is YYYYTT and sample values are 20111, 20113 and 20122.
TermCourseIdCount	MS_Description	The number of classes for a course in a term.
TermTitle	MS_Description	The title of the term. The title consists of a literal description of the term, followed by the word 'Term' and then the academic year in the format of YYYY (Fall Term 2012).
TimeBlock	MS_Description	Descriptive name for the time block of the class.
TimeBlockCode	MS_Description	Code which indicates the Time Block of the class, as a broad characterization of when the class meets.
VirtualCollege	MS_Description	Indication that the class is participating in the Virtual College. Values are Yes, No and N/A.
WebBlended	MS_Description	Indication that the class room experience has both class room and online components. Values are Yes, No and N/A.
WebEnabled	MS_Description	Indication that the class room experience is enhanced or supplemented with web based material. Values are Yes, No and N/A.
WeekendCollege	MS_Description	Indication that the class is categorized as participating in the Weekend College program. Values are Yes, No and N/A.

Object

Property

Value

/****** Object: Table [dbo].[DimCurriculum] Script Date: 03/09/2017 17:14:54 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[DimCurriculum](
    [CurriculumSK] [int] IDENTITY(1,1) NOT NULL,
    [ReferenceNumberAK] [int] NOT NULL,
    [ReferenceNumber] [int] NOT NULL,
    [Term] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [TermTitle] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [CourseId] [varchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [CurrentTerm] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [CurrentCourseId] [varchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [CourseIdPrefix] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [ClassTitle] [varchar](25) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [CourseTypeCode] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [CourseType] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [CreditNonCreditVocational] [varchar](15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [CreditTypeCode] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [CreditType] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [CreditNonCredit] [varchar](15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [ICSCode] [varchar](5) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [InstructionalClassification] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [DivisionCode] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [Division] [varchar](60) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [DepartmentCode] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [Department] [varchar](60) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [CampusCode] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [Campus] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [CenterCode] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [Center] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [MinimumClassSize] [smallint] NOT NULL,
    [MaximumClassSize] [smallint] NOT NULL,
    [ClassStatusCode] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [ClassStatus] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [TimeBlockCode] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [TimeBlock] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [DeliveryMethod] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [PrimaryInstructorId] [numeric](9, 0) NOT NULL,
    [PrimaryInstructorFullName] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [PrimaryInstructorLastName] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [PrimaryInstructorFirstName] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [PrimaryInstructorMiddleInitial] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [SessionCode] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [Session] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [Honors] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [WeekendCollege] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [DualEnrollment] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [IndependentStudy] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [Apprenticeship] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [VirtualCollege] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [Online100Percent] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [WebEnabled] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [WebBlended] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [ScheduleInformation] [varchar](250) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [PrimaryInstructorType] [varchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [ICSCategoryCode] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [InstructionalClassificationCategory] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [TermCourseIdCount] [smallint] NOT NULL,
    [IsTermCourseIdCountGE10] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [IsCourseRepeatable] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [CourseNumberTimesForCredit] [smallint] NOT NULL,
    [RowIsCurrent] [char](1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [RowStartDate] [datetime] NOT NULL,
    [RowEndDate] [datetime] NULL,
    [CourseLevel] [varchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [CreditNonCreditVocationalTest] [varchar](15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [DivisionDescription] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [DepartmentDescription] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
CONSTRAINT [PK_DimCurriculum] PRIMARY KEY CLUSTERED
(
    [CurriculumSK] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The Curriculum Dimension contains one row per ''class'' held or administered by the institution, it is an occurance or instance of a Course.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimCurriculum'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Indication the class is participating in an apprenticeship programs. Values are Yes, No and N/A.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimCurriculum', @level2type=N'COLUMN',@level2name=N'Apprenticeship'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Descriptive name for the campus where the class is held.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimCurriculum', @level2type=N'COLUMN',@level2name=N'Campus'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Code which indicates the campus of the class. ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimCurriculum', @level2type=N'COLUMN',@level2name=N'CampusCode'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Descriptive name for the center, where the class is held.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimCurriculum', @level2type=N'COLUMN',@level2name=N'Center'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Code which indicates the center of the class, where being held.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimCurriculum', @level2type=N'COLUMN',@level2name=N'CenterCode'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Descriptive name for the current class status.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimCurriculum', @level2type=N'COLUMN',@level2name=N'ClassStatus'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Code which indicates the current status of the class.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimCurriculum', @level2type=N'COLUMN',@level2name=N'ClassStatusCode'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The descriptive title for the class.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimCurriculum', @level2type=N'COLUMN',@level2name=N'ClassTitle'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Code identifier for the Course, for the class.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimCurriculum', @level2type=N'COLUMN',@level2name=N'CourseId'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'First three characters of the Course ID.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimCurriculum', @level2type=N'COLUMN',@level2name=N'CourseIdPrefix'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Value will be determined based on the Credit Type and the table setting in ''SITE-PARAM'' generic table the ''DA-UPPL'' entry. If the Credit Type of the Class is greater than 3 and less than 14, then the Course Level will be Lower. If the Class Type is N or T, the Course Level will be Lower. If the 4th character in the COURSE_ID is equal to one of the indicated values on the parameter, then the CourseLevel should be set to ''Upper''. All other courses will be set to ''Lower''. ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimCurriculum', @level2type=N'COLUMN',@level2name=N'CourseLevel'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Number of times a course can be repeated for credit.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimCurriculum', @level2type=N'COLUMN',@level2name=N'CourseNumberTimesForCredit'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Descriptive name of the Type of Course.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimCurriculum', @level2type=N'COLUMN',@level2name=N'CourseType'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Code which identifies the Type of Course.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimCurriculum', @level2type=N'COLUMN',@level2name=N'CourseTypeCode'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Indicates if the class is credit or non credit The valid values are ''Credit'' and ''NonCredit''.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimCurriculum', @level2type=N'COLUMN',@level2name=N'CreditNonCredit'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Indicates the credit category for the class. The valid values are ''Credit'', ''NonCredit'' and ''Vocational''.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimCurriculum', @level2type=N'COLUMN',@level2name=N'CreditNonCreditVocational'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'A descriptive value indicating of whether the class is a Test, Vocational, Credit or Non-Credit class.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimCurriculum', @level2type=N'COLUMN',@level2name=N'CreditNonCreditVocationalTest'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Descriptive name of the Credit Type of the class.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimCurriculum', @level2type=N'COLUMN',@level2name=N'CreditType'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Code which indicates the Credit Type of the class.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimCurriculum', @level2type=N'COLUMN',@level2name=N'CreditTypeCode'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The current Course ID for the course for the class.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimCurriculum', @level2type=N'COLUMN',@level2name=N'CurrentCourseId'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Current Term for the Current course for the class.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimCurriculum', @level2type=N'COLUMN',@level2name=N'CurrentTerm'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Unique identifier for the class in the data warehouse, in numeric format.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimCurriculum', @level2type=N'COLUMN',@level2name=N'CurriculumSK'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Indication as to the Delivery Method aspect of the class. The valid values are ''Conventional'' and ''Distance Learning''.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimCurriculum', @level2type=N'COLUMN',@level2name=N'DeliveryMethod'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Descriptive name of the Department.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimCurriculum', @level2type=N'COLUMN',@level2name=N'Department'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Code which indicates the Department that is administratively responsible for the class.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimCurriculum', @level2type=N'COLUMN',@level2name=N'DepartmentCode'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'A descriptive value of the Department associated with the Class' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimCurriculum', @level2type=N'COLUMN',@level2name=N'DepartmentDescription'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Descriptive name of the Division.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimCurriculum', @level2type=N'COLUMN',@level2name=N'Division'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Code which indicates the Division that is administratively responsible for the class.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimCurriculum', @level2type=N'COLUMN',@level2name=N'DivisionCode'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'A descriptive value of the Division associated with the Class' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimCurriculum', @level2type=N'COLUMN',@level2name=N'DivisionDescription'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Indication the class has a Dual Enrollment component. Values are Yes, No and N/A.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimCurriculum', @level2type=N'COLUMN',@level2name=N'DualEnrollment'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Indication that the class has an Honors component. Values are Yes, No and N/A.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimCurriculum', @level2type=N'COLUMN',@level2name=N'Honors'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Code for the ICS Category, which is the first three digits of the ICS Code.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimCurriculum', @level2type=N'COLUMN',@level2name=N'ICSCategoryCode'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Code which indicates the type of Instructional Classification of the class.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimCurriculum', @level2type=N'COLUMN',@level2name=N'ICSCode'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Indication the class is for independent and directed study. Values are Yes, No and N/A.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimCurriculum', @level2type=N'COLUMN',@level2name=N'IndependentStudy'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Descriptive name of the Instructional Classification.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimCurriculum', @level2type=N'COLUMN',@level2name=N'InstructionalClassification'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Descriptive name of the ICSCategoryCode.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimCurriculum', @level2type=N'COLUMN',@level2name=N'InstructionalClassificationCategory'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Indicator for courses which are repeatable for credit. All non-credit and test classes are repeatable.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimCurriculum', @level2type=N'COLUMN',@level2name=N'IsCourseRepeatable'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Indicator for courses which have 10 or more classes in the term.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimCurriculum', @level2type=N'COLUMN',@level2name=N'IsTermCourseIdCountGE10'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Maximum number of students who are permitted to enroll in the class.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimCurriculum', @level2type=N'COLUMN',@level2name=N'MaximumClassSize'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Minimum number of students who need to be enrolled in a class in order to continue with the class.
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimCurriculum', @level2type=N'COLUMN',@level2name=N'MinimumClassSize'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Indication that the class room experience is completely an on-line interaction, there is no class room component. Values are Yes, No and N/A.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimCurriculum', @level2type=N'COLUMN',@level2name=N'Online100Percent'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'First name of the class primary instructor.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimCurriculum', @level2type=N'COLUMN',@level2name=N'PrimaryInstructorFirstName'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Full Name for the primary class instructor: last name, first name followed by the middle initial.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimCurriculum', @level2type=N'COLUMN',@level2name=N'PrimaryInstructorFullName'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Code which identifies an employee, the person ID, as assigned in the source system, for the primary instructor of the class.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimCurriculum', @level2type=N'COLUMN',@level2name=N'PrimaryInstructorId'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Last name of the class primary instructor.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimCurriculum', @level2type=N'COLUMN',@level2name=N'PrimaryInstructorLastName'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Middle initial of the primary class instructor.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimCurriculum', @level2type=N'COLUMN',@level2name=N'PrimaryInstructorMiddleInitial'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The type of the Primary Instructor for the class, indicates if the primary instructor is Faculty or Adjunct.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimCurriculum', @level2type=N'COLUMN',@level2name=N'PrimaryInstructorType'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Class reference number, assigned by the source application.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimCurriculum', @level2type=N'COLUMN',@level2name=N'ReferenceNumber'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Class identifier assigned by the source application and used by the Data Warehouse as the Business Key. The class reference number.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimCurriculum', @level2type=N'COLUMN',@level2name=N'ReferenceNumberAK'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The effective end date-time for the current Curriculum row.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimCurriculum', @level2type=N'COLUMN',@level2name=N'RowEndDate'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Indicator if the row is the most current representation of the curriculum. The valid values are ''N'' or ''Y''.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimCurriculum', @level2type=N'COLUMN',@level2name=N'RowIsCurrent'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The effective start date-time for the current Curriculum row.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimCurriculum', @level2type=N'COLUMN',@level2name=N'RowStartDate'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Future.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimCurriculum', @level2type=N'COLUMN',@level2name=N'ScheduleInformation'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Descriptive name for the session.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimCurriculum', @level2type=N'COLUMN',@level2name=N'Session'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Code which identifies the session to which the class is attached and held.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimCurriculum', @level2type=N'COLUMN',@level2name=N'SessionCode'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The term when the class starts, used as the administrative term for the class. The format is YYYYTT and sample values are 20111, 20113 and 20122.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimCurriculum', @level2type=N'COLUMN',@level2name=N'Term'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The number of classes for a course in a term.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimCurriculum', @level2type=N'COLUMN',@level2name=N'TermCourseIdCount'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The title of the term. The title consists of a literal description of the term, followed by the word ''Term'' and then the academic year in the format of YYYY (Fall Term 2012).' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimCurriculum', @level2type=N'COLUMN',@level2name=N'TermTitle'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Descriptive name for the time block of the class.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimCurriculum', @level2type=N'COLUMN',@level2name=N'TimeBlock'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Code which indicates the Time Block of the class, as a broad characterization of when the class meets.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimCurriculum', @level2type=N'COLUMN',@level2name=N'TimeBlockCode'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Indication that the class is participating in the Virtual College. Values are Yes, No and N/A.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimCurriculum', @level2type=N'COLUMN',@level2name=N'VirtualCollege'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Indication that the class room experience has both class room and online components. Values are Yes, No and N/A.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimCurriculum', @level2type=N'COLUMN',@level2name=N'WebBlended'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Indication that the class room experience is enhanced or supplemented with web based material. Values are Yes, No and N/A.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimCurriculum', @level2type=N'COLUMN',@level2name=N'WebEnabled'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Indication that the class is categorized as participating in the Weekend College program. Values are Yes, No and N/A.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimCurriculum', @level2type=N'COLUMN',@level2name=N'WeekendCollege'

Apprenticeship

Campus

CampusCode

Center

CenterCode

ClassStatus

ClassStatusCode

ClassTitle

CourseId

CourseIdPrefix

CourseLevel

CourseNumberTimesForCredit

CourseType

CourseTypeCode

CreditNonCredit

CreditNonCreditVocational

CreditNonCreditVocationalTest

CreditType

CreditTypeCode

CurrentCourseId

CurrentTerm

CurriculumSK

DeliveryMethod

Department

DepartmentCode

DepartmentDescription

Division

DivisionCode

DivisionDescription

DualEnrollment

Honors

ICSCategoryCode

ICSCode

IndependentStudy

InstructionalClassification

InstructionalClassificationCategory

IsCourseRepeatable

IsTermCourseIdCountGE10

MaximumClassSize

MinimumClassSize

Online100Percent

PrimaryInstructorFirstName

PrimaryInstructorFullName

PrimaryInstructorId

PrimaryInstructorLastName

PrimaryInstructorMiddleInitial

PrimaryInstructorType

ReferenceNumber

ReferenceNumberAK

RowIsCurrent

RowStartDate

ScheduleInformation

Session

SessionCode

Term

TermCourseIdCount

TermTitle

TimeBlock

TimeBlockCode

VirtualCollege

WebBlended

WebEnabled

WeekendCollege

Lake Worth Campus

Lake Worth

Unavailable

Basic Algebra 2

MAT0020

MAT

Lower

Lecture

Credit

Dev Ed

MAT0028

20122

5453766

Conventional

Cpi - Cpi

CPI

Cpi

Deg - Degree

DEG

Degree

131

13101

College Prep

Preparatory Instruction

Yes

Kenny

Arango-Jaramillo,Kenny

20443

Arango-Jaramillo

N/A

Faculty

139057

2017-03-09T11:29:00-05:00

TBA

Main Session

20112

104

Spring Term 2011

Day Time

Boca Raton Campus

Boca Raton

Full

Statistics

STA2023

STA

Lower

Lecture

Credit

A & P

STA2023

20162

5532804

Conventional

Math - Mathematics

MATH

Mathematics

Deg - Degree

DEG

Degree

116

11617

Mathematics

Mathematics And Computer Sc

Yes

Patricia

Kimiagarov,Patricia,M

72800

Kimiagarov

Adjunct

224270

2017-03-09T11:29:00-05:00

TBA

Main Session

20172

Spring Term 2017

Day Time

Lake Worth Campus

Lake Worth

Unavailable

Am Lit After 1865

AML2020

AML

Lower

Lecture

Credit

A & P

AML2020

20001

5412575

Conventional

Lit - Literature

LIT

Literature

Deg - Degree

DEG

Degree

113

11315

Letters

Letters And Foreign Languages

Yes

Steven

Broschard,Steven

656

Broschard

N/A

Faculty

98305

2017-03-09T11:29:00-05:00

TBA

Main Session

20081

Fall Term 2007

Day Time

Lake Worth Campus

Lake Worth

Open

Microbiology

MCB2010

MCB

Lower

Lecture

Credit

A & P

MCB2010

20141

5526092

Distance Learning

Bio - Biology

BIO

Biology

Deg - Degree

DEG

Degree

111

11104

Biological Science

Natural And Physical Science

Yes

Lee

Beyer,Lee,Z

1845

Beyer

Faculty

218560

2017-03-09T11:29:00-05:00

TBA

Fall 12 Weeks

20171

Fall Term 2016

Virtual

Lake Worth Campus

Lake Worth

Cancelled

Drawing 1

ART1300C

ART

Lower

Lecture/Lab Combination

Credit

A & P

ART1300C

20123

5445492

Conventional

Art - Art

ART

Art

Deg - Degree

DEG

Degree

112

11210

Fine And Applied Arts

Yes

N/A

Tba

999999999

N/A

Adjunct

131742

2017-03-09T11:29:00-05:00

TBA

Main Session

20101

Fall Term 2009

Other

Belle Glade Campus

Belle Glade

Unavailable

Coll Prep English 1

ENC0001

ENC

Lower

Lecture

Credit

Dev Ed

ENC0015

20122

5414403

Conventional

Cpi - Cpi

CPI

Cpi

Deg - Degree

DEG

Degree

131

13101

College Prep

Preparatory Instruction

Yes

Nicholas

Maxwell,Nicholas,T

32390

Maxwell

Faculty

102181

2017-03-09T11:29:00-05:00

TBA

Main Session

20082

Spring Term 2008

Evening

Lake Worth Campus

Lake Worth

Cancelled

Intro To Portuguese

BEO0283

BEO

Lower

Lecture

NonCredit

Supplemental Vocational

LGO0107

20122

5447116

Conventional

Bi - Business & Industry

Business & Industry

Cte - Career & Technical Education

CTE

Career & Technical Education

127

12703

Public Service

Yes

N/A

Tba

999999999

N/A

Adjunct

132410

2017-03-09T11:29:00-05:00

TBA

6-11 Weeks

NC11

20102

Spring Term 2010

Weekend

Belle Glade Campus

Belle Glade

Cancelled

Colleg Composition 1

ENC1101

ENC

Lower

Lecture

Credit

A & P

ENC1101

20161

5446622

Conventional

Comp - Composition

COMP

Composition

Deg - Degree

DEG

Degree

113

11315

Letters

Letters And Foreign Languages

Yes

N/A

Tba

999999999

N/A

Adjunct

132900

2017-03-09T11:29:00-05:00

TBA

Express A (1St 8 Weeks)

20101

146

Fall Term 2009

Day Time

Palm Beach Gardens Campus

Pb Gardens

Unavailable

Intermed Algebra Lab

MAT1033L

MAT

Lower

Lab

Credit

A & P

MAT1033L

20143

5507376

Distance Learning

Math - Mathematics

MATH

Mathematics

Deg - Degree

DEG

Degree

116

11617

Mathematics

Mathematics And Computer Sc

Yes

Christine

Friedman,Christine,W

272

Friedman

Faculty

194912

2017-03-09T11:29:00-05:00

TBA

Main Session

20152

105

Spring Term 2015

Day Time

Yes

Lake Worth Campus

Lake Worth

Cancelled

Commun With Hisp Pt

NUR2070

NUR

Lower

Lecture

Credit

Occup/Postsecondary Vocational

NUR2651

20051

5364354

Conventional

Nuc - Nursing Atc

NUC

Nursing Atc

Deg - Degree

DEG

Degree

123

12301

Health Occupations

N/A

Tba

999999999

N/A

Adjunct

45715

2017-03-09T11:29:00-05:00

TBA

Mini Session

11F

20031

Fall Term 2002

Day Time

Property	Value
Name	DimCurriculum
Schema	dbo
Row Count	223588
Data Size	125264 KB
Index Size	3320 KB
Create Date	8/28/2013 9:52 AM
Description	The Curriculum Dimension contains one row per 'class' held or administered by the institution, it is an occurance or instance of a Course.