02 — Vessel Tables

Vessel Table Catalog — OV*, HI*, FU* Families

Complete column definitions for vessel identity, ownership history, and fuel/equipment tables. All tables use LRNO (nvarchar 7) as primary key unless noted.

OV
OV* Family — Vessel Identity & Status
ABSD_OVGE — Vessel General Data Master Record — One row per vessel
Primary key: LRNO nvarchar(7). Root of all vessel data. No SEQNO — single row.
ColumnTypeDescription
LRNOnvarchar(7)Lloyd's Register vessel identifier — primary key
DOBchar(6)Date of Build (YYMMDD format)
A01_SRCEnvarchar(9)Vessel status source system
A01_EFDnvarchar(6)Vessel status effective date
A03_EFDnvarchar(8)Publication status effective date
A03_PUBSTnvarchar(1)Publication status: D=Confirmed Will Not Publish, U=Continues, Y=Suppressed, S=Confirmed Never Was, X=Suppressed Confirmed Never Was, Z=Suppressed Confirmed Will Not Pub
B01_EFDnvarchar(6)Call sign effective date
B01_CCnvarchar(1)Call sign confidence code
B01_SRCEnvarchar(9)Call sign source
B01_VERnvarchar(1)Call sign verification
B01_CALLSIGNnvarchar(13)International maritime call sign (validated by fnCallsignCheck; 2 chars for some flags, 3 for others)
B01_BLT_TO_MKnvarchar(1)Built to Mark: +, *, R or blank
B02_EFDnvarchar(6)Official number effective date
B02_CCnvarchar(1)Official number confidence
B02_SRCEnvarchar(9)Official number source
B02_VERnvarchar(1)Official number verification
B02_OFFNOnvarchar(30)Official registry number (hyphen stripped if Panama flag)
B03_EFDnvarchar(6)Shipyard location effective date
B03_NA1–B03_NA12nvarchar(1) each12 shipyard location attribute flags
B10_FISHNOnvarchar(10)Fishing vessel registration number
B11_SATCOMnvarchar(10)Satellite communication number
B11_ANSBK_CODEnvarchar(6)Answerback code
B12_AMVERnvarchar(1)AMVER (Automated Mutual Assistance Vessel Rescue) participation
SBLDR_CMPnvarchar(9)Shipbuilder composite code (KEYC+KEYG+KEYN+KEYX from ABSD_CBSB)
D_BLDSHPnvarchar(6)Date built ship
YARD_NOnvarchar(6)Shipyard hull number
F01_EFDnvarchar(6)Classification society effective date
F01_BLT_TO_MKnvarchar(1)Built to mark indicator
F01_YR_ALLWDnvarchar(3)Year allowed for class
F01_HULL_LETnvarchar(1)Hull letter (LR class notation)
F01_EQPT_CHKnvarchar(1)Equipment check: 1, E, N, - or blank
F01_OFF_LETnvarchar(2)Official letter (LR class notation)
F01_TETHD_MARKnvarchar(1)Tethered mark
F01_2ND_EQPT_CHKnvarchar(3)Second equipment check year
MOVE_INDnvarchar(1)Move indicator
J06_LNCHDATEnvarchar(6)Last change date (YYMMDD) — updated by ALL triggers
J06_LNCHTIMEnvarchar(6)Last change time (HHMMSS)
J06_AUTHORnvarchar(3)Last change author (3-letter user initials from Windows login)
ABSD_OVNA — Vessel Name History
Primary key: LRNO + SEQ_NO. SEQNO='00'=current name. One row per historical name change.
ColumnTypeDescription
LRNOnvarchar(7)Vessel LR number
SEQ_NOnvarchar(2)'00'=current, '01'=previous, etc.
G01_EFDnvarchar(6)Name effective date (required, cannot be null)
G01_CCnvarchar(1)Confidence code
G01_SRCEnvarchar(9)Source of name data
G01_VERnvarchar(1)Verification indicator
G01_HULL_SECnvarchar(2)Hull section code (validated against CBUB1 table 42)
G01_LNCHD_ASnvarchar(1)Launched as this name (Y/N) — only ONE per vessel allowed
G01_COMP_ASnvarchar(1)Completed as this name (Y/N) — only ONE per vessel allowed
G01_ORIG_NAMEnvarchar(1)Original name indicator (Y/U) — at least one required per vessel
G01_NAMEvarchar(50)Vessel name — UPPERCASE for current (SEQ '00'), no trailing spaces
G01_RB_SEQnvarchar(2)Rebuild sequence number
LRNO_NAMEnvarchar(7)LR number cross-reference
GRT_LintGross tonnage at time of name (max 7 digits)
DOBnvarchar(4)Date of build (year portion)
SHIP_TYPnvarchar(20)Ship type at time of name
INV_GRT_LintInvented gross tonnage (max 7 digits)
FLAG_CDEnvarchar(3)Flag country code at time of name
SHP_ACT_STnvarchar(1)Ship activity status at time of name
KEY_NAMEnvarchar(50)Sort key for the name
Name business rules (trigger-enforced): SEQ '00' name MUST be UPPERCASE • No trailing spaces • Cannot duplicate any existing name for same vessel • Cannot have consecutive identical names • Only one G01_LNCHD_AS='Y' per vessel • Only one G01_COMP_AS='Y' per vessel • At least one G01_ORIG_NAME='Y' or 'U' required • G01_EFD must be ≥ vessel construction date
ABSD_OVTY — Vessel Ship Type
Primary key: LRNO + SEQ_NO. SEQNO='00'=current type.
ColumnTypeDescription
LRNOnvarchar(7)Vessel LR number
SEQ_NOnvarchar(2)Sequence ('00'=current)
D01_EFDnvarchar(6)Ship type effective date
D01_CCnvarchar(1)Confidence code
D01_SRCEnvarchar(9)Source
D01_INT_BASICnvarchar(5)Initial basic type code (5 bytes, e.g. 'A37A2')
D01_TYP_Anvarchar(3)Ship type subtype A (no spaces)
D01_TYP_Bnvarchar(3)Ship type subtype B
D01_TYP_Cnvarchar(3)Ship type subtype C
D01_TYP_Dnvarchar(3)Ship type subtype D
D01_TYP_Envarchar(3)Ship type subtype E
D01_SEQnvarchar(2)Internal sequence number
The 20-byte ship type code concatenates D01_INT_BASIC + D01_TYP_A + D01_TYP_B + D01_TYP_C + D01_TYP_D + D01_TYP_E. Type 'A37A2PC' = Passenger/Cargo (special tonnage rules).
ABSD_OVCA — Vessel Casualty/Disposal Indicator
ColumnTypeDescription
LRNOnvarchar(7)Vessel LR number
SEQ_NOnvarchar(2)Sequence number
F14_EFDnvarchar(6)Casualty effective date
F14_SRCEnvarchar(9)Casualty source
F14_NOTESnvarchar(140)Casualty notes — required when A03_PUBST is D/Y and A02_STS is T/B/D/W/H
F14_DISP_DATEnvarchar(1)Display date indicator
ABSD_OVCS — Casualty Sub-Information
ColumnTypeDescription
LRNOnvarchar(7)Vessel LR number
SEQ_NOnvarchar(2)Sequence number
SEQ_NO2nvarchar(1)Sub-sequence
CODEnvarchar(2)Casualty code (validated against CBUB1 table 57)
DINDnvarchar(1)Direction indicator
DATE_OVCnvarchar(6)Casualty date
TEXTnvarchar(50)Casualty text description
ABSD_OVDOC — Document of Compliance Company
Links vessel to DOC-issuing company. PK: LRNO + SEQNO
ColumnTypeDescription
LRNOnvarchar(7)Vessel LR number
SEQNOnvarchar(2)Sequence ('00'=current)
OWCODEvarchar(7)Owner/company code of DOC holder
EffectiveDatedatetimeDate relationship became effective
Sourcevarchar(50)Data source
EDIT_DATEdatetimeLast edit timestamp
ABSD_OVSMC — Safety Management Certificate (ISM/SMC)
ColumnTypeDescription
LRNOvarchar(7)Vessel LR number
SEQNOvarchar(2)Sequence ('00'=current)
SMC_SHIPNAMEvarchar(50)Ship name on the SMC document
SMC_SHIPTYPEvarchar(50)Ship type on SMC
DOC_COMPANYvarchar(50)DOC company name
DOC_COMPANY_IDvarchar(20)DOC company identifier
SMC_FLAGvarchar(50)Flag state on SMC
SMC_AUDITORvarchar(20)Auditor code
SMC_ISSUERvarchar(20)Certificate issuer code
SMC_C_OR_Vvarchar(1)C=Certificate, V=Verification
DATE_ISSUEDdatetimeIssue date
DATE_EXPIRESdatetimeExpiry date
OWCODEvarchar(7)Owner company code
Survey_DatedatetimeSurvey date
Next_Survey_DatedatetimeNext survey date
Class_Statusvarchar(50)Classification status
Class_Status_DatedatetimeClassification status effective date
Class_Status_Reasonvarchar(100)Reason for status change
ABSD_OVISSC — International Ship Security Certificate (ISPS Code)
ColumnTypeDescription
LRNOvarchar(7)Vessel LR number
SEQNOvarchar(2)Sequence ('00'=current)
SHIPNAMEvarchar(150)Ship name on certificate
COMPANYNAMEvarchar(150)Company name on certificate
FLAGvarchar(50)Flag state
APPROVED_BYvarchar(50)Approving authority
VERIFIED_BYvarchar(50)Verification party
ISSCvarchar(100)ISSC certificate number
ISSUED_BYvarchar(50)Issuing authority
C_OR_Vvarchar(1)C=Certificate, V=Verification
DATE_ISSUEDdatetimeIssue date
DATE_EXPIRESdatetimeExpiry date
OWCODEvarchar(7)Owner code
HI
HI* Family — History Tables (Temporal Records)

