| Column name |
Type |
Definition |
| VESSEL |
varchar2(4) |
A unique four-digit, alpha-numeric code identifying each domestic vessel or plant that contracts for observer coverage. All vessel codes begin with the alpha code A, followed by a three-digit number, or for plants, the codes begin with the alpha code P, followed by a three-digit number. |
| VESSEL_NAME |
varchar2(30) |
The name of the vessel. |
| PERMIT |
number(5,0) |
The last four (or five) digits of the permit number. |
| ADFG_NUMBER |
varchar2(8) |
This is the ADFG number of the vessel. |
| CG_NUMBER |
varchar2(8) |
This is the US Coast Guard number of the vessel. |
| NMFS_PROCESSOR |
varchar2(5) |
For vessels that occasionally process fish caught by another vessel (and also catch and process their own fish), this starts with an M, followed by the last four digits of the permit number. For vessels or plants that only process fish (but don't catch fish), this starts with an F, followed by four digits. This field is null for vessels that don't process fish caught by another vessel. |
| STATE_PROCESSOR |
varchar2(5) |
Typically this is the last four digits of a shoreside plant's permit number. Is typically null for vessels. |
| OLD_VESSEL |
varchar2(4) |
This is the old 4-digit alpha-numeric code of the vessel or plant. |
| RECORD_TYPE |
varchar2(1) |
V is for vessel; P is for plant; N is for unknown. |
| OBSERVER_COVERAGE |
varchar2(1) |
For plants and floating processors only, N means that no observer coverage is required and Y means that observer coverage is required. |
| COMPANY |
varchar2(50) |
The name of the company that owns or manages the vessel or plant. |
| COMPANY_ADDRESS |
varchar2(50) |
The street address of the company's main office. |
| COMPANY_CITY |
varchar2(25) |
The city in which the company's main office resides. |
| COMPANY_STATE |
varchar2(2) |
The state in which the company's main office resides. |
| COMPANY_ZIPCODE |
varchar2(10) |
The zipcode of the company's main office. |
| COMPANY_PHONE |
varchar2(13) |
The company's main phone number, including area code. |
| CALL_SIGN |
varchar2(12) |
This field is mostly null. It should contain the call sign of the vessel. |
| COMMUNICATION_NUMBER |
varchar2(20) |
A phone number for the vessel itself. |
| COMM_TYPE |
varchar2(1) |
Unknown code going from 0 to 5. |
| STANDARD_A |
varchar2(1) |
This field is null. |
| STANDARD_C |
varchar2(1) |
This field is null. |
| GEAR_LIST |
varchar2(8) |
J is jig; L is longline; P is pot; T is trawl. |
| PROCESS_MODE |
varchar2(4) |
C is catcher vessel; CP is catcher/processor vessel; F is floating processor; M is mothership; P is shoreside processing plant. |
| VESSEL_LENGTH |
number(4,0) |
This is the length overall (in feet) of the vessel. |
| GROSS_WEIGHT |
number(6,0) |
Gross Registered Tons of the vessel. |
| HORSE_POWER |
number(4,0) |
Horsepower of the vessel. |
| VESSEL_NOTES |
varchar2(40) |
Notes of interest about the vessel or plant. |
| DATE_OF_ENTRY |
date |
Date when this record was first added to the table. |
| DATE_OF_CHANGE |
date |
Date when the most recent change was made to this record. |
| CDQ_CONTACT |
varchar2(50) |
Name of the individual who is the cdq contact person. |
| CDQ_PHONE |
varchar2(13) |
Phone number of the cdq contact person. |
| CDQ_FAX |
varchar2(13) |
Fax number of the cdq contact person. |
| CDQ_EMAIL |
varchar2(60) |
E-mail address of the cdq contact person. |
| CDQ_LAST_CONTACT |
date |
The last time this cdq person was contacted. |
| CDQ_PHONE2 |
varchar2(20) |
Second phone number of the cdq contact person. |
| CDQ_FAX2 |
varchar2(20) |
Second fax number of the cdq contact person. |
