Skip Headers
Oracle® Communications Data Model Reference
11g Release 2 (11.2)

Part Number E15886-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

2 Logical Data Model Foundation

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.

This chapter includes the following sections:

Major Area Reference Entities

The following are the major area reference logical data model entities:

Account Simple Entity

Figure 2-1 shows the Account Simple entity. Table 2-1 lists the Account Simple entities.

Figure 2-1 Account Simple Entity Organization

Description of Figure 2-1 follows
Description of "Figure 2-1 Account Simple Entity Organization"

Table 2-1 Account Simple Reference Entity

Account Simple Entity List

ACCOUNT

ACCOUNT ASSIGNMENT

ACCOUNT ASSIGNMENT REASON

ACCOUNT PROFILE

ACCOUNT TYPE


Dealer Entity

Figure 2-3 shows the Dealer entity. Table 2-3 lists the Dealer entities.

Figure 2-3 Dealer Entity Organization

Description of Figure 2-3 follows
Description of "Figure 2-3 Dealer Entity Organization"

Organization Business Unit Entity

Figure 2-5 shows the Organization Business Unit entity. Table 2-5 lists the Organization Business Unit entities.

Figure 2-5 Organization Business Unit Entity Organization

Description of Figure 2-5 follows
Description of "Figure 2-5 Organization Business Unit Entity Organization"

Product Entity

Figure 2-8 shows the Product entity. Table 2-8 lists the Product entities.

Note:

Figure 2-8 is a simplified figure and does not show all of the entities listed in Table 2-8.

Figure 2-8 Product Entity Organization

Description of Figure 2-8 follows
Description of "Figure 2-8 Product Entity Organization"

Table 2-8 Product Reference Entity

Product Entity List

ACCESSORIES

ADDITIONAL TEXT

ADDRESS LOCATION

BROADBAND

BROADBAND RATING PLAN

CABLE MODEM

CALL FORWARD

CALLER ID

CONTENT

DISCOUNT GROUP

DOCUMENT CONDITION TYPE

DOCUMENT TYPE

DSL MODEM

EQUIPMENT

EQUIPMENT FUNCTIONALITY

EQUIPMENT FUNCTIONALITY ASSIGNMENT

EQUIPMENT INSTANCE

EQUIPMENT INSTANCE STATUS HISTORY

EQUIPMENT INSTANCE STATUS TYPE

FIXED LINE

FIXED LINE RATING PLAN

GPRS SERVICE

HANDSET INSTANCE

HANDSET MODEL

IDD

ITEM

LANGUAGE

MARKET PLAN SUBSTITUTE BY DOC

MARKET PLAN TERM VALUE

MUSIC DOWNLOAD

NETWORK TOUCHPOINT

ORGANIZATION ITEM SELLING PRICE

PARTY

PAY TV

POSTPAID WIRELESS

PREPAID WIRELESS

PRODUCT

PRODUCT ASSIGNMENT

PRODUCT ASSIGNMENT REASON

PRODUCT CAPABILITY

PRODUCT CAPABILITY TYPE

PRODUCT CAPABILITY VALUE

PRODUCT CHARGE TYPE

PRODUCT CHARGE TYPE RELATIONSHIP

PRODUCT CHARGE TYPE RLTN REASON

PRODUCT CHARGING REASON

PRODUCT FEATURE

PRODUCT FEATURE ASSIGNMENT

PRODUCT FUNCTIONALITY DEPENDENCY

PRODUCT GEOGRAPHY ASSIGNMENT

PRODUCT GROUP

PRODUCT GROUP ASSIGNMENT

PRODUCT GROUP TYPE

PRODUCT INSTANCE

PRODUCT MANAGEMENT HISTORY

PRODUCT MANAGEMENT REASON

PRODUCT MANAGEMENT ROLE

PRODUCT MARKET PLAN

PRODUCT MARKET PLAN ASSIGNMENT

PRODUCT MARKET PLAN ASSIGNMENT TYPE

PRODUCT MARKET PLAN GEOGRAPHY ASSIGNMENT

PRODUCT MARKET PLAN GROUP

PRODUCT MARKET PLAN GROUP ASSIGNMENT

PRODUCT MARKET PLAN GROUP 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 VERSION

RATING METHOD TYPE

RINGTONE

SERVICE

SET TOP BOX

SET TOP BOX MODEL

SIM CARD HANDSET ASSIGNMENT

SMS RATING PLAN

SUPPLEMENTARY SERVICE

TV CHANNEL

VALUE ADDED SERVICE

VOICE MESSAGE SERVICE

WIRELESS RATING PLAN


Service Entity

Figure 2-10 shows the Service entity. Table 2-10 lists the Service entities.

Figure 2-10 Service Entity Organization

Description of Figure 2-10 follows
Description of "Figure 2-10 Service Entity Organization"

Time Calendar Entity

Figure 2-12 shows the Time Calendar entity. Table 2-12 lists the Time Calendar entities.

Figure 2-12 Time Calendar Reference Entity Organization

Description of Figure 2-12 follows
Description of "Figure 2-12 Time Calendar Reference Entity Organization"

Table 2-12 Time Calendar Entity

Time Calendar Entity List

CALENDAR HALF MONTH

CALENDAR HALF YEAR

CALENDAR MONTH

CALENDAR QUARTER

CALENDAR WEEK

CALENDAR YEAR

DAY


Business Area Logical Entities

The following are the business area logical data model entities:

Product Management Business Area Logical Entity

Figure 2-20 shows the Product Management entity. Table 2-20 lists the Product Management entities.

Note:

Figure 2-20 is a simplified figure and does not show all of the entities listed in Table 2-20.

Figure 2-20 Product Management Area Organization

Description of Figure 2-20 follows
Description of "Figure 2-20 Product Management Area Organization"

Table 2-20 Product Management Business Area Logical Entity

Product Management Entity List

ACCESSORIES

ADDITIONAL TEXT

BROADBAND RATING PLAN

CALLER ID

CONTENT

DISCOUNT GROUP

DOCUMENT CONDITION TYPE

DOCUMENT TYPE

EQUIPMENT

EQUIPMENT FUNCTIONALITY

EQUIPMENT FUNCTIONALITY ASSIGNMENT

EQUIPMENT INSTANCE

EQUIPMENT INSTANCE STATUS HISTORY

EQUIPMENT INSTANCE STATUS TYPE

FIXED LINE RATING PLAN

HANDSET MODEL

ITEM

LANGUAGE

MARKET PLAN SUBSTITUTE BY DOC

MARKET PLAN TERM VALUE

NETWORK TOUCHPOINT

ORGANIZATION BUSINESS UNIT

ORGANIZATION WAREHOUSE

PARTY

PREPAID MOBILE VOUCHER

PRODUCT

PRODUCT ADDITIONAL TEXT

PRODUCT ASSIGNMENT

PRODUCT ASSIGNMENT REASON

PRODUCT CAPABILITY

PRODUCT CAPABILITY TYPE

PRODUCT CAPABILITY VALUE

PRODUCT CHARGE TYPE

PRODUCT CHARGE TYPE RELATIONSHIP

PRODUCT CHARGE TYPE RLTN REASON

PRODUCT CHARGING REASON

PRODUCT FEATURE

PRODUCT FEATURE ASSIGNMENT

PRODUCT FUNCTIONALITY DEPENDENCY

PRODUCT GEOGRAPHY ASSIGNMENT

PRODUCT GROUP

PRODUCT GROUP ASSIGNMENT

PRODUCT GROUP TYPE

PRODUCT INSTANCE

PRODUCT MANAGEMENT HISTORY

PRODUCT MANAGEMENT REASON

PRODUCT MANAGEMENT ROLE

PRODUCT MARKET PLAN

PRODUCT MARKET PLAN ASSIGNMENT

PRODUCT MARKET PLAN ASSIGNMENT TYPE

PRODUCT MARKET PLAN GEOGRAPHY ASSIGNMENT

PRODUCT MARKET PLAN GROUP

PRODUCT MARKET PLAN GROUP ASSIGNMENT

PRODUCT MARKET PLAN GROUP 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 VERSION

RATING METHOD TYPE

SERVICE

SET TOP BOX MODEL

SIM CARD HANDSET ASSIGNMENT

SMS RATING PLAN

SUPPLEMENTARY SERVICE

TV CHANNEL

VALUE ADDED SERVICE

WIRELESS RATING PLAN


Provisioning and Service Business Area Logical Entity

Figure 2-21 shows the Provisioning and Service entity. Table 2-21 lists the Provisioning and Service entities.

Note:

Figure 2-21 is a simplified figure and does not show all of the entities listed in Table 2-21.

Figure 2-21 Provisioning and Service Area Organization

Description of Figure 2-21 follows
Description of "Figure 2-21 Provisioning and Service Area Organization"

Logical Data Model Entity Dictionary

Table 2-23 through Table 2-29 list the logical data model entities, in alphabetically.

Table 2-23 A to C Entity Descriptions

Entity Name Type Description

ACCESS METHOD

Reference

Lookup for methods that a customer accesses or utilizes a service. For example:

  • Fixed Line telephone numbers

  • Wireless telephone numbers

  • xDSL account

  • IDD Calling card number

ACCESS METHOD ACCOUNT ASSIGNMENT

Reference

Assigns ACCESS METHODs to an account.

ACCESS METHOD ASSIGNMENT TYPE

Lookup

Type of relationship between two ACCESS METHODs. For example:

  • Replace

  • Bind together

ACCESS METHOD ASSIGNMENT

Reference

Assignment of an ACCESS METHOD to a related ACCESS METHOD.

ACCESS METHOD ELEMENT

Reference

The ACCESS METHOD may be split into multiple elements for better management. Each element is a segment in the ACCESS METHOD, which represents a group of access methods. For example, for the access method for a phone number, where access method elements are:

  • Country code

  • Area code

  • Local number

ACCESS METHOD ELEMENT TYPE

Lookup

Lookup for type of ACCESS METHOD ELEMENT. For example:

  • Country code of phone number

  • Area code of phone number

ACCESS METHOD EQUIPMENT ASSIGNMENT

Reference

How the access method binds to an equipment instance. For example:

  • Cell phone number binds onto a cell phone

  • Login code binds to a modem

ACCESS METHOD GEOGRAPHY ASSIGNMENT

Reference

Assigns the access method to a geographic region.

ACCESS METHOD PARTY ASSIGNMENT

Reference

Assigns access method to a party.

ACCESS METHOD PARTY ASSIGNMENT TYPE

Lookup

Lookup for type of relationship between ACCESS METHOD and PARTY. For example:

  • Management

  • Owned by

The management type of access method party relationship specifies that an employee may be responsible for the maintenance of a group of access methods.

ACCESS METHOD POOL

Reference

The logical network resources. For example:

  • Telephone number

  • IP address

ACCESS METHOD PORTING HISTORY

Base

The history of access methods that the customer brought to the operator from another telecom operator, according to the number porting scheme.

ACCESS METHOD SEGMENT

Reference

Segments of ACCESS METHODs defined for usage tracking. For example:

  • Phone number may have the segments: Country_Code + Area_Code + Local_Number

  • IP address may have the segments: Type A, B, C, D, E subnetwork

ACCESS METHOD SEGMENT PROD CAPABILITY RL

Reference

The relationship between ACCESS METHOD SEGMENT and PRODUCT CAPABILITY to define which product capabilities require which access method segment.

ACCESS METHOD STATUS HISTORY

Base

The status of an ACCESS METHOD. Defines both current status and historical status. For example:

  • Active

  • Suspended

  • Deactivated

ACCESS METHOD STATUS REASON

Lookup

Lookup for available reasons an ACCESS METHOD may have a change in status.

For example:

  • Customer relocation

  • Suspension due to late-payment

ACCESS METHOD STATUS TYPE

Lookup

Lookup for available ACCESS METHOD status types and descriptions. For example:

  • Active

  • Inactive

  • Suspended

  • Future Activated

ACCESS METHOD SUBSCRIPTION ASSIGNMENT

Reference

Assigns ACCESS METHOD(s) to a SUBSCRIPTION.

ACCESS METHOD TYPE

Lookup

Lookup for ACCESS METHOD type: Defines the types of methods by which a customer may use or access services or products. For example:

  • Fixed Line telephone numbers

  • Wireless telephone numbers

  • xDSL account

  • IDD Calling card number

ACCESSORIES

Reference

The accessories that may be purchased from the service provider in addition to the item, product, or service. For example:

  • Handset chains

  • Starter kit

  • Headset (earphones)

  • USB Cable

ACCOUNT

Reference

The account is generated by a contract between service provider and customer. For the service provider hosting different network, including CDMA, GSM, broadband, and others, one customer may have a different account for a different network or can be unified.

Once set up, a customer can use account for self service from the Web site or from a Service Provider terminal. In this case the account is normally protected by a password.

ACCOUNT ACCOUNTING CYCLE HISTORY

Base

Billing cycle status history for accounts.

ACCOUNT ADJUSTMENT REASON

Lookup

Lookup of all the reasons for adjustments. For example:

  • Goodwill

  • Agreement after complaint

ACCOUNT ASSIGNMENT

Reference

Relationship assignments between accounts. For example, parent and child accounts.

ACCOUNT ASSIGNMENT REASON

Lookup

Lookup for available reasons accounts may be related.

ACCOUNT BALANCE ADJUSTMENT

Base

Contains the list of all adjustments to any account balance. These are pure adjustments and not just additional payments or costs. An account balance adjustment is usually related to the party interaction thread.

ACCOUNT BALANCE ADJUSTMENT TYPE

Lookup

Lookup of all the types of adjustments. For example:

  • Free Monthly Fee

  • Free Service

  • Direct credit amount

ACCOUNT BALANCE HISTORY

Base

Balance history of account subjected to the primary currency. The balance value was classified by the balance type. For example:

  • Monetary value deposit

  • Free allowance minutes balance over wireless call

ACCOUNT BALANCE TYPE

Lookup

Type of account balance. For example:

  • Broadband

  • PTV

  • Wireless free call allowance

ACCOUNT BILLING CYCLE HISTORY

Reference

Billing cycle status history for accounts.

ACCOUNT BILLING FREQUENCY HISTORY

Reference

Billing frequency history for accounts.

ACCOUNT BILLING PERIOD HISTORY

Reference

Billing period history for accounts.

ACCOUNT CONTRACT RELATIONSHIP

Reference

Assignment of ACCOUNT to a CONTRACT.

ACCOUNT COST

Base

Subtype of COST, which associates a specific incurred cost to an ACCOUNT (through an EMPLOYEE).

ACCOUNT CREDIT LIMIT

Base

Credit limit assigned to an account, subscription, or contract.

ACCOUNT DEBT DAY DRVD

Derived

The summarized daily debt status for each account.

ACCOUNT DEBT MONTH AGGR

Aggregate

Derived from ACCOUNT DEBT DAY DRVD. The summarized monthly debt status for each CUSTOMER TYPE.

ACCOUNT DEBT WRITE OFF

Base

Lists the debt write-off activities on all accounts.

ACCOUNT EVENT TYPE

Lookup

Lookup for account event types.

ACCOUNT MANAGEMENT HISTORY

Base

Subtype of PARTY ACCOUNT ASSIGNMENT. The account management history tracks the management relationship from employee to the accounts, including account creation, through sales channel, and accounts update or termination.

ACCOUNT PARTY PMP RELATIONSHIP

Reference

Assigns accounts and parties to PRODUCT MARKET PLAN.

ACCOUNT PAYMENT

Base

Allocations of funds from a receipt made by a party to an account. The receipt of a single sum from a party as a credit against an outstanding balance for the provision and supply of products or services.

ACCOUNT PAYMENT DAY DRVD

Derived

Daily aggregation of payments made by all customers.

ACCOUNT PAYMENT METHOD STATUS

Base

Status history of each account preferred payment method. For example:

  • Active

  • Inactive

  • Invalid

ACCOUNT PAYMENT METHOD STATUS HIST AGGR

Aggregate

Collects all changes to the payment method status and the reason of the changes over time.

ACCOUNT PAYMENT METHOD STATUS HIST DRVD

Derived

Collects the changes on payment method status.

ACCOUNT PAYMENT METHOD STATUS REASON

Lookup

Lookup for specific status of the account payment method. For example:

  • Activated

  • Deactivated

  • Disabled

ACCOUNT PAYMENT METHOD STATUS TYPE

Lookup

Lookup for types of ACCOUNT PAYMENT METHOD STATUS. For example:

  • Active

  • Inactive

  • Payment Rejected

ACCOUNT PAYMENT MONTH AGGR

Aggregate

Monthly summary of payments made by all customers.

ACCOUNT PMP PARTICIPATION HISTORY

Base

Defines the history of how account uses the PRODUCT MARKET PLAN.

ACCOUNT PREFERRED INVOICE DELIVERY

Reference

The preferred invoice delivery type history for account.

ACCOUNT PREFERRED PAYMENT METHOD

Reference

Contains preferred payment methods for the account.

ACCOUNT PROFILE

Reference

Records more details about the account.

ACCOUNT REFUND

Base

The customer refund is the money transferred back to customer account, which is normally based on an invoice adjustment.

ACCOUNT REFUND DAY DRVD

Derived

The daily summary of refund to customers and the impacts to revenue.

ACCOUNT REFUND MONTH AGGR

Aggregate

The monthly summary of refunds to customers and the impacts to revenue.

ACCOUNT REFUND REASON

Lookup

Lookup for the reasons why a refund may occur. For example:

  • Invoice Adjustment

  • Tax Refund

ACCOUNT SEGMENT

Reference

The segments identifying distinct groupings of accounts with similar characteristics. The account segments are typically generated from the data mining analysis.

ACCOUNT SEGMENT ASSIGNMENT HISTORY

Reference

Assign account segment to each account.

ACCOUNT SEGMENTATION MODEL

Reference

Used to cluster the account.

ACCOUNT STATISTIC DRVD

Derived

Account statistics for each account. One account normally has multiple SUBSCRIPTIONs, and CONTRACTs, all values on which are summed into the account level. Any deleted or blocked accounts are also included and are deemed as Churned, regardless of whether the deletion or block was voluntary.

ACCOUNT STATISTIC TYPE AGGR

Aggregate

Account statistical information at higher level by CUSTOMER TYPE.

ACCOUNT STATUS DRVD

Derived

The status change information about all accounts at every month.

ACCOUNT STATUS HISTORY

Base

History of line status on the network. Any subscriber number actually is a line/connection on the switch or network. Each line goes through a variety of stages during its lifecycle on the switch.

ACCOUNT STATUS REASON

Lookup

Lookup for account status reasons, or possible reasons a given account status has been changed.

ACCOUNT STATUS TYPE

Lookup

Lookup for account status types.

ACCOUNT STATUS TYPE AGGR

Aggregate

