The Project involves in customizing our sugar crm installation with additional fields and needs to design appropriate workflows and email reminders according to the conditions described below:
Parameters to be tracked over the year:
Weight - 12 times i.e.. one per every visit every month
BMI - 12 times | to be calculated on the basis of Height and weight
Fasting Blood Sugar (FBS) - 3 times for Secure & 6 times for Total in terms of reminders
Post Prandial Blood Sugar - 3 times for Secure & 6 times for Total in terms of reminders
HBA1C - 4 times | once every quarter
Lipid Profile - 4 times | once every quarter but not 1st and 3rd time is mandatory
Serum Creatinine - 2 times maximum | 1st time is mandatory
Urine Microalbumin - 2 times maximum | 1st time is mandatory
Glomerular Filtration Rate (GFR) to be calculated whenever Serum Creatinine is done on the basis of Creatinine reading and age (to get formula from Dr Joshi)
Scorecard to be generated on the basis on data downloaded from the application (Refer scorecard)
Health Check Parameters other than those mentioned above to be captured (refer Diabetes Patient Tracker)
Refer Diabetes Secure & Diabetes Total latest leaflet for a calendar of services:
The doctor (PCP) is required to tick mark services as and when they are consumed
Pending and Consumed services should be visible to doctor at any point of time
If customer does not avail services at a given point in time then it becomes a red flag (Admin should be able to filter for red flags; an MIS for this will be highly useful)
Primary Care Physician (PCP) should be allotted to the Customer at the start of the program; everything with respect to the patient (Example: MIS should come with patient name & PCP name in the same row)
Besides Name, phone #, email id, plan name, effective date (when the plan started), age, gender we should also capture the following as simple check boxes:
Hypertension
Hypothyroidism
Heart Diseases
Obesity
History of angioplasty
History of CABG
History of hospitalisation due to Diabetes
Nephropathy
Neuropathy
Retinopathy
Tele-consult has top happen every month (again a part of the calendar)
All services to be availed in a particular month as a part of the calendar should come as an email reminder to the doctor with the following details:
Name
Age
Phone number
Email id
Plan name
What services need to be availed this month?
First diet consult, first physio consult, Ophthal consult, dental consult, Full System Review, In Case of an Emergency form and Health Check need to get done in the first month itself
Diabetologist consult - 1 fort Diabetes Secure & 2 for Diabetes total need to come at 3rd month and/or 7th month
Foot examination every month - refer Diabetes Patient Tracker
Biothesiometry readings 4 times a year to be captured in terms of:
Normal
Mild sensory neuropathy
Moderate sensory neuropathy
Severe sensory neuropathy
On insulin - yes/no to be mentioned every month | MIS to show which patients went from Insulin (Yes) to Insulin (No)
Current medication to be captured in text fields
Extra test results to be capture (not mandatory fields):
Vitamin D
Vitamin B12
PSA
Thyroid profile - individual fields for:
T3
T4
TSH
Vaccines done / not done ticks: (admin should be able to filter)
Pneumococcal vaccine - once
Influenza - every year (so done this year?)
Hepatitis A - zero & 6th month (twice; completed - yes/ no)
Hepatitis B - zero, 1st month & 6th month (thrice; completed - yes/no)
Typhoid vaccine - every 3 years (done/ not done?)
Admin to have filter rights for all abnormalities or trend in increasing readings or services not availed on time or other complications (example: Hypertension etc.. listed above)
i am topper student of MCA
i work many project like this, and many happy client
mostly i need more time to complete project ,but at the end you are happy