EnterpriseDW
 dbo.FactActiveEnrollmentSnapshot (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.FactActiveEnrollmentSnapshot
  Properties
Property Value
Name FactActiveEnrollmentSnapshot
Schema dbo
Row Count 221455
Data Size 15712 KB
Index Size 8 KB
Create Date 9/5/2012 10:56 AM
Description The Active Enrollment Fact contains the record of the institutional enrollment for the active terms. The enrollment snapshote will be as of the day being processed. 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)
False
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.
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.
RelativeDay
int(10, 0)
False
False
False
 
A numeric value which indicates the days as calculated from the start date of the term. The smaller the number, the closer the day is to the start of the term. Negative numbers indicate the day is prior to the start of the term.
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
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
CurriculumSK
DimCurriculum
CurriculumSK
True
DateSK
DimDate
DateSK
True
FTEClassificationSK
DimFTEClassification
FTEClassificationSK
True
StudentSK
DimStudent
StudentSK
True
StudentTermSK
DimStudentTerm
StudentTermSK
True
TermSK
DimTerm
TermSK
True
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.FactActiveEnrollmentSnapshot depends on)
Name Type
Table
Table
Table
Table
Table
Table
  Child Dependencies (objects that depend on dbo.FactActiveEnrollmentSnapshot)
Name Type
TABLE
TABLE
TABLE
TABLE
TABLE
TABLE
  Extended Properties
Object Property Value
FactActiveEnrollmentSnapshot
MS_Description
The Active Enrollment Fact contains the record of the institutional enrollment for the active terms. The enrollment snapshote will be as of the day being processed. 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.
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.
RelativeDay
MS_Description
A numeric value which indicates the days as calculated from the start date of the term. The smaller the number, the closer the day is to the start of the term. Negative numbers indicate the day is prior to the start of the term.
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].[FactActiveEnrollmentSnapshot] Script Date: 03/09/2017 17:14:57 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[FactActiveEnrollmentSnapshot](
    [DateSK] [int] NOT NULL,
    [StudentSK] [int] NOT NULL,
    [StudentTermSK] [int] NOT NULL,
    [TermSK] [int] NOT NULL,
    [CurriculumSK] [int] NOT NULL,
    [FTEClassificationSK] [int] NOT NULL,
    [RelativeDay] [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) NOT NULL
) ON [PRIMARY]
ALTER TABLE [dbo].[FactActiveEnrollmentSnapshot]  WITH CHECK ADD  CONSTRAINT [FK_FactActiveEnrollmentSnapshot_DimCurriculum] FOREIGN KEY([CurriculumSK])
REFERENCES [DimCurriculum] ([CurriculumSK])
ALTER TABLE [dbo].[FactActiveEnrollmentSnapshot] CHECK CONSTRAINT [FK_FactActiveEnrollmentSnapshot_DimCurriculum]
ALTER TABLE [dbo].[FactActiveEnrollmentSnapshot]  WITH CHECK ADD  CONSTRAINT [FK_FactActiveEnrollmentSnapshot_DimDate] FOREIGN KEY([DateSK])
REFERENCES [DimDate] ([DateSK])
ALTER TABLE [dbo].[FactActiveEnrollmentSnapshot] CHECK CONSTRAINT [FK_FactActiveEnrollmentSnapshot_DimDate]
ALTER TABLE [dbo].[FactActiveEnrollmentSnapshot]  WITH CHECK ADD  CONSTRAINT [FK_FactActiveEnrollmentSnapshot_DimFTEClassification] FOREIGN KEY([FTEClassificationSK])
REFERENCES [DimFTEClassification] ([FTEClassificationSK])
ALTER TABLE [dbo].[FactActiveEnrollmentSnapshot] CHECK CONSTRAINT [FK_FactActiveEnrollmentSnapshot_DimFTEClassification]
ALTER TABLE [dbo].[FactActiveEnrollmentSnapshot]  WITH CHECK ADD  CONSTRAINT [FK_FactActiveEnrollmentSnapshot_DimStudent] FOREIGN KEY([StudentSK])
REFERENCES [DimStudent] ([StudentSK])
ALTER TABLE [dbo].[FactActiveEnrollmentSnapshot] CHECK CONSTRAINT [FK_FactActiveEnrollmentSnapshot_DimStudent]
ALTER TABLE [dbo].[FactActiveEnrollmentSnapshot]  WITH CHECK ADD  CONSTRAINT [FK_FactActiveEnrollmentSnapshot_DimStudentTerm] FOREIGN KEY([StudentTermSK])
REFERENCES [DimStudentTerm] ([StudentTermSK])
ALTER TABLE [dbo].[FactActiveEnrollmentSnapshot] CHECK CONSTRAINT [FK_FactActiveEnrollmentSnapshot_DimStudentTerm]
ALTER TABLE [dbo].[FactActiveEnrollmentSnapshot]  WITH CHECK ADD  CONSTRAINT [FK_FactActiveEnrollmentSnapshot_DimTerm] FOREIGN KEY([TermSK])
REFERENCES [DimTerm] ([TermSK])
ALTER TABLE [dbo].[FactActiveEnrollmentSnapshot] CHECK CONSTRAINT [FK_FactActiveEnrollmentSnapshot_DimTerm]


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The Active Enrollment Fact contains the record of the institutional enrollment for the active terms. The enrollment snapshote will be as of the day being processed. 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'FactActiveEnrollmentSnapshot'


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'FactActiveEnrollmentSnapshot', @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'FactActiveEnrollmentSnapshot', @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'FactActiveEnrollmentSnapshot', @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'FactActiveEnrollmentSnapshot', @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'FactActiveEnrollmentSnapshot', @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'FactActiveEnrollmentSnapshot', @level2type=N'COLUMN',@level2name=N'Enrollment'


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'FactActiveEnrollmentSnapshot', @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'FactActiveEnrollmentSnapshot', @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'FactActiveEnrollmentSnapshot', @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'FactActiveEnrollmentSnapshot', @level2type=N'COLUMN',@level2name=N'PaidFullTimeEquivalent'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'A numeric value which indicates the days as calculated from the start date of the term. The smaller the number, the closer the day is to the start of the term. Negative numbers indicate the day is prior to the start of the term.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactActiveEnrollmentSnapshot', @level2type=N'COLUMN',@level2name=N'RelativeDay'


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'FactActiveEnrollmentSnapshot', @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'FactActiveEnrollmentSnapshot', @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'FactActiveEnrollmentSnapshot', @level2type=N'COLUMN',@level2name=N'TermSK'
  Sample Data
