Version: 1.0
Attribute ID | Datatype | Data length | Nullabe ? | Label | Description |
---|---|---|---|---|---|
AREA | VARCHAR2 | 240 | Y | Area | Area name |
AREA_CODE | VARCHAR2 | 32 | Y | Area code | Area code |
AREA_TYPE | VARCHAR2 | 20 | Y | Area type: - Numbered seat - Not numbred seat - Not numbered standing |
|
ENTRANCE | VARCHAR2 | 240 | Y | Entrance | Entrance name |
FROZEN_INVALID_NB | NUMBER | 22 | Y | Freezed invalid number | |
INSTIT_CODE | VARCHAR2 | 15 | N | Institution code | |
INVALID_NB | NUMBER | 22 | Y | Invalid number | |
LAST_UPDATE | TIMESTAMP(6) WITH TIME ZONE | 13 | Y | Date of last update of report data | |
LOGAREA_ID | NUMBER | 22 | N | Technical identifier of the logical seat | |
LOGCONFIG_ID | NUMBER | 22 | Y | Technical identifier of performance logical configuration | |
LOGICAL_SEAT_CATEGORY | VARCHAR2 | 240 | Y | Logical seat category | Name of logical seat category |
MAX_CAPACITY | NUMBER | 22 | Y | Maximum of capacity | |
PHYAREA_ID | NUMBER | 22 | N | Technical identifier of physical area | |
PHYCONFIG_ID | NUMBER | 22 | Y | Technical identifier of physical configuration | |
SEAT_CATEGORY | VARCHAR2 | 32 | Y | Seat category | Seat category name |
SECTOR | VARCHAR2 | 240 | Y | Sector | Name of sector in which an area is located |
TIME_ZONE | VARCHAR2 | 40 | Y | Time zone of the organization | |
T_ENTRANCE_ID | NUMBER | 22 | Y | Technical identifier of entrance to be used to reach an area or a set of seats | |
T_LOG_SEAT_CAT_ID | NUMBER | 22 | Y | Technical identifier of logical seat category | |
T_SEAT_CAT_ID | NUMBER | 22 | Y | Seat category technical identifier |