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

• Business Area Logical Entities

• Logical Data Model Entity Dictionary

Major Area Reference Entities

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

• Account Simple Entity

• Customer Entity

• Dealer Entity

• Geography Entity

• Organization Business Unit Entity

• Party Entity

• Party Subject Area Entity

• Product Entity

• Product Instance Entity

• Service Entity

• Subscription Entity

• Time Calendar Entity

• Vendor Entity

• Wireless Network Entity

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 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

Customer Entity

Figure 2-2 shows the Customer entity. Table 2-2 lists the Customer entities.

Note:

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

Figure 2-2 Customer Entity Organization

Description of "Figure 2-2 Customer Entity Organization"

Table 2-2 Customer Reference Entity

Customer Entity List
ACCOUNT
ACCOUNT PAYMENT
ADDRESS LOCATION
ARPU BAND
BARING REASON
BLACK LIST HISTORY
CALENDAR MONTH
CONTRACT
CUSTOMER
CUSTOMER CLASS
CUSTOMER INDIVIDUAL
CUSTOMER MINING
CUSTOMER OCCASION
CUSTOMER OCCASION TYPE
CUSTOMER ORGANIZATION
CUSTOMER RESTRICTED INFO
CUSTOMER REVENUE BAND
CUSTOMER REVENUE BAND ASSIGNMENT
CUSTOMER REVENUE TYPE
CUSTOMER SCORE
CUSTOMER SEGMENT
CUSTOMER SEGMENTATION MODEL
CUSTOMER SIC ASSIGNMENT
CUSTOMER SOURCE
CUSTOMER TYPE
DERIVED VALUE
EDUCATION
EVENT PARTY INTERACTION
EXTERNAL ORGANIZATION TYPE
GENDER
HOUSEHOLD
INDIVIDUAL DEMOGRAPHY VALUE
INITIATIVE RESULT TYPE
INITIATIVE TYPE
INVOICE
JOB
LANGUAGE
MEDIA OBJECT
NATIONALITY
PARTY PROMOTION RESPONSE
PARTY STATUS HISTORY
PARTY STATUS HISTORY
PROMOTION
PROSPECT
PROSPECT INDIVIDUAL
PROSPECT ORGANIZATION
SEGMENT CRITERIA
SOC JOB
VALUE MEASURE
VALUE 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 Dealer Entity Organization"

Table 2-3 Dealer Reference Entity

Dealer Entity List
CHANNEL
DEALER
DEALER DISCOUNT GROUP ASSIGNMENT
DISCOUNT GROUP
OTHER INDIVIDUAL
PARTY
SALES CHANNEL

Geography Entity

Figure 2-4 shows the Geography entity. Table 2-4 lists the Geography entities.

Figure 2-4 Geography Entity Organization

Description of "Figure 2-4 Geography Entity Organization"

Table 2-4 Geography Reference Entity

Geography Entity List
ADDRESS LOCATION
ADDRESS RELATED
ADDRESS RELATED REASON
ADDRESS STATUS
ADDRESS STATUS REASON
ADDRESS TYPE
ACCOUNT TYPE
EMPLOYEE
GEOGRAPHY CITY
GEOGRAPHY COUNTRY
GEOGRAPHY COUNTY
GEOGRAPHY DEMOGRAPHIC GROUP
GEOGRAPHY DEMOGRAPHY ATTRIBUTE
GEOGRAPHY DEMOGRAPHY VALUE
GEOGRAPHY ENTITY
GEOGRAPHY HIERARCHY
GEOGRAPHY HIERARCHY LEVEL
GEOGRAPHY HIERARCHY LEVEL ASSIGNMENT
GEOGRAPHY LEVEL
GEOGRAPHY LEVEL ATTRIBUTE
GEOGRAPHY LEVEL ATTRIBUTE VALUE
GEOGRAPHY REGION
GEOGRAPHY STATE
GEOGRAPHY SUB REGION
GEOGRAPHY WORLD
PARTY ADDRESS LOCATION ASSIGNMENT
POSTCODE
TIME ZONE

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 Organization Business Unit Entity Organization"

