EnterpriseDW
 dbo.FactStudentSuccess_FirstYearSnapshot (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.FactStudentSuccess_FirstYearSnapshot
  Properties
Property Value
Name FactStudentSuccess_FirstYearSnapshot
Schema dbo
Row Count 29468
Data Size 1816 KB
Index Size 16 KB
Create Date 1/28/2014 9:47 AM
Description The fact will contain one row per student in the Student Success Cohort and will be captured at the end of the term at the one year mark for the student. The fact captures the first year success measures for the degree seeking student. The students first year measures will be captured at the end of the term, one year from the cohort term.
  Columns
 
 
Column Name
Data Type
Allow Nulls
Row Guid
Fulltext Indexed
Identity
Default
Description / Computed Formula
AttendedSummerTerm
int(10, 0)
False
False
False
 
Indication the student attended during a summer term within their first year of enrollment at the institution, while pursuing a degree.
CompletedCollegeExpCourse
int(10, 0)
False
False
False
 
Indication the student had completed the a College Experience course at the end of their first year of enrollment at the institution, while pursuing a degree.
CompletedGatewayCourse
int(10, 0)
False
False
False
 
Indication the student had completed a Gateway course at the end of their first year of enrollment at the institution, while pursuing a degree.
DidNotMeetAny1stYearSuccessFactors
int(10, 0)
False
False
False
 
Indication the student did not meet any of the first year success factors while enrolled in their first year at the institution, while pursuing a degree.
Foreign Key
FirstYearTermSK
int(10, 0)
False
False
False
 
Key identifier for the Term dimension, represents the one year term for the student for the first year measures.
Meets24CreditsRequirement
int(10, 0)
False
False
False
 
Indication the student had completed 24 or more credit hours at the end of their first year of enrollment at the institution, while pursuing a degree.
Meets67PctCompletedRequirement
int(10, 0)
False
False
False
 
Indication the student had a 67% or higher course completion rate at the end of their first year of enrollment at the institution, while pursuing a degree.
MeetsGPARequirement
int(10, 0)
False
False
False
 
Indication the student had a 2.0 or higher Cum GPA at the end of their first year of enrollment at the institution, while pursuing a degree.
Foreign Key
StudentObjectiveSK
int(10, 0)
False
False
False
 
Key identifier for the students objective at the time the First Year Term mearsurements are taken, used to reference the student objective dimension.
Foreign Key
StudentSK
int(10, 0)
False
False
False
 
Key identifier for the student, used to reference the student dimension.
In Primary Key
StudentSuccess_FirstYearSnapshotSK
int(10, 0)
False
False
False
(1 / 1)
Primary Key for the Student Success First Year measures.
Foreign Key
StudentSuccessCohortSK
int(10, 0)
False
False
False
 
Key identifier for the Student Success Cohort, used to reference the student success cohort dimension.
Foreign Key
StudentSuccessCohortTermSK
int(10, 0)
False
False
False
 
Key identifier for the Term dimension, represents the original cohort term for the student.
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
True
StudentSuccess_FirstYearSnapshotSK
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
StudentSK
DimStudent
StudentSK
True
StudentObjectiveSK
DimStudentObjective
StudentObjectiveSK
True
StudentSuccessCohortSK
DimStudentSuccessCohort
StudentSuccessCohortSK
True
StudentSuccessCohortTermSK
DimTerm
TermSK
True
FirstYearTermSK
DimTerm
TermSK
True
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.FactStudentSuccess_FirstYearSnapshot depends on)
Name Type
Table
Table
Table
Table
  Child Dependencies (objects that depend on dbo.FactStudentSuccess_FirstYearSnapshot)
Name Type
TABLE
TABLE
TABLE
TABLE
  Extended Properties
