This document highlights data and functionality most often of concern to practices converting from MidWinter AdviceOS to XPLAN, however if there is specific data and/or functionality that is not contained within this document and is of importance to your Practice, please discuss with your IRESS representative prior toyour conversion.
It is also important to be aware that IRESS will not undertake data cleansing. Any data errors (i.e. misspellings, client names, date of birth) will be transferred; therefore a practice may wish to ‘clean up’ their data before commencing with the conversion.
Please be aware that there will be a wait of a number of weeks from the time that IRESS receives your request for a data conversion. This time frame will vary throughout the year and your IRESS representative will inform you of an estimated time when your conversion will be scheduled.
If you require any data converted that is outside the scope of this document, IRESS is happy to assess the data. Once IRESS has made the assessment, a decision will be made on whether or not the conversion is possible. Once this decision has been made, an approximate quote on timeframe and additional cost will be given. Please contact your IRESS representative to discuss this further.
Outlined in the following pages are details of the data within Midwinter that will be converted to XPLAN. It is important that you review this information so you are fully aware of how your Midwinter data will be converted to XPLAN.
Midwinter OS Screen Field Name |
Midwinter OS Field Name |
Screen Field Name |
Group |
Field Name |
FirstName |
|
Key Details|First Name |
entity |
first_name |
LastName |
|
Key Details|Surname |
entity |
last_name |
MiddleName |
|
Key Details|Second Name |
entity |
middle_name |
TaxFileNumber |
|
Key Details|Tax File Number |
entity |
tfn |
Male |
|
Key Details|Gender |
entity |
sex |
ClientTag |
|
Key Details|Category |
entity |
client_category |
Birthdate |
|
Key Details|Date of Birth |
entity |
dob |
PreferredName |
|
Key Details|Preferred Name |
entity |
preferred_name |
Salutation |
|
Key Details|Salutation |
entity |
salutation |
Health |
|
Key Details|Health |
entity |
health |
Smoker |
|
Key Details|Smoker |
entity |
is_smoker |
memberid |
|
Key Details|Client reference/File number |
entity |
reference_file_number |
OptInDate |
|
Key Details|Next Opt-in Date |
entity |
next_opt_in_date |
DisclosureDate |
|
Key Details|Next Disclosure Statement Date |
entity |
disclosure_statement_date |
Midwinter OS Screen Field Name |
Midwinter OS Field Name |
Screen Field Name |
Group |
Field Name |
Notes |
Country |
|
Address|Country |
entity_address |
country |
|
PostCode |
|
Address|Postcode |
entity_address |
postcode |
|
State |
|
Address|State |
entity_address |
state |
|
Address1 Address2 |
|
Address|Street |
entity_address |
street |
|
Suburb |
|
Address|Suburb |
entity_address |
suburb |
|
WorkPhone HomePhone MobilePhone
|
|
Contact|Detail |
entity_contact |
value |
WorkPhone = Work Phone HomePhone = Home Phone Email = Other Email MobilePhone = Mobile Phone |
WorkPhone HomePhone MobilePhone
|
|
Contact|Type |
entity_contact |
type |
WorkPhone = Work Phone HomePhone = Home Phone Email = Other Email MobilePhone = Mobile Phone |
Midwinter OS Screen Field Name |
Midwinter OS Field Name |
Screen Field Name |
Group |
Field Name |
Notes |
EmploymentType |
|
Employment|Status |
entity_ employment |
Emp_Status |
|
StartOfEmployment |
|
Employment|StartDate |
entity_ employment |
Start_date | |
OccupationID | Employment| Occupation(Standard) |
entity_ employment |
iqm2_ occupation | Mapping is required | |
Employer | Employment|Employment |
entity_ employment |
employer |
Midwinter OS Screen Field Name |
Midwinter OS Field Name |
Screen Field Name |
Group |
Field Name |
Notes |
|
ReviewDate |
|
Review|Date |
entity_review |
date |
Create a review in Xplan |
Midwinter OS Screen Field Name |
Midwinter OS Field Name |
Screen Field Name |
Group |
Field Name |
DateOfWill |
|
Estate|Date of Will |
entity |
date_of_will |
HasWill |
|
Estate|Will Exists |
entity |
will_exists |
Midwinter OS Screen Field Name |
Midwinter OS Field Name |
Screen Field Name |
Group |
Field Name |
AssetyType |
|
Balance Sheet-Asset|Asset Type |
entity_asset |
type |
Name
|
|
Balance Sheet-Asset|Description |
entity_asset |
desc |
Value |
|
Balance Sheet-Asset|Current Value |
entity_asset |
amount |
Midwinter OS Screen Field Name |
Midwinter OS Field Name |
Screen Field Name |
Group |
Field Name |
Notes |
|
LoanType |
|
Balance Sheet-Liability|Loan Type |
entity_ liability |
type |
|
|
Value |
|
Balance Sheet-Liability| Outstanding Balance |
entity_ liability |
amount |
|
|
InterestRate |
|
Balance Sheet-Liability|Interest Rate (pa) |
entity_ liability |
rate |
|
|
Monthy Repayment |
|
Balance Sheet-Liability|Repayment Amount |
entity_ liability |
repayment |
|
|
LoanType |
|
Balance Sheet-Liability|Type |
entity_ liability |
type_group |
||
Comments |
|
Balance Sheet-Liability|Comment |
entity_ liability |
comment |
|
|
|
Balance Sheet-Liability|Repayment Frequency |
entity_ liability |
frequency |
Default to Monthly |
||
TaxDeductibility
|
|
Balance Sheet-Liability|Deductible |
entity_ liability |
deductible |
|
|
RepaymentType |
|
Balance Sheet-Liability|Repayment Type |
entity_ liability |
repayment_ type |
|
|
Name |
|
Balance Sheet-Liability| Package/Product Name |
entity_ liability |
package _name |
|
|
YearsRemaining |
|
Balance Sheet-Liability|Loan Term (integer) |
entity_ liability |
loan_ term _amount |
|
Midwinter OS Screen Field Name |
Midwinter OS Field Name |
Screen Field Name |
Group |
Field Name |
Notes |
|
Nominated Beneficiaries |
|
Insurance Group|Beneficiary |
entity _insurance _group |
beneficiary |
Insurance.xls |
|
UpfrontCommission Rate OngoingCommission Rate PaymentDate TaxDeductibility ProductLevelID
PaymentMethodID
ProductName
Comments TerminalIllness Benefit ChildCoverDetails
PolicyNumber
PolicyOwnerMemberID
InsuranceStatusID
FrequencyID
PremiumWaiver |
|
Insurance Group| Commission Comments |
entity _insurance _group |
commission _comments |
|
|
|
Insurance Group|Payment Comments |
entity _insurance _group |
payment _comments |
Insurance.xls |
||
|
Insurance Group|Payment Method |
entity _insurance _group |
payment _method |
Insurance.xls Mapping of the ID required |
||
|
Insurance Group|Plan Name |
entity _insurance _group |
plan_name |
Insurance.xls |
||
|
Insurance Group|Policy Comment |
entity _insurance _group |
policy _comments |
Insurance.xls |
||
|
Insurance Group|Policy Number |
entity _insurance _group |
policy_number |
Insurance.xlsx
|
||
|
Insurance Group|Policy Owner |
entity _insurance _group |
policy_owner |
Insurance.xls |
||
|
Insurance Group|Policy Status |
entity _insurance _group |
policy_status |
Insurance.xls ID mapping required |
||
|
Insurance Group|Premium Frequency |
entity _insurance _group |
frequency |
Insurance.xls ID mapping required |
||
|
Insurance Group|Premium Waiver |
entity _insurance _group |
premium _waiver |
|
||
PolicyProviderID |
|
Insurance Group|Provider |
entity _insurance _group |
coy |
Insurance.xlsx Mapping for th ID required |
|
PolicyStartDate |
|
Insurance Group|StartDate |
entity _insurance _group |
inception _date |
|
|
Premium |
|
Insurance Group|Total Premiums Paid |
entity _insurance _group |
total _premium _paid |
Insurance.xls |
Midwinter OS Screen Field Name |
Midwinter OS Field Name |
Screen Field Name |
Group |
Field Name |
Notes |
|
TPD Trauma IP BE Life |
|
Risk|Sum Insured |
entity_insurance |
value |
Insurance.xls |
|
Life |
|
Risk|Base Sum Insured |
entity_insurance |
base_sum _insured |
|
|
PremiumBasis
InsuredIndividual ID Exclusions |
|
Risk|Premium Structure |
entity_insurance |
premium _structure |
Insurance.xls ID mapping required |
|
|
Risk|Life Insured |
entity_insurance |
life_insured |
Insurance.xls |
||
|
Risk|Exclusion Notes |
entity_insurance |
loading_exclusion _notes |
|
Midwinter OS Screen Field Name |
Midwinter OS Field Name |
Screen Field Name |
Group |
Field Name |
PrivateHealthInsurance |
|
Risk-Medical|Cover under a Private Policy |
entity |
medical_private_cover |
Midwinter OS Screen Field Name |
Midwinter OS Field Name |
Screen Field Name |
Group |
Field Name |
Notes |
|
Created |
|
Note|Date |
entity_note |
date |
File note.xls |
|
subject |
|
Note|Subject |
entity_note |
subject |
File note.xls |
|
Text |
|
Note|Text |
entity_note |
data |
File note.xls |
Midwinter OS Screen Field Name |
Midwinter OS Field Name |
Screen Field Name |
Group |
Field Name |
Name |
|
Portfolio Account|Investment Risk Profile |
entity |
risk_profile |
If you require any data to be converted that is outside the scope of this document, IRESS will be happy to assess the data and your specific requirement. If the conversion can be done IRESS will provide an estimate of the time it will take to complete the conversion and the associated cost. Please discuss any custom requirements with your Transition Consultant.
Post conversion checking instructions
Once the conversion has taken place you will need to go through the data to ensure that everything has converted correctly. We recommend that you run a client list as well as check a 10-20 clients in full, comparing software to software where possible.
If any issues are discovered, the conversion analyst will need the following information to investigate and resolve the issues:
This information will be submitted in the Feedback Form provided in Appendices F
The screen shots below illustrate how you should run your post conversion data check.
Run a ‘Client List’ management report:
This will allow you to produce a client list report to check all clients have converted.
Go through a client file from start to finish:
If IPS data has been converted:
Note: The default is to ONLY bring across manual data and for all datafeed data to be refreshed from inception post conversion. |
The following are recommended settings for the Internet Explorer browser to access XPLAN.
Set the security level for Trusted Sites by:
Complete this form if you have identified an issue with your converted data and wish IRESS to investigate if there was a problem with the conversion.
Complete your XPLAN Transitions Conversion Feedback Form here
This form must be completed and returned to your transition consultant once you have checked your converted data in XPLAN and verified that all has been converted. In the absence of feedback, your conversion will be considered finalised after a period of ten working days.
Complete your XPLAN Transitions Data Conversion Sign Off Form here
IRESS Wealth Management | XPLAN Transitions | Platform to XPLAN Conversion Guide