| Schema Version | 5.0.6 | |
| Filegroup | ACCESS_DATA | |
| Partitioned | Yes, when you use the partitioning scheme and corresponding SQL scripts | |
The ACCESS_TABLE table is defined by the following columns in your back-end database. See the column details for more information.
| Name | PK | FK | IX | Uses | Used by | Definition |
|---|---|---|---|---|---|---|
| OID | PK_ACCESS_TABLE |
|
The access unique ID | |||
| USER_SERVICE_ID | IX_ACCESS |
|
The user service ID (USID) for the user access; a technical key that identifies the end customer regarding to the consumed service. | |||
| SERVICE_ID | IX_ACCESS |
|
The service identifier (SID) for the user access | |||
| OWNER |
|
The name of the pricing catalog to which the access belongs | ||||
| PARTITION_ID | PK_ACCESS_TABLE | IX_ACCESS |
|
The partition of the access |
The database schema defines the following columns. Check the definitions, types, available indexes, and formats:
| Definition | The access unique ID |
| Type | DECIMAL(28), NOT NULL |
| Primary Key | PK_ACCESS_TABLE |
| Definition | The user service ID (USID) for the user access; a technical key that identifies the end customer regarding to the consumed service. |
| Type | NVARCHAR(128), NOT NULL |
| Available Index | IX_ACCESS |
| Definition | The service identifier (SID) for the user access |
| Type | NVARCHAR(128), NOT NULL |
| Available Index | IX_ACCESS |
| Definition | The name of the pricing catalog to which the access belongs |
| Description |
The name of the pricing catalog to which the access belongs. This field is set automatically
if the access was created by an SAP user associated to a catalog.
|
| Type | NVARCHAR(64), NULL |
| Definition | The partition of the access |
| Type | DECIMAL(4), NOT NULL |
| Primary Key | PK_ACCESS_TABLE |
| Available Index | IX_ACCESS |
See the primary key information:
| Column(s) | PARTITION_ID, OID |
| Filegroup | ACCESS_DATA |
The following database indexes are available in the ACCESS_TABLE database table to improve the speed of data retrieval operations during the business processes of SAP Convergent Charging:
| Indexed Column(s) | PARTITION_ID,USER_SERVICE_ID,SERVICE_ID |
| Unique | Yes |
| Partitioned | No |
| Clustered | No |
| Filegroup | ACCESS_INDX |
