3 Logical Data Model Dimensions

Describes the logical dimensions, and hierarchies in the data model.

• Logical Data Model Dimensions
  Lists the logical data model dimensions.

Logical Data Model Dimensions

Lists the logical data model dimensions.

• Access Method
  
• Account
  
• Account Payment Method Status Type
  
• Account Refund Reason
  
• Address Location
  
• Age Band
  
• Age Group
  
• Age On Net Band
  
• ARPU Band
  
• Agreement Change Initiator Type
  
• Agreement Type
  
• 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)
  

Access Method

Description: ACCESS METHOD

Access Method Hierarchy

Standard Access Method Hierarchy

Description of the illustration GUID-C96DD98A-3C5A-4CCB-B4CF-D9FC3E7EF56D-default.gif

Access Method Levels

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

Table 3-1 Access Method Total

Sr. Number	Attribute	Description
1.	ACCESS METHOD TOTAL	Code for All Access Method.

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

Table 3-2 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	No sample values

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

Table 3-3 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	No sample values
5	ACCESS METHOD SEGMENT CODE	Unique identifier for Access Method Segment	No sample values
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.	No sample values
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.	No sample values
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	No sample values
8	STATUS CODE	Current STATUS CODE, standard SCD2 column.	No sample values
9	SWITCH CODE	Unique identifier for Switch	No sample values

Account

Description: ACCOUNT

Account Hierarchies

Standard ACCOUNT Hierarchy:

Description of the illustration GUID-C35FDDAF-974D-4FA5-925A-0F1C93455D37-default.png

Account Levels

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

Table for ACCOUNT Total

Table 3-4 Account Total

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

Detail table ACCOUNT TYPE

Table 3-5 Account Type

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

Detail table ACCOUNT Detail

Table 3-6 Account Detail

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

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 the illustration GUID-FC10BF1F-A1AC-4EB3-8991-374CDBEB94B4-default.gif

Account Payment Method Status Type Levels

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

Table 3-7 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-8 shows Account Payment Method Status Type Detail: All Account Payment Method Status Types are most aggregate level of the dimension.

Table 3-8 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	No Value

Account Refund Reason

Description: ACCOUNT REFUND REASON

Account Refund Reason Hierarchies

Standard Account Refund Reason Hierarchy:

Description of the illustration GUID-C1F3C6FD-3774-4C7C-B597-C6BDAEADCA74-default.gif

Account Refund Reason Levels

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

Table 3-9 Account Refund Reason Total

Sr. Number	Attribute	Description
1.	ACCOUNT REFUND REASON TOTAL	Code for All Account Refund Reason.

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

Table 3-10 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	No Value

Address Location

Description: ADDRESS LOCATION

Address Location Hierarchies

Standard Address Location Hierarchy:

Description of the illustration GUID-D94C5A8E-06DF-4022-8155-53BFC80AABEF-default.gif

Address Location Levels

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

Table 3-11 Address Location Total

Sr. Number	Attribute	Description
1.	ADDRESS LOCATION TOTAL	Code for All Address Locations.

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

Table 3-12 Address Location Detail

Sr. Number	Attribute	Description
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
4	ADDRESS LINE 2	Address. Line two of detailed postal address
5	ADDRESS LINE 3	Address. Line three of detailed postal address
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.
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.
No value	GEOGRAPHY LOCATION CODE	No value
No value	ELEVATION	No value
No value	ELEVATION UOM CODE	No value
No value	GEOGRAPHY REGION CODE	No value
No value	PRIMARY EMAIL ADDRESS	No value

Age Band

Description: AGE BAND

Age Band Hierarchies

Standard Age Band Hierarchy

Description of the illustration GUID-6323C239-C51D-4815-8AFC-2DA4E4EB5487-default.gif

Age Band Levels

Table 3-13 Age Band Total

Sr. Number	Attribute	Description
1.	AGE BAND TOTAL	Code for All Age Bands.

Table 3-14 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	No value

Age Group

Description: AGE GROUP

AGE GROUP Hierarchies

Standard AGE GROUP Hierarchy:

Description of the illustration GUID-F281CF54-90E4-471B-9FF5-30ADBFF90893-default.png

AGE GROUP Levels

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

Table 3-15shows AGE GROUP Total.

Table 3-15 Age Group Total

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

Table 3-16 shows AGE GROUP Detail: All AGE GROUP types is the most aggregate level of the dimension.

Table 3-16 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 the illustration GUID-99322D88-92BD-4BC5-BDC1-28A6B978847B-default.gif

Age on Net Band Levels

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

Table 3-17 Age on Net Band Total

Sr. Number	Attribute	Description
1.	AGE ON NET BAND TOTAL	Code for All Age On Net Band.

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

Table 3-18 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.	No value

ARPU Band

Description: ARPU BAND

ARPU Band Hierarchies

Standard ARPU Band Hierarchy:

Description of the illustration GUID-E119F4E5-3289-40B7-852F-9042A50BCBE1-default.gif

ARPU Band Levels

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

Table 3-19 ARPU Band Total

Sr. Number	Attribute	Description
1.	ARPU BAND TOTAL	Code for All ARPU Band.

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

Table 3-20 ARPU Band Detail

Sr. Number	Attribute	Description
1	ARPU BAND CODE	Unique identifier for revenue band. For example: 0_1000, 1000_3000.
2	ARPU BAND DESC	Description revenue band.
3	ARPU BAND END VALUE	The end point of a band (the end point is included in the band).
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).
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 the illustration GUID-761CCF0B-EF9E-453F-859C-1D7099F080CF-default.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

Table 3-21 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

Table 3-22 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	Unique identifier for Language

Agreement Type

Description: AGREEMENT TYPE

Agreement Type Hierarchies

Standard AGREEMENT TYPE Hierarchy:

Description of the illustration GUID-58C01DA6-F0C3-45FF-AACB-32529DC960F9-default.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

Table 3-23 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

Table 3-24 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	Unique identifier for language

Bank Direct Debit Channel

Description: BANK DIRECT DEBIT CHANNEL

Bank Direct Debit Channel Hierarchies

Standard Bank Direct Debt Channel Hierarchy:

Description of the illustration GUID-76AFB386-B634-4E0C-80A2-CF4DA366D397-default.gif

Bank Direct Debit Channel Levels

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

Table 3-25 Bank Direct Debt Channel Total

Sr. Number	Attribute	Description
1.	BANK DIRECT DEBT CHANNEL TOTAL	Code for All Bank Direct Debt Channel.

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

Table 3-26 Bank Direct Debit Channel Detail

Sr. Number	Attribute	Description
1	BANK BRANCH CODE	Bank Branch id/code.
2	BANK DIRECT DEBIT CHANNEL CODE	Unique identifier for Bank Direct Debit Channel
3	PAYMENT CHANNEL CODE	No value
4	CHANNEL CODE	No value
5	CHANNEL TYPE CODE	No value
6	PARTY CODE	No value
7	PARTY TYPE CODE	No value
8	CHANNEL NAME	No value
9	CHANNEL DESC	No value
10	CAPACITY QUANTITY	No value
11	EFFECTIVE FROM DATE	No value
12	EFFECTIVE TO DATE	No value
13	STATUS CODE	No value

Ber Fer Type

Description: BER FER TYPE

Ber Fer Type Hierarchies

Standard Ber Fer Type Hierarchy:

Description of the illustration GUID-367332BF-7A35-4846-A61A-3C9FC04244B4-default.gif

Ber Fer Type Levels

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

Table 3-27 Ber Fer Type Total

Sr. Number	Attribute	Description
1.	BER FER TYPE TOTAL	Code for All Ber Fer Type.

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

Table 3-28 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	No value

Billing Cycle

Description: BILLING CYCLE

Billing Cycle Hierarchies

Standard BILLING CYCLE Hierarchy:

Description of the illustration GUID-D0A9DA29-CE15-4518-AC9F-1A70AF2C3139-default.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

Table 3-29 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

Table 3-30 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	No value
13	LANGUAGE CODE	Unique identifier for language
14	PAYMENT DUE DATE OFFSET	No value

Billing Status Type

Description: BILLING STATUS TYPE

Billing Status Type Hierarchies

Standard Billing Status Type Hierarchy:

Description of the illustration GUID-455F67A4-9FCA-4EDF-B706-35004D64E810-default.gif

Billing Status Type Levels

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

Table 3-31 Billing Status Type Total

Sr. Number	Attribute	Description
1.	BILLING STATUS TYPE TOTAL	Code for All Billing Status Type.

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

Table 3-32 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	No value

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 the illustration GUID-D3BD13E3-0B63-49CE-81F7-89C11E69AE32-default.gif

Business Time Level

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

Table 3-33 Business Time Total

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

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

Table 3-34 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	No value
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	No value	No value

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

Table 3-35 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	No value

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

Table 3-36 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	No value
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.	No value
10	BUSINESS YEAR START DAY CODE	Code for year start date	No value

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

Table 3-37 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	No value
11	BUSINESS YEAR CODE	Unique warehouse key for year	20050101
12	BUSINESS YEAR START DAY CODE	Unique warehouse key year start day	No value

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

Table 3-38 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	No value
11	BUSINESS QUARTER CODE	Unique warehouse key for quarter	20050101
12	BUSINESS QUARTER START DAY CODE	Unique warehouse key for quarter start day	No value
13	BUSINESS YEAR CODE	Unique warehouse key for year	20050101
14	BUSINESS YEAR START DAY CODE	Unique warehouse key for year start day	No value

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

Table 3-39 Day

Sr. Number	Attribute	Description	Sample Value
1	BUSINESS CURRENT IND	Business Current indicator 'Y' or 'N'	No value
2	BUSINESS DATE	Business date.	No value
3	BUSINESS DATE DESC	Business Date description.	No value
4	BUSINESS DAY CODE	Code for Calendar Day	20050101
5	BUSINESS DAY OF YEAR	Business day of year	No value
6	BUSINESS DAY TIME SPAN	The length, in terms of days, of this fortnight in the Calendar.	No value
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.	No value
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.	No value
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	No value
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	No value
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.	No value
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.	No value
39	BUSINESS WEEK DAY CODE	Unique identifier for business week day.	20050101
40	BUSINESS WEEK DAY DESC	Business week day description	No value
41	BUSINESS WEEK DESC	Business week description.	No value
42	BUSINESS WEEK END DATE	Business week end date.	12/31/2005 12:00:00 AM
43	BUSINESS WEEK NUMBER	Number for business week	No value
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.	No value
47	BUSINESS WEEKEND IND	Weekend indicator 'Y' or 'N'	No value
48	BUSINESS WORKING DAY IND	Working day indicator 'Y' or "N'	No value
49	BUSINESS YEAR CODE	Unique warehouse key for year	20050101
50	BUSINESS YEAR DESC	Calendar year description	No value
51	BUSINESS YEAR END DATE	Calendar year end date.	12/31/2005 12:00:00 AM
52	BUSINESS YEAR NUMBER	Calendar year number.	No value
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 the illustration GUID-51F190CF-A56D-4219-A561-31518EB70A63-default.gif

Calendar Time Level

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

Table 3-40 Calendar Time Total

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

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

Table 3-41 Calendar Year

Sr. Number	Attribute	Description	Sample Value
1	CALENDAR NAME	Textual name of the business Calendar	No value
2	CALENDAR YEAR CODE	Unique warehouse key of the Year, in the Calendar.	No value
3	CALENDAR YEAR DESC	Calendar year description.	No value
4	CALENDAR YEAR END DATE	Calendar year end date.	12/31/2005 12:00:00 AM
5	CALENDAR YEAR NUMBER	Calendar year number.	No value
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	No value

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

Table 3-42 Calendar Half Year

Sr. Number	Attribute	Description	Sample Value
1	CALENDAR HALF YEAR CODE	Unique warehouse key of the half year, in the Calendar.	No value
2	CALENDAR HALF YEAR DESC	Calendar half year description.	No value
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.	No value
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	No value
7	CALENDAR YEAR CODE	Unique key of the year, in which this half year occurred in the Calendar.	No value
8	CALENDAR YEAR START DAY CODE	Code for calendar year start day	No value

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

Table 3-43 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-44 shows Calendar Month: It captures information relating to a month in a Calendar.

Table 3-44 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	No value
3	CALENDAR MONTH CODE	Unique warehouse key of the month, in the Calendar.	20050101
4	CALENDAR MONTH DESC	Calendar month description.	No value
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.	No value
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	No value
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	No value
11	CALENDAR YEAR CODE	Unique warehouse key for year	20050101
12	CALENDAR YEAR START DAY CODE	Unique warehouse key year start day	No value

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

Table 3-45 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.	No value
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.	No value
5	CALENDAR HALF MONTH START DATE	Calendar half month start date	No value
6	CALENDAR HALF MONTH TIMESPAN	The length, in terms of days, of this fortnight in the Calendar. For example: 15 days	No value
7	CALENDAR HALF YEAR CODE	Unique warehouse key for half year.	No value
8	CALENDAR HALF YEAR START DAY CODE	Unique warehouse key for half year start day	No value
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	No value
11	CALENDAR QUARTER CODE	Unique warehouse key for quarter	20050101
12	CALENDAR QUARTER START DAY CODE	Unique warehouse key for quarter start day	No value
13	CALENDAR YEAR CODE	Unique warehouse key for year	20050101
14	CALENDAR YEAR START DAY CODE	Unique warehouse key for year start day	No value

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

