EnterpriseDW
 dbo.FactStudentGrades (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.FactStudentGrades
  Properties
Property Value
Name FactStudentGrades
Schema dbo
Row Count 3446585
Data Size 424200 KB
Index Size 1584 KB
Create Date 8/28/2013 9:53 AM
Description The fact will contain one row per student per class that has received a grade and has been loaded into academic history. The population will be limited to the rows on the ST_ACDMC_HIST_A where the REF_NUM field is not NULL. On a full load all the academic history that meets the condition will be selected. On an incremental load only the rows on the table where the REF_NUM is not NULL and the RowUpdatedOn is within the incremental load dates will be processed.
  Columns
 
 
Column Name
Data Type
Allow Nulls
Row Guid
Fulltext Indexed
Identity
Default
Description / Computed Formula
Attempt1
int(10, 0)
False
False
False
 
Student(s) first attempt for a course.
Attempt2
int(10, 0)
False
False
False
 
Student(s) second attempt for a course.
Attempt2OrMore
int(10, 0)
False
False
False
 
Student(s) second or more attempt for a course.
Attempt3OrMore
int(10, 0)
False
False
False
 
Student9s) third or more attempt for a course.
Foreign Key
CurriculumSK
int(10, 0)
False
False
False
 
Key to Curriculum dimension
Foreign Key
FTEClassificationSK
int(10, 0)
False
False
False
 
Key to the FTEClassification dimension
GradeA
int(10, 0)
False
False
False
 
Student(s) received an A grade in the class.
GradeB
int(10, 0)
False
False
False
 
Student(s) received a B grade in the class.
GradeByLetterOther
int(10, 0)
False
False
False
 
Student(s) receiving a grade in the class other than an A, B, C, D, F, W, S, P, N, U, S or I.
GradeC
int(10, 0)
False
False
False
 
Student(s) recived a C grade in the class.
GradeD
int(10, 0)
False
False
False
 
Student(s) received a D grade in the class.
GradeF
int(10, 0)
False
False
False
 
Student(s) received an F grade in the class.
GradeFail
int(10, 0)
False
False
False
 
Student(s) received a Failure grade in the class.
GradeI
int(10, 0)
False
False
False
 
Student(s) received an I grade in the class.
GradeMarginal
int(10, 0)
False
False
False
 
Student(s) received a Marginal grade in the class.
GradeN
int(10, 0)
False
False
False
 
Student(s) received an N grade in the class.
GradeOther
int(10, 0)
False
False
False
 
Student(s) receivd a grade other than a successful, marginal or failure and did not withdraw from the class.
GradeP
int(10, 0)
False
False
False
 
Student(s) received an P grade in the class.
GradeS
int(10, 0)
False
False
False
 
Student(s) received an S grade in the class.
GradeSuccess
int(10, 0)
False
False
False
 
Student(s) received a Successful grade in the class.
GradeU
int(10, 0)
False
False
False
 
Student(s) received an U grade in the class.
GradeW
int(10, 0)
False
False
False
 
Student(s) was withdrawn from the class.
GradeWithdrawal
int(10, 0)
False
False
False
 
Student(s) was withdrawn from the class.
GradeX
int(10, 0)
False
False
False
 
Student(s) received an X grade in the class.
In Primary Key
StudentGradesSK
int(10, 0)
False
False
False
(1 / 1)
Primary Key for the FactStudentGrades.
Foreign Key
StudentSK
int(10, 0)
False
False
False
 
Key to the Student dimension
Foreign Key
StudentTermSK
int(10, 0)
False
False
False
 
Key to the Student Term dimension
Foreign Key
TermSK
int(10, 0)
False
False
False
 
Key to the Term dimension
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
True
StudentGradesSK
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
CurriculumSK
DimCurriculum
CurriculumSK
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.FactStudentGrades depends on)
Name Type
Table
Table
Table
Table
Table
  Child Dependencies (objects that depend on dbo.FactStudentGrades)
