|
|
||||||
|
|
||||||
Properties
| Property | Value |
| Table Name | dbo_DimPaymentSource |
| Database Table Name | DimPaymentSource |
| Schema | dbo |
| Friendly Name | DimPaymentSource |
| Table Type | Table |
| Query Definition | |
| Description |
Columns
Column Name |
Friendly Name |
Data Type |
Computed Column Expression |
Description |
|
 |
PaymentSourceSK |
PaymentSourceSK |
System.Int32 | ||
 |
PaymentSourceAK |
PaymentSourceAK |
System.String(20) | ||
|
PaymentSourceCode |
PaymentSourceCode |
System.String(10) | ||
|
PaymentSource |
PaymentSource |
System.String(60) | ||
|
PaymentSourceLabel |
PaymentSourceLabel |
System.String(30) | ||
|
PaymentCategoryCode |
PaymentCategoryCode |
System.String(10) | ||
|
PaymentCategory |
PaymentCategory |
System.String(60) | ||
|
PaymentCategoryLabel |
PaymentCategoryLabel |
System.String(30) | ||
|
PaymentCategoryShort |
PaymentCategoryShort |
System.String(15) | ||
|
RowIsCurrent |
RowIsCurrent |
System.String(1) | ||
|
RowStartDate |
RowStartDate |
System.DateTime | ||
|
RowEndDate |
RowEndDate |
System.DateTime |
Parent Relations
Table Name |
Using Column |
Friendly Name |
Table Type |
Is Logical |
Description |
Child Relations
Table Name |
Using Column |
Friendly Name |
Table Type |
Is Logical |
Description |
PaymentSourceSK |
FactStudentTotalFeesForClass |
Table |
False |
||
PaymentSourceSK |
FactStudentTotalFees |
Table |
False |
||
PaymentSourceSK |
FactStudentFeesPaid |
Table |
False |
| Powered by BI Documenter |
