Skip to main content
All CollectionsForm Builder
Form Builder: Master Data
Form Builder: Master Data
Sarah avatar
Written by Sarah
Updated yesterday

Master Data

The Master Data section captures the core information about your RSE structure—covering everything from products and fees to investment menus and options. Because these details flow through to your APRA reporting, it’s vital to keep them accurate and up to date. Master Data is divided into three main areas:

TIP: If you manage multiple funds, confirm you have selected the correct fund from the dropdown at the top of the page before making any updates.

Note: Updates to Master Data made after you have uploaded Source Data in Form Builder may require re-validation or a form rebuild, as the system will need to recognise any new or changed attributes.


Navigating Master Data

Select Master Data from the Form Builder Side Menu. Company Profile is always the default view. However, you can easily switch sections:

  • When on Company Profile: You’ll see options for Mapping and Pathways in the top right.

  • When on Mapping: You’ll see options for Company Profile and Pathways in the top right.

  • When on Pathways: You’ll see options for Company Profile and Mapping in the top right.

This layout ensures you can quickly jump between sections while updating key attributes and relationships.


1. Company Profile

Under Company Profile, you’ll see four tabs representing different aspects of your RSE:

  • Products

  • Investment Menus

  • Investment Options

  • Fees and Costs

Each tab shows a table of relevant items. You can:

  • Add a new row by selecting the icon.

  • Edit an existing row by clicking anywhere on the row.

  • Leave commentary on your changes by selecting the icon (useful for explaining why something was updated).

  • Upload data by selecting the icon.

  • Download data by selecting the icon.

Keeping these details current is essential for accurate form building later on.

Important: Ensure the Company Profile in your Master Data matches the Company Profile that APRA has on APRA Connect. Mismatches could lead to validation issues or discrepancies when submitting your forms. If you’re unsure about official details, double-check your APRA Connect records before finalising any changes here.

1.1 Adding New Investment Options to Master Data

Why this Matters

Each quarter, funds may invest in new investment securities that weren’t previously reported in their 605 or 606 returns. These new securities appear in the AFS Unit Report, but won’t be recognised by the platform until they are:

  • Mapped in Reference Data (Mapping Security Option), and

  • Added to Master Data (Company Profile), where applicable.

This process ensures that downstream forms (like 605.0) are built with the correct data and that validations run accurately across the platform.


Steps to Add New Investment Options to Master Data

1. Upload the AFS Unit Report

  • Go to Form Builder → Manager, and select the correct fund and return (605.0).

  • Upload the latest AFS Unit Report.

  • The platform will validate the report against the current Reference Data (Mapping Security Option).

  • Any new investment securities not found in the mapping file will appear in the validation messages.

2. Update the Reference Data (Mapping Security Option)

  • Navigate to Reference Data, and download the latest Mapping Security Option file.

  • Add the new investment securities flagged during validation. For each one:

    • Provide all required details (e.g. security name, type, APIR if applicable).

    • Assign a new APRA Investment Option Identifier, or associate the security to an existing identifier where appropriate.

  • Save, re-upload, and approve the updated Reference Data file.

3. Update Master Data (Company Profile)

  • Go to Master Data → Company Profile.

  • Add each new APRA Investment Option Identifier that was created in the updated Reference Data.

  • Include all other required investment option details in the appropriate section.

4. Re-run Validation in Form Builder

  • Return to Form Builder → Manager, ensure the correct fund and return (605.0) are selected.

  • Re-run validation.

  • The platform should now recognise the updated Reference Data and Master Data, allowing the form to proceed with the latest data.


2. Mapping

The Mapping area lets you connect (or “map”) items such as:

  • Products to Fees and Costs and Investment Menus

  • Investment Menus to Investment Options

An item is considered unmapped if it has no parent-child relationship (for example, a Menu not mapped to a Product). If an item previously had a mapping but you removed it, it is now de-mapped.

Mapping Cards and Their States

When you go to Mapping, you’ll see cards representing each item. These cards can appear in different states to help you quickly see which are mapped, unmapped, or de-mapped.

  • Default / Hover / Disabled – Indicates an item’s normal or interactive states

  • Parent Selection – Highlights a “parent” card you have selected

  • Child Mapped – Shows which child cards are mapped to the parent

  • Unmapped or De-mapped – Indicates items that have no current parent or whose previous mapping was removed

  • Key Attributes – Highlights special attributes on certain cards (for example, ID or product name)

Common Mapping States

How to Map Items

  1. Select the Parent

  • Click on the parent card (for example, Product if you’re mapping Fees or Menus, or Menu if you’re mapping Options).

  • The parent’s card state changes to Selected, and any child cards already mapped to it will also highlight.

  1. Choose Child Items to Map or Unmap

  • An Edit Drawer opens, showing all child items (for example, Options if you selected Menu).

  • All existing mapped child items will already have their box checked.

  • To map a new child item, select its checkbox, or Select All (Tick the Select All box at the top of the child list to map or de-map every item visible under the current filters - Useful if you have many items to map at once.)

  • To unmap (de-map) a currently mapped item, deselect its checkbox. Keep in mind you can only de-map an item if there isn’t an existing investment pathway using that relationship. If there is, remove or update that pathway first before you de-map.

  • A summary of your changes appears in the drawer, and the Save button activates once you make at least one mapping change.

