A web-based pipeline report which will enable our branch personnel to register and conflict check the files. The pipeline will be posted in our company's intranet and will required password to enter. The following features are required in the program: 1. Automatic File Number Assignment. File Numbers should start with a pre-set number (i.e. 150000) and should be client oriented. For instance, when registering the file, the system should automatically assigns a number to the new file. However, if the borrower is an existing client, then a new sub-file number should be created. For example, ABC company is and existing client and its client number is 150003. A new file for ABC company should be 150003 - 1001, etc.). 2. The system should allow the user to do a conflict check on the client to avoid double registering for the same file. The conflict check should verify the Name of the client, property name, property location (by City and State) and originator (such as brokers). 3. Link To Processing Update. The system should also have the ability to update the status of the file. Under the processing Status, the program should be linked to our processing program where our processors can update the status of the file. 4. Reports. The program should allow the user to print out reports by project types, loan type, monthly origination, location, or by originators, etc. 5. Security Level. Depending on the job title of each user, a security level is assigned so access to the pipeline report is limited by the user's security level.
## Deliverables
Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. Complete copyrights to all work purchased. 50% of the fee will be released to coder upon receipt of the test model. The balance of the fee will be released upon completion of the program design in a fully functional manner. Coder is also required to provide 60-day free service for debugging.
## Platform
MS 2000 for Network Server The program can be written either in Excel or Access or other programs that maybe workable with our system.