MLS Schema Payload Change Report

RETS ChangeRequest Status Report 20070709

#97 Status: Deferred   Severity: Medium  
  Modified Time: 7/2/2007 11:01:34 AM   Entered On: 6/26/2007 11:52:19 AM  
  Responsibility:     Entered By: Gina Accawi  
  Type: Defect   Build Reviewed: 2007-05-14  
  Addressed By:     Addressed In:    
  Synopsis: Verify case consistency for attribute names.
  Description: Mostly complete. There are some id attributes that are not case consistent in some of the more minor schemas.  



#71 Status: Deferred   Severity: Medium  
  Modified Time: 6/29/2007 1:06:34 PM   Entered On: 6/22/2007 12:17:06 PM  
  Responsibility: Gina Accawi   Entered By: Gina Accawi  
  Type: Defect   Build Reviewed: 2007-05-14  
  Addressed By:     Addressed In:    
  Synopsis: Check for enums requiring the attribute for specifying values. Make sure all enums needing the otherDescription have it.

Having enum with attribute of otherDescription means that the enum is a complexType. Being a complexType means that attributes cannot use the enum as a type. Should we have simple version (no attribute) plus a complex version (with attribute)?

  Description:    



#36 Status: Deferred   Severity: Medium  
  Modified Time: 7/3/2007 12:49:15 AM   Entered On: 6/12/2007 10:59:44 AM  
  Responsibility: Gina Accawi   Entered By: Gina Accawi  
  Type: Suggestion   Build Reviewed: 2007-05-14  
  Addressed By:     Addressed In:    
  Synopsis: Include township in address information.
  Description:    



#106 Status: Fixed   Severity: Medium  
  Modified Time: 7/9/2007 12:12:49 PM   Entered On: 7/9/2007 11:38:42 AM  
  Responsibility: Paul Stusiak   Entered By: Paul Stusiak  
  Type: Defect   Build Reviewed: 2007-05-14  
  Addressed By: Paul Stusiak   Addressed In: Next Build  
  Synopsis: Move View from Listings to Properties
  Description:    



#104 Status: Fixed   Severity: Medium  
  Modified Time: 7/6/2007 12:12:22 AM   Entered On: 7/6/2007 12:08:05 AM  
  Responsibility: Paul Stusiak   Entered By: Paul Stusiak  
  Type: Defect   Build Reviewed: 2007-05-14  
  Addressed By: Paul Stusiak   Addressed In: Next Build  
  Synopsis: Create container for ListingPricing and ListingDates
  Description:    



#103 Status: Fixed   Severity: Medium  
  Modified Time: 7/5/2007 5:58:16 PM   Entered On: 7/5/2007 5:31:30 PM  
  Responsibility: Paul Stusiak   Entered By: Paul Stusiak  
  Type: Defect   Build Reviewed: 2007-05-14  
  Addressed By: Paul Stusiak   Addressed In: Next Build  
  Synopsis: Apply general pattern of nonNegativeInteger for <Property>Total element names
  Description:    



#102 Status: Fixed   Severity: Medium  
  Modified Time: 7/5/2007 2:14:20 PM   Entered On: 7/5/2007 12:35:16 PM  
  Responsibility: Gina Accawi   Entered By: Gina Accawi  
  Type: Defect   Build Reviewed: 2007-05-14  
  Addressed By: Gina Accawi   Addressed In: Next Build  
  Synopsis: Move Address to the ContactMethods schema. Make changes to Members, Teams and Person accordingly.
  Description: Will need to include Address in the preference ordering.
Create address types of: Physical, Display, Mailing, Tax, Legal, Billing, Shipping, and Other.
 



#101 Status: Fixed   Severity: Medium  
  Modified Time: 7/3/2007 1:02:41 AM   Entered On: 7/2/2007 5:44:21 PM  
  Responsibility: Paul Stusiak   Entered By: Paul Stusiak  
  Type: Defect   Build Reviewed: 2007-05-14  
  Addressed By: Paul Stusiak   Addressed In: Next Build  
  Synopsis: Create a container for Pricing information on a Listing
  Description:    



#100 Status: Fixed   Severity: Medium  
  Modified Time: 7/3/2007 1:04:55 AM   Entered On: 7/2/2007 5:40:29 PM  
  Responsibility: Paul Stusiak   Entered By: Paul Stusiak  
  Type: Defect   Build Reviewed: 2007-05-14  
  Addressed By: Paul Stusiak   Addressed In: Next Build  
  Synopsis: Remove redundant Zoning in Properties
  Description:    



#99 Status: Fixed   Severity: Medium  
  Modified Time: 7/2/2007 4:04:06 PM   Entered On: 7/2/2007 1:51:54 PM  
  Responsibility: Paul Stusiak   Entered By: Paul Stusiak  
  Type: Defect   Build Reviewed: 2007-05-14  
  Addressed By: Paul Stusiak   Addressed In: Next Build  
  Synopsis: Update WaterFeature based on feedback
  Description: Change the WaterInformation container to WaterFeature and refactor the elements.  



#96 Status: Fixed   Severity: Medium  
  Modified Time: 7/3/2007 1:04:55 AM   Entered On: 6/22/2007 1:48:51 PM  
  Responsibility: Gina Accawi   Entered By: Gina Accawi  
  Type: Defect   Build Reviewed: 2007-05-14  
  Addressed By: Paul Stusiak   Addressed In: Next Build  
  Synopsis: Move topography, land use to the lot information.
  Description:    



#94 Status: Fixed   Severity: Medium  
  Modified Time: 7/2/2007 11:02:31 AM   Entered On: 6/22/2007 1:47:11 PM  
  Responsibility: Gina Accawi   Entered By: Gina Accawi  
  Type: Defect   Build Reviewed: 2007-05-14  
  Addressed By: Gina Accawi   Addressed In: Next Build  
  Synopsis: Revise the container for Schools
  Description: Do not need all the various school types. Should be Schools, not SchoolData. School type has district. Make the elements repeatable and optional. Make school type enumeration. School name. Add secondary as a school type. Need other. Description attribute for other.  