Table 3-46 Day

Sr. Number	Attribute	Description	Sample Value
1	CALENDAR CURRENT IND	Calendar current indicator 'Y' or 'N'	No value
2	CALENDAR DATE	Calendar date.	No value
3	CALENDAR DATE DESC	Calendar date description.	No value
4	CALENDAR DAY OF YEAR	Calendar day of year.	No value
5	CALENDAR DAY TIMESPAN	The length, in terms of days.	No value
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.	No value
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.	No value
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.	No value
13	CALENDAR HALF MONTH TIMESPAN	The length, in terms of days, of this fortnight in the Calendar. For example: 15 days	No value
14	CALENDAR HALF YEAR CODE	The unique identifier for a calendar half year.	20050101
15	CALENDAR HALF YEAR DESC	Calendar half year description.	No value
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.	No value
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	No value
21	CALENDAR HOLIDAY IND	It indicates holiday indicator 'Y' or 'N'	No value
22	CALENDAR MONTH CODE	The unique identifier for a calendar month.	20050101
23	CALENDAR MONTH DESC	Calendar month description.	No value
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.	No value
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	No value
29	CALENDAR QUARTER CODE	The unique identifier for calendar quarter.	20050101
30	CALENDAR QUARTER DESC	Calendar quarter description.	No value
31	CALENDAR QUARTER END DATE	Calendar quarter end date.	12/31/2005 0:00
32	CALENDAR QUARTER NUMBER	Number for Calendar quarter	No value
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	No value
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	No value
39	CALENDAR WEEK DAY CODE	The unique identifier for a calendar week day.	20050101
40	CALENDAR WEEK DAY DESCRIPTION	Calendar week day description.	No value
41	CALENDAR WEEK DESC	Calendar week description.	No value
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.	No value
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	No value
46	CALENDAR WEEKEND IND	It indicates calendar weekend indicator 'Y' or 'N'	No value
47	CALENDAR WORKING DAY IND	It indicates the calendar working day indicator 'Y' or 'N'	No value
48	CALENDAR YEAR CODE	The unique identifier for a calendar year.	20050101
49	CALENDAR YEAR DESC	Calendar week description.	No value
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.	No value
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.	No value
54	CALENDAR YEAR TIME SPAN	The length, in terms of days, of this year in the Calendar. For example: 365 days	No value
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	No value

Call Category

Description:

Call Category Hierarchies

Standard Call Category Hierarchy:

Description of the illustration GUID-3835D3A7-D7F3-4F97-9261-10A3DC0CE013-default.gif

Call Category Levels

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

Table 3-47 Call Category Total

Sr. Number	Attribute	Description
1.	CALL CATEGORY TOTAL	Code for All Call Categories.

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

Table 3-48 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 the illustration GUID-952973C5-9472-46C5-AD26-E19B8E75A34B-default.gif

Call Center Agent Levels

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

Table 3-49 Call Center Agent Total

Sr. Number	Attribute	Description
1.	CALL CENTER AGENT TOTAL	Code for All Call Center Agent Subscribers.

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

Table 3-50 Call Center Agent Type

Sr. Number	Attribute	Description
1	CALL CENTER AGENT TYPE DESC	Description of the Agent type.
2	CALL CENTER AGENT TYPE NAME	Name of Agent type.
3	LANGUAGE CODE	Uniquely identifier of language
4	CALL CENTER AGENT TYPE CODE	No value

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

Table 3-51 Call Center Agent Detail

Sr. Number	Attribute	Description
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.
2	CALL CENTER AGENT DESC	Description of the Agent.
3	CALL CENTER AGENT NAME	Name of Agent.
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	No value	No value
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
30	EMPLOYEE TYPE DESC	Description of the Employee Type
31	EMPLOYEE TYPE NAME	Unique identifier for the Employee Type
32	EMPLOYER TAX NUMBER	The tax code of Employer.
33	EMPLOYMENT BEGIN DATE	Start date for the employment.
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	No value
74	PERSONAL ID NUMBER	No value
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.
79	SOC JOB KEY	No value
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 the illustration GUID-276E4A19-947D-4165-A091-8AF17D84814A-default.gif

Call Center Case Levels

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

Table 3-52 Call Center Case Title Total

Sr. Number	Attribute	Description
1.	CALL CENTER CASE TITLE TOTAL	Total of all call center case titles.

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

Table 3-53 Call Center Case Title Detail

Sr. Number	Attribute	Description
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.
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 the illustration GUID-9631A2A9-81E9-4DBA-8D0E-A26D3ADD4F84-default.gif

Call Center Levels

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

Table 3-54 Call Center Total

Sr. Number	Attribute	Description
1.	CALL CENTER TOTAL	Code for All Call Centers.

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

Table 3-55 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	No value
84	PARTY TYPE CODE	No value
85	BUSINESS LEGAL STATUS CODE	No value
86	SOURCE SYSTEM CODE	No value
87	BARING REASON CODE	No value
88	STATUS CODE	No value
89	CITY	No value
90	STATE	No value
91	COUNTRY	No value
92	PARTY NAME	No value
93	PARTY DESC	No value
94	ADDRESS	No value
95	ACTIVE INDICATOR	No value
96	CUSTOMER INDICATOR	No value
97	EFFECTIVE FROM DATE	No value
98	EFFECTIVE TO DATE	No value

Call Direction

Description: CALL DIRECTION

Call Direction Hierarchies

Standard Call Direction Hierarchy:

Description of the illustration GUID-1C09C6A6-6496-4585-A9E2-FA34F03CCFC5-default.gif

Call Direction Levels

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

Table 3-56 Call Direction Total

Sr. Number	Attribute	Description
1.	ALL CALL DIRECTION CODE	Code for Call Directions.

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

Table 3-57 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	No value

Call Other Type

Description: CALL OTHER TYPE

Call Other Type Hierarchies

Standard Call Other Type Hierarchy:

Description of the illustration GUID-C5B8ADEA-7012-4BBD-BE3D-D7C6E1DB4520-default.gif

Call Other Type Levels

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

Table 3-58 Call Other Type Total

Sr. Number	Attribute	Description
1.	ALL CALL OTHER TYPE CODE	Code for Call Other Types.

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

Table 3-59 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	No value

Call Routing Type

Description: CALL ROUTING TYPE

Call Routing Type Hierarchies

Standard Call Routing Type Hierarchy:

Description of the illustration GUID-471EB0A5-6280-49BA-966E-112FE4F7BF32-default.gif

Call Routing Type Levels

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

Table 3-60 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-61 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	Unique identifier of language	No Value

Call Service Type

Description: CALL SERVICE TYPE

Call Service Type Hierarchies

Standard Service Type Hierarchy:

Description of the illustration GUID-2A59B9D4-E25A-4B16-917E-11F982A089CD-default.gif

Call Service Type Levels

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

Table 3-62 Call Service Type Total

Sr. Number	Attribute	Description
1.	CALL SERVICE TYPE TOTAL CODE	Code for All Call Service Type.

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

Table 3-63 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	Unique identifier for language	No value

Call Source Destination

Description: CALL SOURCE DESTINATION

Call Source Destination Hierarchies

Standard Call Source Destination Hierarchy:

Description of the illustration GUID-69E11142-D742-42D6-9CAE-8D86F7EA8E95-default.gif

Call Source Destination Levels

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

Table 3-64 Call Source Destination Total

Sr. Number	Attribute	Description
1.	CALL SOURCE DESTINATION TOTAL	Code for All Call Source Destination

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

Table 3-65 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.	No value
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.	No value
7	NETWORK TYPE CODE	Unique identifier of destination network type.	No value
8	NUMBER AREA CODE	Area code. For example: 713-Houston	No value
9	NUMBER NETWORK TYPE CODE	Unique identifier of destination network type.	No value
10	STATUS CODE	Current status of the assignment.	No value

Call Success Fail Type

Description: CALL SUCCESS FAILURE TYPE

Call Successful Fail Hierarchies

Standard Call Success Fail Hierarchy:

Description of the illustration GUID-19F11976-906F-40A8-8B5D-F5A9D847B8E9-default.gif

Call Success Fail Type Levels

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

Table 3-66 Call Successful Fail Total

Sr. Number	Attribute	Description
1.	ALL SUCCESSFUL/FAILED CODE	Code for All Call Successful/failed.

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

Table 3-67 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.	No value

Call Type

Description: CALL TYPE

Call Type Hierarchies

Standard Call Type Hierarchy:

Description of the illustration GUID-1A55025E-DF64-4E13-9992-66E1908AEDDD-default.gif

Call Type Levels

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

Table 3-68 Call Type Total

Sr. Number	Attribute	Description
1.	ALL CALL TYPE CODE	Code for All Call Type Subscribers.

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

Table 3-69 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.	No value

Campaign

Description: CAMPAIGN

Campaign Hierarchies

Standard CAMPAIGN Hierarchy:

Description of the illustration GUID-BC1BC1CD-58B3-401C-A90D-CBD516D5D384-default.png

Campaign Levels

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

Table for CAMPAIGN Total

Table 3-70 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

Table 3-71 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	No value
19	CAMPAIGN CODE	No value
20	CAMPAIGN NAME	No value
21	CAMPAIGN PURPOSE TYPE CODE	No value
22	CAMPAIGN STATUS CODE	No value

Campaign Channel

Description: CAMPAIGN CHANNEL

Campaign Channel Hierarchies

Standard Campaign Channel Hierarchy:

Description of the illustration GUID-FD25A57C-C5C0-457A-9633-99CBADC29136-default.gif

Campaign Channel Levels

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

Table 3-72 Campaign Channel Total

Sr. Number	Attribute	Description
1.	ALL CAMPAIGN CHANNEL CODE	Code for All Campaign Channel.

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

Table 3-73 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.	No value
3	CAMPAIGN CHANNEL NAME	A textual description of an campaign channel.	No value
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.	No value
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.	No value
7	CHANNEL DESC	Descriptions of the channels	No value
8	CHANNEL NAME	The name assigned to a channel.	No value
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.	No value
13	PARTY TYPE CODE	Type of party	RPRSTTV
14	STATUS CODE	Current status.	No value

Campaign Media

Description: CAMPAIGN MEDIA

Campaign Media Hierarchies

Standard CAMPAIGN MEDIA Hierarchy:

Description of the illustration GUID-8F758875-2746-49AC-8846-CC6BD784A353-default.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

Table 3-74 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

Table 3-75 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 the illustration GUID-C530D440-248B-4F34-84FB-1E0CD904BB9E-default.gif

Cell Outage Levels

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

Table 3-76 Cell Outage Reason Total

Sr. Number	Attribute	Description
1.	ALL CELL OUTAGE REASON CODE	Code for All Cell Outage Reason.

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

Table 3-77 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 language	No value

Cell Site

Description: CELL SITE

Cell Site Hierarchies

Standard CELL SITE Hierarchy:

Description of the illustration GUID-8414B13C-B47F-4CA3-9C82-3D4C75188BAE-default.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

Table 3-78 CONTENT Detail

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	No value
5	CELL SITE NAME	No value
6	CELL SITE DESC	No value

Change Proposed By Type

Description: CHANGE PROPOSED BY TYPE

Change Proposed By Type

Standard CHANGE PROPOSED BY TYPE Hierarchy:

Description of the illustration GUID-BE87E5A2-F8E1-4F83-9D07-D48F699C915B-default.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

Table 3-79 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.

Table 3-80 CHANGE PROPOSED BY TYPE Detail

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 the illustration GUID-389F9F4A-F9ED-4862-9332-3B70EFF15BF1-default.png

Channel Levels

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

Table for CHANNEL Total

Table 3-81 CHANNEL Total

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

Table shows CHANNEL TYPE

Table 3-82 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	No value

Detail table CHANNEL Detail

Table 3-83 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	No value
9	CHANNEL TYPE CODE2	No value
10	CHANNEL DESC	No value

Collection Agency

Description: COLLECTION AGENCY

Collection Agency Hierarchies

Standard Collection Agency Hierarchy:

Description of the illustration GUID-C4EA22E6-4CB7-4300-847C-4E04F560F689-default.gif

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

Table 3-84 Collection Agency Total

Sr. Number	Attribute	Description
1.	ALL COLLECTION AGENCY TOTAL CODE	Identification for the top level value

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

Table 3-85 Collection Agency Detail

Sr. Number	Attribute	Description
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.
8	BANKRUPTCY START DATE	Start date of bankruptcy.
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.
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
26	JUDICIAL DISTRAINT CODE	Case identifier of the judicial distraint
27	JUDICIAL DISTRAINT DATE	Date of the judicial distraint.
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.
29	LIQUIDATION START DATE	Start date of liquidation.
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
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. Redundant 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. Redundant to party location history.
48	COUNTRY	Country of the party. Redundant 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
51	EFFECTIVE TO DATE	EFFECTIVE TO DATE, standard SCD2 column
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.
55	PARTY TYPE CODE	type code. type code
56	POST CODE	Postcode of the party. Redundant 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. Redundant 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 the illustration GUID-82C40388-46AF-4341-8BE2-A6205F30E6C7-default.gif

