Purge Orphan Entries

Purge Load Orphan Entries is initiated from the Supplementary Purge using Request Type "POE".

This function will remove unreferenced entries in:

  • Restrictions table (RSTC_T)
  • Business Hours (BUS_HRS_T)
  • Address Table (ADDR_T)

Note that, for this purge, the Cut-off Date will not apply.

Restrictions Table

Purge routine will remove unreferenced Restrictions (RSTC_T) entries. The following tables reference RSTC_T entries:

  • Tariff Service (TFF_SRVC_T)
  • Tariff Lane (LANE_ASSC_T)
  • Tariff Service Equipment Type (TFF_SRVC_EQMT_T)

Business Hours

Purge routine will remove unreferenced Business Hours (BUS_HRS_T) entries. The following tables reference BUS_HRS_T entries:

  • Domicile (DMCL_T)
  • Carrier (CARR_T)
  • Customer (CUST_T)
  • Logistics System (LGST_SYS_T)
  • Load-at (LDAT_T)
  • Consignee (CNSE_T)
  • Distribution Center (DC_T)
  • Hub (HUB_T)
  • Dock (DOCK_T)
  • Tariff Service (TFF_SRVC_T)
  • Delivery Schedule (DLVY_SCHD_T)
  • Itinerary (ITNR_T)
  • Zone (ZN_T)

Address Table

Purge routine will remove unreferenced ADDR_T entries. Since there is no automatic deletion of these entries at any time, and also no update capability, there is a potential for a large number of "orphaned" Address records.

The following table lists all the static and transactional entities containing foreign keys to ADDR_T:

Entity

Table

Setup

Global Defaults

LGST_SYS_T

Customer

CUST_VER_T

Carrier

CARR_T

Salesperson

SALE_PERS_T

Distribution Center

DC_T

Hub

HUB_T

Load-At

LDAT_T

Consignee

CNSE_T

Domicile

DMCL_T

Division

DIV_T

Transactions

Shipments

SHPM_T

Shipment Legs

LD_LEG_DETL_T

Loads

LD_LEG_T

Stops

STOP_T

Non Operational Freight

NON_OP_FRHT_T

Non Operational Freight Stop

NON_OP_STOP_T

Rate Quotation

RATE_QTE_T

Rate Quotation Itinerary

RATE_QTE_ITNR_T

Rate Quotation Schedule

RATE_QTE_SCH D_T

The purge routine will review each row in ADDR_T and remove those that are not referenced by any of the entities listed above.

See Also