Table - dbo.FactStudentSuccess

Property	Value
Name	FactStudentSuccess_TermSnapshot
Schema	dbo
Row Count	206978
Data Size	37640 KB
Index Size	152 KB
Create Date	1/28/2014 9:47 AM
Description	The fact will contain one row per student per term for six years for students in the Student Success Cohort. The fact captures information about academic success at the end of each term; including CUM GPA, Term GPA, degree progress, graduation progress, SOAP and enrollment status. The term measures will be captured at the end of each term, whether the student is enrolled in the term or not.

Column Name	Data Type	Allow Nulls	Row Guid	Fulltext Indexed	Identity	Default	Description / Computed Formula
CumGPA	numeric(4, 2)	False	False	False			A measure of a student's academic achievement at a college; calculated by dividing the total number of grade points received by the total number attempted. The cumulative GPA includes all the coursework across all institutions.
CumGPAHours	numeric(5, 2)	False	False	False			Sum of all the credit hours for all the classes and grade combinations that the institution has determined should be included in the calculation of the GPA.
CumGradePoints	numeric(7, 2)	False	False	False			Sum of the Credit Hours times the value of the grade for all the classes attempted by the student.
CumHoursAttempted	numeric(5, 2)	False	False	False			Sum of all the credit hours for all the classes in which the student enrolled (including withdrawals).
CumHoursEarned	numeric(5, 2)	False	False	False			Sum of all the credit hours for all the classes in which the student was successful.
DegreeBenchmark_100_Pct	int(10, 0)	False	False	False			Indication the student has completed 100 percent of the credits required to complete their program as of the end of the tracking term.
DegreeBenchmark_25_Pct	int(10, 0)	False	False	False			Indication the student has completed between 25 and 49 percent of the credits required to complete their program as of the end of the tracking term.
DegreeBenchmark_50_Pct	int(10, 0)	False	False	False			Indication the student has completed between 50 and 74 percent of the credits required to complete their program as of the end of the tracking term.
DegreeBenchmark_75_Pct	int(10, 0)	False	False	False			Indication the student has completed between 75 and 99 percent of the credits required to complete their program as of the end of the tracking term.
DegreeBenchmark_LessThan25_Pct	int(10, 0)	False	False	False			Indication the student has completed less than 25 percent of the credits required to complete their program as of the end of the tracking term.
EnrolledInTerm	int(10, 0)	False	False	False			Indication of the enrollment status of the student for the tracking term.
GPA_000_199	int(10, 0)	False	False	False			Indicates the Cumulative GPA for the student as of the tracking term is less than a 2.0.
GPA_200_249	int(10, 0)	False	False	False			Indication the Cumulative GPA for the student as of the tracking term is between 2.00 and 2.49.
GPA_250_299	int(10, 0)	False	False	False			Indication the Cumulative GPA for the student as of the tracking term is between 2.50 and 2.99.
GPA_300_349	int(10, 0)	False	False	False			Indication the Cumulative GPA for the student as of the tracking term is between 3.00 and 3.49.
GPA_350_Plus	int(10, 0)	False	False	False			Indication the Cumulative GPA for the student as of the tracking term is 3.50 or higher.
GPA_None	int(10, 0)	False	False	False			Indicates the Cumulative GPA for the student cannot be calculated as the number of hours attempted is zero.
GraduationProgress_AppliedToGraduate	int(10, 0)	False	False	False			Indication the student applied to graduated (but did not graduate) within the cohort.
GraduationProgress_Continueing	int(10, 0)	False	False	False			Indication the student is currently enrolled for the tracking term or was enrolled in the prior term.
GraduationProgress_Graduated	int(10, 0)	False	False	False			Indication the student graduated has graduated from a degree within the cohort.
GraduationProgress_NotEnrolledFor2Terms	int(10, 0)	False	False	False			Indication the student is not enrolled for the tracking term and was not enrolled for the prior term.
IsLastTermCaptured	int(10, 0)	False	False	False			This will be 1 if the Tracking Term equals the Last Term Captured; else 0. This record will then be a measure of the student's last term at the institution.
SOAP_Appeal	int(10, 0)	False	False	False			Indication the student's standards of academic progress for the tracking term has been Appealed.
SOAP_Clear	int(10, 0)	False	False	False			Indication the student has a Clear standards of academic progress for the tracking term.
SOAP_Dismissal	int(10, 0)	False	False	False			Indication the student's standards of academic progress for the tracking term is Dismissal.
SOAP_Other	int(10, 0)	False	False	False			Indication the student's standards of academic progress for the tracking term has a value other than Clear, Warning, Appeal, Suspension, Probation or Dismissal.
SOAP_Probation	int(10, 0)	False	False	False			Indication the student's standards of academic progress for the tracking term is Probation.
SOAP_Suspension	int(10, 0)	False	False	False			Indication the student's standards of academic progress for the tracking term is Suspension.
SOAP_Warning	int(10, 0)	False	False	False			Indication the student's standards of academic progress for the tracking term is Warning.
StudentObjectiveSK	int(10, 0)	False	False	False			Key identifier for the students objective at the time the Tracking Term mearsurements are taken, used to reference the student objective dimension.
StudentSK	int(10, 0)	False	False	False			Unique key identifier for the student, used to reference the student dimension.
StudentSuccess_TermSnapshotSK	int(10, 0)	False	False	False	(1 / 1)		Primary Key for the Student Success Term measures.
StudentSuccessCohortSK	int(10, 0)	False	False	False			Unique key identifier for the Student Success Cohort, used to reference the student success cohort dimension.
StudentSuccessCohortTermSK	int(10, 0)	False	False	False			Key identifier for the Term dimension, represents the original cohort term for the student.
TermGPA	numeric(4, 2)	False	False	False			A measure of a student's academic achievement at a college; calculated by dividing the total number of grade points received by the total number attempted. The term GPA includes the coursework for the tracking term.
TermGPAHours	numeric(5, 2)	False	False	False			Sum of all the credit hours for all the classes and grade combinations that the institution had determined should be included in the calculation of the GPA for the tracking term.
TermGradePoints	numeric(7, 2)	False	False	False			Sum of the Credit Hours times the value of the grade for all the classes attempted by the student for the tracking term.
TermHoursAttempted	numeric(5, 2)	False	False	False			Sum of all the credit hours for all the classes in which the student enrolled (including withdrawals) for the tracking term.
TermHoursEarned	numeric(5, 2)	False	False	False			Sum of all the credit hours for all the classes in which the student was successful for the tracking term.
TrackingTermSK	int(10, 0)	False	False	False			Key identifier for the Term dimension, represents the student success tracking term for the student.

