Reference Tables — LR Maritime Database

ABSD_CAGE1 — Casualty/Incident Primary Record

PK: LRNO + INNO. Each incident record. DISP distinguishes casualty (C), demolition (D/X), or both.

Column	Type	Description
`LRNO`	nvarchar(7)	Vessel LR number
`INNO`	varchar(7)	Incident number (zero-padded, exactly 5 chars when set)
`DISP`	varchar(2)	Disposition: C=Casualty, D=Demolished, X=Both, blank=none
`REM`	varchar(1)	Removal from scene — required when DISP='C' or 'X'
`STD`	varchar(8)	Incident start date (YYYYMMDD)
`ENDD`	varchar(8)	Incident end date
`STDS`	varchar(2)	Start date source (validated against CBUB1 table 20)
`STCS`	varchar(2)	Start circumstance code (validated against CBUB1 table 22)
`KNO`	varchar(7)	Key number cross-reference (null or exactly 5 chars)
`OLR_1`	varchar(7)	Other vessel LR number 1 involved in incident
`OLR_2`	varchar(7)	Other vessel LR number 2
`OLR_3`	varchar(7)	Other vessel LR number 3
`FLAG`	varchar(3)	Vessel flag at time of incident
`STYP`	varchar(20)	Vessel type at time of incident
+ 50+ additional columns for detailed casualty information

Trigger business rules: OLR_1/2/3 set → automatically creates matching CAGE1 records for other vessels involved • DISP='D' or 'X' (demolition): CADI disposal record created/verified, SUPPLEMENTAL_ABSD_CADI also updated • DISP='C': if CADI record exists, it is deleted (casualty and disposal marker mutually exclusive) • Cannot set DISP='C' if CADI disposal record already exists

ABSD_CADI — Casualty Detail / Disposal Information

Column	Type	Description
`LRNO`	varchar(7)	Vessel LR number
`INNO`	varchar(7)	Incident number
`MD`	varchar(1)	Mode: D=Draft, T=Total, S=Scrapped
`TOBE`	varchar(1)	To-be indicator
`BKCD`	varchar(7)	Ship breaker/port code
`SVPT`	varchar(3)	Salved point code
`SBKR`	varchar(9)	Ship breaker company code
`BKR`	varchar(36)	Breaker details narrative
`ZONE`	varchar(2)	Geographic zone
`MG`	varchar(3)	Management group code
`DATE_1`	varchar(8)	Primary date (YYYYMMDD)
`DATE_2`	varchar(8)	Secondary date
`DATE_3`	varchar(8)	Tertiary date
`AMNT`	varchar(10)	Financial amount
`TEXT_1`	varchar(58)	Casualty description text line 1
`TEXT_2`	varchar(58)	Casualty description text line 2
`TEXT_3`	varchar(58)	Casualty description text line 3

ABSD_CALA — Casualty Address / Location Detail

Updated automatically by ABSD_CAGE1_Update trigger when STD or LRNO changes. Sets EDITOR (user initials) and EDIT_DATE (YYYYMMDD) automatically. Contains geographic location where incident occurred.

Other CA* Tables

Table	Description
`ABSD_CAGE2`	Casualty age group detail — secondary event grouping
`ABSD_CACO`	Casualty company associations
`ABSD_CACT`	Casualty contact information
`ABSD_CAGC`	Casualty age/size groups
`ABSD_CAPO`	Casualty port/location
`ABSD_CAPR`	Casualty property details

ABSD_CBUB1 — Universal Code Book (Multi-purpose Lookup)

The most-referenced code table in the database. Multiple lookup domains distinguished by FLDI.

Column	Type	Description
`FLDI`	varchar(2)	Field/domain identifier
`CODE`	varchar(20)	Code value within domain
`HMKR`	nvarchar(1)	Historical marker
`WMKR`	nvarchar(1)	Withdrawal marker: W=withdrawn (prevents update)
`TRUD`	nvarchar(30)	True description (internal decode text)
`PUBD`	nvarchar(30)	Published description (public decode text)
`MK01–MK30`	nvarchar(1) each	30 attribute marker flags
`APSProperTrud`	varchar(30)	APS proper-case version of TRUD

