City Of Valenzuela Tender

Description Item No. Quantity Unit Of Issue Item Description/specification 1 1 Lot "valenzuela City Medicine Inventory System, Requirements: 1. Develop A Web-based Valenzuela City Medicine Inventory System That Is Intuitive, Mobile Responsive, Cross-browser Adaptive / Compatible, And That Adheres To The Current Best Practices For Web Design, Privacy, And Security. 2. Improvethe City's Medicine Inventory Network Through A Web-based Portal Available For The Users 24 Hours A Day, 7 Days A Week. 3. Protected By Excessive Access Protection 4. Develop The System Framework 5. Develop The Administration/management System Specific Req: A. Manage And Monitor Stocks Between Central Warehouse And Health Centers I. 1 Central Warehouse Ii. 54 Health Centers Iii. 9 Lying-in Clinics Iv. 1 Hospital V. 1 Molecular Laboratory Vi. Medical Missions Vii. Botika-ng-bayan (doh) B. View Real-time Inventory Of Stocks, Scoped Medicines: I. +/- 100 Individual Medicines Ii. +/- 200 Total Variations (100mg, 250mg, 500mg, Etc.) Iii. Possible Multiple Suppliers/vendors Per Variant C. Monitor Low Stocks And Critical Inventory Level. Scoped: I. Stakeholders Maintain A Shared Google Sheet That Are Updated By Designated Staff Per Cwh / Hc For Weekly Updating (manual Encoding) D. Identify Fast Moving And Slow Moving E. Monitor Expiring Medicines F. Generate Notification And Procurement Requests (pr) G. Move Stocks Between Health Centers (with Notification And Confirmation) H. Scope System Users: 1. Central Warehouse Encoders 2. Health Centers Encoders 3. System Admin (it) 4. City Admin 5. Medical Mission Encoder I. Manual Data Entry (encoding In And Out) A. Item Code (character 10) B. Item Description (character 20) C. Ml/mg (variant) (character 10) D. Supplier (character 10) E. Date Received (purchase) (date [mm/dd/yyyy]) F. Date Received (donation) (date [mm/dd/yyyy]) G. Expiration Date (date [mm/dd/yyyy]) H. Critical Level 999,999 I. Stock Transfer 999,999 J. Received 999,999 K. Damage 999,999 L. Expired 999,999 M. Ending Balance 999,999 N. Report N.1. Item Code (character 10) N.2. Item Description (character 20) N.3. Ml/mg (variant) (character 10) N.4. Supplier (character 10) N.5. Date Received (purchase) (date [mm/dd/yyyy]) N.6. Date Received (donation) (date [mm/dd/yyyy]) N.7. Expiration Date (date [mm/dd/yyyy]) N.8. Critical Level 999,999 N.9. Stock Transfer 999,999 N.10. Received 999,999 N.11. Damage 999,999 N.12. Expired 999,999 N.13. Ending Balance 999,999 J. Activity Logs And Audit Trail: Encoder Entry/edit History Tracker K. Ready For Possible Future Integration With Client Barcode Scanner Hardware L. Stock Transfer Feature > Health Center To Health Center M. Prevent Patient Health Center Hopping Via Patient Enrolment Module And Patient Transaction History M.1. Patient Enrolment Module 1.1. Name (first, Middle, Last, Suffix) 1.2. City Address (house No., Street, Subd./village, Barangay) 1.3. Gender 1.4. Birthdate 1.5. Contact No/active Mobile No 1.6. Gov Issued Id Upload 1.7. Selfie Photo Upload M.2. Patient Enrolment Admin Module 2.1 View-edit-delete Account, Account Status 2.2 View Transaction History N. Display Statistical Information (frequency, Average, Etc)"