DimCustomer.StateProvinceCode

Metadata hierarchy: MDWT_Adventure_Works_Demo » MDWT_AdventureWorksDW » DimCustomer

Attribute DimCustomer.StateProvinceCode

Property NameValue
DescriptionState or Province code
Display NameStateProvinceCode
ETL RulesJoin from Person.Address.StateProvinceId
Is Audit Subsystem
SCD Type2
Source Datatypenchar(3)
Source Field NameStateProvinceCode
Source SchemaPerson
Source SystemAW
Source TableAddress
Table Type
Used in schemas
View Name

Also Found In

  • A list tables where this item is also located can be found here.

    • More information about the source and ETL of this column can be found in:

  • Package: DimCustomer