text: --
  -- PostgreSQL database dump
  --
  
  -- Dumped from database version 10.6
  -- Dumped by pg_dump version 10.5
  
  -- Started on 2019-06-18 12:27:10 EDT
  
  SET statement_timeout = 0;
  SET lock_timeout = 0;
  SET idle_in_transaction_session_timeout = 0;
  SET client_encoding = 'UTF8';
  SET standard_conforming_strings = on;
  SELECT pg_catalog.set_config('search_path', '', false);
  SET check_function_bodies = false;
  SET client_min_messages = warning;
  SET row_security = off;
  
  SET default_tablespace = '';
  
  SET default_with_oids = false;
  
  --
  -- TOC entry 281 (class 1259 OID 20735)
  -- Name: qa_lar_table_2018; Type: TABLE; Schema: hmda_user; Owner: hmda_user
  --
  
  CREATE TABLE hmda_user.qa_lar_table_2018 (
      id integer NOT NULL,
      lei character varying COLLATE pg_catalog."default" NOT NULL,
      uli character varying COLLATE pg_catalog."default",
      application_date character varying COLLATE pg_catalog."default",
      loan_type integer,
      loan_purpose integer,
      preapproval integer,
      construction_method character varying COLLATE pg_catalog."default",
      occupancy_type integer,
      loan_amount numeric,
      action_taken_type integer,
      action_taken_date integer,
      street character varying COLLATE pg_catalog."default",
      city character varying COLLATE pg_catalog."default",
      state character varying COLLATE pg_catalog."default",
      zip character varying COLLATE pg_catalog."default",
      county character varying COLLATE pg_catalog."default",
      tract character varying COLLATE pg_catalog."default",
      ethnicity_applicant_1 character varying COLLATE pg_catalog."default",
      ethnicity_applicant_2 character varying COLLATE pg_catalog."default",
      ethnicity_applicant_3 character varying COLLATE pg_catalog."default",
      ethnicity_applicant_4 character varying COLLATE pg_catalog."default",
      ethnicity_applicant_5 character varying COLLATE pg_catalog."default",
      other_hispanic_applicant character varying COLLATE pg_catalog."default",
      ethnicity_co_applicant_1 character varying COLLATE pg_catalog."default",
      ethnicity_co_applicant_2 character varying COLLATE pg_catalog."default",
      ethnicity_co_applicant_3 character varying COLLATE pg_catalog."default",
      ethnicity_co_applicant_4 character varying COLLATE pg_catalog."default",
      ethnicity_co_applicant_5 character varying COLLATE pg_catalog."default",
      other_hispanic_co_applicant character varying COLLATE pg_catalog."default",
      ethnicity_observed_applicant integer,
      ethnicity_observed_co_applicant integer,
      race_applicant_1 character varying COLLATE pg_catalog."default",
      race_applicant_2 character varying COLLATE pg_catalog."default",
      race_applicant_3 character varying COLLATE pg_catalog."default",
      race_applicant_4 character varying COLLATE pg_catalog."default",
      race_applicant_5 character varying COLLATE pg_catalog."default",
      other_native_race_applicant character varying COLLATE pg_catalog."default",
      other_asian_race_applicant character varying COLLATE pg_catalog."default",
      other_pacific_race_applicant character varying COLLATE pg_catalog."default",
      race_co_applicant_1 character varying COLLATE pg_catalog."default",
      race_co_applicant_2 character varying COLLATE pg_catalog."default",
      race_co_applicant_3 character varying COLLATE pg_catalog."default",
      race_co_applicant_4 character varying COLLATE pg_catalog."default",
      race_co_applicant_5 character varying COLLATE pg_catalog."default",
      other_native_race_co_applicant character varying COLLATE pg_catalog."default",
      other_asian_race_co_applicant character varying COLLATE pg_catalog."default",
      other_pacific_race_co_applicant character varying COLLATE pg_catalog."default",
      race_observed_applicant integer,
      race_observed_co_applicant integer,
      sex_applicant integer,
      sex_co_applicant integer,
      observed_sex_applicant integer,
      observed_sex_co_applicant integer,
      age_applicant integer,
      age_co_applicant integer,
      income character varying COLLATE pg_catalog."default",
      purchaser_type integer,
      rate_spread character varying COLLATE pg_catalog."default",
      hoepa_status integer,
      lien_status integer,
      credit_score_applicant integer,
      credit_score_co_applicant integer,
      credit_score_type_applicant integer,
      credit_score_model_applicant character varying COLLATE pg_catalog."default",
      credit_score_type_co_applicant integer,
      credit_score_model_co_applicant character varying COLLATE pg_catalog."default",
      denial_reason1 character varying COLLATE pg_catalog."default",
      denial_reason2 character varying COLLATE pg_catalog."default",
      denial_reason3 character varying COLLATE pg_catalog."default",
      denial_reason4 character varying COLLATE pg_catalog."default",
      other_denial_reason character varying COLLATE pg_catalog."default",
      total_loan_costs character varying COLLATE pg_catalog."default",
      total_points character varying COLLATE pg_catalog."default",
      origination_charges character varying COLLATE pg_catalog."default",
      discount_points character varying COLLATE pg_catalog."default",
      lender_credits character varying COLLATE pg_catalog."default",
      interest_rate character varying COLLATE pg_catalog."default",
      payment_penalty character varying COLLATE pg_catalog."default",
      debt_to_incode character varying COLLATE pg_catalog."default",
      loan_value_ratio character varying COLLATE pg_catalog."default",
      loan_term character varying COLLATE pg_catalog."default",
      rate_spread_intro character varying COLLATE pg_catalog."default",
      baloon_payment integer,
      insert_only_payment integer,
      amortization integer,
      other_amortization integer,
      property_value character varying COLLATE pg_catalog."default",
      home_security_policy integer,
      lan_property_interest integer,
      total_uits integer,
      mf_affordable character varying COLLATE pg_catalog."default",
      application_submission integer,
      payable character varying COLLATE pg_catalog."default",
      nmls character varying COLLATE pg_catalog."default",
      aus1 character varying COLLATE pg_catalog."default",
      aus2 character varying COLLATE pg_catalog."default",
      aus3 character varying COLLATE pg_catalog."default",
      aus4 character varying COLLATE pg_catalog."default",
      aus5 character varying COLLATE pg_catalog."default",
      other_aus character varying COLLATE pg_catalog."default",
      aus1_result integer,
      aus2_result character varying COLLATE pg_catalog."default",
      aus3_result character varying COLLATE pg_catalog."default",
      aus4_result character varying COLLATE pg_catalog."default",
      aus5_result character varying COLLATE pg_catalog."default",
      other_aus_result character varying COLLATE pg_catalog."default",
      reverse_mortgage integer,
      line_of_credits integer,
      business_or_commercial integer,
      created_at timestamp without time zone DEFAULT now(),
      checksum character varying COLLATE pg_catalog."default",
      file_name character varying,
      time_stamp bigint
  );
  
  
  ALTER TABLE hmda_user.qa_lar_table_2018 OWNER TO hmda_user;
  
  -- Completed on 2019-06-18 12:27:11 EDT
  
  --
  -- PostgreSQL database dump complete
  --