Employee dimension table
Table Name | Column Name | Column Type | Primary Key |
|---|---|---|---|
Bi_DimEmployee_s3 | employeeuniqueid | VARCHAR(36) | PK |
Bi_DimEmployee_s3 | employeeid | VARCHAR(36) |
|
Bi_DimEmployee_s3 | firstname | NVARCHAR(160) |
|
Bi_DimEmployee_s3 | lastname | NVARCHAR(256) |
|
Bi_DimEmployee_s3 | middlename | NVARCHAR(128) |
|
Bi_DimEmployee_s3 | address1 | NVARCHAR(2048) |
|
Bi_DimEmployee_s3 | address2 | NVARCHAR(2048) |
|
Bi_DimEmployee_s3 | city | NVARCHAR(128) |
|
Bi_DimEmployee_s3 | StateOther | NVARCHAR(128) |
|
Bi_DimEmployee_s3 | ZipCode | NVARCHAR(128) |
|
Bi_DimEmployee_s3 | UserTypeID | VARCHAR(36) |
|
Bi_DimEmployee_s3 | UserTypeName | NVARCHAR(128) |
|
Bi_DimEmployee_s3 | CreationDt | TIMESTAMP |
|
Bi_DimEmployee_s3 | CenterID | VARCHAR(36) |
|
Bi_DimEmployee_s3 | NVARCHAR(256) |
| |
Bi_DimEmployee_s3 | homephone | NVARCHAR(64) |
|
Bi_DimEmployee_s3 | mobilephone | NVARCHAR(64) |
|
Bi_DimEmployee_s3 | workphone | NVARCHAR(64) |
|
Bi_DimEmployee_s3 | username | NVARCHAR(256) |
|
Bi_DimEmployee_s3 | usercode | NVARCHAR(512) |
|
Bi_DimEmployee_s3 | lastlogin | TIMESTAMP |
|
Bi_DimEmployee_s3 | gender | INT |
|
Bi_DimEmployee_s3 | dob | TIMESTAMP |
|
Bi_DimEmployee_s3 | preferredTherapist | VARCHAR(36) |
|
Bi_DimEmployee_s3 | preferredRoom | VARCHAR(36) |
|
Bi_DimEmployee_s3 | otherpreferences | NVARCHAR(65535) |
|
Bi_DimEmployee_s3 | referralsourceid | VARCHAR(36) |
|
Bi_DimEmployee_s3 | roomno | NVARCHAR(80) |
|
Bi_DimEmployee_s3 | referredby | VARCHAR(36) |
|
Bi_DimEmployee_s3 | anniversarydate | TIMESTAMP |
|
Bi_DimEmployee_s3 | PreferedCenerId | VARCHAR(36) |
|
Bi_DimEmployee_s3 | registrationsource | INT |
|
Bi_DimEmployee_s3 | customerapplogin | INT |
|
Bi_DimEmployee_s3 | cultureCode | NVARCHAR(4096) |
|
Bi_DimEmployee_s3 | cultureDispName | NVARCHAR(4096) |
|
Bi_DimEmployee_s3 | langCode | NVARCHAR(4096) |
|
Bi_DimEmployee_s3 | LangDispName | NVARCHAR(4096) |
|
Bi_DimEmployee_s3 | mobileCountryDName | NVARCHAR(4096) |
|
Bi_DimEmployee_s3 | mobileCountrySName | NVARCHAR(4096) |
|
Bi_DimEmployee_s3 | workCountryDName | NVARCHAR(4096) |
|
Bi_DimEmployee_s3 | workCountrySName | NVARCHAR(4096) |
|
Bi_DimEmployee_s3 | homeCountryDName | NVARCHAR(4096) |
|
Bi_DimEmployee_s3 | homeCountrySName | NVARCHAR(4096) |
|
Bi_DimEmployee_s3 | stateDispName | NVARCHAR(4096) |
|
Bi_DimEmployee_s3 | stateShortName | NVARCHAR(4096) |
|
Bi_DimEmployee_s3 | statecode | NVARCHAR(40) |
|
Bi_DimEmployee_s3 | CountryDName | NVARCHAR(4096) |
|
Bi_DimEmployee_s3 | CountrySName | NVARCHAR(4096) |
|
Bi_DimEmployee_s3 | ReceiveTransactionalSMS | BOOLEAN |
|
Bi_DimEmployee_s3 | ReceiveMarketingSMS | BOOLEAN |
|
Bi_DimEmployee_s3 | UserPK | DECIMAL(19,0) |
|
Bi_DimEmployee_s3 | UnSubscribeToTransactionalEmail | BOOLEAN |
|
Bi_DimEmployee_s3 | UnSubscribeToMarketingEmail | BOOLEAN |
|
Bi_DimEmployee_s3 | PasswordUpdatedOn | TIMESTAMP |
|
Bi_DimEmployee_s3 | ReceiveTransactionalEMail | BOOLEAN |
|
Bi_DimEmployee_s3 | ReceiveMarketingEMail | BOOLEAN |
|
Bi_DimEmployee_s3 | AcceptedTAndC | INT |
|
Bi_DimEmployee_s3 | NationalityFK | INT |
|
Bi_DimEmployee_s3 | DOB_IncompleteYear | NVARCHAR(20) |
|
Bi_DimEmployee_s3 | OrganizationID | VARCHAR(36) |
|
Bi_DimEmployee_s3 | JobCode | NVARCHAR(8000) |
|
Bi_DimEmployee_s3 | JobName | NVARCHAR(1020) |
|
Bi_DimEmployee_s3 | JobDesc | NVARCHAR(8000) |
|
Bi_DimEmployee_s3 | StartDate | TIMESTAMP |
|
Bi_DimEmployee_s3 | LastDate | TIMESTAMP |
|
Bi_DimEmployee_s3 | MandatoryBreakTimePerDay | INT |
|
Bi_DimEmployee_s3 | EmployeeCode | NVARCHAR(512) |
|
Bi_DimEmployee_s3 | PodName | VARCHAR(20) |
|
Bi_DimEmployee_s3 | Void | BOOLEAN |
|
Bi_DimEmployee_s3 | EtlLastUpdatedOn | TIMESTAMP |
|
Bi_DimEmployee_s3 | EtlLastUpdatedBy | NVARCHAR(50) |
|