Object Property Value
FactStudentSuccess_FirstYearSnapshot
MS_Description
The fact will contain one row per student in the Student Success Cohort and will be captured at the end of the term at the one year mark for the student. The fact captures the first year success measures for the degree seeking student. The students first year measures will be captured at the end of the term, one year from the cohort term.
AttendedSummerTerm
MS_Description
Indication the student attended during a summer term within their first year of enrollment at the institution, while pursuing a degree.
CompletedCollegeExpCourse
MS_Description
Indication the student had completed the a College Experience course at the end of their first year of enrollment at the institution, while pursuing a degree.
CompletedGatewayCourse
MS_Description
Indication the student had completed a Gateway course at the end of their first year of enrollment at the institution, while pursuing a degree.
DidNotMeetAny1stYearSuccessFactors
MS_Description
Indication the student did not meet any of the first year success factors while enrolled in their first year at the institution, while pursuing a degree.
FirstYearTermSK
MS_Description
Key identifier for the Term dimension, represents the one year term for the student for the first year measures.
Meets24CreditsRequirement
MS_Description
Indication the student had completed 24 or more credit hours at the end of their first year of enrollment at the institution, while pursuing a degree.
Meets67PctCompletedRequirement
MS_Description
Indication the student had a 67% or higher course completion rate at the end of their first year of enrollment at the institution, while pursuing a degree.
MeetsGPARequirement
MS_Description
Indication the student had a 2.0 or higher Cum GPA at the end of their first year of enrollment at the institution, while pursuing a degree.
StudentObjectiveSK
MS_Description
Key identifier for the students objective at the time the First Year Term mearsurements are taken, used to reference the student objective dimension.
StudentSK
MS_Description
Key identifier for the student, used to reference the student dimension.
StudentSuccess_FirstYearSnapshotSK
MS_Description
Primary Key for the Student Success First Year measures.
StudentSuccessCohortSK
MS_Description
Key identifier for the Student Success Cohort, used to reference the student success cohort dimension.
StudentSuccessCohortTermSK
MS_Description
Key identifier for the Term dimension, represents the original cohort term for the student.
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[FactStudentSuccess_FirstYearSnapshot] Script Date: 03/09/2017 17:14:59 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[FactStudentSuccess_FirstYearSnapshot](
    [StudentSuccess_FirstYearSnapshotSK] [int] IDENTITY(1,1) NOT NULL,
    [StudentSuccessCohortSK] [int] NOT NULL,
    [StudentSuccessCohortTermSK] [int] NOT NULL,
    [StudentSK] [int] NOT NULL,
    [StudentObjectiveSK] [int] NOT NULL,
    [FirstYearTermSK] [int] NOT NULL,
    [MeetsGPARequirement] [int] NOT NULL,
    [Meets24CreditsRequirement] [int] NOT NULL,
    [Meets67PctCompletedRequirement] [int] NOT NULL,
    [CompletedCollegeExpCourse] [int] NOT NULL,
    [CompletedGatewayCourse] [int] NOT NULL,
    [AttendedSummerTerm] [int] NOT NULL,
    [DidNotMeetAny1stYearSuccessFactors] [int] NOT NULL,
 CONSTRAINT [PK_StudentSuccess_FirstYearSnapshotSK] PRIMARY KEY CLUSTERED 
(
    [StudentSuccess_FirstYearSnapshotSK] 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].[FactStudentSuccess_FirstYearSnapshot]  WITH CHECK ADD  CONSTRAINT [FK_FactStudentSuccess_FirstYearSnapshot_DimStudent] FOREIGN KEY([StudentSK])
REFERENCES [DimStudent] ([StudentSK])
ALTER TABLE [dbo].[FactStudentSuccess_FirstYearSnapshot] CHECK CONSTRAINT [FK_FactStudentSuccess_FirstYearSnapshot_DimStudent]
ALTER TABLE [dbo].[FactStudentSuccess_FirstYearSnapshot]  WITH CHECK ADD  CONSTRAINT [FK_FactStudentSuccess_FirstYearSnapshot_DimStudentObjective] FOREIGN KEY([StudentObjectiveSK])
REFERENCES [DimStudentObjective] ([StudentObjectiveSK])
ALTER TABLE [dbo].[FactStudentSuccess_FirstYearSnapshot] CHECK CONSTRAINT [FK_FactStudentSuccess_FirstYearSnapshot_DimStudentObjective]
ALTER TABLE [dbo].[FactStudentSuccess_FirstYearSnapshot]  WITH CHECK ADD  CONSTRAINT [FK_FactStudentSuccess_FirstYearSnapshot_DimStudentSuccessCohort] FOREIGN KEY([StudentSuccessCohortSK])
REFERENCES [DimStudentSuccessCohort] ([StudentSuccessCohortSK])
ALTER TABLE [dbo].[FactStudentSuccess_FirstYearSnapshot] CHECK CONSTRAINT [FK_FactStudentSuccess_FirstYearSnapshot_DimStudentSuccessCohort]
ALTER TABLE [dbo].[FactStudentSuccess_FirstYearSnapshot]  WITH CHECK ADD  CONSTRAINT [FK_FactStudentSuccess_FirstYearSnapshot_DimStudentSuccessCohortTerm] FOREIGN KEY([StudentSuccessCohortTermSK])
REFERENCES [DimTerm] ([TermSK])
ALTER TABLE [dbo].[FactStudentSuccess_FirstYearSnapshot] CHECK CONSTRAINT [FK_FactStudentSuccess_FirstYearSnapshot_DimStudentSuccessCohortTerm]
ALTER TABLE [dbo].[FactStudentSuccess_FirstYearSnapshot]  WITH CHECK ADD  CONSTRAINT [FK_FactStudentSuccess_FirstYearSnapshot_DimTerm] FOREIGN KEY([FirstYearTermSK])
REFERENCES [DimTerm] ([TermSK])
ALTER TABLE [dbo].[FactStudentSuccess_FirstYearSnapshot] CHECK CONSTRAINT [FK_FactStudentSuccess_FirstYearSnapshot_DimTerm]


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The fact will contain one row per student in the Student Success Cohort and will be captured at the end of the term at the one year mark for the student. The fact captures the first year success measures for the degree seeking student. The students first year measures will be captured at the end of the term, one year from the cohort term. ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentSuccess_FirstYearSnapshot'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Indication the student attended during a summer term within their first year of enrollment at the institution, while pursuing a degree.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentSuccess_FirstYearSnapshot', @level2type=N'COLUMN',@level2name=N'AttendedSummerTerm'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Indication the student had completed the a College Experience course at the end of their first year of enrollment at the institution, while pursuing a degree.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentSuccess_FirstYearSnapshot', @level2type=N'COLUMN',@level2name=N'CompletedCollegeExpCourse'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Indication the student had completed a Gateway course at the end of their first year of enrollment at the institution, while pursuing a degree.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentSuccess_FirstYearSnapshot', @level2type=N'COLUMN',@level2name=N'CompletedGatewayCourse'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Indication the student did not meet any of the first year success factors while enrolled in their first year at the institution, while pursuing a degree.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentSuccess_FirstYearSnapshot', @level2type=N'COLUMN',@level2name=N'DidNotMeetAny1stYearSuccessFactors'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Key identifier for the Term dimension, represents the one year term for the student for the first year measures.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentSuccess_FirstYearSnapshot', @level2type=N'COLUMN',@level2name=N'FirstYearTermSK'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Indication the student had completed 24 or more credit hours at the end of their first year of enrollment at the institution, while pursuing a degree.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentSuccess_FirstYearSnapshot', @level2type=N'COLUMN',@level2name=N'Meets24CreditsRequirement'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Indication the student had a 67% or higher course completion rate at the end of their first year of enrollment at the institution, while pursuing a degree.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentSuccess_FirstYearSnapshot', @level2type=N'COLUMN',@level2name=N'Meets67PctCompletedRequirement'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Indication the student had a 2.0 or higher Cum GPA at the end of their first year of enrollment at the institution, while pursuing a degree.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentSuccess_FirstYearSnapshot', @level2type=N'COLUMN',@level2name=N'MeetsGPARequirement'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Key identifier for the students objective at the time the First Year Term mearsurements are taken, used to reference the student objective dimension.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentSuccess_FirstYearSnapshot', @level2type=N'COLUMN',@level2name=N'StudentObjectiveSK'


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


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Primary Key for the Student Success First Year measures.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentSuccess_FirstYearSnapshot', @level2type=N'COLUMN',@level2name=N'StudentSuccess_FirstYearSnapshotSK'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Key identifier for the Student Success Cohort, used to reference the student success cohort dimension.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentSuccess_FirstYearSnapshot', @level2type=N'COLUMN',@level2name=N'StudentSuccessCohortSK'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Key identifier for the Term dimension, represents the original cohort term for the student.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentSuccess_FirstYearSnapshot', @level2type=N'COLUMN',@level2name=N'StudentSuccessCohortTermSK'
  Sample Data
AttendedSummerTerm CompletedCollegeExpCourse CompletedGatewayCourse DidNotMeetAny1stYearSuccessFactors FirstYearTermSK Meets24CreditsRequirement Meets67PctCompletedRequirement MeetsGPARequirement StudentObjectiveSK StudentSK StudentSuccess_FirstYearSnapshotSK StudentSuccessCohortSK StudentSuccessCohortTermSK
0 1 1 0 20153 0 0 0 3219759 22939210 8072 23508 20151
1 1 1 0 20161 1 1 1 3635101 23131004 11870 37266 20152
0 1 1 0 20153 1 0 1 3796232 23343049 19866 45870 20151
0 1 1 0 20153 0 0 0 3058718 22787900 4835 31046 20151
0 1 1 0 20153 0 0 0 3804564 23347877 20278 49276 20151
1 0 1 0 20153 1 0 1 3857655 23373221 21864 50610 20151
1 1 1 0 20163 0 0 1 2761548 23165708 14570 39261 20161
0 1 0 0 20153 0 1 1 3310806 22983317 9305 22805 20151
0 0 1 0 20163 0 1 1 4011128 23469787 23764 52171 20161
0 1 1 0 20163 0 0 1 3177012 22925977 6909 33706 20161
Powered by BI Documenter