ratings.consideration_complaint
Y
Normal
0
/
N
1000
100
-
2024/08/02 11:56:22.507
-
2024/08/02 11:56:22.507
H4sIAAAAAAAAAAMAAAAAAAAAAAA=
N
Table input (appeal_document) РФ
Insert / update (main_dashboard.appeals)
Y
Insert / update (main_dashboard.appeals)
InsertUpdate
Y
1
none
ervu-dashboard
100
N
main_dashboard
recruitment_id
recruitment_id
=
total_appeals
total_appeals
Y
recruitment_id
recruitment_id
N
752
176
Y
Table input (appeal_document) РФ
TableInput
Y
1
none
postgres.appeal-document-service
WITH
t1 AS (
SELECT COUNT(*) AS total_appeals
FROM public.appeal_document
) -- нет причин обжалований
SELECT
t1.total_appeals,
'00' AS recruitment_id,
0 AS incorrect_inf,
0 AS no_data,
0 AS other,
0 AS incorrect_inf_percent,
0 AS no_data_percent,
0 AS other_percent
FROM t1;
0
N
N
N
400
176
Y