EnterpriseDW
 dbo.FactStudentTotalFees (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.FactStudentTotalFees
  Properties
Property Value
Name FactStudentTotalFees
Schema dbo
Row Count 1400064
Data Size 92304 KB
Index Size 52128 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
PaymentSourceSK
int(10, 0)
False
False
False
 
Key identifier for the payment source category for the student for the term. Will identify how to aggregate the student for pay
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.
In Primary Key
StudentTermTotalFeesSK
int(10, 0)
False
False
False
(1 / 1)
Primary Key to the Fact.
Foreign Key
TermSK
int(10, 0)
False
False
False
 
Key identifier for the term, used to reference the term dimension.
TotalFeesAssessed
numeric(11, 2)
True
False
False
 
The total fees assessed for the student for a term. Will include the class and term fees minus the exemptions.
TotalFeesExempted
numeric(11, 2)
True
False
False
 
The total fees for the student for a term that were exempted.
TotalFeesNotPaid
numeric(11, 2)
True
False
False
 
The total fees remaining unpaid for the student for the term. Calculated as the Total Fees Assessed minus the Total Fees Paid f
TotalFeesPaid
numeric(11, 2)
True
False
False
 
The total fees paid for the student for a term. Will include the dollars from all methods of payment and source of funds.
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
False
StudentTermSK
False
StudentTermTotalFeesSK
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
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.FactStudentTotalFees depends on)
Name Type
Table
Table
Table
Table
  Child Dependencies (objects that depend on dbo.FactStudentTotalFees)
Name Type
TABLE
TABLE
TABLE
TABLE
  Extended Properties
