Table: DIALECT_GEAR_LIST
Entity (ENT) | Southeast Fisheries Science Center (SEFSC)GUID: gov.noaa.nmfs.inport:28533 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
A table of different Dialect names for a specific Gear and Form Template.
DescriptionA table of different Dialect names for a specific Gear and Form Template.
Entity Information
Entity Type
Data Table
Data Attribute / Type | Description |
---|---|
DIALECT_CD
VARCHAR2 |
FK to DIALECT_LIST. Supports different Gear Names grouped by Dialect. |
GEAR_CD
VARCHAR2 |
FK to GEAR_LIST. Links a specific gear to an alternate name using a Dialect. |
DIALECT_GEAR_NM
VARCHAR2 |
The alternate name for a Gear based on the chosen dialect. |
SEQ
NUMBER |
The display sequence (order by). To help the online forms match the paper forms. |
LU_DT
DATE |
Last update date. |
LU_USER_ID
NUMBER |
Last update user. |
Child Items
No Child Items for this record.
Contact Information
No contact information is available for this record.
Please contact the owner organization (SEFSC) for inquiries on this record.
Item Identification
Title: | Table: DIALECT_GEAR_LIST |
---|---|
Short Name: | DIALECT_GEAR_LIST |
Status: | Completed |
Abstract: |
A table of different Dialect names for a specific Gear and Form Template. |
Notes: |
Loaded by batch 7533, 11-05-2015 16:10 |
Entity Information
Entity Type: | Data Table |
---|---|
Active Version?: | Yes |
Schema Name: | CCL |
Description: |
A table of different Dialect names for a specific Gear and Form Template. |
Data Attributes
Attribute Summary
Name | Type | Description | ||
---|---|---|---|---|
100
|
DIALECT_CD | VARCHAR2 | FK to DIALECT_LIST. Supports different Gear Names grouped by Dialect. | |
100
|
GEAR_CD | VARCHAR2 | FK to GEAR_LIST. Links a specific gear to an alternate name using a Dialect. | |
100
|
DIALECT_GEAR_NM | VARCHAR2 | The alternate name for a Gear based on the chosen dialect. | |
100
|
SEQ | NUMBER | The display sequence (order by). To help the online forms match the paper forms. | |
100
|
LU_DT | DATE | Last update date. | |
100
|
LU_USER_ID | NUMBER | Last update user. |
Attribute Details
DIALECT_CD
Seq. Order: | 1 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 30 |
Required: | Yes |
Primary Key: | Yes |
Status: | Active |
Description: |
FK to DIALECT_LIST. Supports different Gear Names grouped by Dialect. |
General Data Type: | VARCHAR2 |
Foreign Key Relations: |
CCL.DIALECT_LIST |
GEAR_CD
Seq. Order: | 2 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 30 |
Required: | Yes |
Primary Key: | Yes |
Status: | Active |
Description: |
FK to GEAR_LIST. Links a specific gear to an alternate name using a Dialect. |
General Data Type: | VARCHAR2 |
Foreign Key Relations: |
CCL.GEAR_LIST |
DIALECT_GEAR_NM
Seq. Order: | 3 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 60 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The alternate name for a Gear based on the chosen dialect. |
General Data Type: | VARCHAR2 |
SEQ
Seq. Order: | 4 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Scale: | 0 |
Status: | Active |
Description: |
The display sequence (order by). To help the online forms match the paper forms. |
General Data Type: | NUMBER |
LU_DT
Seq. Order: | 5 |
---|---|
Data Storage Type: | DATE |
Max Length: | 7 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Last update date. |
General Data Type: | DATE |
LU_USER_ID
Seq. Order: | 6 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
Last update user. |
General Data Type: | NUMBER |
Activity Log
Activity Log 1
Activity Date/Time: | 2011-11-23 |
---|---|
Activity Type: | Gear code additions and edits |
Responsible Party: | Joshua Bennett |
Description: |
Gear Code HL_POW was replaced by HL_TROLL in lookups and data. (The spanish name is SILGA for trolling hook and line). HL_POW_REEL was added to (spanish name is MALACATE for hook and line, electric reel). HL_HAND code gear name ('HAND') was renamed 'HANDLINE' in lookup and 'CORDEL DE MANO' in dialect lookup. Bottom Longline (CODE HL_BLL) was renamed (PALANGRE DE FONDO)IN dialect lookup. Drift Longline (code HL_DLL) was renamed (PALANGRE horizontal DE superfecie) IN dialect lookup. Vertical Longline (code HL_VLL) was renamed (PALANGRE vertical) IN dialect lookup. HL_BUOY (yo-yo) was dropped from dialect list. New code 'HL_BOTTOM' (Bottom Fishing Hook and Line) was added to lookup and listed as 'CALA' in dialect list. Another gear code addition: GILL_NET_BOTT for Gill Nets Fished on or near the sea bottom. Translates to Trasmallo in dialect list for SP01. The code of GILL_NET, named SURFACE GILL NET, was retained for surface gill nets and translates now to FILETE in dialect list for SP01. |
Activity Log 2
Activity Date/Time: | 2015-11-23 |
---|---|
Activity Type: | Gear code additions |
Responsible Party: | Joshua Bennett |
Description: |
Gear codes NET_AQUARFISH for 'AQUARIUM FISH NET' and NET_GILL_SCUBA 'GILL NET, FISHED USING SCUBA' were added to the CCL.GEAR_LIST table and to the CCL.DIALECT_GEAR_LIST as 'REDES PARA PECES ORNAMENTALES' AND 'TRASMALLO CON BUCEO CON TANQUE' respectively. |
Catalog Details
Catalog Item ID: | 28533 |
---|---|
GUID: | gov.noaa.nmfs.inport:28533 |
Metadata Record Created By: | Joshua Bennett |
Metadata Record Created: | 2015-11-05 16:10+0000 |
Metadata Record Last Modified By: | SysAdmin InPortAdmin |
Metadata Record Last Modified: | 2022-08-09 17:11+0000 |
Metadata Record Published: | 2021-05-06 |
Owner Org: | SEFSC |
Metadata Publication Status: | Published Externally |
Do Not Publish?: | N |
Metadata Last Review Date: | 2021-05-06 |
Metadata Review Frequency: | 1 Year |
Metadata Next Review Date: | 2022-05-06 |