Mapping

In order to report properly, we conform to the OSCRE Industry Data Model. OSCRE is the international standard for corporate real estate and real estate investment.

To make sure your values end up in the right places, we need to map your columns to the database standard. Type the header of your upload in the in the appropriate boxes. You can overwrite the suggested column names.

Important notes:

  • Your upload must be in Excel format and have the .xlsx or .csv extension
  • In case of .xlsx, your workbook can only have 1 sheet
  • Your upload must have 1 header row
  • The format of your upload must be consistent; If the format of your upload changes, you will need to adjust the mapping here.

    Description

    OSCRE
    table and field

    Your header

    Format | Required

    LEASE
    Lease ID
    Lease | LeaseID
    VARCHAR | YES
    Lease start date
    Lease | DateOfLeaseDate
    YYYY-MM-DD | YES
    First day of term date
    Lease | FirstDayOfTermDate
    YYYY-MM-DD | YES
    Last day of term date
    Lease | LastDayOfTermDate
    YYYY-MM-DD | if known
    Lease expiration date
    Lease | ExpirationDate
    YYYY-MM-DD | YES
    Rent security
    RentSecurity | ProvidedAmount
    INT | if applicable
    Rent security type
    RentSecurity | SecurityTypeCode
    VARCHAR | if applicable
    TENANT
    Tenant id
    Tenant | TenantID
    VARCHAR | YES
    Tenant name
    Tenant | Name
    VARCHAR | YES
    Is company
    Tenant | IsCompany
    BIT | YES
    LEASE OPTION
    Option from date
    LeaseOption | FromDate
    YYYY-MM-DD | if applicable
    Option to date
    LeaseOption | ToDate
    YYYY-MM-DD | if applicable
    Option type break purchase renew
    LeaseOption | TypeCode
    INT | if applicable
    Option type landlord tenant mutual
    LeaseOption | OptionByCode
    INT | if applicable
    Term
    LeaseOption | Term
    INT | if applicable
    Notice term
    LeaseOption | NoticeTerm
    INT | if applicable
    Notice term date
    LeaseOption | NoticeTermDate
    YYYY-MM-DD | if applicable
    Notice term frequency
    LeaseOption | TermFrequencyCode
    INT | if applicable
    UNIT
    Fund id
    All tables | FundID
    VARCHAR | YES
    Property id
    All tables | PropertyID
    VARCHAR | YES
    Unit id
    All tables | UnitID
    VARCHAR | YES
    Unit type
    Unit | UnitType
    VARCHAR | YES
    Gross area
    Unit | GrossArea
    INT | YES
    Net area
    Unit | NetArea
    INT | YES
    Is vacant
    Unit | Vacant
    BIT | YES
    Vacancy reason
    Unit | VacancyNote
    VARCHAR | required if IsVacant = 1
    LEASE CHARGE
    Income category rent amount
    LeaseCharge | Amount
    INT | YES
    Income category service charges amount
    LeaseCharge | Amount
    INT | if applicable
    Income category others amount
    LeaseCharge | Amount
    INT | if applicable
    Income category discount amount
    LeaseCharge | Amount
    INT | if applicable
    Term frequency
    LeaseCharge | TermFrequency
    INT | YES
    Charge frequency
    LeaseCharge | ChargeFrequency
    INT | YES
    Value added tax
    LeaseCharge | VATCode
    BIT | YES
    Value added tax rate
    LeaseCharge | VATRate
    INT | YES
    Start payment schedule
    LeaseCharge | StartPaymentSchedule
    YYYY-MM-DD | YES
    End payment schedule
    LeaseCharge | EndPaymentSchedule
    YYYY-MM-DD | if known
    Currency
    LeaseCharge | CurrencyCode
    VARCHAR | YES
    INDEXATION
    Index series
    Indexation | IndexSeries
    VARCHAR | if applicable
    Index type
    Indexation | IndexType
    VARCHAR | if applicable
    Start date
    Indexation | StartDate
    YYYY-MM-DD | if applicable
    Index frequency
    Indexation | IndexFrequency
    INT | if applicable
    Index date
    Indexation | IndexDate
    YYYY-MM-DD | if applicable
    Index value
    Indexation | Value
    INT | if applicable
    Next index date
    Indexation | Value
    YYYY-MM-DD | if applicable
    Next index value
    Indexation | IndexDate
    INT | if applicable