<mysql_data>
</mysql_data>
<fbsql_data dest_pharm_id="0">
/*
<nzok_update_date>16.08.2026</nzok_update_date> 
<fix_index>1</fix_index> 
<comment>Отпадащи НЗОК кодове от следващ период</comment> 
*/
UPDATE AXP_ENV_VARS SET VAR_VALUE = '16.08.2026' WHERE VAR_NAME = 'NZOKInactiveAfterPrescriptionDate';
DELETE FROM NZOK_INACTIVE_AFTER_DATE;
INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('CA084');
INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('LF099');
INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('LF100');
INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('RF250');
INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('SF039');

INSERT INTO AXP_ENV_VARS (ID, VAR_NAME, VAR_VALUE)
  SELECT FIRST 1 GEN_ID(AXP_ENV_VARS_ID, 1), 'ESignUsageCheckAfterDate', '15.08.2035'
  FROM AXP_ENV_VARS
  WHERE NOT EXISTS(
    SELECT ID
    FROM AXP_ENV_VARS
    WHERE (VAR_NAME = 'ESignUsageCheckAfterDate')
    );

update axp_env_vars av1 set av1.VAR_VALUE = '15.08.2035' where (av1.VAR_NAME = 'ESignUsageCheckAfterDate');

INSERT INTO AXP_ENV_VARS (ID, VAR_NAME, VAR_VALUE)
  SELECT FIRST 1 GEN_ID(AXP_ENV_VARS_ID, 1), 'NHISESignCallsSelfHeal', 'F'
  FROM AXP_ENV_VARS
  WHERE NOT EXISTS(
    SELECT ID
    FROM AXP_ENV_VARS
    WHERE (VAR_NAME = 'NHISESignCallsSelfHeal')
    );

update axp_env_vars av1 set av1.VAR_VALUE = 'F' where (av1.VAR_NAME = 'NHISESignCallsSelfHeal');

</fbsql_data>