EnterpriseDW
 dbo.FactEOTEnrollmentSnapshot (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.FactEOTEnrollmentSnapshot
  Properties
Property Value
Name FactEOTEnrollmentSnapshot
Schema dbo
Row Count 3628181
Data Size 273280 KB
Index Size 8 KB
Create Date 9/10/2012 1:44 PM
Description The End of Term Enrollment Fact contains the record of the institutional enrollment for the terms for which the institution has been using INTEGROW. The enrollment snapshote will always contains the most current enrollment for the term. 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
Foreign Key
ActiveTermSK
int(10, 0)
False
False
False
 
Unique key identifier for the active term, used to reference the term dimension.
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.
EOTClockHours
numeric(6, 2)
False
False
False
 
Contact Hours for the class if the student is enrolled at the end of 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.
EOTCreditAndClockHoursCombined
numeric(6, 2)
False
False
False
 
The total value of the Clock Hours divided by 30 and the Credit Hours combined.
EOTCreditHours
numeric(5, 2)
False
False
False
 
CreditHours for the class, if the student is enrolled at the end of term and the class is a credit class. Values are the CNTCT_HRS for credit classes.
EOTEnrollment
int(10, 0)
False
False
False
 
Indication that the student is enrolled in the class as of the relative day for the end of term - term (i.e. not dropped). The valid values are 1 for enrolled.
EOTFullTimeEquivalent
numeric(7, 6)
False
False
False
 
Calculated full time equivalent for the student for the class, if enrolled in the end of term - term. The values for credit classes is calculated by CreditHours divided by 30 and for NonCredit Classes by ContactHours divided by 900.
EOTPaidEnrollment
int(10, 0)
False
False
False
 
Indication that the student is enrolled and paid for the class as of the relative day for the end of term - term. the valid values are 1 for paid and 0 for not paid.
EOTPaidFullTimeEquivalent
numeric(7, 6)
False
False
False
 
Calculated full time equivalent for the student for the class, if enrolled and paid in the end of term - term. 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.
EOTRelativeDay
int(10, 0)
False
False
False
 
A numeric value which indicates the days as calculated from the start date of the end of term - 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
EOTTermSK
int(10, 0)
False
False
False
 
Unique key identifier for the end of term - term, used to reference the term dimension.
Foreign Key
FTEClassificationSK
int(10, 0)
False
False
False
 
Unique key identifier for the FTE classification, used to reference the FTE classification 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.
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
ActiveTermSK
DimTerm
TermSK
True
CurriculumSK
DimCurriculum
CurriculumSK
True
DateSK
DimDate
DateSK
True
EOTTermSK
DimTerm
TermSK
True
FTEClassificationSK
DimFTEClassification
FTEClassificationSK
True
StudentSK
DimStudent
StudentSK
True
StudentTermSK
DimStudentTerm
StudentTermSK
True
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.FactEOTEnrollmentSnapshot depends on)
Name Type
Table
Table
Table
Table
Table
Table
  Child Dependencies (objects that depend on dbo.FactEOTEnrollmentSnapshot)
Name Type
TABLE
TABLE
TABLE
TABLE
TABLE
TABLE
  Extended Properties
