ALTER TABLE
   DONORLIST
ADD
   (
      DND_DOB             DATE,
      DNC_Nationality     VARCHAR2(30 BYTE),
      DNC_Occupation      VARCHAR2(30 BYTE),
      DNC_Married         CHAR (1 BYTE),
      DNC_RelationStatus  CHAR (1 BYTE),
      DNC_Relation        VARCHAR2(30 BYTE),
      DNC_PatientStatus   CHAR (1 BYTE),
      DNC_Patientid       CHAR (10 BYTE),
      DNC_Mobile          VARCHAR2(30 BYTE),
      DNC_WorkPhone       VARCHAR2(30 BYTE),
      DNC_EmailID         VARCHAR2(30 BYTE),
      DNC_Weight          NUMBER (10);
	  DNC_DonorType     CHAR (4 BYTE),
      DNC_CampID   INT,
	  DNC_ENTDATE     DATE default sysdate,
      DNC_USERCODE   CHAR (4 Byte)
);


CREATE TABLE BloodBankCamps(
         CampN_ID             INT NOT NULL,
         CampD_Date          DATE NOT NULL,
         CampC_Name        VARCHAR2(30 BYTE),
         CampC_Place         VARCHAR2(30 BYTE),
         CampC_Address     VARCHAR2(250 BYTE),
         CampC_Remarks    VARCHAR2(250 BYTE),  
         CampC_EntDate      DATE default sysdate,
         CampC_UserCode   CHAR (4 Byte),      
         CONSTRAINT BloodBankCamps_pk PRIMARY KEY (CampN_ID)
);

CREATE TABLE BloodDonorTypes(
         BDTC_Code           CHAR (4 BYTE),
         BDTC_Name          VARCHAR2(30 BYTE),
         CONSTRAINT BloodDonorTypes_pk PRIMARY KEY (BDTC_Code)
);


CREATE TABLE BloodInfections(
         BIC_Code           CHAR (4 BYTE),
         BIC_Name          VARCHAR2(30 BYTE),
         CONSTRAINT BloodInfections_pk PRIMARY KEY (BIC_Code)
);


CREATE TABLE BloodBackFrontDetails(
         BBFD_Code           CHAR (4 BYTE),
         BBFD_Name          VARCHAR2(30 BYTE),
         CONSTRAINT  BloodBackFront_pk PRIMARY KEY (BBFD_Code)
);


ALTER TABLE
   BloodBackFrontDetails
ADD
   (
      SORDER             INT
   );



CREATE TABLE BloodScreeningTests(
     BST_Code           CHAR (4 BYTE),
     BST_DonorID        CHAR (4 BYTE),
	 BST_WeightONtest   NUMBER (8,2),
	 BST_maxBloodDrawn  NUMBER (8,2),
	 BST_Hemoglobin     NUMBER (8,2),
	 BST_minusA         CHAR (1 BYTE),
	 BST_minusAB        CHAR (1 BYTE),
	 BST_AC             CHAR (1 BYTE),
	 BST_AntiH          CHAR (1 BYTE),
	 BST_BC             CHAR (1 BYTE),
	 BST_minusD         CHAR (1 BYTE),
	 BST_Lectin         CHAR (1 BYTE),
	 BST_OC             CHAR (1 BYTE),
	 BST_SC             CHAR (1 BYTE),
	 BST_AbnormalHemo   CHAR (1 BYTE),
	 BST_AntiHIV        CHAR (1 BYTE),
	 BST_HBSAG          CHAR (1 BYTE),
	 BST_HCV            CHAR (1 BYTE),
	 BST_IrregudantB    CHAR (1 BYTE),
	 BST_MP             CHAR (1 BYTE),
	 BST_VDRL           CHAR (1 BYTE),
	 BST_RecStatus      CHAR (1 BYTE),
	 BST_Reason         VARCHAR2(250 BYTE),
	 BST_LabTechCode    CHAR (4 BYTE),
     BST_ScreeningDate  DATE,
     BST_Remarks        VARCHAR2(250 BYTE),
	 BST_ENTDATE        DATE default sysdate,
     BST_USERCODE       CHAR (4 Byte),
     CONSTRAINT  BloodScrnTest_pk PRIMARY KEY (BST_Code)
);

ALTER TABLE BloodScreeningTests ADD CONSTRAINT FK_LL_Bscreening_Users FOREIGN KEY (BST_USERCODE) REFERENCES  Users(US_CODE) ;

ALTER TABLE BloodScreeningTests ADD CONSTRAINT FK_LL_Bscreening_DonorList FOREIGN KEY (BST_DonorID) REFERENCES  DONORLIST(DNC_CODE) ;


ALTER TABLE
   BloodScreeningTests
ADD
   (
      BST_minusB             CHAR (1 BYTE)
   );

alter table 
   BloodScreeningTests
modify 
( 
   BST_DONORID   CHAR (6 Byte)
);


ALTER TABLE
   BloodScreeningTests
ADD
   (
      BST_BleedingApproval             CHAR (1 BYTE) default 'P'
   );

ALTER TABLE
   BloodScreeningTests
ADD
   (
      BST_ApprovedDoctor             CHAR (4 Byte) default NULL
   );

ALTER TABLE
   BloodScreeningTests
ADD
   (
      BST_BleedingCode             CHAR (4 Byte) default NULL
   );


   CREATE TABLE BloodBankBleedingDetails(
         BBBD_BleededCode     CHAR (4 BYTE),
         BBBD_ScreenedCode    CHAR (4 BYTE),
         BBBD_DonorID         CHAR (4 BYTE),
         BBBD_BagNo           CHAR (10 Byte),
         BBBD_BleededDate     DATE,
         BBBD_BleededBy       CHAR (4 BYTE),  
         BBBD_EntDate         DATE default sysdate,
         BBBD_UserCode        CHAR (4 Byte),      
         CONSTRAINT BBBdetails_pk PRIMARY KEY (BBBD_BleededCode)
);

ALTER TABLE BloodBankBleedingDetails ADD CONSTRAINT FK_LL_BBBD_Users FOREIGN KEY (BBBD_UserCode) REFERENCES  Users(US_CODE) ;

ALTER TABLE BloodBankBleedingDetails ADD CONSTRAINT FK_LL_BBBD_Screening FOREIGN KEY (BBBD_ScreenedCode) REFERENCES  BloodScreeningTests(BST_Code) ;

ALTER TABLE BloodBankBleedingDetails ADD CONSTRAINT FK_LL_BBBD_DonorList FOREIGN KEY (BBBD_DonorID) REFERENCES  donorlist(dnc_code) ;


alter table 
   BloodBankBleedingDetails
modify 
( 
   BBBD_DonorID   CHAR (6 Byte)
);


CREATE TABLE BloodRBCTypes(
         BRT_TypeCode           CHAR (4 BYTE),
         BRT_ComponentCode  CHAR (4 BYTE),
         BRT_TypeName           VARCHAR2(30 BYTE),
         CONSTRAINT BloodRBCTypes_pk PRIMARY KEY (BRT_TypeCode)
);