Commission Type Levels

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

Table 3-86 Commission Type Total

Sr. Number	Attribute	Description
1.	ALL COMMISSION TYPE CODE	Code for All Commission Type.

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

Table 3-87 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.	No value

Competitor

Description: COMPETITOR

Competitor Hierarchies

Standard Competitor Hierarchy:

Description of the illustration GUID-2A936B77-3A2D-4F70-AE8B-8A5B262398DE-default.png

Competitor Levels

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

Table for COMPETITOR Total

Table 3-88 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.

Table 3-89 COMPETITOR Detail

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	No value
19	PARTY TYPE CODE2	No value
20	BUSINESS LEGAL STATUS CODE2	No value
21	LANGUAGE DIALECT CODE	No value
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 the illustration GUID-B241ACFC-402C-45B3-939B-42EFB902618B-default.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

Table 3-90 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.

Table 3-91 CONTACT LIST Detail

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	No value
10	SOURCE SYSTEM CODE1	No value
11	CONTACT LIST CHANGE REASON CODE2	No value
12	COST CODE	No value

Content

Description: CONTENT

Content Hierarchies

Standard CONTENT Hierarchy:

Description of the illustration GUID-7F9131BB-22C6-456E-815D-899769ACABC2-default.png

Content Levels

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

Table for CONTENT Total

Table 3-92 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

Table 3-93 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	No value
6	CONTENT PROVIDER CODE1	No value
7	CONTENT CODE	No value

Content Type

Description: CONTENT TYPE

Content Type Hierarchies

Standard Content Type Hierarchy:

Description of the illustration GUID-F1DFB825-0629-46CE-80B2-D407F9BEE8EA-default.gif

Content Type Levels

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

Table 3-94 All Content Type

Sr. Number	Attribute	Description
1.	ALL CONTENT TYPE CODE	Code for All Content Type.

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

Table 3-95 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.	No value

Contract Change Initiator Type

Description: AGREEMENT CHANGE INITIATOR TYPE

Contract Change Initiator Type Hierarchies

Standard Contract Change Initiator Type Hierarchy:

Description of the illustration GUID-E02AD57C-A320-441E-BECF-522E4C47629C-default.gif

Contract Change Initiator Type Levels

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

Table 3-96 Contract Change InitiatorType Total

Sr. Number	Attribute	Description
1.	ALL CONTENT TYPE CODE	Code for All Content Type.

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

Table 3-97 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.	No value

Contract Assignment Reason

Description: AGREEMENT ASSIGNMENT REASON

Contract Assignment Reason Hierarchies

Standard Contract Assignment Reason Hierarchies:

Description of the illustration GUID-E566280F-07A5-4CE0-89B8-07C5F56CB42C-default.gif

Contract Assignment Reason Level

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

Table 3-98 Contract Assignment Reason Total

Sr. Number	Attribute	Description
1	CONTRACT ASSIGNMENT REASON ID	Code of reason

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

Table 3-99 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.	No value

Cost Center

Description: COST CENTER

Cost Center Hierarchies

Standard COST CENTER Hierarchy:

Description of the illustration GUID-71ADA35E-2616-456F-A25C-BF2D6EB62CFB-default.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

Table 3-100 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

Table 3-101 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	No value
4	COST CENTER NAME	No value
5	COST CENTER CODE1	No value
6	COST CENTER CODE	No value

Credit Category

Description: CREDIT CATEGORY

Credit Category Hierarchies

Standard Credit Category Hierarchies:

Description of the illustration GUID-FD7F3652-1856-4FCC-8454-0A5559AB27DB-default.gif

Credit Category Levels

Table 3-102 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-102 Credit Category Total

Sr. Number	Attribute	Description
1	CREDIT CATEGORY TOTAL ID	Id of the contract Credit Category Total

Table 3-103 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-103 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.	No value

Currency

Description: CURRENCY

Currency Hierarchies

Standard CURRENCY Hierarchy:

Description of the illustration GUID-2332A9B2-3642-4985-A50E-3A23E7A1D1F1-default.png

Currency Levels

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

Table for CURRENCY Total

Table 3-104 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

Table 3-105 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	No value
11	LANGUAGE CODE	No value
12	CURRENCY CODE	No value

Customer

Description: CUSTOMER

Customer Hierarchies

Standard CUSTOMER Hierarchy:

Description of the illustration GUID-9F1FBE17-4926-43A9-A031-28815094B316-default.png

Customer Levels

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

Table for CUSTOMER Total

Table 3-106 CUSTOMER Total

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

Table for CUSTOMER TYPE

Table 3-107 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	No value
4	CUSTOMER TYPE NAME	No value

Detail table CUSTOMER Detail

Table 3-108 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	No value
11	CUSTOMER PAYMENT RESPONSIBLE INDICATOR	Indicate if this customer is responsible for payment of an customer organization or household.
12	MAIL ALLOWED INDICATOR	No value
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	No value
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	No value
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	No value
51	CONTACT CODE	No value
52	CONTACT NAME	No value
53	NATIONALITY CODE	No value
54	MARITAL STATUS CODE	No value
55	MIDDLE NAME	No value
56	LIVING AT CURRENT ADDRESS SINCE	No value
57	LANGUAGE CODE2	No value
58	LAST NAME	No value
59	LEGAL TITLE TO HOUSING	No value
60	JOB CODE	No value
61	JOB CONTRACT TYPE	No value
62	JOB POSITION	No value
63	PARTY ORGANIZATION TYPE CODE	No value
64	CUSTOMER SCORE CODE1	No value
65	CUSTOMER SEGMENT CODE1	No value
66	DEATH CERTIFICATE CODE	No value
67	DRIVER LICENSE NUMBER	No value
68	DWELLING SIZE	No value
69	DWELLING STATUS	No value
70	DWELLING TENURE	No value
71	DWELLING TYPE	No value
72	ECONOMICALLY ACTIVE INDICATOR	No value
73	EDUCATION CODE	No value
74	FAMILY NAME IN MAIDEN	No value
75	FIRST NAME	No value
76	ANNUAL REVENUE	No value
77	ANNUAL REVENUE LOCAL	No value
78	ANNUAL REVENUE REPORTING	No value
79	ANNUAL SALES	No value
80	ANNUAL SALES LOCAL	No value
81	ARPU BAND CODE2	No value
82	ANNUAL SALES REPORTING	No value
83	COMPANY REGISTRY NUMBER	No value
84	NUMBER OF CHILDREN	No value
85	NUMBER OF DEPENDENTS	No value
86	PREV EMPLOYER TAX NUMBER	No value
87	PREV EMPLOYMENT END DATE	No value
88	PREV EMPLOYMENT START DATE	No value
89	PERSONAL IDENTIFICATION NUMBER	No value
90	PLACE OF BIRTH	No value
91	RELIGIOUS AFFILIATION CODE	No value
92	PROSPECT CODE	No value
93	STOCK EXCHANGE NAME	No value
94	TAX EXEMPT STATUS	No value
95	SALES VOLUME CODE	No value
96	START OF EMPLOYMENT	No value
97	SOC JOB CODE	No value
98	SOURCE OF INCOME	No value
99	EQUITY AMOUNT	No value
100	EQUITY AMOUNT LOCAL	No value
101	EQUITY AMOUNT REPORTING	No value
102	EMPLOYEE COUNT	No value
103	ETHNIC BACKGROUND	No value
104	ETHNICITY	No value
105	END OF JOB CONTRACT	No value
106	EXTERNAL ORGANIZATION TYPE CODE2	No value
107	GENDER CODE	No value
108	GIVEN NAME IN MAIDEN	No value
109	HOUSEHOLD CODE	No value
110	FORM OF EMPLOYMENT	No value
111	NAME	No value
112	NAME OF WORKPLACE	No value
113	NAME PREFIX	No value
114	NAME SUFFIX	No value
115	MANAGER CODE	No value
116	MANAGER NAME	No value

Customer Cluster

Description: CUSTOMER CLUSTER

Customer Cluster Hierarchies

Standard CUSTOMER CLUSTER Hierarchy:

Description of the illustration GUID-3E65B518-5C07-4B80-AADA-C76DABCFD993-default.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

Table 3-109 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

Table 3-110 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 the illustration GUID-F96A4F1D-CAFE-4E69-9D49-1543E0386C9E-default.gif

Customer Revenue Band Levels

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

Table 3-111 Customer Revenue Band Total

Sr. Number	Attribute	Description
1	CUSTOMER REVENUE BAND TOTAL ID	Id of Customer Revenue Band Total

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

Table 3-112 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.	No value

Customer Segment

Description: CUSTOMER SEGMENT

Customer Segment Hierarchies

Standard Customer Segment Hierarchies:

Description of the illustration GUID-A8B2B3EF-D802-4881-96FD-AC666A7544B2-default.gif

Customer Segment Levels

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

Table 3-113 Customer Segment Total

Sr. Number	Attribute	Description
1	CUSTOMER SEGMENT TOTAL ID	Id of Customer Segment Total

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

Table 3-114 Customer Segment Detail

Sr. Number	Attribute	Description
1	CUSTOMER SEGMENT CODE	A code used to uniquely identify a grouping of Parties or Accounts for marketing and management issues.
2	CUSTOMER SEGMENT DESC	A textual description for a Segment.
3	CUSTOMER SEGMENT NAME	The name assigned to a Segment.
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.

Dealer

Description: DEALER

Dealer Hierarchies

Standard Dealer Hierarchies:

Description of the illustration GUID-F0C42CB9-6ABD-4CF1-8A71-BED1F1EE0B08-default.gif

Dealer Levels

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

Table 3-115 Dealer Total

Sr. Number	Attribute	Description
1	DEALER TOTAL ID	Id of dealer

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

Table 3-116 Dealer Detail

Sr. Number	Attribute	Description
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.
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.
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.
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
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. Redundant 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. Redundant to party location history.
55	COUNTRY	Country of the party. Redundant 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. Redundant 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. Redundant 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 the illustration GUID-7D94895F-32B5-43A8-86FD-5B0B3A64B268-default.gif

Debt Aging Band Levels

Table 3-117 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-117 Debt Aging Band Total

Sr. Number	Attribute	Description
1.	DEBT AGING BAND ID	Code for Debt Aging Band

Table 3-118 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-118 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	No value	No value
4	DEBT AGING BAND NAME	Name for aging Slab.	Band(0-4)
5	DEBT AGING BAND TO	0	No value
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 the illustration GUID-52F7320D-BB30-4330-BB57-95F0F992B245-default.gif

Direct Debit Status Reason Levels

Table 3-119 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-119 Direct Debit Status Reason Total

Sr. Number	Attribute	Description
1	DIRECT DEBT STATUS REASON ID	Code for Direct Debit Status Reason

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

Table 3-120 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	No value

Divert Retrieve Type

Description:

Divert Retrieve type Hierarchies

Standard Divert Retrieve Type Hierarchy:

Description of the illustration GUID-4F41EFCB-AAB0-434A-9A66-99C19428B5BF-default.gif

Divert Retrieve Type Levels

Table 3-121 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-121 Divert Retrieve Type Total

Sr. Number	Attribute	Description
1.	DIVERT RETRIEVE TYPE TOTAL ID	Code for Divert Retrieve Type Total

Table 3-122 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-122 Divert Retrieve Type Detail

Sr. Number	Attribute	Description	Sample Value
1	DIVERT RETRIEVE SUB TYPE CODE	Call divert/retrieve subtype ID	No value
2	DIVERT RETRIEVE SUB TYPE DESC	Call divert/retrieve subtype description	No value
3	DIVERT RETRIEVE SUB TYPE NAME	Call divert/retrieve subtype short description	No value
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	No value

Employee

Description: EMPLOYEE

Employee Hierarchies

Standard Employee Hierarchy:

Description of the illustration GUID-52707517-7FFA-4015-BA59-6B76AC467C12-default.gif

Employee Levels

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

Table 3-123 Employee Total

Sr. Number	Attribute	Description
1.	EMPLOYEE TOTAL ID	Code for employee total identifier.

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

Table 3-124 Employee Detail

Sr. Number	Attribute	Description
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
24	EMPLOYEE TYPE DESC	Description of the Employee Type
25	EMPLOYEE TYPE NAME	Unique identifier for the Employee Type
26	EMPLOYER TAX NUMBER	The tax code of Employer.
27	EMPLOYMENT BEGIN DATE	Start date for the employment.
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	Redundant 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.
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. Redundant to party location history.
82	COUNTRY	Country of the party. Redundant 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 the illustration GUID-6E48172A-E763-49D0-BB67-E4BF9AD5CE83-default.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

Table 3-125 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 the illustration GUID-6E48172A-E763-49D0-BB67-E4BF9AD5CE83-default.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

Table 3-126 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

Table 3-127 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 the illustration GUID-6F036907-D852-45A6-B43C-98A7D9194BFF-default.gif

Event Result Levels

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

Table 3-128 Event Result Total

Sr. Number	Attribute	Description
1.	ALL EVENT RESULT ID	Code for Event Result

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

