EnterpriseDW
 dbo.FactStudentTotalFeesForClass (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.FactStudentTotalFeesForClass
  Properties
Property Value
Name FactStudentTotalFeesForClass
Schema dbo
Row Count 3508613
Data Size 245744 KB
Index Size 127792 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
ClassTotalFeesAssessed
numeric(11, 2)
True
False
False
 
The total fees assessed for the student for a class. Will include the class and term fees minus the exemptions.
ClassTotalFeesExempted
numeric(11, 2)
True
False
False
 
The total fees for the student for a class that were exempted.
ClassTotalFeesNotPaid
numeric(11, 2)
True
False
False
 
The total fees remaining unpaid for the student for a class. Calculated as the Total Fees Assessed minus the Total Fees Paid fo
ClassTotalFeesPaid
numeric(11, 2)
True
False
False
 
The total fees paid for the student for a class. Will include the dollars from all methods of payment and source of funds.
Foreign Key
CurriculumSK
int(10, 0)
False
False
False
 
Key identifier for the Curriculum, used to reference the Class dimenstion.
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
StudentClassTotalFeesSK
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
StudentClassTotalFeesSK
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
CurriculumSK
DimCurriculum
CurriculumSK
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.FactStudentTotalFeesForClass depends on)
Name Type
Table
Table
Table
Table
Table
  Child Dependencies (objects that depend on dbo.FactStudentTotalFeesForClass)
Name Type
TABLE
TABLE
TABLE
TABLE
TABLE
  Extended Properties
