2 Logical Data Model

Defines the business entities and their relationships and provides descriptions of the business and data requirements for the Oracle Airlines Data Model data warehouse.

• Reference Entities
  Reference Entities define the entities within, and associated with the airline organization for which data is recorded and analyzed. Reference entities help define the structure of the organization.
• Lookup Entities
  Lookup entities describe the relatively static or descriptive data in the data warehouse. Lookup entities define 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.
• Base Entities
  Base entities define atomic level transaction data. Data in the base tables support the derived and aggregate layers, and act as a source for Data Mining and for other advanced analysis.
• Derived Entities
  Provides a list of the derived entities.
• Aggregate Entities
  Aggregate entities hold data rolled up from the Base or Derived entities at different levels across different dimensional hierarchies.
• Logical Data Model Entity Dictionary
  Lists the logical data model entities, in an alphabetical order.

See Also:

The figures showing complete diagrams with attributes and entities are available with the Oracle Airlines Data Model IP Patch. The IP Patch includes additional documentation. For information on obtaining the IP Patch, see the Oracle Airlines Data Model Release Notes and for the latest information about Oracle Airlines Data Model patch sets, go to My Oracle Support at https://support.oracle.com.

Reference Entities

Reference Entities define the entities within, and associated with the airline organization for which data is recorded and analyzed. Reference entities help define the structure of the organization.

Reference Entity List

ACCOUNT
ADDRESS LOCATION
ADDRESS LOCATION STATUS HISTORY
ADDRESS RELATED
AGENCY
ALTERNATIVE ITEMS
AIRCRAFT
AIRCRAFT TYPE
AIRCRAFT VERSION
AIRCRAFT VERSION
AIRPORT
AIRPORT
BASE DAY
BOOKING CLASS
BOOKING CLASS TYPE
HOTEL BOOKING CUSTOMER REFERENCE
BOOKING OFFICE
BOOKING OFFICE
BOOKING OFFICE USER
BOOKING PASSENGER
BOOKING PASSENGER
BOOKING PASSENGER DOCUMENT INFORMATION
BOOKING PRODUCT
BOOKING PRODUCT DETAIL
BOOKING SEAT
BOOKING SEAT PREFERENCE
BOOKING SERIES
HOTEL BOOKING SAVING AMOUNT
BOOKING TST
BLACK LIST HISTORY
BANK
BANK CARD
BUSINESS HALF MONTH
BUSINESS HALF YEAR
BUSINESS MONTH
BUSINESS QUARTER
BUSINESS UNIT JOB ROLE
BUSINESS UNIT SHIFT
BUSINESS YEAR
CALL CENTER
CALL CENTER AGENT
CALL CENTER SERVICE CAPABILITY
CAR PRODUCT
CAR RENTAL MODEL
CARRIER
CARRIER
CARRIER TYPE
CODESHARE
CHECKIN BAGGAGE GROUP
CHECKIN INDIVIDUAL BAGGAGE
CHANNEL
CALENDAR
CALENDAR HALF MONTH
CALENDAR HALF YEAR
CALENDAR MONTH
CALENDAR QUARTER
CALENDAR WEEK
CALENDAR YEAR
CAMPAIGN
CAMPAIGN MEDIA SELLING ITEM
CAMPAIGN MANAGEMENT HISTORY
CAMPAIGN MESSAGE
COMPETITOR
COMPETITOR INTELLIGENCE
COMPETITOR INTELLIGENCE PARTY ROLE
COMPETITOR MARKET SEGMENT ASSIGNMENT
COMPETITOR MARKET SEGMENT SWOT
COMPETITOR PRODUCT CORRELATION
COMPETITOR SWOT
COMPETITOR TIER ASSIGNMENT
COMPETITIVE TIER
COUNTERS
COMP INTEL CHARACTERISTIC
COMP INTEL CHARACTERISTIC VALUE
COMP INTEL MARKET SEGMENT
COMP PROD CRRL CHARACTERISTIC ASSIGNMENT
COMP PROD CRRL CHARACTERISTIC VALUE
CREDIT SCORE PROVIDER
CORPORATE CUSTOMER
CERTIFICATE
COST CENTER
CUSTOMER
CUSTOMER INDIVIDUAL
CUSTOMER OCCASION
CUSTOMER ORGANIZATION
CUSTOMER RESTRICTED INFO
CUSTOMER REVENUE BAND ASSIGNMENT
CUSTOMER SCORE
CUSTOMER SEGMENT
CUSTOMER SEGMENTATION MODEL
CUSTOMER SOURCE
DAY
DEMOGRAPHY ATTRIBUTE
DEMOGRAPHY GROUP
DEPARTMENT
DISCOUNT GROUP
DEALER
DOCUMENT
DERIVED VALUE
EDUCATION
EMAIL ADDRESS
EMPLOYEE
EMPLOYEE DISCOUNT GROUP ASSIGNMENT
EMPLOYEE JOB ROLE ASSIGNMENT
EMPLOYEE LANGUAGE CAPABILITY
EMPLOYEE RESTRICTED INFO
EMPLOYEE SCHEDULE
EXTERNAL CREDIT PROFILE
EXTERNAL CREDIT PROFILE ASSIGNMENT
FARE ELEMENT
FARE TYPE
FLEET_HEADERS
FLIGHT
FLIGHT
FLIGHT INVENTORY
FLIGHT INVENTORY NUMBER OF UNITS
FLIGHT INVENTORY OPERATIONS
FLIGHT INVENTORY SCHEDULE ASSIGNMENT
FLIGHT INVENTORY STATUS
FLIGHT LEG INVENTORY
FLIGHT LEG INVENTORY CABIN
FLIGHT LEG INVENTORY CABIN ACV CONFIG
FLIGHT LEG INVENTORY CABIN BLOCKSPACE
FLIGHT LEG INVENTORY CABIN RMS
FLIGHT LEG INVENTORY CABIN SALECONFIG
FLIGHT LEG INVENTORY SSR
FLIGHT LEG INVENTORY SSR OPTION
FLIGHT LEG INVENTORY STATUS
FLIGHT LEG INVENTORY CABIN SALECONFIG CHARACTERISTIC
FLIGHT SEGMENT INVENTORY
FLIGHT SEGMENT INVENTORY CABIN
FLIGHT SEGMENT INVENTORY CABIN CODESHARE
FLIGHT SEGMENT INVENTORY CODESHARE
FLIGHT SEGMENT INVENTORY STATUS
FLIGHT SEGMENT INVENTORY TRAFFIC RESTRICTION
FLIGHT SEGMENT INVENTORY CABIN BOOKING CLASS CODESHARE BOARDINGFIGURES DCS
FLIGHT SEGMENT INVENTORY CABIN BOOKING CLASS CODESHARE DCS
FLIGHT SEGMENT INVENTORY CABIN BOOKING SUBCLASS FLAG
FLIGHT SEGMENT INVENTORY CABIN BOOKING SUBCLASS YIELD
FLIGHT SEGMENT INVENTORY CABIN BOOKING CLASS STATUS
FLIGHT SEGMENT INVENTORY CABIN BOOKING SUBCLASS NEGO
FLIGHT SEGMENT INVENTORY CABIN BOOKING CLASS CODESHARE DCS
FLIGHT SEGMENT INVENTORY CABIN BOOKING SUBCLASS COUNTERS
FLIGHT SEGMENT INVENTORY CABIN BOOKING SUBCLASS DATEFLAG
FLIGHT SEGMENT INVENTORY CABIN BOOKING SUBCLASS AVAILABILITY
FLIGHT SEGMENT INVENTORY CABIN BOARDING FIGURES DCS
FLIGHT SEGMENT INVENTORY CABIN CODESHARE BLOCKSPACE COUNTER
FORM OF PAYMENT
FREQUENT FLYER
FREQUENT FLYER
FREQUENT FLYER PREFERENCE
FISCAL HALF MONTH
FISCAL HALF YEAR
FISCAL MONTH
FISCAL QUARTER
FISCAL WEEK
FISCAL YEAR
GEOGRAPHY
GEOGRAPHY DEMOGRAPHY ATTRIBUTES
GEOGRAPHY DEMOGRAPHIC GROUP
GEOGRAPHY DEMOGRAPHY VALUE
GEOGRAPHY ENTITY
GEOGRAPHY HIERARCHY
GEOGRAPHY HIERARCHY LEVEL
GEOGRAPHY HIERARCHY LEVEL ASSIGNMENT
GEOGRAPHY HIERARCHY VERSION
GEOGRAPHY LEVEL
GEOGRAPHY LEVEL ATTRIBUTES
GEOGRAPHY LEVEL ATTRIBUTE VALUE
GENDER
HALF HOUR
HALF MONTH TODATE TRANSFORMATION
HALF MONTH TRANSFORMATION
HALF YEAR TODATE TRANSFORMATION
HALF YEAR TRANSFORMATION
HOUR
HOUSEHOLD
HOTEL BOOKING
HOTEL BOOKING BILLABLE INFO
HOTEL BOOKING CONTACT
HOTEL BOOKING FORM OF PAYMENT
HOTEL BOOKING MISC REMARKS
HOTEL BOOKING OPTION TEXT
HOTEL BOOKING STATUS
HOTEL FACILITY
HOTEL PRODUCT
HOTEL PRODUCT AMENITY
HOTEL PAYMENT
HOTEL ROOM
HOTEL TARIFF
HOTEL TARIFF CHARGE
INDIVIDUAL DEMOGRAPHY VALUE
INDIVIDUAL NAME
INFLIGHT MEAL
INTERACTION RESULT
INTERACTION REASON
ITEM
ITEM SEASON
JOB
JOB ROLE
LANGUAGE DIALECT
LOCAL TAX AUTHORITY
LEG
LOT_NUMBERS
LOYALTY ACCOUNT
LOYALTY LEVEL
LOYALTY PROGRAM
MEMBERSHIP ACCOUNT
MEDIA OBJECT
MEL
MFG_PART_NUMBERS
MISCELLANEOUS REMARKS
MARKET AREA
MARKET AREA
MARKET AREA LEVEL
MARKET SEGMENT
MARKET SEGMENT CHARACTERISTIC
MARKET SEGMENT CHARACTERISTIC VALUE
MARKET STATISTICS
MARKET STATISTIC INCLUSION
MONTH TODATE TRANSFORMATION
MONTH TRANSFORMATION
MR_EFFECTIVITY_DTLS
MRO RESOURCE
MASTER CONFIGURATION HEADER
MTL_MANUFACTURERS
ODT ACCOUNT
OPTION
ORGANIZATION
ORGANIZATION AREA
ORGANIZATION BANNER
ORGANIZATION BUSINESS ENTITY
ORGANIZATION BUSINESS UNIT
ORGANIZATION CHAIN
ORGANIZATION COMPANY
ORGANIZATION CORPORATE
ORGANIZATION DISTRICT
ORGANIZATION HIERARCHY
ORGANIZATION HIERARCHY LEVEL
ORGANIZATION HIERARCHY LEVEL ASSIGNMENT
ORGANIZATION HIERARCHY VERSION
ORGANIZATION LEVEL
ORGANIZATION LEVEL ATTRIBUTES
ORGANIZATION LEVEL ATTRIBUTES VALUE
ORGANIZATION MARKET DATA
ORGANIZATION NAME
ORGANIZATION REGION
ORGANIZATION SERVICE WEBSITE
ORGANIZATION WAREHOUSE
ORGANIZATIONAL DEMOGRAPHY VALUE
OTHER INDIVIDUAL
PART LOCATIONS
PASSPORT
PASSENGER CONTACT
PAX COUPON DATA
PAX INVOICE HEADER
PDI CHANNEL
PDI CHANNEL
PDI CHARACTERISTIC
PHASE
PLANNING QUARTER
PLANNING SEASON
PLANNING WEEK
PLANNING YEAR
PNR
PNR
PNR TYPE
POS DEPARTMENT
POS IDENTITY
POSTCODE
PRICE DERIVATION RULE
PREFERENCE TYPE
PROFILE SOURCE
PROMOTION
PROMOTION ITEM
PROMOTION MESSAGE RENDERING
PROMOTION PRODUCT OFFERING ASSIGNMENT
PROMOTION SELLING ITEM
PRODUCT ENTITY
PRODUCT OFFERING
PROSPECT
PROSPECT INDIVIDUAL
PROSPECT ORGANIZATION
PARTNER PROMOTION PROGRAM
PARTY
PARTY ACCOUNT ASSIGNMENT
PARTY ADDRESS LOCATION ASSIGNMENT
PARTY ASSIGNMENT
PARTY CONTACT INFORMATION
PARTY CONTACT LIST PARTICIPATION
PARTY DEMOGRAPHIC
PARTY DEMOGRAPHY VALUE
PARTY GEOGRAPHY ENTITY ASSIGNMENT
PARTY IDENTIFICATION
PARTY INTERACTION ITEM STATUS
PARTY LANGUAGE CAPABILITY
PARTY NAME
PARTY ROLE
PARTY ROLE ASSIGNMENT
PARTY SKILL
PARTY STATUS
PARTY STATUS
QUALITY PLANS
QUARTER TO DATE TRANSFORMATION
QUARTER TRANSFORMATION
ROLES HIERARCHY
RELIGION
ROUTEPAIRS
ROUTES
REPAIR_CATEGORIES
RETAIL SEASON
RETAIL STORE
SECOND
SEGMENT CRITERIA
SEGMENT DIM
SEGMENT PAIR DIM
SKU ITEM
SALES CHANNEL
SALES CHANNEL REPRESENTATIVE
SALES FORECAST ITEM ORG HIERARCHY WEEK
SALE OR RETURN ACTION
SALES PLAN ITEM ORG HIERARCHY WEEK
SALES RESTRICTION
SELLING LOCATION
SOC JOB
SOURCE SYSTEM
SOURCE SYSTEM KEY MAPPING
SERVICE
SERVICE COVERAGE AREA
SERVICE COVERAGE GEO DETAIL
SERVICE
SSR
SUPPLIER
TAXABLE GROUP
TIME DIM
TIME STANDARD BY DAY
TIME STANDARD BY WEEK
TIME TOTAL
TIME ZONE
TRAFFIC CATEGORY
TRAFFIC CATEGORY
TARGET ACCESS METHOD
TARGET ACCOUNT
TARGET GEOGRAPHY AREA
TERMINAL
TASK ASSIGNMENT
TSM EXCESS BAGGAGE
TSM MCO
TSM PASSENGER
TSM PRICE
TSM ROUTE
TSM SERVICE
UNIT_ACCOMPLISHMNTS
UNIT CONFIGURATION HEADER
UNIT CONFIGURATION HISTORY
UNIT_DEFERRALS
UNIT MAINTENANCE PLAN
UNIT MAINTENANCE PLAN COUNTER HISTORY
UNIT MAINTENANCE PLAN THRESHOLD RULE
USER
VEHICLE
VIRTUAL TEAM
WEEK TODATE TRANSFORMATION
WEEK TRANSFORMATION
WEEKDAY
WORK ORDER OPERATION
WARRANTY_ENTITLEMENTS

Logical to Physical Mappings for Oracle Airlines Data Model

Logical Data Model Entity Dictionary

