Skip to content
Projects
Groups
Snippets
Help
Loading...
Sign in
Toggle navigation
H
HIMS
Project
Project
Details
Activity
Cycle Analytics
Repository
Repository
Files
Commits
Branches
Tags
Contributors
Graph
Compare
Charts
Issues
0
Issues
0
List
Board
Labels
Milestones
Merge Requests
0
Merge Requests
0
CI / CD
CI / CD
Pipelines
Jobs
Schedules
Charts
Wiki
Wiki
Snippets
Snippets
Members
Members
Collapse sidebar
Close sidebar
Activity
Graph
Charts
Create a new issue
Jobs
Commits
Issue Boards
Open sidebar
Sandeep Sagar
HIMS
Repository
c6923c5a72346e4154fca7ac2e104162ecf98780
Switch branch/tag
HIMS
Database Queries
2.UAT
Queries Before 04 April 2023- 5PM
History
Find file
Select Archive Format
Source code
Download zip
Download tar.gz
Download tar.bz2
Download tar
initial commit
· e1c9a299
Sandeep Sagar Panjala
authored
Oct 12, 2023
e1c9a299
Name
Last commit
Last update
..
1. Queue Managemnt
Loading commit data...
5. Web Notifications
Loading commit data...
Account_table_changes
Loading commit data...
Admission Lab Queries-kalyan
Loading commit data...
AlredyRan Querry
Loading commit data...
Alter queries in master module
Loading commit data...
AppointmentLog
Loading commit data...
BedListView
Loading commit data...
ChargeMODULEChanges
Loading commit data...
Cubicles
Loading commit data...
DepartmentalConsumption
Loading commit data...
Doctor Availability tables
Loading commit data...
EncounterLabChanges
Loading commit data...
Enums of eceiptAreaTypeId for Labs
Loading commit data...
INVENTORYPHASE2.1
Loading commit data...
InventoryDepartmentIndent
Loading commit data...
InventoryPhase2
Loading commit data...
JK_PAyType
Loading commit data...
Kalyan Doctor and Specialization charges
Loading commit data...
Kalyan Labs in Admission
Loading commit data...
Kalyan ModulesMasterColumn in Respective Tables
Loading commit data...
Kalyan Services in Admisions and Charge Module
Loading commit data...
Kalyan lab Queries
Loading commit data...
KalyanAddDoctorChanges
Loading commit data...
KalyanChanges for user and Account Table
Loading commit data...
KalyanDoctorSpecialization
Loading commit data...
KalyanNewLabsMachineinParameters
Loading commit data...
KalyanPaymentMapHelperTable
Loading commit data...
LabBarcodeChange
Loading commit data...
LabChanges
Loading commit data...
LabNewChange
Loading commit data...
LabParameterQuery#1
Loading commit data...
ModificationRegistrationCharges
Loading commit data...
New Lab Concept Part 1
Loading commit data...
New Lab Concept Part 2
Loading commit data...
New Patient Changes Fernandez
Loading commit data...
NewChargeCategoriesMasters
Loading commit data...
NewExcelUploads
Loading commit data...
NewLabChanges
Loading commit data...
NewLabNotificationChange
Loading commit data...
NewPatientChanges
Loading commit data...
NewPatientConcept
Loading commit data...
NotificationConcept
Loading commit data...
Patient Settings
Loading commit data...
PatientCommentQuerry
Loading commit data...
PharmacyChanges
Loading commit data...
PharmacyDepartmentsChanges
Loading commit data...
PharmacyNewChanges
Loading commit data...
PharmacyPhase2
Loading commit data...
PharmacyPhase2-part 2
Loading commit data...
PharmacyProductDetails
Loading commit data...
PharmacyPurchaseBillChange
Loading commit data...
PharmacyQueryChange
Loading commit data...
PharmacyROL-ROQ-Phase 2
Loading commit data...
PharmacySettongForRetail
Loading commit data...
PhrmacySettingsChanges
Loading commit data...
ProviderLocation
Loading commit data...
ProviderMedicationConcept
Loading commit data...
ProviderRooms
Loading commit data...
Queue Logs
Loading commit data...
Queue Phase II
Loading commit data...
Queue Phase II Part 2
Loading commit data...
Queue Phase II Part 3
Loading commit data...
ReportsLocation
Loading commit data...
Revised Queue Management
Loading commit data...
Sai Package Queries
Loading commit data...
Scan Appointments
Loading commit data...
Session Issue
Loading commit data...
Shiva_Queries
Loading commit data...
Small Pharmacy Change
Loading commit data...
Srilekha
Loading commit data...
Supplier Change
Loading commit data...
TenderConcept#2
Loading commit data...
TenderConcept#3
Loading commit data...
VendorDueDate
Loading commit data...
appointment_alter
Loading commit data...
final_query
Loading commit data...
jk_NOv22_query
Loading commit data...
jk_PT_SP
Loading commit data...
kalyan SessionType and Sessions
Loading commit data...
kalyanAdmissionStoredProcedure
Loading commit data...
kalyanLabQueries
Loading commit data...
new charge type queries
Loading commit data...
newmedicationCocept
Loading commit data...
provider_new_master_tables
Loading commit data...
provider_tables
Loading commit data...
quick schedule query
Loading commit data...
scan
Loading commit data...
tej_ quick schedule query
Loading commit data...
udf fetch location
Loading commit data...
1. IgnoreForQueue Column
Loading commit data...
1.table Payment Response Log.txt
Loading commit data...
Add ReqNo in BookScanAppointment.txt
Loading commit data...
AddcolnqryForOTRoom.txt
Loading commit data...
AdmissionPayType.txt
Loading commit data...
Alter BookScanAppointment.txt
Loading commit data...
AlterQueryforSalucro.txt
Loading commit data...
AlterTables.txt
Loading commit data...
AlterTablesForSalucro.txt
Loading commit data...
Alter_Tbl_AuditLog.txt
Loading commit data...
AppTrans_table_newCol_jk.txt
Loading commit data...
AppointmentCheckPointsTable.txt
Loading commit data...
Appointment_Paytype_Query.txt
Loading commit data...
ApptCheckPtTableUpdates.txt
Loading commit data...
AptReportFunctionQry.txt
Loading commit data...
BedTypeColumn.txt
Loading commit data...
BloodGroup_to_patient.txt
Loading commit data...
CaseType_table_query.txt
Loading commit data...
DoctorUnitMater_shivani.txt
Loading commit data...
DynamicReportTable.txt
Loading commit data...
Dynamic_template.txt
Loading commit data...
EmployeeShift.txt
Loading commit data...
Free_Followup.txt
Loading commit data...
GynEncounter.txt
Loading commit data...
HIMS_master_paycat.txt
Loading commit data...
InsertQryForModuleMaster.txt
Loading commit data...
InventoryPurchase_Report_LocationWise.txt
Loading commit data...
Kalyan ModuleMasterAdd Column.txt
Loading commit data...
LabQuery_Receive_.txt
Loading commit data...
Lab_Barcode_Related.txt
Loading commit data...
Lab_Query.txt
Loading commit data...
NewPatientChanges.txt
Loading commit data...
NewTotal_udf_uiReport_fetch_Appointments_Location.txt
Loading commit data...
New_udf_FetchPatients_For_QuickSchedule.txt
Loading commit data...
New_udf_uiReport_Receipts_Admissions_Location.txt
Loading commit data...
New_udf_uiReport_Receipts_Appointments_Location.txt
Loading commit data...
New_udf_uiReport_fetch_Appointments_Location.txt
Loading commit data...
OTREgCaseTypeAlter.txt
Loading commit data...
OTRegLocAlter.txt
Loading commit data...
OTRegisterQry.txt
Loading commit data...
OTroomSurgeryMapTblQry.txt
Loading commit data...
PatientAlterQueries.txt
Loading commit data...
PatientExcelHistoryqry.txt
Loading commit data...
PaymentModuleInsertQuery.txt
Loading commit data...
Paytype_Query.txt
Loading commit data...
Pharma_query4Bug.txt
Loading commit data...
PharmacyPurchaseReportFuncQry.txt
Loading commit data...
ProviderBreak Table.txt
Loading commit data...
Queries of ObEncounter.txt
Loading commit data...
Query.txt
Loading commit data...
Query_Lab_Task.txt
Loading commit data...
Queue_status_query.txt
Loading commit data...
README.txt
Loading commit data...
ReceiptAreaTypeTableUpdates.txt
Loading commit data...
ReferralDoctor_newMaster.txt
Loading commit data...
Referredby insert qry.txt
Loading commit data...
Settings.txt
Loading commit data...
Settings_jk.txt
Loading commit data...
TBL_Master_FloorLocation.txt
Loading commit data...
TagDoctorQuery_shivani.txt
Loading commit data...
UpdatedAptReportFunctionQry.txt
Loading commit data...
adding columns in book scan apt.txt
Loading commit data...
adding foreign key const.txt
Loading commit data...
admission_alter.txt
Loading commit data...
alter OBEncounter_table.txt
Loading commit data...
alter provide availability table.txt
Loading commit data...
alter table in Appointment table.txt
Loading commit data...
alter table in provider avaialblity table.txt
Loading commit data...
alterOTRoom.txt
Loading commit data...
alterObEncounterTable.txt
Loading commit data...
alterQryForDeptTble.txt
Loading commit data...
alterQryForOTRoom.txt
Loading commit data...
alterQryForSurgery.txt
Loading commit data...
alterSurgeyLoc.txt
Loading commit data...
alter_admission_query.txt
Loading commit data...
alter_encounter.txt
Loading commit data...
alter_patient_table.txt
Loading commit data...
alterpatientTable.txt
Loading commit data...
alterquery_patienttable.txt
Loading commit data...
alterscantable.txt
Loading commit data...
altrQryForPracticeLocations.txt
Loading commit data...
app settings add keys.txt
Loading commit data...
appointmentlogtableupdate.txt
Loading commit data...
appttransactiontableupdate.txt
Loading commit data...
blood group column query.txt
Loading commit data...
charge type availability.txt
Loading commit data...
charge_jk_query.txt
Loading commit data...
chargecategoryLaboct21kalyan.txt
Loading commit data...
cubicle.txt
Loading commit data...
datesquery.txt
Loading commit data...
deleteQueryFromSrilekha.txt
Loading commit data...
doctor drop down in quick scheudule active in active query.txt
Loading commit data...
done with udf_employee_new_revenue_reports.txt
Loading commit data...
himsAlterQry.txt
Loading commit data...
idproof.txt
Loading commit data...
inserQryForAnaesthesiatype.txt
Loading commit data...
insert enum.txt
Loading commit data...
insert lookup tables.txt
Loading commit data...
ivftable.txt
Loading commit data...
logtype_insertQuery_shivani.txt
Loading commit data...
mobile query change.txt
Loading commit data...
mounikapgsqlQueries.txt
Loading commit data...
new quick schedule doctor drop down query.txt
Loading commit data...
new_pharmacybills_report.txt
Loading commit data...
new_udf_DailySalesReportByMedication.txt
Loading commit data...
new_udf_PatientMedicationReport.txt
Loading commit data...
order-prescription.txt
Loading commit data...
otregAltQry.txt
Loading commit data...
otroomAvaialbility.txt
Loading commit data...
outpatientReportFuncQry.txt
Loading commit data...
paientFilterquery.txt
Loading commit data...
patient function query.txt
Loading commit data...
patient qry.txt
Loading commit data...
paytypesalucrocolumn.txt
Loading commit data...
practiceLocQry.txt
Loading commit data...
provider availablity table drop follow up columns.txt
Loading commit data...
provider charge type query.txt
Loading commit data...
provider schedule charges table adding follow up columns.txt
Loading commit data...
query for lab booking detail_tej.txt
Loading commit data...
query update for followup changes.txt
Loading commit data...
query1.txt
Loading commit data...
quick schedule op doctor drop down change query.txt
Loading commit data...
quick schedule vikas changes.txt
Loading commit data...
receipt _Link For_registration_Patient.txt
Loading commit data...
roomcharge queries.txt
Loading commit data...
scan machine availability.txt
Loading commit data...
scan_queries.txt
Loading commit data...
scanavailability_logtype_query.txt
Loading commit data...
setting insert query.txt
Loading commit data...
shiva_Roles_Except_Patient.txt
Loading commit data...
surgeryInstQry.txt
Loading commit data...
ticket_alter_table.txt
Loading commit data...
udf_FetchPatientsFilter_For_Appointment1.txt
Loading commit data...
udf_PharmacyBills_Report.txt
Loading commit data...
udf_ProductPurchaseReport(text, text, integer, text, text, date, date, boolean, text).txt
Loading commit data...
udf_emloyee_new_revenue.txt
Loading commit data...
udf_uiReport_fetch_Appointments_Location.txt
Loading commit data...
userExcelHistory.txt
Loading commit data...
visit type availabilty new change.txt
Loading commit data...
README.txt