Name Type
TABLE
TABLE
TABLE
TABLE
TABLE
  Extended Properties
Object Property Value
FactStudentGrades
MS_Description
The fact will contain one row per student per class that has received a grade and has been loaded into academic history. The population will be limited to the rows on the ST_ACDMC_HIST_A where the REF_NUM field is not NULL. On a full load all the academic history that meets the condition will be selected. On an incremental load only the rows on the table where the REF_NUM is not NULL and the RowUpdatedOn is within the incremental load dates will be processed.
Attempt1
MS_Description
Student(s) first attempt for a course.
Attempt2
MS_Description
Student(s) second attempt for a course.
Attempt2OrMore
MS_Description
Student(s) second or more attempt for a course.
Attempt3OrMore
MS_Description
Student9s) third or more attempt for a course.
CurriculumSK
MS_Description
Key to Curriculum dimension
FTEClassificationSK
MS_Description
Key to the FTEClassification dimension
GradeA
MS_Description
Student(s) received an A grade in the class.
GradeB
MS_Description
Student(s) received a B grade in the class.
GradeByLetterOther
MS_Description
Student(s) receiving a grade in the class other than an A, B, C, D, F, W, S, P, N, U, S or I.
GradeC
MS_Description
Student(s) recived a C grade in the class.
GradeD
MS_Description
Student(s) received a D grade in the class.
GradeF
MS_Description
Student(s) received an F grade in the class.
GradeFail
MS_Description
Student(s) received a Failure grade in the class.
GradeI
MS_Description
Student(s) received an I grade in the class.
GradeMarginal
MS_Description
Student(s) received a Marginal grade in the class.
GradeN
MS_Description
Student(s) received an N grade in the class.
GradeOther
MS_Description
Student(s) receivd a grade other than a successful, marginal or failure and did not withdraw from the class.
GradeP
MS_Description
Student(s) received an P grade in the class.
GradeS
MS_Description
Student(s) received an S grade in the class.
GradeSuccess
MS_Description
Student(s) received a Successful grade in the class.
GradeU
MS_Description
Student(s) received an U grade in the class.
GradeW
MS_Description
Student(s) was withdrawn from the class.
GradeWithdrawal
MS_Description
Student(s) was withdrawn from the class.
GradeX
MS_Description
Student(s) received an X grade in the class.
StudentGradesSK
MS_Description
Primary Key for the FactStudentGrades.
StudentSK
MS_Description
Key to the Student dimension
StudentTermSK
MS_Description
Key to the Student Term dimension
TermSK
MS_Description
Key to the Term dimension
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[FactStudentGrades] Script Date: 03/09/2017 17:14:59 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[FactStudentGrades](
    [StudentGradesSK] [int] IDENTITY(1,1) NOT NULL,
    [TermSK] [int] NOT NULL,
    [CurriculumSK] [int] NOT NULL,
    [StudentSK] [int] NOT NULL,
    [StudentTermSK] [int] NOT NULL,
    [FTEClassificationSK] [int] NOT NULL,
    [GradeSuccess] [int] NOT NULL,
    [GradeMarginal] [int] NOT NULL,
    [GradeFail] [int] NOT NULL,
    [GradeWithdrawal] [int] NOT NULL,
    [GradeOther] [int] NOT NULL,
    [GradeA] [int] NOT NULL,
    [GradeB] [int] NOT NULL,
    [GradeC] [int] NOT NULL,
    [GradeD] [int] NOT NULL,
    [GradeF] [int] NOT NULL,
    [GradeW] [int] NOT NULL,
    [GradeS] [int] NOT NULL,
    [GradeP] [int] NOT NULL,
    [GradeU] [int] NOT NULL,
    [GradeN] [int] NOT NULL,
    [GradeX] [int] NOT NULL,
    [GradeI] [int] NOT NULL,
    [GradeByLetterOther] [int] NOT NULL,
    [Attempt1] [int] NOT NULL,
    [Attempt2] [int] NOT NULL,
    [Attempt2OrMore] [int] NOT NULL,
    [Attempt3OrMore] [int] NOT NULL,
 CONSTRAINT [PK_FactStudentGrades] PRIMARY KEY CLUSTERED 
(
    [StudentGradesSK] 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].[FactStudentGrades]  WITH CHECK ADD  CONSTRAINT [FK_FactStudentGrades_DimCurriculum] FOREIGN KEY([CurriculumSK])
REFERENCES [DimCurriculum] ([CurriculumSK])
ALTER TABLE [dbo].[FactStudentGrades] CHECK CONSTRAINT [FK_FactStudentGrades_DimCurriculum]
ALTER TABLE [dbo].[FactStudentGrades]  WITH CHECK ADD  CONSTRAINT [FK_FactStudentGrades_DimFTEClassification] FOREIGN KEY([FTEClassificationSK])
REFERENCES [DimFTEClassification] ([FTEClassificationSK])
ALTER TABLE [dbo].[FactStudentGrades] CHECK CONSTRAINT [FK_FactStudentGrades_DimFTEClassification]
ALTER TABLE [dbo].[FactStudentGrades]  WITH CHECK ADD  CONSTRAINT [FK_FactStudentGrades_DimStudent] FOREIGN KEY([StudentSK])
REFERENCES [DimStudent] ([StudentSK])
ALTER TABLE [dbo].[FactStudentGrades] CHECK CONSTRAINT [FK_FactStudentGrades_DimStudent]
ALTER TABLE [dbo].[FactStudentGrades]  WITH CHECK ADD  CONSTRAINT [FK_FactStudentGrades_DimStudentTerm] FOREIGN KEY([StudentTermSK])
REFERENCES [DimStudentTerm] ([StudentTermSK])
ALTER TABLE [dbo].[FactStudentGrades] CHECK CONSTRAINT [FK_FactStudentGrades_DimStudentTerm]
ALTER TABLE [dbo].[FactStudentGrades]  WITH CHECK ADD  CONSTRAINT [FK_FactStudentGrades_DimTerm] FOREIGN KEY([TermSK])
REFERENCES [DimTerm] ([TermSK])
ALTER TABLE [dbo].[FactStudentGrades] CHECK CONSTRAINT [FK_FactStudentGrades_DimTerm]


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The fact will contain one row per student per class that has received a grade and has been loaded into academic history. The population will be limited to the rows on the ST_ACDMC_HIST_A where the REF_NUM field is not NULL. On a full load all the academic history that meets the condition will be selected. On an incremental load only the rows on the table where the REF_NUM is not NULL and the RowUpdatedOn is within the incremental load dates will be processed. ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentGrades'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Student(s) first attempt for a course.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentGrades', @level2type=N'COLUMN',@level2name=N'Attempt1'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Student(s) second attempt for a course.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentGrades', @level2type=N'COLUMN',@level2name=N'Attempt2'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Student(s) second or more attempt for a course.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentGrades', @level2type=N'COLUMN',@level2name=N'Attempt2OrMore'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Student9s) third or more attempt for a course.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentGrades', @level2type=N'COLUMN',@level2name=N'Attempt3OrMore'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Key to Curriculum dimension' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentGrades', @level2type=N'COLUMN',@level2name=N'CurriculumSK'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Key to the FTEClassification dimension' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentGrades', @level2type=N'COLUMN',@level2name=N'FTEClassificationSK'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Student(s) received an A grade in the class.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentGrades', @level2type=N'COLUMN',@level2name=N'GradeA'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Student(s) received a B grade in the class.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentGrades', @level2type=N'COLUMN',@level2name=N'GradeB'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Student(s) receiving a grade in the class other than an A, B, C, D, F, W, S, P, N, U, S or I.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentGrades', @level2type=N'COLUMN',@level2name=N'GradeByLetterOther'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Student(s) recived a C grade in the class.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentGrades', @level2type=N'COLUMN',@level2name=N'GradeC'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Student(s) received a D grade in the class.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentGrades', @level2type=N'COLUMN',@level2name=N'GradeD'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Student(s) received an F grade in the class.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentGrades', @level2type=N'COLUMN',@level2name=N'GradeF'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Student(s) received a Failure grade in the class.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentGrades', @level2type=N'COLUMN',@level2name=N'GradeFail'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Student(s) received an I grade in the class.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentGrades', @level2type=N'COLUMN',@level2name=N'GradeI'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Student(s) received a Marginal grade in the class.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentGrades', @level2type=N'COLUMN',@level2name=N'GradeMarginal'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Student(s) received an N grade in the class.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentGrades', @level2type=N'COLUMN',@level2name=N'GradeN'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Student(s) receivd a grade other than a successful, marginal or failure and did not withdraw from the class.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentGrades', @level2type=N'COLUMN',@level2name=N'GradeOther'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Student(s) received an P grade in the class.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentGrades', @level2type=N'COLUMN',@level2name=N'GradeP'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Student(s) received an S grade in the class.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentGrades', @level2type=N'COLUMN',@level2name=N'GradeS'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Student(s) received a Successful grade in the class.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentGrades', @level2type=N'COLUMN',@level2name=N'GradeSuccess'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Student(s) received an U grade in the class.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentGrades', @level2type=N'COLUMN',@level2name=N'GradeU'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Student(s) was withdrawn from the class.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentGrades', @level2type=N'COLUMN',@level2name=N'GradeW'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Student(s) was withdrawn from the class.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentGrades', @level2type=N'COLUMN',@level2name=N'GradeWithdrawal'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Student(s) received an X grade in the class.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentGrades', @level2type=N'COLUMN',@level2name=N'GradeX'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Primary Key for the FactStudentGrades.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentGrades', @level2type=N'COLUMN',@level2name=N'StudentGradesSK'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Key to the Student dimension' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentGrades', @level2type=N'COLUMN',@level2name=N'StudentSK'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Key to the Student Term dimension' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentGrades', @level2type=N'COLUMN',@level2name=N'StudentTermSK'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Key to the Term dimension' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentGrades', @level2type=N'COLUMN',@level2name=N'TermSK'
  Sample Data
