Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 2 Current »

Groups

DIAMETER_CDR

Col #Column NameData TypeField LengthNot Null?Data Def.Comments
1

ID

NUMBER

22

N

  
2

CREATE_DATE

DATE

7

Y

  
3

STATUS_ID

NUMBER

22

Y

 

0-New

1-Processed

3-Error

4

CODE

VARCHAR2

400

Y

  
5

RATING_CODE

VARCHAR2

224

Y

  
6

RATING_KEY

VARCHAR2

224

Y

  
7

REQUEST_TYPE

NUMBER

22

Y

  
8

REQUEST_NUMBER

NUMBER

22

Y

  
9

SESSION_IDEN

VARCHAR2

4000

Y

  
10

CHARGING_IDEN

VARCHAR2

200

Y

  
11

IMSI

VARCHAR2

400

Y

  
12

MSISDN

VARCHAR2

400

Y

  
13

MCC

NUMBER

22

Y

  
14

MNC

NUMBER

22

Y

  
15

SAC

NUMBER

22

Y

  
16

LAC

NUMBER

22

Y

  
17

RATING_GROUP

NUMBER

22

Y

  
18

TRAFFIC_IN

NUMBER

22

Y

  
19

TRAFFIC_OUT

NUMBER

22

Y

  
20

TRAFFIC_TOTAL

NUMBER

22

Y

  
21

RATE_COUNTRY_ID

NUMBER

22

Y

  
22

COMMENTS

VARCHAR2

4000

Y

  
23

GEO_LOC_TYPE

NUMBER

22

Y

  
24

CI

NUMBER

22

Y

  
25

RAC

NUMBER

22

Y

  
26

BILLING_RECORD_ID

NUMBER

22

Y

  
27

EVENT_TIMESTAMP

DATE

7

Y

  
28

REQUESTED_CC_TIME

NUMBER

22

Y

  
29

USED_CC_TIME

NUMBER

22

Y

  
30

CALLING_PARTY_ADDRESS

VARCHAR2

200

Y

  
31

CALLED_PARTY_ADDRESS

VARCHAR2

200

Y

  
32

REAL_CALLED_NUMBER

VARCHAR2

200

Y

  
33

CONNECT_CALLED_NUMBER

VARCHAR2

200

Y

  
34

CHARGE_FLOW_TYPE

NUMBER

22

Y

  
35

CALLING_PARTYS_CATEGORY

NUMBER

22

Y

  
36

CALLING_VLR_NUMBER

VARCHAR2

200

Y

  
37

CALLING_CELL_ID_OR_SAI

VARCHAR2

200

Y

  
38

CALLED_VLR_NUMBER

VARCHAR2

200

Y

  
39

CALLED_CELL_ID_OR_SAI

VARCHAR2

200

Y

  
40

BEARER_CAPABILITY

VARCHAR2

200

Y

  
41

REDIRECTING_PARTY_ID

VARCHAR2

200

Y

  
42

REDIRECTION_REASON

VARCHAR2

200

Y

  
43

CALL_REFERENCE_NUMBER

VARCHAR2

200

Y

  
44

MSC_ADDRESS

VARCHAR2

200

Y

  
45

SSP_TIME

DATE

7

Y

  
46

CALL_FORWARD_INDICATOR

NUMBER

22

Y

  
47

TIME_ZONE

NUMBER

22

Y

  
48

SMSC_ADDRESS

VARCHAR2

200

Y

  
49

SM_ID

VARCHAR2

200

Y

  
50

SM_LENGTH

NUMBER

22

Y

  
51

MO_MSC_ADDRESS

VARCHAR2

200

Y

  
52

MT_MSC_ADDRESS

VARCHAR2

200

Y

  
53

SOURCE_ADDRESS

VARCHAR2

200

Y

  
54

DESTINATION_ADDRESS

VARCHAR2

200

Y

  
55

FEE_ADDRESS

VARCHAR2

200

Y

  
56

FEE_FLAG

NUMBER

22

Y

  
57

FEE_TYPE

NUMBER

22

Y

  
58

STATUS_REPOST_REQUEST

NUMBER

22

Y

  
59

SEND_RESULT

NUMBER

22

Y

  
60

REQUESTED_CC_TOTAL_OCTETS

NUMBER

22

Y

  
61

USED_CC_TOTAL_OCTETS

NUMBER

22

Y

  
62

USED_CC_INPUT_OCTETS

NUMBER

22

Y

  
63

USED_CC_OUTPUT_OCTETS

NUMBER

22

Y

  
64

QOS

VARCHAR2

200

Y

  
65

SGSN_ADDRESS

VARCHAR2

200

Y

  
66

CALLED_STATION_ID

VARCHAR2

200

Y

  
67

SP_ID

VARCHAR2

200

Y

  
68

SERVICE_ID

VARCHAR2

200

Y

  
69

SERVICE_TYPE

VARCHAR2

200

Y

  
70

BEARER_TYPE

NUMBER

22

Y

  
71

START_TIME

VARCHAR2

200

Y

  
72

BEARER_PROTOCOL_TYPE

NUMBER

22

Y

  
73

CHARGING_ID

VARCHAR2

200

Y

  
74

TGPP_SGSN_MCC_MNC

VARCHAR2

200

Y

  
75

TGPP_USER_LOCATION_INFO

VARCHAR2

200

Y

  
76

RECIPIENT_ADDR_TYPE

NUMBER

22

Y

  
77

RECIPIENT_ADDR_DATA

VARCHAR2

200

Y

  
78

CC_CORRELATION_IDEN

VARCHAR2

200

Y

  
79

SERVICE_IDENTIFIER

NUMBER

22

Y

  
80

REQUESTED_ACTION

NUMBER

22

Y

  
81

CONTENT_PROVIDER_IDEN

VARCHAR2

200

Y

  
82

CONTENT_IDEN

VARCHAR2

200

Y

  
83

MULTIPLE_SERV_INDICATOR

NUMBER

22

Y

  
84

ORIGIN_ADDR_TYPE

NUMBER

22

Y

  
85

ORIGIN_ADDR_DATA

VARCHAR2

200

Y

  
85

REFUND_INFORMATION

VARCHAR2

200

Y

  
86

MESSAGE_IDEN

VARCHAR2

200

Y

  
87

ORIGIN_SCCP_ADDR

VARCHAR2

200

Y

  
88

MULTIPLE_SERVICES_INDICATOR

NUMBER

22

Y

  
89

ORIGINATOR_ADDRESS_TYPE

NUMBER

22

Y

  
90

ORIGINATOR_ADDRESS_DATA

VARCHAR2

200

Y

  
91

RECIPIENT_ADDRESS_TYPE

NUMBER

22

Y

  
92

RECIPIENT_ADDRESS_DATA

VARCHAR2

200

Y

  
93

MESSAGE_ID

VARCHAR2

200

Y

  
94

CORRELATION_ID

VARCHAR2

200

Y

  

 

 

  • No labels