D_LOTTERY_USERS

Version: 1.0

Attribute details

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

EMAIL VARCHAR2 1016 Y Email 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

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
EMAIL	VARCHAR2	1016	Y	Email	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