4 Oracle Airlines Data Model Logical to Physical Mapping

Provides a table listing the Oracle Airlines Data Model entities in the logical data model, and the physical database tables or views to which the logical entities have been implemented or "physicalized".

Logical to Physical Mappings for Oracle Airlines Data Model

Provides a table listing the Oracle Airlines Data Model entities in the logical data model, and the physical database tables or views to which the logical entities have been implemented or "physicalized".

Table 4-1 Entity Mapping Table: Logical to Physical Mapping

Entity Physical Table Name

ACCOUNT

DWR_ACCT

ACCOUNT DIM

DWR_ACCT_DIM

ACCOUNT LEVEL

DWL_ACCT_LVL

ACCOUNT LEVEL HISTORY

DWB_ACCT_LVL_HIST

ACCOUNT PAYMENT

DWB_ACCT_PYMT

ACCOUNT TRANSFER

DWB_ACCT_TRNSFR

ACCOUNT TRANSFER REASON

DWL_ACCT_TRNSFR_RSN

ACCOUNT TYPE

DWL_ACCT_TYP

ADDRESS LOCATION

DWR_ADDR_LOC

ADDRESS LOCATION STATUS HISTORY

DWR_ADDR_LOC_STAT_HIST

ADDRESS RELATED

DWR_ADDR_RLTD

ADDRESS TYPE

DWL_ADDR_TYP

AGENCY

DWR_AGNCY

AIRCRAFT

DWR_ARCFT

AIRCRAFT DISPATCH

DWB_ARCFT_DSPTCH

AIRCRAFT TURN AROUND

DWB_ARCFT_TRN_ARND

AIRCRAFT TYPE

DWR_ARCFT_TYP

AIRCRAFT VERSION

DWR_ARCFT_VRSN

AIRCRAFT VERSION

DWR_ARCFT_VRSN_DIM

AIRPORT

DWR_ARPRT

AIRPORT

DWR_ARPRT_DIM

ALTERNATIVE ITEMS

DWR_ALTVE_ITEM

AMOUNT TYPE

DWL_AMT_TYP

ASSET_DATA_DRAFT

DWB_ASSET_DATA_DRFT

ATA CHAPTER

DWL_ATA_CHPTR

AWARD VOUCHER

DWB_AWRD_VCHR

BANK

DWR_BNK

BANK CARD

DWR_BNK_CARD

BANK CARD TYPE

DWL_BNK_CARD_TYP

BANNING REASON

DWL_BNNING_RSN

BASE DAY

DWR_BASE_DAY

BILLING ANALYSIS HEADER

DWB_BLLG_ANLYS_HDR

BILLING ANALYSIS TOTALS CURRENCY

DWB_BLLG_ANLYS_TOT_CRNCY

BILLING OFFICE HEADER

DWB_BLLG_OFFC_HDR

BILLING OFFICE SUBTOTALS TRANSACTION CURRENCY

DWB_BLLG_OFFC_SBTOT_TRX_CRNCY

BILLING OFFICE TOTALS CURRENCY

DWB_BLLG_OFFC_TOT_CRNCY

BILLING TRANSACTION AGENCY AIRLINE INFO

DWB_BLLG_TRX_AGNCY_ARLN_INFO

BILLING TRANSACTION COMPLETE FORM OF PAYMENT

DWB_BLLG_TRX_CMPLT_FORMOF_PYMT

BILLING TRANSACTION COMPLETE TICKET DOCUMENT

DWB_BLLG_TRX_CMPLT_TCKT_DOC

BILLING TRANSACTION COUPON ADDITIONAL PRINT LINES

DWB_BLLG_TRX_CPN_ADDL_PRINT_LN

BILLING TRANSACTION DOCUMENT AMOUNTS

DWB_BLLG_TRX_DOC_AMT

BILLING TRANSACTION ELECTRONIC TRANSACTION

DWB_BLLG_TRX_ELCTRNC_TRX

BILLING TRANSACTION EMD COUPON DETAIL

DWB_BLLG_TRX_EMD_CPN_DTL

BILLING TRANSACTION EMD REMARKS

DWB_BLLG_TRX_EMD_RMRK

BILLING TRANSACTION FARE CALCULATION

DWB_BLLG_TRX_FARE_CALC

BILLING TRANSACTION FILE TOTALS CURRENCY

DWB_BLLG_TRX_FL_TOT_CRNCY

BILLING TRANSACTION FORM OF PAYMENT

DWB_BLLG_TRX_FORM_OF_PYMT

BILLING TRANSACTION HEADER

DWB_BLLG_TRX_HDR

BILLING TRANSACTION MD ADDITIONAL INFO

DWB_BLLG_TRX_MD_ADDL_INFO

BILLING TRANSACTION MD INFO AMOUNT

DWB_BLLG_TRX_MD_INFO_AMT

BILLING TRANSACTION MD ISSUANCE REASON

DWB_BLLG_TRX_MD_ISSNCE_RSN

BILLING TRANSACTION NETTING VALUES

DWB_BLLG_TRX_NETNG_VAL

BILLING TRANSACTION PAYMENT AUTHORIZATION

DWB_BLLG_TRX_PYMT_ATHRZTN

BILLING TRANSACTION PREPAID TICKET ADVICE SPONSOR INFORMATION

DWB_BT_PRPD_TCKT_ADC_SPNSR_INF

BILLING TRANSACTION RELATED TICKET

DWB_BLLG_TRX_RLTD_TCKT

BILLING TRANSACTION TICKET

DWB_BLLG_TRX_TCKT

BILLING TRANSACTION TICKET AMOUNT

DWB_BLLG_TRX_TCKT_AMT

BILLING TRANSACTION TICKET COMMISSION

DWB_BLLG_TRX_TCKT_CMISN

BILLING TRANSACTION TICKET FORM OF PAYMENT

DWB_BLLG_TRX_TCKT_FORM_OF_PYMT

BILLING TRANSACTION TICKET ITINERARY DATA SEGMENT

DWB_BT_TCKT_ITNRY_DATA_SEG

BILLING TRANSACTION TICKET MISCELLANEOUS ADDITIONAL PRINT LINES

DWB_BT_TCKT_MISCLNSADDL_PRNTLN

