Project Summary
To Develop an Integrated Clinical Record Management and Decision Support System as an Enterprise Resource Planning Suite. We have an aim and that is to have a Single Database and a single Application to access the same from any where as far as possible to manage all our activities. For a more detailed explanation please refer to the Product Features List.
Key Words
ERP,Health, Medical Records, Medical Reports, Laboratory Equipment, Clinics,Enterprise Resource Planning, Clinical Laboratories
Introduction
Setup a centralised Database that is robust enough to encompass the different activities of a Clinical Laboratory or Medical Testing Institution of any Size. Have a simple and a robust Application that shall allow us to access this Database from any part of the World with Security measures incorporated and Access to the Specified Persons with functions specific to their activities. Related reports and information will be shared between Different Departments that are customised and are of a practical utility.
Origin Of Proposal
By Our Experience and Observation we have found that Many a times Vital Information like Breakdowns in Testing Equipment Is not Available in time when a Patient is in need of those Services, As well Data Entry Operators who are Qualified are not easily avaialble as Ecconomy Thinks they are a Costly Breed to Groom and Maintain.
Problem Definition
To have a Common Standard for Database Architecture so that it can be Shared across many different Levels in the Organisation and the External Environment like Docotrs, Clinics, Medical Institutions, Government, Funding Agencies, Tax Authorities etc for Decision making and a General Harmonious and Higher Progress.
Work plan
We will be starting with MS SQL Server as a Database, C# as Code Behind language and MVC.net with HTML as the Front End to start with and Development on other Databases and other Languages at a later stage depending on the Demand and need of the Technology.
Project Information
Review and Status of Research and Development in the Subject
Project Features / Product Catalog
Accounts
- Account Group
- Account Section
- Bank Account
- Expense
- Expense Type
- Income Head
- Income Head Type
- Tax Duty
- Tax Type
- Payment Issu Parent
- Payment Mode
- Payment Rcpt Parent
- Payment Rcpt Det
- Payment Rcpt Parent
- Asset Block
- Asset
- Asset Type Tax Config
Calendar
- Calendar Events Det
- Holiday
- Holiday Type
- Yearly List Of Holidays
Security
- User Type
- User Type Report Privilages
- User Type Privilages
Contacts Management
- Caste
- Contact Addr
- Contact Category
- Contact Group
- Contact Hobbies
- Contact Languages
- Contact
- Contact Multiple Roles Det
- Contact Qualifications
- Contact Skills
- Contact Type
- Hobby
- Quota Caste Allocation
- Quota
- Skill
- Skill Type
Location
- City
- Country
- District
- State
Language
- Language
- Language Type
Inventory Management
- Asset Block Alloc Det
- Asset Block Type
- Asset Class
- Asset Type
- Issu Parent
- Item Designation
- Item Designation Property Sub Type Std Val
- Item Designation Property Val
- Item Form
- Item Form Property Sub Type Config
- Item Grade
- Item Info
- Item Process Config
- Item Property
- Item Property Fixed Sub Type
- Item Property Sub Type
- Item Property Sub Type Values
- Item Property Type
- Item Property Val
- Item Pur Track
- Item Service
- Item Service Category
- Item Service Group
- Item Service Sub Type
- Item Service Type
- Item Store Shelf StockShelf
- U O M
- Product Feature
- Product Set Det
- Product Set Parent
- Product Sub Feature
- Mtl Reqt Det
- Mtl Reqt Parent (BOM)
Human Resource Dept
- Employee Benefit
- Employee Benefit Type
- Employee Cur Sal Comp
- Employee Cur Sal Deduct
- Employee Deduct
- Employee Deduct Type
- Employee Group Benefit
- Employee Group Deduct
- Employee Group Leave Type
- Employee Group Sal Comp
- Employee Leave
- Employee Leave Open Bal
- Employee Leave Register
- Employee Leave Type
- Employee Loan Apply
- Employee Loan Disburs
- Employee Loan Purpose
- Employee Log Details
- Employee Config
- Employee Contribute
- Employee Sal Advance
- Employee Sal Comp
- Employee Sal Comp Type
- Employee Sal
- Employee Sal Parent
Purchase
- P O Det
- P O Parent
- P O Schedule
- P O Shdl
- P O Terms
Planning
- Plan
- Plan Type
- Production Plan
Production
- Processes
- Machine Item Process Config
- Machines Avail
System Admin
- Data Entry Mode
- Menu
- Menu Type
- Module
- Module Table Details
- Org Education Vertical Config
- Owner Addr
- Trans Type
- Table Rec Year Serial No
- Table
- Team
Sales
- Quote Det
- Quote Det Rev
- Quote Parent
- Quote Parent Rev
- Quote Terms
- S O Det
- S O Parent
- S O Terms
- Pack List Det
- Pack List Parent
- Bill Det
- Bill G S T Det
- Bill Other Charges Det
- Bill Parent
- Bill Terms
Sample Entity Relationship Diagram
Sample Entity Relationship Diagram
Time Schedule of Work Plan
| Sl No | Broad Work Element | Time Estimates In Months |
| 1 | Developing a Core Team who can type in all Languages that are used in India, These people will be developing the Resources Files that will be necessary so that users are comfortable in using the Clinical Record Mangement ERP. | 2 |
| 2 | Developing a Simple Call Center that can explain the process that is to be employed for running and using the ERP, the same team will train other Startups to make sure that they will lend support for Data Entry Operators and other users who will be given adequate support as and when necessary. | 3 |
| 3 | We will be further Developing and Implementing an application that is nearly ready along with Design Rights to modify the Database and Front End in the near future. | 2 |
| 4 | We will need Data Entry Operators who can Collect Data initially for a Patricular Geo Physical Locality, this is a massive work and may need more resources. | 3 |
| 5 | In short the Application software must support all the Core Functionalities that are necessary to Run a Clinical Record Management System. | 2 |
| 6 | For a more detailed Explanation please refer to the Product Features. | 1 |
| 7 | Prime Importance will be to Develop an Implementation Methodology for the Most Largest Size of a Clinic or Medical Institute Possible. | 1 |
| 8 | Next Step once the First version is built successfully Implemented at least in One Locality must be Extended Horizontally Across the Country. | Need to Workout Details |
Minimum Group Organisation
| Sl No | Group Code | Position Description | No Of Posts |
| 1 | 1 | Testing Administrator | 1 |
| 2 | 2 | Assistant DB Architect | 4 |
| 3 | 3 | Internal User Interface Administrator | 1 |
| 4 | 4 | Data Mapper Administrator | 2 |
| 5 | 5 | Process Experts | 2 |
| 6 | 6 | Data Entry Operators | 10 |
| 7 | 7 | Accountants | 1 |
| 8 | 8 | Process Designers | 2 |
| 9 | 9 | Internal Marketing Administrator | 1 |
| 10 | 10 | Internal Project Manager | 1 |
Suggested plan of action for utilization of Research Outcome Expected from the project
These Details may have to worked out in Association with All India Medical Association, Rotary Foundaations and other Organisations who can show some Interest in the Project.
Budget Estimates: Summary
| Item | BUDGET | (in Rupees) | |||
| 1st Year | 2nd Year | 3rd Year | Total | ||
| A. | Recurring | ||||
| Salary Expenses | 67500000 | 74250000 | 81675000 | 223425000 | |
| Printing and Stationery | 300000 | 330000 | 363000 | 993000 | |
| Travelling Expenses | 2400000 | 2640000 | 2904000 | 7944000 | |
| Others | 2400000 | 2640000 | 2904000 | 7944000 | |
| B. | Equipment To be Built If Applicable | 0 | 0 | 0 | 0 |
| Grand Total (A+B) | 72600000 | 79860000 | 87846000 | 240306000 |
Budget for Salaries/Wages
| Position Description | No Of Posts | Monthly Emoluments | BUDGET | (in Rupees) | ||
| 1st Year | 2nd Year | 3rd Year | Total | |||
| Testing Administrator | 1 | 250000 | 3000000 | 3300000 | 3630000 | 9930000 |
| Assistant DB Architect | 4 | 250000 | 12000000 | 13200000 | 14520000 | 39720000 |
| Internal User Interface Administrator | 1 | 250000 | 3000000 | 3300000 | 3630000 | 9930000 |
| Data Mapper Administrator | 2 | 250000 | 6000000 | 6600000 | 7260000 | 19860000 |
| Process Experts | 2 | 250000 | 6000000 | 6600000 | 7260000 | 19860000 |
| Data Entry Operators | 10 | 200000 | 24000000 | 26400000 | 29040000 | 79440000 |
| Accountants | 1 | 125000 | 1500000 | 1650000 | 1815000 | 4965000 |
| Process Designers | 2 | 250000 | 6000000 | 6600000 | 7260000 | 19860000 |
| Internal Marketing Administrator | 1 | 250000 | 3000000 | 3300000 | 3630000 | 9930000 |
| Internal Project Manager | 1 | 250000 | 3000000 | 3300000 | 3630000 | 9930000 |
| Totals | 67500000 | 74250000 | 81675000 | 223425000 |
Budget for Consumable Materials
| Item | BUDGET | (in Rupees) | ||
| 1st Year | 2nd Year | 3rd Year | Total | |
| Printing and Stationery | 300000 | 330000 | 363000 | 993000 |
Budget for Travelling Expences
| Item | BUDGET | (in Rupees) | ||
| 1st Year | 2nd Year | 3rd Year | Total | |
| Travelling Expenses | 2400000 | 2640000 | 3630000 | 8670000 |
Budget for Other Expenditures
| Item | BUDGET | (in Rupees) | ||
| 1st Year | 2nd Year | 3rd Year | Total | |
| Others | 2400000 | 2640000 | 2904000 | 7944000 |
Budget for Equipment If Applicable
| Item | BUDGET | (in Rupees) | ||
| 1st Year | 2nd Year | 3rd Year | Total | |
| Equipment To be Built If Applicable | 0 | 0 | 0 | 0 |
Infrastructural Facilities
| SrNo | Infrastructural Facility | Status |
| 1 | Workshop Facility | Yes – Sharing basis |
| 2 | Water & Electricity | Yes - Sharing basis |
| 3 | Laboratory Space/ Furniture | Yes - Sharing basis |
| 4 | Power Generator | No |
| 5 | AC Room or AC | No |
| 6 | Air Cooler If Tempratures are too High | Yes |
| 7 | Telecommunication including e-mail & fax | Yes |
| 8 | Transportation | Yes |
| 9 | Administrative/ Secretarial support | Yes – Sharing Basis |
| 10 | Information facilities like Internet/ Library | Yes – Sharing Basis |
| 11 | Computational facilities | Yes – Sharing Basis |
| 12 | Animal/ Glass House | No |
| 13 | Any other special facility being provided | Not Required |
Equipment available with the Institute/ Group/ Department/ Other Institutes for the project
| Sl No | Equipment Available | Generic Name Of Equipment | Qty Available | Model Make And Year Of Purchase | Remarks Including Accessories Available And Current Usage Of Equipment |
| 1 | With Group | Laptops | 1 | 2016-2016 | 60% capacity utilisation |
| 2 | With Group | Laptops | 1 | 2016-2016 | 60% capacity utilisation |
| 3 | With Group | Laptops | 1 | 2016-2016 | 60% capacity utilisation |
