SUBS_TIER_TABLE_ROW
Definition
The SUBS_TIER_TABLE_ROW table contains the rows of tier table instances in subscriptions
Technical Data
| Schema Version |
4.5.13 |
| Tablespace |
SUBSCRIBER_DATA |
| Partitioned |
Yes, when you use the partitioning scheme and corresponding SQL scripts |
Summary
The SUBS_TIER_TABLE_ROW table is defined by the
following columns.
See the column details for more information.
Column Details
INDEX_IN_TINS
| Definition |
The ordinal number of the row in the tier table instance |
| Type |
DECIMAL(5), NOT NULL |
TINS_OID
| Definition |
The identifier of the tier table instance |
| Type |
DECIMAL(28), NOT NULL |
| Available Index |
IX_STIERTR_TINS_OID |
GROUP_NAME
| Definition |
The group name of the row |
| Type |
VARCHAR(256), NULL |
LOW_RANGE
| Definition |
The lower range |
| Type |
DECIMAL(28,6), NULL |
LOW_RANGE_INC
| Definition |
Is the lower range inclusive |
| Type |
DECIMAL(1), NOT NULL |
| Default |
0 |
UP_RANGE
| Definition |
The upper range |
| Type |
DECIMAL(28,6), NULL |
UP_RANGE_INC
| Definition |
Is the upper range inclusive |
| Type |
DECIMAL(1), NOT NULL |
| Default |
0 |
OUT_BD_01
| Definition |
A decimal output value of the row |
| Type |
DECIMAL(28,6), NULL |
OUT_BD_02
| Definition |
A decimal output value of the row |
| Type |
DECIMAL(28,6), NULL |
OUT_BD_03
| Definition |
A decimal output value of the row |
| Type |
DECIMAL(28,6), NULL |
OUT_BD_04
| Definition |
A decimal output value of the row |
| Type |
DECIMAL(28,6), NULL |
OUT_BD_05
| Definition |
A decimal output value of the row |
| Type |
DECIMAL(28,6), NULL |
OUT_S_01
| Definition |
A string output value of the row |
| Type |
VARCHAR(256), NULL |
OUT_S_02
| Definition |
A string output value of the row |
| Type |
VARCHAR(256), NULL |
OUT_S_03
| Definition |
A string output value of the row |
| Type |
VARCHAR(256), NULL |
OUT_S_04
| Definition |
A string output value of the row |
| Type |
VARCHAR(256), NULL |
OUT_S_05
| Definition |
A string output value of the row |
| Type |
VARCHAR(256), NULL |
ROOT_SUBS_OID
| Definition |
The root subscription |
| Type |
DECIMAL(28), NOT NULL |
| Available Index |
IX_STIERTR_RS_OID |
PARTITION_ID
| Definition |
The partition of the subscriber account owning the subscription containing the tier
table instance
|
| Type |
DECIMAL(4), NOT NULL |
Index Details
The following database indexes are available in the
SUBS_TIER_TABLE_ROW database table to improve the speed of data retrieval operations during
the business processes of SAP Convergent Charging:
IX_STIERTR_TINS_OID
| Indexed Column(s) |
TINS_OID |
| Unique |
No |
| Partitioned |
No |
| Tablespace |
SUBSCRIBER_INDX |
IX_STIERTR_RS_OID
| Indexed Column(s) |
ROOT_SUBS_OID |
| Unique |
No |
| Partitioned |
Yes |
| Tablespace |
SUBSCRIBER_INDX |
