Search Help Show/Hide Menu
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