Sold by employee tag dimension table
bi_dimsoldbyemptag
Field | Description | Field Type | Primary Key |
|---|---|---|---|
acceptedtandc | integer | ||
additionalfield1 | varchar ( 8000 ) | ||
additionalfield2 | varchar ( 8000 ) | ||
address1 | varchar ( 65535 ) | ||
address2 | varchar ( 65535 ) | ||
anniversarydate | timestamp without time zone | ||
centerid | varchar ( 36 ) | ||
city | varchar ( 128 ) | ||
countrydname | varchar ( 4096 ) | ||
countrysname | varchar ( 4096 ) | ||
creationdt | timestamp without time zone | ||
ctetllastupdatedon | timestamp without time zone | ||
culturecode | varchar ( 4096 ) | ||
culturedispname | varchar ( 4096 ) | ||
customerapplogin | integer | ||
date1 | timestamp without time zone | ||
date2 | timestamp without time zone | ||
dob | timestamp without time zone | ||
dob_incompleteyear | varchar ( 20 ) | ||
varchar ( 512 ) | |||
emailstate | integer | ||
employeecode | varchar ( 512 ) | ||
employeetags | varchar ( 65535 ) | ||
emptags | text | ||
etllastupdatedby | varchar ( 50 ) | ||
etllastupdatedon | timestamp without time zone | ||
firstname | varchar ( 256 ) | ||
gender | integer | ||
guestreferralsource | varchar ( 3200 ) | ||
homecountrydname | varchar ( 4096 ) | ||
homecountrysname | varchar ( 4096 ) | ||
homephone | varchar ( 64 ) | ||
id | integer | ||
jobcode | varchar ( 8000 ) | ||
jobname | varchar ( 1020 ) | ||
langcode | varchar ( 4096 ) | ||
langdispname | varchar ( 4096 ) | ||
lastdate | timestamp without time zone | ||
lastlogin | timestamp without time zone | ||
lastname | varchar ( 256 ) | ||
mandatorybreaktimeperday | integer | ||
middlename | varchar ( 256 ) | ||
mobilecountrydname | varchar ( 4096 ) | ||
mobilecountrysname | varchar ( 4096 ) | ||
mobilephone | varchar ( 64 ) | ||
nationalityfk | integer | ||
nosalecomments | varchar ( 65535 ) | ||
organizationid | varchar ( 36 ) | ||
otherpreferences | varchar ( 65535 ) | ||
passwordupdatedon | timestamp without time zone | ||
phonecode | integer | ||
podname | varchar ( 20 ) | ||
preferedcenerid | varchar ( 36 ) | ||
preferredroom | varchar ( 36 ) | ||
preferredtherapist | varchar ( 36 ) | ||
receivemarketingemail | boolean | ||
receivemarketingsms | boolean | ||
receivetransactionalemail | boolean | ||
receivetransactionalsms | boolean | ||
referralsourceid | varchar ( 36 ) | ||
referredby | varchar ( 36 ) | ||
registrationsource | integer | ||
relationshipmanager | varchar ( 36 ) | ||
roomno | varchar ( 80 ) | ||
startdate | timestamp without time zone | ||
statecode | varchar ( 40 ) | ||
statedispname | varchar ( 4096 ) | ||
stateother | varchar ( 128 ) | ||
stateshortname | varchar ( 4096 ) | ||
unsubscribetomarketingemail | boolean | ||
unsubscribetotransactionalemail | boolean | ||
usercode | varchar ( 128 ) | ||
userid | varchar ( 36 ) | ||
username | varchar ( 512 ) | ||
userpk | numeric | ||
usertags | varchar ( 65535 ) | ||
usertypeid | varchar ( 36 ) | ||
usertypename | varchar ( 128 ) | ||
userwid | bigint | ||
void | boolean | ||
workcountrydname | varchar ( 4096 ) | ||
workcountrysname | varchar ( 4096 ) | ||
workphone | varchar ( 64 ) | ||
zipcode | varchar ( 128 ) |