Previous page Section 4.4.28. UsageSelectParam Section 4.4.29. UsageColumnDef (71 / 223)   Table of Contents Section 4.5. <PCRFGxSessionSQL> Next page

4.4.29. UsageColumnDef Previous topic Parent topic Child topic Next topic

This optional parameter allows you to define the way Radiator interprets the result of the UsageSelect statement.
You can specify any number of UsageColumnDef parameters, one for each interesting field returned by UsageSelect. The general format is:
UsageColumnDef n, dataitem
  • n is the index of the field in the result of UsageSelect. 0 is the first field.
  • dataitem is the name of a entry in the subscriber information
The usage tracking information entries required by the modules shipped with Radiator policy and charging support use the following information:

Table 7. Usage tracking information fetched from the SPR

Name Description
id Index or other identifier that uniquely identifies a single row in the SPR
name Index of subscriber information table for the current subscriber
monitoring_enabled Value the evaluates as true in Perl means usage monitoring is enabled
data_plan Index or other identifier to Data plan, see DataPlanSelect for the details
online Value for Online, for example DISABLE_ONLINE
offline Value for Offline, for example ENABLE_OFFLINE
online_primary Diameter URI for the primary online charging server
online_secondary Diameter URI for the secondary online charging server
offline_primary Diameter URI for the primary offline charging server
offline_secondary Diameter URI for the secondary offline charging server
Previous page Section 4.4.28. UsageSelectParam Section 4.4.29. UsageColumnDef (71 / 223)   Table of Contents Section 4.5. <PCRFGxSessionSQL> Next page