DWOperations
 dbo.Verify_dbo_DimCurriculum (Table)
Home  Diagrams  Documents  Images  DWOperations  Storage  Users  Roles  Schemas  Tables  Views  Indexes  Triggers  Stored Procedures  Functions  Data Types  XML Schemas  Rules  Defaults  Fulltext Catalogs  Synonyms  Keys  Partitions  Assemblies 
Current Path:  DWOperations   Tables   dbo.Verify_dbo_DimCurriculum
  Properties
Property Value
Name Verify_dbo_DimCurriculum
Schema dbo
Row Count 225813
Data Size 118680 KB
Index Size 456 KB
Create Date 8/28/2013 9:56 AM
Description
  Columns
 
 
Column Name
Data Type
Allow Nulls
Row Guid
Fulltext Indexed
Identity
Default
Description / Computed Formula
Apprenticeship
varchar(3)
False
False
False
 
Campus
varchar(50)
False
False
False
 
CampusCode
varchar(3)
False
False
False
 
Center
varchar(50)
False
False
False
 
CenterCode
varchar(4)
False
False
False
 
ClassStatus
varchar(30)
False
False
False
 
ClassStatusCode
varchar(3)
False
False
False
 
ClassTitle
varchar(25)
False
False
False
 
CourseId
varchar(10)
False
False
False
 
CourseIdPrefix
varchar(3)
False
False
False
 
CourseLevel
varchar(10)
False
False
False
 
CourseNumberTimesForCredit
smallint(5, 0)
False
False
False
 
CourseType
varchar(30)
False
False
False
 
CourseTypeCode
varchar(3)
False
False
False
 
CreditNonCredit
varchar(15)
False
False
False
 
CreditNonCreditVocational
varchar(15)
False
False
False
 
CreditNonCreditVocationalTest
varchar(15)
False
False
False
 
CreditType
varchar(30)
False
False
False
 
CreditTypeCode
varchar(3)
False
False
False
 
CurrentCourseId
varchar(10)
False
False
False
 
CurrentTerm
varchar(6)
False
False
False
 
DeliveryMethod
varchar(30)
False
False
False
 
Department
varchar(60)
False
False
False
 
DepartmentCode
varchar(4)
False
False
False
 
DepartmentDescription
varchar(50)
False
False
False
 
Division
varchar(60)
False
False
False
 
DivisionCode
varchar(4)
False
False
False
 
DivisionDescription
varchar(50)
False
False
False
 
DualEnrollment
varchar(3)
False
False
False
 
Honors
varchar(3)
False
False
False
 
ICSCategoryCode
varchar(3)
False
False
False
 
ICSCode
varchar(5)
False
False
False
 
IndependentStudy
varchar(3)
False
False
False
 
InstructionalClassification
varchar(30)
False
False
False
 
InstructionalClassificationCategory
varchar(30)
False
False
False
 
IsCourseRepeatable
varchar(3)
False
False
False
 
IsTermCourseIdCountGE10
varchar(3)
False
False
False
 
MaximumClassSize
smallint(5, 0)
False
False
False
 
MinimumClassSize
smallint(5, 0)
False
False
False
 
Online100Percent
varchar(3)
False
False
False
 
PrimaryInstructorFirstName
varchar(30)
False
False
False
 
PrimaryInstructorFullName
varchar(50)
False
False
False
 
PrimaryInstructorId
numeric(9, 0)
False
False
False
 
PrimaryInstructorLastName
varchar(50)
False
False
False
 
PrimaryInstructorMiddleInitial
varchar(20)
False
False
False
 
PrimaryInstructorType
varchar(10)
False
False
False
 
ReferenceNumber
int(10, 0)
False
False
False
 
ReferenceNumberAK
int(10, 0)
False
False
False
 
RowIsDuplicate
char(1)
False
False
False
 
RowIsSelected
char(1)
False
False
False
 
ScheduleInformation
varchar(250)
False
False
False
 
Session
varchar(30)
False
False
False
 
SessionCode
varchar(4)
False
False
False
 
Term
varchar(6)
False
False
False
 
TermCourseIdCount
smallint(5, 0)
False
False
False
 
TermTitle
varchar(30)
False
False
False
 
TimeBlock
varchar(30)
False
False
False
 
TimeBlockCode
varchar(3)
False
False
False
 
