BalanceAAP > File Structure Details / User-defined Reference Tables

RETURN TO: File Structure Details for balanceAAP Tables

KEY TOPICS:

  • Drilldown
  • Rollup

NEXT STEP:


Optional Reference Tables for Organizing AAP Metrics

Note: The term "Required," as shown in the column headers below, refers to a system requirement for operation.

Drilldown

Field Name Data Type Length Required Master Plan Required
Drilldown Field Text 255 Yes Yes
Description Text 255 No No
Zip Code Text 5 No No

BalanceAAP Cross-reference: If a Drilldown Field is user defined, the column will be added to all Data tables, where entries will be required. Refer to: Reporting Levels > Drilldowns.

For detailed instructions, see the BALANCEaap User's Guide at: Drilldowns.

Rollup (Master Plan)

Field Name Data Type Length Required Master Plan Required
Rollup Field Text 255 N/A Yes
Description Text 255 No No
Zip Code Text 5 No No

BalanceAAP Cross-reference: If a Rollup Field is user defined, the column will be added to all Data tables. Refer to: Reporting Levels > Rollups.

For detailed instructions, see the BALANCEaap User Guide at: Rollups.