D_LOTTERY_GUESTS

Version: 1.0

Attribute details

Attribute ID Datatype Data length Nullabe ? Label Description
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
COUNTRY_CODE VARCHAR2 60 Y Country Contact nationality in the form of a country code
DISABILITY_PROOF_PROVIDED VARCHAR2 20 Y Flag indicating whether a disability proof has been provided
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
LASTNAME VARCHAR2 400 Y Contact last name
LAST_UPDATE TIMESTAMP(6) WITH TIME ZONE 13 Y Date of last update of report data
RESIDENCE_COUNTRY_CODE VARCHAR2 8 Y Code of residence country
TICKET_REQUEST_RANK NUMBER 22 Y Rank of current guest within a ticket request
TITLE VARCHAR2 100 Y Title
T_GUEST_ID VARCHAR2 248 N Technical identifier of guest
T_TICKET_REQUEST_ID VARCHAR2 248 Y Technical identifier of ticket request