Search TipsSubscription Analytics
Data is only considered up to midnight of the previous day. This is to ensure a common cut-off date across all Data Warehouse output.
|
Column Heading |
Unique? |
Type |
Length |
Details |
|---|---|---|---|---|
|
Subscription Number |
Y |
Numeric |
8,0 |
CMP Subscription Number |
|
User Name |
|
Alphanumeric |
50,0 |
CMP Subscription Username |
|
Account Number |
|
Numeric |
8,0 |
CMP Account Number |
|
Company Number |
|
Alphanumeric |
3 |
CMP Company Number |
|
Agreement Number |
|
Numeric |
8,0 |
CMP Agreement Number |
|
Group Code |
|
Alphanumeric |
6,0 |
CMP Group Code |
| Group Description | Alphanumeric | 30,0 | Text description of the CMP Group Code | |
|
Corporate Code |
|
Alphanumeric |
6,0 |
CMP Corporate Code |
| Corporate Description | Alphanumeric | 30,0 | Text description of the Corporate Code | |
|
Price Plan Code |
|
Alphanumeric |
6,0 |
CMP Price Plan Code associated with the subscription, for example, PAYG |
| Price Plan Description | Alphanumeric | 30,0 | Text description of the Price Plan Code associated with the subscription, for example, Pay As You Go Plan | |
|
Tariff Code |
|
Alphanumeric |
6,0 |
CMP Tariff Code associated with the subscription |
| Tariff Description | Alphanumeric | 30,0 | Text description of the Tariff Code associated with the subscription | |
|
Package Code |
|
Alphanumeric |
6,0 |
CMP Package Code associated with the subscription , for example, PAYG |
| Package Description | Alphanumeric | 30,0 | Text description of the Package Code associated with the subscription, e.g. Pay As You Go Base Package | |
|
Network Code |
|
Alphanumeric |
6,0 |
CMP Network Code for network associated with the subscription |
| Network Description | Alphanumeric | 30,0 | Text description of the CMP Network Code associated with the subscription | |
|
Network Serial Number 1 |
|
Alphanumeric |
25 |
As stored in CMP. Typically a mobile number or landline CLI as stored in Managed Serial Number 1 |
|
Network Serial Number 2 |
|
Alphanumeric |
25 |
This value varies by CMP implementation/environment. In mobile implementations this is typically a SIM related serial number |
|
Network Serial Number 3 |
|
Alphanumeric |
25 |
This value varies by CMP implementation/environment. In mobile implementations this is typically a SIM related serial number |
|
Network Serial Number 4 |
|
Alphanumeric |
25 |
This value varies by CMP implementation/environment. In mobile implementations this is typically a SIM related serial number |
|
Network Serial Number 5 |
|
Alphanumeric |
25 |
This value varies by CMP implementation/environment |
| Delivery Address Name | Alphanumeric | 40 | The name for the delivery address in CMP | |
|
Address Line 1 |
|
Alphanumeric |
40 |
As stored in CMP |
|
Address Line 2 |
|
Alphanumeric |
40 |
As stored in CMP |
|
Address Line 3 |
|
Alphanumeric |
40 |
As stored in CMP |
|
Address Line 4 |
|
Alphanumeric |
40 |
As stored in CMP |
|
Address Line 5 |
|
Alphanumeric |
40 |
As stored in CMP |
|
Post Code |
|
Alphanumeric |
10 |
As stored in CMP |
|
Connected Date |
|
Numeric |
25,0 |
Date Connected in CMP. YYYY-MM-DD format |
|
Disconnected Date |
|
Numeric |
25,0 |
Date Disconnected in CMP. YYYY-MM-DD format. "0" if not disconnected |
|
Subscription Status |
|
Alphanumeric |
6,0 |
First, Normal, Final |
|
Connected Reason |
|
Alphanumeric |
4,0 |
Reason the Sub was Connected (Code), for example, CR |
|
Connected Reason Description |
|
Alphanumeric |
30,0 |
Reason the Sub was Connected (Text Description), for example, Customer Request |
|
Disconnection Reason |
|
Alphanumeric |
4,0 |
Reason the Sub was Disconnected (Code) |
|
Disconnection Reason Description |
|
Alphanumeric |
30,0 |
Reason the Sub was Disconnected (Description) |
|
Contract Start Date |
|
Numeric |
25,0 |
Contract Start Date in CMP. YYYY-MM-DD format |
| Contract Expiry Date |
Numeric |
25,0 |
Contract Start Date in CMP. YYYY-MM-DD format |
|
|
Contract Term |
|
Numeric |
3,0 |
Contract term (months) |
|
Contract Number |
|
Alphanumeric |
12 |
Contract Number for Agreement |
|
Date of Birth |
|
Numeric |
25,0 |
YYYY-MM-DD format |
|
Date Time Created |
|
Numeric |
25,0 |
Date record created in CMP. YYYY-MM-DD HH:MM:SS format |
|
Created By |
|
Alphanumeric |
10 |
User ID of user who created the record |
|
Date Time Changed |
|
Numeric |
25,0 |
Date record changed in CMP. YYYY-MM-DD HH:MM:SS format |
|
Changed By |
|
Alphanumeric |
10 |
User ID of user who last changed the record |
|
Salesperson Number |
|
Numeric |
8,0 |
Numeric ID of the salesperson who processed the purchase |
| Salesperson Name | Alphanumeric | 50, 0 | The name of the salesperson | |
|
Data Extract Date |
|
Numeric |
7,0 |
Date that the data above was extracted from CMP. YYYY-MM-DD format |