DROP TABLE public.hmis_patient_nursing_extend_insurance_askes;

CREATE TABLE public.hmis_patient_nursing_extend_insurance_askes
(
  ouname character varying(50),
  oucode character varying(50),
  cluster_id character varying(50),
  server_session_id character varying(50),
  client_session_id character varying(50),
  partition_name character varying(80),
  id character varying(50) NOT NULL,
  patient_nursing_partition_name character varying(80),
  patient_nursing_id character varying(50),
  register_waranty_letter_number character varying(250),
  register_waranty_letter_date date,
  register_service_start_date date,
  register_service_end_date date,
  register_membership_source character varying(32),
  register_membership_number character varying(250),
  register_membership_printing_date date,
  register_identity_number character varying(250),
  register_full_name character varying(250),
  register_gender character varying(32),
  register_date_of_birth date,
  register_principal_insurance_name character varying(250),
  register_principal_insurance_code character varying(32),
  register_primary_provider_name character varying(250),
  register_primary_provider_code character varying(32),
  register_contract_service_name character varying(250),
  register_contract_service_code character varying(32),
  register_service_level_description character varying(250),
  register_service_level_code character varying(32),
  register_referal_number character varying(250),
  register_referal_date date,
  register_referal_medical_service_name character varying(250),
  register_referal_medical_service_code character varying(32),
  register_referal_diagnose_description character varying(250),
  register_referal_diagnose_code character varying(50),
  register_referal_to_department_name character varying(250),
  register_referal_to_department_bpjs_code character varying(50),
  register_dokter_name character varying(250),
  register_dokter_bpjs_code character varying(50),
  register_nursing_type smallint,
  register_notes character varying(250),
  register_cob_description character varying(250),
  register_cob_code character varying(80),
  register_lokasi_kll character varying(250),
  register_penanggung_kll character varying(250),
  register_deskripsi_diagnosa_masuk character varying(250),
  register_kode_diagnosa_masuk character varying(80),
  register_json character varying(5120),
  height numeric,
  weight numeric,
  register_daily_diagnose_description character varying(250),
  register_daily_diagnose_code character varying(50),
  register_min_casemix_code character varying(50),
  register_estimate_min_claim numeric,
  register_max_casemix_code character varying(50),
  register_estimate_max_claim numeric,
  register_check_out character varying(80),
  register_claimable character varying(80),
  admission_diagnose_description_1 character varying(250),
  admission_diagnose_code_1 character varying(50),
  admission_diagnose_description_2 character varying(250),
  admission_diagnose_code_2 character varying(50),
  admission_diagnose_description_3 character varying(250),
  admission_diagnose_code_3 character varying(50),
  admission_diagnose_description_4 character varying(250),
  admission_diagnose_code_4 character varying(50),
  admission_diagnose_description_5 character varying(250),
  admission_diagnose_code_5 character varying(50),
  planning_treatment_description_1 character varying(250),
  planning_treatment_code_1 character varying(50),
  planning_treatment_description_2 character varying(250),
  planning_treatment_code_2 character varying(50),
  planning_treatment_description_3 character varying(250),
  planning_treatment_code_3 character varying(50),
  planning_treatment_description_4 character varying(250),
  planning_treatment_code_4 character varying(50),
  planning_treatment_description_5 character varying(250),
  planning_treatment_code_5 character varying(50),
  admission_inacbg_description character varying(250),
  admission_inacbg_code character varying(50),
  billing_estimate numeric,
  working_diagnose_description_1 character varying(250),
  working_diagnose_code_1 character varying(50),
  working_diagnose_description_2 character varying(250),
  working_diagnose_code_2 character varying(50),
  working_diagnose_description_3 character varying(250),
  working_diagnose_code_3 character varying(50),
  working_diagnose_description_4 character varying(250),
  working_diagnose_code_4 character varying(50),
  working_diagnose_description_5 character varying(250),
  working_diagnose_code_5 character varying(50),
  working_treatment_description_1 character varying(250),
  working_treatment_code_1 character varying(50),
  working_treatment_description_2 character varying(250),
  working_treatment_code_2 character varying(50),
  working_treatment_description_3 character varying(250),
  working_treatment_code_3 character varying(50),
  working_treatment_description_4 character varying(250),
  working_treatment_code_4 character varying(50),
  working_treatment_description_5 character varying(250),
  working_treatment_code_5 character varying(50),
  working_inacbg_description character varying(250),
  working_inacbg_code character varying(50),
  working_billing_estimate numeric,
  working_denda_estimate numeric,
  billing_hospital_g01 numeric,
  billing_hospital_g02 numeric,
  billing_hospital_g03 numeric,
  billing_hospital_g04 numeric,
  billing_hospital_g05 numeric,
  billing_hospital_g06 numeric,
  billing_hospital_g07 numeric,
  billing_hospital_g08 numeric,
  billing_hospital_g09 numeric,
  billing_hospital_g10 numeric,
  billing_hospital_g11 numeric,
  billing_hospital_g12 numeric,
  billing_hospital_g13 numeric,
  billing_hospital_g14 numeric,
  billing_hospital_g15 numeric,
  billing_hospital_g16 numeric,
  billing_hospital_g17 numeric,
  billing_hospital_g18 numeric,
  billing_hospital_g19 numeric,
  billing_hospital_g20 numeric,
  billing_hospital_total numeric,
  claim_diagnose_description_1 character varying(250),
  claim_diagnose_code_1 character varying(50),
  claim_diagnose_description_2 character varying(250),
  claim_diagnose_code_2 character varying(50),
  claim_diagnose_description_3 character varying(250),
  claim_diagnose_code_3 character varying(50),
  claim_diagnose_description_4 character varying(250),
  claim_diagnose_code_4 character varying(50),
  claim_diagnose_description_5 character varying(250),
  claim_diagnose_code_5 character varying(50),
  claim_treatment_description_1 character varying(250),
  claim_treatment_code_1 character varying(50),
  claim_treatment_description_2 character varying(250),
  claim_treatment_code_2 character varying(50),
  claim_treatment_description_3 character varying(250),
  claim_treatment_code_3 character varying(50),
  claim_treatment_description_4 character varying(250),
  claim_treatment_code_4 character varying(50),
  claim_treatment_description_5 character varying(250),
  claim_treatment_code_5 character varying(50),
  claim_inacbg_description character varying(250),
  claim_inacbg_code character varying(50),
  claim_inacbg numeric,
  claim_kelas_1 numeric,
  claim_kelas_2 numeric,
  claim_kelas_3 numeric,
  billing_insurance numeric,
  billing_personal numeric,
  billing_request numeric,
  billing_contract_service_class numeric,
  billing_current_service_class numeric,
  billing_state_description character varying(250),
  billing_state integer,
  billing_paid numeric,
  ts_insert timestamp without time zone DEFAULT now(),
  ts_update timestamp without time zone DEFAULT now(),
  bl_state character varying(1) DEFAULT 'A'::character varying,
  ac_conn character varying(50),
  ac_user character varying(50),
  CONSTRAINT "pkey::hmis_patient_nursing_extend_insurance_askes" PRIMARY KEY (id)
)
WITH (
  OIDS=FALSE
);
ALTER TABLE public.hmis_patient_nursing_extend_insurance_askes
  OWNER TO postgres;