#92 Status: Fixed   Severity: Medium  
  Modified Time: 6/26/2007 11:59:50 AM   Entered On: 6/22/2007 1:44:31 PM  
  Responsibility: Gina Accawi   Entered By: Gina Accawi  
  Type: Defect   Build Reviewed: 2007-05-14  
  Addressed By: Gina Accawi   Addressed In: Next Build  
  Synopsis: Put BathsTotal at the same level as TotalRooms. BlahTotal as the name. Removes Baths as a separate type. Baths now should be in with the rest of the rooms. Ensure all the names with Total in them are BlahTotal.
  Description:    



#91 Status: Fixed   Severity: Medium  
  Modified Time: 6/29/2007 12:49:25 PM   Entered On: 6/22/2007 1:43:32 PM  
  Responsibility: Gina Accawi   Entered By: Gina Accawi  
  Type: Defect   Build Reviewed: 2007-05-14  
  Addressed By: Gina Accawi   Addressed In: Next Build  
  Synopsis: Document master bathroom as "There is a door or entranceway between the master bedroom and this bathroom." For the isMaster flag, "Indicates the principle one of a given type of room."
  Description:    



#90 Status: Fixed   Severity: Medium  
  Modified Time: 6/25/2007 12:22:07 PM   Entered On: 6/22/2007 1:42:31 PM  
  Responsibility: Gina Accawi   Entered By: Gina Accawi  
  Type: Defect   Build Reviewed: 2007-05-14  
  Addressed By: Gina Accawi   Addressed In: Next Build  
  Synopsis: Add an isMaster flag that can be used on any room element.
  Description:    



#89 Status: Fixed   Severity: Medium  
  Modified Time: 7/2/2007 11:03:42 AM   Entered On: 6/22/2007 1:42:04 PM  
  Responsibility: Gina Accawi   Entered By: Gina Accawi  
  Type: Defect   Build Reviewed: 2007-05-14  
  Addressed By: Gina Accawi   Addressed In: Next Build  
  Synopsis: Revise Bathroom container
  Description: Add bath and types full, half, quarter, threequarter to roomTypeEnum. Remove BathWainscotMaterials. Remove the BathsTotal, BathsFull, BathsHalf, BathsThreeQuarter types. Make the types all integers. BathroomCount is the number of rooms that are bathrooms, also an integer. BathsTotalLegacy is a string.

See CR 92: BathroomCount will be BathroomTotal. All total counts will be named blahTotal.

 



#88 Status: Fixed   Severity: Medium  
  Modified Time: 7/4/2007 7:04:03 PM   Entered On: 6/22/2007 1:41:23 PM  
  Responsibility: Gina Accawi   Entered By: Gina Accawi  
  Type: Defect   Build Reviewed: 2007-05-14  
  Addressed By: Paul Stusiak   Addressed In: Next Build  
  Synopsis: Ensure that there is a measurement source on a measurement
  Description: Check for SecureMeasurement source to make certain it is defined.

It is defined in Primitives, but not used in SecureMeasurement.

Appears to be missing. Reported by Jaison Freed.

 



#87 Status: Fixed   Severity: Medium  
  Modified Time: 6/29/2007 9:31:41 AM   Entered On: 6/22/2007 1:40:52 PM  
  Responsibility:     Entered By: Gina Accawi  
  Type: Defect   Build Reviewed: 2007-05-14  
  Addressed By: Paul Stusiak   Addressed In: Next Build  
  Synopsis: Age (string) and YearBuilt (integer). Neither are nullable. Put them in Building, right under Building.
  Description:    



#86 Status: Fixed   Severity: Medium  
  Modified Time: 7/5/2007 5:14:55 PM   Entered On: 6/22/2007 1:40:15 PM  
  Responsibility: Gina Accawi   Entered By: Gina Accawi  
  Type: Defect   Build Reviewed: 2007-05-14  
  Addressed By: Paul Stusiak   Addressed In: Next Build  
  Synopsis: Add additional enumeration values to PossessionTypeEnum
  Description: Add SpecificDate, AfterHarvest to PossessionTypeEnum. ClosePlus (put more information in the description attribute). Joshua will send the enums for this to me and Paul.  



#84 Status: Fixed   Severity: Medium  
  Modified Time: 7/9/2007 12:12:49 PM   Entered On: 6/22/2007 1:37:29 PM  
  Responsibility: Gina Accawi   Entered By: Gina Accawi  
  Type: Defect   Build Reviewed: 2007-05-14  
  Addressed By: Paul Stusiak   Addressed In: Next Build  
  Synopsis: For pet information: Additional fee, Recurring Fee to cover: Pets: Pet deposit, additional pet rent, Deposit required.

Document the Permitted types to indicate that it includes: breeds, types, neutered declawed, etc.

  Description:    



#82 Status: Fixed   Severity: Medium  
  Modified Time: 7/2/2007 1:45:18 PM   Entered On: 6/22/2007 1:35:37 PM  
  Responsibility: Gina Accawi   Entered By: Gina Accawi  
  Type: Defect   Build Reviewed: 2007-05-14  
  Addressed By: Paul Stusiak   Addressed In: Next Build  
  Synopsis: Use Lot container for Lot improvements
  Description: Add Lot to hold the outside features. Add LotDescription. Examples provided: Sidewalk, StreetLighting, Driveway, PatioType  



#80 Status: Fixed   Severity: Medium  
  Modified Time: 7/6/2007 1:40:19 PM   Entered On: 6/22/2007 1:35:01 PM  
  Responsibility: Gina Accawi   Entered By: Gina Accawi  
  Type: Defect   Build Reviewed: 2007-05-14  
  Addressed By: Gina Accawi   Addressed In: Next Build  
  Synopsis: Make listingRole at team level as well as inside the team on the member level.
  Description:    



#78 Status: Fixed   Severity: Medium  
  Modified Time: 6/27/2007 11:38:03 AM   Entered On: 6/22/2007 1:33:54 PM  
  Responsibility: Gina Accawi   Entered By: Gina Accawi  
  Type: Defect   Build Reviewed: 2007-05-14  
  Addressed By: Gina Accawi   Addressed In: Next Build  
  Synopsis: Add MarketingArea to Listing.
  Description:    



