EnterpriseDW
 dbo.FactEnrollmentActivity (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.FactEnrollmentActivity
  Properties
Property Value
Name FactEnrollmentActivity
Schema dbo
Row Count 8613226
Data Size 682240 KB
Index Size 2552 KB
Create Date 5/29/2013 12:12 AM
Description The Enrollment Activity Fact conains the record of all registration actions including Adds and Drops per student, per class, per term, per day for all registration actibity.
  Columns
 
 
Column Name
Data Type
Allow Nulls
Row Guid
Fulltext Indexed
Identity
Default
Description / Computed Formula
Add
int(10, 0)
False
False
False
 
Count of the number of Adds for a student, for a class, for a term on a day.
AddCreditHours
numeric(6, 2)
False
False
False
 
Sum of the Credit Hours for the Adds for a student, for a class, for a term on a day.
AddFullTimeEquivalent
numeric(9, 6)
False
False
False
 
Sum of the Full Time Equivalents for the Adds for a student, for a class, for a term on a day.
Foreign Key
CurriculumSK
int(10, 0)
False
False
False
 
Unique key identifier for the curriculum, used to reference the curriculum dimension.
Foreign Key
DateSK
int(10, 0)
False
False
False
 
Unique key identifier for the enrollment date, used to reference the date dimension.
Drop
int(10, 0)
False
False
False
 
Count of the number of Drops for a student, for a class, for a term on a day.
DropCreditHours
numeric(6, 2)
False
False
False
 
Sum of the Credit Hours for the Drops for a student, for a class, for a term on a day.
DropFullTimeEquivalent
numeric(9, 6)
False
False
False
 
Sum of the Full Time Equivalents for the Drops for a student, for a class, for a term on a day.
In Primary Key
EnrollmentActivitySK
int(10, 0)
False
False
False
(1 / 1)
Unique identifier for an instance in the Enrollment Activity fact in the data warehouse, in numeric format.
Foreign Key
FTEClassificationSK
int(10, 0)
False
False
False
 
Unique key identifier for the full time equivalent classification, used to reference the FTE classification dimension.
NetCreditHours
numeric(6, 2)
False
False
False
 
The net effect on enrollment credit hours for Adds minus Drops for a student, for a class, for a term on a day.
NetFullTimeEquivalent
numeric(9, 6)
False
False
False
 
The net effect on Full Time Equivalents for Adds minus Drops for a student, for a class, for a term on a day.
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 studentterm dimension.
Foreign Key
TermSK
int(10, 0)
False
False
False
 
Unique key identifier for the term, used to reference the term dimension.
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
True
EnrollmentActivitySK
  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.FactEnrollmentActivity depends on)
Name Type
Table
Table
Table
Table
Table
Table
Table
  Child Dependencies (objects that depend on dbo.FactEnrollmentActivity)
Name Type
TABLE
TABLE
TABLE
TABLE
TABLE
TABLE
TABLE
  Extended Properties