Account statistical information at a higher level by customer type.

ACCOUNT SUBSCRIPTION ASSIGNMENT

Reference

History of subscriptions by an account.

ACCOUNT SUBSCRIPTION ASSIGNMENT REASON

Lookup

Each account to subscription relationship may have a reason associated with it. For example:

  • Warrant account

  • Payment account

ACCOUNT TYPE

Lookup

Lookup for account type. For example:

  • Prepaid

  • Postpaid

ACCOUNTING CYCLE

Lookup

Internal Billing cycle which is used to calculate the usage amount and update the account balance for accounting GL purpose.

ACCOUNTING ITEM CATEGORY

Lookup

Lookup for categories that can be associated with incurred costs. For example:

  • Operations

  • Staffing

  • Supplies

ADDITIONAL TEXT

Reference

Additional text can save multiple lingual notes or comments for products, parties, and other information.

ADDRESS LOCATION

Reference

Address details for physical or mailing address.

ADDRESS RELATED

Reference

Entity associates addresses with other addresses. Addresses can be associated in many ways. For example, one address is an alternate for another address for those locations with multiple addresses.

ADDRESS RELATED REASON

Lookup

Lookup for reasons addresses may be related.

ADDRESS STATUS

Base

Current status of an address location. For example:

  • Active

  • Current

  • Changed

  • Old address

ADDRESS STATUS REASON

Lookup

Lookup for the reason for a change to the current ADDRESS STATUS.

ADDRESS TYPE

Lookup

Lookup for address types. For example:

  • Home

  • Office

  • Warehouse

  • Billing

ADVERTISING PERIOD

Reference

Defines an advertising period.

ADVERTISING QUARTER

Reference

Defines a quarter in an advertising calendar.

ADVERTISING WEEK

Reference

Defines a week in an advertising calendar.

ADVERTISING YEAR

Reference

Defines a year in an advertising calendar.

AGE BAND

Lookup

Lookup to bin the customer into different groups according age. For example:

  • 0~20 years

  • 20~30 year

  • 40-50 years

  • 50-60 years

AGE ON NET BAND

Lookup

Defines subscriber life cycle ranges. For example:

  • 0-1 month

  • 1-2 months

ANZSIC CLASSIFICATION

Reference

The SIC code used in Australia and New Zealand.

APPOINTMENT CALENDAR

Base

Appointments assigning times for vendor or provider to deliver or provide a service.

APPOINTMENT TYPE

Lookup

Lookup for appointment types. For example:

  • Recurring

  • Scheduled

ARPU BASE CUSTOMER TYPE AGGR

Aggregate

The monthly summary of revenue values for ARPU calculation on CUSTOMER TYPE level.

ARPU BASE DRVD

Derived

The monthly summary of revenue values and revenue value components along with the subscriber base count; used to calculate the ARPU values.

ARPU BAND

Lookup

Average Revenue per Unit Band definitions. For example:

  • $0-100

  • $101-200

AWARD LEVEL

Lookup

The level of customer's loyalty, based on the LOYALTY PROGRAM and ability to contribute to the revenue of the carrier. For example:

  • Platinum

  • Gold

  • Silver

  • Bronze

BANK

Reference

Bank information that may be used in transactions.

BANK DIRECT DEBIT CHANNEL

Reference

Subtype of the PAYMENT CHANNEL, which tracks various bank channels where customers can pay by direct debt method.

BARING REASON

Lookup

Lookup defining reasons a customer may be banned from using a service.

BASE STATION CONTROLLER

Reference

Subtype of NETWORK ELEMENT, which lists the Base Station Controller (BSC) of the network. The Base Station Controller provides, classically, the intelligence behind the BASE TRANSCEIVER STATION (BTS)s. Typically a BSC has tens or hundreds of BTSs under its control. The BSC handles allocation of radio channels, receives measurements from the mobile phones, and controls handovers from BTS to BTS.

BASE TRANSCEIVER STATION

Reference

Base Transceiver Station (BTS) is the equipment which facilitates the wireless communication between User Equipment (UE) and the network.

BER FER ERROR RATIO DAY DRVD

Derived

Daily BER (Bit Error Rate) and FER (Frame Error Rate) statistics about the network elements.

BER FER ERROR RATIO MONTH AGGR

Aggregate

Monthly BER (Bit Error Rate) and FER (Frame Error Rate) statistics about the network elements.

Derived from BER FER ERROR RATIO DAY DRVD.

BER FER TYPE

Lookup

Lookup to indicate the statistics value for BER (Bit Error Rate) or FER (Frame Error Rate).

BILLING CYCLE

Lookup

Documents each billing run/cycle. Typically the billing cycle is per month. Sometimes a customer may be billed at a different date inside the billing cycle. For example:

  • The first day of month

  • 10th day of month

BILLING FREQUENCY

Lookup

The billing frequency specifies the number of billing periods that comprise the billing cycle.

BILLING PERIOD

Lookup

The billing period specifies the unit to be used to calculate the billing cycle (such as days or months).

BILLING STATUS CATEGORY

Lookup

Lookup for category of billing status. For example:

  • Successfully Billed

  • Failure to Bill

BILLING STATUS TYPE

Lookup

Lookup for the status type of billing result, including the reasons. For example:

  • Incorrect_data_failed

  • Incorrect_user_not_found

  • Successful

BLACK LIST HISTORY

Base

History of all black-listed customers.

BRAND

Reference

The brands associated with hardware (usually this applies for handsets, but also for ITEMs).

BROADBAND

Reference

Broadband is subtype of PRODUCT service. Describes the characteristics specific to the broadband product.

BROADBAND RATING PLAN

Reference

Subtype of PRODUCT RATING PLAN applied to BROADBAND product.

BROADBAND USAGE EVENT

Base

The broadband network usage event, normally implemented as a period while customer is connected to the network. This is charged based on time usage.

Some internet connection product might charge by data volume.

BUSINESS HALF MONTH

Reference

Defines month-in-half in a business calendar.

BUSINESS HALF YEAR

Reference

Defines half year in a business calendar.

BUSINESS LEGAL STATUS

Lookup

The legal status of the company. For example, a Public Company, Private, and so on.

BUSINESS MONTH

Reference

Defines month in a business calendar.

BUSINESS QUARTER

Reference

Defines quarter in a business calendar.

BUSINESS UNIT JOB ROLE

Reference

Assigns job roles to a business unit within the organization.

BUSINESS UNIT SHIFT

Reference

Work shift associated with the Business Unit, mapped to the Employee job roles for the allocation for these shifts.

BUSINESS WEEK

Reference

Defines week in a business calendar.

BUSINESS YEAR

Reference

Defines year in a business calendar.

CABLE MODEM

Reference

Subtype of EQUIPMENT INSTANCE, which collects all cable modem instances installed at customer's site connecting to the network of the Communications Service Provider.

CALENDAR HALF MONTH

Reference

Defines month-in-half in a Gregorian or Normal Calendar.

CALENDAR HALF YEAR

Reference

Defines half year in a Gregorian or Normal Calendar.

CALENDAR MONTH

Reference

Defines month in a Gregorian or Normal Calendar.

CALENDAR QUARTER

Reference

Defines quarter in a Gregorian or Normal Calendar.

CALENDAR WEEK

Reference

Defines weeks in a Gregorian or Normal Calendar.

CALENDAR YEAR

Reference

Defines years in a Gregorian or Normal Calendar.

CALL CATEGORY

Lookup

Lookup for call categories. For example: Data, Fax, or Voice.

CALL CENTER

Reference

Defines call centers for a carrier or provider.

RDM: A unit within an organization or a third-party organization that handles telephone sales, services, or both.

CALL CENTER AGENT

Reference

Agents of a call center.

CALL CENTER AGENT TYPE

Lookup

Lookup for call center agent types. For example: Employee or IVR.

CALL CENTER CALL DAY DRVD

Derived

The daily aggregate of customer call statistics from the call center. The customer calls are analyzed for the time of the call, duration of the call, subscriber or non-subscriber calling, and the call direction.

CALL CENTER CALL MONTH AGGR

Aggregate

Monthly summary of customer call statistics for the call center.

CALL CENTER CASE DAY DRVD

Derived

Statistics for all the cases initiated or resolved by the call center. For example:

  • Customer Compliant

  • Customer Inquiry

CALL CENTER CASE MONTH AGGR

Aggregate

Monthly summary of statistics for all the cases initiated or resolved by the call center.

CALL CENTER CASE SUB TYPE

Lookup

Lookup to further characterizes the type of cases from the call center. The case subtype helps to split a given case type into various subtypes. For example, for the case type, "Srv: Service Request", the subtype could be classified as "Package Upgrade", "Package Downgrade", "Simple Contract Renewal", or "Onsite Support".

CALL CENTER CASE TITLE

Lookup

Further classifies the CALL CENTER CASE SUB TYPE. For example, for call center case type "Service Request", and call center case subtype "Technical Support", the call center case title could be:

  • Handset Technical Support

  • Product Usage Technical Support

  • Network Fault Technical Support

CALL CENTER CASE TYPE

Lookup

Lookup for type of call center cases. For example:

  • Cmpl: Complaint

  • Inqry: Inquiry

  • Srv: Service Request

CALL CENTER SERVICE CAPABILITY

Reference

Assigns to the CALL CENTER, the languages, products, or geographical areas which the call center can serve.

CALL DIRECTION

Lookup

To indicate incoming call or outgoing call.

CALL FORWARD

Reference

A type of phone service. The calling party can be on hold if receiving party is in a call.

CALL OTHER TYPE

Lookup

This is to record any other characteristics of the call, such as, 3-party call, or any user defined special type of call.

CALL RECYCLED REASON

Lookup

Lookup for reasons why the voice carrying channel is being recycled during the call.

CALL ROUTING TYPE

Lookup

Lookup to define how the call was routed. For example:

  • Calling from external carrier

  • From Wireless to Land Phone

CALL SERVICE TYPE

Lookup

Lookup for service types that could be used in a call. For example:

  • Toll-Free number such as 800/400

  • Emergency Call such as 911, 112, 110

CALL SOURCE DESTINATION

Reference

All the possible call sources or call destinations. The call sources or call destinations classify the calls into different groups, such as: local call, long distance domestic call, or internal call.

CALL SUCCESS FAILURE TYPE

Lookup

Lookup to classify calls into successful calls or unsuccessful due to various reasons or causes. Call success failure, along with the call direction helps in facilitating the required analysis for roaming calls.

CALL SURCHARGE

Lookup

Any extra charge on the call in addition to the normal rating.

CALL TERMINATION REASON

Lookup

Lookup for the reasons a call may be terminated. For example:

  • Dropped

  • Successful End

CALL TYPE

Lookup

Lookup to further classify call category into call types. For example:

  • Voice Voice

  • SMS and MMS

  • Data and FAX

  • Information services

  • GPRS services for Data and Fax

CALLER ID

Reference

Subtype of PRODUCT, with specific information about CALLER ID service.

CAMPAIGN

Reference

Campaigns are the entire communication strategy for a specific marketing communications program. The marketing communications program is frequently in support of promotional events and individual promotions but can be stand-alone. A campaign is always associated with a MEDIA OBJECT, such as a television campaign.

CAMPAIGN CHANNEL

Reference

Channel by which a CAMPAIGN is exposed to a customer. For example: News group or media company which issues newspaper, television affiliate, and so on.

A piece of newspaper of a block/slot on the paper is a publication/media object.

The campaign channel can be categorized by CAMPAIGN CHANNEL TYPE.

CAMPAIGN CHANNEL TYPE

Lookup

Lookup for campaign channel type. For example: newspaper, Television, Magazine.

CAMPAIGN COST

Base

Subtype of COST which can apply to a CAMPAIGN.

CAMPAIGN MANAGEMENT HISTORY

Reference

The history of campaign party role about management of a CAMPAIGN. The party here can be not only the sales or marketing employee at TELCO operator, it can also be campaign partner.

CAMPAIGN MESSAGE

Reference

Details regarding message broadcast or sent during a CAMPAIGN.

CAMPAIGN MESSAGE CREATIVE

Base

Information about the creative content of the message.

CAMPAIGN MESSAGE DEPICTION

Reference

Details about how the execution message is depicted for a CAMPAIGN.

CAMPAIGN PURPOSE TYPE

Lookup

Lookup for types of campaign purposes. For example:

  • Acquire new customers

  • Consolidate existing customers

  • Retention existing customers

CAMPAIGN STATUS

Lookup

Status of CAMPAIGN.

CAMPAIGN TYPE

Lookup

Lookup for type of campaign. For example:

  • A targeted promotion (to specific individuals, account or group of accounts)

  • A mass market promotion (to a massive audience usually through radio, Television and newspaper)

CANNIBALIZATION DETAIL DAY DRVD

Derived

The calculated detail information related to the tariff/package change of customers.

For prepaid customers, usually it is impossible to track customer movement between products due to lack of customer identification. For some customers, they may change at the next "beginning of the month".

CANNIBALIZATION DETAIL MONTH AGGR

Aggregate

The calculated tariff or package change summary of all customers at the month level.

For prepaid customers, usually it is impossible to track customer movement between products due to lack of customer identification.

CELL

Reference

The cell in a wireless network such as GSM, which is an area serviced by the BASE TRANSCEIVER STATION (BTS).

CELL OUTAGE REASON

Lookup

Lookup for reasons a cell outage could occur. For example:

  • Power failure

  • Natural disaster

  • Theft

CELL SECTOR

Reference

Most cells are split into sectors or individual areas to make them more efficient and to let them to carry more calls. The cell site equipment provides each sector with its own set of channels.

CELL SITE

Reference

This is where the base station radio equipment and their antennas are located. A cell site gives radio coverage to a cell.

CELL SITE COST

Base

Subtype of COST which could apply to a CELL SITE. For example:

  • Expenses for the cell site building

  • Rent

  • Maintenance

CELL SITE TYPE

Lookup

Lookup for type of CELL SITE. For example: the cell site type can be classified by GSM/CDMA/PHS/broadband/Pay TV.

CELL STATISTIC DAY DRVD

Derived

The network parameters and runtime statistics captured at the cell level.

CELL STATISTIC MONTH AGGR

Aggregate

The network parameters and runtime statistics for all CELL SITEs aggregated at the month and certain geography level.

CELL TYPE

Lookup

Lookup for all possible cell types. For example, Macro, Micro, and Pico:

  • Macro cells are large geographical area where subscriber base is less dense.

  • Micro cells are small cells in side the macro cells to cover high subscriber density and uneven distribution.

  • Pico cells are used in large buildings, where signals from ground towers are poor.

CHANGE PROPOSED BY TYPE

Lookup

Lookup for who proposed the changes for a customer tariff change. For example:

  • By customer

  • By operator

CHANNEL

Reference

Identifies all the channels through which customers interact with the telco provider for sales or services purposes.

CHANNEL COST

Base

Subtype of COST, which collects all costs specifically related to a given sales channel.

CHANNEL TYPE

Lookup

Lookup for types of channels as defined by their functions. For example:

  • Sales channel

  • Payment channel

  • Debt collection channel

  • Loyalty program channel (where to join/change/redeem loyalty program)

CHURN PREDICT SOURCE DERIVED

Derived

Monthly statistics regarding each account, which acts as source material for training the Churn Predict Mining Model.

CHURN REASON

Lookup

Lookup for reasons an account may churn.

CIRCUIT CATEGORY

Lookup

Lookup for categories to classify the type of circuit. For example:

  • Analogue Voice

  • Digital Data Services (DDS)

  • ATM

CIRCUIT COMPONENT

Reference

Describes each component of each circuit. Typically a circuit will include several components. For example, a Digital Data Services circuit linking two customer sites may include three components:

  1. From the customer site to the exchange/switch

  2. From the switch to another switch

  3. From the second switch to the second customer site

There are two scenarios:

  • The circuit component links two switches.

  • The circuit component links a switch with a customer site

For the first scenario, where two switches are linked, the switch_id and secondary_switch_id attributes will identify the two switches. The site_id attribute will be null.

If the circuit component links a switch with a customer site, then the switch_id attribute will identify the switch and the site_id attribute will identify the customer site. The secondary_switch_id attribute will be null.

CIRCUIT RENTAL

Base

Business activities of renting some circuits to other operators, in return for a monthly, or fixed, revenue.

CIRCUIT RENTAL EVENT TYPE

Lookup

Lookup for types of rental events. For example:

  • Rental Initial

  • Monthly Charge

  • Maintenance Charge

  • Termination

CIRCUIT TRAFFIC

Base

The traffic volume statistics over certain periods, where periods are implementation dependent but generally hourly, for each CIRCUIT COMPONENT.

CIRCUIT TYPE

Lookup

Lookup for type of detailed circuit types. For example:

For interconnect:

  • T1 or E1, carry 1.5mbps

  • T2 6.312 Mbit/s

  • T3 44Mbit/s

For customer connection ADSL:

  • ADSL 1: Normally 1Mbit/s

  • ADSL 2x

COLLECTION AGENCY

Reference

Subtype of a PARTY, who collects the customer debt on behalf of the operator under a financial agreement. For example:

  • Debt collection

  • Roaming settlement collection

COMMISSION DAY DRVD

Derived

Statistics of all commissions granted to the sales agents because of the sales of products and services in the given period.

COMMISSION MONTH AGGR

Aggregate

Monthly aggregation of all commissions granted to the sales agents because of the sales of products and services in the given period.

COMMISSION TYPE

Lookup

Lookup for commission types that may be paid to sales representatives. For example:

  • FLAT: flat rate

  • PERCENTAGE: percent of transaction amount

CONNECT DISCONNECT DAY DRVD

Derived

Statistics about all connections and disconnections from each ACCESS METHOD on the network per day. This is related to the network usage or traffic. This entity is not related to counting "subscriptions" to a given service.

CONNECT DISCONNECT MONTH AGGR

Aggregate

Monthly aggregation of all connections and disconnections on the network per day, for network usage or traffic analysis.

CONTACT LIST

Reference

Lists of potential and existing CUSTOMERs for CAMPAIGNs. Contact lists can be created by the TELCO from marketing activity, running certain models, or obtained from another organization.

CONTACT LIST CHANGE REASON

Lookup

Lookup for possible reasons for changing the CONTACT LIST.

CONTACT LIST COST

Base

Subtype of COST, which applies to a specified CONTACT LIST (usually this is a cost associated with the purchase and maintenance of a contact list).

CONTACT LIST RECURRENCE TYPE

Lookup

A categorization of the recurrence of a CONTACT LIST. For example:

  • W = Once a Week

  • M = Once a Month

  • Y = Once a Year

  • MI = Once a Month with Invoice.

CONTACT ROLES

Lookup

Describes the various roles a contact individual may play in the relationship with the operator.

CONTENT

Reference