#77 Status: Fixed   Severity: Medium  
  Modified Time: 6/27/2007 11:30:04 AM   Entered On: 6/22/2007 1:33:39 PM  
  Responsibility: Gina Accawi   Entered By: Gina Accawi  
  Type: Defect   Build Reviewed: 2007-05-14  
  Addressed By: Gina Accawi   Addressed In: Next Build  
  Synopsis: Add Farm/Ag top property type, DeededParking subtype.
  Description:    



#70 Status: Fixed   Severity: Medium  
  Modified Time: 7/5/2007 5:14:55 PM   Entered On: 6/22/2007 12:06:20 PM  
  Responsibility: Gina Accawi   Entered By: Gina Accawi  
  Type: Defect   Build Reviewed: 2007-05-14  
  Addressed By: Paul Stusiak   Addressed In: Next Build  
  Synopsis: Owner and Occupant should be defined in Property.
They are ContactablePerson types.
  Description:    



#67 Status: Fixed   Severity: Medium  
  Modified Time: 7/9/2007 12:12:49 PM   Entered On: 6/22/2007 12:01:43 PM  
  Responsibility: Gina Accawi   Entered By: Gina Accawi  
  Type: Defect   Build Reviewed: 2007-05-14  
  Addressed By: Paul Stusiak   Addressed In: Next Build  
  Synopsis: Move Community to Property (rather than Listing).
  Description:    



#66 Status: Fixed   Severity: Medium  
  Modified Time: 7/4/2007 11:21:58 AM   Entered On: 6/22/2007 11:58:26 AM  
  Responsibility: Gina Accawi   Entered By: Gina Accawi  
  Type: Defect   Build Reviewed: 2007-05-14  
  Addressed By: Paul Stusiak   Addressed In: Next Build  
  Synopsis: Add documentation to indicate closed is the same as sold under listing status. Also under the ClosePrice, add the documentation.
  Description:    



#65 Status: Fixed   Severity: Medium  
  Modified Time: 7/4/2007 11:20:00 AM   Entered On: 6/22/2007 11:57:30 AM  
  Responsibility: Gina Accawi   Entered By: Gina Accawi  
  Type: Defect   Build Reviewed: 2007-05-14  
  Addressed By: Paul Stusiak   Addressed In: Next Build  
  Synopsis: Document the meaning of ListPriceHigh and ListPriceLow as being ranged pricing.
  Description:    



#64 Status: Fixed   Severity: Medium  
  Modified Time: 7/2/2007 9:45:35 AM   Entered On: 6/22/2007 11:56:02 AM  
  Responsibility: Gina Accawi   Entered By: Gina Accawi  
  Type: Defect   Build Reviewed: 2007-05-14  
  Addressed By: Gina Accawi   Addressed In: Next Build  
  Synopsis: Add key to each of the resources. Add a resourceKey common type. Make the elements of the common type.
  Description:    



#62 Status: Fixed   Severity: Medium  
  Modified Time: 7/6/2007 2:31:03 PM   Entered On: 6/22/2007 11:54:28 AM  
  Responsibility: Gina Accawi   Entered By: Gina Accawi  
  Type: Defect   Build Reviewed: 2007-05-14  
  Addressed By: Gina Accawi   Addressed In: Next Build  
  Synopsis: Rename elements that are Ids to be OfficeContactManagerId. Check for other elements that are Id.
  Description:    



#60 Status: Fixed   Severity: Medium  
  Modified Time: 7/6/2007 2:32:03 PM   Entered On: 6/22/2007 11:53:16 AM  
  Responsibility: Gina Accawi   Entered By: Gina Accawi  
  Type: Defect   Build Reviewed: 2007-05-14  
  Addressed By: Gina Accawi   Addressed In: Next Build  
  Synopsis: FranchiseId should say NRDSFranchiseId.

Check for NRDS fields in the office schema to ensure they are all indicated.

  Description:    



#58 Status: Fixed   Severity: Medium  
  Modified Time: 6/27/2007 11:53:31 AM   Entered On: 6/22/2007 8:52:29 AM  
  Responsibility: Gina Accawi   Entered By: Gina Accawi  
  Type: Defect   Build Reviewed: 2007-05-14  
  Addressed By: Gina Accawi   Addressed In: Next Build  
  Synopsis: Remove OfficeFormalName from Offices.xsd.
  Description:    



#57 Status: Fixed   Severity: Medium  
  Modified Time: 6/27/2007 2:29:36 PM   Entered On: 6/22/2007 8:52:03 AM  
  Responsibility: Gina Accawi   Entered By: Gina Accawi  
  Type: Defect   Build Reviewed: 2007-05-14  
  Addressed By: Gina Accawi   Addressed In: Next Build  
  Synopsis: Rename Agent to Member.
  Description: This will include file rename, and carefully locating all agent references. Also, document this renaming.  



#56 Status: Fixed   Severity: Medium  
  Modified Time: 7/5/2007 3:52:25 PM   Entered On: 6/22/2007 8:51:06 AM  
  Responsibility: Gina Accawi   Entered By: Gina Accawi  
  Type: Suggestion   Build Reviewed: 2007-05-14  
  Addressed By: Gina Accawi   Addressed In: Next Build  
  Synopsis: Create Team.xsd.
  Description: Conversation around teams:

At least one needs to be licensed. Others could be assistants, etc.

Is one primary? Is that primary always the primary - the primary can change.

Could a team replace a list agent where list agent is required? Like a foreign key to the team rather than to the list agent? Yes, db rule but is something on which we should ponder.

I think there may be licensing laws as far as who has the listing contract. We should check with NAR and our state licensing bodies. I would think they require a specific responsible party for legal purposes so we would probably have to identify that person as a lead or something.

Team needs, as a starting point:
modification timestamp
elements
team name
contact method
id
website
collection of members

Document that the primary could/would be implied by the member category (list, co-list).

However, in talks, it is clear there needs to be also a role for each member to identify their role within the team. Examples provided for role: photographer, marketing lead, team manager/lead, etc).

The team could persist beyond a given listing, and these roles may be more descriptive than roles needed within the context of the actual listing. Is it important to list the photographer for a listing?

 



