Advertisement
Guest User

Untitled

a guest
Apr 26th, 2017
81
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1.     insert into mc_case_becku_s ("id", "uid", "mark", "note", "aud_who", "aud_when", "state_id", "clinic_id", "open_date", "open_time", "result_id", "aud_source", "close_date", "funding_id",
  2.         "patient_id", "create_date", "referral_id", "case_type_id", "death_reason", "hsp_canal_id", "init_goal_id", "init_type_id", "repeat_count", "soc_group_id", "time_gone_id",
  3.         "care_level_id", "notes_to_work", "who_delivered", "aud_who_create", "care_gender_id", "injury_type_id", "plan_hosp_date", "aud_when_create", "care_full_years", "care_regimen_id",
  4.         "closing_step_id", "main_diagnos_id", "repeat_count_id", "is_need_sicklist", "main_contract_id", "sicklist_open_dt", "admission_type_id", "aud_source_create", "payment_method_id",
  5.         "severity_level_id", "sicklist_close_dt", "admission_state_id", "narcotic_substance", "plan_case_duration", "who_delivered_code", "admission_reason_id", "complexity_level_id",
  6.         "deviation_reason_id", "drunkenness_type_id", "emergency_team_code", "transporting_type_id", "where_from_delivered", "referral_resulting_id", "care_providing_form_id",
  7.         "provision_condition_id", "death_reason_diagnosis_id", "who_delivered_team_number", "prehospital_stage_defect_id", "rankin_scale_on_disposal_id")
  8.     select
  9.         cast((delta->'id') as INTEGER),
  10.         cast((delta->'uid') as varchar(255)),
  11.         cast((delta->'mark') as INTEGER),
  12.         cast((delta->'note') as varchar(255)),
  13.         cast((delta->'aud_who') as varchar),
  14.         cast((delta->'aud_when') as timestamp(6)),
  15.         cast((delta->'state_id') as INTEGER),
  16.         cast((delta->'clinic_id') as INTEGER),
  17.         cast((delta->'open_date') as date),
  18.         cast((delta->'open_time') as time(6)),
  19.         cast((delta->'result_id') as INTEGER),
  20.         cast((delta->'aud_source') as varchar),
  21.         cast((delta->'close_date') as date),
  22.         cast((delta->'funding_id') as INTEGER),
  23.         cast((delta->'patient_id') as INTEGER),
  24.         cast((delta->'create_date') as date),
  25.         cast((delta->'referral_id') as INTEGER),
  26.         cast((delta->'case_type_id') as INTEGER),
  27.         cast((delta->'death_reason') as varchar(255)),
  28.         cast((delta->'hsp_canal_id') as INTEGER),
  29.         cast((delta->'init_goal_id') as INTEGER),
  30.         cast((delta->'init_type_id') as INTEGER),
  31.         cast((delta->'repeat_count') as INTEGER),
  32.         cast((delta->'soc_group_id') as INTEGER),
  33.         cast((delta->'time_gone_id') as INTEGER),
  34.         cast((delta->'care_level_id') as INTEGER),
  35.         cast((delta->'notes_to_work') as varchar(500)),
  36.         cast((delta->'who_delivered') as varchar(255)),
  37.         cast((delta->'aud_who_create') as varchar),
  38.         cast((delta->'care_gender_id') as INTEGER),
  39.         cast((delta->'injury_type_id') as INTEGER),
  40.         cast((delta->'plan_hosp_date') as date),
  41.         cast((delta->'aud_when_create') as timestamp(6)),
  42.         cast((delta->'care_full_years') as INTEGER),
  43.         cast((delta->'care_regimen_id') as INTEGER),
  44.         cast((delta->'closing_step_id') as INTEGER),
  45.         cast((delta->'main_diagnos_id') as INTEGER),
  46.         cast((delta->'repeat_count_id') as INTEGER),
  47.         cast((delta->'is_need_sicklist') as bool),
  48.         cast((delta->'main_contract_id') as INTEGER),
  49.         cast((delta->'sicklist_open_dt') as date),
  50.         cast((delta->'admission_type_id') as INTEGER),
  51.         cast((delta->'aud_source_create') as varchar),
  52.         cast((delta->'payment_method_id') as INTEGER),
  53.         cast((delta->'severity_level_id') as INTEGER),
  54.         cast((delta->'sicklist_close_dt') as date),
  55.         cast((delta->'admission_state_id') as INTEGER),
  56.         cast((delta->'narcotic_substance') as text),
  57.         cast((delta->'plan_case_duration') as INTEGER),
  58.         cast((delta->'who_delivered_code') as varchar(255)),
  59.         cast((delta->'admission_reason_id') as INTEGER),
  60.         cast((delta->'complexity_level_id') as INTEGER),
  61.         cast((delta->'deviation_reason_id') as INTEGER),
  62.         cast((delta->'drunkenness_type_id') as INTEGER),
  63.         cast((delta->'emergency_team_code') as varchar(255)),
  64.         cast((delta->'transporting_type_id') as INTEGER),
  65.         cast((delta->'where_from_delivered') as text),
  66.         cast((delta->'referral_resulting_id') as INTEGER),
  67.         cast((delta->'care_providing_form_id') as INTEGER),
  68.         cast((delta->'provision_condition_id') as INTEGER),
  69.         cast((delta->'death_reason_diagnosis_id') as INTEGER),
  70.         cast((delta->'who_delivered_team_number') as varchar(255)),
  71.         cast((delta->'prehospital_stage_defect_id') as INTEGER),
  72.         cast((delta->'rankin_scale_on_disposal_id') as INTEGER)
  73. from audit.public$mc_case where id in(9676160, 10311701,9751802);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement