main_dashboard Normal 0 / LOAD_DATE 20240809

ID_BATCH Y ID_BATCH CHANNEL_ID Y CHANNEL_ID TRANSNAME Y TRANSNAME STATUS Y STATUS LINES_READ Y LINES_READ LINES_WRITTEN Y LINES_WRITTEN LINES_UPDATED Y LINES_UPDATED LINES_INPUT Y LINES_INPUT LINES_OUTPUT Y LINES_OUTPUT LINES_REJECTED Y LINES_REJECTED ERRORS Y ERRORS STARTDATE Y STARTDATE ENDDATE Y ENDDATE LOGDATE Y LOGDATE DEPDATE Y DEPDATE REPLAYDATE Y REPLAYDATE LOG_FIELD Y LOG_FIELD EXECUTING_SERVER N EXECUTING_SERVER EXECUTING_USER N EXECUTING_USER CLIENT N CLIENT

ID_BATCH Y ID_BATCH SEQ_NR Y SEQ_NR LOGDATE Y LOGDATE TRANSNAME Y TRANSNAME STEPNAME Y STEPNAME STEP_COPY Y STEP_COPY LINES_READ Y LINES_READ LINES_WRITTEN Y LINES_WRITTEN LINES_UPDATED Y LINES_UPDATED LINES_INPUT Y LINES_INPUT LINES_OUTPUT Y LINES_OUTPUT LINES_REJECTED Y LINES_REJECTED ERRORS Y ERRORS INPUT_BUFFER_ROWS Y INPUT_BUFFER_ROWS OUTPUT_BUFFER_ROWS Y OUTPUT_BUFFER_ROWS

ID_BATCH Y ID_BATCH CHANNEL_ID Y CHANNEL_ID LOG_DATE Y LOG_DATE LOGGING_OBJECT_TYPE Y LOGGING_OBJECT_TYPE OBJECT_NAME Y OBJECT_NAME OBJECT_COPY Y OBJECT_COPY REPOSITORY_DIRECTORY Y REPOSITORY_DIRECTORY FILENAME Y FILENAME OBJECT_ID Y OBJECT_ID OBJECT_REVISION Y OBJECT_REVISION PARENT_CHANNEL_ID Y PARENT_CHANNEL_ID ROOT_CHANNEL_ID Y ROOT_CHANNEL_ID

ID_BATCH Y ID_BATCH CHANNEL_ID Y CHANNEL_ID LOG_DATE Y LOG_DATE TRANSNAME Y TRANSNAME STEPNAME Y STEPNAME STEP_COPY Y STEP_COPY LINES_READ Y LINES_READ LINES_WRITTEN Y LINES_WRITTEN LINES_UPDATED Y LINES_UPDATED LINES_INPUT Y LINES_INPUT LINES_OUTPUT Y LINES_OUTPUT LINES_REJECTED Y LINES_REJECTED ERRORS Y ERRORS LOG_FIELD N LOG_FIELD

ID_BATCH Y ID_BATCH CHANNEL_ID Y CHANNEL_ID LOG_DATE Y LOG_DATE METRICS_DATE Y METRICS_DATE METRICS_CODE Y METRICS_CODE METRICS_DESCRIPTION Y METRICS_DESCRIPTION METRICS_SUBJECT Y METRICS_SUBJECT METRICS_TYPE Y METRICS_TYPE METRICS_VALUE Y METRICS_VALUE

