The SHARING_GROUP_CONTRIBUTOR table contains the contributor contract for each sharing
group. A sharing group without contributor contract is not represented here.
This table is used by the cache of sharing group contributors.
| Schema Version | 2025.0.0 | |
| Partitioned | No | |
The SHARING_GROUP_CONTRIBUTOR 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 |
|---|---|---|---|---|---|---|
| CLIENT_NUMBER | PK_SHARING_GROUP |
|
The client number associated to the shared allowance | |||
| SHARING_GROUP | PK_SHARING_GROUP |
|
The sharing group of the charging contracts that will use the shared allowances | |||
| SUAC_SERVICE_PROVIDER |
|
The service provider associated to the subscriber account that owns the contributor contract | ||||
| SUAC_ID |
|
The identifier of the subscriber account that owns the contributor contract | ||||
| CONTRIBUTOR_ID |
|
The identifier of the contributor contract of the sharing group i.e. the contract that creates the shared allowances for this sharing group | ||||
| LAST_SNAPSHOT_ID |
|
The last date when snapshots were created for the counters of the contributor contract | ||||
| PARTITION_ID |
|
The partition of the subscriber account |
The database schema defines the following columns. Check the definitions, types, available indexes, and formats:
| Definition | The client number associated to the shared allowance |
| Type | DECIMAL(3), NOT NULL |
| Primary Key | PK_SHARING_GROUP |
| Definition | The sharing group of the charging contracts that will use the shared allowances |
| Type | NVARCHAR(256), NOT NULL |
| Primary Key | PK_SHARING_GROUP |
| Definition | The service provider associated to the subscriber account that owns the contributor contract |
| Type | NVARCHAR(256), NOT NULL |
| Definition | The identifier of the subscriber account that owns the contributor contract |
| Type | NVARCHAR(256), NOT NULL |
| Definition | The identifier of the contributor contract of the sharing group i.e. the contract that creates the shared allowances for this sharing group |
| Type | NVARCHAR(256), NOT NULL |
| Definition | The last date when snapshots were created for the counters of the contributor contract |
| Type | DECIMAL(8), NULL |
| Definition | The partition of the subscriber account |
| Type | DECIMAL(4), NOT NULL |
See the primary key information:
| Column(s) | CLIENT_NUMBER, SHARING_GROUP |
| Segment | ALLOWANCE_INDX |
