| key |
id |
string(500)* |
= |
The id field uniquely identifies the entity record. It's equivalent to the professionalId |
| timeline |
updDate |
dateTime* |
=< >= |
Last modification date and time |
|
ciqCompanyId |
long |
|
CIQ Identifier for a company |
| link |
company |
Company |
|
CIQ Identifier for a company; Foreign key that links to Company Entity |
|
companyName |
string(800) |
|
Company name |
|
country |
string(2) |
|
The country or territory of the registered company, 2 Char ISO code. |
|
courtesy |
string(40) |
|
Courtesy of professional |
|
dateOfBirth |
date |
|
Date of birth of the professional |
|
deceasedDate |
date |
|
Date when professional deceased |
|
email |
string(500) |
|
Email of professional |
|
endDate |
date |
|
Date when professional ended in this role |
|
firstName |
string(400) |
|
First name of professional |
|
gender |
string(100) |
|
Gender of professional |
|
jobTitle |
string(1000) |
|
SME Professional Title |
|
keyMINameSpace |
long |
|
MI Name Space |
|
lastName |
string(400) |
|
Last name of professional |
|
middleName |
string(400) |
|
Middle name of professional |
|
personAddress |
string(1600) |
|
Address of the professional |
|
personCountry |
string(2) |
|
The country or territory of the professional. |
|
personPostalCode |
string(50) |
|
Zip code of professional's address |
|
registrationNumber |
string(1000) |
|
Unique personal identifier, as provided by national registeries |
|
startDate |
date |
|
Date when professional started in this role |
|
suffix |
string(40) |
|
Suffix used by professional |
|
suffixTitle |
string(200) |
|
Suffix title of professional |
|
updOperation |
long |
|
Indicates whether the row is new, updated, or (logically) deleted i.e. 0=new, 1=updated, 2=deleted |
|
vendorId |
string(50) |
|
Vendor identifier |
|
verifiedDate |
date |
|
Date on which CreditSafe got the data updated from the government website |