0.0 0.0 10000 50 50 N Y 50000 Y N 1000 100 local localhost 8888 cluster Encrypted 2be98afc86aa7f2e4cb1aa265cd86aac8 Y N - 2024/08/02 11:56:22.507 - 2024/08/02 11:56:22.507 H4sIAAAAAAAAAAMAAAAAAAAAAAA= N ervu-dashboard 10.10.31.119 POSTGRESQL Native ervu-dashboard 5432 ervu-dashboard Encrypted 2be98caba1cd2df80aa0aa672d193bdde PORT_NUMBER 5432 postgres.appeal-document-service 10.10.31.118 POSTGRESQL Native appeal-document-service 5432 postgres Encrypted 2be98afc86aa7f2e4b11ba562feabf7eb PORT_NUMBER 5432 postgres.person_registry 10.10.31.118 POSTGRESQL Native person_registry 5432 postgres Encrypted 2be98afc86aa7f2e4b11ba562feabf7eb PORT_NUMBER 5432 postgres.subpoena 10.10.31.118 POSTGRESQL Native subpoena 5432 postgres Encrypted 2be98afc86aa7f2e4b11ba562feabf7eb PORT_NUMBER 5432 Table input 2 (person_registry) РФ Get variables Y Get variables Select values Y Select values Insert / update (main_dashboard.waiting_registration) Y Get variables 2 Select values 2 Y Select values 2 Insert / update (main_dashboard.total_registered) Y Table input (person_registry) РФ Get variables 2 Y Get variables 3 Select values 3 Y Select values 3 Insert / update (main_dashboard.appeals) Y Table input (appeal_document) РФ Get variables 3 Y Get variables 4 Select values 4 Y Select values 4 Insert / update (main_dashboard.recruitment_campaign) Y Table input (subpoena) РФ/осень Get variables 4 Y Get variables 2 2 Select values 2 2 Y Select values 2 2 Insert / update (main_dashboard.total_registered) 2 Y Table input (person_registry) липецк Get variables 2 2 Y Get variables 2 2 2 Select values 2 2 2 Y Select values 2 2 2 Insert / update (main_dashboard.total_registered) 2 2 Y Table input (person_registry) рязань Get variables 2 2 2 Y Get variables 2 2 2 2 Select values 2 2 2 2 Y Select values 2 2 2 2 Insert / update (main_dashboard.total_registered) 2 2 2 Y Table input (person_registry) сахалин Get variables 2 2 2 2 Y Get variables 5 Select values 5 Y Select values 5 Insert / update (main_dashboard.waiting_registration) 2 Y Table input 2 (person_registry) липецк Get variables 5 Y Get variables 5 2 Select values 5 2 Y Select values 5 2 Insert / update (main_dashboard.waiting_registration) 2 2 Y Table input 2 (person_registry) рязань Get variables 5 2 Y Get variables 5 2 2 Select values 5 2 2 Y Select values 5 2 2 Insert / update (main_dashboard.waiting_registration) 2 2 2 Y Table input 2 (person_registry) сахалин Get variables 5 2 2 Y Get variables 3 2 Select values 3 2 Y Select values 3 2 Insert / update (main_dashboard.appeals) 2 Y Table input (appeal_document) липецк Get variables 3 2 Y Get variables 3 2 2 Select values 3 2 2 Y Select values 3 2 2 Insert / update (main_dashboard.appeals) 2 2 Y Table input (appeal_document) рязань Get variables 3 2 2 Y Get variables 3 2 2 2 Select values 3 2 2 2 Y Select values 3 2 2 2 Insert / update (main_dashboard.appeals) 2 2 2 Y Table input (appeal_document) сахалин Get variables 3 2 2 2 Y Get variables 4 2 Select values 4 2 Y Select values 4 2 Insert / update (main_dashboard.recruitment_campaign) 2 Y Table input (subpoena) РФ/весна Get variables 4 2 Y Get variables 4 3 Select values 4 3 Y Select values 4 3 Insert / update (main_dashboard.recruitment_campaign) 3 Y Table input (subpoena) липецк/осень Get variables 4 3 Y Get variables 4 3 2 Select values 4 3 2 Y Select values 4 3 2 Insert / update (main_dashboard.recruitment_campaign) 3 2 Y Table input (subpoena) липецк/весна Get variables 4 3 2 Y Get variables 4 3 3 Select values 4 3 3 Y Select values 4 3 3 Insert / update (main_dashboard.recruitment_campaign) 3 3 Y Table input (subpoena) рязань/осень Get variables 4 3 3 Y Get variables 4 3 3 2 Select values 4 3 3 2 Y Select values 4 3 3 2 Insert / update (main_dashboard.recruitment_campaign) 3 3 2 Y Table input (subpoena) рязань/весна Get variables 4 3 3 2 Y Get variables 4 3 3 3 Select values 4 3 3 3 Y Select values 4 3 3 3 Insert / update (main_dashboard.recruitment_campaign) 3 3 3 Y Table input (subpoena) сахалин/осень Get variables 4 3 3 3 Y Get variables 4 3 3 3 2 Select values 4 3 3 3 2 Y Select values 4 3 3 3 2 Insert / update (main_dashboard.recruitment_campaign) 3 3 3 2 Y Table input (subpoena) сахалин/весна Get variables 4 3 3 3 2 Y Get variables GetVariable Y 1 none LOAD_DATE ${LOAD_DATE} Date yyyyMMdd -1 -1 none 304 192 Y Get variables 2 GetVariable Y 1 none LOAD_DATE ${LOAD_DATE} Date yyyyMMdd -1 -1 none 304 80 Y Get variables 2 2 GetVariable Y 1 none LOAD_DATE ${LOAD_DATE} Date yyyyMMdd -1 -1 none 304 688 Y Get variables 2 2 2 GetVariable Y 1 none LOAD_DATE ${LOAD_DATE} Date yyyyMMdd -1 -1 none 304 1200 Y Get variables 2 2 2 2 GetVariable Y 1 none LOAD_DATE ${LOAD_DATE} Date yyyyMMdd -1 -1 none 304 1792 Y Get variables 3 GetVariable Y 1 none LOAD_DATE ${LOAD_DATE} Date yyyyMMdd -1 -1 none 304 304 Y Get variables 3 2 GetVariable Y 1 none LOAD_DATE ${LOAD_DATE} Date yyyyMMdd -1 -1 none 304 848 Y Get variables 3 2 2 GetVariable Y 1 none LOAD_DATE ${LOAD_DATE} Date yyyyMMdd -1 -1 none 304 1392 Y Get variables 3 2 2 2 GetVariable Y 1 none LOAD_DATE ${LOAD_DATE} Date yyyyMMdd -1 -1 none 304 1984 Y Get variables 4 GetVariable Y 1 none LOAD_DATE ${LOAD_DATE} Date yyyyMMdd -1 -1 none 304 400 Y Get variables 4 2 GetVariable Y 1 none LOAD_DATE ${LOAD_DATE} Date yyyyMMdd -1 -1 none 304 464 Y Get variables 4 3 GetVariable Y 1 none LOAD_DATE ${LOAD_DATE} Date yyyyMMdd -1 -1 none 304 928 Y Get variables 4 3 2 GetVariable Y 1 none LOAD_DATE ${LOAD_DATE} Date yyyyMMdd -1 -1 none 304 992 Y Get variables 4 3 3 GetVariable Y 1 none LOAD_DATE ${LOAD_DATE} Date yyyyMMdd -1 -1 none 304 1472 Y Get variables 4 3 3 2 GetVariable Y 1 none LOAD_DATE ${LOAD_DATE} Date yyyyMMdd -1 -1 none 304 1536 Y Get variables 4 3 3 3 GetVariable Y 1 none LOAD_DATE ${LOAD_DATE} Date yyyyMMdd -1 -1 none 304 2080 Y Get variables 4 3 3 3 2 GetVariable Y 1 none LOAD_DATE ${LOAD_DATE} Date yyyyMMdd -1 -1 none 304 2144 Y Get variables 5 GetVariable Y 1 none LOAD_DATE ${LOAD_DATE} Date yyyyMMdd -1 -1 none 304 768 Y Get variables 5 2 GetVariable Y 1 none LOAD_DATE ${LOAD_DATE} Date yyyyMMdd -1 -1 none 304 1296 Y Get variables 5 2 2 GetVariable Y 1 none LOAD_DATE ${LOAD_DATE} Date yyyyMMdd -1 -1 none 304 1888 Y Insert / update (main_dashboard.appeals) InsertUpdate Y 1 none ervu-dashboard 100 N main_dashboard

appeals

LOAD_DATE recording_date = total_appeals total_appeals Y average_consideration average_consideration Y resolved resolved Y average_rating average_rating Y average_to_face average_to_face Y "average_EPGU" average_epgu Y average_to_face_percent average_to_face_percent Y "average_EPGU_percent" average_epgu_percent Y testrecruitment_id recruitment_id Y recording_date LOAD_DATE N 624 304 Y Insert / update (main_dashboard.appeals) 2 InsertUpdate Y 1 none ervu-dashboard 100 N main_dashboard appeals

LOAD_DATE recording_date = total_appeals total_appeals Y average_consideration average_consideration Y resolved resolved Y average_rating average_rating Y average_to_face average_to_face Y "average_EPGU" average_epgu Y average_to_face_percent average_to_face_percent Y "average_EPGU_percent" average_epgu_percent Y testrecruitment_id recruitment_id Y recording_date LOAD_DATE N 624 848 Y Insert / update (main_dashboard.appeals) 2 2 InsertUpdate Y 1 none ervu-dashboard 100 N main_dashboard appeals

LOAD_DATE recording_date = total_appeals total_appeals Y average_consideration average_consideration Y resolved resolved Y average_rating average_rating Y average_to_face average_to_face Y "average_EPGU" average_epgu Y average_to_face_percent average_to_face_percent Y "average_EPGU_percent" average_epgu_percent Y testrecruitment_id recruitment_id Y recording_date LOAD_DATE N 624 1392 Y Insert / update (main_dashboard.appeals) 2 2 2 InsertUpdate Y 1 none ervu-dashboard 100 N main_dashboard appeals

LOAD_DATE recording_date = total_appeals total_appeals Y average_consideration average_consideration Y resolved resolved Y average_rating average_rating Y average_to_face average_to_face Y "average_EPGU" average_epgu Y average_to_face_percent average_to_face_percent Y "average_EPGU_percent" average_epgu_percent Y testrecruitment_id recruitment_id Y recording_date LOAD_DATE N 624 1984 Y Insert / update (main_dashboard.recruitment_campaign) InsertUpdate Y 1 none ervu-dashboard 100 N main_dashboard recruitment_campaign

