The logical data model of the Oracle Communications Data Model defines the business entities and their relationships and provides an understanding of the business and data requirements for the Oracle Communications Data Model data warehouse. Frequent Flyer is an individual, whose frequency of usage of the airline is higher than normal passengers. All attributes for each entity are specified. LANGUAGE CHECKIN BAGGAGE GROUP UNIT MAINTENANCE PLAN THRESHOLD RULE Introduction of ER Model Difference between Physical and Logical Data Independence Last Updated: 31-08-2020 Prerequisite : Physical and Logical Data Independence 1. For example, if AIRCRAFT TYPE is Boeing 737 then aircraft version could be 800. EXTERNAL ORGANIZATION TYPE Aggregate entities hold data rolled up from the Base or Derived entities at different levels across different dimensional hierarchies. SERVICE MEL_CDL_PROCEDURES Logical Data Model - UML Notation Logical data models help to define the detailed structure of the data elements in a system and the relationships between data elements. Japanese / 日本語 The resource required to complete the MRO work, an indication of the skills and trade required. CUSTOMER REVENUE BAND ASSIGNMENT CUSTOMER’s subscription to services is the basis of billing and network usage authorization. This is a subset of TSM which stores the service fee for the TSM. CUSTOMER SOURCE BILLING TRANSACTION RELATED TICKET MATERIAL TRASACTION The miscellaneous remarks of hotel booking. When the airline wants to merge several loyalty programs together or let the customer from a partner use points in a program. 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. ACCOUNT PAYMENT For example: 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. The entity type may also be used to control sales that are not properly identified at the item level. PROSPECT ORGANIZATION A classification of a Competitor, such as by size, product lines offered, and so forth. FLIGHT INVENTORY STATUS BILLING TRANSACTION ELECTRONIC TRANSACTION. Stores the details of the code share. The data is the lowest level of the revenue cost group hierarchy. FREQUENT FLYER PREFERENCE FLIGHT SEGMENT INVENTORY STATUS The job role employee might take. COMP INTEL CHARACTERISTIC VALUE GEOGRAPHY DEMOGRAPHY VALUE The other rate rule related date information of the car rental. Lookup for all possible types of CONTRACT STATUS. TRAFFIC CATEGORY ACCOUNT TRANSFER REASON ODT ACCOUNT MR_INTERVALS FREQUENT FLIER LOYALTY ACCOUNT BALANCE SOURCE. CUSTOMER SEGMENT Items presented to the customer or public as part of the CAMPAIGN. Details about the code share flights along with the segment and CARRIER to which the flight belongs. Lookup for different types of shipment methods. During this phase you’ll identify entities, relationships, and attributes and normalize your data. A type of INVENTORY CONTROL DOCUMENT LINE ITEM that records the type and amount of freight cost incurred on an INVENTORY CONTROL DOCUMENT. Describes the date hierarchy with a granularity as date and then gives week, month, quarter, and year. BOOKING CAMPAIGN ASSIGNMENT A unique retailer assigned code denoting a type of CUSTOMER ORDER, PURCHASE ORDER, or ORDER. IND= “Individual", GRP= “Group", COR= “Corporate" or NCO= “Non Commercial". 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. 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. For example: The value can vary at different time periods of the CONTRACT. PURCHASE ORDER PARTY STATUS CHANGE REASON BOOKING The information about billing transaction ticket. CUSTOMER RESTRICTED INFO ACCOUNT Associates product market plans to a promotion. For example, for operational cost several organizations may share the same expense on a promotion or campaign. PARTY INTERACTION THREAD Work Order details, including actual start and finish. Portuguese/Portugal / Português/Portugal The payment information of hotel booking. Defines weeks in a Gregorian or Normal Calendar. HALF MONTH TRANSFORMATION Specifies the checking information at the LEG level. For example: This is a reference level entity for information on the TSM MCO fare information. COUNTERS JOB ROLE TARGET ACCOUNT Billing transaction ticket qualifying issue information. The amount information about billing transaction ticket. PROMOTION PRODUCT OFFERING ASSIGNMENT Specifies the daily summary data about LOYALTY ACCOUNT (for a FREQUENT FLYER). Passenger information for the booking. Defines quarter in a Gregorian or Normal Calendar. TAX LINE ITEM LOCAL TAX AUTHORITY MARKET SEGMENT Different types of organization name represent their business legal status. For example: Lookup for different types of shipment priority. DELAY CAUSE This is the base level information for the details of ticket price discounts. FLIGHT SEGMENT INVENTORY TRAFFIC RESTRICTION For example: Lookup for all possible result of initiatives. For example, item could be Acme shirt, with associated SKUs for each color and size of the shirt. FLIGHT SEGMENT INVENTORY CABIN BOARDING FIGURES DCS For example are: To categorize the different cost charges inside the CARRIER for different purpose. External source for merchandise and goods that the ORGANIZATION STORE offers or for supplies and goods. FLIGHT INVENTORY OPERATIONS Code detailing the reason for a flight cancelation. The billable information for hotel booking transaction. The car rental tariff charge information. List of all the business levels within an organization. Any real thing that you would want to put a name to is a party. EMPLOYEE JOB ROLE ASSIGNMENT FREQUENT FLIER CUSTOMER LIFE TIME VALUE SOURCE. TASK LIST Any logical entity that is recognized as a part of the enterprise for business analysis and transactions. Each entity has various attributes, and each attribute is housed in an individual field. FLIGHT SEGMENT INVENTORY CABIN BOOKING SUBCLASS AVAILABILITY Subsequently, additionally, it displays your relationship between each of these entities. BOOKING PRODUCT TSM ROUTE Specifies the account number and the cost center associated with each BOOKING. DIRECT EARNING Represents Decision Tree rules, derived from customer loyalty decision tree mining model. The form of payment information for hotel booking. Reason codes are grouped into REASON CATEGORYs based on where they are referenced. FREQUENT FLIER CUSTOMER LIFE TIME VALUE APPLY. Associative entity connecting any level of the item hierarchy and organization hierarchy, and optionally a VENDOR, with the promotion. The surcharge period of the car rental transaction. A customer account in a membership program. 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. Acceptance channel types can be Front-End, KSK for Kiosk, MBL for Mobile check-in channel origin. BOOKING TST PROMOTION BOOKING SEAT The segments are typically used in marketing campaigns. By commenting, you are accepting the 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). CAR PRODUCT DISQUS’ privacy policy. At this Data Modeling level, no primary or secondary key is defined. A certificate with a face monetary value issued by a store for subsequent exchange for merchandise. ATA CHAPTER Describes an event celebrated or observed by a customer. A campaign is a concentrated effort to enhance the image of the enterprise to retain, acquire, or consolidate customers. SERVICE COVERAGE GEO DETAIL CHECKIN FACT HOTEL BOOKING CUSTOMER REFERENCE They refine the data elements introduced by a Conceptual data model and form the basis of the Physical data model. The touchpoint can be both logical and physical. In this case normally the ODT account is protected by a password. This chapter includes the following sections: Logical Entities for Business Areas CURRENCY The logical data model is the next layer down, and is the one we are most involved in when designing the BI application. LOYALTY ACCOUNT LEVEL HISTORY BILLING TRANSACTION COUPON ADDITIONAL PRINT LINES. 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. RETAIL SALE RETURN LINE ITEM Weekly sales forecast information at given levels of ITEM, and organization hierarchies. COMPETITIVE TIER Once set up, the customer can use the account to do self service at airlines Website or terminal. Weather details at a specific date, time, and location. Represents apply results of non-frequent flier related mining models on non-frequent fliers latest data. FLIGHT LEG INVENTORY CABIN SALECONFIG CHARACTERISTIC. MONTH TODATE TRANSFORMATION 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. This is a entity in the operational layer to cater to a particular condition used to interpret the office. Specifies the status of bookings, cancelations, confirmations, and so on, as on date for future departures starting the next day. Organization hierarchy level within an ORGANIZATION CORPORATE and is the parent of one or more ORGANIZATION CHAINs. This information can be used to perform item searches by manufacturer part number. The billing information about each booking. HOTEL BOOKING Reference Entities define the entities within, and associated with the airline organization for which data is recorded and analyzed. Information about the individual baggage during the check-in process. FLIGHT SEGMENT INVENTORY CABIN BOARDING FIGURES DCS. PART CAMPAIGN MANAGEMENT HISTORY EMPLOYEE DESIGNATION The most detailed level of job code from Standard Occupational Classification (SOC) System. For example: List of inventory items that can be used, identifies interchangeable parts that can be used at a location. COMPLAIN ADVICE DAILY LOYALTY ACCOUNT BOOKING. To date transformation information at the half-month level. HOTEL BOOKING COMMISSION DAILY FLIGHT DETAILS Specifies attributes of an individual prospect, one who is not an organization. AIRCRAFT TYPE The relationships may include those among customers or between customers and the airline. 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 BALANCE HISTORY Physical location where merchandise resides. Polish / polski TICKET PRICING DISCOUNT CAMPAIGN 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. Associative entity for ITEM, SEASON, and PHASE. Examples are Christianity, Islamic, and Hinduism. MEDIA OBJECT PARTY STATUS Scripting appears to be disabled or not supported for your browser. BILLING TRANSACTION TICKET VAT INFORMATION PDI CHANNEL PNR RELATIONSHIP CAR RENTAL REMARKS A marketing practice in which two or more airlines agree to share for marketing purposes. 831 HEL-LHR. CAR RENTAL TARIFF CHARGE For example: 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. Defines related calendar elements for performing to-date time transformations. Entity represents information about the frequent flyer. The meeting point for customer and retail organization. PARTY ROLE ASSIGNMENT For example: The Special Service Request (SSR) is a request to an airline for services or amenities other than the standard requests. Essential documents about the passenger. ORGANIZATION CORPORATE POSTCODE For example: Specifies details of each allocation of money from a receipt made by a party to a specific account. PAX COUPON DATA The ticket stores the ticket number and the issuing office for the ticket. Assignment of a GEOGRAPHY HIERARCHY LEVEL to a GEOGRAPHY ENTITY; assigns geography values to hierarchy levels. UNIT CONFIGURATION HISTORY PHASE The legal status of the company. LOG_BOOK For example, the CARRIER which it belongs to or if there is an alpha suffix associated. Establishing the high level logical model is a necessary foundation before I dive into detailed architecture of data mesh core components in future articles. BILLING TRANSACTION PREPAID TICKET ADVICE SPONSOR INFORMATION. Provides SVM factors for attributes of non-frequent flier passengers. This seems to be three alternative terms for one and the same thing. TIME TOTAL A collection of eligibility and price derivation rules, during a specific time. The logical data model can be This is an analytical layer entity of the type dimension with a granularity of city. UNIT_EFFECTIVITIES Depending on type of PARTY, the relationship might be: Some customer belongs to some country, visited (roamed or not) other countries. Weekly sales plan including Returns, Cost of Sales, PROMOTIONs, Clearance, at given levels of ITEM and ORGANIZATION HIERARCHY. Allows the user to categorize each item according to different seasons and phases within a season. describes the data and the relationships in detail at a very high level PROMOTION CLUSTER USAGE The choice of which item is made by the customer at the POS. OPERATION MATERIAL Aggregate SKU: Subtype of SKU that is an aggregation of one or more constituent SKU. COMP PROD CRRL CHARACTERISTIC ASSIGNMENT MASTER CONFIGURATION HEADER They will need to know which entities to add. PNR TYPE Associative entity for EMPLOYEE and JOB ROLES. For example: The domain of classifications used to group profile information about a PARTY. VEHICLE SALES CHANNEL CUSTOMER ORDER LINE ITEM PARTY ORDER ASSIGNMENT That information, along with your comments, will be governed by Specifies details about the codeshare flights along with the segment and CARRIER to which the flight belongs. The POS Item ID will generally be filled with the GTIN (UPC, EAN, and so on) for an item -- but it is not mandatory. Represents Support Vector Machine (SVM) factors of attributes of customers, derived from customer life time value support vector machine mining model. This is a lookup entity to roll up different revenue cost element categories into different groups. Airline agency detailed information from billing transaction data. This entity relates parties with events. REVENUE COST TRANSACTION SKU ITEM FLIGHT SEGMENT INVENTORY CABIN BOOKING CLASS CODESHARE BOARDINGFIGURES DCS. CUSTOMER RECENCY FREQUENCY MONETARY PROFITABILITY SCORE. This is at each individual passenger level and segment level. ROUTES TOUR DIV-2 – Logical Data Model The DIV-2 allows analysis of an architecture’s data definition aspect, without consideration of implementation-specific or product-specific issues. Hungarian / Magyar This is a reference entity for information about the form of a payment for ticketing. CAR RENTAL SURCHARGE PERIOD The Geography information included in a specific CAMPAIGN. Another purpose is to provide a common dictionary of data definitions to consistently express models wherever logical-level data elements are included in the descriptions. REVENUE COST ELEMENT GROUP An employee must have multiple discount groups, and several employees must have the same discount group. Tour operators (or sales people/Group Analysts on their behalf) enter their series requests for the upcoming season into the system. 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. A level in a product hierarchy frequently used for business analysis. POS IDENTITY NON ROUTINE For example: Type of geographic hierarchy. AIRCRAFT DISPATCH this classification can be based on, Community: This is represented as the one set of demographic attributes as described in the demography entity. BILLING TRANSACTION TICKET PASSENGER BOOKING TST PFC TAX AMOUNT LANGUAGE DIALECT CHECKIN INDIVIDUAL BAGGAGE For example,,1,2,3,4,5 or 1~10,11~20. It is also called Credit rating agency. Represents Decision Tree (DT) rules, derived from frequent flier prediction decision tree mining model. HOUR NATIONALITY For example: Subtype of PARTY INTERACTION, which represents the interaction with customer through letter. A line item component of a CUSTOMER placed ORDER. CUSTOMER SEGMENTATION MODEL Each data modeler should test their logical data model or models before completing project work and merging into a shared model in an SCM system. PARTY Subtype of CUSTOMER (and PARTY), which contains details of individuals as opposed to organizations. The special service request (SSR) for flight inventory at LEG level. CALL CENTER PLANNING YEAR 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. FREQUENT FLYER UNIT_ACCOMPLISHMNTS The segment level cabin booking class boarding data. ORGANIZATION MARKET DATA Serbian / srpski If a customer raises multiple complaints about the same issue, those calls are grouped into single thread. All agents belong to an office. ORGANIZATION WAREHOUSE BILLING TRANSACTION TICKET FORM OF PAYMENT CARRIER COMPETITOR SWOT FLIGHT SEGMENT INVENTORY CABIN BOOKING CLASS CODESHARE DCS The selling location may be assigned to or rented by a VENDOR. This is a operational layer entity which stores the ticket number and the issuing office of the ticket. The data redundancy can be eliminated from the database as the data model can easily identify the redundant data. PARTY CONTACT INFORMATION TYPE This is the base level entity with information on the details of TSM MCO tax. The complete details of a passenger's BOOKING, including itinerary, contact details, and special requests. Allocation does not indicate inventory levels or existence of SKU ITEMs in the INVENTORY LOCATION. Contains the information about different organization banners under which product or service are sold. GEOGRAPHY HIERARCHY LEVEL ASSIGNMENT Specifies the details of the booking products. 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. SEASON SEGMENT DIM For example: Lookup for all possible terms which may be attached to a CONTRACT. Specifies the airport terminal related information. A history of campaign party role about management of a campaign episode. SSR The advantage of the Logical data model is to provide a foundation to form the base for the Physical model. PROSPECT INDIVIDUAL ADDRESS RELATED GEOGRAPHY DEMOGRAPHY ATTRIBUTES Advertising MEDIA associated with a CAMPAIGN. Billing transaction issuance reason information from MISCELLANEOUS DOCUMENT. Can be physical or electronic. In CADS, this categorization is split into two categorizations: Traffic Flight Type and Route Hierarchy Level 1. It captures the restricted information for the customer or prospects. WEEKDAY 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. BILLING TRANSACTION ELECTRONIC TRANSACTION PARTY STATUS HISTORY Assigns a PARTY to one or more GEOGRAPHY ENTITYs. A number or text that can be assigned to a CompProdCorrelationCharacteristic. The warehouse is to store the equipment instance like maintenance parts before delivering to the customer. BILLING TRANSACTION DOCUMENT AMOUNTS COMPLAIN CLASS ADDRESS LOCATION Represents tour and tour related information. It is used as a record of the flight and as a communication tool between pilots and the ground crew. For example: Lookup for description of the contract status change. For example, the capture and storage of TRANSACTIONS and operational performance reporting. CAMPAIGN MESSAGE Type of ORGANIZATION business unit. To be further investigated, difference with "xxx hourly". Represents customer LOYALTY ACCOUNT balance details for the last number of months. Lookup for the reason of the interaction thread. User defined. The entity is used to store all the miles earning activity from carrier's partners. SCRAP_VALUES Represents non-frequent flier passengers demographic and BOOKING details for a period months. FLIGHT INVENTORY SCHEDULE ASSIGNMENT It includes all the entities, relationships and attributes. User defined attribute definitions and corresponding values regarding demographic statistics as related to an ORGANIZATION BUSINESS UNIT. Route Pair means a grouping of Routes. Catalan / Català Transformations for a month. BILLING OFFICE TOTALS CURRENCY RETAIL STORE Macedonian / македонски Defines a Transitional Store Ticket (TST) generated with the BOOKING. That is, a user may assign a season of “Spring" to a group of items, according to the supplier's deliveries of fashion items. AIRCRAFT 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. -- Marcel Douwe Dekker 21:23, 15 October 2008 (UTC) Individual demography value, the detailed information and its value collected about customers. GEOGRAPHY DEMOGRAPHIC GROUP For example: Different Dealer or partner may also have different discount policy according to their relationship with Service provider and sales volume. MAINTENANCE REQUIREMENT The segment level cabin inventory data for code share flight. ER modeling helps you to assess info specifications systematically to make a … The segment level inventory update by DCS input. SECOND For example: Organization hierarchy level within an ORGANIZATION COMPANY and is the parent of one or more ORGANIZATION AREAs. BOOKING TST FARE DATA FISCAL WEEK The detailed operations for each agent and each booking. Each series request is for a certain number of seats, one-way on a certain segment, on a certain weekday for a certain period. Describes the derived value of the customer. Represents the top most level of time. Describes the detailed information and its value collected about organizations. TSM PASSENGER The Access Methods included in a specific CAMPAIGN. FLIGHT LEG INVENTORY CABIN Time zone relative to Greenwich Mean Time (GMT). COMP INTEL CHARACTERISTIC For example, if the booking is done with other bookings, this hotel booking can save a certain amount of money. SOC JOB Scripting on this page enhances content navigation, but does not change the content in any way. This is a sub entity of party individual. DEPARTMENT Represents customer life time value prediction mining model. FLIGHT SEGMENT INVENTORY Customer classification in its income/revenue term. HOTEL FACILITY This is an operational layer entity which stores the information of the PNR type. BOOKING OTHER SERVICE MARKET AREA For example, a page in a newspaper, or a time slot in a TV broadcast. EMPLOYEEs in different level have a different discount group. PASSENGER VISA INFORMATION This information is mainly baggage tag, baggage source, baggage tag number, baggage tag final destination, and airline code. A logical data model, as the name suggests, represents the logical relationships between the data of any organization. ACCOUNT LEVEL For example: Lookup of SKILL TYPE for a individual party. ITEM DISQUS terms of service. Value type can be time or money. For example: Route means a number of flights that carry the same flight number. Entity-Relation model is based on the idea of true-planet entities and the relationship between the two. CALENDAR HALF MONTH Represents customers recency, frequency, monetary, and profitability score at a month level. Lookup for the type of the BANK CARD. PARTY INTERACTION VISIT FLIGHT SCHEDULE FLIGHT SEGMENT INVENTORY CABIN BOOKING SUBCLASS FLAG. Bulgarian / Български SEGMENT SCHEDULE For example: Identifies the department within the organization. FLIGHT SEGMENT INVENTORY TRAFFIC RESTRICTION. REVENUE COST ELEMENT CUSTOMER REVENUE BAND It defines the structure of the data elements and set the relationships between them. A written or printed paper, or digital equivalent, that evidences the movement of merchandise or supply SKU ITEMs. 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). BOOKING OFFICE Assign the Competitor Product Correlation CHARACTERISTIC to the related competitor intelligence characteristic. An event captures information pertaining to the aircraft or flight. A type of INVENTORY CONTROL DOCUMENT recording a request for SKU ITEMs to be sent from a ORGANIZATION DISTRIBUTION CENTER to a ORGANIZATION STORE. E-mail address associated with a location. Finnish / Suomi Associates one address with other addresses. For example, the CARRIER which it belongs to or if there is an alpha suffix. Structured marketing efforts that reward, and therefore encourage loyal buying behavior. For example: Defines the temperature, relative humidity, lighting, and other physical or climatic environmental requirements for storing and displaying the item. PNR PARENT CHILD RELATIONSHIP Croatian / Hrvatski LOT_NUMBERS Keeps the special discount groups of employee or Partner. Any logical entity that is recognized as a product or item for Business Analysis and transactions. In the example, we have identified the entity names, attribute names, and relationship. PLANNING WEEK FLIGHT LEG INVENTORY FLIGHT LEG INVENTORY CABIN ACV CONFIG FLIGHT SEGMENT INVENTORY CABIN CODESHARE BLOCKSPACE COUNTER The ODT account tracks the financial or services interactions of a customer with the airline. ADDRESS TYPE Association of a PARTY with one or more other PARTY. Specifies the award voucher given by an airline. Items, quantities and amounts included in a PURCHASE ORDER. The market statistical information gathered about the competitors and the market. Specifies the number of units of data which are used to present different KPIs for flight inventory. Please note that DISQUS operates this forum. System of record from which Oracle Airlines Data Model data was loaded. The segment level cabin boarding data from DCS. 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. The relational tables, foreign and primary keys are all defined by the data models. FLIGHT SEGMENT INVENTORY CABIN BOOKING SUBCLASS COUNTERS. HOT FILE HEADER Determine revenue band of the customer. Keep the type of contact information. FLIGHT SEGMENT INVENTORY CABIN BOOKING SUBCLASS YIELD Information about the flight is stored. 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). BILLING TRANSACTION TICKET COMMISSION You also need a plan that is visible and laid out correctly. Lookup entities describe the relatively static or descriptive data in the data warehouse. MR_EFFECTIVITY_DTLS The various designations present in an organization for the employees. DOCUMENT