3. Save

  • Click Save to confirm your mapping updates.

  • The system updates each card’s state (mapped, unmapped, or de-mapped) accordingly.

Filters

  • View All – Shows all items (mapped, unmapped, and de-mapped).

  • Unmapped (Default) – Focuses only on unmapped or newly de-mapped items needing attention.

    • Why this is the Default: It helps users immediately see items that require mapping for accurate reporting.

  • Hide Unmapped – Displays only items that are already mapped.


3. Pathways

Pathways is where you can view, create, and manage the complete chain of relationships among Products, Investment Menus, and Investment Options—often referred to as PMOs. These relationships ensure your Master Data accurately reflects your fund’s structure for APRA reporting.

When you open Pathways, you’ll see:

  • Fund Selector – Choose the relevant fund if you have multiple.

  • View Filter – Switch between viewing All, Active, or Inactive pathways.

  • Date Selector – A time filter that shows only the pathways active within the selected period.

3.1 What Are Pathways Used For?

  • Compliance & Validation: Tells the platform which Product → Menu → Option combinations are valid, preventing errors during form building.

  • Effective Dated Control: By activating or deactivating a pathway with a date, you only report valid PMOs during that period.

  • Visibility: Offers a bird’s-eye view of how your fund’s investments link together, helping you quickly spot unmapped or de-mapped items.

3.2 Two Views: Table and Card

Pathways can be displayed in Table View or Card View. Both show the same data in different layouts to suit your workflow.

Table View

  • Row-by-Row: Each pathway is in its own row with columns for Product, Menu, and Option.

  • Key Attributes: To view or edit details (for example, Product Name, Identifier), select a cell in the table. This opens the Key Attributes drawer.

  • Effective Dates: Activated pathways show their Effective Date or date range.

  • Filtering & Sorting: Use the View Filter (active/inactive/all) and Date Selector (time-based) to pinpoint specific pathways.

  • Bulk Actions: Tick multiple rows’ checkboxes to activate or deactivate them simultaneously.

Card View

  • Visual Layout: Products, Menus, and Options appear as columns of cards. Highlighted lines or states show how items are mapped.

  • Key Attributes: To view or edit an item’s attributes, select the “eye” icon on its card. This opens the same Key Attributes drawer.

  • Bird’s-Eye Perspective: Clicking on a Product card shows its mapped Menus; selecting a Menu card then shows its mapped Options.

  • Toggle: Switch between Table and Card views at any time using the slider on the right side of the screen.

3.3 Activating or Deactivating a Pathway

A pathway is a specific Product + Menu + Option combination. Here’s how to manage them:

Select the Pathway


In Card View, click a Product, then a Menu, then an Option.


In Table View, tick the checkbox in the row you want to edit.

Pathway Activation Drawer

  • This drawer opens once the system recognises a complete PMO selection.

  • Activate the pathway by setting an Effective Date, or Deactivate it and add commentary if desired.

  • Save remains disabled until you enter or remove an effective date, or add commentary.

Save Changes

  • Once you save, the view updates to reflect the new pathway status.

  • If the pathway is active, the Effective Date is shown; if it’s inactive, no date is displayed or it’s marked as ended.

3.4 Managing Key Attributes and Bulk Edits

Key Attributes

  • Fields like Name, Identifier, Status, and Inception Date are considered core attributes of each Product, Menu, or Option.

  • Select “View full details” to go the full details in Company Profile view.

In Card View, select the “eye” icon on the card to do the same.

In Table View, select any cell to open the Key Attributes drawer.

  • Make your changes and click Save. If you make no changes, Save stays disabled.

Bulk Edits

  • In Table View, select multiple rows to activate or deactivate them all at once.

  • Ideal for large, simultaneous changes—for example, rolling out a new set of Options across multiple Menus.

3.5 Filters and Default Views

  • View All – Shows both active and inactive pathways.

  • Active Pathway – Focuses on currently live pathways, identified by an effective date.

  • Inactive Pathway – Displays pathways that have been deactivated or never activated.

  • Date Selector – Filters pathways to only those active within a specific time frame (for example, a particular quarter).

TIP: Use the Date Selector when reviewing historical or future-dated pathways to ensure you’re only seeing the relevant P,M,O's for your reporting period.

3.6 Common Scenarios

  • Adding a New Investment Option

    • Add the new Investment Option in Company Profile (Investment Options tab).

    • Map it to the relevant Investment Menu in Mapping.

    • Activate the pathway in Pathways with the correct effective date.

  • Terminating an Investment Option

    • Deactivate the pathway in Pathways and add commentary (for example, “Option terminated on [Date]”).

    • Update the Investment Option’s status in Company Profile.

    • Remove the mapping in Mapping if no active pathway exists for that option.

Audit & Troubleshooting

  • Adjust the Date Selector to view historical pathway data.

  • If forms flag missing data or relationships, check Pathways for unmapped or de-mapped items.


Next Steps

With Company Profile, Mapping, and Pathways fully explained, you’re ready to:

  1. Confirm Reference Data for any fund-specific overrides.

  2. Upload and Validate Source Data to move forward with building your APRA forms.

Keeping your Master Data current and correctly mapped is crucial for smooth, accurate APRA reporting across the platform.

TIP: If you have questions or need additional support, open the Nuj platform chat.

Did this answer your question?