• S: Successful

• F: failed

Table 3-129 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	No value

Event Type

Description: EVENT TYPE

Event Type Hierarchies

Standard Event Type Hierarchies:

Description of the illustration GUID-52D68AED-AA67-4F37-AC8A-046DF43A5FC1-default.gif

Event Type Levels

Table 3-130 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-130 Event Type Total

Sr. Number	Attribute	Description
1.	ALL EVENT TYPE TOTAL ID	Code for All Event Type

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

Table 3-131 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	No value

External Operator

Description: EXTERNAL OPERATOR

External Operator Hierarchies

Standard EXTERNAL OPERATOR Hierarchy:

Description of the illustration GUID-6C0C6D3F-858D-48E5-8CCA-AB5ED8E7244B-default.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

Table 3-132 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

Table 3-133 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	No value
44	COUNTRY NAME	No value
45	EXTERNAL ORGANIZATION TYPE CODE2	No value
46	PARTY ORGANIZATION TYPE CODE	No value
47	OTHER INDIVIDUAL CODE1	No value
48	OPERATOR GROUP CODE1	No value
49	OPERATOR TYPE CODE2	No value
50	PLMN CODE	No value
51	TAP 1 ID	No value
52	TAP 2 ID	No value
53	ANNUAL SALES REPORTING	No value
54	ANNUAL SALES LOCAL	No value
55	ANNUAL SALES	No value

Fraud Profile Class

Description: FRAUD PROFILE CLASS

Fraud Profile Class Hierarchies

Standard Fraud Profile Class Hierarchy:

Description of the illustration GUID-94C12251-0C87-43F4-AEA0-7003CFAA7BCD-default.gif

Fraud Profile Class Levels

Table 3-134 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-134 Fraud Profile Class Total

Sr. Number	Attribute	Description
1.	ALL FRAUD PROFILE CLASS ID	Code for All Fraud Profile Class

Table 3-135 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-135 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
4.	LANGUAGE CODE	No value

Geography

Description: GEOGRAPHY ENTITY

Geography Hierarchies

Standard Geography Hierarchy:

Description of the illustration GUID-E2EB1C77-2B6D-4553-B489-A7BFD047A43E-default.gif

Geography Levels

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

Table 3-136 Geography World

Sr. Number	Attribute	Description	Sample Value
1	EFFECTIVE TO DATE	EFFECTIVE TO DATE, standard SCD2 column	No value
2	GEOGRAPHY WORLD CODE	Identifier of world.	No value
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.	No value

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

Table 3-137 Geography Region

Sr. Number	Attribute	Description	Sample Value
1	GEOGRAPHY REGION CODE	unique identifier of geography region	No value
2	EFFECTIVE TO DATE	EFFECTIVE TO DATE, standard SCD2 column	12/31/2005 12:00:00 AM
3	GEOGRAPHY WORLD CODE	Identifier of world.	No value
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	No value

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

Table 3-138 Geography Sub Region

Sr. Number	Attribute	Description	Sample Value
1	GEOGRAPHY REGION CODE	unique identifier of geography region	No value
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	No value
5	GEOGRAPHY SUB REGION CODE	Unique identifier of geography sub region	No value

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

Table 3-139 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	Unique identifier of the country.	No value
4	GEOGRAPHY SUB REGION CODE	Unique identifier of geography sub region	No value
5	GEOGRAPHY COUNTRY NAME	Name of the country	No value

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

Table 3-140 Geography State

Sr. Number	Attribute	Description	Sample Value
1	GEOGRAPHY STATE NAME	Name of state	No value
2	EFFECTIVE TO DATE	EFFECTIVE TO DATE, standard SCD2 column	12/31/2005 12:00:00 AM
3	GEOGRAPHY STATE CODE	Unique identifier of geography state	No value
4	EFFECTIVE FROM DATE	Active from. Standard SCD field, Effective Start Date	12/31/2005 12:00:00 AM
5	GEOGRAPHY COUNTRY CODE	Unique identifier of the country.	No value

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

Table 3-141 Geography City

Sr. Number	Attribute	Description	Sample Value
1	GEOGRAPHY CITY NAME	Name of the city	No value
2	EFFECTIVE TO DATE	EFFECTIVE TO DATE, standard SCD2 column	12/31/2005 12:00:00 AM
3	GEOGRAPHY STATE CODE	Unique identifier of state	No value
4	EFFECTIVE FROM DATE	Active from. Standard SCD field, Effective Start Date	12/31/2005 12:00:00 AM
5	GEOGRAPHY CITY CODE	Unique identifier of city	No value
6	GEOGRAPHY CITY DESC	CITY DESC.	No value

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

Table 3-142 Geography County

Sr. Number	Attribute	Description	Sample Value
1	EFFECTIVE TO DATE	EFFECTIVE TO DATE, standard SCD2 column	No value
2	EFFECTIVE FROM DATE	Active from. Standard SCD field, Effective Start Date	12/31/2005 12:00:00 AM
3	GEOGRAPHY COUNTY CODE	Unique identifier of county	No value
4	GEOGRAPHY COUNTY NAME	Name of the county	No value
5	GEOGRAPHY CITY CODE	Unique identifier of city	No value

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

Table 3-143 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	Unique identifier of building
3	ELEVATION	Elevation of the Geographic Location
4	ELEVATION UOM CODE	Unique identifier of ELEVATION UOM
5	FLOOR CODE	Unique identifier of floor
6	FLOOR NAME	Name of the floor
7	GEOGRAPHY LOCATION CODE	Applicable unique geography ID.
8	GEOGRAPHY REGION CODE	Unique 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	Uniquelidentifier of state
19	CITY DESC	Description of the city
20	FLAT ROOM CODE	Unique 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 the illustration GUID-C5F3B576-D899-43B6-937B-520FBC87506B-default.gif

Give Away Type Levels

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

Table 3-144 All Give Away Type

Sr. Number	Attribute	Description
1.	ALL GIVE AWAY TYPE CODE	Code for All Give Away Type.

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

Table 3-145 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 the illustration GUID-D73F69D8-B66E-482A-9674-8F6A5EABACF4-default.gif

GPRS Service Levels

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

Table 3-146 GRRS Services Total

Sr. Number	Attribute	Description
1.	ALL GPRS SERVICE CODE	Code for All GPRS Service.

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

Table 3-147 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.
17.	PRODUCT RATING PLAN TYPE CODE	No value

Handset Model

Description: HANDSET MODEL

Handset Model Hierarchies

Standard Handset Model Hierarchy:

Description of the illustration GUID-E601E6D8-2EDC-41DE-9084-8AC8CF00790D-default.gif

Handset Model Levels

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

Table 3-148 Handset Model Total

Sr. Number	Attribute	Description
1.	HANDSET MODEL TOTAL CODE	Code for All Handset Model.

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

Table 3-149 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
51	PRODUCT DESC	No value
52	MODEL TYPE CODE	No value

IN Platform

Description: IN PLATFORM

IN Platform Hierarchies

Standard IN Platform Hierarchy:

Description of the illustration GUID-C8804E6A-813D-4463-B11E-9EB177603967-default.gif

IN Platform Level

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

Table 3-150 IN Platform Total

Sr. Number	Attribute	Description
1.	ALL IN PLATFORM CODE	Code for All IN Platform.

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

Table 3-151 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.	No value
5.	IN PLATFORM NAME	IN Platform name.	No value
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.	No value

Initiative Type

Description: INITIATIVE TYPE

Initiative Type Hierarchies

Standard Initiative Type Hierarchy:

Description of the illustration GUID-CE2B1D42-2216-49B1-9314-7BA6C7DC1270-default.gif

Initiative Type Levels

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

Table 3-152 Initiative Type Total

Sr. Number	Attribute	Description
1.	ALL INITIATIVE TYPE CODE	Code for All Initiative Type.

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

Table 3-153 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 the illustration GUID-0965E7D9-6D6B-49E5-A043-162218A231EB-default.gif

Interaction Channel Levels

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

Table 3-154 Interaction Channel Total

Sr. Number	Attribute	Description
1.	ALL INTERACTION CHANNEL CODE	Code for All Interaction Channel.

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

Table 3-155 Interaction Channel Detail

Sr. Number	Attribute	Description
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. For example 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 the illustration GUID-2C454286-C405-4677-B5A2-29D5BB85980B-default.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

Table 3-156 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

Table 3-157 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	No value
4	INTERACTION DIRECTION DESC	No value

Interaction Type

Description: INTERACTION TYPE

Interaction Type Hierarchies

Standard INTERACTION TYPE Hierarchy:

Description of the illustration GUID-25BE6BB7-E9B4-45F3-955E-C680E2BE3E57-default.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

Table 3-158 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

Table 3-159 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 the illustration GUID-8409A498-C7AC-4CAD-81F2-D69A510ACBDF-default.gif

Invoice Adjustment Reason Levels

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

Table 3-160 Invoice Adjustment Reason Total

Sr. Number	Attribute	Description
1.	ALL INVOICE ADJUSTMENT REASON CODE	Code for All Invoice Adjustment Reason.

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

Table 3-161 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.	No value

Invoice Adjustment Type

Description: INVOICE ADJUSTMENT TYPE

Invoice Adjustment Type Hierarchies

Standard Invoice Adjustment Type Hierarchy:

Description of the illustration GUID-37F67DF2-C2FA-4FBE-9A89-CA9EDE87BAFD-default.gif

Invoice Adjustment Type Levels

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

Table 3-162 Invoice Adjustment Type Total

Sr. Number	Attribute	Description
1.	ALL INVOICE ADJUSTMENT TYPE CODE	Code for All Invoice Adjustment Type.

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

Table 3-163 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.	No value

Invoice Status

Description: INVOICE STATUS

Invoice Status Hierarchies

Standard INVOICE STATUS Hierarchy:

Description of the illustration GUID-B9FFEFE9-81E7-4522-9655-57D0E0DA5FFE-default.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

Table 3-164 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

Table 3-165 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 the illustration GUID-7F803E78-E0D4-476D-9A89-DE264563060C-default.png

ISP Levels

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

Table for ISP Total

Table 3-166 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

Table 3-167 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	No value
36	ANNUAL SALES REPORTING	No value
37	EXTERNAL ORGANIZATION TYPE CODE2	No value
38	ISP CODE	No value
39	ISP TYPE CODE2	No value
40	ANNUAL SALES	No value
41	OTHER INDIVIDUAL CODE1	No value
42	PARTY ORGANIZATION TYPE CODE	No value

Item Subclass

Description: ITEM SUBCLASS

Item Subclass Hierarchies

Standard ITEM SUBCLASS Hierarchy:

Description of the illustration GUID-12FC16F8-835C-4B7D-AD69-0D491DC67F7D-default.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

Table 3-168 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

Table 3-169 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 the illustration GUID-B4C18A61-710E-48C0-A3AC-75451183B82A-default.gif

Legal Process Status type Levels

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

Table 3-170 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-171 shows Legal Process Status Type Detail: Detail level of the dimension. It Stores the Legal Process Status Type Detail Information.

Table 3-171 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 the illustration GUID-03941F58-8542-455A-B251-46FD5B0F1BF8-default.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

Table 3-172 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

Table 3-173 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 the illustration GUID-7FBFD687-6DB0-4EA3-BA79-986891781ED8-default.gif

Loyalty Program Channel Levels

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

Table 3-174 Loyalty Program Channel Total

Sr. Number	Attribute	Description
1.	ALL LOYALTY PROGRAM CHANNEL CODE	Code for All Loyalty Program Channel.

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

Table 3-175 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.	No value
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.	No value
4.	CHANNEL NAME	The name assigned to a channel.	No value
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.	No value
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.	No value

Loyalty Tier

Description: LOYALTY TIER

Loyalty Tier Hierarchies

Standard LOYALTY TIER Hierarchy:

Description of the illustration GUID-DBBA5930-F837-439C-81B8-B29CC9914C95-default.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:

Table 3-176 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

Table 3-177 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

Table 3-178 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 the illustration GUID-0A4591D9-4481-4A3A-86B2-113E27F6F2DB-default.gif

Market Area Levels

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

Table 3-179 Market Area Total

Sr. Number	Attribute	Description
1.	ALL MARKET AREA CODE	Code for All Market Area's

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

Table 3-180 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.
21.	DEFINITION TYPE	No value
22.	AREA SHAPE	No value
23.	STATE SALES LOCAL	No value
24.	STATE SALES REPORTING	No value
25.	EFFECTIVE FROM DATE	No value
26.	EFFECTIVE TO DATE	No value

Media Object Type

Description: MEDIA OBJECT TYPE

Media Object Type Hierarchies

Standard MEDIA OBJECT TYPE Hierarchy:

Description of the illustration GUID-EA310B16-D3C7-4B83-9955-9599932C5D75-default.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

Table 3-181 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

Table 3-182 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	No value

Network

Description: NETWORK

Network Hierarchies

Standard Network Hierarchy:

Description of the illustration GUID-9E4826AD-19FE-4447-AFC2-E0B3D969C710-default.gif

Network Levels

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

Table 3-183 Network Total

