Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
SEFSC Metadata Library > Fisheries Statistics Division > Observer Programs > Pelagic Longline Observer Program > PELAGIC OBSERVER PROGRAM (POP). Catch/Effort d... >

Table: POP_SPECIES_CODE

Entity (ENT)  |  Southeast Fisheries Science Center (SEFSC)
GUID: gov.noaa.nmfs.inport:5366  |  Updated: June 14, 2024  |  Published / External 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

Holds valid species codes in the Animal Log Form

Description

Holds valid species codes in the Animal Log Form

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
POP_SPECIES_CODE
VARCHAR2 		Pop Spc Code Assigned By Data Manager
NODC_SPECIES_CODE
VARCHAR2 		NODC Code equivalent (If available)
POP_GROUP_CODE
VARCHAR2 		Pop Grouping Code/Name assigned By POP Data Manager
POP_COMMON_NAME
VARCHAR2 		Common Name Of Animal
NMFS_SPECIES_CODE
VARCHAR2 		4 digit NMFS Species Code if avilable
CREATED_BY_USER_ID
VARCHAR2 		Created by whom
CREATED_DATE
DATE 		Created when
MODIFIED_BY_USER_ID
VARCHAR2 		Modified by whom
MODIFIED_DATE
DATE 		Modified when
MINIMUM_LENGTH_1
NUMBER 		Minimum Reccomended Length For Species
MAXIMUM_LENGTH_1
NUMBER 		Maximum Reccomended Length For Species
WEIGHT_LENGTH_COEFF_A
NUMBER 		First Coefficient In Weight To Length Conversion For Species
WEIGHT_LENGTH_COEFF_B
NUMBER 		Second Coefficient In Weight To Length Conversion For Species
PERCENT_ERROR_MARGIN
NUMBER 		Acceptable Percent Error For Species In Question

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: POP_SPECIES_CODE
Short Name: POP_SPECIES_CODE
Status: Completed
Abstract:

Holds valid species codes in the Animal Log Form
Notes:

Loaded by batch 1683, 10-12-2007 05:01

Entity Information

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

Holds valid species codes in the Animal Log Form

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 Primary Key POP_SPECIES_CODE VARCHAR2 Pop Spc Code Assigned By Data Manager
100
 NODC_SPECIES_CODE VARCHAR2 NODC Code equivalent (If available)
100
 POP_GROUP_CODE VARCHAR2 Pop Grouping Code/Name assigned By POP Data Manager
100
 POP_COMMON_NAME VARCHAR2 Common Name Of Animal
100
 NMFS_SPECIES_CODE VARCHAR2 4 digit NMFS Species Code if avilable
100
 CREATED_BY_USER_ID VARCHAR2 Created by whom
100
 CREATED_DATE DATE Created when
100
 MODIFIED_BY_USER_ID VARCHAR2 Modified by whom
100
 MODIFIED_DATE DATE Modified when
100
 MINIMUM_LENGTH_1 NUMBER Minimum Reccomended Length For Species
100
 MAXIMUM_LENGTH_1 NUMBER Maximum Reccomended Length For Species
100
 WEIGHT_LENGTH_COEFF_A NUMBER First Coefficient In Weight To Length Conversion For Species
100
 WEIGHT_LENGTH_COEFF_B NUMBER Second Coefficient In Weight To Length Conversion For Species
100
 PERCENT_ERROR_MARGIN NUMBER Acceptable Percent Error For Species In Question

Attribute Details

POP_SPECIES_CODE

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

Pop Spc Code Assigned By Data Manager
General Data Type: VARCHAR2

NODC_SPECIES_CODE

CC ID: 16479
Seq. Order: 2
Data Storage Type: VARCHAR2
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

NODC Code equivalent (If available)
General Data Type: VARCHAR2

POP_GROUP_CODE

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

Pop Grouping Code/Name assigned By POP Data Manager
General Data Type: VARCHAR2

POP_COMMON_NAME

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

Common Name Of Animal
General Data Type: VARCHAR2

NMFS_SPECIES_CODE

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

4 digit NMFS Species Code if avilable
General Data Type: VARCHAR2

CREATED_BY_USER_ID

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

Created by whom
General Data Type: VARCHAR2

CREATED_DATE

CC ID: 16474
Seq. Order: 7
Data Storage Type: DATE
Max Length: 7
Required: Yes
Primary Key: No
Status: Active
Description:

Created when
General Data Type: DATE

MODIFIED_BY_USER_ID

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

Modified by whom
General Data Type: VARCHAR2

MODIFIED_DATE

CC ID: 16472
Seq. Order: 9
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Modified when
General Data Type: DATE

MINIMUM_LENGTH_1

CC ID: 16471
Seq. Order: 10
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 3
Scale: 0
Status: Active
Description:

Minimum Reccomended Length For Species
General Data Type: NUMBER

MAXIMUM_LENGTH_1

CC ID: 16470
Seq. Order: 11
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 3
Scale: 0
Status: Active
Description:

Maximum Reccomended Length For Species
General Data Type: NUMBER

WEIGHT_LENGTH_COEFF_A

CC ID: 16469
Seq. Order: 12
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 20
Scale: 10
Status: Active
Description:

First Coefficient In Weight To Length Conversion For Species
General Data Type: NUMBER

WEIGHT_LENGTH_COEFF_B

CC ID: 16468
Seq. Order: 13
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 20
Scale: 10
Status: Active
Description:

Second Coefficient In Weight To Length Conversion For Species
General Data Type: NUMBER

PERCENT_ERROR_MARGIN

CC ID: 16467
Seq. Order: 14
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 2
Scale: 0
Status: Active
Description:

Acceptable Percent Error For Species In Question
General Data Type: NUMBER

Catalog Details

Catalog Item ID: 5366
GUID: gov.noaa.nmfs.inport:5366
Metadata Record Created By: Lee M Weinberger
Metadata Record Created: 2007-10-12 05:01+0000
Metadata Record Last Modified By: Lee M Weinberger
Metadata Record Last Modified: 2024-06-14 13:53+0000
Metadata Record Published: 2024-06-14
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