Section 15: Sanctions & Audit Infrastructure Tables

Staging table for OFAC's Non-SDN Consolidated Sanctions list — specifically the vessel entries. Non-SDN sanctions include sectoral sanctions (SSI list), the Palestinian Legislative Council (PLC) list, and other programme-specific lists that do not constitute full asset freezes. The table receives periodic updates from OFAC's published data.

Staging table for OFAC's Specially Designated Nationals list — specifically the company and individual owner entries. The SDN list is the most restrictive US sanctions instrument; entities on this list are subject to asset freezing and US persons are prohibited from transacting with them.

The tblOFAC_*_MASTERLOAD tables hold the output of running ABSD_ company and vessel records against the OFAC SDN and Non-SDN staging tables via Levenshtein name matching. The schema is analogous to the tblMIRS_*_MASTERLOAD tables documented in Section 13.

Key OFAC MASTERLOAD Tables

MASTERLOAD Column Schema

The SDDB (Salvage and Demolition Database) tables hold data on vessels sold for scrapping or demolished, sourced from ship recycling yards and broker reports. The data feeds the scrap price triangle stored in SUPPLEMENTAL_ABSD_HITL (documented in Section 09) and provides intelligence on end-of-life vessel dispositions.

SDDB_COMBINED_NOTATION

SDDB Table Family (13 tables)

The primary field-level audit table for the ABSD_ database. Every time a trigger fires and modifies vessel or company data, the trigger writes one or more rows to tblChanges capturing the change metadata. This table is the definitive record of who changed what, when, and from what source.

Key Query Patterns

-- All changes to a vessel in the last 30 days
SELECT ChangeType, EffDate, UserInitials, Source, SourceRef
FROM   tblChanges
WHERE  LRNo = '1234567'
  AND  EffDate >= DATEADD(day, -30, GETDATE())
ORDER BY EffDate DESC;

-- Count changes by source in the last 7 days
SELECT Source, COUNT(*) AS Changes
FROM   tblChanges
WHERE  EffDate >= DATEADD(day, -7, GETDATE())
GROUP BY Source
ORDER BY Changes DESC;

Complementary audit table to tblChanges. While tblChanges records field-level data changes, tblAnnotationLogGeneral records analyst annotations — notes, comments, and workflow state changes attached to vessel or company records. This table supports the annotation system documented in Section 12d (spAnnotateChange, spWriteAnnotation*).

Tracks which vessels have an active Sales Page record in the Fairplay Ship World (FSW) commercial publication system. When a vessel appears on the FSW sales platform (vessels available for purchase, charter, or scrapping), this table is updated to flag that status in the ABSD_ record. The flag drives FSW-specific fields in downstream views.