/*05.24.
18*/
create table hhospaccreditation (
pfacility varchar(4) not null,
paccreno varchar(20) not null,
validity datetime not null,
phospitalcode varchar(6) not null,
pusername varchar(45) default null,
ppassword varchar(45) default null,
datemod datetime not null,
entryby varchar(45) not null,
pstatus varchar(1) not null,
pfacilityname varchar(100) not null,
primary key (pfacility,paccreno,phospitalcode));
create table hphicdischargediagnosis (
enccode varchar(48) not null,
pdischargediagnosis varchar(500),
picdcode varchar(30),
prelatedprocedure varchar(500),
prvscode varchar(6),
pproceduredate datetime,
platerality varchar(1),
diag_cnt numeric not null,
pspecialcon varchar(5),
entryby varchar(15) not null,
modifiedby varchar(15) not null,
datemod datetime not null,
primary key (enccode,diag_cnt));
alter table hpatcon1
modify pabpothers datetime null;
alter table hpatcon1
modify pabpspecify varchar(50) null;
alter table hpersonal
add contactno varchar(50) null;
alter table hpatcon1
add (padmissiondatetime datetime null,
pdischargedatetime datetime null,
pdisposition varchar(1) null);
alter table fhud_hospitaladd accreno varchar(20) null;
alter table hpatconadd accreno varchar(20) null;
alter table hpatcon add ppatientpin varchar(12) null;
create table hphicclaimtransmittal(
pclaimnumber varchar(12) not null,
enccode varchar(48) not null,
entryby varchar(15) not null,
constraint pk_hphicclaimtransmittal primary key (pclaimnumber));
alter table tmpclaim
add entryby varchar(15) null;
alter table hprofserv
add (pwithcopay varchar(1) null,
pcopayamount decimal(12,0) null,
pinclude varchar(1) null);
alter table hphiclog
add pemailaddress varchar(150) null;
alter table hprofserv add pdoctoraccrecode varchar(20) null;
ALTER TABLE hpatcon1
MODIFY psessiondatehemodt VARCHAR(255) NULL;
ALTER TABLE hpatcon1
MODIFY psessiondateperiodt VARCHAR(255) NULL;
ALTER TABLE hpatcon1
MODIFY psessiondateradiolinacdt VARCHAR(255) NULL;
ALTER TABLE hpatcon1
MODIFY psessiondateradiocobaltdt VARCHAR(255) NULL;
ALTER TABLE hpatcon1
MODIFY psessiondateblooddt VARCHAR(255) NULL;
ALTER TABLE hpatcon1
MODIFY psessiondatebrachydt VARCHAR(255) NULL;
ALTER TABLE hpatcon1
MODIFY psessiondatechemodt VARCHAR(255) NULL;
ALTER TABLE hpatcon1
MODIFY psessiondatedebridedt VARCHAR(255) NULL;
ALTER TABLE hpatcon1
ADD psessionnoimrt varchar(1) NULL;
ALTER TABLE hpatcon1
ADD psessiondateimrt varchar(50) NULL;
ALTER TABLE hprofserv
ADD pdoctoraccrecode varchar(20) null;
ALTER TABLE hpatcon
Add pPatientpin varchar(12) null;
ALTER TABLE hprofserv
ADD pdoctorsigndate datetime null;
/*10.1.18*/
CREATE TABLE hphictransmittalno(
phospitaltransmittalno VARCHAR(45) NOT NULL,
phospitalcode varchar(10) NOT NULL,
entryby VARCHAR(15) NOT NULL,
PRIMARY KEY (phospitaltransmittalno)
);
ALTER TABLE hpatcon
ADD ptrackingnumber VARCHAR(20) NULL;
ALTER TABLE user_acc
ADD workstation varchar(255) NULL;
alter table hhospaccreditation
add cipherkey varchar(255) null;
ALTER TABLE hphicclaimstatus
add refilepath VARCHAR(45) NULL;
/*11.23.18*/
ALTER TABLE hphicclaimstatus
add refilepath VARCHAR(45) NULL;
/*Additional Database Update: 04.01.19
========== MySQL/HBSys Version ==========*/
alter table hpatchrg
add (qtyintake decimal(8,2) null,
uomintake varchar(5) null);
alter table hpatout
add (time_frequency int null,
unit_frequency varchar(5) null);
alter table hpatout
add (qtyintake decimal(8,2) null,
uomintake varchar(5) null);
insert into hphicclaimdocument values('CF4', 'Claim Form 4', 'Y');
/*04.16.19*/
alter table hprenatal
add (datemod datetime null,
entryby varchar(15) null);
alter table hdmhdr
add saltcode varchar(5) null;
alter table hpatchrg
add time_frequency int null;
alter table hpatchrg
add unit_frequency varchar(3) null;
alter table hphyexam
add (awakealert varchar(1) NULL,
alteredsensorium varchar(100) NULL,
heent_essentiallynormal varchar(2) NULL,
heent_abnopupireact varchar(2) NULL,
heent_cervlympadeno varchar(2) NULL,
heent_drymucousmembrane varchar(2) NULL,
heent_ictericsclerae varchar(2) NULL,
heent_paleconjunctivae varchar(2) NULL,
heent_sunkeneyeballs varchar(2) NULL,
heent_sunkenfontanelle varchar(2) NULL,
heent_others varchar(100) NULL,
cl_essentiallynormal varchar(2) NULL,
cl_asymchestexpansion varchar(2) NULL,
cl_decbreathsounds varchar(2) NULL,
cl_wheezes varchar(2) NULL,
cl_lumpoverbreast varchar(2) NULL,
cl_ralescracklesrhonchi varchar(2) NULL,
cl_interribclaretract varchar(2) NULL,
cl_others varchar(100) NULL,
cvs_essentiallynormal varchar(2) NULL,
cvs_disapexbeat varchar(2) NULL,
cvs_heavesthrills varchar(2) NULL,
cvs_pericarbulge varchar(2) NULL,
cvs_irregularrhythm varchar(2) NULL,
cvs_muffledheartsounds varchar(2) NULL,
cvs_murmur varchar(2) NULL,
cvs_others varchar(100) NULL,
abd_essentiallynormal varchar(2) NULL,
abd_abdrigidity varchar(2) NULL,
abd_abdtenderness varchar(2) NULL,
abd_hyperbowelsounds varchar(2) NULL,
abd_palpablemass varchar(2) NULL,
abd_tympdullabdomen varchar(2) NULL,
abd_uterinecontraction varchar(2) NULL,
abd_others varchar(100) NULL,
guie_essentiallynormal varchar(2) NULL,
guie_bldstainedinexamfinger varchar(2) NULL,
guie_cervicaldilatation varchar(2) NULL,
guie_presenceabnodis varchar(2) NULL,
guie_others varchar(100) NULL,
skinex_essentiallynormal varchar(2) NULL,
skinex_clubbing varchar(2) NULL,
skinex_coldclammyskin varchar(2) NULL,
skinex_cyanosismottledskin varchar(2) NULL,
skinex_edemaswelling varchar(2) NULL,
skinex_decmobility varchar(2) NULL,
skinex_palenailbeds varchar(2) NULL,
skinex_poorskinturgor varchar(2) NULL,
skinex_rashespetechiae varchar(2) NULL,
skinex_weakpulses varchar(2) NULL,
skinex_others varchar(100) NULL,
neuro_essentiallynormal varchar(2) NULL,
neuro_abnormalgait varchar(2) NULL,
neuro_abnopositionsense varchar(2) NULL,
neuro_abnodecsensation varchar(2) NULL,
neuro_abnoreflexes varchar(2) NULL,
neuro_pooralteredmemory varchar(2) NULL,
neuro_poormusctonestren varchar(2) NULL,
neuro_poorcoordination varchar(2) NULL,
neuro_others varchar(100) NULL);
alter table hmrhistoob
add (datelog datetime null,
timelog datetime null,
entryby varchar(15) null);
ALTER TABLE HGEN
ADD (edpms_code varchar(5) NULL,
edpms_desc varchar(255) NULL);
ALTER TABLE hdmhdr
ADD COLUMN packcode VARCHAR(5) null;
CREATE TABLE hdmhdr_edpms (
pDrugCode varchar(30) NOT NULL,
pDrugDesc varchar(100) NOT NULL,
pGenericCode varchar(5) NOT NULL,
pSaltCode varchar(5) NOT NULL,
pStrengthCode varchar(5) NOT NULL,
pFormCode varchar(5) NOT NULL,
pUnitCode varchar(5) NOT NULL,
pPackageCode varchar(5) NOT NULL,
pRoute varchar(500) NULL,
updsw varchar(1) NULL,
pDrugstat varchar(1) NOT NULL,
datemod datetime NOT NULL,
entryby varchar(15) NULL,
PRIMARY KEY (pDrugCode)
);
CREATE TABLE IF NOT EXISTS hsalt (
saltcode varchar(5) not null,
saltdesc varchar(30) not null,
updsw varchar(1) null,
saltstat varchar(1) null,
datemod datetime null,
PRIMARY KEY (saltcode)
);
CREATE TABLE hpesignsothers (
enccode varchar(48) NOT NULL,
datelog datetime NOT NULL,
timelog datetime NOT NULL,
pesigntype varchar(20) NOT NULL,
remarks varchar(255) NOT NULL,
datemod datetime NOT NULL,
entryby varchar(15) NOT NULL,
PRIMARY KEY (enccode,datelog,timelog,pesigntype)
);
CREATE TABLE hsignsymptoms (
enccode varchar(48) NOT NULL,
entryby varchar(15) NOT NULL,
datelog datetime NOT NULL,
timelog datetime NOT NULL,
datemod datetime NOT NULL,
alter_mental_sensorium varchar(2) NULL,
abdominal_cramp_pain varchar(2) NULL,
anorexia varchar(2) NULL,
bleeding_gums varchar(2) NULL,
body_weakness varchar(2) NULL,
blurring_vision varchar(2) NULL,
chest_pain_discomfort varchar(2) NULL,
constipation varchar(2) NULL,
cough varchar(2) NULL,
diarrhea varchar(2) NULL,
dizziness varchar(2) NULL,
dysphagia varchar(2) NULL,
dysuria varchar(2) NULL,
epistaxis varchar(2) NULL,
fever varchar(2) NULL,
frequent_urination varchar(2) NULL,
headache varchar(2) NULL,
hematemesis varchar(2) NULL,
hematuria varchar(2) NULL,
hemoptysis varchar(2) NULL,
irritability varchar(2) NULL,
jaundice varchar(2) NULL,
lower_extremity_edema varchar(2) NULL,
myalgia varchar(2) NULL,
orthopnea varchar(2) NULL,
painsite varchar(100) NULL,
palpitations varchar(2) NULL,
seizures varchar(2) NULL,
skin_rashes varchar(2) NULL,
sbbtm varchar(2) NULL,
sweating varchar(2) NULL,
urgency varchar(2) NULL,
vomiting varchar(2) NULL,
weight_loss varchar(2) NULL,
others varchar(100) NULL,
dyspnea varchar(2) NULL,
PRIMARY KEY (enccode)
);
alter table hpatchrg
add (qtyintake decimal(8,2) null,
uomintake varchar(5) null);
/*06.19.19*/
alter table hstkdelivery
add (risno varchar(45) null, iarno varchar(45) null, prno varchar(45) null, pono
varchar(45) null);
alter table res_template
add (datemod datetime null, updsw varchar(45) null, confdl varchar(45) null,
templock varchar(45) null);
alter table hperson
add henlistdte datetime not null;
alter table hprovider
modify column emptime varchar (45) null;
