Table: OBTRIPEXT
Entity (ENT) | Northeast Fisheries Science Center (NEFSC)GUID: gov.noaa.nmfs.inport:33354 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
Observer Trip Extension Support Table
DescriptionObserver Trip Extension Support Table
Entity Information
Entity Type
Data Table
Data Attribute / Type | Description |
---|---|
TRIPEXT
VARCHAR2 |
Level of sampling of discards in the gillnet fishery, or whether or not trip aborted. See OBTRIPEXT table. Only recorded as to aborted prior to 5/1994; others set to x : unknown. Collected for ASM where applicable. |
TRIPEXTDESC
VARCHAR2 |
Description of trip extension identified by tripext code |
OBTRPEXTCOMMENTS
VARCHAR2 |
Additional information on trip extension identified by tripext and described in tripextdesc. |
DOE
DATE |
Date of Entry of the associated record. |
UOE
VARCHAR2 |
Oracle user ID of the person who entered the data. |
DOC
DATE |
Date associated record was updated. |
UOC
VARCHAR2 |
Oracle ID of user who made the (most recent ) change on the record. |
TRIPEXTLIST
VARCHAR2 |
Shortened description of trip extension identified by tripext code. |
Child Items
No Child Items for this record.
Contact Information
No contact information is available for this record.
Please contact the owner organization (NEFSC) for inquiries on this record.
Item Identification
Title: | Table: OBTRIPEXT |
---|---|
Short Name: | OBTRIPEXT |
Status: | Completed |
Abstract: |
Observer Trip Extension Support Table |
Notes: |
Loaded by batch 8950, 07-06-2016 08:24 |
Entity Information
Entity Type: | Data Table |
---|---|
Active Version?: | Yes |
Schema Name: | OBDBS |
Description: |
Observer Trip Extension Support Table |
Data Attributes
Attribute Summary
Name | Type | Description | ||
---|---|---|---|---|
100
|
TRIPEXT | VARCHAR2 | Level of sampling of discards in the gillnet fishery, or whether or not trip aborted. See OBTRIPEXT table. Only recorded as to aborted prior to 5/1994; others set to x : unknown. Collected for ASM where applicable. | |
100
|
TRIPEXTDESC | VARCHAR2 | Description of trip extension identified by tripext code | |
100
|
OBTRPEXTCOMMENTS | VARCHAR2 | Additional information on trip extension identified by tripext and described in tripextdesc. | |
100
|
DOE | DATE | Date of Entry of the associated record. | |
100
|
UOE | VARCHAR2 | Oracle user ID of the person who entered the data. | |
100
|
DOC | DATE | Date associated record was updated. | |
100
|
UOC | VARCHAR2 | Oracle ID of user who made the (most recent ) change on the record. | |
100
|
TRIPEXTLIST | VARCHAR2 | Shortened description of trip extension identified by tripext code. |
Attribute Details
TRIPEXT
Seq. Order: | 1 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | Yes |
Primary Key: | Yes |
Status: | Active |
Description: |
Level of sampling of discards in the gillnet fishery, or whether or not trip aborted. See OBTRIPEXT table. Only recorded as to aborted prior to 5/1994; others set to x : unknown. Collected for ASM where applicable. |
General Data Type: | VARCHAR2 |
TRIPEXTDESC
Seq. Order: | 2 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 45 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Description of trip extension identified by tripext code |
General Data Type: | VARCHAR2 |
OBTRPEXTCOMMENTS
Seq. Order: | 3 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 250 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Additional information on trip extension identified by tripext and described in tripextdesc. |
General Data Type: | VARCHAR2 |
DOE
Seq. Order: | 4 |
---|---|
Data Storage Type: | DATE |
Max Length: | 7 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Date of Entry of the associated record. |
General Data Type: | DATE |
UOE
Seq. Order: | 5 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 8 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Oracle user ID of the person who entered the data. |
General Data Type: | VARCHAR2 |
DOC
Seq. Order: | 6 |
---|---|
Data Storage Type: | DATE |
Max Length: | 7 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Date associated record was updated. |
General Data Type: | DATE |
UOC
Seq. Order: | 7 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 8 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Oracle ID of user who made the (most recent ) change on the record. |
General Data Type: | VARCHAR2 |
TRIPEXTLIST
Seq. Order: | 8 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 25 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Shortened description of trip extension identified by tripext code. |
General Data Type: | VARCHAR2 |
Catalog Details
Catalog Item ID: | 33354 |
---|---|
GUID: | gov.noaa.nmfs.inport:33354 |
Metadata Record Created By: | Patricia L Jones |
Metadata Record Created: | 2016-07-06 08:24+0000 |
Metadata Record Last Modified By: | SysAdmin InPortAdmin |
Metadata Record Last Modified: | 2022-08-09 17:11+0000 |
Metadata Record Published: | 2016-07-28 |
Owner Org: | NEFSC |
Metadata Publication Status: | Published Externally |
Do Not Publish?: | N |
Metadata Last Review Date: | 2016-07-28 |
Metadata Review Frequency: | 1 Year |
Metadata Next Review Date: | 2017-07-28 |