LOAD_DATE recording_date = subpoenas_sent subpoenas_sent Y appeared_on_subpoenas appeared_on_subpoenas Y not_appeared_on_subpoenas not_appeared_on_subpoenas 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 testrecruitment_id recruitment_id Y testspring_autumn spring_autumn Y recording_date LOAD_DATE N 640 400 Y Insert / update (main_dashboard.recruitment_campaign) 2 InsertUpdate Y 1 none ervu-dashboard 100 N main_dashboard recruitment_campaign

LOAD_DATE recording_date = subpoenas_sent subpoenas_sent Y appeared_on_subpoenas appeared_on_subpoenas Y not_appeared_on_subpoenas not_appeared_on_subpoenas 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 testrecruitment_id recruitment_id Y testspring_autumn spring_autumn Y recording_date LOAD_DATE N 640 464 Y Insert / update (main_dashboard.recruitment_campaign) 3 InsertUpdate Y 1 none ervu-dashboard 100 N main_dashboard recruitment_campaign

LOAD_DATE recording_date = subpoenas_sent subpoenas_sent Y appeared_on_subpoenas appeared_on_subpoenas Y not_appeared_on_subpoenas not_appeared_on_subpoenas 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 testrecruitment_id recruitment_id Y testspring_autumn spring_autumn Y recording_date LOAD_DATE N 640 928 Y Insert / update (main_dashboard.recruitment_campaign) 3 2 InsertUpdate Y 1 none ervu-dashboard 100 N main_dashboard recruitment_campaign

LOAD_DATE recording_date = subpoenas_sent subpoenas_sent Y appeared_on_subpoenas appeared_on_subpoenas Y not_appeared_on_subpoenas not_appeared_on_subpoenas 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 testrecruitment_id recruitment_id Y testspring_autumn spring_autumn Y recording_date LOAD_DATE N 640 992 Y Insert / update (main_dashboard.recruitment_campaign) 3 3 InsertUpdate Y 1 none ervu-dashboard 100 N main_dashboard recruitment_campaign

LOAD_DATE recording_date = subpoenas_sent subpoenas_sent Y appeared_on_subpoenas appeared_on_subpoenas Y not_appeared_on_subpoenas not_appeared_on_subpoenas 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 testrecruitment_id recruitment_id Y testspring_autumn spring_autumn Y recording_date LOAD_DATE N 640 1472 Y Insert / update (main_dashboard.recruitment_campaign) 3 3 2 InsertUpdate Y 1 none ervu-dashboard 100 N main_dashboard recruitment_campaign

LOAD_DATE recording_date = subpoenas_sent subpoenas_sent Y appeared_on_subpoenas appeared_on_subpoenas Y not_appeared_on_subpoenas not_appeared_on_subpoenas 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 testrecruitment_id recruitment_id Y testspring_autumn spring_autumn Y recording_date LOAD_DATE N 640 1536 Y Insert / update (main_dashboard.recruitment_campaign) 3 3 3 InsertUpdate Y 1 none ervu-dashboard 100 N main_dashboard recruitment_campaign

LOAD_DATE recording_date = subpoenas_sent subpoenas_sent Y appeared_on_subpoenas appeared_on_subpoenas Y not_appeared_on_subpoenas not_appeared_on_subpoenas 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 testrecruitment_id recruitment_id Y testspring_autumn spring_autumn Y recording_date LOAD_DATE N 640 2080 Y Insert / update (main_dashboard.recruitment_campaign) 3 3 3 2 InsertUpdate Y 1 none ervu-dashboard 100 N main_dashboard recruitment_campaign

LOAD_DATE recording_date = subpoenas_sent subpoenas_sent Y appeared_on_subpoenas appeared_on_subpoenas Y not_appeared_on_subpoenas not_appeared_on_subpoenas 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 testrecruitment_id recruitment_id Y testspring_autumn spring_autumn Y recording_date LOAD_DATE N 640 2144 Y Insert / update (main_dashboard.total_registered) InsertUpdate Y 1 none ervu-dashboard 100 N main_dashboard total_registered

LOAD_DATE recording_date = total_registered total_count Y "total_registered_M" male_count Y "total_registered_W" female_count Y mobilization_criterion mobilization_criterion Y volunteer_criterion volunteer_criterion Y contract_criterion contract_criterion Y mobilization_criterion_percent mobilization_criterion_percent Y volunteer_criterion_percent volunteer_criterion_percent Y contract_criterion_percent contract_criterion_percent Y testrecruitment_id recruitment_id Y recording_date LOAD_DATE N 624 80 Y Insert / update (main_dashboard.total_registered) 2 InsertUpdate Y 1 none ervu-dashboard 100 N main_dashboard total_registered

LOAD_DATE recording_date = total_registered total_count Y "total_registered_M" male_count Y "total_registered_W" female_count Y mobilization_criterion mobilization_criterion Y volunteer_criterion volunteer_criterion Y contract_criterion contract_criterion Y mobilization_criterion_percent mobilization_criterion_percent Y volunteer_criterion_percent volunteer_criterion_percent Y contract_criterion_percent contract_criterion_percent Y testrecruitment_id recruitment_id Y recording_date LOAD_DATE N 624 688 Y Insert / update (main_dashboard.total_registered) 2 2 InsertUpdate Y 1 none ervu-dashboard 100 N main_dashboard total_registered

LOAD_DATE recording_date = total_registered total_count Y "total_registered_M" male_count Y "total_registered_W" female_count Y mobilization_criterion mobilization_criterion Y volunteer_criterion volunteer_criterion Y contract_criterion contract_criterion Y mobilization_criterion_percent mobilization_criterion_percent Y volunteer_criterion_percent volunteer_criterion_percent Y contract_criterion_percent contract_criterion_percent Y testrecruitment_id recruitment_id Y recording_date LOAD_DATE N 624 1200 Y Insert / update (main_dashboard.total_registered) 2 2 2 InsertUpdate Y 1 none ervu-dashboard 100 N main_dashboard total_registered

LOAD_DATE recording_date = total_registered total_count Y "total_registered_M" male_count Y "total_registered_W" female_count Y mobilization_criterion mobilization_criterion Y volunteer_criterion volunteer_criterion Y contract_criterion contract_criterion Y mobilization_criterion_percent mobilization_criterion_percent Y volunteer_criterion_percent volunteer_criterion_percent Y contract_criterion_percent contract_criterion_percent Y testrecruitment_id recruitment_id Y recording_date LOAD_DATE N 624 1792 Y Insert / update (main_dashboard.waiting_registration) InsertUpdate Y 1 none ervu-dashboard 100 N main_dashboard waiting_registration

