877.245.5629
sales@billmax.com
|
BillMax Billing Solutions 877.245.5629 sales@billmax.com |
| datacall table | ||
|---|---|---|
 |
Chapter 3. Database Schema | 
|
datacall table — table for Datacall data
The defaults listed below are not relevant. The data comes from the RADIUS data.
| Name | Description |
Data Type |
|---|---|---|
| Name | Description |
Data Type |
| bauddown | The data transfer speed of traffic to the customer's modem. |
int(11) |
| baudup | The data transfer speed of traffic from the customer's modem. |
int(11) |
| bytesin | The number of bytes downloaded to the customer's modem. |
int(11) unsigned |
| bytesout | The number of bytes uploaded to the customer's modem. |
int(11) unsigned |
| callerid | The number from which the customer is calling. |
char(15) |
| callnum | A unique identifier for the customer session. |
char(15) |
| delaytime | The delaytime of either the stop or start record (the last one received) for the current session. |
int(11) |
| disconnect | A description indicating why a session was terminated. |
char(30) |
| dnis | The number the customer's modem called. |
char(12) |
| enddate | The date a stop record is received for the session indicating session termination. This value is adjusted by accompanying delaytime. |
date |
| endtime | The time a stop record is received for the session indicating session termination. This value is adjusted by accompanying delaytime. |
time |
| expires | If populated, the UNIX time in seconds for terminating the session. This is used by radmond to schedule a termination job for this session. |
int(11) |
| gigabytesin | The number of gigabytes downloaded to the customer's modem. |
int(11) |
| gigabytesout | The number of gigabytes uploaded to the customer's modem. |
int(11) |
| job | If populated, the at job number of the termination job created by radmond. |
int(11) |
| length | The length of the session in seconds. |
int(11) |
| mlid | The identifier of a multilink bundle when one of the multilink sessions closes. Populated when a stop record is received. |
int(11) |
| mlnum | The number of sessions remaining in a multilink bundle when a session closes. Populated when a stop record is received. |
int(11) |
| pktin | The number of data packets transferred to the customer's modem. |
int(11) |
| pktout | The number of data packets transferred from the customer's modem. |
int(11) |
| port | The NAS port. |
int(11) |
| progress | The state of the connection before disconnection. Populated when a stop record received. |
char(30) |
| protocol | The Framed protocol (PPP, SLP, etc.). |
int(11) |
| service | The number of service.number for the Service that is provisioned/billed for the current session. |
int(11) |
| shelf | The shelf number of the terminal server modem. |
int(11) |
| slot | The slot number of the terminal server modem. |
int(11) |
| startdate | The date a start record is received for the beginning of a session. This value is adjusted by accompanying delaytime. |
date |
| starttime | The time a start record is received for the beginning of a session. This value is adjusted by accompanying delaytime. |
time |
| status |
Indicates whether the last record received for the session was a start, stop or interim record.
|
int(11) |
| termip | The IP address of the terminal into which the customer has dialed. |
char(15) |
| userip | The IP address of the customer's connection. |
char(15) |
| username | The username supplied by the customer when logging in. |
char(100) |
Relevant Interfaces
Library Routines
Command Line Routines
| radiusd |
| radparse |
| report_datacall |
CGI Routines - NONE
Web Forms - Datacall Forms
|
|
 |
|
| customsql table |  |
datatopop table |