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

Summary

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
PR_GEAR
VARCHAR2
GEAR_NAME
VARCHAR2
PR_SPECIES
VARCHAR2
ITIS_COMMON_NAME
VARCHAR2
SPECIES_ITIS
VARCHAR2
POUNDS
VARCHAR2
RECORDS
VARCHAR2
INVALID_GEAR
VARCHAR2
INVALID_SPECIES
VARCHAR2
INVALID_GEAR_SPEC_COMBINATION
VARCHAR2

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: 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