ALTER TABLE
   BloodBankBleedingDetails
ADD
   (
      BBBD_ComponentEntryID             CHAR (4 Byte) default NULL
   );


CREATE TABLE BloodComponentStockHeader(
         BCSH_ProcessCode           CHAR (4 BYTE),
         BCSH_ProcessDate        Date,
         BCSH_ProcessBy             CHAR (4 BYTE),
     BCSH_BleedCode             CHAR (4 BYTE), 
         BCSH_EntDate               DATE default sysdate,
         BCSH_UserCode              CHAR (4 Byte), 
         CONSTRAINT BcomponentSH_pk PRIMARY KEY (BCSH_ProcessCode)
);

ALTER TABLE BloodComponentStockHeader ADD CONSTRAINT FK_LL_BCSH_Users FOREIGN KEY (BCSH_UserCode) REFERENCES  Users(US_CODE) ;

ALTER TABLE BloodComponentStockHeader ADD CONSTRAINT FK_LL_BCSH_Bleeding FOREIGN KEY (BCSH_BleedCode) REFERENCES  BloodBankBleedingDetails(BBBD_BLEEDEDCODE) ;

CREATE TABLE BloodComponentStockDetail(
         BCSD_HeaderCode           CHAR (4 BYTE),
		 BCSD_SortOrder            INT,
         BCSD_Component               CHAR (4 BYTE),
         BCSD_Type                 CHAR (4 BYTE) default Null,
		 BCSD_BagNo                CHAR (10 Byte),
		 BCSD_BloodVolume       NUMBER (8,2),
		 BCSD_BloodPer           NUMBER (8,2),
		 BCSH_ExpiryDate       Date,
         CONSTRAINT BcomponentSD_pk PRIMARY KEY (BCSD_HeaderCode,BCSD_Component)
);

ALTER TABLE BloodComponentStockDetail ADD CONSTRAINT FK_LL_BCSD_BCSH FOREIGN KEY (BCSD_HeaderCode) REFERENCES  BloodComponentStockHeader(BCSH_ProcessCode) ;

ALTER TABLE BloodComponentStockDetail ADD CONSTRAINT FK_LL_BCSD_BldComponent FOREIGN KEY (BCSD_Component) REFERENCES  BloodComponent(BC_CODE) ;

ALTER TABLE BloodComponentStockDetail  ADD CONSTRAINT FK_LL_BCSD_BldRBCTypes FOREIGN KEY (BCSD_Type) REFERENCES  BloodRBCTypes(BRT_TypeCode) ;

ALTER TABLE
   BloodComponentStockDetail
ADD
   (
      BCSD_FinalBagNo              CHAR (14 Byte) default NULL
   );


   ALTER TABLE
   BloodComponentStockDetail
ADD
   (
      BCSD_ExpiryPeriodDays             INT default 0
   );


ALTER TABLE
   BloodComponentStockDetail
ADD
   (
      BCSD_Remarks             VARCHAR2(150 BYTE) default NULL
   );


   CREATE TABLE BloodRequestHDR(
     BR_Code               CHAR (4 BYTE),
     BR_PatientID          CHAR (4 BYTE),
     BR_BloodGroup         CHAR (4 BYTE),
     BR_IPNO           CHAR (10 Byte),
     BR_BedNo           CHAR (4 BYTE),
     BR_Indication         CHAR (4 BYTE),
     BR_RequestedDoctor        CHAR (4 BYTE),
     BR_PreTransfuse       CHAR (1 BYTE),
     BR_RemarkPreTransfuse    VARCHAR2(250 BYTE),
     BR_ReasonPreTransfuse  CHAR (1 BYTE),
     BR_RemarkReason        VARCHAR2(250 BYTE),
     BR_PregHO            CHAR (1 BYTE),
     BR_RemarksPregHO       VARCHAR2(250 BYTE),
     BR_RequestedDT         DATE,
     BR_RequiredDT          DATE,
     BR_Emergency        CHAR (1 BYTE),
     BR_SampleCollected     CHAR (1 BYTE),
     BR_EntryDT            CHAR (1 BYTE),
     BR_ENTDATE            DATE default sysdate,
     BR_USERCODE           CHAR (4 Byte),
          CONSTRAINT  BloodRequestHDR_pk PRIMARY KEY (BR_Code)
);

ALTER TABLE BloodRequestHDR ADD CONSTRAINT FK_LL_BR_Patient FOREIGN KEY (BR_PatientID) REFERENCES  Patient(PT_NO) ;

ALTER TABLE BloodRequestHDR ADD CONSTRAINT FK_LL_BR_IPADMISS FOREIGN KEY (BR_IPNO) REFERENCES  IPADMISS(IP_NO) ;

ALTER TABLE BloodRequestHDR ADD CONSTRAINT FK_LL_BR_Bed FOREIGN KEY (BR_BedNo) REFERENCES  bed(BD_CODE) ;

ALTER TABLE BloodRequestHDR ADD CONSTRAINT FK_LL_BR_ADMNREASON FOREIGN KEY (BR_Indication) REFERENCES  ADMNREASON(RS_CODE) ;

ALTER TABLE BloodRequestHDR ADD CONSTRAINT FK_LL_BR_Doctor FOREIGN KEY (BR_RequestedDoctor) REFERENCES  Doctor(DO_CODE);

ALTER TABLE BloodRequestHDR ADD CONSTRAINT FK_LL_BR_BloodGroup FOREIGN KEY (BR_BloodGroup) REFERENCES  BloodGroup(BG_CODE);

ALTER TABLE BloodRequestHDR ADD CONSTRAINT FK_LL_BR_Users FOREIGN KEY (BR_USERCODE) REFERENCES  Users(US_CODE) ;



CREATE TABLE BloodRequestDTL(
          BRD_BRcode               CHAR (4 BYTE),
          BRD_SortOrder          INT,
		  BRD_Component         CHAR (4 BYTE),
		  BRD_Type           CHAR (4 BYTE),
     BRD_Pints           INT,
          CONSTRAINT  BloodRequestDTL_pk PRIMARY KEY (BRD_BRcode, BRD_Component)
);

ALTER TABLE BloodRequestDTL ADD CONSTRAINT FK_LL_BRD_BldComponent FOREIGN KEY (BRD_Component) REFERENCES  BloodComponent(BC_CODE) ;

ALTER TABLE BloodRequestDTL ADD CONSTRAINT FK_LL_BRD_BldRBCTypes FOREIGN KEY (BRD_Type) REFERENCES  BloodRBCTypes(BRT_TypeCode) ;

ALTER TABLE BloodRequestDTL ADD CONSTRAINT FK_LL_BRD_BR FOREIGN KEY (BRD_BRcode) REFERENCES  BloodRequestHDR(BR_Code) ;



alter table
   BloodRequestHDR
drop column
   BR_EntryDT;


   alter table 
		BloodRequestHDR
	modify 
	( 
	   BR_PatientID   CHAR (10 Byte)
	);



	ALTER TABLE
   BloodRequestHDR
