Name: Sheet1$

Display Field: MORTGAGOR_FULL_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:

• LOAN_NUMBER (type: esriFieldTypeDouble, alias: LOAN NUMBER, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MORTGAGOR_FULL_NAME (type: esriFieldTypeString, alias: MORTGAGOR_FULL_NAME, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• LOAN_TYPE_DESC (type: esriFieldTypeString, alias: LOAN_TYPE_DESC, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• TRACKING_STATUS_DESC (type: esriFieldTypeString, alias: TRACKING_STATUS_DESC, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ORIGINATOR_DESC (type: esriFieldTypeString, alias: ORIGINATOR_DESC, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• UNDERWRITER_DESC (type: esriFieldTypeString, alias: UNDERWRITER_DESC, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• FIRST_LIEN_INTEREST_RATE (type: esriFieldTypeDouble, alias: FIRST_LIEN_INTEREST_RATE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• NEW_EXISTING_DESC (type: esriFieldTypeString, alias: NEW_EXISTING_DESC, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• FIRST_LIEN_AMOUNT (type: esriFieldTypeDouble, alias: FIRST_LIEN_AMOUNT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PURCHASE_PRICE (type: esriFieldTypeDouble, alias: PURCHASE_PRICE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• COUNTY_CODE_DESC (type: esriFieldTypeString, alias: COUNTY_CODE_DESC, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CENSUS_TRACT (type: esriFieldTypeDouble, alias: CENSUS_TRACT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PRODUCT_GROUP_DESC (type: esriFieldTypeString, alias: PRODUCT_GROUP_DESC, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• PRODUCT_TYPE_DESC (type: esriFieldTypeString, alias: PRODUCT_TYPE_DESC, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• MEDIAN_CREDIT_SCORE (type: esriFieldTypeDouble, alias: MEDIAN_CREDIT_SCORE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CURRENT_LOAN_TO_VALUE (type: esriFieldTypeDouble, alias: CURRENT_LOAN_TO_VALUE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HOUSEHOLD_INCOME (type: esriFieldTypeDouble, alias: HOUSEHOLD_INCOME, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SECOND_MORTGAGE_AMOUNT (type: esriFieldTypeDouble, alias: SECOND_MORTGAGE_AMOUNT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TITLE_NAME_2 (type: esriFieldTypeString, alias: TITLE_NAME_2, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• TITLE_NAME_1 (type: esriFieldTypeString, alias: TITLE_NAME_1, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• TITLE_OFFICER (type: esriFieldTypeString, alias: TITLE_OFFICER, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• TITLE_ADDRESS_1 (type: esriFieldTypeString, alias: TITLE_ADDRESS_1, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• TITLE_ADDRESS_2 (type: esriFieldTypeString, alias: TITLE_ADDRESS_2, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• TITLE_STATE (type: esriFieldTypeString, alias: TITLE_STATE, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• TITLE_CITY (type: esriFieldTypeString, alias: TITLE_CITY, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• TITLE_ZIP (type: esriFieldTypeDouble, alias: TITLE_ZIP, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TRACKING_STATUS_DESC1 (type: esriFieldTypeString, alias: TRACKING_STATUS_DESC1, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• RESERVATION_DATE (type: esriFieldTypeDate, alias: RESERVATION_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• RESERVATION_EXPIRATION_DATE (type: esriFieldTypeDate, alias: RESERVATION_EXPIRATION_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• LAST_EXTENSION_TAKEN_DATE (type: esriFieldTypeDate, alias: LAST_EXTENSION_TAKEN_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• NON_COMPLIANCE_DATE (type: esriFieldTypeString, alias: NON_COMPLIANCE_DATE, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• EXPECTED_CLOSING_DATE (type: esriFieldTypeDate, alias: EXPECTED_CLOSING_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• ACTIVE_DATE (type: esriFieldTypeDate, alias: ACTIVE_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• DATE_UNDERWRITTEN (type: esriFieldTypeString, alias: DATE_UNDERWRITTEN, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• IN_UNDERWRITING_DATE (type: esriFieldTypeDate, alias: IN_UNDERWRITING_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• PENDING_CONDITIONS_DATE (type: esriFieldTypeDate, alias: PENDING_CONDITIONS_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• SUSPENSE_DATE (type: esriFieldTypeDate, alias: SUSPENSE_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• RESUBMISSION_DATE (type: esriFieldTypeString, alias: RESUBMISSION_DATE, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• MASTER_SERVICER_RECEIVED_DATE (type: esriFieldTypeDate, alias: MASTER_SERVICER_RECEIVED_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• SECURITIZED_DATE (type: esriFieldTypeDate, alias: SECURITIZED_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• CANCELLED_DATE (type: esriFieldTypeString, alias: CANCELLED_DATE, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• LOAN_OFFICER_NAME (type: esriFieldTypeString, alias: LOAN_OFFICER_NAME, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• LISTING_REAL_ESTATE_AGENT (type: esriFieldTypeString, alias: LISTING_REAL_ESTATE_AGENT, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SELLING_REAL_ESTATE_AGENT (type: esriFieldTypeString, alias: SELLING_REAL_ESTATE_AGENT, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• LOAN_OFFICER_NAME1 (type: esriFieldTypeString, alias: LOAN_OFFICER_NAME1, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• PROPERTY_STREET_NUM (type: esriFieldTypeDouble, alias: PROPERTY_STREET_NUM, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PROPERTY_STREET_NAME (type: esriFieldTypeString, alias: PROPERTY_STREET_NAME, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Property_Address (type: esriFieldTypeString, alias: Property Address, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• PROPERTY_CITY (type: esriFieldTypeString, alias: PROPERTY_CITY, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• PROPERTY_ZIP (type: esriFieldTypeDouble, alias: PROPERTY_ZIP, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ALLOCATION_NO (type: esriFieldTypeDouble, alias: ALLOCATION_NO, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ALLOCATION_DESC (type: esriFieldTypeString, alias: ALLOCATION_DESC, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ALLOCATED_FIRST (type: esriFieldTypeDouble, alias: ALLOCATED_FIRST, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ALLOCATED_AMOUNT (type: esriFieldTypeDouble, alias: ALLOCATED_AMOUNT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ALLOCATED_AMOUNT_2ND (type: esriFieldTypeDouble, alias: ALLOCATED_AMOUNT_2ND, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ObjectID (type: esriFieldTypeOID, alias: ObjectID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)

Templates:

Name: Sheet1$
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 10/16/2024 3:34:43 PM

Schema Last Edit Date: 10/16/2024 3:34:43 PM

Data Last Edit Date: 10/16/2024 3:34:43 PM

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