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.