3 Oracle Airlines Data Model Physical Data Model

This chapter provides information about the physical data model of Oracle Airlines Data Model.

This chapter includes the following sections:

• Introduction to Oracle Airlines Data Model Physical Data Model

• Reference Tables

• Base Tables

• Derived Tables

• Aggregate Tables

• Lookup Tables

• Mining Tables

• Database Sequences

• Metadata Tables

• Oracle Airlines Data Model OLAP Cube MV, Cube View

Introduction to Oracle Airlines Data Model Physical Data Model

The Physical Data Model of the Oracle Airlines Data Model is the physical manifestation of the logical data model into database tables and relationships (or foreign key constraints). Partitions and Materialized Views have been added to aid performance.

Important:

Do not make changes to the schemas as such changes are not supported.

Table 3-1 shows the table name prefix conventions. When you examine the predefined physical model, keep in mind the naming conventions shown in Table 3-1 that use DW (Data Warehouse) prefixes to identify the types of tables and views.

Table 3-1 Table Name Prefix and Suffix Conventions

Prefix	Description
CB$	Materialized view of an OLAP cube. This materialized view is automatically created by the OLAP server. Note: Do not report or query against this object. Instead access the corresponding _VIEW object.
DM_	Data Mining Settings
DMV_	Materialized views used for as the source data of data mining model
DWA_	Aggregate tables
DWB_	Base transaction data (3NF) tables
DWC_	Control tables
DWD_	Derived table (including data mining result tables)
DWL_	Lookup tables
DWL_	Lookup table
DWR_	Reference data tables used as dimension tables in a foundation layer fact table (that is, for a DWB_ table)
DWV_	Relational view of time dimension
_VIEW	Suffix specifies relational views of OLAP cubes, dimensions, or hierarchies.

Reference Tables

In the Oracle Airlines Data Model foundation layer, DWR_ tables (also known as reference tables) act as dimension tables to the base (DWB_ ) tables.

Table 3-2 lists the Reference tables in Oracle Airlines Data Model.

Table 3-2 Reference Tables

