Table: GEAR_CONDITION
Entity (ENT) | Northeast Fisheries Science Center (NEFSC)GUID: gov.noaa.nmfs.inport:31474 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
Support table for field GEARCOND in the table SVSTA_BASE. Identifies condition of the gear and is one component of the SHG value.
DescriptionSupport table for field GEARCOND in the table SVSTA_BASE. Identifies condition of the gear and is one component of the SHG value.
Entity Information
Entity Type
Data Table
Data Attribute / Type | Description |
---|---|
GEARCOND
VARCHAR2 |
Refer to SVDBS.GEAR_CONDITION table for gear condition codes and descriptions. |
GEAR_CONDITION
VARCHAR2 |
Description of gear condition. |
DOE
DATE |
Date when record was inserted into Oracle. Date format (MM/DD/YY HH:MI:SS). |
DOC
DATE |
Date when the current record was updated or changed. Date format (MM/DD/YY HH:MI:SS) |
UOE
VARCHAR2 |
The Oracle username of the individual who entered the new record. |
UOC
VARCHAR2 |
The Oracle username of the individual who changed the current 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: GEAR_CONDITION |
---|---|
Short Name: | GEAR_CONDITION |
Status: | Completed |
Abstract: |
Support table for field GEARCOND in the table SVSTA_BASE. Identifies condition of the gear and is one component of the SHG value. |
Notes: |
Loaded by batch 8359, 03-16-2016 14:35 |
Entity Information
Entity Type: | Data Table |
---|---|
Active Version?: | Yes |
Schema Name: | SVDBS |
Description: |
Support table for field GEARCOND in the table SVSTA_BASE. Identifies condition of the gear and is one component of the SHG value. |
Data Attributes
Attribute Summary
![]() |
![]() |
Name | Type | Description |
---|---|---|---|---|
100
|
![]() |
GEARCOND | VARCHAR2 | Refer to SVDBS.GEAR_CONDITION table for gear condition codes and descriptions. |
100
|
GEAR_CONDITION | VARCHAR2 | Description of gear condition. | |
100
|
DOE | DATE | Date when record was inserted into Oracle. Date format (MM/DD/YY HH:MI:SS). | |
100
|
DOC | DATE | Date when the current record was updated or changed. Date format (MM/DD/YY HH:MI:SS) | |
100
|
UOE | VARCHAR2 | The Oracle username of the individual who entered the new record. | |
100
|
UOC | VARCHAR2 | The Oracle username of the individual who changed the current record. |
Attribute Details
GEARCOND
Seq. Order: | 1 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | Yes |
Primary Key: | Yes |
Status: | Active |
Description: |
Refer to SVDBS.GEAR_CONDITION table for gear condition codes and descriptions. |
General Data Type: | VARCHAR2 |
GEAR_CONDITION
Seq. Order: | 2 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 300 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Description of gear condition. |
General Data Type: | VARCHAR2 |
DOE
Seq. Order: | 3 |
---|---|
Data Storage Type: | DATE |
Max Length: | 7 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Date when record was inserted into Oracle. Date format (MM/DD/YY HH:MI:SS). |
General Data Type: | DATE |
DOC
Seq. Order: | 4 |
---|---|
Data Storage Type: | DATE |
Max Length: | 7 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Date when the current record was updated or changed. Date format (MM/DD/YY HH:MI:SS) |
General Data Type: | DATE |
UOE
Seq. Order: | 5 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 8 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The Oracle username of the individual who entered the new record. |
General Data Type: | VARCHAR2 |
UOC
Seq. Order: | 6 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 8 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The Oracle username of the individual who changed the current record. |
General Data Type: | VARCHAR2 |
Catalog Details
Catalog Item ID: | 31474 |
---|---|
GUID: | gov.noaa.nmfs.inport:31474 |
Metadata Record Created By: | Patricia L Jones |
Metadata Record Created: | 2016-03-16 14:35+0000 |
Metadata Record Last Modified By: | SysAdmin InPortAdmin |
Metadata Record Last Modified: | 2022-08-09 17:11+0000 |
Metadata Record Published: | 2016-07-29 |
Owner Org: | NEFSC |
Metadata Publication Status: | Published Externally |
Do Not Publish?: | N |
Metadata Last Review Date: | 2016-07-29 |
Metadata Review Frequency: | 1 Year |
Metadata Next Review Date: | 2017-07-29 |