Describes the daily summary data about customer survey result. 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. The different operation type of flight inventory. CHECKIN DAILY FACT A summarized list of charges, including payment terms, invoice item information, and other information that is sent to a CUSTOMER for payment. EMPLOYEE RESTRICTED INFO CALL CENTER AGENT Stores the details of Service Fee (SVC). PARTY INTERACTION THREAD Market Area denotes a geographic area for which resident demographic data is available. For example: Lookup for all possible terms which may be attached to a CONTRACT. HOTEL ROOM BILLING TRANSACTION COUPON ADDITIONAL PRINT LINES. The billing information about each booking. PARTY COST ASSIGNMENT The relational tables, foreign and primary keys are all defined by the data models. COMPETITOR SWOT Physical data flow diagrams illustrate how a system will be implemented. Specifies the gender. For example, male or female. Catalan / Català FISCAL HALF MONTH DEMOGRAPHY ATTRIBUTE Grouping information required to determine the connecting flight. This is the base level entity with information on the details of TSM payment data. Intelligence gathered about each competitor. SVM factor is a numeric value, which quantifies the importance of attribute in predicting the target. The line detail which records the number of units counted during the Physical Inventory. Represents non-frequent flier passengers demographic and BOOKING details for a period months. 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. Information about the message queues sent to a different office which holds different information about the BOOKING. The entity is used to store all the miles earning activity from carrier's partners. One party may incur multiple costs. BLACK LIST HISTORY The segment level cabin blockspace data for code share flight. Japanese / 日本語 The attribute value of organization hierarchy. FLIGHT SEGMENT INVENTORY CABIN BOOKING CLASS CODESHARE DCS For example: Provider originated: Bad payment (leading to suspension), Customer originated: Debt paid (leading to reactivation). For example: A place in which goods or merchandise are stored; a storehouse. Common characteristics of a logical data model: 1. Defines individual and organization demography value for a given party demographic profile. ORGANIZATION HIERARCHY VERSION The main entity to store the car rental transaction information. PARTY DEMOGRAPHY VALUE CERTIFICATE Car rental additional rate related information. Passengers reserve Segments on a BOOKING. FARE TYPE TSM MCO TAX LEG TYPE PARTY ACCOUNT ASSIGNMENT Lookup for type of revenue a customer may bring to the CARRIER. Aggregate entities hold data rolled up from the Base or Derived entities at different levels across different dimensional hierarchies. For example: An electronic document sent to a store by a vendor that defines the shipment date, expected delivery date, carrier, shipped items, and OrderDocument reference. LOYALTY ACCOUNT A Segment may cover one or more LEGs CARRIERs publish schedules of Segments and publish Availability for them. Information about schedule of the flight from the FLD system. This is a operational layer entity which stores the ticket number and the issuing office of the ticket. Any party that has an active account can be considered a customer. The market statistical information gathered about the competitors and the market. CUSTOMER SEGMENT The Segments table contains details of customer segments identified by business analysis activities, for example, data mining. Provides information about LEG and segment of a particular flight. Serbian / srpski The LEG level cabin configuration for each aircraft. BUSINESS HALF YEAR BOOKING TST PRICE Represents the earnings transferred to or from an ACCOUNT. Dutch / Nederlands Specifies reference financial rating scores for each customer to the service provider. All attributes for each entity are specified. describes the data and the relationships in detail at a very high level HALF MONTH TODATE TRANSFORMATION Apart for the five offices mentioned below all the other offices follow a standard logic: 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. MONTH TRANSFORMATION ORGANIZATION LEVEL GEOGRAPHY HIERARCHY VERSION Pricing information details for Transitional Store Ticket (TST). RETAIL STORE TERMINAL FORM OF PAYMENT ORGANIZATION WAREHOUSE A PARTY that offers Product similar to the enterprise's PRODUCT ENTITY in a MARKET SEGMENT. 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). Defines a complaint or advice from customer, it is a subtype of PARTY INTERACTION THREAD. The information may be calculated from internal data. ADDRESS TYPE Subtype of PARTY INTERACTION, which represents the visit interaction from customers. A type of INVENTORY CONTROL DOCUMENT LINE ITEM that records sales, use, and value added taxes applicable to the whole INVENTORY CONTROL DOCUMENT. The record of CUSTOMER using a product or service which may be based on a contract. Specifies the fare element details of the BOOKING and the TSM. CAR RENTAL PREFERENCE TYPE CAR RENTAL OTHER RATE RULE BILLING TRANSACTION TICKET PASSENGER User defined attributes associated with a specific GEOGRAPHY LEVEL. This is a lookup entity for the different types of revenue cost items. FLEET_UNIT_ASSOCS E-mail address associated with a location. 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. For triangular flights each route can either cover the whole triangle (For example: HEL-TXL-HAM-HEL), or part of it. Item is sometimes referred to as an article, product, or bundle of SKUs. LETTER TYPE Definition documents can import other definition documents upon which they Billing Office Subtotals per Transaction Code and Currency Type. FLIGHT INVENTORY STATUS FLIGHT SEGMENT INVENTORY CABIN PLANNING YEAR Keep the type of contact information. 15-1011 Computer and Information Scientists Research. REVENUE COST ELEMENT SOURCE SYSTEM This is subset of TSM which stores the miscellaneous charge order of the TSM. The meeting point for customer and retail organization. UNIT MAINTENANCE PLAN Specifies the relationship between a given week and all days of a given season up to that week. The job role employee might take. For example: Lookup of SKILL TYPE for a individual party. FLIGHT SEGMENT INVENTORY CABIN BOOKING CLASS CODESHARE DCS The granularity of the fact is at a current date. BOOKING PASSENGER One seat can have multiple preferences. ADDRESS LOCATION STATUS HISTORY The header of a billing office transaction document. BOOKING CAMPAIGN ASSIGNMENT A type of INVENTORY CONTROL DOCUMENT LINE ITEM that records the type and amount of freight cost incurred on an INVENTORY CONTROL DOCUMENT. Individual party associated with a PARTY organization other than those defined, For example: An order that is sent outside of the organization for processing (sub-contract). This event records all the point earnings of LOYALTY ACCOUNT. Turkish / Türkçe Specifies customer loyalty prediction mining model that can be applied to predict the loyalty of customers. This table records the actual shifts worked in for the salaried employees. These attributes denote the ). PREFERENCE TYPE The payment data of each billing transaction. HOTEL BOOKING FORM OF PAYMENT Represents customer segmentation mining model that can be applied. The history of the campaign party role about the management of a campaign. REVENUE COST DERIVED BOOKING STATUS CHANGE REASON MARITAL STATUS The passenger information of billing transaction ticket. ADDRESS RELATED CAR RENTAL OTHER RATE RULE DATE External operation has business at some country. For example: Lookup for result of response received from customer interaction. 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. Different types of organization name represent their business legal status. PROMOTION CLUSTER USAGE CURRENCY Contact information for a party. AIRCRAFT DISPATCH Billing transaction ticket qualifying issue information. RETAIL SALE RETURN LINE ITEM For direct flights each route covers only one LEG (outbound or inbound). A PARTY can have many events; and an event can involve many parties. Associative entity linking promotion item and campaign media selling item, and the prices which may be used for the item during the promotional period. INDIVIDUAL NAME ER modeling helps you to assess info specifications systematically to make a … FLIGHT SEGMENT INVENTORY CABIN CODESHARE CUSTOMER SEGMENTATION MODEL BOOKING OTHER SERVICE The data is the lowest level of the revenue cost group hierarchy. BOOKING OFFICE The PARTY that resells products or services from the CARRIER. IND= “Individual", GRP= “Group", COR= “Corporate" or NCO= “Non Commercial". ORGANIZATION HIERARCHY Specifies the airport terminal related information. For example, flight booking or any customer interaction. It is important for campaign planning and management. 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. LEG SCHEDULE LOYALTY ACCOUNT LEVEL HISTORY For example: Boeing 737. The tax on commission data for billing transaction ticket. MASTER CONFIGURATION HEADER An effectivity definition contains a set of effectivity details, and a set of interval thresholds. Store the language capability as the reference to the related party attribute. It provides a conceptual abstract overview of the structure of the data. CUSTOMER SURVEY DERIVED Value type can be time or money. Assigns the languages, products, or geographical areas which the call center can serve to the call center. Captures history of the names and addresses associated with a party or customers. There are different levels in one loyalty program. For example: Lookup for valid Types of PARTY IDENTIFICATION. FLIGHT SEGMENT INVENTORY STATUS For example: A company, association, institution, or other enterprise of interest to an organization including retail enterprise, or the retail organization itself. 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. JOB Further classifications of TRANSACTION CATEGORY. Items, quantities and amounts included in a PURCHASE ORDER. COMPETITOR MARKET SEGMENT ASSIGNMENT Form of payment information of billing transaction ticket. 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: Summary level entity which represents the cost related summary calculation.