Data Dictionary 2.0 Changes Approved

[Jad212s]

The following changes were approved at the meeting on 2024-10-11 and reflected on the attached spreadsheet.
2024-10-11-Changes-RESODataDictionary-2.0.xlsx

Fields
OfficeCountry

• Change SimpleDataType to String List, Single
• Add LookupName - Country
• Add LookupStatus - Open with Enumerations

OfficeMailCountry

• Change SimpleDataType to String List, Single
• Add LookupName - Country
• Add LookupStatus - Open with Enumerations

OfficeMailStateOrProvince

• Change SimpleDataType to String List, Single
• Add LookupName - StateOrProvince
• Add LookupStatus - Open with Enumerations

OfficeMailCountyOrParish

• Change SimpleDataType to String List, Single
• Add LookupName - CountryOrParish
• Add LookupStatus - Open

OfficeMailCountyOrParish - Change SugMaxLength to 50

Change the following field names from using "ID" to "Id":

• LockOrBoxOriginatingSystemID -> LockOrBoxOriginatingSystemId
• LockOrBoxSourceSystemID -> LockOrBoxSourceSystemId
• OriginatingSystemResourceRecordID -> OriginatingSystemResourceRecordId
• OriginatingSystemResourceRecordSystemID -> OriginatingSystemResourceRecordSystemId
• SourceSystemResourceRecordID -> SourceSystemResourceRecordId
• SourceSystemResourceRecordSystemID -> SourceSystemResourceRecordSystemId
• FranchiseNationalAssociationID -> FranchiseNationalAssociationId
• OfficeBrokerNationalAssociationID -> OfficeBrokerNationalAssociationId

PropertyTimeZoneName

• Changed LookupName to IanaTimeZoneValues
• Changed LookupStatus to Locked with Enumerations
• Updated the field definition

ListingTimeZone

• Changed LookupName to IanaTimeZoneValues
• Changed LookupStatus to Locked with Enumerations
• Changed SimpleDataType to String List, Single
• Changed SuggMaxLength to 150
• Updated the field definition

ShowingTimeZone

• Changed LookupName to IanaTimeZoneValues
• Changed LookupStatus to Locked with Enumerations
• Changed SimpleDataType to String List, Single
• Changed SuggMaxLength to 150
• Updated the field definition

Lookups
Stainless Steel Appliance(s)

• Updated definition

Removed lookups named PropertyTimeZone and ShowingTimeZone

Added a Lookup named IanaTimeZoneValues with 381 LookupValues