Vos droits DIRECTIVES SAAQ CATÉGORIES DE VICTIMES Incapacité et droit à l'indemnité GESTION DE L'INDEMNITÉ DE REMPLACEMENT DU REVENU (IRR)

6.6 Consultation auprès d'un membre du Service de l'expertise conseil en santé

provide at least one parameter for fusion overlay

SELECT categories.* FROM (SELECT DISTINCT CAST(SUBSTRING(members.anchor, 10) AS UNSIGNED) AS target FROM yacs_members AS members WHERE (members.member LIKE 'article:3174') AND (members.anchor LIKE 'category:%')) AS ids, yacs_categories AS categories WHERE (categories.id = ids.target) AND (categories.active='Y') AND ((categories.expiry_date is NULL) OR (categories.expiry_date <= '0000-00-00 00:00:00') OR (categories.expiry_date > '2024-11-25 08:49:11')) ORDER BY rank, title, edit_date DESC LIMIT 0,40
1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ', title, edit_date DESC LIMIT 0,40' at line 1

SELECT articles.* FROM yacs_articles AS articles WHERE (articles.anchor LIKE 'section:6') AND ((articles.active='Y') AND NOT ((articles.publish_date is NULL) OR (articles.publish_date <= '0000-00-00')) AND ((articles.expiry_date is NULL) OR (articles.expiry_date <= '0000-00-00 00:00:00') OR (articles.expiry_date > '2024-11-25 08:49:11'))) ORDER BY rank, publish_date DESC, title LIMIT 0,7
1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ', publish_date DESC, title LIMIT 0,7' at line 1

Compte tenu des types de dossiers traités par les agents d'indemnisation, ceux-ci doivent parfois obtenir l'opinion d'un des membres du Service de l'expertise conseil en santé avant de rendre une décision. L'outil d'aide à la décision SADI précise la marche à suivre.