main_dashboard.recruitment_campaign
Y
Normal
0
N
1000
100
-
2024/08/02 11:56:22.507
-
2024/08/02 11:56:22.507
Get variables 2 2
Select values 2 2
Y
Select values 2 2
Insert / update (main_dashboard.recruitment_campaign)
Y
Table input (subpoena) РФ/осень
Get variables 2 2
Y
Execute SQL script
Table input (subpoena) РФ/осень
Y
Execute SQL script
ExecSql
N
1
none
ervu-dashboard
N
N
Y
N
N
DELETE FROM main_dashboard.recruitment_campaign
WHERE recording_date = current_date
AND schema = 'Ministry'
AND recruitment_id = '${REG_ID}'
784
480
Get variables 2 2
GetVariable
Y
1
none
-1
REG_ID
-1
none
String
-1
VK_ARRAY
-1
none
String
1248
480
Insert / update (main_dashboard.recruitment_campaign)
InsertUpdate
Y
1
none
100
ervu-dashboard
=
spring_autumn
spring_autumn
=
recruitment_id
REG_ID
=
schema
schema
main_dashboard
subpoenas_sent
count_subpoena
Y
appeared_on_subpoenas
count_appeared
Y
not_appeared_on_subpoenas
count_not_appeared
Y
new_recruits
new_recruits
Y
postponement_have_right
postponement_have_right
Y
postponement_granted
postponement_granted
Y
appeared_on_subpoenas_percent
appeared_on_subpoenas_percent
Y
not_appeared_on_subpoenas_percent
not_appeared_on_subpoenas_percent
Y
postponement_have_right_percent
postponement_have_right_percent
Y
postponement_granted_percent
postponement_granted_percent
Y
recruitment_id
recruitment_id
N
spring_autumn
spring_autumn
N
schema
schema
N
N
1744
480
Select values 2 2
SelectValues
Y
1
none
N
REG_ID
REG_ID
String
-2
-2
false
false
VK_ARRAY
VK_ARRAY
String
-2
-2
false
false
1456
480
Table input (subpoena) РФ/осень
TableInput
Y
1
none
ervu-dashboard
N
0
SELECT
COALESCE(SUM(subpoenas_sent), 0) count_subpoena,
COALESCE(SUM(appeared_on_subpoenas), 0) count_appeared,
COALESCE(SUM(not_appeared_on_subpoenas), 0) count_not_appeared,
COALESCE(SUM(new_recruits), 0) new_recruits,
COALESCE(SUM(postponement_have_right), 0) postponement_have_right,
COALESCE(SUM(postponement_granted), 0) postponement_granted,
COALESCE(
CASE
WHEN SUM(subpoenas_sent) > 0
THEN ROUND((SUM(appeared_on_subpoenas) / SUM(subpoenas_sent) * 100), 2)
ELSE 0
END,
0
) appeared_on_subpoenas_percent,
COALESCE(
CASE
WHEN SUM(subpoenas_sent) > 0
THEN ROUND((SUM(not_appeared_on_subpoenas) / SUM(subpoenas_sent) * 100), 2)
ELSE 0
END,
0
) not_appeared_on_subpoenas_percent,
COALESCE(
CASE
WHEN SUM(new_recruits) > 0
THEN ROUND((SUM(postponement_have_right) / SUM(new_recruits) * 100), 2)
ELSE 0
END,
0
) postponement_have_right_percent,
COALESCE(
CASE
WHEN SUM(new_recruits) > 0
THEN ROUND((SUM(postponement_granted) / SUM(new_recruits) * 100), 2)
ELSE 0
END,
0
) postponement_granted_percent,
'${REG_ID}' AS recruitment_id,
spring_autumn,
'Ministry' AS schema
FROM main_dashboard.recruitment_campaign
WHERE recruitment_id = ANY ('${VK_ARRAY}')
AND schema = 'Region'
AND recording_date = CURRENT_DATE
GROUP BY spring_autumn;
Y
1024
480