Skip Headers
Oracle® Communications Data Model Reference
Release 11.3.2

E28440-05
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

3 Logical Data Model Dimensions

This chapter describes the logical dimensions, and hierarchies, of the data model, as shown in Table 3-1.

Table 3-1 Logical Data Model Dimensions

Dimension

Access Method

Account

Account Payment Method Status Type

Account Refund Reason

Address Location

Age Band

Age Group

Age On Net Band

Agreement Change Initiator Type

Agreement Type

ARPU Band

Bank Direct Debit Channel

Ber Fer Type

Billing Cycle

Billing Status Type

Business Time

Calendar Time

Call Category

Call Center Agent

Call Center Case Title

Call Center

Call Direction

Call Other Type

Call Routing Type

Call Service Type

Call Source Destination

Call Success Fail Type

Call Type

Campaign

Campaign Channel

Campaign Media

Cell Outage Reason

Cell Site

Change Proposed By Type

Channel

Collection Agency

Commission Type

Competitor

Contact List

Content

Content Type

Contract Change Initiator Type

Contract Assignment Reason

Cost Center

Credit Category

Currency

Customer

Customer Cluster

Customer Revenue Band

Customer Segment

Dealer

Debt Aging Band

Direct Debit Status Reason

Divert Retrieve Type

Employee

Environment Type

Event Category

Event Result

Event Type

External Operator

Fraud Profile Class

Geography

Give Away Type

GPRS Services

Handset Model

IN Platform

Initiative Type

Interaction Channel

Interaction Direction

Interaction Type

Invoice Adjustment Reason

Invoice Adjustment Type

Invoice Status

ISP

Item Subclass

Legal Process Status Type

Lifecycle Type

Loyalty Program Channel

Loyalty Tier

Market Area

Media Object Type

Network

Network Touchpoint

Network Touchpoint Class

Network Touchpoint Status

Network Touchpoint Type

Network Type

Notification Type

NP Request Type

On Off Net Type

Order Line Item State

Order State

Order Type

Organization

Packet Control Unit Outage Reason

Partner Settlement Reason

Party

Payment Channel

Payment Method Type

Payment Transaction Type

PCU Outage Reason

Peak Offpeak Time

PPA Category

Product

Product Specification Type

Product Subscription Status

Product Subscription Type

Promotion

Promotion Result Type

Quarter Hour

Reason

Recharge Revenue Slab

Redemption Type

Retail Type

RF Carrier

Roaming Type

Sales Channel

Sales Channel Representative

Script

Service Coverage Area

SKU Item

SPNM Other Party Number

Subsidy Type

Switch

Technology Type

Tender

Time Slot

UMS Access Type

Value Added Services (VAS)


Logical Data Model Dimensions

This sections lists the logical data model dimensions.

Access Method

Description: ACCESS METHOD

Access Method Hierarchy

Standard Access Method Hierarchy

Description of image001.gif follows
Description of the illustration image001.gif

Access Method Levels

Table 3-2 shows Access Method Total: All access method is the most aggregate level of the dimension.

Table 3-2 Access Method Total

Sr. Number Attribute Description

1.

ACCESS METHOD TOTAL

Code for All Access Method.


Table 3-3 shows Access Method Type: This entity keeps all types of the Access Telephone Numbers, such as Wire line, Wireless.

Table 3-3 Access Method Type

Sr. Number Attribute Description Sample Value

1

ACCESS METHOD TYPE CODE

A code, used to uniquely identify the access method type.

FLTN

2

ACCESS METHOD TYPE DESC

A textual description of the Access Method Type.

Fixed Line Telephone Numbers

3

ACCESS METHOD TYPE NAME

The name assigned to the Access Method Type.

Fixed Line Telephone Numbers

4

LANGUAGE CODE

Unique identifier for Language

 

Table 3-4 shows Access Method Detail: Detail level of the dimension. Stores the Access Method Information.

Table 3-4 Access Method Detail

Sr. Number Attribute Description Sample Value

1

ACCESS METHOD CODE

A sequence of numbers (like phone number) electronically registered to telecommunications equipment that gives the Customer access to services or products. Other access method like DSL account, Service ID might be character type.

867558305000

2

ACCESS METHOD DESC

Access method full description.

WRLS867558305000

3

ACCESS METHOD NAME

ACCESS METHOD NAME. ACCESS METHOD NAME

WRLS867558305000

4

ACCESS METHOD POOL CODE

Unique identifier for Access Method Pool

 

5

ACCESS METHOD SEGMENT CODE

Unique identifier for Access Method Segment

 

1

ACCESS METHOD TYPE CODE

A code, used to uniquely identify a access method type.

FLTN

2

ACCOUNT CODE

This is usually natural key of the account. Optional column, At certain time period, the access method may not be bound to an account.

10000101

3

CUSTOMER SELECT INDICATOR

Indicates whether the phone number (access method identifier) is selected by a customer.

 

4

EFFECTIVE FROM DATE

EFFECTIVE FROM DATE, standard SCD2 column.

12/31/2005 12:00:00 AM

5

EFFECTIVE TO DATE

EFFECTIVE TO DATE, standard SCD2 column.

12/31/2005 12:00:00 AM

6

NETWORK CODE

Identifier of the network.

 

7

SILENT NUMBER INDICATOR

An indicator that indicates whether a party has a silent number. A silent number could not be found on the White Pages. access method full description

 

8

STATUS CODE

Current STATUS CODE, standard SCD2 column.

 

9

SWITCH CODE

Unique identifier for Switch

 

Account

Description: ACCOUNT

Account Hierarchies

Standard ACCOUNT Hierarchy:

Description of dim_account.png follows
Description of the illustration dim_account.png

Account Levels

The following table shows ACCOUNT Total: All ACCOUNT is the most aggregate level of the dimension.

Table for ACCOUNT Total

Sr. Number Attribute Description
1. ALL ACCOUNT CODE Identification for the top level value

Detail table ACCOUNT TYPE

Sr. Number Attribute
1 ACCOUNT TYPE NAME
2 ACCOUNT TYPE CODE
3 LANGUAGE CODE
4 ACCOUNT TYPE DESC

Detail table ACCOUNT Detail

Sr. Number Attribute Description Sample Value
1 ACCOUNT CODE This is usually natural key of the account. 10000102
2 ACCOUNT NAME The name for the account.  
3 ACCOUNT SEGMENT CODE Unique identifier for Account Segment  
4 ACCOUNT TYPE CODE Unique identifier for Account Type PRPD
5 ACCOUNTING CYCLE CODE Unique identifier for Accounting Cycle  
6 ADVERTISING STATUS Indicated if it need some advertising material for a particular invoice arrangement, and if customer explicitly requested NOT to send.  
7 BILLING CYCLE CODE Unique identifier for Billing Cycle MO
8 BILLING PERIOD CODE Unique identifier for Billing period  
9 CREATE DATE The date when the account was created. 4/4/2006 12:00:00 AM
10 CREATE STAFF the employee number of who created the account.  
11 CREDIT CATEGORY CODE Current Credit Category Code.  
12 CREDIT RATING DATE CREDIT RATING DATE is when the credit category code is rated for the account.  
13 CURRENCY CODE Unique identifier for Currency USD
14 CUSTOMER CODE Unique identifier for Customer  
15 EFFECTIVE FROM DATE EFFECTIVE FROM DATE, standard SCD2 column. 12/31/2005 12:00:00 AM
16 EFFECTIVE TO DATE EFFECTIVE TO DATE, standard SCD2 column. 12/31/2005 12:00:00 AM
17 GROUP PLAN INDICATOR Indicates whether an account belongs to a group plan/solution.  
18 LAST ACTIVATE DATE The last date when account was activated.  
19 LAST REOPEN DATE Last time when account was reopen.  
20 LAST SUSPEND DATE Last date when the account was suspended for certain reasons.  
21 MULTIPLE CUSTOMER INDICATOR Indicates whether one bill has multiple customer.  
22 ORGANIZATION BUSINESS UNIT CODE Unique identifier for Organization Business Unit  
23 PAYMENT DAYS The number of days after customer billing before certain actions (like debt collection) would be taken.  
24 STATUS CODE STATUS CODE, standard SCD2 column.  
25 TERMINATION DATE TERMINATION DATE. 3/3/2008 12:00:00 AM

Account Payment Method Status Type

Description: ACCOUNT PAYMENT METHOD STATUS TYPE

Account Payment Method Status Type Hierarchy

Standard Account Payment Method Status Type Hierarchy:

Description of image003.gif follows
Description of the illustration image003.gif

Account Payment Method Status Type Levels

Table 3-5 shows Account Payment Method Status Type Total: All Account Payment Method Status Types are most aggregate level of the dimension.

Table 3-5 Account Payment Method Status Type Total

Sr. Number Attribute Description

1.

ACCOUNT PAYMENT METHOD STATUS TYPE TOTAL

Code for All Account Payment Method Status Type.


Table 3-6 shows Account Payment Method Status Type Detail: All Account Payment Method Status Types are most aggregate level of the dimension.

Table 3-6 Account Payment Method Status Type Detail

Sr. Number Attribute Description Sample Value

1

ACCOUNT PAYMENT METHOD STATUS TYPE CODE

Code for Direct Debit Status

CHECK

2

ACCOUNT PAYMENT METHOD STATUS TYPE DESC

Direct Debit Status Description

CHECK

3

ACCOUNT PAYMENT METHOD STATUS TYPE NAME

Direct Debit Status Short Description

Transaction By Check

4

LANGUAGE CODE

Unique identifier for Language

 

Account Refund Reason

Description: ACCOUNT REFUND REASON

Account Refund Reason Hierarchies

Standard Account Refund Reason Hierarchy:

Description of image004.gif follows
Description of the illustration image004.gif

Account Refund Reason Levels

Table 3-7 shows Account Refund Reason Total: All Account Refund Reasons are the most aggregate level of the dimension.

Table 3-7 Account Refund Reason Total

Sr. Number Attribute Description

1.

ACCOUNT REFUND REASON TOTAL

Code for All Account Refund Reason.


Table 3-8 shows Account Refund Reason Detail: All Account Refund Reason Types are most aggregate level of the dimension.

Table 3-8 Account Refund Reason Detail

Sr. Number Attribute Description Sample Value

1

ACCOUNT REFUND REASON CODE

A code, used to uniquely identify ACCOUNT REFUND REASON.

INVCADJ

2

ACCOUNT REFUND REASON DESC

A textual description of ACCOUNT REFUND REASON.

Invoice Adjustment

3

ACCOUNT REFUND REASON NAME

The name assigned to ACCOUNT REFUND REASON.

Invoice Adjustment

4

LANGUAGE CODE

Unique identifier for Language

 

Address Location

Description: ADDRESS LOCATION

Address Location Hierarchies

Standard Address Location Hierarchy:

Description of image005.gif follows
Description of the illustration image005.gif

Address Location Levels

Table 3-9 shows Address Location Total: All Address Location is most aggregate level of the dimension.

Table 3-9 Address Location Total

Sr. Number Attribute Description

1.

ADDRESS LOCATION TOTAL

Code for All Address Locations.


Table 3-10 shows Address Location Detail: All Address Locations are most aggregate level of the dimension.

Table 3-10 Address Location Detail

Sr. Number Attribute Description Sample Value

1

ADDRESS DESCRIPTION

Address description. Textual description of the address.

 

2

ADDRESS LATITUDE MEASURE

This is the Latitude value of the specified location

 

3

ADDRESS LINE 1

Address. Line one of detailed postal address

123 Park Avenue

4

ADDRESS LINE 2

Address. Line two of detailed postal address

ABC Tower

5

ADDRESS LINE 3

Address. Line three of detailed postal address

Suite 1111

6

ADDRESS LINES PHONETIC

Phonetic or Kana representation of the Kanji address lines (used in Japan)

 

7

ADDRESS LOCATION CODE

unique identifier for the address.

 

8

ADDRESS LONGITUDE MEASURE

This is the longitude location of the specified address.

 

9

ADDRESS STYLE

Any specific style of the address. It might include the detail like All Capital words, case, font and so on.

 

10

ADDRESS TYPE CODE

Unique identifier for the address type.

Shipping

11

REGION NAME

Name of the Reason

 

12

SUBREGION DESC

description of sub region

 

13

TAX AUTHORITY CODE

Unique identified for the tax authority

 

14

WORLD DESC

Description of world

 

15

WORLD NAME

Name of the world

 

16

ADDRESS LATITUDE MEASURE

This is the Latitude value of the specified location

 

17

POSTAL PLUS CODE

Four digit extension to the United States Postal ZIP code.

 

18

STREET CODE

Uniquely identifier of state

 

19

CITY DESC

Description of the city

 

20

FLAT ROOM CODE

Uniquely identifier of the flat room

 

21

GEOGRAPHY STATE CODE

State of the geography

 

22

POST OFFICE BOX

PO box if available.

 

23

STATE DESC

Description of the state

 

24

STATE NAME

Name of the state

 

26

BUILDING DESC

Description for Building

 

27

COUNTY DESC

Description for County

 

28

GEOGRAPHY COUNTRY CODE

Code for Geography Country

 

29

POSTCODE CODE

Code for Post Code

 

30

ADDRESS DESCRIPTION

Address description. Textual description of the address.

 

31

ADDRESS TYPE CODE

Unique identifier for the address type.

 

32

BUILDING NAME

Name for Building

 

33

COUNTY NAME

Name for County

 

34

EFFECTIVE TO DATE

EFFECTIVE TO DATE, standard SCD2 column.

 

35

FLAT ROOM DESC

Description for Flat Room

 

36

GEOGRAPHY COUNTY CODE

Code for Geography County

 

37

GEOGRAPHY ENTITY CODE

unique geography identifier. A unique identifier for the geography entities, could be a system generated unique key for Geography entity.

 

38

REGION DESC

Description for Region

 

39

WORLD CODE

Description for World

 

42

LONGITUDE

The angular distance between a point on any meridian and the prime meridian at Greenwich

 

43

PRIMARY ADDRESS TELEPHONE

Telephonic address

 

44

STATUS CODE

An indicator of the address current status. For instance, this address may be valid, invalid, temporary, and so on.

 

47

COUNTRY NAME

Name for Country

 

48

EFFECTIVE FROM DATE

EFFECTIVE FROM DATE, standard SCD2 column.

 

49

EMPLOYEE CODE

Code for Employee

 

50

FLOOR DESC

Description for Floor

 

51

SUBREGION NAME

Name for Subregion

 

52

ADDRESS LOCATION CODE

unique identifier for the address.

 

53

CITY NAME

Name for City

 

54

COUNTRY DESC

Description for Country

 

55

FLAT ROOM NAME

Name for Flat Room

 

56

GEOGRAPHY CITY CODE

Code for Geography City

 

57

GEOGRAPHY SUBREGION CODE

Code for Geography Subregion

 

58

STREET DESC

Description for Street

 

59

STREET NAME

Name for Street

 

60

TIME ZONE CODE

Unique Identifier for time zone.

 
 

GEOGRAPHY LOCATION CODE

   
 

ELEVATION

   
 

ELEVATION UOM CODE

   
 

GEOGRAPHY REGION CODE

   
 

PRIMARY EMAIL ADDRESS

   

Age Band

Description: AGE BAND

Age Band Hierarchies

Standard Age Band Hierarchy

Description of image006.gif follows
Description of the illustration image006.gif

Age Band Levels

Table 3-11 shows Age Band Total: All Age Bands are most aggregate level of the dimension.

Table 3-11 Age Band Total

Sr. Number Attribute Description

1.

AGE BAND TOTAL

Code for All Age Bands.


Table 3-12 shows Age Band Detail: All Age Bands are most aggregate level of the dimension.

Table 3-12 Age Band Detail

Sr. Number Attribute Description Sample Value

1

AGE BAND CODE

Code for Age band.

AGBND1

2

AGE BAND DESC

Long Description for age band value.

Age Band 21-30

3

AGE BAND FROM

Lower limit of age value of the slab.

21

4

AGE BAND NAME

Description for age band value.

Age Band 21-30

5

AGE BAND TO

Upper limit of age value of the slab.

30

6

LANGUAGE CODE

Unique identifier for Language

 

Age Group

Description: AGE GROUP

AGE GROUP Hierarchies

Standard AGE GROUP Hierarchy:

Description of dim_age.png follows
Description of the illustration dim_age.png

AGE GROUP Levels

The following table shows AGE GROUP Total: All AGE GROUP is the most aggregate level of the dimension.

Table for AGE GROUP Total

Sr. Number Attribute Description
1. AGE GROUP TOTAL Code for All AGE GROUP

Detail table shows AGE GROUP Detail: All AGE GROUP types is the most aggregate level of the dimension.

Detail table AGE GROUP Detail

Sr. Number Attribute
1 AGE GROUP TO
2 AGE GROUP NAME
3 AGE GROUP FROM
4 AGE GROUP CODE
5 LANGUAGE CODE
6 AGE GROUP DESCRIPTION

Age On Net Band

Description: AGE ON NET BAND

Age on Net Band Hierarchies

Standard Age On Net Band Hierarchy:

Description of image007.gif follows
Description of the illustration image007.gif

Age on Net Band Levels

Table 3-13 shows Age on Net Band Total: All age on net bands are most aggregate level of the dimension.

Table 3-13 Age on Net Band Total

Sr. Number Attribute Description

1.

AGE ON NET BAND TOTAL

Code for All Age On Net Band.


Table 3-14 shows Age On Net Band Detail: All Age on net bands are most aggregate level of the dimension.

Table 3-14 Age On Net Band Detail

Sr. Number Attribute Description Sample Value

1

AGE ON NET BAND CODE

Code for age on Net band.

AGBND1

2

AGE ON NET BAND DESC

Long Description for age on net band value.

Age on net Band 0-20

3

AGE ON NET BAND FROM

Lower limit of age on net band value of the slab.

21

4

AGE ON NET BAND NAME

Description for age on net band value.

Age on net Band 21-30

5

AGE ON NET BAND TO

Upper limit of age on net band value of the slab.

30

6

LANGUAGE CODE

Unique identifier for Language.

 

ARPU Band

Description: ARPU BAND

ARPU Band Hierarchies

Standard ARPU Band Hierarchy:

Description of image008.gif follows
Description of the illustration image008.gif

ARPU Band Levels

Table 3-15 shows ARPU Band Total: All ARPU Bands are most aggregate level of the dimension.

Table 3-15 ARPU Band Total

Sr. Number Attribute Description

1.

ARPU BAND TOTAL

Code for All ARPU Band.


Table 3-16 shows ARPU Band Detail: All ARPU Bands are most aggregate level of the dimension.

Table 3-16 ARPU Band Detail

Sr. Number Attribute Description Sample Value

1

ARPU BAND CODE

Unique identifier for revenue band. For example: 0_1000, 1000_3000.

ARPU1000

2

ARPU BAND DESC

Description revenue band.

ARPU Ranging From 0-1000

3

ARPU BAND END VALUE

The end point of a band (the end point is included in the band).

$1,000.00

4

ARPU BAND END VALUE LOCAL

The end point of a band.

 

5

ARPU BAND END VALUE REPORTING

The end point of a band.

 

6

ARPU BAND NAME

Name of revenue band.

 

7

ARPU BAND START VALUE

The start point of a band (the start value is included in the band).

$0.00

8

ARPU BAND START VALUE LOCAL

The start point of a band.

 

9

ARPU BAND START VALUE REPORTING

The start point of a band.

 

10

LANGUAGE CODE

Unique identifier for Language

 

Agreement Change Initiator Type

Description: AGREEMENT CHANGE INITIATOR TYPE

Agreement Change Initiator Type Hierarchies

Standard AGREEMENT CHANGE INITIATOR TYPE Hierarchy:

Description of dim_aggr_change.png follows
Description of the illustration dim_aggr_change.png

Agreement Change Initiator Type Levels

The following table shows AGREEMENT CHANGE INITIATOR TYPE Total: All AGREEMENT CHANGE INITIATOR TYPE is the most aggregate level of the dimension.

Table for AGREEMENT CHANGE INITIATOR TYPE Total

Sr. Number Attribute Description
1. AGREEMENT CHANGE INITIATOR TYPE TOTAL Code for AGREEMENT CHANGE INITIATOR TYPE.

Detail table shows AGREEMENT CHANGE INITIATOR TYPE Detail: All AGREEMENT CHANGE INITIATOR TYPE is the most aggregate level of the dimension.

Detail table AGREEMENT CHANGE INITIATOR TYPE Detail

Sr. Number Attribute Description
1 AGREEMENT CHANGE INITIATOR TYPE CODE CONTRACT CHANGE INITIATOR TYPE CODE
2 AGREEMENT CHANGE INITIATOR TYPE DESC CONTRACT CHANGE INITIATOR TYPE DESC
3 AGREEMENT CHANGE INITIATOR TYPE NAME CONTRACT CHANGE INITIATOR TYPE name
4 LANGUAGE CODE  

Agreement Type

Description: AGREEMENT TYPE

Agreement Type Hierarchies

Standard AGREEMENT TYPE Hierarchy:

Description of dim_aggr_type.png follows
Description of the illustration dim_aggr_type.png

Agreement Type Levels

The following table shows AGREEMENT TYPE Total: All AGREEMENT TYPE is the most aggregate level of the dimension.

Table for AGREEMENT TYPE Total

Sr. Number Attribute Description
1. AGREEMENT TYPE TOTAL Code for All AGREEMENT TYPE.

Detail table shows AGREEMENT TYPE Detail: All AGREEMENT TYPE types is the most aggregate level of the dimension.

Detail table AGREEMENT TYPE Detail

Sr. Number Attribute Description
1 AGREEMENT TYPE CODE A code used to uniquely identify the category of Contracts. Examples: LC = lease contract, SC = service contract
2 AGREEMENT TYPE DESC A textual description of the category of contracts.
3 AGREEMENT TYPE NAME The name assigned to a Contract Type. such as lease contract, service contract
4 LANGUAGE CODE  

Bank Direct Debit Channel

Description: BANK DIRECT DEBIT CHANNEL

Bank Direct Debit Channel Hierarchies

Standard Bank Direct Debt Channel Hierarchy:

Description of image009.gif follows
Description of the illustration image009.gif

Bank Direct Debit Channel Levels

Table 3-17 shows Bank Direct Debt Channel Total: All Bank Direct Debt Channel is most aggregate level of the dimension.

Table 3-17 Bank Direct Debt Channel Total

Sr. Number Attribute Description

1.

BANK DIRECT DEBT CHANNEL TOTAL

Code for All Bank Direct Debt Channel.


Table 3-18 shows Bank Direct Debit Channel Detail: All Bank Direct Debt Channel is most aggregate level of the dimension.

Table 3-18 Bank Direct Debit Channel Detail

Sr. Number Attribute Description Sample Value

1

BANK BRANCH CODE

Bank Branch id/code.

 

2

BANK DIRECT DEBIT CHANNEL CODE

Unique identifier for Bank Direct Debit Channel

SHP

3

PAYMENT CHANNEL CODE

   

4

CHANNEL CODE

   

5

CHANNEL TYPE CODE

   

6

PARTY CODE

   

7

PARTY TYPE CODE

   

8

CHANNEL NAME

   

9

CHANNEL DESC

   

10

CAPACITY QUANTITY

   

11

EFFECTIVE FROM DATE

   

12

EFFECTIVE TO DATE

   

13

STATUS CODE

   

Ber Fer Type

Description: BER FER TYPE

Ber Fer Type Hierarchies

Standard Ber Fer Type Hierarchy:

Description of image010.gif follows
Description of the illustration image010.gif

Ber Fer Type Levels

Table 3-19 shows Ber Fer Type Total: All Ber Fer Types are most aggregate level of the dimension.

Table 3-19 Ber Fer Type Total

Sr. Number Attribute Description

1.

BER FER TYPE TOTAL

Code for All Ber Fer Type.


Table 3-20 shows Ber Fer Type Detail: All Ber Fer Type are most aggregate level of the dimension.

Table 3-20 Ber Fer Type Detail

Sr. Number Attribute Description Sample Value

1

BER FER TYPE CODE

Unique identifier for Ber Fer Type

BER

2

BER FER TYPE DESC

Description for Ber Fer Type

Bit Error Ratio

3

BER FER TYPE NAME

Name of Ber Fer Type

Bit Error Ratio

4

LANGUAGE CODE

Unique identifier for Language

 

Billing Cycle

Description: BILLING CYCLE

Billing Cycle Hierarchies

Standard BILLING CYCLE Hierarchy:

Description of dim_billc.png follows
Description of the illustration dim_billc.png

Billing Cycle Levels

The following table shows BILLING CYCLE Total: All BILLING CYCLE is the most aggregate level of the dimension.

Table for BILLING CYCLE Total

Sr. Number Attribute Description
1. BILLING CYCLE TOTAL Code for All BILLING CYCLE.

Detail table shows BILLING CYCLE Detail: All BILLING CYCLE types is the most aggregate level of the dimension.

Detail table BILLING CYCLE Detail

Sr. Number Attribute Description
1 CHARGE DATE OFFSET An offset of number of days from beginning of billing cycle after before which the charges from an account should appear.
2 CREDIT DATE OFFSET An offset of number of days from beginning of billing cycle after before which the credit from account should appear.
3 BILLING DATE SHIFT An offset of number of days from beginning of billing cycle to determine next billing.
4 BILLING CYCLE CODE Code.
5 STATUS CODE Current STATUS CODE, standard SCD2 column
6 EFFECTIVE FROM DATE EFFECTIVE FROM DATE, standard SCD2 column
7 EFFECTIVE TO DATE EFFECTIVE TO DATE, standard SCD2 column
8 BILLING CYCLE DESC Full description.
9 BILLING CYCLE UNIT AMOUNT The numeric value for billing cycle period. For example, number of days, or months.
10 BILLING CYCLE PERIOD UOM The unit of measure for billing cycle period amount
11 BILLING CYCLE NAME title
12 MAILING DATE OFFSET  
13 LANGUAGE CODE  
14 PAYMENT DUE DATE OFFSET  

Billing Status Type

Description: BILLING STATUS TYPE

Billing Status Type Hierarchies

Standard Billing Status Type Hierarchy:

Description of image012.gif follows
Description of the illustration image012.gif

Billing Status Type Levels

Table 3-21 shows Billing Status Type Total: All Billing Status Type are most aggregate level of the dimension.

Table 3-21 Billing Status Type Total

Sr. Number Attribute Description

1.

BILLING STATUS TYPE TOTAL

Code for All Billing Status Type.


Table 3-22 shows Billing Status Type Detail: All Billing Status Type is most aggregate level of the dimension.

Table 3-22 Billing Status Type Detail

Sr. Number Attribute Description Sample Value

1

BILLING STATUS CATEGORY CODE

BILLING STATUS CATEGORY CODE.

FAILED

2

BILLING STATUS TYPE CODE

BILLING STATUS TYPE code.

FAILDAT

3

BILLING STATUS TYPE DESC

BILLING STATUS TYPE description.

Status type of billing result: Incorrect_data_failed

4

BILLING STATUS TYPE NAME

BILLING STATUS TYPE NAME

Incorrect data failed

5

LANGUAGE CODE

Unique identifier for Language

 

Business Time

