Table: OBEQUIP
Entity (ENT) | Northeast Fisheries Science Center (NEFSC)GUID: gov.noaa.nmfs.inport:33335 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
Observer Equipment Support Table
DescriptionObserver Equipment Support Table
Entity Information
Entity Type
Data Table
Data Attribute / Type | Description |
---|---|
EQUIPCOD
VARCHAR2 |
Code for type of equipment. See OBEQUIP table. |
EQUIPNM
VARCHAR2 |
Name of the equipment coded in the OBEQUIP table |
EQUIPTYP
VARCHAR2 |
WHEELHOUSE, GEAR MOUNTED, PROCESSING, REFRIGERATION, WHEELHOUSE OR UNKNOWN |
EQUIPCOMMENTS
VARCHAR2 |
Additional information about equipment code or description |
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. |
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: OBEQUIP |
---|---|
Short Name: | OBEQUIP |
Status: | Completed |
Abstract: |
Observer Equipment 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 Equipment Support Table |
Data Attributes
Attribute Summary
Name | Type | Description | ||
---|---|---|---|---|
100
|
EQUIPCOD | VARCHAR2 | Code for type of equipment. See OBEQUIP table. | |
100
|
EQUIPNM | VARCHAR2 | Name of the equipment coded in the OBEQUIP table | |
100
|
EQUIPTYP | VARCHAR2 | WHEELHOUSE, GEAR MOUNTED, PROCESSING, REFRIGERATION, WHEELHOUSE OR UNKNOWN | |
100
|
EQUIPCOMMENTS | VARCHAR2 | Additional information about equipment code or description | |
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. |
Attribute Details
EQUIPCOD
Seq. Order: | 1 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | Yes |
Primary Key: | Yes |
Status: | Active |
Description: |
Code for type of equipment. See OBEQUIP table. |
General Data Type: | VARCHAR2 |
EQUIPNM
Seq. Order: | 2 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 50 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Name of the equipment coded in the OBEQUIP table |
General Data Type: | VARCHAR2 |
EQUIPTYP
Seq. Order: | 3 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 15 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
WHEELHOUSE, GEAR MOUNTED, PROCESSING, REFRIGERATION, WHEELHOUSE OR UNKNOWN |
General Data Type: | VARCHAR2 |
EQUIPCOMMENTS
Seq. Order: | 4 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 250 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Additional information about equipment code or description |
General Data Type: | VARCHAR2 |
DOE
Seq. Order: | 5 |
---|---|
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: | 6 |
---|---|
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: | 7 |
---|---|
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: | 8 |
---|---|
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 |
Catalog Details
Catalog Item ID: | 33335 |
---|---|
GUID: | gov.noaa.nmfs.inport:33335 |
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 |