Oracle® Communications Data Model Reference Release 11.3.1 Part Number E28440-03 |
|
|
PDF · Mobi · ePub |
This chapter provides a table listing the Oracle Communications 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".
This chapter includes the following section:
Overview of Mapping and Inheritance in Oracle Communications Data Model
Logical to Physical Mappings for Oracle Communications Data Model
The physical manifestation of the logical data model into database tables and relationships is not necessarily a pure 1:1 mapping from logical entities to physical tables. Physically, Oracle Communications Data Model is setup for best performance, and minimal data disk storage, leveraging the database options and consulting best practices wherever possible. The foundation layer follows the Third normal Form rule ("the key, only the key and nothing but the key") while the analytics layer is setup for optimal reporting performance. Partitions, Indexes, primary and foreign keys, constraints, and Materialized Views are used to map the logical model in the best possible way by default.
The complete Oracle Communications Data Model model is installed into two database schemas of the same database instance:
OCDM_SYS
: Schema includes most of Oracle Communications Data Model tables from the foundation and analytics layers, including the OLAP cubes.
OCDM_MINING
: Schema includes the mining models related objects like source tables, model building database packages, target tables and the specific views. This allows a third party mining tools to connect and interact with Oracle Communications Data Model when required, in a similar way that the Oracle Mining option would (with the difference that it would not necessarily be in-database mining).
Inheritance with Subtypes and SuperEntities
Some logical entities are sub-types of super-entities. Physically, there are different ways to realize this. For example, WIRELESS CALL EVENT
and FIXED LINE CALL
EVENT
are both sub-types of NETWORK EVENT
. To avoid data duplication, one could use either NETWORK EVENT
as a view of both tables or the sub-types could be a filtered view of the main table NETWORK EVENT
. In this concrete case, NETWORK EVENT
is not a view. It stays a purely abstract entity because there is usually no search on very different type of events at this level. So decision on how to materialize the logical entity is based on consulting experience.
Table 5-1 and Table 5-2 list the Oracle Communications 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 5-1 Entity Mapping Table: Logical to Physical Mapping A to N
Entity | Table or View |
---|---|
ACCESS METHOD |
|
ACCESS METHOD ACCOUNT ASSIGNMENT |
|
ACCESS METHOD ASSIGNMENT |
|
ACCESS METHOD ASSIGNMENT TYPE |
|
ACCESS METHOD ELEMENT |
|
ACCESS METHOD ELEMENT TYPE |
|
ACCESS METHOD EQUIPMENT ASSIGNMENT |
|
ACCESS METHOD GEOGRAPHY ASSIGNMENT |
|
ACCESS METHOD PARTY ASSIGNMENT |
|
ACCESS METHOD PARTY ASSIGNMENT TYPE |
|
ACCESS METHOD POOL |
|
ACCESS METHOD PORTING HISTORY |
|
ACCESS METHOD SEGMENT |
|
ACCESS METHOD SEGMENT PROD CAPABILITY RL |
|
ACCESS METHOD SERVICE ASSIGNMENT |
|
ACCESS METHOD STATUS HISTORY |
|
ACCESS METHOD STATUS REASON |
|
ACCESS METHOD STATUS TYPE |
|
ACCESS METHOD SUBSCRIPTION ASSIGNMENT |
|
ACCESS METHOD TYPE |
|
ACCESSORIES |
|
ACCOUNT |
|
ACCOUNT ACCOUNTING CYCLE HISTORY |
|
ACCOUNT ADJUSTMENT REASON |
|
ACCOUNT ASSIGNMENT |
|
ACCOUNT ASSIGNMENT REASON |
|
ACCOUNT ASSIGNMENT TYPE |
|
ACCOUNT BALANCE ADJUSTMENT |
|
ACCOUNT BALANCE ADJUSTMENT TYPE |
|
TBS |
|
ACCOUNT BALANCE GROUP |
|
ACCOUNT BALANCE HISTORY |
|
ACCOUNT BALANCE TYPE |
|
ACCOUNT BILLING CYCLE HISTORY |
|
ACCOUNT BILLING FREQUENCY HISTORY |
|
ACCOUNT BILLING OCCURRENCE |
|
ACCOUNT BILLING PERIOD HISTORY |
|
ACCOUNT BUSINESS INTERACTION ROLE |
|
ACCOUNT CONTRACT RELATIONSHIP |
|
ACCOUNT COST |
|
ACCOUNT CREDIT LIMIT |
|
ACCOUNT DEBT DAY DRVD |
|
ACCOUNT DEBT MONTH AGGR |
|
ACCOUNT DEBT WRITE OFF |
|
ACCOUNT EVENT TYPE |
|
ACCOUNT MANAGEMENT HISTORY |
|
ACCOUNT PARTY PMP RELATIONSHIP |
|
ACCOUNT PAYMENT |
|
ACCOUNT PAYMENT DAY DRVD |
|
ACCOUNT PAYMENT METHOD STATUS |
|
ACCOUNT PAYMENT METHOD STATUS HIST AGGR |
|
ACCOUNT PAYMENT METHOD STATUS HIST DRVD |
|
ACCOUNT PAYMENT METHOD STATUS REASON |
|
ACCOUNT PAYMENT METHOD STATUS TYPE |
|
ACCOUNT PAYMENT MONTH AGGR |
|
ACCOUNT PMP PARTICIPATION HISTORY |
|
ACCOUNT PREFERRED INVOICE DELIVERY |
|
ACCOUNT PREFERRED PAYMENT METHOD |
|
ACCOUNT PROFILE |
|
ACCOUNT RECHARGE |
|
ACCOUNT REFUND |
|
ACCOUNT REFUND DAY DRVD |
|
ACCOUNT REFUND MONTH AGGR |
|
ACCOUNT REFUND REASON |
|
ACCOUNT SEGMENT |
|
ACCOUNT SEGMENT ASSIGNMENT HISTORY |
|
ACCOUNT SEGMENTATION MODEL |
|
ACCOUNT STATISTIC DRVD |
|
ACCOUNT STATISTIC TYPE AGGR |
|
ACCOUNT STATUS DRVD |
|
ACCOUNT STATUS HISTORY |
|
ACCOUNT STATUS REASON |
|
ACCOUNT STATUS TYPE |
|
ACCOUNT STATUS TYPE AGGR |
|
ACCOUNT SUBSCRIPTION ASSIGNMENT |
|
ACCOUNT SUBSCRIPTION ASSIGNMENT REASON |
|
ACCOUNT TYPE |
|
ACCOUNTING CYCLE |
|
ACCOUNTING ITEM CATEGORY |
|
ADDITIONAL TEXT |
|
ADDRESS LOCATION |
|
ADDRESS LOCATION NAME |
|
ADDRESS RELATED |
|
ADDRESS RELATED REASON |
|
ADDRESS RELATED TYPE |
|
ADDRESS STATUS |
|
ADDRESS STATUS REASON |
|
ADDRESS TYPE |
|
ADVERTISING PERIOD |
|
ADVERTISING QUARTER |
|
ADVERTISING WEEK |
|
ADVERTISING YEAR |
|
AGE BAND |
|
AGE ON NET BAND |
|
AGGREGATION INTERFACE |
|
ALLOWANCE SBRP PRICE ALTERNATION |
|
AMERICAN PROPERTY ADDRESS |
|
ANZSIC CLASSIFICATION |
|
APPOINTMENT CALENDAR |
|
APPOINTMENT TYPE |
|
ARPU BAND |
|
ARPU BASE CUSTOMER TYPE AGGR |
|
ARPU BASE DRVD |
|
ASSET |
|
ASSET PARTY ASSOCIATION |
|
ATM INTERFACE |
|
AUTONOMOUS SYSTEM |
|
AUXILIARY COMPONENT |
|
AWARD LEVEL |
|
BANK |
|
BANK DIRECT DEBIT CHANNEL |
|
BARING REASON |
|
BASE DAY |
|
BASE STATION CONTROLLER |
|
BASE TRANSCEIVER STATION |
|
BER FER ERROR RATIO DAY DRVD |
|
BER FER ERROR RATIO MONTH AGGR |
|
BER FER TYPE |
|
BILLING CYCLE |
|
BILLING FREQUENCY |
|
BILLING OCCURRENCE TYPE |
|
BILLING PERIOD |
|
BILLING STATUS CATEGORY |
|
BILLING STATUS TYPE |
|
BLACK LIST HISTORY |
|
BRAND |
|
BRIDGING PROTOCOL |
|
BROADBAND RATING PLAN |
|
BROADBAND USAGE EVENT |
|
BUNDLED NETWORK EVENT |
|
BUSINESS HALF MONTH |
|
BUSINESS HALF YEAR |
|
BUSINESS INTERACTION |
|
BUSINESS INTERACTION ASSIGNMENT |
|
BUSINESS INTERACTION ASSIGNMENT TYPE |
|
BUSINESS INTERACTION ITEM |
|
BUSINESS INTERACTION ITEM PRICE |
|
BUSINESS INTERACTION LOCATION ASSIGNMENT |
|
BUSINESS INTERACTION TYPE |
|
BUSINESS INTERACTION VERSION |
|
BUSINESS LEGAL STATUS |
|
BUSINESS MONTH |
|
BUSINESS QUARTER |
|
BUSINESS UNIT COST |
|
BUSINESS UNIT JOB ROLE |
|
BUSINESS UNIT SHIFT |
|
BUSINESS WEEK |
|
BUSINESS YEAR |
|
CABLE |
|
CABLE MODEM |
|
CALENDAR HALF MONTH |
|
CALENDAR HALF YEAR |
|
CALENDAR MONTH |
|
CALENDAR QUARTER |
|
CALENDAR WEEK |
|
CALENDAR YEAR |
|
CALL CATEGORY |
|
CALL CENTER |
|
CALL CENTER AGENT |
|
CALL CENTER AGENT TYPE |
|
CALL CENTER CALL DAY DRVD |
|
CALL CENTER CALL MONTH AGGR |
|
CALL CENTER CASE DAY DRVD |
|
CALL CENTER CASE MONTH AGGR |
|
CALL CENTER CASE SUB TYPE |
|
CALL CENTER CASE TITLE |
|
CALL CENTER CASE TYPE |
|
CALL CENTER SERVICE CAPABILITY |
|
CALL DIRECTION |
|
CALL FORWARD |
|
CALL OTHER TYPE |
|
CALL RECYCLED REASON |
|
CALL ROUTING TYPE |
|
CALL SERVICE TYPE |
|
CALL SOURCE DESTINATION |
|
CALL SUCCESS FAILURE TYPE |
|
CALL SURCHARGE |
|
CALL TERMINATION REASON |
|
CALL TYPE |
|
CALLER ID |
|
CAMPAIGN |
|
CAMPAIGN CHANNEL |
|
CAMPAIGN CHANNEL ASSIGNMENT |
|
CAMPAIGN CHANNEL TYPE |
|
CAMPAIGN CHARACTERISTIC |
|
CAMPAIGN CHARACTERISTIC VALUE |
|
CAMPAIGN COST |
|
CAMPAIGN DOCUMENT |
|
CAMPAIGN MANAGEMENT HISTORY |
|
CAMPAIGN MESSAGE |
|
CAMPAIGN MESSAGE CREATIVE |
|
CAMPAIGN MESSAGE DEPICTION |
|
CAMPAIGN PURPOSE TYPE |
|
CAMPAIGN RELATIONSHIP |
|
CAMPAIGN STATUS |
|
CAMPAIGN TERM VALUE |
|
CAMPAIGN TYPE |
|
CANNIBALIZATION DETAIL DAY DRVD |
|
CANNIBALIZATION DETAIL MONTH AGGR |
|
CAPACITY |
|
CARD |
|
CARD RELATIONSHIP |
|
CELL |
|
CELL OUTAGE REASON |
|
CELL SECTOR |
|
CELL SITE |
|
CELL SITE COST |
|
CELL SITE TYPE |
|
CELL STATISTIC DAY DRVD |
|
CELL STATISTIC MONTH AGGR |
|
CELL TYPE |
|
CFS SPEC VERSION DETAIL |
|
CHANGE PROPOSED BY TYPE |
|
CHANNEL |
|
CHANNEL COST |
|
CHANNEL TYPE |
|
CHASSIS |
|
CHASSIS POSITION |
|
CHURN PREDICT SOURCE DERIVED |
|
CHURN REASON |
|
CIRCUIT CATEGORY |
|
CIRCUIT COMPONENT |
|
CIRCUIT RENTAL |
|
CIRCUIT RENTAL EVENT TYPE |
|
CIRCUIT TRAFFIC |
|
CIRCUIT TYPE |
|
COLLECTION |
|
COLLECTION AGENCY |
|
COMMISSION DAY DRVD |
|
COMMISSION MONTH AGGR |
|
COMMISSION TYPE |
|
COMMUNICATION SERVICE |
|
COMP INTEL CHARACTERISTIC |
|
COMP INTEL CHARACTERISTIC VALUE |
|
COMP INTEL MARKET SEGMENT |
|
COMP PROD CRRL CHARACTERISTIC |
|
COMP PROD CRRL CHARACTERISTIC ASSIGNMENT |
|
COMP PROD CRRL CHARACTERISTIC RELATIONSHIP |
|
COMP PROD CRRL CHARACTERISTIC VALUE |
|
COMPETITIVE TIER |
|
COMPETITOR |
|
COMPETITOR INTELLIGENCE |
|
COMPETITOR INTELLIGENCE PARTY ROLE |
|
COMPETITOR MARKET SEGMENT ASSIGNMENT |
|
COMPETITOR MARKET SEGMENT SWOT |
|
COMPETITOR PRODUCT CORRELATION |
|
COMPETITOR SWOT |
|
COMPETITOR TIER ASSIGNMENT |
|
COMPONENT SUBSCRIPTION PRICE |
|
COMPOSITE COMP PROD CRRL CHARACTERISTIC |
|
COMPOSITE PRODUCT RATING PLAN |
|
COMPOSITE PRODUCT RATING PLAN ASSIGNMENT |
|
COMPOSITE SERVICE |
|
COMPOSITE SERVICE INCLUSION |
|
COMPOSITE SERVICE TYPE INCLUSION |
|
COMPOSITE SUBSCRIPTION PRICE |
|
COMPOUND ELEMENT |
|
COMPOUND ELEMENT COLLECTION |
|
COMPOUND ELEMENT COMPOUND DETAIL |
|
COMPOUND ELEMENT DETAIL |
|
COMPOUND ELEMENT LOGICAL DETAIL |
|
COMPOUND ELEMENT PHYSICAL DETAIL |
|
COMPOUND ELEMENT ROLE |
|
COMPOUND ELEMENT ROLE ASSIGNMENT |
|
COMPOUND ELEMENT ROLE SPEC |
|
COMPOUND ELEMENT SPEC |
|
COMPOUND ELEMENT SPEC ATOMIC |
|
COMPOUND ELEMENT SPEC COMPOSITE |
|
COMPOUND ELEMENT TP DETAIL |
|
COMPOUND ELEMENT UNIT |
|
CONNECT DISCONNECT DAY DRVD |
|
CONNECT DISCONNECT MONTH AGGR |
|
CONNECTION |
|
CONNECTION TERMINATION POINT |
|
CONSEQUENCE PERFORMANCE NOTIFICATION |
|
CONSEQUENCE PERFORMANCE NOTIFICATION SPEC |
|
CONTACT LIST |
|
CONTACT LIST CHANGE REASON |
|
CONTACT LIST COST |
|
CONTACT LIST RECURRENCE TYPE |
|
CONTACT ROLES |
|
CONTENT |
|
CONTENT DELIVERY EVENT |
|
CONTENT PRICE |
|
CONTENT PRICING TYPE |
|
CONTENT PROVIDER |
|
CONTENT TYPE |
|
CONTRACT |
|
CONTRACT APPROVAL |
|
CONTRACT ASSIGNMENT |
|
CONTRACT ASSIGNMENT REASON |
|
CONTRACT ASSIGNMENT TYPE |
|
CONTRACT CHANGE INITIATOR TYPE |
|
CONTRACT CHANGE TYPE |
|
CONTRACT CHANGED DRVD |
|
CONTRACT DOCUMENT |
|
CONTRACT DRVD |
|
CONTRACT ITEM |
|
CONTRACT MONTH AGGR |
|
CONTRACT PRODUCT ASSIGNMENT |
|
CONTRACT STATUS |
|
CONTRACT STATUS REASON |
|
CONTRACT STATUS TYPE |
|
CONTRACT TERM TYPE |
|
CONTRACT TERM VALUE |
|
CONTRACT TYPE |
|
CORE INTERFACE |
|
COST |
|
COST CENTER |
|
COST CENTER BUDGET |
|
COST CUSTOMER DRVD |
|
COST CUSTOMER MONTH AGGR |
|
COST ORGANIZATIONAL DRVD |
|
COST ORGANIZATIONAL MONTH AGGR |
|
COST REASON |
|
COST SUBTYPE |
|
COST TYPE |
|
COURIER |
|
COURIER COST |
|
CPE LOGICAL DEVICE ROLE |
|
CREDIT CATEGORY |
|
CREDIT CATEGORY DRVD |
|
CREDIT CATEGORY MONTH AGGR |
|
CREDIT SCORE PROVIDER |
|
CURRENCY |
|
CURRENCY EXCHANGE RATE |
|
CURRENCY GEOGRAPHY ENTITY ASSIGNMENT |
|
CUSTOMER |
|
CUSTOMER ACQUISITION SUMMARY DAY DRVD |
|
CUSTOMER ACQUISITION SUMMARY MONTH AGGR |
|
CUSTOMER CLASS |
|
CUSTOMER CLASS ASSIGNMENT |
|
CUSTOMER COST |
|
CUSTOMER DEBT COLLECTION DRVD |
|
CUSTOMER DEBT COLLECTION MONTH AGGR |
|
CUSTOMER DOCUMENT |
|
CUSTOMER EQUIPMENT INSTALLATION DAY DRVD |
|
CUSTOMER EQUIPMENT INSTALLATION MO AGGR |
|
CUSTOMER FACING SERVICE |
|
CUSTOMER FACING SERVICE ROLE |
|
CUSTOMER FACING SERVICE SPEC |
|
CUSTOMER FACING SERVICE SPEC ATOMIC |
|
CUSTOMER FACING SERVICE SPEC COMPOSITE |
|
CUSTOMER FACING SERVICE SPEC ROLE |
|
CUSTOMER FACING SERVICE SPEC VERSION |
|
CUSTOMER FIELD INSTALLATION |
|
CUSTOMER FIELD SERVICE ACTIVITY |
|
CUSTOMER FIELD SERVICE DETAIL |
|
CUSTOMER FIELD SUPPORT |
|
CUSTOMER GROUP |
|
CUSTOMER GROUP ASSIGNMENT |
|
CUSTOMER INDIVIDUAL |
|
CUSTOMER OCCASION |
|
CUSTOMER OCCASION TYPE |
|
CUSTOMER ORDER |
|
CUSTOMER ORDER DOCUMENT |
|
CUSTOMER ORDER LINE ITEM |
|
CUSTOMER ORDER LINE ITEM STATE ASSIGN |
|
CUSTOMER ORDER PAYMENT |
|
CUSTOMER ORDER PRIORITY TYPE |
|
CUSTOMER ORDER STATE CHANGE REASON |
|
CUSTOMER ORDER STATE ASSIGNMENT |
|
CUSTOMER ORGANIZATION |
|
CUSTOMER RESTRICTED INFO |
|
CUSTOMER REVENUE BAND |
|
CUSTOMER REVENUE BAND ASSIGNMENT |
|
CUSTOMER REVENUE TYPE |
|
CUSTOMER SCORE |
|
CUSTOMER SEGMENT |
|
CUSTOMER SEGMENTATION MODEL |
|
CUSTOMER SIC ASSIGNMENT |
|
CUSTOMER SOURCE |
|
CUSTOMER TYPE |
|
DATA SERVICE EVENT |
|
DATA USAGE DAY DRVD |
|
DATA USAGE MONTH AGGR |
|
DAY |
|
DAY ACTUAL CONDITION |
|
DAY TODATE TRANSFORMATION |
|
DAY TRANSFORMATION |
|
DEAL |
|
DEALER |
|
DEALER DISCOUNT GROUP ASSIGNMENT |
|
DEBT AGING BAND |
|
DEBT COLLECTION |
|
DEBT COLLECTION ASSIGNMENT |
|
DEBT COLLECTION ASSIGNMENT BATCH |
|
DEMOGRAPHIC CHARACTERISTIC |
|
DEMOGRAPHIC CHARACTERISTIC VALUE |
|
DEMOGRAPHY ATTRIBUTE |
|
DEMOGRAPHY GROUP |
|
DERIVED VALUE |
|
DESTINATION TYPE |
|
DEVICE INTERFACE |
|
DEVICE INTERFACE DETAIL |
|
DEVICE INTERFACE PHYSICAL PORT ASSIGNMENT |
|
DEVICE INTERFACE ROLE |
|
DEVICE INTERFACE TP ASSIGNMENT |
|
DIRECT DEBIT STATUS REASON |
|
DISCOUNT GROUP |
|
DISCOUNT SBRP PRICE ALTERATION |
|
DISTANCE BAND |
|
DIVERT RETRIEVE REASON |
|
DIVERT RETRIEVE TYPE |
|
DOCUMENT CONDITION TYPE |
|
DOCUMENT TYPE |
|
DOCUMENT TYPE GROUP |
|
DOCUMENT TYPE GROUP ASSIGNMENT |
|
DSL MODEM |
|
EDGE INTERFACE |
|
EDUCATION |
|
ELEMENT CHARACTERISTIC |
|
ELEMENT CHARACTERISTIC ASSIGNMENT |
|
ELEMENT CHARACTERISTIC RELATIONSHIP |
|
ELEMENT CHARACTERISTIC VALUE |
|
ELEMENT CHARACTERISTIC VALUE ASSIGNMENT |
|
ELEMENT CHARACTERISTIC VALUE RELATIONSHIP |
|
EMPLOYEE |
|
EMPLOYEE ACTUAL LABOR HOURLY |
|
EMPLOYEE ACTUAL LABOR SALARIED |
|
EMPLOYEE COST |
|
EMPLOYEE DESIGNATION |
|
EMPLOYEE DISCOUNT GROUP ASSIGNMENT |
|
EMPLOYEE EXPENSE REPORT |
|
EMPLOYEE EXPENSE REPORT ITEM |
|
EMPLOYEE JOB ROLE ASSIGNMENT |
|
EMPLOYEE JOB ROLE TYPE |
|
EMPLOYEE LANGUAGE CAPABILITY |
|
EMPLOYEE RESTRICTED INFO |
|
EMPLOYEE SCHEDULE |
|
EMPLOYEE TRAINING RECORD |
|
EMPLOYEE TYPE |
|
ENTITY |
|
ENTITY ROLE |
|
ENTITY SPECIFICATION |
|
EQUIPMENT |
|
EQUIPMENT CENTER |
|
EQUIPMENT CENTER COST |
|
EQUIPMENT FUNCTIONALITY |
|
EQUIPMENT FUNCTIONALITY ASSIGNMENT |
|
EQUIPMENT HOLDER |
|
EQUIPMENT INSTANCE |
|
EQUIPMENT INSTANCE RENTING CONTRACT |
|
EQUIPMENT INSTANCE STATUS HISTORY |
|
EQUIPMENT INSTANCE STATUS TYPE |
|
EQUIPMENT SUBSCRIPTION |
|
EQUIPMENT TYPE |
|
ERRORED MEDIATED CALL EVENT |
|
ERRORED RATED WIRELESS CALL EVENT |
|
ERRORED RAW WIRELESS CALL EVENT |
|
EVENT |
|
EVENT ACCESS METHOD ACTIVITY |
|
EVENT ACCOUNT |
|
EVENT ASSIGNMENT |
|
EVENT ASSIGNMENT REASON |
|
EVENT ASSIGNMENT TYPE |
|
EVENT CATEGORY |
|
EVENT CIRCUIT RENTAL |
|
EVENT CLASS |
|
EVENT COST |
|
EVENT EMIT DETAIL |
|
EVENT EMPLOYEE PAYROLL |
|
EVENT EQUIPMENT INSTANCE |
|
EVENT FINANCIAL |
|
EVENT GEOGRAPHY |
|
EVENT GIFT REDEMPTION |
|
EVENT INVOICE DELIVERY |
|
EVENT LOCATION |
|
EVENT LOYALTY PROGRAM |
|
EVENT LOYALTY PROGRAM ACCUMULATION |
|
EVENT LOYALTY PROGRAM REDEMPTION |
|
EVENT PARTY ASSIGNMENT |
|
EVENT PARTY INTERACTION |
|
EVENT PARTY INTERACTION CALL |
|
EVENT PARTY INTERACTION EMAIL |
|
EVENT PARTY INTERACTION LETTER |
|
EVENT PARTY INTERACTION VISIT |
|
EVENT PARTY PROFILE |
|
EVENT PARTY ROLE |
|
EVENT PREPAID MOBILE |
|
EVENT PRODUCT PACKAGE |
|
EVENT REASON |
|
EVENT REASON CATEGORY |
|
EVENT RESOLUTION |
|
EVENT RESPONSE REASON |
|
EVENT RESULT |
|
EVENT SIM CARD |
|
EVENT STATUS |
|
EVENT STATUS REASON |
|
EVENT STATUS TYPE |
|
EVENT SUBSCRIPTION |
|
EVENT SUBSCRIPTION CHANGE |
|
EVENT TRIGGER DETAIL |
|
EVENT TYPE |
|
EVENT WEB REGISTRATION |
|
EVENT WEB VISIT |
|
EXCLUDE PORT DETAIL |
|
EXTERNAL CREDIT PROFILE |
|
EXTERNAL CREDIT PROFILE ASSIGNMENT |
|
EXTERNAL DEBT COLLECTION DAY DRVD |
|
EXTERNAL DEBT COLLECTION MONTH AGGR |
|
EXTERNAL INFORMATION SOURCE |
|
EXTERNAL OPERATOR |
|
EXTERNAL ORGANIZATION TYPE |
|
FACTOR COMPANY |
|
FAULT RESOLUTION TYPE |
|
FAULT TYPE |
|
FIELD ACTIVITY RESULT TYPE |
|
FIELD ACTIVITY TYPE |
|
FIREWALL ROLE |
|
FISCAL HALF MONTH |
|
FISCAL HALF YEAR |
|
FISCAL MONTH |
|
FISCAL QUARTER |
|
FISCAL WEEK |
|
FISCAL YEAR |
|
FIXED LINE CALL EVENT |
|
FIXED LINE PORT |
|
FIXED LINE RATING PLAN |
|
FLEXIBLE CHARACTERISTIC |
|
FLEXIBLE CHARACTERISTIC ASSIGNMENT |
|
FLEXIBLE CHARACTERISTIC ASSIGNMENT TYPE |
|
FLEXIBLE CHARACTERISTIC RELATIONSHIP |
|
FLEXIBLE CHARACTERISTIC TYPE |
|
FLEXIBLE CHARACTERISTIC VALUE |
|
FLEXIBLE CHARACTERISTIC VALUE ASSIGNMENT |
|
FLEXIBLE CHARACTERISTIC VALUE RELATIONSHIP |
|
FRAUD PROFILE CLASS |
|
GENDER |
|
GEOGRAPHY BUILDING |
|
GEOGRAPHY CITY |
|
GEOGRAPHY COUNTRY |
|
GEOGRAPHY COUNTY |
|
GEOGRAPHY DEMOGRAPHIC GROUP |
|
GEOGRAPHY DEMOGRAPHY ATTRIBUTE |
|
GEOGRAPHY DEMOGRAPHY VALUE |
|
GEOGRAPHY ENTITY |
|
GEOGRAPHY ENTITY ASSIGNMENT |
|
GEOGRAPHY ENTITY HIER LEVEL ASSIGNMENT |
|
GEOGRAPHY HIERARCHY |
|
GEOGRAPHY HIERARCHY LEVEL |
|
GEOGRAPHY HIERARCHY LEVEL ASSIGNMENT |
|
GEOGRAPHY LEVEL |
|
GEOGRAPHY LEVEL ATTRIBUTE |
|
GEOGRAPHY LEVEL ATTRIBUTE VALUE |
|
GEOGRAPHY REGION |
|
GEOGRAPHY STATE |
|
GEOGRAPHY STREET |
|
GEOGRAPHY SUB REGION |
|
GEOGRAPHY WORLD |
|
GIVE AWAY ITEM DAY DRVD |
|
GIVE AWAY ITEM MONTH AGGR |
|
GIVE AWAY TYPE |
|
GL REFERENCE |
|
GPRS PCU DAY DRVD |
|
GPRS PCU MONTH AGGR |
|
GPRS SERVICE |
|
GPRS SERVICES DAY DRVD |
|
GPRS SERVICES MONTH AGGR |
|
HALF HOUR |
|
HALF MONTH TODATE TRANSFORMATION |
|
HALF MONTH TRANSFORMATION |
|
HALF YEAR TODATE TRANSFORMATION |
|
HALF YEAR TRANSFORMATION |
|
HANDSET INSTANCE |
|
HANDSET MODEL |
|
HANDSET STOCK DAY DRVD |
|
HANDSET STOCK MO AGGR |
|
HANDSET SUBSIDY DAY DRVD |
|
HANDSET SUBSIDY MONTH AGGR |
|
HARDWARE |
|
HOLDER ATOMIC |
|
HOLDER COMPOSITE |
|
HOUR |
|
HOUSEHOLD |
|
IDD |
|
IDD CALL EVENT |
|
IN PLATFORM DAY DRVD |
|
IN PLATFORM MONTH AGGR |
|
INDIVIDUAL DEMOGRAPHY PROFILE |
|
INDIVIDUAL DEMOGRAPHY VALUE |
|
INDIVIDUAL NAME |
|
INITIATIVE RESULT TYPE |
|
INITIATIVE TYPE |
|
INTERACTION ANSWER CHOICE |
|
INTERACTION CHANNEL |
|
INTERACTION DIRECTION |
|
INTERACTION QUESTION RESPONSE |
|
INTERACTION REASON |
|
INTERACTION RESULT TYPE |
|
INTERACTION STATUS |
|
INTERACTION TYPE |
|
INTERNAL DEBT COLLECTION DAY DRVD |
|
INTERNAL DEBT COLLECTION MONTH AGGR |
|
INTERNET ACCESS EVENT |
|
INVOICE |
|
INVOICE ADJUSTMENT |
|
INVOICE ADJUSTMENT DRVD |
|
INVOICE ADJUSTMENT MONTH AGGR |
|
INVOICE ADJUSTMENT QUOTA |
|
INVOICE ADJUSTMENT REASON |
|
INVOICE ADJUSTMENT TYPE |
|
INVOICE CUSTOMER TYPE AGGR |
|
INVOICE DELIVERY FORMAT |
|
INVOICE DELIVERY TYPE |
|
INVOICE DISCOUNT |
|
INVOICE DISCOUNT REASON |
|
INVOICE DISCOUNT TYPE |
|
INVOICE DRVD |
|
INVOICE ITEM |
|
INVOICE ITEM DETAIL |
|
INVOICE ITEM DETAIL TYPE |
|
INVOICE ITEM RELATIONSHIP |
|
INVOICE ITEM TYPE |
|
INVOICE PAYMENT ASSIGNMENT |
|
INVOICE PAYMENT TERM TYPE |
|
INVOICE TAX ITEM |
|
INVOICE TYPE |
|
IP ADDRESS |
|
IP ADDRESS POOL |
|
IP SUBNET |
|
IPV4 ADDRESS |
|
ISP |
|
ISP BUSINESS |
|
ISP BUSINESS ASSIGNMENT |
|
ISP BUSINESS TYPE |
|
ISP TYPE |
|
ISP USAGE EVENT |
|
ISP USER |
|
ITEM |
|
ITEM TYPE |
|
JOB |
|
JOB ROLE |
|
KEY PERFORMANCE INDICATOR SLS PARM |
|
KEY QUALITY INDICATOR SLS PARM |
|
LAN |
|
LAN PROTOCOL |
|
LANGUAGE |
|
LANGUAGE DIALECT |
|
LAYER NETWORK |
|
LEGAL PROCESS STATUS TYPE |
|
LETTER TYPE |
|
LINE ACTIVATION TERMINATION DAY DRVD |
|
LINE ACTIVATION TERMINATION MONTH AGGR |
|
LOCAL ADDRESS LOCATION |
|
LOGICAL CAPACITY |
|
LOGICAL DEVICE |
|
LOGICAL DEVICE ATOMIC |
|
LOGICAL DEVICE COMPOSITE |
|
LOGICAL DEVICE OS ASSIGNMENT |
|
LOGICAL DEVICE ROLE |
|
LOGICAL DEVICE ROLE SPEC |
|
LOGICAL ELEMENT |
|
LOGICAL ELEMENT PHYSICAL SUPPORT |
|
LOGICAL ELEMENT ROLE |
|
LOGICAL ELEMENT ROLE ASSIGNMENT |
|
LOGICAL ELEMENT ROLE SPEC |
|
LOGICAL ELEMENT SPEC |
|
LOGICAL ELEMENT SPEC ATOMIC |
|
LOGICAL ELEMENT SPEC COMPOSITE |
|
LOGICAL ELEMENT SPEC PHYSICAL SUPPORT |
|
LOGICAL ELEMENT TYPE VERSION |
|
LOGICAL INTERFACE |
|
LOOKUP |
|
LOYALTY PROGRAM |
|
LOYALTY PROGRAM CHANNEL |
|
LOYALTY PROGRAM DAY DRVD |
|
LOYALTY PROGRAM EVENT CATEGORY |
|
LOYALTY PROGRAM EVENT TYPE |
|
LOYALTY PROGRAM MO AGGR |
|
LOYALTY PROGRAM PARTY ROLE |
|
LOYALTY PROGRAM POINTS BALANCE |
|
LOYALTY PROGRAM TERMINATION REASON |
|
MAILBOX |
|
MANAGE ACTION TYPE |
|
MANAGED ENTITY |
|
MANAGED HARDWARE |
|
MANAGED TRANSMISSION ENTITY |
|
MANAGEMENT DOMAIN |
|
MANAGEMENT PROTOCOL |
|
MARITAL STATUS |
|
MARKET AREA |
|
MARKET AREA LEVEL |
|
MARKET OPERATOR PORTING DERIVED |
|
MARKET PLAN DOCUMENT REQUIREMENT |
|
MARKET PLAN MANAGEMENT |
|
MARKET PLAN SUBSTITUTE BY DOC |
|
MARKET PLAN TERM VALUE |
|
MARKET SEGMENT |
|
MARKET SEGMENT CHARACTERISTIC |
|
MARKET SEGMENT CHARACTERISTIC VALUE |
|
MARKET SEGMENT INCLUSION |
No physical table is associated with this entity. |
MARKET SHARE MONTH AGGR |
|
MARKET SHARE MONTH DRVD |
|
MARKET STATISTICS |
|
MARKET STATISITC INCLUSION |
No physical table is associated with this entity. |
MEDIA INTERFACE |
|
MEDIA OBJECT |
|
MEDIA OBJECT ASSIGNMENT |
|
MEDIA OBJECT COST |
|
MEDIA OBJECT TYPE |
|
MEDIATED CALL EVENT |
|
MEDIATION STATUS CATEGORY |
|
MEDIATION STATUS REASON |
|
MEDIATION STATUS TYPE |
|
MINUTE |
|
MINUTE ALLOWANCE |
|
MMS EVENT |
|
MOBILE SWITCHING CENTER |
|
MODEL TYPE |
|
MONTH TODATE TRANSFORMATION |
|
MONTH TRANSFORMATION |
|
MSC TRAFFIC DAY DRVD |
|
MSC TRAFFIC MONTH AGGR |
|
MUSIC DOWNLOAD |
|
NAICS CLASSIFICATION |
|
NAICS INDUSTRY |
|
NAICS INDUSTRY GROUP |
|
NAICS INDUSTRY SECTOR |
|
NAICS INDUSTRY SUBSECTOR |
|
NATIONALITY |
|
NEGOTIATED SERVICE LEVEL SPEC |
|
NETWORK |
|
NETWORK ADDRESS |
|
NETWORK ADDRESS INTERFACE BINDING |
|
NETWORK ADDRESS TYPE |
|
NETWORK ASSIGNMENT |
|
NETWORK ASSIGNMENT TYPE |
|
NETWORK ATOMIC |
|
NETWORK AVAILABILITY DAY DRVD |
|
NETWORK AVAILABILITY MONTH AGGR |
|
NETWORK COMPOSITE |
|
NETWORK DOMAIN |
|
NETWORK ELEMENT |
|
NETWORK ELEMENT BUSINESS INTERACTION ROLE |
|
NETWORK ELEMENT CATEGORY |
|
NETWORK ELEMENT COST |
|
NETWORK ELEMENT FAULT ASSIGNMENT |
|
NETWORK ELEMENT PARTY ASSOCIATION |
|
NETWORK ELEMENT PARTY MANAGEMENT |
|
NETWORK ELEMENT RELATIONSHIP |
|
NETWORK ELEMENT RELATIONSHIP TYPE |
|
NETWORK ELEMENT ROLE |
|
NETWORK ELEMENT ROLE ASSIGNMENT |
|
NETWORK ELEMENT ROLE PARTY ASSIGNMENT |
|
NETWORK ELEMENT ROLE SPEC |
|
NETWORK ELEMENT STATE HISTORY |
|
NETWORK ELEMENT TYPE |
|
NETWORK ELEMENT TYPE VERSION |
|
NETWORK ELEMENT TYPE VERSION USAGE |
|
NETWORK ELEMENT USAGE EVENT TYPE |
|
NETWORK EVENT |
|
NETWORK EVENT ASSIGNMENT |
|
NETWORK EVENT CHARACTERISTIC |
|
NETWORK EVENT CHARACTERISTIC ASSIGNMENT |
|
NETWORK EVENT CHARACTERISTIC RELATIONSHIP |
|
NETWORK EVENT CHARACTERISTIC TYPE |
|
NETWORK EVENT CHARACTERISTIC VALUE |
|
NETWORK EVENT CHARACTERISTIC VALUE ASSIGNMENT |
|
NETWORK EVENT CHARACTERISTIC VALUE RELATIONSHIP |
|
NETWORK EVENT STATUS |
|
NETWORK EVENT TYPE |
|
NETWORK EVENT TYPE VERSION |
|
NETWORK FAULT |
|
NETWORK FAULT SUBSCRIPTION ASSIGNMENT |
|
NETWORK ROUTE |
|
NETWORK ROUTE POINT |
|
NETWORK ROUTE POINT ASSIGNMENT |
|
NETWORK SERVICE COVERAGE ASSIGNMENT |
|
NETWORK SITE |
|
NETWORK TOUCHPOINT |
|
NETWORK TOUCHPOINT CLASS |
|
NETWORK TOUCHPOINT DRVD |
|
NETWORK TOUCHPOINT MONTH AGGR |
|
NETWORK TOUCHPOINT STATUS |
|
NETWORK TOUCHPOINT TYPE |
|
NETWORK TYPE |
|
NOTIFICATION TYPE |
|
NP MOBILE MSISDN |
|
NP REQUEST HEADER |
|
NP REQUEST LINE ITEM |
|
NP REQUEST LINE ITEM STATE HISTORY |
|
NP REQUEST LINE ITEM STATE TYPE |
|
NP REQUEST STATE HISTORY |
|
NP REQUEST STATE TYPE |
|
NP REQUEST TYPE |
|
NP STEP |
|
NUMBER AREA |
|
NUMBER COUNTRY |
|
NUMBER NETWORK TYPE |
|
NUMBER PORT DAY DRVD |
|
NUMBER PORT MONTH AGGR |
|
Table 5-2 Entity Mapping Table: Logical to Physical Mapping P to Z
Entity | Table or View |
---|---|
ON OFF NET TYPE |
|
OPERATING SYSTEM |
|
OPERATOR GROUP |
|
OPERATOR TYPE |
|
ORDER LINE ITEM STATE |
|
ORDER STATE |
|
ORDER STATUS |
|
ORDER TYPE |
|
ORGANIZATION AREA |
|
ORGANIZATION BANNER |
|
ORGANIZATION BUSINESS ENTITY |
|
ORGANIZATION BUSINESS UNIT |
|
ORGANIZATION BUSINESS UNIT COST |
|
ORGANIZATION BUSINESS UNIT TYPE |
|
ORGANIZATION CHAIN |
|
ORGANIZATION COMPANY |
|
ORGANIZATION CORPORATE |
|
ORGANIZATION DISTRICT |
|
ORGANIZATION DIVISION |
|
ORGANIZATION HIERARCHY |
|
ORGANIZATION HIERARCHY LEVEL |
|
ORGANIZATION HIERARCHY LEVEL ASSIGNMENT |
|
ORGANIZATION HIERARCHY VERSION |
|
ORGANIZATION ITEM SELLING PRICE |
|
ORGANIZATION LEVEL |
|
ORGANIZATION LEVEL ATTRIBUTE VALUE |
|
ORGANIZATION LEVEL ATTRIBUTES |
|
ORGANIZATION MARKET DATA |
|
ORGANIZATION NAME |
|
ORGANIZATION REGION |
|
ORGANIZATION SERVICE WEBSITE |
|
ORGANIZATION WAREHOUSE |
|
ORGANIZATIONAL DEMOGRAPHY VALUE |
|
OS LICENSE ASSIGNMENT |
|
OTHER INDIVIDUAL |
|
PARTNER PAYMENT |
|
PARTNER PROMOTION PROGRAM |
|
PARTNER SETTLEMENT DRVD |
|
PARTNER SETTLEMENT MONTH AGGR |
|
PARTNER SETTLEMENT REASON |
|
PARTY |
|
PARTY ACCOUNT ASSIGNMENT |
|
PARTY ACCOUNT ASSIGNMENT TYPE |
|
PARTY ADDRESS LOCATION ASSIGNMENT |
|
PARTY AM PMP ASSIGNMENT HISTORY |
|
PARTY AM PMP ASSIGNMENT STATUS |
|
PARTY ASSIGNMENT |
|
PARTY ASSIGNMENT REASON |
|
PARTY ASSIGNMENT TYPE |
|
PARTY BUSINESS INTERACTION ROLE |
|
PARTY CONTACT INFORMATION |
|
PARTY CONTACT INFORMATION TYPE |
|
PARTY CONTACT LIST PARTICIPATION |
|
PARTY CONTACT LIST ROLE |
|
PARTY CONTRACT ASSIGNMENT |
|
PARTY CONTRACT ASSIGNMENT ROLE |
|
PARTY CONTRACT ASSIGNMENT TYPE |
|
PARTY COST ASSIGNMENT |
|
PARTY DEMOGRAPHIC |
|
PARTY DEMOGRAPHY VALUE |
|
PARTY EVENT TYPE |
|
PARTY GEOGRAPHY ENTITY ASSIGNMENT |
|
PARTY IDENTIFICATION |
|
PARTY IDENTIFICATION TYPE |
|
PARTY INTERACTION THREAD |
|
PARTY INTERACTION THREAD TYPE |
|
PARTY LANGUAGE CAPABILITY |
|
PARTY LOCATION REASON |
|
PARTY LOCATION TYPE |
|
PARTY LOYALTY PROGRAM PARTICIPATION |
|
PARTY MANAGEMENT ROLE |
|
PARTY MARKET SEGMENT ASSIGNMENT |
|
PARTY NAME |
|
PARTY ORDER ASSIGNMENT |
|
PARTY ORDER ASSIGNMENT TYPE |
|
PARTY PROFILE CHARACTERISTIC |
|
PARTY PROFILE CHARACTERISTIC VALUE |
|
PARTY PROMOTION RESPONSE |
|
PARTY ROLE |
|
PARTY ROLE ASSIGNMENT |
|
PARTY ROLE OS PROCESS ASSIGNMENT |
|
PARTY ROLE STATUS |
|
PARTY SEGMENTATION METHOD |
|
PARTY SERVICE ASSIGNMENT |
|
PARTY SERVICE ASSIGNMENT ROLE |
|
PARTY SERVICE ASSIGNMENT REASON |
|
PARTY SIM CARD ASSIGNMENT |
|
PARTY SIM CARD ROLE |
|
PARTY SKILL |
|
PARTY STATUS CATEGORY |
|
PARTY STATUS CHANGE REASON |
|
PARTY STATUS HISTORY |
|
PARTY STATUS TYPE |
|
PARTY SUBSCRIPTION ASSIGNMENT |
|
PARTY SUBSCRIPTION ROLE |
|
PARTY TYPE |
|
PASSPORT |
|
PAY CATEGORY |
|
PAY TYPE |
|
PAYMENT AGING CLASS |
|
PAYMENT AGING DAY DRVD |
|
PAYMENT AGING MONTH AGGR |
|
PAYMENT CHANNEL |
|
PAYMENT METHOD TYPE |
|
PAYMENT TRANSACTION TYPE |
|
PCU OUTAGE REASON |
|
PE LOGICAL DEVICE ROLE |
|
PEAK OFFPEAK TIME |
|
PERFORMANCE APPLICABILITY |
|
PERFORMANCE CAT CHARACTERISTIC VALUE |
|
PERFORMANCE CAT SPEC RELATIONSHIP |
|
PERFORMANCE CAT SPECIFICATION |
|
PERFORMANCE CATEGORY |
|
PERFORMANCE CATEGORY RELATIONSHIP |
|
PERFORMANCE CHARACTERISTIC VALUE |
|
PERFORMANCE INDICATOR DERIVATION PARAMETER |
No table generated for this entity. |
PERFORMANCE INDICATOR RELATIONSHIP |
|
PERFORMANCE INDICATOR SPEC RELATIONSHIP |
|
PERFORMANCE INDICATOR SPECIFICATION |
|
PERFORMANCE IP ADDRESS SPECIFICATION |
No table generated for this entity. |
PERFORMANCE NETWORK ADDRESS SPECIFICATION |
No table generated for this entity. |
PERFORMANCE NOTIFICATION SPECIFICATION |
|
PERFORMANCE OBJECTIVE |
|
PERFORMANCE OBJECTIVE APPLICABILITY |
|
PERFORMANCE OBJECTIVE APPLICABILITY CONSEQUENCE |
|
PERFORMANCE SPEC INTERVAL CONVERSION |
|
PERFORMANCE SPECIFICATION |
|
PERFORMANCE SPECIFICATION INTERVAL |
|
PERIOD TO DATE TRANSFORMATION |
|
PERIOD TRANSFORMATION |
|
PHYSICAL CAPACITY |
|
PHYSICAL CAPACITY DETAIL |
|
PHYSICAL COMPONENT |
|
PHYSICAL CONNECTOR |
|
PHYSICAL CONTAINER |
|
PHYSICAL DEVICE |
|
PHYSICAL DEVICE ATOMIC |
|
PHYSICAL DEVICE COMPOSITE |
|
PHYSICAL DEVICE ROLE SPEC |
|
PHYSICAL DEVICE ROLE SPEC DETAIL |
|
PHYSICAL DEVICE SPEC |
|
PHYSICAL ELEMENT |
|
PHYSICAL ELEMENT CHARACTERISTIC |
|
PHYSICAL ELEMENT ROLE |
|
PHYSICAL ELEMENT ROLE ASSIGNMENT |
|
PHYSICAL ELEMENT ROLE SPEC |
|
PHYSICAL ELEMENT SPEC |
|
PHYSICAL ELEMENT SPEC ATOMIC |
|
PHYSICAL ELEMENT SPEC COMPOSITE |
|
PHYSICAL EQUIPMENT |
|
PHYSICAL LINK |
|
PHYSICAL PORT |
|
PHYSICAL PORT RESOURCE PORT ASSIGNMENT |
|
PHYSICAL RESOURCE ROLE SPEC DETAIL |
|
PIPE |
|
PLANNING PERIOD |
|
PLANNING QUARTER |
|
PLANNING SEASON |
|
PLANNING WEEK |
|
PLANNING YEAR |
|
PMP AVAILABILITY |
|
PMP LOYALTY PROGRAM AVAILABILITY |
|
PMP MARKET SEGMENT AVAILABILITY |
|
PMP ORGANIZATION AVAILABILITY |
|
PMP PRICE POLICY ACTION |
|
PMP PRICE POLICY CONDITION |
|
PMP PRICE POLICY VALUE |
|
PMP PRICE POLICY VARIABLE |
|
PMP PRICE POLICY VARIABLE |
|
PMP RATING PLAN |
|
PMP RATING PLAN DETAIL |
|
POINT CODE |
|
POLICY |
|
POLICY ACTION |
|
POLICY ACTION ASSIGNMENT |
|
POLICY ACTION ATOMIC |
|
POLICY ACTION COMPOSITE |
|
POLICY ACTION RULE ASSIGNMENT |
|
POLICY ACTION VENDOR |
|
POLICY APPLICATION ASSIGNMENT |
|
POLICY CONDITION |
|
POLICY CONDITION ASSIGNMENT |
|
POLICY CONDITION ATOMIC |
|
POLICY CONDITION COMPOSITE |
|
POLICY CONDITION RULE ASSIGNMENT |
|
POLICY EVENT |
|
POLICY EVENT ATOMIC |
|
POLICY EVENT COMPOSITE |
|
POLICY GROUP |
|
POLICY GROUP EXECUTION DETAIL |
|
POLICY OPERATOR |
|
POLICY OPERATOR VARIABLE ASSIGNMENT |
|
POLICY ROLE |
|
POLICY RULE |
|
POLICY SET |
|
POLICY SET ASSIGNMENT |
|
POLICY STATEMENT |
|
POLICY VALUE |
|
POLICY VARIABLE |
|
POLICY VARIABLE VALUE ASSIGNMENT |
|
POSTAL SERVICE TYPE |
|
POSTCODE |
|
POSTPAID WIRELESS |
|
PPA CATEGORY |
|
PPA DEDUCTION TYPE |
|
PREPAID ACCOUNT STATISTIC DRVD |
|
PREPAID ACCOUNT STATISTIC SEGMENT AGGR |
|
PREPAID ALLOWANCE DAY DRVD |
|
PREPAID ALLOWANCE MONTH AGGR |
|
PREPAID CALL SUMMARY DAY DRVD |
|
PREPAID CALL SUMMARY MONTH AGGR |
|
PREPAID MOBILE EVENT TYPE |
|
PREPAID RECHARGE |
|
PREPAID VOUCHER |
|
PREPAID VOUCHER INSTANCE |
|
PREPAID WIRELESS |
|
PRICE DERIVATION RULE |
|
PRICE EVENT |
|
PRODUCT |
|
PRODUCT ADDITIONAL TEXT |
|
PRODUCT ASSIGNMENT |
|
PRODUCT ASSIGNMENT REASON |
|
PRODUCT CAPABILITY |
|
PRODUCT CAPABILITY TYPE |
|
PRODUCT CAPABILITY VALUE |
|
PRODUCT CATALOG |
|
PRODUCT CATALOG CHARACTERISTIC |
|
PRODUCT CATALOG CHARACTERISTIC ASSIGNMENT |
|
PRODUCT CATALOG CHARACTERISTIC RELATIONSHIP |
|
PRODUCT CATALOG CHARACTERISTIC VALUE |
|
PRODUCT CATALOG CHARACTERISTIC VALUE ASSIGNMENT |
|
PRODUCT CATALOG CHARACTERISTIC VALUE RELATIONSHIP |
|
PRODUCT CATALOG GEOGRAPHY ASSIGNMENT |
|
PRODUCT CATALOG MARKET PLAN ASSIGNMENT |
|
PRODUCT CATALOG PRESENTATION TYPE |
|
PRODUCT CATALOG SALES CHANNEL ASSIGNMENT |
|
PRODUCT CATALOG TYPE |
|
PRODUCT CATEGORY |
|
PRODUCT CHARACTERISTIC |
|
PRODUCT CHARACTERISTIC ASSIGNMENT |
|
PRODUCT CHARACTERISTIC RELATIONSHIP |
|
PRODUCT CHARACTERISTIC TYPE |
|
PRODUCT CHARACTERISTIC VALUE |
|
PRODUCT CHARACTERISTIC VALUE ASSIGNMENT |
|
PRODUCT CHARACTERISTIC VALUE RELATIONSHIP |
|
PRODUCT CHARGE TYPE |
|
PRODUCT CHARGE TYPE RELATIONSHIP |
|
PRODUCT CHARGE TYPE RLTN REASON |
|
PRODUCT CHARGING REASON |
|
PRODUCT COST |
|
PRODUCT COVERAGE AREA |
|
PRODUCT COVERAGE GEO DETAIL |
|
PRODUCT FEATURE |
|
PRODUCT FEATURE ASSIGNMENT |
|
PRODUCT FUNCTIONALITY DEPENDENCY |
|
PRODUCT GEOGRAPHY ASSIGNMENT |
|
PRODUCT GROUP |
|
PRODUCT GROUP ASSIGNMENT |
|
PRODUCT GROUP TYPE |
|
PRODUCT INSTANCE |
|
PRODUCT LINE |
|
PRODUCT MANAGEMENT HISTORY |
|
PRODUCT MANAGEMENT REASON |
|
PRODUCT MANAGEMENT ROLE |
|
PRODUCT MARKET PLAN |
|
PRODUCT MARKET PLAN ASSIGNMENT |
|
PRODUCT MARKET PLAN ASSIGNMENT TYPE |
|
PRODUCT MARKET PLAN COST |
|
PRODUCT MARKET PLAN GEOGRAPHY ASSIGNMENT |
|
PRODUCT MARKET PLAN GROUP |
|
PRODUCT MARKET PLAN GROUP ASSIGNMENT |
|
PRODUCT MARKET PLAN GROUP TYPE |
|
PRODUCT MARKET PLAN RELATIONSHIP |
|
PRODUCT MARKET PLAN RELATIONSHIP TYPE |
|
PRODUCT MARKET PLAN TYPE |
|
PRODUCT NETWORK ASSIGNMENT |
|
PRODUCT PACKAGE |
|
PRODUCT PACKAGE ASSIGNMENT |
|
PRODUCT PACKAGE CHARGE TYPE |
|
PRODUCT RATING PLAN |
|
PRODUCT RATING PLAN DETAIL |
|
PRODUCT RATING PLAN TYPE |
|
PRODUCT STATUS HISTORY |
|
PRODUCT STATUS TYPE |
|
PRODUCT TYPE |
|
PRODUCT USERNAME |
|
PRODUCT VERSION |
|
PROMOTION |
|
PROMOTION CLUSTER USAGE |
|
PROMOTION CONTACT LIST UTILIZATION |
|
PROMOTION COST |
|
PROMOTION MANAGEMENT HISTORY |
|
PROMOTION MARKET PLAN ASSIGNMENT |
|
PROMOTION MESSAGE RENDERING |
|
PROMOTION PRODUCT ASSIGNMENT |
|
PROMOTION PRODUCT CATALOG ASSIGNMENT |
|
PROMOTION RELATIONSHIP |
|
PROMOTION RESULT TYPE |
|
ROMOTION SALES CHANNEL ASSIGNMENT |
|
PROMOTION TERM TYPE |
|
PROMOTION TERM VALUE |
|
PROMOTION TYPE |
|
PROPERTY |
|
PROPERTY ADDRESS LOCATION ASSIGNMENT |
|
PROPOSAL |
|
PROPOSAL RELATIONSHIP |
|
PROSPECT |
|
PROSPECT INDIVIDUAL |
|
PROSPECT ORGANIZATION |
|
PROSPECT PRIORITY TYPE |
|
PROSPECT QUALITY SCORE TYPE |
|
PROSPECT QUALITY SCORE VALUE |
|
PROSPECT REJECT REASON |
|
PROTOCOL |
|
PTV FULL CHANNEL ACTIVATION |
|
PTV QPI SERVICE EVENT |
|
PTV USAGE EVENT |
|
PUBLICATION |
|
PUBLICATION TYPE |
|
PV BIT STRING VALUE |
|
PV BOOLEAN VALUE |
|
PV INTEGER VALUE |
|
PV IP ADDRESS VALUE |
|
PV STRING VALUE |
|
PVAR BIT STRING VARIABLE |
|
PVAR STRING VARIABLE |
|
QOS SERVICE |
|
QOS SERVICE SPEC TYPE |
No physical table is associated with this entity. |
QUARTER HOUR |
|
QUARTER TO DATE TRANSFORMATION |
|
QUARTER TRANSFORMATION |
|
RACK |
|
RATED NETWORK EVENT |
DWB_RTD_NTWK_EVT |
RATING METHOD TYPE |
|
RAW MMS EVENT |
|
RAW WIRELESS CALL EVENT |
DWB_RAW_WRLS_CALL_EVT |
RECHARGE REVENUE SLAB |
|
RECURRING PMP RATING PLAN DETAIL |
|
REDEMPTION DAY DRVD |
|
REDEMPTION MO AGGR |
|
REDEMPTION TYPE |
|
RESOURCE FACING SERVICE |
|
RESOURCE FACING SERVICE ROLE |
|
RESOURCE FACING SERVICE SPEC VERSION |
|
RESOURCE FACING SERVICE SPECROLE |
|
RESOURCE ORDER |
|
RESOURCE ORDER ITEM |
|
RESOURCE PERFORMANCE SPEC |
|
RESOURCE PORT |
|
RESOURCE SPEC PERF ROLE |
|
RETAIL STORE |
|
RF CARRIER |
|
RF NETWORK CAPACITY DAY DRVD |
|
RF NETWORK CAPACITY MONTH AGGR |
|
RFS SPEC VERSION DETAIL |
|
RINGTONE |
|
ROAMING TYPE |
|
ROLE |
|
ROLES HIERARCHY |
|
ROOT ENTITY |
|
ROUTED PROTOCOL |
|
ROUTER |
|
ROUTING DEVICE |
|
ROUTING PROTOCOL |
|
ROUTING ROLE |
|
SALES CAMPAIGN SUMMARY DAY DRVD |
|
SALES CAMPAIGN SUMMARY MONTH AGGR |
|
SALES CHANNEL |
|
SALES CHANNEL REPRESENTATIVE |
|
SALES COMMISSION DETAIL |
|
SALES COMMISSION PAYROLL |
|
SALES COMMISSION PLAN |
|
SALES COMMISSION PLAN DETAIL |
|
SALES DAY DRVD |
|
SALES MONTH AGGR |
|
SALES REPRESENTATIVE STATISTICS DRVD |
|
SCD2 MULTILANGUAGE |
No table generated. |
SCRIPT |
|
SCRIPT QUESTION |
|
SCRIPT QUESTION TYPE |
|
SEASON |
|
SECOND |
|
SECURE HOLDER |
|
SECURITY REQUIRED TYPE |
|
SEGMENT CRITERIA |
|
SEGMENT TYPE |
|
SELLING LOCATION |
|
SELLING LOCATION TYPE |
|
SERVICE |
|
SERVICE BUNDLE |
|
SERVICE BUNDLE SPEC |
|
SERVICE BUNDLE SPEC ATOMIC |
|
SERVICE BUNDLE SPEC COMPOSITE |
|
SERVICE BUSINESS ACTOR |
No table generated. |
SERVICE CHARACTERISTIC |
|
SERVICE CHARACTERISTIC ASSIGNMENT |
|
SERVICE CHARACTERISTIC RELATIONSHIP |
|
SERVICE CHARACTERISTIC VALUE |
|
SERVICE CHARACTERISTIC VALUE ASSIGNMENT |
|
SERVICE CHARACTERISTIC VALUE RELATIONSHIP |
|
SERVICE CLASS |
|
SERVICE CLASS TYPE |
|
SERVICE COVERAGE AREA |
|
SERVICE COVERAGE AREA TYPE |
|
SERVICE COVERAGE GEO DETAIL |
|
SERVICE DEPENDENCY |
|
SERVICE DEVICE INTERFACE ASSIGNMENT |
|
SERVICE EQUIPMENT ASSIGNMENT |
|
SERVICE LEVEL AGREEMENT |
|
SERVICE LEVEL AGREEMENT ITEM |
|
SERVICE LEVEL AGREEMENT TYPE |
|
SERVICE LEVEL OBJECTIVE |
|
SERVICE LEVEL SPECIFICATION |
|
SERVICE LEVEL SPEC APPLICABILITY |
|
SERVICE LEVEL SPEC CONSEQUENCE |
|
SERVICE LEVEL SPEC PARAMETER |
|
SERVICE LEVEL UNMET CONSEQUENCE TYPE |
|
SERVICE LR DEPENDENCY |
|
SERVICE NETWORK ELEMENT ASSIGNMENT |
|
SERVICE ORDER |
|
SERVICE ORDER LINE ITEM |
|
SERVICE PACKAGE |
|
SERVICE PACKAGE BUNDLE ASSIGNMENT |
No physical table is associated with this entity. |
SERVICE PACKAGE BUNDLE DETAIL |
|
SERVICE PACKAGE SPEC |
|
SERVICE PACKAGE SPEC ATOMIC |
|
SERVICE PACKAGE SPEC COMPOSITE |
|
SERVICE PERFORMANCE SPEC |
|
SERVICE PR DEPENDENCY |
|
SERVICE REQUEST |
|
SERVICE ROLE |
|
SERVICE SPEC |
|
SERVICE SPEC ATOMIC |
|
SERVICE SPEC COMPOSITE |
|
SERVICE SPEC NETWORK ELEMENT TYPE RELATIONSHIP |
|
SERVICE SPEC PRODUCT RELATIONSHIP |
|
SERVICE SPEC VERSION |
|
SERVICE SPECIFICATION ROLE |
|
SERVICE USAGE TYPE |
|
SET TOP BOX |
|
SET TOP BOX MODEL |
|
SHARED PACKAGE USAGE STATISTICS DAY DRVD |
|
SHARED PACKAGE USAGE STATISTICS MO AGGR |
|
SHELF |
|
SHOP EFFICIENCY DAY DRVD |
|
SHOP EFFICIENCY MONTH AGGR |
|
SIC ASSIGNMENT |
|
SIC ASSIGNMENT REASON |
|
SIC CLASSIFICATION |
|
SIC DIVISION |
|
SIC INDUSTRY GROUP |
|
SIGNALING PROTOCOL |
|
SIM CARD |
|
SIM CARD ACCESS METHOD ASSIGNMENT |
|
SIM CARD ACCESS METHOD REASON |
|
SIM CARD ACTIVATION REASON |
|
SIM CARD ACTIVATION TYPE |
|
SIM CARD HANDSET ASSIGNMENT |
|
SIM CARD SUBSCRIPTION ASSIGNMENT |
|
SIM CARD SUBSCRIPTION REASON |
|
SIM CARD TYPE |
|
SITE |
|
SITE INTERFACE ROLE |
|
SITE TYPE |
|
SKILL TYPE |
|
SLOT |
|
SLOT RELATIONSHIP |
|
SMS EVENT |
|
SMS RATING PLAN |
|
SOC JOB |
|
SOC JOB CATEGORY |
|
SOC JOB GROUP |
|
SOC JOB MAJOR GROUP |
|
SOFTWARE |
|
SOFTWARE ATOMIC |
|
SOFTWARE COMMAND |
|
SOFTWARE COMPOSITE |
|
SOFTWARE FEATURE SETS |
|
SOFTWARE OS RELATIONSHIP |
|
SOURCE SYSTEM |
|
SOURCE SYSTEM KEY MAPPING |
|
SOURCE SYSTEM TYPE |
|
SPECIFICATION |
|
SPECIFICATION ROLE |
|
SPECTRUM COVERAGE AREA |
|
STATISTICAL ENTITY |
|
SUB NETWORK |
|
SUBSCRIBER ACTIVATION REASON |
|
SUBSCRIPTION |
|
SUBSCRIPTION ASSIGNMENT |
|
SUBSCRIPTION ASSIGNMENT TYPE |
|
SUBSCRIPTION EVENT TYPE |
|
SUBSCRIPTION NETWORK ELEMENT ROLE ASSIGNMENT |
|
SUBSCRIPTION PMP ASSIGNMENT |
|
SUBSCRIPTION PRICE |
|
SUBSCRIPTION PRICE ALTERATION |
|
SUBSCRIPTION PRICE CHARGE |
|
SUBSCRIPTION PRICE PARTY ROLE ASSIGNMENT |
|
SUBSCRIPTION SERVICE CLASS ASSIGNMENT |
|
SUBSCRIPTION STATISTIC MONTH AGGR |
|
SUBSCRIPTION STATUS |
|
SUBSCRIPTION STATUS CATEGORY |
|
SUBSCRIPTION STATUS HISTORY |
|
SUBSCRIPTION STATUS REASON |
|
SUBSCRIPTION TERM TYPE |
|
SUBSCRIPTION TERM VALUE |
|
SUBSCRIPTION TYPE |
|
SUBSIDY AMOUNT DRVD |
|
SUBSIDY AMOUNT MONTH AGGR |
|
SUBSIDY TYPE |
|
SUPPLEMENTARY SERVICE |
|
SUPPLEMENTARY SERVICE USAGE MONTH AGGR |
|
SUPPLEMENTARY SERVICE USAGE MONTH DRVD |
|
SURVEY |
|
SWITCH |
|
SWITCH CAPABILITY |
|
SWITCH CAPABILITY TYPE |
|
SWITCH COMMAND |
|
SWITCH ROUTING DEVICE ASSIGNMENT |
|
SWITCH TYPE |
|
SWITCHING PROTOCOL |
|
SWITCHING ROLE |
|
SWOT TYPE |
|
TAP IN WIRELESS ROAMING EVENT |
|
TAP OUT WIRELESS ROAMING EVENT |
|
TARGET ACCESS METHOD |
|
TARGET ACCOUNT |
|
TARGET CONTRACT |
|
TARGET GEOGRAPHY AREA |
|
TARGET MARKET SEGMENT |
|
TARGET TYPE |
|
TAX AUTHORITY |
|
TAX CATEGORY |
|
TAX EXEMPT |
|
TCH TYPE |
|
TECHNOLOGY |
|
TECHNOLOGY TYPE |
|
TELEPHONE NUMBER |
DWR_PHONE_NBR |
TELEPHONE NUMBER POOL |
|
TEMPLATE SERVICE LEVEL SPEC |
|
TERMINATION POINT |
|
TIME BAND |
|
TIME SLOT |
|
TIME STANDARD BY DAY |
|
TIME STANDARD BY WEEK |
|
TIME ZONE |
|
TRAIL |
|
TRAIL TERMINATION POINT |
|
TV CHANNEL |
|
UMS ACCESS TYPE |
|
UMS EVENT |
|
UMS EVENT TYPE |
|
UNIT OF MEASURE |
|
URBAN PROPERTY ADDRESS |
|
USER |
|
VALUE ADDED SERVICE |
|
VALUE CUSTOM |
|
VALUE STANDARD |
|
VALUE TYPE |
|
VARIABLE CUSTOM |
|
VARIABLE STANDARD |
|
VAS SUBSCRIPTION |
|
VAS SUBSCRIPTION QUICK SUMMARY DRVD |
|
VAS SUBSCRIPTION QUICK SUMMARY MO AGGR |
|
VAS USAGE DAY DRVD |
|
VAS USAGE MONTH AGGR |
|
VENDOR |
|
VENDOR APPOINTMENT |
|
VENDOR CLASS |
|
VENDOR CONTRACT |
|
VENDOR FACTOR COMPANY ASSIGNMENT |
|
VENDOR RATING |
|
VENDOR RATING TYPE |
|
VENDOR SITE |
|
VENDOR SITE COURIER ASSIGNMENT |
|
VENDOR SITE TYPE |
|
VIRTUAL TEAM |
|
VOICE CALL DAY DRVD |
|
VOICE CALL MONTH AGGR |
|
VOICE MESSAGE SERVICE |
|
VOIP CALL EVENT |
|
VOLUME BAND |
|
VPN LOGICAL DEVICE ROLE |
|
WAN PROTOCOL |
|
WEATHER CONDITION |
|
WEB PAGE |
|
WEB PAGE CONTENT |
|
WEB PAGE TYPE |
|
WEEK TODATE TRANSFORMATION |
|
WEEK TRANSFORMATION |
|
WEEKDAY |
|
WIRELESS CALL EVENT |
|
WIRELESS CONTENT DOWNLOADING EVENT |
|
WIRELESS NETWORK ELEMENT |
|
WIRELESS RATING PLAN |
|
WIRELESS ROAMING EVENT |
|
WIRELESS ROAMING EVENT BATCH |
|
WIRELESS SPECTRUM |
|
YEAR TRANSFORMATION |
|