EnterpriseDW_SSAS
 dbo_FactStudentReceiptPayments (Data Source View Table)
  Properties
Property Value
Table Name dbo_FactStudentReceiptPayments
Database Table Name FactStudentReceiptPayments
Schema dbo
Friendly Name FactStudentReceiptPayments
Table Type Table
Query Definition
Description
  Columns
 
Column Name
Friendly Name
Data Type
Computed Column Expression
Description
In Primary Key
StudentReceiptPaymentsSK
StudentReceiptPaymentsSK
System.Int32
StudentReceiptSK
StudentReceiptSK
System.Int32
StudentSK
StudentSK
System.Int32
DateSK
DateSK
System.Int32
ReceiptPaymentCategorySK
ReceiptPaymentCategorySK
System.Int32
ReceiptPaymentAmount
ReceiptPaymentAmount
System.Decimal
  Parent Relations
Table Name
Using Column
Friendly Name
Table Type
Is Logical
Description
ReceiptPaymentCategorySK
DimReceiptPaymentCategory
Table
False
StudentSK
DimStudent
Table
False
StudentReceiptSK
DimStudentReceipt
Table
False
DateSK
DimDate
Table
False
  Child Relations
Table Name
Using Column
Friendly Name
Table Type
Is Logical
Description
Powered by BI Documenter