Table Name	Description and More information
DWR_ACCT	ACCOUNT
DWR_ACCT_DIM	ACCOUNT
DWR_ADDR_LOC	ADDRESS LOCATION
DWR_ADDR_LOC_STAT_HIST	ADDRESS LOCATION STATUS HISTORY
DWR_ADDR_RLTD	ADDRESS RELATED
DWR_AGNCY	AGENCY
DWR_ARCFT	AIRCRAFT
DWR_ARCFT_TYP	AIRCRAFT TYPE
DWR_ARCFT_VRSN	AIRCRAFT VERSION
DWR_ARCFT_VRSN_DIM	AIRCRAFT VERSION
DWR_ARPRT	AIRPORT
DWR_ARPRT_DIM	AIRPORT
DWR_BASE_DAY	BASE DAY
DWR_BKG_CLS	BOOKING CLASS
DWR_BKG_CLS_TYP	BOOKING CLASS TYPE
DWR_BKG_CUST_REF	HOTEL BOOKING CUSTOMER REFERENCE
DWR_BKG_OFFC	BOOKING OFFICE
DWR_BKG_OFFC_DIM	BOOKING OFFICE
DWR_BKG_OFFC_USER	BOOKING OFFICE USER
DWR_BKG_PROD	BOOKING PRODUCT
DWR_BKG_PROD_DTL	BOOKING PRODUCT DETAIL
DWR_BKG_PAX	BOOKING PASSENGER
DWR_BKG_PAX_DIM	BOOKING PASSENGER
DWR_BKG_PAX_DOC_INFO	BOOKING PASSENGER DOCUMENT INFORMATION
DWR_BKG_SEAT	BOOKING SEAT
DWR_BKG_SEAT_PREF	BOOKING SEAT PREFERENCE
DWR_BKG_SRIS	BOOKING SERIES
DWR_BKG_SVNG_AMT	HOTEL BOOKING SAVING AMOUNT
DWR_BKG_TST_DIM
DWR_BLK_LST_HIST	BLACK LIST HISTORY
DWR_BNK	BANK
DWR_BNK_CARD	BANK CARD
DWR_BSNS_HLF_MO	BUSINESS HALF MONTH
DWR_BSNS_HLF_YR	BUSINESS HALF YEAR
DWR_BSNS_MO	BUSINESS MONTH
DWR_BSNS_MO_DIM
DWR_BSNS_QTR	BUSINESS QUARTER
DWR_BSNS_TEN_DAYS_CYCL
DWR_BSNS_UNIT_JB_RL	BUSINESS UNIT JOB ROLE
DWR_BSNS_UNIT_SHFT	BUSINESS UNIT SHIFT
DWR_BSNS_YR	BUSINESS YEAR
DWR_CALL_CNTR	CALL CENTER
DWR_CALL_CNTR_AGNT	CALL CENTER AGENT
DWR_CALL_CNTR_SRVC_CAPBLTY	CALL CENTER SERVICE CAPABILITY
DWR_CARRIER	CARRIER
DWR_CARRIER_DIM	CARRIER
DWR_CARRIER_TYP	CARRIER TYPE
DWR_CAR_PROD	CAR PRODUCT
DWR_CAR_RNTL_MDL	CAR RENTAL MODEL
DWR_CDSHR	CODESHARE
DWR_CHKIN_BAG_GRP	CHECKIN BAGGAGE GROUP
DWR_CHKIN_INDVL_BAG	CHECKIN INDIVIDUAL BAGGAGE
DWR_CHNL	CHANNEL
DWR_CLNDR	CALENDAR
DWR_CLNDR_HLF_MO	CALENDAR HALF MONTH
DWR_CLNDR_HLF_YR	CALENDAR HALF YEAR
DWR_CLNDR_QTR	CALENDAR QUARTER
DWR_CLNDR_MO	CALENDAR MONTH
DWR_CLNDR_WK	CALENDAR WEEK
DWR_CLNDR_YR	CALENDAR YEAR
DWR_CMPGN	CAMPAIGN
DWR_CMPGN_MEDIA_SLNG_ITEM	CAMPAIGN MEDIA SELLING ITEM
DWR_CMPGN_MGMT_HIST	CAMPAIGN MANAGEMENT HISTORY
DWR_CMPGN_MSG	CAMPAIGN MESSAGE
DWR_CMPTR	COMPETITOR
DWR_CMPTR_INTLGNCE	COMPETITOR INTELLIGENCE
DWR_CMPTR_INTLGNCE_PRTY_RL	COMPETITOR INTELLIGENCE PARTY ROLE
DWR_CMPTR_MKT_SEG_ASGN	COMPETITOR MARKET SEGMENT ASSIGNMENT
DWR_CMPTR_MKT_SEG_SWOT	COMPETITOR MARKET SEGMENT SWOT
DWR_CMPTR_PROD_CRLTN	COMPETITOR PRODUCT CORRELATION
DWR_CMPTR_SWOT	COMPETITOR SWOT
DWR_CMPTR_TIER_ASGN	COMPETITOR TIER ASSIGNMENT
DWR_CMPTVE_TIER	COMPETITIVE TIER
DWR_COMP_INTL_CHR	COMP INTEL CHARACTERISTIC
DWR_COMP_INTL_CHR_VAL	COMP INTEL CHARACTERISTIC VALUE
DWR_COMP_INTL_MKT_SEG	COMP INTEL MARKET SEGMENT
DWR_COMP_PROD_CRRL_CHR_ASGN	COMP PROD CRRL CHARACTERISTIC ASSIGNMENT
DWR_COMP_PROD_CRRL_CHR_VAL	COMP PROD CRRL CHARACTERISTIC VALUE
DWR_CRDT_SCR_PRVDR	CREDIT SCORE PROVIDER
DWR_CRPRT_BSNS_TYP
DWR_CRPRT_CUST	CORPORATE CUSTOMER
DWR_CRTFCT	CERTIFICATE
DWR_CST_CNTR	COST CENTER
DWR_CUST	CUSTOMER
DWR_CUST_INDVL	CUSTOMER INDIVIDUAL
DWR_CUST_OCCSN	CUSTOMER OCCASION
DWR_CUST_ORG	CUSTOMER ORGANIZATION
DWR_CUST_RSTRCT_INFO	CUSTOMER RESTRICTED INFO
DWR_CUST_RVN_BND_ASGN	CUSTOMER REVENUE BAND ASSIGNMENT
DWR_CUST_SCR	CUSTOMER SCORE
DWR_CUST_SEG	CUSTOMER SEGMENT
DWR_CUST_SEGTN_MDL	CUSTOMER SEGMENTATION MODEL
DWR_CUST_SRC	CUSTOMER SOURCE
DWR_DAY	DAY
DWR_DAY_ACT_CNDTN
DWR_DAY_TODATE_TRANS
DWR_DAY_TRANS
DWR_DEMOG_ATRIB	DEMOGRAPHY ATTRIBUTE
DWR_DEMOG_GRP	DEMOGRAPHY GROUP
DWR_DISC_GRP	DISCOUNT GROUP
DWR_DLR	DEALER
DWR_DRVR_VAL	DERIVED VALUE
DWR_EDU	EDUCATION
DWR_EML_ADDR	EMAIL ADDRESS
DWR_EMP	EMPLOYEE
DWR_EMP_DISC_GRP_ASGN	EMPLOYEE DISCOUNT GROUP ASSIGNMENT
DWR_EMP_JB_RL_ASGN	EMPLOYEE JOB ROLE ASSIGNMENT
DWR_EMP_LANG_CAPBLTY	EMPLOYEE LANGUAGE CAPABILITY
DWR_EMP_RSTRCT_INFO	EMPLOYEE RESTRICTED INFO
DWR_EMP_SCHL	EMPLOYEE SCHEDULE
DWR_EXTRNL_CRDT_PRFL	EXTERNAL CREDIT PROFILE
DWR_EXTRNL_CRDT_PRFL_ASGN	EXTERNAL CREDIT PROFILE ASSIGNMENT
DWR_FARE_ELMNT	FARE ELEMENT
DWR_FARE_TYP	FARE TYPE
DWR_FLT	FLIGHT
DWR_FLT_DIM	FLIGHT
DWR_FLT_INV	FLIGHT INVENTORY
DWR_FLT_INV_NBR_OF_UNITS	FLIGHT INVENTORY NUMBER OF UNITS
DWR_FLT_INV_OPRN	FLIGHT INVENTORY OPERATIONS
DWR_FLT_INV_SCHL_ASGN	FLIGHT INVENTORY SCHEDULE ASSIGNMENT
DWR_FLT_INV_STAT	FLIGHT INVENTORY STATUS
DWR_FLT_LEG_INV	FLIGHT LEG INVENTORY
DWR_FLT_LEG_INV_CBN	FLIGHT LEG INVENTORY CABIN
DWR_FLT_LEG_INV_CBN_ACV_CONFIG	FLIGHT LEG INVENTORY CABIN ACV CONFIG
DWR_FLT_LEG_INV_CBN_BLCKSPC	FLIGHT LEG INVENTORY CABIN BLOCKSPACE
DWR_FLT_LEG_INV_CBN_RMS	FLIGHT LEG INVENTORY CABIN RMS
DWR_FLT_LEG_INV_CBN_SLCONFIG	FLIGHT LEG INVENTORY CABIN SALECONFIG
DWR_FLT_LEG_INV_SSR	FLIGHT LEG INVENTORY SSR
DWR_FLT_LEG_INV_SSR_OPTN	FLIGHT LEG INVENTORY SSR OPTION
DWR_FLT_LEG_INV_STAT	FLIGHT LEG INVENTORY STATUS
DWR_FLT_LEGINV_CBN_SLCNFG_CHR	FLIGHT LEG INVENTORY CABIN SALECONFIG CHARACTERISTIC
DWR_FLT_SEG_INV	FLIGHT SEGMENT INVENTORY
DWR_FLT_SEG_INVCBN_BRDG_FIGDCS	FLIGHT SEGMENT INVENTORY CABIN BOOKING CLASS CODESHARE BOARDINGFIGURES DCS
DWR_FLT_SEG_INV_CBN	FLIGHT SEGMENT INVENTORY CABIN
DWR_FLT_SEG_INV_CBN_CDSHR	FLIGHT SEGMENT INVENTORY CABIN CODESHARE
DWR_FLT_SEG_INV_CDSHR	FLIGHT SEGMENT INVENTORY CODESHARE
DWR_FLT_SEG_INV_STAT	FLIGHT SEGMENT INVENTORY STATUS
DWR_FLT_SEG_INV_TRFC_RSTRCT	FLIGHT SEGMENT INVENTORY TRAFFIC RESTRICTION
DWR_FLTSEG_INCBBK_CLS_CSBRDRDC	FLIGHT SEGMENT INVENTORY CABIN BOOKING CLASS CODESHARE DCS
DWR_FLTSEG_INVCBNBKG_SBC_CNTRS	FLIGHT SEGMENT INVENTORY CABIN BOOKING SUBCLASS COUNTERS
DWR_FLTSEG_INVCBNBKG_SBC_DTFLG	FLIGHT SEGMENT INVENTORY CABIN BOOKING SUBCLASS DATEFLAG
DWR_FLTSEG_INVCBN_BKGCLS_CSRDC	FLIGHT SEGMENT INVENTORY CABIN BOOKING CLASS CODESHARE DCS
DWR_FLTSEG_INVCNBKG_SBC_AVLBTY	FLIGHT SEGMENT INVENTORY CABIN BOOKING SUBCLASS AVAILABILITY
DWR_FLTSEG_INV_CBNBKG_CLS
DWR_FLTSEG_INV_CBNBKG_CLS_STAT	FLIGHT SEGMENT INVENTORY CABIN BOOKING CLASS STATUS
DWR_FLTSEG_INV_CBNBKG_SBC
DWR_FLTSEG_INV_CBNBKG_SBC_NEGO	FLIGHT SEGMENT INVENTORY CABIN BOOKING SUBCLASS NEGO
DWR_FLTSEG_INV_CBN_BKG_SBC_FLG	FLIGHT SEGMENT INVENTORY CABIN BOOKING SUBCLASS FLAG
DWR_FLTSEG_INV_CBN_BKG_SBC_YLD	FLIGHT SEGMENT INVENTORY CABIN BOOKING SUBCLASS YIELD
DWR_FLTSEG_IVCN_BGCS_BDFIG_DCS	FLIGHT SEGMENT INVENTORY CABIN BOARDING FIGURES DCS
DWR_FLTSEG_IVCN_CDSR_BLKSC_CTR	FLIGHT SEGMENT INVENTORY CABIN CODESHARE BLOCKSPACE COUNTER
DWR_FORM_OF_PYMT	FORM OF PAYMENT
DWR_FREQ_FLYR	FREQUENT FLYER
DWR_FREQ_FLYR_DIM	FREQUENT FLYER
DWR_FREQ_FLYR_PREF	FREQUENT FLYER PREFERENCE
DWR_FSCL_HLF_MO	FISCAL HALF MONTH
DWR_FSCL_HLF_YR	FISCAL HALF YEAR
DWR_FSCL_MO	FISCAL MONTH
DWR_FSCL_QTR	FISCAL QUARTER
DWR_FSCL_WK	FISCAL WEEK
DWR_FSCL_YR	FISCAL YEAR
DWR_GEO	GEOGRAPHY
DWR_GEO_DEMOG_ATRIB	GEOGRAPHY DEMOGRAPHY ATTRIBUTES
DWR_GEO_DEMOG_GRP	GEOGRAPHY DEMOGRAPHIC GROUP
DWR_GEO_DEMOG_VAL	GEOGRAPHY DEMOGRAPHY VALUE
DWR_GEO_ENT	GEOGRAPHY ENTITY
DWR_GEO_HRCHY	GEOGRAPHY HIERARCHY
DWR_GEO_HRCHY_LVL	GEOGRAPHY HIERARCHY LEVEL
DWR_GEO_HRCHY_LVL_ASGN	GEOGRAPHY HIERARCHY LEVEL ASSIGNMENT
DWR_GEO_HRCHY_VRSN	GEOGRAPHY HIERARCHY VERSION
DWR_GEO_LVL	GEOGRAPHY LEVEL
DWR_GEO_LVL_ATRIB	GEOGRAPHY LEVEL ATTRIBUTES
DWR_GEO_LVL_ATRIB_VAL	GEOGRAPHY LEVEL ATTRIBUTE VALUE
DWR_GNDR	GENDER
DWR_HLF_HR	HALF HOUR
DWR_HLF_MO_TODATE_TRANS	HALF MONTH TODATE TRANSFORMATION
DWR_HLF_MO_TRANS	HALF MONTH TRANSFORMATION
DWR_HLF_YR_TODATE_TRANS	HALF YEAR TODATE TRANSFORMATION
DWR_HLF_YR_TRANS	HALF YEAR TRANSFORMATION
DWR_HR	HOUR
DWR_HSHLD	HOUSEHOLD
DWR_HTL_BKG	HOTEL BOOKING
DWR_HTL_BKG_BILLBL_INFO	HOTEL BOOKING BILLABLE INFO
DWR_HTL_BKG_CNCT	HOTEL BOOKING CONTACT
DWR_HTL_BKG_FORM_OF_PYMT	HOTEL BOOKING FORM OF PAYMENT
DWR_HTL_BKG_MISC_RMRK	HOTEL BOOKING MISC REMARKS
DWR_HTL_BKG_OPTN_TXT	HOTEL BOOKING OPTION TEXT
DWR_HTL_BKG_STAT	HOTEL BOOKING STATUS
DWR_HTL_FCLTY	HOTEL FACILITY
DWR_HTL_PROD	HOTEL PRODUCT
DWR_HTL_PROD_AMNTY	HOTEL PRODUCT AMENITY
DWR_HTL_PYMT	HOTEL PAYMENT
DWR_HTL_RM	HOTEL ROOM
DWR_HTL_TRF	HOTEL TARIFF
DWR_HTL_TRF_CHRG	HOTEL TARIFF CHARGE
DWR_INDVL_DEMOG_VAL	INDIVIDUAL DEMOGRAPHY VALUE
DWR_INDVL_NAME	INDIVIDUAL NAME
DWR_INFLT_MEAL	INFLIGHT MEAL
DWR_INTRACN_RSLT	INTERACTION RESULT
DWR_INTRACN_RSLT_DIM	INTERACTION RESULT
DWR_INTRACN_RSN	INTERACTION REASON
DWR_INTRACN_RSN_DIM	INTERACTION REASON
DWR_ITEM	ITEM
DWR_ITEM_SEASON	ITEM SEASON
DWR_JB	JOB
DWR_JB_RL	JOB ROLE
DWR_LANG_DILCT	LANGUAGE DIALECT
DWR_LCL_TAX_AUTHRTY	LOCAL TAX AUTHORITY
DWR_LEG_DIM	LEG
DWR_LEG_H	LEG
DWR_LYLTY_ACCT	LOYALTY ACCOUNT
DWR_LYLTY_LVL	LOYALTY LEVEL
DWR_LYLTY_LVL_DIM	LOYALTY LEVEL
DWR_LYLTY_PROG	LOYALTY PROGRAM
DWR_LYLTY_PROG_DIM	LOYALTY PROGRAM
DWR_MBRSHIP_ACCT	MEMBERSHIP ACCOUNT
DWR_MEDIA_OBJ	MEDIA OBJECT
DWR_MISCLNS_RMRK	MISCELLANEOUS REMARKS
DWR_MKT_AREA	MARKET AREA
DWR_MKT_AREA_DIM	MARKET AREA
DWR_MKT_AREA_LVL	MARKET AREA LEVEL
DWR_MKT_SEG	MARKET SEGMENT
DWR_MKT_SEG_CHR	MARKET SEGMENT CHARACTERISTIC
DWR_MKT_SEG_CHR_VAL	MARKET SEGMENT CHARACTERISTIC VALUE
DWR_MKT_STTSTC	MARKET STATISTICS
DWR_MKT_STTSTC_INCLSN	MARKET STATISTIC INCLUSION
DWR_MNT
DWR_MO_TODATE_TRANS	MONTH TODATE TRANSFORMATION
DWR_MO_TRANS	MONTH TRANSFORMATION
DWR_ODT_ACCT	ODT ACCOUNT
DWR_OPTN	OPTION
DWR_ORG	ORGANIZATION
DWR_ORG_AREA	ORGANIZATION AREA
DWR_ORG_BNR	ORGANIZATION BANNER
DWR_ORG_BSNS_ENT	ORGANIZATION BUSINESS ENTITY
DWR_ORG_BSNS_UNIT	ORGANIZATION BUSINESS UNIT
DWR_ORG_CHAIN	ORGANIZATION CHAIN
DWR_ORG_CMPNY	ORGANIZATION COMPANY
DWR_ORG_CRPRT	ORGANIZATION CORPORATE
DWR_ORG_DSTRCT	ORGANIZATION DISTRICT
DWR_ORG_HRCHY	ORGANIZATION HIERARCHY
DWR_ORG_HRCHY_LVL	ORGANIZATION HIERARCHY LEVEL
DWR_ORG_HRCHY_LVL_ASGN	ORGANIZATION HIERARCHY LEVEL ASSIGNMENT
DWR_ORG_HRCHY_VRSN	ORGANIZATION HIERARCHY VERSION
DWR_ORG_LVL	ORGANIZATION LEVEL
DWR_ORG_LVL_ATRIB	ORGANIZATION LEVEL ATTRIBUTES
DWR_ORG_LVL_ATRIB_VAL	ORGANIZATION LEVEL ATTRIBUTES VALUE
DWR_ORG_MKT_DATA	ORGANIZATION MARKET DATA
DWR_ORG_NAME	ORGANIZATION NAME
DWR_ORG_RGN	ORGANIZATION REGION
DWR_ORG_SRVC_WBSITE	ORGANIZATION SERVICE WEBSITE
DWR_ORG_WRHS	ORGANIZATION WAREHOUSE
DWR_ORGNTL_DEMOG_VAL	ORGANIZATIONAL DEMOGRAPHY VALUE
DWR_OTHR_INDVL	OTHER INDIVIDUAL
DWR_PASPRT	PASSPORT
DWR_PAX_CNCT	PASSENGER CONTACT
DWR_PAX_CPN_DATA	PAX COUPON DATA
DWR_PAX_INVC_HDR	PAX INVOICE HEADER
DWR_PDI_CHR	PDI CHARACTERISTIC
DWR_PDI_CHNL	PDI CHANNEL
DWR_PDI_CHNL_DIM	PDI CHANNEL
DWR_PHS	PHASE
DWR_PLNG_QTR	PLANNING QUARTER
DWR_PLNG_SEASON	PLANNING SEASON
DWR_PLNG_WK	PLANNING WEEK
DWR_PLNG_YR	PLANNING YEAR
DWR_PNR	PNR
DWR_PNR_DIM	PNR
DWR_PNR_TYP	PNR TYPE
DWR_POS_DEPT	POS DEPARTMENT
DWR_POS_ID	POS IDENTITY
DWR_POSTCD	POSTCODE
DWR_PRC_DRVTN_RULE	PRICE DERIVATION RULE
DWR_PRD_TODATE_TRANS
DWR_PRD_TRANS
DWR_PREF_TYP	PREFERENCE TYPE
DWR_PRFL_SRC	PROFILE SOURCE
DWR_PRMTN	PROMOTION
DWR_PRMTN_ITEM	PROMOTION ITEM
DWR_PRMTN_MSG_RNDRNG	PROMOTION MESSAGE RENDERING
DWR_PRMTN_PROD_OFRNG_ASGN	PROMOTION PRODUCT OFFERING ASSIGNMENT
DWR_PRMTN_SLNG_ITEM	PROMOTION SELLING ITEM
DWR_PROD_ENT	PRODUCT ENTITY
DWR_PROD_OFRNG	PRODUCT OFFERING
DWR_PRSPCT	PROSPECT
DWR_PRSPCT_INDVL	PROSPECT INDIVIDUAL
DWR_PRSPCT_ORG	PROSPECT ORGANIZATION
DWR_PRTNR_PRMTN_PROG	PARTNER PROMOTION PROGRAM
DWR_PRTY	PARTY
DWR_PRTY_ACCT_ASGN	PARTY ACCOUNT ASSIGNMENT
DWR_PRTY_ADDR_LOC_ASGN	PARTY ADDRESS LOCATION ASSIGNMENT
DWR_PRTY_ASGN	PARTY ASSIGNMENT
DWR_PRTY_CNCT_INFO	PARTY CONTACT INFORMATION
DWR_PRTY_CNCT_LST_PRTCPTN	PARTY CONTACT LIST PARTICIPATION
DWR_PRTY_DEMOG	PARTY DEMOGRAPHIC
DWR_PRTY_DEMOG_VAL	PARTY DEMOGRAPHY VALUE
DWR_PRTY_GEO_ENT_ASGN	PARTY GEOGRAPHY ENTITY ASSIGNMENT
DWR_PRTY_ID	PARTY IDENTIFICATION
DWR_PRTY_INTRACN_STAT	PARTY INTERACTION ITEM STATUS
DWR_PRTY_LANG_CAPBLTY	PARTY LANGUAGE CAPABILITY
DWR_PRTY_NAME	PARTY NAME
DWR_PRTY_RL	PARTY ROLE
DWR_PRTY_RL_ASGN	PARTY ROLE ASSIGNMENT
DWR_PRTY_SKILL	PARTY SKILL
DWR_PRTY_STAT	PARTY STATUS
DWR_PRTY_STAT_DIM	PARTY STATUS
DWR_QTR_TODATE_TRANS	QUARTER TO DATE TRANSFORMATION
DWR_QTR_TRANS	QUARTER TRANSFORMATION
DWR_RLGN	RELIGION
DWR_RL_HRCHY	ROLES HIERARCHY
DWR_ROUTEPAIRS	ROUTEPAIRS
DWR_ROUTES	ROUTES
DWR_RTL_SEASON	RETAIL SEASON
DWR_RTL_STORE	RETAIL STORE
DWR_SCND	SECOND
DWR_SEG_CRTRA	SEGMENT CRITERIA
DWR_SEG_DIM
DWR_SEG_PAIR_DIM
DWR_SKU_ITEM	SKU ITEM
DWR_SL_CHNL	SALES CHANNEL
DWR_SL_CHNL_RPRSTV	SALES CHANNEL REPRESENTATIVE
DWR_SL_FRCST_ITEM_ORG_HRCHY_WK	SALES FORECAST ITEM ORG HIERARCHY WEEK
DWR_SL_OR_RETRN_ACTN	SALE OR RETURN ACTION
DWR_SL_PLN_ITEM_ORG_HRCHY_WK	SALES PLAN ITEM ORG HIERARCHY WEEK
DWR_SL_RSTRCT	SALES RESTRICTION
DWR_SLNG_LOC	SELLING LOCATION
DWR_SOC_JB	SOC JOB
DWR_SRC_SYS	SOURCE SYSTEM
DWR_SRC_SYS_KEY_MAPNG	SOURCE SYSTEM KEY MAPPING
DWR_SRVC	SERVICE
DWR_SRVC_COVRG_AREA	SERVICE COVERAGE AREA
DWR_SRVC_COVRG_GEO_DTL	SERVICE COVERAGE GEO DETAIL
DWR_SRVC_DIM	SERVICE
DWR_SSR	SSR
DWR_SUPLIR	SUPPLIER
DWR_TAXBL_GRP	TAXABLE GROUP
DWR_TIME_DIM	TIME DIM
DWR_TIME_STNDRD_BY_DAY	TIME STANDARD BY DAY
DWR_TIME_STNDRD_BY_WK	TIME STANDARD BY WEEK
DWR_TIME_TOT	TIME TOTAL
DWR_TIME_ZN	TIME ZONE
DWR_TRFC_CTGRY	TRAFFIC CATEGORY
DWR_TRFC_CTGRY_DIM	TRAFFIC CATEGORY
DWR_TRGT_ACCS_MTHD	TARGET ACCESS METHOD
DWR_TRGT_ACCT	TARGET ACCOUNT
DWR_TRGT_GEO_AREA	TARGET GEOGRAPHY AREA
DWR_TRML	TERMINAL
DWR_TSM_PAX	TSM PASSENGER
DWR_TSM_EXCSS_BAG	TSM EXCESS BAGGAGE
DWR_TSM_MCO	TSM MCO
DWR_TSM_PRC	TSM PRICE
DWR_TSM_ROUTE	TSM ROUTE
DWR_TSM_SRVC	TSM SERVICE
DWR_USER	USER
DWR_VHCL	VEHICLE
DWR_VRTL_TEAM	VIRTUAL TEAM
DWR_WKDAY	WEEKDAY
DWR_WK_TODATE_TRANS	WEEK TODATE TRANSFORMATION
DWR_WK_TRANS	WEEK TRANSFORMATION

