|
|
||||||
|
|
||||||
Properties
| Property | Value |
| Table Name | dbo_DimRelativeDay |
| Database Table Name | DimRelativeDay |
| Schema | dbo |
| Friendly Name | DimRelativeDay |
| Table Type | Table |
| Query Definition | |
| Description |
Columns
Column Name |
Friendly Name |
Data Type |
Computed Column Expression |
Description |
|
 |
RelativeDaySK |
RelativeDaySK |
System.Int32 | ||
 |
TermYear |
TermYear |
System.String(4) | ||
|
TermTypeCode |
TermTypeCode |
System.String(3) | ||
|
RelativeDayNumber |
RelativeDayNumber |
System.Int32 | ||
|
RelativeDayDate |
RelativeDayDate |
System.DateTime | ||
|
RelativeDayDateSK |
System.Int32 | |||
|
Term |
System.String(6) | |||
|
TermTitle |
System.String(30) | |||
|
RelativeDay |
System.String(15) | |||
|
RowIsCurrent |
System.String(1) | |||
|
RowStartDate |
System.DateTime | |||
|
RowEndDate |
System.DateTime | |||
|
RelativeDayFullDescription_Sort |
System.Int32 | |||
|
RelativeDayFullDescription |
System.String(50) |
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 |
RelativeDaySK |
FactEnrollmentActivity |
Table |
False |
||
RelativeDaySK |
FactEnrollmentSnapshot |
Table |
False |
| Powered by BI Documenter |