Table 2-5 Organization Reference Entity

Organization Entity List
ORGANIZATION AREA
ORGANIZATION BANNER
ORGANIZATION BUSINESS UNIT
ORGANIZATION CHAIN
ORGANIZATION COMPANY
ORGANIZATION CORPORATE
ORGANIZATION DISTRICT
ORGANIZATION DIVISION
ORGANIZATION REGION

Party Entity

Figure 2-6 shows the Party entity. Table 2-6 lists the Party entities.

Note:

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

Figure 2-6 Party Entity Organization

Description of "Figure 2-6 Party Entity Organization"

Table 2-6 Party Reference Entity

Party Entity List
ACCESS METHOD PARTY ASSIGNMENT
BLACK LIST HISTORY
BUSINESS LEGAL STATUS
CHANNEL
COST
CUSTOMER
CUSTOMER INDIVIDUAL
EVENT PARTY ASSIGNMENT
INDIVIDUAL DEMOGRAPHY VALUE
LANGUAGE
NATIONALITY
ORGANIZATION BUSINESS UNIT
ORGANIZATIONAL DEMOGRAPHY VALUE
PARTY
PARTY ACCOUNT ASSIGNMENT
PARTY ADDRESS LOCATION ASSIGNMENT
PARTY ASSIGNMENT
PARTY CONTACT INFORMATION
PARTY CONTACT LIST PARTICIPATION
PARTY COST ASSIGNMENT
PARTY GEOGRAPHY ENTITY ASSIGNMENT
PARTY IDENTIFICATION
PARTY INTERACTION THREAD
PARTY ORDER ASSIGNMENT
PARTY ROLE ASSIGNMENT
PARTY SIM CARD ASSIGNMENT
PARTY STATUS HISTORY
PARTY SUBSCRIPTION ASSIGNMENT
PARTY TYPE
SOURCE SYSTEM KEY MAPPING

Party Subject Area Entity

Figure 2-7 shows the Party Subject Area entity. Table 2-7 lists the Party Subject Area entities.

Note:

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

Figure 2-7 Party Subject Entity Organization

Description of "Figure 2-7 Party Subject Entity Organization"

Table 2-7 Party Subject Area Reference Entity

Party Subject Area Entity List
ACCOUNT
ANZSIC CLASSIFICATION
BANK
BLACK LIST HISTORY
BUSINESS LEGAL STATUS
COLLECTION AGENCY
CONTACT ROLES
CONTENT PROVIDER
COST
COST CENTER
CUSTOMER
CUSTOMER OCCASION
CUSTOMER OCCASION TYPE
CUSTOMER SIC ASSIGNMENT
DEALER
DEMOGRAPHY ATTRIBUTE
DEMOGRAPHY GROUP
EMPLOYEE
EMPLOYEE JOB ROLE ASSIGNMENT
EVENT
EXTERNAL INFORMATION SOURCE
EXTERNAL OPERATOR
EXTERNAL ORGANIZATION TYPE
INDIVIDUAL DEMOGRAPHY VALUE
ISP
JOB ROLE
LANGUAGE
NAICS CLASSIFICATION
ORGANIZATION BUSINESS UNIT
PARTY
PARTY ADDRESS LOCATION ASSIGNMENT
PARTY ASSIGNMENT
PARTY ASSIGNMENT REASON
PARTY ASSIGNMENT TYPE
PARTY CONTACT INFORMATION
PARTY CONTACT INFORMATION TYPE
PARTY COST ASSIGNMENT
PARTY GEOGRAPHY ENTITY ASSIGNMENT
PARTY LOCATION REASON
PARTY LOYALTY PROGRAM PARTICIPATION
PARTY ROLE
PARTY ROLE ASSIGNMENT
PARTY ROLE STATUS
PARTY STATUS CATEGORY
PARTY STATUS CHANGE REASON
PARTY STATUS HISTORY
PARTY STATUS TYPE
PARTY TYPE
PROSPECT
SIC ASSIGNMENT
SIC ASSIGNMENT REASON
SIC CLASSIFICATION
SOURCE SYSTEM
SOURCE SYSTEM KEY MAPPING
VENDOR

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 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

