Click on images to expand in a new tab
Overview
Orphan records are database entries left without a parent association, typically due to errors or inconsistencies during data handling processes.
These records occur when importing data from third-party sources, where relational links are broken or not properly established. For instance, in a relational database, if a record refers to a parent entry that no longer exists or was not imported correctly, it becomes an orphan.
Navigation
To map an Investment Orphan record in AdviserLogic go to Tools > Administrative Tools > Data Import - Map Orphan Record > Map Orphan Record - Investments.
💡Tip
You must have access to Administrative Tools to use the Map Orphan Record feature.
The landing screen will show a list of unmapped investments, with several mapping and managing options.
The list will show the existing Unmapped Investments as a default.
You can also choose whether to view Mapped and Discarded Investments.
These options allow you to reverse any previous mapping that may have been completed incorrectly in the case of discarded records, or export data into an Excel report.
Unmapped
There are two ways to map an unmapped orphan investment.
Quick Map
To quickly map individual Orphan Investments select the quick map clock icon from the second column on the line item to be mapped.
Select the Investment Type from the drop-down. Search for the client the orphan investment belongs to by typing their name or ADLID in the client field and selecting the client from the populated list.
📌Note
Record the ADLID when mapping orphan files, this will allow you to ensure the file is mapped to the correct client by conducting a client search.
Clicking the Clock Icon at the right end of the pop-up will map the investment to the allocated client and apply the investment type to the Client's Assets screen.
Bulk Map
To Bulk Map multiple orphan investments to a single client, select the tick box from the first selection column for each line item, and then Bulk Map from the top right of the window.
Select the Investment Type from the drop-down. Search for the client the orphan investment belongs to by typing their name or ADLID in the client field and selecting the client from the populated list.
📌Note
Record the ADLID when mapping orphan files, this will allow you to ensure the file is mapped to the correct client by conducting a client search.
Clicking the Clock Icon at the right end of the pop-up will map the investment to the allocated client and apply the investment type to the Client's Assets screen.
Editing an Orphan Investment File
Occasionally, the reason the file was orphaned is due to incorrect or incomplete data and you will want to edit the file prior to mapping.
To do this select the column of the line item you wish to edit and either enter the value or select it from the options provided.
Editable
| Follow the quickmap Instructions |
| Manually type a Description that will be reflect in the Assets Screen |
| Choose investment Type from dropdown |
| Select the correct date from the dropdown |
| Manually Type in the revised amount |
Non Editable
| Editable via the edit asset screen in Assets |
| Editable via the edit asset screen in Assets |
| Editable via the edit asset screen in Assets |
| Editable via the edit asset screen in Assets |
These fields reflect in the Assets and Edit Asset screens. The fields that are uneditable in the Orphan Investments Screen can be edited in the Assets section.
Discard
To Discard an Orphan Investment file select the tick box from the first selection column for each line item, and then Discard from the top right of the window.
A confirmation notification will show, select Yes to continue discarding the file or Cancel to return to the Unmapped screen.
The file will be moved to the Discarded section.
Export UnMapped
Selecting Export will export an Excel file of the existing Unmapped Orphan Investment records.
Mapped
The Mapped Screen will show a list of investments that have recently been Mapped to clients.
📌Note
There is no provision to unmap records mapped to client accounts, so please ensure the right client is being mapped in the mapping stage by following the above mapping instructions.
Export Mapped
Selecting Export will export an Excel file of the Mapped Orphan Investment records.
Discarded
The Discarded section houses previously discarded Orphan Investment records.
Unmap Discarded Records
If you need to restore an orphan record that was previously discarded, you can select Unmap from the second column on the line item to do so.
Export Discarded
Selecting Export will export an Excel file of the Discarded Orphan Investment records.
ADLID Client Search
When mapping a client account, make a note of the client's ADLID to ensure you have the correct client. This can be found on the clients Fact Find - Internal > Account Codes section
You can also find the client's ADLID by going to the Client Search and entering the client's name, searching and finding the ADLID in the results.
This ensured that you have the correct client when mapping the client orphan fee as this mapping cannot be undone.
Delete Incorrectly Mapped Orphan File
If you map an Orphan File incorrectly, delete it from the client's Assets tab by selecting the line item and then Delete.