Base Tables

In Oracle Airlines Data Model, the base tables present the transaction data in 3NF. Base tables define atomic level transaction data. Data in the base tables support the derived and aggregate layers, and act as a source for Data Mining for advanced analysis.

Table 3-3 lists the Base tables in Oracle Airlines Data Model.

Table 3-3 Base Tables

Table Name	Description and More Information
DWB_ACCT_LVL_HIST	ACCOUNT LEVEL HISTORY
DWB_ACCT_PYMT	ACCOUNT PAYMENT
DWB_AWRD_VCHR	AWARD VOUCHER
DWB_ACCT_TRNSFR	ACCOUNT TRANSFER
DWB_BKG	BOOKING
DWB_BKG_AGNT_OPT_LN	BOOKING AGENT OPT LINE
DWB_BKG_BLLG	BOOKING BILLING
DWB_BKG_CMPGN_ASGN	BOOKING CAMPAIGN ASSIGNMENT
DWB_BKG_OTHR_SRVC	BOOKING OTHER SERVICE
DWB_BKG_RMRK	BOOKING REMARK
DWB_BKG_SSR	BOOKING SSR
DWB_BKG_SSR_BRDG	BOOKING SSR BRDG
DWB_BKG_STAT_CHNG_HIST	BOOKING STATUS CHANGE HISTORY
DWB_BKG_TST	BOOKING TST
DWB_BKG_TST_FARE_DATA	BOOKING TST FARE DATA
DWB_BKG_TST_PFC_TAX_AMT	BOOKING TST PFC TAX AMOUNT
DWB_BKG_TST_PRC	BOOKING TST PRICE
DWB_BKG_TST_SEG	BOOKING TST SEGMENT
DWB_BKG_TST_TAX	BOOKING TST TAX
DWB_BLLG_ANLYS_HDR	BILLING ANALYSIS HEADER
DWB_BLLG_ANLYS_TOT_CRNCY	BILLING ANALYSIS TOTALS CURRENCY
DWB_BLLG_OFFC_HDR	BILLING OFFICE HEADER
DWB_BLLG_OFFC_SBTOT_TRX_CRNCY	BILLING OFFICE SUBTOTALS TRANSACTION CURRENCY
DWB_BLLG_OFFC_TOT_CRNCY	BILLING OFFICE TOTALS CURRENCY
DWB_BLLG_TRX_AGNCY_ARLN_INFO	BILLING TRANSACTION AGENCY AIRLINE INFO
DWB_BLLG_TRX_CMPLT_FORMOF_PYMT	BILLING TRANSACTION COMPLETE FORM OF PAYMENT
DWB_BLLG_TRX_CMPLT_TCKT_DOC	BILLING TRANSACTION COMPLETE TICKET DOCUMENT
DWB_BLLG_TRX_CPN_ADDL_PRINT_LN	BILLING TRANSACTION COUPON ADDITIONAL PRINT LINES
DWB_BLLG_TRX_DOC_AMT	BILLING TRANSACTION DOCUMENT AMOUNTS
DWB_BLLG_TRX_ELCTRNC_TRX	BILLING TRANSACTION ELECTRONIC TRANSACTION
DWB_BLLG_TRX_EMD_CPN_DTL	BILLING TRANSACTION EMD COUPON DETAIL
DWB_BLLG_TRX_EMD_RMRK	BILLING TRANSACTION EMD REMARKS
DWB_BLLG_TRX_FARE_CALC	BILLING TRANSACTION FARE CALCULATION
DWB_BLLG_TRX_FL_TOT_CRNCY	BILLING TRANSACTION FILE TOTALS CURRENCY
DWB_BLLG_TRX_FORM_OF_PYMT	BILLING TRANSACTION FORM OF PAYMENT
DWB_BLLG_TRX_HDR	BILLING TRANSACTION HEADER
DWB_BLLG_TRX_MD_ADDL_INFO	BILLING TRANSACTION MD ADDITIONAL INFO
DWB_BLLG_TRX_MD_INFO_AMT	BILLING TRANSACTION MD INFO AMOUNT
DWB_BLLG_TRX_MD_ISSNCE_RSN	BILLING TRANSACTION MD ISSUANCE REASON
DWB_BLLG_TRX_NETNG_VAL	BILLING TRANSACTION NETTING VALUES
DWB_BLLG_TRX_PYMT_ATHRZTN	BILLING TRANSACTION PAYMENT AUTHORIZATION
DWB_BLLG_TRX_RLTD_TCKT	BILLING TRANSACTION RELATED TICKET
DWB_BLLG_TRX_TCKT	BILLING TRANSACTION TICKET
DWB_BLLG_TRX_TCKT_AMT	BILLING TRANSACTION TICKET AMOUNT
DWB_BLLG_TRX_TCKT_CMISN	BILLING TRANSACTION TICKET COMMISSION
DWB_BLLG_TRX_TCKT_FORM_OF_PYMT	BILLING TRANSACTION TICKET FORM OF PAYMENT
DWB_BLLG_TRX_TCKT_PAX	BILLING TRANSACTION TICKET PASSENGER
DWB_BLLG_TRX_TCKT_TAX_ON_CMISN	BILLING TRANSACTION TICKET TAX ON COMMISSION
DWB_BLLG_TRX_TCKT_VAT_INFO	BILLING TRANSACTION TICKET VAT INFORMATION
DWB_BT_PRPD_TCKT_ADC_SPNSR_INF	BILLING TRANSACTION PREPAID TICKET ADVICE SPONSOR INFORMATION
DWB_BT_TCKT_ITNRY_DATA_SEG	BILLING TRANSACTION TICKET ITINERARY DATA SEGMENT
DWB_BT_TCKT_MISCLNSADDL_PRNTLN	BILLING TRANSACTION TICKET MISCELLANEOUS ADDITIONAL PRINT LINES
DWB_BT_TCKT_QLFYNG_ISSUE_INFO	BILLING TRANSACTION TICKET QUALIFYING ISSUE INFORMATION
DWB_CAR_RNTL	CAR RENTAL
DWB_CAR_RNTL_ADDL_RT_CD_INFO	CAR RENTAL ADDITIONAL RATE CODE INFO
DWB_CAR_RNTL_CHRG_PRD	CAR RENTAL CHARGE PERIOD
DWB_CAR_RNTL_ESTM_DISTNC	CAR RENTAL ESTIMATE DISTANCE
DWB_CAR_RNTL_FOP	CAR RENTAL FOP
DWB_CAR_RNTL_LOC	CAR RENTAL LOCATION
DWB_CAR_RNTL_OTHR_RT_RULE	CAR RENTAL OTHER RATE RULE
DWB_CAR_RNTL_OTHR_RT_RULE_DT	CAR RENTAL OTHER RATE RULE DATE
DWB_CAR_RNTL_PREF_TYP	CAR RENTAL PREFERENCE TYPE
DWB_CAR_RNTL_RMRK	CAR RENTAL REMARKS
DWB_CAR_RNTL_SRCHRG_RPD	CAR RENTAL SURCHARGE PERIOD
DWB_CAR_RNTL_SRCHRG_RPD_TRFC	CAR RENTAL SURCHARGE PERIOD TARIFF
DWB_CAR_RNTL_TRFC	CAR RENTAL TARIFF
DWB_CAR_RNTL_TRFC_CHRG	CAR RENTAL TARIFF CHARGE
DWB_CDSHR_BRDG	CODESHARE BRIDGE
DWB_CHKIN	CHECKIN
DWB_CMNSTRY_ERNG	COMPENSATORY EARNING
DWB_CMPLN_ADVC	COMPLAIN ADVICE
DWB_CST	COST
DWB_CUST_ORDR	CUSTOMER ORDER
DWB_CUST_ORDR_LN_ITEM	CUSTOMER ORDER LINE ITEM
DWB_DRCT_ERNG	DIRECT EARNING
DWB_EMP_ACT_LBR_HRLY	EMPLOYEE ACTUAL LABOR HOURLY
DWB_EMP_ACT_LBR_SLRED	EMPLOYEE ACTUAL LABOR SALARIED
DWB_EMP_TRNG_REC	EMPLOYEE TRAINING RECORD
DWB_ERNG_EVT	EARNING EVENT
DWB_EVT_PRTY_ASGN	EVENT PARTY ASSIGNMENT
DWB_EVT_PRTY_INTRACN	EVENT PARTY INTERACTION
DWB_FLT_CHNG	FLIGHT CHANGE
DWB_FLT_SCHL	FLIGHT SCHEDULE
DWB_GRPNG	GROUPING
DWB_HOT_FL_HDR	HOT FILE HEADER
DWB_HTL_BKG_CMISN	HOTEL BOOKING COMMISSION
DWB_LEG_SCHL	LEG SCHEDULE
DWB_LYLTY_ACCT_BAL_HIST	LOYALTY ACCOUNT BALANCE HISTORY
DWB_LYLTY_ACCT_LVL_HIST	LOYALTY ACCOUNT LEVEL HISTORY
DWB_LYLTY_CNVRSN	LOYALTY CONVERSION
DWB_LYLTY_PTS_EXP	LOYALTY POINTS EXPIRE
DWB_MIN_CNCTNG_TMS	MINIMUM CONNECTING TIMES
DWB_PAX_CNTRY_ADDR_INFO	PASSENGER COUNTRY ADDRESS INFORMATION
DWB_PAX_VISA_INFO	PASSENGER VISA INFORMATION
DWB_PDH_H
DWB_PNR_GDS_INFO	PNR GDS INFO
DWB_PNR_PRNT_CHILD_RLTN	PNR PARENT CHILD RELATIONSHIP
DWB_PNR_RLTN	PNR RELATIONSHIP
DWB_PRC_MDFCTN_LN_ITEM	PRICE MODIFICATION LINE ITEM
DWB_PRMTN_CLSTR_USG	PROMOTION CLUSTER USAGE
DWB_PRMTN_MGMT_HIST	PROMOTION MANAGEMENT HISTORY
DWB_PRTNR_ERNG	PARTNER EARNING
DWB_PRTY_CST_ASGN	PARTY COST ASSIGNMENT
DWB_PRTY_INTRACN	PARTY INTERACTION
DWB_PRTY_INTRACN_CALL	PARTY INTERACTION CALL
DWB_PRTY_INTRACN_EML	PARTY INTERACTION EMAIL
DWB_PRTY_INTRACN_FAX	PARTY INTERACTION FAX
DWB_PRTY_INTRACN_ITEM	PARTY INTERACTION ITEM
DWB_PRTY_INTRACN_LTTR	PARTY INTERACTION LETTER
DWB_PRTY_INTRACN_SMS	PARTY INTERACTION SMS
DWB_PRTY_INTRACN_THRD	PARTY INTERACTION THREAD
DWB_PRTY_INTRACN_VST	PARTY INTERACTION VISIT
DWB_PRTY_ORDR_ASGN	PARTY ORDER ASSIGNMENT
DWB_PRTY_PRMTN_RESPN	PARTY PROMOTION RESPONSE
DWB_PRTY_STAT_HIST	PARTY STATUS HISTORY
DWB_RTL_CST_TRX	REVENUE COST TRANSACTION
DWB_RTL_SL_RETRN_LN_ITEM	RETAIL SALE RETURN LINE ITEM
DWB_RTL_TRX	RETAIL TRANSACTION
DWB_RTL_TRX_LN_ITEM	RETAIL TRANSACTION LINE ITEM
DWB_SEG_SCHL	SEGMENT SCHEDULE
DWB_TAX_LN_ITEM	TAX LINE ITEM
DWB_TCKT	TICKET
DWB_TCKT_CPN	TICKET COUPON
DWB_TCKT_DLVRY_ARNGMNT	TICKET DELIVERY ARRANGEMENT
DWB_TCKT_PRC	TICKET PRICE
DWB_TCKT_PRCNG_DISC	TICKET PRICING DISCOUNT
DWB_TCKT_PRCNG_DISC_DTLS	TICKET PRICING DOCUMENT DETAILS
DWB_TCKTNG_FORM_OF_PYMT	TICKETING FORM OF PAYMENT
DWB_TSM	TSM
DWB_TOUR	TOUR
DWB_TRNSFR_ERNG	TRANSFER EARNING
DWB_TSM_DOC	TSM DOC
DWB_TSM_MCO_FARES	TSM MCO FARES
DWB_TSM_MCO_TAX	TSM MCO TAX
DWB_TSM_PYMT	TSM PAYMENT
DWB_TSM_RFI	TSM RFI
DWB_TSM_XSB_RT	TSM ROUTE