Keeps all downloadable content provided to the customer through the operator's network. For example:

  • Weather reports

  • Constellation

  • Jokes

CONTENT DELIVERY EVENT

Base

EVENT in which content was downloaded.

CONTENT PRICE

Reference

Price for downloading/ordering the content. This price is for individual content clip. There might be other contents priced as a flat rate rather than different price for each content. In this case, the pricing information should be in PRODUCT RATING PLAN.

CONTENT PRICING TYPE

Lookup

Lookup for types of content pricing. For example:

  • Charge per download

  • Monthly fixed rate

CONTENT PROVIDER

Reference

Provider for content that would be consumed by end user. The contents could be video, audio clips, or text content.

CONTENT TYPE

Lookup

Lookup for content types. For example:

  • Constellation

  • Jokes

  • Weather report

CONTRACT

Reference

Legal agreement between a Communications Service Provider and an account.

CONTRACT APPROVAL

Base

Approval for the CONTRACT from the operator's authorized employee, if the contract requires higher level approval or review.

CONTRACT ASSIGNMENT

Reference

Defines relationship(s) between contracts.

CONTRACT ASSIGNMENT REASON

Lookup

Lookup for reasons of why two contracts are related. For example:

The reason for one contract to be replaced by another:

  • CNRT-END: The first contract was naturally terminated

  • DLT-Delete:

  • CUST-CHNG: Voluntary change by customer

  • OP-INIT: Service Provider, operator, solicited the contract change, normally to increase the ARPU value

The reason for one contract to depend on another:

  • Equipment dependency

  • Network dependency

CONTRACT ASSIGNMENT TYPE

Lookup

Lookup for types of assignment between two contracts. For example:

  • RPLC: a new contract replaces the original contract

  • UPGRADE: a new contract replace original one with upgraded product

  • DEPEND: a contract depends on existence of another contract

CONTRACT CHANGE INITIATOR TYPE

Lookup

Lookup to classify the initiator of the contract change.

CONTRACT CHANGE TYPE

Lookup

Lookup of all the type of contract changes. For example:

  • Contract Renew

  • Contract Terminate

CONTRACT CHANGED DRVD

Derived

Derived information about a customer's current/future contract for analytical purpose. This entity captures only changed, current or future, contracts.

CONTRACT DOCUMENT

Reference

The document(s) provided by the customer when a contract was signed. For example:

  • Photocopy image of customer ID

  • The contract itself

  • Any other documents attached to the contract

CONTRACT DRVD

Derived

Derived information about a customer's current/future contract for analytical purpose. The entity only contains changed contract (current or future).

CONTRACT MONTH AGGR

Aggregate

Derived information about a customer's current/future contract for analytical purpose. The entity only contains changed contract (current or future).

CONTRACT PRODUCT ASSIGNMENT

Reference

To accommodate special link or additional usage of product in contract.

CONTRACT STATUS

Base

The status history of the CONTRACT.

CONTRACT STATUS REASON

Lookup

Lookup for description of the contract status change. For example:

  • Customer originated product change

  • Customer originated churn

  • Provider originated: Bad payment (leading to suspension)

  • Customer originated: Debt paid (leading to reactivation)

  • Customer originated: Banqueroute

CONTRACT STATUS TYPE

Lookup

Lookup for all possible types of CONTRACT STATUS. For example:

  • Newly created for new account

  • Renewed automatically

  • Naturally expired or terminated

CONTRACT TERM TYPE

Lookup

Lookup for all possible terms which may be attached to a CONTRACT. For example:

  • Monetary amount

  • Period

  • Premium

  • Initial points

  • Cancellation policy

  • Subsidy

CONTRACT TERM VALUE

Base

The value of terms attached to the CONTRACT. For example:

  • Monetary amount

  • Period

  • Premium

  • Initial points

The value can vary at different time period of contract. For example, the monthly fee might be 100 for the first six months and 80 for the last six months. A penalty calculation can also be based on the months left in contract.

CONTRACT TYPE

Lookup

Lookup for contract types.

COST

Base

Costs that have been incurred from operations and events at trackable levels. For example:

  • Gift offer expense

  • Employee salary

  • Commission

  • Promotion delivery cost

  • Carrier billing charge (for roaming/LAC/and so on)

COST CENTER

Reference

Cost Center of a COURIER or provider to which costs can be charged.

COST CENTER BUDGET

Base

The budget of each cost center at a specific financial period.

COST CUSTOMER MONTH AGGR

Aggregate

Statistics of various costs incurred to the customer. These details are important for analysis such as:

  • Subscriber retention cost

  • Subscriber acquisition cost

COST CUSTOMER DRVD

Derived

Monthly aggregation of various cost incurred to the customer. These details are important for analysis such as:

  • Subscriber retention cost

  • Subscriber acquisition cost

COST ORGANIZATIONAL MONTH AGGR

Aggregate

Monthly aggregation of all expenses by each business unit inside the carrier.

COST ORGANIZATIONAL DRVD

Derived

Statistics of all expenses by each business unit inside the carrier. These values can be useful for auditing and budgeting purposes.

COST REASON

Lookup

Lookup of all possible reasons why the cost occurred. For example:

  • Natural disaster

  • Operator error

COST SUBTYPE

Lookup

Lookup to further classify COST TYPEs. For example:

  • Acquisition cost

  • Retention cost

  • Salary

  • Damaged

  • New machine

  • Repair fee

COST TYPE

Lookup

Lookup for types of costs. For example, the cost is to the CUSTOMER, CHANNEL, COURIER, or to the EMPLOYEE (Mobile Monthly Claim or Purchase).

COURIER

Reference

The party who provides the Courier service for the Telecom Operator.

COURIER COST

Base

Subtype of COST which applies to a COURIER for delivering products or invoices to the customer.

CREDIT CATEGORY

Reference

Lookup for credit categories that may be assigned to customers. For example:

  • Excellent

  • Good

  • High risk

CREDIT CATEGORY MONTH AGGR

Aggregate

Credit category aggregation over all customers at each month.

CREDIT CATEGORY DRVD

Derived

Credit category assigned to each customer at each month. The credit categories are defined in the credit category dimension.

CURRENCY

Lookup

Lookup for currencies that may be used in a transaction.

CURRENCY EXCHANGE RATE

Base

Exchange rate against the primary currency, as determined by exchange rate type and value date.

CURRENCY GEOGRAPHY ENTITY ASSIGNMENT

Reference

Assigns currency usage to a geographic area.

CUSTOMER

Reference

Information pertaining to customers.

CUSTOMER ACQUISITION SUMMARY DAY DRVD

Derived

Aggregate daily new customer count by PRODUCT.

CUSTOMER ACQUISITION SUMMARY MONTH AGGR

Aggregate

Monthly summary of newly acquired customers by PRODUCT.

CUSTOMER CLASS

Lookup

Lookup for Customer Classification codes. For example:

  • HLCU-High Local Call Usage Customers

  • HNCU-High National Call Usage Customers

  • HINCU-High InterNational Call Usage Customers

CUSTOMER CLASS ASSIGNMENT

Reference

Assign customer to a customer class. A customer may belong to different customer classes because of their usage behavior at different times, therefore customer to customer class is a many to many relationship.

CUSTOMER COST

Base

Subtype of COST which applies to a customer. For example, the cost of a gift that is sent to a customer.

CUSTOMER DEBT COLLECTION MONTH AGGR

Aggregate

Statistics on Customer fraud and debt collection.

CUSTOMER DEBT COLLECTION DRVD

Derived

Monthly summary of customer fraud and debt collection.

CUSTOMER EQUIPMENT INSTALLATION DAY DRVD

Derived

Statistics related to customer equipment installation activities for each customer. These statistics typically include: modems, routers, or DSL boxes for internet and Television equipment

CUSTOMER EQUIPMENT INSTALLATION MO AGGR

Aggregate

Monthly summary of customer equipment installation activities. These statistics typically include: modems, routers, or DSL boxes for internet and Television equipment.

CUSTOMER FIELD INSTALLATION

Base

The activities to install services at the customer site. For example:

  • Broadband model installation (xDSL modem, cable modem)

  • Pay TV (Digital) installation with set-top box

CUSTOMER FIELD SERVICE ACTIVITY

Base

On site installation for the customer with particular equipment instance.

CUSTOMER FIELD SERVICE DETAIL

Base

Details regarding customer service.

CUSTOMER FIELD SUPPORT

Base

The activities of providing on site support to a customer.

CUSTOMER INDIVIDUAL

Reference

Subtype of CUSTOMER (and PARTY), which contains details of individuals as opposed to organizations.

CUSTOMER LTV BAND

TBS

TBS

CUSTOMER MINING

Derived

The result measures from mining analysis, including churn probabilities, Life Time Value (LTV) mining, and other result measures.

CUSTOMER OCCASION

Reference

Event celebrated or observed by a customer. For example:

  • Birthday

  • Anniversary

  • Company establishment day

CUSTOMER OCCASION TYPE

Lookup

Lookup for occasion type. For example: Wedding Anniversary, Birthday, Company founding anniversary, and so on.

CUSTOMER ORDER

Base

Orders placed by customers. This customer order is currently for service providers shop service, where a customer can place an order for a handset, a broadband installation request, or make some other order.

CUSTOMER ORDER LINE ITEM

Base

Details regarding items in the CUSTOMER ORDER.

CUSTOMER ORDER LINE ITEM STATE ASSIGN

Base

Current state of an order line item.

CUSTOMER ORDER PAYMENT

Base

Payments applied to a CUSTOMER ORDER.

CUSTOMER ORDER STATE ASSIGNMENT

Base

Current state of a CUSTOMER ORDER.

CUSTOMER ORGANIZATION

Reference

Subtype of CUSTOMER (and PARTY), which contains details of organizations as opposed to individuals. Note that an organization can also consist of one individual only (for example: "independent").

CUSTOMER RESTRICTED INFO

Reference

Detail information about a customer that may be deemed private.

CUSTOMER REVENUE BAND

Lookup

Entity contains a customer classification in revenue terms. For example: Customer with charges between $100 to $200.

CUSTOMER REVENUE BAND ASSIGNMENT

Reference

Assigns a revenue band to a customer.

CUSTOMER REVENUE TYPE

Lookup

Lookup for types of revenue a customer may bring to the operator. For example:

  • Recharging

  • Rent fee

  • One time equipment purchase

CUSTOMER SCORE

Reference

Scores or Score ranges that may be assigned to a customer based on credit, behavior, or other criteria. For example:

  • 1, 2, 3, 4, 5

  • 1-10, 11-20

CUSTOMER SEGMENT

Reference

Market or customer segments to which customer may be assigned.

CUSTOMER SEGMENTATION MODEL

Reference

The segmentation model used to profile the customers. For example:

  • KMeans by Revenue from Market Department

  • O-Clustering by IT department

CUSTOMER SENTIMENT

Lookup

Lookup for the various customer feelings as reported during a party interaction (on the phone, as email, or from simple mail). The value can be used for text mining. For example:

  • Angry

  • Happy

  • Neutral

CUSTOMER SIC ASSIGNMENT

Reference

Assigns SIC/NASIC code to customers.

CUSTOMER SOURCE

Reference

Initial source or contact with customer. For example:

  • Sales campaign

  • Advertisement

  • Call center

  • Dealer

CUSTOMER TYPE

Lookup

Lookup for type of customer. For example: Individual or Corporate.


Table 2-24 D to F Entity Descriptions

Entity Name Type Description

DATA SERVICE EVENT

Base

Data Service Events. For example

  • Fixed Line modem dial

  • Broadband access

  • GPRS service

DATA USAGE DAY DRVD

Derived

Daily aggregate of data usage.

DATA USAGE MONTH AGGR

Aggregate

Monthly aggregate of data usage.

DAY

Reference

Defines day, the lowest level of all calendars.

DAY ACTUAL CONDITION

Reference

Weather, external and internal conditions that may have impacted performance on a given day at a given location.

DAY TODATE TRANSFORMATION

Reference

Documents how todate transformation can be implemented at day level.

DAY TRANSFORMATION

Reference

Transformation with respect to a day. For example: maps a day last year to a corresponding day this year, or a day last year, to a day last month, and so on.

DEAL

Reference

A deal refers to a special offer from a supplier to the telecom provider. The deal generally provides allowances, discounts, special favorable terms of payment or other incentives to motivate the service provider to buy more products or services from a supplier.

DEAL VENDOR ITEM ASSIGNMENT

Reference

Identifies a specific product or service that is offered as part of a deal to the service provider and defines how the deal cost is to be handled.

DEALER

Reference

The PARTY who resells products from the operator.

DEALER DISCOUNT GROUP ASSIGNMENT

Reference

Assigns DEALER to a discount group(s).

DEBT AGING BAND

Lookup

Ranges of time used to group debt based on the age of the debt. For example:

  • 0-90 days

  • 91-180 days

DEBT COLLECTION

Base

A special type of interaction to collect defaulted payment from a customer by the in-house debt collector.

DEBT COLLECTION ASSIGNMENT

Base

The assignment of a debt collection case to an external debt collection agency.

DEBT COLLECTION ASSIGNMENT BATCH

Base

Grouping of collection assignments sent to collector.

DEMOGRAPHY ATTRIBUTE

Reference

User defined demographic attributes that can be assigned values.

DEMOGRAPHY GROUP

Reference

The domain of classifications used to group profile information about a PARTY. For example:

  • CH - Credit History

  • ED- Education

  • EM - Employment

  • EQ- Equipment

  • HB - Hobbies

  • HH - Household

  • OR - Organization

And other relevant demographics and psychographics.

DERIVED VALUE

Reference

Derived value of the customer based on predetermined criteria.

DESTINATION TYPE

Lookup

Lookup for the types of call source destinations. For example:

  • National

  • International

  • Particular continent

DIRECT DEBIT STATUS REASON

Lookup

Lookup for the various reasons the current status is direct debit payment. For example:

  • Customer preferred choice: when the customer does not want to use a credit card.

  • Customer imposed: which means the CSP imposes this status after problems with credit card or cash payments.

DISCOUNT GROUP

Reference

Discount groups that employees or partners may be a part of.

DISTANCE BAND

Lookup

Distance ranges to characterize network events by geographical distance.

DIVERT RETRIEVE REASON

Lookup

Lookup for all reasons for diverting a call or retrieving a call from a Mailbox. For example:

  • Line busy (divert)

  • Line off (divert)

  • No answer (divert)

  • Customer originated (divert / retrieve)

  • Mailbox originated (retrieve only)

DIVERT RETRIEVE TYPE

Lookup

Lookup for types for diverting a call or retrieving a call. For example:

  • Divert

  • Retrieve

Subscriber's calls are diverted to voice mail or to a Unified Messaging Service (UMS) mailbox as specified by the subscriber instructions or settings. For example, calls can be diverted when a subscriber is busy on another call, or when the subscriber has switched off the handset, or when a subscriber is not reachable. The subscriber can later retrieve all calls that are stored on the mailbox by accessing the mailbox through specified numbers or using the Internet, in case of UMS. All this traffic generated by diverted calls and retrieved calls is to be analyzed based on the type of call such as diverted or retrieved. The Divert Retrieve type helps in achieving this analysis by organizing calls as diverted or retrieved calls.

DOCUMENT CONDITION TYPE

Lookup

Lookup for possible document condition types. For example:

  • Complete

  • Incomplete

  • Unavailable

DOCUMENT TYPE

Lookup

Lookup for document types. For example:

  • Driver license photocopy

  • Address certification

  • Bank card photocopy

DSL MODEM

Reference

The xDSL modem to implement Broadband on copper wire (router).

EDUCATION

Lookup

Demographic education levels that may be assigned to customers.

EMPLOYEE

Reference

Subtype of individual indicating an employee of the provider.

EMPLOYEE ACTUAL LABOR HOURLY

Base

Worked shifts by hourly employees.

EMPLOYEE ACTUAL LABOR SALARIED

Base

Worked shifts by salaried employees.

EMPLOYEE COST

Base

Subtype of COST, which applies to employee. For example, salary and bonus for employee.

EMPLOYEE DESIGNATION

Lookup

The various designations present in an organization for the employees. For example:

  • Call Center Agent

  • Manager Customer Care

  • Consultant

  • Principal Consultant

EMPLOYEE DISCOUNT GROUP ASSIGNMENT

Reference

Assigns EMPLOYEE to DISCOUNT GROUP(s).

EMPLOYEE JOB ROLE ASSIGNMENT

Reference

Assigns EMPLOYEE to JOB ROLE(s).

EMPLOYEE JOB ROLE TYPE

Lookup

Relevance of job role assignment to employee. For example: Primary, Secondary, and so on.

EMPLOYEE LANGUAGE CAPABILITY

Reference

Specifies the languages the employee can use to serve customers, especially for call center agents and sales representatives.

EMPLOYEE RESTRICTED INFO

Reference

Detail information about the EMPLOYEE that may be deemed private.

EMPLOYEE SCHEDULE

Reference

Planned staffing schedule of location, role, shift, and employees.

EMPLOYEE TRAINING RECORD

Base

List the trainings an employee has received. The employee training record is normally meant to apply to the call center agent, who is trained on specific products and or services.

EMPLOYEE TYPE

Lookup

Lookup of employee type. For example:

  • Part-Time

  • Contractual

  • Full-Time

EQUIPMENT

Reference

The devices that a CUSTOMER can use to access services provided by COURIER. The device might be a Cell Phone, a Fixed Line Phone, or a Fax Machine. Devices might be lent or sold to CUSTOMER. The equipment is a subtype of PRODUCT.

EQUIPMENT CENTER

Reference

Facility housing devices.

EQUIPMENT CENTER COST

Base

Subtype of COST, which collects all costs that are specifically related to a given EQUIPMENT CENTER (facility rent, taxes, and so on).

EQUIPMENT FUNCTIONALITY

Reference

The function of the EQUIPMENT. For example:

  • Make wireless calls

  • Send SMS

  • Send MMS

EQUIPMENT FUNCTIONALITY ASSIGNMENT

Reference

Assigns functionality to EQUIPMENT.

EQUIPMENT INSTANCE

Reference

Implement communications. For example:

  • Handset (with IMEI)

  • Land line phone (with serial number)

  • Set-top box

  • Cable modem

EQUIPMENT INSTANCE RENTING CONTRACT

Reference

Subtype of CONTRACT in which customers lease some EQUIPMENT. This equipment still belongs to the service provider. When a contract terminates the device should be returned to the service provider. For example:

  • ADSL modem lease

  • Handset short term renting

EQUIPMENT INSTANCE STATUS HISTORY

Base

A history of the status for an EQUIPMENT INSTANCE. For example:

  • New

  • Broken

  • Returned

  • Lost

  • Reserved (for VIP loyalty program customer)

EQUIPMENT INSTANCE STATUS TYPE

Lookup