BILLING TRANSACTION TICKET PASSENGER

DWB_BLLG_TRX_TCKT_PAX

BILLING TRANSACTION TICKET QUALIFYING ISSUE INFORMATION

DWB_BT_TCKT_QLFYNG_ISSUE_INFO

BILLING TRANSACTION TICKET TAX ON COMMISSION

DWB_BLLG_TRX_TCKT_TAX_ON_CMISN

BILLING TRANSACTION TICKET VAT INFORMATION

DWB_BLLG_TRX_TCKT_VAT_INFO

BLACK LIST HISTORY

DWR_BLK_LST_HIST

BOOKING

DWB_BKG

BOOKING AGENT OPT LINE

DWB_BKG_AGNT_OPT_LN

BOOKING BILLING

DWB_BKG_BLLG

BOOKING CAMPAIGN ASSIGNMENT

DWB_BKG_CMPGN_ASGN

BOOKING CLASS

DWR_BKG_CLS

BOOKING CLASS TYPE

DWR_BKG_CLS_TYP

BOOKING DAILY INVENTORY SNAPSHOT

DWA_BKG_DLY_INV_SNPST

BOOKING OFFICE

DWR_BKG_OFFC

BOOKING OFFICE

DWR_BKG_OFFC_DIM

BOOKING OFFICE USER

DWR_BKG_OFFC_USER

BOOKING OTHER SERVICE

DWB_BKG_OTHR_SRVC

BOOKING PASSENGER

DWR_BKG_PAX

BOOKING PASSENGER

DWR_BKG_PAX_DIM

BOOKING PASSENGER DOCUMENT INFORMATION

DWR_BKG_PAX_DOC_INFO

BOOKING PRODUCT

DWR_BKG_PROD

BOOKING PRODUCT DETAIL

DWR_BKG_PROD_DTL

BOOKING PRODUCT TYPE

DWL_BKG_PROD_TYP

BOOKING REMARK

DWB_BKG_RMRK

BOOKING SEAT

DWR_BKG_SEAT

BOOKING SEAT PREFERENCE

DWR_BKG_SEAT_PREF

BOOKING SERIES

DWR_BKG_SRIS

BOOKING SSR

DWB_BKG_SSR

BOOKING SSR BRDG

DWB_BKG_SSR_BRDG

BOOKING STATUS CHANGE HISTORY

DWB_BKG_STAT_CHNG_HIST

BOOKING STATUS CHANGE REASON

DWL_BKG_STAT_CHNG_RSN

BOOKING TST

DWB_BKG_TST

BOOKING TST

DWR_BKG_TST_DIM

BOOKING TST FARE DATA

DWB_BKG_TST_FARE_DATA

BOOKING TST PFC TAX AMOUNT

DWB_BKG_TST_PFC_TAX_AMT

BOOKING TST PRICE

DWB_BKG_TST_PRC

BOOKING TST SEGMENT

DWB_BKG_TST_SEG

BOOKING TST TAX

DWB_BKG_TST_TAX

BORROW_TRANSACTIONS

DWB_BRRW_TRNS

BUSINESS HALF MONTH

DWR_BSNS_HLF_MO

BUSINESS HALF YEAR

DWR_BSNS_HLF_YR

BUSINESS LEGAL STATUS

DWL_BSNS_LEGAL_STAT

BUSINESS MONTH

DWR_BSNS_MO

BUSINESS QUARTER

DWR_BSNS_QTR

BUSINESS UNIT JOB ROLE

DWR_BSNS_UNIT_JB_RL

BUSINESS UNIT SHIFT

DWR_BSNS_UNIT_SHFT

BUSINESS YEAR

DWR_BSNS_YR

CALENDAR

DWR_CLNDR

CALENDAR HALF MONTH

DWR_CLNDR_HLF_MO

CALENDAR HALF YEAR

DWR_CLNDR_HLF_YR

CALENDAR MONTH

DWR_CLNDR_MO

CALENDAR QUARTER

DWR_CLNDR_QTR

CALENDAR WEEK

DWR_CLNDR_WK

CALENDAR YEAR

DWR_CLNDR_YR

CALL CENTER

DWR_CALL_CNTR

CALL CENTER AGENT

DWR_CALL_CNTR_AGNT

CALL CENTER SERVICE CAPABILITY

DWR_CALL_CNTR_SRVC_CAPBLTY

CAMPAIGN

DWR_CMPGN

CAMPAIGN MANAGEMENT HISTORY

DWR_CMPGN_MGMT_HIST

CAMPAIGN MEDIA SELLING ITEM

DWR_CMPGN_MEDIA_SLNG_ITEM

CAMPAIGN MESSAGE

DWR_CMPGN_MSG

CAMPAIGN STATUS

DWL_CMPGN_STAT

CAMPAIGN TYPE

DWL_CMPGN_TYP

CAR PRODUCT

DWR_CAR_PROD

CAR RENTAL

DWB_CAR_RNTL

CAR RENTAL ADDITIONAL RATE CODE INFO

DWB_CAR_RNTL_ADDL_RT_CD_INFO

CAR RENTAL CHARGE PERIOD

DWB_CAR_RNTL_CHRG_PRD

CAR RENTAL ESTIMATE DISTANCE

DWB_CAR_RNTL_ESTM_DISTNC

CAR RENTAL FOP

DWB_CAR_RNTL_FOP

CAR RENTAL LOCATION

DWB_CAR_RNTL_LOC

CAR RENTAL MODEL

DWR_CAR_RNTL_MDL

CAR RENTAL OTHER RATE RULE

DWB_CAR_RNTL_OTHR_RT_RULE

CAR RENTAL OTHER RATE RULE DATE

DWB_CAR_RNTL_OTHR_RT_RULE_DT

CAR RENTAL PREFERENCE TYPE

DWB_CAR_RNTL_PREF_TYP

CAR RENTAL REMARKS

DWB_CAR_RNTL_RMRK

CAR RENTAL SURCHARGE PERIOD

DWB_CAR_RNTL_SRCHRG_RPD

CAR RENTAL SURCHARGE PERIOD TARIFF

DWB_CAR_RNTL_SRCHRG_RPD_TRFC

CAR RENTAL TARIFF

DWB_CAR_RNTL_TRFC