Derived Tables

In Oracle Airlines Data Model, the Derived tables are tables that have as values the result of a non-aggregate calculation. There are two types of derived tables in Oracle Airlines Data Model:

• Tables that hold the results of a calculation.

• Result tables for the data mining models.

Table 3-4 lists the Derived tables in Oracle Airlines Data Model.

Table 3-4 Derived Tables

Table Name	Description and More Information
DWD_BKG_FCT	BOOKING FACT
DWD_CALL_CNTR_PRFMNC	CALL CENTER PERFORMANCE
DWD_CHKIN	CHECKIN FACT
DWD_CUST_LTV_SVM_FACTOR	CUSTOMER LIFE TIME VALUE SUPPORT VECTOR MACHINE FACTOR
DWD_CUST_LYLTY_DT_RULES	CUSTOMER LOYALTY DECISION TREE RULES
DWD_CUST_LYLTY_SVM_FACTOR	CUSTOMER LOYALTY SUPPORT VECTOR MACHINE FACTOR
DWD_CUST_MNNG	CUSTOMER MINING
DWD_CUST_RFMP_SCR	CUSTOMER RECENCY FREQUENCY MONETARY PROFITABILITY SCORE
DWD_CUST_SRVY	CUSTOMER SURVEY DERIVED
DWD_FFP_PRED_DT_RULES	FREQUENT FLIER PREDICTION DECISION TREE RULES
DWD_FFP_PRED_SVM_FACTOR	FREQUENT FLIER PREDICTION SUPPORT VECTOR MACHINE FACTOR
DWD_FLT_DTLS	FLIGHT DETAILS FACT
DWD_LYLTY_ACCT_BAL_HIST	LOYALTY ACCOUNT BALANCE HISTORY
DWD_LYLTY_ACCT_LVL_HIST	LOYALTY ACCOUNT LEVEL HISTORY
DWD_NON_FFP_MNNG	NON FREQUENT FLIER MINING
DWD_PNR	PNR
DWD_RVN_CST_DRVD	REVENUE COST DERIVED
DWD_TCKT	TICKET

