|
|
||||||
|
|
||||||
Properties
| Property | Value |
| Table Name | dbo_DimZipCounty |
| Database Table Name | DimZipCounty |
| Schema | dbo |
| Friendly Name | DimZipCounty |
| Table Type | Table |
| Query Definition | |
| Description |
Columns
Column Name |
Friendly Name |
Data Type |
Computed Column Expression |
Description |
|
 |
ZipCountySK |
ZipCountySK |
System.Int32 | ||
 |
ZipCodeAK |
ZipCodeAK |
System.String(5) | ||
|
ZipCode |
ZipCode |
System.String(5) | ||
|
CountyFIPS |
CountyFIPS |
System.String(5) | ||
|
County |
County |
System.String(45) | ||
|
City |
City |
System.String(35) | ||
|
State |
State |
System.String(3) | ||
|
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 |
ZipCountySK |
FactPurchaseOrderAmounts |
Table |
False |
||
ZipCountySK |
FactPayableAmounts |
Table |
False |
| Powered by BI Documenter |
