Employee dimension table
bi_dimemployee
Field | Description | Field Type | Primary Key |
|---|---|---|---|
acceptedtandc | integer | ||
address1 | varchar ( 1024 ) | ||
address2 | varchar ( 1024 ) | ||
anniversarydate | timestamp without time zone | ||
centerwid | bigint | ||
city | varchar ( 512 ) | ||
countrydname | varchar ( 4096 ) | ||
countrysname | varchar ( 4096 ) | ||
creationdt | timestamp without time zone | ||
culturecode | varchar ( 4096 ) | ||
culturedispname | varchar ( 4096 ) | ||
customerapplogin | integer | ||
dob | timestamp without time zone | ||
dob_incompleteyear | varchar ( 80 ) | ||
varchar ( 1024 ) | |||
employeecode | varchar ( 128 ) | ||
employeeuniqueid | varchar ( 36 ) | ||
employeeuniquewid | bigint | ||
employeewid | bigint | ||
etllastupdatedby | ETL system admin user who inserted or updated the corresponding record in this table. | varchar ( 50 ) | |
etllastupdatedon | Latest timestamp at which the corresponding record was either inserted or updated in this table. | timestamp without time zone | |
firstname | varchar ( 640 ) | ||
gender | integer | ||
homecountrydname | varchar ( 4096 ) | ||
homecountrysname | varchar ( 4096 ) | ||
homephone | varchar ( 256 ) | ||
jobcode | varchar ( 8000 ) | ||
jobdesc | varchar ( 8000 ) | ||
jobname | varchar ( 1020 ) | ||
langcode | varchar ( 4096 ) | ||
langdispname | varchar ( 4096 ) | ||
lastdate | timestamp without time zone | ||
lastlogin | timestamp without time zone | ||
lastname | varchar ( 512 ) | ||
mandatorybreaktimeperday | integer | ||
middlename | varchar ( 512 ) | ||
mobilecountrydname | varchar ( 4096 ) | ||
mobilecountrysname | varchar ( 4096 ) | ||
mobilephone | varchar ( 256 ) | ||
nationalityfk | integer | ||
organizationid | varchar ( 36 ) | ||
otherpreferences | varchar ( 32000 ) | ||
passwordupdatedon | timestamp without time zone | ||
podid | integer | ||
podname | varchar ( 20 ) | ||
preferedcenerid | varchar ( 36 ) | ||
preferredroom | varchar ( 36 ) | ||
preferredtherapist | varchar ( 36 ) | ||
receivemarketingemail | Flag that indicates whether the guest opted for marketing emails. - True: Opted - False: Not opted | boolean | |
receivemarketingsms | boolean | ||
receivetransactionalemail | Flag that indicates whether the guest opted for transactional emails. - True: Opted - False: Not opted | boolean | |
receivetransactionalsms | boolean | ||
referralsourceid | varchar ( 36 ) | ||
referredby | varchar ( 36 ) | ||
registrationsource | integer | ||
roomno | varchar ( 320 ) | ||
startdate | timestamp without time zone | ||
statecode | varchar ( 160 ) | ||
statedispname | varchar ( 4096 ) | ||
stateother | varchar ( 512 ) | ||
stateshortname | varchar ( 4096 ) | ||
unsubscribetomarketingemail | boolean | ||
unsubscribetotransactionalemail | boolean | ||
usercode | varchar ( 512 ) | ||
username | varchar ( 1024 ) | ||
userpk | numeric | ||
usertypeid | varchar ( 36 ) | ||
usertypename | varchar ( 512 ) | ||
void | boolean | ||
workcountrydname | varchar ( 4096 ) | ||
workcountrysname | varchar ( 4096 ) | ||
workphone | varchar ( 256 ) | ||
zipcode | varchar ( 128 ) |