DIAMETER_CDR

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