-- TYPES

CREATE OR REPLACE TYPE stage3core42detail AS OBJECT ("Patient" numeric(10,0), "Chart" character varying(10), "Last" character varying(25), "First" character varying(30), "Date" timestamp without time zone, "Description" character varying(30), "User" numeric(10,0), "AppUser" numeric(10,0), "Flag" numeric );

CREATE OR REPLACE TYPE stage3coredetail AS OBJECT ("Patient" numeric(10,0), "Chart" character varying(10), "Last" character varying(25), "First" character varying(30), "Flag" numeric, "Ex" numeric, "Exc" numeric, "Denom" numeric );

CREATE TYPE t_stage3core42detail AS TABLE OF stage3core42detail;

CREATE TYPE t_stage3coredetail AS TABLE OF stage3coredetail;
