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) |