Attempt1 Attempt2 Attempt2OrMore Attempt3OrMore CurriculumSK FTEClassificationSK GradeA GradeB GradeByLetterOther GradeC GradeD GradeF GradeFail GradeI GradeMarginal GradeN GradeOther GradeP GradeS GradeSuccess GradeU GradeW GradeWithdrawal GradeX StudentGradesSK StudentSK StudentTermSK TermSK
1 0 0 0 5459459 5 0 0 0 0 0 1 1 0 0 0 0 0 0 0 0 0 0 0 652287 22799225 50690087 20111
1 0 0 0 5405715 5 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 0 1544008 23136265 52010671 20073
1 0 0 0 5380579 5 1 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 1458799 23113858 51900662 20051
1 0 0 0 5477368 5 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 0 1872975 23194942 52460132 20131
1 0 0 0 5497745 3 1 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 1343967 23063043 51711494 20151
1 0 0 0 5439938 5 0 0 0 0 0 1 1 0 0 0 0 0 0 0 0 0 0 0 3008608 23516142 54139142 20102
1 0 0 0 5355417 5 0 0 0 0 0 0 1 0 0 0 0 0 0 0 1 0 0 0 1963975 23224493 52588185 20022
1 0 0 0 5435890 5 0 0 1 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 113680 22745981 49939288 20093
1 0 0 0 5523578 5 0 1 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 171579 22753707 50009543 20171
1 0 0 0 5433008 5 0 1 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 1547646 23133182 52016055 20101
Powered by BI Documenter