Key FLDI domains: 01=Stowage codes • 02=Commodity codes • 03=Prime mover position codes (validated in HIGE) • 19=Generator supertype codes • 20=Casualty start date source • 22=Casualty circumstance codes • 42=Hull section codes (validated in OVNA) • 57=Casualty type codes (validated in OVCS) • 92=Ship type codes

ABSD_CBCY — Country Code Book

Column	Type	Description
`CNTRY`	nvarchar(3)	3-char country code (LR internal code)
`NAME`	nvarchar(50)	Country name
`PUBNAME`	nvarchar(50)	Published country name
`ISO2`	nvarchar(2)	ISO 3166-1 alpha-2 country code
`MK01–MK20`	nvarchar(1) each	20 binary attribute markers

Country attribute markers (MK01–MK20) encode: EU membership • NATO membership • OECD membership • Flag of convenience designation • Sanctions status • Regional groupings (Americas, Asia, etc.) • Port State Control MOU membership. Note: EDM.dbo.T_REF_COUNTRY is the preferred source in views; CBCY is the ABSD fallback.

ABSD_CBCOROOT — Company/Builder Root Record

Master record for companies and shipbuilders. OUT_TYPE determines entity type processing.

Column	Type	Description
`OWCODE`	varchar(7)	Owner/company code (links to ABSD_OWGE)
`OUT_TYPE`	varchar(1)	Entity type: F=Flag code, T=Type table, S=Shipbuilder, A=Address
`OUT_STATUS`	varchar(1)	Status: T=Trading, N=Non-trading, W=Withdrawn
`OUT_SHORT_NAME`	varchar(30)	Short name (normalized to proper case in SUPPLEMENTAL_ABSD_CBCOROOT)

Subsidiary tables: ABSD_CBCONAME (company names) • ABSD_CBCOCOMM (phone/fax/email/telex/web) • ABSD_CBCOADDR (address lines) • ABSD_CBCONOTE (notes, location seq 10–19, history seq 20–49). Trigger processing: Type F→updates CBEB; Type T→updates CBSB + BLDR_TEXT A/P; Type S→updates BLDR_NAME/BLDR_TEXT H/N, parses BLDR_XREF (70-char field → 10×6-char builder codes); Type A→address lines.

ABSD_CBPPROOT — Port / Place Root Record

Column	Type	Description
`KEY`	varchar(7)	7-char port key (must be exactly 7 chars — trigger enforced)
`OUT_LLP_PORT_CODE`	varchar(10)	Grid reference (must be unique if populated)
`CNTRY`	varchar(3)	Country code

Trigger automatic sync: ABSD_CBTO1 (town: name split at 19-char boundary into TNS1/TNS2) • ABSD_CBPD (coordinates, Marsden grid via fnMarsdenGrid, SIS zone via fnSISZone, lat/long degree/minutes/N-S/E-W components). Subsidiary tables: ABSD_CBPPNAME, ABSD_CBPPNOTE, ABSD_CBPPSTRE, ABSD_CBPPSRCH (port search index).

ABSD_CBSB — Shipbuilder Code Book

Column	Type	Description
`KEYC`	varchar(3)	Country component
`KEYG`	varchar(3)	Geographic component
`KEYN`	varchar(3)	Name component
`KEYX`	varchar(3)	Extension component
`DECODEA`	varchar(70)	Shipbuilder long name part A
`DECODEB`	varchar(70)	Shipbuilder long name part B
`SBCountryCode`	varchar(3)	Country of shipbuilder

SBLDR_CMP in ABSD_OVGE = concatenation of KEYC+KEYG+KEYN+KEYX (9 chars total).

