Performance Considerations › Grouping

Grouping

Grouping is one of the most powerful features of CA JARS. It can be used to:

• Select/reject account records from processing in a given report
• Group together account records based on an indicated criteria
  • Group codes can be assigned for sorting and/or grouping
  • CPUID can be altered to sort or group records so multiple billing algorithms can be applied

Grouping Considerations

• Grouping is applied to step and job records--including 1 step job records created by CREDIT, DEBIT and BUDGET statements
• Grouping occurs prior to rate application
• Limitations
  • One GROUP statement only: Up to six Basic Account fields defined
  • Unlimited GROUPC statements per report
• The GROUP statement along with the GROUPC statements define the data to be selected or rejected based on the actual values found in specific positions in the Basic Accounting Table
• AND Logic

  Grouping is an AND type of logic. Qualification starts with the first test. If selected, the account record then goes to the next test (if any) and so on through all fields to be tested. If a record meets any test, it is rejected or selected based on the rejection/selection indicator.

• GROUP statement
  • Limited to 6 tests (applied in sequence)
  • States the offset in the account record to check
  • Number of positions of data to look at (up to 8 positions)
  • Format data is carried in (hexadecimal, packed or alphanumeric)
• GROUPC statement
  • Must be associated with GROUP statement
  • Sets ranges of test (high value/low value)
  • Unlimited number of GROUPC statements permitted
  • Ability to reassign or assign CPUIDs and/or group codes
• OR Logic

  Grouping can also be an OR logic by using the grouping-on-grouping technique. By not selecting or rejecting the account records, test for a value or range of values and, based on these values, assign unique group codes. These group codes can then be tested and the account records which qualify can then be selected or rejected.