Product Instance Entity

Figure 2-9 shows the Product Instance entity. Table 2-9 lists the Product Instance entities.

Note:

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

Figure 2-9 Product Instance Entity Organization

Description of "Figure 2-9 Product Instance Entity Organization"

Table 2-9 Product Instance Reference Entity

Product Instance Entity List
ACCESS METHOD EQUIPMENT ASSIGNMENT
ADDRESS LOCATION
CABLE MODEM
CONTENT
CONTENT DELIVERY EVENT
CONTENT PRICE
CONTENT PRICING TYPE
CONTENT PROVIDER
CONTENT TYPE
CUSTOMER ORDER LINE ITEM
DSL MODEM
EQUIPMENT INSTANCE
EQUIPMENT INSTANCE RENTING CONTRACT
EQUIPMENT INSTANCE STATUS HISTORY
EVENT EQUIPMENT INSTANCE
HANDSET INSTANCE
NETWORK TOUCHPOINT
PARTY
PRODUCT
PRODUCT INSTANCE
SERVICE
SERVICE EQUIPMENT ASSIGNMENT
SET TOP BOX
SIM CARD HANDSET ASSIGNMENT
SUBSCRIPTION
VALUE ADDED SERVICE

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 Service Entity Organization"

Table 2-10 Service Reference Entity

Service Entity List
BROADBAND
CONTENT
FIXED LINE
GPRS SERVICE
IDD
MUSIC DOWNLOAD
PAY TV
POSTPAID WIRELESS
PREPAID WIRELESS
SERVICE
VALUE ADDED SERVICE
VOICE MESSAGE SERVICE

Subscription Entity

Figure 2-11 shows the Subscription entity. Table 2-11 lists the Subscription entities.

Note:

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

Figure 2-11 Subscription Entity Organization

Description of "Figure 2-11 Subscription Entity Organization"

Table 2-11 Subscription Reference Entity

Subscription Entity List
ACCESS METHOD SUBSCRIPTION ASSIGNMENT
ACCOUNT
ACCOUNT CREDIT LIMIT
CAMPAIGN CHANNEL
CHANNEL
CONTRACT
CUSTOMER
EQUIPMENT INSTANCE
EQUIPMENT INSTANCE RENTING CONTRACT
EVENT SUBSCRIPTION CHANGE
HANDSET INSTANCE
ORGANIZATION BUSINESS UNIT
PARTY SUBSCRIPTION ASSIGNMENT
PARTY SUBSCRIPTION ROLE
PRODUCT
PRODUCT MARKET PLAN
SALES CHANNEL REPRESENTATIVE
SIM CARD SUBSCRIPTION ASSIGNMENT
SUBSCRIPTION
SUBSCRIPTION ASSIGNMENT
SUBSCRIPTION ASSIGNMENT TYPE
SUBSCRIPTION PMP ASSIGNMENT
SUBSCRIPTION STATUS
SUBSCRIPTION STATUS CATEGORY
SUBSCRIPTION STATUS HISTORY
SUBSCRIPTION STATUS REASON
SUBSCRIPTION TERM TYPE
SUBSCRIPTION TERM VALUE
SUBSCRIPTION TYPE
VAS SUBSCRIPTION

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 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

Vendor Entity

Figure 2-13 shows the Vendor entity. Table 2-13 lists the Vendor entities.

Figure 2-13 Vendor Reference Entity Organization

Description of "Figure 2-13 Vendor Reference Entity Organization"

Table 2-13 Vendor Entity

Vendor Entity List
APPOINTMENT TYPE
DEAL
DEAL VENDOR ITEM ASSIGNMENT
FACTOR COMPANY
ORGANIZATION BUSINESS UNIT
VENDOR
VENDOR APPOINTMENT
VENDOR CLASS
VENDOR CONTRACT
VENDOR FACTOR COMPANY ASSIGNMENT
VENDOR RATING
VENDOR SITE
VENDOR SITE COURIER ASSIGNMENT

