Table: SFOQVR
Greater Atlantic Regional Fisheries Office
Entity
(ENT)
| ID: 11924
| Published / External
Created: 2012-03-09
|
Last Modified: 2022-08-09
Parent: SC/OQ Vessel Database
Data Set (DS) | ID: 1503
Data Set (DS) | ID: 1503
ID: 11924
Entity (ENT)
* Discovery• First Pass
» Metadata Rubric
Item Identification
| * » Title | Table: SFOQVR |
|---|---|
| Short Name | SFOQVR |
| * Status | Completed |
| Creation Date | |
| Revision Date | |
| • Publication Date | |
| * » Abstract |
Main Surf Clam/Ocean Quahog vessel logbook table. |
| * Purpose |
Holds data for SF/OQ vessel logbook records. |
| Notes |
Loaded by batch 2887, 03-09-2012 12:19 |
| Other Citation Details | |
| • Supplemental Information |
Server: NERO Schema: SFCLAM Table: SFOQVR (Surf Clam-Ocean Quahog-Vessel Report) |
| DOI (Digital Object Identifier) | |
| DOI Registration Authority | |
| DOI Issue Date |
Keywords
Theme Keywords
| Thesaurus | Keyword |
|---|---|
| None | individual transferable quota |
| None | itq |
| None | ocean quahog |
| None | oq |
| None | quota monitoring |
| None | sc |
| None | sc/oq |
| None | surf clam |
| None | surfclam |
| None | vessel logbook reporting |
| None | vessel reporting |
Temporal Keywords
| Thesaurus | Keyword |
|---|---|
| None | 1978-present |
* Spatial Keywords
| Thesaurus | Keyword |
|---|---|
| None | atlantic |
| None | connecticut |
| None | ct |
| None | de |
| None | delaware |
| None | gloucester |
| None | ma |
| None | maine |
| None | maryland |
| None | massachusetts |
| None | md |
| None | me |
| None | ne |
| None | nero |
| None | new england |
| None | new hampshire |
| None | new jersey |
| None | new york |
| None | nj |
| None | northeast |
| None | ny |
| None | rhode island |
| None | ri |
| None | va |
| None | virginia |
Stratum Keywords
| Thesaurus | Keyword |
|---|---|
| None | area |
| None | gear |
| None | species |
Instrument Keywords
| Thesaurus | Keyword |
|---|---|
Platform Keywords
| Thesaurus | Keyword |
|---|---|
Physical Location
| • » Organization | Greater Atlantic Regional Fisheries Office |
|---|---|
| • » City | Gloucester |
| • » State/Province | MA |
| • Country | USA |
| • » Location Description |
Fisheries Data Services Division (FDSD) 55 Great Republic Drive |
Entity Information
| Entity Type | Data Table |
|---|---|
| Active Version? | Y |
| Alias | |
| Schema Name | SFCLAM |
| » Description |
Holds data for SF/OQ vessel logbook records. |
| Change Summary |
Data Attributes
Attribute Summary
| Score | Req'd? | PKey? | » Name | Data Storage Type | Description |
|---|---|---|---|---|---|
| 100 | Yes | Yes | VR_REC_ID | NUMBER | Unique record identification number; generated by the system at data entry. |
| 100 | No | No | DNUM | NUMBER | Dealer permit number. |
| 100 | No | No | NUM | NUMBER | Vessel permit number. |
| 100 | No | No | CD | DATE | Catch date. |
| 100 | No | No | LAT | VARCHAR2 | Latitude degrees concatenated with latitude minutes. |
| 100 | No | No | LON | VARCHAR2 | Longitude degrees concatenated with longitude minutes. |
| 100 | No | No | TAS | NUMBER | Time at sea (tenths of hours). |
| 100 | No | No | TF | NUMBER | Time fished (tenths of hours). |
| 100 | No | No | BUSH | NUMBER | Number of bushels landed (32 cages = 1 bushel). |
| 100 | No | No | DISP | NUMBER | Percent of catch discarded by the vessel. |
| 100 | No | No | ST | VARCHAR2 | 2 digit state code. Link to VTR.PORT.STATECD. |
| 100 | No | No | PC | VARCHAR2 | 2 digit port code. Link to VTR.PORT.PORT2. |
| 100 | No | No | CY | VARCHAR2 | 2 digit county code. Link to VTR.PORT.COUNTYCD. |
| 100 | No | No | PR | NUMBER | Price per bushel in dollars. |
| 100 | No | No | ANUM | VARCHAR2 | Allocation number. |
| 100 | No | No | TRIP_NUM | NUMBER | Trip number. Set automatically by application. User may override but not set directly. |
| 100 | No | No | DE | DATE | Date record was loaded into table. |
| 100 | No | No | UE | VARCHAR2 | User loading data into table. |
| 100 | No | No | DC | DATE | Date of most recent update(s) to record. |
| 100 | No | No | UC | VARCHAR2 | User making most recent update(s) to record. |
| 100 | No | No | LORAN1 | VARCHAR2 | Loran bearing 1. |
| 100 | No | No | LORAN2 | VARCHAR2 | Loran bearing 2. |
| 100 | No | No | CHANGE | VARCHAR2 | Change flag. T indicates user forced retention of previous trip number. |
| 100 | No | No | CAREA | VARCHAR2 | Calculated area. |
| 100 | No | No | CLATDEG | VARCHAR2 | Calculated latitude degrees. |
| 100 | No | No | CLATMIN | VARCHAR2 | Calculated latitude minutes. |
| 100 | No | No | CLATSEC | VARCHAR2 | Calculated latitude seconds. |
| 100 | No | No | CLONDEG | VARCHAR2 | Calculated longitude degrees. |
| 100 | No | No | CLONMIN | VARCHAR2 | Calculated longitude minutes. |
| 100 | No | No | CLONSEC | VARCHAR2 | Calculated longitude seconds. |
| 100 | No | No | CFZONE | VARCHAR2 | Calculated fishing zone. |
| 100 | No | No | CQDSQ | VARCHAR2 | Calculated quarter-degree square. |
| 100 | No | No | CTNMS | VARCHAR2 | Calculated ten minute square. |
| 100 | No | No | CERRNO | NUMBER | Calculated error code. Codes range from 1-12. |
Attribute Details
| Attribute Name | VR_REC_ID |
|---|---|
| Seq. Order | 1 |
| Data Storage Type | NUMBER |
| Max Length | 22 |
| Min Length | |
| Required | Yes |
| Primary Key | Yes |
| Precision | 6 |
| Scale | 0 |
| Status | Active |
| Description |
Unique record identification number; generated by the system at data entry. |
| General Data Type | NUMBER |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | DNUM |
|---|---|
| Seq. Order | 2 |
| Data Storage Type | NUMBER |
| Max Length | 22 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 5 |
| Scale | 0 |
| Status | Active |
| Description |
Dealer permit number. |
| General Data Type | NUMBER |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | NUM |
|---|---|
| Seq. Order | 3 |
| Data Storage Type | NUMBER |
| Max Length | 22 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 6 |
| Scale | 0 |
| Status | Active |
| Description |
Vessel permit number. |
| General Data Type | NUMBER |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | CD |
|---|---|
| Seq. Order | 4 |
| Data Storage Type | DATE |
| Max Length | 7 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Catch date. |
| General Data Type | DATE |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | LAT |
|---|---|
| Seq. Order | 5 |
| Data Storage Type | VARCHAR2 |
| Max Length | 5 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Latitude degrees concatenated with latitude minutes. |
| General Data Type | VARCHAR2 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | LON |
|---|---|
| Seq. Order | 6 |
| Data Storage Type | VARCHAR2 |
| Max Length | 5 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Longitude degrees concatenated with longitude minutes. |
| General Data Type | VARCHAR2 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | TAS |
|---|---|
| Seq. Order | 7 |
| Data Storage Type | NUMBER |
| Max Length | 22 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 4 |
| Scale | 1 |
| Status | Active |
| Description |
Time at sea (tenths of hours). |
| General Data Type | NUMBER |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | TF |
|---|---|
| Seq. Order | 8 |
| Data Storage Type | NUMBER |
| Max Length | 22 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 4 |
| Scale | 1 |
| Status | Active |
| Description |
Time fished (tenths of hours). |
| General Data Type | NUMBER |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | BUSH |
|---|---|
| Seq. Order | 9 |
| Data Storage Type | NUMBER |
| Max Length | 22 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 4 |
| Scale | 0 |
| Status | Active |
| Description |
Number of bushels landed (32 cages = 1 bushel). |
| General Data Type | NUMBER |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | DISP |
|---|---|
| Seq. Order | 10 |
| Data Storage Type | NUMBER |
| Max Length | 22 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 3 |
| Scale | 1 |
| Status | Active |
| Description |
Percent of catch discarded by the vessel. |
| General Data Type | NUMBER |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | ST |
|---|---|
| Seq. Order | 11 |
| Data Storage Type | VARCHAR2 |
| Max Length | 2 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
2 digit state code. Link to VTR.PORT.STATECD. |
| General Data Type | VARCHAR2 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | PC |
|---|---|
| Seq. Order | 12 |
| Data Storage Type | VARCHAR2 |
| Max Length | 2 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
2 digit port code. Link to VTR.PORT.PORT2. |
| General Data Type | VARCHAR2 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | CY |
|---|---|
| Seq. Order | 13 |
| Data Storage Type | VARCHAR2 |
| Max Length | 2 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
2 digit county code. Link to VTR.PORT.COUNTYCD. |
| General Data Type | VARCHAR2 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | PR |
|---|---|
| Seq. Order | 14 |
| Data Storage Type | NUMBER |
| Max Length | 22 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 5 |
| Scale | 2 |
| Status | Active |
| Description |
Price per bushel in dollars. |
| General Data Type | NUMBER |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | ANUM |
|---|---|
| Seq. Order | 15 |
| Data Storage Type | VARCHAR2 |
| Max Length | 4 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Allocation number. |
| General Data Type | VARCHAR2 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | TRIP_NUM |
|---|---|
| Seq. Order | 16 |
| Data Storage Type | NUMBER |
| Max Length | 22 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 6 |
| Scale | 0 |
| Status | Active |
| Description |
Trip number. Set automatically by application. User may override but not set directly. |
| General Data Type | NUMBER |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | DE |
|---|---|
| Seq. Order | 17 |
| Data Storage Type | DATE |
| Max Length | 7 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Date record was loaded into table. |
| General Data Type | DATE |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | UE |
|---|---|
| Seq. Order | 18 |
| Data Storage Type | VARCHAR2 |
| Max Length | 15 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
User loading data into table. |
| General Data Type | VARCHAR2 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | DC |
|---|---|
| Seq. Order | 19 |
| Data Storage Type | DATE |
| Max Length | 7 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Date of most recent update(s) to record. |
| General Data Type | DATE |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | UC |
|---|---|
| Seq. Order | 20 |
| Data Storage Type | VARCHAR2 |
| Max Length | 15 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
User making most recent update(s) to record. |
| General Data Type | VARCHAR2 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | LORAN1 |
|---|---|
| Seq. Order | 21 |
| Data Storage Type | VARCHAR2 |
| Max Length | 5 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Loran bearing 1. |
| General Data Type | VARCHAR2 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | LORAN2 |
|---|---|
| Seq. Order | 22 |
| Data Storage Type | VARCHAR2 |
| Max Length | 5 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Loran bearing 2. |
| General Data Type | VARCHAR2 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | CHANGE |
|---|---|
| Seq. Order | 23 |
| Data Storage Type | VARCHAR2 |
| Max Length | 1 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Change flag. T indicates user forced retention of previous trip number. |
| General Data Type | VARCHAR2 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | CAREA |
|---|---|
| Seq. Order | 24 |
| Data Storage Type | VARCHAR2 |
| Max Length | 3 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Calculated area. |
| General Data Type | VARCHAR2 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | CLATDEG |
|---|---|
| Seq. Order | 25 |
| Data Storage Type | VARCHAR2 |
| Max Length | 2 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Calculated latitude degrees. |
| General Data Type | VARCHAR2 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | CLATMIN |
|---|---|
| Seq. Order | 26 |
| Data Storage Type | VARCHAR2 |
| Max Length | 2 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Calculated latitude minutes. |
| General Data Type | VARCHAR2 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | CLATSEC |
|---|---|
| Seq. Order | 27 |
| Data Storage Type | VARCHAR2 |
| Max Length | 2 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Calculated latitude seconds. |
| General Data Type | VARCHAR2 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | CLONDEG |
|---|---|
| Seq. Order | 28 |
| Data Storage Type | VARCHAR2 |
| Max Length | 2 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Calculated longitude degrees. |
| General Data Type | VARCHAR2 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | CLONMIN |
|---|---|
| Seq. Order | 29 |
| Data Storage Type | VARCHAR2 |
| Max Length | 2 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Calculated longitude minutes. |
| General Data Type | VARCHAR2 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | CLONSEC |
|---|---|
| Seq. Order | 30 |
| Data Storage Type | VARCHAR2 |
| Max Length | 2 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Calculated longitude seconds. |
| General Data Type | VARCHAR2 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | CFZONE |
|---|---|
| Seq. Order | 31 |
| Data Storage Type | VARCHAR2 |
| Max Length | 1 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Calculated fishing zone. |
| General Data Type | VARCHAR2 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | CQDSQ |
|---|---|
| Seq. Order | 32 |
| Data Storage Type | VARCHAR2 |
| Max Length | 5 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Calculated quarter-degree square. |
| General Data Type | VARCHAR2 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | CTNMS |
|---|---|
| Seq. Order | 33 |
| Data Storage Type | VARCHAR2 |
| Max Length | 6 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Calculated ten minute square. |
| General Data Type | VARCHAR2 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | CERRNO |
|---|---|
| Seq. Order | 34 |
| Data Storage Type | NUMBER |
| Max Length | 22 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 3 |
| Scale | 0 |
| Status | Active |
| Description |
Calculated error code. Codes range from 1-12. |
| General Data Type | NUMBER |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | |
|---|---|
| Seq. Order | |
| Data Storage Type | |
| Max Length | |
| Precision | |
| Scale | |
| Required | |
| Primary Key | |
| Status | |
| Description | |
| General Data Type | |
| Case Restriction | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Min Length | |
| Unit of Measure | |
| Display Example | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | |
|---|---|
| Seq. Order | |
| Data Storage Type | |
| Max Length | |
| Precision | |
| Scale | |
| Required | |
| Primary Key | |
| Status | |
| Description | |
| General Data Type | |
| Case Restriction | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Min Length | |
| Unit of Measure | |
| Display Example | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | |
|---|---|
| Seq. Order | |
| Data Storage Type | |
| Max Length | |
| Precision | |
| Scale | |
| Required | |
| Primary Key | |
| Status | |
| Description | |
| General Data Type | |
| Case Restriction | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Min Length | |
| Unit of Measure | |
| Display Example | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
Support Roles
» At least one Distributor Org, one Metadata Contact, one Point of Contact, and one Data Steward should be listed.
| * » Support Role | Metadata Contact |
|---|---|
| * » Date Effective From | 2010-01-01 |
| Date Effective To | |
| Person | Ferguson, Alison |
| Address |
55 Great Republic Drive Gloucester, MA 01930 United States |
| Email Address | alison.ferguson@noaa.gov |
| Phone | 978-281-9209 |
| Fax | 978-281-9161 |
| Mobile | |
| URL | |
| Business Hours | |
| Contact Instructions |
| * » Support Role | Originator |
|---|---|
| * » Date Effective From | 2000-01-01 |
| Date Effective To | 2010-01-01 |
| Person | Power, Gregory |
| Address |
55 Great Republic Drive Gloucester, MA 01930 USA |
| Email Address | greg.power@noaa.gov |
| Phone | 978-281-9304 |
| Fax | 978-281-9161 |
| Mobile | |
| URL | |
| Business Hours | |
| Contact Instructions |
| * » Support Role | Point of Contact |
|---|---|
| * » Date Effective From | 2010-01-01 |
| Date Effective To | |
| Person | St Cyr, James R |
| Address |
55 Great Republic Drive Gloucester, MA 01930 USA |
| Email Address | james.stcyr@noaa.gov |
| Phone | 978-281-9369 |
| Fax | |
| Mobile | |
| URL | |
| Business Hours | |
| Contact Instructions |
| * » Support Role | |
|---|---|
| * » Date Effective From | |
| Date Effective To | |
| * » Contact | |
| * Contact Instructions |
| * » Support Role | |
|---|---|
| * » Date Effective From | |
| Date Effective To | |
| * » Contact | |
| * Contact Instructions |
| * » Support Role | |
|---|---|
| * » Date Effective From | |
| Date Effective To | |
| * » Contact | |
| * Contact Instructions |
Extents
| Currentness Reference |
|---|
Extent Group 1
| Extent Description |
|---|
Extent Group 1 / Geographic Area
| * » W° Bound | |
|---|---|
| * » E° Bound | |
| * » N° Bound | |
| * » S° Bound | |
| * » Description |
Extent Group 1 / Vertical Extent
| EPSG Code | |
|---|---|
| Vertical Minimum | |
| Vertical Maximum |
Extent Group 1 / Time Frame 1
| * » Time Frame Type | Continuing |
|---|---|
| * » Start | 1978 |
| End | |
| Alternate Start As Of Info | |
| Alternate End As Of Info | |
| Description |
Beginning in 1978, participation in the surf clam fishery became conditional upon a set of requirements including detailed logbook reporting. In the early 1980's ocean quahog vessels became subject to the same detailed logbook reporting requirements. |
Access Information
| * » Security Class | Confidential |
|---|---|
| * Security Classification System |
Vessel trip reports are considered to be business confidential and may not be released without signed approval of the permit holder on record for the time period requested. |
| Security Handling Description | |
| • Data Access Policy |
Access to VTR data is governed by 50CFR600 - Confidentiality of Information. Access by state fishery management agency staff and Fisheries Management Council staff may be allowed through Memorandum of Understanding that are signed by the NE Regional Administrator and Directors of the State Agency or Councils that describe the need and uses of the data and list the individuals who will have access to the data. Contractors may be granted access provided they are working under contract to NOAA or a cooperating partner (state, Council, Commission) on a specific project under the oversight of a partner. |
| » Data Access Procedure |
Contact POC to request access. |
| • » Data Access Constraints |
Access is restricted to personnel authorized in accordance with NOAA Administrative Order 216-100. A signed non-disclosure agreement must be on file for all authorized personnel. The APSD Data Request staff are the POC for non-disclosure forms. |
| • Data Use Constraints |
Access to individual reports is restricted to NOAA employees and our partners who have signed non-disclosure agreements. Summary data may be made available based on the "rule of 3", i.e., there must be at least three entities included in a summary for the summary information to be made publically available. Data may be made available if there is no information included that could uniquely link the information to an individual entity (person, vessel operating unit, business, etc.). Individually identifiable information may not be released without written authorization from the provider or by court order. |
| Metadata Access Constraints | |
| Metadata Use Constraints |
There are no constraints on the use of the metadata associated with this program. |
Distribution Information
| Start Date | |
|---|---|
| End Date | |
| » Download URL | |
| Distributor | |
| File Name | |
| Description | |
| File Date/Time | |
| File Type | |
| FGDC Content Type | |
| File Size | |
| Application Version | |
| Compression | |
| Review Status |
| Start Date | |
|---|---|
| End Date | |
| » Download URL | |
| Distributor | |
| File Name | |
| Description | |
| File Date/Time | |
| File Type | |
| FGDC Content Type | |
| File Size | |
| Application Version | |
| Compression | |
| Review Status |
| Start Date | |
|---|---|
| End Date | |
| » Download URL | |
| Distributor | |
| File Name | |
| Description | |
| File Date/Time | |
| File Type | |
| FGDC Content Type | |
| File Size | |
| Application Version | |
| Compression | |
| Review Status |
Activity Log
| Activity Time | |
|---|---|
| Activity Type | |
| Responsible Party | |
| Description |
| Activity Time | |
|---|---|
| Activity Type | |
| Responsible Party | |
| Description |
| Activity Time | |
|---|---|
| Activity Type | |
| Responsible Party | |
| Description |
Issues
| Issue Date | |
|---|---|
| Author | |
| Issue |
| Issue Date | |
|---|---|
| Author | |
| Issue |
| Issue Date | |
|---|---|
| Author | |
| Issue |
FAQs
| Date | |
|---|---|
| Author | |
| Question | |
| Answer |
Child Items
Rubric scores updated every 15m
| Score | Type | Title |
|---|---|---|
Related Items
| Item Type | Relationship Type | Title |
|---|---|---|
Catalog Details
| Catalog Item ID | 11924 |
|---|---|
| Metadata Record Created By | Patrick R Rohan |
| Metadata Record Created | 2012-03-09 12:19+0000 |
| Metadata Record Last Modified By | SysAdmin InPortAdmin |
| » Metadata Record Last Modified | 2022-08-09 17:11+0000 |
| Metadata Record Published | 2016-02-25 |
| Owner Org | GARFO |
| Metadata Publication Status | Published Externally |
| Do Not Publish? | N |
| Metadata Workflow State | Published / External |
| Metadata Last Review Date | 2016-02-25 |
| Metadata Review Frequency | 1 Year |
| Metadata Next Review Date | 2017-02-25 |
| Tags |
|---|