Sr. Number	Attribute	Description
1.	ALL NETWORK CODE	Code for All Network's.

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

Table 3-184 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.	No value
4.	SERVICE PROVIDER CODE	Code of the service provider of the network.	No value
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 the illustration GUID-A0EACA30-145A-4D71-9DE8-4491260A6E56-default.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

Table 3-185 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

Table 3-186 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	No value
12	RESOURCE CODE	No value

Network Touchpoint Class

Description: NETWORK TOUCHPOINT CLASS

Network Touchpoint Class Hierarchies

Standard Network Touchpoint Class Hierarchy:

Description of the illustration GUID-BB44558E-B690-4C29-AB0E-94E72CEFD4C9-default.gif

Network Touchpoint Class Levels

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

Table 3-187 Network Touchpoint Class Total

Sr. Number	Attribute	Description
1.	NETWORK TOUCHPOINT CLASS TOTAL CODE	Code for All Network Touchpoint class.

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

Table 3-188 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.	No value

Network Touchpoint Status

Description: NETWORK TOUCHPOINT STATUS

Network Touchpoint Status Hierarchies

Standard Network Touchpoint Status Hierarchy:

Description of the illustration GUID-E12AC98A-3A44-4F46-A5A6-72CD44F0431C-default.gif

Network Touchpoint Status Level

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

Table 3-189 Network Touchpoint Status Total

Sr. Number	Attribute	Description
1.	NETWORK TOUCHPOINT STATUS TOTAL CODE	Code for All Network Touchpoint Status.

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

Table 3-190 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 the illustration GUID-1C5C54A1-7DD7-447D-A88D-E176B033A9F7-default.gif

Network Touchpoint Type Levels

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

Table 3-191 Network Touchpoint Type Total

Sr. Number	Attribute	Description
1.	NETWORK TOUCHPOINT TYPE TOTAL CODE	Code for All Network Touchpoint Type.

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

Table 3-192 Network Touchpoint Type Detail

Sr. Number	Attribute	Description	Sample Value
1.	LANGUAGE CODE	Code for network touchpoint type languages	No value
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 the illustration GUID-BDD94E07-AEA1-42F7-8C11-B32FF7862B21-default.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

Table 3-193 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

Table 3-194 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 the illustration GUID-7E57FE53-7688-4C4E-93A5-B2C835919103-default.gif

Notification Type Levels

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

Table 3-195 Notification Type Total

Sr. Number	Attribute	Description
1.	NOTIFICATION TYPE TOTAL CODE	Code for All Notification Type total.

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

Table 3-196 Notification Type Detail

Sr. Number	Attribute	Description	Sample Value
1.	LANGUAGE CODE	Code for Notification type languages	No value
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 the illustration GUID-07D8FC90-5678-45DA-8C37-7416EFF3CBC8-default.gif

NP Request Type Levels

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

Table 3-197 NP Request Type Total

Sr. Number	Attribute	Description
1.	NP REQUEST TYPE TOTAL CODE	Code for All NP Request Types Total.

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

Table 3-198 NP Request Type Detail

Sr. Number	Attribute	Description	Sample Value
1.	LANGUAGE CODE	Code for NP Request Type language	No value
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 the illustration GUID-C5AAD7C6-BABA-477D-A14C-DA9B1627DBD6-default.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

Table 3-199 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

Table 3-200 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 the illustration GUID-DC77E373-DA42-45A9-A5AA-77DD11E01090-default.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

Table 3-201 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

Table 3-202 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

Table 3-203 ORDER LINE ITEM STATE Detail

Sr. Number	Attribute	Description
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. For example: 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	No value
4	ORDER LINE ITEM STATE TYPE CODE	No value
5	STATUS CODE	No value
6	EFFECTIVE TO DATE	No value
7	EFFECTIVE FROM DATE	No value

Order State

Description: ORDER STATE

Order State Hierarchies

Standard ORDER STATE Hierarchy:

Description of the illustration GUID-46F40D5B-14CD-4B0C-9CC3-06BAC7CA74C7-default.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

Table 3-204 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

Table 3-205 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

Table 3-206 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	No value
4	ORDER STATE NAME	No value
5	EFFECTIVE TO DATE	No value
6	EFFECTIVE FROM DATE	No value
7	STATUS CODE	No value

Order Type

Description: ORDER TYPE

Order Type Hierarchies

Standard ORDER TYPE Hierarchy:

Description of the illustration GUID-75CBBB2F-17BC-4B63-A510-E1DFBCC1A148-default.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

Table 3-207 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

Table 3-208 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	No value
4	LANGUAGE CODE	No value

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 the illustration GUID-870B9E3F-831A-4268-8196-9F13BC585D35-default.gif

Company Hierarchy:

Description of the illustration GUID-637A528B-8068-47BD-B842-1A54200321B7-default.gif

Division Hierarchy:

Description of the illustration GUID-448F3F1D-1048-4482-912A-5DDBF19560D8-default.gif

Organization Corporate Levels

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

Table 3-209 All Organization Total

Sr. Number	Attribute	Description
1.	ORGANIZATION TOTAL Id's	Code for All Organization Total.

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

Table 3-210 Organization Corporate

Sr. Number	Attribute	Description
1.	EFFECTIVE FROM DATE	Active from. Standard SCD field, Effective Start Date For example: 12/31/2005 12:00:00 AM
2.	EFFECTIVE TO DATE	End effective date for the assignment. For example: 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	No value
6.	ORGANIZATION CORPORATE NAME	Name for Organization Corporate
7.	STATUS CODE	Current STATUS CODE of the assignment.

Organization Banner Levels

Table 3-211 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-211 Organization Banner Levels

Sr. Number	Attribute	Description
1.	ALL ORGANIZATION BANNER ID's	Code for All Organization Banner.

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

Table 3-212 Organization Banner

Sr. Number	Attribute	Description
1.	EFFECTIVE FROM DATE	Active from. Standard SCD field, Effective Start Date For example: 12/31/2005 12:00:00 AM
2.	EFFECTIVE TO DATE	End effective date for the assignment. For example: 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-213 shows All Organization Company: All Organization Company are most aggregate level of Dimension.

Table 3-213 All Organization Company

Sr. Number	Attribute	Description
1.	ALL ORGANIZATION COMPANY ID's	Code for All Organization Company.

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

Table 3-214 Organization Company

Sr. Number	Attribute	Description
1	EFFECTIVE FROM DATE	Active from. Standard SCD field, Effective Start Date For example: 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. For example: 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-215 shows Organization Division Total: All Organization Division are most aggregate level of dimension.

Table 3-215 Organization Division Total

Sr. Number	Attribute	Description
1.	ALL ORGANIZATION DIVISION ID's	Code for All Organization Division.

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

Table 3-216 Organization Division

Sr. Number	Attribute	Description
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.
8.	EFFECTIVE TO DATE	No value

Organization Chain: Organization Chain Levels

Table 3-217 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-217 Organization Chain Total

Sr. Number	Attribute	Description
1.	ALL ORGANIZATION CHAIN ID's	Code for All Organization Chain.

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

Table 3-218 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-219 shows Organization Area Total: Organization hierarchy level within an organization chain and is the parent of one or more organization regions.

Table 3-219 Organization Area Total

Sr. Number	Attribute	Description
1.	ALL ORGANIZATION AREA ID's	Code for All Organization Area.

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

Table 3-220 Organization Area Detail

Sr. Number	Attribute	Description
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-221 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-221 All Organization Regions

Sr. Number	Attribute	Description
1.	ALL ORGANIZATION REGION ID's	Code for All Organization Region.

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

Table 3-222 Organization Region

Sr. Number	Attribute	Description
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-223 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-223 All Organization District

Sr. Number	Attribute	Description
1.	ALL ORGANIZATION DISTRICT ID's	Code for All Organization District.

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

Table 3-224 Organization District

Sr. Number	Attribute	Description
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-225 shows All Organization Business Unit: It is the lowest level of Organization.

Table 3-225 All Organization Business Unit

Sr. Number	Attribute	Description
1.	ALL ORGANIZATION BUSINESS UNIT ID's	Code for All Organization Business Unit.

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

Table 3-226 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."
81	PARTY CODE	No value
82	PARTY TYPE CODE	No value
83	BUSINESS LEGAL STATUS CODE	No value
84	SOURCE SYSTEM CODE	No value
85	BARING REASON CODE	No value
86	STATUS CODE	No value
87	CITY	No value
88	STATE	No value
89	COUNTRY	No value
90	PARTY NAME	No value
91	PARTY DESC	No value
92	LOCATION TYPE CODE	No value
93	CONTACT TYPE CODE	No value
94	ADDRESS	No value
95	PRIMARY MARKET AREA CODE	No value
96	ACTIVE INDICATOR	No value
97	CUSTOMER INDICATOR	No value
98	JUDICIAL DISTRAINT CODE	No value
99	CONTACT CODE	No value
100	COURT CODE	No value
101	MANAGER CODE	No value
102	DUNS NUMBER	No value
103	CONTACT NUMBER	No value
104	LONG DESCRIPTION	No value
105	CONSTRUCTION STATUS	No value
106	CONTACT NAME	No value
107	EXTERNAL NAME	No value
108	EMPLOYEE COUNT	No value
109	EQUITY AMOUNT	No value
110	EQUITY AMOUNT LOCAL	No value
111	EQUITY AMOUNT REPORTING	No value
112	LIQUIDATION START DATE	No value
113	LIQUIDATION END DATE	No value
114	DOMESTIC INDICATOR	No value
115	FINAL SETTLEMENT START DATE	No value
116	FINAL SETTLEMENT END DATE	No value
117	JUDICIAL DISTRAINT DATE	No value
118	EFFECTIVE FROM DATE	No value
119	EFFECTIVE TO DATE	No value

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 the illustration GUID-73E53412-F861-4C2D-8049-5FB757DE6C06-default.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

Table 3-227 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

Table 3-228 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 the illustration GUID-792AB49A-97D9-4731-8A0E-8EDFA5DB50B3-default.gif

Partner Settlement Reason Levels

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

Table 3-229 Partner Settlement Reason Total

Sr. Number	Attribute	Description
1.	ALL PARTNER SETTLEMENT REASON CODE	Code for All Partner Settlement Reason.

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

Table 3-230 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 the illustration GUID-F122109A-05D4-4DFE-82C1-3D69FE750069-default.gif

Party Levels

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

Table 3-231 Party Total

Sr. Number	Attribute	Description
1.	ALL PARTY CODE	Code for All Party.

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

Table 3-232 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. Redundant to party location history.	No value
3.	BARING REASON CODE	Reasons for barring. For example, 1-Credit Limit, 2-Barring period.	No value
4.	BUSINESS LEGAL STATUS CODE	A unique identifier for a legal classification of a non-residential Customer.	No value
5.	CITY	City of the party. Redundant to party location history.	No value
6.	COUNTRY	Country of the party. Redundant to party location history.	No value
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.	No value
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. Redundant to party location history.	No value
15.	SOURCE SYSTEM CODE	SOURCE SYSTEM ID, from which source ERP system this recorded was extracted.	No value
16.	STATE	State of the party. Redundant to party location history.	No value
17.	STATUS CODE	Current status of party.	No value

Payment Channel

Description: PAYMENT CHANNEL.

Payment Channel Hierarchies

Standard Payment Channel Hierarchy:

Description of the illustration GUID-72A66AF2-C7EC-40C9-BDC5-AA6E041F1624-default.gif

Payment Channel Levels

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

Table 3-233 Payment Channel Total

Sr. Number	Attribute	Description
1.	PAYMENT CHANNEL TOTAL ID's	Code for All Payment Channel.

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

Table 3-234 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.	No value
3.	PARTY CODE	A code for any person or business that is of interest to the Communications Service Provider.	No value
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.	No value
5.	CHANNEL NAME	The name assigned to a channel.	PAY
6.	CHANNEL TYPE CODE	Unique identifier of the channel type	PAY
7.	PARTY TYPE CODE	No value	No value
8.	CHANNEL DESC	No value	No value
9.	EFFECTIVE FROM DATE	No value	No value
10.	EFFECTIVE TO DATE	No value	No value
11.	STATUS CODE	No value	No value

Payment Method Type

Description: PAYMENT METHOD TYPE

Payment Method Type Hierarchies

Standard Payment Method Type Hierarchy:

Description of the illustration GUID-0D318585-FECE-48CB-832D-55BC33A606B7-default.gif

Payment Method Type Levels

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

Table 3-235 Payment Method Type Total

Sr. Number	Attribute	Description
1.	PAYMENT METHOD TYPE TOTAL ID's	Code for All Payment Method Types.

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

Table 3-236 Payment Method Type Detail

Sr. Number	Attribute	Description	Sample Value
1.	LANGUAGE CODE	Language ID---Unique identifier for a row in the Language dimension.	No value
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 the illustration GUID-314E1295-B7CA-4F57-A322-D39F8F2AA85F-default.gif

Payment Transaction Type Levels

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

Table 3-237 Payment Transaction Type Total

Sr. Number	Attribute	Description
1.	PAYMENT TRANSACTION TYPE TOTAL CODE	Code for All Payment Transaction Type.

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

