Data Structure

FOCUS is structured with multiple tables to increase efficiency.

The Main Tables and their subsequent identifiers include:

CLIENT INFORMATION – the main record identifier is “CID” or Client Identification – ideally, every client will only have one CID.  ie, James Brown of Anytown, California has a CID of 12.  At some point in the future, James Brown may come to visit your location a year after his initial visit.  Your reservation agent may not search for a previous entry (by phone, name, address, or even email) so James Brown will be assigned a new CID of 152.  In order for proper client tracking, the staff must be do searches on clients to make sure they don’t have and existing record in the system.

RESERVATION – the main record identifier is “RID” or Reservation Identification.  An RID tracks each reservation (or tour booking) a client has. Each CID can have multiple RIDs in the system – one for each reservation booked.  Ie, James Brown (CID 12) originally booked a tour on 1/1/2012 which he gets an RID of 511 that he no shows for.  A year later, James Brown books another tour under CID 152 and gets and RID of 612 that he no shows for.  He then books into RID 613.  RID 613 that he shows for is which CID / RID combination any sale needs associated with.

SALES – the main record identifier is “SID” or Sales Identification.  A SID tracks each sales contract written.  The SID requires a connection to a CID and an RID.  ie, James Brown (CID 152) tours under RID 613.  James Brown purchases a timeshare product and has an SID of 70.  SID 70 is now linked with CID 152 and RID 613.

Flow Chart - CID RID SID

INVENTORY – the main record identifier is IID or Inventory Identification.  an IID tracks each piece of inventory sold to a client.  This can be unique timeshare inventory, trackable club inventory, or any other piece of inventory that needs to be managed.  An IID that is sold only connects to the SID – in the case above, IID 5 is connected to SID 70.

These are the primary links that generate the majority of the reporting structure within FOCUS.  As long as these relationships are in tact, with proper data entry training, the reports within FOCUS should be reliable.