Groups

DIAMETER_CDR

Column Name	Data Type	Field Length	Not Null?	Comments
ID	NUMBER	22	N
CREATE_DATE	DATE	7	Y
STATUS_ID	NUMBER	22	Y	0-New 1-Processed 3-Error
CODE	VARCHAR2	400	Y
RATING_CODE	VARCHAR2	224	Y
RATING_KEY	VARCHAR2	224	Y
REQUEST_TYPE	NUMBER	22	Y
REQUEST_NUMBER	NUMBER	22	Y
SESSION_IDEN	VARCHAR2	4000	Y
CHARGING_IDEN	VARCHAR2	200	Y
IMSI	VARCHAR2	400	Y
MSISDN	VARCHAR2	400	Y
MCC	NUMBER	22	Y
MNC	NUMBER	22	Y
SAC	NUMBER	22	Y
LAC	NUMBER	22	Y
RATING_GROUP	NUMBER	22	Y
TRAFFIC_IN	NUMBER	22	Y
TRAFFIC_OUT	NUMBER	22	Y
TRAFFIC_TOTAL	NUMBER	22	Y
RATE_COUNTRY_ID	NUMBER	22	Y
COMMENTS	VARCHAR2	4000	Y
GEO_LOC_TYPE	NUMBER	22	Y
CI	NUMBER	22	Y
RAC	NUMBER	22	Y
BILLING_RECORD_ID	NUMBER	22	Y
EVENT_TIMESTAMP	DATE	7	Y
REQUESTED_CC_TIME	NUMBER	22	Y
USED_CC_TIME	NUMBER	22	Y
CALLING_PARTY_ADDRESS	VARCHAR2	200	Y
CALLED_PARTY_ADDRESS	VARCHAR2	200	Y
REAL_CALLED_NUMBER	VARCHAR2	200	Y
CONNECT_CALLED_NUMBER	VARCHAR2	200	Y
CHARGE_FLOW_TYPE	NUMBER	22	Y
CALLING_PARTYS_CATEGORY	NUMBER	22	Y
CALLING_VLR_NUMBER	VARCHAR2	200	Y
CALLING_CELL_ID_OR_SAI	VARCHAR2	200	Y
CALLED_VLR_NUMBER	VARCHAR2	200	Y
CALLED_CELL_ID_OR_SAI	VARCHAR2	200	Y
BEARER_CAPABILITY	VARCHAR2	200	Y
REDIRECTING_PARTY_ID	VARCHAR2	200	Y
REDIRECTION_REASON	VARCHAR2	200	Y
CALL_REFERENCE_NUMBER	VARCHAR2	200	Y
MSC_ADDRESS	VARCHAR2	200	Y
SSP_TIME	DATE	7	Y
CALL_FORWARD_INDICATOR	NUMBER	22	Y
TIME_ZONE	NUMBER	22	Y
SMSC_ADDRESS	VARCHAR2	200	Y
SM_ID	VARCHAR2	200	Y
SM_LENGTH	NUMBER	22	Y
MO_MSC_ADDRESS	VARCHAR2	200	Y
MT_MSC_ADDRESS	VARCHAR2	200	Y
SOURCE_ADDRESS	VARCHAR2	200	Y
DESTINATION_ADDRESS	VARCHAR2	200	Y
FEE_ADDRESS	VARCHAR2	200	Y
FEE_FLAG	NUMBER	22	Y
FEE_TYPE	NUMBER	22	Y
STATUS_REPOST_REQUEST	NUMBER	22	Y
SEND_RESULT	NUMBER	22	Y
REQUESTED_CC_TOTAL_OCTETS	NUMBER	22	Y
USED_CC_TOTAL_OCTETS	NUMBER	22	Y
USED_CC_INPUT_OCTETS	NUMBER	22	Y
USED_CC_OUTPUT_OCTETS	NUMBER	22	Y
QOS	VARCHAR2	200	Y
SGSN_ADDRESS	VARCHAR2	200	Y
CALLED_STATION_ID	VARCHAR2	200	Y
SP_ID	VARCHAR2	200	Y
SERVICE_ID	VARCHAR2	200	Y
SERVICE_TYPE	VARCHAR2	200	Y
BEARER_TYPE	NUMBER	22	Y
START_TIME	VARCHAR2	200	Y
BEARER_PROTOCOL_TYPE	NUMBER	22	Y
CHARGING_ID	VARCHAR2	200	Y
TGPP_SGSN_MCC_MNC	VARCHAR2	200	Y
TGPP_USER_LOCATION_INFO	VARCHAR2	200	Y
RECIPIENT_ADDR_TYPE	NUMBER	22	Y
RECIPIENT_ADDR_DATA	VARCHAR2	200	Y
CC_CORRELATION_IDEN	VARCHAR2	200	Y
SERVICE_IDENTIFIER	NUMBER	22	Y
REQUESTED_ACTION	NUMBER	22	Y
CONTENT_PROVIDER_IDEN	VARCHAR2	200	Y
CONTENT_IDEN	VARCHAR2	200	Y
MULTIPLE_SERV_INDICATOR	NUMBER	22	Y
ORIGIN_ADDR_TYPE	NUMBER	22	Y
ORIGIN_ADDR_DATA	VARCHAR2	200	Y
REFUND_INFORMATION	VARCHAR2	200	Y
MESSAGE_IDEN	VARCHAR2	200	Y
ORIGIN_SCCP_ADDR	VARCHAR2	200	Y
MULTIPLE_SERVICES_INDICATOR	NUMBER	22	Y
ORIGINATOR_ADDRESS_TYPE	NUMBER	22	Y
ORIGINATOR_ADDRESS_DATA	VARCHAR2	200	Y
RECIPIENT_ADDRESS_TYPE	NUMBER	22	Y
RECIPIENT_ADDRESS_DATA	VARCHAR2	200	Y
MESSAGE_ID	VARCHAR2	200	Y
CORRELATION_ID	VARCHAR2	200	Y

Browser not supported