ADD
   (
      BR_CrossMatch             CHAR (4 BYTE) default NULL
   );


ALTER TABLE
   BloodComponentStockDetail
ADD
   (
      BCSD_IssuedStatus             CHAR (1 BYTE) default 'N'
   );


alter table 
   BloodComponentStockDetail
modify 
( 
   BCSD_FINALBAGNO   CHAR(14 BYTE)          DEFAULT 'X'                   NOT NULL
);

alter table BloodComponentStockDetail drop constraint BcomponentSD_pk;

ALTER TABLE BloodComponentStockDetail ADD CONSTRAINT BcomponentSD_pk PRIMARY KEY (BCSD_FINALBAGNO);

CREATE TABLE BloodBankCrossMatch(
     BBCM_CrossMatchCode               CHAR (4 BYTE),
     BBCM_RequestCode                  CHAR (4 BYTE),
     BBCM_ComponentCode                CHAR (4 BYTE),
     BBCM_ComponentType                CHAR (4 BYTE),
     BBCM_BagNo                        CHAR (14 Byte),
     BBCM_PintNo                       INT,
     BBCM_SalineMajor                  CHAR (1 BYTE),
     BBCM_SalineMinor                  CHAR (1 BYTE),
     BBCM_BovineMajor                  CHAR (1 BYTE),
     BBCM_BovineMinor                  CHAR (1 BYTE),
     BBCM_CombsMajor                   CHAR (1 BYTE),
     BBCM_CombsMinor                   CHAR (1 BYTE),
     BBCM_ProcessedDate                DATE,
     BBCM_ProcessedBy                  CHAR (4 BYTE),
     BBCM_ENTDATE                      DATE default sysdate,
     BBCM_USERCODE                     CHAR (4 Byte),
          CONSTRAINT  BBCM_pk PRIMARY KEY (BBCM_CrossMatchCode)
);


ALTER TABLE BloodBankCrossMatch ADD CONSTRAINT FK_BB_BBCM_BRHDR FOREIGN KEY (BBCM_RequestCode) REFERENCES  BloodRequestHDR(BR_CODE);

ALTER TABLE BloodBankCrossMatch ADD CONSTRAINT FK_BB_BBCM_BC FOREIGN KEY (BBCM_ComponentCode) REFERENCES  BloodComponent(BC_CODE);

ALTER TABLE BloodBankCrossMatch ADD CONSTRAINT FK_BB_BBCM_CT FOREIGN KEY (BBCM_ComponentType) REFERENCES  BloodRBCTypes(BRT_TypeCode);

ALTER TABLE BloodBankCrossMatch ADD CONSTRAINT FK_BB_BBCM_BCSD FOREIGN KEY (BBCM_BagNo) REFERENCES  BloodComponentStockDetail(BCSD_FINALBAGNO);

ALTER TABLE BloodBankCrossMatch ADD CONSTRAINT FK_BB_BBCM_LT FOREIGN KEY (BBCM_ProcessedBy) REFERENCES  LabTechnician(LT_CODE);

ALTER TABLE BloodBankCrossMatch ADD CONSTRAINT FK_BB_BBCM_Users FOREIGN KEY (BBCM_USERCODE) REFERENCES  Users(US_CODE);


ALTER TABLE
   BloodBankCrossMatch
ADD
   (
      BBCM_Issue                CHAR (1 BYTE)  default 'F',
      BBCM_Return                CHAR (1 BYTE)  default 'F',
      BBCM_Unuseful                CHAR (1 BYTE)  default 'F'
   );


   ALTER TABLE
   BloodBankCrossMatch
ADD
   (
      BBCM_Remarks                VARCHAR2(250 BYTE)  default '--'
   );



     ALTER TABLE
   BloodBankCrossMatch
ADD
   (
      BBCM_TimeOfAction                Date  default NULL
   );


   ------------------***************************************** Date : 21/09/2014 sunday.  Modification after discussing with Nishachechi and Manesh Chettan.


   CREATE TABLE BloodBankRacks(
         BBRC_RackID                  CHAR (4 Byte), 
         BBRC_RackName             VARCHAR2(30 BYTE),
         BBRC_EntDate                 DATE default sysdate,
         BBRC_UserCode              CHAR (4 Byte),      
         CONSTRAINT pk_BloodBankRacks PRIMARY KEY (BBRC_RackID)
);

ALTER TABLE
   BloodBankRacks
ADD
   (
      BBRC_RackActiveStatus                CHAR (1 Byte)  default 'Y'
   );


   Insert into BLOODBANKRACKS
   (BBRC_RACKID, BBRC_RACKNAME, BBRC_ENTDATE, BBRC_USERCODE, BBRC_RACKACTIVESTATUS)
 Values
   ('F001', 'FRZR-1/RX-1', TO_DATE('09/21/2014 12:57:25', 'MM/DD/YYYY HH24:MI:SS'), 'D010', 'Y');
Insert into BLOODBANKRACKS
   (BBRC_RACKID, BBRC_RACKNAME, BBRC_ENTDATE, BBRC_USERCODE, BBRC_RACKACTIVESTATUS)
 Values
   ('F004', 'FRZR-1/RX-4', TO_DATE('09/21/2014 13:00:44', 'MM/DD/YYYY HH24:MI:SS'), 'D010', 'Y');
Insert into BLOODBANKRACKS
   (BBRC_RACKID, BBRC_RACKNAME, BBRC_ENTDATE, BBRC_USERCODE, BBRC_RACKACTIVESTATUS)
 Values
   ('F002', 'FRZR-1/RX-2', TO_DATE('09/21/2014 13:00:30', 'MM/DD/YYYY HH24:MI:SS'), 'D010', 'Y');
Insert into BLOODBANKRACKS
   (BBRC_RACKID, BBRC_RACKNAME, BBRC_ENTDATE, BBRC_USERCODE, BBRC_RACKACTIVESTATUS)
 Values
   ('F003', 'FRZR-1/RX-3', TO_DATE('09/21/2014 13:00:38', 'MM/DD/YYYY HH24:MI:SS'), 'D010', 'Y');
Insert into BLOODBANKRACKS
   (BBRC_RACKID, BBRC_RACKNAME, BBRC_ENTDATE, BBRC_USERCODE, BBRC_RACKACTIVESTATUS)
 Values
   ('F005', 'FRZR-2/RX-1', TO_DATE('09/21/2014 13:00:50', 'MM/DD/YYYY HH24:MI:SS'), 'D010', 'Y');
Insert into BLOODBANKRACKS
   (BBRC_RACKID, BBRC_RACKNAME, BBRC_ENTDATE, BBRC_USERCODE, BBRC_RACKACTIVESTATUS)
 Values
   ('F006', 'FRZR-2/RX-2', TO_DATE('09/21/2014 13:00:57', 'MM/DD/YYYY HH24:MI:SS'), 'D010', 'Y');
Insert into BLOODBANKRACKS
   (BBRC_RACKID, BBRC_RACKNAME, BBRC_ENTDATE, BBRC_USERCODE, BBRC_RACKACTIVESTATUS)
 Values
   ('F007', 'FRZR-2/RX-3', TO_DATE('09/21/2014 13:01:06', 'MM/DD/YYYY HH24:MI:SS'), 'D010', 'Y');