Other CB* Reference Tables

Table	Description	Primary Use
`ABSD_CBEB`	Engine/boiler manufacturer codes	HIGE trigger validation (E45_GM field)
`ABSD_CBED`	Engine design codes	Engine design lookup
`ABSD_CBFT`	Fuel type codes	Fuel classification
`ABSD_CBIC`	IMO chemical class codes	Chemical tanker classification (TANKER trigger)
`ABSD_CBMG`	Management group codes	Group fleet categorization
`ABSD_CBPD`	Port details (coordinates, grid refs)	Geographic lookups, maintained by CBPPROOT trigger
`ABSD_CBPI`	P&I club codes	Insurance classification
`ABSD_CBPT`	Port type codes	Port function classification
`ABSD_CBSC, CBSC2`	Service codes	Service classification
`ABSD_CBSF`	Source/filing reference codes	Data provenance
`ABSD_CBTO1`	Town master	Town name lookup, maintained by CBPPROOT trigger
`ABSD_CBLOOKUPS`	General lookup table	Ad-hoc code lookups

ABSD_OWGE — Owner / Company General Data

Master company entity record. PK: OWCODE varchar(7).

Column	Type	Description
`OWCODE`	varchar(7)	Unique company/owner identifier
`SHNAME`	varchar(30)	Short name of company
`GROUP_OWGE`	varchar(1)	Group type: A=Group owner, M=Management co, B=Both
`TITLE1`	varchar(2)	Primary company role (BO=Beneficial Owner, etc.)
`NATY1`	varchar(3)	Nationality code 1
`NATY2`	varchar(3)	Nationality code 2
`CONF`	varchar(1)	Confidence indicator — drives HIPP/HITP dual certification path

GROUP_OWGE='A' companies are treated differently in the HIOW trigger for dual certification path (HIPP vs HITP assignment). See Triggers §HIOW for full logic.

ABSD_OWNA — Owner Name History

Column	Type	Description
`OWCODE`	varchar(7)	Owner code
`SEQNOA`	varchar(2)	Name sequence
`SEQNOD`	varchar(2)	Sub-sequence
`RBNMSTYL_NAMSTYL_1`	varchar(140)	Name part 1
`NAMSTYL_2`	varchar(140)	Name part 2

ABSD_OWAD1 / ABSD_OWAD2 — Owner Address (Primary / Secondary)

Column	Type	Description
`OWCODE`	varchar(7)	Owner code
`SEQNO`	varchar(2)	Address sequence (00=current)
`TYPE`	varchar(1)	A=Correspondence, B=Technical, C=Care-of
`CNTRY`	varchar(3)	Country code
`TOWN`	varchar(4)	Town code
`LINE1–LINE4`	varchar(40) each	Address free-text lines
`POSTCODE`	varchar(10)	Postal code

ABSD_OWSH — Owner-to-Ship Relationship

Column	Type	Description
`SHLRNO`	varchar(7)	Ship LR number
`OWCODE`	varchar(7)	Owner company code
`REL1_1`	varchar(2)	Primary relationship type (RC=Registered Owner, MR=Manager, CO=Operator, etc.)
`REL1_2`	varchar(2)	Secondary relationship type
`REL1_3`	varchar(2)	Tertiary relationship type
`PI_1`	varchar(1)	Primary indicator (P=Primary)

Maintained by the HIOW trigger. Can hold up to 3 relationships per owner-ship link. When updated, old relationship is demoted to position 2 or 3. If no relationships remain, owner record is deleted.

ABSD_OWXR — Owner Cross-Reference (Company Relationships)

Column	Type	Description
`OWCODE`	varchar(7)	Owner company code
`FXCODE`	varchar(7)	Related company code
`REL1_1`	varchar(2)	Relationship type: BO=Beneficial Owner, LA=Late, FT=Formerly Trading As, SO=Successor To, AO=Amalgamation Of, AS=Associate
`PUBLIND_1`	varchar(1)	Publication indicator: P=Public, R=Restricted, I=Internal, Z=Suppressed

