This chapter describes the data Flow between the fact tables of Oracle Airlines Data Model.
This chapter includes the following sections:
For more information, see Chapter 8, "Oracle Airlines Data Model OLAP Model Cubes".
Oracle Airlines Data Model contains low level combination of base tables and summary, average, and so on, of Base and Derived data. Each dimension includes the following information:
Levels
Hierarchies
Attributes and Attribute mappings
Table 7-1 lists the Dimension tables.
Table 7-2 briefly describes all the information of the Booking Class Dimension.
Table 7-2 Booking Class (BKCLS) Levels and Hierarchies
| Level | Description | Booking Class Hierarchy (HBKCLS) |
|---|---|---|
|
TBKCLS |
Total Booking Class |
TBKCLS |
|
SVCLS |
Service Class |
SVCLS |
|
BKCLS |
Booking Class |
BKCLS |
Attribute Name: Long Description (LONG_DESCRIPTION)
Table 7-3 Booking Class Long Description Attribute Mapping
| Level | Mapping (Physical Column) |
|---|---|
|
TBKCLS |
Total Booking Class |
|
SVCLS |
DWR_BKG_CLS_TYP.SRVC_CLS_DSCR |
|
BKCLS |
DWR_BKG_CLS_TYP.SRVC_CLS_DSCR |
Attribute Name: Short Description (SHORT_DESCRIPTION)
Table 8-3 briefly describes all the information of the Booking Office Dimension.
Table 7-5 Booking Office (HBKOFC) Levels and Hierarchies
| Levels | Description | Booking Office Hierarchy (HBKOFC) | Channel Type Hierarchy (HCNTYP) |
|---|---|---|---|
|
TBKOFC |
Total Booking Office |
TBKOFC |
TBKOFC |
|
ACNTNT |
Agent Continent |
ACNTNT |
|
|
ACUNTRY |
Agent Country |
ACUNTRY |
|
|
ARGN |
Agent Region |
ARGN |
|
|
ACITY |
Agent City |
ACITY |
|
|
BKOFC |
Booking Office |
BKOFC |
|
|
CNTYP |
Channel Type |
CNTYP |
|
|
AGNT |
Agent |
AGNT |
AGNT |
Attribute Name: Long Description (LONG_DESCRIPTION)
Table 7-6 Booking Office HBKOFC Long Description Attribute Mapping
| Levels | Mapping (Physical Column) |
|---|---|
|
TBKOFC |
Total Booking Office |
|
ACNTNT |
DWR_BKG_OFFC.AGNT_CONT |
|
ACUNTRY |
DWR_BKG_OFFC.AGNT_CTRY |
|
ARGN |
DWR_BKG_OFFC.AGNT_REGN |
|
ACITY |
DWR_BKG_OFFC.AGNT_CITY |
|
BKOFC |
DWR_BKG_OFFC.OFF_NM |
|
AGNT |
DWR_BKG_OFFC.AGNT_NM |
Attribute Name: Short Description (SHORT_DESCRIPTION)
Table 7-7 Booking Office HBKOFC Short Description Attribute Mapping
| Level | Mapping (Physical Column) |
|---|---|
|
TBKOFC |
Total Booking Office |
|
ACNTNT |
DWR_BKG_OFFC.AGNT_CONT_CD |
|
ACUNTRY |
DWR_BKG_OFFC.AGNT_CTRY_CD |
|
ARGN |
DWR_BKG_OFFC.AGNT_REGN_CD |
|
ACITY |
DWR_BKG_OFFC.AGNT_CITY_CD |
|
BKOFC |
DWR_BKG_OFFC.OFF_NM |
|
AGNT |
DWR_BKG_OFFC.AGNT_NM |
Attribute Name: Agent Status (ASTUS)
Table 7-8 Booking Office HBKOFC Agent Status Attribute Mapping
| Level | Mapping (Physical Column) |
|---|---|
|
TBKOFC |
|
|
ACNTNT |
|
|
ACUNTRY |
|
|
ARGN |
|
|
ACITY |
|
|
BKOFC |
|
|
AGNT |
DWR_BKG_OFFC.STAT_CD |
Attribute Name: Agent Name (ANM)
Table 7-9 Booking Office HBKOFC Agent Name Attribute Mapping
| Level | Mapping (Physical Column) |
|---|---|
|
TBKOFC |
|
|
ACNTNT |
|
|
ACUNTRY |
|
|
ARGN |
|
|
ACITY |
|
|
BKOFC |
|
|
AGNT |
DWR_BKG_OFFC.AGNT_NM |
Attribute Name: Agent IATA Code (AITCD)
Table 7-10 Booking Office HBKOFC Agent IATA Code Attribute Mapping
| Level | Mapping (Physical Column) |
|---|---|
|
TBKOFC |
|
|
ACNTNT |
|
|
ACUNTRY |
|
|
ARGN |
|
|
ACITY |
|
|
BKOFC |
|
|
AGNT |
DWR_BKG_OFFC.IATA_CD |
Attribute Name: Long Description (LONG_DESCRIPTION)
Table 7-11 Booking Office HCNTYP Long Description Mapping
| Level | Mapping (Physical Column) |
|---|---|
|
TBKOFC |
Total Booking Office |
|
CNTYP |
DWR_BKG_OFFC.CHNL_TYP |
|
AGNT |
DWR_BKG_OFFC.AGNT_NM |
Attribute Name: Short Description (SHORT_DESCRIPTION)
Table 7-12 Booking Office HCNTYP Short Description Mapping
| Level | Mapping (Physical Column) |
|---|---|
|
TBKOFC |
Total Booking Office |
|
CNTYP |
DWR_BKG_OFFC.CHNL_TYP |
|
AGNT |
DWR_BKG_OFFC.AGNT_NM |
Attribute Name: Agent IATA Code (AITCD))
Table 7-13 Booking Office HCNTYP IATA Code Attribute Mapping
| Level | Mapping (Physical Column) |
|---|---|
|
TBKOFC |
|
|
CNTYP |
|
|
AGNT |
DWR_BKG_OFFC.IATA_CD |
Attribute Name: Agent Name (ANM)
Table 7-14 Booking Office HCNTYP Agent Name Attribute Mapping
| Level | Mapping (Physical Column) |
|---|---|
|
TBKOFC |
|
|
CNTYP |
|
|
AGNT |
DWR_BKG_OFFC.AGNT_NM |
Attribute Name: Agent Status (ASTUS)
Table 8-4 briefly describes all the information of the Geography Dimension.
Table 7-16 Geography (HGEO) Levels and Hierarchies
| Level | Description | Geography Hierarchy (HGEO) |
|---|---|---|
|
TGEO |
Total Geography |
TGEO |
|
CONT |
Continent |
CONT |
|
COUNTRY |
Country |
COUNTRY |
|
CITY |
City |
CITY |
Attribute Name: Long Description (LONG_DESCRIPTION)
Table 7-17 Geography Long Description Attribute Mapping
| Level | Mapping (Physical Column) |
|---|---|
|
TGEO |
Total Geography |
|
CONT |
DWR_GEO.CONTINENT_NAME |
|
COUNTRY |
DWR_GEO.CNTRY_NAME |
|
CITY |
DWR_GEO.CITY_NAME |
Attribute Name: Short Description (SHORT_DESCRIPTION)
Table 8-5 briefly describes all the information of the Interaction Reason Dimension.
Table 7-19 Interaction Reason (HIRSN) Levels and Hierarchies
| Level | Description | Interaction Reason Hierarchy (HIRSN) |
|---|---|---|
|
TIRSN |
Total Interaction Reason |
TIRSN |
|
IRSN |
Interaction Reason |
IRSN |
Attribute Name: Long Description (LONG_DESCRIPTION)
Table 7-20 Interaction Reason Long Description Attribute Mapping
| Level | Mapping (Physical Column) |
|---|---|
|
TIRSN |
Total Interaction Reason |
|
IRSN |
DWR_INTRACN_RSN. INTRACN_RSN_NAME |
Attribute Name: Short Description (SHORT_DESCRIPTION)
Table 8-6 briefly describes all the information of the Loyalty Level Dimension.
Table 7-22 Loyalty Level (HLOYLY) Levels and Hierarchies
| Level | Description | Loyalty Level Hierarchy (HLOYLY) |
|---|---|---|
|
TLOYLY |
Total Loyalty Level |
TLOYLY |
|
LOYLY |
Loyalty Level |
LOYLY |
Attribute Name: Long Description (LONG_DESCRIPTION)
Table 7-23 Loyalty Level Long Description Attribute Mapping
| Level | Mapping (Physical Column) |
|---|---|
|
TLOYLY |
Total Loyalty Level |
|
LOYLY |
DWR_LYLTY_LVL. LYLTY_LVL_NAME |
Attribute Name: Short Description (SHORT_DESCRIPTION)
Table 7-24 Loyalty Level Short Description Attribute Mapping
| Level | Mapping (Physical Column) |
|---|---|
|
TLOYLY |
Total Loyalty Level |
|
LOYLY |
DWR_LYLTY_LVL. LYLTY_LVL_NAME |
Attribute Name: Level Qualifying Start Points (LVL_STPN)
Table 8-7 briefly describes all the information of the Operating Flight Dimension.
Table 7-26 Operating Flight (OPFLT) Levels and Hierarchies
| Level | Description | Operating Flight Hierarchy (HOPFLT) |
|---|---|---|
|
TOPFLT |
Total Operating Flight |
TOPFLT |
|
OPFLT |
Operating Flight |
OPFLT |
Attribute Name: Long Description (LONG_DESCRIPTION)
Table 7-27 Operating Flight Long Description Attribute Mapping
| Level | Mapping (Physical Column) |
|---|---|
|
TOPFLT |
Total Operating Flight |
|
OPFLT |
DWR_FLT.FLT_TXT_DSCR |
Attribute Name: Short Description(SHORT_DESCRIPTION)
Table 8-8 briefly describes all the information of the Operating Segment Dimension.
Table 7-29 Operating Segment (OPSMT) Levels and Hierarchies
| Level | Description | Operating Segment Hierarchy (HOPSMT) |
|---|---|---|
|
TOPSMT |
Total Operating Segment |
TOPSMT |
|
TFRGN |
Traffic Region |
TFRGN |
|
OPSMT |
Operating Segment |
OPSMT |
Attribute Name: Long Description (LONG_DESCRIPTION)
Table 7-30 Operating Segment Long Description Attribute Mapping
| Level | Mapping (Physical Column) |
|---|---|
|
TOPSMT |
Total Operating Segment |
|
TFRGN |
DWR_SEG.OFPNT_CONT |
|
OPSMT |
DWR_SEG.OFPNT_AIP_NM |
Attribute Name: Short Description (SHORT_DESCRIPTION)
Table 7-31 Operating Segment Short Description Attribute Mapping
| Level | Mapping (Physical Column) |
|---|---|
|
TOPSMT |
Total Operating Segment |
|
TFRGN |
DWR_SEG. OFFPOINT_CONTINENT |
|
OPSMT |
DWR_SEG. BRD_ARPRT_NAME |
Attribute Name: Segment Pair (SEG_PAIR)
Table 8-9 briefly describes all the information of the Route Dimension.
Table 7-33 Route (ROUTE) Levels and Hierarchies
| Level | Description | Route Hierarchy (HROUTE) |
|---|---|---|
|
TROUTE |
Total Route |
TROUTE |
|
ROUTE |
Route |
ROUTE |
Attribute Name: Long Description (LONG_DESCRIPTION)
Table 7-34 Route Long Description Attribute Mapping
| Level | Mapping (Physical Column) |
|---|---|
|
TROUTE |
Total Route |
|
ROUTE |
ROUTE LD |
Attribute Name: Short Description (SHORT_DESCRIPTION)
Table 8-10 briefly describes all the information of the Service Dimension.
Table 7-36 Service (SRVC) Levels and Hierarchies
| Level | Description | Service Hierarchy (HSRVC) |
|---|---|---|
|
SVTYP |
Service Type |
SVTYP |
|
SRVC |
Service |
SRVC |
Attribute Name: Long Description (LONG_DESCRIPTION)
Table 7-37 Service Long Description Attribute Mapping
| Level | Mapping (Physical Column) |
|---|---|
|
SVTYP |
DWR_SRVC. SRVC_NAME |
|
SRVC |
DWR_SRVC. SRVC_TYP_DSCR |
Attribute Name: Short Description (SHORT_DESCRIPTION)
Table 8-11 briefly describes all the information of the Time Dimension.
Table 7-39 Time (TIME) Levels and Hierarchies
| Level | Description | Time Hierarchy (HTIME) |
|---|---|---|
|
TIME |
Total Time |
TIME |
|
YEAR |
Year |
YEAR |
|
HLFY |
Half Year |
HLFY |
|
QTR |
Quarter |
QTR |
|
MONTH |
Month |
MONTH |
|
WEEK |
Week |
WEEK |
|
DAY |
Day |
DAY |
Attribute Name: Long Description (LONG_DESCRIPTION)
Table 7-40 Time Long Description Attribute Mapping
| Level | Mapping (Physical Column) |
|---|---|
|
TIME |
Total Time |
|
YEAR |
DWR_CLNDR.CLNDR_YR_DSCR |
|
HLFY |
DWR_CLNDR.CLNDR_HLF_YR_DSCR |
|
QTR |
DWR_CLNDR.CLNDR_QTR |
|
MONTH |
DWR_CLNDR.CLNDR_MO_NM |
|
WEEK |
DWR_CLNDR.CLNDR_WK_DSCR |
|
DAY |
DWR_CLNDR.CLNDR_DT_DSCR |
Attribute Name: Short Description (SHORT_DESCRIPTION)
Table 7-41 Time Short Description Attribute Mapping
| Level | Mapping (Physical Column) |
|---|---|
|
TIME |
Total Time |
|
YEAR |
DWR_CLNDR.CLNDR_YR_CD |
|
HLFY |
DWR_CLNDR.CLNDR_HLF_YR_CD |
|
QTR |
DWR_CLNDR.CLNDR_QTR_CD |
|
MONTH |
DWR_CLNDR.CLNDR_MO_CD |
|
WEEK |
DWR_CLNDR.CLNDR_WK_CD |
|
DAY |
DWR_CLNDR.CLNDR_DT_DSCR |
Attribute Name: End Date (END_DATE)
Table 7-42 Time End Date Attribute Mapping
| Level | Mapping (Physical Column) |
|---|---|
|
TIME |
DWR_CLNDR.CLNDR_YR_END_DT |
|
YEAR |
DWR_CLNDR.CLNDR_YR_END_DT |
|
HLFY |
DWR_CLNDR.CLNDR_HLF_YR_END_DT |
|
QTR |
DWR_CLNDR.CLNDR_QTR_END_DT |
|
MONTH |
DWR_CLNDR.CLNDR_MO_END_DT |
|
WEEK |
DWR_CLNDR.CLNDR_WK_END_DT |
|
DAY |
DWR_CLNDR.CLNDR_DT |
Attribute Name: Time Span (TIME_SPAN)
Table 7-43 Time Span Attribute Mapping
| Level | Mapping (Physical Column) |
|---|---|
|
TIME |
DWR_CLNDR.CLNDR_YR_TIMESPN |
|
YEAR |
DWR_CLNDR.CLNDR_YR_TIMESPN |
|
HLFY |
DWR_CLNDR.CLNDR_HLF_YR_TIMESPN |
|
QTR |
DWR_CLNDR.CLNDR_QTR_TIMESPN |
|
MONTH |
DWR_CLNDR.CLNDR_MO_TIMESPN |
|
WEEK |
DWR_CLNDR.CLNDR_WK_TIMESPN |
|
DAY |
1 |
Attribute Name: Calendar Week Number In Year (CWIY)
Table 7-44 Time Calendar Week Number in Year Attribute Mapping
| Level | Mapping (Physical Column) |
|---|---|
|
TIME |
|
|
YEAR |
|
|
HLFY |
|
|
QTR |
|
|
MONTH |
|
|
WEEK |
DWR_CLNDR.CLNDR_WK_NBR_IN_YR |
|
DAY |
DWR_CLNDR.CLNDR_WK_NBR_IN_YR |
Attribute Name: Day of Week Number (DOWN)
Table 7-45 Time Day of Week Number Attribute Mapping
| Level | Mapping (Physical Column) |
|---|---|
|
TIME |
|
|
YEAR |
|
|
HLFY |
|
|
QTR |
|
|
MONTH |
|
|
WEEK |
|
|
DAY |
DWR_CLNDR.DAY_OF_WK_NBR |
Attribute Name: Day of Week Name (DOWNM)