Slide Menu
Search Help Show/Hide Menu

Item Identification

Title: Table: OBEGGS
Short Name: OBEGGS
Status: Completed
Abstract:

Observer Crustacean Egg Codes Support Table

Notes:

Loaded by batch 8950, 07-06-2016 08:24

Entity Information

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

Observer Crustacean Egg Codes Support Table

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key EGG VARCHAR2 Indicator of whether eggs are visible underneath back part of abdomen of animal sampled. See OBEGGS table.
100
EGGDESC VARCHAR2 Text description of the egg code.
100
EGGCOMMENTS VARCHAR2 Additional information about the egg code identified by egg.
100
DOE DATE Date of Entry of the associated record.
100
UOE VARCHAR2 Oracle user ID of the person who entered the data.
100
DOC DATE Date associated record was updated.
100
UOC VARCHAR2 Oracle ID of user who made the (most recent ) change on the record.

Attribute Details

EGG

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

Indicator of whether eggs are visible underneath back part of abdomen of animal sampled. See OBEGGS table.

General Data Type: VARCHAR2

EGGDESC

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

Text description of the egg code.

General Data Type: VARCHAR2

EGGCOMMENTS

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

Additional information about the egg code identified by egg.

General Data Type: VARCHAR2

DOE

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

Date of Entry of the associated record.

General Data Type: DATE

UOE

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

Oracle user ID of the person who entered the data.

General Data Type: VARCHAR2

DOC

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

Date associated record was updated.

General Data Type: DATE

UOC

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

Oracle ID of user who made the (most recent ) change on the record.

General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 33332
GUID: gov.noaa.nmfs.inport:33332
Metadata Record Created By: Patricia L Jones
Metadata Record Created: 2016-07-06 08:24+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2016-07-28
Owner Org: NEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2016-07-28
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2017-07-28