Table 3-238 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 the illustration GUID-187B43EA-13E5-4D19-90C4-2CDA93430833-default.gif

PCU Outage Reason Levels

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

Table 3-239 PCU Outage Reason Total

Sr. Number	Attribute	Description
1.	PCU OUTAGE REASON TOTAL CODE	Code for All PCU Outage Reason.

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

Table 3-240 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 the illustration GUID-A781C684-2BD4-4C59-9CBA-9C461F1DC121-default.gif

Peak Offpeak Time Levels

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

Table 3-241 Peak Offpeak Time Total

Sr. Number	Attribute	Description
1.	PEAK OFFPEAK TIME TOTAL Id's	Code for All Peak Offpeak Time.

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

Table 3-242 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	No value
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
9.	LANGUAGE CODE	Unique identifier for language	No value

PPA Category

Description: PPA CATEGORY

PPA Category Hierarchies

Standard PPA Category Hierarchy:

Description of the illustration GUID-842A2BC9-C75C-4AD1-B54B-5DFE9A7553A3-default.gif

PPA Category Levels

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

Table 3-243 PPA Category Total

Sr. Number	Attribute	Description
1.	PPA CATEGORY TOTAL ID	Code for All PPA Categories

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

Table 3-244 PPA Category Detail

Sr. Number	Attribute	Description	Sample Value
1.	PPA CATEGORY CD	PPA Category code	FLANSWER
2.	LANGUAGE CODE	Language Code	Language ID---Unique identifier for a row in the Language dimension
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 the illustration GUID-0F734F63-232B-4CCD-BB93-9FE48630B74B-default.gif

Product Levels

Table 3-245 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-245 Product Total

Sr. Number	Attribute	Description
1.	All PRODUCTS ID	Identification for the top level value

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

Table 3-246 Product Type

Sr. Number	Attribute	Description
1.	PRODUCT TYPE CD	Product Type Code For example: BB
2.	PRODUCT TYPE DESCRIPTION	Product Type Description For example: Broad Band
3.	PRODUCT TYPE NAME	No value
4.	PRODUCT TYPE DESC	No value
5.	EFFECTIVE FROM DATE	No value
6.	EFFECTIVE TO DATE	No value
7.	STATUS CODE	No value

Product Specification Type

Description: PRODUCT SPECIFICATION TYPE

Product Specification Type Hierarchies

Standard PRODUCT SPECIFICATION TYPE Hierarchy:

Description of the illustration GUID-79BD3135-463B-454B-B3EA-E1103319C61B-default.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

Table 3-247 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

Table 3-248 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	No value
5	EFFECTIVE TO DATE	No value
6	EFFECTIVE FROM DATE	No value

Product Subscription Status

Description: PRODUCT SUBSCRIPTION STATUS

Product Subscription Status Hierarchies

Standard PRODUCT SUBSCRIPTION STATUS Hierarchy:

Description of the illustration GUID-558F3065-C271-468A-A6EB-90BDA63A0601-default.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

Table 3-249 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

Table 3-250 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.	No value
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	No value	No value
5	LANGUAGE CODE	No value	No value

Product Subscription Type

Description: PRODUCT SUBSCRIPTION TYPE

Product Subscription Type Hierarchies

Standard PRODUCT SUBSCRIPTION TYPE Hierarchy:

Description of the illustration GUID-631A3E77-AE13-4CA0-985A-2014A013EEF9-default.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

Table 3-251 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

Table 3-252 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	Language ID---Unique identifier for a row in the Language dimension

Promotion

Description: PROMOTION

Promotion Hierarchies

Standard Promotion Hierarchy:

Description of the illustration GUID-1779A005-0200-45AD-BBAF-4AA438295DEA-default.gif

Promotion Levels

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

Table 3-253 Campaign

Sr. Number	Attribute	Description
1	CAMPAIGN CODE	Unique Identifier for Campaign For example: 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. For example: 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. For example: CSTAT
7	CAMPAIGN TYPE CODE	Unique Identifier for a Campaign type. For example: 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.
13	EFFECTIVE TO DATE	The end date of a Campaign.
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-254 shows Campaign Type:

Table 3-254 Campaign Type

Sr. Number	Attribute	Description	Sample Value
1	CAMPAIGN TYPE CODE	A code used to uniquely identify a CAMPAIGN TYPE.	TGPRMTN
2	CAMPAIGN TYPE DESC	A textual description of a CAMPAIGN TYPE.	A Targeted Promotion
3	CAMPAIGN TYPE NAME	The name assigned to a CAMPAIGN TYPE.	Targeted Promotion
4	LANGUAGE CODE	Unique identifier for a row in the Language dimension.	No value

Table 3-255 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-255 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.	No value

Table 3-256 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-256 Promotion

Sr. Number	Attribute	Description
1	PROMOTION CODE	A unique identifier for a campaign cell. For example: PRMTN-1
2	PROMOTION DESC	A textual description for a campaign Cell. For example: PRMTN-1
3	PROMOTION NAME	Name of Promotion For example: 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 For example: 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. For example: 12/31/2005 12:00:00 AM
27	PROMOTION PURPOSE	Captures the purpose of the promotion.
28	PROMOTION START DATE	PROMOTION START DATE. For example: 12/31/2005 12:00:00 AM
29	PROMOTION TYPE CODE	A code used to uniquely identify a PROMOTION TYPE. For example: 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. For example: 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 the illustration GUID-1D1EA574-B8BF-4712-A621-2D7475A46724-default.gif

Promotion Result Type Levels

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

Table 3-257 Promotion Result Type Total

Sr. Number	Attribute	Description
1.	PROMOTION RESULT TYPE TOTAL ID	Code for All Promotion Result Type

Table 3-258 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-258 Promotion Result Type Detail

Sr. Number	Attribute	Description	Sample Value
1	PROMOTION RESULT CTGRY CODE	Code for Sales Campaign result category.	No value
2	PROMOTION RESULT CTGRY DESC	Code for Sales Campaign result category.	No value
3	PROMOTION RESULT CTGRY NAME	Description of the Sales Campaign result category.	No value
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.	No value

Quarter Hour

Description: QUARTER HOUR

Quarter Hour Hierarchies

Standard QUARTER HOUR Hierarchy:

Description of the illustration GUID-9184869E-044E-4926-B204-F354DB136E96-default.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

Table 3-259 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

Table 3-260 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 the illustration GUID-3DE0F33A-CCB2-47E2-AF87-9854EDBDC1CE-default.png

Reason Levels

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

Table for REASON Total

Table 3-261 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

Table 3-262 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 the illustration GUID-3E48F949-ED52-4057-8707-CC4726166B42-default.gif

Recharge Revenue Slab Levels

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

Table 3-263 Recharge Revenue Slab Total

Sr. Number	Attribute	Description
1.	RECHARGE REVENUE SLAB TOTAL ID	Code for All recharge revenue slabs

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

Table 3-264 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.	No value
5	SLAB RANGE END VALUE LOCAL	End value of the slab.	No value
6	SLAB RANGE END VALUE REPORTING	End value of the slab.	No value
7	SLAB RANGE START VALUE	Starting value of the slab.	No value
8	SLAB RANGE START VALUE LOCAL	Starting value of the slab.	No value
9	SLAB RANGE START VALUE REPORTING	Starting value of the slab	No value
10	LANGUAGE CODE	Unique identifier for a row in the Language dimension.	No value

Redemption Type

Description: REDEMPTION TYPE

Redemption Type Hierarchies

Standard Redemption Type Hierarchy:

Description of the illustration GUID-F3C8F348-27E3-4673-B619-1A1697E1698B-default.gif

Redemption Type Levels

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

Table 3-265 Redemption Type Total

Sr. Number	Attribute	Description
1.	REDEMPTION TYPE TOTAL ID	Code for All redemption Types

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

Table 3-266 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.	No value

Retail Type

Description: RETAIL TYPE

Retail Type Hierarchies

Standard RETAIL TYPE Hierarchy:

Description of the illustration GUID-75597844-78E2-4720-BF09-D2D16D54D0FF-default.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

Table 3-267 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

Table 3-268 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 the illustration GUID-94552D63-8ECA-4D19-8ED2-4B575E5F627E-default.gif

RF Carrier Levels

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

Table 3-269 RF Carrier Total

Sr. Number	Attribute	Description
1.	CARRIER TOTAL ID	Code for All Carriers

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

Table 3-270 RF Carrier Detail

Sr. Number	Attribute	Description	Sample Value
1	RF CARRIER CODE	Carrier code or ID.	No value
2	RF CARRIER DESC	Carrier description.	No value
3	RF CARRIER NAME	Carrier Name.	No value
4	STATUS CODE	Current Status Identifier	No value
5	BASE TRANSCEIVER STATION CODE	Identifier for Transceiver Station	No value
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 the illustration GUID-897216BB-BBD5-4488-A3F8-AD9273811132-default.gif

Roaming Type Levels

Table 3-271 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-271 Roaming Type Total

Sr. Number	Attribute	Description
1.	ROAMING TYPE TOTAL CODE	Code for All Roaming Types

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

Table 3-272 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.	No value

Sales Channel

Description: SALES CHANNEL

Sales Channel Hierarchy

Standard Sales Channel Hierarchy:

Description of the illustration GUID-BA932397-204E-4344-970B-6093CE21EB69-default.gif

Sales Channel Levels

Table 3-273 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-273 Sales Channel Total

Sr. Number	Attribute	Description
1.	SALES CHANNEL TOTAL ID	Code for All Sales channels value

Table 3-274 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-274 Sales Channel Detail

Sr. Number	Attribute	Description	Sample Value
2	SALES CHANNEL CODE	Code for Sales Channel	No value
3	CHANNEL DESC	A text description for the channel	No value
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.	No value
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.	No value
8	DEALER CODE	The number of transaction that a Channel can handle, at a point of time.	No value
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.	No value
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 the illustration GUID-815A69C5-42DE-494C-A59B-665D24DDF599-default.gif

Sales Channel Representative Levels

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

Table 3-275 Sales Channel Representative Total

Sr. Number	Attribute	Description
1.	SALES CHANNEL REPRESENTATIVE TOTAL ID	Code for All Sales Channel Representative

Table 3-276 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-276 Sales Channel Representative

Sr. Number	Attribute	Description
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.
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
24	EMPLOYEE TYPE DESC	Description of the Employee Type
25	EMPLOYEE TYPE NAME	Unique identifier for the Employee Type
26	EMPLOYER TAX NUMBER	The tax code of Employer.
27	EMPLOYMENT BEGIN DATE	Start date for the employment.
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	Redundant 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	No value
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	No value
67	PERSONAL ID NUMBER	In China, this one will be 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.
72	SOC JOB KEY	No value
73	SOCIAL SECURITY NUMBER	In US, this code will be same as party.national_identifier. Null if some 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. Redundant to party location history.
82	COUNTRY	Country of the party. Redundant 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

Script

Description: SCRIPT

Script Hierarchies

Standard SCRIPT Hierarchy:

Description of the illustration GUID-30522284-A5CE-424D-AC7C-4C1C9641FDCE-default.png

Script Levels

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

Table for SCRIPT Total

Table 3-277 SCRIPT Total

Sr. Number	Attribute	Description
1	SCRIPT Total	Code for All Script Total.

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

Detail table SCRIPT Detail

Table 3-278 SCRIPT Detail

Sr. Number	Attribute	Description
1	SCRIPT DESC	A brief description for a script.
2	SCRIPT NAME	A name assigned to a Script.
3	SCRIPT CODE	Unique identifier for a script.

Service Coverage Area

Description: SERVICE COVERAGE AREA

Service Coverage Hierarchies

Standard Service Coverage Hierarchy:

Description of the illustration GUID-D23484C3-9790-4C53-B6A4-41DD03C5FBA6-default.gif

Service Coverage Area Levels

Table 3-279 shows Service Coverage Area Total: Service areas are defined so that service providers can determine the demographic / psychographic / population data the geography served by the network.

Table 3-279 Service Coverage Area Total

Sr. Number	Attribute	Description
1.	SALES CHANNEL REPRESENTATIVE TOTAL ID	Code for All Sales Coverage Area values

Table 3-280 shows Service Coverage Area: This is the detail level of Service Coverage Area.

Table 3-280 Service Coverage Area

