Slide Menu
Search Help Show/Hide Menu

Item Identification

Title: Table: FLS_GEAR_PARAMETER_CODES
Short Name: FLS_GEAR_PARAMETER_CODES
Status: Completed
Abstract:

All possible parameters that can be measured for a gear, along with the acceptable minimum and maximum values for each parameter. The primary key on this table is composed of the GEAR_CLASS and GEAR_PARAMETER_CODE. This ensures that all parameter codes are unique for each gear class

Notes:

Loaded by batch 2103, 02-28-2008 14:10

Keywords

Theme Keywords

Thesaurus Keyword
UNCONTROLLED
None Gear Parameters

Entity Information

Entity Type: Data Table
Active Version?: Yes
Schema Name: FLS
Description:

All possible parameters that can be measured for a gear, along with the acceptable minimum and maximum values for each parameter. The primary key on this table is composed of the GEAR_CLASS and GEAR_PARAMETER_CODE. This ensures that all parameter codes are unique for each gear class

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key GEAR_CLASS VARCHAR2 Broad category which includes related gears that share the same characteristic.
100
Primary Key GEAR_PARAMETER_CODE VARCHAR2 Measurable characteristic of a gear such as line length, number of hooks, etc.
100
PARAMETER_DESCRIPTION VARCHAR2 Description of the gear parameter.
100
MEASUREMENT_CLASS VARCHAR2 Code that represents a category or class of measurement units. For example the category Small Length Measurement Unit (i.e. SMLU) includes units such as milimiter, inch, etc., but excludes miles and kilometers.This enables us to control the allowable values depending on the item that is being described. If I am measuring an animal, I want to be able to display a reasonable set of measurement units: it would not reasonable to measure an animal in nautical miles or fathoms, although these are valid measurement units. On the other hand, milimiters is not a reasonable measurement unit for DEPTH.Validation:The domain MEASUREMENT CLASS ensures that only a predefined set of measurement class codes in allowed into the system. This column is not optional and therefore cannot be left empty.
100
ENABLED VARCHAR2 Flag that indicates whether a parameter is being used.
100
MINIMUM_VALUE VARCHAR2 Minimum acceptable value for a gear parameter.
100
MAXIMUM_VALUE VARCHAR2 Maximum acceptable value for a gear parameter.
100
MEASUREMENT_UNIT_CODE VARCHAR2 Code that represents the measurement unit, e.g., FT-feet, FM-fathoms, etc.Validation:A domain called MEASUREMENT_UNIT ensures that only acceptable values are entered into his column.

Attribute Details

GEAR_CLASS

CC ID: 27243
Seq. Order: 1
Data Storage Type: VARCHAR2
Max Length: 5
Required: Yes
Primary Key: Yes
Status: Active
Description:

Broad category which includes related gears that share the same characteristic.

General Data Type: VARCHAR2

GEAR_PARAMETER_CODE

CC ID: 27244
Seq. Order: 2
Data Storage Type: VARCHAR2
Max Length: 5
Required: Yes
Primary Key: Yes
Status: Active
Description:

Measurable characteristic of a gear such as line length, number of hooks, etc.

General Data Type: VARCHAR2

PARAMETER_DESCRIPTION

CC ID: 27245
Seq. Order: 3
Data Storage Type: VARCHAR2
Max Length: 50
Required: Yes
Primary Key: No
Status: Active
Description:

Description of the gear parameter.

General Data Type: VARCHAR2

MEASUREMENT_CLASS

CC ID: 27246
Seq. Order: 4
Data Storage Type: VARCHAR2
Max Length: 5
Required: Yes
Primary Key: No
Status: Active
Description:

Code that represents a category or class of measurement units. For example the category Small Length Measurement Unit (i.e. SMLU) includes units such as milimiter, inch, etc., but excludes miles and kilometers.This enables us to control the allowable values depending on the item that is being described. If I am measuring an animal, I want to be able to display a reasonable set of measurement units: it would not reasonable to measure an animal in nautical miles or fathoms, although these are valid measurement units. On the other hand, milimiters is not a reasonable measurement unit for DEPTH.Validation:The domain MEASUREMENT CLASS ensures that only a predefined set of measurement class codes in allowed into the system. This column is not optional and therefore cannot be left empty.

General Data Type: VARCHAR2

ENABLED

CC ID: 27247
Seq. Order: 5
Data Storage Type: VARCHAR2
Max Length: 1
Required: Yes
Primary Key: No
Status: Active
Description:

Flag that indicates whether a parameter is being used.

General Data Type: VARCHAR2

MINIMUM_VALUE

CC ID: 27248
Seq. Order: 6
Data Storage Type: VARCHAR2
Max Length: 15
Required: No
Primary Key: No
Status: Active
Description:

Minimum acceptable value for a gear parameter.

General Data Type: VARCHAR2

MAXIMUM_VALUE

CC ID: 27249
Seq. Order: 7
Data Storage Type: VARCHAR2
Max Length: 15
Required: No
Primary Key: No
Status: Active
Description:

Maximum acceptable value for a gear parameter.

General Data Type: VARCHAR2

MEASUREMENT_UNIT_CODE

CC ID: 27250
Seq. Order: 8
Data Storage Type: VARCHAR2
Max Length: 5
Required: No
Primary Key: No
Status: Active
Description:

Code that represents the measurement unit, e.g., FT-feet, FM-fathoms, etc.Validation:A domain called MEASUREMENT_UNIT ensures that only acceptable values are entered into his column.

General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 7159
GUID: gov.noaa.nmfs.inport:7159
Metadata Record Created By: Lee M Weinberger
Metadata Record Created: 2008-02-28 14:10+0000
Metadata Record Last Modified By: Lee M Weinberger
Metadata Record Last Modified: 2021-05-06 22:24+0000
Metadata Record Published: 2021-05-06
Owner Org: SEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2022-05-07