Wireless Network Entity

Figure 2-14 shows the Wireless Network entity. Table 2-14 lists the Wireless Network entities.

Note:

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

Figure 2-14 Wireless Network Organization

Description of "Figure 2-14 Wireless Network Organization"

Table 2-14 Wireless Network Entity

Wireless Network Entity List
ADDRESS LOCATION
BASE STATION CONTROLLER
BASE TRANSCEIVER STATION
CELL
CELL SECTOR
CELL SITE
CELL SITE TYPE
CELL TYPE
CIRCUIT CATEGORY
CIRCUIT COMPONENT
CIRCUIT TRAFFIC
CIRCUIT TYPE
EQUIPMENT CENTER
EXTERNAL OPERATOR
IN PLATFORM
MOBILE SWITCHING CENTER
NETWORK
NETWORK SERVICE COVERAGE ASSIGNMENT
NETWORK TOUCHPOINT
NETWORK TOUCHPOINT CLASS
NETWORK TOUCHPOINT TYPE
NETWORK TYPE
PARTY
RF CARRIER
ROUTING DEVICE
SERVICE COVERAGE AREA
SERVICE COVERAGE AREA TYPE
SERVICE COVERAGE GEO DETAIL
SWITCH
SWITCH CAPABILITY
SWITCH CAPABILITY TYPE
SWITCH ROUTING DEVICE ASSIGNMENT
SWITCH TYPE
TECHNOLOGY
TECHNOLOGY TYPE

Business Area Logical Entities

The following are the business area logical data model entities:

• Cost Business Area Logical Entity

• Customer Management Business Area Logical Entity

• Marketing Business Area Logical Entity

• Network Business Area Logical Entity

• Partner Management Business Area Logical Entity

• Product Management Business Area Logical Entity

• Provisioning and Service Business Area Logical Entity

• Revenue Business Area Logical Entity

Cost Business Area Logical Entity

Figure 2-15 shows the Cost entity. Table 2-15 lists the Cost entities.

Figure 2-15 Cost Business Area Organization

Description of "Figure 2-15 Cost Business Area Organization"

Table 2-15 Cost Business Area Logical Entities

Cost Entity List
ACCOUNT COST
CAMPAIGN COST
CELL SITE COST
CHANNEL COST
CONTACT LIST COST
COST
COST CENTER
COST CENTER BUDGET
COST REASON
COST SUBTYPE
COST TYPE
COURIER COST
CUSTOMER COST
EMPLOYEE COST
EQUIPMENT CENTER COST
EVENT COST
MEDIA OBJECT COST
NETWORK ELEMENT COST
ORGANIZATION BUSINESS UNIT COST
PARTY COST ASSIGNMENT
PRODUCT COST
PRODUCT MARKET PLAN COST
PROMOTION COST

Customer Management Business Area Logical Entity

Figure 2-16 shows the Customer Management entity. Table 2-16 lists the Customer Management entities.

Note:

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

Figure 2-16 Customer Management Area Organization

Description of "Figure 2-16 Customer Management Area Organization"

Table 2-16 Customer Management Business Area Logical Entities