Used by the HIOW trigger to traverse up to 2 levels to find the publishable beneficial owner for non-Group A companies. The PUBLIND_1 value controls whether the relationship is exposed in client-facing products.

ABSD_OWST — Owner Statistics Summary

Column	Type	Description
`OWCODE`	varchar(7)	Owner code
`IRP_OWNED`	int	Count of ships as registered owner (REL1_1='RC')
`IRP_MANAGED`	int	Count of ships as manager (any of REL1_1/2/3='MR')
`IRP_AGENTFOR`	int	Count of ships as agent
`RP_AGENTFOR`	int	Restricted publication ships as agent
`P_AGENTFOR`	int	Public ships as agent

Deleted and fully recalculated by the HIOW trigger on every ownership change. Not incrementally updated.

Other OW* Tables

Table	Description
`ABSD_OWCA`	Owner certificate of authority — rebuilt by CAGE1 trigger when STD or LRNO changes
`ABSD_OWCN`	Owner communications (phone, fax, email, telex, web)
`ABSD_OWCO`	Owner corporate structure (parent company code COCODE for C/O addresses)
`ABSD_OWDC`	Owner document control
`ABSD_OWIN`	Owner intermediate (registered company linking table)
`ABSD_OWNC`	Owner new condition status — maintained alongside OWSH by HIOW trigger
`ABSD_OWAN`	Owner annotations/notes

ABSD_STSE — Statutory Survey / Construction Record

Primary construction and survey record per vessel. SEQNO='01'=initial build; higher = rebuild.

Column	Type	Description
`LRNO`	nvarchar(7)	Vessel LR number
`SEQNO`	nvarchar(2)	Sequence ('01'=initial, higher=rebuilt sections)
`C01_EFD`	nvarchar(6)	Construction effective date (build date)
`C01_BLD_COMP`	nvarchar(9)	Builder composite code
`C01_HUL_SECN`	nvarchar(2)	Hull section code (from CBUB1 table 42)
`C01_CC`	nvarchar(1)	Confidence code
`C01_SRCE`	nvarchar(9)	Source

Cross-check rule: ABSD_OVNA.G01_EFD cannot be prior to ABSD_STSE.C01_EFD unless the vessel has multiple hull sections (rebuilt), in which case higher SEQNO name records are exempt.

Other ST* Tables

Table	Description	Key Fields
`ABSD_STAL`	Load line/freeboard record	Freeboard, load line zone, issuers
`ABSD_STDE`	Statutory deadweight history	DWT by date
`ABSD_STGE`	Statutory gross tonnage history	GT by date, regulation
`ABSD_STKE`	Statutory key entry records	Key statutory data points
`ABSD_STST`	Statutory status records	Statutory compliance status

LR* Family — Lloyd's Register Specific Tables

Table	Description	Key Fields
`ABSD_LREQ1–4`	LR classification equivalence (4 levels)	LR class notation equivalences
`ABSD_LRGE`	LR general entry	LR-specific vessel data
`ABSD_LRHI`	LR hull/intermediate record	Hull survey intermediate data
`ABSD_LRHN`	LR hull number	Hull numbering scheme
`ABSD_LRSC`	LR survey class	LR survey classification
`ABSD_LRSU`	LR survey unit	Survey unit details
`ABSD_LRWD`	LR water depth / ballast	Loading condition records

MA* Family — Machinery Tables

ABSD_MAEM1, MAEM2, MAEM3 — Three parallel tables for up to 3 distinct main engine groups.

