recruitment_campaign.subpoenas
Y
Normal
0
N
1000
100
-
2024/08/09 13:13:59.825
-
2024/08/09 13:13:59.825
Get variables 2 2
Select values 2 2
Y
Table input (subpoena) осень/РФ
Get variables 2 2
Y
Select values 2 2
Insert / update (recruitment_campaign.subpoenas)
Y
Execute SQL script
Table input (subpoena) осень/РФ
Y
Execute SQL script
ExecSql
N
1
none
ervu-dashboard
N
N
Y
N
N
DELETE FROM recruitment_campaign.subpoenas
WHERE recording_date = current_date
AND schema = 'Ministry'
AND recruitment_id = '${REG_ID}'
192
336
Get variables 2 2
GetVariable
Y
1
none
-1
REG_ID
-1
none
String
-1
VK_ARRAY
-1
none
String
640
336
Insert / update (recruitment_campaign.subpoenas)
InsertUpdate
Y
1
none
100
ervu-dashboard
=
recruitment_id
REG_ID
=
spring_autumn
spring_autumn
=
schema
schema
recruitment_campaign
subpoena
count_subpoena
Y
appeared
count_appeared
Y
not_appeared
count_not_appeared
Y
not_ap_good_reason
count_not_ap_good_reason
Y
introduced_measures
count_introduced_measures
Y
ap_not_required
count_ap_not_required
Y
restrictions_applied
count_restrictions_applied
Y
appeared_percent
appeared_percent
Y
not_appeared_percent
not_appeared_percent
Y
not_ap_good_reason_percent
not_ap_good_reason_percent
Y
ap_not_required_percent
ap_not_required_percent
Y
restrictions_applied_percent
restrictions_applied_percent
Y
introduced_measures_percent
introduced_measures_percent
Y
recruitment_id
recruitment_id
N
rest
rest
Y
spring_autumn
spring_autumn
N
count_not_delivery
count_not_delivery
Y
appear_date_is_good
appear_date_is_good
Y
not_delivery_percent
not_delivery_percent
Y
appear_date_is_good_percent
appear_date_is_good_percent
Y
schema
schema
N
N
1104
336
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
848
336
Table input (subpoena) осень/РФ
TableInput
Y
1
none
ervu-dashboard
N
0
SELECT
COALESCE(SUM(subpoena), 0) count_subpoena,
COALESCE(SUM(appeared), 0) count_appeared,
COALESCE(SUM(not_appeared), 0) count_not_appeared,
COALESCE(SUM(not_ap_good_reason), 0) count_not_ap_good_reason,
COALESCE(SUM(introduced_measures), 0) count_introduced_measures,
COALESCE(SUM(ap_not_required), 0) count_ap_not_required,
COALESCE(SUM(restrictions_applied), 0) count_restrictions_applied,
COALESCE(
CASE
WHEN SUM(subpoena) > 0
THEN ROUND((SUM(appeared) / SUM(subpoena) * 100), 2)
ELSE 0
END,
0
) appeared_percent,
COALESCE(
CASE
WHEN SUM(subpoena) > 0
THEN ROUND((SUM(not_appeared) / SUM(subpoena) * 100), 2)
ELSE 0
END,
0
) not_appeared_percent,
COALESCE(
CASE
WHEN SUM(subpoena) > 0
THEN ROUND((SUM(not_ap_good_reason) / SUM(subpoena) * 100), 2)
ELSE 0
END,
0
) not_ap_good_reason_percent,
COALESCE(
CASE
WHEN SUM(subpoena) > 0
THEN ROUND((SUM(ap_not_required) / SUM(subpoena) * 100), 2)
ELSE 0
END,
0
) ap_not_required_percent,
COALESCE(
CASE
WHEN SUM(subpoena) > 0
THEN ROUND((SUM(restrictions_applied) / SUM(subpoena) * 100), 2)
ELSE 0
END,
0
) restrictions_applied_percent,
COALESCE(
CASE
WHEN SUM(subpoena) > 0
THEN ROUND((SUM(introduced_measures) / SUM(subpoena) * 100), 2)
ELSE 0
END,
0
) introduced_measures_percent,
COALESCE(SUM(rest), 0) rest,
COALESCE(SUM(count_not_delivery), 0) count_not_delivery,
COALESCE(SUM(appear_date_is_good), 0) appear_date_is_good,
COALESCE(
CASE
WHEN SUM(subpoena) > 0
THEN ROUND((SUM(count_not_delivery) / SUM(subpoena) * 100), 2)
ELSE 0
END,
0
) not_delivery_percent,
COALESCE(
CASE
WHEN SUM(subpoena) > 0
THEN ROUND((SUM(count_not_delivery) / SUM(subpoena) * 100), 2)
ELSE 0
END,
0
) not_delivery_percent,
COALESCE(
CASE
WHEN SUM(subpoena) > 0
THEN ROUND((SUM(appear_date_is_good) / SUM(subpoena) * 100), 2)
ELSE 0
END,
0
) appear_date_is_good_percent,
'${REG_ID}' AS recruitment_id,
spring_autumn,
'Ministry' AS schema
FROM recruitment_campaign.subpoenas
WHERE recruitment_id = ANY ('${VK_ARRAY}')
AND schema = 'Region'
AND recording_date = CURRENT_DATE
GROUP BY spring_autumn;
Y
416
336