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

Summary


The CIT_AGGR_RULE 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
POLICY_OID PK_CIT_AGGR_RULE       

    The unique identifier of the charged items aggregation policy
    FIELD_NAME PK_CIT_AGGR_RULE       

      The name of the field concerned by the charged items aggregation rule
      OPERATOR_TYPE        

        The type of operator associated to the charged items aggregation rule

        More...

        Column Details

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

        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

        See the primary key information:

        PK_CIT_AGGR_RULE

        Column(s) POLICY_OID, FIELD_NAME
        Segment CATALOG_INDX