       , A.ADMISSION_ID
       , A.ADMISSION_DATE
       , A.DISCHARGE_ID
-      , A.DISCHARGE_DATE
-      , A.DISCHARGE_TYPE
       , A.ADMISSION_SECTOR
   FROM
       FILTER_ADM_DISCH_ENROLLMENT A


-- **********************************************
COMMIT;
-- **********************************************
BEGIN
     EXECUTE IMMEDIATE 'DROP VIEW DETECT_INVALID_INDEX';
EXCEPTION
     WHEN OTHERS THEN
            IF SQLCODE != -942 THEN
                 RAISE;
            END IF;
END;
/

-- **********************************************

--------------------------------------------------------

    OR  NOT REGEXP_LIKE(ICD10,'^[a-tA-Tv-zV-Z][0-9][a-zA-Z0-9](\.[a-zA-Z0-9]{0,4})?$')
); 

-- ******************************************************
CREATE OR REPLACE VIEW DETECT_INVALID_LABNUM_RESULT AS
(