Aggregate Tables

In Oracle Airlines Data Model, the Aggregate tables are tables that aggregate or "roll up" the data to one level higher than a base or derived table. The aggregate tables provide a view of the data similar to the view provided by a fact table in a snowflake schema.

Table 3-5 lists the Aggregate tables in Oracle Airlines Data Model.

Table 3-5 Aggregate Tables

Table Name	Description and More Information
DWA_BKG_DLY_INV_SNPST	BOOKING DAILY INVENTORY SNAPSHOT
DWA_CDSHR_BRDG	CODESHARE BRIDGE
DWA_CHKIN_DLY	CHECKIN DAILY FACT
DWA_CUST_SRVY	CUSTOMER SURVEY AGG
DWA_DLY_BKG	DAILY BOOKING FACT
DWA_DLY_CALL_CNTR_PRFMNC	DAILY CALL CENTER PERFORMANCE
DWA_DLY_LYLTY_ACCT	DAILY LOYALTY ACCOUNT
DWA_DLY_LYLTY_ACCT_BKG	DAILY LOYALTY ACCOUNT BOOKING

Lookup Tables

In Oracle Airlines Data Model lookup tables contain the relatively static or descriptive data in the data warehouse. Lookup tables hold the descriptions for frequently used attributes. Using lookup entities saves space, as the referring fact table holds only a small key or code and foreign key, and Oracle Airlines Data Model stores the space consuming description in a lookup table and does not repeat the description in each transaction row in which it is referenced.