CAR RENTAL TARIFF CHARGE

DWB_CAR_RNTL_TRFC_CHRG

CARRIER

DWR_CARRIER

CARRIER

DWR_CARRIER_DIM

CARRIER TYPE

DWR_CARRIER_TYP

CERTIFICATE

DWR_CRTFCT

CHANNEL

DWR_CHNL

CHECKIN

DWB_CHKIN

CHECKIN BAGGAGE GROUP

DWR_CHKIN_BAG_GRP

CHECKIN DAILY FACT

DWA_CHKIN_DLY

CHECKIN INDIVIDUAL BAGGAGE

DWR_CHKIN_INDVL_BAG

CODESHARE

DWR_CDSHR

CODESHARE BRIDGE

DWA_CDSHR_BRDG

CODESHARE BRIDGE

DWB_CDSHR_BRDG

COMP INTEL CHARACTERISTIC

DWR_COMP_INTL_CHR

COMP INTEL CHARACTERISTIC VALUE

DWR_COMP_INTL_CHR_VAL

COMP INTEL MARKET SEGMENT

DWR_COMP_INTL_MKT_SEG

COMP PROD CRRL CHARACTERISTIC ASSIGNMENT

DWR_COMP_PROD_CRRL_CHR_ASGN

COMP PROD CRRL CHARACTERISTIC VALUE

DWR_COMP_PROD_CRRL_CHR_VAL

COMPENSATORY EARNING

DWB_CMNSTRY_ERNG

COMPENSATORY REASON

DWL_CMNSTRY_RSN

COMPETITIVE TIER

DWR_CMPTVE_TIER

COMPETITOR

DWR_CMPTR

COMPETITOR INTELLIGENCE

DWR_CMPTR_INTLGNCE

COMPETITOR INTELLIGENCE PARTY ROLE

DWR_CMPTR_INTLGNCE_PRTY_RL

COMPETITOR MARKET SEGMENT ASSIGNMENT

DWR_CMPTR_MKT_SEG_ASGN

COMPETITOR MARKET SEGMENT SWOT

DWR_CMPTR_MKT_SEG_SWOT

COMPETITOR PRODUCT CORRELATION

DWR_CMPTR_PROD_CRLTN

COMPETITOR SWOT

DWR_CMPTR_SWOT

COMPETITOR TIER ASSIGNMENT

DWR_CMPTR_TIER_ASGN

COMPLAIN ADVICE

DWB_CMPLN_ADVC

COMPLAIN CLASS

DWL_CMPLN_CLS

COMPLAIN TYPE

DWL_CMPLN_TYP

CORPORATE CUSTOMER

DWR_CRPRT_CUST

COST

DWB_CST

COST CENTER

DWR_CST_CNTR

COUNTERS

DWR_CNTRS

CREDIT SCORE PROVIDER

DWR_CRDT_SCR_PRVDR

CURRENCY

DWL_CRNCY

CUSTOMER

DWR_CUST

CUSTOMER INDIVIDUAL

DWR_CUST_INDVL

CUSTOMER OCCASION

DWR_CUST_OCCSN

CUSTOMER OCCASION TYPE

DWL_CUST_OCCSN_TYP

CUSTOMER ORDER

DWB_CUST_ORDR

CUSTOMER ORDER LINE ITEM

DWB_CUST_ORDR_LN_ITEM

CUSTOMER ORGANIZATION

DWR_CUST_ORG

CUSTOMER RESTRICTED INFO

DWR_CUST_RSTRCT_INFO

CUSTOMER REVENUE BAND

DWL_CUST_RVN_BND

CUSTOMER REVENUE BAND ASSIGNMENT

DWR_CUST_RVN_BND_ASGN

CUSTOMER REVENUE TYPE

DWL_CUST_RVN_TYP

CUSTOMER SCORE

DWR_CUST_SCR

CUSTOMER SEGMENT

DWR_CUST_SEG

CUSTOMER SEGMENTATION MODEL

DWR_CUST_SEGTN_MDL

CUSTOMER SOURCE

DWR_CUST_SRC

CUSTOMER SURVEY AGG

DWA_CUST_SRVY

CUSTOMER TYPE

DWL_CUST_TYP

DAILY BOOKING FACT

DWA_DLY_BKG

DAILY CALL CENTER PERFORMANCE

DWA_DLY_CALL_CNTR_PRFMNC

DAILY LOYALTY ACCOUNT

DWA_DLY_LYLTY_ACCT

DAILY LOYALTY ACCOUNT BOOKING

DWA_DLY_LYLTY_ACCT_BKG

DAY

DWR_DAY

DEALER

DWR_DLR

DEFECT STATUS

DWL_DFCT_STAT

DELAY CAUSE

DWL_DELAY_CAUSE

DELAYS AND CANCELLATIONS

DWB_DELAY_AND_CNCL

DEMOGRAPHY ATTRIBUTE

DWR_DEMOG_ATRIB

DEMOGRAPHY GROUP

DWR_DEMOG_GRP

DEPARTMENT

DWR_DEPT

DERIVED VALUE

DWR_DRVR_VAL

DIRECT EARNING

DWB_DRCT_ERNG

DISCOUNT GROUP

DWR_DISC_GRP

DISPOSITIONS

DWB_DSPSTNS

DOCUMENT

DWR_DOC

EARNING EVENT

DWB_ERNG_EVT

EDUCATION

DWR_EDU

EMAIL ADDRESS

DWR_EML_ADDR

EMPLOYEE

DWR_EMP

EMPLOYEE ACTUAL LABOR HOURLY

DWB_EMP_ACT_LBR_HRLY

EMPLOYEE ACTUAL LABOR SALARIED

DWB_EMP_ACT_LBR_SLRED

EMPLOYEE DESIGNATION

DWL_EMP_DESIG

EMPLOYEE DISCOUNT GROUP ASSIGNMENT

DWR_EMP_DISC_GRP_ASGN

EMPLOYEE JOB ROLE ASSIGNMENT

DWR_EMP_JB_RL_ASGN

EMPLOYEE LANGUAGE CAPABILITY

DWR_EMP_LANG_CAPBLTY

EMPLOYEE RESTRICTED INFO

DWR_EMP_RSTRCT_INFO

EMPLOYEE SCHEDULE

