Scribd Logo
Upload

Welcome to Scribd!

  • 28 views

    Data Dictionary932a5c1

    Uploaded by

    tinkudhull
    This document contains descriptions of data columns for multiple data files that contain real estate and deal information. The files include accounts, properties, deals to properties mappings, opportunities, and properties. The columns described provide identifiers, statuses, financial details, locations, sizes, and other attributes for accounts, deals, and properties.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd

    Data Dictionary932a5c1

    Uploaded by

    tinkudhull
    28 views4 pages
    This document contains descriptions of data columns for multiple data files that contain real estate and deal information. The files include accounts, properties, deals to properties mappings, opportunities, and properties. The columns described provide identifiers, statuses, financial details, locations, sizes, and other attributes for accounts, deals, and properties.

    Original Title

    Data_dictionary932a5c1 (1).xlsx

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document contains descriptions of data columns for multiple data files that contain real estate and deal information. The files include accounts, properties, deals to properties mappings, opportunities, and properties. The columns described provide identifiers, statuses, financial details, locations, sizes, and other attributes for accounts, deals, and properties.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    28 views4 pages

    Data Dictionary932a5c1

    Uploaded by

    tinkudhull
    This document contains descriptions of data columns for multiple data files that contain real estate and deal information. The files include accounts, properties, deals to properties mappings, opportunities, and properties. The columns described provide identifiers, statuses, financial details, locations, sizes, and other attributes for accounts, deals, and properties.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    of 4

    Data dictionar

    File Name:-
    File Description:-
    Columns Name
    id_accs
    active_deals
    activity_count
    buyer_book
    servicing_contract
    investor_type
    cmbs
    consultant
    correspondent
    foreign
    master_servicer
    lender_book
    loan_sales_book
    loan_servicing
    num_deals_as_client
    num_deals_as_investor
    number_of_properties
    number_of_related_deals
    number_of_related_properties
    number_of_won_deals_as_client

    File Name:-
    File Description:-
    Columns Name
    id
    id_accs
    id_props

    File Name:-
    File Description:-
    Columns Name
    id
    createdbyid
    id_deals
    id_props

    File Name:-
    File Description:-
    Columns Name
    id_deals
    id_accs
    accounting_date
    best_initial_bid
    closedate
    date_closed
    deal_type
    deal_update_flag
    debt_yield
    fiscal
    fiscalquarter
    fiscalyear
    platform
    property_group
    property_type

    File Name:-
    File Description:-
    Columns Name
    id_props
    building_status
    building_tax_expenses
    id_deals
    city
    class
    county
    sale_status
    portfolio
    market
    num_buildings
    num_floors
    num_parking_spaces
    occupancy_rate
    price_per_sq_f
    price_per_unit
    property_type_1
    region__c
    sale_amount__c
    sale_date__c
    size_acres
    size_sf
    size_units
    year_built
    Data dictionary

    Accounts
    Account Information
    Description
    Account ID
    Deals currently in pipeline
    Aggregate number of activities
    Whether any of the accounts has Investment Advisory as a preference
    Whether we have a contract to service their loans
    Whether the account is a bank or fund or private investor
    Whether the account is involved in Mortgage Backed Securities
    Consulting relationships
    Correspondent office
    Denotes a foreign investor
    -
    Whether any of the accounts has Debt deals as a preference
    Whether any of the accounts has Loan Sale deals as a preference
    Whether any of the accounts has Loan Servicing as a preference
    Number of deals where the company has hired
    Number of deals where the company was the investor on the deal
    Total number of properties
    Total number of related deals
    Total number of related properties
    Number of won deals as a client

    Accounts_properties
    Account information and the property details of the lead
    Description
    ID
    Account ID
    Property ID

    Deals_to_Properties
    Deal and properties mapping
    Description
    ID
    SalesforceID of the person that created the record
    Deal ID
    Property ID

    Opportunities
    Succesful deal information
    Description
    Deal ID
    Account ID
    Date when the deal was closed and paid
    Best bid made by the customer
    Date when work has been completed on the deal
    -
    Deal Type
    -
    Debt deals, the yield of the loan
    Concatenation of fiscal year and fiscal quarter
    Fiscal quarter
    Fiscal year
    Which platform the deal belongs to
    Group of the property
    Type of the property

    Properties
    Property Information
    Description
    Property ID
    Status of the building
    Tax expenses
    Deal ID
    City code
    Class code
    County code
    Status of the Sale
    Portfolio code
    Market code
    Number of buildings
    Number of floors
    Number of parking spaces
    Occupancy rate
    Price per square feet
    Price per unit
    Type of the property
    Region
    Sale Amount
    Date of Sale
    Acre size
    Size in square feet
    Size Units
    Built year

    You might also like