As TLT is expecting to have a great

As TLT is expecting to have a greater volume of contracts going through the system. A system modification is required for a data to be interfaced and populated in CMS so that processes can be carried out automatically. In particular the vehicle and insurance information in which needs to be entered before a contract is activated. Since the implementation of CMS phase II, insurance business has not been part of TLT business as TIB was established to handle TLT insurance business. Consequently, Insurance information has not been entered in the system since, although the functionality still remain in the system. What we would like to modify is for users to be able to upload the data residing in a specific location on Oracle database. The data will include information such as vehicle information, customer details and insurance details, etc. Once the data populates the required table user can then proceed with the subsequent steps right up to contract activation. However, the data may be reloaded and replaced on an ad-hoc basis. Another important point is that if the dealer collected indicator is not marked. Then the insurance information should not be deducted from the payables. This is an important point as TLT is no longer qualified to have process insurance information in the system. Attached herewith is the layout of the tables in which data is to be populated from. Could you please review the data and please let me know in case of any queries, thank you.