Insert into BLOODBANKRACKS
   (BBRC_RACKID, BBRC_RACKNAME, BBRC_ENTDATE, BBRC_USERCODE, BBRC_RACKACTIVESTATUS)
 Values
   ('F008', 'FRZR-2/RX-4', TO_DATE('09/21/2014 13:01:19', 'MM/DD/YYYY HH24:MI:SS'), 'D010', 'Y');

COMMIT;


ALTER TABLE
   BloodBankBleedingDetails
ADD
   (
      BBBD_RackID             CHAR (4 Byte)
   );


   ALTER TABLE
   BloodComponentStockDetail
ADD
   (
     BCSD_RackID             CHAR (4 Byte)
   );

 ------------------***************************************** Date : 24/09/2014 Wednesday.  Modification for adding more Cross Match Parameter Values.

CREATE TABLE BloodCrossMatchParameters(
         BCMP_ID             INT NOT NULL,
         BCMP_Name          VARCHAR2(30 BYTE),
         BCMP_SortID         INT,
         BCMP_Value         CHAR(1 BYTE),
         BCMP_EntDate        DATE default sysdate,
         BCMP_ACTIVE         CHAR(1 BYTE) DEFAULT 'Y',
         CONSTRAINT Pk_BloodCrossMatchParameters PRIMARY KEY (BCMP_ID)
);

Insert into BLOODCROSSMATCHPARAMETERS
   (BCMP_ID, BCMP_NAME, BCMP_SORTID, BCMP_VALUE)
 Values
   (1, 'Compatible', 1, 'C');
Insert into BLOODCROSSMATCHPARAMETERS
   (BCMP_ID, BCMP_NAME, BCMP_SORTID, BCMP_VALUE)
 Values
   (2, 'Incompatible', 2, 'I');
Insert into BLOODCROSSMATCHPARAMETERS
   (BCMP_ID, BCMP_NAME, BCMP_SORTID, BCMP_VALUE)
 Values
   (3, 'Not Applicable', 3, 'N');

COMMIT;

------------------***************************************** Date : 26/09/2014 Friday.  Modification for Opening/Bulk Stock and Re/Pending Screening

CREATE TABLE BloodBank_BagSupplier
(
  SUPPLIERCODE   CHAR(4 BYTE)                   NOT NULL,
  SUPPLIERNAME   VARCHAR2(50 BYTE),
  ADDRESS        VARCHAR2(100 BYTE),
  PHONENUM       VARCHAR2(30 BYTE),
  MOBILENUM      VARCHAR2(30 BYTE),
  EMAILID        VARCHAR2(30 BYTE),
  CONTACTPERSON  VARCHAR2(30 BYTE),
  CREATED_BY     CHAR(4 BYTE)                   NOT NULL,
  CREATED_ON     DATE                           NOT NULL,
  STATUS         CHAR(1 CHAR)                   DEFAULT 'Y'                   NOT NULL,
  SHORTNAME      VARCHAR2(20 BYTE)              DEFAULT NULL,
  CONSTRAINT PK_BloodBank_BagSupplier PRIMARY KEY (SUPPLIERCODE)
)

Insert into WEBMENU
   (CMODULE, NMAIN_MENU, NSUBMENU_ID, NSUBMENU_NAME, CMENU_URL, NMENU_ORDER, EDATE)
 Values
   ('GM', 11, 'GMBB158', 'Blood Bank Bag Suppliers', 'MasterBloodBankBagSupplier.aspx', 
    158, TO_DATE('09/26/2014 11:32:24', 'MM/DD/YYYY HH24:MI:SS'));
    
COMMIT;



ALTER TABLE
   BloodComponentStockHeader
ADD
   (
     BCSH_Category                 CHAR (2 BYTE)  default 'NS',
     BCSH_SupplierID               CHAR (4 BYTE)
   );
   
   ALTER TABLE
   BloodComponentStockDetail
ADD
   (
      BCSD_SegmentNo              CHAR (10 Byte)
   );

   ALTER TABLE
   BloodComponentStockDetail
ADD
   (
      BCSH_LotNO                    CHAR (10 BYTE)
   );

ALTER TABLE
   BloodComponentStockDetail
ADD
   (
      BCSH_BG_CODE         CHAR (4 BYTE)
   );

   ALTER TABLE
   BloodComponentStockDetail
ADD
   (
      BCSH_OSOBScreening         CHAR (1 BYTE) 
   );


   Insert into BLOODBANK_BAGSUPPLIER
   (SUPPLIERCODE, SUPPLIERNAME, ADDRESS, PHONENUM, MOBILENUM, EMAILID, CONTACTPERSON, CREATED_BY, CREATED_ON, STATUS, SHORTNAME)
 Values
   ('I002', 'I.M.A.BLOOD BANK SOCIETY', 'KAROL BAGH', '1234654', '12345678888', 
    'TEST2@HFH.COM', 'MR. AUTHORITY', 'D010', TO_DATE('09/26/2014 12:02:20', 'MM/DD/YYYY HH24:MI:SS'), 'Y', 
    'IMA');
Insert into BLOODBANK_BAGSUPPLIER
   (SUPPLIERCODE, SUPPLIERNAME, ADDRESS, PHONENUM, MOBILENUM, EMAILID, CONTACTPERSON, CREATED_BY, CREATED_ON, STATUS, SHORTNAME)
 Values
   ('H001', 'HOLY CROSS BLOOD BANK', 'SILAMPUR', '123457896', '123456789', 
    'TEST3@HFH.COM', 'MR. ADMINISTRATOR', 'D010', TO_DATE('09/26/2014 12:05:41', 'MM/DD/YYYY HH24:MI:SS'), 'Y', 
    'HOLY CROSS');
Insert into BLOODBANK_BAGSUPPLIER
   (SUPPLIERCODE, SUPPLIERNAME, ADDRESS, PHONENUM, MOBILENUM, EMAILID, CONTACTPERSON, CREATED_BY, CREATED_ON, STATUS, SHORTNAME)
 Values
   ('I001', 'IMA VOLUNTARY DONOR BB', 'ERNAKULAM', '9846100663', '9846100663', 
    'TEST1@HFH.COM', 'MR. SUNIL VARMA', 'D010', TO_DATE('09/26/2014 11:49:17', 'MM/DD/YYYY HH24:MI:SS'), 'Y', 
    'TD ROAD');
COMMIT;


 ALTER TABLE BLOODBANKPARAMETER ADD MW45TO55BV NUMBER(3); 

ALTER TABLE BLOODBANKPARAMETER ADD MWABOVE55BV NUMBER(3);

ALTER TABLE BLOODBANKPARAMETER ADD FWABOVE45BV NUMBER(3);

COMMENT ON COLUMN BLOODBANKPARAMETER.MW45TO55BV IS 'MALE WEIGHT BETWEEN 45 TO 55 BLOOD BLEED VOLUME';

COMMENT ON COLUMN BLOODBANKPARAMETER.MWABOVE55BV IS 'MALE WEIGHT ABOVE 55 BLOOD BLEED VOLUME';

COMMENT ON COLUMN BLOODBANKPARAMETER.FWABOVE45BV IS 'MALE WEIGHT ABOVE 45 BLOOD BLEED VOLUME'; 


CREATE TABLE BloodBankReScreening(
          	  BBRS_BagNo               CHAR (14 BYTE),
          	  BBRS_ScreenDate          DATE,
		  BBRS_EntryDate           DATE Default Sysdate,
		  BBRS_UserCode            CHAR (4 BYTE),
     		  BBRS_ScreenStatus        CHAR (1 BYTE),
     		  BBRS_Remarks             VARCHAR2(200 BYTE)
);
COMMIT;


--------26/09/2014------------------ BLOOD BANK PARAMETER CHANGE

ALTER TABLE BLOODBANKPARAMETER ADD MW45TO55BV NUMBER(3); 

ALTER TABLE BLOODBANKPARAMETER ADD MWABOVE55BV NUMBER(3);

ALTER TABLE BLOODBANKPARAMETER ADD FWABOVE45BV NUMBER(3);

COMMENT ON COLUMN BLOODBANKPARAMETER.MW45TO55BV IS 'MALE WEIGHT BETWEEN 45 TO 55 BLOOD BLEED VOLUME';

COMMENT ON COLUMN BLOODBANKPARAMETER.MWABOVE55BV IS 'MALE WEIGHT ABOVE 55 BLOOD BLEED VOLUME';

COMMENT ON COLUMN BLOODBANKPARAMETER.FWABOVE45BV IS 'MALE WEIGHT ABOVE 45 BLOOD BLEED VOLUME';


--------07/10/2014------------------ BLOOD BANK COMPONENT CHANGE

ALTER TABLE
   BloodComponent
ADD
   (
     BCN_DefaultBloodVolume   NUMBER (8,2) default 0
   );
   

   ALTER TABLE
   BloodBankBleedingDetails
ADD
   (
    BBBD_ActiveStatus    CHAR (1 BYTE) default 'Y'
   );
   
   ALTER TABLE
   BloodBankBleedingDetails
ADD
   (
    BBBD_BleedType    CHAR (4 BYTE) default 'R001'
   );


   CREATE TABLE BloodBankBleedingTypes(
         BTC_TypeCode                  CHAR (4 Byte), 
         BTV_TypeName            VARCHAR2(30 BYTE),
         BTV_EntDate                 DATE default sysdate,
         BTV_UserCode              CHAR (4 Byte),    
         BTV_ActiveStatus   CHAR (1 Byte) default 'Y',  
         CONSTRAINT pk_BleedingTypes PRIMARY KEY (BTC_TypeCode)
);

ALTER TABLE
   BLOODBANKBLEEDINGTYPES
ADD
   (
    BTN_BleedGap    NUMBER (2) default 0
   );


Insert into WEBMENU
   (CMODULE, NMAIN_MENU, NSUBMENU_ID, NSUBMENU_NAME, CMENU_URL, NMENU_ORDER, EDATE)
 Values
   ('GM', 11, 'GMBB160', 'Blood Bank Bleeding Types', 'MasterBloodBankBleedingTypes.aspx', 
    160, TO_DATE('10/08/2014 17:20:24', 'MM/DD/YYYY HH24:MI:SS'));
    
COMMIT;



Insert into BLOODBANKBLEEDINGTYPES
   (BTC_TYPECODE, BTV_TYPENAME, BTV_ENTDATE, BTV_USERCODE, BTV_ACTIVESTATUS, BTN_BleedGap)
 Values
   ('R001', 'REGULAR', TO_DATE('10/08/2014 19:13:10', 'MM/DD/YYYY HH24:MI:SS'), 'D010', 'Y', 
    90);
Insert into BLOODBANKBLEEDINGTYPES
   (BTC_TYPECODE, BTV_TYPENAME, BTV_ENTDATE, BTV_USERCODE, BTV_ACTIVESTATUS, BTN_BleedGap)
 Values
   ('D001', 'DIRECTED', TO_DATE('10/08/2014 19:13:48', 'MM/DD/YYYY HH24:MI:SS'), 'D010', 'Y', 
    10);
Insert into BLOODBANKBLEEDINGTYPES
   (BTC_TYPECODE, BTV_TYPENAME, BTV_ENTDATE, BTV_USERCODE, BTV_ACTIVESTATUS, BTN_BleedGap)
 Values
   ('A001', 'AUTOLOGOUS', TO_DATE('10/08/2014 19:13:02', 'MM/DD/YYYY HH24:MI:SS'), 'D010', 'Y', 
    30);
COMMIT;


 alter table BloodRequestHDR
    ADD  ( BR_GroupTestLab   CHAR (1) default 'I' );
    
 alter table BloodRequestHDR  
    ADD(BR_RequestType   CHAR (1) default 'A' );

  alter table BloodBankCrossMatch
    ADD ( BBCM_Pathologist   CHAR (4) );

alter table BloodBankCrossMatch
    ADD ( BBCM_Doctor   CHAR (4 Byte) );

--12/10/2014 ----------For User Rights 

INSERT INTO SUBMENU
   (CMODULE, NMAIN_MENU, SUBMENU_NAME, NMENU_ORDER, ENTRY_REPORT, 
    EDATE)
 VALUES
   ('BB', 5, 'Other Rights', 3, 'S', 
    TO_DATE('10/09/2014 13:25:29', 'MM/DD/YYYY HH24:MI:SS'));

INSERT INTO WEBMENU
   (CMODULE, NMAIN_MENU, NSUBMENU_ID, NSUBMENU_NAME, NMENU_ORDER, 
    EDATE, CMENU_UNIQUEID)
 VALUES
   ('BB', 5, 'BB012', 'Cross Match for different blood groups', 11, 
    TO_DATE('10/01/2014 15:49:48', 'MM/DD/YYYY HH24:MI:SS'), 'CROSS MATCH OTHER GROUP');
INSERT INTO WEBMENU
   (CMODULE, NMAIN_MENU, NSUBMENU_ID, NSUBMENU_NAME, NMENU_ORDER, 
    EDATE, CMENU_UNIQUEID)
 VALUES
   ('BB', 5, 'BB013', 'Rights of Expiry Marking', 12, 
    TO_DATE('10/01/2014 15:49:48', 'MM/DD/YYYY HH24:MI:SS'), 'EXPIRY MARKING');

   
COMMIT;

-- From Nursing Station Calling---------------------

Insert into WEBMENU
   (CMODULE, NMAIN_MENU, NSUBMENU_ID, NSUBMENU_NAME, CMENU_URL, 
    NMENU_ORDER, EDATE)
 Values
   ('NS', 1, 'NS045', 'Blood Request', '../BloodBank/BloodRequest.aspx?EditVal=&tabtoshow=first&TitleHide=1', 
    9, TO_DATE('03/10/2010 12:32:23', 'MM/DD/YYYY HH24:MI:SS'));
