Search
Intermediate Certificate on pass

Custom Fields in Reports

Field settings, report availability, and data quality.

3 lessons 40 min 5-question assessment 70% to pass

What you’ll learn

  • Explain the configuration and custom fields control purpose behind custom fields in reports
  • Configure custom field definitions, validation parameters, and module rollouts
  • Handle configuration settings overrides, options cleanups, and security controls
  • Provide audit-ready change logs and configuration histories

Course content

3 lessons · 40 min of reading
01
Lesson 1 of 3 Reading 12 min

Link custom fields to reports

Custom Fields in Reports focuses on linking custom fields to reports, managing availability settings, and auditing data quality. In AWRA, custom fields and configuration parameters allow tenants to adapt database tables to unique business operations without breaking data structure.

The primary objective is database stability and change control. Configuration admins should test definitions and validation rules before wide deployment.

In practice, an accountant adds custom fields to a sales report, configures index availability, and tests output quality.

Report field integration path

1

Select

Choose custom field from active definition registry.

2

Integrate

Link column to report builder datasets.

3

Configure

Enable availability flags in settings index.

4

Verify

Run test report to confirm custom values display cleanly.

Configuration model

  • Custom field definitions modify active database schemas.
  • Input validation rules protect data value format and type.
  • Settings overrides require security controls and approvals.
  • Always verify template layouts before run-time value imports.
02
Lesson 2 of 3 Workshop 14 min

Manage field availability

The operating routine is to integrate custom columns into reports, configure availability flags, monitor query runtimes, and verify quality. That sequence prevents data formatting errors and keeps parameters aligned with policies.

Before publishing configuration updates, check custom fields list, dataset links, availability settings, report outputs, and query logs. These safety gates protect data values, user inputs, and reporting stability.

An administrator can verify active parameters, clear settings caches, or run cleanups directly from the builder.

Reporting field guide

Signal Check Action
Field missing in builder Availability flag is disabled Enable availability in settings index
Slow query on custom column Check column index status Apply SQL index to custom table
Incorrect column label Verify header configuration Update label in settings catalog
Clean report generated Values match target records Publish report template

Admin decisions

  • Restrict layout changes to certified system administrators.
  • Lock global defaults using security approval overrides.
  • Resolve values validation errors during template imports.
  • Ensure data cleanups occur on a regular cadence.
03
Lesson 3 of 3 Practice 14 min

Audit reporting quality

Configuration updates and field overrides should leave proof. Useful evidence includes report dataset configuration, availability logs, SQL query trace logs, and test report PDFs, which is required for audit logs reviews and system restores.

Management should review configuration drift: stale custom fields, broken dropdown options, or unapproved overrides point to settings reviews needs.

In practice, closure means custom columns are available in report builders, query runs are fast, and values display cleanly.

Fields in reports checklist

Field is linked to report
Availability is active
SQL index is verified
Output quality is confirmed
Change log is complete

Oversight validation

  • Confirm that change logs record configuration updates.
  • Verify that database constraint tests are successful.
  • Validate that custom options match active guidelines.
  • Ensure configuration rollbacks are tested and ready.

Finished the material?

Take the 5-question assessment and earn your certificate — 70% to pass.

Take the assessment

Help Center

Need a quick answer while you read?

Run inventory, procurement, assets, sales, and field work with approved AWRA guidance for setup, migration, integrations, security, pricing, and support.

Search all approved AWRA public help articles.

Open Help Center