Pink Patrol

Overview of implemented objects

Type	Name	Description	Step
Trigger	trg_appointment_status_audit
Function	fn_get_active_diagnoses
Function	fn_prescribe_medicine
Function	fn_check_doctor_availability
Procedure	prc_create_referral
Procedure	prc_add_appointment_for_referral
Procedure	prc_complete_examination
Procedure	prc_add_new_diagnosis
Procedure	prc_create_prescription
Procedure	prc_buy_prescription