MRI Data Fields Available in Stella
The following fields can be imported from MRI into Stella. Fields are organized by data category.
Units
|
Field |
Description |
|---|---|
|
Unit Number |
Unit identifier |
|
Unit Name |
Display name for the unit |
|
Space Number |
Space or location identifier within the property |
|
Unit Type |
Unit classification (e.g., Studio, 1BR, 2BR) |
|
Bedrooms |
Number of bedrooms |
|
Bathrooms |
Number of bathrooms |
|
Min Square Feet |
Minimum square footage |
|
Max Square Feet |
Maximum square footage |
|
Market Rent |
Listed market rent |
|
Available Date |
Date the unit becomes available |
|
Status |
Occupancy status (e.g., occupied, vacant) |
Residents
|
Field |
Description |
|---|---|
|
Resident ID |
Internal customer identifier |
|
Public ID |
Public-facing resident number |
|
Customer Type |
Resident classification |
|
Status |
Residency status |
|
First Name |
First name |
|
Last Name |
Last name |
|
|
Email address |
|
Phone |
Phone number |
Leases
|
Field |
Description |
|---|---|
|
Lease Number |
Unique lease identifier |
|
Unit Number |
Associated unit number |
|
Unit Name |
Display name of the unit |
|
Unit Space Number |
Associated unit space ID |
|
Status |
Lease status |
|
Lease Start Date |
Lease commencement date |
|
Lease End Date |
Lease expiration date |
|
Move-In Date |
Actual move-in date |
|
Move-Out Date |
Actual or anticipated move-out date |
|
Notice Date |
Date notice to vacate was given |
|
Rent |
Monthly rent amount |
Charges
|
Field |
Description |
|---|---|
|
Charge Number |
Unique charge or transaction identifier |
|
Charge Type |
Whether this is a charge or a payment |
|
Amount |
Charge or payment amount |
|
Charge Code |
Account or transaction code |
|
Charge Date |
Date the transaction was recorded |
|
Account ID |
General ledger account identifier |
|
Post Month |
Accounting period for the charge |
|
Note |
Additional details or description |
Budgets
|
Field |
Description |
|---|---|
|
Period |
Fiscal period (year and month) |
|
Budget Type |
High-level category (Revenue or Expenses) |
|
Category |
Sub-category within the budget type |
|
Account Number |
General ledger account number |
|
Account Name |
General ledger account name |
|
Budgeted Amount |
Amount budgeted for the period |
|
Actual Amount |
Amount actually spent or earned |
|
Variance |
Difference between budgeted and actual |