|
|
|||||
|
|
|||||
Properties
| Property | Value |
| Name | FactStudentGraduation |
| Schema | dbo |
| Row Count | 129378 |
| Data Size | 4864 KB |
| Index Size | 16 KB |
| Create Date | 8/28/2013 9:53 AM |
| Description | The fact will contain one row per student objective that has been graduated. The population will be limited to the rows on the ST_STDNT_OBJ_AWD_A where the ACT_GRAD_TRM field is not NULL. This will be emptied and reloaded each time, there will be no incremental load. |
Columns
Column Name |
Data Type |
Allow Nulls |
Row Guid |
Fulltext Indexed |
Identity |
Default |
Description / Computed Formula |
||
 |
 |
GraduationTermSK |
int(10, 0) |
False |
False |
False |
Key to the Term dimension |
||
|
|
NumTermsToGraduate |
int(10, 0) |
False |
False |
False |
The number of terms the student was enrolled at the institution up to and including the actual graduation term of the objective. |
||
|
|
ProgramGpa |
numeric(9, 2) |
False |
False |
False |
The program GPA the student received when they graduated from the program objective. |
||
 |
|
StudentGraduationSK |
int(10, 0) |
False |
False |
False |
(1 / 1) |
Primary Key for the FactStudentGraduation. |
|
|
|
StudentObjectiveSK |
int(10, 0) |
False |
False |
False |
Key to Student Objective dimension |
||
|
|
StudentSK |
int(10, 0) |
False |
False |
False |
Key to the Student dimension |
||
|
|
StudentTermSK |
int(10, 0) |
False |
False |
False |
Key to the Student Term dimension |
Triggers
| Name | Insert | Update | Delete | Instead |
Indexes
| Name | Clustered | Columns |
True |
StudentGraduationSK |
Foreign Key Constraints
| Name | Columns | Referenced Table | Referenced Columns | Checked |
StudentSK |
DimStudent |
StudentSK |
True |
|
StudentObjectiveSK |
DimStudentObjective |
StudentObjectiveSK |
True |
|
StudentTermSK |
DimStudentTerm |
StudentTermSK |
True |
|
GraduationTermSK |
DimTerm |
TermSK |
True |
Check Constraints
| Name | Text | Checked |
Parent Dependencies (objects that dbo.FactStudentGraduation depends on)
| Name | Type |
Table |
|
Table |
|
Table |
|
Table |
Child Dependencies (objects that depend on dbo.FactStudentGraduation)
| Name | Type |
TABLE |
|
TABLE |
|
TABLE |
|
TABLE |
Extended Properties
| Object | Property | Value |
FactStudentGraduation |
MS_Description |
The fact will contain one row per student objective that has been graduated. The population will be limited to the rows on the ST_STDNT_OBJ_AWD_A where the ACT_GRAD_TRM field is not NULL. This will be emptied and reloaded each time, there will be no incremental load. |
GraduationTermSK |
MS_Description |
Key to the Term dimension |
NumTermsToGraduate |
MS_Description |
The number of terms the student was enrolled at the institution up to and including the actual graduation term of the objective. |
ProgramGpa |
MS_Description |
The program GPA the student received when they graduated from the program objective. |
StudentGraduationSK |
MS_Description |
Primary Key for the FactStudentGraduation. |
StudentObjectiveSK |
MS_Description |
Key to Student Objective dimension |
StudentSK |
MS_Description |
Key to the Student dimension |
StudentTermSK |
MS_Description |
Key to the Student Term dimension |
Annotations
| Object | Property | Value |
DDL
|
/****** Object: Table [dbo].[FactStudentGraduation] Script Date: 03/09/2017 17:14:59 ******/ SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [dbo].[FactStudentGraduation]( [StudentGraduationSK] [int] IDENTITY(1,1) NOT NULL, [StudentObjectiveSK] [int] NOT NULL, [GraduationTermSK] [int] NOT NULL, [StudentSK] [int] NOT NULL, [StudentTermSK] [int] NOT NULL, [NumTermsToGraduate] [int] NOT NULL, [ProgramGpa] [numeric](9, 2) NOT NULL, CONSTRAINT [PK_FactStudentGraduation] PRIMARY KEY CLUSTERED ( [StudentGraduationSK] 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].[FactStudentGraduation] WITH CHECK ADD CONSTRAINT [FK_FactStudentGraduation_DimStudent] FOREIGN KEY([StudentSK]) REFERENCES [DimStudent] ([StudentSK]) ALTER TABLE [dbo].[FactStudentGraduation] CHECK CONSTRAINT [FK_FactStudentGraduation_DimStudent] ALTER TABLE [dbo].[FactStudentGraduation] WITH CHECK ADD CONSTRAINT [FK_FactStudentGraduation_DimStudentObjective] FOREIGN KEY([StudentObjectiveSK]) REFERENCES [DimStudentObjective] ([StudentObjectiveSK]) ALTER TABLE [dbo].[FactStudentGraduation] CHECK CONSTRAINT [FK_FactStudentGraduation_DimStudentObjective] ALTER TABLE [dbo].[FactStudentGraduation] WITH CHECK ADD CONSTRAINT [FK_FactStudentGraduation_DimStudentTerm] FOREIGN KEY([StudentTermSK]) REFERENCES [DimStudentTerm] ([StudentTermSK]) ALTER TABLE [dbo].[FactStudentGraduation] CHECK CONSTRAINT [FK_FactStudentGraduation_DimStudentTerm] ALTER TABLE [dbo].[FactStudentGraduation] WITH CHECK ADD CONSTRAINT [FK_FactStudentGraduation_DimTerm] FOREIGN KEY([GraduationTermSK]) REFERENCES [DimTerm] ([TermSK]) ALTER TABLE [dbo].[FactStudentGraduation] CHECK CONSTRAINT [FK_FactStudentGraduation_DimTerm] EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The fact will contain one row per student objective that has been graduated. The population will be limited to the rows on the ST_STDNT_OBJ_AWD_A where the ACT_GRAD_TRM field is not NULL. This will be emptied and reloaded each time, there will be no incremental load.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentGraduation' 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'FactStudentGraduation', @level2type=N'COLUMN',@level2name=N'GraduationTermSK' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The number of terms the student was enrolled at the institution up to and including the actual graduation term of the objective.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentGraduation', @level2type=N'COLUMN',@level2name=N'NumTermsToGraduate' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The program GPA the student received when they graduated from the program objective.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentGraduation', @level2type=N'COLUMN',@level2name=N'ProgramGpa' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Primary Key for the FactStudentGraduation.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentGraduation', @level2type=N'COLUMN',@level2name=N'StudentGraduationSK' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Key to Student Objective dimension' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentGraduation', @level2type=N'COLUMN',@level2name=N'StudentObjectiveSK' 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'FactStudentGraduation', @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'FactStudentGraduation', @level2type=N'COLUMN',@level2name=N'StudentTermSK' |
Sample Data
| GraduationTermSK | NumTermsToGraduate | ProgramGpa | StudentGraduationSK | StudentObjectiveSK | StudentSK | StudentTermSK |
| 19921 | 8 | 0.00 | 42664 | 2928204 | 23180282 | 52320026 |
| 20123 | 6 | 2.66 | 64486 | 3195736 | 22936418 | 51044127 |
| 20161 | 6 | 3.76 | 59085 | 4129610 | 23533144 | 54282453 |
| 20142 | 9 | 3.10 | 32117 | 4166233 | 23560042 | 54380543 |
| 19722 | 4 | 0.00 | 45306 | 3380246 | 23013667 | -1 |
| 20151 | 6 | 3.10 | 33599 | 3218427 | 23200953 | 52504384 |
| 19982 | 13 | 0.00 | 55961 | 3938034 | 23436043 | 53697890 |
| 20171 | 4 | 0.00 | 21069 | 4130629 | 23539732 | 54287572 |
| 19712 | 5 | 0.00 | 28554 | 3593962 | 23105395 | -1 |
| 20121 | 6 | 3.92 | 50298 | 3285487 | 22969397 | 51222338 |
| Powered by BI Documenter |