#55 Status: Fixed   Severity: Medium  
  Modified Time: 7/5/2007 2:16:17 PM   Entered On: 6/22/2007 8:46:12 AM  
  Responsibility: Gina Accawi   Entered By: Gina Accawi  
  Type: Defect   Build Reviewed: 2007-05-14  
  Addressed By: Gina Accawi   Addressed In: Next Build  
  Synopsis: For contact method preferences need phonePreference, emailPreference, otherPreference, and top-level preference as integers.
  Description: This allows for specifying:

Contact by email, then phone.

As well as:

Work email, home email, other. Office phone, cell phone, home phone.

As preference/precedence.

 



#54 Status: Fixed   Severity: Medium  
  Modified Time: 7/5/2007 12:07:02 PM   Entered On: 6/22/2007 8:43:28 AM  
  Responsibility: Gina Accawi   Entered By: Gina Accawi  
  Type: Suggestion   Build Reviewed: 2007-05-14  
  Addressed By: Gina Accawi   Addressed In: Next Build  
  Synopsis: Create privacy type enum: Public, Agent/Member, MLS. This would be an attribute then for Phone, Email, (and addresses?).
  Description:    



#53 Status: Fixed   Severity: Medium  
  Modified Time: 6/26/2007 1:05:18 PM   Entered On: 6/22/2007 8:42:07 AM  
  Responsibility: Gina Accawi   Entered By: Gina Accawi  
  Type: Suggestion   Build Reviewed: 2007-05-14  
  Addressed By:     Addressed In: Next Build  
  Synopsis: Rename ContactInformation.xsd to ContactMethods.xsd.
  Description:    



#52 Status: Fixed   Severity: Medium  
  Modified Time: 6/29/2007 1:04:07 PM   Entered On: 6/22/2007 8:40:59 AM  
  Responsibility: Gina Accawi   Entered By: Gina Accawi  
  Type: Suggestion   Build Reviewed: 2007-05-14  
  Addressed By: Gina Accawi   Addressed In: Next Build  
  Synopsis: Ensure we cover at least URL and GetObject methods for retrieving agent photos and office logos. Add MediaItems to Agent/Member and Office.
  Description:    



#51 Status: Fixed   Severity: Medium  
  Modified Time: 7/5/2007 11:55:00 AM   Entered On: 6/14/2007 3:28:30 PM  
  Responsibility: Gina Accawi   Entered By: Gina Accawi  
  Type: Defect   Build Reviewed: 2007-05-14  
  Addressed By: Gina Accawi   Addressed In: Next Build  
  Synopsis: For preferred items, such as phone or email, create an attribute in the Primitives.xsd. This attribute may be an integer (for precedence) or Boolean (for preferred).
  Description:    



#45 Status: Fixed   Severity: Medium  
  Modified Time: 7/4/2007 6:46:49 PM   Entered On: 6/12/2007 2:56:43 PM  
  Responsibility: Gina Accawi   Entered By: Gina Accawi  
  Type: Defect   Build Reviewed: 2007-05-14  
  Addressed By: Paul Stusiak   Addressed In: Next Build  
  Synopsis: Rename PricePerSqFt,Lot Acres to units neutral names
  Description: Need a better name for the PricePerSqFoot element, there may be units other than sq feet. Also, need better name for the LotAcreage, as the unit may be other than acres.  



#35 Status: Fixed   Severity: Medium  
  Modified Time: 7/4/2007 7:01:59 PM   Entered On: 6/12/2007 10:55:38 AM  
  Responsibility: Gina Accawi   Entered By: Gina Accawi  
  Type: Defect   Build Reviewed: 2007-05-14  
  Addressed By: Paul Stusiak   Addressed In: Next Build  
  Synopsis: Change Designation to DesignationList, indicating that a member may have multiple
  Description:    



#34 Status: Fixed   Severity: Medium  
  Modified Time: 7/4/2007 11:18:30 AM   Entered On: 6/12/2007 10:54:53 AM  
  Responsibility: Gina Accawi   Entered By: Gina Accawi  
  Type: Defect   Build Reviewed: 2007-05-14  
  Addressed By: Paul Stusiak   Addressed In: Next Build  
  Synopsis: Address example should be modified for the postal code to be a zip + 4.
  Description:    



#33 Status: Fixed   Severity: Medium  
  Modified Time: 7/4/2007 4:09:15 PM   Entered On: 6/12/2007 10:54:04 AM  
  Responsibility: Gina Accawi   Entered By: Gina Accawi  
  Type: Defect   Build Reviewed: 2007-05-14  
  Addressed By: Paul Stusiak   Addressed In: Next Build  
  Synopsis: Add county for agent and office.
  Description:    



#32 Status: Fixed   Severity: Medium  
  Modified Time: 7/5/2007 2:12:31 PM   Entered On: 6/12/2007 10:53:38 AM  
  Responsibility: Gina Accawi   Entered By: Gina Accawi  
  Type: Defect   Build Reviewed: 2007-05-14  
  Addressed By: Gina Accawi   Addressed In: Next Build  
  Synopsis: Additional elements required for person schema: birthdate, gender, and languages.
  Description: Birthdate appears in MemberRecord.  



#31 Status: Fixed   Severity: Medium  
  Modified Time: 7/4/2007 4:09:15 PM   Entered On: 6/12/2007 10:52:01 AM  
  Responsibility: Gina Accawi   Entered By: Gina Accawi  
  Type: Suggestion   Build Reviewed: 2007-05-14  
  Addressed By: Paul Stusiak   Addressed In: Next Build  
  Synopsis: For agents schema, add remarks and job description elements.
  Description:    



#29 Status: Fixed   Severity: Medium  
  Modified Time: 7/6/2007 9:30:51 AM   Entered On: 6/12/2007 10:50:19 AM  
  Responsibility: Gina Accawi   Entered By: Gina Accawi  
  Type: Defect   Build Reviewed: 2007-05-14  
  Addressed By: Paul Stusiak   Addressed In: Next Build  
  Synopsis: Revise Rooms - apply general pattern of otherDescription, Category to Rooms
  Description:    



