EnterpriseDW
 dbo.FactStudentFeesPaid (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.FactStudentFeesPaid
  Properties
Property Value
Name FactStudentFeesPaid
Schema dbo
Row Count 20138181
Data Size 927160 KB
Index Size 643352 KB
Create Date 1/28/2014 9:47 AM
Description
  Columns
 
 
Column Name
Data Type
Allow Nulls
Row Guid
Fulltext Indexed
Identity
Default
Description / Computed Formula
Foreign Key
CurriculumSK
int(10, 0)
False
False
False
 
Key identifier for the Curriculum, used to reference the Class dimenstion.
FeePaidAmount
numeric(11, 2)
True
False
False
 
The amount of a class or registration fee which have been 'paid'.
Foreign Key
FeeTypeSK
int(10, 0)
False
False
False
 
Key identifier for the student term, used to reference the fee type dimension.
Foreign Key
PaymentSourceSK
int(10, 0)
False
False
False
 
Key identifier for the payment source category for the student for a class. Will identify how to aggregate the student for paym
In Primary Key
StudentPaidFeesSK
int(10, 0)
False
False
False
(1 / 1)
Primary Key to the Fact.
Foreign Key
StudentSK
int(10, 0)
False
False
False
 
Key identifier for the student, used to reference the student dimension.
Foreign Key
StudentTermSK
int(10, 0)
False
False
False
 
Key identifier for the student term, used to reference the student term dimension.
Foreign Key
TermSK
int(10, 0)
False
False
False
 
Key identifier for the term, used to reference the term dimension.
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
False
StudentTermSK
False
StudentPaidFeesSK
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
CurriculumSK
DimCurriculum
CurriculumSK
True
FeeTypeSK
DimFeeType
FeeTypeSK
True
PaymentSourceSK
DimPaymentSource
PaymentSourceSK
True
StudentSK
DimStudent
StudentSK
True
StudentTermSK
DimStudentTerm
StudentTermSK
True
TermSK
DimTerm
TermSK
True
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.FactStudentFeesPaid depends on)
Name Type
Table
Table
Table
Table
Table
Table
  Child Dependencies (objects that depend on dbo.FactStudentFeesPaid)
Name Type
TABLE
TABLE
TABLE
TABLE
TABLE
TABLE
  Extended Properties
