Name: final_hmda_data

Display Field: parent_name

Type: Table

Description:

Copyright Text:

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• OBJECTID__ (type: esriFieldTypeDouble, alias: OBJECTID *, SQL Type: sqlTypeOther, nullable: true, editable: true)
• activity_year (type: esriFieldTypeDouble, alias: activity_year, SQL Type: sqlTypeOther, nullable: true, editable: true)
• lei (type: esriFieldTypeString, alias: lei, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• derived_msa_md (type: esriFieldTypeDouble, alias: derived_msa-md, SQL Type: sqlTypeOther, nullable: true, editable: true)
• state_code (type: esriFieldTypeString, alias: state_code, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• county_code (type: esriFieldTypeDouble, alias: county_code, SQL Type: sqlTypeOther, nullable: true, editable: true)
• census_tract (type: esriFieldTypeDouble, alias: census_tract, SQL Type: sqlTypeOther, nullable: true, editable: true)
• derived_loan_product_type (type: esriFieldTypeString, alias: derived_loan_product_type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• derived_dwelling_category (type: esriFieldTypeString, alias: derived_dwelling_category, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• derived_ethnicity (type: esriFieldTypeString, alias: derived_ethnicity, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• derived_race (type: esriFieldTypeString, alias: derived_race, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• derived_sex (type: esriFieldTypeString, alias: derived_sex, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• action_taken (type: esriFieldTypeDouble, alias: action_taken, SQL Type: sqlTypeOther, nullable: true, editable: true)
• action_taken_recode (type: esriFieldTypeString, alias: action_taken_recode, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• loan_type (type: esriFieldTypeDouble, alias: loan_type, SQL Type: sqlTypeOther, nullable: true, editable: true)
• loan_type_recode (type: esriFieldTypeString, alias: loan_type_recode, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• loan_purpose (type: esriFieldTypeDouble, alias: loan_purpose, SQL Type: sqlTypeOther, nullable: true, editable: true)
• loan_purpose_recode (type: esriFieldTypeString, alias: loan_purpose_recode, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• loan_amount (type: esriFieldTypeDouble, alias: loan_amount, SQL Type: sqlTypeOther, nullable: true, editable: true)
• interest_rate (type: esriFieldTypeString, alias: interest_rate, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• hoepa_status (type: esriFieldTypeDouble, alias: hoepa_status, SQL Type: sqlTypeOther, nullable: true, editable: true)
• total_loan_costs (type: esriFieldTypeString, alias: total_loan_costs, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• total_points_and_fees (type: esriFieldTypeString, alias: total_points_and_fees, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• origition_charges (type: esriFieldTypeString, alias: origition_charges, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• discount_points (type: esriFieldTypeString, alias: discount_points, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• lender_credits (type: esriFieldTypeString, alias: lender_credits, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Total_Charges_to_Borrower (type: esriFieldTypeString, alias: Total_Charges_to_Borrower, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• loan_term (type: esriFieldTypeString, alias: loan_term, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• property_value (type: esriFieldTypeString, alias: property_value, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• income (type: esriFieldTypeString, alias: income, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• applicant_sex (type: esriFieldTypeDouble, alias: applicant_sex, SQL Type: sqlTypeOther, nullable: true, editable: true)
• denial_reason_1 (type: esriFieldTypeDouble, alias: denial_reason-1, SQL Type: sqlTypeOther, nullable: true, editable: true)
• denial_reason_recode (type: esriFieldTypeString, alias: denial_reason_recode, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• tract_population (type: esriFieldTypeDouble, alias: tract_population, SQL Type: sqlTypeOther, nullable: true, editable: true)
• tract_minority_population_perce (type: esriFieldTypeDouble, alias: tract_minority_population_percent, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ffiec_msa_md_median_family_inco (type: esriFieldTypeDouble, alias: ffiec_msa_md_median_family_income, SQL Type: sqlTypeOther, nullable: true, editable: true)
• tract_to_msa_income_percentage (type: esriFieldTypeDouble, alias: tract_to_msa_income_percentage, SQL Type: sqlTypeOther, nullable: true, editable: true)
• tract_one_to_four_family_homes (type: esriFieldTypeDouble, alias: tract_one_to_four_family_homes, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Race_and_Ethnicity (type: esriFieldTypeString, alias: Race_and_Ethnicity, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Minority_Applicant (type: esriFieldTypeString, alias: Minority_Applicant, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Majority_Minority_Census_Tract (type: esriFieldTypeString, alias: Majority_Minority_Census_Tract, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Tract_Income_Level (type: esriFieldTypeString, alias: Tract_Income_Level, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• LMI_Tract (type: esriFieldTypeString, alias: LMI_Tract, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Borrower_Income_Level (type: esriFieldTypeString, alias: Borrower_Income_Level, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• LMI_Borrower (type: esriFieldTypeString, alias: LMI_Borrower, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• geoid_text__ (type: esriFieldTypeDouble, alias: geoid_text *, SQL Type: sqlTypeOther, nullable: true, editable: true)
• other_lender_code (type: esriFieldTypeDouble, alias: other_lender_code, SQL Type: sqlTypeOther, nullable: true, editable: true)
• other_lender_code_recode (type: esriFieldTypeString, alias: other_lender_code_recode, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• InstitutionType (type: esriFieldTypeString, alias: InstitutionType, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• parent_name (type: esriFieldTypeString, alias: parent_name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• parent_rssd (type: esriFieldTypeDouble, alias: parent_rssd, SQL Type: sqlTypeOther, nullable: true, editable: true)
• respondent_name (type: esriFieldTypeString, alias: respondent_name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• respondent_rssd (type: esriFieldTypeDouble, alias: respondent_rssd, SQL Type: sqlTypeOther, nullable: true, editable: true)
• tax_id (type: esriFieldTypeString, alias: tax_id, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• topholder_name (type: esriFieldTypeString, alias: topholder_name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• topholder_rssd (type: esriFieldTypeDouble, alias: topholder_rssd, SQL Type: sqlTypeOther, nullable: true, editable: true)
• income_reformat (type: esriFieldTypeString, alias: income_reformat, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• census_reformat (type: esriFieldTypeString, alias: census_reformat, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• TEXTGEOID (type: esriFieldTypeString, alias: TEXTGEOID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• JOINEDID (type: esriFieldTypeString, alias: JOINEDID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• IncomeLevelRecode (type: esriFieldTypeString, alias: IncomeLevelRecode, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• LMITractCalculation (type: esriFieldTypeString, alias: LMITractCalculation, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• MMCT (type: esriFieldTypeString, alias: MMCT, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Institution_Assets (type: esriFieldTypeDouble, alias: Institution_Assets, SQL Type: sqlTypeOther, nullable: true, editable: true)
• hispanic_applicant (type: esriFieldTypeString, alias: Hispanic Applicant, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• total_borrower_costs (type: esriFieldTypeInteger, alias: Total Borrower Costs, SQL Type: sqlTypeOther, nullable: true, editable: true)
• property_value_reformat (type: esriFieldTypeInteger, alias: Property Value, SQL Type: sqlTypeOther, nullable: true, editable: true)
• interest_rate_reformat (type: esriFieldTypeDouble, alias: Interest Rate, SQL Type: sqlTypeOther, nullable: true, editable: true)
• InstitutionSize (type: esriFieldTypeString, alias: Institution Size, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• county (type: esriFieldTypeString, alias: County, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)

Templates:

Name: final_hmda_data
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 9/23/2022 5:56:29 PM

Schema Last Edit Date: 9/23/2022 5:56:29 PM

Data Last Edit Date: 9/23/2022 5:56:29 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat