Previous page Section 4.5.9. GetSessionSelectParam Section 4.5.10. GetSessionColumnDef (82 / 223)   Table of Contents Section 4.5.11. GetSubscriberSessionsSelect Next page

4.5.10. GetSessionColumnDef Previous topic Parent topic Child topic Next topic

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

Table 8. Session information fetched from the GxSession

Name Description
id Index or other identifier that uniquely identifies this session in this table
start_time Unix timestamp of the session start
alive_time Unix timestamp of the last update for this session
stop_time Unix timestamp of the session end
subscription_id Index of subscriber information table for this subscriber
session_id Session-Id for this Gx session
imsi IMSI for the subscriber
nai NAI for the subscriber
e164 E.164 formatted telephone number for the subscriber
sip_uri SIP URI for the subscriber
origin_host Origin-Host value for this Rx session
origin_realm Origin-Realm value for this Rx session
framed_ip_address Framed-IP-Address for this Rx session
framed_ip_address Framed-IPv6-Prefix for this Rx session
rat_type RAT-Type value for this Gx session
reserved_octets Number of octets currently allocated for this session
reserved_time Number of seconds currently allocated for this session
Previous page Section 4.5.9. GetSessionSelectParam Section 4.5.10. GetSessionColumnDef (82 / 223)   Table of Contents Section 4.5.11. GetSubscriberSessionsSelect Next page