Files are received from the state street bank on a monthly and daily basis. Monthly file is received on first day of the month and called blanket file. Daily file is called composite file. Blanked file is matched against the database and search is performed to allocate contributions to the proper fund and account number. The unmatched records are left for research.
Same processing is done for the composite file.
Any of the unmatched records are researched and applied and second transmission file is sent to DST on 5th day of the month. This System will read in an input transmission file received every day from State Street and verify the validity of each record against each table. If Investor is not present in the Investor table that record becomes a Kikai record and placed in the Kikai table. Depending upon the client's selection money is divided in to the different accounts. This System is a database backed JSP Application.