Slide Menu
InPort and its associated services will be under maintenance and unavailable for the deployment of InPort Release 5.2.3. Downtime Schedule Tuesday, November 29, 2022 12:00pm - 1:30pm Eastern / 10:00am - 11:30pm Pacific / 7:00am - 8:30pm Hawaii Impacted Areas - InPort Website: https://www.fisheries.noaa.gov/inport - InPort WAF: https://www.fisheries.noaa.gov/inportserve/waf What's...
View All
Search Help Show/Hide Menu

Item Identification

Title: Table: ALS_PR_SPECIES_GEAR_VALIDATE
Short Name: ALS_PR_SPECIES_GEAR_VALIDATE
Status: Completed
Notes:

Loaded by batch 7906, 12-22-2015 14:11

Entity Information

Entity Type: Data Table
Active Version?: Yes
Schema Name: ALS

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
67
PR_GEAR VARCHAR2
67
GEAR_NAME VARCHAR2
67
PR_SPECIES VARCHAR2
67
ITIS_COMMON_NAME VARCHAR2
67
SPECIES_ITIS VARCHAR2
67
POUNDS VARCHAR2
67
RECORDS VARCHAR2
67
INVALID_GEAR VARCHAR2
67
INVALID_SPECIES VARCHAR2
67
INVALID_GEAR_SPEC_COMBINATION VARCHAR2

Attribute Details

PR_GEAR

CC ID: 267235
Seq. Order: 1
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
General Data Type: VARCHAR2

GEAR_NAME

CC ID: 267237
Seq. Order: 2
Data Storage Type: VARCHAR2
Max Length: 15
Required: No
Primary Key: No
Status: Active
General Data Type: VARCHAR2

PR_SPECIES

CC ID: 267238
Seq. Order: 3
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
General Data Type: VARCHAR2

ITIS_COMMON_NAME

CC ID: 267239
Seq. Order: 4
Data Storage Type: VARCHAR2
Max Length: 28
Required: No
Primary Key: No
Status: Active
General Data Type: VARCHAR2

SPECIES_ITIS

CC ID: 267240
Seq. Order: 5
Data Storage Type: VARCHAR2
Max Length: 6
Required: No
Primary Key: No
Status: Active
General Data Type: VARCHAR2

POUNDS

CC ID: 267241
Seq. Order: 6
Data Storage Type: VARCHAR2
Max Length: 7
Required: No
Primary Key: No
Status: Active
General Data Type: VARCHAR2

RECORDS

CC ID: 267242
Seq. Order: 7
Data Storage Type: VARCHAR2
Max Length: 6
Required: No
Primary Key: No
Status: Active
General Data Type: VARCHAR2

INVALID_GEAR

CC ID: 267243
Seq. Order: 8
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
General Data Type: VARCHAR2

INVALID_SPECIES

CC ID: 267244
Seq. Order: 9
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
General Data Type: VARCHAR2

INVALID_GEAR_SPEC_COMBINATION

CC ID: 267236
Seq. Order: 10
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 29949
GUID: gov.noaa.nmfs.inport:29949
Metadata Record Created By: Joshua Bennett
Metadata Record Created: 2015-12-22 14:11+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