In Primary Key
VerifyCurriculumSK
int(10, 0)
False
False
False
(1 / 1)
VirtualCollege
varchar(3)
False
False
False
 
WebBlended
varchar(3)
False
False
False
 
WebEnabled
varchar(3)
False
False
False
 
WeekendCollege
varchar(3)
False
False
False
 
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
True
VerifyCurriculumSK
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.Verify_dbo_DimCurriculum depends on)
Name Type
StoredProcedure
  Child Dependencies (objects that depend on dbo.Verify_dbo_DimCurriculum)
Name Type
STOREDPROCEDURE
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[Verify_dbo_DimCurriculum] Script Date: 03/09/2017 17:21:46 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[Verify_dbo_DimCurriculum](
    [VerifyCurriculumSK] [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,
    [RowIsDuplicate] [char](1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [RowIsSelected] [char](1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT 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 
(
    [VerifyCurriculumSK] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
  Sample Data
Apprenticeship Campus CampusCode Center CenterCode ClassStatus ClassStatusCode ClassTitle CourseId CourseIdPrefix CourseLevel CourseNumberTimesForCredit CourseType CourseTypeCode CreditNonCredit CreditNonCreditVocational CreditNonCreditVocationalTest CreditType CreditTypeCode CurrentCourseId CurrentTerm 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 RowIsDuplicate RowIsSelected ScheduleInformation Session SessionCode Term TermCourseIdCount TermTitle TimeBlock TimeBlockCode VerifyCurriculumSK VirtualCollege WebBlended WebEnabled WeekendCollege
No LAKE WORTH CAMPUS 1 LAKE WORTH UNAVAILABLE U COLLEGE ALGEBRA MAC1105 MAC Lower 1 LECTURE 01 Credit Credit Credit A & P 01 MAC1105 20092 Conventional MATH - MATHEMATICS MATH MATHEMATICS DEG - DEGREE DEG DEGREE No No 116 11617 No MATHEMATICS MATHEMATICS AND COMPUTER SC No Yes 35 1 No SUSAN SCOTT,SUSAN,K 1625 SCOTT K Faculty 42969 42969 Y Y TBA MAIN SESSION 1 20031 63 FALL TERM 2002 Day Time D 36128 No No No No
No LAKE WORTH CAMPUS 1 LAKE WORTH UNAVAILABLE U DEVELOPMENTAL MATH 2 MAT0028 MAT Lower 1 LECTURE 01 Credit Credit Credit DEV ED 03 MAT0028 20122 Conventional CPI - CPI CPI CPI DEG - DEGREE DEG DEGREE No No 131 13101 No COLLEGE PREP PREPARATORY INSTRUCTION No Yes 26 1 No YOSHUA CERVANTES,YOSHUA,I 25751 CERVANTES I Adjunct 164212 164212 N Y TBA FALL 12 WEEKS 3 20131 119 FALL TERM 2012 Day Time D 153182 No No No No
No BOCA RATON CAMPUS 5 BOCA RATON UNAVAILABLE U ART APPRECIATION ARH1000 ARH Lower 1 LECTURE 01 Credit Credit Credit A & P 01 ARH1000 20143 Conventional ART - ART ART ART DEG - DEGREE DEG DEGREE No No 112 11210 No FINE AND APPLIED ARTS FINE AND APPLIED ARTS No Yes 36 1 No CHARLOTTE JOHNSON,CHARLOTTE,J 6409 JOHNSON J Adjunct 113442 113442 N Y TBA SPRING 12 WEEKS 3 20092 40 SPRING TERM 2009 Day Time D 103675 No No No No
No LAKE WORTH CAMPUS 1 LAKE WORTH CANCELLED C CLASS INST GUITAR 2 MVS1116 B MVS Lower 2 LECTURE 01 Credit Credit Credit A & P 01 MVS1117 20111 Conventional MUS - MUSIC MUS MUSIC DEG - DEGREE DEG DEGREE No No 112 11210 No FINE AND APPLIED ARTS FINE AND APPLIED ARTS Yes No 1 1 No N/A TBA 999999999 N/A N/A Adjunct 91450 91450 N Y TBA MAIN SESSION 1 20072 2 SPRING TERM 2007 Other O 82246 No No No No
No LAKE WORTH CAMPUS 1 LAKE WORTH OPEN O INTER FLIGHT SMULATR ATF2605 ATF Lower 1 LAB 02 Credit Credit Credit OCCUP/POSTSECONDARY VOCATIONAL 02 ATF2605 20091 Conventional PP - PROFESSIONAL PILOT PP PROFESSIONAL PILOT DEG - DEGREE DEG DEGREE No No 126 12601 No INDUSTRIAL INDUSTRIAL No No 6 1 No MARGARET MOYES,MARGARET,W 1276 MOYES W Adjunct 4033 4033 N Y TBA SUMMER A (1ST 6 WK TERM) 2 19993 3 SUMMER TERM 1999 Other O 2633 No No No No
No PALM BEACH GARDENS CAMPUS 2 PB GARDENS UNAVAILABLE U AMER LIT TO 1865 AML2010 AML Lower 1 LECTURE 01 Credit Credit Credit A & P 01 AML2010 20001 Conventional LIT - LITERATURE LIT LITERATURE DEG - DEGREE DEG DEGREE No No 113 11315 No LETTERS LETTERS AND FOREIGN LANGUAGES No No 36 1 No KELLY PSC-KARBAL,KELLY 89795 PSC-KARBAL N/A Faculty 200224 200224 N Y TBA SUMMER B (2nd 6 Weeks) 3 20153 5 SUMMER TERM 2015 Day Time D 187642 No No No No
No LAKE WORTH CAMPUS 1 LAKE WORTH OPEN O GENERAL CHEMISTRY I CHM1040 CHM Lower 1 LECTURE 01 Credit Credit Credit A & P 01 CHM1025 20051 Conventional CHEM - CHEMISTRY CHEM CHEMISTRY DEG - DEGREE DEG DEGREE No No 111 11119 No PHYSICAL SCIENCES NATURAL AND PHYSICAL SCIENCE No Yes 40 1 No PETER STEELE,PETER,J 1345 STEELE J Faculty 2270 2270 N Y TBA MAIN SESSION 1 19991 13 FALL TERM 1998 Day Time D 949 No No No No
No LAKE WORTH CAMPUS 1 LAKE WORTH UNAVAILABLE U FTCE MATH GKT PREP EDO0058 EDO Lower 0 LECTURE 01 NonCredit NonCredit NonCredit SUPPLEMENTAL VOCATIONAL 06 EDO0058 20161 Conventional EDU - EDUCATION CE EDU EDUCATION CE CTE - CAREER & TECHNICAL EDUCATION CTE CAREER & TECHNICAL EDUCATION No No 127 12703 No PUBLIC SERVICE PUBLIC SERVICE Yes No 28 1 No YUKI HORLICK,YUKI 27155 HORLICK N/A Adjunct 185065 185065 N Y TBA 1 OR 2 DAYS NC1 20141 2 FALL TERM 2013 Weekend W 173118 No No No No
No LAKE WORTH CAMPUS 1 LAKE WORTH UNAVAILABLE U BASIC ALGEBRA 1 MAT0012 MAT Lower 1 LECTURE 01 Credit Credit Credit DEV ED 03 MAT0018 20122 Conventional CPI - CPI CPI CPI DEG - DEGREE DEG DEGREE No No 131 13101 No COLLEGE PREP PREPARATORY INSTRUCTION No Yes 27 1 No LEE VALMOND,LEE,K 42679 VALMOND K Adjunct 139039 139039 N Y TBA MAIN SESSION 1 20112 71 SPRING TERM 2011 Day Time D 128632 No No No No
No PALM BEACH GARDENS CAMPUS 2 PB GARDENS UNAVAILABLE U PARALEGAL OFFICE SYS PLA2762 PLA Lower 1 LECTURE 01 Credit Credit Credit OCCUP/POSTSECONDARY VOCATIONAL 02 PLA2762 20161 Conventional PARA - PARALEGAL PARA PARALEGAL DEG - DEGREE DEG DEGREE No No 127 12701 No PUBLIC SERVICE PUBLIC SERVICE No No 20 1 No BETTEE YON,BETTEE,M 24206 YON M Adjunct 155686 155686 N Y TBA SUMMER A (1st 6 Weeks) 2 20123 1 SUMMER TERM 2012 Evening E 144863 No No No No
Powered by BI Documenter