Object Property Value
FactEnrollmentActivity
MS_Description
The Enrollment Activity Fact conains the record of all registration actions including Adds and Drops per student, per class, per term, per day for all registration actibity.
Add
MS_Description
Count of the number of Adds for a student, for a class, for a term on a day.
AddCreditHours
MS_Description
Sum of the Credit Hours for the Adds for a student, for a class, for a term on a day.
AddFullTimeEquivalent
MS_Description
Sum of the Full Time Equivalents for the Adds for a student, for a class, for a term on a day.
CurriculumSK
MS_Description
Unique key identifier for the curriculum, used to reference the curriculum dimension.
DateSK
MS_Description
Unique key identifier for the enrollment date, used to reference the date dimension.
Drop
MS_Description
Count of the number of Drops for a student, for a class, for a term on a day.
DropCreditHours
MS_Description
Sum of the Credit Hours for the Drops for a student, for a class, for a term on a day.
DropFullTimeEquivalent
MS_Description
Sum of the Full Time Equivalents for the Drops for a student, for a class, for a term on a day.
EnrollmentActivitySK
MS_Description
Unique identifier for an instance in the Enrollment Activity fact in the data warehouse, in numeric format.
FTEClassificationSK
MS_Description
Unique key identifier for the full time equivalent classification, used to reference the FTE classification dimension.
NetCreditHours
MS_Description
The net effect on enrollment credit hours for Adds minus Drops for a student, for a class, for a term on a day.
NetFullTimeEquivalent
MS_Description
The net effect on Full Time Equivalents for Adds minus Drops for a student, for a class, for a term on a day.
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 studentterm dimension.
TermSK
MS_Description
Unique key identifier for the term, used to reference the term dimension.
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[FactEnrollmentActivity] Script Date: 03/09/2017 17:14:57 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[FactEnrollmentActivity](
    [EnrollmentActivitySK] [int] IDENTITY(1,1) NOT NULL,
    [TermSK] [int] NOT NULL,
    [CurriculumSK] [int] NOT NULL,
    [StudentSK] [int] NOT NULL,
    [StudentTermSK] [int] NOT NULL,
    [DateSK] [int] NOT NULL,
    [RelativeDaySK] [int] NOT NULL,
    [FTEClassificationSK] [int] NOT NULL,
    [Drop] [int] NOT NULL,
    [Add] [int] NOT NULL,
    [DropCreditHours] [numeric](6, 2) NOT NULL,
    [AddCreditHours] [numeric](6, 2) NOT NULL,
    [NetCreditHours] [numeric](6, 2) NOT NULL,
    [DropFullTimeEquivalent] [numeric](9, 6) NOT NULL,
    [AddFullTimeEquivalent] [numeric](9, 6) NOT NULL,
    [NetFullTimeEquivalent] [numeric](9, 6) NOT NULL,
 CONSTRAINT [PK_FactEnrollmentActivity] PRIMARY KEY CLUSTERED 
(
    [EnrollmentActivitySK] 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].[FactEnrollmentActivity]  WITH CHECK ADD  CONSTRAINT [FK_FactEnrollmentActivity_DimCurriculum] FOREIGN KEY([CurriculumSK])
REFERENCES [DimCurriculum] ([CurriculumSK])
ALTER TABLE [dbo].[FactEnrollmentActivity] CHECK CONSTRAINT [FK_FactEnrollmentActivity_DimCurriculum]
ALTER TABLE [dbo].[FactEnrollmentActivity]  WITH CHECK ADD  CONSTRAINT [FK_FactEnrollmentActivity_DimDate] FOREIGN KEY([DateSK])
REFERENCES [DimDate] ([DateSK])
ALTER TABLE [dbo].[FactEnrollmentActivity] CHECK CONSTRAINT [FK_FactEnrollmentActivity_DimDate]
ALTER TABLE [dbo].[FactEnrollmentActivity]  WITH CHECK ADD  CONSTRAINT [FK_FactEnrollmentActivity_DimFTEClassification] FOREIGN KEY([FTEClassificationSK])
REFERENCES [DimFTEClassification] ([FTEClassificationSK])
ALTER TABLE [dbo].[FactEnrollmentActivity] CHECK CONSTRAINT [FK_FactEnrollmentActivity_DimFTEClassification]
ALTER TABLE [dbo].[FactEnrollmentActivity]  WITH CHECK ADD  CONSTRAINT [FK_FactEnrollmentActivity_DimRelativeDay] FOREIGN KEY([RelativeDaySK])
REFERENCES [DimRelativeDay] ([RelativeDaySK])
ALTER TABLE [dbo].[FactEnrollmentActivity] CHECK CONSTRAINT [FK_FactEnrollmentActivity_DimRelativeDay]
ALTER TABLE [dbo].[FactEnrollmentActivity]  WITH CHECK ADD  CONSTRAINT [FK_FactEnrollmentActivity_DimStudent] FOREIGN KEY([StudentSK])
REFERENCES [DimStudent] ([StudentSK])
ALTER TABLE [dbo].[FactEnrollmentActivity] CHECK CONSTRAINT [FK_FactEnrollmentActivity_DimStudent]
ALTER TABLE [dbo].[FactEnrollmentActivity]  WITH CHECK ADD  CONSTRAINT [FK_FactEnrollmentActivity_DimStudentTerm] FOREIGN KEY([StudentTermSK])
REFERENCES [DimStudentTerm] ([StudentTermSK])
ALTER TABLE [dbo].[FactEnrollmentActivity] CHECK CONSTRAINT [FK_FactEnrollmentActivity_DimStudentTerm]
ALTER TABLE [dbo].[FactEnrollmentActivity]  WITH CHECK ADD  CONSTRAINT [FK_FactEnrollmentActivity_DimTerm] FOREIGN KEY([TermSK])
REFERENCES [DimTerm] ([TermSK])
ALTER TABLE [dbo].[FactEnrollmentActivity] CHECK CONSTRAINT [FK_FactEnrollmentActivity_DimTerm]


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The Enrollment Activity Fact conains the record of all registration actions including Adds and Drops per student, per class, per term, per day for all registration actibity.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactEnrollmentActivity'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Count of the number of Adds for a student, for a class, for a term on a day.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactEnrollmentActivity', @level2type=N'COLUMN',@level2name=N'Add'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Sum of the Credit Hours for the Adds for a student, for a class, for a term on a day.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactEnrollmentActivity', @level2type=N'COLUMN',@level2name=N'AddCreditHours'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Sum of the Full Time Equivalents for the Adds for a student, for a class, for a term on a day.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactEnrollmentActivity', @level2type=N'COLUMN',@level2name=N'AddFullTimeEquivalent'


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


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


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Count of the number of Drops for a student, for a class, for a term on a day.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactEnrollmentActivity', @level2type=N'COLUMN',@level2name=N'Drop'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Sum of the Credit Hours for the Drops for a student, for a class, for a term on a day.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactEnrollmentActivity', @level2type=N'COLUMN',@level2name=N'DropCreditHours'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Sum of the Full Time Equivalents for the Drops for a student, for a class, for a term on a day.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactEnrollmentActivity', @level2type=N'COLUMN',@level2name=N'DropFullTimeEquivalent'


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


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


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The net effect on enrollment credit hours for Adds minus Drops for a student, for a class, for a term on a day. ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactEnrollmentActivity', @level2type=N'COLUMN',@level2name=N'NetCreditHours'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The net effect on Full Time Equivalents for Adds minus Drops for a student, for a class, for a term on a day.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactEnrollmentActivity', @level2type=N'COLUMN',@level2name=N'NetFullTimeEquivalent'


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'FactEnrollmentActivity', @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'FactEnrollmentActivity', @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 studentterm dimension.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactEnrollmentActivity', @level2type=N'COLUMN',@level2name=N'StudentTermSK'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Unique key identifier for the term, used to reference the term dimension.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactEnrollmentActivity', @level2type=N'COLUMN',@level2name=N'TermSK'
  Sample Data
AccruedTime EarnedTime LeaveTime LongTermTime OvertimeTime PaidTime RegularTime RowIsDuplicate RowIsSelected SickPoolTime TimeAttendReportingOption TimeAttendReportingOptionCode TimeType TimeTypeAK TimeTypeCode VerifyTimeTypeSK
No No Yes No No Yes No N Y No HOURS REPORTED TO THIS TIME-TYPE WILL APPLY TO USED BALANCE USED 1.125 DAY NORMAL DUTY/SUMMER SCHEDULE/4.5 DAY WK NR45 NR45 30
No No Yes No No Yes No N Y No TIME IS NOT ALLOWED TO BE REPORTED ON A TIMESHEET NO-REPT PROFESSIONAL LEAVE PROF PROF 9
No No Yes No No Yes No N Y No HOURS REPORTED TO THIS TIME-TYPE WILL APPLY TO USED BALANCE USED MILITARY LEAVE/PAID ML ML 11
No No Yes Yes No No No N Y No TIME IS NOT ALLOWED TO BE REPORTED ON A TIMESHEET NO-REPT FAMILY MEDICAL LEAVE ACT CHARGE LWOP FMLW FMLW 36
No No Yes No No No No N Y No HOURS REPORTED TO THIS TIME-TYPE WILL APPLY TO USED BALANCE USED LEAVE WITHOUT PAY LWOP LWOP 22
No No Yes No No Yes No N Y No HOURS REPORTED TO THIS TIME-TYPE WILL APPLY TO USED BALANCE USED SUMMER HOLIDAY/PAID 1 HL, .25X HLSM HLSM 19
No No Yes No No Yes No N Y No HOURS REPORTED TO THIS TIME-TYPE WILL APPLY TO USED BALANCE USED FAMILY MEDICAL LEAVE ACT CHARGE TO VACATION FMVA FMVA 35
No No No No No Yes No N Y No HOURS REPORTED TO THIS TIME-TYPE WILL APPLY TO USED BALANCE USED OVERTIME PAID AS STRAIGHT TIME/< 40 HRS OTST OTST 17
No No No No Yes Yes No N Y No HOURS REPORTED TO THIS TIME-TYPE WILL APPLY TO USED BALANCE USED STRAIGHT TIME OVERTIME (LESS THAN 40 HOURS) STOT STOT 29
No No Yes No No Yes No N Y Yes HOURS REPORTED TO THIS TIME-TYPE WILL APPLY TO USED BALANCE USED SICK POOL POOL POOL 24
Powered by BI Documenter