All HI* tables follow the SEQNO model: '00'=current, '01'=previous, etc. These tables record every change over time, enabling point-in-time queries.

ABSD_HIOW — Registered Owner History
PK: LRNO + SEQNO. Each owner change creates a new SEQNO record.
ColumnTypeDescription
LRNOnvarchar(7)Vessel LR number
SEQNOnvarchar(2)Sequence ('00'=current owner)
H01_EFDnvarchar(8)Owner effective date (required, YYYYMMDD)
H01_CCnvarchar(1)Confidence code
H01_SRCEnvarchar(9)Source
H01_VERnvarchar(1)Verification
H01_OWNER_CODEnvarchar(7)Owner company code (links to ABSD_OWGE.OWCODE)
Key business rules: Owner cannot equal manager unless code is '9991001' (placeholder) • When owner changes to match existing manager, manager is automatically reset • Ownership changes cascade to ABSD_OWST, ABSD_OWSH, ABSD_HIPP, ABSD_HITP • Calls SPMAKEHIMAHISTORICAL when needed • Uses trigger_disable_hima to prevent recursion
ABSD_HIMA — Ship Manager History (Crewing/Technical)
ColumnTypeDescription
LRNOnvarchar(7)Vessel LR number
SEQNOnvarchar(2)Sequence ('00'=current manager)
H02_EFDnvarchar(8)Manager effective date (required, YYYYMMDD)
H02_CCnvarchar(1)Confidence code
H02_SRCEnvarchar(9)Source
H02_VERnvarchar(1)Verification
H02_MANAGERnvarchar(7)Manager company code — cannot equal registered owner unless '9991001'
ABSD_HISM — Ship Manager History (Technical/Operations)
ColumnTypeDescription
LRNOnvarchar(7)Vessel LR number
SEQNOnvarchar(2)Sequence ('00'=current)
EFDnvarchar(8)Effective date (YYYYMMDD)
SHIPMANAGERnvarchar(7)Ship manager company code
ABSD_HIOP — Operator History (Commercial Operator)
ColumnTypeDescription
LRNOnvarchar(7)Vessel LR number
SEQNOnvarchar(2)Sequence ('00'=current)
EFDnvarchar(8)Effective date
OPERATOR_CODEnvarchar(7)Operator company code
ABSD_HIPP — Principal Performance Controller (Parent Group Owner)
ColumnTypeDescription
LRNOnvarchar(7)Vessel LR number
SEQNOnvarchar(2)Sequence ('00'=current)
H03_EFDnvarchar(8)Effective date
H03_CCnvarchar(1)Confidence code
H03_SRCEnvarchar(9)Source
H03_PPCnvarchar(7)Parent/group company code
ABSD_HIGBO — Group / Beneficial Owner History
ColumnTypeDescription
LRNOnvarchar(7)Vessel LR number
SEQNOnvarchar(2)Sequence ('00'=current)
GBO_CODEnvarchar(7)Group/beneficial owner company code
GBO_RECDATEnvarchar(8)Record date (used in fnGetGROUPOWNERAtDate)
ABSD_HIFL — Flag History
PK: LRNO + SEQNO. Every flag change creates a new sequence record.
ColumnTypeDescription
LRNOnvarchar(7)Vessel LR number
SEQNOnvarchar(2)Sequence ('00'=current flag)
B04_EFDnvarchar(6)Flag effective date (required, cannot be null)
B04_CCnvarchar(1)Confidence code
B04_SRCEnvarchar(9)Source
B04_VERnvarchar(1)Verification
B04_CNTYnvarchar(3)Flag country code (validated against T_REF_COUNTRY)
B04_TOWNnvarchar(4)Port of registration town code
B04_HP_INDnvarchar(1)HP (high priority) indicator
ABSD_HITL — Tonnage/Measurement History
ColumnTypeDescription
LRNOnvarchar(7)Vessel LR number
SEQNOnvarchar(2)Sequence ('00'=current)
B07_EFDnvarchar(6)Tonnage effective date
B07_CCnvarchar(1)Confidence code
B07_SRCEnvarchar(9)Source
B07_GR_VERnvarchar(1)Gross tonnage verification
B07_GROSSintGross Tonnage (max 7 digits; cannot be set for A37A2PC type via trigger)
B07_GR_CCnvarchar(1)Gross tonnage confidence
B07_NET_VERnvarchar(1)Net tonnage verification
B07_NETintNet Tonnage
B07_NET_CCnvarchar(1)Net tonnage confidence
ABSD_HIST — Vessel Status History
ColumnTypeDescription
LRNOnvarchar(7)Vessel LR number
SEQNOnvarchar(2)Sequence ('00'=current)
A02_EFDnvarchar(6)Status effective date
A02_STSnvarchar(1)Status code (S/L/T/R/B/C/V/J/P/O/U/F/E/A/N/X/Z/D/W/H — see Overview §10)
A02_CCnvarchar(1)Confidence code
A02_SRCEnvarchar(9)Source
ABSD_HIFC1 — Foreign Classification History (Primary)
ColumnTypeDescription
LRNOnvarchar(7)Vessel LR number
SEQNOnvarchar(2)Sequence ('00'=current)
B09_EFDnvarchar(6)Classification effective date
B09_CCnvarchar(1)Confidence code
B09_SRCEnvarchar(9)Source
B09_VERnvarchar(1)Verification
ABSD_HIFC2 — Additional class notations. Same structure with notation-specific fields for secondary/notation classification details.
ABSD_HIBBC — Bareboat Charterer History
ColumnTypeDescription
LRNOnvarchar(7)Vessel LR number
SEQNOnvarchar(2)Sequence ('00'=current)
BBC_EFDnvarchar(8)BBC effective date
BBC_CCnvarchar(1)Confidence code
BBC_CODEnvarchar(7)Bareboat charterer company code
ABSD_HIBR — Builder History
ColumnTypeDescription
LRNOnvarchar(7)Vessel LR number
SEQNOnvarchar(2)Sequence
C01_EFDnvarchar(6)Builder effective date
C01_BLD_COMPnvarchar(9)Builder composite code (SBLDR_CMP format)
C01_HUL_SECNnvarchar(2)Hull section code
C01_CCnvarchar(1)Confidence code
ABSD_HIGE — Generator / Electrical Equipment History
PK: LRNO + SEQNO + POS_CODE. One row per generator position.
ColumnTypeDescription
LRNOnvarchar(7)Vessel LR number
SEQNOnvarchar(2)Sequence
POS_CODEnvarchar(3)Generator position code
E45_EFDnvarchar(6)Effective date
E45_NOsmallintNumber of generators (max 2 digits)
E45_KWsmallintPower in kilowatts (max 5 digits)
E45_VOLTsmallintVoltage (max 5 digits)
E45_FREQnvarchar(2)Frequency: '50', '60', or '0' when E45_ACDC='A'
E45_ACDCnvarchar(1)AC/DC/N/U/Y — AC requires frequency 50 or 60; DC requires frequency 0
E45_DMnvarchar(6)Date manufacturer — must be ≤ E45_EFD
E45_STnvarchar(6)Supertype — E45_ST > E45_EFD only if E45_GS='8'
E45_PM_POS_1 – _9nvarchar(1) eachPrime mover position codes (validated against CBUB1 table 03)
E45_GMnvarchar(4)Generator manufacturer code (validated against CBEB.MM codes)
E45_GSnvarchar(2)Generator supertype (validated against CBUB1 table 19 or '8')
E45_CCnvarchar(1)Confidence code
E45_SRCEnvarchar(9)Source
Other HI* Tables — Summary
TableDescriptionKey Fields
ABSD_HIDRDrydock/Repair historySurvey type, drydock date, yard
ABSD_HIDEDesign/Engine modificationEngine type changes, design alterations
ABSD_HILEHull dimensions historyLength, breadth, depth at each measurement
ABSD_HILCLoad Line certificate historyCertificate number, issuer, dates
ABSD_HIMOMeasurement historyDeadweight measurements by date
ABSD_HIMTMachinery trials historyTrial date, results, surveyor
ABSD_HIPCPort change historyPort of registry changes
ABSD_HIPMPort of management historyManagement port
ABSD_HIPSSurvey historySurvey type, date, result
ABSD_HIPUPurpose/Use historyVessel purpose classification
ABSD_HISEService historyService type classification
ABSD_HIBSHull survey historyHull survey details
ABSD_HITMTrade mission historyTrade area codes
ABSD_HITPTrade/purpose classificationPurpose classification codes
ABSD_HRXRHistory cross-referenceCross-links between history records
FU
FU* Family — Fuel, Capacity, Machinery Details
ABSD_FUGE — General Vessel Features (Capacity + Propulsion)
Single row per vessel (no SEQNO). The primary capacity table. PK: LRNO
ColumnTypeDescription
LRNOnvarchar(7)Vessel LR number
DOBnvarchar(6)Date of build
D02_SERVICEnvarchar(21)Service designation
D06_EFDnvarchar(6)Passenger/crew capacity effective date
D06_PASS_UNsmallintPassengers underdeck (max 4 digits)
D06_PASS_DKsmallintPassengers on deck (max 4 digits)
D06_PASS_BRsmallintPassengers berthed (max 4 digits)
D06_CREW_NOsmallintCrew number (max 4 digits)
D06_CBNSsmallintNumber of cabins (max 4 digits)
D06_DVBRsmallintDavit-launched lifeboat capacity (max 4 digits)
D10_GRAINintGrain capacity (m³, max 8 digits)
D10_BALEintBale capacity (m³, max 8 digits)
D10_INULTDintInsulated capacity (m³, max 8 digits)
D10_LQDintLiquid capacity (m³, max 8 digits)
D10_LQGintLiquid gas capacity (m³, max 8 digits)
D10_OILintOil capacity (m³, max 8 digits)
D10_SEG_BLLSTintSegregated ballast tank capacity (m³)
D10_CLN_BLLSTintClean ballast capacity (m³)
D10_VRT_BALEintVertical bale capacity (m³)
D10_OTHER_CAPintOther capacity (m³, max 8 digits)
D10_OTHER_TYPnvarchar(1)Other capacity type code
D10_HTNG_CLSnvarchar(1)Heating class: C=Cargo, P=Permanent, N=None, U=Unknown, Y=Yes
D18_WNCHS_NOsmallintNumber of winches (max 2 digits; can only be >0 if FULI2 seq 01 has D19_LG_TYP='DE' or 'AF')
D25_AUX_PROPnvarchar(1)Auxiliary propulsion: Y/N/U
D25_NUCLR_PWRnvarchar(1)Nuclear powered: Y/N/U
SHIP_SEARCH updates: Trigger updates ABSD_SHIP_SEARCH with GASCAP, INSULATEDCAP, LIQUID, GRAIN, BALE, PASSENGERS, OILCAP fields.
ABSD_FUDI1 — Deck/Mooring Equipment
ColumnTypeDescription
LRNOnvarchar(7)Vessel LR number
D22_MANBOW_LENsmallintMan overboard bow length (max 4 digits; must be ≤ LBP or LOA from HILE)
D22_MBL_CCnvarchar(1)Bow length confidence
D22_DIS_DIAMdecimal(4,3)Discharge diameter
D22_MAN_TYPnvarchar(1)Manifold type (validated against CBUB3 table 01)
D21_EFDnvarchar(6)Deck features effective date
ABSD_FUDI2–4 — Engine/Propulsion Details
Three separate engine entry tables (Diesel/Steam/Turbine). Each holds specification for one prime mover group. Key fields include: engine type code, builder code, model, number of cylinders, bore, stroke, MCR (maximum continuous rating) in kW and BHP, RPM, installation date, re-engine indicator.
ABSD_FUSF / FUSF2 — Special Features
One row per special feature code per vessel. PK: LRNO + SEQ_NO
ColumnTypeDescription
LRNOnvarchar(7)Vessel LR number
SEQ_NOnvarchar(3)Sequence within vessel
D07_EFDnvarchar(6)Feature effective date
D07_CCnvarchar(1)Confidence code
D07_SRCEnvarchar(9)Source
D07_CODEnvarchar(4)Special feature code (e.g., '3010'=double hull bottom, '3020'=double hull side, '0554'=LR class notation)
D07_VERnvarchar(1)Verification
FUSF2 managed codes: 3010=double hull bottom port; 3020=double hull starboard; 0527, 0538, 0539, 0551, 0554=LR classification notation features (managed by spAddDeleteFUSF2). TANKER hull type rules: SH removes both 3010+3020; DBP removes 3010; DSP removes 3020.
Other FU* Tables — Summary
TableDescriptionKey Fields
ABSD_FUCA1/2Cargo type (primary/secondary)Cargo type code, effective date
ABSD_FUCO1/2Container capacityTEU, 14T TEU, homogeneous, reefer, reefer plugs, cell guides
ABSD_FUHA1/2Hatch configurationHatch count, type, size
ABSD_FULI1/2/3Lifting gearCrane/derrick type, SWL, number — FULI2 D19_LG_TYP controls FUGE winch count
ABSD_FULCLiquid cargo detailsTank type, segregation
ABSD_FUOFOffshore featuresDP system, anchoring
ABSD_FURO1/2Ramp dataRamp type, SWL, width
ABSD_FUSPSpeed dataService speed, max speed, trial speed
ABSD_FUST1/2Tank dataTank count, segregation, coatings
ABSD_FUTOThruster dataThruster type, power, position
ABSD_FUUN1/2Bunker/fuel tank dataFuel type, capacity, unit
ABSD_FTMEFire/thermal management equipmentEquipment type, rating
ABSD_FTNTNon-propulsion equipmentAuxiliary equipment specs
← System Overview  ·  Documentation Hub  ·  Next: Reference Tables →