Sr. Number	Attribute	Description
1	AREA SHAPE	Shape of the trade area
2	AREA TYPE	Urban - Suburban - Exurban - Rural
3	AVERAGE DRIVE TIME	Average drive time from the coverage area to the given store or site.
4	AVERAGE FAMILY SIZE	Average Family Size = Total population divided by number of families
5	AVERAGE HOUSEHOLD SIZE	Average household size in the coverage area.
6	AVERAGE NUMBER VEHICLES PER HOUSEHOLD	Average Number of Vehicles by household = total number of vehicles divided by total number of household.
7	CITY	City. City of the trade area
8	COMMUNITY SEGMENTS	The segmentation system was created to group neighborhoods based on socioeconomic and demographic composition such as age, income, home value, occupation, household type, education, and so on. They help improve the ability to predict behavior of social groups that are geographically clustered.
9	COMMUTER POPULATION	Total commuter population of the coverage area.
10	COUNTRY	Country. Country of the trade area
11	COUNTY	County / District. County / District of the trade area
12	DEFINITION SOURCE	The source of the definition
13	DEFINITION TYPE	Definition type of the market area, some standard classifications can include: Study traffic flow, Use a retail gravity model, Use a zip code method and so on. Some standard classifications can include: Study traffic flow, Use a retail gravity model, Use a zip code method and so on.
14	ISO CURRENCY CODE	Currency used for the demographic information
15	LATITUDE	The latitude measure for the trade area
16	LONGITUDE	The longitude measure for the trade area
17	NUMBER OF HOUSEHOLDS	Approximate total number of households in the coverage area.
18	ORGANIZATION BUSINESS UNIT CODE	Unique identifier for Business Unit. To identify whether the site is a store, distribution center or warehouse.
19	PEAK SEASON POPULATION	The peak trading season of a given area can be determined by the seasonality or yearly economic cycle and so on. This is mostly applicable for renowned tourist spots.
20	PER CAPITA INCOME	Per Capita Income = income of that area divided by total population
21	PER CAPITA INCOME LOCAL	Per Capita Income = income of that area divided by total population
22	PER CAPITA INCOME REPORTING	Per Capita Income = income of that area divided by total population
23	PRIMARY ZIP CODE	Primary zip code of the market area. The primary zip code or the pin code of the Trade area
24	PRODUCT CODE	The short name for the product.
25	PULL FACTOR	Ratios that estimate the proportion of local sales that occurs in a town. Ratio that estimate the proportion of local sales that occurs in a town.
26	SECONDARY ZIP CODE	Secondary zip code in case the zip code spans across multiple zip codes. Applicable only in case the zip code spans across multiple zip codes
27	SERVICE COVERAGE AREA CODE	COVERAGE AREA CODE. Unique identifier for the coverage area
28	SERVICE COVERAGE AREA TYPE CODE	No value
29	STATE	State or province. State or province of the trade area
30	STATE POPULATION	Approximate population of the state.
31	STATE SALES	Estimated total retail sales in the state.
32	TOTAL POPULATION	Estimated total population of the market area
33	TOURIST POPULATION	Expected tourist population of the Trade coverage area.
34	TRADE AREA CAPTURE	An estimate of the number of people who shop in the local area during a certain period.
35	TRADE AREA CODE	Market Area identifier.
36	TRADE AREA DESC	Trade area description. Textual description of the trade area
37	TRADE AREA NAME	Market area name. The name of the trade area

SKU Item

Description: SKU ITEM

SKU Item Hierarchies

Standard SKU ITEM Hierarchy:

Description of the illustration GUID-9CC38DD5-0E17-4FAF-B9F1-A6448BE4836D-default.png

SKU Item Levels

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

Table for SKU ITEM Total

Table 3-281 SKU ITEM Total

Sr. Number	Attribute	Description
1	SKU ITEM Total	Code for All SKU Item Total.

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

Detail table SKU ITEM Detail

Table 3-282 SKU ITEM Detail

Sr. Number	Attribute
1	TAX EXMPTN CODE
2	SHRINK INDICATOR
3	SILHOUETTE DSCR
4	SRVC ITEM DSCR
5	SRVC TERMS CODE
6	STAT CODE
7	SIZE TYPE CODE
8	SKU ITEM CODE
9	SKU ITEM CONSTRUCTION CODE
10	SKU ITEM DSCR
11	SKU ITEM INDICATORSTRY IDNT CODE
12	SKU ITEM LNG DSCR
13	SKU ITEM NAME
14	SKU ITEM NUMBER
15	SKU ITEM SALENG PRICE NUMBER
16	SKU TYPE CODE
17	SECURITY REQUIRED TYPE CODE
18	UOM CODE
19	VRTY NUMBER1
20	VRTY NUMBER2
21	VRTY NUMBER3
22	W ID
23	VNDR CODE
24	UNIT PRICE FCTR
25	NET COST AMOUNT REPORT
26	NET COST AMOUNT REPORT2
27	NET COST AMOUNT REPORT3
28	LAST UPDATE BY
29	LAST UPDATE DATE
30	LOAD DATE
31	PACK INDICATOR
32	PACK ORDERABLE CODE
33	PACK ORDERABLE DSCR
34	PACK SALEBL CODE
35	PACK SALEBL DSCR
36	PACK SIMPLE CODE
37	PACK SIMPLE DSCR
38	PACKAGE SIZE
39	ORGANIZATION CODE
40	ORGANIZATION TYPE CODE
41	PRICE LN CODE
42	PREPARED DSCR
43	PROD ENT CODE
44	PROD LN CODE
45	PRD COUNT
46	PKG UOM
47	PRD TYPE CODE
48	PENALITY AMOUNT
49	PENALITY AMOUNT LOCAL
50	PENALITY AMOUNT REPORT
51	PENALITY AMOUNT REPORT2
52	PENALITY AMOUNT REPORT3
53	PENALITY METHOD CODE
54	PENALITY PCTG
55	POS DEPT CODE
56	SALE UNIT LANDED COST AMOUNT
57	SALE UNIT LANDED COST AMOUNT LOCAL
58	SALE UNIT LANDED COST AMOUNT REPORT
59	SALE UNIT LANDED COST AMOUNT REPORT2
60	SALE UNIT LANDED COST AMOUNT REPORT3
61	SALE UT LAST RECEIVED BS CST AMOUNT
62	SALE UT LAST RECEIVED BS CST AMOUNT LOCAL
63	SALE UT LAST RECEIVED BS CST AMOUNT REPORT
64	SALE UT LAST RECEIVED BS CST AMOUNT REPORT2
65	SALE UT LAST RECEIVED BS CST AMOUNT REPORT3
66	SALE UT LAST RECEIVED CST ESTBD DATE
67	SALE UT LAST RECEIVED NT CST AMOUNT
68	SALE UT LAST RECEIVED NT CST AMOUNT LOCAL
69	SALE UT LAST RECEIVED NT CST AMOUNT REPORT
70	SALE UT LAST RECEIVED NT CST AMOUNT REPORT2
71	SALE UT LAST RECEIVED NT CST AMOUNT REPORT3
72	SALE WT OR UNIT COUNT INDICATOR
73	RECALL INDICATOR
74	RECIPE CODE
75	REF DNSTY
76	STOCK DSCR
77	STOCK ITEM COATING CODE
78	STOCK ITEM COLOR CODE
79	STOCK ITEM DYE CODE
80	STOCK ITEM FABRIC CODE
81	STOCK ITEM FIBER CODE
82	STOCK ITEM SIZE CODE
83	STOCK ITEM STYLE CODE
84	STOCK ITEM TYPE CODE
85	STOCK ITEM WEAVE CODE
86	STOCK ITEM WT CODE
87	SWELL INDICATOR
88	AGGR TYPE
89	ALERT TRANSACTION INDICATOR
90	AVLBL FOR SALE DATE
91	Attribute_58
92	BASE COST AMOUNT
93	BASE COST AMOUNT LOCAL
94	BASE COST AMOUNT REPORT
95	BASE COST AMOUNT REPORT2
96	BASE COST AMOUNT REPORT3
97	CONSTRCTN CODE
98	BLK TO SALENG UNIT WST FCTR PCTG
99	BLK TO SALENG UNIT WST TYPE CODE
100	BULK ITEM TARE CODE
101	COST ESTBD DATE
102	CURRENT INDICATOR
103	COVER COUNT
104	CUST PAYS FOR DSPSTN INDICATOR
105	CUSTOMER PICKUP TYPE CODE
106	CONVBL TYPE CODE
107	DEPOSIT AMOUNT
108	DEPOSIT AMOUNT LOCAL
109	DEPOSIT AMOUNT REPORT
110	DEPOSIT AMOUNT REPORT2
111	DEPOSIT AMOUNT REPORT3
112	DEPOSIT PCTG
113	DEPOSIT RULE CODE
114	EFFECT TO DATE
115	EFFECT FROM DATE
116	FABRIC DSCR
117	ENV TYPE CODE
118	FINANCIAL LEDGER ACCOUNT CODE
119	GROUP SELECT DSCR
120	HAZARDS MATERIAL TYPE CODE
121	HOLDING TIME
122	GLBL ITEM NUMBER
123	ITEM ORDR COLLCTN CODE
124	ITEM POS DEPT NUMBER
125	ITEM PRICE AUDIT INDICATOR
126	ITEM PRSHBL INDICATOR
127	ITEM RECIPE INDICATOR
128	ITEM SALE WT OR UNIT COUNT CODE
129	ITEM SALEABLE INDICATOR
130	ITEM SALENG RULE NUMBER
131	ITEM SHRNK INDICATOR
132	ITEM SPEC CODE
133	ITEM AUTHORIZED FOR SALE INDICATOR
134	ITEM DISC INDICATOR
135	ITEM ENV TYPE CODE
136	ITEM FULL PALLET ITEM INDICATOR
137	ITEM STORE REORDRBL INDICATOR
138	ITEM STP SALE INDICATOR
139	ITEM SUB IDNT INDICATOR
140	ITEM SWELL INDICATOR
141	ITEM USG CODE
142	ITEM CMISN INDICATOR
143	ITEM INVOICE INDICATOR
144	ITEM KIT SET CODE
145	ITEM MRCHNDS INDICATOR
146	ITEM NUMBER
147	INVOICE ACCOUNT METHOD CODE
148	NET COST AMOUNT
149	NET COST AMOUNT LOCAL

SPNM Other Party Number

Description: SPNM OTHER PARTY NUMBER

SPNM Other Party Number Hierarchies

Standard SPNM OTHER PARTY NUMBER Hierarchy:

Description of the illustration GUID-23DD3BA4-D160-4A5D-BAD6-BFCA4F956741-default.png

SPNM Other Party Number Levels

The following table shows SPNM OTHER PARTY NUMBER Total: All SPNM OTHER PARTY NUMBER is most aggregate level of the dimension.

Table for SPNM OTHER PARTY NUMBER Total

Table 3-283 SPNM OTHER PARTY NUMBER Total

Sr. Number	Attribute	Description
1	SPNM OTHER PARTY NUMBER Total	Code for All SPNM OTHER PARTY NUMBER Total.

Detail table shows SPNM OTHER PARTY NUMBER Detail: It captures information relating to SPNM OTHER PARTY NUMBER.

Detail table SPNM OTHER PARTY NUMBER Detail

Table 3-284 SPNM OTHER PARTY NUMBER Detail

Sr. Number	Attribute
1	STATUS CODE
2	SPNM CODE
3	SPNM GROUP CODE
4	EFFECTIVE TO DATE
5	OTHER PARTY NUMBER
6	EFFECTIVE FROM DATE
7	SPNM KEY

Subsidy Type

Description: SUBSIDY TYPE

Subsidy Type Hierarchies

Standard Subsidy Type Hierarchy:

Description of the illustration GUID-C0BCA8AD-63B4-4401-A15C-88DBD129F9D2-default.gif

Subsidy Type Levels

Table 3-285 shows Subsidy Type Total: Most aggregate level for the Subsidy Type dimension to see the aggregated value of all the subsidy types.

Table 3-285 Subsidy Type Total

Sr. Number	Attribute	Description
1.	SUBSIDY TYPE TOTAL CODE	Code for All Subsidy Types

Table 3-286 shows Subsidy Type Detail: This level stores the actual values for subsidy types and enables analysis of related facts by subsidy types. This is the most granular level of the dimension data will be captured and stored at this level.

Table 3-286 Subsidy Type Detail

Sr. Number	Attribute	Description	Sample Value
1	SUBSIDY TYPE CODE	Code for Subsidy type	ACCTDPST
2	SUBSIDY TYPE DESC	Description of the Subsidy Type	Account Deposit
3	SUBSIDY TYPE NAME	Name of the Subsidy type	Account Deposit
4	LANGUAGE CODE	Unique identifier for a row in the Language dimension.	No value

Switch

Description: SWITCH

Switch Hierarchies

Standard Switch Hierarchy:

Description of the illustration GUID-73F6072A-6A3E-40B4-B97E-5E61DF51CFF3-default.gif

Switch Levels

Table 3-287 shows Switch Total: Network switches or exchanges. It may a position switch (digital or analog), or GSM MSC.

Table 3-287 Switch Total

Sr. Number	Attribute	Description
1.	SWITCH TOTAL CODE	Code for Switches

Table 3-288 shows Switch Detail: Network switches or exchanges. It may a position switch (digital or analog), or GSM MSC.

Table 3-288 Switch Detail

Sr. Number	Attribute	Description
1	SWITCH CODE	A unique identifier for a telecommunications device used to route telephone calls and communication transmissions.
2	SWITCH TYPE CODE	A code used to categorize a switch.
4	TECHNOLOGY CODE	A code that uniquely identifies a technology.
7	EFFECTIVE FROM DATE	Effective from date when valid
8	EFFECTIVE TO DATE	Effective to date when valid
9	EQUIPMENT CENTER CODE	The equipment center, where this equipment locates in.
10	EXTERNAL OUTBOUND INDICATOR	Indicate if the switch belongs to external operator, then the circuit.
11	NETWORK ELEMENT DESC	A text description for the Network
12	NETWORK ELEMENT CODE	Identifier of the network.
13	NETWORK ELEMENT NAME	Short name of the network.
14	NETWORK CODE	Code for the network.
15	STATUS CODE	No value

