Slide Menu
Search Help Show/Hide Menu

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