Office
GET
/trestle/odata/Office
GET
/trestle/rets/search?SearchType=Office&Class=Office
OfficeKey
is the primary key and uniquely identifies records in the Office resource.
The following fields are considered InKeyIndex fields and may be queried in batches up to 300,000 at a time:
ModificationTimestamp
, OfficeKey
, OfficeMlsId
.
Fields
Field | Type | Size | Description |
---|---|---|---|
FranchiseAffiliation | String | 50 | The name of the franchise to which the broker/office is contracted. |
HumanModifiedYN | Boolean | Flag to indicate that the most recent modification to this record was made by a human. | |
IDXOfficeParticipationYN | Boolean | Does the Office/Broker participate in IDX. | |
MainOfficeKey | String | 255 | OfficeKey of the Main Office in a firm/company of offices. This is a self referencing foreign key relating to this resource's OfficeKey. This key may be the same value as the OfficeKey for a given record if the given office is the Main Office. |
MainOfficeKeyNumeric | Int32 | 255 | OfficeKey of the Main Office in a firm/company of offices. This is a self referencing foreign key relating to this resource's OfficeKey. This key may be the same value as the OfficeKey for a given record if the given office is the Main Office. This is the numeric only key and used as an alternative to the MainOfficeKey field. |
MainOfficeMlsId | String | 25 | OfficeMlsId of the Main Office in a firm/company of offices. |
ModificationTimestamp InKey | DateTimeOffset | Date/time the roster (member or office) record was last modified. | |
OfficeAddress1 | String | 50 | The street number, direction, name and suffix of the office. |
OfficeAddress2 | String | 50 | The unit/suite number of the office. |
OfficeAOR | AOR Enum | The Office's Board or Association of REALTORS. | |
OfficeAORkey | String | 255 | A system unique identifier. Specifically, in aggregation systems, the OfficeAORkey is the system unique identifier from the system that the record was retrieved. This may be identical to the related xxxId. This is a foreign key relating to the AOR's member management system in which the record was originated. |
OfficeAORkeyNumeric | Int32 | 255 | A system unique identifier. Specifically, in aggregation systems, the OfficeAORkey is the system unique identifier from the system that the record was retrieved. This may be identical to the related xxxId. This is a foreign key relating to the AOR's member management system in which the record was originated. This is the numeric only key and used as an alternative to the OfficeAORkey field. |
OfficeAORMlsId | String | 25 | The local, well-known identifier for the office's Association of REALTORS. This value may not be unique, specifically in the case of aggregation systems, this value should be the identifier from the original system. |
OfficeAssociationComments | String | 500 | Notes relating to the office. |
OfficeBranchType | OfficeBranchType Enum | The level of the office in the hierarchy of Main, Branch, Stand Alone, etc., | |
OfficeBrokerKey | String | 255 | The MemberKey of the responsible/owning broker. This is a foreign key relating to the Member resource's MemberKey. |
OfficeBrokerKeyNumeric | Int32 | 255 | The MemberKey of the responsible/owning broker. This is a foreign key relating to the Member resource's MemberKey. This is the numeric only key and used as an alternative to the OfficeBrokerKey field. |
OfficeBrokerMlsId | String | 25 | The MemberMlsId of the responsible/owning broker. |
OfficeCity | String | 50 | The city of the office. |
OfficeCityRegion | String | 150 | |
OfficeCorporateLicense | String | 50 | When an office/firm is a corporation, an independent license number is issued. |
OfficeCountry | String | 2 | The office's country code for the street address. |
OfficeCountyOrParish | String | 50 | The county or parish in which the offices is located. |
OfficeEmail | String | 80 | The email address of the office |
OfficeFax | String | 16 | North American 10 digit phone numbers should be in the format of ###-###-#### (separated by hyphens). Other conventions should use the common local standard. International numbers should be preceded by a plus symbol. |
OfficeKey Key InKey | String | 255 | A system unique identifier. Specifically, in aggregation systems, the Key is the system unique identifier from the system that the record was just retrieved. This may be identical to the related xxxId identifier, but the key is guaranteed unique for this record set. |
OfficeKeyNumeric | Int32 | 255 | A unique identifier for this record from the immediate source. This is the numeric only key and used as an alternative to the OfficeKey fields. This is the local key of the system. When records are received from other systems, a local key is commonly applied. If conveying the original keys from the source or originating systems, see SourceSystemOfficeKey and OriginatingSystemOfficeKey. |
OfficeManagerKey | String | 255 | The lead Office Manager for the given office. This is a foreign key relating to the Member resource's MemberKey. |
OfficeManagerKeyNumeric | Int32 | 255 | The lead Office Manager for the given office. This is a foreign key relating to the Member resource's MemberKey. This is the numeric only key and used as an alternative to the OfficeManagerKey field. |
OfficeManagerMlsId | String | 25 | The lead Office Manager for the given office. |
OfficeMlsId InKey | String | 25 | The local, well-known identifier. This value may not be unique, specifically in the case of aggregation systems, this value should be the identifier from the original system. |
OfficeName | String | 255 | The legal name of the brokerage. |
OfficeNationalAssociationId | String | 25 | The national association ID of the office. i.e. in the U.S. is the NRDS number. |
OfficePhone | String | 16 | North American 10 digit phone numbers should be in the format of ###-###-#### (separated by hyphens). Other conventions should use the common local standard. International numbers should be preceded by a plus symbol. |
OfficePhoneExt | String | 10 | The extension of the given phone number (if applicable). |
OfficePostalCode | String | 10 | The postal code of the office. |
OfficePostalCodePlus4 | String | 4 | The extension of the postal/zip code. i.e. +4 |
OfficeStateOrProvince | StateOrProvince Enum | The state or province in which the office is located. | |
OfficeStatus | OfficeStatus Enum | Is the office active, inactive or under disciplinary action. | |
OfficeStreetAdditionalInfo | String | 50 | |
OfficeType | OfficeType Enum | The type of business conducted by the office. i.e. Real Estate, Appraiser, etc. | |
OriginalEntryTimestamp | DateTimeOffset | Date/time the roster (member or office) record was originally input into the source system. | |
OriginatingSystemID | String | 25 | The RESO OUID's OrganizationUniqueId of the Originating record provider. The Originating system is the system with authoritative control over the record. For example; the name of the MLS where the office was input. In cases where the Originating system was not where the record originated (the authoritative system), see the Originating System fields. |
OriginatingSystemName | String | 255 | The name of the Originating record provider. Most commonly the name of the MLS. The place where the office is originally input by the member. The legal name of the company. |
OriginatingSystemOfficeKey | String | 255 | The system key, a unique record identifier, from the Originating system. The Originating system is the system with authoritative control over the record. For example, the Multiple Listing Service where the office was input. There may be cases where the Source System (how you received the record) is not the Originating System. See Source System Key for more information. |
OriginatingSystemSubName | String | 255 | |
Permission | Permission Enum | ||
PermissionPrivate | String | 255 | |
SocialMediaType | SocialMediaType Enum | A list of types of sites, blog, social media, the Office URL or ID is referring to. i.e. Website, Blog, Facebook, Twitter, LinkedIn, Skype, etc., This list is used to populate the Type with repeating Social Media URL or ID types. | |
SourceSystemID | String | 25 | The RESO OUID's OrganizationUniqueId of the Source record provider. The source system is the system from which the record was directly received. In cases where the source system was not where the record originated (the authoritative system), see the Originating System fields. |
SourceSystemName | String | 255 | The name of the immediate record provider. The system from which the record was directly received. The legal name of the company. |
SourceSystemOfficeKey | String | 255 | The system key, a unique record identifier, from the Source System. The Source System is the system from which the record was directly received. In cases where the Source System was not where the record originated (the authoritative system), see the Originating System fields. |
SyndicateAgentOption | SyndicateAgentOption Enum | A list of options allowing the broker to pass the decision of syndication choice down to the listing agents. i.e. No Agent Choice, Allow Agent Choice, Restrict Agent Choice, etc. | |
SyndicateTo | SyndicateTo Enum | The principal broker's choice on where they would like their listings syndicated. i.e. Zillow, Trulia, Homes.com, etc. |
Expands
Name | Target |
---|---|
BuyerOfficeProperties | Property |
CoBuyerOfficeProperties | Property |
CoListOfficeProperties | Property |
ListOfficeProperties | Property |