Technology Type

Description: TECHNOLOGY TYPE

Technology Type Hierarchies

Standard Technology Type Hierarchy:

Description of the illustration GUID-717B2DA8-C6F1-4279-B0E2-D5CEBE77CFB7-default.gif

Technology Type Levels

Table 3-289 shows Technology Type Total: Categories for a Technology. For example, wireless, copper line, Optical Fiber.

Table 3-289 Technology Type Total

Sr. Number	Attribute	Description
1.	ALL TECHNOLOGY CODE	Code for all technologies.

Table 3-290 shows Technology Types: Detail level of each technology type. Categories for Technology, for example, wireless, copper line, Optical Fiber

Table 3-290 Technology Types

Sr. Number	Attribute	Description	Sample Value
1	TECHNOLOGY TYPE CODE	A code that uniquely identifies technology type.	CL
2	TECHNOLOGY TYPE DESC	A textual description that describes a technology type.	Copper Line
3	TECHNOLOGY TYPE NAME	A name assigned to a technology type.	Copper Line
4	LANGUAGE CODE	Unique identifier for a row in the Language dimension.	No value

Tender

Description: TENDER

Tender Hierarchies

Standard TENDER Hierarchy:

Description of the illustration GUID-47ED8A42-0EAC-4D9C-9C5E-59B013017317-default.png

Tender Levels

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

Table for TENDER Total

Sr. Number	Attribute	Description
1	TENDER Total	Code for All Tender Total.

Detail table shows TENDER CLASS Detail: It captures information relating to Tender Class.

Detail table TENDER CLASS Detail

Table 3-291 TENDER CLASS Detail

Sr. Number	Attribute
1	TENDER CLASS CODE
2	LANGUAGE CODE
3	TENDER CLASS NAME
4	TENDER CLASS DESC

Detail table shows TENDER Detail: It captures information relating to Tender.

Detail Table TENDER Detail

Table 3-292 TENDER Detail

Sr. Number	Attribute
1	OFFLINE TENDER CEILING APRVL AMOUNT REPORT2
2	OFFLINE TENDER CEILING APRVL AMOUNT REPORT3
3	OFFLINE TENDER FLOOR APPROVAL AMOUNT
4	OFFLINE TENDER FLOOR APPROVAL AMOUNT LOCAL
5	OFFLINE TENDER FLOOR APPROVAL AMOUNT REPORT
6	OFFLINE TENDER FLOOR APPROVAL AMOUNT REPORT2
7	OFFLINE TENDER FLOOR APPROVAL AMOUNT REPORT3
8	REALTIME BALANCE UPDT INDICATOR
9	PRSNL ID NBR REQUIRED INDICATOR
10	TENDER CLASS CODE
11	TENDER CODE
12	TENDER CODE _1
13	STATUS CODE
14	SRL ID NBR REQUIRED INDICATOR
15	W ID
16	UNIT COUNT REQUIRED INDICATOR
17	ACCEPT FOR PAY ON ACCOUNT INDICATOR
18	ACCOUNT ID REQUIRED INDICATOR
19	ACCOUNT REC INDICATOR
20	AMOUNT COUNT REQUIRED INDICATOR
21	AUTHORIZATION EXP DT REQUIRED INDICATOR
22	AUTHORIZATION MAXIMUM WAIT ALWD SEC COUNT
23	AUTHORIZATION MTHD CODE
24	AUTHORIZATION REQUIRED INDICATOR
25	CHANGE THRESHOLD AMOUNT
26	CHANGE THRESHOLD AMOUNT LOCAL
27	CHANGE THRESHOLD AMOUNT REPORT
28	CHANGE THRESHOLD AMOUNT REPORT2
29	CHANGE THRESHOLD AMOUNT REPORT3
30	CHK ENCODENG INDICATOR
31	CURRENT INDICATOR
32	CUST ID REQUIRED INDICATOR
33	CUST SIGN REQUIRED INDICATOR
34	EFFECT TO DATE
35	DSCR
36	EFFECT FROM DATE
37	FINCL LDGR ACCOUNT CODE
38	ENDORSEMENT REQUIRED INDICATOR
39	GFT CARD EXPRY INDICATOR
40	GFT CARD FIXED INDICATOR
41	ITEM RESTRICTED APPLY INDICATOR
42	MAGNET STRIP RDR REQUIRED INDICATOR
43	MICR INDICATOR
44	MINIMUM ACCEPT AMOUNT
45	MINIMUM ACCEPT AMOUNT LOCAL
46	MINIMUM ACCEPT AMOUNT REPORT
47	MINIMUM ACCEPT AMOUNT REPORT2
48	MINIMUM ACCEPT AMOUNT REPORT3
49	MAXIMUM ACCEPT AMOUNT
50	MAXIMUM ACCEPT AMOUNT LOCAL
51	MAXIMUM ACCEPT AMOUNT REPORT
52	MAXIMUM ACCEPT AMOUNT REPORT2
53	MAXIMUM ACCEPT AMOUNT REPORT3
54	MAXIMUM ACCEPT DENMTN
55	LAST UPDATE BY
56	LOAN PERMISSIBILITY INDICATOR
57	LAST UPDATE DATE
58	LOCAL CURRENCY AVAILABILITY INDICATOR
59	LOAD DATE
60	LOCAL ISO CURRENCY CODE
61	OVERRIDE TRIGGER MAXIMUM AMOUNT
62	OVERRIDE TRIGGER MAXIMUM AMOUNT LOCAL
63	OVERRIDE TRIGGER MAXIMUM AMOUNT REPORT
64	OVERRIDE TRIGGER MAXIMUM AMOUNT REPORT2
65	OVERRIDE TRIGGER MAXIMUM AMOUNT REPORT3
66	ONLINE TENDER CEILING APPROVAL AMOUNT
67	ONLINE TENDER CEILING APPROVAL AMOUNT LOCAL
68	ONLINE TENDER CEILING APPROVAL AMOUNT REPORT
69	ONLINE TENDER CEILING APPROVAL AMOUNT REPORT2
70	ONLINE TENDER CEILING APPROVAL AMOUNT REPORT3
71	ONLINE TENDER FLOOR APPROVAL AMOUNT
72	ONLINE TENDER FLOOR APPROVAL AMOUNT LOCAL
73	ONLINE TENDER FLOOR APPROVAL AMOUNT REPORT
74	ONLINE TENDER FLOOR APPROVAL AMOUNT REPORT2
75	ONLINE TENDER FLOOR APPROVAL AMOUNT REPORT3
76	OPEN CASH DRAWER REQUIRED INDICATOR
77	OFFLINE TENDER CEILING APPROVAL AMOUNT
78	OFFLINE TENDER CEILING APPROVAL AMOUNT LOCAL
79	OFFLINE TENDER CEILING APRVL AMOUNT REPORT

Time Slot

Description: TIME SLOT

Time Slot Hierarchies

Standard Time Slot Hierarchy:

Description of the illustration GUID-9F31D829-5B26-4E21-9A55-84EAB3223DDE-default.gif

Time Slot Levels

Table 3-293 shows Time Slot Total: Level to be used for summary analysis for all time slots. Most aggregate level of the dimension.

Table 3-293 Time Slot Total

Sr. Number	Attribute	Description
1.	TIME SLOT TOTAL ID	Key/code for grouping all the time hour slots of the day.

Table 3-294 shows Time Slot Detail: Most detail level of the dimension at which data will be captured in the facts. Values will be used for detail analysis.

Table 3-294 Time Slot Detail

Sr. Number	Attribute	Description	Sample Value
1	HALF HOUR CODE	Retrofitted from column HALF_HOUR_CODE of table TIME_SLOT_DIM	No value
2	HALF HOUR NAME	Retrofitted from column HALF_HOUR_NAME of table TIME_SLOT_DIM	01:00 - 01:29 AM
3	HALF HOUR NUMBER	Retrofitted from column HLF_HOUR_NUMBER of table TIME_SLOT_DIM	No value
4	HALF HOUR TIME OF DAY	Retrofitted from column HLF_HOUR_TIME_OF_DAY of table TIME_SLOT_DIM	5/15/2008 1:00:00 AM
5	HOUR CODE	Retrofitted from column HOUR_CODE of table TIME_SLOT_DIM	No value
6	HOUR NAME	Retrofitted from column HOUR_NAME of table TIME_SLOT_DIM	01:00 - 01:29 AM
7	HOUR NUMBER	Retrofitted from column HOUR_NUMBER of table TIME_SLOT_DIM	1
8	HOUR TIME OF DAY	Retrofitted from column HOUR_TIME_OF_DAY of table TIME_SLOT_DIM	5/5/2008 1:00:00 AM
9	QTR HOUR CODE	Retrofitted from column QTR_HOUR_CODE of table TIME_SLOT_DIM	No value
10	QTR HOUR NAME	Retrofitted from column QTR_HOUR_NAME of table TIME_SLOT_DIM	No value
11	QTR HOUR NUMBER	Retrofitted from column QTR_HOUR_NUMBER of table TIME_SLOT_DIM	No value
12	QTR HOUR TIME OF DAY	Retrofitted from column QTR_HOUR_TIME_OF_DAY of table TIME_SLOT_DIM	No value
13	TIME SLOT CODE	TIME SLOT CODE.	5,6
14	TIME SLOT NAME	TIME SLOT NAME.	01:00 - 01:14 AM
15	WHOLE DAY CODE	Retrofitted from column WHOLE_DAY_CODE of table TIME_SLOT_DIM	No value
16	WHOLE DAY NAME	Retrofitted from column WHOLE_DAY_NAME of table TIME_SLOT_DIM	No value

UMS Access Type

Description: UMS ACCESS TYPE

UMS Access Type Hierarchies

Standard UMS Access Type Hierarchy:

Description of the illustration GUID-743CE3FF-8F27-4602-AF3A-E881C95ECC6E-default.gif

UMS Access Type Levels

Table 3-295 shows UMS Access Type Total: Most aggregate level shows sum of values for all types of UMS access.

Table 3-295 UMS Access Type Total

Sr. Number	Attribute	Description
1.	UMS ACCESS TYPE TOTAL ID	Code for All UMS Access Types

Table 3-296 shows UMS Access Type Detail: The granular level at which data will be captured. The values at this level indicate the actual UMS access types that are used to notify the UMS subscribers.

Table 3-296 UMS Access Type Detail

Sr. Number	Attribute	Description	Sample Value
1	UMS ACCESS TYPE CODE	Code for UMS Access Type.	FAX
2	UMS ACCESS TYPE DESC	Description of the UMS Access Type.	Fax
3	UMS ACCESS TYPE NAME	Short description of the UMS Access Type.	Fax
4	LANGUAGE CODE	Unique identifier for a row in the Language dimension.	No value

Value Added Services (VAS)

Description: VALUE ADDED SERVICE

Value Added Services Hierarchies

Standard Value Added Service Hierarchy:

Description of the illustration GUID-5F04FDAE-4F61-4DA2-9FA8-0BAE0A0D400D-default.gif

Value Added Services Levels

Table 3-297 shows Value Added Service (VAS) Total: All VAS is the most aggregate level of the dimension and is used to see the results for all the services, that is, irrespective of type and individual service.

Table 3-297 Value Added Service Total

Sr. Number	Attribute	Description
1.	VALUE ADDED SERVICE TOTAL CODE	Code for All Value Added Service

Table 3-298 shows Value Added Service (VAS): is the lowest level or the most detail level, at which data related to VAS facts will be captured and stored. The values in this level indicate the actual value added services offered by Service provider

Table 3-298 Value Added Service

Sr. Number	Attribute	Description
1	VALUE ADDED SERVICE TYPE NAME	Short description of the VAS type.
2	VALUE ADDED SERVICE TYPE DESC	Description of the VAS Type.
3	VALUE ADDED SERVICE TYPE CODE	Code for VAS type.
4	VALUE ADDED SERVICE NAME	Short description of the VAS.
5	VALUE ADDED SERVICE DESC	Description of VAS.
6	VALUE ADDED SERVICE CODE	Code or Id for VAS.
7	PRODUCT TYPE CODE	Retrofitted from column PRODUCT_KEY of table FACT_MARKET_SHARE
8	PRODUCT RATING PLAN TYPE CODE	Identifier for the offer.
9	PRODUCT PACKAGE TYPE CODE	Identifier for the offer.
10	PRODUCT PACKAGE CHARGE TYPE CODE	Code.
11	PRODUCT NAME	Product name.
12	PRODUCT GROUP CODE	Unique identifier for Product Group.
13	PRODUCT CODE	Uniquely identifier of product.
14	NETWORK CODE	The network which is used by this platform
15	IN PLATFORM CODE	Code for IN Platform
16	EQUIPMENT FUNCTIONALITY CODE	The code of function
18	EFFECTIVE TO DATE	The end date of the period when this Channel was valid.
19	EFFECTIVE FROM DATE	Standard SCD field, effective from date
20	PROD_DESC	No value