SeamensMain


TEST SERVER: 192.168.1.230
user: sa
password: Whitehat2014

1 194 473 150
123@Medsys

C:\Users\myPC\Desktop\MEDSYS 2025 upgrade\PhilHealth

Gonzales, jerwin ralph adm num 3631201B outpatient
 
Medic_SavePHICSOA_Package
	
in-patient: MEDSYS
	25-0000789
	25-0000798

out-patient: 3608640b
3661060B
123456789012

tbmedlogs
	-remove 3 column below
Medic_GetForm1PatientInfo
vwMed_PatientMaster
fn_ExemptedCase
Medic_GetForm1AttendingDoc
proc_Bar_Search_Patient
[Medic_SaveMemberInfo]
[Medic_SaveMemberRelationship]
Medic_InsertUpdateForm1

PATIENT_DATA
	- add to tbAdmPatientInfoUpdate (Module, Version)
Medic_GetConfinementHour
Medic_CheckSameDayConfinement
fn_GetDateCaseRate
medic_AutoAdjust_DiscrepDiscount	
	-add to medic_dumptable (DiscountAmount, Net Amount)
Medic_ConfinementinOtherHospital
Medic_Confinementwithin90Days
Medic_UpdateAdmMedicareType (REMOVE IDNUM)
Medic_GetAdmMedicareType --only add typeCode 
tbMedActual - add FirstICDRVSAmount, SecondICDRVSAmount
Medic_SaveDiscount
Medic_DumpDiscount
	-Create tabke [Medic_DumpDiscount]
Medic_SaveHMO
tbMedActual	
	-add PPCode
Medic_DumpHMO
PHIC_ItemType varchar(50)
tmpSOA
	-add PPCode 
	-PHICAmount1 float
	-PHICAmount2 float
	-ORNUM varchar(50)
create tbSOAnum
tbMed_ExemptedCase
[fn_getpf_itemized]
[Medic_GetDoctorPF]
[Medic_SaveActualComputation_New_Package]
[vwICDRVS]
tbMedRvsGroupCode
Medic_SaveDoctorPF_Package
tbMedSpecialization
tbmed_CaseRateTerms
Medic_CaseRateCondition
Medic_CheckIfHemoChemo
Medic_GetCaseRateWithoutRestriction