Insert into WEBMENU
   (CMODULE, NMAIN_MENU, NSUBMENU_ID, NSUBMENU_NAME, CMENU_URL, 
    NMENU_ORDER, EDATE)
 Values
   ('NS', 1, 'NS046', 'Blood Request Status', '../bloodbank/BloodBankInfoforNS.aspx', 
    10, TO_DATE('12/30/1899 10:00:00', 'MM/DD/YYYY HH24:MI:SS'));
COMMIT;

--14/10/2014--------------------------------------

ALTER TABLE  BLOODBANKCROSSMATCH ADD BBCM_BILLNO   CHAR(6);

--15/10/2014 -----------------------------------


ALTER TABLE BLOODCOMPONENTSTOCKDETAIL MODIFY BCSD_SEGMENTNO VARCHAR2(50);

ALTER TABLE BLOODCOMPONENTSTOCKDETAIL MODIFY BCSH_LOTNO VARCHAR2(50);


--20/10/2014----------------------------------------------------------

CREATE TABLE COMMONCHECKLIST
(
  CCN_SLNO        NUMBER(10),
  CCC_DESC        VARCHAR2(500 BYTE),
  CCC_GENDERTYPE  CHAR(1 BYTE)                  DEFAULT 'M',
  CCC_ANSWER      CHAR(1 BYTE)                  DEFAULT 'N',
  CCC_YESQUEST    VARCHAR2(200 BYTE),
  CCC_NOQUEST     VARCHAR2(200 BYTE),
  CCC_STATUS      CHAR(1 BYTE)                  DEFAULT 'Y',
  CCC_MODULECODE  CHAR(2 BYTE),
  CCN_ORDERNO     NUMBER(3),
  US_CODE         CHAR(4 BYTE),
  CR_DATE         DATE                          DEFAULT SYSDATE,
  ED_DATE         DATE
);

COMMENT ON COLUMN COMMONCHECKLIST.CCC_GENDERTYPE IS 'M-MALE . F-FEMALE';

ALTER TABLE COMMONCHECKLIST ADD (
  CONSTRAINT PK_COMMONCHKLIST
  PRIMARY KEY
  (CCN_SLNO));

-----FOR STORING COMMON CHECKLIST DATA.-----------------------------

CREATE TABLE COMMONCHECKLISTDATA
(
    CCN_SLNO  NUMBER(10),
    DNC_CODE CHAR(6),
    MODULECODE  CHAR(2 BYTE),
    CCC_ANSWER CHAR(1),
    CCC_YESANS    VARCHAR2(200 BYTE),
    CCC_NOANS     VARCHAR2(200 BYTE),
    US_CODE         CHAR(4 BYTE),
    CR_DATE         DATE                          DEFAULT SYSDATE,
    ED_DATE         DATE
);

ALTER TABLE COMMONCHECKLISTDATA
ADD CONSTRAINTS FK_DONORLIST_CCHECKLISTDATA
 FOREIGN KEY (DNC_CODE) 
  REFERENCES DONORLIST (DNC_CODE);


--FOR PROCEDURE MAPPING WITH MODULES------------------------------------

CREATE TABLE MODPROCMAPPING
( MPC_CMODULE VARCHAR2(2),
  MPC_PD_CODE CHAR(4),
  MPC_STATUS CHAR(1) DEFAULT 'Y');
  
  ALTER TABLE MODPROCMAPPING
  ADD CONSTRAINTS PK_MODPROCMAPPING
  PRIMARY KEY(MPC_CMODULE,MPC_PD_CODE);


--22/10/2014----------------------------------------------------

ALTER  TABLE BloodBankBleedingDetails MODIFY BBBD_BagNo VARCHAR2 (20);
   
ALTER TABLE BloodComponentStockDetail MODIFY BCSD_BagNo  VARCHAR2 (20);
   
ALTER TABLE BLOODCOMPONENTSTOCKDETAIL DROP  CONSTRAINT BCOMPONENTSD_PK;
  
ALTER TABLE  BloodComponentStockDetail  MODIFY BCSD_FinalBagNo  VARCHAR2 (20) ;
  
ALTER TABLE BLOODBANKCROSSMATCH MODIFY BBCM_BAGNO VARCHAR2(20);
   
ALTER TABLE BLOODCOMPONENTSTOCKDETAIL ADD (
  CONSTRAINT BCOMPONENTSD_PK
  PRIMARY KEY  (BCSD_FINALBAGNO));
 
ALTER TABLE BLOODBANKRESCREENING MODIFY BBRS_BAGNO VARCHAR2(20);



Insert into BLOODBACKFRONTDETAILS
   (BBFD_CODE, BBFD_NAME, SORDER)
 Values
   ('AM01', '-A', 1);
Insert into BLOODBACKFRONTDETAILS
   (BBFD_CODE, BBFD_NAME, SORDER)
 Values
   ('BM01', '-B', 2);
Insert into BLOODBACKFRONTDETAILS
   (BBFD_CODE, BBFD_NAME, SORDER)
 Values
   ('ABM1', '-AB', 3);
Insert into BLOODBACKFRONTDETAILS
   (BBFD_CODE, BBFD_NAME, SORDER)
 Values
   ('DM01', '-D', 4);
Insert into BLOODBACKFRONTDETAILS
   (BBFD_CODE, BBFD_NAME, SORDER)
 Values
   ('AC01', 'AC', 5);
Insert into BLOODBACKFRONTDETAILS
   (BBFD_CODE, BBFD_NAME, SORDER)
 Values
   ('BC01', 'BC', 6);
Insert into BLOODBACKFRONTDETAILS
   (BBFD_CODE, BBFD_NAME, SORDER)
 Values
   ('OC01', 'OC', 7);
Insert into BLOODBACKFRONTDETAILS
   (BBFD_CODE, BBFD_NAME, SORDER)
 Values
   ('SC01', 'SC', 8);
Insert into BLOODBACKFRONTDETAILS
   (BBFD_CODE, BBFD_NAME, SORDER)
 Values
   ('L001', 'Lectin', 9);
Insert into BLOODBACKFRONTDETAILS
   (BBFD_CODE, BBFD_NAME, SORDER)
 Values
   ('AH01', 'Anti H', 10);
COMMIT;


Insert into BLOODINFECTIONS
   (BIC_CODE, BIC_NAME)
 Values
   ('B001', 'High/Low Blood Pressure');
Insert into BLOODINFECTIONS
   (BIC_CODE, BIC_NAME)
 Values
   ('H003', 'Abnormal Hemoglobin Level');
Insert into BLOODINFECTIONS
   (BIC_CODE, BIC_NAME)
 Values
   ('I001', 'Irregud AntiB');
Insert into BLOODINFECTIONS
   (BIC_CODE, BIC_NAME)
 Values
   ('H002', 'HCV');
Insert into BLOODINFECTIONS
   (BIC_CODE, BIC_NAME)
 Values
   ('H001', 'HBSAG');
