SURT_RARO

Definition

The SURT_RARO table contains the values of the rows of the subscriber range tables

Description

The SURT_RARO table contains the values of the rows of the subscriber range tables.

Technical Data

Schema Version	5.0.6
Partitioned	No

Summary

The SURT_RARO 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
UPPER_BOUND						The upper bound of the range table row. It must be unique in the subscriber range table containing the row
IS_UNBOUNDED						For unbounded value
START_DATE						The start date for the row
END_DATE						The end date of the row
IN_S_01						The value of an input column (string type)
IN_S_02						The value of an input column (string type)
IN_S_03						The value of an input column (string type)
IN_S_04						The value of an input column (string type)
IN_S_05						The value of an input column (string type)
OUT_S_01						The value of an output column (string or currency type)
OUT_S_02						The value of an output column (string or currency type)
OUT_S_03						The value of an output column (string or currency type)
OUT_S_04						The value of an output column (string or currency type)
OUT_S_05						The value of an output column (string or currency type)
OUT_S_06						The value of an output column (string or currency type)
OUT_S_07						The value of an output column (string or currency type)
OUT_S_08						The value of an output column (string or currency type)
OUT_S_09						The value of an output column (string or currency type)
OUT_S_10						The value of an output column (string or currency type)
OUT_S_11						The value of an output column (string or currency type)
OUT_S_12						The value of an output column (string or currency type)
OUT_S_13						The value of an output column (string or currency type)
OUT_S_14						The value of an output column (string or currency type)
OUT_S_15						The value of an output column (string or currency type)
OUT_N_01						The value of an output column (Number type)
OUT_N_02						The value of an output column (Number type)
OUT_N_03						The value of an output column (Number type)
OUT_N_04						The value of an output column (Number type)
OUT_N_05						The value of an output column (Number type)
OUT_N_06						The value of an output column (Number type)
OUT_N_07						The value of an output column (Number type)
OUT_N_08						The value of an output column (Number type)
OUT_N_09						The value of an output column (Number type)
OUT_N_10						The value of an output column (Number type)
OUT_N_11						The value of an output column (Number type)
OUT_N_12						The value of an output column (Number type)
OUT_N_13						The value of an output column (Number type)
OUT_N_14						The value of an output column (Number type)
OUT_N_15						The value of an output column (Number type)
SURT_OID			IX_SURT_RARO	SURT (OID)		The identifier of the subscriber range table containing the row
PARTITION_ID						The partition of the subscriber account that the subscriber range table including this row belongs to

Column Details

The database schema defines the following columns. Check the definitions, types, available indexes, and formats:

UPPER_BOUND

Definition	The upper bound of the range table row. It must be unique in the subscriber range table containing the row
Type	DECIMAL(28,6), NULL

IS_UNBOUNDED

Definition	For unbounded value
Type	DECIMAL(1), NULL

START_DATE

Definition	The start date for the row
Type	SECONDDATE, NULL

END_DATE

Definition	The end date of the row
Type	SECONDDATE, NULL

IN_S_01

Definition	The value of an input column (string type)
Type	NVARCHAR(256), NULL

IN_S_02

Definition	The value of an input column (string type)
Type	NVARCHAR(256), NULL

IN_S_03

Definition	The value of an input column (string type)
Type	NVARCHAR(256), NULL

IN_S_04

Definition	The value of an input column (string type)
Type	NVARCHAR(256), NULL

IN_S_05

Definition	The value of an input column (string type)
Type	NVARCHAR(256), NULL

OUT_S_01

Definition	The value of an output column (string or currency type)
Type	NVARCHAR(256), NULL

OUT_S_02

Definition	The value of an output column (string or currency type)
Type	NVARCHAR(256), NULL

OUT_S_03

Definition	The value of an output column (string or currency type)
Type	NVARCHAR(256), NULL

OUT_S_04

Definition	The value of an output column (string or currency type)
Type	NVARCHAR(256), NULL

OUT_S_05

Definition	The value of an output column (string or currency type)
Type	NVARCHAR(256), NULL

OUT_S_06

Definition	The value of an output column (string or currency type)
Type	NVARCHAR(256), NULL

OUT_S_07

Definition	The value of an output column (string or currency type)
Type	NVARCHAR(256), NULL

OUT_S_08

Definition	The value of an output column (string or currency type)
Type	NVARCHAR(256), NULL

OUT_S_09

Definition	The value of an output column (string or currency type)
Type	NVARCHAR(256), NULL

OUT_S_10

Definition	The value of an output column (string or currency type)
Type	NVARCHAR(256), NULL

OUT_S_11

Definition	The value of an output column (string or currency type)
Type	NVARCHAR(256), NULL

OUT_S_12

Definition	The value of an output column (string or currency type)
Type	NVARCHAR(256), NULL

OUT_S_13

Definition	The value of an output column (string or currency type)
Type	NVARCHAR(256), NULL

OUT_S_14

Definition	The value of an output column (string or currency type)
Type	NVARCHAR(256), NULL

OUT_S_15

Definition	The value of an output column (string or currency type)
Type	NVARCHAR(256), NULL

OUT_N_01

Definition	The value of an output column (Number type)
Type	DECIMAL(28,6), NULL

OUT_N_02

Definition	The value of an output column (Number type)
Type	DECIMAL(28,6), NULL

OUT_N_03

Definition	The value of an output column (Number type)
Type	DECIMAL(28,6), NULL

OUT_N_04

Definition	The value of an output column (Number type)
Type	DECIMAL(28,6), NULL

OUT_N_05

Definition	The value of an output column (Number type)
Type	DECIMAL(28,6), NULL

OUT_N_06

Definition	The value of an output column (Number type)
Type	DECIMAL(28,6), NULL

OUT_N_07

Definition	The value of an output column (Number type)
Type	DECIMAL(28,6), NULL

OUT_N_08

Definition	The value of an output column (Number type)
Type	DECIMAL(28,6), NULL

OUT_N_09

Definition	The value of an output column (Number type)
Type	DECIMAL(28,6), NULL

OUT_N_10

Definition	The value of an output column (Number type)
Type	DECIMAL(28,6), NULL

OUT_N_11

Definition	The value of an output column (Number type)
Type	DECIMAL(28,6), NULL

OUT_N_12

Definition	The value of an output column (Number type)
Type	DECIMAL(28,6), NULL

OUT_N_13

Definition	The value of an output column (Number type)
Type	DECIMAL(28,6), NULL

OUT_N_14

Definition	The value of an output column (Number type)
Type	DECIMAL(28,6), NULL

OUT_N_15

Definition	The value of an output column (Number type)
Type	DECIMAL(28,6), NULL

SURT_OID

Definition	The identifier of the subscriber range table containing the row
Type	DECIMAL(28), NOT NULL
Available Index	IX_SURT_RARO

PARTITION_ID

Definition	The partition of the subscriber account that the subscriber range table including this row belongs to
Type	DECIMAL(4), NOT NULL

Index Details

The following database indexes are available in the SURT_RARO database table to improve the speed of data retrieval operations during the business processes of SAP Convergent Charging:

IX_SURT_RARO

Indexed Column(s)	SURT_OID
Unique	No
Partitioned	No