Slide Menu
Known Issue with Distributions: We have been made aware of an issue introduced in the current release with the new Distribution Format field. When creating a new Distribution, if Distribution Format is not populated, you will encounter an unintended application error. Until this issue is fixed, if you need to create Distributions without a Distribution Format, please use the following workar...
View All
Maintenance Notice: Thursday November 30 @ 1pm-2:30pm Eastern. InPort and its associated services will be under maintenance and unavailable for the deployment of InPort Release 5.3.2. Downtime Schedule Thursday, November 30, 2023 1:00pm - 2:30pm Eastern / 10:00am - 11:30am Pacific / 8:00am - 9:30am Hawaii Impacted Areas - InPort Website: https://www.fisheries.noaa.gov/inport - InPo...
View All
Search Help Show/Hide Menu

Item Identification

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

Fate of fish at release/recapture

Notes:

Loaded by batch 9651, 01-12-2017 16:35

Entity Information

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

Fate of fish at release/recapture

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key FISHFATECD VARCHAR2 Fate of fish code.
100
FATE_OF_FISH VARCHAR2 Fate of fish description.
100
DOE DATE Date when record was inserted into Oracle. Date format (DD-MON-YYYY HH24:MI:SS).
100
UOE VARCHAR2 The Oracle username of the individual who entered the new record.
100
DOC DATE Date when the current record was updated or changed. Date format (DD-MON-YYYY HH:MI:SS).
100
UOC VARCHAR2 The Oracle username of the individual who changed the current record.
100
FISHERY_STRING VARCHAR2 Fisheries to which species is affiliated (comma separated list of fishery codes).

Attribute Details

FISHFATECD

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

Fate of fish code.

General Data Type: VARCHAR2

FATE_OF_FISH

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

Fate of fish description.

General Data Type: VARCHAR2

DOE

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

Date when record was inserted into Oracle. Date format (DD-MON-YYYY HH24:MI:SS).

General Data Type: DATE

UOE

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

The Oracle username of the individual who entered the new record.

General Data Type: VARCHAR2

DOC

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

Date when the current record was updated or changed. Date format (DD-MON-YYYY HH:MI:SS).

General Data Type: DATE

UOC

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

The Oracle username of the individual who changed the current record.

General Data Type: VARCHAR2

FISHERY_STRING

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

Fisheries to which species is affiliated (comma separated list of fishery codes).

General Data Type: VARCHAR2

Catalog Details

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