Name

Insert

Update

Delete

Instead

Name	Clustered	Columns
PK_StudentSuccess_TermSnapshotSK	True	StudentSuccess_TermSnapshotSK

Name	Columns	Referenced Table	Referenced Columns	Checked
FK_FactStudentSuccess_TermSnapshot_DimStudent	StudentSK	DimStudent	StudentSK	True
FK_FactStudentSuccess_TermSnapshot_DimStudentObjective	StudentObjectiveSK	DimStudentObjective	StudentObjectiveSK	True
FK_FactStudentSuccess_TermSnapshot_DimStudentSuccessCohort	StudentSuccessCohortSK	DimStudentSuccessCohort	StudentSuccessCohortSK	True
FK_FactStudentSuccess_TermSnapshot_DimStudentSuccessCohortTerm	StudentSuccessCohortTermSK	DimTerm	TermSK	True
FK_FactStudentSuccess_TermSnapshot_DimTerm	TrackingTermSK	DimTerm	TermSK	True

Name

Text

Checked

Name	Type
dbo.DimStudent	Table
dbo.DimStudentObjective	Table
dbo.DimStudentSuccessCohort	Table
dbo.DimTerm	Table

Name	Type
dbo.DimStudent	TABLE
dbo.DimStudentObjective	TABLE
dbo.DimStudentSuccessCohort	TABLE
dbo.DimTerm	TABLE

