CREATE OR REPLACE TYPE "CDS_OBJ" IS OBJECT (CdsEnc NUMBER(10), Record VARCHAR2(4000));

  CREATE OR REPLACE TYPE "CDS_TAB" IS TABLE OF "CDS_OBJ";

  CREATE OR REPLACE TYPE "STAGE1APPTDETAIL" AS OBJECT (
                                     "Appointment" NUMBER(10),
                                     "Date" DATE,
                                     "From" NUMBER(10),
                                     "Clinic" NUMBER(10),
                                     "Chart" VARCHAR2(10),
                                     "Last" VARCHAR2(25),
                                     "First" VARCHAR2(30),
                                     "Flag" NUMBER);




  CREATE OR REPLACE TYPE "STAGE1CORE4DETAIL" AS OBJECT (
                               "Patient" NUMBER(10),
                               "Chart" VARCHAR2(10),
                               "Last" VARCHAR2(25),
                               "First" VARCHAR2(30),
                               "Prescription" NUMBER(10),
                               "Flag" NUMBER);




  CREATE OR REPLACE TYPE "STAGE1COREDETAIL" AS OBJECT (
                                     "Patient" NUMBER(10),
                                     "Chart" VARCHAR2(10),
                                     "Last" VARCHAR2(25),
                                     "First" VARCHAR2(30),
                                     "Flag" NUMBER);




  CREATE OR REPLACE TYPE "STAGE3CORE42DETAIL" AS OBJECT (
                               "Patient" NUMBER(10),
                               "Chart" VARCHAR2(10),
                               "Last" VARCHAR2(25),
                               "First" VARCHAR2(30),
                               "Date" DATE,
                               "Description" VARCHAR2(30),
                               "User" NUMBER(10),
                               "AppUser" NUMBER(10),
                               "Flag" NUMBER);


  CREATE OR REPLACE TYPE "STAGE3COREDETAIL" AS OBJECT (
                                     "Patient" NUMBER(10),
                                     "Chart" VARCHAR2(10),
                                     "Last" VARCHAR2(25),
                                     "First" VARCHAR2(30),
                                     "Flag" NUMBER,
                                     "Ex" NUMBER,
                                     "Exc" NUMBER,
                                     "Denom" NUMBER);


  CREATE OR REPLACE TYPE "T_STAGE1APPTDETAIL" AS TABLE of "STAGE1APPTDETAIL";

  CREATE OR REPLACE TYPE "T_STAGE1CORE4DETAIL" AS TABLE of "STAGE1CORE4DETAIL";

  CREATE OR REPLACE TYPE "T_STAGE1COREDETAIL" AS TABLE of "STAGE1COREDETAIL";

  CREATE OR REPLACE TYPE "T_STAGE3CORE42DETAIL" AS TABLE of "STAGE3CORE42DETAIL";

  CREATE OR REPLACE TYPE "T_STAGE3COREDETAIL" AS TABLE of "STAGE3COREDETAIL";