--Requirement field of Type of stay
insert into paTIENT_DATA..tbAdmReqEntrySettings (EntryID,Entry,Status) values
('24','Type of Stay','0')

go

--Disallow editing of admdate greater than charges date
Update PATIENT_DATA..tbAdmittingSetup set isAllowCheckAdmdateGreaterThanCharges='1'
go

--check paending request

alter table PATIENT_DATA..tbadmittingsetup
add IsAllowCheckPendingRequestOnRoomTransfer bit default(0)
go
update PATIENT_DATA..tbAdmittingSetUp set IsAllowCheckPendingRequestOnRoomTransfer=1 
go