Insert into BLOODINFECTIONS
   (BIC_CODE, BIC_NAME)
 Values
   ('V001', 'VDRL');
Insert into BLOODINFECTIONS
   (BIC_CODE, BIC_NAME)
 Values
   ('M001', 'MP');
Insert into BLOODINFECTIONS
   (BIC_CODE, BIC_NAME)
 Values
   ('A001', 'Anti HIV');
COMMIT;


Insert into BLOODDONORTYPES
   (BDTC_CODE, BDTC_NAME)
 Values
   ('D001', 'DIRECT');
Insert into BLOODDONORTYPES
   (BDTC_CODE, BDTC_NAME)
 Values
   ('R001', 'REPLACE');
Insert into BLOODDONORTYPES
   (BDTC_CODE, BDTC_NAME)
 Values
   ('V001', 'VOLUNTARY');
COMMIT;


-------------------------- For Masters(MIS) Menu ---------------------------- Start -----------------

Insert into WEBMENU
   (CMODULE, NMAIN_MENU, NSUBMENU_ID, NSUBMENU_NAME, CMENU_URL, NMENU_ORDER, EDATE)
 Values
   ('GM', 11, 'GMBB157', 'Blood Bank Racks', 'MasterBloodbankRack.aspx', 
    157, TO_DATE('09/21/2014 12:45:15', 'MM/DD/YYYY HH24:MI:SS'));
Insert into WEBMENU
   (CMODULE, NMAIN_MENU, NSUBMENU_ID, NSUBMENU_NAME, CMENU_URL, NMENU_ORDER, EDATE)
 Values
   ('GM', 11, 'GM152', 'Blood Component', 'Masterbloodcomponent.aspx', 
    152, TO_DATE('01/15/2013 18:28:10', 'MM/DD/YYYY HH24:MI:SS'));
Insert into WEBMENU
   (CMODULE, NMAIN_MENU, NSUBMENU_ID, NSUBMENU_NAME, CMENU_URL, NMENU_ORDER, EDATE)
 Values
   ('GM', 11, 'GM153', 'Blood Parameter', 'MasterBloodbankparameter.aspx', 
    153, TO_DATE('01/15/2013 18:57:50', 'MM/DD/YYYY HH24:MI:SS'));
Insert into WEBMENU
   (CMODULE, NMAIN_MENU, NSUBMENU_ID, NSUBMENU_NAME, CMENU_URL, NMENU_ORDER, EDATE)
 Values
   ('GM', 11, 'GM155', 'Blood Group Definition', 'Masterbloodgroup.aspx', 
    155, TO_DATE('01/16/2013 18:18:24', 'MM/DD/YYYY HH24:MI:SS'));
Insert into WEBMENU
   (CMODULE, NMAIN_MENU, NSUBMENU_ID, NSUBMENU_NAME, CMENU_URL, NMENU_ORDER, EDATE)
 Values
   ('GM', 11, 'gm156', 'Blood Bank Doctor Marking', 'MasterBloodBankDoctors.aspx', 
    156, TO_DATE('07/22/2014 13:42:10', 'MM/DD/YYYY HH24:MI:SS'));
Insert into WEBMENU
   (CMODULE, NMAIN_MENU, NSUBMENU_ID, NSUBMENU_NAME, CMENU_URL, NMENU_ORDER, EDATE)
 Values
   ('GM', 11, 'GMBB158', 'Blood Bank Bag Suppliers', 'MasterBloodBankBagSupplier.aspx', 
    158, TO_DATE('09/26/2014 11:32:24', 'MM/DD/YYYY HH24:MI:SS'));
Insert into WEBMENU
   (CMODULE, NMAIN_MENU, NSUBMENU_ID, NSUBMENU_NAME, CMENU_URL, NMENU_ORDER, EDATE)
 Values
   ('GM', 11, 'GMBB160', 'Blood Bank Bleeding Types', 'MasterBloodBankBleedingTypes.aspx', 
    160, TO_DATE('10/08/2014 17:20:24', 'MM/DD/YYYY HH24:MI:SS'));
COMMIT;

-------------------------- For Masters(MIS) Menu ---------------------------- End -------------------



 ---For Blood bag Type for cosmo
 CREATE TABLE BLOODBAGTYPE(
         BTC_CODE           CHAR (4 BYTE),
         BTC_NAME           VARCHAR2(150 BYTE),
         BTC_STATUS     CHAR(1) DEFAULT 'Y'
); 

ALTER TABLE BLOODBAGTYPE ADD CONSTRAINT BLOODBAGTYPE_PK PRIMARY KEY (BTC_CODE);

--- For Bleeding Duration
ALTER TABLE  BLOODBANKBLEEDINGDETAILS ADD  
(BBBN_BLEEDINGHOUR NUMBER(2), 
BBBN_BLEEDINGMIN NUMBER(2)); 


Insert into WEBMENU
   (CMODULE, NMAIN_MENU, NSUBMENU_ID, NSUBMENU_NAME, CMENU_URL, NMENU_ORDER, EDATE)
 Values
   ('GM', 11, 'GMBB161', 'Blood Bank Bag Types', 'MasterBloodBagType.aspx', 
    161, TO_DATE('04/09/2015 18:15:24', 'MM/DD/YYYY HH24:MI:SS'));


ALTER TABLE  BLOODBANKBLEEDINGDETAILS ADD BTC_CODE CHAR (4 BYTE); 


Insert into WEBMENU
   (CMODULE, NMAIN_MENU, NSUBMENU_ID, NSUBMENU_NAME, NMENU_ORDER, EDATE, CMENU_UNIQUEID)
 Values
   ('BB', 5, 'BB025', 'Issue any Crossing Component', 
    13, TO_DATE('04/17/2015 11:47:18', 'MM/DD/YYYY HH24:MI:SS'), 'ISSUE ALTERNATE COMPONENT');


	Insert into WEBMENU
   (CMODULE, NMAIN_MENU, NSUBMENU_ID, NSUBMENU_NAME, CMENU_URL, NMENU_ORDER, EDATE)
 Values
   ('GM', 11, 'GMBB162', 'Blood Component - Procedure Mapping', 'MasterBloodComponentProcedureMapping.aspx', 
    162, TO_DATE('04/17/2015 14:28:08', 'MM/DD/YYYY HH24:MI:SS'));



ALTER TABLE BLOODBANKPARAMETER ADD BLC_COMPONENTISSUEASSERVICE CHAR(1) DEFAULT 'Y'; 



CREATE TABLE BLOODCOMPONENTPROCMAPPING
(
BC_CODE CHAR (4 BYTE),
PD_CODE CHAR (4 BYTE)
);


ALTER TABLE BLOODCOMPONENTPROCMAPPING ADD CONSTRAINT PK_BLOODCOMPONENTPROCMAPPING PRIMARY KEY (BC_CODE, PD_CODE); 

ALTER TABLE BLOODCOMPONENTPROCMAPPING ADD CONSTRAINT FK_BLOODCOMPONENTPROC_BCCODE FOREIGN KEY (BC_CODE)
REFERENCES BLOODCOMPONENT(BC_CODE);

