EnterpriseDW_SSAS
 dbo_FactStudentFeesPaid (Data Source View Table)
  Properties
Property Value
Table Name dbo_FactStudentFeesPaid
Database Table Name FactStudentFeesPaid
Schema dbo
Friendly Name FactStudentFeesPaid
Table Type Table
Query Definition
Description
  Columns
 
Column Name
Friendly Name
Data Type
Computed Column Expression
Description
In Primary Key
StudentPaidFeesSK
StudentPaidFeesSK
System.Int32
TermSK
TermSK
System.Int32
StudentSK
StudentSK
System.Int32
StudentTermSK
StudentTermSK
System.Int32
FeeTypeSK
FeeTypeSK
System.Int32
CurriculumSK
CurriculumSK
System.Int32
PaymentSourceSK
PaymentSourceSK
System.Int32
FeePaidAmount
FeePaidAmount
System.Decimal
  Parent Relations
Table Name
Using Column
Friendly Name
Table Type
Is Logical
Description
PaymentSourceSK
DimPaymentSource
Table
False
StudentTermSK
DimStudentTerm
Table
False
CurriculumSK
DimCurriculum
Table
False
TermSK
DimTerm
Table
False
StudentSK
DimStudent
Table
False
FeeTypeSK
DimFeeType
Table
False
  Child Relations
Table Name
Using Column
Friendly Name
Table Type
Is Logical
Description
Powered by BI Documenter