Section 4.4.9. SubscriberColumnDef

4.4.9. SubscriberColumnDef

This optional parameter allows you to define the way Radiator interprets the result of the SubscriberSelect* statements.

You can specify any number of SusbscriberColumnDef parameters, one for each interesting field returned by SubscriberColumnSelect. The general format is:

SubscriberColumnDef n, dataitem

n is the index of the field in the result of SubscriberSelect. 0 is the first field.
dataitem is the name of a entry in the subscriber information.

The subscriber information entries required by the modules shipped with Radiator policy and charging support use the following information:

Table 1. Subscriber information fetched from the SPR

Name	Description
`id`	Index or other identifier that uniquely identifies the subscription in the SPR
`e164`	E.164 formatted telephone number for the user
`imsi`	IMSI for the user
`nai`	NAI for the user
`sip_uri`	SIP_URI for the user
`private`	Private identifier for the user
`enabled`	Value the evaluates as true in Perl means the subscription is enabled
`pcc_rules`	Comma separated list of names from `pcc_rules` table
`qos_information`	Name of one entry in `qos_information` table
`wlan_max_sess`	Non-NULL if session count should be limited for RAT-Type WLAN
`wlan_curr_sess`	Current count of WLAN sessions
`usage_tracking`	Name of one entry in usage tracking table
`quota_octets`	Remaining default octet quota. Used when PCRF usage monitoring is enabled
`all_reservations_octets`	Total default octet quota reserved for sessions. Used when PCRF usage monitoring is enabled
`lte_quota_octets`	Non-NULL if usage monitoring it done for LTE. Currently RAT-types UTRAN, GERAN, GAN HSPA-Evolution and EUTRAN and the unknown RAT-Type are considered as LTE for octet usage monitoring purposes
`lte_all_reservations_octets`	Total octet quota reserved for LTE sessions. Used when PCRF usage monitoring is enabled for LTE octets
`wlan_quota_octets`	Non-NULL if usage monitoring it done for RAT-Type WLAN octets
`wlan_all_reservations_octets`	Total WLAN octet quota reserved for sessions. Used when PCRF usage monitoring is enabled for WLAN octets
`wlan_quota_time`	Non-NULL if usage monitoring is done for RAT-Type WLAN time
`wlan_all_reservations_time`	Total WLAN time quota reserved for sessions. Used when PCRF usage monitoring is enabled for WLAN time