Object Property Value
FactEOTEnrollmentSnapshot
MS_Description
The End of Term Enrollment Fact contains the record of the institutional enrollment for the terms for which the institution has been using INTEGROW. The enrollment snapshote will always contains the most current enrollment for the term. The fact will contain one row per student, per class where the student is enrolled (not dropped).
ActiveTermSK
MS_Description
Unique key identifier for the active term, used to reference the term dimension.
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.
EOTClockHours
MS_Description
Contact Hours for the class if the student is enrolled at the end of 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.
EOTCreditAndClockHoursCombined
MS_Description
The total value of the Clock Hours divided by 30 and the Credit Hours combined.
EOTCreditHours
MS_Description
CreditHours for the class, if the student is enrolled at the end of term and the class is a credit class. Values are the CNTCT_HRS for credit classes.
EOTEnrollment
MS_Description
Indication that the student is enrolled in the class as of the relative day for the end of term - term (i.e. not dropped). The valid values are 1 for enrolled.
EOTFullTimeEquivalent
MS_Description
Calculated full time equivalent for the student for the class, if enrolled in the end of term - term. The values for credit classes is calculated by CreditHours divided by 30 and for NonCredit Classes by ContactHours divided by 900.
EOTPaidEnrollment
MS_Description
Indication that the student is enrolled and paid for the class as of the relative day for the end of term - term. the valid values are 1 for paid and 0 for not paid.
EOTPaidFullTimeEquivalent
MS_Description
Calculated full time equivalent for the student for the class, if enrolled and paid in the end of term - term. 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.
EOTRelativeDay
MS_Description
A numeric value which indicates the days as calculated from the start date of the end of term - 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.
EOTTermSK
MS_Description
Unique key identifier for the end of term - term, used to reference the term dimension.
FTEClassificationSK
MS_Description
Unique key identifier for the FTE classification, used to reference the FTE classification 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.
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[FactEOTEnrollmentSnapshot] Script Date: 03/09/2017 17:14:57 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[FactEOTEnrollmentSnapshot](
    [DateSK] [int] NOT NULL,
    [StudentSK] [int] NOT NULL,
    [StudentTermSK] [int] NOT NULL,
    [ActiveTermSK] [int] NOT NULL,
    [CurriculumSK] [int] NOT NULL,
    [FTEClassificationSK] [int] NOT NULL,
    [EOTTermSK] [int] NOT NULL,
    [EOTRelativeDay] [int] NOT NULL,
    [EOTEnrollment] [int] NOT NULL,
    [EOTPaidEnrollment] [int] NOT NULL,
    [EOTCreditHours] [numeric](5, 2) NOT NULL,
    [EOTClockHours] [numeric](6, 2) NOT NULL,
    [EOTFullTimeEquivalent] [numeric](7, 6) NOT NULL,
    [EOTPaidFullTimeEquivalent] [numeric](7, 6) NOT NULL,
    [EOTCreditAndClockHoursCombined] [numeric](6, 2) NOT NULL
) ON [PRIMARY]
ALTER TABLE [dbo].[FactEOTEnrollmentSnapshot]  WITH CHECK ADD  CONSTRAINT [FK_FactEOTEnrollmentSnapshot_DimActiveTerm] FOREIGN KEY([ActiveTermSK])
REFERENCES [DimTerm] ([TermSK])
ALTER TABLE [dbo].[FactEOTEnrollmentSnapshot] CHECK CONSTRAINT [FK_FactEOTEnrollmentSnapshot_DimActiveTerm]
ALTER TABLE [dbo].[FactEOTEnrollmentSnapshot]  WITH CHECK ADD  CONSTRAINT [FK_FactEOTEnrollmentSnapshot_DimCurriculum] FOREIGN KEY([CurriculumSK])
REFERENCES [DimCurriculum] ([CurriculumSK])
ALTER TABLE [dbo].[FactEOTEnrollmentSnapshot] CHECK CONSTRAINT [FK_FactEOTEnrollmentSnapshot_DimCurriculum]
ALTER TABLE [dbo].[FactEOTEnrollmentSnapshot]  WITH CHECK ADD  CONSTRAINT [FK_FactEOTEnrollmentSnapshot_DimDate] FOREIGN KEY([DateSK])
REFERENCES [DimDate] ([DateSK])
ALTER TABLE [dbo].[FactEOTEnrollmentSnapshot] CHECK CONSTRAINT [FK_FactEOTEnrollmentSnapshot_DimDate]
ALTER TABLE [dbo].[FactEOTEnrollmentSnapshot]  WITH CHECK ADD  CONSTRAINT [FK_FactEOTEnrollmentSnapshot_DimEOTTerm] FOREIGN KEY([EOTTermSK])
REFERENCES [DimTerm] ([TermSK])
ALTER TABLE [dbo].[FactEOTEnrollmentSnapshot] CHECK CONSTRAINT [FK_FactEOTEnrollmentSnapshot_DimEOTTerm]
ALTER TABLE [dbo].[FactEOTEnrollmentSnapshot]  WITH CHECK ADD  CONSTRAINT [FK_FactEOTEnrollmentSnapshot_DimFTEClassification] FOREIGN KEY([FTEClassificationSK])
REFERENCES [DimFTEClassification] ([FTEClassificationSK])
ALTER TABLE [dbo].[FactEOTEnrollmentSnapshot] CHECK CONSTRAINT [FK_FactEOTEnrollmentSnapshot_DimFTEClassification]
ALTER TABLE [dbo].[FactEOTEnrollmentSnapshot]  WITH CHECK ADD  CONSTRAINT [FK_FactEOTEnrollmentSnapshot_DimStudent] FOREIGN KEY([StudentSK])
REFERENCES [DimStudent] ([StudentSK])
ALTER TABLE [dbo].[FactEOTEnrollmentSnapshot] CHECK CONSTRAINT [FK_FactEOTEnrollmentSnapshot_DimStudent]
ALTER TABLE [dbo].[FactEOTEnrollmentSnapshot]  WITH CHECK ADD  CONSTRAINT [FK_FactEOTEnrollmentSnapshot_DimStudentTerm] FOREIGN KEY([StudentTermSK])
REFERENCES [DimStudentTerm] ([StudentTermSK])
ALTER TABLE [dbo].[FactEOTEnrollmentSnapshot] CHECK CONSTRAINT [FK_FactEOTEnrollmentSnapshot_DimStudentTerm]


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The End of Term Enrollment Fact contains the record of the institutional enrollment for the terms for which the institution has been using INTEGROW. The enrollment snapshote will always contains the most current enrollment for the term. 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'FactEOTEnrollmentSnapshot'


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


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


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Contact Hours for the class if the student is enrolled at the end of 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'FactEOTEnrollmentSnapshot', @level2type=N'COLUMN',@level2name=N'EOTClockHours'


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


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'CreditHours for the class, if the student is enrolled at the end of term 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'FactEOTEnrollmentSnapshot', @level2type=N'COLUMN',@level2name=N'EOTCreditHours'


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 end of term - term (i.e. not dropped). The valid values are 1 for enrolled.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactEOTEnrollmentSnapshot', @level2type=N'COLUMN',@level2name=N'EOTEnrollment'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Calculated full time equivalent for the student for the class, if enrolled in the end of term - term. 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'FactEOTEnrollmentSnapshot', @level2type=N'COLUMN',@level2name=N'EOTFullTimeEquivalent'


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 end of term - term. the valid values are 1 for paid and 0 for not paid.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactEOTEnrollmentSnapshot', @level2type=N'COLUMN',@level2name=N'EOTPaidEnrollment'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Calculated full time equivalent for the student for the class, if enrolled and paid in the end of term - term. 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'FactEOTEnrollmentSnapshot', @level2type=N'COLUMN',@level2name=N'EOTPaidFullTimeEquivalent'


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 end of term - 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'FactEOTEnrollmentSnapshot', @level2type=N'COLUMN',@level2name=N'EOTRelativeDay'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Unique key identifier for the end of term - term, used to reference the term dimension.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactEOTEnrollmentSnapshot', @level2type=N'COLUMN',@level2name=N'EOTTermSK'


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


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'FactEOTEnrollmentSnapshot', @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'FactEOTEnrollmentSnapshot', @level2type=N'COLUMN',@level2name=N'StudentTermSK'
  Sample Data
