Загрузка данных
back_office incoming_order 4 date date
back_office incoming_order 24 arrival_date date
back_office incoming_order 25 extracted_date date
back_office operation 6 operation_date date
back_office operation 7 effective_date date
back_office operation 13 period_date date
back_office operation 71 date_order_number date
ourpension agent 5 contract_close_date date
ourpension application_amlcft_individual 5 start_relation_date date
ourpension application_amlcft_individual 6 end_relation_date date
ourpension application_amlcft_individual 11 relatives_have_pdl_state boolean
ourpension application_amlcft_individual 13 relatives_have_ipdl_state boolean
ourpension application_amlcft_individual 34 close_relatives_information character varying
ourpension application_amlcft_individual 64 relatives_have_ipdl_state_info character varying
ourpension application_amlcft_individual 74 relationships_duration integer
ourpension application_amlcft_individual 79 relationships_goals integer
ourpension application_death_info 1 id integer
ourpension application_death_info 2 number character varying
ourpension application_death_info 3 date date
ourpension application_death_info 4 death_date date
ourpension application_death_info 5 death_info_date date
ourpension application_death_info 6 death_certificate_date date
ourpension application_death_info 7 death_certificate_number text
ourpension application_death_info 8 death_info_certificate_code integer
ourpension application_death_info 9 comment text
ourpension application_death_info 10 accepted timestamp without time zone
ourpension application_death_info 11 rejected timestamp without time zone
ourpension application_death_info 12 canceled timestamp without time zone
ourpension application_death_info 13 version timestamp without time zone
ourpension application_death_info 14 agent_id integer
ourpension application_death_info 15 individual_id integer
ourpension application_death_info 16 individual_document_id integer
ourpension application_death_info 17 death_certificate_place character varying
ourpension application_death_info 18 person_death_registration_id character varying
ourpension application_death_info 19 person_id character varying
ourpension application_death_info 20 death_info_received_type_code integer
ourpension application_death_info 21 ops_transfer_register_id integer
ourpension application_death_info 22 source_document_info jsonb
ourpension application_death_info 23 is_svo boolean
ourpension application_death_info 24 previous_death_info_id integer
ourpension application_death_info 25 is_not_death_date boolean
ourpension application_death_info 26 death_date_month integer
ourpension application_death_info 27 death_date_year integer
ourpension assignee_notification 5 assignee_known_relatives_id integer
ourpension contract 18 close_date date
ourpension contract 19 contract_close_reason_id integer
ourpension contract 40 family_member boolean
ourpension contract 64 fm_relation_type character
ourpension full_positions 4 dateclose date
ourpension individual 18 draft_close_date timestamp without time zone
ourpension inherited_payment 42 assignee_relation_type_code character varying
ourpension ops_assignee_payment 21 assignee_relation_type_code character varying
ourpension partner 8 contract_close_date date
ourpension pension_account_changes 6 close_reason_id integer
ourpension pension_scheme 5 close_date date
ourpension positions 7 list_close_1c ARRAY
ourpension positions_history 7 list_close_1c ARRAY
ourpension related_entity 5 related_type_id integer
ourpension sales_office 4 close_date date
ourpension sharer 16 close_date date
ourpension sharer 17 closed timestamp without time zone
ourpension sharer 18 closed_agent_id integer
ourpension sharer 19 closed_reason_id integer
ourpension sharer_closure_regain 3 original_close_date date
ourpension sharer_closure_regain 4 close_date date
ourpension sharer_closure_regain 5 close_reason_code character varying
ourpension sharer_closure_regain 7 close_doc_date date
ourpension sharer_closure_regain 9 close_doc_number character varying
ourpension sharer_closure_regain 11 close_agent_id integer
ourpension sharer_closure_regain 13 close_version timestamp without time zone