Lookup for type of specific equipment instance status type. For example:

  • Purchased from vendor

  • In inventory

  • In customer

  • Broken

  • Reserved

EVENT

Base

Describes the interactions with the Communications Service Provider. Event contains only "non-network" events (anything other than a call data record).

An event can occur related to a provider. For example, for equipment down or a service disruption. An event can occur related to a CUSTOMER. For example, for a service order or a bill payment.

Events store customer behavior to make special campaigns or to analyze the cost of customers. Normally an event incurs some cost and may generate revenue for the operator.

The information specific to the type of event, or event interaction, is stored in corresponding event subtypes.

EVENT ACCESS METHOD ACTIVITY

Base

Occurrence of Access Method Usage.

EVENT ACCOUNT

Base

Events occurring on an account. For example:

  • Account create

  • Account suspension/resume

  • Line (account) termination attempted (convinced back by representatives)

  • Line termination

EVENT ASSIGNMENT

Base

Describes relationship between unique events.

EVENT ASSIGNMENT REASON

Lookup

Lookup for all possible reasons why a relationship exists between two EVENTs. For example:

  • Premise

  • Result in

EVENT ASSIGNMENT TYPE

Lookup

Lookup for all types of relationships between two EVENTs.

EVENT CATEGORY

Lookup

Lookup for EVENT CATEGORY which is further grouped into EVENT TYPE. For example:

  • Loyalty Program Event

  • Access Method Event

EVENT CIRCUIT RENTAL

Base

Subtype of "Non Network Events", corresponding to the rental of a fixed line (broadband or phone line). The rental normally incurs charges for various type of activities. For example:

  • Initial Installation

  • Maintenance Check

  • Termination

EVENT CLASS

Lookup

Lookup for the classification for the types of EVENTs that can occur. For example:

  • IN: involves only Communications Service Provider

  • OUT: involves customer

EVENT COST

Base

Subtype of COST, which is specifically related to a given EVENT. This cost is usually for a non-network event such as an interaction with a customer. For example, for on-site maintenance after a service issue or a break-down.

EVENT EMPLOYEE PAYROLL

Base

Event in which payroll payment was made to an employee (excludes sales commission). Subtype of EVENT.

EVENT EQUIPMENT INSTANCE

Base

Events per instance of EQUIPMENT. Subtype of EVENT.

EVENT FINANCIAL

Base

Financial event involving an account or billing statement. Subtype of EVENT.

EVENT GEOGRAPHY

Base

Events affecting a Geographic Area that may have an impact on a provider's business. Subtype of EVENT. For example:

  • Earthquake

  • Power Outage

  • Labor Strike

EVENT GIFT REDEMPTION

Base

A gift redemption event occurred for a contract or subscription; normally because of a product market plan promotion. Operators may also give away gift items because of events such as a wrong billing. The redemption does not involve a LOYALTY PROGRAM.

EVENT INVOICE DELIVERY

Base

The delivery of invoice to customer. For example:

  • Printed letter

  • Email

  • Duplicate printed letter on request

EVENT LOCATION

Reference

Assigns an address location to the EVENT.

EVENT LOYALTY PROGRAM

Base

Events associated with each event or transaction on a customer loyalty program. For example:

  • Loyalty points earned by the customer

  • Bonus points awarded to the customer

  • Points redeemed by the customer

EVENT LOYALTY PROGRAM ACCUMULATION

Base

Subtype of EVENT LOYALTY PROGRAM, where a customer receives loyalty program points, a credit, based on network usage, a payment, or some other event.

EVENT LOYALTY PROGRAM REDEMPTION

Base

Subtype of EVENT LOYALTY PROGRAM, where a customer uses loyalty program points, a credit, to redeem gift items including cash placed in their account balance or some other redemption gift item such as a toy.

EVENT PARTY ASSIGNMENT

Base

Many to many relationship assigning a party or multiple parties to event(s).

EVENT PARTY INTERACTION

Base

Interactions or communications with the customer. For example:

  • Faults

  • Inbound and outbound telemarketing

  • Direct mail

  • SMS

  • Email

  • Service calls

  • Complaints

  • Debt collection

EVENT PARTY INTERACTION CALL

Base

Subtype of EVENT PARTY INTERACTION which represents all phone call interactions from the customer with detailed information including:

  • Hold time

  • Queue time

  • Interaction time

  • Run by the Automated Voice Response (AVR)

EVENT PARTY INTERACTION EMAIL

Base

Subtype of EVENT PARTY INTERACTION which represents email interaction from customers.

EVENT PARTY INTERACTION LETTER

Base

Subtype of EVENT PARTY INTERACTION which represents the interaction with customers through letters.

EVENT PARTY INTERACTION VISIT

Base

Visits to a store by a customer. Subtype of EVENT.

EVENT PARTY PROFILE

Base

Event in which party profile information was modified or updated.

EVENT PARTY ROLE

Reference

Role played by a PARTY in an EVENT. For example:

  • Customer who reported the event

  • Customer affected by event

  • Party who caused the event

EVENT PREPAID MOBILE

Base

Actions involving PREPAID MOBILE EVENT TYPE account. Subtype of EVENT ACCOUNT. For example:

  • Initial activation

  • Recharges

  • Adjustments

  • Deactivation

EVENT PRODUCT PACKAGE

Base

Events associated with an offer or PRODUCT PACKAGE. Subtype of EVENT.

EVENT REASON

Lookup

Lookup for event reasons. For example: arrearage.

EVENT REASON CATEGORY

Lookup

Lookup for event reason categories. Categories are further grouped into event reasons.

EVENT RESOLUTION

Reference

Lookup for possible event resolutions.

EVENT RESPONSE REASON

Lookup

Lookup for possible response reasons that may be used in an EVENT.

EVENT RESULT

Lookup

Lookup for the description of a result or any events. For example:

  • Successfully processed

  • Escalated

  • Refused by CSP

  • Refused by customer

  • Failed – Impossible

  • Failed – process error

EVENT SIM CARD

Base

Events associated with a SIM CARD. Subtype of EVENT.

EVENT STATUS

Base

Lookup for event status. For example:

  • Completed

  • Pending

  • In-Progress

  • Suspended

  • Cancelled

  • Abandoned

EVENT STATUS REASON

Lookup

Lookup for event status reasons. For example:

  • Insufficient funds

  • Stolen card

EVENT STATUS TYPE

Lookup

Lookup for EVENT STATUS. For example:

  • Complete

  • Pending

  • In-Progress

  • Suspended

  • Cancelled

  • Abandoned

EVENT SUBSCRIPTION

Base

Events associated with a subscription. Subtype of EVENT. For example:

  • Subscription activation

  • Reimbursement on prepaid account

  • Termination

  • Suspension because of insufficient deposit

EVENT SUBSCRIPTION CHANGE

Base

Events involving temporal provisioning and relinquishment of products and services to current subscription base.

EVENT TYPE

Lookup

Lookup for event type. For example:

  • In Loyalty Program Event

    1.1 Points Accumulation

    1.2 Redemption

  • Access Method Event

    2.1 Access Method Login (connect)

    2.2 Access Method Logout (disconnect)

    2.3 Access Method Suspension (because of late payment or other reason)

EVENT WEB REGISTRATION

Base

The event of a customer registering at Web site to apply for service.

EXTERNAL DEBT COLLECTION DAY DRVD

Derived

Daily collections by external collector.

EXTERNAL DEBT COLLECTION MONTH AGGR

Aggregate

Monthly collections by external collector.

EXTERNAL INFORMATION SOURCE

Reference

Source from which the demographic information or customer information is obtained.

EXTERNAL OPERATOR

Reference

All operators the Service Provider does business with, including inland competitors or roaming partners.

EXTERNAL ORGANIZATION TYPE

Lookup

Lookup for types of external organizations.

FACTOR COMPANY

Reference

Stores the information about the factor company, which is the financial instrument holding the receivables.

FAULT RESOLUTION TYPE

Lookup

Lookup for available types of network fault resolution.

FAULT TYPE

Lookup

Lookup for available types of faults.

FIELD ACTIVITY RESULT TYPE

Lookup

Lookup for available result types for customer field activities that are performed by support engineers. For example:

  • S - Successful

  • F - Failed

FIELD ACTIVITY TYPE

Lookup

Lookup for types of customer field activities that may be performed by support engineers. For example:

  • Installation

  • Troubleshooting

  • Upgrade

FISCAL HALF MONTH

Reference

Defines half-month in a fiscal calendar.

FISCAL HALF YEAR

Reference

Defines half-year in a fiscal calendar.

FISCAL MONTH

Reference

Defines month in a fiscal calendar.

FISCAL QUARTER

Reference

Defines quarter in a fiscal calendar.

FISCAL WEEK

Reference

Defines week in a fiscal calendar.

FISCAL YEAR

Reference

Defines year in a fiscal calendar.

FIXED LINE

Reference

Subtype of PRODUCT that provides detailed information on the fixed line service.

FIXED LINE CALL EVENT

Base

Event involving a call made on a Fixed Line telephone.

FIXED LINE PORT

Reference

The port ID associated with the telephone plug that provides a customer with fixed line service. The Fixed Line Port connects a customer's phone to a SWITCH.

FIXED LINE RATING PLAN

Reference

Subtype of PRODUCT RATING PLAN associated only with Fixed Lines.

FRAUD PROFILE CLASS

Lookup

Lookup for all possible classes of fraud profile that customers or dealers may commit.


Table 2-25 G to J Entity Descriptions

Entity Name Type Description

GENDER

Lookup

Lookup for gender.

GEOGRAPHY CITY

Reference

Cities defined in a Geography.

GEOGRAPHY COUNTRY

Reference

Countries defined in a Geography.

GEOGRAPHY COUNTY

Reference

Counties defined in a Geography.

GEOGRAPHY DEMOGRAPHIC GROUP

Reference

User-defined classification for DEMOGRAPHY ATTRIBUTEs.

GEOGRAPHY DEMOGRAPHY ATTRIBUTE

Reference

User defined attributes to describe demographic information for a given Geography.

GEOGRAPHY DEMOGRAPHY VALUE

Reference

User defined values corresponding to the DEMOGRAPHY ATTRIBUTEs.

GEOGRAPHY ENTITY

Reference

User defined geographic units.

GEOGRAPHY ENTITY ASSIGNMENT

Reference

Assignment of GEOGRAPHY ENTITYs to a user defined hierarchy level.

GEOGRAPHY ENTITY HIER LEVEL ASSIGNMENT

Reference

Assigns GEOGRAPHY ENTITYs to GEOGRAPHY HIERARCHY LEVELs.

GEOGRAPHY HIERARCHY

Reference

User defined geographic hierarchies.

GEOGRAPHY HIERARCHY LEVEL

Reference

User defined levels within a geographic hierarchy.

GEOGRAPHY HIERARCHY LEVEL ASSIGNMENT

Reference

Assignment of a GEOGRAPHY HIERARCHY level to a GEOGRAPHY ENTITY.

GEOGRAPHY LEVEL

Reference

User defined name and descriptions for GEOGRAPHY HIERARCHY LEVEL.

GEOGRAPHY LEVEL ATTRIBUTE

Reference

User defined attributes associated with a GEOGRAPHY LEVEL.

GEOGRAPHY LEVEL ATTRIBUTE VALUE

Reference

Values assigned to the GEOGRAPHY LEVEL ATTRIBUTEs.

GEOGRAPHY REGION

Reference

Defines a region in a Geography.

GEOGRAPHY STATE

Reference

Defines a state in a Geography.

GEOGRAPHY SUB REGION

Reference

Defines a subregion in a Geography.

GEOGRAPHY WORLD

Reference

Top level of Geography.

GIVE AWAY ITEM DAY DRVD

Derived

Statistics of all give away items to the customer for promotion or retention purposes.

GIVE AWAY ITEM MONTH AGGR

Aggregate

Monthly aggregation of all give away items given to customers for promotion or retention purposes.

GIVE AWAY TYPE

Lookup

Lookup for types of give-aways.

GL REFERENCE

Reference

Groups or Categories referred from General Ledger to classify all revenue related activities.

GPRS PCU DAY DRVD

Derived

Statistics on the PCU (Packet Control Unit) for the GPRS (General Packet Radio Service) such as bytes sent, bytes received, the transferred data volume, and so on.

GPRS PCU MONTH AGGR

Aggregate

Monthly aggregation of statistical values on PCU (Packet Control Unit) for the GPRS (General Packet Radio Service). For example:

  • Bytes sent

  • Bytes received

GPRS SERVICE

Reference

Subtype of PRODUCT, with more information about GPRS (General Packet Radio Service).

The service provider provides various services such as Internet, WAP to its customers or subscribers over GPRS. The information about the usage of these services is to be analyzed at individual and aggregate level. The GPRS service dimension organizes all GPRS services.

GPRS SERVICES DAY DRVD

Derived

Daily summation regarding GPRS services provided to subscribers.

GPRS SERVICES MONTH AGGR

Aggregate

Monthly summation regarding GPRS services provided to subscribers.

HALF HOUR

Reference

Half-hours defined as part of time.

HALF MONTH TODATE TRANSFORMATION

Reference

Todate transformation information at the half-month level.

HALF MONTH TRANSFORMATION

Reference

Transformations with respect to half-month. For example:

  • This half-month last year

  • This year last half-month

HALF YEAR TODATE TRANSFORMATION

Reference

Cumulative time transformations at the half-year level.

HALF YEAR TRANSFORMATION

Reference

Transformations with respect to half-year. For example:

  • This half-year last year

  • This year last half-year

HANDSET INSTANCE

Reference

Instance of a handset.

HANDSET MODEL

Reference

Models of handsets.

HANDSET STOCK DAY DRVD

Derived

Daily Aggregate of Handset Stock statistics by CUSTOMER, SALES CHANNEL, and SALES CHANNEL REPRESENTATIVE.

HANDSET STOCK MO AGGR

Aggregate

Monthly Summary of Handset Stock statistics by SALES CHANNEL and SALES CHANNEL REPRESENTATIVE.

HANDSET SUBSIDY DAY DRVD

Derived

Daily summation of handset distributions involving gift, discount, or loyalty voucher points.

HANDSET SUBSIDY MONTH AGGR

Aggregate

Monthly summation of handset distributions involving gift, discount, or loyalty voucher points.

HOUR

Reference

Hours defined as part of time.

HOUSEHOLD

Reference

Captures household information for the household that the individual customer may belong to.

IDD

Reference

Subtype of PRODUCT that provides information about IDD service.

IDD CALL EVENT

Base

Event involving an International Direct Dial (IDD) call.

IN PLATFORM

Reference

IN (Intelligent Network) platforms operated by the telecom service provider. The Prepaid mobile or toll-free business normally relies on IN platform.

IN PLATFORM DAY DRVD

Derived

Daily summation of parameters related to the IN PLATFORM functioning and performance on a daily level.

IN PLATFORM MONTH AGGR

Aggregate

Monthly summation of parameters related to the IN PLATFORM functioning and performance on a monthly level.

INDIVIDUAL DEMOGRAPHY PROFILE

Reference

The demographic values for individual customer and customer household.

INDIVIDUAL DEMOGRAPHY VALUE

Reference

Values assigned to user-defined DEMOGRAPHY ATTRIBUTEs.

INITIATIVE RESULT TYPE

Lookup

Lookup for all possible results of initiatives. For example, the result is:

  • Becomes a customer

  • Does not become a customer

INITIATIVE TYPE

Lookup

Lookup for available initiative types.

INTERACTION ANSWER CHOICE

Base

Defined answers, choices, corresponding to initiative questions.

INTERACTION CHANNEL

Reference

Channels used for Provider or Customer interactions. For example:

  • Call center

  • Online business system

  • Counter

INTERACTION DIRECTION

Lookup

Lookup for available directions for initiatives. For example:

  • Inbound

  • Outbound

INTERACTION QUESTION RESPONSE

Base

Responses provided by CUSTOMER to interaction questions.

INTERACTION REASON

Lookup

Lookup for interaction reasons. For example:

  • Debt collection

  • Service call

  • Inbound marketing

  • Outbound marketing

  • Customer complaints

INTERACTION RESULT TYPE

Lookup

Lookup for possible responses to customer interaction. For example:

  • Showed interest without decision

  • Offer accepted

  • Never call again

INTERACTION STATUS

Lookup

Lookup for available interaction status. For example:

  • Planned

  • In-progress

  • Executed

  • Closed

INTERACTION TYPE

Lookup

Lookup for types of interactions between company and CUSTOMER. For example:

  • Email

  • Call Center Inbound

  • Call Center Outbound

  • Walk-In to the shop

  • Letter

INTERNAL DEBT COLLECTION DAY DRVD

Derived

Daily summary of payment and collection by internal collector.

INTERNAL DEBT COLLECTION MONTH AGGR

Aggregate

Monthly summary of payment and collection by internal collector.

INTERNET ACCESS EVENT

Base

Subtype of NETWORK EVENT, which captures customer internet surfing history with detailed URL and time information.

INVOICE

Base

Invoices issued to accounts representing request for payment for goods and services for a specified period.

INVOICE ADJUSTMENT

Base

Adjustments made on the INVOICE.

INVOICE ADJUSTMENT MONTH AGGR

Aggregate

Monthly aggregation of calculated measures for all adjustments made on the INVOICEs.

INVOICE ADJUSTMENT DRVD

Derived

Calculated measures for all adjustments made on the INVOICEs.

INVOICE ADJUSTMENT QUOTA

Reference

Quota of INVOICE ADJUSTMENTs assigned to EMPLOYEE.

INVOICE ADJUSTMENT REASON

Lookup

Lookup for the possible reasons for an adjustment on a customer's or on a partner's bill. For example:

  • Service Activation Error

  • Billing Error

  • Goodwill

  • VIP, Loyalty Program, Customer

  • Promotion Event

  • Service downgrade/fault compensation

  • Customer complain

INVOICE ADJUSTMENT TYPE

Lookup

Lookup for available adjustment types that may be applied to customer invoices. For example:

  1. Direct Total Amount Adjustment

  2. Discount Total Bill Amount Adjustment

  3. Monthly Fee Adjustment

  4. Recharge Fee Adjustment (Prepaid)

  5. Activation Fee Adjustment

  6. Free-Unit Amount Adjustment

  7. Item Charge Adjustment

  8. Loyalty Points Adjustment

  9. Others

INVOICE CUSTOMER TYPE AGGR

Aggregate

Monthly aggregation of all INVOICEs to post paid customers at customer type level.

INVOICE DELIVERY TYPE

Lookup

Lookup for available delivery types of INVOICE to customer. For example:

  • Printed letter

  • Email

  • Duplicate printed letter on request

INVOICE DISCOUNT

Base

Discount applied to INVOICE.

INVOICE DISCOUNT REASON

Lookup

Lookup for available discount reasons.

