access_points
Table name: access_points (from db v2.3)
Contains/Role: Shows a list of all the access points for Phone and written requests (chat/email/SoMe), and their Descriptions.
| Column Name | Datatype | Description |
|---|---|---|
| Accesspoint | varchar | Primary key. The access number (for Phone) or the Access point for Email/Chat/Social media. In special cases the Accesspoint can be a range. |
| ServiceNo | Int | The Service number this Accesspoint belongs to |
| CountryCode | Varchar | The Country this Accesspoint belongs to |
| AliasNo | Varchar | If such an Alias exist, this will be shown as the Access point (Access number) in the statistics report Total overview. |
| Description | nvarchar | The description for the Accesspoint |
| FromNumber | Varchar | The same value as Accesspoint |
| ToNumber | Varchar | For an Accesspoint being a range, we show the highest value in the range here. For non-range values, we show the Accesspoint also here. |
| dte_updated | Datetime | When the record last was updated |
| deleted | bit | If the Accesspoint is deleted in PCC, the deleted bit is set. |