Version: 1.0
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 |