CheckComponentTypeAK ComponentCategory ComponentLine ComponentLineCode ComponentOne ComponentOneCode ComponentTwo ComponentTwoCode RowIsDuplicate RowIsSelected VerifyCheckComponentTypeSK
01ASSIGNRG3 Gross Gross 01 REGULAR GROSS FROM ASSIGNMENT ASSIGNRG N/A 3 N Y 34
07VISION VISCHILD Deduction Pre Tax Deduction 07 VISION INSURANCE VISION VISION DEDUCTION FOR CHILD PLAN VISCHILD N Y 278
03UA UA Benefit Benefit 03 FRS RETIREE NOT ELIGIBLE UA FRS RETIREE NOT ELIGIBLE UA N Y 136
16HTHHBUCHHLTHCHBU Benefit Benefit Accounts 16 HMO BARG UNIT EMPLOYEE+CHILD/PD BY COLL HTHHBUCH HMO BARG UNIT EEC PAID BY COLLEGE HLTHCHBU N Y 670
07HEALTH HMODUAL1 Deduction Pre Tax Deduction 07 COLLEGE'S HEALTH PORTION/PD. BY COLLEGE HEALTH HMO HEALTH/DUAL/1ST PERSON HMODUAL1 N Y 237
14CHILDSUPCHSP WI Deduction Post Tax Adjustment 14 CHILD SUPPORT CHILDSUP CHILD SUPP/MILWAUKEE WISCONSIN CHSP WI N Y 560
16DTLSRSP DTLSRSP Benefit Benefit Accounts 16 SR.MAN.+SPOUSE DENTAL HMO PD BY COLLEGE DTLSRSP SR.MAN.+SPOUSE DENTAL HMO PD BY COLLEGE DTLSRSP N Y 640
13FACC FACC60 Deduction Post Tax Deduction 13 FACC DEDUCTIONS FACC AFC 60.00 PER YEAR (LESS THAN 100,000) FACC60 N Y 450
08HEALTH HMOBU SG Deduction Pre Tax Deduction Adjustment 08 COLLEGE'S HEALTH PORTION/PD. BY COLLEGE HEALTH HMO BARG UNIT EMPLOYEE ONLY HMOBU SG N Y 341
13HEALTH PPOCHILD Deduction Post Tax Deduction 13 COLLEGE'S HEALTH PORTION/PD. BY COLLEGE HEALTH PPO HEALTH/EMPLOYEE PLUS CHILD PPOCHILD N Y 494
Powered by BI Documenter