Object Property Value
FactStudentTotalFees
Display Name
TotalFees
FactStudentTotalFees
Table Description
The fact will contain one row per student per term where the student was assessed fees on the IT_STUDENT_FEES and IT_STUDENT_FEE
FactStudentTotalFees
Table Type
Fact
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 the term. Will identify how to aggregate the student for pay
PaymentSourceSK
Source Field Name
derived
PaymentSourceSK
Source System
DWStaging
PaymentSourceSK
Source Table
IT_STUDENT_FEES_A
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.
StudentTermTotalFeesSK
Display Folder
key
StudentTermTotalFeesSK
Display Name
StudentTermTotalFeesSK
StudentTermTotalFeesSK
ETL Rules
Identity key, assigned by SQL Server.
StudentTermTotalFeesSK
Example Values
1, 2, 3
StudentTermTotalFeesSK
MS_Description
Primary Key to the Fact.
TermSK
Display Name
TermSK
TermSK
Example Values
1,2,3
TermSK
MS_Description
Key identifier for the term, used to reference the term dimension.
TotalFeesAssessed
Display Folder
TotalFeesAssessed
Display Name
Total Fees Assessed
TotalFeesAssessed
ETL Rules
The sum of all the FEE_ASSESS_AMOUNTs for the student for the term on the IT_STUDENT_FEES_A table minus the sum of all the EXMPT
TotalFeesAssessed
Example Values
0,50.00,1,290.50,3,225.98
TotalFeesAssessed
MS_Description
The total fees assessed for the student for a term. Will include the class and term fees minus the exemptions.
TotalFeesAssessed
Source Field Name
derived
TotalFeesAssessed
Source System
DWStaging
TotalFeesAssessed
Source Table
IT_STUDENT_FEES_A
TotalFeesExempted
Display Name
Total Fees Exepted
TotalFeesExempted
ETL Rules
The sum of all the EXMPT_AMOUNTs for the student for the term in the IT_STUDENT_FEES_A table.
TotalFeesExempted
Example Values
0,50.00,1,290.50,3,225.98
TotalFeesExempted
MS_Description
The total fees for the student for a term that were exempted.
TotalFeesExempted
Source Field Name
derived
TotalFeesExempted
Source System
DWStaging
TotalFeesExempted
Source Table
IT_STUDENT_FEES_A
TotalFeesNotPaid
Display Name
Total Fees Not Paid
TotalFeesNotPaid
ETL Rules
The sum of all the DUE_AMOUNTs for the student for the term in the IT_STUDENT_FEES_A table.
TotalFeesNotPaid
Example Values
0,50.00,1,290.50,3,225.98
TotalFeesNotPaid
MS_Description
The total fees remaining unpaid for the student for the term. Calculated as the Total Fees Assessed minus the Total Fees Paid f
TotalFeesNotPaid
Source Field Name
derived
TotalFeesNotPaid
Source System
DWStaging
TotalFeesNotPaid
Source Table
IT_STUDENT_FEES_A
TotalFeesPaid
Display Name
Total Fees Paid
TotalFeesPaid
ETL Rules
The sum of all the COVERATE_AMOUNTs plus the PAYMENT_AMOUNTs for the student for the term in the IT_STUDENT_FEES_A table.
TotalFeesPaid
Example Values
0,50.00,1,290.50,3,225.98
TotalFeesPaid
MS_Description
The total fees paid for the student for a term. Will include the dollars from all methods of payment and source of funds.
TotalFeesPaid
Source Field Name
derived
TotalFeesPaid
Source System
DWStaging
TotalFeesPaid
Source Table
IT_STUDENT_FEES_A
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[FactStudentTotalFees] Script Date: 03/09/2017 17:14:59 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[FactStudentTotalFees](
    [StudentTermTotalFeesSK] [int] IDENTITY(1,1) NOT NULL,
    [TermSK] [int] NOT NULL,
    [StudentSK] [int] NOT NULL,
    [StudentTermSK] [int] NOT NULL,
    [PaymentSourceSK] [int] NOT NULL,
    [TotalFeesAssessed] [numeric](11, 2) NULL,
    [TotalFeesPaid] [numeric](11, 2) NULL,
    [TotalFeesNotPaid] [numeric](11, 2) NULL,
    [TotalFeesExempted] [numeric](11, 2) NULL,
 CONSTRAINT [PK_dbo.FactStudentTotalFees] PRIMARY KEY NONCLUSTERED 
(
    [StudentTermTotalFeesSK] 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].[FactStudentTotalFees]  WITH CHECK ADD  CONSTRAINT [FK_FactStudentTotalFees_DimPaymentSource] FOREIGN KEY([PaymentSourceSK])
REFERENCES [DimPaymentSource] ([PaymentSourceSK])
ALTER TABLE [dbo].[FactStudentTotalFees] CHECK CONSTRAINT [FK_FactStudentTotalFees_DimPaymentSource]
ALTER TABLE [dbo].[FactStudentTotalFees]  WITH CHECK ADD  CONSTRAINT [FK_FactStudentTotalFees_DimStudent] FOREIGN KEY([StudentSK])
REFERENCES [DimStudent] ([StudentSK])
ALTER TABLE [dbo].[FactStudentTotalFees] CHECK CONSTRAINT [FK_FactStudentTotalFees_DimStudent]
ALTER TABLE [dbo].[FactStudentTotalFees]  WITH CHECK ADD  CONSTRAINT [FK_FactStudentTotalFees_DimStudentTerm] FOREIGN KEY([StudentTermSK])
REFERENCES [DimStudentTerm] ([StudentTermSK])
ALTER TABLE [dbo].[FactStudentTotalFees] CHECK CONSTRAINT [FK_FactStudentTotalFees_DimStudentTerm]
ALTER TABLE [dbo].[FactStudentTotalFees]  WITH CHECK ADD  CONSTRAINT [FK_FactStudentTotalFees_DimTerm] FOREIGN KEY([TermSK])
REFERENCES [DimTerm] ([TermSK])
ALTER TABLE [dbo].[FactStudentTotalFees] CHECK CONSTRAINT [FK_FactStudentTotalFees_DimTerm]


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


EXEC sys.sp_addextendedproperty @name=N'Table Description', @value=N'The fact will contain one row per student per term where the student was assessed fees on the IT_STUDENT_FEES and IT_STUDENT_FEE' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentTotalFees'


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


EXEC sys.sp_addextendedproperty @name=N'Display Folder', @value=N' ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentTotalFees', @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'FactStudentTotalFees', @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'FactStudentTotalFees', @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'FactStudentTotalFees', @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 the term. Will identify how to aggregate the student for pay' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentTotalFees', @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'FactStudentTotalFees', @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'FactStudentTotalFees', @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'FactStudentTotalFees', @level2type=N'COLUMN',@level2name=N'PaymentSourceSK'


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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 term in the IT_STUDENT_FEES_A table.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentTotalFees', @level2type=N'COLUMN',@level2name=N'TotalFeesPaid'


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


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


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


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


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'FactStudentTotalFees', @level2type=N'COLUMN',@level2name=N'TotalFeesPaid'
  Sample Data
PaymentSourceSK StudentSK StudentTermSK StudentTermTotalFeesSK TermSK TotalFeesAssessed TotalFeesExempted TotalFeesNotPaid TotalFeesPaid
9 22921407 50929673 791716 20072 408.00 0.00 0.00 408.00
9 23618362 54749165 379125 20103 531.00 0.00 0.00 531.00
8 23493352 54017752 1066153 20032 208.00 0.00 0.00 208.00
2 23328353 53109429 1130083 20162 616.00 0.00 0.00 616.00
9 23620324 54744915 342596 20073 798.00 0.00 0.00 798.00
17 22924029 50961634 1046056 20042 0.00 170.00 0.00 0.00
5 23609585 54718483 293931 20072 208.50 0.00 0.00 208.50
5 23593446 54617566 72549 20083 16.00 0.00 0.00 16.00
2 22928628 51074190 1843 20142 1028.50 0.00 0.00 1028.50
2 22753296 50007343 580609 20132 892.00 0.00 0.00 892.00
Powered by BI Documenter