Table 3-6 lists the Lookup tables in Oracle Airlines Data Model.

Table 3-6 Lookup Tables

Table Name	Description and More Information
DWL_ACCT_LVL	ACCOUNT LEVEL
DWL_ACCT_TRNSFR_RSN	ACCOUNT TRANSFER REASON
DWL_ACCT_TYP	ACCOUNT TYPE
DWL_ADDR_TYP	ADDRESS TYPE
DWL_AMT_TYP	AMOUNT TYPE
DWL_BKG_PROD_TYP	BOOKING PRODUCT TYPE
DWL_BKG_STAT_CHNG_RSN	BOOKING STATUS CHANGE REASON
DWL_BNK_CARD_TYP	BANK CARD TYPE
DWL_BNNING_RSN	BANNING REASON
DWL_BSNS_LEGAL_STAT	BUSINESS LEGAL STATUS
DWL_CMNSTRY_RSN	COMPENSATORY REASON
DWL_CMPGN_STAT	CAMPAIGN STATUS
DWL_CMPGN_TYP	CAMPAIGN TYPE
DWL_CMPLN_CLS	COMPLAIN CLASS
DWL_CMPLN_TYP	COMPLAIN TYPE
DWL_CRNCY	CURRENCY
DWL_CUST_OCCSN_TYP	CUSTOMER OCCASION TYPE
DWL_CUST_RVN_BND	CUSTOMER REVENUE BAND
DWL_CUST_RVN_TYP	CUSTOMER REVENUE TYPE
DWL_CUST_TYP	CUSTOMER TYPE
DWL_EMP_DESIG	EMPLOYEE DESIGNATION
DWL_EMP_TYP	EMPLOYEE TYPE
DWL_EXTRNL_ORG_TYP	EXTERNAL ORGANIZATION TYPE
DWL_FLT_INV_OPRN_TYP	FLIGHT INVENTORY OPERATION TYPE
DWL_INTTV_RSLT_TYP	INITIATIVE RESULT TYPE
DWL_INTTV_TYP	INITIATIVE TYPE
DWL_LANG	LANGUAGE
DWL_LCL_AUTHRTY_TYP	LOCAL AUTHORITY TYPE
DWL_LEG_TYP	LEG TYPE
DWL_LTTR_TYP	LETTER TYPE
DWL_MRTL_STAT	MARITAL STATUS
DWL_NTNLTY	NATIONALITY
DWL_ORG_BSNS_UNIT_TYP	ORGANIZATION BUSINESS UNIT TYPE
DWL_PRMTN_TYP	PROMOTION TYPE
DWL_PRTY_CNCT_INFO_TYP	PARTY CONTACT INFORMATION TYPE
DWL_PRTY_ID_TYP	PARTY IDENTIFICATION TYPE
DWL_PRTY_STAT_CHNG_RSN	PARTY STATUS CHANGE REASON
DWL_PRTY_STAT_TYP	PARTY STATUS TYPE
DWL_PRTY_TYP	PARTY TYPE
DWL_RVN_CST_ELMNT	REVENUE COST ELEMENT
DWL_RVN_CST_ELMNT_CTGRY	REVENUE COST ELEMENT CATEGORY
DWL_RVN_CST_ELMNT_GRP	REVENUE COST ELEMENT GROUP
DWL_SEASON	SEASON
DWL_SKILL_TYP	SKILL TYPE
DWL_SLNG_LOC_TYP	SELLING LOCATION TYPE
DWL_SWOT_TYP	SWOT TYPE
DWL_TRGT_TYP	TARGET TYPE
DWL_TRX_TYP	TRANSACTION TYPE
DWL_VAL_TYP	VALUE TYPE

