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.
| Column | Type | Description |
|---|---|---|
LRNO | nvarchar(7) | Lloyd's Register vessel identifier — primary key |
DOB | char(6) | Date of Build (YYMMDD format) |
A01_SRCE | nvarchar(9) | Vessel status source system |
A01_EFD | nvarchar(6) | Vessel status effective date |
A03_EFD | nvarchar(8) | Publication status effective date |
A03_PUBST | nvarchar(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_EFD | nvarchar(6) | Call sign effective date |
B01_CC | nvarchar(1) | Call sign confidence code |
B01_SRCE | nvarchar(9) | Call sign source |
B01_VER | nvarchar(1) | Call sign verification |
B01_CALLSIGN | nvarchar(13) | International maritime call sign (validated by fnCallsignCheck; 2 chars for some flags, 3 for others) |
B01_BLT_TO_MK | nvarchar(1) | Built to Mark: +, *, R or blank |
B02_EFD | nvarchar(6) | Official number effective date |
B02_CC | nvarchar(1) | Official number confidence |
B02_SRCE | nvarchar(9) | Official number source |
B02_VER | nvarchar(1) | Official number verification |
B02_OFFNO | nvarchar(30) | Official registry number (hyphen stripped if Panama flag) |
B03_EFD | nvarchar(6) | Shipyard location effective date |
B03_NA1–B03_NA12 | nvarchar(1) each | 12 shipyard location attribute flags |
B10_FISHNO | nvarchar(10) | Fishing vessel registration number |
B11_SATCOM | nvarchar(10) | Satellite communication number |
B11_ANSBK_CODE | nvarchar(6) | Answerback code |
B12_AMVER | nvarchar(1) | AMVER (Automated Mutual Assistance Vessel Rescue) participation |
SBLDR_CMP | nvarchar(9) | Shipbuilder composite code (KEYC+KEYG+KEYN+KEYX from ABSD_CBSB) |
D_BLDSHP | nvarchar(6) | Date built ship |
YARD_NO | nvarchar(6) | Shipyard hull number |
F01_EFD | nvarchar(6) | Classification society effective date |
F01_BLT_TO_MK | nvarchar(1) | Built to mark indicator |
F01_YR_ALLWD | nvarchar(3) | Year allowed for class |
F01_HULL_LET | nvarchar(1) | Hull letter (LR class notation) |
F01_EQPT_CHK | nvarchar(1) | Equipment check: 1, E, N, - or blank |
F01_OFF_LET | nvarchar(2) | Official letter (LR class notation) |
F01_TETHD_MARK | nvarchar(1) | Tethered mark |
F01_2ND_EQPT_CHK | nvarchar(3) | Second equipment check year |
MOVE_IND | nvarchar(1) | Move indicator |
J06_LNCHDATE | nvarchar(6) | Last change date (YYMMDD) — updated by ALL triggers |
J06_LNCHTIME | nvarchar(6) | Last change time (HHMMSS) |
J06_AUTHOR | nvarchar(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.
| Column | Type | Description |
|---|---|---|
LRNO | nvarchar(7) | Vessel LR number |
SEQ_NO | nvarchar(2) | '00'=current, '01'=previous, etc. |
G01_EFD | nvarchar(6) | Name effective date (required, cannot be null) |
G01_CC | nvarchar(1) | Confidence code |
G01_SRCE | nvarchar(9) | Source of name data |
G01_VER | nvarchar(1) | Verification indicator |
G01_HULL_SEC | nvarchar(2) | Hull section code (validated against CBUB1 table 42) |
G01_LNCHD_AS | nvarchar(1) | Launched as this name (Y/N) — only ONE per vessel allowed |
G01_COMP_AS | nvarchar(1) | Completed as this name (Y/N) — only ONE per vessel allowed |
G01_ORIG_NAME | nvarchar(1) | Original name indicator (Y/U) — at least one required per vessel |
G01_NAME | varchar(50) | Vessel name — UPPERCASE for current (SEQ '00'), no trailing spaces |
G01_RB_SEQ | nvarchar(2) | Rebuild sequence number |
LRNO_NAME | nvarchar(7) | LR number cross-reference |
GRT_L | int | Gross tonnage at time of name (max 7 digits) |
DOB | nvarchar(4) | Date of build (year portion) |
SHIP_TYP | nvarchar(20) | Ship type at time of name |
INV_GRT_L | int | Invented gross tonnage (max 7 digits) |
FLAG_CDE | nvarchar(3) | Flag country code at time of name |
SHP_ACT_ST | nvarchar(1) | Ship activity status at time of name |
KEY_NAME | nvarchar(50) | Sort key for the name |
ABSD_OVTY — Vessel Ship Type
Primary key: LRNO + SEQ_NO. SEQNO='00'=current type.
| Column | Type | Description |
|---|---|---|
LRNO | nvarchar(7) | Vessel LR number |
SEQ_NO | nvarchar(2) | Sequence ('00'=current) |
D01_EFD | nvarchar(6) | Ship type effective date |
D01_CC | nvarchar(1) | Confidence code |
D01_SRCE | nvarchar(9) | Source |
D01_INT_BASIC | nvarchar(5) | Initial basic type code (5 bytes, e.g. 'A37A2') |
D01_TYP_A | nvarchar(3) | Ship type subtype A (no spaces) |
D01_TYP_B | nvarchar(3) | Ship type subtype B |
D01_TYP_C | nvarchar(3) | Ship type subtype C |
D01_TYP_D | nvarchar(3) | Ship type subtype D |
D01_TYP_E | nvarchar(3) | Ship type subtype E |
D01_SEQ | nvarchar(2) | Internal sequence number |
ABSD_OVCA — Vessel Casualty/Disposal Indicator
| Column | Type | Description |
|---|---|---|
LRNO | nvarchar(7) | Vessel LR number |
SEQ_NO | nvarchar(2) | Sequence number |
F14_EFD | nvarchar(6) | Casualty effective date |
F14_SRCE | nvarchar(9) | Casualty source |
F14_NOTES | nvarchar(140) | Casualty notes — required when A03_PUBST is D/Y and A02_STS is T/B/D/W/H |
F14_DISP_DATE | nvarchar(1) | Display date indicator |
ABSD_OVCS — Casualty Sub-Information
| Column | Type | Description |
|---|---|---|
LRNO | nvarchar(7) | Vessel LR number |
SEQ_NO | nvarchar(2) | Sequence number |
SEQ_NO2 | nvarchar(1) | Sub-sequence |
CODE | nvarchar(2) | Casualty code (validated against CBUB1 table 57) |
DIND | nvarchar(1) | Direction indicator |
DATE_OVC | nvarchar(6) | Casualty date |
TEXT | nvarchar(50) | Casualty text description |
ABSD_OVDOC — Document of Compliance Company
Links vessel to DOC-issuing company. PK: LRNO + SEQNO
| Column | Type | Description |
|---|---|---|
LRNO | nvarchar(7) | Vessel LR number |
SEQNO | nvarchar(2) | Sequence ('00'=current) |
OWCODE | varchar(7) | Owner/company code of DOC holder |
EffectiveDate | datetime | Date relationship became effective |
Source | varchar(50) | Data source |
EDIT_DATE | datetime | Last edit timestamp |
ABSD_OVSMC — Safety Management Certificate (ISM/SMC)
| Column | Type | Description |
|---|---|---|
LRNO | varchar(7) | Vessel LR number |
SEQNO | varchar(2) | Sequence ('00'=current) |
SMC_SHIPNAME | varchar(50) | Ship name on the SMC document |
SMC_SHIPTYPE | varchar(50) | Ship type on SMC |
DOC_COMPANY | varchar(50) | DOC company name |
DOC_COMPANY_ID | varchar(20) | DOC company identifier |
SMC_FLAG | varchar(50) | Flag state on SMC |
SMC_AUDITOR | varchar(20) | Auditor code |
SMC_ISSUER | varchar(20) | Certificate issuer code |
SMC_C_OR_V | varchar(1) | C=Certificate, V=Verification |
DATE_ISSUED | datetime | Issue date |
DATE_EXPIRES | datetime | Expiry date |
OWCODE | varchar(7) | Owner company code |
Survey_Date | datetime | Survey date |
Next_Survey_Date | datetime | Next survey date |
Class_Status | varchar(50) | Classification status |
Class_Status_Date | datetime | Classification status effective date |
Class_Status_Reason | varchar(100) | Reason for status change |
ABSD_OVISSC — International Ship Security Certificate (ISPS Code)
| Column | Type | Description |
|---|---|---|
LRNO | varchar(7) | Vessel LR number |
SEQNO | varchar(2) | Sequence ('00'=current) |
SHIPNAME | varchar(150) | Ship name on certificate |
COMPANYNAME | varchar(150) | Company name on certificate |
FLAG | varchar(50) | Flag state |
APPROVED_BY | varchar(50) | Approving authority |
VERIFIED_BY | varchar(50) | Verification party |
ISSC | varchar(100) | ISSC certificate number |
ISSUED_BY | varchar(50) | Issuing authority |
C_OR_V | varchar(1) | C=Certificate, V=Verification |
DATE_ISSUED | datetime | Issue date |
DATE_EXPIRES | datetime | Expiry date |
OWCODE | varchar(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.
| Column | Type | Description |
|---|---|---|
LRNO | nvarchar(7) | Vessel LR number |
SEQNO | nvarchar(2) | Sequence ('00'=current owner) |
H01_EFD | nvarchar(8) | Owner effective date (required, YYYYMMDD) |
H01_CC | nvarchar(1) | Confidence code |
H01_SRCE | nvarchar(9) | Source |
H01_VER | nvarchar(1) | Verification |
H01_OWNER_CODE | nvarchar(7) | Owner company code (links to ABSD_OWGE.OWCODE) |
ABSD_HIMA — Ship Manager History (Crewing/Technical)
| Column | Type | Description |
|---|---|---|
LRNO | nvarchar(7) | Vessel LR number |
SEQNO | nvarchar(2) | Sequence ('00'=current manager) |
H02_EFD | nvarchar(8) | Manager effective date (required, YYYYMMDD) |
H02_CC | nvarchar(1) | Confidence code |
H02_SRCE | nvarchar(9) | Source |
H02_VER | nvarchar(1) | Verification |
H02_MANAGER | nvarchar(7) | Manager company code — cannot equal registered owner unless '9991001' |
ABSD_HISM — Ship Manager History (Technical/Operations)
| Column | Type | Description |
|---|---|---|
LRNO | nvarchar(7) | Vessel LR number |
SEQNO | nvarchar(2) | Sequence ('00'=current) |
EFD | nvarchar(8) | Effective date (YYYYMMDD) |
SHIPMANAGER | nvarchar(7) | Ship manager company code |
ABSD_HIOP — Operator History (Commercial Operator)
| Column | Type | Description |
|---|---|---|
LRNO | nvarchar(7) | Vessel LR number |
SEQNO | nvarchar(2) | Sequence ('00'=current) |
EFD | nvarchar(8) | Effective date |
OPERATOR_CODE | nvarchar(7) | Operator company code |
ABSD_HIPP — Principal Performance Controller (Parent Group Owner)
| Column | Type | Description |
|---|---|---|
LRNO | nvarchar(7) | Vessel LR number |
SEQNO | nvarchar(2) | Sequence ('00'=current) |
H03_EFD | nvarchar(8) | Effective date |
H03_CC | nvarchar(1) | Confidence code |
H03_SRCE | nvarchar(9) | Source |
H03_PPC | nvarchar(7) | Parent/group company code |
ABSD_HIGBO — Group / Beneficial Owner History
| Column | Type | Description |
|---|---|---|
LRNO | nvarchar(7) | Vessel LR number |
SEQNO | nvarchar(2) | Sequence ('00'=current) |
GBO_CODE | nvarchar(7) | Group/beneficial owner company code |
GBO_RECDATE | nvarchar(8) | Record date (used in fnGetGROUPOWNERAtDate) |
ABSD_HIFL — Flag History
PK: LRNO + SEQNO. Every flag change creates a new sequence record.
| Column | Type | Description |
|---|---|---|
LRNO | nvarchar(7) | Vessel LR number |
SEQNO | nvarchar(2) | Sequence ('00'=current flag) |
B04_EFD | nvarchar(6) | Flag effective date (required, cannot be null) |
B04_CC | nvarchar(1) | Confidence code |
B04_SRCE | nvarchar(9) | Source |
B04_VER | nvarchar(1) | Verification |
B04_CNTY | nvarchar(3) | Flag country code (validated against T_REF_COUNTRY) |
B04_TOWN | nvarchar(4) | Port of registration town code |
B04_HP_IND | nvarchar(1) | HP (high priority) indicator |
ABSD_HITL — Tonnage/Measurement History
| Column | Type | Description |
|---|---|---|
LRNO | nvarchar(7) | Vessel LR number |
SEQNO | nvarchar(2) | Sequence ('00'=current) |
B07_EFD | nvarchar(6) | Tonnage effective date |
B07_CC | nvarchar(1) | Confidence code |
B07_SRCE | nvarchar(9) | Source |
B07_GR_VER | nvarchar(1) | Gross tonnage verification |
B07_GROSS | int | Gross Tonnage (max 7 digits; cannot be set for A37A2PC type via trigger) |
B07_GR_CC | nvarchar(1) | Gross tonnage confidence |
B07_NET_VER | nvarchar(1) | Net tonnage verification |
B07_NET | int | Net Tonnage |
B07_NET_CC | nvarchar(1) | Net tonnage confidence |
ABSD_HIST — Vessel Status History
| Column | Type | Description |
|---|---|---|
LRNO | nvarchar(7) | Vessel LR number |
SEQNO | nvarchar(2) | Sequence ('00'=current) |
A02_EFD | nvarchar(6) | Status effective date |
A02_STS | nvarchar(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_CC | nvarchar(1) | Confidence code |
A02_SRCE | nvarchar(9) | Source |
ABSD_HIFC1 — Foreign Classification History (Primary)
| Column | Type | Description |
|---|---|---|
LRNO | nvarchar(7) | Vessel LR number |
SEQNO | nvarchar(2) | Sequence ('00'=current) |
B09_EFD | nvarchar(6) | Classification effective date |
B09_CC | nvarchar(1) | Confidence code |
B09_SRCE | nvarchar(9) | Source |
B09_VER | nvarchar(1) | Verification |
ABSD_HIBBC — Bareboat Charterer History
| Column | Type | Description |
|---|---|---|
LRNO | nvarchar(7) | Vessel LR number |
SEQNO | nvarchar(2) | Sequence ('00'=current) |
BBC_EFD | nvarchar(8) | BBC effective date |
BBC_CC | nvarchar(1) | Confidence code |
BBC_CODE | nvarchar(7) | Bareboat charterer company code |
ABSD_HIBR — Builder History
| Column | Type | Description |
|---|---|---|
LRNO | nvarchar(7) | Vessel LR number |
SEQNO | nvarchar(2) | Sequence |
C01_EFD | nvarchar(6) | Builder effective date |
C01_BLD_COMP | nvarchar(9) | Builder composite code (SBLDR_CMP format) |
C01_HUL_SECN | nvarchar(2) | Hull section code |
C01_CC | nvarchar(1) | Confidence code |
ABSD_HIGE — Generator / Electrical Equipment History
PK: LRNO + SEQNO + POS_CODE. One row per generator position.
| Column | Type | Description |
|---|---|---|
LRNO | nvarchar(7) | Vessel LR number |
SEQNO | nvarchar(2) | Sequence |
POS_CODE | nvarchar(3) | Generator position code |
E45_EFD | nvarchar(6) | Effective date |
E45_NO | smallint | Number of generators (max 2 digits) |
E45_KW | smallint | Power in kilowatts (max 5 digits) |
E45_VOLT | smallint | Voltage (max 5 digits) |
E45_FREQ | nvarchar(2) | Frequency: '50', '60', or '0' when E45_ACDC='A' |
E45_ACDC | nvarchar(1) | AC/DC/N/U/Y — AC requires frequency 50 or 60; DC requires frequency 0 |
E45_DM | nvarchar(6) | Date manufacturer — must be ≤ E45_EFD |
E45_ST | nvarchar(6) | Supertype — E45_ST > E45_EFD only if E45_GS='8' |
E45_PM_POS_1 – _9 | nvarchar(1) each | Prime mover position codes (validated against CBUB1 table 03) |
E45_GM | nvarchar(4) | Generator manufacturer code (validated against CBEB.MM codes) |
E45_GS | nvarchar(2) | Generator supertype (validated against CBUB1 table 19 or '8') |
E45_CC | nvarchar(1) | Confidence code |
E45_SRCE | nvarchar(9) | Source |
Other HI* Tables — Summary
| Table | Description | Key Fields |
|---|---|---|
ABSD_HIDR | Drydock/Repair history | Survey type, drydock date, yard |
ABSD_HIDE | Design/Engine modification | Engine type changes, design alterations |
ABSD_HILE | Hull dimensions history | Length, breadth, depth at each measurement |
ABSD_HILC | Load Line certificate history | Certificate number, issuer, dates |
ABSD_HIMO | Measurement history | Deadweight measurements by date |
ABSD_HIMT | Machinery trials history | Trial date, results, surveyor |
ABSD_HIPC | Port change history | Port of registry changes |
ABSD_HIPM | Port of management history | Management port |
ABSD_HIPS | Survey history | Survey type, date, result |
ABSD_HIPU | Purpose/Use history | Vessel purpose classification |
ABSD_HISE | Service history | Service type classification |
ABSD_HIBS | Hull survey history | Hull survey details |
ABSD_HITM | Trade mission history | Trade area codes |
ABSD_HITP | Trade/purpose classification | Purpose classification codes |
ABSD_HRXR | History cross-reference | Cross-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
| Column | Type | Description |
|---|---|---|
LRNO | nvarchar(7) | Vessel LR number |
DOB | nvarchar(6) | Date of build |
D02_SERVICE | nvarchar(21) | Service designation |
D06_EFD | nvarchar(6) | Passenger/crew capacity effective date |
D06_PASS_UN | smallint | Passengers underdeck (max 4 digits) |
D06_PASS_DK | smallint | Passengers on deck (max 4 digits) |
D06_PASS_BR | smallint | Passengers berthed (max 4 digits) |
D06_CREW_NO | smallint | Crew number (max 4 digits) |
D06_CBNS | smallint | Number of cabins (max 4 digits) |
D06_DVBR | smallint | Davit-launched lifeboat capacity (max 4 digits) |
D10_GRAIN | int | Grain capacity (m³, max 8 digits) |
D10_BALE | int | Bale capacity (m³, max 8 digits) |
D10_INULTD | int | Insulated capacity (m³, max 8 digits) |
D10_LQD | int | Liquid capacity (m³, max 8 digits) |
D10_LQG | int | Liquid gas capacity (m³, max 8 digits) |
D10_OIL | int | Oil capacity (m³, max 8 digits) |
D10_SEG_BLLST | int | Segregated ballast tank capacity (m³) |
D10_CLN_BLLST | int | Clean ballast capacity (m³) |
D10_VRT_BALE | int | Vertical bale capacity (m³) |
D10_OTHER_CAP | int | Other capacity (m³, max 8 digits) |
D10_OTHER_TYP | nvarchar(1) | Other capacity type code |
D10_HTNG_CLS | nvarchar(1) | Heating class: C=Cargo, P=Permanent, N=None, U=Unknown, Y=Yes |
D18_WNCHS_NO | smallint | Number of winches (max 2 digits; can only be >0 if FULI2 seq 01 has D19_LG_TYP='DE' or 'AF') |
D25_AUX_PROP | nvarchar(1) | Auxiliary propulsion: Y/N/U |
D25_NUCLR_PWR | nvarchar(1) | Nuclear powered: Y/N/U |
ABSD_FUDI1 — Deck/Mooring Equipment
| Column | Type | Description |
|---|---|---|
LRNO | nvarchar(7) | Vessel LR number |
D22_MANBOW_LEN | smallint | Man overboard bow length (max 4 digits; must be ≤ LBP or LOA from HILE) |
D22_MBL_CC | nvarchar(1) | Bow length confidence |
D22_DIS_DIAM | decimal(4,3) | Discharge diameter |
D22_MAN_TYP | nvarchar(1) | Manifold type (validated against CBUB3 table 01) |
D21_EFD | nvarchar(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
| Column | Type | Description |
|---|---|---|
LRNO | nvarchar(7) | Vessel LR number |
SEQ_NO | nvarchar(3) | Sequence within vessel |
D07_EFD | nvarchar(6) | Feature effective date |
D07_CC | nvarchar(1) | Confidence code |
D07_SRCE | nvarchar(9) | Source |
D07_CODE | nvarchar(4) | Special feature code (e.g., '3010'=double hull bottom, '3020'=double hull side, '0554'=LR class notation) |
D07_VER | nvarchar(1) | Verification |
Other FU* Tables — Summary
| Table | Description | Key Fields |
|---|---|---|
ABSD_FUCA1/2 | Cargo type (primary/secondary) | Cargo type code, effective date |
ABSD_FUCO1/2 | Container capacity | TEU, 14T TEU, homogeneous, reefer, reefer plugs, cell guides |
ABSD_FUHA1/2 | Hatch configuration | Hatch count, type, size |
ABSD_FULI1/2/3 | Lifting gear | Crane/derrick type, SWL, number — FULI2 D19_LG_TYP controls FUGE winch count |
ABSD_FULC | Liquid cargo details | Tank type, segregation |
ABSD_FUOF | Offshore features | DP system, anchoring |
ABSD_FURO1/2 | Ramp data | Ramp type, SWL, width |
ABSD_FUSP | Speed data | Service speed, max speed, trial speed |
ABSD_FUST1/2 | Tank data | Tank count, segregation, coatings |
ABSD_FUTO | Thruster data | Thruster type, power, position |
ABSD_FUUN1/2 | Bunker/fuel tank data | Fuel type, capacity, unit |
ABSD_FTME | Fire/thermal management equipment | Equipment type, rating |
ABSD_FTNT | Non-propulsion equipment | Auxiliary equipment specs |