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.