Version: 1.0
Attribute ID | Datatype | Data length | Nullabe ? | Label | Description |
---|---|---|---|---|---|
ACCESS_TOKEN | VARCHAR2 | 80 | Y | Access token | |
ADDRESS_SALUTATION | VARCHAR2 | 100 | Y | Adress salutation | Polite salutation for the contact address. The value of the field is defined based on the "Title" field. |
BIRTHDATE | DATE | 7 | Y | Birth date | Date of birth |
BIRTH_CITY | VARCHAR2 | 400 | Y | City of birth | |
BIRTH_PROVINCE | VARCHAR2 | 400 | Y | Province of birth | |
CONTACT_LANGUAGE | VARCHAR2 | 20 | Y | Contact preferred language | |
COUNTRY_CODE | VARCHAR2 | 8 | Y | Country | Contact nationality in the form of a country code |
CREATED_FROM | VARCHAR2 | 100 | Y | Created from | User inserted |
DISABILITY_PROOF_PROVIDED | VARCHAR2 | 20 | Y | Flag indicating whether a disability proof has been provided | |
DTE_LOG_I | TIMESTAMP(6) WITH TIME ZONE | 13 | Y | Date-time of first insertion | |
VARCHAR2 | 1016 | Y | Contact email address | ||
EMAIL_VALIDATED | VARCHAR2 | 4 | Y | Flag indicating whether the email address has already been validated | |
EXTERNAL_CONTACT_NUMBER | VARCHAR2 | 400 | Y | Contact number in ticketing database | |
FIRSTNAME | VARCHAR2 | 400 | Y | Contact first name | |
ID_NUMBER | VARCHAR2 | 400 | Y | Number of contact's identity document | |
INSTIT_CODE | VARCHAR2 | 60 | Y | Institution code | |
INT_PREFIX_ALT_PHONE | VARCHAR2 | 40 | Y | Prefix of the contact′s alternate phone number | |
INT_PREFIX_CELLPHONE | VARCHAR2 | 40 | Y | Prefix of contact's mobile phone number | |
LASTNAME | VARCHAR2 | 400 | Y | Contact last name | |
LAST_UPDATE | TIMESTAMP(6) WITH TIME ZONE | 13 | Y | Date of last update of report data | |
LOCALITY | VARCHAR2 | 240 | Y | Area of the contact address | |
LOTTERY_CODE | VARCHAR2 | 120 | Y | Lottery where the user has registered | |
MAIN_ADDR_COUNTRY_CODE | VARCHAR2 | 8 | Y | Country code of contact address | |
MAIN_ADDR_LINE1 | VARCHAR2 | 400 | Y | First line of contact address | |
MAIN_ADDR_LINE2 | VARCHAR2 | 400 | Y | Second line of contact address | |
MAIN_ADDR_LINE3 | VARCHAR2 | 400 | Y | Third line of contact address | |
MAIN_ADDR_TOWN | VARCHAR2 | 400 | Y | Contact address town | |
MAIN_ADDR_ZIPCODE | VARCHAR2 | 80 | Y | Postal code of contact address | |
MOBILE_PHONE_NUMBER_VERIFIED | VARCHAR2 | 4 | Y | Flag indicating whether the mobile phone number has been verified | |
NAT_NUMBER_ALT_PHONE | VARCHAR2 | 80 | Y | Contact alternate phone number (including area prefix) | |
NAT_NUMBER_CELLPHONE | VARCHAR2 | 80 | Y | Contact mobile phone number (including area prefix) | |
OPTIN_EMAILS | VARCHAR2 | 4 | Y | Accepts marketing communication through emails | |
OPTIN_EMAILS_THIRD_PARTY | VARCHAR2 | 4 | Y | Accepts marketing communication from third parties | |
OPTIN_SMS | VARCHAR2 | 4 | Y | Accepts marketing communication through SMS | |
ROW_ID | NUMBER | 22 | Y | Technical identifier of row | |
SSO_ID | VARCHAR2 | 1008 | Y | SSO ID | |
TICKETING_EXPORT_DATE | DATE | 7 | Y | Date of export to the ticketing system | |
T_USER_ID | VARCHAR2 | 248 | N | Technical identifier of user | |
USER_NUMBER | VARCHAR2 | 80 | Y | User number |