Mining Tables

Table 3-7 lists the Data Mining control and Data Mining settings tables in Oracle Airlines Data Model.

Table 3-7 Data Mining and Data Mining Settings Tables

Table Name	Description
DM_STNG_CUST_LTY_DT	SETTING CUSTOMER DECISION TREE
DM_STNG_CUST_LTY_SVM	SETTING CUSTOMER SUPPORT VECTOR MACHINE
DM_STNG_PROFILE_KMEANS	SETTING PROFILE KMEANS
DM_STNG_USER_ALL	SETTING USER ALL
DMV_BKG_FACT_APPLY	FREQUENT FLIER BOOKING FACT APPLY
DMV_BKG_FACT_SRC	FREQUENT FLIER BOOKING FACT SOURCE
DMV_CUST_LOYALTY_APPLY	FREQUENT FLIER CUSTOMER LOYALTY APPLY
DMV_CUST_LOYALTY_SRC	FREQUENT FLIER CUSTOMER LOYALTY SOURCE
DMV_CUST_LTV_APPLY	FREQUENT FLIER CUSTOMER LIFE TIME VALUE APPLY
DMV_CUST_LTV_SRC	FREQUENT FLIER CUSTOMER LIFE TIME VALUE SOURCE
DMV_CUST_PROFILE_APPLY	FREQUENT FLIER CUSTOMER PROFILE APPLY
DMV_CUST_PROFILE_SRC	FREQUENT FLIER CUSTOMER PROFILE SOURCE
DMV_FFP_PRED_APPLY	FREQUENT FLIER PREDICTION APPLY
DMV_FFP_PRED_SRC	FREQUENT FLIER PREDICTION SOURCE
DMV_LYLTY_ACCT_BAL_APPLY	FREQUENT FLIER LOYALTY ACCOUNT BALANCE APPLY
DMV_LYLTY_ACCT_BAL_SRC	FREQUENT FLIER LOYALTY ACCOUNT BALANCE SOURCE

