EnterpriseDW
 dbo.FactEnrollmentSnapshot (Table)
Home  Diagrams  Documents  Images  EnterpriseDW  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:  EnterpriseDW   Tables   dbo.FactEnrollmentSnapshot
  Properties
Property Value
Name FactEnrollmentSnapshot
Schema dbo
Row Count 4718883
Data Size 352816 KB
Index Size 1320 KB
Create Date 5/29/2013 12:12 AM
Description The Enrollment Snapshot Fact contains the enrollment for Active Terms and three years prior to each active term as of the Processing Day and for the seven days prior, The fact will contain one row per student, per class where the student is enrolled (not dropped).
  Columns
 
 
Column Name
Data Type
Allow Nulls
Row Guid
Fulltext Indexed
Identity
Default
Description / Computed Formula
ClockHours
numeric(6, 2)
False
False
False
 
Contact Hours for the class if the student is enrolled in the term and if the class is 'not' a credit class. The values are the EVAL_CRED_HRS for NonCredit classes and the CNTCT_HRS for Test classes.
CreditAndClockHoursCombined
numeric(6, 2)
True
False
False
 
The total value of the Clock Hours divided by 30 and the Credit Hours combined.
CreditHours
numeric(5, 2)
False
False
False
 
CreditHours for the class, if the student is enrolled and the class is a credit class. Values are the CNTCT_HRS for credit classes.
Foreign Key
CurriculumSK
int(10, 0)
False
False
False
 
Unique key identifier for the class, used to reference the curriculum dimension.
Foreign Key
DateSK
int(10, 0)
False
False
False
 
Unique key identifier for the date, used to reference the date dimension.
Enrollment
int(10, 0)
False
False
False
 
Indication that the student is enrolled in the class as of the relative day for the term (i.e. not dropped). The valid values are 1 for enrolled.
In Primary Key
EnrollmentSnapshotSK
int(10, 0)
False
False
False
(1 / 1)
Unique identifier for an instance in the Enrollment Snapshot fact in the data warehouse, in numeric format.
Foreign Key
FTEClassificationSK
int(10, 0)
False
False
False
 
Unique key identifier for the FTE classification, used to reference the FTE classification dimension.
FullTimeEquivalent
numeric(7, 6)
False
False
False
 
Calculated full time equivalent for the student for the class, if enrolled. The values for credit classes is calculated by CreditHours divided by 30 and for NonCredit Classes by ContactHours divided by 900.
PaidEnrollment
int(10, 0)
False
False
False
 
Indication that the student is enrolled and paid for the class as of the relative day for the term. the valid values are 1 for paid and 0 for not paid.
PaidFullTimeEquivalent
numeric(7, 6)
False
False
False
 
Calculated full time equivalent for the student for the class, if enrolled and paid. The values for credit classes is calculated by CreditHours divided by 30 and for NonCredit Classes by ContactHours divided by 900. If the student is not paid, the value will be zero.
Foreign Key
RelativeDaySK
int(10, 0)
False
False
False
 
Unique key identifier for the relative date for enrollment, used to reference the relative day dimension.
Foreign Key
StudentSK
int(10, 0)
False
False
False
 
Unique key identifier for the student, used to reference the student dimension.
Foreign Key
StudentTermSK
int(10, 0)
False
False
False
 
Unique key identifier for the student+Term, used to reference the student term dimension.
Foreign Key
TermSK
int(10, 0)
False
False
False
 
Unique key identifier for the active term, used to reference the term dimension.
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
True
EnrollmentSnapshotSK
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
CurriculumSK
DimCurriculum
CurriculumSK
True
DateSK
DimDate
DateSK
True
FTEClassificationSK
DimFTEClassification
FTEClassificationSK
True
RelativeDaySK
DimRelativeDay
RelativeDaySK
True
StudentSK
DimStudent
StudentSK
True
StudentTermSK
DimStudentTerm
StudentTermSK
True
TermSK
DimTerm
TermSK
True
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.FactEnrollmentSnapshot depends on)
Name Type
Table
Table
Table
Table
Table
Table
Table
  Child Dependencies (objects that depend on dbo.FactEnrollmentSnapshot)