Customer Management Entity List
ACCOUNT
ACCOUNT PAYMENT
ADDRESS LOCATION
ARPU BAND
BARING REASON
BLACK LIST HISTORY
CALENDAR MONTH
CONTRACT
CUSTOMER
CUSTOMER CLASS
CUSTOMER INDIVIDUAL
CUSTOMER MINING
CUSTOMER OCCASION
CUSTOMER OCCASION TYPE
CUSTOMER ORGANIZATION
CUSTOMER RESTRICTED INFO
CUSTOMER REVENUE BAND
CUSTOMER REVENUE BAND ASSIGNMENT
CUSTOMER REVENUE TYPE
CUSTOMER SCORE
CUSTOMER SEGMENT
CUSTOMER SEGMENTATION MODEL
CUSTOMER SIC ASSIGNMENT
CUSTOMER SOURCE
CUSTOMER TYPE
DERIVED VALUE
EDUCATION
EVENT PARTY INTERACTION
EXTERNAL ORGANIZATION TYPE
GENDER
HOUSEHOLD
INITIATIVE RESULT TYPE
INITIATIVE TYPE
INVOICE
JOB
LANGUAGE
MARITAL STATUS
MEDIA OBJECT
NATIONALITY
PARTY PROMOTION RESPONSE
PARTY STATUS CHANGE REASON
PARTY STATUS HISTORY
PROMOTION
PROSPECT
PROSPECT INDIVIDUAL
PROSPECT ORGANIZATION
SEGMENT CRITERIA
SOC JOB
VALUE MEASURE
VALUE TYPE

Marketing Business Area Logical Entity

Figure 2-17 shows the Marketing entity. Table 2-17 lists the Marketing entities.

Note:

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

Figure 2-17 Marketing Area Organization

Description of "Figure 2-17 Marketing Area Organization"

Table 2-17 Marketing Business Area Logical Entity

Marketing Entity List
CAMPAIGN
CAMPAIGN CHANNEL
CAMPAIGN CHANNEL TYPE
CAMPAIGN MANAGEMENT HISTORY
CAMPAIGN MESSAGE
CAMPAIGN MESSAGE CREATIVE
CAMPAIGN MESSAGE DEPICTION
CAMPAIGN STATUS
CAMPAIGN TYPE
CONTACT LIST
CONTACT LIST CHANGE REASON
CONTACT LIST RECURRENCE TYPE
COST
EVENT PARTY INTERACTION
INITIATIVE TYPE
MEDIA OBJECT
MEDIA OBJECT ASSIGNMENT
MEDIA OBJECT TYPE
ORGANIZATION BUSINESS UNIT
PARTNER PROMOTION PROGRAM
PARTY CONTACT LIST PARTICIPATION
PARTY MANAGEMENT ROLE
PARTY PROMOTION RESPONSE
PRODUCT MARKET PLAN
PROMOTION
PROMOTION CLUSTER USAGE
PROMOTION CONTACT LIST UTILIZATION
PROMOTION MANAGEMENT HISTORY
PROMOTION MARKET PLAN ASSIGNMENT
SOURCE SYSTEM TYPE
TARGET ACCESS METHOD
TARGET ACCOUNT
TARGET GEOGRAPHY AREA
TARGET TYPE

Network Business Area Logical Entity

Figure 2-18 shows the Network entity. Table 2-18 lists the Network entities.

Note:

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

Figure 2-18 Network Area Organization

Description of "Figure 2-18 Network Area Organization"

Table 2-18 Network Business Area Logical Entity

Network Entity List
ADDRESS LOCATION
CELL SITE
CELL SITE TYPE
CIRCUIT CATEGORY
CIRCUIT COMPONENT
CIRCUIT RENTAL
CIRCUIT RENTAL EVENT TYPE
CIRCUIT TRAFFIC
CIRCUIT TYPE
EQUIPMENT CENTER
EVENT CIRCUIT RENTAL
EXTERNAL OPERATOR
FIXED LINE PORT
IN PLATFORM
MOBILE SWITCHING CENTER
NETWORK
NETWORK ELEMENT
NETWORK SERVICE COVERAGE ASSIGNMENT
NETWORK TOUCHPOINT
NETWORK TOUCHPOINT CLASS
NETWORK TOUCHPOINT TYPE
NETWORK TYPE
PARTY
ROUTING DEVICE
SERVICE COVERAGE AREA
SERVICE COVERAGE AREA TYPE
SERVICE COVERAGE GEO DETAIL
SERVICE EQUIPMENT ASSIGNMENT
SWITCH
SWITCH CAPABILITY
SWITCH CAPABILITY TYPE
SWITCH ROUTING DEVICE ASSIGNMENT
SWITCH TYPE
TECHNOLOGY
TECHNOLOGY TYPE