CompensationCategory CompensationType CompensationTypeAK CompensationTypeCode RowEndDate RowIsCurrent RowStartDate
Benefit Frs/Local Annuity Optional Program FLRETHO FLRETHO 9999-12-31T23:59:00-05:00 Y 2017-03-09T12:11:00-05:00
Benefit Ppo College's Portion Pd By College For Spouse PPO+SP PPO+SP 9999-12-31T23:59:00-05:00 Y 2017-03-09T12:11:00-05:00
Benefit Hra Barg Unit Employee Plus One/Pd By Coll HRABU+1 HRABU+1 9999-12-31T23:59:00-05:00 Y 2017-03-09T12:11:00-05:00
Benefit Frs Retiree Not Eligible UA UA 9999-12-31T23:59:00-05:00 Y 2017-03-09T12:11:00-05:00
Benefit Hmo Barg Unit Ee+Spouse/Pd By Coll HTHHBUSP HTHHBUSP 9999-12-31T23:59:00-05:00 Y 2017-03-09T12:11:00-05:00
Benefit Plan C With Consortium Hmo Dental PLANCDH PLANCDH 9999-12-31T23:59:00-05:00 Y 2017-03-09T12:11:00-05:00
Benefit Ppo College's Portion Pd By College For Children PPO+CH PPO+CH 9999-12-31T23:59:00-05:00 Y 2017-03-09T12:11:00-05:00
Salary Salary SALARY SALARY 9999-12-31T23:59:00-05:00 Y 2017-03-09T12:11:00-05:00
Deduction Savings Bonds Deductions BONDS BONDS 9999-12-31T23:59:00-05:00 Y 2017-03-09T12:11:00-05:00
Deduction Child Support CHILDSUP CHILDSUP 9999-12-31T23:59:00-05:00 Y 2017-03-09T12:11:00-05:00
Powered by BI Documenter