Object Property Value
FactStudentFeesPaid
Display Name
PaidFees
FactStudentFeesPaid
Table Description
The fact will contain the record of payment for a student for class and registration fees at the insitution as exist on the IT_S
FactStudentFeesPaid
Table Type
Fact
CurriculumSK
Display Name
CurriculumSK
CurriculumSK
Example Values
1,2,3
CurriculumSK
MS_Description
Key identifier for the Curriculum, used to reference the Class dimenstion.
FeePaidAmount
Display Name
Fee Paid Amount
FeePaidAmount
Example Values
0,50.00,1,290.50,3,225.98
FeePaidAmount
MS_Description
The amount of a class or registration fee which have been 'paid'.
FeePaidAmount
Source Field Name
FEE_AMOUNT
FeePaidAmount
Source System
DWStaging
FeePaidAmount
Source Table
IT_STUDENT_FEES_A_PAYMENT_GROUP
FeeTypeSK
Display Name
FeeTypeSK
FeeTypeSK
Example Values
1,2,3
FeeTypeSK
MS_Description
Key identifier for the student term, used to reference the fee type dimension.
PaymentSourceSK
Display Folder
PaymentSourceSK
Display Name
PaymentSourceSK
PaymentSourceSK
ETL Rules
The source category for the student is determined by the combination of values on the fee payment entry for the various types of
PaymentSourceSK
Example Values
1,2,3
PaymentSourceSK
MS_Description
Key identifier for the payment source category for the student for a class. Will identify how to aggregate the student for paym
PaymentSourceSK
Source Field Name
PaymentSourceSK
Source System
PaymentSourceSK
Source Table
StudentPaidFeesSK
Display Folder
key
StudentPaidFeesSK
Display Name
StudentPaidFeesSK
StudentPaidFeesSK
ETL Rules
Identity key, assigned by SQL Server.
StudentPaidFeesSK
Example Values
1, 2, 3
StudentPaidFeesSK
MS_Description
Primary Key to the Fact.
StudentSK
Display Name
StudentSK
StudentSK
Example Values
1,2,3
StudentSK
MS_Description
Key identifier for the student, used to reference the student dimension.
StudentTermSK
Display Name
StudentTermSK
StudentTermSK
Example Values
1,2,3
StudentTermSK
MS_Description
Key identifier for the student term, used to reference the student term dimension.
TermSK
Display Name
TermSK
TermSK
Example Values
1,2,3
TermSK
MS_Description
Key identifier for the term, used to reference the term dimension.
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[FactStudentFeesPaid] Script Date: 03/09/2017 17:14:59 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[FactStudentFeesPaid](
    [StudentPaidFeesSK] [int] IDENTITY(1,1) NOT NULL,
    [TermSK] [int] NOT NULL,
    [StudentSK] [int] NOT NULL,
    [StudentTermSK] [int] NOT NULL,
    [FeeTypeSK] [int] NOT NULL,
    [CurriculumSK] [int] NOT NULL,
    [PaymentSourceSK] [int] NOT NULL,
    [FeePaidAmount] [numeric](11, 2) NULL,
 CONSTRAINT [PK_dbo.FactStudentPaidFees] PRIMARY KEY NONCLUSTERED 
(
    [StudentPaidFeesSK] 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].[FactStudentFeesPaid]  WITH CHECK ADD  CONSTRAINT [FK_FactStudentFeesPaid_DimCurriculum] FOREIGN KEY([CurriculumSK])
REFERENCES [DimCurriculum] ([CurriculumSK])
ALTER TABLE [dbo].[FactStudentFeesPaid] CHECK CONSTRAINT [FK_FactStudentFeesPaid_DimCurriculum]
ALTER TABLE [dbo].[FactStudentFeesPaid]  WITH CHECK ADD  CONSTRAINT [FK_FactStudentFeesPaid_DimFeeType] FOREIGN KEY([FeeTypeSK])
REFERENCES [DimFeeType] ([FeeTypeSK])
ALTER TABLE [dbo].[FactStudentFeesPaid] CHECK CONSTRAINT [FK_FactStudentFeesPaid_DimFeeType]
ALTER TABLE [dbo].[FactStudentFeesPaid]  WITH CHECK ADD  CONSTRAINT [FK_FactStudentFeesPaid_DimPaymentSource] FOREIGN KEY([PaymentSourceSK])
REFERENCES [DimPaymentSource] ([PaymentSourceSK])
ALTER TABLE [dbo].[FactStudentFeesPaid] CHECK CONSTRAINT [FK_FactStudentFeesPaid_DimPaymentSource]
ALTER TABLE [dbo].[FactStudentFeesPaid]  WITH CHECK ADD  CONSTRAINT [FK_FactStudentFeesPaid_DimStudent] FOREIGN KEY([StudentSK])
REFERENCES [DimStudent] ([StudentSK])
ALTER TABLE [dbo].[FactStudentFeesPaid] CHECK CONSTRAINT [FK_FactStudentFeesPaid_DimStudent]
ALTER TABLE [dbo].[FactStudentFeesPaid]  WITH CHECK ADD  CONSTRAINT [FK_FactStudentFeesPaid_DimStudentTerm] FOREIGN KEY([StudentTermSK])
REFERENCES [DimStudentTerm] ([StudentTermSK])
ALTER TABLE [dbo].[FactStudentFeesPaid] CHECK CONSTRAINT [FK_FactStudentFeesPaid_DimStudentTerm]
ALTER TABLE [dbo].[FactStudentFeesPaid]  WITH CHECK ADD  CONSTRAINT [FK_FactStudentFeesPaid_DimTerm] FOREIGN KEY([TermSK])
REFERENCES [DimTerm] ([TermSK])
ALTER TABLE [dbo].[FactStudentFeesPaid] CHECK CONSTRAINT [FK_FactStudentFeesPaid_DimTerm]


EXEC sys.sp_addextendedproperty @name=N'Display Name', @value=N'PaidFees' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentFeesPaid'


EXEC sys.sp_addextendedproperty @name=N'Table Description', @value=N'The fact will contain the record of payment for a student for class and registration fees at the insitution as exist on the IT_S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentFeesPaid'


EXEC sys.sp_addextendedproperty @name=N'Table Type', @value=N'Fact' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentFeesPaid'


EXEC sys.sp_addextendedproperty @name=N'Display Name', @value=N'CurriculumSK' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentFeesPaid', @level2type=N'COLUMN',@level2name=N'CurriculumSK'


EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'1,2,3' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentFeesPaid', @level2type=N'COLUMN',@level2name=N'CurriculumSK'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Key identifier for the Curriculum, used to reference the Class dimenstion.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentFeesPaid', @level2type=N'COLUMN',@level2name=N'CurriculumSK'


EXEC sys.sp_addextendedproperty @name=N'Display Name', @value=N'Fee Paid Amount' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentFeesPaid', @level2type=N'COLUMN',@level2name=N'FeePaidAmount'


EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'0,50.00,1,290.50,3,225.98' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentFeesPaid', @level2type=N'COLUMN',@level2name=N'FeePaidAmount'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The amount of a class or registration fee which have been ''paid''.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentFeesPaid', @level2type=N'COLUMN',@level2name=N'FeePaidAmount'


EXEC sys.sp_addextendedproperty @name=N'Source Field Name', @value=N'FEE_AMOUNT' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentFeesPaid', @level2type=N'COLUMN',@level2name=N'FeePaidAmount'


EXEC sys.sp_addextendedproperty @name=N'Source System', @value=N'DWStaging' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentFeesPaid', @level2type=N'COLUMN',@level2name=N'FeePaidAmount'


EXEC sys.sp_addextendedproperty @name=N'Source Table', @value=N'IT_STUDENT_FEES_A_PAYMENT_GROUP' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentFeesPaid', @level2type=N'COLUMN',@level2name=N'FeePaidAmount'


EXEC sys.sp_addextendedproperty @name=N'Display Name', @value=N'FeeTypeSK' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentFeesPaid', @level2type=N'COLUMN',@level2name=N'FeeTypeSK'


EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'1,2,3' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentFeesPaid', @level2type=N'COLUMN',@level2name=N'FeeTypeSK'


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


EXEC sys.sp_addextendedproperty @name=N'Display Folder', @value=N' ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentFeesPaid', @level2type=N'COLUMN',@level2name=N'PaymentSourceSK'


EXEC sys.sp_addextendedproperty @name=N'Display Name', @value=N'PaymentSourceSK' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentFeesPaid', @level2type=N'COLUMN',@level2name=N'PaymentSourceSK'


EXEC sys.sp_addextendedproperty @name=N'ETL Rules', @value=N'The source category for the student is determined by the combination of values on the fee payment entry for the various types of' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentFeesPaid', @level2type=N'COLUMN',@level2name=N'PaymentSourceSK'


EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'1,2,3' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentFeesPaid', @level2type=N'COLUMN',@level2name=N'PaymentSourceSK'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Key identifier for the payment source category for the student for a class. Will identify how to aggregate the student for paym' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentFeesPaid', @level2type=N'COLUMN',@level2name=N'PaymentSourceSK'


EXEC sys.sp_addextendedproperty @name=N'Source Field Name', @value=N' ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentFeesPaid', @level2type=N'COLUMN',@level2name=N'PaymentSourceSK'


EXEC sys.sp_addextendedproperty @name=N'Source System', @value=N' ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentFeesPaid', @level2type=N'COLUMN',@level2name=N'PaymentSourceSK'


EXEC sys.sp_addextendedproperty @name=N'Source Table', @value=N' ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentFeesPaid', @level2type=N'COLUMN',@level2name=N'PaymentSourceSK'


EXEC sys.sp_addextendedproperty @name=N'Display Folder', @value=N'key' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentFeesPaid', @level2type=N'COLUMN',@level2name=N'StudentPaidFeesSK'


EXEC sys.sp_addextendedproperty @name=N'Display Name', @value=N'StudentPaidFeesSK' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentFeesPaid', @level2type=N'COLUMN',@level2name=N'StudentPaidFeesSK'


EXEC sys.sp_addextendedproperty @name=N'ETL Rules', @value=N'Identity key, assigned by SQL Server. ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentFeesPaid', @level2type=N'COLUMN',@level2name=N'StudentPaidFeesSK'


EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'1, 2, 3' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentFeesPaid', @level2type=N'COLUMN',@level2name=N'StudentPaidFeesSK'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Primary Key to the Fact.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentFeesPaid', @level2type=N'COLUMN',@level2name=N'StudentPaidFeesSK'


EXEC sys.sp_addextendedproperty @name=N'Display Name', @value=N'StudentSK' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentFeesPaid', @level2type=N'COLUMN',@level2name=N'StudentSK'


EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'1,2,3' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentFeesPaid', @level2type=N'COLUMN',@level2name=N'StudentSK'


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


EXEC sys.sp_addextendedproperty @name=N'Display Name', @value=N'StudentTermSK' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentFeesPaid', @level2type=N'COLUMN',@level2name=N'StudentTermSK'


EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'1,2,3' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentFeesPaid', @level2type=N'COLUMN',@level2name=N'StudentTermSK'


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


EXEC sys.sp_addextendedproperty @name=N'Display Name', @value=N'TermSK' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentFeesPaid', @level2type=N'COLUMN',@level2name=N'TermSK'


EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'1,2,3' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentFeesPaid', @level2type=N'COLUMN',@level2name=N'TermSK'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Key identifier for the term, used to reference the term dimension.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentFeesPaid', @level2type=N'COLUMN',@level2name=N'TermSK'
  Sample Data
CurriculumSK FeePaidAmount FeeTypeSK PaymentSourceSK StudentPaidFeesSK StudentSK StudentTermSK TermSK
5435299 6.40 588 5 16298300 23456414 53836468 20101
5472868 35.00 616 10 4863286 22926139 50977843 20113
5515387 11.52 470 9 6574171 22991024 51374821 20161
5415727 5.00 371 5 10734843 23198495 52429414 20072
5485784 22.88 467 6 2502329 22818738 50358310 20133
5357246 3.00 588 9 19241192 23588528 54541066 20022
5411297 5.01 467 9 16146651 23466370 53801845 20072
5421407 8.07 605 9 13439830 23329131 53137644 20081
5402951 8.07 605 9 13285826 23327629 53105574 20072
5440013 19.20 588 10 6859542 23012206 51467813 20102
Powered by BI Documenter