DWR_EMP_SCHL

EMPLOYEE TRAINING RECORD

DWB_EMP_TRNG_REC

EMPLOYEE TYPE

DWL_EMP_TYP

EVENT

DWB_EVT

EVENT PARTY ASSIGNMENT

DWB_EVT_PRTY_ASGN

EVENT PARTY INTERACTION

DWB_EVT_PRTY_INTRACN

EXTERNAL CREDIT PROFILE

DWR_EXTRNL_CRDT_PRFL

EXTERNAL CREDIT PROFILE ASSIGNMENT

DWR_EXTRNL_CRDT_PRFL_ASGN

EXTERNAL ORGANIZATION TYPE

DWL_EXTRNL_ORG_TYP

FARE ELEMENT

DWR_FARE_ELMNT

FARE TYPE

DWR_FARE_TYP

FISCAL HALF MONTH

DWR_FSCL_HLF_MO

FISCAL HALF YEAR

DWR_FSCL_HLF_YR

FISCAL MONTH

DWR_FSCL_MO

FISCAL QUARTER

DWR_FSCL_QTR

FISCAL WEEK

DWR_FSCL_WK

FISCAL YEAR

DWR_FSCL_YR

FLEET

DWL_FLET

FLEET_HEADERS

DWR_FLET_HDRS

FLEET UNIT ASSOCIATE

DWB_FLET_UNIT_ASSOCT

FLIGHT

DWR_FLT

FLIGHT

DWR_FLT_DIM

FLIGHT CANCELLATION REASON

DWL_FLT_CNCL_RSN

FLIGHT CHANGE

DWB_FLT_CHNG

FLIGHT GATE OPERATION

DWB_FLT_GTE_OPRN

FLIGHT INVENTORY

DWR_FLT_INV

FLIGHT INVENTORY NUMBER OF UNITS

DWR_FLT_INV_NBR_OF_UNITS

FLIGHT INVENTORY OPERATION TYPE

DWL_FLT_INV_OPRN_TYP

FLIGHT INVENTORY OPERATIONS

DWR_FLT_INV_OPRN

FLIGHT INVENTORY SCHEDULE ASSIGNMENT

DWR_FLT_INV_SCHL_ASGN

FLIGHT INVENTORY STATUS

DWR_FLT_INV_STAT

FLIGHT LEG INVENTORY

DWR_FLT_LEG_INV

FLIGHT LEG INVENTORY CABIN

DWR_FLT_LEG_INV_CBN

FLIGHT LEG INVENTORY CABIN ACV CONFIG

DWR_FLT_LEG_INV_CBN_ACV_CONFIG

FLIGHT LEG INVENTORY CABIN BLOCKSPACE

DWR_FLT_LEG_INV_CBN_BLCKSPC

FLIGHT LEG INVENTORY CABIN RMS

DWR_FLT_LEG_INV_CBN_RMS

FLIGHT LEG INVENTORY CABIN SALECONFIG

DWR_FLT_LEG_INV_CBN_SLCONFIG

FLIGHT LEG INVENTORY CABIN SALECONFIG CHARACTERISTIC

DWR_FLT_LEGINV_CBN_SLCNFG_CHR

FLIGHT LEG INVENTORY SSR

DWR_FLT_LEG_INV_SSR

FLIGHT LEG INVENTORY SSR OPTION

DWR_FLT_LEG_INV_SSR_OPTN

FLIGHT LEG INVENTORY STATUS

DWR_FLT_LEG_INV_STAT

FLIGHT OPERATION DERIVED

DWD_FLT_OPRN

FLIGHT SCHEDULE

DWB_FLT_SCHL

FLIGHT SEGMENT INVENTORY

DWR_FLT_SEG_INV

FLIGHT SEGMENT INVENTORY CABIN

DWR_FLT_SEG_INV_CBN

FLIGHT SEGMENT INVENTORY CABIN BOARDING FIGURES DCS

DWR_FLTSEG_IVCN_BGCS_BDFIG_DCS

FLIGHT SEGMENT INVENTORY CABIN BOOKING CLASS CODESHARE BOARDINGFIGURES DCS

DWR_FLT_SEG_INVCBN_BRDG_FIGDCS

FLIGHT SEGMENT INVENTORY CABIN BOOKING CLASS CODESHARE DCS

DWR_FLTSEG_INCBBK_CLS_CSBRDRDC

FLIGHT SEGMENT INVENTORY CABIN BOOKING CLASS CODESHARE DCS

DWR_FLTSEG_INVCBN_BKGCLS_CSRDC

FLIGHT SEGMENT INVENTORY CABIN BOOKING CLASS STATUS

DWR_FLTSEG_INV_CBNBKG_CLS_STAT

FLIGHT SEGMENT INVENTORY CABIN BOOKING SUBCLASS AVAILABILITY

DWR_FLTSEG_INVCNBKG_SBC_AVLBTY

FLIGHT SEGMENT INVENTORY CABIN BOOKING SUBCLASS COUNTERS

DWR_FLTSEG_INVCBNBKG_SBC_CNTRS

FLIGHT SEGMENT INVENTORY CABIN BOOKING SUBCLASS DATEFLAG

DWR_FLTSEG_INVCBNBKG_SBC_DTFLG

FLIGHT SEGMENT INVENTORY CABIN BOOKING SUBCLASS FLAG

DWR_FLTSEG_INV_CBN_BKG_SBC_FLG

FLIGHT SEGMENT INVENTORY CABIN BOOKING SUBCLASS NEGO

DWR_FLTSEG_INV_CBNBKG_SBC_NEGO

FLIGHT SEGMENT INVENTORY CABIN BOOKING SUBCLASS YIELD

DWR_FLTSEG_INV_CBN_BKG_SBC_YLD

FLIGHT SEGMENT INVENTORY CABIN CODESHARE

DWR_FLT_SEG_INV_CBN_CDSHR

FLIGHT SEGMENT INVENTORY CABIN CODESHARE BLOCKSPACE COUNTER

DWR_FLTSEG_IVCN_CDSR_BLKSC_CTR

FLIGHT SEGMENT INVENTORY CODESHARE

DWR_FLT_SEG_INV_CDSHR

FLIGHT SEGMENT INVENTORY STATUS

