B Comma-Delimited Entries for Local Files
Local File Format
This section contains two example tables that show where, in locally-generated CSV files, specific VSAs may appear. The first table is for an Interim CDR to a successful call; the second is for an SMS event. The user can produce the formats of local CDRs based on their configuration using the dump_csv_format command, documented in the Configuring Accounting chapter.
For more information about this feature and how to enable it, refer to the Local CDR Storage and FTP Push section in this guide’s Configuring Accounting chapter. Note that the Acme-CDR-Sequence-Number, VSA ID 59, appears in local CDR files when both file-output is enabled and an account server is configured.
Interim Record CSV Placement
The following ordered list of attributes is an example of a CSV when you have configured for output-inclusive.
cdr-output-inclusive enabled| CSV Placement | Attribute Name | VSA ID Number |
|---|---|---|
| 1 | Acct-Status-Type | N/A |
| 2 | NAS-IP-Address | N/A |
| 3 | NAS-Port | N/A |
| 4 | Acct-Session-Id | N/A |
| 5 | Acme-Session-Ingress-CallId | 3 |
| 6 | Acme-Session-Egress-CallId | 4 |
| 7 | Acme-Session-Protocol-Type | 43 |
| 8 | Acme-Session-Forked-Call-Id | 171 |
| 9 | Acme-Session-Generic-Id | 40 |
| 10 | Calling-Station-Id | N/A |
| 11 | Called-Station-Id | N/A |
| 12 | h323-setup-time | N/A |
| 13 | h323-connect-time | N/A |
| 14 | Acme-Egress-Network-Interface-Id | 139 |
| 15 | Acme-Egress-Vlan-Tag-Value | 140 |
| 16 | Acme-Ingress-Network-Interface-Id | 137 |
| 17 | Acme-Ingress-Vlan-Tag-Value | 138 |
| 18 | Acme-Session-Egress-Realm | 42 |
| 19 | Acme-Session-Ingress-Realm | 41 |
| 20 | Acme-FlowId_FS1_F | 1 |
| 21 | Acme-FlowType_FS1_f | 2 |
| 22 | Acme-Flow-In-Realm_FS1_f | 10 |
| 23 | Acme-Flow-In-Src-Addr_FS1_F | 11 |
| 24 | Acme-Flow-In-Src-Port_FS1_F | 12 |
| 25 | Acme-Flow-In-Dst-Addr_FS1_F | 13 |
| 26 | Acme-Flow-In-Dst-Port_FS1_F | 14 |
| 27 | Acme-Flow-Out-Realm_FS1_F | 20 |
| 28 | Acme-Flow-Out-Src-Addr_FS1_F | 21 |
| 29 | Acme-Flow-Out-Src-Port_FS1_F | 22 |
| 30 | Acme-Flow-Out-Dst-Addr_FS1_F | 23 |
| 31 | Acme-Flow-Out-Dst-Port_FS1_F | 24 |
| 32 | Acme-Calling-RTCP-Packets-Lost_FS1 | 32 |
| 33 | Acme-Calling-RTCP-Avg-Jitter_FS1 | 33 |
| 34 | Acme-Calling-RTCP-Avg-Latency_FS1 | 34 |
| 35 | Acme-Calling-RTCP-MaxJitter_FS1 | 35 |
| 36 | Acme-Calling-RTCP-MaxLatency_FS1 | 36 |
| 37 | Acme-Calling-RTP-Packets-Lost_FS1 | 37 |
| 38 | Acme-Calling-RTP-Avg-Jitter_FS1 | 38 |
| 39 | Acme-Calling-RTP-MaxJitter_FS1 | 39 |
| 40 | Acme-Calling-Octets_FS1 | 28 |
| 41 | Acme-Calling-Packets_FS1 | 29 |
| 42 | Acme-Calling-R-Factor | 151 |
| 43 | Acme-Calling-MOS | 152 |
| 44 | Acme-FlowID_FS1_R | 78 |
| 45 | Acme-FlowType_FS1_R | 79 |
| 46 | Acme-Flow-In-Realm_FS1_R | 80 |
| 47 | Acme-Flow-In-Src-Addr_FS1_R | 81 |
| 48 | Acme-Flow-In-Src-Port_FS1_R | 82 |
| 49 | Acme-Flow-In-Dst-Addr_FS1_R | 83 |
| 50 | Acme-Flow-In-Dst-Port_FS1_R | 84 |
| 51 | Acme-Flow-Out-Realm_FS1_R | 85 |
| 52 | Acme-Flow-Out-Src-Addr_FS1_R | 86 |
| 53 | Acme-Flow-Out-Src-Port_FS1_R | 87 |
| 54 | Acme-Flow-Out-Dst-Addr_FS1_R | 88 |
| 55 | Acme-Flow-Out-Dst-Port_FS1_R | 89 |
| 56 | Acme-Called-RTCP-Packets-Lost_FS1 | 46 |
| 57 | Acme-Called-RTCP-Avg-Jitter_FS1 | 47 |
| 58 | Acme-Called-RTCP-Avg-Latency_FS1 | 48 |
| 59 | Acme-Called-RTCP-MaxJitter_FS1 | 49 |
| 60 | Acme-Called-RTCP-MaxLatency_FS1 | 50 |
| 61 | Acme-Called-RTP-Packets-Lost_FS1 | 51 |
| 62 | Acme-Called-RTP-Avg-Jitter_FS1 | 52 |
| 63 | Acme-Called-RTP-MaxJitter_FS1 | 53 |
| 64 | Acme-Called-Octets_FS1 | 44 |
| 65 | Acme-Called-Packets_FS1 | 45 |
| 66 | Acme-Called-R-Factor | 153 |
| 67 | Acme-Called-MOS | 154 |
| 68 | Acme-FlowID_FS2_F | 90 |
| 69 | Acme-FlowType_FS2_F | 91 |
| 70 | Acme-Flow-In-Realm_FS2_F | 92 |
| 71 | Acme-Flow-In-Src-Addr_FS2_F | 93 |
| 72 | Acme-Flow-In-Src-Port_FS2_F | 94 |
| 73 | Acme-Flow-In-Dst-Addr_FS2_F | 95 |
| 74 | Acme-Flow-In-Dst-Port_FS2_F | 96 |
| 75 | Acme-Flow-Out-Realm_FS2_F | 97 |
| 76 | Acme-Flow-Out-Src-Addr_FS2_F | 98 |
| 77 | Acme-Flow-Out-Src-Port_FS2_F | 99 |
| 78 | Acme-Flow-Out-Dst-Addr_FS2_F | 100 |
| 79 | Acme-Flow-Out-Dst-Port_FS2_F | 101 |
| 80 | Acme-Calling-RTCP-Packets-Lost_FS2 | 104 |
| 81 | Acme-Calling-RTCP-Avg-Jitter_FS2 | 105 |
| 82 | Acme-Calling-RTCP-Avg-Latency_FS2 | 107 |
| 83 | Acme-Calling-RTCP-MaxJitter_FS2 | 107 |
| 84 | Acme-Calling-RTCP-MaxLatency_FS2 | 108 |
| 85 | Acme-Calling-RTP-Packets-Lost_FS2 | 109 |
| 86 | Acme-Calling-RTP-Avg-Jitter_FS2 | 110 |
| 87 | Acme-Calling-RTP-MaxJitter_FS2 | 111 |
| 88 | Acme-Calling-Octets_FS2 | 102 |
| 89 | Acme-Calling-Packets_FS2 | 103 |
| 90 | Acme-FlowID_FS2_R | 112 |
| 91 | Acme-FlowType_FS2_R | 113 |
| 92 | Acme-Flow-In-Realm_FS2_R | 114 |
| 93 | Acme-Flow-In-Src-Addr_FS2_R | 115 |
| 94 | Acme-Flow-In-Src-Port_FS2_R | 116 |
| 95 | Acme-Flow-In-Dst-Addr_FS2_R | 117 |
| 96 | Acme-Flow-In-Dst-Port_FS2_R | 118 |
| 97 | Acme-Flow-Out-Realm_FS2_R | 119 |
| 98 | Acme-Flow-Out-Src-Addr_FS2_R | 120 |
| 99 | Acme-Flow-Out-Src-Port_FS2_R | 121 |
| 100 | Acme-Flow-Out-Dst-Addr_FS2_R | 122 |
| 101 | Acme-Flow-Out-Dst-Port_FS2_R | 123 |
| 102 | Acme-Called-RTCP-Packets-Lost_FS2 | 126 |
| 103 | Acme-Called--RTCP-Avg-Jitter_FS2 | 127 |
| 104 | Acme-Called--RTCP-Avg-Latency_FS2 | 128 |
| 105 | Acme-Called--RTCP-MaxJitter_FS2 | 129 |
| 106 | Acme-Called-RTCP-MaxLatency_FS2 | 130 |
| 107 | Acme-Called-RTP-Packets-Lost_FS2 | 131 |
| 108 | Acme-Called-RTP-Avg-Jitter_FS2 | 132 |
| 109 | Acme-Called-RTP-MaxJitter_FS2 | 133 |
| 110 | Acme-Called-Octets_FS2 | 124 |
| 111 | Acme-Called-Packets_FS2 | 125 |
| 112 | Acme-Session-Charging-Vector | 54 |
| 113 | Acme-Session-Charging-Function_Address | 55 |
| 114 | Acme-Firmware-Version | 56 |
| 115 | Acme-Local-Time-Zone | 57 |
| 116 | Acme-Post-Dial-Delay | 58 |
| 117 | Acme-Primary-Routing-Number | 64 |
| 118 | Acme-Originating-Trunk-Group | 65 |
| 119 | Acme-Terminating-Trunk-Group | 66 |
| 120 | Acme-Originating-Trunk-Context | 67 |
| 121 | Acme-Terminating-Trunk-Context | 68 |
| 122 | Acme-P-Asserted-ID | 69 |
| 123 | Acme-Ingress-Local-Addr | 74 |
| 124 | Acme-Ingress-Remote-Addr | 75 |
| 125 | Acme-Egress-Local-Addr | 76 |
| 126 | Acme-Egress-Remote-Addr | 77 |
| 127 | Acme-SIP-Diversion | 70 |
| 128 | Acme-Intermediate_Time | 63 |
| 129 | Acct-Session-Time | N/A |
| 130 | Acme-Egress-Final-Routing-Number | 134 |
| 131 | Acme-Session-Ingress-RPH | 135 |
| 132 | Acme-Session-Egress-RPH | 136 |
| 133 | Acme-Custom-VSA-200 | 200 |
| 134 | Acme-Custom-VSA-201 | 201 |
| 135 | Acme-Custom-VSA-202 | 202 |
| 136 | Acme-Custom-VSA-203 | 203 |
| 137 | Acme-Custom-VSA-204 | 204 |
| 138 | Acme-Custom-VSA-205 | 205 |
| 139 | Acme-Custom-VSA-206 | 206 |
| 140 | Acme-Custom-VSA-207 | 207 |
| 141 | Acme-Custom-VSA-208 | 208 |
| 142 | Acme-Custom-VSA-209 | 209 |
| 143 | Acme-Custom-VSA-210 | 210 |
| 144 | Acme-Custom-VSA-211 | 211 |
| 145 | Acme-Custom-VSA-212 | 212 |
| 146 | Acme-Custom-VSA-213 | 213 |
| 147 | Acme-Custom-VSA-214 | 214 |
| 148 | Acme-Custom-VSA-215 | 215 |
| 149 | Acme-Custom-VSA-216 | 216 |
| 150 | Acme-Custom-VSA-217 | 217 |
| 151 | Acme-Custom-VSA-218 | 218 |
| 152 | Acme-Custom-VSA-219 | 219 |
| 153 | Acme-Custom-VSA-220 | 220 |
| 154 | Acme-Custom-VSA-221 | 221 |
| 155 | Acme-Custom-VSA-222 | 222 |
| 156 | Acme-Custom-VSA-223 | 223 |
| 157 | Acme-Custom-VSA-224 | 224 |
| 158 | Acme-Custom-VSA-225 | 225 |
| 159 | Acme-Custom-VSA-226 | 226 |
| 160 | Acme-Custom-VSA-227 | 227 |
| 161 | Acme-Custom-VSA-228 | 228 |
| 162 | Acme-Custom-VSA-229 | 229 |
| 163 | Acme-Custom-VSA-230 | 230 |
| 164 | Acme-Flow-Calling-Media-Stop-Time_FS1 | 231 |
| 165 | Acme-Flow-Called-Media-Stop-Time_FS1 | 232 |
| 166 | Acme-Flow-Calling-Media-Stop-Time_FS2 | 233 |
| 167 | Acme-Flow-Called-Media-Stop-Time_FS2 | 234 |
| 168 | Acme-FlowMediaType_FS1_F | 142 |
| 169 | Acme-FlowMediaType_FS1_R | 143 |
| 170 | Acme-FlowMediaType_FS2_F | 144 |
| 171 | Acme-FlowMediaType_FS2_R | 145 |
| 172 |
PGW-IP Address |
249 |
| 173 | SGW-IP Address | 249 |
| 174 | ORIG-IOI | 249 |
| 175 | TERM-IOI | 249 |
| 176 | IMEI | 249 |
| 177 | Node Functionality | 249 |
| 178 | History Info | 250 |
| 179 | P-Visited Network ID | 251 |
| 180 | IMSI | 252 |
| 181 | ACME-Access-Network-Information | 248 |
| 182 | Acme-CDR-Sequence-Number | 59 |
SMS Event CSV Order
The OCSBC creates an Event CSV file for SMS messages when the generate-event = message parameter is enabled. The following table shows the inclusive CSV element order, when protocol = RADIUS (or protocol=default).
CSV placement is similar to other event CDRs, but includes message specific attributes.
| CSV Placement | Attribute Name | Vendor ID | RADIUS IE |
|---|---|---|---|
| CSV Placement | Attribute Name | Vendor ID | RADIUS IE |
| 1 | "Accounting Status" | 40 | |
| 2 | "NAS IP Address" | 4 | |
| 3 | "NAS Port" | 5 | |
| 4 | "Accounting Session ID" | 44 | |
| 5 | "Ingress Session ID" | ACME | 3 |
| 6 | "Egress Session ID" | ACME | 4 |
| 7 | "Session Protocol Type" | ACME | 43 |
| 8 | "Session-Forked-Call-Id" | ACME | 171 |
| 9 | "Generic ID" | ACME | 40 |
| 10 | "Calling Station ID" | 31 | |
| 11 | "Called Station ID" | 30 | |
| 12 | "Egress Network Interface ID " | ACME | 139 |
| 13 | "Egress Vlan Tag Value " | ACME | 140 |
| 14 | "Ingress Network Interface ID " | ACME | 137 |
| 15 | "Ingress Vlan Tag Value " | ACME | 138 |
| 16 | "Cisco Setup Time" | CISCO | 25 |
| 17 | "Cisco Connect Time" | CISCO | 28 |
| 18 | "Custom VSA 200" | ACME | 200 |
| 19 | "Custom VSA 201" | ACME | 201 |
| 20 | "Custom VSA 202" | ACME | 202 |
| 21 | "Custom VSA 203" | ACME | 203 |
| 22 | "Custom VSA 204" | ACME | 204 |
| 23 | "Custom VSA 205" | ACME | 205 |
| 24 | "Custom VSA 206" | ACME | 206 |
| 25 | "Custom VSA 207" | ACME | 207 |
| 26 | "Custom VSA 208" | ACME | 208 |
| 27 | "Custom VSA 209" | ACME | 209 |
| 28 | "Custom VSA 210" | ACME | 210 |
| 29 | "Custom VSA 211" | ACME | 211 |
| 30 | "Custom VSA 212" | ACME | 212 |
| 31 | "Custom VSA 213" | ACME | 213 |
| 32 | "Custom VSA 214" | ACME | 214 |
| 33 | "Custom VSA 215" | ACME | 215 |
| 34 | "Custom VSA 216" | ACME | 216 |
| 35 | "Custom VSA 217" | ACME | 217 |
| 36 | "Custom VSA 218" | ACME | 218 |
| 37 | "Custom VSA 219" | ACME | 219 |
| 38 | "Custom VSA 220" | ACME | 220 |
| 39 | "Custom VSA 221" | ACME | 221 |
| 40 | "Custom VSA 222" | ACME | 222 |
| 41 | "Custom VSA 223" | ACME | 223 |
| 42 | "Custom VSA 224" | ACME | 224 |
| 43 | "Custom VSA 225" | ACME | 225 |
| 44 | "Custom VSA 226" | ACME | 226 |
| 45 | "Custom VSA 227" | ACME | 227 |
| 46 | "Custom VSA 228" | ACME | 228 |
| 47 | "Custom VSA 229" | ACME | 229 |
| 48 | "Custom VSA 230" | ACME | 230 |
| 49 | "PGW-IP Address" | ACME | 249 |
| 50 | "SGW-IP Address" | ACME | 249 |
| 51 | "ORIG-IOI" | ACME | 249 |
| 52 | "TERM-IOI" | ACME | 249 |
| 53 | "IMEI" | ACME | 249 |
| 54 | "Node Functionality" | ACME | 249 |
| 55 | "Sms-Msg-Type" | ACME | 249 |
| 56 | "Sms-Calling-Party-Number" | ACME | 249 |
| 57 | "Sms-Called-Party-Number" | ACME | 249 |
| 58 | "Sms-Msg-length" | ACME | 249 |
| 59 | "P-Visited Network ID" | ACME | 251 |
| 60 | "IMSI" | ACME | 252 |
| 61 | "Access-Network-Information" | ACME | 248 |
| 62 | "CDR Sequence Number " | ACME | 59 |