CIT_AGGR_RULE

Definition


The CIT_AGGR_RULE table contains the list of charged items aggregation rules which are associated to existing charged items aggregation policies

Technical Data


Schema Version 4.5.13
Filegroup CATALOG_DATA
Partitioned No

Summary


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

Name PK FK IX Uses Used by
POLICY_OID PK_CIT_AGGR_RULE         
FIELD_NAME PK_CIT_AGGR_RULE         
OPERATOR_TYPE          

Column Details


POLICY_OID

Definition The unique identifier of the charged items aggregation policy
Type DECIMAL(28), NOT NULL
Primary Key PK_CIT_AGGR_RULE

FIELD_NAME

Definition The name of the field concerned by the charged items aggregation rule
Type NVARCHAR(256), NOT NULL
Primary Key PK_CIT_AGGR_RULE

OPERATOR_TYPE

Definition The type of operator associated to the charged items aggregation rule
Format

The possible values are:

  • 1: CONSTANT
  • 2: FIRST
  • 3: LAST
  • 4: LOWEST_DATE
  • 5: GREATEST_DATE
  • 6: LOWEST_NUMBER
  • 7: GREATEST_NUMBER
  • 8: ADD

Type DECIMAL(4), NOT NULL

Primary Key Details


PK_CIT_AGGR_RULE

Column(s) POLICY_OID, FIELD_NAME
Filegroup CATALOG_DATA