#28 Status: Fixed   Severity: Medium  
  Modified Time: 7/4/2007 4:09:15 PM   Entered On: 6/12/2007 10:49:44 AM  
  Responsibility: Gina Accawi   Entered By: Gina Accawi  
  Type: Suggestion   Build Reviewed: 2007-05-14  
  Addressed By: Paul Stusiak   Addressed In: Next Build  
  Synopsis: Agent needs a status enumeration
  Description: Agent status enumeration should include Active, Suspended, Inactive, Pending.  



#27 Status: Fixed   Severity: Medium  
  Modified Time: 7/4/2007 4:09:15 PM   Entered On: 6/12/2007 10:48:40 AM  
  Responsibility: Gina Accawi   Entered By: Gina Accawi  
  Type: Defect   Build Reviewed: 2007-05-14  
  Addressed By: Paul Stusiak   Addressed In: Next Build  
  Synopsis: Dates missing from agents schema. Join date, reinstated date, termination date, suspended date.
  Description:    



#25 Status: Fixed   Severity: Medium  
  Modified Time: 7/5/2007 5:25:22 PM   Entered On: 6/12/2007 10:46:13 AM  
  Responsibility: Gina Accawi   Entered By: Gina Accawi  
  Type: Suggestion   Build Reviewed: 2007-05-14  
  Addressed By: Paul Stusiak   Addressed In: Next Build  
  Synopsis: Add licensing to Members
  Description: Need to accommodate member licensing. Suggestion is that Real Estate License may be multiples, since member may have many different types of licensing. Need research done to construct an enumeration of license types.

For member licensing, include expiration date for license. Also, include transfer date, for event of member moving to another office.

NRDS captures some of this type of information, and it appears in the MemberRecords.xsd. Does it need to be moved into the Agent schema level or can it stay where it is and get more detail added, or multiplicity if needed?

 



#24 Status: Fixed   Severity: Medium  
  Modified Time: 7/6/2007 11:03:34 AM   Entered On: 6/12/2007 10:29:57 AM  
  Responsibility: Gina Accawi   Entered By: Gina Accawi  
  Type: Defect   Build Reviewed: 2007-05-14  
  Addressed By: Paul Stusiak   Addressed In: Next Build  
  Synopsis: Apply extensibility pattern of otherDescription attribute to the Features.xsd enumerations
  Description:    



#23 Status: Fixed   Severity: Medium  
  Modified Time: 6/27/2007 11:55:00 AM   Entered On: 6/12/2007 10:27:57 AM  
  Responsibility: Gina Accawi   Entered By: Gina Accawi  
  Type: Suggestion   Build Reviewed: 2007-05-14  
  Addressed By: Gina Accawi   Addressed In: Next Build  
  Synopsis: Rename phone.xsd to CommunicationMethod.xsd.
  Description:    



#22 Status: Fixed   Severity: Medium  
  Modified Time: 7/5/2007 2:15:41 PM   Entered On: 6/12/2007 10:27:35 AM  
  Responsibility: Gina Accawi   Entered By: Gina Accawi  
  Type: Suggestion   Build Reviewed: 2007-05-14  
  Addressed By: Gina Accawi   Addressed In: Next Build  
  Synopsis: For email and website, utilize the type and order of preference as suggested for the phone.
  Description: See questions regarding the order of preference for phone.

Also, what would the type enumeration be for email and website?

 



#21 Status: Fixed   Severity: Medium  
  Modified Time: 7/5/2007 11:53:53 AM   Entered On: 6/12/2007 10:25:10 AM  
  Responsibility: Gina Accawi   Entered By: Gina Accawi  
  Type: Suggestion   Build Reviewed: 2007-05-14  
  Addressed By: Gina Accawi   Addressed In: Next Build  
  Synopsis: Add attribute to email for type: Agent, MLS, Consumer...
  Description: Do we have a full list of the types of email desired?  



#20 Status: Fixed   Severity: Medium  
  Modified Time: 7/5/2007 11:53:24 AM   Entered On: 6/12/2007 10:24:30 AM  
  Responsibility: Gina Accawi   Entered By: Gina Accawi  
  Type: Suggestion   Build Reviewed: 2007-05-14  
  Addressed By: Gina Accawi   Addressed In: Next Build  
  Synopsis: Make email a sequence.
  Description: A sequence of what? Repeatable email element sequence? Sequence with the type and category sort of information like the model suggested for phone?  



#19 Status: Fixed   Severity: Medium  
  Modified Time: 6/14/2007 11:10:20 AM   Entered On: 6/12/2007 10:23:38 AM  
  Responsibility: Gina Accawi   Entered By: Gina Accawi  
  Type: Suggestion   Build Reviewed: 2007-05-14  
  Addressed By: Gina Accawi   Addressed In: Next Build  
  Synopsis: Add website element to agent schema.
  Description: I see in the contact information, Phone.xsd, the website was pulled from there in the past. Does it indeed belong in the Agent information or should it be in Person or Phone?  



#17 Status: Fixed   Severity: Medium  
  Modified Time: 6/13/2007 1:24:09 PM   Entered On: 6/12/2007 10:21:50 AM  
  Responsibility: Gina Accawi   Entered By: Gina Accawi  
  Type: Suggestion   Build Reviewed: 2007-05-14  
  Addressed By: Gina Accawi   Addressed In: Next Build  
  Synopsis: Add phone type enumeration. Add phone category enumeration.
  Description: Phone types suggested: Voice, Fax, Pager, SMS, TTY, Other.
Phone categories suggested: Office, Mobile, Home, Assistant, Team, Event, Conference, Other.
 



#16 Status: Fixed   Severity: Medium  
  Modified Time: 6/12/2007 2:10:16 PM   Entered On: 6/12/2007 10:20:04 AM  
  Responsibility: Gina Accawi   Entered By: Gina Accawi  
  Type: Defect   Build Reviewed: 2007-05-14  
  Addressed By: Gina Accawi   Addressed In: Next Build  
  Synopsis: If an element comes from NRDS commons, change the name to include NRDS in the name.
  Description:    



#15 Status: Fixed   Severity: Medium  
  Modified Time: 7/5/2007 11:51:51 AM   Entered On: 6/12/2007 10:19:21 AM  
  Responsibility: Gina Accawi   Entered By: Gina Accawi  
  Type: Suggestion   Build Reviewed: 2007-05-14  
  Addressed By: Gina Accawi   Addressed In: Next Build  
  Synopsis: In addition to showing number, add preferred phone number associated with agent and a listing.
  Description: If the model for contact information is changed from:

