|
|
|
|
|
|
Each tuple in the fact table represents a summary of the CDR records generated at tje switch for each customer.
Field Name |
Data Type |
Description/Example |
Date_Key |
Integer |
Call Date. Foreign Key, references Date table key |
Plan_Key |
Integer |
Foreign Key, references Rate_Plan table key |
Calling_Number_key |
Integer |
Calling party number. Foreign Key, references Number table key |
Called_Number_Key |
Integer |
Called party location. Foreign Key, references Number table key |
Cust_Key |
Integer |
Calling Party customer id, who will be billed for the call and services. Foreign Key, references Customer_Details table key |
Feature_key |
Integer |
Foreign Key, references Feature table key |
Termination_key |
Integer |
Call Termination Type i.e. normal or abnormal |
Equipment_Key |
Integer |
Type of Equipment |
Roaming_Flag |
Bool |
Whether this call is made/recd while roaming |
Call_Duration |
timestamp |
Duration of the call |
Number_of_Calls |
Integer |
Total number of calls made during the day |
Total_Minutes |
Integer |
Total number of minutes of calls made that day |
Total_Roaming_Minutes |
Integer |
Total number of roaming minutes used |
Total_Long_Distance_Minutes |
Integer |
Total number of long distance calls made. |
Total_Call_Cost |
Float |
Total cost of all the call |
Total_Roaming_Cost |
Float |
Total roaming charges |
Total_Long_Distance_Cost |
Float |
Total Long Distance charges |
Service_tax |
Float |
Service tax |
Surcharge |
Float |
Surcharge |