Object	Property	Value
FactStudentSuccess_TermSnapshot	MS_Description	The fact will contain one row per student per term for six years for students in the Student Success Cohort. The fact captures information about academic success at the end of each term; including CUM GPA, Term GPA, degree progress, graduation progress, SOAP and enrollment status. The term measures will be captured at the end of each term, whether the student is enrolled in the term or not.
CumGPA	MS_Description	A measure of a student's academic achievement at a college; calculated by dividing the total number of grade points received by the total number attempted. The cumulative GPA includes all the coursework across all institutions.
CumGPAHours	MS_Description	Sum of all the credit hours for all the classes and grade combinations that the institution has determined should be included in the calculation of the GPA.
CumGradePoints	MS_Description	Sum of the Credit Hours times the value of the grade for all the classes attempted by the student.
CumHoursAttempted	MS_Description	Sum of all the credit hours for all the classes in which the student enrolled (including withdrawals).
CumHoursEarned	MS_Description	Sum of all the credit hours for all the classes in which the student was successful.
DegreeBenchmark_100_Pct	MS_Description	Indication the student has completed 100 percent of the credits required to complete their program as of the end of the tracking term.
DegreeBenchmark_25_Pct	MS_Description	Indication the student has completed between 25 and 49 percent of the credits required to complete their program as of the end of the tracking term.
DegreeBenchmark_50_Pct	MS_Description	Indication the student has completed between 50 and 74 percent of the credits required to complete their program as of the end of the tracking term.
DegreeBenchmark_50_Pct	MS_Descriptions	Indication the student has completed between 50 and 74 percent of the credits required to complete their program as of the end of the tracking term.
DegreeBenchmark_75_Pct	MS_Description	Indication the student has completed between 75 and 99 percent of the credits required to complete their program as of the end of the tracking term.
DegreeBenchmark_LessThan25_Pct	MS_Description	Indication the student has completed less than 25 percent of the credits required to complete their program as of the end of the tracking term.
EnrolledInTerm	MS_Description	Indication of the enrollment status of the student for the tracking term.
GPA_000_199	MS_Description	Indicates the Cumulative GPA for the student as of the tracking term is less than a 2.0.
GPA_200_249	MS_Description	Indication the Cumulative GPA for the student as of the tracking term is between 2.00 and 2.49.
GPA_250_299	MS_Description	Indication the Cumulative GPA for the student as of the tracking term is between 2.50 and 2.99.
GPA_300_349	MS_Description	Indication the Cumulative GPA for the student as of the tracking term is between 3.00 and 3.49.
GPA_350_Plus	MS_Description	Indication the Cumulative GPA for the student as of the tracking term is 3.50 or higher.
GPA_None	MS_Description	Indicates the Cumulative GPA for the student cannot be calculated as the number of hours attempted is zero.
GraduationProgress_AppliedToGraduate	MS_Description	Indication the student applied to graduated (but did not graduate) within the cohort.
GraduationProgress_Continueing	MS_Description	Indication the student is currently enrolled for the tracking term or was enrolled in the prior term.
GraduationProgress_Graduated	MS_Description	Indication the student graduated has graduated from a degree within the cohort.
GraduationProgress_NotEnrolledFor2Terms	MS_Description	Indication the student is not enrolled for the tracking term and was not enrolled for the prior term.
IsLastTermCaptured	MS_Description	This will be 1 if the Tracking Term equals the Last Term Captured; else 0. This record will then be a measure of the student's last term at the institution.
SOAP_Appeal	MS_Description	Indication the student's standards of academic progress for the tracking term has been Appealed.
SOAP_Clear	MS_Description	Indication the student has a Clear standards of academic progress for the tracking term.
SOAP_Dismissal	MS_Description	Indication the student's standards of academic progress for the tracking term is Dismissal.
SOAP_Other	MS_Description	Indication the student's standards of academic progress for the tracking term has a value other than Clear, Warning, Appeal, Suspension, Probation or Dismissal.
SOAP_Probation	MS_Description	Indication the student's standards of academic progress for the tracking term is Probation.
SOAP_Suspension	MS_Description	Indication the student's standards of academic progress for the tracking term is Suspension.
SOAP_Warning	MS_Description	Indication the student's standards of academic progress for the tracking term is Warning.
StudentObjectiveSK	MS_Description	Key identifier for the students objective at the time the Tracking Term mearsurements are taken, used to reference the student objective dimension.
StudentSK	MS_Description	Unique key identifier for the student, used to reference the student dimension.
StudentSuccess_TermSnapshotSK	MS_Description	Primary Key for the Student Success Term measures.
StudentSuccessCohortSK	MS_Description	Unique 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.
TermGPA	MS_Description	A measure of a student's academic achievement at a college; calculated by dividing the total number of grade points received by the total number attempted. The term GPA includes the coursework for the tracking term.
TermGPAHours	MS_Description	Sum of all the credit hours for all the classes and grade combinations that the institution had determined should be included in the calculation of the GPA for the tracking term.
TermGradePoints	MS_Description	Sum of the Credit Hours times the value of the grade for all the classes attempted by the student for the tracking term.
TermHoursAttempted	MS_Description	Sum of all the credit hours for all the classes in which the student enrolled (including withdrawals) for the tracking term.
TermHoursEarned	MS_Description	Sum of all the credit hours for all the classes in which the student was successful for the tracking term.
TrackingTermSK	MS_Description	Key identifier for the Term dimension, represents the student success tracking term for the student.