INVOICE DISCOUNT TYPE

Lookup

Lookup for available discount types that may be applied to customer invoice.

INVOICE DRVD

Derived

Statistics on Invoices for further aggregation.

INVOICE ITEM

Base

Any line that appears on the INVOICE which is specific to the product components a customer has. The invoice item is not necessarily associated with a monetary charge or a credit (but invoice item usually does have an associated monetary charge or credit). The invoice item is usually a billable item to a given account, onto which usage or other events are charged. The unbillable items that could be part of the invoice item are "Loyalty Points", "Free Unit Amount/Rollover", and so on.

For example:

  • Wireless Call

  • Ringtone Downloading

  • Monthly Fixed Rate

INVOICE ITEM DETAIL

Base

Additional details regarding INVOICE ITEM including Product Usage Level.

INVOICE ITEM DETAIL TYPE

Lookup

Lookup for invoice item detail types (item detail is the description of each column of a given item in a bill). The invoice item detail type may be classified in a mobile line. For example:

  • Call Date

  • Duration

  • Dialed Digits

  • Units

  • Direction

  • Zone

  • Charge Net

  • VAT

  • Total Charge

INVOICE ITEM TYPE

Lookup

Lookup for invoice item types. For example:

  • 1 = Long Distance Minutes of Usage

  • 2 = Access Charge

  • 3 = Monthly Fee

  • 4 = Equipment Charge

  • 5 = Roaming Minutes of Usage

  • 6 = Equipment Rental

  • 7 = Installation Charge

  • 8 = Adjustment or Discount

  • 9 = Call Record Detail

INVOICE DRVD

Derived

Postpaid customers are billed/invoiced for the usage of services on monthly basis, that is, bill for every subscriber based on his package, category, and usage is calculated, printed and sent to the customer account address for payment.

INVOICE PAYMENT ASSIGNMENT

Base

Matches the payment to an INVOICE.

INVOICE PAYMENT TERM

Reference

Payment terms of each INVOICE. For example:

  • Payment days

INVOICE PAYMENT TERM TYPE

Lookup

Lookup for available types of payment terms.

INVOICE TYPE

Lookup

Lookup for type of INVOICE according to invoice generation process. For example:

  • Summary Invoice for hierarchical account

  • Standard Invoice

  • Trial Billing Invoice

IP ADDRESS POOL

Reference

Subtype of ACCESS METHOD POOL, which lists all IP addresses available to customers.

ISP

Reference

Internet Service Provider (ISP).

ISP BUSINESS

Reference

The business that the ISP may provide. For example:

  • Company | Services

  • A $ 45.00 Broadband DSL Access 20Mbps Down, 896Kps Up

  • A $ 25.00 Broadband DSL Access 7Mbps, 896Kps Up

  • A $ 19.99 Broadband DSL Access 1.5Mbps, 896Kps Up

  • A $ x.xx Wireless Broadband or cable modem Access

Please note that this only covers ISP specific business (not Application Provider business).

ISP BUSINESS ASSIGNMENT

Reference

Relates an ISP to the Communications Service Provider through a "business" relationship. This entity assigns the definition of the relationship, in entity ISP BUSINESS, with the corresponding ISP.

ISP BUSINESS TYPE

Lookup

Lookup for high level of ISP business type. For example, Cooper Line Internet Connection (may further divided as DSL, ISDN), Colocation, DNS Name, and so on. For example:

  • Virtual private server

  • Dedicated hosting

  • Colocation center

  • Web hosting

  • Free hosting

  • Shared hosting

  • Clustered hosting

  • Reseller hosting

  • Application-specific

  • Blog hosting

  • Image hosting

  • Video hosting

  • Wiki farms

  • File hosting

  • Remote backup service

  • Game server hosting

  • DNS hosting

  • E-mail hosting

ISP TYPE

Lookup

Lookup for types of ISPs.

ISP USAGE EVENT

Base

Records traffic details of each session the user conducts with the Internet Service Provider ISP. The entity documents the connect and disconnect date/time and the number of local and international bytes downloaded, and uploaded. There will typically be multiple rows for each long running session. The entity will be implementation dependent, but normally there will be a record generated each hour - all records for the one session will have the same connect and disconnect date times, but the event start/end datetimes will identify the period that the usage (bytes) covers.

ISP USER

Reference

Identifies the user names associated with the Internet Service Provider (ISP) subscription.

ITEM

Reference

Details describing the item or PRODUCT.

ITEM TYPE

Lookup

Lookup for type of item (PRODUCT).

JOB

Reference

The occupation of the customer, which is the principal activity the customer performs to earn money.

JOB ROLE

Reference

Job Roles defined in the company that may be assigned to employees. For example:

  • Sales representative

  • Support

  • Product manager

  • Customer representative

  • Call center agent


Table 2-26 K to N Entity Descriptions

Entity Name Type Description

LANGUAGE

Lookup

Languages spoken or written within the company or in interactions with CUSTOMERs.

LEGAL PROCESS STATUS TYPE

Lookup

Lookup for various states which a legal process could be in, as part of a party interaction (usually after an inability to find an agreement to pay debts).

LETTER TYPE

Lookup

Lookup for available types of letters that may be sent to CUSTOMERs. For example:

  • Direct marketing

  • Legal letter

  • Contract confirmation letter (Welcome)

LINE ACTIVATION TERMINATION DAY DRVD

Derived

Statistics for the number of lines activated and terminated every day for each ORGANIZATION BUSINESS UNIT.

LINE ACTIVATION TERMINATION MONTH AGGR

Aggregate

Monthly aggregation of numbers of lines activated and terminated for each ORGANIZATION BUSINESS UNIT.

LOYALTY PROGRAM

Reference

Loyalty programs available to which customers may be members of.

LOYALTY PROGRAM CHANNEL

Reference

Channel through which a customer can join, change, or redeem the loyalty program. For example:

  • Online service

  • Call center

  • Shops

LOYALTY PROGRAM DAY DRVD

Derived

Daily aggregate of LOYALTY PROGRAM statistics by CUSTOMER, PRODUCT, SALES CHANNEL, LOYALTY PROGRAM CHANNEL, SALES CHANNEL REPRESENTATIVE, AGE ON NET BAND, CREDIT CATEGORY.

LOYALTY PROGRAM EVENT CATEGORY

Lookup

Lookup for the types of award updates that can be given to the PARTY. For example:

  • E = Earnings

  • R = Redemption

LOYALTY PROGRAM EVENT TYPE

Lookup

Lookup for types of LOYALTY PROGRAM events that could be used in a LOYALTY PROGRAM.

LOYALTY PROGRAM MO AGGR

Aggregate

Monthly summary of LOYALTY PROGRAM statistics by PRODUCT, SALES CHANNEL, LOYALTY PROGRAM CHANNEL.

LOYALTY PROGRAM PARTY ROLE

Lookup

Lookup for available roles or responsibilities that may be assigned to a PARTY participant of a LOYALTY PROGRAM. For Example:

  • Customer Member

  • Internal Officer

  • Manager

LOYALTY PROGRAM POINTS BALANCE

Base

Balance points awarded to a PARTY in a LOYALTY PROGRAM.

MAILBOX

Reference

Mailbox allocated to a CUSTOMER.

MANAGE ACTION TYPE

Lookup

Lookup for type of management action that can be performed on a product market plan. For example:

  • Marketing Manager

  • Creation

  • Marketing Research

MARITAL STATUS

Lookup

Lookup for marital status that may be assigned to an individual.

MARKET AREA

Reference

A geographic area or region or other connotation for which demographic data are available.

MARKET AREA LEVEL

Reference

Hierarchical levels of market area.

MARKET OPERATOR PORTING DERIVED

Derived

Monthly porting count between operators.

MARKET PLAN MANAGEMENT

Base

The management history of market plan by the employee.

MARKET PLAN SUBSTITUTE BY DOC

Reference

Stores the document that allows the customer to access a market plan specific to a certain category of customers (such as Students, Seniors, or unemployed). These market plans usually require a document that proves the validity of the request (for example, income certification or identification documents) that this entity stores.

MARKET PLAN TERM VALUE

Reference

The detail term value according to each term for the market plan, including monthly charge.

MARKET SHARE MONTH AGGR

Aggregate

Monthly summation of Geographic Market Share for a PRODUCT MARKET PLAN.

MARKET SHARE MONTH DRVD

Derived

PRODUCT MARKET PLAN Sales Revenue by Month, Address, and Business Unit.

MEDIA OBJECT

Reference

Any form of media in which a CAMPAIGN MESSAGE may appear. For example:

  • Newspaper page

  • Television time slot

MEDIA OBJECT ASSIGNMENT

Reference

Relation of one MEDIA OBJECT to another MEDIA OBJECT.

MEDIA OBJECT COST

Base

Costs incurred in the usage of a MEDIA OBJECT. Subtype of the COST that collects all costs related to a specific media (Newspaper, Television spots, Fliers, and so on).

MEDIA OBJECT TYPE

Lookup

Lookup for available types of MEDIA OBJECTs. For example:

  • Newspaper

  • Television

MEDIATED CALL EVENT

Base

The mediated call event with original device information, dropped call, and missed call information, which is normally ignored by rating engine. The call event are collected before the calls are rated by rating engine.

MINUTE

Reference

Defines minutes as part of time.

MINUTE ALLOWANCE

Base

Subtype of Account Balance describing the number of 'Free' or 'Prepaid' minutes allocated to Subscriber in a given month.

MMS

Reference

Subtype of VALUE ADDED SERVICE and PRODUCT, which contains the information relative to the Multimedia Messaging Service (MMS). Do not confuse with the MMS EVENT itself.

MMS EVENT

Base

Subtype of NETWORK EVENT, which collects all information of calls of type Multimedia Messaging Service (MMS).

MOBILE SWITCHING CENTER

Reference

The Mobile Switching Center (MSC) is a sophisticated telephone exchange which provides circuit-switched calling, mobility management, and GSM services to the mobile phones roaming within the area that it serves. This includes voice, data and fax services, and SMS and call divert services.

MODEL TYPE

Lookup

Lookup for the model types of items. Note that there may be different "types" for a given model. For example, for a handset a model may allow "Bluetooth" or not.

MONTH TODATE TRANSFORMATION

Reference

Defines related calendar elements for performing to-date time transformations.

MONTH TRANSFORMATION

Reference

Transformations with respect to a month. For example:

  • This month last year

  • This year last month

MSC TRAFFIC DAY DRVD

Derived

Parameters, configurations, and runtime statistics related to the MSC (Mobile Switch Center) functioning and performance.

MSC TRAFFIC MONTH AGGR

Aggregate

Monthly aggregation of parameters, configurations, and runtime statistics related to the MSC (Mobile Switch Center) functioning and performance.

MUSIC DOWNLOAD

Reference

Subtype of VALUE ADDED SERVICE and PRODUCT, which contains the information relative to the music downloading service.

NAICS CLASSIFICATION

Reference

Lookup for Classifications in the North American Classification System (NAICS).

NAICS INDUSTRY

Reference

Lookup for Industry in the North American Industry Classification System (NAICS).

NAICS INDUSTRY GROUP

Reference

Lookup for Classification Groups in the North American Industry Classification System (NAICS).

NAICS INDUSTRY SECTOR

Reference

Lookup for Industry Sectors in the North American Industry Classification System (NAICS).

NAICS INDUSTRY SUBSECTOR

Reference

Lookup for Industry Sub-sectors in the North American Industry Classification System (NAICS).

NATIONALITY

Lookup

Lookup for available nationalities.

NETWORK

Reference

Names and Service Providers for relevant Networks. The full details of a service provider are found in the PARTY and Organizations entities.

NETWORK AVAILABILITY DAY DRVD

Derived

Statistics of network availability measures and all outages that happened to the operator's network.

NETWORK AVAILABILITY MONTH AGGR

Aggregate

Monthly aggregation of network availability statistics and all outages that happened to the operator's network.

NETWORK ELEMENT

Reference

All elements belonging to the network (normally, only of the Communications Service Provider) to deliver the communication services.

NETWORK ELEMENT COST

Base

Subtype of the COST, which associate a specific cost to a given NETWORK ELEMENT (purchase, maintenance, recycling, and so on).

NETWORK ELEMENT FAULT ASSIGNMENT

Base

Assignment of a NETWORK FAULT to a SUBSCRIPTION.

NETWORK EVENT

Base

Abstracted event for all events that happened to the operator network because of customer usage; network events are usually the basis for customer billing.

NETWORK EVENT STATUS

Lookup

Lookup for possible status of NETWORK EVENTs. For example:

  • Mediated

  • Billed

NETWORK EVENT TYPE

Lookup

Lookup for available types of NETWORK EVENTs.

NETWORK FAULT

Base

Records each registered fault.

NETWORK FAULT SUBSCRIPTION ASSIGNMENT

Base

Links a network issue to all subscriptions impacted, which allows you to list the customer and service impacted by a network fault.

NETWORK SERVICE COVERAGE ASSIGNMENT

Reference

Defines the relationship between NETWORK TOUCHPOINT and SERVICE COVERAGE AREA.

NETWORK TOUCHPOINT

Reference

Point of service site for a subscriber to access a CELL SITE or FIXED LINE PORT.

The site is a geographical point instead of area, therefore, it belongs to some geographical entity. For example, a city or a town rather than a type of the GEOGRAPHY ENTITY.

For example:

  • BTS in GSM network

  • Customer installation site in ADSL broadband

NETWORK TOUCHPOINT CLASS

Lookup

Lookup for available classes of NETWORK TOUCHPOINT. For example:

  • Public

  • Private

NETWORK TOUCHPOINT MONTH AGGR

Aggregate

Monthly summary of NETWORK TOUCHPOINTs by CUSTOMER, NETWORK, Address, and so on.

NETWORK TOUCHPOINT DRVD

Derived

Monthly summary of NETWORK TOUCHPOINTs by NETWORK, County, and so on.

NETWORK TOUCHPOINT STATUS

Lookup

Lookup for Available Status codes and descriptions of NETWORK TOUCHPOINT.

NETWORK TOUCHPOINT TYPE

Lookup