LOAD_DATE recording_date = waiting_registration waiting_count Y "waiting_registration_M" male_count Y "waiting_registration_W" female_count Y mobilization_criterion mobilization_criterion Y volunteer_criterion volunteer_criterion Y contract_criterion contract_criterion Y mobilization_criterion_percent mobilization_criterion_percent Y volunteer_criterion_percent volunteer_criterion_percent Y contract_criterion_percent contract_criterion_percent Y testrecruitment_id recruitment_id Y recording_date LOAD_DATE N 624 1888 Y Select values SelectValues Y 1 none N LOAD_DATE LOAD_DATE Date -2 -2 yyyy-MM-dd false false 400 192 Y Select values 2 SelectValues Y 1 none N LOAD_DATE LOAD_DATE Date -2 -2 yyyy-MM-dd false false 400 80 Y Select values 2 2 SelectValues Y 1 none N LOAD_DATE LOAD_DATE Date -2 -2 yyyy-MM-dd false false 400 688 Y Select values 2 2 2 SelectValues Y 1 none N LOAD_DATE LOAD_DATE Date -2 -2 yyyy-MM-dd false false 400 1200 Y Select values 2 2 2 2 SelectValues Y 1 none N LOAD_DATE LOAD_DATE Date -2 -2 yyyy-MM-dd false false 400 1792 Y Select values 3 SelectValues Y 1 none N LOAD_DATE LOAD_DATE Date -2 -2 yyyy-MM-dd false false 400 304 Y Select values 3 2 SelectValues Y 1 none N LOAD_DATE LOAD_DATE Date -2 -2 yyyy-MM-dd false false 400 848 Y Select values 3 2 2 SelectValues Y 1 none N LOAD_DATE LOAD_DATE Date -2 -2 yyyy-MM-dd false false 400 1392 Y Select values 3 2 2 2 SelectValues Y 1 none N LOAD_DATE LOAD_DATE Date -2 -2 yyyy-MM-dd false false 400 1984 Y Select values 4 SelectValues Y 1 none N LOAD_DATE LOAD_DATE Date -2 -2 yyyy-MM-dd false false 416 400 Y Select values 4 2 SelectValues Y 1 none N LOAD_DATE LOAD_DATE Date -2 -2 yyyy-MM-dd false false 416 464 Y Select values 4 3 SelectValues Y 1 none N LOAD_DATE LOAD_DATE Date -2 -2 yyyy-MM-dd false false 416 928 Y Select values 4 3 2 SelectValues Y 1 none N LOAD_DATE LOAD_DATE Date -2 -2 yyyy-MM-dd false false 416 992 Y Select values 4 3 3 SelectValues Y 1 none N LOAD_DATE LOAD_DATE Date -2 -2 yyyy-MM-dd false false 416 1472 Y Select values 4 3 3 2 SelectValues Y 1 none N LOAD_DATE LOAD_DATE Date -2 -2 yyyy-MM-dd false false 416 1536 Y Select values 4 3 3 3 SelectValues Y 1 none N LOAD_DATE LOAD_DATE Date -2 -2 yyyy-MM-dd false false 416 2080 Y Select values 4 3 3 3 2 SelectValues Y 1 none N LOAD_DATE LOAD_DATE Date -2 -2 yyyy-MM-dd false false 416 2144 Y Select values 5 SelectValues Y 1 none N LOAD_DATE LOAD_DATE Date -2 -2 yyyy-MM-dd false false 400 768 Y Select values 5 2 SelectValues Y 1 none N LOAD_DATE LOAD_DATE Date -2 -2 yyyy-MM-dd false false 400 1296 Y Select values 5 2 2 SelectValues Y 1 none N LOAD_DATE LOAD_DATE Date -2 -2 yyyy-MM-dd false false 400 1888 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 ad), t2 as (select (avg(trim(both '"' from (ad.extra_info -> 'resultDate')::text)::date - appeal_date)) as average_consideration from public.appeal_document ad) select t1.total_appeals, t2.average_consideration, '76e40191-adc7-4f03-84a4-0c29c44961a6' as recruitment_id, 0 as resolved, 1 as average_rating, 0 as average_to_face, 0 as average_epgu, 0 as average_to_face_percent, 0 as average_epgu_percent from t1 full outer join t2 on 1 = 1 0 N N N 144 304 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 ad where vk_id = '191e81ae-8f1d-495a-aee5-ec1f200ba509'), t2 as (select (avg(trim(both '"' from (ad.extra_info -> 'resultDate')::text)::date - appeal_date)) as average_consideration from public.appeal_document ad where vk_id = '191e81ae-8f1d-495a-aee5-ec1f200ba509') select t1.total_appeals, t2.average_consideration, '794ed0fa-a25b-4858-b89e-815bb391f2b5' as recruitment_id, 0 as resolved, 0 as average_rating, 0 as average_to_face, 0 as average_epgu, 0 as average_to_face_percent, 0 as average_epgu_percent from t1 full outer join t2 on 1 = 1 0 N N N 144 848 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 ad where vk_id = '1284964b-3bf8-41b5-adb5-c6d1ec1bc13c'), t2 as (select (avg(trim(both '"' from (ad.extra_info -> 'resultDate')::text)::date - appeal_date)) as average_consideration from public.appeal_document ad where vk_id = '1284964b-3bf8-41b5-adb5-c6d1ec1bc13c') select t1.total_appeals, t2.average_consideration, 'd2e839ef-933c-48df-9a3a-ac1c00663154' as recruitment_id, 0 as resolved, 0 as average_rating, 0 as average_to_face, 0 as average_epgu, 0 as average_to_face_percent, 0 as average_epgu_percent from t1 full outer join t2 on 1 = 1 0 N N N 144 1392 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 ad where vk_id = 'de265e31-4b82-4dc8-9bf6-af990d6d649e'), t2 as (select (avg(trim(both '"' from (ad.extra_info -> 'resultDate')::text)::date - appeal_date)) as average_consideration from public.appeal_document ad where vk_id = 'de265e31-4b82-4dc8-9bf6-af990d6d649e') select t1.total_appeals, t2.average_consideration, '6b56f46a-16e7-4c0f-83a8-05fbddf2e6cb' as recruitment_id, 0 as resolved, 0 as average_rating, 0 as average_to_face, 0 as average_epgu, 0 as average_to_face_percent, 0 as average_epgu_percent from t1 full outer join t2 on 1 = 1 0 N N N 144 1984 Y Table input (person_registry) РФ TableInput Y 1 none postgres.person_registry with t1 as (select count(*) total_count from public.recruits r where r.vu_current_info -> 'isMilitaryRegistered' = 'true'), t2 as (select count(*) filter(where gender='MALE') male_count from public.recruits r where r.vu_current_info -> 'isMilitaryRegistered' = 'true'), t3 as (select count(*) filter(where gender='FEMALE') female_count from public.recruits r where r.vu_current_info -> 'isMilitaryRegistered' = 'true') select t1.total_count, t2.male_count, t3.female_count, '76e40191-adc7-4f03-84a4-0c29c44961a6' as recruitment_id, 0 as mobilization_criterion, 0 as volunteer_criterion, 0 as contract_criterion, 0 as mobilization_criterion_percent, 0 as volunteer_criterion_percent, 0 as contract_criterion_percent from t1 full outer join t2 on 1 = 1 full outer join t3 on 1 = 1 0 N N N 144 80 Y Table input (person_registry) липецк TableInput Y 1 none postgres.person_registry with t1 as (select count(*) total_count from public.recruits r where r.vu_current_info -> 'isMilitaryRegistered' = 'true' and target_recruitment_id = '191e81ae-8f1d-495a-aee5-ec1f200ba509'), t2 as (select count(*) filter(where gender='MALE') male_count from public.recruits r where r.vu_current_info -> 'isMilitaryRegistered' = 'true' and target_recruitment_id = '191e81ae-8f1d-495a-aee5-ec1f200ba509'), t3 as (select count(*) filter(where gender='FEMALE') female_count from public.recruits r where r.vu_current_info -> 'isMilitaryRegistered' = 'true' and target_recruitment_id = '191e81ae-8f1d-495a-aee5-ec1f200ba509') select t1.total_count, t2.male_count, t3.female_count, '794ed0fa-a25b-4858-b89e-815bb391f2b5' as recruitment_id, 0 as mobilization_criterion, 0 as volunteer_criterion, 0 as contract_criterion, 0 as mobilization_criterion_percent, 0 as volunteer_criterion_percent, 0 as contract_criterion_percent from t1 full outer join t2 on 1 = 1 full outer join t3 on 1 = 1 0 N N N 144 688 Y Table input (person_registry) рязань TableInput Y 1 none postgres.person_registry with t1 as (select count(*) total_count from public.recruits r where r.vu_current_info -> 'isMilitaryRegistered' = 'true' and target_recruitment_id = '1284964b-3bf8-41b5-adb5-c6d1ec1bc13c'), t2 as (select count(*) filter(where gender='MALE') male_count from public.recruits r where r.vu_current_info -> 'isMilitaryRegistered' = 'true' and target_recruitment_id = '1284964b-3bf8-41b5-adb5-c6d1ec1bc13c'), t3 as (select count(*) filter(where gender='FEMALE') female_count from public.recruits r where r.vu_current_info -> 'isMilitaryRegistered' = 'true' and target_recruitment_id = '1284964b-3bf8-41b5-adb5-c6d1ec1bc13c') select t1.total_count, t2.male_count, t3.female_count, 'd2e839ef-933c-48df-9a3a-ac1c00663154' as recruitment_id, 0 as mobilization_criterion, 0 as volunteer_criterion, 0 as contract_criterion, 0 as mobilization_criterion_percent, 0 as volunteer_criterion_percent, 0 as contract_criterion_percent from t1 full outer join t2 on 1 = 1 full outer join t3 on 1 = 1 0 N N N 144 1200 Y Table input (person_registry) сахалин TableInput Y 1 none postgres.person_registry with t1 as (select count(*) total_count from public.recruits r where r.vu_current_info -> 'isMilitaryRegistered' = 'true' and target_recruitment_id = 'de265e31-4b82-4dc8-9bf6-af990d6d649e'), t2 as (select count(*) filter(where gender='MALE') male_count from public.recruits r where r.vu_current_info -> 'isMilitaryRegistered' = 'true' and target_recruitment_id = 'de265e31-4b82-4dc8-9bf6-af990d6d649e'), t3 as (select count(*) filter(where gender='FEMALE') female_count from public.recruits r where r.vu_current_info -> 'isMilitaryRegistered' = 'true' and target_recruitment_id = 'de265e31-4b82-4dc8-9bf6-af990d6d649e') select t1.total_count, t2.male_count, t3.female_count, '6b56f46a-16e7-4c0f-83a8-05fbddf2e6cb' as recruitment_id, 0 as mobilization_criterion, 0 as volunteer_criterion, 0 as contract_criterion, 0 as mobilization_criterion_percent, 0 as volunteer_criterion_percent, 0 as contract_criterion_percent from t1 full outer join t2 on 1 = 1 full outer join t3 on 1 = 1 0 N N N 144 1792 Y Table input (subpoena) РФ/весна TableInput Y 1 none postgres.subpoena with t1 as (select count(distinct subpoena.id) as subpoenas_sent FROM subpoena JOIN subpoena_history ON subpoena_history.subpoena_id = subpoena.id JOIN subpoena_status AS sub_status ON sub_status.id = subpoena.status_id JOIN subpoena_status AS sub_stat_hist ON sub_stat_hist.id = subpoena_history.status_id JOIN subpoena_reason ON subpoena_reason.id = subpoena.reason_id where subpoena_reason.type='3' and sub_stat_hist.code ='3'), t2 as (select count(distinct subpoena.id) as appeared_on_subpoenas FROM subpoena JOIN subpoena_history ON subpoena_history.subpoena_id = subpoena.id JOIN subpoena_status AS sub_status ON sub_status.id = subpoena.status_id JOIN subpoena_status AS sub_stat_hist ON sub_stat_hist.id = subpoena_history.status_id JOIN subpoena_reason ON subpoena_reason.id = subpoena.reason_id where subpoena_reason.type='3' and sub_stat_hist.code in ('4.1','4.2')), t3 as (select count(distinct subpoena.id) as not_appeared_on_subpoenas FROM subpoena JOIN subpoena_history ON subpoena_history.subpoena_id = subpoena.id JOIN subpoena_status AS sub_status ON sub_status.id = subpoena.status_id JOIN subpoena_status AS sub_stat_hist ON sub_stat_hist.id = subpoena_history.status_id JOIN subpoena_reason ON subpoena_reason.id = subpoena.reason_id where subpoena_reason.type='3' and sub_stat_hist.code ='5') select t1.subpoenas_sent, t2.appeared_on_subpoenas, t3.not_appeared_on_subpoenas, 1 as org, '76e40191-adc7-4f03-84a4-0c29c44961a6' as recruitment_id, 'Весна' as spring_autumn, 0 as new_recruits, 0 as postponement_have_right, 0 as postponement_granted, 0 as appeared_on_subpoenas_percent, 0 as not_appeared_on_subpoenas_percent, 0 as postponement_have_right_percent, 0 as postponement_granted_percent from t1 full outer join t2 on 1 = 1 full outer join t3 on 1 = 1 0 N N N 144 464 Y Table input (subpoena) РФ/осень TableInput Y 1 none postgres.subpoena with t1 as (select count(distinct subpoena.id) as subpoenas_sent FROM subpoena JOIN subpoena_history ON subpoena_history.subpoena_id = subpoena.id JOIN subpoena_status AS sub_status ON sub_status.id = subpoena.status_id JOIN subpoena_status AS sub_stat_hist ON sub_stat_hist.id = subpoena_history.status_id JOIN subpoena_reason ON subpoena_reason.id = subpoena.reason_id where subpoena_reason.type='3' and sub_stat_hist.code ='3'), t2 as (select count(distinct subpoena.id) as appeared_on_subpoenas FROM subpoena JOIN subpoena_history ON subpoena_history.subpoena_id = subpoena.id JOIN subpoena_status AS sub_status ON sub_status.id = subpoena.status_id JOIN subpoena_status AS sub_stat_hist ON sub_stat_hist.id = subpoena_history.status_id JOIN subpoena_reason ON subpoena_reason.id = subpoena.reason_id where subpoena_reason.type='3' and sub_stat_hist.code in ('4.1','4.2')), t3 as (select count(distinct subpoena.id) as not_appeared_on_subpoenas FROM subpoena JOIN subpoena_history ON subpoena_history.subpoena_id = subpoena.id JOIN subpoena_status AS sub_status ON sub_status.id = subpoena.status_id JOIN subpoena_status AS sub_stat_hist ON sub_stat_hist.id = subpoena_history.status_id JOIN subpoena_reason ON subpoena_reason.id = subpoena.reason_id where subpoena_reason.type='3' and sub_stat_hist.code ='5') select t1.subpoenas_sent, t2.appeared_on_subpoenas, t3.not_appeared_on_subpoenas, 1 as org, '76e40191-adc7-4f03-84a4-0c29c44961a6' as recruitment_id, 'Осень' as spring_autumn, 0 as new_recruits, 0 as postponement_have_right, 0 as postponement_granted, 0 as appeared_on_subpoenas_percent, 0 as not_appeared_on_subpoenas_percent, 0 as postponement_have_right_percent, 0 as postponement_granted_percent from t1 full outer join t2 on 1 = 1 full outer join t3 on 1 = 1 0 N N N 144 400 Y Table input (subpoena) липецк/весна TableInput Y 1 none postgres.subpoena with t1 as (select count(distinct subpoena.id) as subpoenas_sent FROM subpoena JOIN subpoena_history ON subpoena_history.subpoena_id = subpoena.id JOIN subpoena_status AS sub_status ON sub_status.id = subpoena.status_id JOIN subpoena_status AS sub_stat_hist ON sub_stat_hist.id = subpoena_history.status_id JOIN subpoena_reason ON subpoena_reason.id = subpoena.reason_id where subpoena_reason.type='3' and sub_stat_hist.code ='3' and subpoena.department_id = '191e81ae-8f1d-495a-aee5-ec1f200ba509'), t2 as (select count(distinct subpoena.id) as appeared_on_subpoenas FROM subpoena JOIN subpoena_history ON subpoena_history.subpoena_id = subpoena.id JOIN subpoena_status AS sub_status ON sub_status.id = subpoena.status_id JOIN subpoena_status AS sub_stat_hist ON sub_stat_hist.id = subpoena_history.status_id JOIN subpoena_reason ON subpoena_reason.id = subpoena.reason_id where subpoena_reason.type='3' and sub_stat_hist.code in ('4.1','4.2') and subpoena.department_id = '191e81ae-8f1d-495a-aee5-ec1f200ba509'), t3 as (select count(distinct subpoena.id) as not_appeared_on_subpoenas FROM subpoena JOIN subpoena_history ON subpoena_history.subpoena_id = subpoena.id JOIN subpoena_status AS sub_status ON sub_status.id = subpoena.status_id JOIN subpoena_status AS sub_stat_hist ON sub_stat_hist.id = subpoena_history.status_id JOIN subpoena_reason ON subpoena_reason.id = subpoena.reason_id where subpoena_reason.type='3' and sub_stat_hist.code ='5' and subpoena.department_id = '191e81ae-8f1d-495a-aee5-ec1f200ba509') select t1.subpoenas_sent, t2.appeared_on_subpoenas, t3.not_appeared_on_subpoenas, 1 as org, '794ed0fa-a25b-4858-b89e-815bb391f2b5' as recruitment_id, 'Весна' as spring_autumn, 0 as new_recruits, 0 as postponement_have_right, 0 as postponement_granted, 0 as appeared_on_subpoenas_percent, 0 as not_appeared_on_subpoenas_percent, 0 as postponement_have_right_percent, 0 as postponement_granted_percent from t1 full outer join t2 on 1 = 1 full outer join t3 on 1 = 1 0 N N N 144 992 Y Table input (subpoena) липецк/осень TableInput Y 1 none postgres.subpoena with t1 as (select count(distinct subpoena.id) as subpoenas_sent FROM subpoena JOIN subpoena_history ON subpoena_history.subpoena_id = subpoena.id JOIN subpoena_status AS sub_status ON sub_status.id = subpoena.status_id JOIN subpoena_status AS sub_stat_hist ON sub_stat_hist.id = subpoena_history.status_id JOIN subpoena_reason ON subpoena_reason.id = subpoena.reason_id where subpoena_reason.type='3' and sub_stat_hist.code ='3' and subpoena.department_id = '191e81ae-8f1d-495a-aee5-ec1f200ba509'), t2 as (select count(distinct subpoena.id) as appeared_on_subpoenas FROM subpoena JOIN subpoena_history ON subpoena_history.subpoena_id = subpoena.id JOIN subpoena_status AS sub_status ON sub_status.id = subpoena.status_id JOIN subpoena_status AS sub_stat_hist ON sub_stat_hist.id = subpoena_history.status_id JOIN subpoena_reason ON subpoena_reason.id = subpoena.reason_id where subpoena_reason.type='3' and sub_stat_hist.code in ('4.1','4.2') and subpoena.department_id = '191e81ae-8f1d-495a-aee5-ec1f200ba509'), t3 as (select count(distinct subpoena.id) as not_appeared_on_subpoenas FROM subpoena JOIN subpoena_history ON subpoena_history.subpoena_id = subpoena.id JOIN subpoena_status AS sub_status ON sub_status.id = subpoena.status_id JOIN subpoena_status AS sub_stat_hist ON sub_stat_hist.id = subpoena_history.status_id JOIN subpoena_reason ON subpoena_reason.id = subpoena.reason_id where subpoena_reason.type='3' and sub_stat_hist.code ='5' and subpoena.department_id = '191e81ae-8f1d-495a-aee5-ec1f200ba509') select t1.subpoenas_sent, t2.appeared_on_subpoenas, t3.not_appeared_on_subpoenas, 1 as org, '794ed0fa-a25b-4858-b89e-815bb391f2b5' as recruitment_id, 'Осень' as spring_autumn, 0 as new_recruits, 0 as postponement_have_right, 0 as postponement_granted, 0 as appeared_on_subpoenas_percent, 0 as not_appeared_on_subpoenas_percent, 0 as postponement_have_right_percent, 0 as postponement_granted_percent from t1 full outer join t2 on 1 = 1 full outer join t3 on 1 = 1 0 N N N 144 928 Y Table input (subpoena) рязань/весна TableInput Y 1 none postgres.subpoena with t1 as (select count(distinct subpoena.id) as subpoenas_sent FROM subpoena JOIN subpoena_history ON subpoena_history.subpoena_id = subpoena.id JOIN subpoena_status AS sub_status ON sub_status.id = subpoena.status_id JOIN subpoena_status AS sub_stat_hist ON sub_stat_hist.id = subpoena_history.status_id JOIN subpoena_reason ON subpoena_reason.id = subpoena.reason_id where subpoena_reason.type='3' and sub_stat_hist.code ='3' and subpoena.department_id = '1284964b-3bf8-41b5-adb5-c6d1ec1bc13c'), t2 as (select count(distinct subpoena.id) as appeared_on_subpoenas FROM subpoena JOIN subpoena_history ON subpoena_history.subpoena_id = subpoena.id JOIN subpoena_status AS sub_status ON sub_status.id = subpoena.status_id JOIN subpoena_status AS sub_stat_hist ON sub_stat_hist.id = subpoena_history.status_id JOIN subpoena_reason ON subpoena_reason.id = subpoena.reason_id where subpoena_reason.type='3' and sub_stat_hist.code in ('4.1','4.2') and subpoena.department_id = '1284964b-3bf8-41b5-adb5-c6d1ec1bc13c'), t3 as (select count(distinct subpoena.id) as not_appeared_on_subpoenas FROM subpoena JOIN subpoena_history ON subpoena_history.subpoena_id = subpoena.id JOIN subpoena_status AS sub_status ON sub_status.id = subpoena.status_id JOIN subpoena_status AS sub_stat_hist ON sub_stat_hist.id = subpoena_history.status_id JOIN subpoena_reason ON subpoena_reason.id = subpoena.reason_id where subpoena_reason.type='3' and sub_stat_hist.code ='5' and subpoena.department_id = '1284964b-3bf8-41b5-adb5-c6d1ec1bc13c') select t1.subpoenas_sent, t2.appeared_on_subpoenas, t3.not_appeared_on_subpoenas, 1 as org, 'd2e839ef-933c-48df-9a3a-ac1c00663154' as recruitment_id, 'Весна' as spring_autumn, 0 as new_recruits, 0 as postponement_have_right, 0 as postponement_granted, 0 as appeared_on_subpoenas_percent, 0 as not_appeared_on_subpoenas_percent, 0 as postponement_have_right_percent, 0 as postponement_granted_percent from t1 full outer join t2 on 1 = 1 full outer join t3 on 1 = 1 0 N N N 144 1536 Y Table input (subpoena) рязань/осень TableInput Y 1 none postgres.subpoena with t1 as (select count(distinct subpoena.id) as subpoenas_sent FROM subpoena JOIN subpoena_history ON subpoena_history.subpoena_id = subpoena.id JOIN subpoena_status AS sub_status ON sub_status.id = subpoena.status_id JOIN subpoena_status AS sub_stat_hist ON sub_stat_hist.id = subpoena_history.status_id JOIN subpoena_reason ON subpoena_reason.id = subpoena.reason_id where subpoena_reason.type='3' and sub_stat_hist.code ='3' and subpoena.department_id = '1284964b-3bf8-41b5-adb5-c6d1ec1bc13c'), t2 as (select count(distinct subpoena.id) as appeared_on_subpoenas FROM subpoena JOIN subpoena_history ON subpoena_history.subpoena_id = subpoena.id JOIN subpoena_status AS sub_status ON sub_status.id = subpoena.status_id JOIN subpoena_status AS sub_stat_hist ON sub_stat_hist.id = subpoena_history.status_id JOIN subpoena_reason ON subpoena_reason.id = subpoena.reason_id where subpoena_reason.type='3' and sub_stat_hist.code in ('4.1','4.2') and subpoena.department_id = '1284964b-3bf8-41b5-adb5-c6d1ec1bc13c'), t3 as (select count(distinct subpoena.id) as not_appeared_on_subpoenas FROM subpoena JOIN subpoena_history ON subpoena_history.subpoena_id = subpoena.id JOIN subpoena_status AS sub_status ON sub_status.id = subpoena.status_id JOIN subpoena_status AS sub_stat_hist ON sub_stat_hist.id = subpoena_history.status_id JOIN subpoena_reason ON subpoena_reason.id = subpoena.reason_id where subpoena_reason.type='3' and sub_stat_hist.code ='5' and subpoena.department_id = '1284964b-3bf8-41b5-adb5-c6d1ec1bc13c') select t1.subpoenas_sent, t2.appeared_on_subpoenas, t3.not_appeared_on_subpoenas, 1 as org, 'd2e839ef-933c-48df-9a3a-ac1c00663154' as recruitment_id, 'Осень' as spring_autumn, 0 as new_recruits, 0 as postponement_have_right, 0 as postponement_granted, 0 as appeared_on_subpoenas_percent, 0 as not_appeared_on_subpoenas_percent, 0 as postponement_have_right_percent, 0 as postponement_granted_percent from t1 full outer join t2 on 1 = 1 full outer join t3 on 1 = 1 0 N N N 144 1472 Y Table input (subpoena) сахалин/весна TableInput Y 1 none postgres.subpoena with t1 as (select count(distinct subpoena.id) as subpoenas_sent FROM subpoena JOIN subpoena_history ON subpoena_history.subpoena_id = subpoena.id JOIN subpoena_status AS sub_status ON sub_status.id = subpoena.status_id JOIN subpoena_status AS sub_stat_hist ON sub_stat_hist.id = subpoena_history.status_id JOIN subpoena_reason ON subpoena_reason.id = subpoena.reason_id where subpoena_reason.type='3' and sub_stat_hist.code ='3' and subpoena.department_id = 'de265e31-4b82-4dc8-9bf6-af990d6d649e'), t2 as (select count(distinct subpoena.id) as appeared_on_subpoenas FROM subpoena JOIN subpoena_history ON subpoena_history.subpoena_id = subpoena.id JOIN subpoena_status AS sub_status ON sub_status.id = subpoena.status_id JOIN subpoena_status AS sub_stat_hist ON sub_stat_hist.id = subpoena_history.status_id JOIN subpoena_reason ON subpoena_reason.id = subpoena.reason_id where subpoena_reason.type='3' and sub_stat_hist.code in ('4.1','4.2') and subpoena.department_id = 'de265e31-4b82-4dc8-9bf6-af990d6d649e'), t3 as (select count(distinct subpoena.id) as not_appeared_on_subpoenas FROM subpoena JOIN subpoena_history ON subpoena_history.subpoena_id = subpoena.id JOIN subpoena_status AS sub_status ON sub_status.id = subpoena.status_id JOIN subpoena_status AS sub_stat_hist ON sub_stat_hist.id = subpoena_history.status_id JOIN subpoena_reason ON subpoena_reason.id = subpoena.reason_id where subpoena_reason.type='3' and sub_stat_hist.code ='5' and subpoena.department_id = 'de265e31-4b82-4dc8-9bf6-af990d6d649e') select t1.subpoenas_sent, t2.appeared_on_subpoenas, t3.not_appeared_on_subpoenas, 1 as org, '6b56f46a-16e7-4c0f-83a8-05fbddf2e6cb' as recruitment_id, 'Весна' as spring_autumn, 0 as new_recruits, 0 as postponement_have_right, 0 as postponement_granted, 0 as appeared_on_subpoenas_percent, 0 as not_appeared_on_subpoenas_percent, 0 as postponement_have_right_percent, 0 as postponement_granted_percent from t1 full outer join t2 on 1 = 1 full outer join t3 on 1 = 1 0 N N N 144 2144 Y Table input (subpoena) сахалин/осень TableInput Y 1 none postgres.subpoena with t1 as (select count(distinct subpoena.id) as subpoenas_sent FROM subpoena JOIN subpoena_history ON subpoena_history.subpoena_id = subpoena.id JOIN subpoena_status AS sub_status ON sub_status.id = subpoena.status_id JOIN subpoena_status AS sub_stat_hist ON sub_stat_hist.id = subpoena_history.status_id JOIN subpoena_reason ON subpoena_reason.id = subpoena.reason_id where subpoena_reason.type='3' and sub_stat_hist.code ='3' and subpoena.department_id = 'de265e31-4b82-4dc8-9bf6-af990d6d649e'), t2 as (select count(distinct subpoena.id) as appeared_on_subpoenas FROM subpoena JOIN subpoena_history ON subpoena_history.subpoena_id = subpoena.id JOIN subpoena_status AS sub_status ON sub_status.id = subpoena.status_id JOIN subpoena_status AS sub_stat_hist ON sub_stat_hist.id = subpoena_history.status_id JOIN subpoena_reason ON subpoena_reason.id = subpoena.reason_id where subpoena_reason.type='3' and sub_stat_hist.code in ('4.1','4.2') and subpoena.department_id = 'de265e31-4b82-4dc8-9bf6-af990d6d649e'), t3 as (select count(distinct subpoena.id) as not_appeared_on_subpoenas FROM subpoena JOIN subpoena_history ON subpoena_history.subpoena_id = subpoena.id JOIN subpoena_status AS sub_status ON sub_status.id = subpoena.status_id JOIN subpoena_status AS sub_stat_hist ON sub_stat_hist.id = subpoena_history.status_id JOIN subpoena_reason ON subpoena_reason.id = subpoena.reason_id where subpoena_reason.type='3' and sub_stat_hist.code ='5' and subpoena.department_id = 'de265e31-4b82-4dc8-9bf6-af990d6d649e') select t1.subpoenas_sent, t2.appeared_on_subpoenas, t3.not_appeared_on_subpoenas, 1 as org, '6b56f46a-16e7-4c0f-83a8-05fbddf2e6cb' as recruitment_id, 'Осень' as spring_autumn, 0 as new_recruits, 0 as postponement_have_right, 0 as postponement_granted, 0 as appeared_on_subpoenas_percent, 0 as not_appeared_on_subpoenas_percent, 0 as postponement_have_right_percent, 0 as postponement_granted_percent from t1 full outer join t2 on 1 = 1 full outer join t3 on 1 = 1 0 N N N 144 2080 Y Table input 2 (person_registry) РФ TableInput Y 1 none postgres.person_registry with t1 as (select count(*) waiting_count from public.recruits r where r.system_pgs_status = '1'), t2 as (select count(*) filter(where gender='MALE') male_count from public.recruits r where r.system_pgs_status = '1'), t3 as (select count(*) filter(where gender='FEMALE') female_count from public.recruits r where r.system_pgs_status = '1') select t1.waiting_count, t2.male_count, t3.female_count, '76e40191-adc7-4f03-84a4-0c29c44961a6' as recruitment_id, 0 as mobilization_criterion, 0 as volunteer_criterion, 0 as contract_criterion, 0 as mobilization_criterion_percent, 0 as volunteer_criterion_percent, 0 as contract_criterion_percent from t1 full outer join t2 on 1 = 1 full outer join t3 on 1 = 1 0 N N N 144 192 Y Table input 2 (person_registry) липецк TableInput Y 1 none postgres.person_registry with t1 as (select count(*) waiting_count from public.recruits r where r.system_pgs_status = '1' and target_recruitment_id = '191e81ae-8f1d-495a-aee5-ec1f200ba509'), t2 as (select count(*) filter(where gender='MALE') male_count from public.recruits r where r.system_pgs_status = '1' and target_recruitment_id = '191e81ae-8f1d-495a-aee5-ec1f200ba509'), t3 as (select count(*) filter(where gender='FEMALE') female_count from public.recruits r where r.system_pgs_status = '1' and target_recruitment_id = '191e81ae-8f1d-495a-aee5-ec1f200ba509') select t1.waiting_count, t2.male_count, t3.female_count, '794ed0fa-a25b-4858-b89e-815bb391f2b5' as recruitment_id, 0 as mobilization_criterion, 0 as volunteer_criterion, 0 as contract_criterion, 0 as mobilization_criterion_percent, 0 as volunteer_criterion_percent, 0 as contract_criterion_percent from t1 full outer join t2 on 1 = 1 full outer join t3 on 1 = 1 0 N N N 144 768 Y Table input 2 (person_registry) рязань TableInput Y 1 none postgres.person_registry with t1 as (select count(*) waiting_count from public.recruits r where r.system_pgs_status = '1' and target_recruitment_id = '1284964b-3bf8-41b5-adb5-c6d1ec1bc13c'), t2 as (select count(*) filter(where gender='MALE') male_count from public.recruits r where r.system_pgs_status = '1' and target_recruitment_id = '1284964b-3bf8-41b5-adb5-c6d1ec1bc13c'), t3 as (select count(*) filter(where gender='FEMALE') female_count from public.recruits r where r.system_pgs_status = '1' and target_recruitment_id = '1284964b-3bf8-41b5-adb5-c6d1ec1bc13c') select t1.waiting_count, t2.male_count, t3.female_count, 'd2e839ef-933c-48df-9a3a-ac1c00663154' as recruitment_id, 0 as mobilization_criterion, 0 as volunteer_criterion, 0 as contract_criterion, 0 as mobilization_criterion_percent, 0 as volunteer_criterion_percent, 0 as contract_criterion_percent from t1 full outer join t2 on 1 = 1 full outer join t3 on 1 = 1 0 N N N 144 1296 Y Table input 2 (person_registry) сахалин TableInput Y 1 none postgres.person_registry with t1 as (select count(*) waiting_count from public.recruits r where r.system_pgs_status = '1' and target_recruitment_id = 'de265e31-4b82-4dc8-9bf6-af990d6d649e'), t2 as (select count(*) filter(where gender='MALE') male_count from public.recruits r where r.system_pgs_status = '1' and target_recruitment_id = 'de265e31-4b82-4dc8-9bf6-af990d6d649e'), t3 as (select count(*) filter(where gender='FEMALE') female_count from public.recruits r where r.system_pgs_status = '1' and target_recruitment_id = 'de265e31-4b82-4dc8-9bf6-af990d6d649e') select t1.waiting_count, t2.male_count, t3.female_count, '6b56f46a-16e7-4c0f-83a8-05fbddf2e6cb' as recruitment_id, 0 as mobilization_criterion, 0 as volunteer_criterion, 0 as contract_criterion, 0 as mobilization_criterion_percent, 0 as volunteer_criterion_percent, 0 as contract_criterion_percent from t1 full outer join t2 on 1 = 1 full outer join t3 on 1 = 1 0 N N N 144 1888 Y