Describes the logical dimensions, and hierarchies in the data model.
Lists the logical data model dimensions.
Description: ACCESS METHOD
Access Method Hierarchy
Standard Access Method Hierarchy
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 |
Description: ACCOUNT
Account Hierarchies
Standard ACCOUNT Hierarchy:
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. |
Description: ACCOUNT PAYMENT METHOD STATUS TYPE
Account Payment Method Status Type Hierarchy
Standard Account Payment Method Status Type Hierarchy:
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 |
Description: ACCOUNT REFUND REASON
Account Refund Reason Hierarchies
Standard Account Refund Reason Hierarchy:
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 |
Description: ADDRESS LOCATION
Address Location Hierarchies
Standard Address Location Hierarchy:
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 |
Description: AGE BAND
Age Band Hierarchies
Standard Age Band Hierarchy
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 |
Description: AGE GROUP
AGE GROUP Hierarchies
Standard AGE GROUP Hierarchy:
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 |
Description: AGE ON NET BAND
Age on Net Band Hierarchies
Standard Age On Net Band Hierarchy:
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 |
Description: ARPU BAND
ARPU Band Hierarchies
Standard ARPU Band Hierarchy:
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 |
Description: AGREEMENT CHANGE INITIATOR TYPE
Agreement Change Initiator Type Hierarchies
Standard AGREEMENT CHANGE INITIATOR TYPE Hierarchy:
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 |
Description: AGREEMENT TYPE
Agreement Type Hierarchies
Standard AGREEMENT TYPE Hierarchy:
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 |
Description: BANK DIRECT DEBIT CHANNEL
Bank Direct Debit Channel Hierarchies
Standard Bank Direct Debt Channel Hierarchy:
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 |
Description: BER FER TYPE
Ber Fer Type Hierarchies
Standard Ber Fer Type Hierarchy:
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 |
Description: BILLING CYCLE
Billing Cycle Hierarchies
Standard BILLING CYCLE Hierarchy:
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 |
Description: BILLING STATUS TYPE
Billing Status Type Hierarchies
Standard Billing Status Type Hierarchy:
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 |
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:
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 |
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:
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 Hierarchies
Standard Call Category Hierarchy:
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 |
Description: CALL CENTER AGENT
Call Center Agent Hierarchy
Standard Call Center Agent Hierarchy:
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 |
|
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 |
Description: CALL CENTER CASE TITLE
Call Center Case Title Hierarchies
Standard Call Center Case Title Hierarchy:
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 |
Description: CALL CENTER
Call Center Hierarchies
Standard Call Center Hierarchy:
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 |
Description: CALL DIRECTION
Call Direction Hierarchies
Standard Call Direction Hierarchy:
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 |
Description: CALL OTHER TYPE
Call Other Type Hierarchies
Standard Call Other Type Hierarchy:
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 |
Description: CALL ROUTING TYPE
Call Routing Type Hierarchies
Standard Call Routing Type Hierarchy:
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 |
Description: CALL SERVICE TYPE
Call Service Type Hierarchies
Standard Service Type Hierarchy:
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 |
Description: CALL SOURCE DESTINATION
Call Source Destination Hierarchies
Standard Call Source Destination Hierarchy:
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 |
Description: CALL SUCCESS FAILURE TYPE
Call Successful Fail Hierarchies
Standard Call Success Fail Hierarchy:
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 |
Description: CALL TYPE
Call Type Hierarchies
Standard Call Type Hierarchy:
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 |
Description: CAMPAIGN
Campaign Hierarchies
Standard CAMPAIGN Hierarchy:
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 |
Description: CAMPAIGN CHANNEL
Campaign Channel Hierarchies
Standard Campaign Channel Hierarchy:
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 |
Description: CAMPAIGN MEDIA
Campaign Media Hierarchies
Standard CAMPAIGN MEDIA Hierarchy:
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 |
Description: CELL OUTAGE REASON
Cell Outage Reason Hierarchies
Standard Cell Outage Reason Hierarchy:
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 |
Description: CELL SITE
Cell Site Hierarchies
Standard CELL SITE Hierarchy:
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 |
Description: CHANGE PROPOSED BY TYPE
Change Proposed By Type
Standard CHANGE PROPOSED BY TYPE Hierarchy:
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 |
Description: CHANNEL
Channel Hierarchies
Standard Channel Hierarchy:
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 |
Description: COLLECTION AGENCY
Collection Agency Hierarchies
Standard Collection Agency Hierarchy:
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. |
Description: COMMISSION TYPE
Commission Type Hierarchies
Standard Commission Type Hierarchy:
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 |
Description: COMPETITOR
Competitor Hierarchies
Standard Competitor Hierarchy:
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. |
Description: CONTACT LIST
Contact List Hierarchies
Standard CONTACT LIST Hierarchy:
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 |
Description: CONTENT
Content Hierarchies
Standard CONTENT Hierarchy:
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 |
Description: CONTENT TYPE
Content Type Hierarchies
Standard Content Type Hierarchy:
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 |
Description: AGREEMENT CHANGE INITIATOR TYPE
Contract Change Initiator Type Hierarchies
Standard Contract Change Initiator Type Hierarchy:
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 |
Description: AGREEMENT ASSIGNMENT REASON
Contract Assignment Reason Hierarchies
Standard Contract Assignment Reason Hierarchies:
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 |
Description: COST CENTER
Cost Center Hierarchies
Standard COST CENTER Hierarchy:
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 |
Description: CREDIT CATEGORY
Credit Category Hierarchies
Standard Credit Category Hierarchies:
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 |
Description: CURRENCY
Currency Hierarchies
Standard CURRENCY Hierarchy:
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 |
Description: CUSTOMER
Customer Hierarchies
Standard CUSTOMER Hierarchy:
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 |
Description: CUSTOMER CLUSTER
Customer Cluster Hierarchies
Standard CUSTOMER CLUSTER Hierarchy:
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 |
Description: CUSTOMER REVENUE BAND
Customer Revenue Band Hierarchies
Standard Customer Revenue Band Hierarchies:
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 |
Description: CUSTOMER SEGMENT
Customer Segment Hierarchies
Standard Customer Segment Hierarchies:
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. |
Description: DEALER
Dealer Hierarchies
Standard Dealer Hierarchies:
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. |
Description: DEBT AGING BAND
Debt Aging Band Hierarchies
Standard Debt Aging Band Hierarchy:
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 |
Description: DIRECT DEBIT STATUS REASON
Direct Debit Status Reason Hierarchies
Standard Direct Debt Status Reason Hierarchy:
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 Hierarchies
Standard Divert Retrieve Type Hierarchy:
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 |
Description: EMPLOYEE
Employee Hierarchies
Standard Employee Hierarchy:
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 |
|
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 |
Description: ENVIRONMENT TYPE
Environment Type Hierarchies
Standard ENVIRONMENT TYPE Hierarchy:
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 |
Description: EVENT CATEGORY
Event Category Hierarchies
Standard EVENT CATEGORY Hierarchy:
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 |
Description: EVENT RESULT
Event Result Hierarchies
Standard Event Result Hierarchy:
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 |
Description: EVENT TYPE
Event Type Hierarchies
Standard Event Type Hierarchies:
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 |
Description: EXTERNAL OPERATOR
External Operator Hierarchies
Standard EXTERNAL OPERATOR Hierarchy:
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 |
Description: FRAUD PROFILE CLASS
Fraud Profile Class Hierarchies
Standard Fraud Profile Class Hierarchy:
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 |
Description: GEOGRAPHY ENTITY
Geography Hierarchies
Standard Geography Hierarchy:
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. |
Description: GIVE AWAY TYPE
Give Away Type Hierarchies
Standard Give Away Hierarchy:
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. |
Description: GPRS SERVICE
GRPS Service Hierarchies
Standard GRPS Service Hierarchy:
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 |
Description: HANDSET MODEL
Handset Model Hierarchies
Standard Handset Model Hierarchy:
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 |
Description: IN PLATFORM
IN Platform Hierarchies
Standard IN Platform Hierarchy:
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 |
Description: INITIATIVE TYPE
Initiative Type Hierarchies
Standard Initiative Type Hierarchy:
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. |
Description: INTERACTION CHANNEL
Interaction Channel Hierarchies
Standard Interaction Channel Hierarchy:
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. |
Description: INTERACTION DIRECTION
Interaction Direction Hierarchies
Standard INTERACTION DIRECTION Hierarchy:
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 |
Description: INTERACTION TYPE
Interaction Type Hierarchies
Standard INTERACTION TYPE Hierarchy:
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 |
Description: INVOICE ADJUSTMENT REASON
Invoice Adjustment Reason Hierarchies
Standard Invoice Adjustment Reason Hierarchy:
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 |
Description: INVOICE ADJUSTMENT TYPE
Invoice Adjustment Type Hierarchies
Standard Invoice Adjustment Type Hierarchy:
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 |
Description: INVOICE STATUS
Invoice Status Hierarchies
Standard INVOICE STATUS Hierarchy:
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 |
Description: ISP
ISP Hierarchies
Standard ISP Hierarchy:
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 |
Description: ITEM SUBCLASS
Item Subclass Hierarchies
Standard ITEM SUBCLASS Hierarchy:
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 |
Description: LEGAL PROCESS STATUS TYPE
Legal Process Status Type Hierarchies
Standard Legal Process Status Type Hierarchy:
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. |
Description: LIFECYCLE TYPE
Lifecycle Type Hierarchies
Standard LIFECYCLE TYPE Hierarchy:
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 Hierarchies
Standard Loyalty Program Channel Hierarchy:
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 |
Description: LOYALTY TIER
Loyalty Tier Hierarchies
Standard LOYALTY TIER Hierarchy:
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 |
Description: MARKET AREA
Market Area Hierarchies
Standard Market Area Hierarchy:
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 |
Description: MEDIA OBJECT TYPE
Media Object Type Hierarchies
Standard MEDIA OBJECT TYPE Hierarchy:
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 |
Description: NETWORK
Network Hierarchies
Standard Network Hierarchy:
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 |
Description: NETWORK TOUCHPOINT
Network Touchpoint Hierarchies
Standard NETWORK TOUCHPOINT Hierarchy:
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 |
Description: NETWORK TOUCHPOINT CLASS
Network Touchpoint Class Hierarchies
Standard Network Touchpoint Class Hierarchy:
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 |
Description: NETWORK TOUCHPOINT STATUS
Network Touchpoint Status Hierarchies
Standard Network Touchpoint Status Hierarchy:
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. |
Description: NETWORK TOUCHPOINT TYPE
Network Touchpoint Type Hierarchies
Standard Network Touchpoint Type Hierarchy:
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 |
Description: NETWORK TYPE
Network Type Hierarchies
Standard NETWORK TYPE Hierarchy:
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 |
Description: NOTIFICATION TYPE
Notification Type Hierarchies
Standard Notification Type Hierarchy:
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 |
Description: NP REQUEST TYPE
NP Request Type Hierarchies
Standard NP Request Type Hierarchy:
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 |
Description: ON OFF NET TYPE
On Off Net Type Hierarchies
Standard ON OFF NET TYPE Hierarchy:
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 |
Description: ORDER LINE ITEM STATE
Order Line Item State Hierarchies
Standard ORDER LINE ITEM STATE Hierarchy:
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 |
Description: ORDER STATE
Order State Hierarchies
Standard ORDER STATE Hierarchy:
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 |
Description: ORDER TYPE
Order Type Hierarchies
Standard ORDER TYPE Hierarchy:
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 |
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
Company Hierarchy:
Division Hierarchy:
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 |
Description: PACKET CONTROL UNIT OUTAGE REASON
Packet Control Unit Outage Reason Hierarchies
Standard PACKET CONTROL UNIT OUTAGE REASON Hierarchy:
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 |
Description: PARTNER SETTLEMENT REASON
Partner Settlement Reason Hierarchies
Standard Partner Settlement Reason Hierarchy:
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 |
Description: PARTY
Party Hierarchies
Standard Party Hierarchy:
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 |
Description: PAYMENT CHANNEL.
Payment Channel Hierarchies
Standard Payment Channel Hierarchy:
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 |
Description: PAYMENT METHOD TYPE
Payment Method Type Hierarchies
Standard Payment Method Type Hierarchy:
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 |
Description: PAYMENT TRANSACTION TYPE
Payment Transaction Type Hierarchies
Standard Payment Transaction Type Hierarchy:
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 |
Description: PACKET CONTROL UNIT OUTAGE REASON
PCU Outage Reason Hierarchies
Standard PCU Outage Reason Hierarchy:
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. |
Description: PEAK OFFPEAK TIME
Peak Offpeak Time Hierarchies
Standard Peak Offpeak Time Hierarchy:
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 |
Description: PPA CATEGORY
PPA Category Hierarchies
Standard PPA Category Hierarchy:
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 |
Description: PRODUCT SPECIFICATION
Product Hierarchies
Standard Product Hierarchy:
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 |
Description: PRODUCT SPECIFICATION TYPE
Product Specification Type Hierarchies
Standard PRODUCT SPECIFICATION TYPE Hierarchy:
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 |
Description: PRODUCT SUBSCRIPTION STATUS
Product Subscription Status Hierarchies
Standard PRODUCT SUBSCRIPTION STATUS Hierarchy:
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 |
Description: PRODUCT SUBSCRIPTION TYPE
Product Subscription Type Hierarchies
Standard PRODUCT SUBSCRIPTION TYPE Hierarchy:
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 |
Description: PROMOTION
Promotion Hierarchies
Standard Promotion Hierarchy:
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. |
|
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. |
|
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 |
Description: PROMOTION RESULT TYPE
Promotion Result Hierarchies
Standard Promotion Result Type Hierarchy:
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 |
Description: QUARTER HOUR
Quarter Hour Hierarchies
Standard QUARTER HOUR Hierarchy:
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 |
Description: REASON
Reason Hierarchies
Standard REASON Hierarchy:
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 |
Description: RECHARGE REVENUE SLAB
Recharge Revenue Slab Hierarchies
Standard recharge revenue slab Hierarchy:
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 |
Description: REDEMPTION TYPE
Redemption Type Hierarchies
Standard Redemption Type Hierarchy:
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 |
Description: RETAIL TYPE
Retail Type Hierarchies
Standard RETAIL TYPE Hierarchy:
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 |
Description: RF CARRIER
RF Carrier Hierarchies
Standard RF Carrier Hierarchy:
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 |
Description: ROAMING TYPE
Roaming Type Hierarchies
Standard Roaming Type Hierarchy:
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 |
Description: SALES CHANNEL
Sales Channel Hierarchy
Standard Sales Channel Hierarchy:
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 |
Description: SALES CHANNEL REPRESENTATIVE
Sales Channel Hierarchies
Standard Sales Channel Representative Hierarchy:
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 |
|
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 |
Description: SCRIPT
Script Hierarchies
Standard SCRIPT Hierarchy:
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. |
Description: SERVICE COVERAGE AREA
Service Coverage Hierarchies
Standard Service Coverage Hierarchy:
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 |
Description: SKU ITEM
SKU Item Hierarchies
Standard SKU ITEM Hierarchy:
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 |
Description: SPNM OTHER PARTY NUMBER
SPNM Other Party Number Hierarchies
Standard SPNM OTHER PARTY NUMBER Hierarchy:
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 |
Description: SUBSIDY TYPE
Subsidy Type Hierarchies
Standard Subsidy Type Hierarchy:
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 |
Description: SWITCH
Switch Hierarchies
Standard Switch Hierarchy:
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 |
Description: TECHNOLOGY TYPE
Technology Type Hierarchies
Standard Technology Type Hierarchy:
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 |
Description: TENDER
Tender Hierarchies
Standard TENDER Hierarchy:
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 |
Description: TIME SLOT
Time Slot Hierarchies
Standard Time Slot Hierarchy:
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 |
Description: UMS ACCESS TYPE
UMS Access Type Hierarchies
Standard UMS Access Type Hierarchy:
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 |
Description: VALUE ADDED SERVICE
Value Added Services Hierarchies
Standard Value Added Service Hierarchy:
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 |