EnterpriseDW_SSAS
 dbo_FactStudentReceiptTotals (Data Source View Table)
  Properties
Property Value
Table Name dbo_FactStudentReceiptTotals
Database Table Name FactStudentReceiptTotals
Schema dbo
Friendly Name FactStudentReceiptTotals
Table Type Table
Query Definition
Description
  Columns
 
Column Name
Friendly Name
Data Type
Computed Column Expression
Description
In Primary Key
StudentReceiptTotalsSK
StudentReceiptTotalsSK
System.Int32
StudentReceiptSK
StudentReceiptSK
System.Int32
StudentSK
StudentSK
System.Int32
DateSK
DateSK
System.Int32
ReceiptTotal
ReceiptTotal
System.Decimal
ReceiptTotalPlusCoverage
ReceiptTotalPlusCoverage
System.Decimal
ReceiptFeesPaid
ReceiptFeesPaid
System.Decimal
ReceiptReceivablesPaid
ReceiptReceivablesPaid
System.Decimal
ReceiptObligationsPaid
ReceiptObligationsPaid
System.Decimal
  Parent Relations
Table Name
Using Column
Friendly Name
Table Type
Is Logical
Description
StudentSK
DimStudent
Table
False
DateSK
DimDate
Table
False
StudentReceiptSK
DimStudentReceipt
Table
False
  Child Relations
Table Name
Using Column
Friendly Name
Table Type
Is Logical
Description
Powered by BI Documenter