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 |
| Tablespace |
|
| Partitioned |
No |
Summary
The PROP_INFO table is defined by the
following columns.
See the column details for more information.
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 |
VARCHAR2(256 CHAR), 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 |
| Foreign Key |
FK_PROP_CI_INFO |
Primary Key Details
PK_PROP_INFO
| Column(s) |
PROP_ID |
| Tablespace |
|
Constraint Details
FK_PROP_CI_INFO
| Column(s) |
CI_ID |
| Foreign Table |
CI_INFO |
| Foreign Column(s) |
CI_ID |
| Cascade |
true |
