appeals.reasons_appeal(m_d)
Y
Normal
N
1000
100
-
2025/01/28 10:29:54.859
-
2025/01/28 10:29:54.859
Execute SQL script
Table input (appeal_document) регионы
Y
Get variables 3 2
Select values 3 2
Y
Insert / update (main_dashboard.appeals) 2
Execute SQL script 2
Y
Select values 3 2
Insert / update (main_dashboard.appeals) 2
Y
Table input (appeal_document) регионы
Get variables 3 2
Y
Execute SQL script
ExecSql
N
1
none
ervu-dashboard
N
N
Y
N
N
DELETE FROM appeals.reasons_appeal
WHERE recording_date = current_date
AND schema = 'Region'
AND recruitment_id = '${MD_ID}'
320
256
Execute SQL script 2
ExecSql
N
1
none
ervu-dashboard
N
N
Y
N
N
DELETE FROM appeals.reasons_appeal
WHERE recording_date = current_date
AND schema = 'MD_LVL'
AND recruitment_id = '${MD_ID}'
1344
256
Get variables 3 2
GetVariable
Y
1
none
-1
MD_ID
-1
none
String
-1
MD_ARRAY
-1
none
String
752
256
Insert / update (main_dashboard.appeals) 2
InsertUpdate
Y
1
none
100
ervu-dashboard
=
recruitment_id
MD_ID
=
schema
schema
appeals
appeal
appeal
Y
incorrect_inf
incorrect_inf
Y
incorrect_inf_percent
incorrect_inf_percent
Y
sending_documents
sending_documents
Y
sending_documents_percent
sending_documents_percent
Y
decision_disagreement
decision_disagreement
Y
decision_disagreement_persent
decision_disagreement_persent
Y
complaint_withdrawal
complaint_withdrawal
Y
complaint_withdrawal_percent
complaint_withdrawal_percent
Y
recruitment_id
recruitment_id
N
schema
schema
N
Y
1104
256
Select values 3 2
SelectValues
Y
1
none
N
MD_ID
MD_ID
String
-2
-2
false
false
MD_ARRAY
MD_ARRAY
String
-2
-2
false
false
896
256
Table input (appeal_document) регионы
TableInput
N
1
none
ervu-dashboard
N
0
SELECT
COALESCE(SUM(appeal), 0) appeal,
COALESCE(SUM(incorrect_inf), 0) incorrect_inf,
COALESCE(SUM(sending_documents), 0) sending_documents,
COALESCE(SUM(decision_disagreement), 0) decision_disagreement,
COALESCE(SUM(complaint_withdrawal), 0) complaint_withdrawal,
COALESCE(
CASE
WHEN SUM(appeal) > 0
THEN ROUND((SUM(incorrect_inf) / SUM(appeal) * 100), 2)
ELSE 0
END,
0
) incorrect_inf_percent,
COALESCE(
CASE
WHEN SUM(appeal) > 0
THEN ROUND((SUM(sending_documents) / SUM(appeal) * 100), 2)
ELSE 0
END,
0
) sending_documents_percent,
COALESCE(
CASE
WHEN SUM(appeal) > 0
THEN ROUND((SUM(decision_disagreement) / SUM(appeal) * 100), 2)
ELSE 0
END,
0
) decision_disagreement_persent,
COALESCE(
CASE
WHEN SUM(appeal) > 0
THEN ROUND((SUM(complaint_withdrawal) / SUM(appeal) * 100), 2)
ELSE 0
END,
0
) complaint_withdrawal_percent,
'${MD_ID}' AS recruitment_id,
'Region' AS schema
FROM appeals.reasons_appeal
WHERE recruitment_id = ANY ('${MD_ARRAY}')
AND schema = 'Organization'
AND recording_date = CURRENT_DATE;
Y
528
256