HomePhone
OfficePhone
CellPhone

to
Phone
Home
Phone
Office
Phone
Cell

Having a PreferredPhone seems to conflict with the model suggested. Or, perhaps the order in which the Phone element appears indicates preference? Or, perhaps the preferred phone is indicated with an attribute, preferred="true".

 



#14 Status: Fixed   Severity: Medium  
  Modified Time: 7/5/2007 11:51:14 AM   Entered On: 6/12/2007 10:18:27 AM  
  Responsibility: Gina Accawi   Entered By: Gina Accawi  
  Type: Suggestion   Build Reviewed: 2007-05-14  
  Addressed By: Gina Accawi   Addressed In: Next Build  
  Synopsis: Add showing number, telephone number for reservations for showing times, to schema. Associated with an agent.
  Description: Does this conflict with the suggestion on the category for phone in any way? Should the categories include showing? Should the category concept be dropped in favor of element names as previous model?  



#13 Status: Fixed   Severity: Medium  
  Modified Time: 7/5/2007 5:14:55 PM   Entered On: 6/12/2007 10:17:25 AM  
  Responsibility: Gina Accawi   Entered By: Gina Accawi  
  Type: Suggestion   Build Reviewed: 2007-05-14  
  Addressed By: Paul Stusiak   Addressed In: Next Build  
  Synopsis: Create PlanarDimemsions to contain repeat elements
  Description: The Area, Dimension, Length and Width are repeated in several places. Create a PlanarDimensions to contain them.  



#39 Status: As Designed   Severity: Medium  
  Modified Time: 6/25/2007 10:13:27 AM   Entered On: 6/12/2007 1:28:14 PM  
  Responsibility: Gina Accawi   Entered By: Gina Accawi  
  Type: Suggestion   Build Reviewed: 2007-05-14  
  Addressed By: Gina Accawi   Addressed In:    
  Synopsis: Why is there both a PrimaryAssociationId and a PrimaryStateAssociationId?
  Description: In the June Westlake meeting, group consensus was that there are indeed two different pieces of information being captured by these elements making them both needed and not redundant.  



#38 Status: As Designed   Severity: Medium  
  Modified Time: 7/4/2007 4:13:16 PM   Entered On: 6/12/2007 1:27:34 PM  
  Responsibility: Gina Accawi   Entered By: Gina Accawi  
  Type: Suggestion   Build Reviewed: 2007-05-14  
  Addressed By: Paul Stusiak   Addressed In:    
  Synopsis: MLSAssociation cardinality needs to be mandatory.
  Description: PS can the assumption that every location has an MLSAssociationId be true? Otherwise, the license needs to be tied to a specific location, probably ProvinceOrState.  



#95 Status: In Progress   Severity: Medium  
  Modified Time: 7/4/2007 4:20:55 PM   Entered On: 6/22/2007 1:48:31 PM  
  Responsibility: Paul Stusiak   Entered By: Gina Accawi  
  Type: Defect   Build Reviewed: 2007-05-14  
  Addressed By:     Addressed In:    
  Synopsis: Revise the Parking complexType.
  Description: Remove the garage, carport, etc. specific types for Parking. Create type enumeration include oversized, commercial. Matt L will send the possible types with definitions. Joshua will also send his. HasParking goes with the isPresent discussion that we had earlier. Will have total. Add description at the parking level. Financials: Leased, owns, rents, deeded, fees, conveys. Change area to use the area type.  



#49 Status: In Progress   Severity: Medium  
  Modified Time: 7/5/2007 4:46:27 PM   Entered On: 6/12/2007 3:12:32 PM  
  Responsibility: Paul Stusiak   Entered By: Gina Accawi  
  Type: Defect   Build Reviewed: 2007-05-14  
  Addressed By:     Addressed In:    
  Synopsis: Use the commons Parking type, needs a subtype of ShortParking.
  Description:    



#85 Status: Open   Severity: Medium  
  Modified Time: 6/29/2007 1:06:55 PM   Entered On: 6/22/2007 1:38:24 PM  
  Responsibility:     Entered By: Gina Accawi  
  Type: Defect   Build Reviewed: 2007-05-14  
  Addressed By:     Addressed In:    
  Synopsis: Ensure all enums have none as possible value. No nullable enums. For container amenities, add flag boolean yes no attribute. If the amenity presence is unknown/not filled out DO NOT SEND THE ELEMENT. We won't allow nulls in order to keep this clear.
  Description:    



#74 Status: Open   Severity: Medium  
  Modified Time: 6/29/2007 1:05:43 PM   Entered On: 6/22/2007 12:41:57 PM  
  Responsibility: Gina Accawi   Entered By: Gina Accawi  
  Type: Defect   Build Reviewed: 2007-05-14  
  Addressed By:     Addressed In:    
  Synopsis: Remove all the various and sundry remarks types. Reuse a common remarks type.
  Description:    



#63 Status: Open   Severity: Medium  
  Modified Time: 6/28/2007 7:06:44 AM   Entered On: 6/22/2007 11:55:42 AM  
  Responsibility:     Entered By: Gina Accawi  
  Type: Defect   Build Reviewed: 2007-05-14  
  Addressed By:     Addressed In:    
  Synopsis: Change the documentation for the Id to no longer indicate uniqueness.
  Description:    



#18 Status: Open   Severity: Medium  
  Modified Time: 6/29/2007 1:09:24 PM   Entered On: 6/12/2007 10:22:20 AM  
  Responsibility: Gina Accawi   Entered By: Gina Accawi  
  Type: Suggestion   Build Reviewed: 2007-05-14  
  Addressed By:     Addressed In:    
  Synopsis: Remove broker name from agent schema.
  Description: Broker name is in the ShortOffice complexType definition. It is used in other places, most notably within the Office information. Should the broker name be removed in all cases? Why should it be removed?  



