PROP_INFO

Description

The PROP_INFO table defines the typical properties that are available for each extended chargeable item (XCI) stored in the IEC database system. The property values are stored in the XCI_VALUES table.

Technical Data

Schema Version	4.5.0
Partitioned	No

Summary

The PROP_INFO table is defined by the following columns. See the column details for more information.

Name	PK	Uses	Used by
PROP_ID	PK_PROP_INFO		XCI_VALUES (PROP_ID)
PROP_NAME
PROP_TYPE
CI_ID		CI_INFO (CI_ID)

Column Details

PROP_ID

Definition	The property unique identifier
Type	DECIMAL(28), NOT NULL
Primary Key	PK_PROP_INFO

PROP_NAME

Definition	The property name of a property recorded in the extended chargeable items (XCIs) stored in the database
Description	The property name in the chargeable item. It can be a default property or a property customized by the implementation project team.
Format	The possible values are: `USID` (User Service Identifier - a technical identification key of the end customer in the service) `SID` (Service Identifier - a technical identfication key of the customer service `CONS_DATE` or another name defined during the implementation project Examples `CALLEE` or `CALLER`
Type	NVARCHAR(256), NOT NULL

PROP_TYPE

Definition This property type is only used for the User properties or Default properties of chargeable items

Format

The possible values are:

0: number
1: string
2: date

Type DECIMAL(1), NOT NULL

CI_ID

Definition	The ID of the chargeable item class
Type	DECIMAL(28), NOT NULL

Primary Key Details

PK_PROP_INFO

Column(s)	PROP_ID
Tablespace