ALTER TABLE BLOODCOMPONENTPROCMAPPING ADD CONSTRAINT FK_BLOODCOMPONENTPROC_PDCODE FOREIGN KEY (PD_CODE)
REFERENCES PRODESCRIPTION(PD_CODE);



ALTER TABLE BLOODBANKPARAMETER MODIFY BSN_WEIGHT NUMBER(5,2) DEFAULT 45;

ALTER TABLE BLOODBANKPARAMETER ADD BSN_MINAGE NUMBER(3) DEFAULT 18; 

 ALTER TABLE BLOODBANKPARAMETER ADD BLC_ENABLEDETAILEDTRANFUSE CHAR(1) DEFAULT 'N' 




	 Insert into WEBMENU
   (CMODULE, NMAIN_MENU, NSUBMENU_ID, NSUBMENU_NAME, CMENU_URL, NMENU_ORDER, EDATE)
 Values
   ('GM', 11, 'GMBB162', 'Blood Component - Procedure Mapping', 'MasterBloodComponentProcedureMapping.aspx', 
    162, TO_DATE('04/17/2015 14:28:08', 'MM/DD/YYYY HH24:MI:SS'));

Insert into WEBMENU
   (CMODULE, NMAIN_MENU, NSUBMENU_ID, NSUBMENU_NAME, CMENU_URL, NMENU_ORDER, EDATE)
 Values
   ('GM', 11, 'GMBB161', 'Blood Bank Bag Types', 'MasterBloodBagType.aspx', 
    161, TO_DATE('04/09/2015 18:15:24', 'MM/DD/YYYY HH24:MI:SS'));

Insert into WEBMENU
   (CMODULE, NMAIN_MENU, NSUBMENU_ID, NSUBMENU_NAME, CMENU_URL, NMENU_ORDER, EDATE)
 Values
   ('GM', 20, 'GMLR001', 'Microbiology - Specimen Based Growth', 'MasterLRspecimenGrowth.aspx', 
    1, TO_DATE('04/14/2015 16:01:37', 'MM/DD/YYYY HH24:MI:SS'));

	Insert into WEBMENU
   (CMODULE, NMAIN_MENU, NSUBMENU_ID, NSUBMENU_NAME, CMENU_URL, NMENU_ORDER, EDATE)
 Values
   ('GM', 11, 'GMBB163', 'Signs and Symptoms During Transfusion', 'MasterBloodBankTransfuseSymptoms.aspx', 
    99999, TO_DATE('04/22/2015 16:29:27', 'MM/DD/YYYY HH24:MI:SS'));


	ALTER TABLE TRANSFUSIONNOTE ADD(
TFD_STARTTIME DATE,
TFD_ENDTIME DATE,
TFN_QTY NUMBER(6,3), 
TFN_BEFORETEMPRATURE NUMBER(6,2),
TFN_DURINGTEMPRATURE NUMBER(6,2),
TFN_AFTERTEMPRATURE NUMBER(6,2),
TFN_BEFOREPULSE NUMBER(4),
TFN_DURINGPULSE NUMBER(4),
TFN_AFTERPULSE NUMBER(4),
TFN_BEFORESBP NUMBER(5),
TFN_BEFOREDBP NUMBER(5),
TFN_DURINGSBP NUMBER(5),
TFN_DURINGDBP NUMBER(5),
TFN_AFTERSBP NUMBER(5),
TFN_AFTERDBP NUMBER(5)); 


CREATE TABLE SYMPTOMSMASTER
( SS_CODE NUMBER(5),
SSC_DESC VARCHAR2(500),
SSC_ACTIVE CHAR(1) DEFAULT 'N'
);


ALTER TABLE SYMPTOMSMASTER ADD CONSTRAINT PK_SYMPTOMSMASTER PRIMARY KEY(SS_CODE);


CREATE TABLE TRANSFUSIONSYMPTOMS
(
TFN_SLNO NUMBER(10),
SS_CODE NUMBER(5),
SSC_ANSWER CHAR(1) DEFAULT 'N'
);


ALTER TABLE TRANSFUSIONSYMPTOMS ADD (
CONSTRAINT PK_TRANSFUSIONSYMPTOMS
PRIMARY KEY (TFN_SLNO,SS_CODE ));


ALTER TABLE TRANSFUSIONSYMPTOMS ADD (
CONSTRAINT FK_TRANSFUSIONSYMPTOMS_TFNSLNO
FOREIGN KEY (SS_CODE)
REFERENCES SYMPTOMSMASTER(SS_CODE));


Insert into WEBMENU
   (CMODULE, NMAIN_MENU, NSUBMENU_ID, NSUBMENU_NAME, CMENU_URL, NMENU_ORDER, EDATE)
 Values
   ('BB', 1, 'BB026', 'Direct/Bulk Whole Blood Bag Seperation', 'BulkWholeBloodBag.aspx?tabtoshow=first', 
    7, TO_DATE('04/27/2015 12:57:51', 'MM/DD/YYYY HH24:MI:SS'));
COMMIT;


Insert into WEBMENU
   (CMODULE, NMAIN_MENU, NSUBMENU_ID, NSUBMENU_NAME, CMENU_URL, NMENU_ORDER, EDATE)
 Values
   ('BB', 1, 'BB027', 'Show Bags With Status', 'SelectBagsWithStatus.aspx?tabtoshow=first', 
    11, TO_DATE('04/29/2015 16:55:51', 'MM/DD/YYYY HH24:MI:SS'));



	ALTER TABLE  MULTIHOSPITAL ADD MHC_BBCOUNTER CHAR (4); 

ALTER TABLE MULTIHOSPITAL ADD CONSTRAINT FK_MULTIHOSPITAL_BBCOUNTER FOREIGN KEY(MHC_BBCOUNTER)
REFERENCES OPCOUNTER (CN_CODE); 


CREATE TABLE COMMONHTMLRPTOUTPUT
(
  CMN_CODE     NUMBER(10),
  CMD_DATE    DATE DEFAULT SYSDATE,
  CMODULE     VARCHAR2(2 BYTE),
  MH_CODE     CHAR (2 Byte),
  CMC_HTMLDATA       LONG,
  CMC_CANCEL  CHAR(1)  DEFAULT 'Y',
  US_CODE        CHAR(4 BYTE)
);

ALTER TABLE COMMONHTMLRPTOUTPUT ADD CONSTRAINT PK_COMMONHTMLRPTOUTPUT PRIMARY KEY (CMN_CODE);

ALTER TABLE COMMONHTMLRPTOUTPUT ADD CONSTRAINT FK_COMMONHTMLRPTOUTPUT FOREIGN KEY(CMODULE) REFERENCES MMDYNMODULE(SHT_NAME); 

 ALTER TABLE
   COMMONHTMLRPTOUTPUT
ADD
   (
      CMN_MONTH     NUMBER(2),
      CMN_YEAR      NUMBER(4)
   ); 


    ALTER TABLE  BLOODBANKCROSSMATCH ADD BBCM_CROSSMATCHREMARKS VARCHAR2 (500);