Name Type
TABLE
TABLE
TABLE
TABLE
TABLE
TABLE
TABLE
  Extended Properties
Object Property Value
FactEnrollmentSnapshot
MS_Description
The Enrollment Snapshot Fact contains the enrollment for Active Terms and three years prior to each active term as of the Processing Day and for the seven days prior, The fact will contain one row per student, per class where the student is enrolled (not dropped).
ClockHours
MS_Description
Contact Hours for the class if the student is enrolled in the term and if the class is 'not' a credit class. The values are the EVAL_CRED_HRS for NonCredit classes and the CNTCT_HRS for Test classes.
CreditAndClockHoursCombined
MS_Description
The total value of the Clock Hours divided by 30 and the Credit Hours combined.
CreditHours
MS_Description
CreditHours for the class, if the student is enrolled and the class is a credit class. Values are the CNTCT_HRS for credit classes.
CurriculumSK
MS_Description
Unique key identifier for the class, used to reference the curriculum dimension.
DateSK
MS_Description
Unique key identifier for the date, used to reference the date dimension.
Enrollment
MS_Description
Indication that the student is enrolled in the class as of the relative day for the term (i.e. not dropped). The valid values are 1 for enrolled.
EnrollmentSnapshotSK
MS_Description
Unique identifier for an instance in the Enrollment Snapshot fact in the data warehouse, in numeric format.
FTEClassificationSK
MS_Description
Unique key identifier for the FTE classification, used to reference the FTE classification dimension.
FullTimeEquivalent
MS_Description
Calculated full time equivalent for the student for the class, if enrolled. The values for credit classes is calculated by CreditHours divided by 30 and for NonCredit Classes by ContactHours divided by 900.
PaidEnrollment
MS_Description
Indication that the student is enrolled and paid for the class as of the relative day for the term. the valid values are 1 for paid and 0 for not paid.
PaidFullTimeEquivalent
MS_Description
Calculated full time equivalent for the student for the class, if enrolled and paid. The values for credit classes is calculated by CreditHours divided by 30 and for NonCredit Classes by ContactHours divided by 900. If the student is not paid, the value will be zero.
RelativeDaySK
MS_Description
Unique key identifier for the relative date for enrollment, used to reference the relative day dimension.
StudentSK
MS_Description
Unique key identifier for the student, used to reference the student dimension.
StudentTermSK
MS_Description
Unique key identifier for the student+Term, used to reference the student term dimension.
TermSK
MS_Description
Unique key identifier for the active term, used to reference the term dimension.
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[FactEnrollmentSnapshot] Script Date: 03/09/2017 17:14:57 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[FactEnrollmentSnapshot](
    [EnrollmentSnapshotSK] [int] IDENTITY(1,1) NOT NULL,
    [DateSK] [int] NOT NULL,
    [StudentSK] [int] NOT NULL,
    [StudentTermSK] [int] NOT NULL,
    [TermSK] [int] NOT NULL,
    [CurriculumSK] [int] NOT NULL,
    [FTEClassificationSK] [int] NOT NULL,
    [RelativeDaySK] [int] NOT NULL,
    [Enrollment] [int] NOT NULL,
    [PaidEnrollment] [int] NOT NULL,
    [CreditHours] [numeric](5, 2) NOT NULL,
    [ClockHours] [numeric](6, 2) NOT NULL,
    [FullTimeEquivalent] [numeric](7, 6) NOT NULL,
    [PaidFullTimeEquivalent] [numeric](7, 6) NOT NULL,
    [CreditAndClockHoursCombined] [numeric](6, 2) NULL,
 CONSTRAINT [PK_FactEnrollmentSnapshot] PRIMARY KEY CLUSTERED 
(
    [EnrollmentSnapshotSK] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
ALTER TABLE [dbo].[FactEnrollmentSnapshot]  WITH CHECK ADD  CONSTRAINT [FK_FactEnrollmentSnapshot_DimCurriculum] FOREIGN KEY([CurriculumSK])
REFERENCES [DimCurriculum] ([CurriculumSK])
ALTER TABLE [dbo].[FactEnrollmentSnapshot] CHECK CONSTRAINT [FK_FactEnrollmentSnapshot_DimCurriculum]
ALTER TABLE [dbo].[FactEnrollmentSnapshot]  WITH CHECK ADD  CONSTRAINT [FK_FactEnrollmentSnapshot_DimDate] FOREIGN KEY([DateSK])
REFERENCES [DimDate] ([DateSK])
ALTER TABLE [dbo].[FactEnrollmentSnapshot] CHECK CONSTRAINT [FK_FactEnrollmentSnapshot_DimDate]
ALTER TABLE [dbo].[FactEnrollmentSnapshot]  WITH CHECK ADD  CONSTRAINT [FK_FactEnrollmentSnapshot_DimFTEClassification] FOREIGN KEY([FTEClassificationSK])
REFERENCES [DimFTEClassification] ([FTEClassificationSK])
ALTER TABLE [dbo].[FactEnrollmentSnapshot] CHECK CONSTRAINT [FK_FactEnrollmentSnapshot_DimFTEClassification]
ALTER TABLE [dbo].[FactEnrollmentSnapshot]  WITH CHECK ADD  CONSTRAINT [FK_FactEnrollmentSnapshot_DimRelativeDay] FOREIGN KEY([RelativeDaySK])
REFERENCES [DimRelativeDay] ([RelativeDaySK])
ALTER TABLE [dbo].[FactEnrollmentSnapshot] CHECK CONSTRAINT [FK_FactEnrollmentSnapshot_DimRelativeDay]
ALTER TABLE [dbo].[FactEnrollmentSnapshot]  WITH CHECK ADD  CONSTRAINT [FK_FactEnrollmentSnapshot_DimStudent] FOREIGN KEY([StudentSK])
REFERENCES [DimStudent] ([StudentSK])
ALTER TABLE [dbo].[FactEnrollmentSnapshot] CHECK CONSTRAINT [FK_FactEnrollmentSnapshot_DimStudent]
ALTER TABLE [dbo].[FactEnrollmentSnapshot]  WITH CHECK ADD  CONSTRAINT [FK_FactEnrollmentSnapshot_DimStudentTerm] FOREIGN KEY([StudentTermSK])
REFERENCES [DimStudentTerm] ([StudentTermSK])
ALTER TABLE [dbo].[FactEnrollmentSnapshot] CHECK CONSTRAINT [FK_FactEnrollmentSnapshot_DimStudentTerm]
ALTER TABLE [dbo].[FactEnrollmentSnapshot]  WITH CHECK ADD  CONSTRAINT [FK_FactEnrollmentSnapshot_DimTerm] FOREIGN KEY([TermSK])
REFERENCES [DimTerm] ([TermSK])
ALTER TABLE [dbo].[FactEnrollmentSnapshot] CHECK CONSTRAINT [FK_FactEnrollmentSnapshot_DimTerm]


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The Enrollment Snapshot Fact contains the enrollment for Active Terms and three years prior to each active term as of the Processing Day and for the seven days prior, The fact will contain one row per student, per class where the student is enrolled (not dropped).' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactEnrollmentSnapshot'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Contact Hours for the class if the student is enrolled in the term and if the class is ''not'' a credit class. The values are the EVAL_CRED_HRS for NonCredit classes and the CNTCT_HRS for Test classes. ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactEnrollmentSnapshot', @level2type=N'COLUMN',@level2name=N'ClockHours'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The total value of the Clock Hours divided by 30 and the Credit Hours combined.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactEnrollmentSnapshot', @level2type=N'COLUMN',@level2name=N'CreditAndClockHoursCombined'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'CreditHours for the class, if the student is enrolled and the class is a credit class. Values are the CNTCT_HRS for credit classes.
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactEnrollmentSnapshot', @level2type=N'COLUMN',@level2name=N'CreditHours'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Unique key identifier for the class, used to reference the curriculum dimension.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactEnrollmentSnapshot', @level2type=N'COLUMN',@level2name=N'CurriculumSK'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Unique key identifier for the date, used to reference the date dimension.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactEnrollmentSnapshot', @level2type=N'COLUMN',@level2name=N'DateSK'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Indication that the student is enrolled in the class as of the relative day for the term (i.e. not dropped). The valid values are 1 for enrolled.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactEnrollmentSnapshot', @level2type=N'COLUMN',@level2name=N'Enrollment'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Unique identifier for an instance in the Enrollment Snapshot fact in the data warehouse, in numeric format.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactEnrollmentSnapshot', @level2type=N'COLUMN',@level2name=N'EnrollmentSnapshotSK'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Unique key identifier for the FTE classification, used to reference the FTE classification dimension.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactEnrollmentSnapshot', @level2type=N'COLUMN',@level2name=N'FTEClassificationSK'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Calculated full time equivalent for the student for the class, if enrolled. The values for credit classes is calculated by CreditHours divided by 30 and for NonCredit Classes by ContactHours divided by 900.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactEnrollmentSnapshot', @level2type=N'COLUMN',@level2name=N'FullTimeEquivalent'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Indication that the student is enrolled and paid for the class as of the relative day for the term. the valid values are 1 for paid and 0 for not paid.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactEnrollmentSnapshot', @level2type=N'COLUMN',@level2name=N'PaidEnrollment'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Calculated full time equivalent for the student for the class, if enrolled and paid. The values for credit classes is calculated by CreditHours divided by 30 and for NonCredit Classes by ContactHours divided by 900. If the student is not paid, the value will be zero.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactEnrollmentSnapshot', @level2type=N'COLUMN',@level2name=N'PaidFullTimeEquivalent'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Unique key identifier for the relative date for enrollment, used to reference the relative day dimension.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactEnrollmentSnapshot', @level2type=N'COLUMN',@level2name=N'RelativeDaySK'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Unique key identifier for the student, used to reference the student dimension.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactEnrollmentSnapshot', @level2type=N'COLUMN',@level2name=N'StudentSK'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Unique key identifier for the student+Term, used to reference the student term dimension.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactEnrollmentSnapshot', @level2type=N'COLUMN',@level2name=N'StudentTermSK'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Unique key identifier for the active term, used to reference the term dimension.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactEnrollmentSnapshot', @level2type=N'COLUMN',@level2name=N'TermSK'
  Sample Data
ClockHours CreditAndClockHoursCombined CreditHours CurriculumSK DateSK Enrollment EnrollmentSnapshotSK FTEClassificationSK FullTimeEquivalent PaidEnrollment PaidFullTimeEquivalent RelativeDaySK StudentSK StudentTermSK TermSK
0.00 1.00 1.00 5501220 20150302 1 521120 5 0.033333 1 0.033333 192201501 23519960 54095381 20151
0.00 3.00 3.00 5501920 20150305 1 641706 5 0.100000 1 0.100000 195201501 23464722 53914466 20151
0.00 3.00 3.00 5501518 20150306 1 560902 5 0.100000 1 0.100000 196201501 22871993 50761631 20151
0.00 3.00 3.00 5498465 20150302 1 574202 5 0.100000 1 0.100000 192201501 22705457 50649550 20151
0.00 1.00 1.00 5505448 20150306 1 890302 5 0.033333 1 0.033333 196201501 23541838 54294732 20151
0.00 3.00 3.00 5508181 20150307 1 935877 5 0.100000 1 0.100000 59201502 23348023 53293567 20152
2.00 0.07 0.00 5533626 20170305 1 4000818 6 0.002222 1 0.002222 293201603 23159773 52263349 20163
0.00 3.00 3.00 5513727 20160305 1 1745492 5 0.100000 1 0.100000 292201503 22983236 51303142 20153
0.00 3.00 3.00 5503204 20150302 1 444075 5 0.100000 1 0.100000 192201501 22825151 50397335 20151
0.00 3.00 3.00 5513561 20160307 1 1731346 5 0.100000 1 0.100000 294201503 22939638 51093302 20153
Powered by BI Documenter