DWR_FLT_SEG_INV_STAT

FLIGHT SEGMENT INVENTORY TRAFFIC RESTRICTION

DWR_FLT_SEG_INV_TRFC_RSTRCT

FLIGHT_DATA_DRAFT

DWB_FLT_DATA_DRFT

FORM OF PAYMENT

DWR_FORM_OF_PYMT

FREQUENT FLYER

DWR_FREQ_FLYR

FREQUENT FLYER

DWR_FREQ_FLYR_DIM

FREQUENT FLYER PREFERENCE

DWR_FREQ_FLYR_PREF

GENDER

DWR_GNDR

GEOGRAPHY

DWR_GEO

GEOGRAPHY DEMOGRAPHIC GROUP

DWR_GEO_DEMOG_GRP

GEOGRAPHY DEMOGRAPHY ATTRIBUTES

DWR_GEO_DEMOG_ATRIB

GEOGRAPHY DEMOGRAPHY VALUE

DWR_GEO_DEMOG_VAL

GEOGRAPHY ENTITY

DWR_GEO_ENT

GEOGRAPHY HIERARCHY

DWR_GEO_HRCHY

GEOGRAPHY HIERARCHY LEVEL

DWR_GEO_HRCHY_LVL

GEOGRAPHY HIERARCHY LEVEL ASSIGNMENT

DWR_GEO_HRCHY_LVL_ASGN

GEOGRAPHY HIERARCHY VERSION

DWR_GEO_HRCHY_VRSN

GEOGRAPHY LEVEL

DWR_GEO_LVL

GEOGRAPHY LEVEL ATTRIBUTE VALUE

DWR_GEO_LVL_ATRIB_VAL

GEOGRAPHY LEVEL ATTRIBUTES

DWR_GEO_LVL_ATRIB

GROUPING

DWB_GRPNG

HALF HOUR

DWR_HLF_HR

HALF MONTH TODATE TRANSFORMATION

DWR_HLF_MO_TODATE_TRANS

HALF MONTH TRANSFORMATION

DWR_HLF_MO_TRANS

HALF YEAR TODATE TRANSFORMATION

DWR_HLF_YR_TODATE_TRANS

HALF YEAR TRANSFORMATION

DWR_HLF_YR_TRANS

HOT FILE HEADER

DWB_HOT_FL_HDR

HOTEL BOOKING

DWR_HTL_BKG

HOTEL BOOKING BILLABLE INFO

DWR_HTL_BKG_BILLBL_INFO

HOTEL BOOKING COMMISSION

DWB_HTL_BKG_CMISN

HOTEL BOOKING CONTACT

DWR_HTL_BKG_CNCT

HOTEL BOOKING CUSTOMER REFERENCE

DWR_BKG_CUST_REF

HOTEL BOOKING FORM OF PAYMENT

DWR_HTL_BKG_FORM_OF_PYMT

HOTEL BOOKING MISC REMARKS

DWR_HTL_BKG_MISC_RMRK

HOTEL BOOKING OPTION TEXT

DWR_HTL_BKG_OPTN_TXT

HOTEL BOOKING SAVING AMOUNT

DWR_BKG_SVNG_AMT

HOTEL BOOKING STATUS

DWR_HTL_BKG_STAT

HOTEL FACILITY

DWR_HTL_FCLTY

HOTEL PAYMENT

DWR_HTL_PYMT

HOTEL PRODUCT

DWR_HTL_PROD

HOTEL PRODUCT AMENITY

DWR_HTL_PROD_AMNTY

HOTEL ROOM

DWR_HTL_RM

HOTEL TARIFF

DWR_HTL_TRF

HOTEL TARIFF CHARGE

DWR_HTL_TRF_CHRG

HOUR

DWR_HR

HOUSEHOLD

DWR_HSHLD

INDIVIDUAL DEMOGRAPHY VALUE

DWR_INDVL_DEMOG_VAL

INDIVIDUAL NAME

DWR_INDVL_NAME

INFLIGHT MEAL

DWR_INFLT_MEAL

INITIATIVE RESULT TYPE

DWL_INTTV_RSLT_TYP

INITIATIVE TYPE

DWL_INTTV_TYP

INTERACTION REASON

DWR_INTRACN_RSN

INTERACTION RESULT

DWR_INTRACN_RSLT

ITEM

DWR_ITEM

ITEM SEASON

DWR_ITEM_SEASON

JOB

DWR_JB

JOB ROLE

DWR_JB_RL

LANGUAGE

DWL_LANG

LANGUAGE DIALECT

DWR_LANG_DILCT

LEG DIM

DWR_LEG_DIM

LEG H

TBS

LEG SCHEDULE

DWB_LEG_SCHL

LEG TYPE

DWL_LEG_TYP

LETTER TYPE

DWL_LTTR_TYP

LOCAL AUTHORITY TYPE

DWL_LCL_AUTHRTY_TYP

LOCAL TAX AUTHORITY

DWR_LCL_TAX_AUTHRTY

LOG_BOOK

DWB_LG_BK

LOT_NUMBERS

DWR_LOT_NBR

LOYALTY ACCOUNT

DWR_LYLTY_ACCT

LOYALTY ACCOUNT BALANCE HISTORY

DWB_LYLTY_ACCT_BAL_HIST

LOYALTY ACCOUNT LEVEL HISTORY

DWB_LYLTY_ACCT_LVL_HIST

LOYALTY CONVERSION

DWB_LYLTY_CNVRSN

LOYALTY LEVEL

DWR_LYLTY_LVL

LOYALTY LEVEL

DWR_LYLTY_LVL_DIM

LOYALTY POINTS EXPIRE

DWB_LYLTY_PTS_EXP

LOYALTY PROGRAM

DWR_LYLTY_PROG

LOYALTY PROGRAM

DWR_LYLTY_PROG_DIM

MAINTNENACE REQUIREMENT

DWB_MNTNCE_REQRMNT

MAINTENANCE TYPE

DWL_MNTNCE_TYP

MAINTENANCE VISIT

DWB_MNTNCE_VST

MAINTENANCE VISIT TASK

DWB_MNTNCE_VST_TSK

MARITAL STATUS

DWL_MRTL_STAT

MARKET AREA

DWR_MKT_AREA

