search

RESOStandards / web-api-commander

Client tools and libraries to work with and test RESO Web APIs.
https://commander.reso.org
Other
37 stars 18 forks source link

Data Dictionary 2.0 File #168

Closed Jad212s closed 11 months ago

Jad212s commented 1 year ago

RESODataDictionary-2.0.xlsx

The original ticket addressed the updates to change CaravanStops, MemberStateLicenses, and OfficeCorporateLicenses to their singular version: CaravanStop, MemberStateLicense, and OfficeCorporateLicense, as well as resolving some duplicate lookup names.

Jad212s commented 1 year ago

Updated SugMaxPrecision for:

AboveGradeUnfinishedArea BelowGradeUnfinishedArea ListingLatitude ListingLongitude TaxAnnualAmountPerLivingAreaUnit

RESODataDictionary-2.0.xlsx

Jad212s commented 1 year ago

Field Changes <html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns="http://www.w3.org/TR/REC-html40">

Resource | Field | Column | New Value -- | -- | -- | -- Caravan | CaravanOrganizerResourceName | SimpleDataType | String List, Single Caravan | CaravanOrganizerResourceName | LookupName | CaravanResourceName Caravan | CaravanOrganizerResourceName | SimpleDataType | String List, Single Caravan | CaravanOrganizerResourceName | LookupStatus | Open with Enumerations CaravanStop | StopAttendedBy | LookupName | CaravanStopAttended CaravanStop | StopResourceName | LookupName | CaravanResourceName LockOrBox | ListingLatitude | SugMaxPrecision | 8 LockOrBox | ListingLongitude | SugMaxPrecision | 8 MemberStateLicense | MemberStateLicenseState | LookupStatus | Open with Enumerations MemberStateLicense | MemberStateLicenseType | LookupStatus | Open with Enumerations OfficeCorporateLicense | OfficeCorporateLicenseState | LookupStatus | Open with Enumerations OfficeCorporateLicense | OfficeCorporateLicenseType | LookupStatus | Open with Enumerations PowerStorage | NameplateCapacity | SugMaxPrecision | 2 PowerStorage | PowerStorageType | LookupStatus | Open with Enumerations Property | AboveGradeUnfinishedArea | SugMaxPrecision | 2 Property | BelowGradeUnfinishedArea | SugMaxPrecision | 2 Property | PropertyTimeZoneStandardOffset | SimpleDataType | Number Property | TaxAnnualAmountPerLivingAreaUnit | SugMaxPrecision | 2

Lookup Changes <html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns="http://www.w3.org/TR/REC-html40">

Column | Previous Value | New Value -- | -- | -- LookupName | CaravanStopClassNames | CaravanStopClassName LookupName | CaravanStopResourceNames | CaravanResourceName

RESODataDictionary-2.0.xlsx

darnjo commented 1 year ago

Thanks for putting this table together, Jason.

@sdebord, I think these changes are ready to review and approve. Note that I haven't built/tested them yet so we could find other things as well.

Jad212s commented 11 months ago

Attached is the 2.0 sheet with all of the definition updates. Does not include items approved after ratification.

RESODataDictionary-2.0 2023-11-01.xlsx

darnjo commented 11 months ago

Thanks, Jason.