DerivedCompCharacteristic:
DerivedCompCharacteristic contains the characteristic information of a compartment, which is implicitly derived based on the current occupant.
When an implicitly derived characteristic is added to a compartment by a Resource Manager, a record is created at that point in the Characteristic table only, for the relevant the characteristic category, e.g. Gender, Religion. This record will have an Apply Type to indicate the desired behavior when a second client is to be placed in the compartment.
When a client is placed into an empty compartment with such a record associated with it, a record is at that point created in the DerivedCompartmentCharacteristic table. This record will store the value for the client of the relevant characteristic category. For example, if the category for the compartment is Gender, and the client being placed is male, then a record will be created with a characteristic code of Male.
This design facilitates searching of suitable compartments by physically storing a record corresponding to an implicitly derived characteristic. It will be necessary for the record in the DerivedCompCharacteristic table to be removed when the last placement in the compartment ends.
While data model support is provided for characteristics to be derived based on Reservations, there is no recommended best practice at this stage to implement them, as the requirements around deriving characteristics based on Reservations haven’t been fully analysed.
|