MARKET AREA

DWR_MKT_AREA_DIM

MARKET AREA LEVEL

DWR_MKT_AREA_LVL

MARKET SEGMENT

DWR_MKT_SEG

MARKET SEGMENT CHARACTERISTIC

DWR_MKT_SEG_CHR

MARKET SEGMENT CHARACTERISTIC VALUE

DWR_MKT_SEG_CHR_VAL

MARKET STATISTIC INCLUSION

DWR_MKT_STTSTC_INCLSN

MARKET STATISTICS

DWR_MKT_STTSTC

MASTER CONFIGURATION HEADER

DWR_MSTR_CNFGRTN_HDR

MATERIAL TRANSACTION

DWB_MTRL_TRNS

MEDIA OBJECT

DWR_MEDIA_OBJ

MEL

DWR_MEL

MEL ATTRIBUTE

DWL_MEL_ATTR

MEL_CDL_PROCEDURES

DWB_MEL_CDL_PROC

MEMBERSHIP ACCOUNT

DWR_MBRSHIP_ACCT

MFG_PART_NUMBERS

DWR_MFG_PART_NBR

MINIMUM CONNECTING TIMES

DWB_MIN_CNCTNG_TMS

MISCELLANEOUS REMARKS

DWR_MISCLNS_RMRK

MONTH TODATE TRANSFORMATION

DWR_MO_TODATE_TRANS

MONTH TRANSFORMATION

DWR_MO_TRANS

MR EFFECTIVITY

DWB_MR_EFCTVTY

MR_EFFECTIVITY_DTLS

DWR_MR_EFCTVTY_DTLS

MR_INTERVALS

DWB_MR_INTRVL

MRO RESOURCE

DWR_MRO_RESRE

MTL_MANUFACTURERS

DWR_MTL_MNFCTR

NATIONALITY

DWL_NTNLTY

NON ROUTINE

DWB_NON_RUTNE

ODT ACCOUNT

DWR_ODT_ACCT

OPERATION

DWB_OPRN

OPERATION MATERIAL

DWB_OPRN_MTRL

OPERATION_RESOURCES

DWB_OPRN_RESRE

OPTION

DWR_OPTN

ORGANIZATION

DWR_ORG

ORGANIZATION AREA

DWR_ORG_AREA

ORGANIZATION BANNER

DWR_ORG_BNR

ORGANIZATION BUSINESS ENTITY

DWR_ORG_BSNS_ENT

ORGANIZATION BUSINESS UNIT

DWR_ORG_BSNS_UNIT

ORGANIZATION BUSINESS UNIT TYPE

DWL_ORG_BSNS_UNIT_TYP

ORGANIZATION CHAIN

DWR_ORG_CHAIN

ORGANIZATION COMPANY

DWR_ORG_CMPNY

ORGANIZATION CORPORATE

DWR_ORG_CRPRT

ORGANIZATION DISTRICT

DWR_ORG_DSTRCT

ORGANIZATION HIERARCHY

DWR_ORG_HRCHY

ORGANIZATION HIERARCHY LEVEL

DWR_ORG_HRCHY_LVL

ORGANIZATION HIERARCHY LEVEL ASSIGNMENT

DWR_ORG_HRCHY_LVL_ASGN

ORGANIZATION HIERARCHY VERSION

DWR_ORG_HRCHY_VRSN

ORGANIZATION LEVEL

DWR_ORG_LVL

ORGANIZATION LEVEL ATTRIBUTES

DWR_ORG_LVL_ATRIB

ORGANIZATION LEVEL ATTRIBUTES VALUE

DWR_ORG_LVL_ATRIB_VAL

ORGANIZATION MARKET DATA

DWR_ORG_MKT_DATA

ORGANIZATION NAME

DWR_ORG_NAME

ORGANIZATION REGION

DWR_ORG_RGN

ORGANIZATION SERVICE WEBSITE

DWR_ORG_SRVC_WBSITE

ORGANIZATION WAREHOUSE

DWR_ORG_WRHS

ORGANIZATIONAL DEMOGRAPHY VALUE

DWR_ORGNTL_DEMOG_VAL

OTHER INDIVIDUAL

DWR_OTHR_INDVL

OUTSIDE PROCESSING ORDER

DWB_OUTSD_PRCSNG_ORDR

PART

DWB_PART

PART CHANGE

DWB_PART_CHNG

PART LOCATIONS

DWR_PART_LOC

PART SERIAL NUMBER

DWB_PART_SRL_NBR

PARTNER EARNING

DWB_PRTNR_ERNG

PARTNER PROMOTION PROGRAM

DWR_PRTNR_PRMTN_PROG

PARTY

DWR_PRTY

PARTY ACCOUNT ASSIGNMENT

DWR_PRTY_ACCT_ASGN

PARTY ADDRESS LOCATION ASSIGNMENT

DWR_PRTY_ADDR_LOC_ASGN

PARTY ASSIGNMENT

DWR_PRTY_ASGN

PARTY CONTACT INFORMATION

DWR_PRTY_CNCT_INFO

PARTY CONTACT INFORMATION TYPE

DWL_PRTY_CNCT_INFO_TYP

PARTY CONTACT LIST PARTICIPATION

DWR_PRTY_CNCT_LST_PRTCPTN

PARTY COST ASSIGNMENT

DWB_PRTY_CST_ASGN

PARTY DEMOGRAPHIC

DWR_PRTY_DEMOG

PARTY DEMOGRAPHY VALUE

DWR_PRTY_DEMOG_VAL

PARTY GEOGRAPHY ENTITY ASSIGNMENT

DWR_PRTY_GEO_ENT_ASGN

PARTY IDENTIFICATION

DWR_PRTY_ID

PARTY IDENTIFICATION TYPE

DWL_PRTY_ID_TYP

PARTY INTERACTION

DWB_PRTY_INTRACN

PARTY INTERACTION CALL

DWB_PRTY_INTRACN_CALL

PARTY INTERACTION EMAIL

DWB_PRTY_INTRACN_EML

PARTY INTERACTION FAX

DWB_PRTY_INTRACN_FAX

PARTY INTERACTION ITEM

DWB_PRTY_INTRACN_ITEM

PARTY INTERACTION ITEM STATUS