Database Sequences

Table 3-8 lists the Sequence Names in Oracle Airlines Data Model.

Table 3-8 Database Sequences

Generates the Physical Key for Table Name	Sequence Name
DWA_CUST_SRVY	SEQ_DWA_CUST_SRVY
DWA_DLY_BKG_FACT	SEQ_DWA_DLY_BKG_FACT
DWA_DLY_CALL_CNTR_PERFM	SEQ_DWA_DLY_CALL_CNTR_PERFM
DWA_DLY_FLT_DETLS	SEQ_DWA_DLY_FLT_DETLS
DWA_DLY_LYLTY_ACCT	SEQ_DWA_DLY_LYLTY_ACCT
DWA_DLY_LYLTY_ACCT_BKG	SEQ_DWA_DLY_LYLTY_ACCT_BKG
DWD_CHKIN_FACT	SEQ_DWD_CHKIN_FACT
DWD_FLT_DETLS_FACT	SEQ_DWD_FLT_DETLS_FACT

Metadata Tables

Table 3-9 lists the Metadata tables in Oracle Airlines Data Model.

Table 3-9 Metadata Tables

Table Name	Description
MD_ENTY	Stores data about logical data model entities, attributes, descriptions, and physical table names.
MD_KPI	Contains distinct presentation columns (KPI_NAME), dashboard folder name as subject area and computation logic for the KPI and subject area used in the RPD.
MD_PRG	Store all the information of the programs. Programs may be Packages used to store the data in Derived and Mining tables, Reports, Cubes or MV's, and so on.
MD_REF_ENTY_KPI	This table contains physical tables and columns used for the particular KPIs along with other columns used in KPI calculations.

Oracle Airlines Data Model OLAP Cube MV, Cube View

Table 3-10 shows the cube materialized views in oadm_sys schema.

Table 3-10 OLAP Cube Materialized Views in oadm_sys Schema

Cube Materialized View Name	OLAP Object Name	OLAP Object Type	More Information
CB$BKCLS_HBKCLS	BKCLS_HBKCLS	Dimension_Hierarchy	Booking Class: BKCLS
CB$BKOFC_HCNTYP	BKOFC_HCNTYP	Dimension_Hierarchy	Booking Office: BKOFC
CB$BKOFC_HBKOFC	BKOFC_HBKOFC	Dimension_Hierarchy	Booking Office: BKOFC
CB$BSDF	BSDF	Cube	Booking Segment Departure Fact Forecast Cube: BSDF_F
CB$BSDF_F	BSDF_F	Cube	Booking Segment Departure Fact Forecast Cube: BSDF_F
CB$CCPF	CCPF	Cube	Call Center Performance Fact Cube: CCPF
CB$CSDF	CSDF	Cube	Customer Survey Daily Fact Cube: CSDF
CB$FDDF	FDDF	Cube	Flight Detail Daily Fact Cube: FDDF
CB$GEO_HGEO	GEO_HGEO	Dimension_Hierarchy	Geography: GEO
CB$IRSN_HIRSN	IRSN_HIRSN	Dimension_Hierarchy	Interaction Reason: IRSN
CB$LOYLV_HLOYLY	LOYLV_HLOYLY	Dimension_Hierarchy	Loyalty Level: LOYLV
CB$LYAF	LYAF	Cube	Loyalty Account Fact Cube: LYAF
CB$LYBF	LYBF	Cube	Loyalty Booking Fact Cube: LYBF
CB$OPFLT_HOPFLT	OPFLT_HOPFLT	Dimension_Hierarchy	Operating Flight: OPFLT
CB$OPSMT_HOPSMT	OPSMT_HOPSMT	Dimension_Hierarchy	Operating Segment: OPSMT
CB$ROUTE_HROUTE	ROUTE_HROUTE	Dimension_Hierarchy	Route: ROUTE
CB$SRVC_HSRVC	SRVC	Dimension_Hierarchy	Service: SRVC
CB$TIME_HTIME	TIME_HTIME	Dimension_Hierarchy	Time: TIME
CB$TIME_HWEEK	TIME_HWEEK	Dimension_Hierarchy	Time: TIME

Table 3-11 shows the OLAP cube views in oadm_sys schema.

Table 3-11 OLAP Cube Views in oadm_sys schema

Cube View Name	OLAP Object Name	OLAP Object Type	More Information
BKCLS_HBKCLS_VIEW	BKCLS_HBKCLS	Hierarchy	Booking Class: BKCLS
BKCLS_VIEW	BKCLS	Dimension	Booking Class: BKCLS
BKOFC_HCNTYP_VIEW	BKOFC_HCNTYP	Hierarchy	Booking Office: BKOFC
BKOFC_HBKOFC_VIEW	BKOFC_HBKOFC	Hierarchy	Booking Office: BKOFC
BKOFC_VIEW	BKOFC	Dimension	Booking Office: BKOFC
BSDF_VIEW	BSDF	Cube	Booking Segment Departure Fact Cube: BSDF
BSDF_F_VIEW	BSDF_F	Cube	Booking Segment Departure Fact Forecast Cube: BSDF_F
CCPF_VIEW	CCPF	Cube	Call Center Performance Fact Cube: CCPF
CSDF_VIEW	CSDF	Cube	Customer Survey Daily Fact Cube: CSDF
FDDF_VIEW	FDDF	Cube	Flight Detail Daily Fact Cube: FDDF
GEO_HGEO_VIEW	GEO_HGEO	Hierarchy	Geography: GEO
GEO_VIEW	GEO	Dimension	Geography: GEO
IRSN_HIRSN_VIEW	IRSN_HIRSN	Hierarchy	Interaction Reason: IRSN
IRSN_VIEW	IRSN	Dimension	Interaction Reason: IRSN
LOYLV_HLOYLY_VIEW	LOYLV_HLOYLY	Hierarchy	Loyalty Level: LOYLV
LOYLV_VIEW	LOYLV	Dimension	Loyalty Level: LOYLV
LYAF_VIEW	LYAF	Cube	Loyalty Account Fact Cube: LYAF
LYBF_VIEW	LYBF	Cube	Loyalty Booking Fact Cube: LYBF
OPFLT_HOPFLT_VIEW	OPFLT_HOPFLT	Hierarchy	Operating Flight: OPFLT
OPFLT_VIEW	OPFLT	Dimension	Operating Flight: OPFLT
OPSMT_HOPSMT_VIEW	OPSMT_HOPSMT	Hierarchy	Operating Segment: OPSMT
OPSMT_VIEW	OPSMT	Dimension	Operating Segment: OPSMT
ROUTE_HROUTE_VIEW	ROUTE_HROUTE	Hierarchy	Route: ROUTE
ROUTE_VIEW	ROUTE	Dimension	Route: ROUTE
SRVC_HSRVC_VIEW	SRVC	Hierarchy	Service: SRVC
SRVC_VIEW	SRVC	Dimension	Service: SRVC
TIME_HTIME_VIEW	TIME_HTIME	Hierarchy	Time: TIME
TIME_HWEEK_VIEW	TIME_HWEEK	Hierarchy	Time: TIME
TIME_VIEW	TIME	Dimension	Time: TIME