DWOperations
 dbo.Staged_dbo_DimCurriculum__New (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.Staged_dbo_DimCurriculum__New
  Properties
Property Value
Name Staged_dbo_DimCurriculum__New
Schema dbo
Row Count 223587
Data Size 120104 KB
Index Size 8 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
 
RowEndDate
datetime(23, 3)
True
False
False
 
RowIsCurrent
char(1)
False
False
False
 
RowStartDate
datetime(23, 3)
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
 
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
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.Staged_dbo_DimCurriculum__New depends on)
Name Type
  Child Dependencies (objects that depend on dbo.Staged_dbo_DimCurriculum__New)
Name Type
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[Staged_dbo_DimCurriculum__New] Script Date: 03/09/2017 17:21:39 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[Staged_dbo_DimCurriculum__New](
    [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
) 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 RowIsCurrent RowStartDate ScheduleInformation Session SessionCode Term TermCourseIdCount TermTitle TimeBlock TimeBlockCode VirtualCollege WebBlended WebEnabled WeekendCollege
No Lake Worth Campus 1 Lake Worth Open O Health Concept/Strat HSC2100 HSC Lower 1 Lecture 01 Credit Credit Credit A & P 01 HSC2100 20152 Conventional Hlth - Health Education HLTH Health Education Deg - Degree DEG Degree No No 114 11408 No Education Education No Yes 45 1 No N/A Tba 999999999 N/A N/A Adjunct 2838 2838 Y 2017-03-09T11:29:00-05:00 TBA Main Session 1 19991 58 Fall Term 1998 Day Time D No No No No
No Lake Worth Campus 1 Lake Worth Unavailable U Scuba Diving PEN2136 PEN Lower 1 Lecture 01 Credit Credit Credit A & P 01 PEN2136 20001 Conventional Pe - Physical Education PE Physical Education Deg - Degree DEG Degree No No 114 11408 No Education Education No No 20 1 No James Abernathy,James, 13444 Abernathy Adjunct 31613 31613 Y 2017-03-09T11:29:00-05:00 TBA Main Session 1 20021 2 Fall Term 2001 Evening E No No No No
No Boca Raton Campus 5 Boca Raton Unavailable U Financial Accounting ACG2022 ACG Lower 1 Lecture 01 Credit Credit Credit A & P 01 ACG2022 20001 Distance Learning Acc - Accounting ACC Accounting Deg - Degree DEG Degree No No 115 11505 No Business & Management Business And Management No Yes 36 1 Yes Gracelyn Mcgann,Gracelyn,V 236 Mcgann V Faculty 196157 196157 Y 2017-03-09T11:29:00-05:00 TBA Spring 12 Weeks 3 20152 25 Spring Term 2015 Virtual V No No No No
No Lake Worth Campus 1 Lake Worth Unavailable U Art Hist: Ancnt/Ren ARH2050 ARH Lower 1 Lecture 01 Credit Credit Credit A & P 01 ARH2050 20143 Conventional Art - Art ART Art Deg - Degree DEG Degree No No 112 11210 No Fine And Applied Arts Fine And Applied Arts No No 35 1 No Terryl Patel,Terryl,B 89432 Patel B Adjunct 201607 201607 Y 2017-03-09T11:29:00-05:00 TBA Main Session 1 20161 9 Fall Term 2015 Day Time D No No No No
No Lake Worth Campus 1 Lake Worth Cancelled C Driver Op Refresher FFO0699 FFO Lower 0 Lecture 01 NonCredit NonCredit NonCredit Supplemental Vocational 06 FFO0699 20133 Conventional Fire - Fire FIRE Fire Cte - Career & Technical Education CTE Career & Technical Education No No 127 12703 No Public Service Public Service Yes No 12 8 No N/A Tba 999999999 N/A N/A Adjunct 214291 214291 Y 2017-03-09T11:29:00-05:00 TBA 1 Or 2 Days NC1 20163 1 Summer Term 2016 Day Time D No No No No
No Boca Raton Campus 5 Boca Raton Unavailable U Coll Composition 2 ENC1102 ENC Lower 1 Lecture 01 Credit Credit Credit A & P 01 ENC1102 20002 Conventional Comp - Composition COMP Composition Deg - Degree DEG Degree No No 113 11315 No Letters Letters And Foreign Languages No Yes 26 1 No Joseph Celestino,Joseph,A 29394 Celestino A Adjunct 111509 111509 Y 2017-03-09T11:29:00-05:00 TBA Main Session 1 20091 79 Fall Term 2008 Day Time D No No No No
No Palm Beach Gardens Campus 2 Pb Gardens Open O Health Concept/Strat HSC2100 HSC Lower 1 Lecture 01 Credit Credit Credit A & P 01 HSC2100 20152 Conventional Hlth - Health Education HLTH Health Education Deg - Degree DEG Degree No No 114 11408 No Education Education No Yes 36 1 No Mari Astromoff,Mari,J 52858 Astromoff J Adjunct 235618 235618 Y 2017-03-09T11:29:00-05:00 TBA Main Session 1 20182 43 Spring Term 2018 Evening E No No No No
No Boca Raton Campus 5 Boca Raton Unavailable U Intro Education Tech EME2040 EME Lower 1 Lecture 01 Credit Credit Credit A & P 01 EME2040 20101 Distance Learning Edu - Education EDU Education Deg - Degree DEG Degree No No 114 11408 No Education Education No Yes 24 1 Yes Patricia Dewilde,Patricia,A 1586 Dewilde A Adjunct 99009 99009 Y 2017-03-09T11:29:00-05:00 TBA Main Session 1 20081 10 Fall Term 2007 Other O No No No No
No Lake Worth Campus 1 Lake Worth Unavailable U Crime Scene Safety CJB2703 CJB Lower 1 Lecture 01 Credit Credit Credit Occup/Postsecondary Vocational 02 CJB2703 20081 Conventional Csi - Crime Scene Investigation CSI Crime Scene Investigation Deg - Degree DEG Degree No No 127 12701 No Public Service Public Service No No 24 12 No Lee Emerson,Lee,S 72491 Emerson S Faculty 173677 173677 Y 2017-03-09T11:29:00-05:00 TBA Summer A (1St 6 Weeks) 2 20133 2 Summer Term 2013 Day Time D No No No No
No Lake Worth Campus 1 Lake Worth Unavailable U Excel Basics CWO0115 CWO Lower 0 Lecture 01 NonCredit NonCredit NonCredit Supplemental Vocational 06 CWO0115 20052 Conventional Ccte - Computers-Cte CCTE Computers-Cte Cte - Career & Technical Education CTE Career & Technical Education No No 125 12503 No Business Business Yes No 9 5 No Nanette Zhang,Nanette,R 31071 Zhang R Adjunct 181717 181717 Y 2017-03-09T11:29:00-05:00 TBA 3 Days To 5 Weeks NC5 20133 3 Summer Term 2013 Evening E No No No No
Powered by BI Documenter