DWR_PRTY_INTRACN_STAT

PARTY INTERACTION LETTER

DWB_PRTY_INTRACN_LTTR

PARTY INTERACTION SMS

DWB_PRTY_INTRACN_SMS

PARTY INTERACTION THREAD

DWB_PRTY_INTRACN_THRD

PARTY INTERACTION VISIT

DWB_PRTY_INTRACN_VST

PARTY LANGUAGE CAPABILITY

DWR_PRTY_LANG_CAPBLTY

PARTY NAME

DWR_PRTY_NAME

PARTY ORDER ASSIGNMENT

DWB_PRTY_ORDR_ASGN

PARTY PROMOTION RESPONSE

DWB_PRTY_PRMTN_RESPN

PARTY ROLE

DWR_PRTY_RL

PARTY ROLE ASSIGNMENT

DWR_PRTY_RL_ASGN

PARTY SKILL

DWR_PRTY_SKILL

PARTY STATUS

DWR_PRTY_STAT

PARTY STATUS

DWR_PRTY_STAT_DIM

PARTY STATUS CHANGE REASON

DWL_PRTY_STAT_CHNG_RSN

PARTY STATUS HISTORY

DWB_PRTY_STAT_HIST

PARTY STATUS TYPE

DWL_PRTY_STAT_TYP

PARTY TYPE

DWL_PRTY_TYP

PASSENGER CONTACT

DWR_PAX_CNCT

PASSENGER COUNTRY ADDRESS INFORMATION

DWB_PAX_CNTRY_ADDR_INFO

PASSENGER VISA INFORMATION

DWB_PAX_VISA_INFO

PASSPORT

DWR_PASPRT

PAX COUPON DATA

DWR_PAX_CPN_DATA

PAX INVOICE HEADER

DWR_PAX_INVC_HDR

PAX TRANSFER

DWB_PAX_TRNSFR

PDI CHANNEL

DWB_PDH_H

PDI CHANNEL

DWR_PDI_CHNL

PDI CHANNEL

DWR_PDI_CHNL_DIM

PDI CHARACTERISTIC

DWR_PDI_CHR

PHASE

DWR_PHS

PLANNING QUARTER

DWR_PLNG_QTR

PLANNING SEASON

DWR_PLNG_SEASON

PLANNING WEEK

DWR_PLNG_WK

PLANNING YEAR

DWR_PLNG_YR

PNR

DWR_PNR

PNR

DWR_PNR_DIM

PNR GDS INFO

DWB_PNR_GDS_INFO

PNR PARENT CHILD RELATIONSHIP

DWB_PNR_PRNT_CHILD_RLTN

PNR RELATIONSHIP

DWB_PNR_RLTN

PNR TYPE

DWR_PNR_TYP

POS DEPARTMENT

DWR_POS_DEPT

POS IDENTITY

DWR_POS_ID

POSTCODE

DWR_POSTCD

PREFERENCE TYPE

DWR_PREF_TYP

PRICE DERIVATION RULE

DWR_PRC_DRVTN_RULE

PRICE MODIFICATION LINE ITEM

DWB_PRC_MDFCTN_LN_ITEM

PRODUCT ENTITY

DWR_PROD_ENT

PRODUCT OFFERING

DWR_PROD_OFRNG

PROFILE SOURCE

DWR_PRFL_SRC

PROJECT

DWB_PROJ

PROJECTS_ALL

DWB_PROJ_ALL

PROMOTION

DWR_PRMTN

PROMOTION CLUSTER USAGE

DWB_PRMTN_CLSTR_USG

PROMOTION ITEM

DWR_PRMTN_ITEM

PROMOTION MANAGEMENT HISTORY

DWB_PRMTN_MGMT_HIST

PROMOTION MESSAGE RENDERING

DWR_PRMTN_MSG_RNDRNG

PROMOTION PRODUCT OFFERING ASSIGNMENT

DWR_PRMTN_PROD_OFRNG_ASGN

PROMOTION SELLING ITEM

DWR_PRMTN_SLNG_ITEM

PROMOTION TYPE

DWL_PRMTN_TYP

PROSPECT

DWR_PRSPCT

PROSPECT INDIVIDUAL

DWR_PRSPCT_INDVL

PROSPECT ORGANIZATION

DWR_PRSPCT_ORG

PURCHASE ORDER

DWB_PCHSE_ORDR

PURCHASE ORDER LINE ITEM

TBS

QUALITY PLANS

DWR_QLTY_PLN

QUALITY RESULTS

DWB_QLTY_RSLT

QUARTER TO DATE TRANSFORMATION

DWR_QTR_TODATE_TRANS

QUARTER TRANSFORMATION

DWR_QTR_TRANS

RECTAFICATION INTERVAL

DWL_RCTFCATN_INTRVL

RECTIFICATION INTERVAL EXTENSION

TBS

RELIGION

DWR_RLGN

REPAIR_CATEGORIES

DWR_RPR_CTGRS

RETAIL SALE RETURN LINE ITEM

DWB_RTL_SL_RETRN_LN_ITEM

RETAIL SEASON

DWR_RTL_SEASON

RETAIL STORE

DWR_RTL_STORE

RETAIL TRANSACTION

DWB_RTL_TRX

RETAIL TRANSACTION LINE ITEM

DWB_RTL_TRX_LN_ITEM

REVENUE COST ELEMENT

DWL_RVN_CST_ELMNT

REVENUE COST ELEMENT CATEGORY

DWL_RVN_CST_ELMNT_CTGRY

REVENUE COST ELEMENT GROUP

DWL_RVN_CST_ELMNT_GRP

REVENUE COST TRANSACTION

DWB_RTL_CST_TRX

ROLES HIERARCHY

DWR_RL_HRCHY

ROUTEPAIRS

DWR_ROUTEPAIRS

ROUTES

DWR_ROUTES

ROUTINE

DWB_RUTNE

SALE OR RETURN ACTION

DWR_SL_OR_RETRN_ACTN

SALES CHANNEL

DWR_SL_CHNL

SALES CHANNEL REPRESENTATIVE

DWR_SL_CHNL_RPRSTV

SALES FORECAST ITEM ORG HIERARCHY WEEK

DWR_SL_FRCST_ITEM_ORG_HRCHY_WK