Description: Calendar as defined and applied to a business unit. Corresponds business calendar entities (BUSINESS YEAR, BUSINESS HALF YEAR, BUSINESS QUARTER, BUSINESS MONTH, BUSINESS HALF MONTH, DAY.

Business Time Hierarchies

Standard Business Time Hierarchy:

Description of image013.gif follows
Description of the illustration image013.gif

Business Time Level

Table 3-23 shows Business Time Total: This is the most aggregate level of the Time dimension.

Table 3-23 Business Time Total

Sr. Number Attribute Description

1.

ALL BUSINESS TIME CODE

Identification for the top level value


Table 3-24 shows Business Year: It captures information relating to a year in a Business Calendar.

Table 3-24 Business Year

Sr. Number Attribute Description Sample Value

1

BUSINESS CALENDAR NAME

Textual name of the business Calendar

BUSINESS

2

BUSINESS YEAR CODE

Unique warehouse key of the Year, in the Calendar.

20050101

3

BUSINESS YEAR DESC

Calendar year description.

BY 2005

4

BUSINESS YEAR END DATE

Calendar year end date.

12/31/2005 12:00:00 AM

5

BUSINESS YEAR NUMBER

Calendar year number

 

6

BUSINESS YEAR START DATE

Calendar year start date

12/31/2005 12:00:00 AM

7

BUSINESS YEAR TIMESPAN

The length, in terms of days, of this year in the Calendar. For example: 365 days

365

8

TOTAL CODE

   

Table 3-25 shows Business Half Year: It captures information relating to half year in a Business Calendar.

Table 3-25 Business Half Year

Sr. Number Attribute Description Sample Value

1

BUSINESS HALF YEAR CODE

Unique warehouse key of the half year, in the Calendar.

20050101

2

BUSINESS HALF YEAR DESC

Calendar half year description.

BY 2005 HY1

3

BUSINESS HALF YEAR END DATE

Calendar half year end date.

12/31/2005 12:00:00 AM

4

BUSINESS HALF YEAR NUMBER

A numeric representation of half year number in the Calendar. It contains values 1 or 2.

1

5

BUSINESS HALF YEAR START DATE

Calendar half year start date.

12/31/2005 0:00

6

BUSINESS HALF YEAR TIMESPAN

The length, in terms of days, of this half year in the Calendar. For example: 178 days

181

7

BUSINESS YEAR CODE

Unique key of the year, in which this half year occurred in the Calendar.

20050101

8

BUSINESS YEAR START DAY CODE

Code for calendar year start day

 

Table 3-26 shows Business Quarter: It captures information relating to half year in a Business Calender.

Table 3-26 Business Quarter

Sr. Number Attribute Description Sample Value

1

BUSINESS HALF YEAR CODE

Unique key of the half year

20050101

2

BUSINESS HALF YEAR START DAY CODE

Calendar year start date

 

3

BUSINESS QUARTER CODE

Unique key of business quarter

20050101

4

BUSINESS QUARTER DESC

Description for business quarter

BY 2005 Q1

5

BUSINESS QUARTER END DATE

Calendar year end date

12/31/2005 0:00

6

BUSINESS QUARTER NUMBER

Number for business quarter

1

7

BUSINESS QUARTER START DATE

Calendar year start date

12/31/2005 0:00

8

BUSINESS QUARTER TIMESPAN

The length, in terms of days, of this quarter

90

9

BUSINESS YEAR CODE

Unique key of the year, in which this half year occurred in the Calendar.

 

10

BUSINESS YEAR START DAY CODE

Code for year start date

 

Table 3-27 shows Business Month: It captures information relating to a month in a Business Calendar.

Table 3-27 Business Month

Sr. Number Attribute Description Sample Value

1

BUSINESS HALF YEAR CODE

Unique warehouse key for half year

20050101

2

BUSINESS HALF YEAR START DAY CODE

Unique warehouse key for year start day

20050101

3

BUSINESS MONTH CODE

Unique warehouse key of the month, in the Calendar.

20050101

4

BUSINESS MONTH DESC

Calendar month description.

BY 2005 M1

5

BUSINESS MONTH END DATE

Calendar month end date

12/31/2005 0:00

6

BUSINESS MONTH NUMBER

A numeric representation of the month number in the Calendar. It ranges from 1 to 12

1

7

BUSINESS MONTH START DATE

Calendar month start date

12/31/2005 0:00

8

BUSINESS MONTH TIMESPAN

The length, in terms of days, of this month in the Calendar. For example: 30 days

28

9

BUSINESS QUARTER CODE

Unique key of the quarter, in which this month occurred in the Calendar.

20050101

10

BUSINESS QUARTER START DAY CODE

Unique warehouse key for quarter start day

 

11

BUSINESS YEAR CODE

Unique warehouse key for year

20050101

12

BUSINESS YEAR START DAY CODE

Unique warehouse key year start day

 

Table 3-28 shows Business Half Month: It captures information relating to a Fortnight in a Business Calendar.

Table 3-28 Business Half Month

Sr. Number Attribute Description Sample Value

1

BUSINESS HALF MONTH CODE

Unique warehouse key of the Fortnight, in the Calendar.

20050101

2

BUSINESS HALF MONTH DESC

Calendar half month description.

BY 2005 M1 HM1

3

BUSINESS HALF MONTH END DATE

Calendar half month end date.

12/31/2005 12:00:00 AM

4

BUSINESS HALF MONTH NUMBER

A numeric representation of the fortnight number in the Calendar. It ranges from 1 to 24

1

5

BUSINESS HALF MONTH START DATE

Calendar half month start date

12/31/2005 12:00:00 AM

6

BUSINESS HALF MONTH TIMESPAN

The length, in terms of days, of this fortnight in the Calendar. For example: 15 days

15

7

BUSINESS HALF YEAR CODE

Unique warehouse key for half year

20050101

8

BUSINESS HALF YEAR START DAY CODE

Unique warehouse key for half year start day

20050101

9

BUSINESS MONTH CODE

Unique key of the month, in which this fortnight occurred in the Calendar.

20050101

10

BUSINESS MONTH START DAY CODE

Unique warehouse key for month start day

 

11

BUSINESS QUARTER CODE

Unique warehouse key for quarter

20050101

12

BUSINESS QUARTER START DAY CODE

Unique warehouse key for quarter start day

 

13

BUSINESS YEAR CODE

Unique warehouse key for year

20050101

14

BUSINESS YEAR START DAY CODE

Unique warehouse key for year start day

 

Table 3-29 shows Day: It captures information relating to a Day.

Table 3-29 Day

Sr. Number Attribute Description Sample Value

1

BUSINESS CURRENT IND

Business Current indicator 'Y' or 'N'

 

2

BUSINESS DATE

Business date.

 

3

BUSINESS DATE DESC

Business Date description.

 

4

BUSINESS DAY CODE

Code for Calendar Day

20050101

5

BUSINESS DAY OF YEAR

Business day of year

 

6

BUSINESS DAY TIME SPAN

The length, in terms of days, of this fortnight in the Calendar.

 

7

BUSINESS END DATE

Business end date.

12/31/2005 12:00:00 AM

8

BUSINESS HALF MONTH CODE

Unique warehouse key for half month

20050101

9

BUSINESS HALF MONTH DESCRIPTION

Calendar half month description.

 

10

BUSINESS HALF MONTH END DATE

Calendar half month end date.

12/31/2005 12:00:00 AM

11

BUSINESS HALF MONTH NUMBER

A numeric representation of the fortnight number in the Calendar. It ranges from 1 to 24.

1

12

BUSINESS HALF MONTH START DATE

Calendar half month start date.

12/31/2005 12:00:00 AM

13

BUSINESS HALF MONTH START DAY CODE

Unique ware house key for half month start day.

20050101

14

BUSINESS HALF MONTH TIMESPAN

The length, in terms of days, of this fortnight in the Calendar. For example: 15 days

15

15

BUSINESS HALF YEAR CODE

Unique warehouse key for half year

20050101

16

BUSINESS HALF YEAR DESC

Business half year description.

 

17

BUSINESS HALF YEAR END DATE

Business half year end date.

12/31/2005 12:00:00 AM

18

BUSINESS HALF YEAR NUMBER

Business half year number

 

19

BUSINESS HALF YEAR START DATE

Business half year start date

12/31/2005 12:00:00 AM

20

BUSINESS HALF YEAR START DAY CODE

Unique warehouse key for half year start day

20050101

21

BUSINESS HALF YEAR TIMESPAN

The length, in terms of days, of this half year in the Calendar. For example: 178 days

181

22

BUSINESS MONTH CODE

Unique key of the month, in which this fortnight occurred in the Calendar

20050101

23

BUSINESS MONTH DESC

Calendar month description

BY 2005 M1

24

BUSINESS MONTH END DATE

Calendar month end date.

12/31/2005 12:00:00 AM

25

BUSINESS MONTH NUMBER

A numeric representation of the month number in the Calendar. It ranges from 1 to 12.

1

26

BUSINESS MONTH START DATE

Calendar month start date.

12/31/2005 12:00:00 AM

27

BUSINESS MONTH START DAY CODE

Unique warehouse key for month start day

20050101

28

BUSINESS MONTH TIME SPAN

The length, in terms of days, of this month in the Calendar. For example: 30 days

28

29

BUSINESS QUARTER CODE

Unique warehouse key for quarter

20050101

30

BUSINESS QUARTER DESC

Calendar quarter description.

BY 2005 Q1

31

BUSINESS QUARTER END DATE

Business quarter end date.

12/31/2005 12:00:00 AM

32

BUSINESS QUARTER NUMBER

Number for business quarter

 

33

BUSINESS QUARTER START DATE

Business quarter start date

12/31/2005 12:00:00 AM

34

BUSINESS QUARTER START DAY CODE

Unique warehouse key for quarter start day

20050101

35

BUSINESS QUARTER TIME SPAN

The length, in terms of days, of this year in the Calendar.

 

36

BUSINESS START DATE

Business start date.

12/31/2005 12:00:00 AM

37

BUSINESS WEEK CODE

Unique identifier for business week

20050101

38

BUSINESS WEEK DAY

Business week day.

 

39

BUSINESS WEEK DAY CODE

Unique identifier for business week day.

20050101

40

BUSINESS WEEK DAY DESC

Business week day description

 

41

BUSINESS WEEK DESC

Business week description.

 

42

BUSINESS WEEK END DATE

Business week end date.

12/31/2005 12:00:00 AM

43

BUSINESS WEEK NUMBER

Number for business week

 

44

BUSINESS WEEK START DATE

Business week start date.

12/31/2005 12:00:00 AM

45

BUSINESS WEEK START DAY CODE

Unique identifier for business week start day

20050101

46

BUSINESS WEEK TIME SPAN

The length, in terms of days, of this year in the Calendar.

 

47

BUSINESS WEEKEND IND

Weekend indicator 'Y' or 'N'

 

48

BUSINESS WORKING DAY IND

Working day indicator 'Y' or "N'

 

49

BUSINESS YEAR CODE

Unique warehouse key for year

20050101

50

BUSINESS YEAR DESC

Calendar year description

 

51

BUSINESS YEAR END DATE

Calendar year end date.

12/31/2005 12:00:00 AM

52

BUSINESS YEAR NUMBER

Calendar year number.

 

53

BUSINESS YEAR START DATE

Calendar year start date.

12/31/2005 12:00:00 AM

54

BUSINESS YEAR START DAY CODE

Unique warehouse key for year start day

20050101

55

BUSINESS YEAR TIMESPAN

The length, in terms of days, of this year in the Calendar. For example: 365 days

365


Calendar Time

Description: Information related to the calendar, including: CALENDAR YEAR, CALENDAR HALF YEAR, CALENDAR QUARTER, CALENDAR MONTH, CALENDAR HALF MONTH, DAY.

Calendar Time Hierarchy

Standard Calendar Time Hierarchy:

Description of image014.gif follows
Description of the illustration image014.gif

Calendar Time Level

Table 3-30 shows Calendar Time Total: This is the most aggregate level of the Time dimension.

Table 3-30 Calendar Time Total

Sr. Number Attribute Description

1.

ALL CALENDAR TIME CODE

Identification for the top level value


Table 3-31 shows Calendar Year: It captures information relating to a year in a Business Calender.

Table 3-31 Calendar Year

Sr. Number Attribute Description Sample Value

1

CALENDAR NAME

Textual name of the business Calendar

 

2

CALENDAR YEAR CODE

Unique warehouse key of the Year, in the Calendar.

 

3

CALENDAR YEAR DESC

Calendar year description.

 

4

CALENDAR YEAR END DATE

Calendar year end date.

12/31/2005 12:00:00 AM

5

CALENDAR YEAR NUMBER

Calendar year number.

 

6

CALENDAR YEAR START DATE

Calendar year start date.

12/31/2005 0:00

7

CALENDAR YEAR TIMESPAN

The length, in terms of days, of this year in the Calendar. For example: 365 days

 

Table 3-32 shows Calendar Half Year: It captures information relating to half year in a Business Calender.

Table 3-32 Calendar Half Year

Sr. Number Attribute Description Sample Value

1

CALENDAR HALF YEAR CODE

Unique warehouse key of the half year, in the Calendar.

 

2

CALENDAR HALF YEAR DESC

Calendar half year description.

 

3

CALENDAR HALF YEAR END DATE

Calendar half year end date.

12/31/2005 12:00:00 AM

4

CALENDAR HALF YEAR NUMBER

A numeric representation of half year number in the Calendar. It contains values 1 or 2.

 

5

CALENDAR HALF YEAR START DATE

Calendar half year start date.

12/31/2005 0:00

6

CALENDAR HALF YEAR TIMESPAN

The length, in terms of days, of this half year in the Calendar. For example: 178 days

 

7

CALENDAR YEAR CODE

Unique key of the year, in which this half year occurred in the Calendar.

 

8

CALENDAR YEAR START DAY CODE

Code for calendar year start day

 

Table 3-33 shows Calendar Quarter: It captures information relating to half year in a Business Calendar.

Table 3-33 Calendar Quarter

Sr. Number Attribute Description Sample Value

1

CALENDAR HALF YEAR CODE

Unique key of the half year

20050101

2

CALENDAR HALF YEAR START DAY CODE

Calendar year start date

20050101

3

CALENDAR QUARTER CODE

Unique key of Calendar quarter

20050101

4

CALENDAR QUARTER DESC

Description for Calendar quarter

CY 2005 Q1

5

CALENDAR QUARTER END DATE

Calendar year end date

12/31/2005 0:00

6

CALENDAR QUARTER NUMBER

Number for Calendar quarter

 

7

CALENDAR QUARTER START DATE

Calendar year start date

12/31/2005 0:00

8

CALENDAR QUARTER TIMESPAN

The length, in terms of days, of this quarter

 

9

CALENDAR YEAR CODE

Unique key of the year, in which this half year occurred in the Calendar.

20050101

10

CALENDAR YEAR START DAY CODE

Code for year start date

20050101


Table 3-34 shows Calendar Month: It captures information relating to a month in a Calendar.

Table 3-34 Calendar Month

Sr. Number Attribute Description Sample Value

1

CALENDAR HALF YEAR CODE

Unique warehouse key for half year

20050101

2

CALENDAR HALF YEAR START DAY CODE

Unique warehouse key for year start day

 

3

CALENDAR MONTH CODE

Unique warehouse key of the month, in the Calendar.

20050101

4

CALENDAR MONTH DESC

Calendar month description.

 

5

CALENDAR MONTH END DATE

Calendar month end date.

12/31/2005 12:00:00 AM

6

CALENDAR MONTH NUMBER

A numeric representation of the month number in the Calendar. It ranges from 1 to 12.

 

7

CALENDAR MONTH START DATE

Calendar month start date.

12/31/2005 0:00

8

CALENDAR MONTH TIMESPAN

The length, in terms of days, of this month in the Calendar. For example: 30 days

 

9

CALENDAR QUARTER CODE

Unique key of the quarter, in which this month occurred in the Calendar.

20050101

10

CALENDAR QUARTER START DAY CODE

Unique warehouse key for quarter start day

 

11

CALENDAR YEAR CODE

Unique warehouse key for year

20050101

12

CALENDAR YEAR START DAY CODE

Unique warehouse key year start day

 

Table 3-35 shows Calendar Half Month: It captures information relating to a Fortnight in a Business Calendar.

Table 3-35 Calendar Half Month

Sr. Number Attribute Description Sample Value

1

CALENDAR HALF MONTH CODE

Unique warehouse key of the Fortnight, in the Calendar.

20050101

2

CALENDAR HALF MONTH DESC

Calendar half month description.

 

3

CALENDAR HALF MONTH END DATE

Calendar half month end date.

12/31/2005 12:00:00 AM

4

CALENDAR HALF MONTH NUMBER

A numeric representation of the fortnight number in the Calendar. It ranges from 1 to 24.

 

5

CALENDAR HALF MONTH START DATE

Calendar half month start date

 

6

CALENDAR HALF MONTH TIMESPAN

The length, in terms of days, of this fortnight in the Calendar. For example: 15 days

 

7

CALENDAR HALF YEAR CODE

Unique warehouse key for half year.

 

8

CALENDAR HALF YEAR START DAY CODE

Unique warehouse key for half year start day

 

9

CALENDAR MONTH CODE

Unique key of the month, in which this fortnight occurred in the Calendar.

20050101

10

CALENDAR MONTH START DAY CODE

Unique warehouse key for month start day

 

11

CALENDAR QUARTER CODE

Unique warehouse key for quarter

20050101

12

CALENDAR QUARTER START DAY CODE

Unique warehouse key for quarter start day

 

13

CALENDAR YEAR CODE

Unique warehouse key for year

20050101

14

CALENDAR YEAR START DAY CODE

Unique warehouse key for year start day

 

Table 3-36 shows Day: It captures information relating to a day.

Table 3-36 Day

Sr. Number Attribute Description Sample Value

1

CALENDAR CURRENT IND

Calendar current indicator 'Y' or 'N'

 

2

CALENDAR DATE

Calendar date.

 

3

CALENDAR DATE DESC

Calendar date description.

 

4

CALENDAR DAY OF YEAR

Calendar day of year.

 

5

CALENDAR DAY TIMESPAN

The length, in terms of days.

 

6

CALENDAR END DATE

Calendar end date

12/31/2005 0:00

7

CALENDAR HALF MONTH CODE

Calendar Half Month Code

20050101

8

CALENDAR HALF MONTH DESC

Calendar half month description.

 

9

CALENDAR HALF MONTH END DATE

Calendar half month end date

12/31/2005 0:00

10

CALENDAR HALF MONTH NUMBER

A numeric representation of the month number in the Calendar. It ranges from 1 to 12.

 

11

CALENDAR HALF MONTH START DATE

Calendar half month start date.

12/31/2005 0:00

12

CALENDAR HALF MONTH START DAY CODE

The unique identifier for a calendar half month start day.

 

13

CALENDAR HALF MONTH TIMESPAN

The length, in terms of days, of this fortnight in the Calendar. For example: 15 days

 

14

CALENDAR HALF YEAR CODE

The unique identifier for a calendar half year.

20050101

15

CALENDAR HALF YEAR DESC

Calendar half year description.

 

16

CALENDAR HALF YEAR END DATE

Calendar half year description,

12/31/2005 0:00

17

CALENDAR HALF YEAR NUMBER

A numeric representation of half year number in the Calendar. It contains values 1 or 2.

 

18

CALENDAR HALF YEAR START DATE

Calendar half year start date.

12/31/2005 0:00

19

CALENDAR HALF YEAR START DAY CODE

The unique identifier for a calendar half year start day.

20050101

20

CALENDAR HALF YEAR TIME SPAN

The length, in terms of days, of this half year in the Calendar. For example: 178 days

 

21

CALENDAR HOLIDAY IND

It indicates holiday indicator 'Y' or 'N'

 

22

CALENDAR MONTH CODE

The unique identifier for a calendar month.

20050101

23

CALENDAR MONTH DESC

Calendar month description.

 

24

CALENDAR MONTH END DATE

Calendar month end date.

12/31/2005 0:00

25

CALENDAR MONTH NUMBER

A numeric representation of the month number in the Calendar. It ranges from 1 to 12.

 

26

CALENDAR MONTH START DATE

Calendar month start date.

12/31/2005 0:00

27

CALENDAR MONTH START DAY CODE

The unique identifier for a calendar month start day

20050101

28

CALENDAR MONTH TIME SPAN

The length, in terms of days, of this month in the Calendar. For example: 30 days

 

29

CALENDAR QUARTER CODE

The unique identifier for calendar quarter.

20050101

30

CALENDAR QUARTER DESC

Calendar quarter description.

 

31

CALENDAR QUARTER END DATE

Calendar quarter end date.

12/31/2005 0:00

32

CALENDAR QUARTER NUMBER

Number for Calendar quarter

 

33

CALENDAR QUARTER START DATE

Calendar quarter start date.

12/31/2005 0:00

34

CALENDAR QUARTER START DAY CODE

The unique identifier for a calendar quarter start day.

20050101

35

CALENDAR QUARTER TIMESPAN

The length, in terms of days, of this quarter

 

36

CALENDAR START DATE

Calendar Start Date

12/31/2005 0:00

37

CALENDAR WEEK CODE

The unique identifier for calendar week.

20050101

38

CALENDAR WEEK DAY

Calendar week day

 

39

CALENDAR WEEK DAY CODE

The unique identifier for a calendar week day.

20050101

40

CALENDAR WEEK DAY DESCRIPTION

Calendar week day description.

 

41

CALENDAR WEEK DESC

Calendar week description.

 

42

CALENDAR WEEK END DATE

Calendar week end date.

12/31/2005 0:00

43

CALENDAR WEEK NUMBER

A numeric representation of the week number in the Calendar.

 

44

CALENDAR WEEK START DATE

Calendar week start date

12/31/2005 0:00

45

CALENDAR WEEK TIMESPAN

The length, in terms of days, of this week

 

46

CALENDAR WEEKEND IND

It indicates calendar weekend indicator 'Y' or 'N'

 

47

CALENDAR WORKING DAY IND

It indicates the calendar working day indicator 'Y' or 'N'

 

48

CALENDAR YEAR CODE

The unique identifier for a calendar year.

20050101

49

CALENDAR YEAR DESC

Calendar week description.

 

50

CALENDAR YEAR END DATE

Calendar year end date.

12/31/2005 0:00

51

CALENDAR YEAR NUMBER

A numeric representation of the year number in the Calendar.

 

52

CALENDAR YEAR START DATE

Calendar year start date.

12/31/2005 0:00

53

CALENDAR YEAR START DAY CODE

The unique identifier for a calendar year starts date.

 

54

CALENDAR YEAR TIME SPAN

The length, in terms of days, of this year in the Calendar. For example: 365 days

 

55

CALENDAR WEEK START DAY CODE

The unique identifier for a calendar week starts date.

20050101

56

DAY CODE

The unique identifier for a calendar date

 

Call Category

Description: CALL CATEGORY

Call Category Hierarchies

Standard Call Category Hierarchy:

Description of image015.gif follows
Description of the illustration image015.gif

Call Category Levels

Table 3-37 shows Call Category Total: All Call Category are most aggregate level of the dimension.

Table 3-37 Call Category Total

Sr. Number Attribute Description

1.

CALL CATEGORY TOTAL

Code for All Call Categories.


Table 3-38 shows Call Category Detail: All Call Category is most aggregate level of the dimension.

Table 3-38 Call Category Detail

Sr. Number Attribute Description Sample Value

1

CALL CATEGORY CODE

Code for Call Category.

DATA

2

CALL CATEGORY DESC

Description of the Call Category.

Data Call

3

CALL CATEGORY NAME

Short description of the Call Category.

Data Call


Call Center Agent

Description: CALL CENTER AGENT

Call Center Agent Hierarchy

Standard Call Center Agent Hierarchy:

Description of image016.gif follows
Description of the illustration image016.gif

Call Center Agent Levels

Table 3-39 shows Call Center Agent Total: All call center agent are most aggregate level of the dimension.

Table 3-39 Call Center Agent Total

Sr. Number Attribute Description

1.

CALL CENTER AGENT TOTAL

Code for All Call Center Agent Subscribers.


Table 3-40 shows Call Center Agent Type: The type of Call Center Agent. Examples includes: Employee, IVR.

Table 3-40 Call Center Agent Type

Sr. Number Attribute Description Sample Value

1

CALL CENTER AGENT TYPE DESC

Description of the Agent type.

AUTO

2

CALL CENTER AGENT TYPE NAME

Name of Agent type.

 

3

LANGUAGE CODE

Uniquely identifier of language

 

4

CALL CENTER AGENT TYPE CODE

   

The next table shows Call Center Agent Detail: Detail level of the dimension. Stores the Call Center Agent Information.

Table 3-41 Call Center Agent Detail

Sr. Number Attribute Description Sample Value

1

CALL CENTER AGENT CODE

All the possible agents with whom the customer can make a contact like IVR, Human Agent, Corporate agent, CRC, and so on.

CODE-1

2

CALL CENTER AGENT DESC

Description of the Agent.

 

3

CALL CENTER AGENT NAME

Name of Agent.

HUMAN

4

CALL CENTER AGENT TYPE CODE

Foreign key, to indicate which type this agent is, for example: Auto, Human.

 

5

CALL CENTER CODE

Uniquely identifier of call center

 

6

     

7

BILLING ADDRESS EFFECTIVE DATE

Date on which the billing address referenced in the billing_address_id column became active. This facilitates queries such as find customers who changed address in the last 3 months.""

 

8

BUSINESS DIVISION EXECUTIVE NAME

BUSINESS DIVISION EXECUTIVE LAST NAME is the last name of the business division executive to whom the employee reports to. Like LOB Owner.

 

9

BUSINESS PHONE NUMBER

Phone number used for business purpose

 

10

CELL PHONE NO

Redundancy to 'party contact information'

 

11

CHILDREN COUNT

Number of children

 

12

CONTACT ADDRESS EFFECTIVE DATE

Date on which the contact address referenced in the billing_address_id column became active. This facilitates queries such as find customers who changed address in the last 3 months.""

 

13

COST CENTER NUMBER

The cost center to which the bank employee expenses are charged.

 

14

DATE OF BIRTH

Date of Birth of the individual.

 

15

DATE OF DEATH

Date of natural person death.

 

16

DEATH CERTIFICATE CODE

The certification document number for customer's death.

 

17

DEPENDENTS COUNT

Number of dependents

 

18

DRIVER LICENSE NUMBER

Driver License Number in most countries.

 

19

DWELLING SIZE

Size of dwelling

 

20

DWELLING TENURE

Tenure of dwelling

 

21

ECONOMICALLY ACTIVE IND

customer is economically active (is not a minor or pensioner and so on.)

 

22

EDUCATION CODE

The customer highest level of education.

 

23

EMAIL

Redundancy to 'party contact information'

 

24

EMPLOYEE CODE

A code for any person or business that is of interest to the Communications Service Provider.

 

25

EMPLOYEE DESIGNATION CODE

Unique warehouse key, representing the designation

 

26

EMPLOYEE DISCOUNT GROUP CODE

Unique identifier for Employee Discount Group

 

27

EMPLOYEE KEY

Key value for each employee

 

28

EMPLOYEE NUMBER

Internal number for the employee.

 

29

EMPLOYEE TYPE CODE

Unique identifier for Employee Type

PT

30

EMPLOYEE TYPE DESC

Description of the Employee Type

Part Time

31

EMPLOYEE TYPE NAME

Unique identifier for the Employee Type

Part Time

32

EMPLOYER TAX NUMBER

The tax code of Employer.

 

33

EMPLOYMENT BEGIN DATE

Start date for the employment.

12/31/2005 12:00:00 AM

34

EMPLOYMENT END DATE

If the employee quit, holds the information of past employment.

 

35

EMPLOYMENT EXEMPT IND

An employee is exempt from the overtime policies due to the nature of the work, as compared to (Non-Exempt).

Education requirements of the position and salary range. These employees are paid an annual salary and are not customarily eligible for overtime pay.

 

36

EMPLOYMENT STATUS

EMPLOYEE STATUS is the abbreviated identifier for the employment status. Employee

 

37

END OF JOB CONTRACT

End date of the customer's job contract (for contracts concluded for definite terms).

 

38

ETHNIC BACKGROUND

Customer Attribute of an employee

 

39

ETHNICITY

Classifies the individual for minority reporting purposes.

 

40

FAMILY NAME IN MAIDEN

Given name in maiden

 

41

FIRST NAME

First name of a party individual

 

42

FORM OF EMPLOYMENT

The customer's form of employment (private entrepreneur, employee, civil servant and so on.)

 

43

GENDER CODE

For PARTYs that are people, this is their GENDER.

For PARTYs that are organizations, this is indicates whether the organization is foreign or domestically owned.

 

44

GIVEN NAME IN MAIDEN

Given name in maiden

 

45

HOME TELEPHONE NO

Redundance to 'party contact information'

 

46

HOUSEHOLD KEY

The code of household which the party belongs to.

 

47

INCOME

Income of a party individual

 

48

INCOME LCL

Income of a party individual

 

49

INCOME RPT

Income of a party individual

 

50

JOB CONTRACT TYPE

Type of the customer's job contract

 

51

JOB KEY

Code for job of subscriber.

 

52

JOB POSITION

job Position.

 

53

LANGUAGE CODE

Unique identifier for Language

 

54

LAST NAME

Last name of a party individual

 

55

LAST PERFORMANCE RATING

This describes the annual rating assigned to the employee.

 

56

LAST PERFORMANCE RATING DATE

When the last rating is done.

 

57

LEGAL TITLE TO HOUSING

The customer's legal title to home (rents, owns and so on.)

 

58

LIVING AT CURRENT ADDRESS SINCE

Date since the customer has lived at the present address.

 

59

MANAGER CODE

manager's employee code.

 

60

MARITAL STATUS

CSALADI ALLAPOT. Marital status

 

61

MARTIAL STATUS CODE

   

62

MIDDLE NAME

Middle name of a party individual

 

63

MOTHER FIRST NAME

Mother's first name

 

64

MOTHER LAST NAME

Mother's last name

 

65

NAME OF WORKPLACE

Name of workplace

 

66

NAME PREFIX

Name prefix

For example: Mr, Mrs, Ms, Dr,

 

67

NAME SUFFIX

Name suffix. For example: PhD, MD, JD, MA

 

68

NATIONALITY CODE

Code for Nationality of subscriber

 

69

NUMBER OF EARNERS IN HOUSEHOLD

Number of wage earners in the household.

 

70

NUMBER OF PERSONS LIVING IN HOUSEHOLD

Number of persons sharing the customer's household.

 

72

OFFICE TELEPHONE NO

Redundancy to 'party contact information'

 

73

ORGANIZATION BUSINESS UNIT KEY

   

74

PERSONAL ID NUMBER

   

75

PLACE OF BIRTH

Where the person was born.

 

76

PREVIOUS EMPLOYER TAX NUMBER

Tax number of previous employer.

 

77

PREVIOUS EMPLOYMENT END DATE

End date of previous job.

 

78

PREVIOUS EMPLOYMENT START DATE

Start date of previous job.

12/31/2005 12:00:00 AM

79

SOC JOB KEY

   

80

SOCIAL SECURITY NUMBER

Null if a country does not have this number.

 

81

SOURCE OF INCOME

Source of income (can typify, may be several)

 

82

START OF EMPLOYMENT

Start of employment

 

83

TAX NUMBER

Tax number

 

84

ACTIVE IND

Activate Indicator

 

85

ADDRESS

Address

 

86

BARING REASON CODE

Unique identifier for Baring Reason

 

87

BUSINESS LEGAL STATUS CODE

A unique identifier for a legal classification of a non-residential Customer.

 

88

CITY

City of the party. Redundance to party location history.

 

89

COUNTRY

Country of the party. Redundance to party location history.

 

90

CUSTOMER IND

Indicator for Customer

 

91

EFFECTIVE FROM DATE

EFFECTIVE FROM DATE, standard SCD2 column.

 

92

EFFECTIVE TO DATE

EFFECTIVE TO DATE, standard SCD2 column.

 

93

EMPLOYEE NAME

Name of the employee

 

94

PARTY DESC

Description for the Party

 

95

PARTY KEY

Key value for Party

 

96

PARTY NAME

Name of the Party

 

97

PARTY TYPE CODE

Unique identifier for Party Type

 

98

POST CODE

Unique identifier for Post

 

99

SOURCE SYSTEM KEY

Key value for Source System

 

100

STATE

State Name

 

101

STATUS CODE

Current Status

 

Call Center Case Title

Description: CALL CENTER CASE TITLE

Call Center Case Title Hierarchies

Standard Call Center Case Title Hierarchy:

Description of image101.gif follows
Description of the illustration image101.gif

Call Center Case Levels

Table 3-42 shows Call Center Case Title Total: All call center case title are most aggregate level of the dimension.

Table 3-42 Call Center Case Title Total

Sr. Number Attribute Description

1.

CALL CENTER CASE TITLE TOTAL

Total of all call center case titles.


Table 3-43 shows Call Center Case Title Detail: Detail level of the dimension. Stores the Call Center Case Title Information.

Table 3-43 Call Center Case Title Detail

Sr. Number Attribute Description Sample Value

1

CALL CENTER CASE SUB TYPE CODE

Code or Id for Call Center Case Sub Type.

 

2

CALL CENTER CASE TITLE CODE

Code or Id for Call Center Case Title.

CBPWD

3

CALL CENTER CASE TITLE DESC

Description of the Call Center Case Title.

 

4

CALL CENTER CASE TITLE NAME

Name of Call Center Case Title.

 

5

LANGUAGE CODE

Uniquely identifier of language

 

Call Center

Description: CALL CENTER

Call Center Hierarchies

Standard Call Center Hierarchy:

Description of image018.gif follows
Description of the illustration image018.gif

Call Center Levels

Table 3-44 shows Call Center Total: All call centers is most aggregate level of the dimension.

Table 3-44 Call Center Total

Sr. Number Attribute Description

1.

CALL CENTER TOTAL

Code for All Call Centers.


Table 3-45 shows Call Center: Detail level of the dimension. Stores the Call Center Information.

Table 3-45 Call Center Detail

Sr. Number Attribute Description

1

CALL CENTER CODE

CODE-1

2

NUMBER OF EMPLOYEES

NUMBER OF EMPLOYEES.

3

NUMBER OF LINES

How many telephone lines (trunk) are offered.

4

PRIMARY LANGUAGE

The language/Dialects the call center can support.

5

ACCOUNT CLERK CODE

This field is client specific. The definition and use of this field is customizable for each client.

6

ADDRESS LINE 1

Address. Line one of detailed postal address

7

ADDRESS LINE 2

Address. Line two of detailed postal address

8

ADDRESS LINE 3

Address. Line three of detailed postal address

9

ADDRESS LOCATION CODE

Unique identifier for the address. unique identifier for the address location

10

ADDRESS TYPE CODE

Unique identifier of the address type.

11

ADDRESS USAGE

Describes how the address is used

12

ANNUAL REVENUE

Revenue of the company.

13

ANNUAL REVENUE LOCAL

Revenue of the company.

14

ANNUAL REVENUE REPORTING

Revenue of the company.

15

ANNUAL SALES

Sales for Annual

16

ANNUAL SALES LOCAL

Local Sales for Annual

17

ANNUAL SALES REPORTING

Reporting Sales for Annual

18

BANKRUPTCY END DATE

The end date of bankruptcy. If current date is behind start and end date is null, then the company is undergoing the bankruptcy process.

19

BANKRUPTCY START DATE

start date of bankruptcy.

20

BUSINESS ENTITY CODE

Unique Identifier for Business Entity

21

BUSINESS UNIT CONCEPT

Possible values include, Convenience, General Merchandise, Category dominant anchors with few small tenants, Fashion, Higher-end (Upscale), Fashion oriented, Manufacturer's Outlet, Leisure, Tourist oriented and Discount.

22

BUSINESS UNIT TYPE CODE

Unique identifier of the business unit type

23

CHAIRMAN CODE

Connect to Another Person Party who is responsible for this Organization.

24

CHANNEL TYPE CODE

Unique identifier of the channel type

25

COMPANY REGISTRY NUMBER

Will be same as Party. National_Identifier. Natural Key for Organization.

26

CONSTRUCTION STATUS

Identifies the status of the site such as 'Under Construction', 'New', and so on.

27

CONTACT CODE

ID of the contact person for the organization.

28

CONTACT NAME

Contact Employee for organization.

29

CONTACT NUMBER

This is the number for the method specified to contact this site. There can be multiple contact numbers of each type for each site.

30

CONTACT TYPE CODE

This is the general method to use to contact a site, that is, Phone, Fax, Telex, and so on.

31

COURT CODE

Code of the law of court.

32

DOMESTIC INDICATOR

For PARTYs that are organizations, this indicates whether the organization is foreign or domestically owned.

33

DUNS NUMBER

DUNS NUMBER is an identifier for organization.

34

EMPLOYEE COUNT

Total number of employee in the company or organization.

35

EQUITY AMOUNT

The equity value of the company/org.

36

EQUITY AMOUNT LOCAL

The equity value of the company/org.

37

EQUITY AMOUNT REPORTING

The equity value of the company/org.

38

EXTERNAL NAME

Name/Number assigned to site for electronic communication. For example: EDI transactions.

39

FINAL SETTLEMENT END DATE

End date of final settlement.

40

FINAL SETTLEMENT START DATE

Start date of final settlement

41

JUDICIAL DISTRAINT CODE

Case identifier of the judicial distraint

42

JUDICIAL DISTRAINT DATE

Date of the judicial distraint

43

LIQUIDATION END DATE

The date when the company/org was liquidated. If is null and start_date is not null, the company is undergoing the liquidation.

44

LIQUIDATION START DATE

Start date of liquidation

45

LOCATION TYPE CODE

Unique identifier for location type

46

LONG DESCRIPTION

The 10 character abbreviation of the store name

47

MANAGER CODE

ID of the manager for the organization.

48

MANAGER EMPLOYEE NUMBER

Unique key denoting the employee number of the employee's manager.

49

MANAGER NAME

Name of manager for the whole company.

50

ORGANIZATION BANNER CODE

 

51

ORGANIZATION BUSINESS UNIT CODE

Unique identifier for Business Unit. To identify whether the site is a store, distribution center or warehouse.

52

ORGANIZATION BUSINESS UNIT TYPE CODE

Unique identifier for Organization business unit type

53

ORGANIZATION CODE

The unique identifier of the organization

54

ORGANIZATION DISTRICT CODE

District code of ORGANIZATION DISTRICT

55

ORGANIZATION DIVISION CODE

Division code of a ORGANIZATION

56

ORGANIZATION NAME

Name of the organization

57

ORGANIZATIONAL DEMOGRAPHY VALUE CODE

Unique identifier for organization demographic value

58

PAYMENT ACCOUNT CLOSE DATE

Closing date of the account for payments.

59

PAYMENT ACCOUNT NUMBER

Account number for payments.

60

PAYMENT ACCOUNT OPEN DATE

Opening date of the account for payments.

61

POSTAL PLUS CODE

Four digit extension to the United States Postal ZIP code.

62

POSTCODE

Postal codes of interest to the Retail Organization

63

PRIMARY ADDRESS TELEPHONE

Default Address Telephone Number

64

PRIMARY BUSINESS UNIT CALENDAR CODE

Primary Business Unit Calendar Code

65

PRIMARY CURRENCY ISO CODE

The unique ISO standard identifier of the CURRENCY

66

PRIMARY EMAIL ADDRESS

Default Email Address

67

PRIMARY MARKET AREA CODE

Market area code under which the business unit falls

68

PRIMARY TRADE AREA CODE

Primary Trade area code, under which the business unit falls

69

SEAL IMAGE

The image of the Organization's Seal, or the Artificial Person's Signature.

70

SECONDARY DESCRIPTION

The secondary description or name of the store or warehouse.

72

SHOPPING CENTER TYPE

Shopping center is group of retail and other commercial establishments that is planned, developed, owned, and managed as a single property.=- Strip Center (Neighborhood, Community)- Mall (Power, Super Regional, Regional, Fashion/Specialty, Lifestyle, Outlet, Theme/Festival)

73

SHORT DESCRIPTION

The 3 character abbreviation of the store name.

74

STOCK EXCHANGE NAME

Abbreviation of listed companies as used on the stock exchange.

75

TAX EXEMPT STATUS

Indicates if the org. is tax exempt.

76

TERMINATION DATE

Termination date of the company in case of company was founded with termination date.

77

TIME ZONE

It denotes which TimeZone the Site is in.

78

TOTAL LINEAR DISTANCE

The total linear selling space of the location.

79

VALIDATION END DATE

Effective date of the deletion of the company's record from the company register.

70

SECONDARY DESCRIPTION

The secondary description or name of the store or warehouse.

80

VALIDATION START DATE

Date of the registration of the company' record deletion from the company register.

81

VAT INCLUDE INDICATOR

Indicates whether the Value Added Tax will be included in the retail prices for the store. Valid values are 'Y' or 'N'

82

VAT REGION

The number of the Value Added Tax region in which this store or warehouse is contained.

83

PARTY CODE

 

84

PARTY TYPE CODE

 

85

BUSINESS LEGAL STATUS CODE

 

86

SOURCE SYSTEM CODE

 

87

BARING REASON CODE

 

88

STATUS CODE

 

89

CITY

 

90

STATE

 

91

COUNTRY

 

92

PARTY NAME

 

93

PARTY DESC

 

94

ADDRESS

 

95

ACTIVE INDICATOR

 

96

CUSTOMER INDICATOR

 

97

EFFECTIVE FROM DATE

 

98

EFFECTIVE TO DATE

 

Call Direction

Description: CALL DIRECTION

Call Direction Hierarchies

Standard Call Direction Hierarchy:

Description of image019.gif follows
Description of the illustration image019.gif

Call Direction Levels

Table 3-46 shows Call Direction Total: All Call Directions are most aggregate level of the dimension.

Table 3-46 Call Direction Total

Sr. Number Attribute Description

1.

ALL CALL DIRECTION CODE

Code for Call Directions.


Table 3-47 shows Call Direction Detail: Detail level of the dimension. Stores the Call Direction Information.

Table 3-47 Call Direction Detail

Sr. Number Attribute Description Sample Value

1

CALL DIRECTION CODE

Code for call direction.

IN

2

CALL DIRECTION DESC

Description of call direction.

To indicate incoming call

3

CALL DIRECTION NAME

Name of the call direction.

IN

4

LANGUAGE CODE

Unique identifier for Language

 

Call Other Type

Description: CALL OTHER TYPE

Call Other Type Hierarchies

Standard Call Other Type Hierarchy:

Description of image020.gif follows
Description of the illustration image020.gif

Call Other Type Levels

Table 3-48 shows Call Other Type Total: All Call Other Types are most aggregate level of the dimension.

Table 3-48 Call Other Type Total

Sr. Number Attribute Description

1.

ALL CALL OTHER TYPE CODE

Code for Call Other Types.


Table 3-49 shows Call Other Type Detail: Detail level of the dimension. Stores the Call other Type Information.

Table 3-49 Call Other Type Detail

Sr. Number Attribute Description Sample Value

1

CALL OTHER TYPE CODE

A code used to uniquely identify a category of Special Services that a Call may utilize. Examples include: 1 - Directory Assistance 2 - 800 3 - 900 4 - 911 5 - Customer Service 6 - Voice Mail.

CUSTSRVC

2

CALL OTHER TYPE DESC

A textual description of a Call Special Service Type.

Customer Service

3

CALL OTHER TYPE NAME

The name assigned to a Call Special Service Type. Examples include: Directory Assistance 800 900 911 Customer Service Voice Mail.

Customer Service

4

LANGUAGE CODE

Unique identifier for Language

 

Call Routing Type

Description: CALL ROUTING TYPE

Call Routing Type Hierarchies

Standard Call Routing Type Hierarchy:

Description of image021.gif follows
Description of the illustration image021.gif

Call Routing Type Levels

Table 3-50 shows Call Routing Type Total: All Call Routing Type are most aggregate level of the dimension.

Table 3-50 Call Routing Type Total

Sr. Number Attribute Description

1.

ALL CALL ROUTING CODE

Code for All Call Routing Subscribers.


Table shows Call Routing Type Detail: Detail level of the dimension. Stores the Call Routing Type Information.

Table 3-51 Call Routing Type Detail

Sr. Number Attribute Description Sample Value

1

CALL ROUTING TYPE CODE

The code for the type can use number or character.

ATA

2

CALL ROUTING TYPE DESC

Full Description.

Call was routed from Air To Air

3

CALL ROUTING TYPE NAME

The short name for the type.

Air To Air

4

LANGUAGE CODE

Uniquely identifier of language

 

Call Service Type

Description: CALL SERVICE TYPE

Call Service Type Hierarchies

Standard Service Type Hierarchy:

Description of image022.gif follows
Description of the illustration image022.gif

Call Service Type Levels

Table 3-52 shows Call Service Type Total: All Call Service Type are most aggregate level of the dimension.

Table 3-52 Call Service Type Total

Sr. Number Attribute Description

1.

CALL SERVICE TYPE TOTAL CODE

Code for All Call Service Type.


Table 3-53 shows Call Service Type Detail: Detail level of the dimension. Stores the Call Service Type Information.

Table 3-53 Call Service Type Detail

Sr. Number Attribute Description Sample Value

1

CALL SERVICE TYPE CODE

The code.

1

2

CALL SERVICE TYPE DESC

The full description.

Fire

3

CALL SERVICE TYPE NAME

The title.

Fire

4

LANGUAGE CODE

Uniquely identifier of language

 

Call Source Destination

Description: CALL SOURCE DESTINATION

Call Source Destination Hierarchies

Standard Call Source Destination Hierarchy:

Description of image023.gif follows
Description of the illustration image023.gif

Call Source Destination Levels

Table 3-54 shows Call Source Destination Total: All Call Source Destination are most aggregate level of the dimension.

Table 3-54 Call Source Destination Total

Sr. Number Attribute Description

1.

CALL SOURCE DESTINATION TOTAL

Code for All Call Source Destination


Table 3-55 shows Call Source Destination Detail: Detail level of the dimension. Stores the Call Source Destination Information.

Table 3-55 Call Source Destination Detail

Sr. Number Attribute Description Sample Value

1

CALL SOURCE DESTINATION CODE

Code for call destination.

8675583965191

2

CALL SOURCE DESTINATION DESC

Description of call destination.

8675583965191

3

CALL SOURCE DESTINATION NAME

Name of the destination.

8675583965191

4

DESTINATION TYPE CODE

Unique identifier of destination type.

 

5

EFFECTIVE FROM DATE

Active from. Standard SCD field, Effective Start Date

12/31/2005 12:00:00 AM

6

EFFECTIVE TO DATE

Date the party left the program. Will be null if the party is currently a member of the program.

 

7

NETWORK TYPE CODE

Unique identifier of destination network type.

 

8

NUMBER AREA CODE

Area code. For example: 713-Houston

 

9

NUMBER NETWORK TYPE CODE

Unique identifier of destination network type.

 

10

STATUS CODE

Current status of the assignment.

 

Call Success Fail Type

Description: CALL SUCCESS FAILURE TYPE

Call Successful Fail Hierarchies

Standard Call Success Fail Hierarchy:

Description of image024.gif follows
Description of the illustration image024.gif

Call Success Fail Type Levels

Table 3-56 shows Call Successful Fail Total: All Call Successful/failed is most aggregate level of the dimension.

Table 3-56 Call Successful Fail Total

Sr. Number Attribute Description

1.

ALL SUCCESSFUL/FAILED CODE

Code for All Call Successful/failed.


Table 3-57 shows Call Successful Fail Detail: Detail level of the dimension. Stores the Successful/failed Detail Information.

Table 3-57 Call Successful Fail Detail

Sr. Number Attribute Description Sample Value

1

CALL SUCCESS FAILURE TYPE CODE

Call Success failure id.

FAIL

2

CALL SUCCESS FAILURE TYPE DESC

Call Success failure description.

Fail

3

CALL SUCCESS FAILURE TYPE NAME

Call Success failure short description.

Fail

4

LANGUAGE CODE

Language ID---Unique identifier for a row in the Language dimension.

 

Call Type

Description: CALL TYPE

Call Type Hierarchies

Standard Call Type Hierarchy:

Description of image025.gif follows
Description of the illustration image025.gif

Call Type Levels

Table 3-58 shows Call Type Total: All Call Type are most aggregate level of the dimension.

Table 3-58 Call Type Total

Sr. Number Attribute Description

1.

ALL CALL TYPE CODE

Code for All Call Type Subscribers.


Table 3-59 shows Call Type Detail: Detail level of the dimension. Stores the Call Type Information.

Table 3-59 Call Type Detail

Sr. Number Attribute Description Sample Value

1

CALL CATEGORY CODE

The code for the call category.

VOI

2

CALL TYPE CODE

The code for the call type.

INTL

3

CALL TYPE DESC

The Full Description.

International

4

CALL TYPE NAME

The title.

International

5

LANGUAGE CODE

Language ID---Unique identifier for a row in the Language dimension.

 

Campaign

Description: CAMPAIGN

Campaign Hierarchies

Standard CAMPAIGN Hierarchy:

Description of dim_campaign.png follows
Description of the illustration dim_campaign.png

Campaign Levels

The following table shows CAMPAIGN Total: All CAMPAIGN is the most aggregate level of the dimension.

Table for CAMPAIGN Total

Sr. Number Attribute Description
1. CAMPAIGN TOTAL Code for All CAMPAIGN.

Detail table shows CAMPAIGN Detail: All CAMPAIGN types is the most aggregate level of the dimension.

Detail table CAMPAIGN Detail

Sr. Number Attribute Description
1 CAMPAIGN DESC A textual description of the Campaign.
2 PRIORITY Campaign priority
3 PLANNED RESPONSE Expected or planned response for the campaign.
4 GLOBAL IND Flag to indicate if the campaign is run globally.
5 PARTNER NUMBER Identification number for partner.
6 COST CODE Identify the cost to the Carrier.
7 PARTNER IND Indicates if the campaign has partners
8 PLANNED COST Planned or budgeted total cost for the campaign.
9 PLANNED COST LOCAL Planned or budgeted total cost for the campaign.
10 PLANNED COST REPORTING Planned or budgeted total cost for the campaign.
11 FUND SOURCE CODE Possible values would include, Vendor Sponsored, Charity, and so on.
12 EFFECTIVE TO DATE The end date of a Campaign
13 COST AMOUNT REPORTING The monetary cost of a Campaign.
14 COST AMOUNT LOCAL The monetary cost of a Campaign.
15 COST AMOUNT The monetary cost of a Campaign.
16 CAMPAIGN PURPOSE The purpose of the campaign being conducted, in most of scenarios this field would be empty since this would be addressed in the Theme and Promotion Theme. But in the cases this campaign is being executed as a continuation of a previous campaign due to demand this field would contain the reason for that.
17 EFFECTIVE FROM DATE The start date of a Campaign
18 CAMPAIGN TYPE CODE  
19 CAMPAIGN CODE  
20 CAMPAIGN NAME  
21 CAMPAIGN PURPOSE TYPE CODE  
22 CAMPAIGN STATUS CODE  

Campaign Channel

Description: CAMPAIGN CHANNEL

Campaign Channel Hierarchies

Standard Campaign Channel Hierarchy:

Description of image026.gif follows
Description of the illustration image026.gif

Campaign Channel Levels

Table 3-60 shows Campaign Channel Total: All Campaign Channels are most aggregate level of the dimension.

Table 3-60 Campaign Channel Total

Sr. Number Attribute Description

1.

ALL CAMPAIGN CHANNEL CODE

Code for All Campaign Channel.


Table 3-61 shows Campaign Channel Detail: Detail level of the dimension. Stores the Campaign Channel Information.

Table 3-61 Campaign Channel Detail

Sr. Number Attribute Description Sample Value

1

CAMPAIGN CHANNEL CODE

A unique identifier for a campaign channel.

MAGAZINE

2

CAMPAIGN CHANNEL DESC

The name assigned to a campaign channel.

 

3

CAMPAIGN CHANNEL NAME

A textual description of an campaign channel.

 

4

CAMPAIGN CHANNEL TYPE CODE

A code used to uniquely identify a campaign channel type.

MGZN

5

CAPACITY QUANTITY

The number of transaction that a Channel can handle, at a point of time.

 

6

CHANNEL CODE

The unique identifier for each Channel. A Channel identifies each possible link where interaction between the Communications Service Provider and the Customer occurs.

 

7

CHANNEL DESC

Descriptions of the channels

 

8

CHANNEL NAME

The name assigned to a channel.

 

9

CHANNEL TYPE CODE

A code used to uniquely identify a major grouping of Channels. Examples: M - MailT - Telephone TV - Television.

LYLTCHNL

10

EFFECTIVE FROM DATE

The first date of the period when this Channel was valid.

12/31/2005 12:00:00 AM

11

EFFECTIVE TO DATE

The end date of the period when this Channel was valid.

12/31/2005 12:00:00 AM

12

PARTY CODE

A code for any person or business that is of interest to the Communications Service Provider.

 

13

PARTY TYPE CODE

Type of party

RPRSTTV

14

STATUS CODE

Current status.

 

Campaign Media

Description: CAMPAIGN MEDIA

Campaign Media Hierarchies

Standard CAMPAIGN MEDIA Hierarchy:

Description of dim_campaign_m.png follows
Description of the illustration dim_campaign_m.png

Campaign Media Levels

The following table shows CAMPAIGN MEDIA Total: All CAMPAIGN MEDIA is the most aggregate level of the dimension.

Table for CAMPAIGN MEDIA Total

Sr. Number Attribute Description
1. CAMPAIGN MEDIA TOTAL Code for All CAMPAIGN MEDIA.

Detail table shows CAMPAIGN MEDIA Detail: All CAMPAIGN MEDIA types is the most aggregate level of the dimension.

Detail table CAMPAIGN MEDIA Detail

Sr. Number Attribute
1 EVENT NUMBER
2 EFFECT FROM DATE
3 EFFECT TO DATE
4 STATUS CODE
5 CURRENT INDICATOR
6 LONG DSCR
7 LOAD DATE
8 LAST UPDATE DATE
9 LAST UPDATE BY
10 MEDIA TYPE CODE
11 MEDIA CODE
12 VEHICLE
13 ACT STRT DATE
14 W ID
15 CAMPAIGN CODE
16 COMMUNICATION TYPE CODE
17 CAMPAIGN MEDIA CODE
18 SHORT DSCR
19 CAMPAIGN MEDIA CODE _1

Cell Outage Reason

Description: CELL OUTAGE REASON

Cell Outage Reason Hierarchies

Standard Cell Outage Reason Hierarchy:

Description of image029.gif follows
Description of the illustration image029.gif

Cell Outage Levels

Table 3-62 shows Cell Outage Reason Total: All Cell Outage Reason is most aggregate level of the dimension.

Table 3-62 Cell Outage Reason Total

Sr. Number Attribute Description

1.

ALL CELL OUTAGE REASON CODE

Code for All Cell Outage Reason.


Table 3-63 shows Cell Outage Reason Detail: Detail level of the dimension. Stores the Cell Outage Reason Information.

Table 3-63 Cell Outage Reason Detail

Sr. Number Attribute Description Sample Value

1

CELL OUTAGE REASON CODE

Cause for cell outage.

FAIL

2

CELL OUTAGE REASON DESC

Description of CELL OUTAGE REASON

Fail

3

CELL OUTAGE REASON NAME

Name of the CELL OUTAGE REASON

Fail

4

LANGUAGE CODE

Language ID---Unique identifier for a row in the Language dimension.

 

Cell Site

Description: CELL SITE

Cell Site Hierarchies

Standard CELL SITE Hierarchy:

Description of dim_cells.png follows
Description of the illustration dim_cells.png

Cell Site Levels

The following table shows CELL SITE Total: All CELL SITE is the most aggregate level of the dimension.

Table for CELL SITE Total

Sr. Number Attribute Description
1. CELL SITE TOTAL Code for All CELL SITE.

Detail table shows CELL SITE Detail: All CELL SITE types is the most aggregate level of the dimension.

Detail table CELL SITE Detail

Sr. Number Attribute Description
1 CELL SITE TYPE CODE Code.
2 LOCATION AREA CODE ID of the location area of the mobile equipment.
3 CELL SITE CODE The serial number for the cell site.
4 CELL SITE TYPE CODE2  
5 CELL SITE NAME  
6 CELL SITE DESC  

Change Proposed By Type

Description: CHANGE PROPOSED BY TYPE

Change Proposed By Type

Standard CHANGE PROPOSED BY TYPE Hierarchy:

Description of dim_ch_prop_type.png follows
Description of the illustration dim_ch_prop_type.png

Change Proposed By Type

The following table shows CHANGE PROPOSED BY TYPE Total: All CHANGE PROPOSED BY TYPE is the most aggregate level of the dimension.

Table for CHANGE PROPOSED BY TYPE Total

Sr. Number Attribute Description
1. CHANGE PROPOSED BY TYPE TOTAL Code for All CHANGE PROPOSED BY TYPE.

Detail table shows CHANGE PROPOSED BY TYPE Detail: All CHANGE PROPOSED BY TYPE types is the most aggregate level of the dimension.

Sr. Number Attribute
1 CHANGE PROPOSED BY TYPE CODE
2 CHANGE PROPOSED BY TYPE DESC
3 CHANGE PROPOSED BY TYPE NAME
4 LANGUAGE CODE

Channel

Description: CHANNEL

Channel Hierarchies

Standard Channel Hierarchy:

Description of dim_channel.png follows
Description of the illustration dim_channel.png

Channel Levels

The following table shows CHANNEL Total: All CHANNEL is the most aggregate level of the dimension.

Table for CHANNEL Total

Sr. Number Attribute Description
1. ALL CHANNEL CODE Identification for the top level value

Table shows CHANNEL TYPE

Sr. Number Attribute Description
1 CHANNEL TYPE NAME A code used to uniquely identify a major grouping of Channels, such as Mail, Telephone, Television.
2 CHANNEL TYPE CODE A code used to uniquely identify a major grouping of Channels. Examples:M - MailT - Telephone TV - Television
3 CHANNEL TYPE DESC A textual description of a Channel Type.
4 LANGUAGE CODE  

Detail table CHANNEL Detail

Sr. Number Attribute Description
1 PARTY CODE1 A code for any person or business that is of interest to the Communications Service Provider.
2 STATUS CODE Current status
3 EFFECTIVE TO DATE The end date of the period when this Channel was valid
4 EFFECTIVE FROM DATE The first date of the period when this Channel was valid
5 CHANNEL NAME The name assigned to a channel.
6 CAPACITY QUANTITY The number of transaction that a Channel can handle, at a point of time.
7 CHANNEL CODE The unique identifier for each Channel. A Channel identifies each possible link where interaction between the Communications Service Provider and the Customer occurs.
8 PARTY TYPE CODE  
9 CHANNEL TYPE CODE2  
10 CHANNEL DESC  

Collection Agency

Description: COLLECTION AGENCY

Collection Agency Hierarchies

Standard Collection Agency Hierarchy:

Description of image031.gif follows
Description of the illustration image031.gif

Collection Agency Levels

Table 3-64 shows Collection Agency Total: This is the most aggregate level of the Debt Aging Band dimension.

Table 3-64 Collection Agency Total

Sr. Number Attribute Description

1.

ALL COLLECTION AGENCY TOTAL CODE

Identification for the top level value


Table 3-65 shows Collection Agency Detail: Description level of the dimension. It stores the Collection Agency details.

Table 3-65 Collection Agency Detail

Sr. Number Attribute Description Sample Value

1

ANNUAL REVENUE

Revenue of the company.

 

2

ANNUAL REVENUE LOCAL

Revenue of the company.

 

3

ANNUAL REVENUE REPORTING

Revenue of the company.

 

4

ANNUAL SALES

Sales for annual

 

5

ANNUAL SALES LOCAL

Local sales for annual

 

6

ANNUAL SALES REPORTING

Reporting sales for annual

 

7

BANKRUPTCY END DATE

The end date of bankruptcy. If current date is behind start and end date is null, then the company is undergoing the bankruptcy process.

12/31/2005 12:00:00 AM

8

BANKRUPTCY START DATE

Start date of bankruptcy.

12/31/2005 12:00:00 AM

9

CAMPAIGN PARTNER CODE

CAMPAIGN PARTNER CODE is the code to track campaign partner.

 

10

CAMPAIGN PARTNER INDICATOR

to indicator this is a campaign partner. The campaign partner can be an external organization or even another Telecommunications operator. The service provider can partner with another service provider if their business is complementary, like 1 wireless operator and 1 local fixed line company. Most of content provider can also partner with the telco for promotion.

 

11

CHAIRMAN CODE

Connect to Another Person Party who is responsible for this Organization.

 

12

COLLECTION AGENCY CODE

A code for any person or business that is of interest to the Communications Service Provider.

1,2,3

13

COMPANY REGISTRY NUMBER

Will be same as Party. National_Identifier. Natural Key for Organization.

 

14

CONTACT CODE

ID of the contact person for the organization.

 

15

CONTACT NAME

Contact Employee for organization.

 

16

COURT CODE

Code of the law of court.

 

17

DOMESTIC INDICATOR

For PARTYs that are organizations, this indicates whether the organization is foreign or domestically owned.

 

18

DUNS NUMBER

DUNS NUMBER is an identifier for organization.

 

19

EMPLOYEE COUNT

Total number of employee in the company or organization.

 

20

EQUITY AMOUNT

The equity value of the company/org.

 

21

EQUITY AMOUNT LOCAL

The equity value of the company/org.

 

22

EQUITY AMOUNT REPORTING

The equity value of the company/org.

 

23

EXTERNAL ORGANIZATION TYPE CODE

Uniquely identifier of EXTERNAL ORGANIZATION TYPE

 

24

FINAL SETTLEMENT END DATE

End date of final settlement.

 

25

FINAL SETTLEMENT START DATE

Start date of final settlement

12/31/2005 0:00

26

JUDICIAL DISTRAINT CODE

Case identifier of the judicial distraint

 

27

JUDICIAL DISTRAINT DATE

Date of the judicial distraint.

12/31/2005 0:00

28

LIQUIDATION END DATE

The date when the company/org was liquidated. If is null and start_date is not null, the company is undergoing the liquidation.

12/31/2005 0:00

29

LIQUIDATION START DATE

Start date of liquidation.

12/31/2005 0:00

30

MANAGER CODE

ID of the manager for the organization.

 

31

MANAGER NAME

Name of manager for the whole company.

 

32

OTHER INDIVIDUAL CODE

Uniquely identifier of OTHER INDIVIDUAL

 

33

PARTY ORGANIZATION TYPE CODE

Type code of organization party.

 

34

PAYMENT ACCOUNT CLOSE DATE

Closing date of the account for payments.

 

35

PAYMENT ACCOUNT NUMBER

Account number for payments.

 

36

PAYMENT ACCOUNT OPEN DATE

Opening date of the account for payments.

 

37

SEAL IMAGE

The image of the Organization's Seal, or the Artificial Person's Signature.

 

38

STOCK EXCHANGE NAME

Abbreviation of listed companies as used on the stock exchange.

 

39

TAX EXEMPT STATUS

Indicates if the org. is tax exempt.

 

40

TERMINATION DATE

Termination date of the company in case of company was founded with termination date.

 

41

VALIDATION END DATE

Effective date of the deletion of the company's record from the company register.

 

42

VALIDATION START DATE

Date of the registration of the company' record deletion from the company register

12/31/2005 0:00

43

ACTIVE INDICATOR

Indicates if the party is currently active - which means the party has a current relationship with the carrier.

 

44

ADDRESS

Address of the party. Redundance to party location history.

 

45

BARING REASON CODE

Reasons for barring. For example, 1-Credit Limit, 2-Barring period.

 

46

BUSINESS LEGAL STATUS CODE

A unique identifier for a legal classification of a non-residential Customer.

 

47

CITY

City of the party. Redundance to party location history.

 

48

COUNTRY

Country of the party. Redundance to party location history.

 

49

CUSTOMER INDICATOR

Indicates if the party is a customer. Note: the party may have multiple relationships simultaneously - this flag identifies those parties which has a current account with the Telecommunications operator.

 

50

EFFECTIVE FROM DATE

EFFECTIVE FROM DATE, standard SCD2 column

12/31/2005 0:00

51

EFFECTIVE TO DATE

EFFECTIVE TO DATE, standard SCD2 column

12/31/2005 0:00

52

PARTY CODE

A code for any person or business that is of interest to the Communications Service Provider

 

53

PARTY DESC

Description of the party. applicable to both individual and organization. Normally it refer to the full name.

 

54

PARTY NAME

Name of the party. applicable to both individual and organization. Normally it refer to the full name.

Collector1

55

PARTY TYPE CODE

type code. type code

 

56

POST CODE

Postcode of the party. Redundance to party location history.

 

57

SOURCE SYSTEM CODE

SOURCE SYSTEM ID, from which source ERP system this recorded was extracted.

 

58

STATE

State of the party. Redundance to party location history.

 

59

STATUS CODE

Current status of party.

 

Commission Type

Description: COMMISSION TYPE

Commission Type Hierarchies

Standard Commission Type Hierarchy:

Description of image032.gif follows
Description of the illustration image032.gif

Commission Type Levels

Table 3-66 shows Commission Type Total: All Commission Type are most aggregate level of the dimension.

Table 3-66 Commission Type Total

Sr. Number Attribute Description

1.

ALL COMMISSION TYPE CODE

Code for All Commission Type.


Table 3-67 shows Commission Type Details: Detail level of the dimension. Stores the Commission Type Information.

Table 3-67 Commission Type Detail

Sr. Number Attribute Description Sample Value

1

COMMISSION TYPE CODE

COMMISSION TYPE CODE.

FLAT

2

COMMISSION TYPE DESC

COMMISSION TYPE DESC.

Flat Rate

3

COMMISSION TYPE NAME

Redemption Type Short Name.

Flat Rate

4

LANGUAGE CODE

Language ID---Unique identifier for a row in the Language dimension.

 

Competitor

Description: COMPETITOR

Competitor Hierarchies

Standard Competitor Hierarchy:

Description of dim_competitor.png follows
Description of the illustration dim_competitor.png

Competitor Levels

The following table shows COMPETITOR Total: All COMPETITOR is the most aggregate level of the dimension.

Table for COMPETITOR Total

Sr. Number Attribute Description
1. COMPETITOR TOTAL Code for All COMPETITOR.

Detail table shows COMPETITOR Detail: All COMPETITOR types is the most aggregate level of the dimension.

Sr. Number Attribute Description
1 ACTIVE INDICATOR Indicates if the party is currently active - which means the party has a current relationship with the carrier.
2 BARING REASON CODE Reasons for barring,eg,1-Credit Limit, 2-Barring period
3 ADDRESS Address of the party.
4 CITY City of the party.
5 COUNTRY Country of the party.
6 CUSTOMER INDICATOR Indicates if the party is a customer. Note: the party may have multiple relationships simultaneously - this flag identifies those parties which has a current account with the Telco.
7 EFFECTIVE FROM DATE EFFECTIVE FROM DATE, standard SCD2 column
8 EFFECTIVE TO DATE EFFECTIVE TO DATE, standard SCD2 column
9 PARTY DESC Description of the party. applicable to both individual and organization. Normally it refer to the full name.
10 PARTY CODE A code for any person or business that is of interest to the Communications Service Provider.
11 POST CODE Postcode of the party.
12 PARTY NAME Name of the party. applicable to both individual and organization. Normally it refer to the full name.
13 SOURCE SYSTEM CODE SOURCE SYSTEM ID, from which source ERP system this recorded was extracted
14 STATUS CODE current status of party.
15 STATE State of the party.
16 BANKRUPTCY START DATE start date of bankruptcy., for either organizational or individual customer.
17 BANKRUPTCY END DATE The end date of bankruptcy. If current date is behind start and end date is null, then the company/individual is undergoing the bankruptcy process.
18 CHANNEL CODE  
19 PARTY TYPE CODE2  
20 BUSINESS LEGAL STATUS CODE2  
21 LANGUAGE DIALECT CODE  
22 DATE CREATED The date when this competitor information is created.

Contact List

Description: CONTACT LIST

Contact List Hierarchies

Standard CONTACT LIST Hierarchy:

Description of dim_contact_li.png follows
Description of the illustration dim_contact_li.png

Contact List Levels

The following table shows CONTACT LIST Total: All CONTACT LIST is the most aggregate level of the dimension.

Table for CONTACT LIST Total

Sr. Number Attribute Description
1. CONTACT LIST TOTAL Code for All CONTACT LIST.

Detail table shows CONTACT LIST Detail: All CONTACT LIST types is the most aggregate level of the dimension.

Sr. Number Attribute Description
1 CONTACT LIST CODE A unique identifier for a contact list.
2 STATUS CODE Current STATUS CODE, standard SCD2 column
3 EFFECTIVE FROM DATE EFFECTIVE FROM DATE, standard SCD2 column
4 EFFECTIVE TO DATE EFFECTIVE TO DATE, standard SCD2 column
5 EXISTING CUSTOMER INDICATOR Indicate if the contact list if based on existing customers.
6 UNKNOWN TARGET INDICATOR Indicator for whether the Prospects on the Contact List are known to the Communications Service Provider
7 CREATION DATE The date on which a Contact List was created.
8 CHANGED BY the employee code who changed contact list
9 CONTACT LIST RECURRENCE TYPE CODE2  
10 SOURCE SYSTEM CODE1  
11 CONTACT LIST CHANGE REASON CODE2  
12 COST CODE  

Content

Description: CONTENT

Content Hierarchies

Standard CONTENT Hierarchy:

Description of dim_content.png follows
Description of the illustration dim_content.png

Content Levels

The following table shows CONTENT Total: All CONTENT is the most aggregate level of the dimension.

Table for CONTENT Total

Sr. Number Attribute Description
1. ALL CONTENT CODE Identification for the top level value

Table for CONTENT TYPE

Sr. Number Attribute
1 CONTENT TYPE NAME
2 CONTENT TYPE CODE
3 LANGUAGE CODE
4 CONTENT TYPE DESC

Detail table CONTENT Detail

Sr. Number Attribute Description
1 VALUE ADDED SERVICE CODE1 Code or Id for VAS
2 POPULARITY RATING How popular the content is, this can be rank by downloading.
3 COPYRIGHT INDICATOR Indicate if the provider has the copyright.
4 MEDIA TYPE CODE The type of media object, for example text, a picture, an audio message or a script.
5 CONTENT TYPE CODE2  
6 CONTENT PROVIDER CODE1  
7 CONTENT CODE  

Content Type

Description: CONTENT TYPE

Content Type Hierarchies

Standard Content Type Hierarchy:

Description of image033.gif follows
Description of the illustration image033.gif

Content Type Levels

Table 3-68 shows All Content Type: All Content Types are most aggregate level of the dimension.

Table 3-68 All Content Type

Sr. Number Attribute Description

1.

ALL CONTENT TYPE CODE

Code for All Content Type.


Table 3-69 shows Content Type Details: Detail level of the dimension. Stores the Content Types Information.

Table 3-69 Content Type Detail

Sr. Number Attribute Description Sample Value

1

CONTENT TYPE CODE

Type of the content: For example: constellation, jokes, and so on.

CONST

2

CONTENT TYPE DESC

Descriptions of content type

Constellation

3

CONTENT TYPE NAME

Name of the content type.

Constellation

4

LANGUAGE CODE

Language ID---Unique identifier for a row in the Language dimension.

 

Contract Change Initiator Type

Description: AGREEMENT CHANGE INITIATOR TYPE

Contract Change Initiator Type Hierarchies

Standard Contract Change Initiator Type Hierarchy:

Description of image034.gif follows
Description of the illustration image034.gif

Contract Change Initiator Type Levels

Table 3-70 shows Contract Change Initiator Type Total: All Contract Change Initiator type is most aggregate level of the dimension.

Table 3-70 Contract Change InitiatorType Total

Sr. Number Attribute Description

1.

ALL CONTENT TYPE CODE

Code for All Content Type.


Table 3-71 shows Contract Change Initiator Type Detail: Detail level of the dimension. Stores the Content Type Information.

Table 3-71 Contract Change Initiator Type Detail

Sr. Number Attribute Description Sample Value

1

CONTRACT CHANGE INITIATOR TYPE CODE

CONTRACT CHANGE INITIATOR TYPE CODE.

CUST

2

CONTRACT CHANGE INITIATOR TYPE DESC

CONTRACT CHANGE INITIATOR TYPE DESC.

Cust

3

CONTRACT CHANGE INITIATOR TYPE NAME

CONTRACT CHANGE INITIATOR TYPE name.

Cust

4

LANGUAGE CODE

Language ID---Unique identifier for a row in the Language dimension.

 

Contract Assignment Reason

Description: AGREEMENT ASSIGNMENT REASON

Contract Assignment Reason Hierarchies

Standard Contract Assignment Reason Hierarchies:

Description of image035.gif follows
Description of the illustration image035.gif

Contract Assignment Reason Level

Table 3-72 shows Contract Assignment Reason Total: It's not actually hierarchy. It is the top level to aggregate.

Table 3-72 Contract Assignment Reason Total

Sr. Number Attribute Description

1

CONTRACT ASSIGNMENT REASON ID

Code of reason


Table 3-73 shows Contract Assignment Reason Detail: Detail level of the Contract Assignment Reason.

Table 3-73 Contract Assignment Reason Detail

Sr. Number Attribute Description Sample Value

1

CONTRACT ASSIGNMENT REASON CODE

Code of reason

CMPLN

2

CONTRACT ASSIGNMENT REASON DESC

Description of reason

Complain

3

CONTRACT ASSIGNMENT REASON NAME

Name of reason

Complain

4

LANGUAGE CODE

Language ID---Unique identifier for a row in the Language dimension.

 

Cost Center

Description: COST CENTER

Cost Center Hierarchies

Standard COST CENTER Hierarchy:

Description of dim_costc.png follows
Description of the illustration dim_costc.png

Cost Center Levels

The following table shows COST CENTER Total: All COST CENTER is the most aggregate level of the dimension.

Table for COST CENTER Total

Sr. Number Attribute Description
1. COST CENTER TOTAL Code for All COST CENTER.

Detail table shows COST CENTER Detail: All COST CENTER types is the most aggregate level of the dimension.

Detail table COST CENTER Detail

Sr. Number Attribute Description
1 APPROVER CODE Approvers employee code incharge of the cost center
2 ORGANIZATION BUSINESS UNIT CODE1 Business Unit Code
3 COST CENTER DESC  
4 COST CENTER NAME  
5 COST CENTER CODE1  
6 COST CENTER CODE  

Credit Category

Description: CREDIT CATEGORY

Credit Category Hierarchies

Standard Credit Category Hierarchies:

Description of image037.gif follows
Description of the illustration image037.gif

Credit Category Levels

Table 3-74 shows Credit Category Total: Top most level used in the Credit Category dimension for aggregating data for all Credit categories. Attribute at this level is just the id for the level value.

Table 3-74 Credit Category Total

Sr. Number Attribute Description

1

CREDIT CATEGORY TOTAL ID

Id of the contract Credit Category Total


Table 3-75 shows Credit Category Detail: The detail or lowest level of the dimension, which actually contains the category values. The attributes for this level are id, descriptions for the level values.

Table 3-75 Credit Category Detail

Sr. Number Attribute Description Sample Value

1

CREDIT CATEGORY CODE

Code for Credit Category.

BAD

2

CREDIT CATEGORY DESC

Description for credit category.

Bad Customer

3

CREDIT CATEGORY NAME

Name for Credit Category.

Bad Customer

4

EFFECTIVE FROM DATE

EFFECTIVE FROM DATE, standard SCD2 column.

12/31/2005 12:00:00 AM

5

EFFECTIVE TO DATE

EFFECTIVE TO DATE, standard SCD2 column.

12/31/2005 12:00:00 AM

6

STATUS CODE

Current STATUS CODE, standard SCD2 column.

 

Currency

Description: CURRENCY

Currency Hierarchies

Standard CURRENCY Hierarchy:

Description of dim_currency.png follows
Description of the illustration dim_currency.png

Currency Levels

The following table shows CURRENCY Total: All CURRENCY is the most aggregate level of the dimension.

Table for CURRENCY Total

Sr. Number Attribute Description
1. CURRENCY TOTAL Code for All CURRENCY.

Detail table shows CURRENCY Detail: All CURRENCY types is the most aggregate level of the dimension.

Detail table CURRENCY Detail

Sr. Number Attribute Description
1 ISO NUMERIC COUNTRY CODE A numeric code representing the country associated with this currency.
2 ISO CURRENCY CODE A unique identifier representing a row in the Currency table.
3 ORGANIZATION BUSINESS UNIT CODE Business Unit Code
4 CURRENCY SYMBOL Symbol of Currency like $ for USD
5 CURRENCY NAME The abbreviated name of the currency.
6 CURRENCY DESC The full name of the currency. For example, United States Dollar.
7 COUNTRY NAME The name of the country associated with this currency.
8 ISO ALPHA CURRENCY CODE The three-character code for this currency as provided by the International Standards Organization (ISO) in publication 4217. Examples: US Dollars = USD, Hong Kong Dollars = HKD, and so on.
9 CURRENCY UNIT The unit for which exchange rates are specified.
10 VENDOR CODE  
11 LANGUAGE CODE  
12 CURRENCY CODE  

Customer

Description: CUSTOMER

Customer Hierarchies

Standard CUSTOMER Hierarchy:

Description of dim_cust.png follows
Description of the illustration dim_cust.png

Customer Levels

The following table shows CUSTOMER Total: All CUSTOMER is the most aggregate level of the dimension.

Table for CUSTOMER Total

Sr. Number Attribute Description
1. ALL CUSTOMER CODE Identification for the top level value

Table for CUSTOMER TYPE

Sr. Number Attribute Description
1 CUSTOMER TYPE CODE Customer product type id
2 CUSTOMER TYPE DESC Description for customer product Type
3 LANGUAGE CODE  
4 CUSTOMER TYPE NAME  

Detail table CUSTOMER Detail

Sr. Number Attribute Description
1 PAYMENT ACCOUNT NUMBER Account number for payments. Deprecated: This one is only used for backward compatibility.
2 ADDRESS LOCATION CODE1 Address Location Code
3 PAYMENT ACCOUNT CLOSE DATE Closing date of the first account with valid payment information. Deprecated: This one is only used for backward compatibility.
4 CUSTOMER CODE CUSTOMER CODE
5 CUSTOMER TYPE CODE2 Customer product type id
6 BILLING ADDRESS EFFECTIVE DATE Date on which the billing address referenced in the billing_address_id column became active. This facilitates queries such as find customers who changed address in the last 3 months"."
7 CONTACT ADDRESS EFFECTIVE DATE Date on which the contact address referenced in the billing_address_id column became active. This facilitates queries such as find customers who changed address in the last 3 months"."
8 PRIMARY LINE NUMBER Default fixed line number.
9 PRIMARY MSISDN NUMBER Default subscriber number, mostly, it's telephone number to the SIM card.
10 CHURN DATE  
11 CUSTOMER PAYMENT RESPONSIBLE INDICATOR Indicate if this customer is responsible for payment of an customer organization or household.
12 MAIL ALLOWED INDICATOR  
13 CUSTOMER IMPORTANCE RANK Integer that gives the Relative Importance of this customer with respect to others.
14 PARTY ROLE CODE  
15 PRIMARY STATUS REASON NAME Name of the Primary Status Reason
16 NUMBER OF LINES Number of phone lines belonging to this customer.
17 PAYMENT ACCOUNT OPEN DATE Opening date of the first account with valid payment information. Deprecated: This one is only used for backward compatibility.
18 REFERRAL CUSTOMER CODE REFERAL CUSTOMER code is another customer from whom the customer was introduced to service provider.
19 SOCIAL SECURITY NUMBER SOCIAL SECURITY NUMBER for individual customer.
20 TAX NUMBER Tax number of the party, for both individual and organizational.
21 BILLING ADDRESS LOCATION CODE The address where the billing is sent to.
22 DATE OF BIRTH The birthday of the customer, for individual customers
23 VALIDATION END DATE The business license validation period end date
24 VALIDATION START DATE The business license validation period start date
25 CAMPAIGN PARTNER CODE The campaign partner code if this customer at the same time is also a campaign partner.
26 CELL PHONE NO the cell phone number, and more contact information can be found in _party contact information_
27 PRIMARY STATUS CODE The current primary line or account status.
28 PRIMARY STATUS NAME The current primary line or account status.
29 DUNS NUMBER The Data Universal Numbering System code, as from D&B.
30 CREATE DATE  
31 LIQUIDATION END DATE The end date of liquidation process
32 FINAL SETTLEMENT END DATE The end date of the period when this customer lives in the last known area.
33 SEAL IMAGE The image of the Organization's Seal, or the Artificial Person's Signature.
34 INITIATIVE NUMBER The initiative code as defined in INITIATIVE entity. For example, when a person register himself on the operator_s website, he becomes an initiative. Later on, once he place the order, he becomes the customer. In the customer table, imitative number tracks which initiative this customer used to be.
35 TERMINATION DATE The natural termination date of organizational and individual customer.
36 OTHER INDIVIDUAL CODE  
37 PRIMARY OCCASION NAME the primary special date of the customer, for example, the marriage anniversary.
38 LIQUIDATION START DATE The start date of liquidation process
39 FINAL SETTLEMENT START DATE The start date of the period when this customer lives in the last known area.
40 EMPLOYER TAX NUMBER The tax number of the employer from tax authority.
41 OFFICE TEL NO This is the office number, and more contact information can be found in _party contact information_
42 ESTABLISHMENT DATE time of establish for organizational customer.
43 DOMESTIC INDICATOR To indicate this is a domestic company (compared with over seas, or those from other country).
44 CAMPAIGN PARTNER INDICATOR To indicate this is an Campaign Partner.
45 PUBLIC INDICATOR To indicate this is public listed company (listed and traded in stock exchange market).
46 CUSTOMER REVENUE BAND CODE Unique identifier for revenue band. For example:

0_1000, 1000_3000

47 PRIMARY STATUS REASON CODE Unique identifier for the primary Status Reason
48 CUSTOMER SOURCE CODE1 Unique identifier of customer source.
49 THIRD PARTY MARKETING ALLOWED INDICATOR Whether or not to allow third party to do marketing to the customer.
50 CHAIRMAN CODE  
51 CONTACT CODE  
52 CONTACT NAME  
53 NATIONALITY CODE  
54 MARITAL STATUS CODE  
55 MIDDLE NAME  
56 LIVING AT CURRENT ADDRESS SINCE  
57 LANGUAGE CODE2  
58 LAST NAME  
59 LEGAL TITLE TO HOUSING  
60 JOB CODE  
61 JOB CONTRACT TYPE  
62 JOB POSITION  
63 PARTY ORGANIZATION TYPE CODE  
64 CUSTOMER SCORE CODE1  
65 CUSTOMER SEGMENT CODE1  
66 DEATH CERTIFICATE CODE  
67 DRIVER LICENSE NUMBER  
68 DWELLING SIZE  
69 DWELLING STATUS  
70 DWELLING TENURE  
71 DWELLING TYPE  
72 ECONOMICALLY ACTIVE INDICATOR  
73 EDUCATION CODE  
74 FAMILY NAME IN MAIDEN  
75 FIRST NAME  
76 ANNUAL REVENUE  
77 ANNUAL REVENUE LOCAL  
78 ANNUAL REVENUE REPORTING  
79 ANNUAL SALES  
80 ANNUAL SALES LOCAL  
81 ARPU BAND CODE2  
82 ANNUAL SALES REPORTING  
83 COMPANY REGISTRY NUMBER  
84 NUMBER OF CHILDREN  
85 NUMBER OF DEPENDENTS  
86 PREV EMPLOYER TAX NUMBER  
87 PREV EMPLOYMENT END DATE  
88 PREV EMPLOYMENT START DATE  
89 PERSONAL IDENTIFICATION NUMBER  
90 PLACE OF BIRTH  
91 RELIGIOUS AFFILIATION CODE  
92 PROSPECT CODE  
93 STOCK EXCHANGE NAME  
94 TAX EXEMPT STATUS  
95 SALES VOLUME CODE  
96 START OF EMPLOYMENT  
97 SOC JOB CODE  
98 SOURCE OF INCOME  
99 EQUITY AMOUNT  
100 EQUITY AMOUNT LOCAL  
101 EQUITY AMOUNT REPORTING  
102 EMPLOYEE COUNT  
103 ETHNIC BACKGROUND  
104 ETHNICITY  
105 END OF JOB CONTRACT  
106 EXTERNAL ORGANIZATION TYPE CODE2  
107 GENDER CODE  
108 GIVEN NAME IN MAIDEN  
109 HOUSEHOLD CODE  
110 FORM OF EMPLOYMENT  
111 NAME  
112 NAME OF WORKPLACE  
113 NAME PREFIX  
114 NAME SUFFIX  
115 MANAGER CODE  
116 MANAGER NAME  

Customer Cluster

Description: CUSTOMER CLUSTER

Customer Cluster Hierarchies

Standard CUSTOMER CLUSTER Hierarchy:

Description of dim_cust_clust.png follows
Description of the illustration dim_cust_clust.png

Customer Cluster Levels

The following table shows CUSTOMER CLUSTER Total: All CUSTOMER CLUSTER is the most aggregate level of the dimension.

Table for CUSTOMER CLUSTER Total

Sr. Number Attribute Description
1. CUSTOMER CLUSTER TOTAL Code for All CUSTOMER CLUSTER.

Detail table shows CUSTOMER CLUSTER Detail: All CUSTOMER CLUSTER types is the most aggregate level of the dimension.

Detail table CUSTOMER CLUSTER Detail

Sr. Number Attribute
1 LAST UPDATE BY
2 STATUS CODE
3 PRINT CUSTOMER CLUSTER CODE
4 ORGANIZATION TYPE CODE
5 ORGANIZATION CODE
6 W ID
7 LAST UPDATE DATE
8 LOAD DATE
9 CURRENT INDICATOR
10 CUSTOMER CLUSTER CODE
11 CUSTOMER CLUSTER DSCR
12 CUSTOMER CLUSTER KEY
13 CUSTOMER CLUSTER TYPE CODE
14 EFFECT TO DATE
15 EFFECT FROM DATE

Customer Revenue Band

Description: CUSTOMER REVENUE BAND

Customer Revenue Band Hierarchies

Standard Customer Revenue Band Hierarchies:

Description of image038.gif follows
Description of the illustration image038.gif

Customer Revenue Band Levels

Table 3-76 shows Customer Revenue Band Total: This is not really a hierarchical dimension but to provide the summary or aggregate value Customer Revenue.

Table 3-76 Customer Revenue Band Total

Sr. Number Attribute Description

1

CUSTOMER REVENUE BAND TOTAL ID

Id of Customer Revenue Band Total


Table 3-77 shows Customer Revenue Band Detail: This level represents the detail level information of Customer Revenue Band.

Table 3-77 Customer Revenue Band Detail

Sr. Number Attribute Description Sample Value

1

CUSTOMER REVENUE BAND CODE

Unique identifier for revenue band. For example: 0_1000, 1000_3000.

BAND100

2

CUSTOMER REVENUE BAND DESC

Description revenue band.

Customer Revenue Band 100

3

CUSTOMER REVENUE BAND END VALUE

The end point of a band.

$100.00

4

CUSTOMER REVENUE BAND NAME

Name of revenue band.

Customer Revenue Band 100

5

CUSTOMER REVENUE BAND START VALUE

The start point of a band.

$0.00

6

CUSTOMER REVENUE TYPE CODE

For recharging, rent fee, one time equipment purchase,-.

RCG

7

LANGUAGE CODE

Language ID---Unique identifier for a row in the Language dimension.

 

Customer Segment

Description: CUSTOMER SEGMENT

Customer Segment Hierarchies

Standard Customer Segment Hierarchies:

Description of image039.gif follows
Description of the illustration image039.gif

Customer Segment Levels

Table 3-78 shows Customer Segment Total: This is not really a hierarchical dimension but to provide the summary or aggregate value Customer Segment.

Table 3-78 Customer Segment Total

Sr. Number Attribute Description

1

CUSTOMER SEGMENT TOTAL ID

Id of Customer Segment Total


Table 3-79 shows Customer Segment Detail: This level represents the detail level information of Customer Segment.

Table 3-79 Customer Segment Detail

Sr. Number Attribute Description Sample Value

1

CUSTOMER SEGMENT CODE

A code used to uniquely identify a grouping of Parties or Accounts for marketing and management issues.

1

2

CUSTOMER SEGMENT DESC

A textual description for a Segment.

SGMNT1

3

CUSTOMER SEGMENT NAME

The name assigned to a Segment.

SGMNT1

4

CUSTOMER SEGMENTATION MODEL CODE

Unique identifier for Customer Segmentation Model

 

5

EFFECTIVE FROM DATE

EFFECTIVE FROM DATE, standard SCD2 column.

 

6

EFFECTIVE TO DATE

EFFECTIVE TO DATE, standard SCD2 column.

 

7

IS LEAF INDICATOR

Is leaf is to indicate if the cluster is leaf of the cluster tree.

 

8

SEGMENT CRITERIA CODE

SEGMENT CRITERIA CODE.

 

9

SEGMENT DISPERSION

The dispersion of the training data in this segment.

 

10

STATUS CODE

Current STATUS CODE, standard SCD2 column.

 

11

SUPPORTING RECORD COUNT

How many customers are included in segment during training, therefore support the cluster.

 

12

TREE LEVEL

TREE LEVEL in the cluster tree.

6


Dealer

Description: DEALER

Dealer Hierarchies

Standard Dealer Hierarchies:

Description of image040.gif follows
Description of the illustration image040.gif

Dealer Levels

Table 3-80 shows Dealer Total: This is not really a hierarchical dimension but to provide the summary or aggregate value of Dealer.

Table 3-80 Dealer Total

Sr. Number Attribute Description

1

DEALER TOTAL ID

Id of dealer


Table 3-81 shows Dealer Detail: This level represents the detail level information of Customer Revenue Band.

Table 3-81 Dealer Detail

Sr. Number Attribute Description Sample Value

1

ADDRESS LOCATION CODE

Unique identifier for Address Location

 

2

ANNUAL REVENUE

Revenue of the company.

 

3

ANNUAL REVENUE LOCAL

Revenue of the company.

 

4

ANNUAL REVENUE REPORTING

Revenue of the company.

 

5

ANNUAL SALES

Annual sales of Dealer

 

6

ANNUAL SALES LOCAL

Annual sales of Dealer local

 

7

ANNUAL SALES REPORTING

Annual sales of Dealer reporting

 

8

AREA CODE

Code for the Area.

 

9

BANKRUPTCY END DATE

The end date of bankruptcy. If current date is behind start and end date is null, then the company is undergoing the bankruptcy process.

 

10

BANKRUPTCY START DATE

start date of bankruptcy.

12/31/2005 12:00:00 AM

11

CAMPAIGN PARTNER CODE

CAMPAIGN PARTNER CODE is the code to track campaign partner.

 

12

CAMPAIGN PARTNER INDICATOR

To indicator this is a campaign partner. The campaign partner can be an external organization or even another telco operator. The service provider can partner with another service provider if their business are complementary, like 1 wireless operator and 1 local fixed line company. Most of content provider can also partner with the telco for promotion.

 

13

CHAIRMAN CODE

Connect to Another Person Party who is responsible for this Organization.

 

14

COMPANY REGISTRY NUMBER

Will be same as Party. National_Identifier. Natural Key for Organization.

 

15

CONTACT CODE

ID of the contact person for the organization.

 

16

CONTACT NAME

Contact Employee for organization.

 

17

CONTRACT DATE

The date when the contract was created.

 

18

CONTRACT VALID TILL

Validation details

 

19

COURT CODE

Code of the law of court.

 

20

DEALER CODE

Uniquely identifier of dealer

 

21

DEALER NAME

Name of the dealer

 

22

DISCOUNT ELIGIBLE INDICATOR

Flag represents eligible for discount or not

 

23

DISCOUNT GROUP CODE

DISCOUNT GROUP CODE.

 

24

DOMESTIC INDICATOR

For PARTYs that are organizations, this indicates whether the organization is foreign or domestically owned.

 

25

DUNS NUMBER

DUNS NUMBER is an identifier for organization.

 

26

EMAIL ADDRESS

Electronic Address of dealer

 

27

EMPLOYEE COUNT

Total number of employee in the company or organization.

 

28

EQUITY AMOUNT

The equity value of the company/org.

 

29

EQUITY AMOUNT LOCAL

The equity value of the company/org.

 

30

EQUITY AMOUNT REPORTING

The equity value of the company/org.

 

31

FINAL SETTLEMENT END DATE

End date of final settlement.

 

32

FINAL SETTLEMENT START DATE

Start date of final settlement.

12/31/2005 0:00

33

JUDICIAL DISTRAINT CODE

Case identifier of the judicial distraint

 

34

JUDICIAL DISTRAINT DATE

Date of the judicial distraint

 

35

LIQUIDATION END DATE

The date when the company/org was liquidated. If is null and start_date is not null, the company is undergoing the liquidation.

 

36

LIQUIDATION START DATE

Start date of liquidation.

12/31/2005 0:00

37

MANAGER CODE

ID of the manager for the organization

 

38

MANAGER NAME

Name of manager for the whole company

 

39

OTHER INDIVIDUAL CODE

Unique identifier for Individual

 

40

PAYMENT ACCOUNT CLOSE DATE

Closing date of the account for payments.

 

41

PAYMENT ACCOUNT NUMBER

Account number for payments.

 

42

PAYMENT ACCOUNT OPEN DATE

Opening date of the account for payments.

 

43

SALES CHANNEL CODE

The unique identifier for each Channel. A Channel identifies each possible link where interaction between the Communications Service Provider and the Customer occurs.

 

44

SEAL IMAGE

The image of the Organization's Seal, or the Artificial Person's Signature.

 

45

STOCK EXCHANGE NAME

Abbreviation of listed companies as used on the stock exchange.

 

46

TAX EXEMPT STATUS

Indicates if the org. is tax exempt.

 

47

TERMINATION DATE

Termination date of the company in case of company was founded with termination date.

 

48

VALIDATION END DATE

Effective date of the deletion of the company's record from the company register.

 

49

VALIDATION START DATE

Date of the registration of the company' record deletion from the company register

12/31/2005 0:00

50

ACTIVE INDICATOR

Indicates if the party is currently active - which means the party has a current relationship with the carrier.

 

51

ADDRESS

Address of the party. Redundance to party location history.

 

52

BARING REASON CODE

Reasons for barring. For example:

1-Credit Limit

2-Barring period

 

53

BUSINESS LEGAL STATUS CODE

A unique identifier for a legal classification of a non-residential Customer.

 

54

CITY

City of the party. Redundance to party location history.

 

55

COUNTRY

Country of the party. Redundance to party location history.

 

56

CUSTOMER INDICATOR

Indicates if the party is a customer. Note: the party may have multiple relationships simultaneously - this flag identifies those parties which has a current account with the Telecommunications operator.

 

57

EFFECTIVE FROM DATE

EFFECTIVE FROM DATE, standard SCD2 column

 

58

EFFECTIVE TO DATE

EFFECTIVE TO DATE, standard SCD2 column

 

59

PARTY CODE

A code for any person or business that is of interest to the Communications Service Provider.

 

60

PARTY DESC

Description of the party. applicable to both individual and organization. Normally it refer to the full name.

 

61

PARTY NAME

Name of the party. Applicable to both individual and organization. Normally it refers to the full name.

 

62

PARTY TYPE CODE

type code.

 

63

POST CODE

Postcode of the party. Redundance to party location history.

 

64

SOURCE SYSTEM CODE

SOURCE SYSTEM ID, from which source ERP system this recorded was extracted.

 

65

STATE

State of the party. Redundance to party location history.

 

66

STATUS CODE

Current status of party.

 

Debt Aging Band

Description: DEBT AGING BAND

Debt Aging Band Hierarchies

Standard Debt Aging Band Hierarchy:

Description of image041.gif follows
Description of the illustration image041.gif

Debt Aging Band Levels

Table 3-82 shows Debt Aging Band Total: Most aggregate level for the Debt Aging Band dimension to see the aggregated value of all the Debt Aging Band.

Table 3-82 Debt Aging Band Total

Sr. Number Attribute Description

1.

DEBT AGING BAND ID

Code for Debt Aging Band


Table 3-83 shows Debt Aging Band Detail: There are customers who have not paid or partially paid one or more bills. This is called as aging for the bill payment. Based on the age of unpaid or partial paid bill those amounts are put into different buckets for each customer.

Table 3-83 Debt Aging Band Detail

Sr. Number Attribute Description Sample Value

1

DEBT AGING BAND CODE

Code for Aging Slab.

DAB1

2

DEBT AGING BAND DESC

Description for aging Slab.

Debt Aging Band Between 0 And 4

3

DEBT AGING BAND FROM

   

4

DEBT AGING BAND NAME

Name for aging Slab.

Band(0-4)

5

DEBT AGING BAND TO

0

 

6

LANGUAGE CODE

Unique identifier for Language

4


Direct Debit Status Reason

Description: DIRECT DEBIT STATUS REASON

Direct Debit Status Reason Hierarchies

Standard Direct Debt Status Reason Hierarchy:

Description of image042.gif follows
Description of the illustration image042.gif

Direct Debit Status Reason Levels

Table 3-84 shows Direct Debit Status Reason Total: Most aggregate level for the Direct Debit Status Reason dimension to see the aggregated value of all the Direct Debit Status Reason.

Table 3-84 Direct Debit Status Reason Total

Sr. Number Attribute Description

1

DIRECT DEBT STATUS REASON ID

Code for Direct Debit Status Reason


Table 3-85 shows Direct Debit Status Reason Detail: All Address Locations are most aggregate level of the dimension.

Table 3-85 Direct Debit Status Reason Detail

Sr. Number Attribute Description Sample Value

1

DIRECT DEBT STATUS REASON CODE

Unique code for Direct Debt Status Reason

ACTV

2

DIRECT DEBT STATUS REASON DESC

Description of Direct Debt Status Reason

Active

3

DIRECT DEBT STATUS REASON NAME

Name for Direct Debt Status Reason

Active

4

LANGUAGE CODE

Unique identifier for Language

 

Divert Retrieve Type

Description: DIVERT RETRIEVE TYPE

Divert Retrieve type Hierarchies

Standard Divert Retrieve Type Hierarchy:

Description of image043.gif follows
Description of the illustration image043.gif

Divert Retrieve Type Levels

Table 3-86 shows Divert Retrieve Type Total: Most aggregate level for the Divert Retrieve Type Total dimension to see the aggregated value of all the Divert Retrieve Type Total.

Table 3-86 Divert Retrieve Type Total

Sr. Number Attribute Description

1.

DIVERT RETRIEVE TYPE TOTAL ID

Code for Divert Retrieve Type Total


Table 3-87 shows Divert Retrieve Type Detail: Call divert retrieve type indicates if the call is a diverted call or a retrieved call and then it can further drill down to define call as diverted to/retrieved from fax, ums or vms.

Subscriber's calls are diverted to the voice mail or UMS mail box according to subscriber instructions or settings. For example, calls can be diverted when subscriber is busy on other call, subscriber has switched off this handset or subscriber is not reachable for the moment.

Subscriber can later retrieve all his calls that are stored on the mailbox by accessing his mailbox through specified numbers or using Internet in case of UMS.

All this traffic generated by diverted calls as well as retrieved calls is to be analyzed based on the type of call such as diverted or retrieved, type of access to retrieve a call and so on.

Call Divert retrieve dimension helps in achieving this by organizing calls as diverted - retrieved calls.

Table 3-87 Divert Retrieve Type Detail

Sr. Number Attribute Description Sample Value

1

DIVERT RETRIEVE SUB TYPE CODE

Call divert/retrieve subtype ID.

 

2

DIVERT RETRIEVE SUB TYPE DESC

Call divert/retrieve subtype description.

 

3

DIVERT RETRIEVE SUB TYPE NAME

Call divert/retrieve subtype short description.

 

4

DIVERT RETRIEVE TYPE CODE

Code for Divert Retrieve Type.

DVRT

5

DIVERT RETRIEVE TYPE DESC

Divert retrieve Type description.

Call Are Diverted To The Mailbox

6

DIVERT RETRIEVE TYPE NAME

Name of Divert retrieve Type.

Diverted Calls

7

LANGUAGE CODE

Unique identifier for Language

 

Employee

Description: EMPLOYEE

Employee Hierarchies

Standard Employee Hierarchy:

Description of image044.gif follows
Description of the illustration image044.gif

Employee Levels

Table 3-88 shows Employee Total: Most aggregate level for the Employee Total dimension to see the aggregated value of all the Employee Total

Table 3-88 Employee Total

Sr. Number Attribute Description

1.

EMPLOYEE TOTAL ID

Code for employee total identifier.


Table 3-89 shows Employee Details: Employee of Carrier. Sub entity of Party individual.

Table 3-89 Employee Detail

Sr. Number Attribute Description Sample Value

1

BILLING ADDRESS EFFECTIVE DATE

Date on which the billing address referenced in the billing_address_id column became active. This facilitates queries such as find customers who changed address in the last 3 months.""

 

2

BUSINESS DIVISION EXECUTIVE NAME

BUSINESS DIVISION EXECUTIVE LAST NAME is the last name of the business division executive to whom the employee reports to. Like LOB Owner.

 

3

BUSINESS PHONE NUMBER

Phone number used for business purpose

 

4

CELL PHONE NO

Redundancy to 'party contact information'

 

5

CHILDREN COUNT

Number of children

 

6

CONTACT ADDRESS EFFECTIVE DATE

Date on which the contact address referenced in the billing_address_id column became active. This facilitates queries such as find customers who changed address in the last 3 months.""

 

7

COST CENTER NUMBER

The cost center to which the bank employee expenses are charged.

 

8

DATE OF BIRTH

Date of Birth of the individual.

 

9

DATE OF DEATH

Date of natural person death.

 

10

DEATH CERTIFICATE CODE

The certification document number for customer's death.

 

11

DEPENDENTS COUNT

Number of dependents

 

12

DRIVER LICENSE NUMBER

Driver License Number in most countries.

 

13

DWELLING SIZE

Size of dwelling

 

14

DWELLING TENURE

Tenure of dwelling

 

15

ECONOMICALLY ACTIVE IND

customer is economically active (is not a minor or pensioner and so on.)

 

16

EDUCATION CODE

The customer highest level of education.

 

17

EMAIL

Redundancy to 'party contact information'

 

18

EMPLOYEE CODE

A code for any person or business that is of interest to the Communications Service Provider.

 

19

EMPLOYEE DESIGNATION CODE

Unique warehouse key, representing the designation

 

20

EMPLOYEE DISCOUNT GROUP CODE

Unique identifier for Employee Discount Group

 

21

EMPLOYEE KEY

Key value for each employee

 

22

EMPLOYEE NUMBER

Internal number for the employee.

 

23

EMPLOYEE TYPE CODE

Unique identifier for Employee Type

PT

24

EMPLOYEE TYPE DESC

Description of the Employee Type

Part Time

25

EMPLOYEE TYPE NAME

Unique identifier for the Employee Type

Part Time

26

EMPLOYER TAX NUMBER

The tax code of Employer.

 

27

EMPLOYMENT BEGIN DATE

Start date for the employment.

12/31/2005 12:00:00 AM

28

EMPLOYMENT END DATE

If the employee quit, holds the information of past employment.

 

29

EMPLOYMENT EXEMPT IND

An employee exempt from the overtime policies due to the nature of the work, as compared to (Non-Exempt).

Education requirements of the position and salary range. These employees are paid an annual salary and are not customarily eligible for overtime pay.

 

30

EMPLOYMENT STATUS

EMPLOYEE STATUS is the abbreviated identifier for the employment status. Employee

 

31

END OF JOB CONTRACT

End date of the customer's job contract (for contracts concluded for definite terms).

 

32

ETHNIC BACKGROUND

Customer Attribute of an employee

 

33

ETHNICITY

Classifies the individual for minority reporting purposes.

 

34

FAMILY NAME IN MAIDEN

Given name in maiden

 

35

FIRST NAME

First name of a party individual

 

36

FORM OF EMPLOYMENT

The customer's form of employment (private entrepreneur, employee, civil servant and so on.)

 

37

GENDER CODE

For PARTYs that are people, this is their GENDER.

For PARTYs that are organizations, this is indicates whether the organization is foreign or domestically owned.

 

38

GIVEN NAME IN MAIDEN

Given name in maiden

 

39

HOME TELEPHONE NO

Redundance to 'party contact information'

 

40

HOUSEHOLD KEY

The code of household which the party belongs to.

 

41

INCOME

Income of a party individual

 

42

INCOME LCL

Income of a party individual

 

43

INCOME RPT

Income of a party individual

 

44

JOB CONTRACT TYPE

Type of the customer's job contract

 

45

JOB KEY

Code for job of subscriber.

 

46

JOB POSITION

job Position.

 

47

LANGUAGE CODE

Unique identifier for Language

 

48

LAST NAME

Last name of a party individual

 

49

LAST PERFORMANCE RATING

This describes the annual rating assigned to the employee.

 

50

LAST PERFORMANCE RATING DATE

When the last rating is done.

 

51

LEGAL TITLE TO HOUSING

The customer's legal title to home (rents, owns and so on.)

 

52

LIVING AT CURRENT ADDRESS SINCE

Date since the customer has lived at the present address.

 

53

MANAGER CODE

manager's employee code.

 

54

MARITAL STATUS

CSALADI ALLAPOT. Marital status

 

55

MARTIAL STATUS CODE

   

56

MIDDLE NAME

Middle name of a party individual

 

57

MOTHER FIRST NAME

Mother's first name

 

58

MOTHER LAST NAME

Mother's last name

 

59

NAME OF WORKPLACE

Name of workplace

 

60

NAME PREFIX

Name prefix

For example: Mr, Mrs, Ms, Dr,

 

61

NAME SUFFIX

Name suffix. For example: PhD, MD, JD, MA

 

62

NATIONALITY CODE

Code for Nationality of subscriber

 

63

NUMBER OF EARNERS IN HOUSEHOLD

Number of wage earners in the household.

 

64

NUMBER OF PERSONS LIVING IN HOUSEHOLD

Number of persons sharing the customer's household.

 

65

OFFICE TELEPHONE NO

Redundancy to 'party contact information'

 

66

ORGANIZATION BUSINESS UNIT KEY

   

67

PERSONAL ID NUMBER

In China, this is the same as party.national_identifier.

 

68

PLACE OF BIRTH

Where the person was born.

 

69

PREVIOUS EMPLOYER TAX NUMBER

Tax number of previous employer.

 

70

PREVIOUS EMPLOYMENT END DATE

End date of previous job.

 

71

PREVIOUS EMPLOYMENT START DATE

Start date of previous job.

12/31/2005 12:00:00 AM

72

SOC JOB KEY

   

73

SOCIAL SECURITY NUMBER

Null if a country does not have.

 

74

SOURCE OF INCOME

Source of income (can typify, may be several)

 

75

START OF EMPLOYMENT

Start of employment

 

76

TAX NUMBER

Tax number

 

77

ACTIVE IND

Activate Indicator

 

78

ADDRESS

Address

 

79

BARING REASON CODE

Unique identifier for Baring Reason

 

80

BUSINESS LEGAL STATUS CODE

A unique identifier for a legal classification of a non-residential Customer.

 

81

CITY

City of the party. Redundance to party location history.

 

82

COUNTRY

Country of the party. Redundance to party location history.

 

83

CUSTOMER IND

Indicator for Customer

 

84

EFFECTIVE FROM DATE

EFFECTIVE FROM DATE, standard SCD2 column.

 

85

EFFECTIVE TO DATE

EFFECTIVE TO DATE, standard SCD2 column.

 

86

EMPLOYEE NAME

Name of the employee

 

87

PARTY DESC

Description for the Party

 

88

PARTY KEY

Key value for Party

 

89

PARTY NAME

Name of the Party

 

90

PARTY TYPE CODE

Unique identifier for Party Type

 

91

POST CODE

Unique identifier for Post

 

92

SOURCE SYSTEM KEY

Key value for Source System

 

93

STATE

State Name

 

94

STATUS CODE

Current Status

 

Environment Type

Description: ENVIRONMENT TYPE

Environment Type Hierarchies

Standard ENVIRONMENT TYPE Hierarchy:

Description of dim_event.png follows
Description of the illustration dim_event.png

Environment Type Levels

The following table shows ENVIRONMENT TYPE Total: All ENVIRONMENT TYPE is the most aggregate level of the dimension.

Table for ENVIRONMENT TYPE Total

Sr. Number Attribute
1 ENVIRONMENT TYPE CODE
2 LANGUAGE CODE
3 ENVIRONMENT TYPE NAME
4 ENVIRONMENT TYPE DESCRIPTION

Event Category

Description: EVENT CATEGORY

Event Category Hierarchies

Standard EVENT CATEGORY Hierarchy:

Description of dim_event.png follows
Description of the illustration dim_event.png

Event Category Levels

The following table shows EVENT CATEGORY Total: All EVENT CATEGORY is the most aggregate level of the dimension.

Table for EVENT CATEGORY Total

Sr. Number Attribute Description
1. EVENT CATEGORY TOTAL Code for All EVENT CATEGORY.

Detail table shows EVENT CATEGORY Detail: All EVENT CATEGORY types is the most aggregate level of the dimension.

Detail table EVENT CATEGORY Detail

Sr. Number Attribute Description
1 EVENT CATEGORY DESC A textual description for event class.
2 EVENT CATEGORY CODE An unique identifier for event class. Examples:

A-advertising

3 EVENT CATEGORY NAME The name assigned to event class. Examples: Advertising, Promotion

Event Result

Description: EVENT RESULT

Event Result Hierarchies

Standard Event Result Hierarchy:

Description of image045.gif follows
Description of the illustration image045.gif

Event Result Levels

Table 3-90 shows Event Result Total: Most aggregate level for the Event Result dimension to see the aggregated value of all the Event Result.

Table 3-90 Event Result Total

Sr. Number Attribute Description

1.

ALL EVENT RESULT ID

Code for Event Result


Table 3-91 shows Event Result Detail: Keep the result of an event. For example,

  • S: Successful

  • F: failed

Table 3-91 Event Result Detail

Sr. Number Attribute Description Sample Value

2

EVENT RESULT CODE

The unique identifier of an event result.

FAIL

3

EVENT RESULT DESC

The description of an event result.

Failed

4

EVENT RESULT NAME

The name of an event result.

Failed

5

LANGUAGE CODE

Unique identifier for Language

 

Event Type

Description: EVENT TYPE

Event Type Hierarchies

Standard Event Type Hierarchies:

Description of image046.gif follows
Description of the illustration image046.gif

Event Type Levels

Table 3-92 shows Event Type Total: Most aggregate level for the Event Type to see the aggregated sales of all the Event Type of all types.

Table 3-92 Event Type Total

Sr. Number Attribute Description

1.

ALL EVENT TYPE TOTAL ID

Code for All Event Type


Table 3-93 shows Event Type Detail: This entity keeps all types of events under each category.

Table 3-93 Event Type Detail

Sr. Number Attribute Description Sample Value

1

EVENT CATEGORY CODE

An unique identifier for event class. Examples: A-advertising.

ACCSMTHD

2

EVENT TYPE CODE

A Code used to uniquely identify the type of Event. Examples: M - Marketing, F - Finance.

ACTV

3

EVENT TYPE DESC

A textual description for an Event Type.

Activate

4

EVENT TYPE NAME

The name of type. Examples: Marketing, Finance.

Activate

5

LANGUAGE CODE

Unique identifier for Language

 

External Operator

Description: EXTERNAL OPERATOR

External Operator Hierarchies

Standard EXTERNAL OPERATOR Hierarchy:

Description of dim_ext_opt.png follows
Description of the illustration dim_ext_opt.png

External Operator Levels

The following table shows EXTERNAL OPERATOR Total: All EXTERNAL OPERATOR is most aggregate level of the dimension.

Table for EXTERNAL OPERATOR Total

Sr. Number Attribute Description
1 EXTERNAL OPERATOR Total Code for All EXTERNAL OPERATOR Total.

Detail table shows EXTERNAL OPERATOR Detail: It captures information relating to External Operator.

Detail table EXTERNAL OPERATOR Detail

Sr. Number Attribute Description
1 STOCK EXCHANGE NAME Abbreviation of listed companies as used on the stock exchange.
2 PAYMENT ACCOUNT NUMBER Account number for payments.
3 CAMPAIGN PARTNER CODE CAMPAIGN PARTNER CODE is the code to track campaign partner.
4 JUDICIAL DISTRAINT CODE Case identifier of the judicial distraint.
5 PAYMENT ACCOUNT CLOSE DATE Closing date of the account for payments.
6 COURT CODE Code of the law of court.
7 CHAIRMAN CODE Connect to Another Person Party who is responsible for this Organization.
8 CONTACT NAME Contact Employee for organization.
9 JUDICIAL DISTRAINT DATE Date of the judicial distraint.
10 VALIDATION START DATE Date of the registration of the company' record deletion from the company register.
11 DUNS NUMBER DUNS NUMBER is an identifier for organization
12 VALIDATION END DATE Effective date of the deletion of the company's record from the company register.
13 FINAL SETTLEMENT END DATE End date of final settlement.
14 DOMESTIC INDICATOR For PARTYs that are organizations, this indicates whether the organization is foreign or domestically owned.
15 OPERATOR DESC Further information with operating country and other details.
16 CONTACT CODE ID of the contact person for the organization.
17 MANAGER CODE ID of the manager for the organization.
18 IMSI Code IMSI code of the operator
19 TAX EXEMPT STATUS Indicates if the org. is tax exempt.
20 IP ADDRESS IP address
21 MANAGER NAME Name of manager for the whole company.
22 PAYMENT ACCOUNT OPEN DATE Opening date of the account for payments.
23 ANNUAL REVENUE REPORTING Revenue of the company
24 ANNUAL REVENUE Revenue of the company
25 ANNUAL REVENUE LOCAL Revenue of the company
26 BANKRUPTCY START DATE start date of bankruptcy.
27 FINAL SETTLEMENT START DATE Start date of final settlement.
28 LIQUIDATION START DATE Start date of liquidation.
29 TERMINATION DATE Termination date of the company in case of company was founded with termination date.
30 CAMPAIGN PARTNER INDICATOR The campaign partner can be an external organization or even another telco operator. The service provider can partner with another service provider if their business are complementary, like 1 wireless operator and 1 local fixed line company.

Most of content provider can also partner with the telco for promotion.

31 COUNTRY The country where the operator serves
32 LIQUIDATION END DATE The date when the company/org was liquidated. If is null and start_date is not null, the company is undergoing the liquidation.
33 BANKRUPTCY END DATE The end date of bankruptcy. If current date is behind start and end date is null, then the company is undergoing the bankruptcy process.
34 EQUITY AMOUNT The equity value of the company/org.
35 EQUITY AMOUNT LOCAL The equity value of the company/org.
36 EQUITY AMOUNT REPORTING The equity value of the company/org.
37 OPERATOR NAME The full name of the operator, like China Mobile for CMCC, ...
38 SEAL IMAGE The image of the Organization's Seal, or the Artificial Person's Signature.
39 EMPLOYEE COUNT Total number of employee in the company or organization.
40 COUNTRY CODE Unique identifier for country,eg. USA, UK, CN, JP
41 EXTERNAL OPERATOR CODE Unique identifier for operator. For example: Airtel, CMCC, NTT
42 COMPANY REGISTRY NUMBER Will be same as Party. National_Identifier. Natural Key for Organization.
43 COUNTRY DESC  
44 COUNTRY NAME  
45 EXTERNAL ORGANIZATION TYPE CODE2  
46 PARTY ORGANIZATION TYPE CODE  
47 OTHER INDIVIDUAL CODE1  
48 OPERATOR GROUP CODE1  
49 OPERATOR TYPE CODE2  
50 PLMN CODE  
51 TAP 1 ID  
52 TAP 2 ID  
53 ANNUAL SALES REPORTING  
54 ANNUAL SALES LOCAL  
55 ANNUAL SALES  

Fraud Profile Class

Description: FRAUD PROFILE CLASS

Fraud Profile Class Hierarchies

Standard Fraud Profile Class Hierarchy:

Description of image048.gif follows
Description of the illustration image048.gif

Fraud Profile Class Levels

Table 3-94 shows Fraud Profile Class Total: Most aggregate level for the Fraud Profile Class dimension to see the aggregated value of all the Fraud Profile Class.

Table 3-94 Fraud Profile Class Total

Sr. Number Attribute Description

1.

ALL FRAUD PROFILE CLASS ID

Code for All Fraud Profile Class


Table 3-95 shows Fraud Profile Class Detail: The fraud profile class is generalized after certain analysis process over the past network event. New network event therefore can be tagged through the same model to detect if there are suspicious activities.

Table 3-95 Fraud Profile Class Detail

Sr. Number Attribute Description

1.

FRAUD PROFILE CLASS CODE

Code of The Fraud Profile Class

2.

FRAUD PROFILE CLASS NAME

Name of The Fraud Profile Class

3.

FRAUD PROFILE CLASS DESCRIPTION

Description of The Fraud Profile Class

 

LANGUAGE CODE

 

Geography

Description: GEOGRAPHY ENTITY

Geography Hierarchies

Standard Geography Hierarchy:

Description of image049.gif follows
Description of the illustration image049.gif

Geography Levels

Table 3-96 shows Geography World: World level in GEOGRAPHY hierarchy.

Table 3-96 Geography World

Sr. Number Attribute Description Sample Value

1

EFFECTIVE TO DATE

EFFECTIVE TO DATE, standard SCD2 column

 

2

GEOGRAPHY WORLD CODE

Identifier of world.

 

3

EFFECTIVE FROM DATE

Active from. Standard SCD field, Effective Start Date

12/31/2005 12:00:00 AM

4

GEOGRAPHY WORLD NAME

Name of the geography world.

 

Table 3-97 shows Geography Region: Region level in GEOGRAPHY hierarchy.

Table 3-97 Geography Region

Sr. Number Attribute Description Sample Value

1

GEOGRAPHY REGION CODE

uniquely identifier of geography region

 

2

EFFECTIVE TO DATE

EFFECTIVE TO DATE, standard SCD2 column

12/31/2005 12:00:00 AM

3

GEOGRAPHY WORLD CODE

Identifier of world.

 

4

EFFECTIVE FROM DATE

Active from. Standard SCD field, Effective Start Date

12/31/2005 12:00:00 AM

5

GEOGRAPHY REGION NAME

Name of the geography region

 

Table 3-98 shows Geography Sub Region: Sub Region level in GEOGRAPHY hierarchy.

Table 3-98 Geography Sub Region

Sr. Number Attribute Description Sample Value

1

GEOGRAPHY REGION CODE

uniquely identifier of geography region

 

2

EFFECTIVE TO DATE

EFFECTIVE TO DATE, standard SCD2 column

12/31/2005 12:00:00 AM

3

EFFECTIVE FROM DATE

Active from. Standard SCD field, Effective Start Date

12/31/2005 12:00:00 AM

4

GEOGRAPHY SUB REGION NAME

name of the sub region

 

5

GEOGRAPHY SUB REGION CODE

Uniquely identifier of geography sub region

 

Table 3-99 shows Geography Country: Country level in GEOGRAPHY hierarchy.

Table 3-99 Geography Country

Sr. Number Attribute Description Sample Value

1

EFFECTIVE TO DATE

EFFECTIVE TO DATE, standard SCD2 column

12/31/2005 12:00:00 AM

2

EFFECTIVE FROM DATE

Active from. Standard SCD field, Effective Start Date

12/31/2005 12:00:00 AM

3

GEOGRAPHY COUNTRY CODE

Uniquely identifier of the country.

 

4

GEOGRAPHY SUB REGION CODE

Uniquely identifier of geography sub region

 

5

GEOGRAPHY COUNTRY NAME

Name of the country

 

Table 3-100 shows Geography State: State level in GEOGRAPHY hierarchy.

Table 3-100 Geography State

Sr. Number Attribute Description Sample Value

1

GEOGRAPHY STATE NAME

Name of state

 

2

EFFECTIVE TO DATE

EFFECTIVE TO DATE, standard SCD2 column

12/31/2005 12:00:00 AM

3

GEOGRAPHY STATE CODE

Uniquely identifier of geography state

 

4

EFFECTIVE FROM DATE

Active from. Standard SCD field, Effective Start Date

12/31/2005 12:00:00 AM

5

GEOGRAPHY COUNTRY CODE

Uniquely identifier of the country.

 

Table 3-101 shows Geography City: CITY level in GEOGRAPHY hierarchy.

Table 3-101 Geography City

Sr. Number Attribute Description Sample Value

1

GEOGRAPHY CITY NAME

Name of the city

 

2

EFFECTIVE TO DATE

EFFECTIVE TO DATE, standard SCD2 column

12/31/2005 12:00:00 AM

3

GEOGRAPHY STATE CODE

Uniquely identifier of state

 

4

EFFECTIVE FROM DATE

Active from. Standard SCD field, Effective Start Date

12/31/2005 12:00:00 AM

5

GEOGRAPHY CITY CODE

Uniquely identifier of city

 

6

GEOGRAPHY CITY DESC

CITY DESC.

 

Table 3-102 shows Geography County: County level in GEOGRAPHY hierarchy.

Table 3-102 Geography County

Sr. Number Attribute Description Sample Value

1

EFFECTIVE TO DATE

EFFECTIVE TO DATE, standard SCD2 column

 

2

EFFECTIVE FROM DATE

Active from. Standard SCD field, Effective Start Date

12/31/2005 12:00:00 AM

3

GEOGRAPHY COUNTY CODE

Uniquely identifier of county

 

4

GEOGRAPHY COUNTY NAME

Name of the county

 

5

GEOGRAPHY CITY CODE

Uniquely identifier of city

 

Table 3-103 shows Address Location: Keep all address. It has levels as country, state, city, address and so on.

Table 3-103 Address Location

Sr. Number Attribute Description

1

ADDRESS STYLE

Any specific style of the address. It might include the detail like All Capital words, case, font and so on.

2

BUILDING CODE

Uniquely identifier of building

3

ELEVATION

Elevation of the Geographic Location

4

ELEVATION UOM CODE

Uniquely identifier of ELEVATION UOM

5

FLOOR CODE

Uniquely identifier of floor

6

FLOOR NAME

Name of the floor

7

GEOGRAPHY LOCATION CODE

Applicable unique geography ID.

8

GEOGRAPHY REGION CODE

Uniquely identifier of GEOGRAPHY REGION

9

LATITUDE

LATITUDE description

10

PRIMARY EMAIL ADDRESS

Email address

11

REGION NAME

Name of the Reason

12

SUBREGION DESC

description of sub region

13

TAX AUTHORITY CODE

Unique identified for the tax authority

14

WORLD DESC

Description of world

15

WORLD NAME

Name of the world

16

ADDRESS LATITUDE MEASURE

This is the Latitude value of the specified location

17

POSTAL PLUS CODE

Four digit extension to the United States Postal ZIP code.

18

STREET CODE

Uniquely identifier of state

19

CITY DESC

Description of the city

20

FLAT ROOM CODE

Uniquely identifier of the flat room

21

GEOGRAPHY STATE CODE

State of the geography

22

POST OFFICE BOX

PO box if available.

23

STATE DESC

Description of the state

24

STATE NAME

Name of the state

25

ADDRESS LONGITUDE MEASURE

This is the longitude location of the specified address.

26

BUILDING DESC

Description for Building

27

COUNTY DESC

Description for County

28

GEOGRAPHY COUNTRY CODE

Code for Geography Country

29

POSTCODE CODE

Code for Post Code

30

ADDRESS DESCRIPTION

Address description. Textual description of the address.

31

ADDRESS TYPE CODE

Unique identifier for the address type.

32

BUILDING NAME

Name for Building

33

COUNTY NAME

Name for County

34

EFFECTIVE TO DATE

EFFECTIVE TO DATE, standard SCD2 column.

35

FLAT ROOM DESC

Description for Flat Room

36

GEOGRAPHY COUNTY CODE

Code for Geography County

37

GEOGRAPHY ENTITY CODE

unique geography identifier. A unique identifier for the geography entities, could be a system generated unique key for geography entity

38

REGION DESC

Description for Region

39

WORLD CODE

Description for World

40

ADDRESS LINE 2

Address. Line 2 of the detailed postal address

41

ADDRESS LINE 3

Address. Line 3 of the detailed postal address

42

LONGITUDE

The angular distance between a point on any meridian and the prime meridian at Greenwich

43

PRIMARY ADDRESS TELEPHONE

Telephonic address

44

STATUS CODE

An indicator of the address current status. For instance, this address may be valid, invalid, temporary, and so on.

45

ADDRESS LINE 1

Address. Line one of detail postal address

46

ADDRESS LINES PHONETIC

Phonetic or Kana representation of the Kanji address lines (used in Japan).

47

COUNTRY NAME

Name for Country

48

EFFECTIVE FROM DATE

EFFECTIVE FROM DATE, standard SCD2 column.

49

EMPLOYEE CODE

Code for Employee

50

FLOOR DESC

Description for Floor

51

SUBREGION NAME

Name for Subregion

52

ADDRESS LOCATION CODE

unique identifier for the address.

53

CITY NAME

Name for City

54

COUNTRY DESC

Description for Country

55

FLAT ROOM NAME

Name for Flat Room

56

GEOGRAPHY CITY CODE

Code for Geography City

57

GEOGRAPHY SUBREGION CODE

Code for Geography Subregion

58

STREET DESC

Description for Street

59

STREET NAME

Name for Street

60

TIME ZONE CODE

Unique Identifier for time zone.


Give Away Type

Description: GIVE AWAY TYPE

Give Away Type Hierarchies

Standard Give Away Hierarchy:

Description of image050.gif follows
Description of the illustration image050.gif

Give Away Type Levels

Table 3-104 shows All Give Away Type: All Give Away are most aggregate level of the dimension.

Table 3-104 All Give Away Type

Sr. Number Attribute Description

1.

ALL GIVE AWAY TYPE CODE

Code for All Give Away Type.


Table 3-105 shows Give Away Type Detail: Detail level of the dimension. Stores the Give Away Type Detail Information.

Table 3-105 Give Away Type Detail

Sr. Number Attribute Description

1.

GIVE AWAY TYPE CODE

Code for Give Away type

2.

GIVE AWAY TYPE DESC

Description of the Give Away Type

3.

GIVE AWAY TYPE NAME

Name of the Give Away type

4.

LANGUAGE CODE

Language ID---Unique identifier for a row in the Language dimension.


GPRS Services

Description: GPRS SERVICE

GRPS Service Hierarchies

Standard GRPS Service Hierarchy:

Description of image051.gif follows
Description of the illustration image051.gif

GPRS Service Levels

Table 3-106 shows GRRS Services Total: All GPRS Service are most aggregate level of the dimension.

Table 3-106 GRRS Services Total

Sr. Number Attribute Description

1.

ALL GPRS SERVICE CODE

Code for All GPRS Service.


Table 3-107 shows GRRS Services: Detail level of the dimension. Stores the GPRS Service Detail Information.

Table 3-107 GRRS Services Detail

Sr. Number Attribute Description

1.

EFFECTIVE FROM DATE

Active from. Standard SCD field,

2.

EFFECTIVE TO DATE

Date the party left the program. Will be null if the party is currently a member of the program.

3.

EQUIPMENT FUNCTIONALITY CODE

The code of function

4.

GPRS SERVICE CODE

GPRS service code

5.

GPRS SERVICE DESC

GPRS service description

6.

GPRS SERVICE NAME

GPRS service name

7.

IN PLATFORM CODE

IN PLATFORM CODE.

8.

NETWORK CODE

Identifier of the network.

9.

PRODUCT CODE

The unique identifier of product.

10.

PRODUCT DESC

Full Description.

11.

PRODUCT GROUP CODE

The unique identifier of product group

12.

PRODUCT NAME

Product name.

13.

PRODUCT PACKAGE CHARGE TYPE CODE

The unique identifier of product package charge type.

14.

PRODUCT PACKAGE TYPE CODE

Code for product package type

15.

PRODUCT TYPE CODE

Retrofitted from column PRODUCT_KEY of table FACT_MARKET_SHARE

16.

STATUS CODE

An indicator of the address current status. For instance, this address may be valid, invalid, temporary, and so on.

 

PRODUCT RATING PLAN TYPE CODE

 

Handset Model

Description: HANDSET MODEL

Handset Model Hierarchies

Standard Handset Model Hierarchy:

Description of image052.gif follows
Description of the illustration image052.gif

Handset Model Levels

Table 3-108 shows Handset Model Total: All Handset Model are most aggregate level of the dimension.

Table 3-108 Handset Model Total

Sr. Number Attribute Description

1.

HANDSET MODEL TOTAL CODE

Code for All Handset Model.


Table 3-109 shows Handset Model Detail: Detail level of the dimension. Stores the Handset Model Detail Information.

Table 3-109 Handset Model Detail

Sr. Number Attribute Description

1.

AVAILABLE FOR SALE DATE

The date when this ITEM becomes available for sale. For example, certain books have specific publication dates, music entertainment release dates.

2.

BRAND CODE

Unique Identifier for a item brand

3.

BRAND NAME

One Item can have one brand name. One brand name can extend to multiple items. A unique name to denote a class of Items as a product of a single supplier or manufacturer. The brand can include private label Items.

4.

COMMISSION IND

A flag to indicate whether this ITEM has a commission related to it or not

5.

CUSTOMER USAGE INDICATOR

Indicates whether equipment should be used by customer, otherwise for service provider.

6.

DISCOUNT IND

A flag to indicate whether this ITEM can be discounted.

7.

EFFECTIVE FROM DATE

Active from. Standard SCD field, Effective Start Date

8.

EFFECTIVE TO DATE

Date the party left the program. Will be null if the party is currently a member of the program.

9.

EQUIPMENT CODE

EQUIPMENT CODE.

10.

EQUIPMENT DESC

EQUIPMENT DESC.

11.

EQUIPMENT FUNCTIONALITY CODE

The code of function

12.

EQUIPMENT NAME

EQUIPMENT NAME.

13.

HANDSET BRAND CODE

Code for Handset Brand.

14.

HANDSET BRAND DESC

Description of the Handset Brand.

15.

HANDSET BRAND NAME

Name of the Handset Brand.

16.

HANDSET MODEL CODE

The date when this ITEM becomes available for sale. For example, certain books have specific publication dates, music entertainment release dates.

17.

HANDSET MODEL DESC

Description of Handset Model.

18.

HANDSET MODEL NAME

Name of the Handset Model.

19.

IN PLATFORM CODE

IN PLATFORM CODE.

20.

INVENTORY IND

Indicates whether an item is an inventory item or a non-inventory item (such as gift certificates, labor)

21.

ITEM CLUSTER CODE

Surrogate key used to identify an Item cluster. This column is used for Behavior Profiling.

22.

ITEM CODE

Unique identifier for item type.

23.

ITEM TYPE CODE

Unique identifier for item type.

24.

MERCHANDISE IND

Indicates whether the item's sales are financially tracked in the stock ledger.

25.

NETWORK CODE

Identifier of the network.

26.

PERISHABLE IND

Indicates whether the item is perishable.

27.

PRICE AUDIT IND

An indicator to denote whether the ITEM was validated (scanned) during verification of the ITEM table.

28.

PRIMARY ALTERNATE ITEM NAME

Default Alternate Item Name

29.

PRIMARY ALTERNATE ITEM NUMBER

Default Alternate Item Number

30

PRODUCT CODE

Description of Handset Model.

31.

PRODUCT GROUP CODE

Code for Product Group.

32.

PRODUCT NAME

Product name.

33.

PRODUCT PACKAGE CHARGE TYPE CODE

Code. For example: CMBND

34.

PRODUCT PACKAGE TYPE CODE

Identifier for the offer. For example: Individual.

35.

PRODUCT RATING PLAN TYPE CODE

Identifier for the offer.

36.

PRODUCT TYPE CODE

Code. For example CALL

37.

RECIPE IND

The recipe identifier that is associated to the selling item.

38.

SECURITY REQUIRED TYPE CODE

A code that defines the security environment and procedures required for receiving, displaying and selling the item. This is for high-priced merchandise like jewelry, certain prescription drugs, ordinance, fireworks, and so on.

39.

SELLABLE IND

Indicates whether the item can be sold. If 'N', then the only analysis available is on customer order lines of type partial within Customer Order Management

40.

SHRINK IND

An indicator to denote if the ITEM could loose weight from the time of order until the time of receipt

41.

STATUS CODE

An indicator of the address current status. For instance, this address may be valid, invalid, temporary, and so on.

42.

STOP SALE IND

Indicates that sale of the item should be stopped immediately at the location.

43.

STORE REORDERABLE IND

Indicates whether the store may re-order the item.

44.

SUBSTITUTE IDENTIFIED IND

An ITEM for which there is a substitute available for sale within the RETAIL STORE

45.

SWELL IND

An indicator to indicate if the ITEM may gain weight or swell from time of order to time of receipt.

46.

TAX EXEMPT CODE

A code to denote the tax exemption status from sales and use tax. The codes refer to the UCC code

47.

UNIT PRICE FACTOR

The number of units of measure per selling unit. Used as the divisor when calculating the ITEMs unit retail price. For example: $1.67 per pound or $2.59 for 32 fl. oz.

48.

UOM CODE

The code used to specify the units in which a value is being expressed, or manner in which a measurement has been taken. This code relates to the UCC data element 355.

49.

VENDOR CODE

The vendor who provide this product. Here product should be an product item. For example: handset, STB

50.

VENDOR SITE CODE

Unique identifier or the Vendor Site

 

PRODUCT DESC

 
 

MODEL TYPE CODE

 

IN Platform

Description: IN PLATFORM

IN Platform Hierarchies

Standard IN Platform Hierarchy:

Description of image054.gif follows
Description of the illustration image054.gif

IN Platform Level

Table 3-110 shows IN Platform Total: All IN Platform are most aggregate level of the dimension.

Table 3-110 IN Platform Total

Sr. Number Attribute Description

1.

ALL IN PLATFORM CODE

Code for All IN Platform.


Table 3-111 shows IN Platform Detail: Detail level of the dimension. Stores the IN Platform Detail Information.

Table 3-111 IN Platform Detail

Sr. Number Attribute Description Sample Value

1.

EFFECTIVE FROM DATE

Active from. Standard SCD field, Effective Start Date

12/31/2005 12:00:00 AM

2.

EFFECTIVE TO DATE

Date the party left the program. Will be null if the party is currently a member of the program.

12/31/2005 12:00:00 AM

3.

IN PLATFORM CODE

Id for IN Platform.

5101

4.

IN PLATFORM DESC

IN Platform description.

 

5.

IN PLATFORM NAME

IN Platform name.

 

6.

NETWORK CODE

The network which is used by this platform

1

8.

STATUS CODE

An indicator of the address current status. For instance, this address may be valid, invalid, temporary, and so on.

 

Initiative Type

Description: INITIATIVE TYPE

Initiative Type Hierarchies

Standard Initiative Type Hierarchy:

Description of image056.gif follows
Description of the illustration image056.gif

Initiative Type Levels

Table 3-112 shows Initiative Type Total: All Initiative Type are most aggregate level of the dimension.

Table 3-112 Initiative Type Total

Sr. Number Attribute Description

1.

ALL INITIATIVE TYPE CODE

Code for All Initiative Type.


Table 3-113 shows Initiative Type Detail: Detail level of the dimension. Stores the Initiative Type Detail Information.

Table 3-113 Initiative Type Detail

Sr. Number Attribute Description

1.

INITIATIVE TYPE CODE

The initiative type identifier.

2.

INITIATIVE TYPE NAME

The initiative type name.

3.

INITIATIVE TYPE DESC

The initiative type description

4.

LANGUAGE CODE

Language ID---Unique identifier for a row in the Language dimension.


Interaction Channel

Description: INTERACTION CHANNEL

Interaction Channel Hierarchies

Standard Interaction Channel Hierarchy:

Description of image057.gif follows
Description of the illustration image057.gif

Interaction Channel Levels

Table 3-114 shows Interaction Channel Total: All Initiative Type are most aggregate level of the dimension.

Table 3-114 Interaction Channel Total

Sr. Number Attribute Description

1.

ALL INTERACTION CHANNEL CODE

Code for All Interaction Channel.


Table 3-115 shows Interaction Channel Detail: Detail level of the dimension. It Stores the Interaction Channel Detail Information.

Table 3-115 Interaction Channel Detail

Sr. Number Attribute Description Sample Value

1.

CAPACITY QUANTITY

The number of transaction that a Channel can handle, at a point of time.

 

2.

CHANNEL CODE

A unique identifier for channel

 

3.

CHANNEL DESC

Description for Channel

 

4.

CHANNEL NAME

The name assigned to a channel.

SHOP

5.

CHANNEL TYPE CODE

A code used to uniquely identify a major grouping of Channels. Examples: M - MailT - Telephone TV - Television.

SLCHNL

6.

EFFECTIVE FROM DATE

Active from. Standard SCD field, Effective Start Date

12/31/2005 12:00:00 AM

7.

EFFECTIVE TO DATE

Date the party left the program. Will be null if the party is currently a member of the program.

12/31/2005 12:00:00 AM

8.

INTERACTION CHANNEL CODE

A code for Interaction channel

 

9.

PARTY CODE

A code for any person or business that is of interest to the Communications Service Provider.

 

10.

PARTY TYPE CODE

PARTY TYPE CODE.

ORG

11.

STATUS CODE

An indicator of the address current status. For instance, this address may be valid, invalid, temporary, and so on. An indicator of the address current status. For instance, this address may be valid, invalid, temporary, and so on.

 

Interaction Direction

Description: INTERACTION DIRECTION

Interaction Direction Hierarchies

Standard INTERACTION DIRECTION Hierarchy:

Description of dim_interactiondirt.png follows
Description of the illustration dim_interactiondirt.png

Interaction Direction Levels

The following table shows INTERACTION DIRECTION Total: All INTERACTION DIRECTION is most aggregate level of the dimension.

Table for INTERACTION DIRECTION Total

Sr. Number Attribute Description
1 INTERACTION DIRECTION Total Code for All INTERACTION DIRECTION Total.

Detail table shows INTERACTION DIRECTION Detail: It captures information relating to interaction Direction.

Detail table INTERACTION DIRECTION Detail

Sr. Number Attribute Description
1 INTERACTION DIRECTION NAME Direction name.
2 INTERACTION DIRECTION CODE Identifier of the interaction direction.
3 LANGUAGE CODE  
4 INTERACTION DIRECTION DESC  

Interaction Type

Description: INTERACTION TYPE

Interaction Type Hierarchies

Standard INTERACTION TYPE Hierarchy:

Description of dim_interaction_typet.png follows
Description of the illustration dim_interaction_typet.png

Interaction Type Levels

The following table shows INTERACTION TYPE Total: All INTERACTION TYPE is most aggregate level of the dimension.

Table for INTERACTION TYPE Total

Sr. Number Attribute Description
1 INTERACTION TYPE Total Code for All INTERACTION TYPE Total.

Detail table shows INTERACTION TYPE Detail: It captures information relating to interaction Type.

Detail table INTERACTION TYPE Detail

Sr. Number Attribute
1 INTERACTION TYPE CODE
2 INTERACTION TYPE DESC
3 INTERACTION TYPE NAME
4 LANGUAGE CODE

Invoice Adjustment Reason

Description: INVOICE ADJUSTMENT REASON

Invoice Adjustment Reason Hierarchies

Standard Invoice Adjustment Reason Hierarchy:

Description of image058.gif follows
Description of the illustration image058.gif

Invoice Adjustment Reason Levels

Table 3-116 shows Invoice Adjustment Reason Total: All Invoice Adjustment Reason are most aggregate level of the dimension.

Table 3-116 Invoice Adjustment Reason Total

Sr. Number Attribute Description

1.

ALL INVOICE ADJUSTMENT REASON CODE

Code for All Invoice Adjustment Reason.


Table 3-117 shows Invoice Adjustment Reason Detail: Detail level of the dimension. It Stores the Invoice Adjustment Reason Detail Information.

Table 3-117 Invoice Adjustment Reason Detail

Sr. Number Attribute Description Sample Value

2.

INVOICE ADJUSTMENT RSN CODE

A unique identifier for reason

CMPLN

3.

INVOICE ADJUSTMENT RSN DESC

Description for reason

Customer complain

4.

INVOICE ADJUSTMENT RSN NAME

The name for invoice adjustment.

Customer complain

5.

LANGUAGE CODE

Language ID---Unique identifier for a row in the Language dimension.

 

Invoice Adjustment Type

Description: INVOICE ADJUSTMENT TYPE

Invoice Adjustment Type Hierarchies

Standard Invoice Adjustment Type Hierarchy:

Description of image059.gif follows
Description of the illustration image059.gif

Invoice Adjustment Type Levels

Table 3-118 shows Invoice Adjustment Type Total: All Invoice Adjustment Type are most aggregate level of the dimension.

Table 3-118 Invoice Adjustment Type Total

Sr. Number Attribute Description

1.

ALL INVOICE ADJUSTMENT TYPE CODE

Code for All Invoice Adjustment Type.


Table 3-119 shows Invoice Adjustment Type Detail: Detail level of the dimension. It Stores the Invoice Adjustment Type Detail Information.

Table 3-119 Invoice Adjustment Type Detail

Sr. Number Attribute Description Sample Value

1.

INVOICE ADJUSTMENT TYPE CODE

A code used to uniquely identify a adjustment type.

CMPGN

2.

INVOICE ADJUSTMENT TYPE DESC

A textual description of the adjustment Type.

Invoice Adjustment because of Specific Campaign in certain time period

3.

INVOICE ADJUSTMENT TYPE NAME

The name assigned to a adjustment Type.

Campaign

4.

LANGUAGE CODE

Language ID---Unique identifier for a row in the Language dimension.

 

Invoice Status

Description: INVOICE STATUS

Invoice Status Hierarchies

Standard INVOICE STATUS Hierarchy:

Description of dim_inv_stat.png follows
Description of the illustration dim_inv_stat.png

Invoice Status Levels

The following table shows INVOICE STATUS Total: All INVOICE STATUS is most aggregate level of the dimension.

Table for INVOICE STATUS Total

Sr. Number Attribute Description
1 INVOICE STATUS Total Code for All INVOICE STATUS Total.

Detail table shows INVOICE STATUS Detail: It captures information relating to Invoice Status.

Detail table INVOICE STATUS Detail

Sr. Number Attribute
1 INVOICE STATUS CODE
2 INVOICE STATUS DESCRIPTION
3 INVOICE STATUS NAME
4 LANGUAGE CODE

ISP

Description: ISP

ISP Hierarchies

Standard ISP Hierarchy:

Description of dim_isp.png follows
Description of the illustration dim_isp.png

ISP Levels

The following table shows ISP Total: All ISP is most aggregate level of the dimension.

Table for ISP Total

Sr. Number Attribute Description
1 ISP Total Code for All ISP Total.

Detail table shows ISP Detail: It captures information relating to ISP.

Detail table ISP Detail

Sr. Number Attribute Description
1 STOCK EXCHANGE NAME Abbreviation of listed companies as used on the stock exchange.
2 PAYMENT ACCOUNT NUMBER Account number for payments.
3 JUDICIAL DISTRAINT CODE Case identifier of the judicial distraint.
4 PAYMENT ACCOUNT CLOSE DATE Closing date of the account for payments.
5 COURT CODE Code of the law of court.
6 CHAIRMAN CODE Connect to Another Person Party who is responsible for this Organization.
7 CONTACT NAME Contact Employee for organization.
8 JUDICIAL DISTRAINT DATE Date of the judicial distraint.
9 VALIDATION START DATE Date of the registration of the company' record deletion from the company register.
10 DUNS NUMBER DUNS NUMBER is an identifier for organization
11 VALIDATION END DATE Effective date of the deletion of the company's record from the company register.
12 FINAL SETTLEMENT END DATE End date of final settlement.
13 DOMESTIC INDICATOR For PARTYs that are organizations, this indicates whether the organization is foreign or domestically owned.
14 CONTACT CODE ID of the contact person for the organization.
15 MANAGER CODE ID of the manager for the organization.
16 TAX EXEMPT STATUS Indicates if the org. is tax exempt.
17 MANAGER NAME Name of manager for the whole company.
18 PAYMENT ACCOUNT OPEN DATE Opening date of the account for payments.
19 ANNUAL REVENUE Revenue of the company
20 ANNUAL REVENUE LOCAL Revenue of the company in local currency.
21 ANNUAL REVENUE REPORTING Revenue of the company in reporting currency.
22 BANKRUPTCY START DATE start date of bankruptcy.
23 FINAL SETTLEMENT START DATE Start date of final settlement.
24 LIQUIDATION START DATE Start date of liquidation.
25 TERMINATION DATE Termination date of the company in case of company was founded with termination date.
26 LIQUIDATION END DATE The date when the company/org was liquidated. If is null and start_date is not null, the company is undergoing the liquidation.
27 BANKRUPTCY END DATE The end date of bankruptcy. If current date is behind start and end date is null, then the company is undergoing the bankruptcy process.
28 EQUITY AMOUNT The equity value of the company/org.
29 EQUITY AMOUNT LOCAL The equity value of the company/org.
30 EQUITY AMOUNT REPORTING The equity value of the company/org.
31 SEAL IMAGE The image of the Organization's Seal, or the Artificial Person's Signature.
32 ISP BUSINESS LICENSE CODE The isp business license code issued by regulation authorities.
33 EMPLOYEE COUNT Total number of employee in the company or organization.
34 COMPANY REGISTRY NUMBER Will be same as Party.National_Identifier. Natural Key for Organization.
35 ANNUAL SALES LOCAL  
36 ANNUAL SALES REPORTING  
37 EXTERNAL ORGANIZATION TYPE CODE2  
38 ISP CODE  
39 ISP TYPE CODE2  
40 ANNUAL SALES  
41 OTHER INDIVIDUAL CODE1  
42 PARTY ORGANIZATION TYPE CODE  

Item Subclass

Description: ITEM SUBCLASS

Item Subclass Hierarchies

Standard ITEM SUBCLASS Hierarchy:

Description of dim_item_sub.png follows
Description of the illustration dim_item_sub.png

Item Subclass Levels

The following table shows ITEM SUBCLASS Total: All ITEM SUBCLASS is most aggregate level of the dimension.

Table for ITEM SUBCLASS Total

Sr. Number Attribute Description
1 ITEM SUBCLASS Total Code for All ITEM SUBCLASS Total.

Detail table shows ITEM SUBCLASS Detail: It captures information relating to Item Subclass.

Detail table ITEM SUBCLASS Detail

Sr. Number Attribute
1 SUBCLASS BUYER NAME
2 SUBCLASS BUYER CODE
3 EFFECTIVE TO DATE
4 STATUS CODE
5 SUBCLASS NAME
6 ITEM CLASS CODE
7 SUBCLASS MERCHANDISER CODE
8 SUBCLASS CODE
9 PRODUCT ENTITY CODE
10 EFFECTIVE FROM DATE
11 SUBCLASS MERCHANDISER NAME

Legal Process Status Type

Description: LEGAL PROCESS STATUS TYPE

Legal Process Status Type Hierarchies

Standard Legal Process Status Type Hierarchy:

Description of image061.gif follows
Description of the illustration image061.gif

Legal Process Status type Levels

Table 3-120 shows Legal Process Status Type Total: All Legal Process Status Type are most aggregate level of the dimension.

Table 3-120 Legal Process Status Type Total

Sr. Number Attribute Description

1.

ALL LEGAL PROCESS STATUS TYPE CODE

Code for All Legal Process Status Type.


Table 3-121 shows Legal Process Status Type Detail: Detail level of the dimension. It Stores the Legal Process Status Type Detail Information.

Table 3-121 Legal Process Status Type Detail

Sr. Number Attribute Description

1.

LEGAL PROCESS STATUS TYPE CODE

Legal Process Started Indicator.

2.

LEGAL PROCESS STATUS TYPE DESC

Description for Legal Process Status Type.

3.

LEGAL PROCESS STATUS TYPE NAME

Name for Legal Process Status Type.

4.

LANGUAGE CODE

Language ID---Unique identifier for a row in the Language dimension.


Lifecycle Type

Description: LIFECYCLE TYPE

Lifecycle Type Hierarchies

Standard LIFECYCLE TYPE Hierarchy:

Description of dim_lifc.png follows
Description of the illustration dim_lifc.png

Lifecycle Type Levels

The following table shows LIFECYCLE TYPE Total: All LIFECYCLE TYPE is most aggregate level of the dimension.

Table for LIFECYCLE TYPE Total

Sr. Number Attribute Description
1 LIFECYCLE TYPE Total Code for All LIFECYCLE TYPE Total.

Detail table shows LIFECYCLE TYPE Detail: It captures information relating to Lifecycle Type.

Detail table LIFECYCLE TYPE Detail

Sr. Number Attribute
1 LANGUAGE CODE
2 LIFECYCLE TYPE CODE
3 LIFECYCLE TYPE NAME
4 LIFECYCLE TYPE DESCRIPTION

Loyalty Program Channel

Description: LOYALTY PROGRAM CHANNEL

Loyalty Program Channel Hierarchies

Standard Loyalty Program Channel Hierarchy:

Description of image062.gif follows
Description of the illustration image062.gif

Loyalty Program Channel Levels

Table 3-122 shows Loyalty Program Channel Total: All Loyalty Program Channel are most aggregate level of the dimension.

Table 3-122 Loyalty Program Channel Total

Sr. Number Attribute Description

1.

ALL LOYALTY PROGRAM CHANNEL CODE

Code for All Loyalty Program Channel.


Table 3-123 shows Loyalty Program Channel Detail: Detail level of the dimension. It Stores the Loyalty Program Channel Detail Information.

Table 3-123 Loyalty Program Channel Detail

Sr. Number Attribute Description Sample Value

1.

CAPACITY QUANTITY

The number of transaction that a Channel can handle, at a point of time.

 

2.

CHANNEL CODE

The unique identifier for each Channel. A Channel identifies each possible link where interaction between the Communications Service Provider and the Customer occurs.

-1,1

3.

CHANNEL DESC

Description for that channel can be handle.

 

4.

CHANNEL NAME

The name assigned to a channel.

 

5.

CHANNEL TYPE CODE

Unique identifier of the channel type

LYLTCHNL

6.

EFFECTIVE FROM DATE

Active from. Standard SCD field, Effective Start Date

12/31/2005 12:00:00 AM

7.

EFFECTIVE TO DATE

Date the party left the program. Will be null if the party is currently a member of the program.

12/31/2005 12:00:00 AM

8.

LOYALTY PROGRAM CHANNEL CODE

Code for Loyalty Program Channel

-1,1

9.

PARTY CODE

A code for any person or business that is of interest to the Communications Service Provider.

 

10.

PARTY TYPE CODE

PARTY TYPE CODE.

CUSTOMER

11.

STATUS CODE

An indicator of the address current status. For instance, this address may be valid, invalid, temporary, and so on. An indicator of the address current status. For instance, this address may be valid, invalid, temporary, and so on.

 

Loyalty Tier

Description: LOYALTY TIER

Loyalty Tier Hierarchies

Standard LOYALTY TIER Hierarchy:

Description of dim_loaltyt.png follows
Description of the illustration dim_loaltyt.png

Loyalty Tier Levels

The following table shows LOYALTY TIER Total: All LOYALTY TIER is most aggregate level of the dimension.

Table for LOYALTY TIER Total:

Sr. Number Attribute Description
1 LOYALTY TIER Total Code for All LOYALTY TIER Total.

Detail table shows LOYALTY TIER CLASS Detail: It captures information relating to Loyalty Tier Class.

Detail table LOYALTY TIER CLASS Detail

Sr. Number Attribute
1 CURRENT INDICATOR
2 PROGRAM CODE
3 LAST UPDATE BY
4 START QUALIFIG PERIOD CODE
5 EFFECT FROM DATE
6 LOYALTY TIER CLASS CODE
7 PROGRAM CODE 2
8 STATUS CODE
9 LOYALTY TIER CLASS NAME
10 LOAD DATE
11 LAST UPDATE DATE
12 EFFECT TO DATE

Detail table shows LOYALTY TIER Detail: It captures information relating to loyalty Tier.

Detail table LOYALTY TIER Detail

Sr. Number Attribute
1 GRACE PERIOD
2 MINIMUM TIER LENGTH
3 LOWEST DEMOTN TIER
4 EXP POINTS INDICATOR
5 EFFECT TO DATE
6 EFFECT FROM DATE
7 DEMOTN TIER INDICATOR
8 CURRENT INDICATOR
9 STATUS CODE
10 TIRE QUALIFICATION START POINTS
11 TIRE CARD TYPE CODE1
12 TIRE CARD TYPE CODE
13 TIER LUNGE
14 PROGRAM CODE
15 POINTS EXPRY BASIC CODE
16 POINTS EXPIRY BASIS CODE 1
17 PRIMARY TIER INDICATOR
18 LOAD DATE
19 LAST UPDATE DATE
20 LOYALTY TIER CLASS CODE
21 LOYALTY TIER CLASS CODE 1
22 LOYALTY TIER CODE
23 LOYALTY TIER NAME
24 LAST UPDATE BY

Market Area

Description: MARKET AREA

Market Area Hierarchies

Standard Market Area Hierarchy:

Description of image063.gif follows
Description of the illustration image063.gif

Market Area Levels

Table 3-124 shows Market Area Total: All Market Area are most aggregate level of dimension.

Table 3-124 Market Area Total

Sr. Number Attribute Description

1.

ALL MARKET AREA CODE

Code for All Market Area's


Table 3-125 shows Market Area Detail: Detail level of the dimension. It Stores the Market Area Information.

Table 3-125 Market Area Details

Sr. Number Attribute Description

1

MARKET AREA CODE

Market Area identifier

2

SERVICE COVERAGE AREA CODE

COVERAGE AREA CODE. Unique identifier for the coverage area

3

ORGANIZATION BUSINESS UNIT CODE

Market Area identifier

4

SECONDARY ZIP CODE

Applicable only in case the zip code spans across multiple zip codes

5

MARKET AREA LEVEL CODE

Identifier for the community or logical segment under the market area.

6

MARKET AREA UOM CODE

This is the unit of measure used to measure the size of the trading area, that is, miles, minutes, and so on.

7

PRIMARY ZIP CODE

Primary Zip code for the market area.

8

MARKET AREA NAME

Name of the market area.

9

MARKET AREA DESC

Description of the market area.

10

AREA TYPE

Type of Trading Area- Urban- Suburban

11

COUNTY

County / District

12.

CITY

City in which the market area belongs

13.

STATE

State or province

14.

COUNTRY

Country of the market area

15.

PULL FACTOR

Ratios that estimate the proportion of local sales that occurs in a town

16.

TRADE AREA CAPTURE

An estimate of the number of people who shop in the local area during a certain period

17.

TOTAL POPULATION

Estimated total population of the market area

18.

STATE POPULATION

Estimated state population of the market area.

19.

STATE SALES

Estimated total retail sales in the state

20.

STATUS CODE

Unique Identifier of the status.

 

DEFINITION TYPE

 
 

AREA SHAPE

 
 

STATE SALES LOCAL

 
 

STATE SALES REPORTING

 
 

EFFECTIVE FROM DATE

 
 

EFFECTIVE TO DATE

 

Media Object Type

Description: MEDIA OBJECT TYPE

Media Object Type Hierarchies

Standard MEDIA OBJECT TYPE Hierarchy:

Description of dim_media_obj.png follows
Description of the illustration dim_media_obj.png

Media Object Type Levels

The following table shows MEDIA OBJECT TYPE Total: All MEDIA OBJECT TYPE is most aggregate level of the dimension.

Table for MEDIA OBJECT TYPE Total

Sr. Number Attribute Description
1 MEDIA OBJECT TYPE Total Code for All MEDIA OBJECT TYPE Total.

Detail table shows MEDIA OBJECT TYPE Detail: It captures information relating to Media Object Type.

Detail table MEDIA OBJECT TYPE Detail

Sr. Number Attribute Description
1 MEDIA OBJECT TYPE CODE The code to identify the Media object.
2 MEDIA OBJECT TYPE DESC The full Description.
3 MEDIA OBJECT TYPE NAME The name
4 LANGUAGE CODE  

Network

Description: NETWORK

Network Hierarchies

Standard Network Hierarchy:

Description of image064.gif follows
Description of the illustration image064.gif

Network Levels

Table 3-126 shows Network Total: All Networks are most aggregate level of dimension.

Table 3-126 Network Total

Sr. Number Attribute Description

1.

ALL NETWORK CODE

Code for All Network's.


Table 3-127 shows Network Detail: Detail level of the dimension. It stores the Network information.

Table 3-127 Network Detail

Sr. Number Attribute Description Sample Value

1.

NETWORK CODE

Identifier of the network

CDMA

2.

NETWORK TYPE CODE

A code that uniquely identifies the type of technology (for example GSM, CDMA) being used by a network.

CDMA

3.

EXTERNAL OPERATOR CODE

Unique identifier for operator. For example: Airtel, CMCC, NTT.

 

4.

SERVICE PROVIDER CODE

Code of the service provider of the network.

 

5.

NETWORK NAME

Name of the network

CDMA

6.

NETWORK DESC

A textual description that describes the type of technology (for example GSM, CDMA) being used by a network.

CDMA


Network Touchpoint

Description: NETWORK TOUCHPOINT

Network Touchpoint Hierarchies

Standard NETWORK TOUCHPOINT Hierarchy:

Description of dim_networkt.png follows
Description of the illustration dim_networkt.png

Network Touchpoint Levels

The following table shows NETWORK TOUCHPOINT Total: All NETWORK TOUCHPOINT is most aggregate level of the dimension.

Table for NETWORK TOUCHPOINT Total

Sr. Number Attribute Description
1 NETWORK TOUCHPOINT Total Code for All NETWORK TOUCHPOINT Total.

Detail table shows NETWORK TOUCHPOINT Detail: It captures information relating to Network Touchpoint.

Detail table NETWORK TOUCHPOINT Detail

Sr. Number Attribute Description
1 GEOGRAPHY ENTITY CODE Geography Entity Code
2 NETWORK TOUCHPOINT CODE Identifier of the site.
3 RURAL DELIVERY ADDRESS Rural delivery instructions. This is implementation dependent.
4 INSTALLATION DATE The date when the network touchpoint was established.
5 LATITUDE The latitude measure for the trade area
6 LONGITUDE The longitude measure for the trade area
7 POSTAL CODE The site postal code.
8 NETWORK TOUCHPOINT CLASS CODE Unique identifier of the network touchpoint class.
9 NETWORK TOUCHPOINT STATUS CODE Unique identifier of the network touchpoint status.
10 NETWORK TOUCHPOINT TYPE CODE Unique identifier of the network touchpoint type.
11 ADDRESS LOCATION CODE  
12 RESOURCE CODE  

Network Touchpoint Class

Description: NETWORK TOUCHPOINT CLASS

Network Touchpoint Class Hierarchies

Standard Network Touchpoint Class Hierarchy:

Description of image066.gif follows
Description of the illustration image066.gif

Network Touchpoint Class Levels

Table 3-128 shows Network Touchpoint Class Total: All Networks Touch point class are most aggregate level of dimension.

Table 3-128 Network Touchpoint Class Total

Sr. Number Attribute Description

1.

NETWORK TOUCHPOINT CLASS TOTAL CODE

Code for All Network Touchpoint class.


Table 3-129 shows Network Touchpoint Class Detail: Detail level of the dimension. It stores the Network Touchpoint class information.

Table 3-129 Network Touchpoint Class Detail

Sr. Number Attribute Description Sample Value

1.

NETWORK TOUCHPOINT CLASS CODE

Unique identifier of the network touchpoint class.

INDVL

2.

NETWORK TOUCHPOINT CLASS NAME

Name of network touchpoint class.

Individual

3.

NETWORK TOUCHPOINT CLASS DESC

Description of network touchpoint class.

Network touchpoint is owned by Individual customer

4.

LANGUAGE CODE

Code for network touchpoint class languages.

 

Network Touchpoint Status

Description: NETWORK TOUCHPOINT STATUS

Network Touchpoint Status Hierarchies

Standard Network Touchpoint Status Hierarchy:

Description of image067.gif follows
Description of the illustration image067.gif

Network Touchpoint Status Level

Table 3-130 shows Network Touchpoint Status Total: All Networks Touchpoint Status are most aggregate level of dimension.

Table 3-130 Network Touchpoint Status Total

Sr. Number Attribute Description

1.

NETWORK TOUCHPOINT STATUS TOTAL CODE

Code for All Network Touchpoint Status.


Table 3-131 shows Network Touchpoint Status Detail: Detail level of the dimension. It stores the Network Touchpoint Status information.

Table 3-131 Network Touchpoint Status Detail

Sr. Number Attribute Description

1.

LANGUAGE CODE

Code for network touchpoint status languages

2.

NETWORK TOUCHPOINT STATUS CODE

Unique identifier of the network touchpoint status.

3.

NETWORK TOUCHPOINT STATUS NAME

Name of network touchpoint status.

4.

NETWORK TOUCHPOINT STATUS DESC

Description of network touchpoint status.


Network Touchpoint Type

Description: NETWORK TOUCHPOINT TYPE

Network Touchpoint Type Hierarchies

Standard Network Touchpoint Type Hierarchy:

Description of image068.gif follows
Description of the illustration image068.gif

Network Touchpoint Type Levels

Table 3-132 shows Network Touchpoint Type Total: All Networks Touchpoint Type are most aggregate level of dimension.

Table 3-132 Network Touchpoint Type Total

Sr. Number Attribute Description

1.

NETWORK TOUCHPOINT TYPE TOTAL CODE

Code for All Network Touchpoint Type.


Table 3-133 shows Network Touchpoint Type Detail: Detail level of the dimension. It stores the Network Touchpoint Type information.

Table 3-133 Network Touchpoint Type Detail

Sr. Number Attribute Description Sample Value

1.

LANGUAGE CODE

Code for network touchpoint type languages

 

2.

NETWORK TOUCHPOINT TYPE CODE

Unique identifier of the network touchpoint type.

BRDBND

3.

NETWORK TOUCHPOINT TYPE NAME

Name of the network touchpoint type.

Broadband

4.

NETWORK TOUCHPOINT TYPE DESC

Description of network touchpoint type.

Broadband


Network Type

Description: NETWORK TYPE

Network Type Hierarchies

Standard NETWORK TYPE Hierarchy:

Description of dim_network_type.png follows
Description of the illustration dim_network_type.png

Network Type Levels

The following table shows NETWORK TYPE Total: All NETWORK TYPE is most aggregate level of the dimension.

Table for NETWORK TYPE Total

Sr. Number Attribute Description
1 NETWORK TYPE Total Code for All NETWORK TYPE Total.

Detail table shows NETWORK TYPE Detail: It captures information relating to Network Type.

Detail table NETWORK TYPE Detail

Sr. Number Attribute Description Sample Value
1 NETWORK TYPE CODE A code that uniquely identifies the type of technology (for example GSM, CDMA) being used by a network. GSM, CDMA
2 NETWORK TYPE NAME A name assigned to the type of technology (for example GSM, CDMA) being used by a network. GSM, CDMA
3 NETWORK TYPE DESC A textual description that describes the type of technology (for example GSM, CDMA) being used by a network. GSM, CDMA

Notification Type

Description: NOTIFICATION TYPE

Notification Type Hierarchies

Standard Notification Type Hierarchy:

Description of image069.gif follows
Description of the illustration image069.gif

Notification Type Levels

Table 3-134 shows Notification Type Total: All Notification Type are most aggregate level of dimension.

Table 3-134 Notification Type Total

Sr. Number Attribute Description

1.

NOTIFICATION TYPE TOTAL CODE

Code for All Notification Type total.


Table 3-135 shows Notification Type Detail: Detail level of the dimension. It stores the Notification Type information.

Table 3-135 Notification Type Detail

Sr. Number Attribute Description Sample Value

1.

LANGUAGE CODE

Code for Notification type languages

 

2.

NOTIFICATION TYPE CODE

Code for UMS Notification Type.

FAX

3.

NOTIFICATION TYPE DESC

Description of the UMS Notification Type.

Fax

4.

NOTIFICATION TYPE NAME

Name of the UMS Notification Type.

Fax


NP Request Type

Description: NP REQUEST TYPE

NP Request Type Hierarchies

Standard NP Request Type Hierarchy:

Description of image070.gif follows
Description of the illustration image070.gif

NP Request Type Levels

Table 3-136 shows NP Request Type Total: All NP Request Type Total are most aggregate level of dimension.

Table 3-136 NP Request Type Total

Sr. Number Attribute Description

1.

NP REQUEST TYPE TOTAL CODE

Code for All NP Request Types Total.


Table 3-137 shows NP Request Type Detail: Detail level of the dimension. It stores the NP Request Type information.

Table 3-137 NP Request Type Detail

Sr. Number Attribute Description Sample Value

1.

LANGUAGE CODE

Code for NP Request Type language

 

2.

NP REQUEST TYPE CODE

A code, used to uniquely identify the NP REQUEST TYPE.

IN

3.

NP REQUEST TYPE NAME

The name assigned to the NP REQUEST TYPE.

Porting In

4.

NP REQUEST TYPE DESC

A textual description of the NP REQUEST TYPE.

Porting In


On Off Net Type

Description: ON OFF NET TYPE

On Off Net Type Hierarchies

Standard ON OFF NET TYPE Hierarchy:

Description of dim_on_off_nett.png follows
Description of the illustration dim_on_off_nett.png

On Off Net Type Levels

The following table shows ON OFF NET TYPE Total: All ON OFF NET TYPE is most aggregate level of the dimension.

Table for ON OFF NET TYPE Total

Sr. Number Attribute Description
1 ON OFF NET TYPE Total Code for All ON OFF NET TYPE Total.

Detail table shows ON OFF NET TYPE Detail: It captures information relating to On Off net Type.

Detail table ON OFF NET TYPE Detail

Sr. Number Attribute
1 LANGUAGE CODE
2 ON OFF NET TYPE DESC
3 ON OFF NET TYPE CODE
4 ON OFF NET TYPE NAME

Order Line Item State

Description: ORDER LINE ITEM STATE

Order Line Item State Hierarchies

Standard ORDER LINE ITEM STATE Hierarchy:

Description of dim_order_lis.png follows
Description of the illustration dim_order_lis.png

Order Line Item State Levels

The following table shows ORDER LINE ITEM STATE Total: All ORDER LINE ITEM STATE is most aggregate level of the dimension.

Table for ORDER LINE ITEM STATE Total

Sr. Number Attribute Description
1 ORDER LINE ITEM STATE Total Code for All ORDER LINE ITEM STATE Total.

Detail table shows ORDER LINE ITEM STATE TYPE Detail: It captures information relating to Order Line item State Type.

Detail table ORDER LINE ITEM STATE TYPE Detail

Sr. Number Attribute
1 ORDER LINE ITEM STATE TYPE DESC
2 ORDER LINE ITEM STATE TYPE NAME
3 ORDER LINE ITEM STATE TYPE CODE

Detail table shows ORDER LINE ITEM STATE Detail: It captures information relating to Order Line item State.

Detail table ORDER LINE ITEM STATE Detail

Sr. Number Attribute Description Sample Value
1 ORDER LINE ITEM STATE CODE A unique retailer assigned code denoting a potential state for a CustomerOrderLineItem. For example,: Deleted, Pending, PartialDelivery, DeliveryComplete, PartialPickup, PickupComplete and so on. Deleted, Pending, PartialDelivery, DeliveryComplete, PartialPickup, PickupComplete
2 ORDER LINE ITEM STATE DESC The description of the retailer assigned OrderLineItem state.  
3 ORDER LINE ITEM STATE NAME    
4 ORDER LINE ITEM STATE TYPE CODE    
5 STATUS CODE    
6 EFFECTIVE TO DATE    
7 EFFECTIVE FROM DATE    

Order State

Description: ORDER STATE

Order State Hierarchies

Standard ORDER STATE Hierarchy:

Description of dim_order_state.png follows
Description of the illustration dim_order_state.png

Order State Levels

The following table shows ORDER STATE Total: All ORDER STATE is most aggregate level of the dimension.

Table for ORDER STATE Total

Sr. Number Attribute Description
1 ORDER STATE Total Code for All ORDER STATE Total

Detail table shows ORDER STATE TYPE Detail: It captures information relating to Order State Type.

Detail table ORDER STATE TYPE Detail

Sr. Number Attribute
1 ORDER STATE TYPE DESC
2 ORDER STATE TYPE CODE
3 ORDER STATE TYPE NAME

Detail table shows ORDER STATE Detail: It captures information relating to Order State.

Detail Table ORDER STATE Detail

Sr. Number Attribute Description
1 ORDER STATE DESC The description of the Order State
2 ORDER STATE CODE The Unique identifier for Order State
3 ORDER STATE TYPE CODE  
4 ORDER STATE NAME  
5 EFFECTIVE TO DATE  
6 EFFECTIVE FROM DATE  
7 STATUS CODE  

Order Type

Description: ORDER TYPE

Order Type Hierarchies

Standard ORDER TYPE Hierarchy:

Description of dim_order_type.png follows
Description of the illustration dim_order_type.png

Order Type Levels

The following table shows ORDER TYPE Total: All ORDER TYPE is most aggregate level of the dimension.

Table for ORDER TYPE Total

Sr. Number Attribute Description
1 ORDER TYPE Total Code for All ORDER TYPE Total.

Detail table shows ORDER TYPE Detail: It captures information relating to Order Type.

Detail table ORDER TYPE Detail

Sr. Number Attribute Description
1 ORDER TYPE DESC Description of Customer order type
2 ORDER TYPE CODE Unique identifier for customer order type
3 ORDER TYPE NAME  
4 LANGUAGE CODE  

Organization

Description: ORGANIZATION HIERARCHY is the hierarchy of business units within the organization, with ORGANIZATION BUSINESS UNIT as lowest level and ORGANIZATION CORPORATE as highest level.

Organization Hierarchies

Standard Organization Hierarchy:

Banner Hierarchy

Description of image072.gif follows
Description of the illustration image072.gif

Company Hierarchy:

Description of image073.gif follows
Description of the illustration image073.gif

Division Hierarchy:

Description of image074.gif follows
Description of the illustration image074.gif

Organization Corporate Levels

Table 3-138 shows All Organization Total: All Organization Total are most aggregate level of dimension.

Table 3-138 All Organization Total

Sr. Number Attribute Description

1.

ORGANIZATION TOTAL Id's

Code for All Organization Total.


Table 3-139 shows Organization Corporate: Description level of the dimension. It stores the Organization Corporate information.

Table 3-139 Organization Corporate

Sr. Number Attribute Description Sample Value

1.

EFFECTIVE FROM DATE

Active from. Standard SCD field, Effective Start Date

12/31/2005 12:00:00 AM

2.

EFFECTIVE TO DATE

End effective date for the assignment.

12/31/2005 12:00:00 AM

3.

ORGANIZATION CORPORATE CODE

Code for Organization Corporate

 

4.

ORGANIZATION CORPORATE DESC

Description for Organization Corporate

 

5.

ORGANIZATION CORPORATE ESTABLISHED

   

6.

ORGANIZATION CORPORATE NAME

Name for Organization Corporate

 

7.

STATUS CODE

Current STATUS CODE of the assignment.

 

Organization Banner Levels

Table 3-140 shows Organization Banner Levels: The name of a company's 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.

Table 3-140 Organization Banner Levels

Sr. Number Attribute Description

1.

ALL ORGANIZATION BANNER ID's

Code for All Organization Banner.


Table 3-141 shows Organization Banner: Description level of the dimension. It stores the Organization Banner information.

Table 3-141 Organization Banner

Sr. Number Attribute Description Sample Value

1.

EFFECTIVE FROM DATE

Active from. Standard SCD field, Effective Start Date

12/31/2005 12:00:00 AM

2.

EFFECTIVE TO DATE

End effective date for the assignment.

12/31/2005 12:00:00 AM

3.

ORGANIZATION BANNER CODE

Code for Organization Banner

 

4.

ORGANIZATION BANNER DESC

Description for Organization Banner.

 

5.

ORGANIZATION BANNER NAME

Name for Organization Banner

 

6.

ORGANIZATION CORPORATE CODE

Code for Organization Corporate

 

7.

STATUS CODE

Current STATUS CODE of the assignment.

 

Organization Company Levels

Table 3-142 shows All Organization Company: All Organization Company are most aggregate level of Dimension.

Table 3-142 All Organization Company

Sr. Number Attribute Description

1.

ALL ORGANIZATION COMPANY ID's

Code for All Organization Company.


Table 3-143 shows Organization Company: Description level of the dimension. It stores the Organization Company information.

Table 3-143 Organization Company

Sr. Number Attribute Description Sample Value

1

EFFECTIVE FROM DATE

Active from. Standard SCD field, Effective Start Date

12/31/2005 0:00

2

ORGANIZATION COMPANY DESC

Description for Organization Company

 

3

ORGANIZATION COMPANY CODE

Code for Organization Company

 

4

EFFECTIVE TO DATE

End effective date for the assignment.

12/31/2005 12:00:00 AM

5

ORGANIZATION COMPANY NAME

Name for Organization Company

 

6

ORGANIZATION CORPORATE CODE

   

7

STATUS CODE

Current STATUS CODE of the assignment.

 

Organization Division Levels

Table 3-144 shows Organization Division Total: All Organization Division are most aggregate level of dimension.

Table 3-144 Organization Division Total

Sr. Number Attribute Description

1.

ALL ORGANIZATION DIVISION ID's

Code for All Organization Division.


Table 3-145 shows Organization Division: Description level of the dimension. It stores the Organization Division information.

Table 3-145 Organization Division

Sr. Number Attribute Description Sample Value

1.

ORGANIZATION DIVISION CODE

Code for Organization Division

Ace Comms

3.

ORGANIZATION CORPORATE CODE

Code for Organization Code

 

4.

EFFECTIVE FROM DATE

Active from. Standard SCD field, Effective Start Date

12/31/2005 12:00:00 AM

5.

ORGANIZATION DIVISION DESC

Description for Organization Division

Ace Comms

6.

ORGANIZATION DIVISION NAME

Name for Organization Division

Ace Comms

7.

STATUS CODE

Current STATUS CODE of the assignment.

 
 

EFFECTIVE TO DATE

   

Organization Chain: Organization Chain Levels

Table 3-146 shows Organization Chain Total: Chain is the second highest level within the organization hierarchy below company. A chain consists of one or more areas.

Table 3-146 Organization Chain Total

Sr. Number Attribute Description

1.

ALL ORGANIZATION CHAIN ID's

Code for All Organization Chain.


Table 3-147 shows Organization Chain Detail: Description level of the dimension. It stores the Organization Chain information

Table 3-147 Organization Chain Detail

Sr. Number Attribute Description

1.

ORGANIZATION CHAIN CODE

Code for Organization chain

2.

ORGANIZATION CHAIN DESC

Description for Organization Chain

3.

ORGANIZATION CHAIN NAME

Name for Organization Chain

4.

EFFECTIVE FROM DATE

Description for Organization Chain

5.

EFFECTIVE TO DATE

End effective date for the assignment.

6.

ORGANIZATION COMPANY CODE

Code for Organization Company

7.

STATUS CODE

Current STATUS CODE of the assignment.


Organization Area

Table 3-148 shows Organization Area Total: Organization hierarchy level within an organization chain and is the parent of one or more organization regions.

Table 3-148 Organization Area Total

Sr. Number Attribute Description

1.

ALL ORGANIZATION AREA ID's

Code for All Organization Area.


Table 3-149 shows Organization Area Detail: Description level of the dimension. It stores the Organization Area information.

Table 3-149 Organization Area Detail

Sr. Number Attribute Description Sample Value

1.

EFFECTIVE FROM DATE

Active from. Standard SCD field, Effective Start Date

12/31/2005 12:00:00 AM

2.

EFFECTIVE TO DATE

End effective date for the assignment.

12/31/2005 12:00:00 AM

3.

ORGANIZATION AREA CODE

Code for Organization area

 

4.

ORGANIZATION AREA DESC

Description for Organization Area

 

5.

ORGANIZATION AREA NAME

Name for Organization Area

 

6.

ORGANIZATION CHAIN CODE

Code for Organization Chain

 

7.

STATUS CODE

Current STATUS CODE of the assignment.

 

Organization Region Levels

Table 3-150 shows All Organization Regions: Region is the fourth highest attribute within the organization hierarchy, below area. A region consists of one or more districts

Table 3-150 All Organization Regions

Sr. Number Attribute Description

1.

ALL ORGANIZATION REGION ID's

Code for All Organization Region.


Table 3-151 shows Organization Region: Description level of the dimension. It stores the Organization Region information.

Table 3-151 Organization Region

Sr. Number Attribute Description Sample Value

1.

EFFECTIVE FROM DATE

Active from. Standard SCD field, Effective Start Date

12/31/2005 12:00:00 AM

2.

EFFECTIVE TO DATE

End effective date for the assignment.

12/31/2005 12:00:00 AM

3.

ORGANIZATION AREA CODE

Code for Organization area.

 

4.

ORGANIZATION REGION CODE

Code for Organization region

 

5.

ORGANIZATION REGION DESC

Description for Organization region

 

6.

ORGANIZATION REGION NAME

Name for Organization Region

 

7.

STATUS CODE

Current STATUS CODE of the assignment.

 

Organization District Levels

Table 3-152 shows All Organization District: District is the fifth highest attribute within the organization hierarchy, below region. A district consists of one or more business units.

Table 3-152 All Organization District

Sr. Number Attribute Description

1.

ALL ORGANIZATION DISTRICT ID's

Code for All Organization District.


Table 3-153 shows Organization District: Description level of the dimension. It stores the Organization District information.

Table 3-153 Organization District

Sr. Number Attribute Description Sample Value

1.

ORGANIZATION DISTRICT CODE

Code for Organization District

12/31/2005 12:00:00 AM

2.

EFFECTIVE TO DATE

End effective date for the assignment.

12/31/2005 12:00:00 AM

3.

EFFECTIVE FROM DATE

Active from. Standard SCD field, Effective Start Date

 

4.

ORGANIZATION DISTRICT DESC

Description for Organization District

 

5.

ORGANIZATION DISTRICT NAME

Name for Organization District

 

6.

ORGANIZATION REGION CODE

Code for Organization Region.

 

7.

STATUS CODE

Current STATUS CODE of the assignment.

 

Organization Business Unit

Organization business unit contains 2 kinds of information -store and branch company. In the higher level is branch company. Some customer cannot belong to a particular store, in that case, they are associated with a branch company. So branch company are put in organization business unit level. A business unit of the organization that sells, stores, or distributes merchandises and services through either a physical location (store), catalog, web page or other channel, distribution center, or warehouse.

Table 3-154 shows All Organization Business Unit: It is the lowest level of Organization.

Table 3-154 All Organization Business Unit

Sr. Number Attribute Description

1.

ALL ORGANIZATION BUSINESS UNIT ID's

Code for All Organization Business Unit.


Table 3-155 shows Organization Business Unit: Description level of the dimension. It stores the Organization Business Unit information.

Table 3-155 Organization Business Unit

Sr. Number Attribute Description

1

ADDRESS LINE 1

Address. Line one of detailed postal address

2

ADDRESS LINE 2

Address. Line 2 of the detailed postal address

3

ADDRESS LINE 3

Address. Line 3 of the detailed postal address

4

ADDRESS LOCATION CODE

unique identifier for the address Location

5

ADDRESS TYPE CODE

Unique identifier of the address type.

6

ADDRESS USAGE

Describes how the address is used

7

ANNUAL REVENUE

Revenue of the company.

8

ANNUAL REVENUE LOCAL

Revenue of the company.

9

ANNUAL REVENUE REPORTING

Revenue of the company.

10

ANNUAL SALES

Sales of the company

11

ANNUAL SALES LOCAL

Sales of the company

12

ANNUAL SALES REPORTING

Sales of the company

13

BANKRUPTCY END DATE

The end date of bankruptcy. If current date is behind start and end date is null, then the company is undergoing the bankruptcy process.

14

BANKRUPTCY START DATE

start date of bankruptcy.

15

BUSINESS ENTITY CODE

Business Entity Identifier. Unique Identifier for Business Entity.

For example: SPRINT

16

BUSINESS UNIT CONCEPT

"Possible values include, Convenience, General Merchandise, Category dominant anchors with few small tenants, Fashion, Higher-end (Upscale), Fashion oriented, Manufacturer's Outlet, Leisure, Tourist oriented and Discount."

18

BUSINESS UNIT TYPE CODE

Unique identifier of the business unit type

19

CHAIRMAN CODE

Connect to Another Person Party who is responsible for this Organization.

20

CHANNEL TYPE CODE

Unique identifier of the channel type

21

COMPANY REGISTRY NUMBER

Will be same as Party. National_Identifier. Natural Key for Organization.

45

ACCOUNT CLERK CODE

This field is client specific. The definition and use of this field is customizable for each client

46

MANAGER EMPLOYEE NUMBER

Unique key denoting the employee number of the employee's manager.

47

MANAGER NAME

Name of manager for the whole company.

48

ORGANIZATION BANNER CODE

Unique identifier for Organization Banner

49

ORGANIZATION BUSINESS UNIT CODE

Unique identifier for Business Unit. To identify whether the site is a store, distribution center or warehouse.

For example: SPRINT1

50

ORGANIZATION BUSINESS UNIT TYPE CODE

Unique identifier for Organization Business Unit Type

51

ORGANIZATION CODE

The unique identifier of the organization.

For example: ORGUNIT1

52

ORGANIZATION DISTRICT CODE

Unique identifier for Organization district

53

ORGANIZATION DIVISION CODE

Unique identifier for division.

For example: China Mobile Beijing

54

ORGANIZATION NAME

Name of the organization

55

ORGANIZATIONAL DEMOGRAPHY VALUE CODE

Unique identifier for demography

56

PAYMENT ACCOUNT CLOSE DATE

Closing date of the account for payments.

For example: 12/31/2005 12:00:00 AM

57

PAYMENT ACCOUNT NUMBER

Account number for payments.

58

PAYMENT ACCOUNT OPEN DATE

Opening date of the account for payments.

For example: 12/31/2005 12:00:00 AM

59

POSTAL PLUS CODE

Four digit extension to the United States Postal ZIP code.

60

POSTCODE

Postal codes of interest to the Retail Organization

61

PRIMARY ADDRESS TELEPHONE

Default Address Telephone Number

62

PRIMARY BUSINESS UNIT CALENDAR CODE

Primary Business Unit Calendar Code

63

PRIMARY CURRENCY ISO CODE

The unique ISO standard identifier of the CURRENCY

64

PRIMARY EMAIL ADDRESS

Default Email Address

65

PRIMARY TRADE AREA CODE

Primary Trade area code, under which the business unit falls

66

SEAL IMAGE

The image of the Organization's Seal, or the Artificial Person's Signature.

67

SECONDARY DESCRIPTION

"The secondary description or name of the store or warehouse."

68

SHOPPING CENTER TYPE

Shopping center is group of retail and other commercial establishments that is planned, developed, owned, and managed as a single property.

Strip Center (Neighborhood, Community)- Mall (Power, Super Regional, Regional, Fashion/Specialty, Lifestyle, Outlet, Theme/Festival)".

70

SHORT DESCRIPTION

The 3 character abbreviation of the store name.

71

STOCK EXCHANGE NAME

Abbreviation of listed companies as used on the stock exchange.

72

TAX EXEMPT STATUS

Indicates if the org. is tax exempt.

73

TERMINATION DATE

Termination date of the company in case of company was founded with termination date.

For example: 12/31/2005 12:00:00 AM

74

TIME ZONE

It denotes which TimeZone the Site is in.

75

TOTAL LINEAR DISTANCE

The total linear selling space of the location.

76

VALIDATION END DATE

Effective date of the deletion of the company's record from the company register.

For example: 12/31/2005 12:00:00 AM

77

VALIDATION START DATE

Date of the registration of the company' record deletion from the company register.

For example: 12/31/2005 12:00:00 AM

78

VAT INCLUDE INDICATOR

Indicates whether the Value Added Tax will be included in the retail prices for the store. Valid values are 'Y' or 'N'."

80

VAT REGION

"The number of the Value Added Tax region in which this store or warehouse is contained."

 

PARTY CODE

 
 

PARTY TYPE CODE

 
 

BUSINESS LEGAL STATUS CODE

 
 

SOURCE SYSTEM CODE

 
 

BARING REASON CODE

 
 

STATUS CODE

 
 

CITY

 
 

STATE

 
 

COUNTRY

 
 

PARTY NAME

 
 

PARTY DESC

 
 

LOCATION TYPE CODE

 
 

CONTACT TYPE CODE

 
 

ADDRESS

 
 

PRIMARY MARKET AREA CODE

 
 

ACTIVE INDICATOR

 
 

CUSTOMER INDICATOR

 
 

JUDICIAL DISTRAINT CODE

 
 

CONTACT CODE

 
 

COURT CODE

 
 

MANAGER CODE

 
 

DUNS NUMBER

 
 

CONTACT NUMBER

 
 

LONG DESCRIPTION

 
 

CONSTRUCTION STATUS

 
 

CONTACT NAME

 
 

EXTERNAL NAME

 
 

EMPLOYEE COUNT

 
 

EQUITY AMOUNT

 
 

EQUITY AMOUNT LOCAL

 
 

EQUITY AMOUNT REPORTING

 
 

LIQUIDATION START DATE

 
 

LIQUIDATION END DATE

 
 

DOMESTIC INDICATOR

 
 

FINAL SETTLEMENT START DATE

 
 

FINAL SETTLEMENT END DATE

 
 

JUDICIAL DISTRAINT DATE

 
 

EFFECTIVE FROM DATE

 
 

EFFECTIVE TO DATE

 

Packet Control Unit Outage Reason

Description: PACKET CONTROL UNIT OUTAGE REASON

Packet Control Unit Outage Reason Hierarchies

Standard PACKET CONTROL UNIT OUTAGE REASON Hierarchy:

Description of dim_packet_control_uor.png follows
Description of the illustration dim_packet_control_uor.png

Packet Control Unit Outage Reason Levels

The following table shows PACKET CONTROL UNIT OUTAGE REASON Total: All PACKET CONTROL UNIT OUTAGE REASON is most aggregate level of the dimension.

Table for PACKET CONTROL UNIT OUTAGE REASON Total

Sr. Number Attribute Description
1 PACKET CONTROL UNIT OUTAGE REASON Total Code for All PACKET CONTROL UNIT OUTAGE REASON Total.

Detail table shows PACKET CONTROL UNIT OUTAGE REASON Detail: It captures information relating to Packet Control Unit Outage Reason.

Detail table PACKET CONTROL UNIT OUTAGE REASON Detail

Sr. Number Attribute
1 PCU OUTAGE REASON CODE
2 PCU OUTAGE REASON DESC
3 LANGUAGE CODE
4 PCU OUTAGE REASON NAME

Partner Settlement Reason

Description: PARTNER SETTLEMENT REASON

Partner Settlement Reason Hierarchies

Standard Partner Settlement Reason Hierarchy:

Description of image075.gif follows
Description of the illustration image075.gif

Partner Settlement Reason Levels

Table 3-156 shows Partner Settlement Reason Total: All Partner Settlement Reason are most aggregate level of dimension.

Table 3-156 Partner Settlement Reason Total

Sr. Number Attribute Description

1.

ALL PARTNER SETTLEMENT REASON CODE

Code for All Partner Settlement Reason.


Table 3-157 shows Partner Settlement Reason Detail: Detail level of the dimension. It stores the Partner Settlement Reason information.

Table 3-157 Partner Settlement Reason Detail

Sr. Number Attribute Description

1.

LANGUAGE CODE

Unique identifier for Language

2.

PARTNER SETTLEMENT REASON CODE

Unique identifier for Partner Settlement

3.

PARTNER SETTLEMENT REASON NAME

Name of the Partner Settlement

4.

PARTNER SETTLEMENT REASON DESC

Description for the Partner Settlement


Party

Description: PARTY

Party Hierarchies

Standard Party Hierarchy:

Description of image076.gif follows
Description of the illustration image076.gif

Party Levels

Table 3-158 shows Party Total: All Party is most aggregate level of dimension.

Table 3-158 Party Total

Sr. Number Attribute Description

1.

ALL PARTY CODE

Code for All Party.


Table 3-159 shows Party Detail: Detail level of the dimension. It stores the Party information.

Table 3-159 Party Detail

Sr. Number Attribute Description Sample Value

1.

ACTIVE INDICATOR

Indicates if the party is currently active - which means the party has a current relationship with the carrier.

Y

2.

ADDRESS

Address of the party. Redundance to party location history.

 

3.

BARING REASON CODE

Reasons for barring. For example, 1-Credit Limit, 2-Barring period.

 

4.

BUSINESS LEGAL STATUS CODE

A unique identifier for a legal classification of a non-residential Customer.

 

5.

CITY

City of the party. Redundance to party location history.

 

6.

COUNTRY

Country of the party. Redundance to party location history.

 

7.

CUSTOMER INDICATOR

Indicates if the party is a customer. Note: the party may have multiple relationships simultaneously - this flag identifies those parties which has a current account with the Telecommunications.

 

8.

EFFECTIVE FROM DATE

EFFECTIVE FROM DATE, standard SCD2 column

12/31/2005 12:00:00 AM

9.

EFFECTIVE TO DATE

EFFECTIVE TO DATE, standard SCD2 column

12/31/2005 12:00:00 AM

10.

PARTY CODE

A code for any person or business that is of interest to the Communications Service Provider.

PRTY-50001

11.

PARTY DESC

Description of the party. Applicable to both individual and organization. Normally it refer to the full name.

Sprint

12.

PARTY NAME

Name of the party. Applicable to both individual and organization. Normally it refer to the full name.

Sprint

13.

PARTY TYPE CODE

Party Type Code

ORGUNIT

14.

POST CODE

Postcode of the party. Redundance to party location history.

 

15.

SOURCE SYSTEM CODE

SOURCE SYSTEM ID, from which source ERP system this recorded was extracted.

 

16.

STATE

State of the party. Redundance to party location history.

 

17.

STATUS CODE

Current status of party.

 

Payment Channel

Description: PAYMENT CHANNEL.

Payment Channel Hierarchies

Standard Payment Channel Hierarchy:

Description of image077.gif follows
Description of the illustration image077.gif

Payment Channel Levels

Table 3-160 shows Payment Channel Total: All Payment Channel are most aggregate level of dimension.

Table 3-160 Payment Channel Total

Sr. Number Attribute Description

1.

PAYMENT CHANNEL TOTAL ID's

Code for All Payment Channel.


Table 3-161 shows Payment Channel Detail: Detail level of the dimension. It stores the Payment Channel Detail information.

Table 3-161 Payment Channel Detail

Sr. Number Attribute Description Sample Value

1.

CAPACITY QUANTITY

The number of transaction that a Channel can handle, at a point of time.

$1.00

2.

CHANNEL CODE

The unique identifier for each Channel. A Channel identifies each possible link where interaction between the Communications Service Provider and the Customer occurs.

 

3.

PARTY CODE

A code for any person or business that is of interest to the Communications Service Provider.

 

4.

PAYMENT CHANNEL CODE

The unique identifier for each Channel. A Channel identifies each possible link where interaction between the Communications Service Provider and the Customer occurs.

 

5.

CHANNEL NAME

The name assigned to a channel.

PAY

6.

CHANNEL TYPE CODE

Unique identifier of the channel type

PAY

 

PARTY TYPE CODE

   
 

CHANNEL DESC

   
 

EFFECTIVE FROM DATE

   
 

EFFECTIVE TO DATE

   
 

STATUS CODE

   

Payment Method Type

Description: PAYMENT METHOD TYPE

Payment Method Type Hierarchies

Standard Payment Method Type Hierarchy:

Description of image078.gif follows
Description of the illustration image078.gif

Payment Method Type Levels

Table 3-162 shows Payment Method Type Total: All Payment Method Types are most aggregate level of dimension.

Table 3-162 Payment Method Type Total

Sr. Number Attribute Description

1.

PAYMENT METHOD TYPE TOTAL ID's

Code for All Payment Method Types.


Table 3-163 shows Payment Method Type Detail: Detail level of the dimension. It stores the Payment Method Type Detail information.

Table 3-163 Payment Method Type Detail

Sr. Number Attribute Description Sample Value

1.

LANGUAGE CODE

Language ID---Unique identifier for a row in the Language dimension.

 

2.

PAYMENT METHOD TYPE CODE

Code for All Payment Methods Types

BNK

3.

PAYMENT METHOD TYPE DESC

Payment Method Type Description.

Bank

4.

PAYMENT METHOD TYPE NAME

Payment Method Type Name.

Bank


Payment Transaction Type

Description: PAYMENT TRANSACTION TYPE

Payment Transaction Type Hierarchies

Standard Payment Transaction Type Hierarchy:

Description of image079.gif follows
Description of the illustration image079.gif

Payment Transaction Type Levels

Table 3-164 shows Payment Transaction Type Total: All Payment Transaction Type are most aggregate level of dimension.

Table 3-164 Payment Transaction Type Total

Sr. Number Attribute Description

1.

PAYMENT TRANSACTION TYPE TOTAL CODE

Code for All Payment Transaction Type.


Table 3-165 shows Payment Transaction Type Detail: Detail level of the dimension. It stores the Payment Transaction Type Detail information.

Table 3-165 Payment Transaction Type Detail

Sr. Number Attribute Description Sample Value

1.

LANGUAGE CODE

Language ID---Unique identifier for a row in the Language dimension.

 

2.

PAYMENT TRANSACTION TYPE CODE

Code for payment transaction type.

CRDT

3.

PAYMENT TRANSACTION TYPE DESC

Description for payment transaction type.

Credit

4.

PAYMENT TRANSACTION TYPE NAME

Name of payment transaction type.

credit


PCU Outage Reason

Description: PACKET CONTROL UNIT OUTAGE REASON

PCU Outage Reason Hierarchies

Standard PCU Outage Reason Hierarchy:

Description of image080.gif follows
Description of the illustration image080.gif

PCU Outage Reason Levels

Table 3-166 shows PCU Outage Reason Total: All PCU Outage Reason are most aggregate level of dimension.

Table 3-166 PCU Outage Reason Total

Sr. Number Attribute Description

1.

PCU OUTAGE REASON TOTAL CODE

Code for All PCU Outage Reason.


Table 3-167 shows PCU Outage Reason Detail: Detail level of the dimension. It stores the PCU Outage Reason Detail information.

Table 3-167 PCU Outage Reason Detail

Sr. Number Attribute Description

1.

LANGUAGE CODE

Language ID---Unique identifier for a row in the Language dimension.

2.

PCU OUTAGE REASON CODE

Code for PCU outage reason.

3.

PCU OUTAGE REASON DESC

Description for PCU outage reason.

4.

PCU OUTAGE REASON NAME

Name of PCU outage reason.


Peak Offpeak Time

Description: PEAK OFFPEAK TIME

Peak Offpeak Time Hierarchies

Standard Peak Offpeak Time Hierarchy:

Description of image081.gif follows
Description of the illustration image081.gif

Peak Offpeak Time Levels

Table 3-168 shows Peak Offpeak Time Total: All Peak Offpeak Time is most aggregate level of dimension.

Table 3-168 Peak Offpeak Time Total

Sr. Number Attribute Description

1.

PEAK OFFPEAK TIME TOTAL Id's

Code for All Peak Offpeak Time.


Table 3-169 shows Peak Offpeak Time Detail: Detail level of the dimension. It stores the Peak Offpeak Time Detail information.

Table 3-169 Peak Offpeak Time Detail

Sr. Number Attribute Description Sample Value

1.

HOLIDAY INDICATOR

Indicates if the time band applies on designated public holidays.

N

2.

PEAK OFFPEAK END

This is to express start and end date for all days, therefore it use varchar2 rather than date data type.

4/1/2008 5:00:00 PM

3.

PEAK OFFPEAK START

This is to express start and end date for all days, therefore it use varchar2 rather than date data type.

4/1/2008 5:00:00 PM

4.

PEAK OFFPEAK TIME CODE

Indicates if this time is busy hour.

PK

5.

PEAK OFFPEAK TIME DESC

Peak Off peak Time Description

 

6.

PEAK OFFPEAK TIMENAME

Peak Off peak Time name

Peak Time

7.

WEEKDAY INDICATOR

Indicates if the time band applies on week days (Monday through Friday).

Y

8.

WEEKEND INDICATOR

Indicates if the time band applies on weekends (Saturday and Sunday).

Y

 

LANGUAGE CODE

   

PPA Category

Description: PPA CATEGORY

PPA Category Hierarchies

Standard PPA Category Hierarchy:

Description of image082.gif follows
Description of the illustration image082.gif

PPA Category Levels

Table 3-170 shows PPA Category Total: Most Aggregate level of the dimension.

Table 3-170 PPA Category Total

Sr. Number Attribute Description

1.

PPA CATEGORY TOTAL ID

Code for All PPA Categories


Table 3-171 shows PPA Category Detail: level of the dimension, stores PPA Category information.

Table 3-171 PPA Category Detail

Sr. Number Attribute Description Sample Value

1.

PPA CATEGORY CD

PPA Category code

FLANSWER

2.

LANGUAGE CODE

Language Code

 

3.

PPA CATEGORY NAME

PPA Category Short Description

Free Local Answer

4.

PPA CATEGORY DESCRIPTION

PPA Category Description

free local answer


Product

Description: PRODUCT SPECIFICATION

Product Hierarchies

Standard Product Hierarchy:

Description of image083.gif follows
Description of the illustration image083.gif

Product Levels

Table 3-172 shows Product Total: This is the most aggregate level of the product dimension and hence represents the summation for all products including prepaid and post paid products/packages in the company.

Table 3-172 Product Total

Sr. Number Attribute Description

1.

All PRODUCTS ID

Identification for the top level value


Table 3-173 shows Product Type: The level classifies products into two main categories, that is, Prepaid and Postpaid products.

Table 3-173 Product Type

Sr. Number Attribute Description Sample Value

1.

PRODUCT TYPE CD

Product Type Code

BB

2.

PRODUCT TYPE DESCRIPTION

Product Type Description

Broad Band

 

PRODUCT TYPE NAME

   
 

PRODUCT TYPE DESC

   
 

EFFECTIVE FROM DATE

   
 

EFFECTIVE TO DATE

   
 

STATUS CODE

   

Product Specification Type

Description: PRODUCT SPECIFICATION TYPE

Product Specification Type Hierarchies

Standard PRODUCT SPECIFICATION TYPE Hierarchy:

Description of dim_product_spec_type.png follows
Description of the illustration dim_product_spec_type.png

Product Specification Type Levels

The following table shows PRODUCT SPECIFICATION TYPE Total: All PRODUCT SPECIFICATION TYPE is most aggregate level of the dimension.

Table for PRODUCT SPECIFICATION TYPE Total

Sr. Number Attribute Description
1 PRODUCT SPECIFICATION TYPE Total Code for All PRODUCT SPECIFICATION TYPE Total.

Detail table shows PRODUCT SPECIFICATION TYPE Detail: It captures information relating to Product Specification Type.

Detail table PRODUCT SPECIFICATION TYPE Detail

Sr. Number Attribute Description
1 PRODUCT SPECIFICATION TYPE CODE Code
2 PRODUCT SPECIFICATION TYPE DESC FULL DESC<>
3 PRODUCT SPECIFICATION TYPE NAME The Title.
4 STATUS CODE  
5 EFFECTIVE TO DATE  
6 EFFECTIVE FROM DATE  

Product Subscription Status

Description: PRODUCT SUBSCRIPTION STATUS

Product Subscription Status Hierarchies

Standard PRODUCT SUBSCRIPTION STATUS Hierarchy:

Description of dim_product_sub_stat.png follows
Description of the illustration dim_product_sub_stat.png

Product Subscription Status Levels

The following table shows PRODUCT SUBSCRIPTION STATUS Total: All PRODUCT SUBSCRIPTION STATUS is most aggregate level of the dimension.

Table for PRODUCT SUBSCRIPTION STATUS Total

Sr. Number Attribute Description
1 PRODUCT SUBSCRIPTION STATUS Total Code for All PRODUCT SUBSCRIPTION STATUS Total.

Detail table shows PRODUCT SUBSCRIPTION STATUS Detail: It captures information relating to Product Subscription Status.

Detail table PRODUCT SUBSCRIPTION STATUS Detail

Sr. Number Attribute Description Sample Value
1 PRODUCT SUBSCRIPTION STATUS CODE A code used to uniquely identify the classifications for a Subscription. Examples: A - Active, I - Inactive, P - Prospective. A - Active,

I - Inactive, P - Prospective

2 PRODUCT SUBSCRIPTION STATUS DESC A textual description for a Subscription Status Type.  
3 PRODUCT SUBSCRIPTION STATUS NAME The name assigned to a Subscription Status Type.

Examples: Active, Inactive, Prospective.

Active, Inactive, Prospective
4 PRODUCT SUBSCRIPTION STATUS CATEGORY CODE    
5 LANGUAGE CODE    

Product Subscription Type

Description: PRODUCT SUBSCRIPTION TYPE

Product Subscription Type Hierarchies

Standard PRODUCT SUBSCRIPTION TYPE Hierarchy:

Description of dim_product_sub_type.png follows
Description of the illustration dim_product_sub_type.png

Product Subscription Type Levels

The following table shows PRODUCT SUBSCRIPTION TYPE Total: All PRODUCT SUBSCRIPTION TYPE is most aggregate level of the dimension.

Table for PRODUCT SUBSCRIPTION TYPE Total

Sr. Number Attribute Description
1 PRODUCT SUBSCRIPTION TYPE Total Code for All PRODUCT SUBSCRIPTION TYPE Total.

Detail table shows PRODUCT SUBSCRIPTION TYPE Detail: It captures information relating to Product Subscription Type.

Detail table PRODUCT SUBSCRIPTION TYPE Detail

Sr. Number Attribute Description
1 PRODUCT SUBSCRIPTION TYPE CATEGORY CODE Category or classification of the subscription type. Can be used for grouping subscription types for analysis or reporting.
2 PRODUCT SUBSCRIPTION TYPE CODE Identifier of the subscription type.
3 PRODUCT SUBSCRIPTION TYPE NAME Name or description of the subscription type.
4 PRODUCT SUBSCRIPTION TYPE DESC Name or description of the subscription type.
5 LANGUAGE CODE  

Promotion

Description: PROMOTION

Promotion Hierarchies

Standard Promotion Hierarchy:

Description of image084.gif follows
Description of the illustration image084.gif

Promotion Levels

Table 3-174 shows Campaign: A campaign is a concentrated effort to enhance the image of the enterprise, to retain, acquire, or consolidate customers.

Table 3-174 Campaign

Sr. Number Attribute Description Sample Value

1

CAMPAIGN CODE

Unique Identifier for Campaign

CMPGN-1

2

CAMPAIGN DESC

A textual description of the Campaign.

 

3

CAMPAIGN NAME

Short Name of the Campaign

 

4

CAMPAIGN PURPOSE

Campaign purpose. The purpose of the campaign being conducted, in most of scenarios this field would be empty since this would be addressed in the Theme and Promotion Theme. But when this campaign is being executed as a continuation of a previous campaign due to demand, this field would contain the reason for that continuation.

ACQUIRE

5

CAMPAIGN PURPOSE TYPE CODE

Unique Identifier for a Campaign purpose type

 

6

CAMPAIGN STATUS CODE

A code used to uniquely identify strategy of a Campaign.

CSTAT

7

CAMPAIGN TYPE CODE

Unique Identifier for a Campaign type.

MMPRMTN

8

COST AMOUNT

The monetary cost of a Campaign.

 

9

COST AMOUNT LOCAL

The monetary cost of a Campaign.

 

10

COST AMOUNT REPORTING

The monetary cost of a Campaign.

 

11

COST CODE

Identify the cost to the Carrier.

 

12

EFFECTIVE FROM DATE

The start date of a Campaign.

12/31/2005 12:00:00 AM

13

EFFECTIVE TO DATE

The end date of a Campaign.

12/31/2005 12:00:00 AM

14

FUND SOURCE CODE

Campaign fund source type. Possible values would include, Vendor Sponsored, Charity and so on.

 

15

GLOBAL IND

Flag to indicate if the campaign is run globally. Flag to indicate if the campaign is run globally.

 

16

PARTNER IND

Indicates if the campaign has partners. Indicates if the campaign has partners

 

17

PARTNER NUMBER

Identification number for partner.

 

18

PLANNED COST

Planned or budgeted total cost for the campaign.

 

19

PLANNED COST LOCAL

Planned or budgeted total cost for the campaign.

 

20

PLANNED COST REPORTING

Planned or budgeted total cost for the campaign.

 

21

PLANNED RESPONSE

Expected or planned response for the campaign.

 

22

PRIORITY

Campaign priority. Campaign priority

 

Table 3-175 shows Campaign Type:

Table 3-175 Campaign Type

Sr. Number Attribute Description Sample Value
 

CAMPAIGN TYPE CODE

A code used to uniquely identify a CAMPAIGN TYPE.

TGPRMTN

 

CAMPAIGN TYPE DESC

A textual description of a CAMPAIGN TYPE.

A Targeted Promotion

 

CAMPAIGN TYPE NAME

The name assigned to a CAMPAIGN TYPE.

Targeted Promotion

 

LANGUAGE CODE

Unique identifier for a row in the Language dimension.

 

Table 3-176 shows Promotion Type: The type of a promotion, like direct marketing by Phone call, direct marketing by mail, Media Broadcast by TV, and so on.

Table 3-176 Promotion Type

Sr. Number Attribute Description Sample Value

1

PROMOTION TYPE CODE

A code used to uniquely identify a PROMOTION TYPE.

MAIL

2

PROMOTION TYPE DESC

A textual description of a PROMOTION TYPE.

Promotion by Mail

3

PROMOTION TYPE NAME

The name assigned to a PROMOTION TYPE.

Mail

4

LANGUAGE CODE

Unique identifier for a row in the Language dimension.

 

Table 3-177 shows Promotion Type: This entity keeps types of Campaigns. Examples include: 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.

Table 3-177 Promotion

Sr. Number Attribute Description Sample Value

1

PROMOTION CODE

A unique identifier for a campaign cell.

PRMTN-1

2

PROMOTION DESC

A textual description for a campaign Cell.

PRMTN-1

3

PROMOTION NAME

Name of Promotion

PRMTN-1

4

ACTUAL RESPONSE COUNT

Actual RESPONSE COUNT.

 

5

ACTUAL SALES AMOUNT

ACTUAL SALES AMOUNT.

 

6

ACTUAL SALES AMOUNT LOCAL

ACTUAL SALES AMOUNT.

 

7

ACTUAL SALES AMOUNT REPORTING

ACTUAL SALES AMOUNT.

 

8

ACTUAL SALES COUNT

ACTUAL SALES COUNT.

 

9

ACTUAL TOTAL COST

ACTUAL TOTAL COST.

 

10

ACTUAL TOTAL COST LOCAL

ACTUAL TOTAL COST.

 

11

ACTUAL TOTAL COST REPORTING

ACTUAL TOTAL COST.

 

12

CAMPAIGN CHANNEL CODE

A unique identifier for a campaign channel.

 

13

CAMPAIGN CODE

The campaign which this cost occurs in

CMPGN-1

14

GLOBAL IND

Flag to indicate if the campaign is run globally.

 

15

PARTICIPANT TARGET NUMBER

The number of target customers within a PROMOTION.

113

16

PARTNER NUMBER

Unique number assigned to the Partner

 

17

PERSON RESPONSIBLE

Name of the employee who is responsible for the promotion

 

18

PLANNED RESPONSE COUNT

Number of positive responses expected on the full promotion time.

 

19

PLANNED SALES AMOUNT

Planned sales amount.

 

20

PLANNED SALES AMOUNT LOCAL

Planned sales amount local.

 

21

PLANNED SALES AMOUNT REPORTING

Planned sales amount reporting.

 

22

PLANNED SALES COUNT

Planned sales count

 

23

PLANNED TOTAL COST

Planned or budgeted total cost for the promotion.

$200.00

24

PLANNED TOTAL COST LOCAL

Planned or budgeted total cost for the promotion.

$200.00

25

PLANNED TOTAL COST REPORTING

Planned or budgeted total cost reporting for the promotion.

$200.00

26

PROMOTION END DATE

Promotion end date.

12/31/2005 12:00:00 AM

27

PROMOTION PURPOSE

Captures the purpose of the promotion.

 

28

PROMOTION START DATE

PROMOTION START DATE.

12/31/2005 12:00:00 AM

29

PROMOTION TYPE CODE

A code used to uniquely identify a PROMOTION TYPE.

MAIL

30

TARGET TYPE CODE

A code used to uniquely identify a Categorization for each Target occurrence. Examples include: C = Customer A = Account AM = Access Method M = Market.

ACCS

31

THEME

Promotion theme

 

32

VERSION NUMBER

Version Number of the campaign. A campaign can have many versions before it goes active

 

Promotion Result Type

Description: PROMOTION RESULT TYPE

Promotion Result Hierarchies

Standard Promotion Result Type Hierarchy:

Description of image085.gif follows
Description of the illustration image085.gif

Promotion Result Type Levels

Table 3-178 shows Promotion Result Type Total: Top level for the dimension with one single value indicating value for all promotion result type.

Table 3-178 Promotion Result Type Total

Sr. Number Attribute Description

1.

PROMOTION RESULT TYPE TOTAL ID

Code for All Promotion Result Type


Table 3-179 shows Promotion Result Type Detail: Contain actual sales campaign result type values. Data for the sales campaign results will have these values. Like Offer accepted, Attribution prevented

Table 3-179 Promotion Result Type Detail

Sr. Number Attribute Description Sample Value

1

PROMOTION RESULT CTGRY CODE

Code for Sales Campaign result category.

 

2

PROMOTION RESULT CTGRY DESC

Code for Sales Campaign result category.

 

3

PROMOTION RESULT CTGRY NAME

Description of the Sales Campaign result category.

 

4

PROMOTION RESULT TYPE CODE

Name of the Sales Campaign result.

ATRPRVNT

5

PROMOTION RESULT TYPE DESC

Code for Sales Campaign Result.

Attribution Prevented

6

PROMOTION RESULT TYPE NAME

Description of the Sales Campaign result

Attribution Prevented

7

LANGUAGE CODE

Unique identifier for a row in the Language dimension.

 

Quarter Hour

Description: QUARTER HOUR

Quarter Hour Hierarchies

Standard QUARTER HOUR Hierarchy:

Description of dim_quarter_hour.png follows
Description of the illustration dim_quarter_hour.png

Quarter Hour Levels

The following table shows QUARTER HOUR Total: All QUARTER HOUR is most aggregate level of the dimension.

Table for QUARTER HOUR Total

Sr. Number Attribute Description
1 QUARTER HOUR Total Code for All QUARTER HOUR Total.

Detail table shows QUARTER HOUR Detail: It captures information relating to Quarter Hour.

Detail table QUARTER HOUR Detail

Sr. Number Attribute Description
1 QUARTER HOUR DESC Description of the time of the day, the quarter represents.
2 QUARTER HOUR NUMBER Quarter Hour value in the 24 hour clock. It is made up of the hour warehouse key, followed by 1 - 4 depending on the quarter hour. For example: 051 represents 5th hour 1st quarter hour.
3 HALF HOUR CODE1 Unique warehouse key of the half hour on a 24 hour clock on a particular day.
4 QUARTER HOUR CODE Unique warehouse key of the Quarter Hour in a 24-hour clock on a particular day

Reason

Description: REASON

Reason Hierarchies

Standard REASON Hierarchy:

Description of dim_reason.png follows
Description of the illustration dim_reason.png

Reason Levels

The following table shows REASON Total: All REASON is most aggregate level of the dimension.

Table for REASON Total

Sr. Number Attribute Description
1 REASON Total Code for All Reason Total.

Detail table shows REASON Detail: It captures information relating to Reason.

Detail table REASON Detail

Sr. Number Attribute
1 REASON CODE
2 REASON CATEGORY CODE
3 REASON NAME
4 LANGUAGE CODE
5 REASON DESC

Recharge Revenue Slab

Description: RECHARGE REVENUE SLAB

Recharge Revenue Slab Hierarchies

Standard recharge revenue slab Hierarchy:

Description of image086.gif follows
Description of the illustration image086.gif

Recharge Revenue Slab Levels

Table 3-180 shows Recharge Revenue Slab Total: Top level for the dimension with one single value indicating value for all slabs.

Table 3-180 Recharge Revenue Slab Total

Sr. Number Attribute Description

1.

RECHARGE REVENUE SLAB TOTAL ID

Code for All recharge revenue slabs


Table 3-181 shows Recharge Revenue Slab Detail: Most detail level holds values for individual recharge slabs.

Table 3-181 Recharge Revenue Slab Detail

Sr. Number Attribute Description Sample Value

1

RECHARGE REVENUE SLAB CODE

Recharge revenue slab ID or code.

RVN100

2

RECHARGE REVENUE SLAB DESC

Recharge revenue slab description.

Recharge revenue earned for $50-100

3

RECHARGE REVENUE SLAB NAME

Recharge revenue slab short description.

$50-100

4

SLAB RANGE END VALUE

End value of the slab.

 

5

SLAB RANGE END VALUE LOCAL

End value of the slab.

 

6

SLAB RANGE END VALUE REPORTING

End value of the slab.

 

7

SLAB RANGE START VALUE

Starting value of the slab.

 

8

SLAB RANGE START VALUE LOCAL

Starting value of the slab.

 

9

SLAB RANGE START VALUE REPORTING

Starting value of the slab

 

10

LANGUAGE CODE

Unique identifier for a row in the Language dimension.

 

Redemption Type

Description: REDEMPTION TYPE

Redemption Type Hierarchies

Standard Redemption Type Hierarchy:

Description of image087.gif follows
Description of the illustration image087.gif

Redemption Type Levels

Table 3-182 shows Redemption Type Total: Top level used to aggregate data for all the redemption types.

Table 3-182 Redemption Type Total

Sr. Number Attribute Description

1.

REDEMPTION TYPE TOTAL ID

Code for All redemption Types


Table 3-183 shows Redemption Type: Granular level of the dimension at which data is available, lists all the redemption types and its descriptions.

Table 3-183 Redemption Type

Sr. Number Attribute Description Sample Value

1

REDEMPTION TYPE CODE

Code for Redemption Types.

ACCTDPST

2

REDEMPTION TYPE DESC

Redemption Type Description.

Account Deposit

3

REDEMPTION TYPE NAME

Redemption Type Short Name.

Account Deposit

4

LANGUAGE CODE

Unique identifier for a row in the Language dimension.

 

Retail Type

Description: RETAIL TYPE

Retail Type Hierarchies

Standard RETAIL TYPE Hierarchy:

Description of dim_retail_type.png follows
Description of the illustration dim_retail_type.png

Retail Type Levels

The following table shows RETAIL TYPE Total: All RETAIL TYPE is most aggregate level of the dimension.

Table for RETAIL TYPE Total

Sr. Number Attribute Description
1 RETAIL TYPE Total Code for All Retail Type Total.

Detail table shows RETAIL TYPE Detail: It captures information relating to Retail Type.

Detail table RETAIL TYPE Detail

Sr. Number Attribute
1 RETAIL TYPE DESC
2 RETAIL TYPE CODE
3 LANGUAGE CODE
4 RETAIL TYPE NAME

RF Carrier

Description: RF CARRIER

RF Carrier Hierarchies

Standard RF Carrier Hierarchy:

Description of image088.gif follows
Description of the illustration image088.gif

RF Carrier Levels

Table 3-184 shows RF Carrier Total: Values for all carriers. Data may or may not be seen at this level.

Table 3-184 RF Carrier Total

Sr. Number Attribute Description

1.

CARRIER TOTAL ID

Code for All Carriers


Table 3-185 shows RF Carrier Detail: The detail level of the dimension at which the data will be captured and stored.

Table 3-185 RF Carrier Detail

Sr. Number Attribute Description Sample Value

1

RF CARRIER CODE

Carrier code or ID.

 

2

RF CARRIER DESC

Carrier description.

 

3

RF CARRIER NAME

Carrier Name.

 

4

STATUS CODE

Current Status Identifier

 

5

BASE TRANSCEIVER STATION CODE

Identifier for Transceiver Station

 

6

EFFECTIVE FROM DATE

In Effect From

12/31/2005 12:00:00 AM

7

EFFECTIVE TO DATE

In Effect until date

12/31/2005 12:00:00 AM


Roaming Type

Description: ROAMING TYPE

Roaming Type Hierarchies

Standard Roaming Type Hierarchy:

Description of image089.gif follows
Description of the illustration image089.gif

Roaming Type Levels

Table 3-186 shows Roaming Type Total: The Subscriber type defines if the calls made/received are by the Roaming subscriber or by a non-roaming subscriber. Roaming type is further classified as Inbound and outbound roaming subscriber

Table 3-186 Roaming Type Total

Sr. Number Attribute Description

1.

ROAMING TYPE TOTAL CODE

Code for All Roaming Types


Table 3-187 shows Roaming Type: If the calls made/received are by the Roaming subscriber or by a non-roaming subscriber.

Table 3-187 Roaming Type Detail

Sr. Number Attribute Description Sample Value

1

ROAMING TYPE CODE

ROAMING TYPE CODE.

NONROAM

2

ROAMING TYPE DESC

ROAMING TYPE DESC.

Non-Roaming

3

ROAMING TYPE NAME

Short description of the ROAMING TYPE.

Non-Roaming

4

LANGUAGE CODE

Unique identifier for a row in the Language dimension.

 

Sales Channel

Description: SALES CHANNEL

Sales Channel Hierarchy

Standard Sales Channel Hierarchy:

Description of image090.gif follows
Description of the illustration image090.gif

Sales Channel Levels

Table 3-188 shows Sales Channel Total: The most aggregate level in the channel dimension. It combines the results of all channels and shows the total values for facts if selected in the report.

Table 3-188 Sales Channel Total

Sr. Number Attribute Description

1.

SALES CHANNEL TOTAL ID

Code for All Sales channels value


Table 3-189 shows Sales Channel Detail: Sales channel is not multi tiered. Mainly there are three channels of sales such as Sales Representatives, Outlets and dealers. Which are represented by the channel level, which also becomes the lowest level for the channel dimension.

Table 3-189 Sales Channel Detail

Sr. Number Attribute Description Sample Value

2

SALES CHANNEL CODE

Code for Sales Channel

 

3

CHANNEL DESC

A text description for the channel

 

4

CHANNEL CODE

The unique identifier for each Channel. A Channel identifies each possible link where interaction between the Communications Service Provider and the Customer occurs.

 

5

CHANNEL NAME

Short name for the channel

A01

6

CHANNEL TYPE CODE

Unique identifier for channel

SLCHNL

7

CAPACITY QUANTITY

The number of transaction that a Channel can handle, at a point of time.

 

8

DEALER CODE

The number of transaction that a Channel can handle, at a point of time.

 

9

EFFECTIVE FROM DATE

The first date of the period when this Channel was valid.

12/31/2005 12:00:00 AM

10

EFFECTIVE TO DATE

The end date of the period when this Channel was valid.

12/31/2005 12:00:00 AM

11

PARTY CODE

A code for any person or business that is of interest to the Communications Service Provider.

 

12

PARTY TYPE CODE

Code for party types

RPRSTTV

13

STATUS CODE

Current status

A


Sales Channel Representative

Description: SALES CHANNEL REPRESENTATIVE

Sales Channel Hierarchies

Standard Sales Channel Representative Hierarchy:

Description of image091.gif follows
Description of the illustration image091.gif

Sales Channel Representative Levels

Table 3-190 shows Sales Channel Representative Total: The most aggregate level in the channel dimension.

Table 3-190 Sales Channel Representative Total

Sr. Number Attribute Description

1.

SALES CHANNEL REPRESENTATIVE TOTAL ID

Code for All Sales Channel Representative


Table 3-191 shows Sales Channel Representative: This is the most granular level of the channel dimension. Values in this level represent the codes for sales representatives in the shops, Direct sales representatives and Sub-dealers in case of dealers.

Table 3-191 Sales Channel Representative

Sr. Number Attribute Description Sample Value

1

SALES CHANNEL CODE

The unique identifier for each Channel. A Channel identifies each possible link where interaction between the Communications Service Provider and the Customer occurs.

 

2

SALES CHANNEL REPRESENTATIVE CODE

SALES CHANNEL REPRESENTATIVE CODE is used to track and detect sales performance on account payment status.

SLREP-1

       

1

BILLING ADDRESS EFFECTIVE DATE

Date on which the billing address referenced in the billing_address_id column became active. This facilitates queries such as find customers who changed address in the last 3 months.""

 

2

BUSINESS DIVISION EXECUTIVE NAME

BUSINESS DIVISION EXECUTIVE LAST NAME is the last name of the business division executive to whom the employee reports to. Like LOB Owner.

 

3

BUSINESS PHONE NUMBER

Phone number used for business purpose

 

4

CELL PHONE NO

Redundancy to 'party contact information'

 

5

CHILDREN COUNT

Number of children

 

6

CONTACT ADDRESS EFFECTIVE DATE

Date on which the contact address referenced in the billing_address_id column became active. This facilitates queries such as find customers who changed address in the last 3 months.""

 

7

COST CENTER NUMBER

The cost center to which the bank employee expenses are charged.

 

8

DATE OF BIRTH

Date of Birth of the individual.

 

9

DATE OF DEATH

Date of natural person death.

 

10

DEATH CERTIFICATE CODE

The certification document number for customer's death.

 

11

DEPENDENTS COUNT

Number of dependents

 

12

DRIVER LICENSE NUMBER

Driver License Number in most countries.

 

13

DWELLING SIZE

Size of dwelling

 

14

DWELLING TENURE

Tenure of dwelling

 

15

ECONOMICALLY ACTIVE IND

customer is economically active (is not a minor or pensioner and so on.)

 

16

EDUCATION CODE

The customer highest level of education.

 

17

EMAIL

Redundancy to 'party contact information'

 

18

EMPLOYEE CODE

A code for any person or business that is of interest to the Communications Service Provider.

 

19

EMPLOYEE DESIGNATION CODE

Unique warehouse key, representing the designation

 

20

EMPLOYEE DISCOUNT GROUP CODE

Unique identifier for Employee Discount Group

 

21

EMPLOYEE KEY

Key value for each employee

 

22

EMPLOYEE NUMBER

Internal number for the employee.

 

23

EMPLOYEE TYPE CODE

Unique identifier for Employee Type

PT

24

EMPLOYEE TYPE DESC

Description of the Employee Type

Part Time

25

EMPLOYEE TYPE NAME

Unique identifier for the Employee Type

Part Time

26

EMPLOYER TAX NUMBER

The tax code of Employer.

 

27

EMPLOYMENT BEGIN DATE

Start date for the employment.

12/31/2005 12:00:00 AM

28

EMPLOYMENT END DATE

If the employee quit, hold the information of past employment.

 

29

EMPLOYMENT EXEMPT IND

An employee exempt from the overtime policies due to the nature of the work, as compared to (Non-Exempt).

Education requirements of the position and salary range. These employees are paid an annual salary and are not customarily eligible for overtime pay.

 

30

EMPLOYMENT STATUS

EMPLOYEE STATUS is the abbreviated identifier for the employment status. Employee

 

31

END OF JOB CONTRACT

End date of the customer's job contract (for contracts concluded for definite terms).

 

32

ETHNIC BACKGROUND

Customer Attribute of an employee

 

33

ETHNICITY

Classifies the individual for minority reporting purposes.

 

34

FAMILY NAME IN MAIDEN

Given name in maiden

 

35

FIRST NAME

First name of a party individual

 

36

FORM OF EMPLOYMENT

The customer's form of employment (private entrepreneur, employee, civil servant and so on.)

 

37

GENDER CODE

For PARTYs that are people, this is their GENDER.

For PARTYs that are organizations, this is indicates whether the organization is foreign or domestically owned.

 

38

GIVEN NAME IN MAIDEN

Given name in maiden

 

39

HOME TELEPHONE NO

Redundance to 'party contact information'

 

40

HOUSEHOLD KEY

The code of household which the party belongs to.

 

41

INCOME

Income of a party individual

 

42

INCOME LCL

Income of a party individual

 

43

INCOME RPT