#105 Status: New   Severity: Medium  
  Modified Time: 7/6/2007 8:25:09 AM   Entered On: 7/6/2007 8:25:09 AM  
  Responsibility:     Entered By: Paul Stusiak  
  Type: Defect   Build Reviewed: 2007-05-14  
  Addressed By:     Addressed In:    
  Synopsis: Remove Mortgage type definition and use Mortgage defined in commons namespace.
  Description:    



#98 Status: New   Severity: Medium  
  Modified Time: 7/3/2007 1:05:49 AM   Entered On: 6/26/2007 1:44:58 PM  
  Responsibility:     Entered By: Gina Accawi  
  Type: Defect   Build Reviewed: 2007-05-14  
  Addressed By:     Addressed In:    
  Synopsis: Update the build files for Team, Listing and Property changes
  Description:    



#93 Status: New   Severity: Medium  
  Modified Time: 6/22/2007 1:45:41 PM   Entered On: 6/22/2007 1:45:41 PM  
  Responsibility:     Entered By: Gina Accawi  
  Type: Defect   Build Reviewed: 2007-05-14  
  Addressed By:     Addressed In:    
  Synopsis: Add WindowTreatment under Windows. Make it a string.
  Description:    



#83 Status: New   Severity: Medium  
  Modified Time: 6/22/2007 1:36:46 PM   Entered On: 6/22/2007 1:35:57 PM  
  Responsibility:     Entered By: Gina Accawi  
  Type: Defect   Build Reviewed: 2007-05-14  
  Addressed By:     Addressed In:    
  Synopsis: Need to handle items that are relevant for communities or multi-family. Like AnimalPolicy, Laundry.
  Description:    



#81 Status: New   Severity: Medium  
  Modified Time: 6/22/2007 1:35:14 PM   Entered On: 6/22/2007 1:35:14 PM  
  Responsibility:     Entered By: Gina Accawi  
  Type: Defect   Build Reviewed: 2007-05-14  
  Addressed By:     Addressed In:    
  Synopsis: Made a suggestion to reverse the category to a top-level container holding the participants.
  Description:    



#79 Status: New   Severity: Medium  
  Modified Time: 6/22/2007 1:34:34 PM   Entered On: 6/22/2007 1:34:34 PM  
  Responsibility:     Entered By: Gina Accawi  
  Type: Defect   Build Reviewed: 2007-05-14  
  Addressed By:     Addressed In:    
  Synopsis: Add a flag to indicate primary agent for listing and selling. Could be within the team and within members. Make entry top level, allow only member.
  Description:    



#76 Status: New   Severity: Medium  
  Modified Time: 7/3/2007 1:07:16 AM   Entered On: 6/22/2007 1:26:49 PM  
  Responsibility:     Entered By: Gina Accawi  
  Type: Defect   Build Reviewed: 2007-05-14  
  Addressed By:     Addressed In:    
  Synopsis: Add element for HDC 433 manufactured home legal notice.
  Description: Research what information is required. Perhaps just an element of type string.

<ps 20070603>
See HUD website and search for Manufactured Home Permanent Foundation Certificate
</ps>

 



#75 Status: New   Severity: Medium  
  Modified Time: 6/22/2007 1:22:38 PM   Entered On: 6/22/2007 1:22:38 PM  
  Responsibility:     Entered By: Gina Accawi  
  Type: Defect   Build Reviewed: 2007-05-14  
  Addressed By:     Addressed In:    
  Synopsis: Check usage of secure types to make sure they are all sensible. FireplaceDetails probably does not need to be a SecureString.
  Description:    



#73 Status: New   Severity: Medium  
  Modified Time: 7/4/2007 11:23:06 AM   Entered On: 6/22/2007 12:22:04 PM  
  Responsibility:     Entered By: Gina Accawi  
  Type: Suggestion   Build Reviewed: 2007-05-14  
  Addressed By:     Addressed In:    
  Synopsis: Create and keep fresh an entity relationship diagram for the schemas.
  Description:    



#72 Status: New   Severity: Medium  
  Modified Time: 6/22/2007 1:25:42 PM   Entered On: 6/22/2007 12:18:54 PM  
  Responsibility:     Entered By: Gina Accawi  
  Type: Defect   Build Reviewed: 2007-05-14  
  Addressed By:     Addressed In:    
  Synopsis: Go through and provide logical ordering and grouping of elements within the schemas for ease of understanding and organization. Due by next week, June 30.
  Description:    



#69 Status: New   Severity: Medium  
  Modified Time: 6/22/2007 12:05:47 PM   Entered On: 6/22/2007 12:05:47 PM  
  Responsibility:     Entered By: Gina Accawi  
  Type: Defect   Build Reviewed: 2007-05-14  
  Addressed By:     Addressed In:    
  Synopsis: Come up with plan for handling community information: Senior, planned, with amenities.
  Description:    



#68 Status: New   Severity: Medium  
  Modified Time: 6/22/2007 12:01:57 PM   Entered On: 6/22/2007 12:01:57 PM  
  Responsibility:     Entered By: Gina Accawi  
  Type: Defect   Build Reviewed: 2007-05-14  
  Addressed By:     Addressed In:    
  Synopsis: ListingArea needs to move to the Property. Rename to MLSArea.
  Description:    



#61 Status: New   Severity: Medium  
  Modified Time: 6/22/2007 11:53:53 AM   Entered On: 6/22/2007 11:53:53 AM  
  Responsibility:     Entered By: Gina Accawi  
  Type: Defect   Build Reviewed: 2007-05-14  
  Addressed By:     Addressed In:    
  Synopsis: OfficeContactManager data type should be the MemberId rather than SecureString.
  Description:    



#59 Status: New   Severity: Medium  
  Modified Time: 7/5/2007 1:44:26 PM   Entered On: 6/22/2007 11:32:35 AM  
  Responsibility:     Entered By: Gina Accawi  
  Type: Defect   Build Reviewed: 2007-05-14  
  Addressed By:     Addressed In:    
  Synopsis: Modify GeographicData model to include coordinate system.
  Description: Details listed on Description tab. Also, add Source and Accuracy.
Make GeographicData extend the BaseGeographicData rather than containing it.

<GeographicData>
<MapBook/>
<Latitude/>
<Longitude/>
<Elevation/>
<CoordinateSystem repeatable>
<easting>
<northing>
<height>
</CoordinateSystem>
</GeographicData>

 