Lookup Entities

Lookup entities describe the relatively static or descriptive data in the data warehouse. Lookup entities define 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.

Lookup Entity List

ACCOUNT LEVEL
ACCOUNT TRANSFER REASON
ACCOUNT TYPE
ADDRESS TYPE
AMOUNT TYPE
ATA CHAPTER
BOOKING PRODUCT TYPE
BOOKING STATUS CHANGE REASON
BANK CARD TYPE
BANNING REASON
BUSINESS LEGAL STATUS
COMPENSATORY REASON
CAMPAIGN STATUS
CAMPAIGN TYPE
COMPLAIN CLASS
COMPLAIN TYPE
CURRENCY
CUSTOMER OCCASION TYPE
CUSTOMER REVENUE BAND
CUSTOMER REVENUE TYPE
CUSTOMER TYPE
DELAY CAUSE
EMPLOYEE DESIGNATION
EMPLOYEE TYPE
EXTERNAL ORGANIZATION TYPE
FLEET
FLIGHT CANCELLATION REASON
FLIGHT INVENTORY OPERATION TYPE
INITIATIVE RESULT TYPE
INITIATIVE TYPE
LANGUAGE
LOCAL AUTHORITY TYPE
LEG TYPE
LETTER TYPE
MEL ATTRIBUTE
MARITAL STATUS
NATIONALITY
ORGANIZATION BUSINESS UNIT TYPE
PROMOTION TYPE
PARTY CONTACT INFORMATION TYPE
PARTY IDENTIFICATION TYPE
PARTY STATUS CHANGE REASON
PARTY STATUS TYPE
PARTY TYPE
RECTAFICATION INTERVAL
REVENUE COST ELEMENT
REVENUE COST ELEMENT CATEGORY
REVENUE COST ELEMENT GROUP
SEASON
SKILL TYPE
SELLING LOCATION TYPE
SWOT TYPE
TARGET TYPE
TRANSACTION TYPE
VALUE TYPE

Logical to Physical Mappings for Oracle Airlines Data Model

Logical Data Model Entity Dictionary

Base Entities

Base entities define atomic level transaction data. Data in the base tables support the derived and aggregate layers, and act as a source for Data Mining and for other advanced analysis.

Base Entity List

ACCOUNT LEVEL HISTORY
ACCOUNT PAYMENT
ACCOUNT TRANSFER
AIRCRAFT DISPATCH
AIRCRAFT TURN AROUND
ASSET_DATA_DRAFT
AWARD VOUCHER
BOOKING
BOOKING AGENT OPT LINE
BOOKING BILLING
BOOKING CAMPAIGN ASSIGNMENT
BOOKING OTHER SERVICE
BOOKING REMARK
BOOKING SSR
BOOKING SSR BRDG
BOOKING STATUS CHANGE HISTORY
BOOKING TST
BOOKING TST FARE DATA
BOOKING TST PFC TAX AMOUNT
BOOKING TST PRICE
BOOKING TST SEGMENT
BOOKING TST TAX
BILLING ANALYSIS HEADER
BILLING ANALYSIS TOTALS CURRENCY
BILLING OFFICE HEADER
BILLING OFFICE SUBTOTALS TRANSACTION CURRENCY
BILLING OFFICE TOTALS CURRENCY
BILLING TRANSACTION AGENCY AIRLINE INFO
BILLING TRANSACTION COMPLETE FORM OF PAYMENT
BILLING TRANSACTION COMPLETE TICKET DOCUMENT
BILLING TRANSACTION COUPON ADDITIONAL PRINT LINES
BILLING TRANSACTION DOCUMENT AMOUNTS
BILLING TRANSACTION ELECTRONIC TRANSACTION
BILLING TRANSACTION EMD COUPON DETAIL
BILLING TRANSACTION EMD REMARKS
BILLING TRANSACTION FARE CALCULATION
BILLING TRANSACTION FILE TOTALS CURRENCY
BILLING TRANSACTION FORM OF PAYMENT
BILLING TRANSACTION HEADER
BILLING TRANSACTION MD ADDITIONAL INFO
BILLING TRANSACTION MD INFO AMOUNT
BILLING TRANSACTION MD ISSUANCE REASON
BILLING TRANSACTION NETTING VALUES
BILLING TRANSACTION PAYMENT AUTHORIZATION
BILLING TRANSACTION RELATED TICKET
BILLING TRANSACTION TICKET
BILLING TRANSACTION TICKET AMOUNT
BILLING TRANSACTION TICKET COMMISSION
BILLING TRANSACTION TICKET FORM OF PAYMENT
BILLING TRANSACTION TICKET PASSENGER
BILLING TRANSACTION TICKET TAX ON COMMISSION
BILLING TRANSACTION TICKET VAT INFORMATION
BORROW_TRANSACTIONS
BILLING TRANSACTION PREPAID TICKET ADVICE SPONSOR INFORMATION
BILLING TRANSACTION TICKET ITINERARY DATA SEGMENT
BILLING TRANSACTION TICKET MISCELLANEOUS ADDITIONAL PRINT LINES
BILLING TRANSACTION TICKET QUALIFYING ISSUE INFORMATION
CAR RENTAL
CAR RENTAL ADDITIONAL RATE CODE INFO
CAR RENTAL CHARGE PERIOD
CAR RENTAL ESTIMATE DISTANCE
CAR RENTAL FOP
CAR RENTAL LOCATION
CAR RENTAL OTHER RATE RULE
CAR RENTAL OTHER RATE RULE DATE
CAR RENTAL PREFERENCE TYPE
CAR RENTAL REMARKS
CAR RENTAL SURCHARGE PERIOD
CAR RENTAL SURCHARGE PERIOD TARIFF
CAR RENTAL TARIFF
CAR RENTAL TARIFF CHARGE
CODESHARE BRIDGE
CHECKIN
COMPENSATORY EARNING
COMPLAIN ADVICE
COST
CUSTOMER ORDER
CUSTOMER ORDER LINE ITEM
DELAYS AND CANCELLATIONS
DIRECT EARNING
DISPOSITIONS
EMPLOYEE ACTUAL LABOR HOURLY
EMPLOYEE ACTUAL LABOR SALARIED
EMPLOYEE TRAINING RECORD
EARNING EVENT
EVENT
EVENT PARTY ASSIGNMENT
EVENT PARTY INTERACTION
FLEET_UNIT_ASSOCS
FLIGHT CHANGE
FLIGHT_DATA_DRAFT
FLIGHT GATE OPERATION
FLIGHT SCHEDULE
GROUPING
HOT FILE HEADER
HOTEL BOOKING COMMISSION
LEG SCHEDULE
LOG_BOOK
LOYALTY ACCOUNT BALANCE HISTORY
LOYALTY ACCOUNT LEVEL HISTORY
LOYALTY CONVERSION
LOYALTY POINTS EXPIRE
MEL_CDL_PROCEDURES
MINIMUM CONNECTING TIMES
MAINTENANCE REQUIREMENT
MAINTENANCE VISIT
MAINTENANCE VISIT TASK
MR EFFECTIVITY
MR_INTERVALS
MATERIAL TRASACTION
NON ROUTINE
OPERATION
OPERATION MATERIAL
OPERATION_RESOURCES
OUTSIDE PROCESSING ORDER
PART
PART CHANGE
PART SERIAL NUMBER
PASSENGER COUNTRY ADDRESS INFORMATION
PAX TRANSFER
PASSENGER VISA INFORMATION
PURCHASE ORDER
PDI CHANNEL
PNR GDS INFO
PNR PARENT CHILD RELATIONSHIP
PNR RELATIONSHIP
PRICE MODIFICATION LINE ITEM
PROMOTION CLUSTER USAGE
PROMOTION MANAGEMENT HISTORY
PROJECT
PROJECTS_ALL
PARTNER EARNING
PARTY COST ASSIGNMENT
PARTY INTERACTION
PARTY INTERACTION CALL
PARTY INTERACTION EMAIL
PARTY INTERACTION FAX
PARTY INTERACTION ITEM
PARTY INTERACTION LETTER
PARTY INTERACTION SMS
PARTY INTERACTION THREAD
PARTY INTERACTION VISIT
PARTY ORDER ASSIGNMENT
PARTY PROMOTION RESPONSE
PARTY STATUS HISTORY
QUALITY RESULTS
REVENUE COST TRANSACTION
RETAIL SALE RETURN LINE ITEM
RETAIL TRANSACTION
RETAIL TRANSACTION LINE ITEM
ROUTINE
SCRAP_VALUES
SEGMENT SCHEDULE
TAX LINE ITEM
TICKET
TICKET COUPON
TICKET DELIVERY ARRANGEMENT
TICKET PRICE
TICKET PRICING DISCOUNT
TICKET PRICING DOCUMENT DETAILS
TICKETING FORM OF PAYMENT
TOUR
TRACKED ITEM
TRANSFER EARNING
TASK EFFECTIVITIES
TASK LIST
TSM
TSM DOC
TSM MCO FARES
TSM MCO TAX
TSM PAYMENT
TSM RFI
TSM ROUTE
UNIT_EFFECTIVITIES
UNIT SCHEDULES
WEATHER
WORK ORDER

Logical to Physical Mappings for Oracle Airlines Data Model

Logical Data Model Entity Dictionary

Derived Entities

Provides a list of the derived entities.

Derived Entity List

BOOKING FACT
CALL CENTER PERFORMANCE
CHECKIN FACT
CUSTOMER SURVEY DERIVED
FLIGHT DETAILS FACT
LOYALTY ACCOUNT BALANCE HISTORY
LOYALTY ACCOUNT LEVEL HISTORY
REVENUE COST DERIVED
TICKET FACT

Logical to Physical Mappings for Oracle Airlines Data Model

Logical Data Model Entity Dictionary

Aggregate Entities

Aggregate entities hold data rolled up from the Base or Derived entities at different levels across different dimensional hierarchies.

Aggregate Entity List

BOOKING DAILY INVENTORY SNAPSHOT
CHECKIN DAILY FACT
CODESHARE BRIDGE FACT
CUSTOMER SOURCE
CUSTOMER SURVEY AGG
DAILY BOOKING FACT
DAILY CALL CENTER PERFORMANCE
DAILY CUSTOMER SURVEY
DAILY FLIGHT DETAILS
DAILY LOYALTY ACCOUNT
DAILY LOYALTY ACCOUNT BOOKING

Logical to Physical Mappings for Oracle Airlines Data Model

Logical Data Model Entity Dictionary

Logical Data Model Entity Dictionary

Lists the logical data model entities, in an alphabetical order.

Table 2-1 A to G Entity Descriptions

