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 a Liability Orphan record in AdviserLogic go to Tools > Administrative Tools > Data Import - Map Orphan Record > Map Orphan Record - Liabilities.
The landing screen will show a list of Unmapped liabilities, with several mapping and managing options.
You can also choose whether to view Mapped, or Discarded Liabilities.
The list will show the existing unmapped Liabilities as a default.
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 Liability.
Quick Map
To quickly map individual Orphan Liabilities, select the quick map clock icon from the second column on the line item to be mapped.
Select the Liability Type from the drop-down. Search for the client the orphan liability 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 liability to the allocated client and apply the liability type to the Client's Liabilities screen.
Bulk Map
To Bulk Map multiple orphan Liabilities 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 LiabilityType from the drop-down. Search for the client the orphan liability 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 liability to the allocated client's Liabilities screen.
Editing an Orphan Liability File
Occasionally, the reason the file was orphaned, is due to incorrect or incomplete data and you will want to edit the file before 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 Fields
| Follow the quickmap Instructions |
| Manually type a Description that will be reflected in the Liabilities Screen |
| Choose the Liability Type from the dropdown |
| Select the correct date from the dropdown |
| Manually Type in the revised amount |
Non-EditableFields
| Shows the record status in the orphan records section - Mapped, Unmapped or Discarded |
| Editable via the edit Liability screen in Liabilities |
| Editable via the edit Liability screen in Liabilities |
| Editable via the edit Liability screen in Liabilities |
These fields are reflected in the Liabilities and Edit Liabilities screens. Fields that are uneditable in the Orphan Liabilities Screen, can be edited in the Liabilities section.
Discard
To Discard an Orphan Liability 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 Liability records.
Mapped
The Mapped Screen will show a list of liabilities 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 mapping instructions.
Export Mapped
Selecting Export will export an Excel file of the Mapped Orphan Liability records.
Discarded
The Discarded section houses previously discarded Orphan Liability 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.
The file will move back to the UnMapped section.
Export Discarded
Selecting Export will export an Excel file of the Discarded Orphan Liability 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 client's 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 ensures 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 Liabilities tab by selecting the line item and then Delete.