SALES PLAN ITEM ORG HIERARCHY WEEK

DWR_SL_PLN_ITEM_ORG_HRCHY_WK

SALES RESTRICTION

DWR_SL_RSTRCT

SCRAP_VALUES

DWB_SCRP_VAL

SEASON

DWL_SEASON

SECOND

DWR_SCND

SEGMENT CRITERIA

DWR_SEG_CRTRA

SEGMENT DIM

DWR_SEG_DIM

SEGMENT PAIR DIM

TBS

SEGMENT SCHEDULE

DWB_SEG_SCHL

SELLING LOCATION

DWR_SLNG_LOC

SELLING LOCATION TYPE

DWL_SLNG_LOC_TYP

SERVICE

DWR_SRVC

SERVICE

DWR_SRVC_DIM

SERVICE COVERAGE AREA

DWR_SRVC_COVRG_AREA

SERVICE COVERAGE GEO DETAIL

DWR_SRVC_COVRG_GEO_DTL

Shop_Findings

DWB_SHOP_FNDNGS

SKILL TYPE

DWL_SKILL_TYP

SKU ITEM

DWR_SKU_ITEM

SOC JOB

DWR_SOC_JB

SOURCE SYSTEM

DWR_SRC_SYS

SOURCE SYSTEM KEY MAPPING

DWR_SRC_SYS_KEY_MAPNG

SSR

DWR_SSR

SUPPLIER

DWR_SUPLIR

SWOT TYPE

DWL_SWOT_TYP

TARGET ACCESS METHOD

DWR_TRGT_ACCS_MTHD

TARGET ACCOUNT

DWR_TRGT_ACCT

TARGET GEOGRAPHY AREA

DWR_TRGT_GEO_AREA

TARGET TYPE

DWL_TRGT_TYP

TASK ASSIGNMENT

DWR_TSK_ASGN

TASK EFFECTIVITIES

DWB_TSK_EFCTVTY

TASK LIST

DWB_TSK_LST

TAX LINE ITEM

DWB_TAX_LN_ITEM

TAXABLE GROUP

DWR_TAXBL_GRP

TERMINAL

DWR_TRML

TICKET

DWB_TCKT

TICKET COUPON

DWB_TCKT_CPN

TICKET DELIVERY ARRANGEMENT

DWB_TCKT_DLVRY_ARNGMNT

TICKET PRICE

DWB_TCKT_PRC

TICKET PRICING DISCOUNT

DWB_TCKT_PRCNG_DISC

TICKET PRICING DOCUMENT DETAILS

DWB_TCKT_PRCNG_DISC_DTLS

TICKETING FORM OF PAYMENT

DWB_TCKTNG_FORM_OF_PYMT

TIME DIM

DWR_TIME_DIM

TIME PERIOD

DWL_TIME_PRD

TIME STANDARD BY DAY

DWR_TIME_STNDRD_BY_DAY

TIME STANDARD BY WEEK

DWR_TIME_STNDRD_BY_WK

TIME TOTAL

DWR_TIME_TOT

TIME ZONE

DWR_TIME_ZN

TOUR

DWB_TOUR

TRACKED ITEM

DWB_TRCKD_ITEM

TRAFFIC CATEGORY

DWR_TRFC_CTGRY

TRAFFIC CATEGORY

DWR_TRFC_CTGRY_DIM

TRANSACTION TYPE

DWL_TRX_TYP

TRANSFER EARNING

DWB_TRNSFR_ERNG

TRAVEL CLASS

DWL_TRVL_CLS

TSM

DWB_TSM

TSM DOC

DWB_TSM_DOC

TSM EXCESS BAGGAGE

DWR_TSM_EXCSS_BAG

TSM MCO

DWR_TSM_MCO

TSM MCO FARES

DWB_TSM_MCO_FARES

TSM MCO TAX

DWB_TSM_MCO_TAX

TSM PASSENGER

DWR_TSM_PAX

TSM PAYMENT

DWB_TSM_PYMT

TSM PRICE

DWR_TSM_PRC

TSM RFI

DWB_TSM_RFI

TSM ROUTE

DWB_TSM_XSB_RT

TSM ROUTE

DWR_TSM_ROUTE

TSM SERVICE

DWR_TSM_SRVC

UNIT CONFIGURATION HEADER

DWR_UNIT_CNFGRTN_HDR

UNIT CONFIGURATION HISTORY

DWR_UNIT_CNFGRTN_HIST

UNIT MAINTENANCE PLAN

DWR_UNIT_MNTNCE_PLN

UNIT MAINTENANCE PLAN COUNTER HISTORY

DWR_UNIT_MNTNCE_PLN_CNTR_HIST

UNIT MAINTENANCE PLAN THRESHOLD RULE

DWR_UNT_MNTNC_PLN_THSLD_RLE

UNIT SCHEDULES

DWB_UNIT_SCHL

UNIT_ACCOMPLISHMNTS

DWR_UNIT_ACMPLSHMNTS

UNIT_DEFERRALS

DWR_UNIT_DFRLS

UNIT_EFFECTIVITIES

DWB_UNIT_EFCTVTS

USER

DWR_USER

VALUE TYPE

DWL_VAL_TYP

VEHICLE

DWR_VHCL

VIRTUAL TEAM

DWR_VRTL_TEAM

WARRANTY_ENTITLEMENTS

DWR_WRNTY_ENTLMNTS

WEATHER

DWB_WEATHR

WEEK TODATE TRANSFORMATION

DWR_WK_TODATE_TRANS

WEEK TRANSFORMATION

DWR_WK_TRANS

WEEKDAY

DWR_WKDAY

WORK ORDER

DWB_WO

WORK ORDER OPERATION

DWR_WO_OPRN

Extra

DWD_FLT_OPRNDWR_BSNS_MO_DIM
DWR_BSNS_TEN_DAYS_CYCL
DWR_CRPRT_BSNS_TYP
DWR_DAY_ACT_CNDTN
DWR_DAY_TODATE_TRANS
DWR_DAY_TRANS
DWR_FLTSEG_INV_CBNBKG_CLS
DWR_FLTSEG_INV_CBNBKG_SBC
DWR_MNTDWR_PRD_TODATE_TRANS
DWR_PRD_TRANS