Entity Name	Type	Description
ACCOUNT	Reference	Specifies the account number and the cost center associated with each BOOKING
ACCOUNT LEVEL	Lookup	Lookup for the domain of account levels achievable within a LOYALTY PROGRAM. For example: Standard Premier Executive Premier
ACCOUNT LEVEL HISTORY	Base	Specifies ACCOUNT LEVEL change history.
ACCOUNT PAYMENT	Base	Specifies details of each allocation of money from a receipt made by a party to a specific account. It is the receipt of a single sum of money from a party as a credit against an outstanding balance for the provision or supply of products or services.
ACCOUNT TRANSFER	Base	Represents the earnings transferred to or from an ACCOUNT.
ACCOUNT TRANSFER REASON	Lookup	Lookup for why the customer transfers points.
ACCOUNT TYPE	Lookup	Lookup for the type of account. For example: Bank Card Loyalty Card
ADDRESS LOCATION	Reference	An ordinary postal address for the PARTY or site.
ADDRESS LOCATION STATUS HISTORY	Reference	History of the names and addresses associated with an ORGANIZATION, PROSPECT, or CUSTOMER.
ADDRESS RELATED	Reference	This is an operational layer entity which stores the relationship between two addresses. Associates one address with other addresses. For example: Alternate address Locations with multiple addresses
ADDRESS TYPE	Lookup	Lookup for address type. For example: Home Mailing Shipping
ADVANCED SHIP NOTICE DOCUMENT	Base	An electronic document sent to a store by a vendor that defines the shipment date, expected delivery date, carrier, shipped items, and OrderDocument reference. It is sent out in advance of the shipment to enable the retailer to plan workload and receipt processing.
ADVANCED SHIP NOTICE DOCUMENT LINE ITEM	Base	Details line in ADVANCED SHIP NOTICE DOCUMENT.
AGENCY	Reference	Subtype of party, who collects the customer debt on behalf of the CARRIER under some financial agreements. For example: Booking agency Debt collection
AIRCRAFT	Reference	An aircraft is a machine that is able to fly. It counters the force of gravity by using either static lift or by using the dynamic lift of an airfoil, or in a few cases the downward thrust from jet engines.
AIRCRAFT DISPATCH	Base	TBS
AIRCRAFT TURN AROUND	Base	The time required to unload an airplane after its arrival at the gate and to prepare it for departure again.
AIRCRAFT TYPE	Lookup	Lookup for the type of Aircraft. For example: Boeing 737.
AIRCRAFT VERSION	Reference	Specifies information about the AIRCRAFT TYPE. For example, if AIRCRAFT TYPE is Boeing 737 then aircraft version could be 800.
AIRPORT	Reference	Specifies an International Air Transport Association (IATA) recognized location that serves as an Origin or Destination of one or more flights, including details for the Airport. For example: Country City Region
ALTERNATIVE ITEMS	Reference	List of inventory items that can be used, identifies interchangeable parts that can be used at a location.
AMOUNT TYPE	Lookup	Specifies the different types of amount. This is similar to the different types of revenue and cost. For example: Actuals Budget 2015 v1 Budget 2015 v2
ASSET_DATA_DRAFT	Base	Data that relates to the asset usage.
ATA CHAPTER	Lookup	ATA chapter numbers - common referencing standard for all commercial aircraft documentation.
AWARD VOUCHER	Reference	Specifies the award voucher given by an airline.
BANK	Reference	Specifies information about banks.
BANK CARD	Reference	A bank card issued by a bank or credit organization.
BANK CARD TYPE	Lookup	Lookup for the type of the BANK CARD. For example: Credit card Debit card
BANNING REASON	Lookup	Lookup defining reasons a customer may be banned from using a service.
BASE DAY	Reference	The abstracted information about a day, which serves as a base for DAY.
BILLING ANALYSIS HEADER	Base	Billing Analysis System Output Information.
BILLING ANALYSIS TOTALS CURRENCY	Base	Billing Office Subtotals per Transaction Code and Currency Type.
BILLING OFFICE HEADER	Base	The header of a billing office transaction document.
BILLING OFFICE SUBTOTALS TRANSACTION CURRENCY	Base	Billing Office Subtotals per Transaction Code and Currency Type.
BILLING OFFICE TOTALS CURRENCY	Base	Billing Office Totals per Currency Type.
BILLING TRANSACTION AGENCY AIRLINE INFO	Base	Airline agency detailed information from billing transaction data.
BILLING TRANSACTION COMPLETE FORM OF PAYMENT	Base	The information about billing transaction complete form of payment.
BILLING TRANSACTION COMPLETE TICKET DOCUMENT	Base	The billing transaction complete ticket document information.
BILLING TRANSACTION COUPON ADDITIONAL PRINT LINES	Base	Additional information of billing transaction coupon.
BILLING TRANSACTION DOCUMENT AMOUNTS	Base	Detailed amount data from the transaction document.
BILLING TRANSACTION ELECTRONIC TRANSACTION	Base	The control data of each billing transaction.
BILLING TRANSACTION EMD COUPON DETAIL	Base	The billing transaction coupon detail data from the ELECTRONIC MISCELLANEOUS DOCUMENT (EMD).
BILLING TRANSACTION EMD REMARKS	Base	The billing transaction remarks from the ELECTRONIC MISCELLANEOUS DOCUMENT(EMD).
BILLING TRANSACTION FARE CALCULATION	Base	The fare calculation elements of billing transaction.
BILLING TRANSACTION FILE TOTALS CURRENCY	Base	The currency information of billing transaction.
BILLING TRANSACTION FORM OF PAYMENT	Base	The payment data of each billing transaction.
BILLING TRANSACTION HEADER	Base	Billing transaction header data.
BILLING TRANSACTION MD ADDITIONAL INFO	Base	Billing transaction additional information from MISCELLANEOUS DOCUMENT.
BILLING TRANSACTION MD INFO AMOUNT	Base	Billing transaction amount information from MISCELLANEOUS DOCUMENT.
BILLING TRANSACTION MD ISSUANCE REASON	Base	Billing transaction issuance reason information from MISCELLANEOUS DOCUMENT.
BILLING TRANSACTION NETTING VALUES	Base	Billing transaction netting values.
BILLING TRANSACTION PAYMENT AUTHORIZATION	Base	Billing transaction payment authorization information.
BILLING TRANSACTION PREPAID TICKET ADVICE SPONSOR INFORMATION	Base	Billing transaction prepaid ticket advice sponsor information.
BILLING TRANSACTION RELATED TICKET	Base	The information about billing transaction related ticket.
BILLING TRANSACTION TICKET	Base	The information about billing transaction ticket.
BILLING TRANSACTION TICKET AMOUNT	Base	The amount information about billing transaction ticket.
BILLING TRANSACTION TICKET COMMISSION	Base	The commission information about billing transaction ticket.
BILLING TRANSACTION TICKET FORM OF PAYMENT	Base	Form of payment information of billing transaction ticket.
BILLING TRANSACTION TICKET ITINERARY DATA SEGMENT	Base	Billing transaction ticket itinerary data segment.
BILLING TRANSACTION TICKET MISCELLANEOUS ADDITIONAL PRINT LINES	Base	Billing transaction ticket miscellaneous additional print lines.
BILLING TRANSACTION TICKET PASSENGER	Base	The passenger information of billing transaction ticket.
BILLING TRANSACTION TICKET QUALIFYING ISSUE INFORMATION	Base	Billing transaction ticket qualifying issue information.
BILLING TRANSACTION TICKET TAX ON COMMISSION	Base	The tax on commission data for billing transaction ticket.
BILLING TRANSACTION TICKET VAT INFORMATION	Base	The Value Added Tax (VAT) information of billing transaction ticket.
BLACK LIST HISTORY	Base	To keep track of black listed customers. Those records might be because of late payment, default, or fraud.
BOOKING	Base	The entity used to store all the main booking related information. This is at each individual passenger level and segment level.
BOOKING AGENT OPT LINE	Base	The detailed operations for each agent and each booking.
BOOKING BILLING	Base	The billing information about each booking.
BOOKING CAMPAIGN ASSIGNMENT	Base	This is an operational layer entity which stores the details of the campaigns related to the booking.
BOOKING CLASS	Reference	Information about the booking class and its corresponding service class for the CARRIER. For example, Service Class is Economy, and Booking Class may be A, B, C, and D. This booking class can fall under different services at a different point of time.
BOOKING CLASS TYPE	Reference	Booking class type is another type of grouping of booking class, other than "Service Class". You can define your own grouping rule according to your business scenario.
BOOKING DAILY INVENTORY SNAPSHOT	Aggregate	Specifies the status of bookings, cancelations, confirmations, and so on, as on date for future departures starting the next day. The major dimensions of analysis for this fact are: Traffic category Segments Flights Snapshot date Booking Class Segment departure date
BOOKING FACT	Derived	Defines at the granularity of BOOKING SSRs, BOOKING REMARKs, OPTIONs, and, BOOKING OTHER SERVICEs attached to each BOOKING.
BOOKING OFFICE	Reference	Designator for a Travel Agent or Airline office as designated by IATA, a Global Distribution System (GDS), or an Airline.
BOOKING OFFICE USER	Reference	This is an operational layer entity which stores the user ids given to the agent using which they login to the system to do the booking. All agents belong to an office. These signs are sets of user ids assigned to the offices.
BOOKING OTHER SERVICE	Reference	Specifies free text of the booking for a CARRIER.
BOOKING PASSENGER	Reference	Passenger information for the booking. For example: Last name First name Gender Note: A booking can only have two passengers if there is an unseated infant.
BOOKING PASSENGER DOCUMENT INFORMATION	Reference	Personal details of the passenger. For example: Gender Nationality Date of birth
BOOKING PRODUCT	Reference	Product information associated with the BOOKING. For example, a CAMPAIGN.
BOOKING PRODUCT DETAIL	Reference	Specifies the details of the booking products. For example: Fare Membership level Discount rate
BOOKING PRODUCT TYPE	Lookup	Specifies the product type. For example: Summer holiday package New year three day trip
BOOKING REMARK	Reference	Different remarks for the BOOKING and the PNR.
BOOKING SEAT	Reference	This is an operational layer entity which stores the name of the seat number and seat status for the BOOKING.
BOOKING SEAT PREFERENCE	Reference	Represents preferences of seat by the passenger specified during BOOKING. One seat can have multiple preferences. For example: window, aisle.
BOOKING SERIES	Reference	Tour operators (or sales people/Group Analysts on their behalf) enter their series requests for the upcoming season into the system. Each series request is for a certain number of seats, one-way on a certain segment, on a certain weekday for a certain period. The series itself is entered as a BOOKING and then every BOOKING that is part of that series is also entered as a BOOKING with a similar identifying Series-OSI- line. All bookings that belong to a certain series, whether it is the series itself or real BOOKINGs belonging to that series, have to be grouped together in a series-container.
BOOKING SSR	Base	Represents the status of the Special Service Request (SSR) and CARRIERs of the Special Service Requests for BOOKINGs.
BOOKING SSR BRDG	Reference	Represents a bridge table used to store information about the Special Service Requests (SSRs) used in a BOOKING.
BOOKING STATUS CHANGE HISTORY	Base	Describes the BOOKING change history.
BOOKING STATUS CHANGE REASON	Lookup	Describes the BOOKING change reason.
BOOKING TST	Reference	Defines a Transitional Store Ticket (TST) generated with the BOOKING. The TST can be reused for other BOOKINGs having similar parameters. This determines the booking fare. A BOOKING can have two TSTs only if the passenger has an unseated infant.
BOOKING TST FARE DATA	Base	Booking transaction store ticket fare data.
BOOKING TST PFC TAX AMOUNT	Base	Booking transaction store ticket tax data.
BOOKING TST PRICE	Reference	Pricing information details for Transitional Store Ticket (TST).
BOOKING TST SEGMENT	Reference	Segment details of Transitional Store Ticket (TST), which has fare basis and stop over indicator information.
BOOKING TST TAX	Base	Booking TST Tax information.
BORROW_TRANSACTIONS	Base	TBS
BUSINESS HALF MONTH	Reference	Defines month-in-half in a business calendar.
BUSINESS HALF YEAR	Reference	Defines half year in a business calendar.
BUSINESS LEGAL STATUS	Lookup	The legal status of the company. For example: Public Company Private Company
BUSINESS MONTH	Reference	Defines month in a business calendar.
BUSINESS QUARTER	Reference	Defines quarter in a business calendar.
BUSINESS UNIT JOB ROLE	Reference	Capture the specific job role for an organization.
BUSINESS UNIT SHIFT	Reference	Work shift associated with the Business Unit, mapped to the EMPLOYEE job roles for the allocation for these shifts. For example, there could be two shifts for a cashier in a store per day: 6:00am-2:00pm, 2:00am-10:00pm.
BUSINESS UNIT TYPE	Lookup	Lookup for ORGANIZATION BUSINESS UNIT types.
BUSINESS WEEK	Reference	Weeks as defined in the business calendar.
BUSINESS YEAR	Reference	Defines year in a business calendar.
CALENDAR	Reference	Describes the date hierarchy with a granularity as date and then gives week, month, quarter, and year.
CALENDAR HALF MONTH	Reference	Defines month-in-half in a Gregorian or Normal Calendar.
CALENDAR HALF YEAR	Reference	Defines half year in a Gregorian or Normal Calendar.
CALENDAR MONTH	Reference	Calender month in a Gregorian or Normal Calendar.
CALENDAR QUARTER	Reference	Defines quarter in a Gregorian or Normal Calendar.
CALENDAR WEEK	Reference	Defines weeks in a Gregorian or Normal Calendar.
CALENDAR YEAR	Reference	Defines years in a Gregorian or Normal Calendar.
CALL CENTER	Reference	The carrier may have multiple call centers in different locations, for different time zones, or language purposes.
CALL CENTER AGENT	Reference	All the possible agents with whom the customer can make a contact. For example: IVR Human Agent
CALL CENTER PERFORMANCE	Derived	Specifies the daily performance summary data about call center.
CALL CENTER SERVICE CAPABILITY	Reference	Assigns the languages, products, or geographical areas which the call center can serve to the call center.
CAMPAIGN	Reference	A campaign is a concentrated effort to enhance the image of the enterprise to retain, acquire, or consolidate customers.
CAMPAIGN MEDIA	Reference	Advertising MEDIA associated with a CAMPAIGN.
CAMPAIGN MANAGEMENT HISTORY	Reference	The history of the campaign party role about the management of a campaign. The party can be not only the sales or marketing employee at the carrier, it can also be a campaign partner.
CAMPAIGN MEDIA SELLING ITEM	Reference	Items presented to the customer or public as part of the CAMPAIGN.
CAMPAIGN MESSAGE	Reference	Holds details about the execution message used in a CAMPAIGN.
CAMPAIGN STATUS	Lookup	Describes the strategy or business objective of the CAMPAIGN.
CAMPAIGN TYPE	Lookup	This entity keeps types of CAMPAIGNs. For example: A targeted promotion (to specific individuals, account or group of accounts) A mass market promotion (to a massive audience usually through radio, television, and newspaper)
CAR PRODUCT	Reference	One of the product type, car, example: rental car service
CAR RENTAL	Base	The main entity to store the car rental transaction information.
CAR RENTAL ADDITIONAL RATE CODE INFO	Base	Car rental additional rate related information.
CAR RENTAL CHARGE PERIOD	Base	The rental car charge period information.
CAR RENTAL ESTIMATE DISTANCE	Base	Car rental estimate distance with different rental type
CAR RENTAL FOP	Base	Car rental form of payment.
CAR RENTAL LOCATION	Reference	Car rental related location information. For example pick up location.
CAR RENTAL MODEL	Base	The rental car model information.
CAR RENTAL OTHER RATE RULE	Base	The other rules of the different type of rental car package.
CAR RENTAL OTHER RATE RULE DATE	Base	The other rate rule related date information of the car rental.
CAR RENTAL PREFERENCE TYPE	Base	The customer preference car type data.
CAR RENTAL REMARKS	Base	The remarks of rental car transaction.
CAR RENTAL SURCHARGE PERIOD	Base	The surcharge period of the car rental transaction.
CAR RENTAL SURCHARGE PERIOD TARIFF	Base	The car rental surcharge period tariff.
CAR RENTAL TARIFF	Base	The car rental tariff information.
CAR RENTAL TARIFF CHARGE	Base	The car rental tariff charge information.
CARRIER	Reference	Specifies the details about the carrier, such as carrier code and description. Carrier means the airline issuing the ticket and all airlines that carry or undertake to carry the Passenger and or his baggage thereunder or to perform any other service related to such air carriage (IATA PAT-GR-1).
CARRIER TYPE	Reference	Carrier type details. For example: Airline Railway On road transport Ship
CERTIFICATE	Reference	A certificate with a face monetary value issued by a store for subsequent exchange for merchandise.
CHANNEL	Reference	The different types of channel of airline, including booking or ticketing channel, check-in channel, marketing channel, and so on.
CHANNEL TYPE	Lookup	Lookup for channel types. For example: Selling Distribution
CHECKIN	Base	Specifies the checking information at the LEG level. TICKET, flight ID, passenger ID can be derived from the booking ID for the PDI record. Provides the departure and arrival airport of the PDI from the LEG of the PDI. The LEG of the PDI is obtained using the booking ID and board and offpoint: You can refer booking ID for the PDI and get the flight and segment information for that particular date. Then refer flight schedule with the flight, segment and date for that booking ID it will give a unique LEG ID.
CHECKIN BAGGAGE GROUP	Reference	Defines information about the number of baggage checked-in, part of a baggage group, weight of the checked baggage of a group, number of hand baggage contained in the baggage group, and so on.
CHECKIN DAILY FACT	Aggregate	Daily fact for which data gets uploaded once at the end of day for the data to be available to the business users the next day. For example: Total number of check-ins for a day for a particular flight Total number of check-ins for a day for a segment Total number of check-ins for a day for a LEG Includes other measures. For example, total number of passengers checked-in on a particular day and is also based on other dimensions.
CHECKIN FACT	Derived	Check-in information at the LEG level.
CHECKIN INDIVIDUAL BAGGAGE	Reference	Information about the individual baggage during the check-in process. This information is mainly baggage tag, baggage source, baggage tag number, baggage tag final destination, and airline code.
CODESHARE	Reference	A marketing practice in which two or more airlines agree to share for marketing purposes. The same two letter code used to identify CARRIERs in the computer Reservation systems used by travel agents. Stores the details of the code share.
CODESHARE BRIDGE	Reference	Details about the code share flights along with the segment and CARRIER to which the flight belongs.
CODESHARE BRIDGE FACT	Aggregate	Specifies details about the codeshare flights along with the segment and CARRIER to which the flight belongs.
COMP INTEL CHARACTERISTIC	Reference	A characteristic quality or a distinctive feature of a Competitor Intelligence. The characteristic can be take on a discrete value, such as number of press releases, can take on a range of values, (for example, number customers within a MARKET SEGMENT (50,000 - 100,000), or can be derived from a formula (for example, number of products offered in a MaketSegment = the number of the Competitor's Product instances associated to the MARKET SEGMENT).
COMP INTEL CHARACTERISTIC VALUE	Reference	A number or text that can be assigned to a COMP INTEL CHARACTERISTIC.
COMP INTEL MARKET SEGMENT	Reference	A MARKET SEGMENT in which a Competitor makes Product available.
COMP PROD CRRL CHARACTERISTIC ASSIGNMENT	Reference	Assign the Competitor Product Correlation CHARACTERISTIC to the related competitor intelligence characteristic.
COMP PROD CRRL CHARACTERISTIC VALUE	Reference	A number or text that can be assigned to a CompProdCorrelationCharacteristic.
COMPENSATORY EARNING	Base	Specifies what the airline company awards, as points to customer as compensation for baggage lost or for a complaint.
COMPENSATORY REASON	Lookup	Lookup for the reason why compensatory points are awarded to a customer.
COMPETITIVE TIER	Reference	Type of Competitors according to their size, revenue, line of product, and so on. A classification of a Competitor, such as by size, product lines offered, and so forth.
COMPETITOR	Reference	A PARTY that offers Product similar to the enterprise's PRODUCT ENTITY in a MARKET SEGMENT.
COMPETITOR INTELLIGENCE	Reference	Intelligence gathered about each competitor. Facts gathered about a Competitor's plans and activities. These facts can be used to perform Competitor SWOT analysis to better understand a Competitor.
COMPETITOR INTELLIGENCE PARTY ROLE	Reference	Specifies the PARTY who generated the intelligence.
COMPETITOR MARKET SEGMENT ASSIGNMENT	Reference	A MARKET SEGMENT served by a Competitor.
COMPETITOR MARKET SEGMENT SWOT	Reference	Strength, Weakness, Opportunity, or Threat in a MARKET SEGMENT served by a Competitor.
COMPETITOR PRODUCT CORRELATION	Reference	How the product market plan are related to competitor product market plans, with its all flexible characteristics.
COMPETITOR SWOT	Reference	General (non-MARKET SEGMENT specific) Strength, Weakness, Opportunity, or Threat when compared to a Competitor.
COMPETITOR TIER ASSIGNMENT	Reference	A classification of a Competitor, such as by size, product lines offered, and so forth.
COMPLAIN ADVICE	Base	Defines a complaint or advice from customer, it is a subtype of PARTY INTERACTION THREAD.
COMPLAIN CLASS	Lookup	Lookup for the level of the complaint. For example: High Normal
COMPLAIN TYPE	Lookup	Lookup for the complaint type. For example: Service complaint Baggage lost complaint
CONTRACT	Reference	Legal agreement between two parties, it could be VENDOR CONTRACT or CUSTOMER CONTRACT.
CONTRACT STATUS	Reference	The status history of the CONTRACT. For example: Terminated Normal Expired
CONTRACT STATUS REASON	Lookup	Lookup for description of the contract status change. For example: Customer originated: Product upgrade Provider originated: Bad payment (leading to suspension) Customer originated: Debt paid (leading to reactivation) Customer originated: Complaint
CONTRACT STATUS TYPE	Lookup	Lookup for all possible types of CONTRACT STATUS. For example: Newly created for new account Renewed automatically Naturally expired or terminated
CONTRACT TERM TYPE	Lookup	Lookup for all possible terms which may be attached to a CONTRACT. For example: Monetary amount Period Premium Initial points Cancellation policy Subsidy
CONTRACT TERM VALUE	Reference	The value of terms attached to the CONTRACT. For example: Monetary amount Period Premium Initial points The value can vary at different time periods of the CONTRACT. For example, the monthly fee might be 100 for the first six months and 80 for the last six months. A penalty calculation can also be based on the months left in the contract.
CORPORATE CUSTOMER	Reference	The details for the corporate customer. For example: Name Location Customer division
COST	Base	Define the cost might incurred from any operation or an event which is trackable at a certain level. For example are: Gift offer expense Employee salary Commission Promotion delivery cost Air bridge cost
COST CENTER	Reference	To categorize the different cost charges inside the CARRIER for different purpose. An organization can own multiple cost centers for different project/product operations.
COUNTERS		Capture usage: flight hours and flight cycles
CREDIT SCORE PROVIDER	Reference	Specifies reference financial rating scores for each customer to the service provider. It is also called Credit rating agency.
CURRENCY	Lookup	Currency information
CUSTOMER	Reference	A customer is the recipient of a good, service, product, or idea, obtained from a seller, vendor, or supplier for a monetary or other valuable consideration. For example: A passenger is a customer A person who booked a ticket but canceled later is also a customer for an airline
CUSTOMER ACCOUNT	Reference	A cddharge account or other accounting relationship a customer has with the organization. An account exists to allow the store to record a series of transactions with the same customer and keep an ongoing record of monies owed by the customer and monies due to the customer.
CUSTOMER ADDRESS	Reference	Associative entity assigning a CUSTOMER to one or more ADDRESS LOCATION.
CUSTOMER CONTRACT	Reference	Legal agreement between a retailer and a CUSTOMER.
CUSTOMER INVOICE	Base	A summarized list of charges, including payment terms, invoice item information, and other information that is sent to a CUSTOMER for payment.
CUSTOMER INDIVIDUAL	Reference	Subtype of CUSTOMER (and PARTY), which contains details of individuals as opposed to organizations.
CUSTOMER INVOICE	Base	A summarized list of charges, including payment terms, invoice item information, and other information that is sent to a CUSTOMER for payment.
CUSTOMER INVOICE ITEM	Base	A single line of an invoice.
CUSTOMER LIFE TIME VALUE SUPPORT VECTOR MACHINE FACTOR	Derived	Represents Support Vector Machine (SVM) factors of attributes of customers, derived from customer life time value support vector machine mining model.
CUSTOMER LOYALTY DECISION TREE RULES	Derived	Represents Decision Tree rules, derived from customer loyalty decision tree mining model.
CUSTOMER LOYALTY SUPPORT VECTOR MACHINE FACTOR	Derived	Represents Support Vector Machine (SVM) factors of attributes of customers, derived from customer loyalty support vector machine mining model.
CUSTOMER MINING	Derived	Represents results of customer related mining models on latest customer data.
CUSTOMER OCCASION	Reference	Describes an event celebrated or observed by a customer. For example: Birthday Anniversary Company establishment day
CUSTOMER OCCASION TYPE	Lookup	A categorization of CUSTOMER OCCASIONs.
CUSTOMER ORDER	Base	ORDER placed by a CUSTOMER for merchandise or services to be provided at some future date and time.
CUSTOMER ORDER LINE ITEM	Base	A line item component of a CUSTOMER placed ORDER.
CUSTOMER ORDER LINE ITEM STATE	Base	Describes the state of fulfillment of a CUSTOMER ORDER LINE ITEM.
CUSTOMER ORDER STATE	Base	Defined state for an ORDER. Possible values include: Pending Partially Delivered Complete Canceled
CUSTOMER ORDER TAX EXEMPTION MODIFIER	Base	A line item component of a CUSTOMER placed ORDER, recording any Tax exemptions that the ordering CUSTOMER may receive.
CUSTOMER ORDER TAX LINE ITEM	Base	A line item component of a CUSTOMER placed ORDER, recording the tax liability that the entire order is incurring.
CUSTOMER ORDER TAX OVERRIDE MODIFIER	Base	A line item component of a CUSTOMER placed ORDER, recording any Tax rate overrides that the ordering CUSTOMER may receive.
CUSTOMER ORDER TENDER PRE AUTHORIZATION	Base	A line item component of a CUSTOMER placed ORDER, recording any credit or debit card pre-authorization that is performed at the time the order is taken.
CUSTOMER ORGANIZATION	Reference	Subtype of CUSTOMER (and PARTY), which contains details of organizations as opposed to individuals. Note: An organization can also consist of only one individual.
CUSTOMER PAYMENT	Base	Amount disbursed to RETAILER by CUSTOMER in response to a CUSTOMER INVOICE.
CUSTOMER RECENCY FREQUENCY MONETARY PROFITABILITY SCORE	Derived	Represents customers recency, frequency, monetary, and profitability score at a month level.
CUSTOMER RESTRICTED INFO	Reference	It captures the restricted information for the customer or prospects.
CUSTOMER REVENUE BAND	Lookup	Customer classification in its income/revenue term. For example: Customer with income/revenue of $10000/Month Organization with 1Billion/Year
CUSTOMER REVENUE BAND ASSIGNMENT	Reference	Determine revenue band of the customer. CUSTOMER REVENUE BAND may drift month by month.
CUSTOMER REVENUE TYPE	Lookup	Lookup for type of revenue a customer may bring to the CARRIER.
CUSTOMER SCORE	Reference	Score ranges that may be assigned to a customer based on credit, behavior, or other criteria. For example,,1,2,3,4,5 or 1~10,11~20. Customer score can be rated based on the Customer Behavior, Credit, or another criteria.
CUSTOMER SEGMENT	Reference	The Segments table contains details of customer segments identified by business analysis activities, for example, data mining. A segment identifies distinct groupings of customers or accounts with similar characteristics. The segments are typically used in marketing campaigns.
CUSTOMER SEGMENTATION MODEL	Reference	The segmentation model used to profile the customers. For example, KMeans by Revenue from Market Department, O-Clustering by IT department, and so on.
CUSTOMER SOURCE	Aggregate	Describes how the customer came in touch with the sales team. For example: Campaign, Advertisement, Call center, Dealer, and so on. It is important for campaign planning and management.
CUSTOMER SURVEY AGG	Aggregate	Describes the daily summary data about customer survey result.
CUSTOMER SURVEY DERIVED	Derived	This entity contains the daily summary data about customer survey result.
CUSTOMER TYPE	Lookup	This level identifies or groups customers as corporate customers or individuals.
DAILY BOOKING FACT	Aggregate	Defines the number of BOOKINGs, confirmed, canceled, ticketed, and so on, for a particular BOOKING date and segment departure date. The granularity of the fact is at a current date. All the bookings, confirmations, and waitlisted information are calculated based on the fact that they are done on the current date. This entity is a fact table storing the number of bookings, confirmed, canceled, ticketed, and so on, for a particular booking date and segment departure date. The granularity of the fact is at a current date. All the bookings, confirmations, and waitlisted information are calculated based on the fact that they are done on the current date.
DAILY CALL CENTER PERFORMANCE	Aggregate	Specifies the daily performance summary data about the call center.
DAILY FLIGHT DETAILS	Aggregate	Specifies the daily summary data about FLIGHT details.
DAILY LOYALTY ACCOUNT	Aggregate	Specifies the daily summary data about LOYALTY ACCOUNT (for a FREQUENT FLYER).
DAILY LOYALTY ACCOUNT BOOKING	Aggregate	Specifies the daily summary data about LOYALTY ACCOUNT booking (for a FREQUENT FLYER).
DAY	Reference	Day level in the normal calendar.
DEALER	Reference	The PARTY that resells products or services from the CARRIER.
DEFECT STATUS	Lookup	TBS
DEFFERALS	TBS	Items that have been executed in the planned time - carried forward.
DELAY CAUSE	Lookup	Delay codes used to standardize the reporting of flight departure delay.
DELAYS AND CANCELLATIONS	Base	Details of the delay and its causes.
DEMOGRAPHY ATTRIBUTE	Reference	A sub-level group or category further qualifying a set of data (Profile Group) collected about a customer to assist in marketing efforts. For example: NC: Number of children EDL: Education level
DEMOGRAPHY GROUP	Reference	The domain of classifications used to group profile information about a PARTY. For example: CH - Credit History ED- Education EM - Employment EQ- Equipment HB - Hobbies HH - Household OR - Organization
DEPARTMENT	Reference	Identifies the department within the organization
DERIVED VALUE	Reference	Describes the derived value of the customer. These value could have multiple value types or value measures.
DIRECT EARNING	Base	Earn points from flying with this airline.
DISCOUNT GROUP	Reference	Keeps the special discount groups of employee or Partner. EMPLOYEEs in different level have a different discount group. For example: Manager's discount group Director's discount group Different Dealer or partner may also have different discount policy according to their relationship with Service provider and sales volume.
DISPOSITIONS	Base	Identifies the condition of the item and suggested actions
DOCUMENT	Reference	Document record.
EARNING EVENT	Base	This event records all the point earnings of LOYALTY ACCOUNT.
EDUCATION	Reference	The education level of the customer.
EMAIL ADDRESS	Reference	E-mail address associated with a location.
EMPLOYEE	Reference	Employee of the carrier. This is a sub entity of party individual.
EMPLOYEE ACTUAL LABOR HOURLY	Base	The actual shifts the hourly employees have worked in, including break time.
EMPLOYEE ACTUAL LABOR SALARIED	Base	This table records the actual shifts worked in for the salaried employees. To be further investigated, difference with "xxx hourly".
EMPLOYEE DESIGNATION	Lookup	The various designations present in an organization for the employees.
EMPLOYEE DISCOUNT GROUP ASSIGNMENT	Reference	The relationship between employee discount groups. An employee must have multiple discount groups, and several employees must have the same discount group.
EMPLOYEE JOB ROLE ASSIGNMENT	Reference	Keep the relationship between employee and job role.
EMPLOYEE LANGUAGE CAPABILITY	Reference	The languages the employee can serve, especially for call center agent and sales shopper representatives.
EMPLOYEE RESTRICTED INFO	Reference	Specifies the restricted information for the employee.
EMPLOYEE SCHEDULE	Reference	Describes the planned schedule for an employee, which consists of the store, job role, and shift the employee is working.
EMPLOYEE TRAINING RECORD	Base	A record that a particular employee has been trained in performing a particular task.
EMPLOYEE TYPE	Lookup	This lookup describes types of EMPLOYEE. For example: Part Time Contractual Full Time
ENVIRONMENT TYPE	Lookup	Defines the temperature, relative humidity, lighting, and other physical or climatic environmental requirements for storing and displaying the item.
EVENT	Base	An event captures information pertaining to the aircraft or flight. For example, this is a ACARS message, an In Flight Shutdown, Air Turn back, or so on.
EVENT PARTY ASSIGNMENT	Base	This entity relates parties with events. A PARTY can have many events; and an event can involve many parties.
EVENT PARTY INTERACTION	Base	The PARTY INTERACTION table records all interactions or communications with the customer. The interactions include: Faults Direct mail, SMS, email Service calls Complaints Debt collection Inbound and outbound telemarketing
EXTERNAL CREDIT PROFILE	Reference	A source of information that helps define a credit worthiness of the customer.
EXTERNAL CREDIT PROFILE ASSIGNMENT	Reference	To indicate which external agency/institute provided the credit profile for the given customer.
EXTERNAL ORGANIZATION TYPE	Lookup	The type of different external organization.
FARE ELEMENT	Reference	Specifies the fare element details of the BOOKING and the TSM. This is an operational layer entity which stores the fare element details of the booking and TSM.
FARE TYPE	Reference	Fare Type means a designator that is used to Categorize Fares. For example: APEX PEX IT It stores booking class fare types. This is an analytical layer dimension which stores the booking class fare types.
FISCAL HALF MONTH	Reference	Defines half-month in a fiscal calendar.
FISCAL HALF YEAR	Reference	Defines half-year in a fiscal calendar.
FISCAL MONTH	Reference	Defines month in a fiscal calendar.
FISCAL QUARTER	Reference	Defines quarter in a fiscal calendar.
FISCAL WEEK	Reference	Defines week in a fiscal calendar.
FISCAL YEAR	Reference	Defines year in a fiscal calendar.
FLEET	Lookup	A group or assemblage of aircraft
FLEET_HEADERS	Reference	Details about a group or assemblage of aircraft
FLEET UNIT ASSOCIATE	Base	Assignment details of individual aircraft into the fleet.
FLIGHT	Reference	Information about the flight is stored. For example, the CARRIER which it belongs to or if there is an alpha suffix. This is an operational layer entity which stores the information about the flight. For example, the CARRIER which it belongs to or if there is an alpha suffix associated.
FLIGHT CANCELLATION REASON	Lookup	Code detailing the reason for a flight cancelation.
FLIGHT_DATA_DRAFT	Base	Information snapshot of a selection of aircraft parameters.
FLIGHT CHANGE	Base	Subtype of PARTY INTERACTION THREAD, about flight change or cancelation.
FLIGHT DETAILS FACT	Derived	Provides information about LEG and segment of a particular flight. The airport and the aircraft information is at the LEG level.
FLIGHT GATE OPERATION	Base	TBS
FLIGHT INVENTORY	Reference	The main entity for airline flight inventory information.
FLIGHT INVENTORY NUMBER OF UNITS	Reference	Specifies the number of units of data which are used to present different KPIs for flight inventory.
FLIGHT INVENTORY OPERATION TYPE	Lookup	The different operation type of flight inventory.
FLIGHT INVENTORY OPERATIONS	Reference	The operations of flight inventory.
FLIGHT INVENTORY SCHEDULE ASSIGNMENT	Reference	The assignment entity to manage the many to many relationship between flight inventory and flight schedule.
FLIGHT INVENTORY STATUS	Reference	The status of flight inventory.
FLIGHT LEG INVENTORY	Reference	The flight inventory data at LEG level.
FLIGHT LEG INVENTORY CABIN	Reference	The cabin configuration data at LEG level.
FLIGHT LEG INVENTORY CABIN BLOCKSPACE	Reference	The block space information about each cabin at LEG level.
FLIGHT LEG INVENTORY CABIN ACV CONFIG	Reference	The LEG level cabin configuration for each aircraft.
FLIGHT LEG INVENTORY CABIN RMS	Reference	Revenue control value for the leg-cabin.
FLIGHT LEG INVENTORY CABIN SALECONFIG	Reference	The LEG level cabin configuration for marking sales.
FLIGHT LEG INVENTORY CABIN SALECONFIG CHARACTERISTIC	Reference	The detailed characteristics of the cabin configuration.
FLIGHT LEG INVENTORY SSR	Reference	The special service request (SSR) for flight inventory at LEG level.
FLIGHT LEG INVENTORY SSR OPTION	Reference	The other options for special service request (SSR) at LEG level.
FLIGHT LEG INVENTORY STATUS	Reference	The LEG level inventory status.
FLIGHT OPERATION DERIVED	Derived	TBS
FLIGHT SCHEDULE	Base	Information about schedule of the flight from the FLD system. Provides, on a daily basis, what are the FLIGHTs and how each FLIGHTs segments and LEG and what are their expected departure and arrival time at the LEG level.
FLIGHT SEGMENT INVENTORY	Reference	The Segment level inventory main entity.
FLIGHT SEGMENT INVENTORY CABIN	Reference	This is the flight segment inventory information at a cabin level.
FLIGHT SEGMENT INVENTORY CABIN BOARDING FIGURES DCS	Reference	The segment level inventory update by DCS input.
FLIGHT SEGMENT INVENTORY CABIN BOOKING CLASS	Reference	The cabin class data at segment level.
FLIGHT SEGMENT INVENTORY CABIN BOOKING CLASS BOARDING FIGURES DCS	Reference	The segment level cabin booking class boarding data.
FLIGHT SEGMENT INVENTORY CABIN BOOKING CLASS CODESHARE BOARDINGFIGURES DCS	Reference	The segment level boarding figures related to code share flight.
FLIGHT SEGMENT INVENTORY CABIN BOOKING CLASS CODESHARE DCS	Reference	The segment level cabin class configuration.
FLIGHT SEGMENT INVENTORY CABIN BOOKING CLASS STATUS	Reference	Segment level cabin class status.
FLIGHT SEGMENT INVENTORY CABIN BOOKING SUBCLASS	Reference	Segment level cabin subclass.
FLIGHT SEGMENT INVENTORY CABIN BOOKING SUBCLASS AVAILABILITY	Reference	Segment level cabin subclass availability.
FLIGHT SEGMENT INVENTORY CABIN BOOKING SUBCLASS COUNTERS	Reference	The segment level cabin subclass counters.
FLIGHT SEGMENT INVENTORY CABIN BOOKING SUBCLASS DATEFLAG	Reference	The segment level cabin subclass date flags.
FLIGHT SEGMENT INVENTORY CABIN BOOKING SUBCLASS FLAG	Reference	The segment level cabin subclass flag data.
FLIGHT SEGMENT INVENTORY CABIN BOOKING SUBCLASS NEGO	Reference	The segment level cabin subclass NEGO.
FLIGHT SEGMENT INVENTORY CABIN BOOKING SUBCLASS YIELD	Reference	Segment level cabin subclass yield.
FLIGHT SEGMENT INVENTORY CABIN BOOKINGCLASS BOARDING FIGURES DCS	Reference	The segment level cabin boarding data from DCS.
FLIGHT SEGMENT INVENTORY CABIN CODESHARE	Reference	The segment level cabin inventory data for code share flight.
FLIGHT SEGMENT INVENTORY CABIN CODESHARE BLOCKSPACE COUNTER	Reference	The segment level cabin blockspace data for code share flight.
FLIGHT SEGMENT INVENTORY CODESHARE	Reference	The segment level inventory data for code share flight.
FLIGHT SEGMENT INVENTORY STATUS	Reference	The segment level inventory status data.
FLIGHT SEGMENT INVENTORY TRAFFIC RESTRICTION	Reference	The segment level inventory traffic restriction data.
FORM OF PAYMENT	Reference	All forms of payment.
FREIGHT DOCUMENT	Base	A carrier-originated document that lists the number of containers, for example, pallets, cartons, and so on, that were delivered. The freight bill does not reference the inner contents of a shipment.
FREQUENT FLIER BOOKING FACT APPLY	Mining	Represents customer booking related facts for a period of months in the past.
FREQUENT FLIER BOOKING FACT SOURCE	Mining	Represents customer booking related facts for a period of months in the past.
FREQUENT FLIER CUSTOMER LIFE TIME VALUE APPLY	Mining	Represents customer life time value prediction mining model.
FREQUENT FLIER CUSTOMER LIFE TIME VALUE SOURCE	Mining	Represents customer life time value prediction mining model can be applied to predict the life time value of customers.
FREQUENT FLIER CUSTOMER LOYALTY APPLY	Mining	Specifies customer loyalty prediction mining model that can be applied to predict the loyalty of customers.
FREQUENT FLIER CUSTOMER LOYALTY SOURCE	Mining	Provides source information for customer loyalty prediction mining model.
FREQUENT FLIER CUSTOMER PROFILE APPLY	Mining	Represents customer segmentation mining model that can be applied.
FREQUENT FLIER CUSTOMER PROFILE SOURCE	Mining	Represents the source for customer segmentation mining model.
FREQUENT FLYER	Reference	Frequent Flyer is an individual, whose frequency of usage of the airline is higher than normal passengers. Entity represents information about the frequent flyer. For example: Membership level Start date Airline
FREQUENT FLYER PREFERENCE	Reference	The different types of preference of frequent flyer passenger.
FREQUENT FLIER LOYALTY ACCOUNT BALANCE APPLY	Mining	Represents customer LOYALTY ACCOUNT balance details for the last number of months.
FREQUENT FLIER LOYALTY ACCOUNT BALANCE SOURCE	Mining	Represents customer LOYALTY ACCOUNT balance details for a period of months in the past.
FREQUENT FLIER PREDICTION APPLY	Mining	Represents non-frequent flier passengers demographic and BOOKING details. Frequent flier prediction among non-ffp mining model can be applied to predict frequent fliers among non-frequent flier passengers.
FREQUENT FLIER PREDICTION DECISION TREE RULES	Derived	Represents Decision Tree (DT) rules, derived from frequent flier prediction decision tree mining model.
FREQUENT FLIER PREDICTION SOURCE	Mining	Represents non-frequent flier passengers demographic and BOOKING details for a period months. Represents frequent flier prediction among non-frequent flier passengers mining model.
FREQUENT FLIER PREDICTION SUPPORT VECTOR MACHINE FACTOR	Derived	Provides SVM factors for attributes of non-frequent flier passengers. Those SVM factors can be derived from frequent flier prediction support vector machine mining model. SVM factor is a numeric value, which quantifies the importance of attribute in predicting the target.
GENDER	Reference	Specifies the gender. For example, male or female.
GEOGRAPHY	Reference	This is a type of dimension with a granularity of city. It has country, continent, and so on as other levels of hierarchy. This is an analytical layer entity of the type dimension with a granularity of city. It has country, continent, and so on, as other levels of hierarchy.
GEOGRAPHY DEMOGRAPHIC GROUP	Reference	User defined classifications for Demographic attributes. For example: Race Age Income
GEOGRAPHY DEMOGRAPHY ATTRIBUTES	Reference	User defined classifications for a demographic profile group. For example: Percent White Percent Black Average Age Average Income Population Population Age 0-12
GEOGRAPHY DEMOGRAPHY VALUE	Reference	Values associated with a geographic location as defined by the GEOGRAPHY DEMOGRAPHY ATTRIBUTES.
GEOGRAPHY ENTITY	Reference	Geographic entities to define the location of an address. For example: Region North State Country City Geography EMEA Americas
GEOGRAPHY HIERARCHY	Reference	Type of geographic hierarchy. For example: Sales Hierarchy Organization Location Hierarchy
GEOGRAPHY HIERARCHY LEVEL	Reference	Associative entity for GEOGRAPHY HIERARCHY and GEOGRAPHY LEVEL, mapping levels to hierarchies.
GEOGRAPHY HIERARCHY LEVEL ASSIGNMENT	Reference	Assignment of a GEOGRAPHY HIERARCHY LEVEL to a GEOGRAPHY ENTITY; assigns geography values to hierarchy levels.
GEOGRAPHY HIERARCHY VERSION	Reference	The different versions of geography hierarchy.
GEOGRAPHY LEVEL	Reference	User defined Hierarchical levels for the GEOGRAPHY HIERARCHYs.
GEOGRAPHY LEVEL ATTRIBUTE VALUE	Reference	Values as defined by geography level attributes for a GEOGRAPHY HIERARCHY LEVEL.
GEOGRAPHY LEVEL ATTRIBUTES	Reference	User defined attributes associated with a specific GEOGRAPHY LEVEL.
GROUPING	Reference	Grouping information required to determine the connecting flight. The grouping types can be marriages or a physical connection.

Table 2-2 H to Q Entity Descriptions

Entity Name	Type	Description
HALF HOUR	Reference	Half-hours defined as part of time.
HALF MONTH TODATE TRANSFORMATION	Reference	To date transformation information at the half-month level.
HALF MONTH TRANSFORMATION	Reference	Transformations for half-month. For example: This half-month last year This year last half-month
HALF YEAR TODATE TRANSFORMATION	Reference	Cumulative time transformations at the half-year level.
HALF YEAR TRANSFORMATION	Reference	Transformations for half-year. For example: This half-year last year This year last half-year
HOT FILE HEADER	Base	HOT File Control Information The Hand Off Tape (HOT) is so called because originally, this file was made available to users on a magnetic tape or floppy disk. The term has stuck and the universal generic term for the flat or text (.txt) billing file is HOT file.
HOTEL BOOKING	Base	Represents hotel booking information.
HOTEL BOOKING BILLABLE INFO	Base	The billable information for hotel booking transaction.
HOTEL BOOKING COMMISSION	Base	The commission data for hotel booking.
HOTEL BOOKING CONTACT	Reference	The customer contact information for hotel booking.
HOTEL BOOKING CUSTOMER REFERENCE	Reference	Hotel booking reference information, it can be used to linked to any event. For example, flight booking or any customer interaction.
HOTEL BOOKING FORM OF PAYMENT	Reference	The form of payment information for hotel booking.
HOTEL BOOKING MISC REMARKS	Reference	The miscellaneous remarks of hotel booking.
HOTEL BOOKING OPTION TEXT	Reference	The free text for different booking options.
HOTEL BOOKING SAVING AMOUNT	Reference	The booking saving amount. For example, if the booking is done with other bookings, this hotel booking can save a certain amount of money.
HOTEL BOOKING STATUS	Reference	The status of hotel booking.
HOTEL FACILITY	Reference	The details of hotel facility.
HOTEL PAYMENT	Reference	The payment information of hotel booking.
HOTEL PRODUCT	Reference	The service or product provided by the hotel.
HOTEL PRODUCT AMENITY	Reference	Specifies what kind of hotel facility is offered in the booking package.
HOTEL ROOM	Reference	The details of hotel room.
HOTEL TARIFF	Reference	The tariff data of hotel booking.
HOTEL TARIFF CHARGE	Reference	The tariff charge transaction of hotel booking.
HOUR	Reference	Hours defined as part of time.
HOUSEHOLD	Reference	Captures household information which the individual customer may belong to.
ICD ALLOWANCE LINE ITEM	Base	A type of INVENTORY CONTROL DOCUMENT LINE ITEM that records allowances applicable to the whole INVENTORY CONTROL DOCUMENT.
ICD CHARGE LINE ITEM	Base	A type of INVENTORY CONTROL DOCUMENT LINE ITEM that records charges applicable to the whole INVENTORY CONTROL DOCUMENT.
ICD FREIGHT LINE ITEM	Base	A type of INVENTORY CONTROL DOCUMENT LINE ITEM that records the type and amount of freight cost incurred on an INVENTORY CONTROL DOCUMENT.
ICD LINE ITEM ASSIGNMENT	Base	Associative entity between two INVENTORY CONTROL DOCUMENT LINE ITEMs.
ICD TAX LINE ITEM	Base	A type of INVENTORY CONTROL DOCUMENT LINE ITEM that records sales, use, and value added taxes applicable to the whole INVENTORY CONTROL DOCUMENT.
INDIVIDUAL DEMOGRAPHY VALUE	Reference	Individual demography value, the detailed information and its value collected about customers. For example, age has Demography group as AGE, Attribute as various bands and value as 15 years which will be stored in this entity.
INDIVIDUAL NAME	Reference	Specifies all names used by the individual party along the history.
INFLIGHT MEAL	Reference	The types of meals given during the flight. For example: VGML - Vegetarian Meal
INITIATIVE RESULT TYPE	Lookup	Lookup for all possible result of initiatives.
INITIATIVE TYPE	Lookup	The lookup for different types of Initiatives.
INTERACTION REASON	Lookup	Lookup for the reason of the interaction thread. For example: Baggage lost Change flight
INTERACTION RESULT	Lookup	Lookup for result of response received from customer interaction. For example: Satisfy Offer accepted Never call again Showed Interest without decision Dissatisfy
INVENTORY ADJUSTMENT DOCUMENT	Base	A document that captures an increment or decrement to an item's unit on hand count and or financial valuation.
INVENTORY ADJUSTMENT DOCUMENT LINE ITEM	Base	The detail line item on the INVENTORY ADJUSTMENT DOCUMENT which applies an increment or decrement to the ITEM’s unit on hand and or the financial valuation.
INVENTORY CONTROL DOCUMENT	Base	A written or printed paper, or digital equivalent, that evidences the movement of merchandise or supply SKU ITEMs.
INVENTORY CONTROL DOCUMENT ASSIGNMENT	Base	Assignment entity between INVENTORY CONTROL DOCUMENTs.
INVENTORY CONTROL DOCUMENT LINE ITEM	Base	Detail line on an INVENTORY CONTROL DOCUMENT that identifies the SKU ITEM, and unit of measure exchanged, or the freight, charges, taxes, and allowances applicable to a particular inventory control event and action.
INVENTORY ITEM STATE	Base	Location of SKU ITEMs in inventory by ORGANIZATION BUSINESS UNIT, SELLING LOCATION, INVENTORY LOCATION, by date.
INVENTORY LOCATION	Reference	Physical location where merchandise resides. INVENTORY LOCATION may be co-located at a SITE with ORGANIZATION STORE, ORGANIZATION DISTRIBUTION CENTER, or ADMINISTRATION CENTER and does not include containers, ships, and trucks that are in transit.
INVENTORY SPACE ALLOCATION	Base	Allocation of INVENTORY LOCATION for SKU ITEMs during a given time frame. Allocation does not indicate inventory levels or existence of SKU ITEMs in the INVENTORY LOCATION.
ITEM	Reference	A level in a product hierarchy frequently used for business analysis. An item can be a group of Stock Keeping Units (SKU)s where each SKU is the same item but varies in size, weight, color, or other attributes. Item is sometimes referred to as an article, product, or bundle of SKUs. For example, item could be Acme shirt, with associated SKUs for each color and size of the shirt.
ITEM INVENTORY JOURNAL ENTRY	Base	The record of a change in an Item Inventory holding that is applied to an Item Inventory account.
ITEM SEASON	Reference	Associative entity for ITEM, SEASON, and PHASE.
JOB	Reference	The type of occupation that customer has, that is the principal activity the customer does to earn money.
JOB ROLE	Reference	The job role employee might take. For example: Sales Representative Support Product manager Customer representative Call center agent
LANGUAGE	Lookup	Speaking or written language.
LANGUAGE DIALECT	Reference	A special type of spoken or written language dialect.
LEG	Reference	Leg is an operational term and used to define the the physical operation between a departure station and the next arrival station. CARRIERs fly aircraft on Legs. This entity represents the attributes of the leg. For example: Terminal Board point Off point city
LEG SCHEDULE	Base	The detailed schedule at LEG level.
LEG TYPE	Lookup	The different types of LEG.
LETTER TYPE	Lookup	Lookup for type of letter sent to the customer according to the content and purpose. For example: Direct Marketing Legal Letter Contract Confirmation letter (Welcome)
LOCAL AUTHORITY TYPE	Lookup	Lookup for the type of local authority. For example: City State County
LOCAL TAX AUTHORITY	Reference	Government authority that levies sales taxes or imposes rules, or statutory compliance.
LOCATION	Reference	A physical place the retailer conducts business. It may be any or all of the defined sub-types: WORK LOCATION, SELLING LOCATION, INVENTORY LOCATION.
LOG_BOOK	Base	The logbook can record flight time, flight type, departure point, destination, VFR, or IFR information and much more. It is used as a record of the flight and as a communication tool between pilots and the ground crew. Can be physical or electronic.
LOT_NUMBERS	Reference	TBS
LOYALTY ACCOUNT	Reference	Typically, airline customers enrolled in the program accumulate frequent flyer miles (kilometers, points, segments) corresponding to the distance flown on that airline or its partners. CUSTOMERs can acquire points on flights or by some other means. The acquired points can be redeemed for free air travel; for other goods or services; or for increased benefits. For example: Travel class upgrades Airport lounge access Priority bookings
LOYALTY ACCOUNT BALANCE HISTORY	Derived	The history of all the changes of one account. Including the earnings, redemption, and expiration. Specifies the current and historical balances of an account.
LOYALTY ACCOUNT BALANCE HISTORY FACT	Derived	Specifies the daily summary data about LOYALTY ACCOUNT (Frequent Flyer).
LOYALTY ACCOUNT LEVEL HISTORY	Derived	The change history of the loyalty account level.
LOYALTY ACCOUNT LEVEL HISTORY FACT	Derived	The daily summary of the LOYALTY ACCOUNT details.
LOYALTY CONVERSION	Base	When the airline wants to merge several loyalty programs together or let the customer from a partner use points in a program. This entity lets you specify the related data.
LOYALTY LEVEL	Reference	There are different levels in one loyalty program. For example: Bronze Silver Gold
LOYALTY POINTS EXPIRE	Base	Airline may have a points expiration policy. The points expire after a certain period of time the points in the account will expire.
LOYALTY PROGRAM	Reference	Structured marketing efforts that reward, and therefore encourage loyal buying behavior.
MAINTNENACE REQUIREMENT	Base	Enables maintenance organizations to record, organize, and plan maintenance requirements, such as routine inspections, replacements, MOD's SB's, CPC, and so on.
MAINTENANCE TYPE	Lookup	TBS
MAINTENANCE VISIT	Base	Maintenance grouping for work to be performed (routine and non routine) such as A, B, C, or D checks.
MAINTENANCE VISIT TASK	Base	Maintenance visit task details.
MAPLET INPUT OFFICE	Control	TBS
MARITAL STATUS	Lookup	Marital status.
MARKET AREA	Reference	Market Area denotes a geographic area for which resident demographic data is available. Market Area may not contain a store. Trade Area and Market Area have been used interchangeably in this model. The definition of a trade/market area is the geographic region from which a town draws most of its retail customers. For example: Study traffic flow Use a retail gravity model Use a zip code method Use commuting data to define the trade area boundaries
MARKET AREA LEVEL	Reference	Level of classification inside the market areas. this classification can be based on, Community: This is represented as the one set of demographic attributes as described in the demography entity Geographic User defined criteria
MARKET SEGMENT	Reference	A market segment is identified to group certain common areas where business can be conducted, for example, a group of person, a specific geographical area, and so on.
MARKET SEGMENT CHARACTERISTIC	Reference	Different characteristics of a market segment. For example, customer age, customer income, and so on.
MARKET SEGMENT CHARACTERISTIC VALUE	Reference	The different characteristic value of market segment.
MARKET STATISTIC INCLUSION	Reference	Relationship between two market statistics.
MARKET STATISTICS	Reference	The market statistical information gathered about the competitors and the market.
MASTER CONFIGURATION HEADER	Reference	Header of assembly tree structure representing the positions of tracked or required components that make up a complex assembly.
MATERIAL TRANSACTION	Base	TBS
MEDIA OBJECT	Reference	This is any object the campaign message may appear on. For example, a page in a newspaper, or a time slot in a TV broadcast.
MEL	Reference	A categorized list of on-board systems, instruments, and equipment that may be inoperative for a flight.
MEL ATTRIBUTE	Lookup	MEL Coding (in accordance with dispatch conditions in MMEL), B (3 days), C (10 Days), D (120 Days)
MEL_CDL_PROCEDURES	Base	Procedures associated with an MEL item.
MEMBERSHIP ACCOUNT	Reference	A customer account in a membership program. For example, a loyalty program.
MFG_PART_NUMBERS	Reference	MFG_PART_NUMBERS represents the cross reference between an item defined in inventory and the part number used by its manufacturer. This information can be used to perform item searches by manufacturer part number.
MINIMUM CONNECTING TIMES	Base	The minimum connecting time between different flights.
MISCELLANEOUS REMARKS	Reference	This entity is used to convey additional information which are entered by the agent and stored on the hotel booking.
MONTH TODATE TRANSFORMATION	Reference	Defines related calendar elements for performing to-date time transformations.
MONTH TRANSFORMATION	Reference	Transformations for a month. For example: This month last year This year last month
MR EFFECTIVITY	Base	MR Effectivity refers to the applicability of a maintenance requirement. An effectivity definition contains a set of effectivity details, and a set of interval thresholds. Intervals and thresholds are used to set a schedule that counts down until the maintenance requirement is due for a unit.
MR_EFFECTIVITY_DTLS	Reference	Extra details on the MR effectivity.
MR_INTERVALS	Base	Intervals and thresholds are used to set a schedule that counts down until the maintenance requirement is due for a unit.
MTL_MANUFACTURERS	Reference	Manufacturers detail.s
MRO RESOURCE	Reference	The resource required to complete the MRO work, an indication of the skills and trade required.
NATIONALITY	Lookup	The nationality information.
NON FREQUENT FLIER MINING	Derived	Represents apply results of non-frequent flier related mining models on non-frequent fliers latest data.
NON ROUTINE	Base	Non Routine requirement record.
NON ROUTINE DERIVED	Derived	Non Routine requirement record.
ODT ACCOUNT	Reference	The ODT account tracks the financial or services interactions of a customer with the airline. Once set up, the customer can use the account to do self service at airlines Website or terminal. In this case normally the ODT account is protected by a password.
OLAP ETL PARAMETER	Control	TBS
OPERATION	Base	Task details
OPERATION MATERIAL	Base	Task materials
OPERATION_RESOURCES	Base	Task resources.
OPTION	Reference	Information about the message queues sent to a different office which holds different information about the BOOKING.
ORDER TYPE	Lookup	A unique retailer assigned code denoting a type of CUSTOMER ORDER, PURCHASE ORDER, or ORDER. For example: Layaway Order for delivery Order for pickup
ORGANIZATION	Reference	A company, association, institution, or other enterprise of interest to an organization including retail enterprise, or the retail organization itself.
ORGANIZATION AREA	Reference	Areas within an organization chain.
ORGANIZATION BANNER	Reference	The name of Company, ORGANIZATION, or subsidiary that is recognizable to the consumer or the name of the store as it appears on the catalog, web channel, or brick and mortar store. Contains the information about different organization banners under which product or service are sold.
ORGANIZATION BUSINESS ENTITY	Reference	Any logical entity that is recognized as a part of the enterprise for business analysis and transactions. Classification for a business entity can include company, operation unit, store, or a warehouse.
ORGANIZATION BUSINESS UNIT	Reference	Represents the lowest level of carrier's organization hierarchy, it can be a local airline office or a call center.
ORGANIZATION BUSINESS UNIT TYPE	Lookup	Type of ORGANIZATION business unit. For example: Call center Branch Office Warehouse
ORGANIZATION CHAIN	Reference	Organization hierarchy level within an ORGANIZATION COMPANY and is the parent of one or more ORGANIZATION AREAs.
ORGANIZATION COMPANY	Reference	Organization hierarchy level within an ORGANIZATION CORPORATE and is the parent of one or more ORGANIZATION CHAINs.
ORGANIZATION CORPORATE	Reference	Highest level of ORGANIZATION HIERARCHY and is the parent of one or more ORGANIZATION COMPANYs.
ORGANIZATION DISTRICT	Reference	Organization hierarchy level within ORGANIZATION CORPORATE.
ORGANIZATION HIERARCHY	Reference	User defined. Master list of all of the hierarchies in an organization.
ORGANIZATION HIERARCHY LEVEL	Reference	The description of different levels in organization hierarchy.
ORGANIZATION HIERARCHY LEVEL ASSIGNMENT	Reference	Assignment of Hierarchy Levels to ORGANIZATION HIERARCHY.
ORGANIZATION HIERARCHY VERSION	Reference	Version of ORGANIZATION HIERARCHY.
ORGANIZATION LEVEL	Reference	List of all the business levels within an organization.
ORGANIZATION LEVEL ATTRIBUTES	Reference	Attributes applicable only to the corresponding level in the organization. Possible values that can be stored in this entity can be, regional language.
ORGANIZATION LEVEL ATTRIBUTES VALUE	Reference	The attribute value of organization hierarchy.
ORGANIZATION MARKET DATA	Reference	Publicly available and statistical information regarding the internal or external parties, such as DUNS number and number of employees. DUNS numbers are specific to ORGANIZATIONs and SIC codes are for industry sectors. So many Organizations with different DUNS numbers can have the same SIC code.
ORGANIZATION NAME	Reference	Different types of organization name represent their business legal status.
ORGANIZATION REGION	Reference	Holds region within a company, chain area. Organization hierarchy level within an ORGANIZATION AREA and is the parent of one or more ORGANIZATION DISTRICTs.
ORGANIZATION SERVICE WEBSITE	Reference	Sub-type of the ORGANIZATION BUSINESS UNIT, it collects all information on (normally public) website managed by the carrier. A website owned/commissioned by the organization from where product/services can be purchased and supported.
ORGANIZATION WAREHOUSE	Reference	Location in which goods or merchandise (routers, maintenance parts, computers, and so on) are stored but not sold, before they are sent to the shops or utilized by carriers. For example: Chairs Engine part Maintenance part A place in which goods or merchandise are stored; a storehouse. The warehouse is to store the equipment instance like maintenance parts before delivering to the customer.
ORGANIZATIONAL DEMOGRAPHY VALUE	Reference	User defined attribute definitions and corresponding values regarding demographic statistics as related to an ORGANIZATION BUSINESS UNIT. Describes the detailed information and its value collected about organizations.
OTHER INDIVIDUAL	Reference	Individual party associated with a PARTY organization other than those defined, For example: Customer Employee
OUTSIDE PROCESSING ORDER	Base	An order that is sent outside of the organization for processing (sub-contract).
PACKING SLIP	Base	A document that identifies the merchandise items a supplier claims to be shipping to the store against one or more PURCHASE ORDERs.
PART	Base	An article or component approved for use / installation onto an aircraft / Engine / Component assembly /sub-assembly.
PART CHANGE	Base	The change record for an article or component removed / installation onto an aircraft / Engine / Component assembly /sub-assembly.
PART LOCATIONS	Reference	Location of part(s) within the organization.
PART SERIAL NUMBER	Base	Unique part identification number.
PARTNER EARNING	Base	The entity is used to store all the miles earning activity from carrier's partners.
PARTNER PROMOTION PROGRAM	Reference	Assigns costs of a given promotion to a partner or a PARTY participating in the promotion.
PARTY	Reference	Any individual or an organization of interest to the enterprise. A party is a real person, organization, branch, subsidiary, legal entity, holding company, and so on. Any real thing that you would want to put a name to is a party. The attributes of a party are universal. In other words, they are independent of your selling (or ultimately buying) relationship with the party. A party is not necessarily a customer. It can represent prospects and parts of an organization hierarchy (branches, head offices, corporate conglomerates) that may not necessarily have a billing relationship with the company. Any party that has an active account can be considered a customer. Historical information concerning the party is available in the Parties History table.
PARTY ACCOUNT ASSIGNMENT	Reference	Describes the relationship between PARTY and account. For example, this assignment tracks the owning party of the account: A party is a warrantor of an account. A party is responsible for payment of the account.
PARTY ADDRESS LOCATION ASSIGNMENT	Reference	Associates one or more addresses with a PARTY. Captures history of the names and addresses associated with a party or customers.
PARTY ASSIGNMENT	Reference	Association of a PARTY with one or more other PARTY. The relationships may include those among customers or between customers and the airline.
PARTY CONTACT INFORMATION	Lookup	Contact information for a party. For example, email and cell phone number.
PARTY CONTACT INFORMATION TYPE	Lookup	Keep the type of contact information. For example: Email Home telephone Number Office telephone Number Cell phone Number Pager Number
PARTY CONTACT LIST PARTICIPATION	Reference	Relationship between PARTY and contact list. For example, a party belongs to a contact list.
PARTY COST ASSIGNMENT	Base	Assignment of cost items to a PARTY. One party may incur multiple costs. For example, for a customer acquisition, the customer might be given any of the following items that lead to costs: Maintenance Part Network Device Gifts Cost might be assigned to multiple parties. For example, for operational cost several organizations may share the same expense on a promotion or campaign
PARTY DEMOGRAPHIC	Reference	A demographic profile for a PARTY.
PARTY DEMOGRAPHY VALUE	Reference	Defines individual and organization demography value for a given party demographic profile.
PARTY GEOGRAPHY ENTITY ASSIGNMENT	Reference	Assigns a PARTY to one or more GEOGRAPHY ENTITYs. Depending on type of PARTY, the relationship might be: Some customer belongs to some country, visited (roamed or not) other countries. Organization's HQ is located at a city. External operation has business at some country.
PARTY IDENTIFICATION	Reference	Identifying information unique to a PARTY. For example: Personal identity card number Driver license number Social security number
PARTY IDENTIFICATION TYPE	Lookup	Lookup for valid Types of PARTY IDENTIFICATION. For example: Driver's License DUNS Number Social security number
PARTY INTERACTION	Base	Specifies all interactions or communications with the customer. For example: Faults Inbound and outbound telemarketing Direct mail SMS Email Service calls Debt collection Complaints
PARTY INTERACTION CALL	Base	Subtype of PARTY INTERACTION which represents all telephone call interactions from the customer with details information including: holding, queuing, and interaction time, run by the Automated Voice Response (AVR) or not.
PARTY INTERACTION EMAIL	Base	Subtype of PARTY INTERACTION, which represents email interaction from customers.
PARTY INTERACTION FAX	Base	Subtype of PARTY INTERACTION, which represents FAX interaction from customers.
PARTY INTERACTION ITEM	Base	The interaction items in each PARTY INTERACTION event. For example, in a party interaction event: when the customer calls the call center there can be several party interaction items: Change flight A to B Change flight C to D A complaint about food on flight E
PARTY INTERACTION ITEM STATUS	Lookup	Documents the various customer interaction statuses. For example: Planned In-progress Executed Closed
PARTY INTERACTION LETTER	Base	Subtype of PARTY INTERACTION, which represents the interaction with customer through letter.
PARTY INTERACTION SMS	Base	Subtype of PARTY INTERACTION, which represents the SMS interaction from customers.
PARTY INTERACTION THREAD	Base	If a customer raises multiple complaints about the same issue, those calls are grouped into single thread.
PARTY INTERACTION VISIT	Base	Subtype of PARTY INTERACTION, which represents the visit interaction from customers.
PARTY LANGUAGE CAPABILITY	Reference	Store the language capability as the reference to the related party attribute.
PARTY NAME	Reference	Lists any other names along the life history used by a given PARTY.
PARTY ORDER ASSIGNMENT	Base	Assignment of a party to a given order. For example: The Sales Agent gets a sales commission because of the customer order.
PARTY PROMOTION RESPONSE	Base	Response of a PARTY to a PROMOTION. For example, positive responses: The customer accepted the offer The customer increased or modified their usage The customer changed a specified behavior (for example moved from payment by check to an electronic payment option)
PARTY ROLE	Reference	Lookup for Roles a PARTY may be assigned for an event. For example: Customer Reseller Manager Dealer Employee
PARTY ROLE ASSIGNMENT	Reference	Assigns party roles that the party acted as to the PARTY. PARTY ROLEs are X-X relationships and it may change due to contract change and so on.
PARTY SKILL	Reference	The list of skills which a party may have.
PARTY STATUS	Reference	The status of a party.
PARTY STATUS CHANGE REASON	Lookup	Lookup for valid reasons that may be assigned for a PARTY STATUS change. For example: Hire Transfer New customer
PARTY STATUS HISTORY	Reference	Describes the current party status history, regarding for topics of carrier interest. Historical information captured for the complete lifetime of the customer or dealer. The information may be calculated from internal data. For example: Payment Obtained from an external source, such as a credit rating agent
PARTY STATUS TYPE	Reference	Status type of the party. For example: In the category of customer status, Values may include: Active Inactive Defaulted New Customer VIP customer Black Listed In the category Prospect Status, values may include New Prospect Contacted No interest Interested Purchased Rejected
PARTY TYPE	Lookup	Lookup for party type that classifies involved parties according to their inherent characteristics and structure. For example: Person Organization Organization Business Unit (Internal)
PASSENGER CONTACT	Reference	This is an operational layer entity stores the contact information of the passenger in the BOOKING.
PASSENGER COUNTRY ADDRESS INFORMATION	Reference	Essential documents about the passenger. For example: Country State Zip
PASSENGER VISA INFORMATION	Reference	Visa details of the passenger.
PASSPORT	Reference	The passport as a type of PARTY IDENTIFICATION.
PAX COUPON DATA	Reference	The passenger ticket coupon data.
PAX INVOICE HEADER	Reference	The passenger invoice header data.
PAX TRANSFER	Base	TBS
PDI CHANNEL	Reference	Check-in channel origins. Acceptance channel types can be Front-End, KSK for Kiosk, MBL for Mobile check-in channel origin. For example: A for airline (check-in agent) S for Self-Service
PDI CHARACTERISTIC	Reference	Characteristics of the PDI.
PDI H	Base	The history of passenger checking details at the transaction level.
PHASE	Reference	Period within a SEASON.
PHYSICAL COUNT DOCUMENT	Base	The document on which the actual SKU ITEM counts are recorded on the day of the physical inventory. This is raw and unedited data that is captured during the inventory.
PHYSICAL COUNT DOCUMENT LINE ITEM	Base	The line detail which records the number of units counted during the Physical Inventory. This is raw and unedited data captured and will compared to the book stock to determine the actual unit and financial discrepancy for that ITEM.
PLANNING QUARTER	Reference	Quarter level in the planning calendar.
PLANNING SEASON	Reference	Season level in the planning calendar.
PLANNING WEEK	Reference	Week level in the planning calendar.
PLANNING YEAR	Reference	Year level in the planning calendar.
PNR	Reference	The complete details of a passenger's BOOKING, including itinerary, contact details, and special requests. A PNR is uniquely identified by a record locator.
PNR GDS INFO	Base	The Global Distribute System (GDS) information of each PNR.
PNR PARENT CHILD RELATIONSHIP	Reference	Parent child relationship of the PNR and gives details about the split PNRs.
PNR RELATIONSHIP	Base	Specifies the different relationships between two PNR, like split PNR.
PNR TYPE	Reference	This is an operational layer entity which stores the information of the PNR type. It contains the type of PNR. IND= “Individual", GRP= “Group", COR= “Corporate" or NCO= “Non Commercial" Lookup for the type of PNR.
POS DEPARTMENT	Reference	Point of Sale (POS) grouping of items with similar point of sale control and processing attributes. The entity type may also be used to control sales that are not properly identified at the item level.
POS GOODS OFFICE	Reference	This is a entity in the operational layer to cater to a particular condition used to interpret the office. Apart for the five offices mentioned below all the other offices follow a standard logic: OSAAY0100 TYOAY0100 NGOAY0101 NYCAY0111 TAYAY0550
POS IDENTITY	Reference	A simple cross-reference between the barcode, point of sale scan code or other keyed identifying number used at POS and the internal stock keeping Item ID for the item. The POS Item ID will generally be filled with the GTIN (UPC, EAN, and so on) for an item -- but it is not mandatory.
POSTCODE	Reference	Postal codes and associative demographic information of interest to the carrier.
PREFERENCE TYPE	Reference	Specifies the different PNR preference types.
PRICE DERIVATION RULE	Reference	The specification of a method to be used to transform the current sell unit retail amount to the price charged to account based on a discount group.
PRICE LIST	Lookup	Lookup for the basic published or advertised price, often subject to discount. For example: Standard Discounted Negotiated
PRICE MODIFICATION LINE ITEM	Reference	A line item component of a RETAIL TRANSACTION that records the granting of a reduction or increase of price on all ITEMs in the transaction.
PRODUCT ENTITY	Reference	Any logical entity that is recognized as a product or item for Business Analysis and transactions.
PRODUCT OFFERING	Reference	Defines how a product is brought to market, including: positioning, pricing, and bundling details. For example: Flight and Hotel and Car rental packaged with a total discount as a product offering Weekend flight ticket between two cities, packaged as season or half year or year package
PROFILE SOURCE	Reference	The source from which a GEOGRAPHY DEMOGRAPHY VALUE is acquired or populated. For example, a mailing list provider.
PROJECT	Base	TBS
PROJECTS_ALL	Base	TBS
PROMOTION	Reference	The promotion reflects the tactics a carrier undertakes to generate increased incremental PAX volume for specific segment combinations within a promotional event. Promotions are frequently communicated as part of a marketing campaign to ensure that awareness is generated with the target audience. A collection of eligibility and price derivation rules, during a specific time.
PROMOTION CLUSTER USAGE	Base	Assigns a particular customer segment (cluster) to a given promotion or list of promotions. The customer segments are generated by certain analytical application (including Oracle Mining) and this assignment tracks the usage of customer segment in the promotion.
PROMOTION ITEM	Reference	Associative entity connecting any level of the item hierarchy and organization hierarchy, and optionally a VENDOR, with the promotion.
PROMOTION MANAGEMENT HISTORY	Base	A history of campaign party role about management of a campaign episode.
PROMOTION MESSAGE RENDERING	Reference	Details regarding each CAMPAIGN MESSAGE broadcast through a MEDIA OBJECT. For example: If the channel is a newspaper, then the media object is the page and the picture. For a TV advertisement, how frequently the message is broadcast, and the time for each broadcast.
PROMOTION PRODUCT OFFERING ASSIGNMENT	Reference	Associates product market plans to a promotion.
PROMOTION SELLING ITEM	Reference	Associative entity linking promotion item and campaign media selling item, and the prices which may be used for the item during the promotional period.
PROMOTION TYPE	Lookup	Lookup for the type of PROMOTION (normally for a limited time). For example: An upsell promotion in a special segment, such as a free extra checked bag. A special discount for retention programs: additional mileage with each flight. A Survey.
PROSPECT	Reference	An individual, collection of individuals, a company, or a public institution that has not purchased merchandise or services, but may in the future. A prospect may also be a CUSTOMER of one PRODUCT (already purchased) that does not currently purchase another PRODUCT (may purchase).
PROSPECT INDIVIDUAL	Reference	Specifies attributes of an individual prospect, one who is not an organization.
PROSPECT ORGANIZATION	Reference	Specifies attributes of an organization prospect.
PURCHASE ORDER	Base	TBS
PURCHASE ORDER LINE ITEM	Base	Items, quantities and amounts included in a PURCHASE ORDER.
QUALITY PLANS	Reference	TBS
QUALITY RESULTS	Base	TBS
QUARTER HOUR	Reference	Quarter Hour level in Time of Day.
QUARTER TO DATE TRANSFORMATION	Reference	Cumulative time transformations at the quarter level.
QUARTER TRANSFORMATION	Reference	Transformation for a quarter. For example: This quarter last year This year last quarter

Table 2-3 R to Z Entity Descriptions

Entity Name	Type	Description
REASON	Lookup	Lookup for reason codes. Reason codes are grouped into REASON CATEGORYs based on where they are referenced.
RECEIVING DOCUMENT	Base	Subtype of INVENTORY CONTROL DOCUMENT that is used by a store to record its acceptance of items shipped to it by a VENDOR against a PURCHASE ORDER and the VENDOR packing slip.
RECTAFICATION INTERVAL	Lookup	Time in which an item must be rectified.
RECTIFICATION INTERVAL EXTENSION	TBS	Rectification extension indicator.
RELIGION	Reference	This lookup keeps information on religions. Examples are Christianity, Islamic, and Hinduism.
REPAIR_CATEGORIES	Reference	Repair category.
REQUISITION DOCUMENT	Base	A type of INVENTORY CONTROL DOCUMENT recording a request for SKU ITEMs to be sent from a ORGANIZATION DISTRIBUTION CENTER to a ORGANIZATION STORE.
RETAIL SALE RETURN LINE ITEM	Base	A line item component of a RETAIL TRANSACTION that records the exchange in ownership of a merchandise item (for example, a sale or return) or the sale or a refund related to a service.
RETAIL SEASON	Reference	Allows the user to categorize each item according to different seasons and phases within a season. That is, a user may assign a season of “Spring" to a group of items, according to the supplier's deliveries of fashion items. Those relationships can be further broken down into the phases, such as “Spring I and Spring II.".
RETAIL STORE	Reference	Subtype of internal organization. Note: a retail store may contain several SELLING LOCATIONs.
RETAIL TRANSACTION	Base	A type of transaction that records the business conducted between the carrier and another party involving the exchange in ownership or accountability, or both, for merchandise or tender, or both, or involving the exchange of tender for services.
RETAIL TRANSACTION LINE ITEM	Base	A detail line item of a RETAIL TRANSACTION that records the business conducted between the ORGANIZATION STORE and another party involving the exchange in ownership or accountability, or both, for merchandise or tender, or both, or involving the exchange of tender for services.
RETURN AUTHORIZATION REQUEST	Base	A type of INVENTORY CONTROL DOCUMENT that makes a request to a VENDOR to grant permission to return merchandise that is received and found to be unsuitable for sale or other use at the store.
RETURN DOCUMENT	Base	A type of INVENTORY CONTROL DOCUMENT that lists the merchandise items to be returned by the store to the VENDOR as a result of: the following: Errors in delivery Substitutions in shipment Late delivery Defective materials, workmanship, or fit Other breaches of contract
REVENUE COST DERIVED	Derived	Summary level entity which represents the cost related summary calculation.
REVENUE COST ELEMENT	Lookup	This is a lookup entity for the different types of revenue cost items. The data is the lowest level of the revenue cost group hierarchy. For example: Fuel Surcharge Mail Revenue Fuel Tax
REVENUE COST ELEMENT CATEGORY	Lookup	Lookup entity to roll up different cost elements into different categories. For example: Passenger Revenue Fuel Landing and Parking
REVENUE COST ELEMENT GROUP	Lookup	This is a lookup entity to roll up different revenue cost element categories into different groups. For example: Revenue, Variable DOCS, Fixed Expenses
REVENUE COST TRANSACTION	Base	This is the base transaction entity to store each and every single revenue or cost transaction record.
ROLES HIERARCHY	Reference	Hierarchy among the job roles within an organization.
ROUTEPAIRS	Reference	Route Pair means a grouping of Routes. It is a synonym for Route Hierarchy Level 5. Usually a Route Pair is the combination of two Route Numbers in both directions, but sometimes not. For example: Route Pair 0152/0157/0158 MOW contains Routes 0152, 0157 and 0158. For multi-leg out-and-return flights the Route Pair is named after the end stop of the flight (0097/0098 SIN for 0097 HEL-BKK-SIN) For triangular flights the Route Pair can either be named after the whole journey (0439/0440 OUL/RVN for 0439 HEL-OUL-RVN), or only the first stop (0911/0912 BER for 0911 HEL-TXL-HAM-HEL)
ROUTES	Reference	Route means a number of flights that carry the same flight number. For example: 831 HEL-LHR. Only one flight operates on a route on any given day. For direct flights each route covers only one LEG (outbound or inbound). For multi-leg out-and-return flights each route covers all legs of each direction. For example: HEL-BKK-SIN). For triangular flights each route can either cover the whole triangle (For example: HEL-TXL-HAM-HEL), or part of it. For example: HEL-OUL-RVN part of HEL-OUL-RVN-HEL).
ROUTINE	Base	Routine / Planned work
SALE OR RETURN ACTION	Reference	A code denoting how the item is being treated in the line item. For example: Layaway Order For Delivery Previous Layaway Return Item Sale Item Return
SALES CHANNEL	Reference	Sales channel or alternatively called booking channel is derived from the BOOKING OFFICE which gives us the channel from which the BOOKING is performed.
SALES CHANNEL REPRESENTATIVE	Reference	The sales representatives who sell the product to the customer. For example: Sales Representative in the operator owned shops, Direct sales representatives in the call center, and dealers in case of partner. For sales channel, The current analytical path is: Internal org type => internal org => Sales representative
SALES FORECAST ITEM ORG HIERARCHY WEEK	Reference	Weekly sales forecast information at given levels of ITEM, and organization hierarchies.
SALES PLAN ITEM ORG HIERARCHY WEEK	Reference	Weekly sales plan including Returns, Cost of Sales, PROMOTIONs, Clearance, at given levels of ITEM and ORGANIZATION HIERARCHY.
SALES RESTRICTION	Reference	A type of limitation that restricts the sale of a particular class of item.
SCRAP_VALUES	Base	TBS
SEASON	Lookup	This is the description of the different seasons defined by the airline.
SECOND	Reference	Second hierarchy level as defined in Time Hierarchy.
SEGMENT CRITERIA	Reference	Minimum and Maximum scores for each segment associated with an ACCOUNT SEGMENT or CUSTOMER SEGMENT.
SEGMENT SCHEDULE	Base	Describes the details of the date and time that a CARRIER has scheduled to the market. Segment is a commercial term and means a portion of a Journey between boarding and disembarkation points. A Segment may cover one or more LEGs CARRIERs publish schedules of Segments and publish Availability for them. Passengers reserve Segments on a BOOKING. This is an operational layer entity which stores segment details such as the board point airports and offpoint airports.
SELLING LOCATION	Reference	An area of floor space or shelf space within the ORGANIZATION STORE to which sales can be assigned. The selling location may be assigned to or rented by a VENDOR.
SELLING LOCATION TYPE	Lookup	Lookup for type code and description used to define a SELLING LOCATION: For example: Store Floor Aisle Shelf
SERVICE	Reference	The type of the postal service. For example: Ordinary mail Express
SERVICE CONTRACT	TBS	TBS
SERVICE COVERAGE AREA	Reference	Specifies the coverage area of a given Service Spec. The geographic area covered by service provider with certain product combination. Service areas are defined so that service providers can determine the demographic / psychographic / population data the geography served by the carrier.
SERVICE COVERAGE GEO DETAIL	Reference	Specifies the detailed geographical data about each service coverage area.
SHIPMENT METHOD	Lookup	Lookup for different types of shipment methods. For example: Shipment by air Shipment by sea Shipment by rail
SHIPMENT PRIORITY	Lookup	Lookup for different types of shipment priority. For example: Primary Secondary Tertiary
SKILL TYPE	Lookup	Lookup of SKILL TYPE for a individual party
SKU ITEM	Reference	Stock Keeping Unit or unit identification, typically the UPC, used to track store inventory and sales. Each SKU is associated with an item, variant, product line, bundle, service, fee, or attachment. Aggregate SKU: Subtype of SKU that is an aggregation of one or more constituent SKU. The constituent items may be sold individually. Group Select: An item, which is a group of items, only one of which is sold. The choice of which item is made by the customer at the POS. Prepared: A sub-type of SKU ITEM that is manufactured (or prepared) for sale from a set of BULK ITEM with a RECIPE. A PREPARED SKU ITEM is different from an SKU ITEM because a PREPARED Item is not booked into inventory when the item is manufactured; nor is it removed from inventory when it is sold; rather the inventory for the BULK ITEM constituent parts as defined by the recipe is reduced when the prepared item is sold. Service SKU: A type of SKU that provides a detailed identifier and description for a service offered for a sale to customer in the retail store. Service SKU also identifies and describes rental items and other tangible items that are used by the customer for a contracted period, but not purchased. Stock: A unit of merchandise that may be sold to a customer or used by the ORGANIZATION STORE.
SOC JOB	Reference	The most detailed level of job code from Standard Occupational Classification (SOC) System. For example: 15-1041 Computer Support Specialists 15-1011 Computer and Information Scientists Research 15-1021 Computer Programmer
SOURCE SYSTEM	Reference	System of record from which Oracle Airlines Data Model data was loaded. For example, GDS system, CRM system.
SOURCE SYSTEM KEY MAPPING	Reference	Track Key of the PARTY (customer or employee) in the originating source system. This key can be used back to track information back to source management system. The party can consolidate different people from different source systems, such as CRM, Billing, into a unique one. Therefore, the multiple keys for the same unique party is saved here.
SSR	Reference	The Special Service Request (SSR) is a request to an airline for services or amenities other than the standard requests. For example: Wheelchair usage Meals for special diets The Special Service Request captures the information of the history and current service request information added, deleted from the source system.
SUBSCRIPTION	Reference	The record of CUSTOMER using a product or service which may be based on a contract. CUSTOMER’s subscription to services is the basis of billing and network usage authorization.
SUPPLIER	Reference	Vendor of any service or product to support the operation of carrier.
SWOT TYPE	Lookup	Type of SWOT analysis. A Strength, Weakness, Opportunity, Threat (SWOT) that an enterprise has when compared to a Competitor. SWOT analysis is a formal framework of identifying and framing organizational growth opportunities.
SYSTEM PARAMETER TABLE	Control	This is a system management table used by ETL to populate the audit columns and generated ids for the audit columns and stores the details of the ETL data load.
TARGET ACCESS METHOD	Reference	The Access Methods included in a specific CAMPAIGN.
TARGET ACCOUNT	Reference	The Customer Accounts included in a specific CAMPAIGN.
TARGET GEOGRAPHY AREA	Reference	The Geography information included in a specific CAMPAIGN.
TARGET TYPE	Lookup	Indicates the type of targets in a specific Promotion: Examples: Customer ACCOUNTs, Access Method, geography area, and so on.
TASK ASSIGNMENT	Reference	TBS
TASK EFFECTIVITIES	Base	Effectivity of a particular task, allows a single task application to be controlled based upon a defined criteria.
TASK LIST	Base	List of tasks.
TAX LINE ITEM	Reference	A line item component of a RETAIL TRANSACTION that records the charging and offsetting liability credit for sales tax on merchandise items and services sold by the store or debit for merchandise returned to the store.
TAXABLE GROUP	Reference	A group of ITEMs for which a TAX AUTHORITY defines TAX GROUP RULEs. For example: Food items Hard goods
TENDER	Reference	Tender includes all the forms of payment that are accepted by the ORGANIZATION STORE in settling sales and other transactions.
TERMINAL	Reference	Specifies the airport terminal related information.
TICKET	Base	Ticket means a document entitled "Passenger Ticket and Baggage Check" is issued by or on behalf of a CARRIER and includes the Conditions of Contract and notices and the Flight Coupons and Passenger Coupons contained therein. The ticket stores the ticket number and the issuing office for the ticket. Ticket means a document entitled “Passenger Ticket and Baggage Check" issued by or on behalf of a CARRIER and includes the Conditions of Contract and notices and the Flight Coupons and Passenger Coupons contained therein (IATA PAT-GR-1). This is a operational layer entity which stores the ticket number and the issuing office of the ticket.
TICKET COUPON	Reference	Coupon means either a Flight Coupon or a Passenger Coupon. When used alone, it usually refers to a Flight Coupon. Stores details about the coupons. This is an operational layer entity which stores details about the coupons.
TICKET DELIVERY ARRANGEMENT	Base	The ticket delivery arrangement for the TICKET. For example: Queue number Delivery system
TICKET FACT	Derived	This is a summary for the information related to ticket.
TICKET PRICE	Base	This is the base level information for the details of ticket pricing.
TICKET PRICING DISCOUNT	Base	This is the base level information for the details of ticket price discounts.
TICKET PRICING DOCUMENT DETAILS	Base	This is the base level entity with information on the details of ticket price document.
TICKETING FORM OF PAYMENT	Reference	This is a reference entity for information about the form of a payment for ticketing.
TIME DIM	Reference	This is a global dimension which stores the details in the granularity of minutes which rolls up to hour.
TIME PERIOD	Lookup	TBS
TIME STANDARD BY DAY	Reference	Relates the calendar day to a season and to a standard day. Specifies the relationship between a given day and all days of a given season up to that day.
TIME STANDARD BY WEEK	Reference	Relates the calendar week to a season and to a standard week. Specifies the relationship between a given week and all days of a given season up to that week.
TIME TOTAL	Reference	Represents the top most level of time. This is needed to enable Ad-Hoc reporting involving the Time Dimension.
TIME ZONE	Base	Time zone relative to Greenwich Mean Time (GMT).
TOUCHPOINT	Reference	Place where the transactions take place. The meeting point for customer and retail organization. The touchpoint can be both logical and physical. Call Center: A department within a retail organization or a third-party organization that handles telephone sales service. Store Workstation: A device used as an as interface to any retail business function. For example, the capture and storage of TRANSACTIONS and operational performance reporting.
TOUR	Base	Represents tour and tour related information.
TRACKED ITEM	Base	Item that can be uniquely identified and tracked
TRAFFIC CATEGORY	Reference	Traffic Category is a term used for the purposes of categorization and reporting on Route Profitability to categorize the flights into: Atlantic Scheduled Flights Atlantic Ad-hoc Flights European Scheduled Flights European Ad-hoc Flights Near-East Scheduled Flights Near-East Ad-hoc Flights Domestic Flights Far East Flights Traffic category is used in combination with Traffic Area/Traffic Type for this purpose. In CADS, this categorization is split into two categorizations: Traffic Flight Type and Route Hierarchy Level 1. It stores the detailed information about the traffic category.
TRANSACTION TYPE	Lookup	Further classifications of TRANSACTION CATEGORY.
TRANSFER EARNING	Base	Points are transferred from one account to another.
TRANSFER IN OUT DOCUMENT	Base	A type of INVENTORY CONTROL DOCUMENT that is completed during return of the item to the supplier or a transfer of the item without any purchase order.
TRAVEL CLASS	Lookup	TBS
TSM	Reference	The TSM is a pricing record associated to one passenger only, the one the MD PNR element is associated to. There is a TSM for each type of MD PNR element, composed of common TSM attributes, presented in this class, and specific ones (presented in class TSMMCO, TSMSVC, and TSMXSB). Stores details of the TSM.
TSM DOC	Base	This is the base level entity for information on the details of TSM document data.
TSM EXCESS BAGGAGE	Reference	This is a subset of TSM which stores the excess baggage charge details of the passenger of the TSM. This corresponds to the description of the charge for excess baggage. Stores information about the pricing carrier, price routing department, weight value, weight piece currency of the excess baggage. This is an operational layer entity which stores information about the pricing carrier, price routing department, weight value, weight piece currency of the excess baggage.
TSM MCO	Reference	This is subset of TSM which stores the miscellaneous charge order of the TSM. Stores the details of the MCO. For example: Endorsement restrictions Tour code
TSM MCO FARES	Reference	This is a reference level entity for information on the TSM MCO fare information.
TSM MCO TAX	Base	This is the base level entity with information on the details of TSM MCO tax.
TSM PASSENGER	Reference	Specifies passenger personal information associated with a TSM.
TSM PAYMENT	Base	This is the base level entity with information on the details of TSM payment data.
TSM PRICE	Reference	Information about the fares and taxes, depending on the TSM type.
TSM RFI	Base	This is the base level entity with information on the details of TSM RFI.
TSM ROUTE	Reference	The routes of TSM mainly the CARRIER from city to city and stop over indicator.
TSM SERVICE	Reference	This is a subset of TSM which stores the service fee for the TSM. Stores the details of Service Fee (SVC). For example: Remarks Present to
TSM XSB RATE	Base	This is the base level entity with information on the details of TSM XSB rate data.
UNIT CONFIGURATION HEADER	Reference	Individual items configuration header.
UNIT CONFIGURATION HISTORY	Reference	TBS
UNIT MAINTENANCE PLAN	Reference	Specifies unit specific maintenance needs projected out into the future.
UNIT MAINTENANCE PLAN COUNTER HISTORY	Refence	TBS
UNIT MAINTENANCE PLAN THRESHOLD RULE	Reference	Threshold specific rule - Start/Stop value, tolerances, and so on.
UNIT SCHEDULES	Base	TBS
UNIT_ACCOMPLISHMNTS	Reference	Unit accomplishment of requirements
UNIT_DEFERRALS	Reference	TBS
UNIT_EFFECTIVITIES	Base	TBS
USER	Reference	Associative entity for EMPLOYEE and JOB ROLES. Assigns a unique ID for each job role that an employee performs at a particular department.
VALUE TYPE	Lookup	Value type describes the type of value. Value type can be time or money.
VEHICLE	Reference	Details of the Vehicle which can be an aircraft, bus, ship, rail, and so on.
VENDOR	Reference	External source for merchandise and goods that the ORGANIZATION STORE offers or for supplies and goods.
VENDOR CONTRACT	Reference	Details of contract with VENDOR.
VENDOR ITEM	Reference	Items supplied by the VENDOR with vendor-specific item and provides the vendor-specific attributes of the item. Provides the vendor's view of the item and uses the vendor's descriptions of item attributes.
VENDOR SITE	Reference	Subentity of VENDOR indicating the vendor location which supplies the item.
VIRTUAL TEAM	Reference	The virtual team beside department hierarchy formed for a specific purpose. For example: Sales Team A,B,C Customer Support Team A,B,C Project team Strategic Account management team including sales and support
WARRANTY_ENTITLEMENTS	Reference	Warranty details
WEEK TODATE TRANSFORMATION	Reference	Cumulative time transformations at the week level.
WEATHER	Base	Weather details at a specific date, time, and location
WEEK TRANSFORMATION	Reference	Time transformations at the week level.
WEEKDAY	Reference	Calendar weekdays.
WORK ORDER	Base	Work Order details, including actual start and finish.
WORK ORDER OPERATION	Reference	Work Order operation details including actual start and finish.
YEAR TRANSFORMATION	Reference	Transformations at the year level.