Lookup for the type of NETWORK TOUCHPOINT. For example:

  • Cell Site (Wireless)

  • International Switch (roaming partners)

  • Ethernet Socket at Customer site (last mile included - wireline/broadband

  • Switch (wireline - exclusive last mile - wireline/broadband)

NETWORK TYPE

Lookup

Lookup for the types of NETWORK. Will include:

  • PSTN

  • GSM

  • CDMA

NOTIFICATION TYPE

Lookup

Lookup for types of notification a subscriber may receive when a call is received by or diverted to a UMS or VMS mailbox. For example:

  • SMS

  • Internet mail

The UMS Notification Type dimension helps to organize the notifications data by notification type, along with other dimensions.

NP MOBILE MSISDN

Reference

The mobile MSISDN number of ported number.

NP REQUEST HEADER

Base

The Number Porting (NP) Request submitted by a customer (Porting In) or a recipient operator (Porting Out).

NP REQUEST LINE ITEM

Base

Request Line Item within a Number Porting (NP) request.

NP REQUEST LINE ITEM STATE HISTORY

Base

State history for Number Porting (NP) request line items.

NP REQUEST LINE ITEM STATE TYPE

Lookup

Lookup for type of Number Porting (NP) line item state. For example:

  • Passed

  • Pending

NP REQUEST STATE HISTORY

Base

State history for the Number Porting (NP) request.

NP REQUEST STATE TYPE

Lookup

Lookup for type of state for Number Porting (NP) request. For example:

  • Pre-application

  • Application

  • Document check

NP REQUEST TYPE

Lookup

Lookup for type of Number Porting (NP) Request. For example:

  • Porting In

  • Porting Out

NP STEP

Lookup

Step involved in the Number Porting (NP) request. For example:

  • Application

  • Document check

  • Notify NPAC

NUMBER AREA

Reference

Defines the codes associated to a given area; these codes are typically used for calls to a fixed line number. For example:

  • 1 for Paris (in France)

  • 89 for Munich (in Germany)

Note that a number area could also be associated to other operators, and not to a geographical area. For example, 9 in France.

NUMBER COUNTRY

Reference

Country number. For example:

  • US-01

  • China-86

NUMBER NETWORK TYPE

Lookup

Lookup for available classifications for the network technology, used in relation to subscriptions. For example:

  • in MICA-GCM: CDMA

  • in Flexcab - NTWK, NNSA, WRBL, and so on

NUMBER PORT DAY DRVD

Derived

Aggregation of daily Porting Requests (in/out).

NUMBER PORT MONTH AGGR

Aggregate

Monthly summary of Porting Requests (in/out).


Table 2-27 O to R Entity Descriptions

Entity Name Type Description

ON OFF NET TYPE

Lookup

Lookup of call classifications:

  • On net

  • Off net

OPERATOR GROUP

Lookup

Classification group for operators. For example, the group can be classified as:

  • Global Direct Competing

  • Local Competitor

  • Allied by Stock Share

OPERATOR TYPE

Lookup

Lookup for operator type to classify operators. For example:

  • International

  • Local

International operators normally have multiple subsidiaries whose relationship is modeled in the party relationship.

ORDER LINE ITEM STATE

Reference

Lookup for the status that a given order line item, in a command, can be assigned. For example:

  • Pending

  • Waiting for Customer feedback

  • Closed

  • Started

  • Error

ORDER STATE

Reference

Lookup for the type of Order State. For example:

  • Open / Processing

  • Pending / Waiting for Customer Feedback

  • Pending / Waiting for Internal Feedback

  • Pending / Waiting for Third Party Feedback

  • Error

  • Closed

  • Cancelled

ORDER STATUS

Lookup

Lookup for the type of Order Status. For example:

  • Already Shipped

  • Delivered / Processed

  • Processing

  • Partially Delivered

  • Installed

ORDER TYPE

Lookup

Lookup for type of CUSTOMER ORDER. For example:

  • Order for Pickup

  • Order for Delivery

  • Order for Activation

ORGANIZATION AREA

Reference

An ORGANIZATION HIERARCHY LEVEL within an ORGANIZATION CHAIN. The Organization Area entity is the parent of one or more ORGANIZATION REGIONs.

ORGANIZATION BANNER

Reference

The name of Company, Organization, or subsidiary that is recognizable to the consumer or the name of the store as it appears on the catalog, web channel, or brick and mortar store.

ORGANIZATION BUSINESS ENTITY

Reference

Any logical entity that is recognized as a part of the enterprise for business analysis and transactions. Classification for a business entity can include company, operation unit, store, or warehouse.

ORGANIZATION BUSINESS UNIT

Reference

A business unit of the organization that delivers a limited range of specific communications services or merchandise through any sales channel (Web Site, store, partner stands, and so on). For example, for the SuperTelco example, two Business Units could be defined as:

  • SuperTelco Communications (Mobile)

  • SuperData (Broadband)

ORGANIZATION BUSINESS UNIT COST

Base

Sub-table of COST. This entity associates a specific cost to an ORGANIZATION BUSINESS UNIT (for those costs not covered by EMPLOYEE COST).

ORGANIZATION BUSINESS UNIT TYPE

Lookup

Lookup for type of ORGANIZATION BUSINESS UNIT. For example:

  • Call Center

  • Branch Office

  • Warehouse

ORGANIZATION CHAIN

Reference

An ORGANIZATION HIERARCHY LEVEL within an ORGANIZATION COMPANY. Organization Chain entity is the parent of one or more ORGANIZATION AREAs.

ORGANIZATION COMPANY

Reference

An ORGANIZATION HIERARCHY LEVEL within an ORGANIZATION CORPORATE. Organization Company entity is the parent of one or more ORGANIZATION CHAINs.

ORGANIZATION CORPORATE

Reference

Highest level of ORGANIZATION HIERARCHY. Organization Corporate entity is the parent of one or more ORGANIZATION COMPANYs.

ORGANIZATION DISTRICT

Reference

An ORGANIZATION HIERARCHY LEVEL within an ORGANIZATION REGION. Organization District entity is the parent of one or more ORGANIZATION BUSINESS UNITs.

ORGANIZATION DIVISION

Reference

An ORGANIZATION HIERARCHY LEVEL within ORGANIZATION CORPORATE.

ORGANIZATION HIERARCHY

Reference

User defined. Master list of all of the hierarchies in an organization.

ORGANIZATION HIERARCHY LEVEL

Reference

The association entity for the hierarchies and levels.

ORGANIZATION HIERARCHY LEVEL ASSIGNMENT

Reference

Assignment of Hierarchy Levels to ORGANIZATION HIERARCHY.

ORGANIZATION HIERARCHY VERSION

Reference

Version of ORGANIZATION HIERARCHY.

ORGANIZATION ITEM SELLING PRICE

Reference

Associate selling price to the item. Each organization might have different prices for the same item model.

ORGANIZATION LEVEL

Reference

List of all the business levels within an organization.

ORGANIZATION LEVEL ATTRIBUTE VALUE

Reference

Values for the user defined attributes associated with an ORGANIZATION HIERARCHY LEVEL.

ORGANIZATION LEVEL ATTRIBUTES

Reference

Attributes assigned to an ORGANIZATION LEVEL.

ORGANIZATION MARKET DATA

Reference

Publicly available and statistical information regarding the internal or external parties, such as DUNS number and number of employees.

ORGANIZATION REGION

Reference

An ORGANIZATION HIERARCHY LEVEL within an ORGANIZATION AREA. Organization Region entity is the parent of one or more ORGANIZATION DISTRICTs.

ORGANIZATION SERVICE WEBSITE

Reference

Subtype of the ORGANIZATION BUSINESS UNIT. This entity collects all information on Web sites managed by the operator. This normally includes only public information.

ORGANIZATION WAREHOUSE

Reference

Location in which goods or merchandise (routers, handsets, computers, and so on) are stored but not sold, before they are sent to the shops or utilized by CSP. For example:

  • Chairs

  • Telephone poles

  • Network equipment

  • Auto transmissions

  • Handsets

ORGANIZATIONAL DEMOGRAPHY VALUE

Reference

User defined attribute definitions and corresponding values regarding demographic statistics as related to an ORGANIZATION BUSINESS UNIT.

OTHER INDIVIDUAL

Reference

Individual associated with a PARTY organization, other than those defined such as CUSTOMER or EMPLOYEE.

PARTNER PROMOTION PROGRAM

Reference

Assigns costs of a given PROMOTION to a Partner or PARTY participating in the promotion.

PARTNER SETTLEMENT MONTH AGGR

Aggregate

The monthly summary of financial settlement activities that have happened to partners at higher level.

PARTNER SETTLEMENT DRVD

Derived

Financial settlement activities that have happened to each partner within the month.

PARTNER SETTLEMENT REASON

Lookup

Lookup for valid reason codes for a partner settlement.

PARTY

Reference

A party is a real person, organization, branch, subsidiary, legal entity, holding company, or some other entity. Any real thing that you would want to put a name to is a party.

The attributes of a party are universal. In other words, they are independent of your selling, or ultimately buying relationship with the party.

A party is not necessarily a customer. A party can represent prospects and parts of an ORGANIZATION HIERARCHY, including branches, head offices, corporate conglomerates, that may not necessarily have a billing relationship with the company.

Any party that has an active account can be considered a customer.

Historical information concerning the party is available in the Parties History.

PARTY ACCOUNT ASSIGNMENT

Reference

Assignment of a PARTY to an ACCOUNT. Depending on type of party, the relationship can be:

  • Customer owns the ACCOUNT (typically for individual customers: there is one customer and one account)

  • Multiple Customers may share the same account:

    This type of assignment is typical when several ORGANIZATION BUSINESS UNITs or individuals, association or employees, have, for example, a shared balance of free minutes to use on top of their own package (with their own ACCOUNT).

PARTY ACCOUNT ASSIGNMENT TYPE

Lookup

Lookup for type of relationship between PARTY and ACCOUNT. Depending on type of party, the relationship can be:

  • Customer owns the account

  • Multiple customers may share the same account

PARTY ADDRESS LOCATION ASSIGNMENT

Reference

Associates one or more Addresses with a PARTY.

PARTY AM PMP ASSIGNMENT HISTORY

Base

The assignment history among ACCESS METHOD, PRODUCT MARKET PLAN, and PARTY.

PARTY AM PMP ASSIGNMENT STATUS

Base

The status history of assignment among PARTY, ACCESS METHOD, and PRODUCT MARKET PLAN.

PARTY ASSIGNMENT

Reference

Association of a PARTY with one or more other Parties.

The relationships may include relationships between customers or between customers and the telecommunications operator. An example of the later type of relationship, are account management portfolios where an account manager will have a relationship with one or more customers.

PARTY ASSIGNMENT REASON

Lookup

Lookup for valid reasons parties may be associated with each other. For example:

  • Cooptation (customer brings in a new customer)

  • Financial Responsibility

  • Hierarchical relationship in the organization

  • Contractual agreement

PARTY ASSIGNMENT TYPE

Lookup

Lookup for the type of the party relationship. For example:

  • Father and son

  • Organizational hierarchy, subsidiary

  • Customer referral

PARTY CONTACT INFORMATION

Reference

Contact information for a party.

PARTY CONTACT INFORMATION TYPE

Lookup

Lookup for the type of contact information. For example:

  • Email

  • Home telephone number

  • Office telephone number

  • Cell phone number

  • Pager number

PARTY CONTACT LIST PARTICIPATION

Lookup

Relationship between PARTY and CONTACT LIST. For example, a party belongs to a contact list.

PARTY CONTACT LIST ROLE

Lookup

The Role of the PARTY in a CONTACT LIST.

PARTY CONTRACT ASSIGNMENT

Reference

Assignment of a PARTY to a CONTRACT.

PARTY CONTRACT ASSIGNMENT ROLE

Lookup

Lookup for valid Roles that Parties may be assigned in PARTY CONTRACT ASSIGNMENT.

PARTY CONTRACT ASSIGNMENT TYPE

Lookup

Lookup for type of the PARTY CONTRACT ASSIGNMENT. For example:

  • Customer contract

  • Managing employee

PARTY COST ASSIGNMENT

Base

Assignment of cost items to a PARTY. One party may incur multiple costs. For example, for a customer acquisition the customer might be given any of the following items that lead to costs:

  • Handset

  • Network Device

  • Gifts

Cost might be assigned to multiple parties. For example, for operational cost several organizations may share the same expense on a PROMOTION or CAMPAIGN.

PARTY EVENT TYPE

Lookup

Lookup for valid EVENT TYPEs that may be assigned to a party profile for the various event types that may be actioned against a party.

PARTY GEOGRAPHY ENTITY ASSIGNMENT

Reference

Assigns a PARTY to one or more GEOGRAPHY ENTITYs.

PARTY IDENTIFICATION

Reference

Identifying information unique to a PARTY.

PARTY IDENTIFICATION TYPE

Lookup

Lookup for valid types of PARTY IDENTIFICATION. For example:

  • Driver's License

  • DUNS Number

PARTY INTERACTION THREAD

Base

Grouping of related contact events with a PARTY into a single thread.

PARTY LOCATION REASON

Lookup

Lookup for available reason code and description for why a PARTY may be assigned to an address. For example:

  • Billing address

  • Shipping address

PARTY LOYALTY PROGRAM PARTICIPATION

Reference

Identifies the LOYALTY PROGRAMs that each customer is enrolled in.

PARTY MANAGEMENT ROLE

Lookup

Defines all roles which a party plays in a CAMPAIGN, such as management or potential customer.

PARTY ORDER ASSIGNMENT

Base

Assignment of PARTY to a given Order. For example:

  • Sales Agent gets a sales commission because of a customer order.

  • A customer refers another customer to the operator network. The customer may receive incentives.

PARTY ORDER ASSIGNMENT TYPE

Lookup

Lookup for available assignment type codes and descriptions pertaining to PARTY ORDER ASSIGNMENT. For example:

  • Customer of contract

  • Sales agent for the order

  • Vendor selling the order

PARTY PROMOTION RESPONSE

Base

Response of a PARTY to a PROMOTION.

Records the customers response result to the initiative. For example, positive responses:

  • The customer accepted the offer.

  • The customer increased or modified their usage.

  • The customer changed a specified behavior (for example moved from payment by check to an electronic payment option).

PARTY ROLE

Lookup

Lookup for Roles a PARTY may be assigned in an EVENT.

PARTY ROLE ASSIGNMENT

Reference

Assigns party roles for the party. PARTY and PARTY ROLE are an X-X relationship. This relationship may change due to a contract change, or for other reasons.

PARTY ROLE STATUS

Reference

Status history of each role that a PARTY has taken.

PARTY SEGMENTATION METHOD

Lookup

Method used to create the segment, such as K-means clustering in Data Mining.

PARTY SIM CARD ASSIGNMENT

Reference

The relationship between SIM CARD and PARTY.

PARTY SIM CARD ROLE

Lookup

The role which PARTY add in regards to the SIM CARD.

PARTY STATUS CATEGORY

Lookup

Higher level of Party Status. For example:

  • Financial Status

  • Credit Status

  • Payment Status

  • Personal Status

  • Legal Status

PARTY STATUS CHANGE REASON

Lookup

Lookup for valid reasons that may be assigned for a Party Status change. For example:

  • Hire

  • Transfer

  • New customer

PARTY STATUS HISTORY

Base

Defines current PARTY status history regarding what Operator may be interested.

Historical information captured for all lifetime of the customer or dealer. This information may be calculated from internal data; for example, from a payment, or this information may be obtained from an external source such as a credit rating agency.

PARTY STATUS TYPE

Lookup

Lookup for status type of the PARTY. For example:

  • Active

  • Inactive

  • Defaulted

  • New customer

  • VIP, Loyalty Program, customer

  • Black listed

Credit Class is used to rank Customer Credit. For example, the entity value can be:

  • Good

  • Fair

  • Bad

Or the customer may be defined as:

  • Gold

  • Silver

  • Bronze

The party's credit is based on the underlying accounts held by the party.

PARTY SUBSCRIPTION ASSIGNMENT

Reference

Defines a PARTY's relationship to a SUBSCRIPTION. For example: a customer owns a subscription.

PARTY SUBSCRIPTION ROLE

Lookup

Lookup for valid Roles that may be assigned to PARTY in regards to the SUBSCRIPTION.

PARTY TYPE

Lookup

Lookup for party type that classifies involved parties according to their inherent characteristics and structure. For example:

  • Person

  • Organization

  • Organization Unit

PAY CATEGORY

Lookup

Lookup for type of pay category on a pay slip. For example:

  • Salary

  • Deductions

  • Contributions

  • Taxes

PAY TV

Reference

Subtype of PRODUCT. Pay TV is subscription-based product to deliver TV channels to a customer.

PAY TYPE

Lookup

Lookup for the type of payment made to the employee. For example:

  • Bonus

  • Basic wages

PAYMENT AGING DAY DRVD

Derived

Customer Debt aging results for a DAY. Customer Debt is assigned to a predefined AGE BAND.

PAYMENT AGING MONTH AGGR

Aggregate

Monthly summary of customer debt aging.

PAYMENT CHANNEL

Reference

Channel by which customer may pay for service. For example:

  • Bank (automatic payment)

  • Store (Check, cash)

  • Call Center (Credit Card)

  • Web (Credit Card)

PAYMENT METHOD TYPE

Lookup

Lookup for valid methods of payment. For example:

  • Cash

  • Check

  • Credit Card

  • Debit Card

PAYMENT TRANSACTION TYPE

Lookup

Lookup for type codes and descriptions for transaction types associated with the Account Payment. The payment may be, for example:

  • Periodically Invoice

  • Installation Fee

  • Pre-deposit to the account

  • Late Pay Penalty Payment

  • Regular Monthly

  • Refund / Void

PCU OUTAGE REASON

Lookup

Lookup for reasons for a Packet Control Unit (PCU) outage in GPRS technology. For example:

  • Link Down

  • Bit Error Rate

PEAK OFFPEAK TIME

Lookup

The definition of the time slots is usage dependent, but it is not common for all the products/packages. The time hours (Peak, off-peak, and night) can be different for different packages. The definition also varies for the following:

  • Normal Day

  • Holiday

  • Friday

  • Sunday

For the special days defined in the system.

PERIOD TO DATE TRANSFORMATION

Reference

Cumulative time transformations at the period level.

PERIOD TRANSFORMATION

Reference

Time transformations at the period level.

PLANNING PERIOD

Reference

Period level in the planning calendar.

PLANNING QUARTER

Reference

Quarter level in the planning calendar.

PLANNING SEASON

Reference

Season level in the planning calendar.

PLANNING WEEK

Reference

Week level in the planning calendar.

PLANNING YEAR

Reference

Year level in the planning calendar.

PMP ORGANIZATION AVAILABILITY

Reference

Reference for available PRODUCT MARKET PLAN subscriptions in an ORGANIZATION BUSINESS UNIT (store, outlet, and so on).

POSTAL SERVICE TYPE

Lookup

Lookup for type of postal service type available to the carrier. For example:

  • First-Class Mail

  • Registered Mail

  • Regular Mail

  • Postal Card

POSTCODE

Reference

Postal Code, Zip Code, or similar geographical designation.

POSTPAID WIRELESS

Reference

Subtype of PRODUCT for postpaid wireless.

PPA CATEGORY

Lookup

Lookup for categorizations of prepaid allowances. For example:

  • Local Call Allowance

  • Long Distance Call Allowance

  • Bonus Free Minutes

  • Internal (Inside Operators network) Call Allowance

PPA DEDUCTION TYPE

Lookup

Lookup for valid deduction types as related to prepaid allowances (PPA).

PREPAID ACCOUNT STATISTIC DRVD

Derived

Monthly aggregation of prepaid account revenue, including: air time, recharge value and so on, by ACCOUNT, SALES CHANNEL, AGE ON NET BAND.

PREPAID ACCOUNT STATISTIC SEGMENT AGGR

Aggregate

Monthly summary of prepaid account revenue, including: air time, recharge value, and so on, by CUSTOMER SEGMENT, PRODUCT MARKET PLAN.

PREPAID ALLOWANCE DAY DRVD

Derived

Daily aggregate of free minutes allowance (PPA) for ACCOUNT and PRODUCT MARKET PLAN.

PREPAID ALLOWANCE MONTH AGGR

Aggregate

Monthly summary of free minutes allowance (PPA) in a PRODUCT MARKET PLAN.

PREPAID CALL SUMMARY DAY DRVD

Derived

Daily aggregate of prepaid calls by ACCOUNT, PRODUCT MARKET PLAN, and ACCESS METHOD.

PREPAID CALL SUMMARY MONTH AGGR

Aggregate

Monthly summary of prepaid call activity by PRODUCT MARKET PLAN, CUSTOMER TYPE.

PREPAID MOBILE EVENT TYPE

Lookup

Lookup for the prepaid mobile event types that may be actioned against a prepaid mobile subscription. The specific event types are implementation specific. For example:

  • Initial activation

  • Recharges

  • Adjustments

  • Deactivations

PREPAID MOBILE VOUCHER

Reference

Represents each prepaid card. The cards are a means of recharging prepaid mobiles. The card can be physically a Plastic Card or a paper slip with account number and pin code.

PREPAID RECHARGE

Base

Type of ACCOUNT PAYMENT in which a PREPAID MOBILE VOUCHER is recharged.

PREPAID VOUCHER

Reference

The voucher a customer can buy to refill their prepaid account, normally in the form of a paper or plastic card. For example:

  • Prepaid Mobile Recharge Voucher

  • Prepaid Calling Card

PREPAID WIRELESS

Reference

Type of Service Product. Subtype of SERVICE, for Prepaid Wireless service only.

PRICE DERIVATION RULE

Reference

The specification of a method to be used to transform the current sell unit retail amount to the price charged to account based on a discount group.

PRODUCT

Reference

The product provided by the carrier. Product includes PRODUCT PACKAGE information. The composition of a PRODUCT PACKAGE is tracked in the product relationship.

PRODUCT ADDITIONAL TEXT

Reference

Additional descriptive text for a given product, that cannot fit in any other existing attributes, or that should be customized for users with different languages.

PRODUCT ASSIGNMENT

Reference

Defines a relationship between a PRODUCT and a related product.

PRODUCT ASSIGNMENT REASON

Lookup

Lookup for valid reason codes and descriptions for PRODUCT ASSIGNMENT.

PRODUCT CAPABILITY

Reference

Various product capabilities, or features. For example:

  • Number of lines for a phone

  • Storage size for Email

  • Number of "Friends&Family" numbers

PRODUCT CAPABILITY TYPE

Lookup

Lookup for type of PRODUCT CAPABILITY.

PRODUCT CAPABILITY VALUE

Reference

Detailed PRODUCT CAPABILITY information. The information would be quantitative by PRODUCT CAPABILITY TYPE.

PRODUCT CHARGE TYPE

Lookup

Lookup for type codes and descriptions for PRODUCT PACKAGE charge on a PRODUCT. For example:

  • One time charge

  • Usage duration charge

  • Usage per call charge

  • Usage amount charge (data transfer)

  • Monthly cycle forward fee

  • Monthly cycle arrear fee

  • Free unit charge

  • Free charge

  • Factorization (call charge* a factor)

PRODUCT CHARGE TYPE RELATIONSHIP

Reference

Assignment of related PRODUCT CHARGE TYPEs.

PRODUCT CHARGE TYPE RLTN REASON

Lookup

Lookup for available reasons for PRODUCT CHARGE TYPEs to be related to each other.

PRODUCT CHARGING REASON

Lookup

Lookup for available reasons for Product Charge in the PRODUCT RATING PLAN. For example:

  • Charge for Roaming

  • Charge for Long-Distance

  • Charge or For Local Call

  • Regular Fee

PRODUCT COST

Base

Sub-table of the COST TYPE table, used to associate a specific cost to a given product.

PRODUCT FEATURE

Reference

Available features that may be associated with one or more PRODUCTs. For example, for a handset there are features such as:

  • MP3 indicator

  • MIDIindicator

  • 3G indicator

  • JAVA indicator

  • GSM 1800 indicator

PRODUCT FEATURE ASSIGNMENT

Reference

Assigns one or more PRODUCT FEATUREs to a PRODUCT. Multiple products may have the same PRODUCT FEATUREs.

PRODUCT FUNCTIONALITY DEPENDENCY

Reference

Assignment of valid EQUIPMENT FUNCTIONALITY and PRODUCT VERSIONs to a PRODUCT.

PRODUCT GEOGRAPHY ASSIGNMENT

Reference

Assigns a PRODUCT to a GEOGRAPHY ENTITY. This is particularly used for products offered only locally or in a limited region. For example: "Broadband Service" in specific cities and ZIP code areas (typically used for City carriers).

PRODUCT GROUP

Lookup

Categorizations or Groups into which PRODUCTs may be assigned, usually based on similar functionality.

Note: this is different and should not be confused with the PRODUCT MARKET PLAN GROUP entity.

For example, the customer may group product in categories such as:

  • Postpaid Wireless

  • Prepaid Wireless

  • Fixed Line Subscription

  • Calling Card

  • Pay TV

  • Broadband

PRODUCT GROUP ASSIGNMENT

Reference

Defines relationship of PRODUCT and one or more PRODUCT GROUPs.

PRODUCT GROUP TYPE

Lookup

Lookup for codes and descriptions of types of PRODUCT GROUPs.

PRODUCT INSTANCE

Reference

The real instance of a given PRODUCT which a customer can purchase or rent (or eventually gets for free as part of a PRODUCT MARKET PLAN). The product instance is linked to the Customer Order Line Item and relates a product to a customer. For example:

  • Song specified as "You are not alone": Corresponding to Product MUSIC DOWNLOAD

  • TV channel specified as "Discovery" - Corresponding to Product PAY TV

PRODUCT MANAGEMENT HISTORY

Base

Defines relationship between EMPLOYEE, PRODUCT MANAGEMENT ROLE, and PRODUCT.

PRODUCT MANAGEMENT REASON

Lookup

Lookup for available reasons for a PRODUCT MANAGEMENT HISTORY relationship.

PRODUCT MANAGEMENT ROLE

Lookup

Lookup for valid role codes and descriptions an employee may be assigned in PRODUCT MANAGEMENT HISTORY. For example:

  • Product Creation role

  • Publication to the market (in/out) role

  • Product Version Update role

  • Product Testing role

PRODUCT MARKET PLAN

Reference

Defines how a product is brought to the market, including: positioning, pricing, and bundling details. For example:

  • Tariff Liberty 60, with 60 Free National Minutes, 3 Friends & Family Network Intern Numbers

  • DSL 32Mbit/s + VoIP Phone + TV Entertainment + Pay TV Soccer Championship one year promotion

PRODUCT MARKET PLAN ASSIGNMENT

Reference

Assigns Products to PRODUCT MARKET PLANs.

PRODUCT MARKET PLAN ASSIGNMENT TYPE

Lookup

Lookup for type of product participation (inclusion) in the market plan. For example:

  • Use as gift

  • Main product

  • Revenue generation service

  • Base on

PRODUCT MARKET PLAN COST

Base

Sub-table of the COST TYPE table. This entity associates a specific cost to a given PRODUCT MARKET PLAN. Note that the cost should not be related to the CAMPAIGN or to the PROMOTION, but just to the PRODUCT MARKET PLAN.

PRODUCT MARKET PLAN GEOGRAPHY ASSIGNMENT

Reference

Relationship between PRODUCT MARKET PLAN and Geography. Some PRODUCTs may only be sold in a particular area.

PRODUCT MARKET PLAN GROUP

Reference

Hierarchy level to group the various PRODUCT MARKET PLANs. For example:

  • Postpaid "Family"

  • Broadband "Business Unlimited"

  • Prepaid "Freedom"

PRODUCT MARKET PLAN GROUP ASSIGNMENT

Reference

Defines relationship of PRODUCT MARKET PLANs to one or more PRODUCT MARKET PLAN GROUPs.

PRODUCT MARKET PLAN GROUP TYPE

Lookup

Lookup for the type code and description for a PRODUCT MARKET PLAN GROUP.

PRODUCT MARKET PLAN TYPE

Lookup

Type of the PRODUCT MARKET PLAN. For example:

  • Prepaid Wireless

  • Postpaid Wireless

  • VAS Special Package

PRODUCT NETWORK ASSIGNMENT

Reference

Assigns a PRODUCT to one or more NETWORKs.

PRODUCT PACKAGE

Reference

Groups of PRODUCTs bundled to serve as basis of a PRODUCT MARKET PLAN. The product package is not customer facing and a customer should subscribe to a product package through the PRODUCT MARKET PLAN. For example:

  • Tariff Liberty 60, Wireless phone, 3 Friends & Family Network Intern Numbers

  • DSL 32Mbit/s + VoIP Phone + TV Entertainment + Pay TV Soccer Championship

PRODUCT PACKAGE ASSIGNMENT

Reference

Assigns PRODUCT(s) to a PRODUCT PACKAGE.

PRODUCT PACKAGE CHARGE TYPE

Lookup

Lookup for type codes and descriptions for PRODUCT PACKAGE charge on a PRODUCT. For example:

  • One time charge

  • Usage Duration charge

  • Usage per Call charge

  • Usage amount charge (Data transfer)

  • Monthly Cycle Forward Fee

  • Monthly Cycle Arrear Fee

  • Free Unit Charge

  • Free Charge

PRODUCT RATING PLAN

Reference

Grouping mechanism for prices and usage limits associated with a PRODUCT.

PRODUCT RATING PLAN DETAIL

Reference

Detail of PRODUCT RATING PLAN, defines prices and usage limits for each PRODUCT CHARGE TYPE.

PRODUCT RATING PLAN TYPE

Lookup

Lookup for the type of PRODUCT RATING PLAN.

PRODUCT STATUS HISTORY

Base

Status history of PRODUCT.

PRODUCT STATUS TYPE

Lookup

Lookup for the type of the product status.

PRODUCT TYPE

Lookup

Lookup for the type of the PRODUCT. For example:

  • Item

  • Service

PRODUCT VERSION

Reference

Iteration of a PRODUCT created when a minor change is made to the PRODUCT setting that does not require creating a new PRODUCT.

PROMOTION

Reference

The promotion reflects the tactics that an operator undertakes to generate increased incremental sales or usage volume for a specific product within a promotional event. Promotions are frequently communicated as part of a marketing campaign to ensure that awareness is generated with the target audience.

PROMOTION CLUSTER USAGE

Base

Assigns a particular CUSTOMER SEGMENT, cluster, to a given PROMOTION or list of promotions. The customer segments are generated by certain analytic applications, including Oracle Mining, and this assignment tracks the usage of customer segments in the PROMOTION.

PROMOTION CONTACT LIST UTILIZATION

Base

Defines the relationship between a CONTACT LIST and a PROMOTION: the contact list has been used for a marketing campaign to which a specific promotion was proposed.

PROMOTION COST

Base

Subtype of the COST, which is used to associate a specific cost uniquely associated to a given promotion. For example, a rent fee for the location where the operator performs the promotion.

PROMOTION MANAGEMENT HISTORY

Base

A history of campaign party role about management of a campaign EPISODE.

PROMOTION MARKET PLAN ASSIGNMENT

Reference

Associates a market plan to a PROMOTION. Typically, this applies when a given market plan is offered with an additional discount (PROMOTION) during a certain period.

PROMOTION MESSAGE RENDERING

Reference

Details regarding each CAMPAIGN MESSAGE broadcast through a MEDIA OBJECT.

PROMOTION RESULT TYPE

Lookup

Lookup for the prospect reaction to a specific PROMOTION during a sales campaign. For example:

  • Accepted

  • Not interested

  • Interested but not accepted

  • Not Interested but other product sold

PROMOTION TERM TYPE

Lookup

Lookup for valid type codes and descriptions of Promotion Term associated with a PROMOTION TERM VALUE. For example:

  • Number of customers

  • Period

  • Planning

  • Selling amount

  • Planning contracts number

PROMOTION TERM VALUE

Base

Assigns PROMOTION TERM TYPE to a PROMOTION with a value corresponding to the Term Type. For example:

  • Maximum Number of customers

  • Period

  • Planning selling amount

  • Planning contracts number

PROMOTION TYPE

Lookup

Lookup for the type of PROMOTION (each for either a limited time or for the contract duration). For example:

  • Monthly Fee Discount

  • Additional Free Service

  • Free Installation Cost

  • Give-away Equipment

  • Free Equipment Rental

  • Limited Extra Usage for Free

PROSPECT

Reference

An individual, collection of individuals, company, or public institution that does not currently purchase merchandise or services, but who may in the future. A prospect may also be a CUSTOMER of one PRODUCT (already purchased) that does not currently purchase another PRODUCT (may purchase).

A prospect has no recorded relationship with the provider.

PROSPECT INDIVIDUAL

Reference

Attributes of an individual prospect, one who is not an organization.

PROSPECT ORGANIZATION

Reference

Attributes of a prospect organization.

PTV FULL CHANNEL ACTIVATION

Base

Pay TV full channel activation event.

PTV QPI SERVICE EVENT

Base

The detail of QPI service.

PTV USAGE EVENT

Base

Customer usage of PAY TV service.

PUBLICATION

Reference

Publication to which the MEDIA OBJECT used in CAMPAIGN belongs.

PUBLICATION TYPE

Lookup

Lookup for code and description describing the type of publication.

QUARTER HOUR

Reference

Quarter Hour as defined in Time Hierarchy.

QUARTER TO DATE TRANSFORMATION

Reference

Cumulative time transformations at the quarter level.

QUARTER TRANSFORMATION

Reference

Transformation with respect to a quarter. For example:

  • This quarter last year

  • This year last quarter

RATING METHOD TYPE

Lookup

Lookup for Rating Method Type code and description. For example:

  • Flat Rate

  • Tier Rating

  • Threshold Rating

RECHARGE REVENUE SLAB

Lookup

Lookup for the bands of revenue earned from the sale of recharge coupons, for prepaid, which is called recharge revenue. The recharge revenue is to be analyzed for all currently active prepaid subscribers and for all churned subscribers until the time of termination.

For example, the revenue can be banded by creating slabs for recharge revenue of $0-$25, $25-$50, and so on.

REDEMPTION DAY DRVD

Derived

The daily aggregate of loyalty point redemption by CREDIT CATEGORY, LOYALTY PROGRAM CHANNEL, AGE ON NET BAND, and EMPLOYEE.

Daily aggregation of LOYALTY PROGRAM redemption statistics by LOYALTY PROGRAM CHANNEL, SALES CHANNEL, AGE ON NET BAND, CREDIT CATEGORY, and EMPLOYEE.

REDEMPTION MO AGGR

Aggregate

Monthly summary of LOYALTY PROGRAM redemption statistics by LOYALTY PROGRAM CHANNEL

REDEMPTION TYPE

Lookup

Lookup for redemption type that maintains all possible point redemption types and organizes redemption data by redemption type for analysis purposes.

RETAIL STORE

Reference

Subtype of internal organization. This usually lists the shops where the communications service provider presents the products and sells directly to customers. Note that a retail store may contain several SELLING LOCATIONs.

RF CARRIER

Reference

Reference list of all wireless or Radio Frequency (RF) carriers.

RF NETWORK CAPACITY DAY DRVD

Derived

Daily aggregate of Radio Frequency (RF) Network Capacity utilization statistics.

Radio Frequency (RF) interfaces are present at two levels in the network:

  • RF Interface between CELL and the Mobile Station

  • RF interface between MSC and the BSS

RF NETWORK CAPACITY MONTH AGGR

Aggregate

Monthly summary of Radio Frequency (RF) Network Capacity utilization statistics.

RINGTONE

Reference

Sub-table of SUPPLEMENTARY SERVICE, by which a customer can download music as a ringtone for the phone.

ROAMING TYPE

Lookup

Lookup for the various roaming types to classify the calls. For example:

  • (Standard) Outgoing Roaming

  • (Standard) Incoming Roaming

  • Inland Outgoing Roaming

  • Inland Incoming Roaming

ROLES HIERARCHY

Reference

Hierarchy among the job roles within an organization.

ROUTING DEVICE

Reference

In IN Network or Wireless, many different type of devices such as VLR, HLR, SCP servers are utilized in network to decide the call routing. This entity tracks the device information.


Table 2-28 S to V Entity Description

Entity Name Type Description

SALES CAMPAIGN SUMMARY DAY DRVD

Derived

Daily aggregate of campaign results by PROMOTION RESULT TYPE and Sales Campaign Client Code.

SALES CAMPAIGN SUMMARY MONTH AGGR

Aggregate

Monthly summary of Sales Campaign results by PRODUCT MARKET PLAN, CAMPAIGN CHANNEL, PROMOTION RESULT TYPE.

SALES CHANNEL

Reference

Channel used to communicate with parties for sales purposes. For example:

  • Representatives

  • Partner-Dealers

  • Direct Dealers

Sales channels are represented by the channel level, which also becomes the lowest level for the channel dimension.

SALES CHANNEL REPRESENTATIVE

Reference

The sales representative who sells the product to the customer. For example:

  • Sales Representative in the operator owned shops.

  • Direct sales representatives in the call center.

  • Dealer for a partner.

SALES COMMISSION DETAIL

Base

The sales commission earned by sales agent because of the contract.

SALES COMMISSION PAYROLL

Base

The sales commission issued to the sales agent.

SALES COMMISSION PLAN

Reference

The sales commission plan for particular PRODUCT PACKAGE and sales agent level.

SALES COMMISSION PLAN DETAIL

Reference

Details about the SALES COMMISSION PLAN per PRODUCT MARKET PLAN and PROMOTIONs, including sales quota and commission rate.

SALES DAY DRVD

Derived

Daily aggregate of sales by SALES CHANNEL, PRODUCT MARKET PLAN, business unit, sales representative, CUSTOMER.

SALES MONTH AGGR

Aggregate

Monthly summary of sales by SALES CHANNEL, PRODUCT MARKET PLAN, business unit, sales representative.

SALES REPRESENTATIVE STATISTICS DRVD

Derived

Monthly summary of sales representative performance measured by sales, commission, and so on.

SCRIPT

Reference

A list of specific groupings of questions or statements presented to individuals during a survey.

SCRIPT QUESTION

Reference

Initiative questions documents the questions asked of the customer as part of the initiative.

SCRIPT QUESTION TYPE

Lookup

The domain of values used to group script items. For example:

  • 1 = Yes or No answers

  • 2 = Provide a Value

  • 3 = Give a Range

  • 4 = Free form answer

SEASON

Lookup

Seasons and their attributes. Seasons are arbitrary periods around which some providers organize their buying and selling patterns. Each day should fall within no more than one season.

SECOND

Reference

Second hierarchy level as defined in Time Hierarchy.

SECURITY REQUIRED TYPE

Lookup

Lookup for type and description of security requirements that may be associated with an ITEM.

SEGMENT CRITERIA

Reference

Minimum and Maximum scores for each segment associated with an ACCOUNT SEGMENT or CUSTOMER SEGMENT.

SEGMENT TYPE

Lookup

Lookup for type codes and descriptions used to define ACCOUNT SEGMENTATION MODEL or CUSTOMER SEGMENTATION MODEL.

SELLING LOCATION

Reference

Physical location in a RETAIL STORE specifically dedicated to selling or displaying merchandise.

SELLING LOCATION TYPE

Lookup

Lookup for type code and description used to define a SELLING LOCATION: For example:

  • Store

  • Floor

  • Aisle

  • Shelf

SERVICE

Reference

A subtype of PRODUCT for all types of telecommunications services.

SERVICE CLASS

Lookup

The class of the services. For QoS reason, the call can be divided into different classes (Basically might be home line or business line, or others). It can also be divided by other aspect, line utilizing Circuit Line or IP packets, and so on.

SERVICE CLASS TYPE

Lookup

Lookup for the type or base to define the SERVICE CLASS.

SERVICE COVERAGE AREA

Reference

The geographic area covered by service provider with certain product combination.

Service areas are defined so that service providers can determine the demographic / psychographic / population data the geography served by the network.

SERVICE COVERAGE AREA TYPE

Lookup

Lookup for type code and description for SERVICE COVERAGE AREA.

SERVICE COVERAGE GEO DETAIL

Reference

The detail about service coverage on lowest level. For example:

  • Areas covered by a specific BTS

  • Building covered by Broadband Copper line or Fiber line.

SERVICE EQUIPMENT ASSIGNMENT

Reference

Assignments between NETWORK TOUCHPOINT, EQUIPMENT, and SERVICE according to which SERVICE was tied to which NETWORK TOUCHPOINT through which EQUIPMENT INSTANCE.

SERVICE REQUEST

Base

Subtype of PARTY INTERACTION THREAD, specifically dedicated to a service request that may trigger a customer field service support order.

SET TOP BOX

Reference

Set-top box for Television service.

SET TOP BOX MODEL

Reference

Set-top box model specification.

SHARED PACKAGE USAGE STATISTICS DAY DRVD

Derived

Daily aggregate of Lines Count by PRODUCT MARKET PLAN. For example:

  • Family 1+1

  • Corporate Package

SHARED PACKAGE USAGE STATISTICS MO AGGR

Aggregate

Monthly summary of Lines Count by PRODUCT MARKET PLAN. The usage and profitability is analyzed in this entity. For example:

  • Family 1+1

  • Corporate Package

SHOP EFFICIENCY DAY DRVD

Derived

Daily aggregate of shop efficiency details including customer and transaction counts, wait times, and so on, by ORGANIZATION BUSINESS UNIT and GEOGRAPHY REGION.

SHOP EFFICIENCY MONTH AGGR

Aggregate

Monthly summary of shop efficiency details including customer and transaction counts, wait times, and so on, by ORGANIZATION BUSINESS UNIT and GEOGRAPHY REGION.

SIC ASSIGNMENT

Reference

Assigns one industry to another industry in Standard Industrial Classification (SIC).

SIC ASSIGNMENT REASON

Lookup

Lookup for reason codes and descriptions that describe why two industries are assigned in the Standard Industrial Classification (SIC).

SIC CLASSIFICATION

Lookup

A classification group for Standard Industrial Classification (SIC). For example:

A. Division A: Agriculture, Forestry, And Fishing:

  • Major Group 01: Agricultural Production Crops

  • Major Group 02: Agriculture Production Livestock and Animal Specialties

  • Major Group 07: Agricultural Services

  • Major Group 08: Forestry

  • Major Group 09: Fishing, Hunting, and Trapping

SIC DIVISION

Reference

The base level of SIC classification. For more information see SIC CLASSIFICATION.

SIC INDUSTRY GROUP

Lookup

The middle level of the industry classification hierarchy.

SIM CARD

Reference

A subscriber identity module (SIM) on a removable SIM card securely stores the service-subscriber key (IMSI) used to identify a subscriber on mobile telephony devices (such as a mobile phone).

Also used for UIM (User Identity Module) in the CDMA (Code Division Multiple Access) network.

SIM CARD ACCESS METHOD ASSIGNMENT

Reference

A history of relationship between ACCESS METHOD and SIM CARD. Many access methods can be assigned to one SIM Card at any given time.

SIM CARD ACCESS METHOD REASON

Lookup

Lookup for valid reason codes and descriptions to describe relationship between SIM CARD and ACCESS METHOD.

SIM CARD ACTIVATION REASON

Lookup

Lookup for valid reason codes and descriptions describing why a SIM CARD has been activated.

SIM CARD ACTIVATION TYPE

Lookup

Usage states that a SIM CARD may be in. For example:

  • PP: Pre-Provisioned

  • BU: Barred from Usage

SIM CARD HANDSET ASSIGNMENT

Reference

A history of relationship between a HANDSET INSTANCE and a SIM CARD. SIM Cards can be swapped between handsets.

SIM CARD SUBSCRIPTION ASSIGNMENT

Reference

A history of relationship between the SIM CARD and a SUBSCRIPTION.

SIM CARD SUBSCRIPTION REASON

Lookup

A reason why a SIM CARD is associated with a SUBSCRIPTION.

SIM CARD TYPE

Lookup

Lookup for the types of SIM CARD. For example:

  • 16k

  • 32k

  • 64k

  • 128k

SMS

Reference

Subtype of VALUE ADDED SERVICE. This entity defines the information relative to the Short Message Service (SMS). Do not confuse this entity with SMS EVENT.

SMS EVENT

Base

Subtype of NETWORK EVENT, which collects all information of product usage of Short Message Service (SMS).

SMS RATING PLAN

Reference

Subtype of PRODUCT RATING PLAN, reserved for Short Message Service (SMS), and also Multimedia Messaging Service (MMS), service.

SOC JOB

Reference

Entity holds the most detailed level of Standard Occupational Classification (SOC) job classification. For example:

  • 15-0000 Computer and Mathematical Occupations

  • 15-1000 Computer Specialists

  • 15-1010 Computer and Information Scientists, Research

  • 15-1011 Computer and Information Scientists, Research

  • 15-1020 Computer Programmers

  • 15-1021 Computer Programmers

  • 15-1030 Computer Software Engineers

  • 15-1031 Computer Software Engineers, Applications

  • 15-1032 Computer Software Engineers, Systems Software

  • 15-1040 Computer Support Specialists

  • 15-1041 Computer Support Specialists

SOC JOB CATEGORY

Reference

Lookups for the categories in the Standard Occupational Classification (SOC) in which each occupation in the SOC is placed. The hierarchy in SOC is typically: NN-MMM0. These job categories correspond to the 449 "broad occupations" or categories. For example:

  • 13-2010 Accountants and Auditors

  • 13-2020 Appraisers and Assessors of Real Estate

  • 13-2030 Budget Analysts

  • 13-2040 Credit Analysts

  • 13-2050 Financial Analysts and Advisors

  • 13-2060 Financial Examiners

SOC JOB GROUP

Reference

Lookups for the groups in the Standard Occupational Classification (SOC) in which each occupation in the SOC is placed. The hierarchy of SOC is typically: NN-MM00. For example:

  • 13-1000 Business Operations Specialists

  • 13-2000 Financial Specialists

SOC JOB MAJOR GROUP

Reference

Lookups from the (23) major groups in the Standard Occupational Classification (SOC) in which each occupation in the SOC is placed. The hierarchy of SOC is typically: NN-0000. For example:

  • 11-0000 Management Occupations

  • 13-0000 Business and Financial Operations Occupations

  • 15-0000 Computer and Mathematical Occupations

  • 17-0000 Architecture and Engineering Occupations

  • 19-0000 Life, Physical, and Social Science Occupations

  • 21-0000 Community and Social Services Occupations

  • 23-0000 Legal Occupations

SOURCE SYSTEM

Reference

System of record from which information was loaded.

SOURCE SYSTEM KEY MAPPING

Reference

Track Key of the PARTY, customer or employee, in the originating source system. This key can track information back to the source management system.

SOURCE SYSTEM TYPE

Lookup

Lookup for type code and description used to describe SOURCE SYSTEM. For example:

  • Competitor Customer Listing

  • Third-Party Purchased Mailing List

  • CRM List

  • Billing System List

SUBSCRIBER ACTIVATION REASON

Lookup

Lookup for valid Subscriber activation code and reasons used to describe Subscriber Activation. For example:

  • Reactivate because of paying

  • Deactivate by non-paid

SUBSCRIBER CHURN STATISTIC MONTH AGGR

Aggregate

Monthly summary of Subscriber Churn by PRODUCT, PRODUCT MARKET PLAN, CUSTOMER TYPE, GEOGRAPHY ENTITY, ORGANIZATION BUSINESS UNIT.

SUBSCRIBER CHURN STATISTIC MONTH DRVD

Derived

Monthly aggregate of Subscriber Churn information by ACCOUNT, PRODUCT MARKET PLAN, SALES CHANNEL, AGE BAND, AGE ON NET BAND, CREDIT CATEGORY, DEBT AGING BAND, CUSTOMER REVENUE BAND, ARPU BAND, CUSTOMER.

SUBSCRIPTION

Reference

The record of customer using a product or service which may be based on a contract. Customer's subscription to services is the basis of billing and network usage authorization.

SUBSCRIPTION ASSIGNMENT

Reference

Relational assignment of one SUBSCRIPTION to another SUBSCRIPTION. This is optional.

SUBSCRIPTION ASSIGNMENT TYPE

Lookup

Lookup for type codes and descriptions pertaining to SUBSCRIPTION ASSIGNMENT.

SUBSCRIPTION EVENT TYPE

Lookup

Lookup for available type codes and descriptions for Subscription Events.

SUBSCRIPTION PMP ASSIGNMENT

Reference

The relationship between SUBSCRIPTION and PRODUCT MARKET PLANs. A SUBSCRIPTION may be reassigned to different PRODUCT MARKET PLANs during its lifetime.

SUBSCRIPTION SERVICE CLASS ASSIGNMENT

Reference

Defines the class of service for a SUBSCRIPTION.

SUBSCRIPTION STATUS

Lookup

Lookup for available code and description for the status of a SUBSCRIPTION. For example:

  • Active

  • Inactive

SUBSCRIPTION STATUS CATEGORY

Lookup

Lookup for category codes and descriptions used to group or categorize SUBSCRIPTION STATUS.

SUBSCRIPTION STATUS HISTORY

Base

A history of the status of a SUBSCRIPTION. For example:

  • Active

  • Inactive

  • Defaulted

  • Terminated

The subscription can simultaneously contain multiple status. For example, the subscription could be Active and In_Debt, or amount below threshold.

SUBSCRIPTION STATUS REASON

Lookup

Lookup for available reason codes and descriptions for defining why a SUBSCRIPTION may be assigned a status.

SUBSCRIPTION TERM TYPE

Lookup

Lookup for available type codes and descriptions pertaining to SUBSCRIPTIONs and PRODUCTs to which Values may be assigned. For example:

  • Monetary Amount

  • Period

  • Premium

  • Initial Points

  • Cancellation Policy

SUBSCRIPTION TERM VALUE

Base

Value assignments for Subscription Terms as pertains to a SUBSCRIPTION and PRODUCT. For example:

  • Monetary amount

  • Period

  • Premium

  • Initial points

The value can vary at different time periods. For example, the monthly fee might be 100 for first six months, and 80 for last six months. A penalty calculation can also be assigned based on the months left in a contract.

SUBSCRIPTION TYPE

Lookup

Lookup for available type codes and descriptions for SUBSCRIPTIONs. For example:

  • Prepaid Wireless

  • Fixed Line

  • Broadband

SUBSIDY AMOUNT MONTH AGGR

Aggregate

Monthly summation of the amount budgeted for the items to be given on subsidy by PRODUCT MARKET PLAN, and CUSTOMER TYPE, excluding the NVP scheme items and give-away items.

SUBSIDY AMOUNT DRVD

Derived

Monthly aggregation of the amount budgeted for the items to be given on subsidy by PRODUCT MARKET PLAN and CUSTOMER TYPE, excluding the NVP scheme items and give-away items.

SUBSIDY TYPE

Lookup

Lookup for type code and description of a Subsidy.

SUPPLEMENTARY SERVICE

Reference

Subtype of PRODUCT that may include supplementary services to complement and support existing services such as telephone and data services. For example:

  • Call forwarding

  • Barring of Outgoing Calls

  • Barring of Incoming Calls

  • Advice of Charge (AoC)

  • Call Hold

  • Call Waiting

  • Multi-party service

  • Calling Line Identification presentation/restriction

  • Closed User Groups (CUGs)

  • Explicit Call Transfer (ECT)

SUPPLEMENTARY SERVICE USAGE MONTH AGGR

Aggregate

Monthly summation of Charge and Billing details for SUPPLEMENTARY SERVICE usage by Business Unit, PRODUCT MARKET PLAN, and PRODUCT.

SUPPLEMENTARY SERVICE USAGE MONTH DRVD

Derived

Monthly aggregation of Charge and Billing details for SUPPLEMENTARY SERVICE usage by Business Unit, Billing Status Type, PRODUCT MARKET PLAN, and PRODUCT.

SWITCH

Reference

Network switches or exchanges. A switch may be a PSTN (wireline) digital or analog, or a GSM Mobile Station controller (wireless).

SWITCH CAPABILITY

Reference

Lookup for capabilities that may be assigned to a SWITCH TYPE.

SWITCH CAPABILITY TYPE

Lookup

Lookup for type codes and descriptions used to categorize SWITCH CAPABILITY.

SWITCH COMMAND

Reference

Command which is sent to the switch, telling it to take an action. For example, activate a port with specified parameters.

SWITCH ROUTING DEVICE ASSIGNMENT

Reference

Assigns a routing device to a switch in any type of network.

SWITCH TYPE

Lookup

Classification of Switch Type and Manufacturer.

TARGET ACCESS METHOD

Reference

The ACCESS METHODs associated with a PROMOTION.

TARGET ACCOUNT

Reference

ACCOUNTs targeted by a PROMOTION.

TARGET CONTRACT

Reference

CONTRACTs targeted by a PROMOTION.

TARGET GEOGRAPHY AREA

Reference

GEOGRAPHY ENTITYs targeted by a PROMOTION.

TARGET TYPE

Lookup

Lookup for valid Type codes and descriptions as pertain to a PROMOTION. For example:

TAX EXEMPT

Lookup

Lookup for valid tax exempt codes and descriptions as pertains to an ITEM.

TCH TYPE

Lookup

Lookup for the types of Traffic Channel. For example:

  • Voice Channel

  • Data Channel

TECHNOLOGY

Lookup

Technology names and descriptions that can define a NETWORK ELEMENT. For example:

  • CDMA

  • GSM

  • ADSL

  • Ethernet

TECHNOLOGY TYPE

Lookup

Lookup for available type codes and descriptions that can classify or categorize a TECHNOLOGY. For example:

  • Wireless

  • Copper line

  • Optical Fiber

TELEPHONE NUMBER POOL

Reference

The telephone number pool allocated to the TELCO operator.

TIME BAND

Lookup

Band of call duration. For example:

  • 0-5 minutes

  • 5-30 minutes

  • 30-120 minutes

  • >120 minutes

TIME SLOT

Reference

Reference entity defining the time slot within a DAY in relation to HOURs, HALF HOURs and QUARTER HOURs. This is used in all time derived and aggregation tables.

TIME STANDARD BY DAY

Reference

Relates the calendar day to a season and to a standard day. Specifies the relationship between a given day and all days of a given season up to that day.

TIME STANDARD BY WEEK

Reference

Relates the calendar week to a season and to a standard week. Specifies the relationship between a given week and all days of a given season up to that week.

TIME ZONE

Lookup

Lookup for the Geographic time zone as related to the Greenwich Mean Time (GMT +0.00).

TV CHANNEL

Reference

Type of PRODUCT INSTANCE associating a Television Channel with a PTV USAGE EVENT.

UMS ACCESS TYPE

Lookup

Lookup for valid type codes and descriptions for Unified Messaging Services (UMS). The UMS access type indicates the way customers are accessing their mailboxes. This is especially applicable to UMS users who can access their mailbox ether using the standard method, with a specified number or by using Internet mail.

UMS EVENT

Base

Subtype of NETWORK EVENT. In the UMS notification type dimension, Unified Messaging Service (UMS) is an advanced version of Voice Message Service (VMS). As it is possible to notify the subscriber using UMS by either SMS or by internet mail, similarly a subscriber can access a mailbox in different ways, including by calling a standard access number or through the internet.

The information related to UMS access is to be analyzed by the type of access. UMS access type dimension will be used to fulfill this requirement.

UMS EVENT TYPE

Lookup

Lookup for the type of UMS events. For example:

  • E-mail

  • SMS

  • Fax

  • Voicemail

  • Video Messaging

UNIT OF MEASURE

Lookup

Lookup for possible measurement units valid for the data within the system. For example:

  • Inch

  • Kilowatt-hour

  • Days

  • Cubic centimeters

USER

Reference

Associative entity for EMPLOYEE, JOB ROLE, Business Unit; associates a unique ID for every job role that an employee performs at a particular business unit. An employee appears only one time in the EMPLOYEE entity, but in USER entity, the employee appears on time for each job role at each business unit.

VALUE ADDED SERVICE

Reference

Type of product consisting of supplementary or value added services such as Call Forward, Call barring, CLI, CLIR, UMS, or VMS.

VALUE MEASURE

Lookup

Lookup for unit of measure for the value. For example a customer or a profile can be valued in terms of monetary value or time (a customer for next three years).

VALUE TYPE

Lookup

Lookup for available type codes and descriptions pertaining to defining the derived value of a CUSTOMER or PROSPECT.

VAS SUBSCRIPTION

Reference

Type of Subscription that includes VALUE ADDED SERVICE.

VAS SUBSCRIPTION QUICK SUMMARY MO AGGR

Aggregate

Monthly Summary of VALUE ADDED SERVICE Details by CUSTOMER TYPE.

VAS SUBSCRIPTION QUICK SUMMARY DRVD

Derived

Monthly Aggregation of VALUE ADDED SERVICE Details by CUSTOMER and ACCESS METHOD.

VAS USAGE DAY DRVD

Derived

Daily usage statistics for all value added services that are content based (and some others). This includes: M2M, P2P, and SMS, MMS, ringtone, music, video, email, Universal (Voice/Email) message, and others.

VAS USAGE MONTH AGGR

Aggregate

Monthly aggregation of VAS usage statistics, from VAS USAGE DAY DRVD.

VENDOR

Reference

Supplier or source of equipment or supplies.

VENDOR APPOINTMENT

Base

Single or recurring appointment times allocated for VENDOR representative to visit the Provider or Retail Site.

VENDOR CLASS

Lookup

Lookup for the classification of Vendors. For example:

  • Primary

  • Associate

  • Direct Supply

VENDOR CONTRACT

Reference

Time bound agreement with VENDOR.

VENDOR FACTOR COMPANY ASSIGNMENT

Reference

Defines the relationship between VENDOR and FACTOR COMPANY.

VENDOR RATING

Reference

Score assigned to VENDOR based on performance criteria.

VENDOR RATING TYPE

Lookup

Lookup for type codes and descriptions of VENDOR RATING performance criteria.

VENDOR SITE

Reference

A Site or Location associated with a VENDOR from which VENDOR may do business with Provider. A Vendor site may be an Office, Warehouse, Dispatch Center, and so on.

VENDOR SITE COURIER ASSIGNMENT

Reference

Association of VENDOR SITE with COURIER.

VENDOR SITE TYPE

Lookup

Lookup for valid type codes and descriptions pertaining to VENDOR SITE. For example:

  • Call center

  • Branch Office

  • Warehouse

VIRTUAL TEAM

Reference

Type of Business Unit formed for a specific purpose. For example:

  • Sales Team A, B, C

  • Customer Support Team A, B, C

  • Project team

  • Strategic Account management team including sales and support

VOICE MESSAGE SERVICE

Reference

Subtype of SERVICE.

VOICE CALL DAY DRVD

Derived

Daily aggregate of Voice Call statistics by TIME SLOT, Business Unit, County, PRODUCT, CUSTOMER TYPE, Call Source, Call Destination, CALL DIRECTION, Call Success/Failure, Roaming Service.

VOIP CALL EVENT

Base

The subtype of Network event, specialized for Voice Over IP (VOIP) Calls.

VOICE CALL MONTH AGGR

Aggregate

Monthly Summary of Voice Call statistics by Business Unit, County, PRODUCT, CUSTOMER TYPE, CALL CATEGORY, CALL DIRECTION, Call Success/Failure.

VOLUME BAND

Lookup

Characterizes network events by volume. The volume characteristic may be in units of bytes, minutes, packets, downloads. The entity is used as part of the rating of calls and other network events.


Table 2-29 W to Z Entity Descriptions

Entity Name Type Description

WEATHER CONDITION

Reference

Reference of the various “weather” conditions, in a very general sense, affecting a given day. There is a difference between internal "weather" (a flood in a store, an employee strike, and so on) and external "weather" (storm, flood, snow, and so on). This information is useful in relation to a network failure.

WEEK TODATE TRANSFORMATION

Reference

Cumulative time transformations at the week level.

WEEK TRANSFORMATION

Reference

Time transformations at the week level.

WEEKDAY

Reference

Calendar weekdays.

WIRELESS CALL EVENT

Base

Defines occurrence of wireless call.

WIRELESS CONTENT DOWNLOADING EVENT

Base

Type of network event, to track wireless content downloading such as music, video clips, and so on.

WIRELESS NETWORK ELEMENT

Derived

Derived from NETWORK ELEMENT Hierarchy for analytical purposes.

WIRELESS RATING PLAN

Reference

Subtype of PRODUCT RATING PLAN, reserved for wireless voice and data services.

YEAR TRANSFORMATION

Reference

Transformations at the year level.