Texas Wholesaler Distributer Database Capstone

Project description: For this capstone project, I improve the Texas Wholesaler Distributer Database and achieve the process of partial automation for the Prescription Monitoring Program (PMP) of Texas State Board of Pharmacy. Currently, PMP staff manage prescription data manually. This project improves this database by migrating increasing functionality to allow PMP staff the ability to manage and import wholesaler data updates with some level of automation. My work is to develop a website to upload files, validate uploaded files in ARCOS format, inform wholesalers of files upload status and clean out previously loaded files automatically.

1. Interview with workers to know the whole work process

2. Study the specific ARCOS format requirement.

In terms of ARCOS format, I study the following two files.

• ARCOS Registrant Handbook
• TWDD FAQ

3. Develop a public website to upload a file

• Sale files: uploading the file directly;
• No-sale files: uploading the file that the transaction code is 7 or checking the no-sale box directly;

4. Validate the file uploaded to public server and save the file to a specified folder through PHP

5. Inform wholesaler of the file upload status

6. Clean out previously loaded files automatically