D_CONFIG_LOGICAL_AREA

Version: 1.0

Attribute details

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