Search Help Show/Hide Menu
Summary
Item Identification
Entity Info
Data Attributes
Activity Log
Catalog Details

Summary

Abstract

A table of different Dialect names for a specific Gear and Form Template.

Description

A 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

Rubric Score Primary Key? Name Type Description
100
Primary Key DIALECT_CD VARCHAR2 FK to DIALECT_LIST. Supports different Gear Names grouped by Dialect.
100
Primary Key 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

CC ID: 246889
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

CC ID: 246890
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

CC ID: 246891
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

CC ID: 246892
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

CC ID: 246893
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

CC ID: 246894
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

CC ID: 256526
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

CC ID: 256527
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