#50 Status: New   Severity: Medium  
  Modified Time: 6/13/2007 12:52:05 PM   Entered On: 6/13/2007 12:52:05 PM  
  Responsibility:     Entered By: Gina Accawi  
  Type: Suggestion   Build Reviewed: 2007-05-14  
  Addressed By:     Addressed In:    
  Synopsis: There are a couple of elements defined in RETSCommons that refer to NRDS items. AssociationOfficeId and AssociationMemberId. In some of the places they are used the elements are named things like NRDSOfficeId. Should the types be moved to the NRDSCommons rather than RETSCommons? With renaming all the elements using NRDS types to use NRDS in the name, I found these couple of elements with NRDS in the name defined in RETSCommons and think this wasn't confusing before, but may be now...
  Description:    



#48 Status: New   Severity: Medium  
  Modified Time: 6/12/2007 3:07:59 PM   Entered On: 6/12/2007 3:07:59 PM  
  Responsibility:     Entered By: Gina Accawi  
  Type: Suggestion   Build Reviewed: 2007-05-14  
  Addressed By:     Addressed In:    
  Synopsis: For the SystemOfficeGUId: How should we handle the case where there is a visibility restriction on the Globally Unique Identifier? A SecureString - the base definition of commons:OfficeId, may not suffice.
  Description:    



#47 Status: New   Severity: Medium  
  Modified Time: 6/12/2007 3:03:40 PM   Entered On: 6/12/2007 3:03:40 PM  
  Responsibility:     Entered By: Gina Accawi  
  Type: Defect   Build Reviewed: 2007-05-14  
  Addressed By:     Addressed In:    
  Synopsis: Remove REPI elements: InteriorDetails, Fireplace, Windows, WallMaterials, Insulation from the Room complexType definition.
  Description:    



#46 Status: New   Severity: Medium  
  Modified Time: 6/12/2007 3:08:23 PM   Entered On: 6/12/2007 3:01:47 PM  
  Responsibility:     Entered By: Gina Accawi  
  Type: Defect   Build Reviewed: 2007-05-14  
  Addressed By:     Addressed In:    
  Synopsis: What is the purpose of the Query complexType? And, why doesn't it have a type?
  Description:    



#44 Status: New   Severity: Medium  
  Modified Time: 6/12/2007 2:54:06 PM   Entered On: 6/12/2007 2:54:06 PM  
  Responsibility:     Entered By: Gina Accawi  
  Type: Defect   Build Reviewed: 2007-05-14  
  Addressed By:     Addressed In:    
  Synopsis: The Units element appears to be defined wrong.
  Description:    



#43 Status: New   Severity: Medium  
  Modified Time: 6/12/2007 3:01:56 PM   Entered On: 6/12/2007 2:49:02 PM  
  Responsibility:     Entered By: Gina Accawi  
  Type: Suggestion   Build Reviewed: 2007-05-14  
  Addressed By:     Addressed In:    
  Synopsis: Provide better description for the EntryId.
  Description:    



#42 Status: New   Severity: Medium  
  Modified Time: 6/12/2007 2:44:54 PM   Entered On: 6/12/2007 2:44:54 PM  
  Responsibility:     Entered By: Gina Accawi  
  Type: Suggestion   Build Reviewed: 2007-05-14  
  Addressed By:     Addressed In:    
  Synopsis: Confirm description for the AssociationId in Associations.xsd.
  Description:    



#41 Status: New   Severity: Medium  
  Modified Time: 6/12/2007 2:39:32 PM   Entered On: 6/12/2007 2:39:32 PM  
  Responsibility:     Entered By: Gina Accawi  
  Type: Defect   Build Reviewed: 2007-05-14  
  Addressed By:     Addressed In:    
  Synopsis: For the SystemId Activity element, should we make this SystemGUId to indicate that it is the key?
  Description:    



#40 Status: New   Severity: Medium  
  Modified Time: 6/12/2007 2:38:33 PM   Entered On: 6/12/2007 2:38:33 PM  
  Responsibility:     Entered By: Gina Accawi  
  Type: Defect   Build Reviewed: 2007-05-14  
  Addressed By:     Addressed In:    
  Synopsis: Are we missing a necessary connection between this activity and the listingGUId or listingId and the transactionGUId or transactionId? Both are in the Vocabulary document but are missing from this schema.
  Description:    



#37 Status: New   Severity: Medium  
  Modified Time: 6/12/2007 11:00:21 AM   Entered On: 6/12/2007 11:00:21 AM  
  Responsibility:     Entered By: Gina Accawi  
  Type: Suggestion   Build Reviewed: 2007-05-14  
  Addressed By:     Addressed In:    
  Synopsis: Should agent role be removed? Should it be put into transaction schema?
  Description:    



#30 Status: New   Severity: Medium  
  Modified Time: 7/4/2007 4:13:49 PM   Entered On: 6/12/2007 10:51:25 AM  
  Responsibility:     Entered By: Gina Accawi  
  Type: Suggestion   Build Reviewed: 2007-05-14  
  Addressed By:     Addressed In:    
  Synopsis: Need to handle deleting of agents.
  Description:    



#26 Status: New   Severity: Medium  
  Modified Time: 6/12/2007 10:47:27 AM   Entered On: 6/12/2007 10:47:27 AM  
  Responsibility:     Entered By: Gina Accawi  
  Type: Suggestion   Build Reviewed: 2007-05-14  
  Addressed By:     Addressed In:    
  Synopsis: Check namespace for NRDS and references to NRDS namespace in agents.xml instance document.
  Description:    



#12 Status: New   Severity: Medium  
  Modified Time: 6/12/2007 10:57:20 AM   Entered On: 6/12/2007 10:16:34 AM  
  Responsibility:     Entered By: Gina Accawi  
  Type: Suggestion   Build Reviewed: 2007-05-14  
  Addressed By:     Addressed In:    
  Synopsis: Investigate Caribbean postal information for inclusion in address information. Kristen Carr volunteered to do this investigation at the previous May RETS meeting, followup with her before conducting investigation would be prudent.
  Description:    


Total: 95