|
|
||||||
|
|
||||||
Properties
| Property | Value |
| Table Name | dbo_FactHoursReportedByDay |
| Database Table Name | FactHoursReportedByDay |
| Schema | dbo |
| Friendly Name | FactHoursReportedByDay |
| Table Type | Table |
| Query Definition | |
| Description |
Columns
Column Name |
Friendly Name |
Data Type |
Computed Column Expression |
Description |
|
 |
HoursReportedByDaySK |
HoursReportedByDaySK |
System.Int32 | ||
 |
EmployeeSK |
EmployeeSK |
System.Int32 | ||
|
PositionSK |
PositionSK |
System.Int32 | ||
|
AssignmentSK |
AssignmentSK |
System.Int32 | ||
|
DateReportedSK |
DateReportedSK |
System.Int32 | ||
|
TimeTypeSK |
TimeTypeSK |
System.Int32 | ||
|
HoursReported |
HoursReported |
System.Decimal |
Parent Relations
Table Name |
Using Column |
Friendly Name |
Table Type |
Is Logical |
Description |
AssignmentSK |
DimAssignment |
Table |
False |
||
EmployeeSK |
DimEmployee |
Table |
False |
||
DateReportedSK |
DimDate |
Table |
False |
||
TimeTypeSK |
DimTimeType |
Table |
False |
||
PositionSK |
DimPosition |
Table |
False |
Child Relations
Table Name |
Using Column |
Friendly Name |
Table Type |
Is Logical |
Description |
| Powered by BI Documenter |
