Purge Domicile Equipment Types and Vehicle Availability

Purge Domicile Equipment Types and Vehicle Availability is initiated from the Supplementary Purge using Request Type "DMCL".

This function will perform the following steps in the designated sequence:

• Remove entries in DMCL_VHCL_AVBLTY_T where the date portion of the Must End By Date/Time is prior to the Cut-Off Date.
• Remove entries in VHCL_SEQ_T that refer to a Domicile / Equipment Type / Vehicle ID / Sequence Number combination for which there is no longer a corresponding row in DMCL_VHCL_AVBLTY_T.
• Remove entries in DMCL_EQMT_T where the date portion of the Must Start By Date/Time is prior to the Cut-Off Date and there are no remaining rows in DMCL_VHCL_AVBLTY_T that refer to the Domicile / Equipment Type combination referenced by the Domicile Equipment entry.