Integration.Employee_Staging
Documentation | WideWorldImportersDW |
Schema | Integration |
Name | Employee_Staging |
Employee staging table
Columns
Key | Name | Data type | Null | Attributes | References | Description | ||
---|---|---|---|---|---|---|---|---|
1 | Employee Staging Key | int | Identity | Row ID within the staging table | ||||
Row ID within the staging table Identity |
||||||||
2 | WWI Employee ID | int | Numeric ID (PersonID) in the WWI database | |||||
Numeric ID (PersonID) in the WWI database |
||||||||
3 | Employee | nvarchar(50) | Full name for this person | |||||
Full name for this person |
||||||||
4 | Preferred Name | nvarchar(50) | Name that this person prefers to be called | |||||
Name that this person prefers to be called |
||||||||
5 | Is Salesperson | bit | Is this person a staff salesperson? | |||||
Is this person a staff salesperson? |
||||||||
6 | Photo | varbinary(MAX) | Photo of this person | |||||
Photo of this person |
||||||||
7 | Valid From | datetime2(7) | Valid from this date and time | |||||
Valid from this date and time |
||||||||
8 | Valid To | datetime2(7) | Valid until this date and time | |||||
Valid until this date and time |
Unique keys
Key name | Columns | Description | |
---|---|---|---|
PK_Integration_Employee_Staging | Employee Staging Key | Primary key (nonclustered) constraint. | |
Primary key (nonclustered) constraint. |
Exported: 2019-02-04 23:05, Last imported: 2018-08-10 09:59