Object

Property

Value

/****** Object: Table [dbo].[FactStudentSuccess_TermSnapshot] Script Date: 03/09/2017 17:14:59 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[FactStudentSuccess_TermSnapshot](
    [StudentSuccess_TermSnapshotSK] [int] IDENTITY(1,1) NOT NULL,
    [StudentSuccessCohortSK] [int] NOT NULL,
    [StudentSuccessCohortTermSK] [int] NOT NULL,
    [StudentSK] [int] NOT NULL,
    [StudentObjectiveSK] [int] NOT NULL,
    [TrackingTermSK] [int] NOT NULL,
    [IsLastTermCaptured] [int] NOT NULL,
    [CumGPA] [numeric](4, 2) NOT NULL,
    [CumGradePoints] [numeric](7, 2) NOT NULL,
    [CumHoursEarned] [numeric](5, 2) NOT NULL,
    [CumHoursAttempted] [numeric](5, 2) NOT NULL,
    [CumGPAHours] [numeric](5, 2) NOT NULL,
    [TermGPA] [numeric](4, 2) NOT NULL,
    [TermGradePoints] [numeric](7, 2) NOT NULL,
    [TermHoursEarned] [numeric](5, 2) NOT NULL,
    [TermHoursAttempted] [numeric](5, 2) NOT NULL,
    [TermGPAHours] [numeric](5, 2) NOT NULL,
    [EnrolledInTerm] [int] NOT NULL,
    [GPA_None] [int] NOT NULL,
    [GPA_000_199] [int] NOT NULL,
    [GPA_200_249] [int] NOT NULL,
    [GPA_250_299] [int] NOT NULL,
    [GPA_300_349] [int] NOT NULL,
    [GPA_350_Plus] [int] NOT NULL,
    [DegreeBenchmark_LessThan25_Pct] [int] NOT NULL,
    [DegreeBenchmark_25_Pct] [int] NOT NULL,
    [DegreeBenchmark_50_Pct] [int] NOT NULL,
    [DegreeBenchmark_75_Pct] [int] NOT NULL,
    [DegreeBenchmark_100_Pct] [int] NOT NULL,
    [SOAP_Clear] [int] NOT NULL,
    [SOAP_Warning] [int] NOT NULL,
    [SOAP_Appeal] [int] NOT NULL,
    [SOAP_Suspension] [int] NOT NULL,
    [SOAP_Probation] [int] NOT NULL,
    [SOAP_Dismissal] [int] NOT NULL,
    [SOAP_Other] [int] NOT NULL,
    [GraduationProgress_NotEnrolledFor2Terms] [int] NOT NULL,
    [GraduationProgress_Continueing] [int] NOT NULL,
    [GraduationProgress_AppliedToGraduate] [int] NOT NULL,
    [GraduationProgress_Graduated] [int] NOT NULL,
CONSTRAINT [PK_StudentSuccess_TermSnapshotSK] PRIMARY KEY CLUSTERED
(
    [StudentSuccess_TermSnapshotSK] 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_TermSnapshot]  WITH CHECK ADD  CONSTRAINT [FK_FactStudentSuccess_TermSnapshot_DimStudent] FOREIGN KEY([StudentSK])
REFERENCES [DimStudent] ([StudentSK])
ALTER TABLE [dbo].[FactStudentSuccess_TermSnapshot] CHECK CONSTRAINT [FK_FactStudentSuccess_TermSnapshot_DimStudent]
ALTER TABLE [dbo].[FactStudentSuccess_TermSnapshot]  WITH CHECK ADD  CONSTRAINT [FK_FactStudentSuccess_TermSnapshot_DimStudentObjective] FOREIGN KEY([StudentObjectiveSK])
REFERENCES [DimStudentObjective] ([StudentObjectiveSK])
ALTER TABLE [dbo].[FactStudentSuccess_TermSnapshot] CHECK CONSTRAINT [FK_FactStudentSuccess_TermSnapshot_DimStudentObjective]
ALTER TABLE [dbo].[FactStudentSuccess_TermSnapshot]  WITH CHECK ADD  CONSTRAINT [FK_FactStudentSuccess_TermSnapshot_DimStudentSuccessCohort] FOREIGN KEY([StudentSuccessCohortSK])
REFERENCES [DimStudentSuccessCohort] ([StudentSuccessCohortSK])
ALTER TABLE [dbo].[FactStudentSuccess_TermSnapshot] CHECK CONSTRAINT [FK_FactStudentSuccess_TermSnapshot_DimStudentSuccessCohort]
ALTER TABLE [dbo].[FactStudentSuccess_TermSnapshot]  WITH CHECK ADD  CONSTRAINT [FK_FactStudentSuccess_TermSnapshot_DimStudentSuccessCohortTerm] FOREIGN KEY([StudentSuccessCohortTermSK])
REFERENCES [DimTerm] ([TermSK])
ALTER TABLE [dbo].[FactStudentSuccess_TermSnapshot] CHECK CONSTRAINT [FK_FactStudentSuccess_TermSnapshot_DimStudentSuccessCohortTerm]
ALTER TABLE [dbo].[FactStudentSuccess_TermSnapshot]  WITH CHECK ADD  CONSTRAINT [FK_FactStudentSuccess_TermSnapshot_DimTerm] FOREIGN KEY([TrackingTermSK])
REFERENCES [DimTerm] ([TermSK])
ALTER TABLE [dbo].[FactStudentSuccess_TermSnapshot] CHECK CONSTRAINT [FK_FactStudentSuccess_TermSnapshot_DimTerm]

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The fact will contain one row per student per term for six years for students in the Student Success Cohort. The fact captures information about academic success at the end of each term; including CUM GPA, Term GPA, degree progress, graduation progress, SOAP and enrollment status. The term measures will be captured at the end of each term, whether the student is enrolled in the term or not. ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentSuccess_TermSnapshot'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'A measure of a student''s academic achievement at a college; calculated by dividing the total number of grade points received by the total number attempted. The cumulative GPA includes all the coursework across all institutions.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentSuccess_TermSnapshot', @level2type=N'COLUMN',@level2name=N'CumGPA'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Sum of all the credit hours for all the classes and grade combinations that the institution has determined should be included in the calculation of the GPA.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentSuccess_TermSnapshot', @level2type=N'COLUMN',@level2name=N'CumGPAHours'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Sum of the Credit Hours times the value of the grade for all the classes attempted by the student.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentSuccess_TermSnapshot', @level2type=N'COLUMN',@level2name=N'CumGradePoints'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Sum of all the credit hours for all the classes in which the student enrolled (including withdrawals).' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentSuccess_TermSnapshot', @level2type=N'COLUMN',@level2name=N'CumHoursAttempted'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Sum of all the credit hours for all the classes in which the student was successful.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentSuccess_TermSnapshot', @level2type=N'COLUMN',@level2name=N'CumHoursEarned'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Indication the student has completed 100 percent of the credits required to complete their program as of the end of the tracking term.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentSuccess_TermSnapshot', @level2type=N'COLUMN',@level2name=N'DegreeBenchmark_100_Pct'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Indication the student has completed between 25 and 49 percent of the credits required to complete their program as of the end of the tracking term.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentSuccess_TermSnapshot', @level2type=N'COLUMN',@level2name=N'DegreeBenchmark_25_Pct'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Indication the student has completed between 50 and 74 percent of the credits required to complete their program as of the end of the tracking term.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentSuccess_TermSnapshot', @level2type=N'COLUMN',@level2name=N'DegreeBenchmark_50_Pct'

EXEC sys.sp_addextendedproperty @name=N'MS_Descriptions', @value=N'Indication the student has completed between 50 and 74 percent of the credits required to complete their program as of the end of the tracking term.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentSuccess_TermSnapshot', @level2type=N'COLUMN',@level2name=N'DegreeBenchmark_50_Pct'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Indication the student has completed between 75 and 99 percent of the credits required to complete their program as of the end of the tracking term.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentSuccess_TermSnapshot', @level2type=N'COLUMN',@level2name=N'DegreeBenchmark_75_Pct'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Indication the student has completed less than 25 percent of the credits required to complete their program as of the end of the tracking term.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentSuccess_TermSnapshot', @level2type=N'COLUMN',@level2name=N'DegreeBenchmark_LessThan25_Pct'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Indication of the enrollment status of the student for the tracking term.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentSuccess_TermSnapshot', @level2type=N'COLUMN',@level2name=N'EnrolledInTerm'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Indicates the Cumulative GPA for the student as of the tracking term is less than a 2.0.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentSuccess_TermSnapshot', @level2type=N'COLUMN',@level2name=N'GPA_000_199'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Indication the Cumulative GPA for the student as of the tracking term is between 2.00 and 2.49.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentSuccess_TermSnapshot', @level2type=N'COLUMN',@level2name=N'GPA_200_249'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Indication the Cumulative GPA for the student as of the tracking term is between 2.50 and 2.99.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentSuccess_TermSnapshot', @level2type=N'COLUMN',@level2name=N'GPA_250_299'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Indication the Cumulative GPA for the student as of the tracking term is between 3.00 and 3.49.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentSuccess_TermSnapshot', @level2type=N'COLUMN',@level2name=N'GPA_300_349'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Indication the Cumulative GPA for the student as of the tracking term is 3.50 or higher.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentSuccess_TermSnapshot', @level2type=N'COLUMN',@level2name=N'GPA_350_Plus'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Indicates the Cumulative GPA for the student cannot be calculated as the number of hours attempted is zero.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentSuccess_TermSnapshot', @level2type=N'COLUMN',@level2name=N'GPA_None'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Indication the student applied to graduated (but did not graduate) within the cohort.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentSuccess_TermSnapshot', @level2type=N'COLUMN',@level2name=N'GraduationProgress_AppliedToGraduate'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Indication the student is currently enrolled for the tracking term or was enrolled in the prior term.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentSuccess_TermSnapshot', @level2type=N'COLUMN',@level2name=N'GraduationProgress_Continueing'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Indication the student graduated has graduated from a degree within the cohort.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentSuccess_TermSnapshot', @level2type=N'COLUMN',@level2name=N'GraduationProgress_Graduated'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Indication the student is not enrolled for the tracking term and was not enrolled for the prior term.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentSuccess_TermSnapshot', @level2type=N'COLUMN',@level2name=N'GraduationProgress_NotEnrolledFor2Terms'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'This will be 1 if the Tracking Term equals the Last Term Captured; else 0. This record will then be a measure of the student''s last term at the institution.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentSuccess_TermSnapshot', @level2type=N'COLUMN',@level2name=N'IsLastTermCaptured'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Indication the student''s standards of academic progress for the tracking term has been Appealed.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentSuccess_TermSnapshot', @level2type=N'COLUMN',@level2name=N'SOAP_Appeal'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Indication the student has a Clear standards of academic progress for the tracking term.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentSuccess_TermSnapshot', @level2type=N'COLUMN',@level2name=N'SOAP_Clear'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Indication the student''s standards of academic progress for the tracking term is Dismissal.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentSuccess_TermSnapshot', @level2type=N'COLUMN',@level2name=N'SOAP_Dismissal'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Indication the student''s standards of academic progress for the tracking term has a value other than Clear, Warning, Appeal, Suspension, Probation or Dismissal.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentSuccess_TermSnapshot', @level2type=N'COLUMN',@level2name=N'SOAP_Other'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Indication the student''s standards of academic progress for the tracking term is Probation.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentSuccess_TermSnapshot', @level2type=N'COLUMN',@level2name=N'SOAP_Probation'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Indication the student''s standards of academic progress for the tracking term is Suspension.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentSuccess_TermSnapshot', @level2type=N'COLUMN',@level2name=N'SOAP_Suspension'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Indication the student''s standards of academic progress for the tracking term is Warning.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentSuccess_TermSnapshot', @level2type=N'COLUMN',@level2name=N'SOAP_Warning'

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

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

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

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Unique 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_TermSnapshot', @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_TermSnapshot', @level2type=N'COLUMN',@level2name=N'StudentSuccessCohortTermSK'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'A measure of a student''s academic achievement at a college; calculated by dividing the total number of grade points received by the total number attempted. The term GPA includes the coursework for the tracking term.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentSuccess_TermSnapshot', @level2type=N'COLUMN',@level2name=N'TermGPA'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Sum of all the credit hours for all the classes and grade combinations that the institution had determined should be included in the calculation of the GPA for the tracking term.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentSuccess_TermSnapshot', @level2type=N'COLUMN',@level2name=N'TermGPAHours'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Sum of the Credit Hours times the value of the grade for all the classes attempted by the student for the tracking term.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentSuccess_TermSnapshot', @level2type=N'COLUMN',@level2name=N'TermGradePoints'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Sum of all the credit hours for all the classes in which the student enrolled (including withdrawals) for the tracking term.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentSuccess_TermSnapshot', @level2type=N'COLUMN',@level2name=N'TermHoursAttempted'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Sum of all the credit hours for all the classes in which the student was successful for the tracking term.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentSuccess_TermSnapshot', @level2type=N'COLUMN',@level2name=N'TermHoursEarned'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Key identifier for the Term dimension, represents the student success tracking term for the student.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentSuccess_TermSnapshot', @level2type=N'COLUMN',@level2name=N'TrackingTermSK'

CumGPA	CumGPAHours	CumGradePoints	CumHoursAttempted	CumHoursEarned	DegreeBenchmark_100_Pct	DegreeBenchmark_25_Pct	DegreeBenchmark_50_Pct	DegreeBenchmark_75_Pct	DegreeBenchmark_LessThan25_Pct	EnrolledInTerm	GPA_000_199	GPA_200_249	GPA_250_299	GPA_300_349	GPA_350_Plus	GPA_None	GraduationProgress_AppliedToGraduate	GraduationProgress_Continueing	GraduationProgress_Graduated	GraduationProgress_NotEnrolledFor2Terms	IsLastTermCaptured	SOAP_Appeal	SOAP_Clear	SOAP_Dismissal	SOAP_Other	SOAP_Probation	SOAP_Suspension	SOAP_Warning	StudentObjectiveSK	StudentSK	StudentSuccess_TermSnapshotSK	StudentSuccessCohortSK	StudentSuccessCohortTermSK	TermGPA	TermGPAHours	TermGradePoints	TermHoursAttempted	TermHoursEarned	TrackingTermSK
2.98	62.00	185.00	65.00	62.00	1	0	0	0	0	1	0	0	1	0	0	0	0	0	1	0	0	0	1	0	0	0	0	0	4006335	23472159	164065	50520	20141	3.66	9.00	33.00	9.00	9.00	20153
3.23	26.00	84.00	29.00	26.00	0	1	0	0	0	1	0	0	0	1	0	0	0	1	0	0	0	0	1	0	0	0	0	0	4015855	23465554	167086	52074	20142	4.00	3.00	12.00	3.00	3.00	20162
3.35	34.00	114.00	49.00	34.00	0	0	1	0	0	0	0	0	0	1	0	0	0	1	0	0	0	0	1	0	0	0	0	0	3447331	23032569	78723	35299	20142	0.00	0.00	0.00	0.00	0.00	20152
3.07	41.00	126.00	52.00	41.00	0	0	1	0	0	1	0	0	0	1	0	0	0	1	0	0	0	0	1	0	0	0	0	0	2667883	23156927	86245	38466	20141	2.00	6.00	12.00	14.00	6.00	20152
3.37	48.00	162.00	61.00	48.00	0	0	0	1	0	1	0	0	0	1	0	0	0	1	0	0	0	0	1	0	0	0	0	0	3796519	23344531	138827	46462	20141	3.42	7.00	24.00	10.00	7.00	20151
3.29	61.00	201.00	61.00	61.00	1	0	0	0	0	0	0	0	0	1	0	0	0	0	1	0	0	0	1	0	0	0	0	0	3064134	22768435	35034	30693	20141	0.00	0.00	0.00	0.00	0.00	20162
1.50	6.00	9.00	6.00	6.00	0	0	0	0	1	1	1	0	0	0	0	0	0	1	0	0	0	0	1	0	0	0	0	0	3398601	23027257	74407	40134	20141	1.50	6.00	9.00	6.00	6.00	20141
2.81	64.00	180.00	67.00	60.00	0	0	0	1	0	1	0	0	1	0	0	0	0	1	0	0	1	0	1	0	0	0	0	0	3166676	23194130	108634	40492	20152	3.12	16.00	50.00	16.00	16.00	20171
0.00	3.00	0.00	3.00	0.00	0	0	0	0	1	0	1	0	0	0	0	0	0	1	0	0	0	0	0	0	0	1	0	0	2920154	22823290	27315	28491	20141	0.00	0.00	0.00	0.00	0.00	20143
3.72	22.00	82.00	22.00	22.00	0	1	0	0	0	1	0	0	0	0	1	0	0	1	0	0	0	0	1	0	0	0	0	0	4143847	23542901	186432	54801	20161	3.50	12.00	42.00	12.00	12.00	20162