PROP_INFO

Definition

The PROP_INFO table defines the typical properties that are available for each chargeable item

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
Filegroup
Partitioned	No

Summary

The PROP_INFO table is defined by the following columns in your back-end database. See the column details for more information.

Name	PK	Uses	Used by	Definition
PROP_ID	PK_PROP_INFO		XCI_VALUES (PROP_ID)	The property unique identifier
PROP_NAME				The property name of a property recorded in the extended chargeable items (XCIs) stored in the database More...
PROP_TYPE				This property type is only used for the User properties or Default properties of chargeable items More...
CI_ID		CI_INFO (CI_ID)		The ID of the chargeable item class

Column Details

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

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

See the primary key information:

PK_PROP_INFO

Column(s)	PROP_ID
Filegroup