DimEmployee.NationalIDNumber

Metadata hierarchy: MDWT_Adventure_Works_Demo » MDWT_AdventureWorksDW » DimEmployee

Attribute DimEmployee.NationalIDNumber

Property NameValue
CommentsTrack as Type 2 because source system doesn't do so
DescriptionNational ID Number (eg SSN) for employee
Display NameNationalIDNumber
ETL RulesStrip out all spaces and hyphens
Example Values112432117
Is Audit Subsystem
SCD Type2
Source Datatypenvarchar(15)
Source Field NameNationalIdNumber
Source SchemaHumanResources
Source SystemAW
Source TableEmployee
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: DimEmployee