Object Property Value
FactStudentTotalFeesForClass
Display Name
TClassFees
FactStudentTotalFeesForClass
Table Description
The fact will contain one row per student per term per class where the student was assessed fees for any fee associated with the
FactStudentTotalFeesForClass
Table Type
Fact
ClassTotalFeesAssessed
Display Folder
ClassTotalFeesAssessed
Display Name
Total Class Fees Assessed
ClassTotalFeesAssessed
ETL Rules
The sum of all the FEE_ASSESS_AMOUNTs for the student for the class on the IT_STUDENT_FEES_A table minus the sum of all the EXMP
ClassTotalFeesAssessed
Example Values
0,50.00,1,290.50,3,225.98
ClassTotalFeesAssessed
MS_Description
The total fees assessed for the student for a class. Will include the class and term fees minus the exemptions.
ClassTotalFeesAssessed
Source Field Name
derived
ClassTotalFeesAssessed
Source System
DWStaging
ClassTotalFeesAssessed
Source Table
IT_STUDENT_FEES_A
ClassTotalFeesExempted
Display Name
Total Class Fees Exepted
ClassTotalFeesExempted
ETL Rules
The sum of all the EXMPT_AMOUNTs for the student for the class in the IT_STUDENT_FEES_A table.
ClassTotalFeesExempted
Example Values
0,50.00,1,290.50,3,225.98
ClassTotalFeesExempted
MS_Description
The total fees for the student for a class that were exempted.
ClassTotalFeesExempted
Source Field Name
derived
ClassTotalFeesExempted
Source System
DWStaging
ClassTotalFeesExempted
Source Table
IT_STUDENT_FEES_A
ClassTotalFeesNotPaid
Display Name
Total Class Fees Not Paid
ClassTotalFeesNotPaid
ETL Rules
The sum of all the DUE_AMOUNTs for the student for the class in the IT_STUDENT_FEES_A table.
ClassTotalFeesNotPaid
Example Values
0,50.00,1,290.50,3,225.98
ClassTotalFeesNotPaid
MS_Description
The total fees remaining unpaid for the student for a class. Calculated as the Total Fees Assessed minus the Total Fees Paid fo
ClassTotalFeesNotPaid
Source Field Name
derived
ClassTotalFeesNotPaid
Source System
DWStaging
ClassTotalFeesNotPaid
Source Table
IT_STUDENT_FEES_A
ClassTotalFeesPaid
Display Name
Total Class Fees Paid
ClassTotalFeesPaid
ETL Rules
The sum of all the COVERATE_AMOUNTs plus the PAYMENT_AMOUNTs for the student for the class in the IT_STUDENT_FEES_A table.
ClassTotalFeesPaid
Example Values
0,50.00,1,290.50,3,225.98
ClassTotalFeesPaid
MS_Description
The total fees paid for the student for a class. Will include the dollars from all methods of payment and source of funds.
ClassTotalFeesPaid
Source Field Name
derived
ClassTotalFeesPaid
Source System
DWStaging
ClassTotalFeesPaid
Source Table
IT_STUDENT_FEES_A
CurriculumSK
Display Name
CurriculumSK
CurriculumSK
Example Values
1,2,3
CurriculumSK
MS_Description
Key identifier for the Curriculum, used to reference the Class dimenstion.
PaymentSourceSK
Display Folder
PaymentSourceSK
Display Name
PaymentSourceSK
PaymentSourceSK
ETL Rules
The source category for the student is determined by the total fees assessed as compared to the totals 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
derived
PaymentSourceSK
Source System
DWStaging
PaymentSourceSK
Source Table
IT_STUDENT_FEES_A
StudentClassTotalFeesSK
Display Folder
key
StudentClassTotalFeesSK
Display Name
StudentClassTotalFeesSK
StudentClassTotalFeesSK
ETL Rules
Identity key, assigned by SQL Server.
StudentClassTotalFeesSK
Example Values
1, 2, 3
StudentClassTotalFeesSK
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].[FactStudentTotalFeesForClass] Script Date: 03/09/2017 17:14:59 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[FactStudentTotalFeesForClass](
    [StudentClassTotalFeesSK] [int] IDENTITY(1,1) NOT NULL,
    [TermSK] [int] NOT NULL,
    [StudentSK] [int] NOT NULL,
    [StudentTermSK] [int] NOT NULL,
    [CurriculumSK] [int] NOT NULL,
    [PaymentSourceSK] [int] NOT NULL,
    [ClassTotalFeesAssessed] [numeric](11, 2) NULL,
    [ClassTotalFeesPaid] [numeric](11, 2) NULL,
    [ClassTotalFeesNotPaid] [numeric](11, 2) NULL,
    [ClassTotalFeesExempted] [numeric](11, 2) NULL,
 CONSTRAINT [PK_dbo.FactStudentTotalFeesByClass] PRIMARY KEY NONCLUSTERED 
(
    [StudentClassTotalFeesSK] 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].[FactStudentTotalFeesForClass]  WITH CHECK ADD  CONSTRAINT [FK_FactStudentTotalFeesForClass_DimCurriculum] FOREIGN KEY([CurriculumSK])
REFERENCES [DimCurriculum] ([CurriculumSK])
ALTER TABLE [dbo].[FactStudentTotalFeesForClass] CHECK CONSTRAINT [FK_FactStudentTotalFeesForClass_DimCurriculum]
ALTER TABLE [dbo].[FactStudentTotalFeesForClass]  WITH CHECK ADD  CONSTRAINT [FK_FactStudentTotalFeesForClass_DimPaymentSource] FOREIGN KEY([PaymentSourceSK])
REFERENCES [DimPaymentSource] ([PaymentSourceSK])
ALTER TABLE [dbo].[FactStudentTotalFeesForClass] CHECK CONSTRAINT [FK_FactStudentTotalFeesForClass_DimPaymentSource]
ALTER TABLE [dbo].[FactStudentTotalFeesForClass]  WITH CHECK ADD  CONSTRAINT [FK_FactStudentTotalFeesForClass_DimStudent] FOREIGN KEY([StudentSK])
REFERENCES [DimStudent] ([StudentSK])
ALTER TABLE [dbo].[FactStudentTotalFeesForClass] CHECK CONSTRAINT [FK_FactStudentTotalFeesForClass_DimStudent]
ALTER TABLE [dbo].[FactStudentTotalFeesForClass]  WITH CHECK ADD  CONSTRAINT [FK_FactStudentTotalFeesForClass_DimStudentTerm] FOREIGN KEY([StudentTermSK])
REFERENCES [DimStudentTerm] ([StudentTermSK])
ALTER TABLE [dbo].[FactStudentTotalFeesForClass] CHECK CONSTRAINT [FK_FactStudentTotalFeesForClass_DimStudentTerm]
ALTER TABLE [dbo].[FactStudentTotalFeesForClass]  WITH CHECK ADD  CONSTRAINT [FK_FactStudentTotalFeesForClass_DimTerm] FOREIGN KEY([TermSK])
REFERENCES [DimTerm] ([TermSK])
ALTER TABLE [dbo].[FactStudentTotalFeesForClass] CHECK CONSTRAINT [FK_FactStudentTotalFeesForClass_DimTerm]


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


EXEC sys.sp_addextendedproperty @name=N'Table Description', @value=N'The fact will contain one row per student per term per class where the student was assessed fees for any fee associated with the' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentTotalFeesForClass'


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


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


EXEC sys.sp_addextendedproperty @name=N'Display Name', @value=N'Total Class Fees Assessed' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentTotalFeesForClass', @level2type=N'COLUMN',@level2name=N'ClassTotalFeesAssessed'


EXEC sys.sp_addextendedproperty @name=N'ETL Rules', @value=N'The sum of all the FEE_ASSESS_AMOUNTs for the student for the class on the IT_STUDENT_FEES_A table minus the sum of all the EXMP' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentTotalFeesForClass', @level2type=N'COLUMN',@level2name=N'ClassTotalFeesAssessed'


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


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The total fees assessed for the student for a class. Will include the class and term fees minus the exemptions.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentTotalFeesForClass', @level2type=N'COLUMN',@level2name=N'ClassTotalFeesAssessed'


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


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


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


EXEC sys.sp_addextendedproperty @name=N'Display Name', @value=N'Total Class Fees Exepted' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentTotalFeesForClass', @level2type=N'COLUMN',@level2name=N'ClassTotalFeesExempted'


EXEC sys.sp_addextendedproperty @name=N'ETL Rules', @value=N'The sum of all the EXMPT_AMOUNTs for the student for the class in the IT_STUDENT_FEES_A table.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentTotalFeesForClass', @level2type=N'COLUMN',@level2name=N'ClassTotalFeesExempted'


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


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The total fees for the student for a class that were exempted.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentTotalFeesForClass', @level2type=N'COLUMN',@level2name=N'ClassTotalFeesExempted'


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


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


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


EXEC sys.sp_addextendedproperty @name=N'Display Name', @value=N'Total Class Fees Not Paid' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentTotalFeesForClass', @level2type=N'COLUMN',@level2name=N'ClassTotalFeesNotPaid'


EXEC sys.sp_addextendedproperty @name=N'ETL Rules', @value=N'The sum of all the DUE_AMOUNTs for the student for the class in the IT_STUDENT_FEES_A table.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentTotalFeesForClass', @level2type=N'COLUMN',@level2name=N'ClassTotalFeesNotPaid'


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


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The total fees remaining unpaid for the student for a class. Calculated as the Total Fees Assessed minus the Total Fees Paid fo' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentTotalFeesForClass', @level2type=N'COLUMN',@level2name=N'ClassTotalFeesNotPaid'


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


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


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


EXEC sys.sp_addextendedproperty @name=N'Display Name', @value=N'Total Class Fees Paid' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentTotalFeesForClass', @level2type=N'COLUMN',@level2name=N'ClassTotalFeesPaid'


EXEC sys.sp_addextendedproperty @name=N'ETL Rules', @value=N'The sum of all the COVERATE_AMOUNTs plus the PAYMENT_AMOUNTs for the student for the class in the IT_STUDENT_FEES_A table.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentTotalFeesForClass', @level2type=N'COLUMN',@level2name=N'ClassTotalFeesPaid'


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


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The total fees paid for the student for a class. Will include the dollars from all methods of payment and source of funds.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentTotalFeesForClass', @level2type=N'COLUMN',@level2name=N'ClassTotalFeesPaid'


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


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


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


EXEC sys.sp_addextendedproperty @name=N'Display Name', @value=N'CurriculumSK' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentTotalFeesForClass', @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'FactStudentTotalFeesForClass', @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'FactStudentTotalFeesForClass', @level2type=N'COLUMN',@level2name=N'CurriculumSK'


EXEC sys.sp_addextendedproperty @name=N'Display Folder', @value=N' ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentTotalFeesForClass', @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'FactStudentTotalFeesForClass', @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 total fees assessed as compared to the totals for the various types of ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentTotalFeesForClass', @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'FactStudentTotalFeesForClass', @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'FactStudentTotalFeesForClass', @level2type=N'COLUMN',@level2name=N'PaymentSourceSK'


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


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


EXEC sys.sp_addextendedproperty @name=N'Source Table', @value=N'IT_STUDENT_FEES_A' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentTotalFeesForClass', @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'FactStudentTotalFeesForClass', @level2type=N'COLUMN',@level2name=N'StudentClassTotalFeesSK'


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


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


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


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


EXEC sys.sp_addextendedproperty @name=N'Display Name', @value=N'StudentSK' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentTotalFeesForClass', @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'FactStudentTotalFeesForClass', @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'FactStudentTotalFeesForClass', @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'FactStudentTotalFeesForClass', @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'FactStudentTotalFeesForClass', @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'FactStudentTotalFeesForClass', @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'FactStudentTotalFeesForClass', @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'FactStudentTotalFeesForClass', @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'FactStudentTotalFeesForClass', @level2type=N'COLUMN',@level2name=N'TermSK'
  Sample Data
ClassTotalFeesAssessed ClassTotalFeesExempted ClassTotalFeesNotPaid ClassTotalFeesPaid CurriculumSK PaymentSourceSK StudentClassTotalFeesSK StudentSK StudentTermSK TermSK
689.25 0.00 0.00 689.25 5397659 9 206924 23371123 53390968 20062
93.09 0.00 0.00 93.09 5412337 10 2919721 22957948 51166757 20082
288.00 0.00 0.00 288.00 5462981 2 3250193 23199360 52495148 20121
294.75 0.00 0.00 294.75 5482679 9 1221802 23130034 52083484 20132
174.00 0.00 0.00 174.00 5378408 9 1879217 23518388 54092091 20051
0.00 1074.00 0.00 0.00 5476654 17 679006 23372847 53449503 20132
153.00 0.00 0.00 153.00 5361201 4 1356653 23240761 52662570 20031
211.77 0.00 0.00 211.77 5417749 9 2336100 23196072 52442500 20082
40.00 0.00 0.00 40.00 5461003 9 3007403 23048072 51632047 20111
165.00 0.00 0.00 165.00 5373488 2 3254848 23314918 53020174 20041
Powered by BI Documenter