Slide Menu
Search Help Show/Hide Menu

Item Identification

Title: MM_OBSERVED_RESEARCH

Entity Information

Description:

Child to mm_obs_trip_report, captures the additional research recorded on hard copy Trip Information Form.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
RESEARCH_CODE VARCHAR2(1 BYTE) Indicates what kind of supplemental or specialized research was conducted during this trip.
100
RESEARCH_DESCRIPTION VARCHAR2(50 BYTE) Description of supplemental or specialized research conducted.
100
RESEARCH_ID NUMBER(6,0) Unique Identifier of Obs_Trip_Research
100
SEQUENCE_NUMBER NUMBER(3,0) Sequence Within Parent Trip
100
TRIP_ID NUMBER(6,0) AMMOP code for the trip

Attribute Details

RESEARCH_CODE

CC ID: 1374661
Data Storage Type: VARCHAR2(1 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

Indicates what kind of supplemental or specialized research was conducted during this trip.

RESEARCH_DESCRIPTION

CC ID: 1374662
Data Storage Type: VARCHAR2(50 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

Description of supplemental or specialized research conducted.

RESEARCH_ID

CC ID: 1374663
Data Storage Type: NUMBER(6,0)
Required: No
Primary Key: No
Status: Active
Description:

Unique Identifier of Obs_Trip_Research

SEQUENCE_NUMBER

CC ID: 1374664
Data Storage Type: NUMBER(3,0)
Required: No
Primary Key: No
Status: Active
Description:

Sequence Within Parent Trip

TRIP_ID

CC ID: 1374665
Data Storage Type: NUMBER(6,0)
Required: No
Primary Key: No
Status: Active
Description:

AMMOP code for the trip

Catalog Details

Catalog Item ID: 75190
GUID: gov.noaa.nmfs.inport:75190
Metadata Record Created By: Rachel Wuest
Metadata Record Created: 2025-03-06 22:58+0000
Metadata Record Last Modified By: Daniel Woodrich
Metadata Record Last Modified: 2025-05-21 19:12+0000
Metadata Record Published: 2025-05-21
Owner Org: AFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Review Frequency: 1 Year