Partner Management Business Area Logical Entity

Figure 2-19 shows the Partner Management entity. Table 2-19 lists the Partner Management entities.

Figure 2-19 Partner Management Area Organization

Description of "Figure 2-19 Partner Management Area Organization"

Table 2-19 Partner Management Business Area Logical Entity

Partner Management Entity List
ACCESS METHOD PORTING HISTORY
APPOINTMENT TYPE
CIRCUIT RENTAL
CONTENT
CONTENT PRICE
CONTENT PRICING TYPE
CONTENT PROVIDER
CONTENT TYPE
COURIER
DEAL
DEAL VENDOR ITEM ASSIGNMENT
DEALER
DEALER DISCOUNT GROUP ASSIGNMENT
DISCOUNT GROUP
EXTERNAL OPERATOR
OPERATOR TYPE
ORGANIZATION BUSINESS UNIT
PARTNER PROMOTION PROGRAM
PARTNER SETTLEMENT DRVD
PARTNER SETTLEMENT MONTH AGGR
PARTNER SETTLEMENT REASON
PARTY
PROMOTION
VENDOR
VENDOR APPOINTMENT
VENDOR CLASS
VENDOR CONTRACT
VENDOR RATING
VENDOR RATING TYPE
VENDOR SITE
VENDOR SITE COURIER ASSIGNMENT
VENDOR SITE TYPE

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 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 Provisioning and Service Area Organization"

Table 2-21 Provisioning and Service Business Area Logical Entity

Provisioning and Service Entity List
ACCESS METHOD
ACCOUNT
CONTRACT
CONTRACT TERM VALUE
CUSTOMER
CUSTOMER ORDER
ITEM
MARKET PLAN MANAGEMENT
MARKET PLAN SUBSTITUTE BY DOC
MARKET PLAN TERM VALUE
PARTY AM PMP ASSIGNMENT HISTORY
PARTY AM PMP ASSIGNMENT STATUS
PMP ORGANIZATION AVAILABILITY
PRODUCT
PRODUCT MARKET PLAN
PRODUCT MARKET PLAN ASSIGNMENT
PRODUCT MARKET PLAN GEOGRAPHY ASSIGNMENT
PRODUCT PACKAGE
PRODUCT RATING PLAN
PRODUCT RATING PLAN DETAIL
SERVICE
SUBSCRIPTION

Revenue Business Area Logical Entity

Figure 2-22 shows the Revenue entity. Table 2-22 lists the Revenue entities.

Note:

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

Figure 2-22 Revenue Area Organization

Description of "Figure 2-22 Revenue Area Organization"

Table 2-22 Revenue Business Area Logical Entities

Revenue Entity List
ACCESS METHOD
ACCOUNT PAYMENT
ACCOUNT PREFERRED PAYMENT METHOD
ACCOUNT REFUND
CONTRACT
CUSTOMER
EVENT INVOICE DELIVERY
GL REFERENCE
INVOICE
INVOICE ADJUSTMENT
INVOICE DELIVERY TYPE
INVOICE DISCOUNT
INVOICE DISCOUNT REASON
INVOICE DISCOUNT TYPE
INVOICE ITEM
INVOICE ITEM DETAIL
INVOICE ITEM DETAIL TYPE
INVOICE ITEM TYPE
INVOICE PAYMENT ASSIGNMENT
INVOICE PAYMENT TERM
INVOICE PAYMENT TERM TYPE
INVOICE TYPE
LANGUAGE
PRODUCT
PRODUCT CHARGE TYPE
PRODUCT RATING PLAN DETAIL
SUBSCRIPTION

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: From the customer site to the exchange/switch From the switch to another switch 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: Direct Total Amount Adjustment Discount Total Bill Amount Adjustment Monthly Fee Adjustment Recharge Fee Adjustment (Prepaid) Activation Fee Adjustment Free-Unit Amount Adjustment Item Charge Adjustment Loyalty Points Adjustment 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: CUSTOMER ACCOUNTs ACCESS METHOD Geography area
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.