Column (E0x prefix)	Type	Description
`E0x_EFD`	nvarchar(6)	Engine effective date
`E0x_ENGTYP`	nvarchar(2)	Engine type code
`E0x_BLDCDE`	nvarchar(9)	Builder code
`E0x_CYLNO`	smallint	Number of cylinders
`E0x_BORE`	smallint	Bore diameter (mm)
`E0x_STROKE`	smallint	Stroke length (mm)
`E0x_MCR_KW`	int	Maximum continuous rating (kW)
`E0x_MCR_HP`	int	Maximum continuous rating (BHP)
`E0x_RPM`	smallint	Revolutions per minute
`E0x_ENGNO`	smallint	Number of engines
`E0x_REENG`	nvarchar(1)	Re-engined indicator (Y/N)

Other MA* tables: ABSD_MAAU (auxiliary availability) • ABSD_MABO (boilers) • ABSD_MABU (bunker fuel) • ABSD_MAGR (gearbox) • ABSD_MAPR (propeller) • ABSD_MASP (service/propulsion) • ABSD_MAST (steam turbine) • ABSD_MATH (thrusters/hydraulics)

HA* Family — Hazardous Cargo Tables

ABSD_HAAD (hazardous cargo address/contact) • ABSD_HACO (hazardous cargo company reference)

ABSD_TANKER — Tanker-Specific Features

PK: LRNO. Specialized attributes for tanker vessels only.

Column	Type	Description
`LRNO`	nvarchar(7)	Vessel LR number
`HULL_TYPE`	varchar(6)	SH=Single Hull, DH=Double Hull, DBP=Double Bottom+Port, DSP=Double Side+Port
`MARPOL13G_PHASEOUT`	varchar(1)	MARPOL regulation 13G phase-out applies
`COW`	varchar(2)	Crude oil washing system
`IGS`	varchar(2)	Inert gas system
`SBT`	varchar(2)	Segregated ballast tanks
`SBT_PROTECTIVE`	varchar(2)	Protective segregated ballast tanks
`HYDROSTATIC_BALANCED`	varchar(1)	Hydrostatic balanced loading
`CLOSED_LOADING`	varchar(1)	Closed loading system
`VRS`	varchar(2)	Vapour recovery system
`IMO_CHEM_CLASS_I/II/III`	varchar(2)	IMO chemical class certification
`TVE_EXPIRY`	varchar(8)	TVE certificate expiry date
`SLOP_CAPACITY`	int	Slop tank capacity (m³)
`PERMANENT_BALLAST_CAP`	int	Permanent ballast capacity (m³)
`CARGO_TANK_COATING`	varchar(1)	Y/N — MUST be Y if any sub-coating (epoxy, ZS, SS, poly, rubber) is Y
`CARGO_TANK_COAT_EPOXY`	varchar(1)	Epoxy coating
`SLOP_TANK_COATING`	varchar(1)	Slop tank coating — same parent-required rule
`STERN_LOADING`	varchar(1)	Stern loading system (requires STERN_DISCHARGE='Y')
`STERN_DISCHARGE`	varchar(1)	Stern discharge (required if STERN_LOADING='Y')
`BOW_LOADING`	varchar(1)	Bow loading system (requires BOW_DISCHARGE='Y')
`BOW_DISCHARGE`	varchar(1)	Bow discharge (required if BOW_LOADING='Y')
`TEMP_MIN_C`	int	Minimum cargo temperature (°C)
`TEMP_MAX_C`	int	Maximum cargo temperature (°C)

HULL_TYPE → FUSF2 rule: SH → removes codes 3010 AND 3020; DBP → removes 3010 only; DSP → removes 3020 only; DH → keeps both.

ABSD_GROUP_FLEET — 4-Level Fleet Hierarchy

PK: LRNO. Maintained by the GROUP_FLEET stored procedure suite (7 procedures).

