3.3 Data Take on
This topic explains the process of actual taking on of the data.
- Take on of information
- Verification of the information taken on
Take on of information
In the case of a manual take on, this step would involve the manual entry of the information into the system. This information could include static and transaction information. The data entry will be done by the end users with the Oracle Financial Services Software Limited consultants assisting them in the same. The data conversion documents prepared during the data preparation exercise will be used here.
In the case of an automated take on operation, the conversion program is run during this stage which will bring the data into the system. A manual check of the data imported through reports can be carried out notwithstanding the fact that the reliability of the conversion program was tested during the earlier step. The reports listed in the above table can be used for checking. This verification exercise is to be done jointly by the client and the implementation team.
On successful completion of the checking exercise, a sign off of the data conversion milestone is done. The live database, data conversion test database and the conversion utility are backed up immediately.
Verification of the information taken on
The verification of the data entered can be carried out through the process of Data Callback. In this process the data imported is verified by manually checking the reports available in the system.
Table 3-1 List of reports
| Screen / Report / Inquiry | Module | Information verifiable | Type of information |
|---|---|---|---|
| User Profile Report | FMG | Users | NA |
| User Profile Details Report | FMG | Access rights of users | NA |
| Entity Details Report | FMG | Details of entities set up in the system | NA |
| Bank Maintenance | FMG | Details of banks set up in system | NA |
| Broker Maintenance | FMG | Details of brokers set up in system | NA |
| Holiday Maintenance | FMG | Details of holidays set up | NA |
| Domicile Maintenance | FMG | Details of countries set up | NA |
| Identification Maintenance | FMG | Details of identification types | NA |
| Corporation Maintenance | FMG | Details of corporation types | Static Information |
| Occupation Maintenance | FMG | Details of occupations | NA |
| Investor Category Set- up | FMG | Details of investor categories set up | NA |
| Fund Family Maintenance | FMG | Details of Fund Family Set-up | NA |
| Fund Type Maintenance | FMG | Details of Fund Type Set- up | NA |
| Fund Rule Report | FMG | Details of Fund Rules | NA |
| View Load Details Inquiry | AGY | Load details set up | NA |
| View Unit Holder Details Inquiry | AGY | Unit holder information | NA |
| View Agents | AGY | Agent Details | NA |
| View Agency Branch | AGY | Agency Branch Details | NA |
| Standing Instruction Report | FMG | Details of Standing Instructions set up | NA |
| Fund Activity Report | AGY | Details for transactions for a fund | NA |
| View Unit Holder Balance | FMG | Details of Unit Holder Balances | NA |
| Allocation Error Reports | AGY | Details of all the transactions failed during allocation | NA |
| Transaction Summary Reports | FMG | Details of Transaction allocations | Transaction Information |
| Fee / Incentive Report | FMG | Details of loads applied | NA |
| UH Acknowledgement Report | AGY | Details of the Unitholders in the system | NA |
| Fund Dividend Maintenance | FMG | Details of dividend set up information | NA |
| View Dividend Payment Details | FMG | Details of dividend payout | NA |
| Reinvestment Report | FMG | Details of reinvestments done | NA |
| Annuity Failure Report | FMG | NA | NA |
| Product Bank Suspense Report | FMG | NA | NA |
| Annuity Forecast Report | FMG | NA | NA |
| Capital Gains Tax Report | FMG | Details regarding the Capital Gains Taxes | NA |
Controls
The Data Take on should start only after the data to be taken on has been checked and signed off. While the client should verify the validity of the data, the implementation team should check the compatibility of the data with the system.
On completion of the testing of the data conversion program, a sign off should be obtained.
A sign off should be obtained on completion of import and verification of the data in the live databases. The live database and the conversion utility should be backed up.
Parent topic: Data Setup/Conversion