CREATE TABLE WF_MAP (
    ID                 DM_ID NOT NULL /* DM_ID = INTEGER NOT NULL */,
    INS_ID             DM_ID /* DM_ID = INTEGER NOT NULL */,
    EVN_TYPE           DM_EVN_TYPE NOT NULL /* DM_EVN_TYPE = VARCHAR(10) */,
    BP                 DM_DATE NOT NULL /* DM_DATE = DATE */,
    EP                 DM_DATE /* DM_DATE = DATE */,
    ZSP_ID             DM_INT /* DM_INT = INTEGER */,
    A08_ID             DM_INT /* DM_INT = INTEGER */,
    ZA7_ID             DM_INT /* DM_INT = INTEGER */,
    NEED_ZA7           DM_BOOLEAN /* DM_BOOLEAN = SMALLINT NOT NULL */,
    NEED_A08_FROM_ZSP  DM_BOOLEAN /* DM_BOOLEAN = SMALLINT NOT NULL */,
    ERR_STATE          DM_BOOLEAN DEFAULT 0 /* DM_BOOLEAN = SMALLINT NOT NULL */,
    ERZ_ID             DM_ID /* DM_ID = INTEGER NOT NULL */
);

create or alter procedure SP_WF_MAP_CREATE (
    INS_ID integer,
    EVN_TYPE type of DM_EVN_TYPE,
    NEED_ZA7 type of DM_BOOLEAN)
as
begin
     insert into WF_MAP (INS_ID, EVN_TYPE, BP, NEED_ZA7, NEED_A08_FROM_ZSP, ERZ_ID)
      values (:ins_id, :evn_type, current_date, :need_za7, 1,
             (select i.erz_id from insurance i where i.id = :ins_id)
             );
end