Column	Type	Description
`LRNO`	varchar(7)	Vessel LR number (primary key)
`REGD_OWNER`	varchar(7)	Registered owner company code (Level 1)
`REGD_OWNER_EFD`	varchar(8)	Registered owner effective date
`SHIP_MANAGER`	varchar(7)	Ship manager company code (Level 2)
`SHIP_MANAGER_EFD`	varchar(8)	Ship manager effective date
`FLEET_MANAGER`	varchar(7)	Fleet manager company code (Level 3)
`FLEET_MANAGER_EFD`	varchar(8)	Fleet manager effective date
`GROUP_OWNER`	varchar(7)	Group/beneficial owner company code (Level 4)
`GROUP_OWNER_EFD`	varchar(8)	Group owner effective date
`FLEET_COR`	varchar(3)	Fleet country of registration
`FLEET_NAT2`	varchar(3)	Fleet nationality 2
`GROUP_NAT2`	varchar(3)	Group nationality 2
`COEB`	varchar(1)	Country of effective business

Hierarchy: REGD_OWNER → SHIP_MANAGER → FLEET_MANAGER → GROUP_OWNER. EFD values default to '198099' when not set. See Procedures section for GROUP_FLEET stored procedure details.

ABSD_DEFECT — Vessel Defect Records

Records deficiency/defect reports per vessel. Fields include defect code, surveyor, date reported, resolution date, and severity classification.

ABSD_SHIP_SEARCH — Denormalized Search Index

PK: LRNO. Maintained by 20+ triggers and spABSD_SHIP_SEARCH_SYNC. One row per vessel with all searchable fields.

Fields maintained by triggers: VESSELNAME (OVNA), CALLSIGN, OFFICIALNO, FISHINGNO (OVGE), OWNERCODE, OWNER, OWNERCOD (HIOW), GASCAP, INSULATEDCAP, LIQUID, GRAIN, BALE, PASSENGERS, OILCAP (FUGE), FLAGCODE (HIFL). Fields maintained by spABSD_SHIP_SEARCH_SYNC: LEGAL2 (frozen/calculated), ISO2 (country mapping), flexible search fields, J06 author/date.

VSL_DESIGNATION — Vessel Identity (Readable Output)

PK: IMO_NUM. Human-readable vessel identity. IMO_NUM = ABSD_OVGE.LRNO (critical mapping).

Column	Type	Description
`IMO_NUM`	nvarchar(10)	IMO number — equals ABSD_OVGE.LRNO
`VESSEL_NAME`	varchar(100)	Current vessel name (from ABSD_OVNA SEQ '00')
`CALLSIGN`	varchar(13)	Radio call sign
`OFFICIAL_NO`	varchar(30)	Official registry number
`FLAG`	varchar(50)	Flag state (full name)
`FLAG_CODE`	varchar(3)	Flag country code (LR internal)
`ISO2`	varchar(2)	ISO 3166-1 alpha-2 flag country code
`SHIP_STATUS`	varchar(50)	Current status description
`SHIP_TYPE`	varchar(50)	Ship type description
`YEAR_OF_BUILD`	int	Year vessel was built
`MMSI`	varchar(20)	Maritime Mobile Service Identity number

Other VSL* Tables

Table	Key Fields	Description
`VSL_PRIN_CHRCS`	IMO_NUM, LOA, LBP, BREADTH, DEPTH, DRAUGHT, DWT, GRT, NRT	Principal characteristics (dimensions and tonnage)
`VSL_TONNAGE`	IMO_NUM, GROSS_TONNAGE, NET_TONNAGE, DWT, SUEZ_GT, PANAMA_GT	Tonnage data — ITC measurement preferred over national measurement
`VSL_OWNER_INFO`	IMO_NUM, OWNER_CODE, OWNER_NAME, MANAGER_CODE, MANAGER_NAME, OPERATOR_CODE	Current ownership — populated from HIOW/HIMA/HIOP SEQNO='00' records

VSL_ population pattern: Views join ABSD_OVGE.LRNO = VSL_DESIGNATION.IMO_NUM. VSL_ tables are populated by triggers and scheduled jobs; they are the read-optimized output layer consumed by downstream products.

Reference, Company, Casualty & Standalone Table Catalog