Slide Menu
Jump to Section...
Search Help Show/Hide Menu
Metadata Rubric
67%
4 / 6
View Report
Alaska Fisheries Science Center Metadata Librar... > Fisheries Management and Analysis Division > AMMOP > AMMOP Oracle database 1999 - 2013 >

MM_INCIDENTAL_TAKE_HISTORY

Entity (ENT)  |  Alaska Fisheries Science Center (AFSC)
GUID: gov.noaa.nmfs.inport:75183  |  Updated: May 21, 2025  |  Published / External 

Item Identification

Title: MM_INCIDENTAL_TAKE_HISTORY

Entity Information

Description:

This table logs any updates and additions to the mm_inicidental_take table.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
67
 CONDITION_CODE VARCHAR2(2 BYTE)
67
 CONDITION_ID NUMBER(6,0)
67
 DATETIME DATE
67
 DISENTANGLMENT_CODE VARCHAR2(2 BYTE)
67
 INCIDENTAL_TAKE_ID NUMBER(6,0)
67
 PHOTO_TAKEN_FLAG VARCHAR2(1 BYTE)
67
 SAMPLED_FLAG VARCHAR2(1 BYTE)
67
 SEQUENCE_NUMBER NUMBER(3,0)
67
 SEX VARCHAR2(1 BYTE)
67
 TAG_ONE_NUMBER VARCHAR2(12 BYTE)
67
 TAG_ONE_STATUS_CODE VARCHAR2(1 BYTE)
67
 TAG_ONE_TYPE_CODE VARCHAR2(2 BYTE)
67
 TAG_ONE_TYPE_ID NUMBER(6,0)
67
 TAG_TWO_NUMBER VARCHAR2(12 BYTE)
67
 TAG_TWO_STATUS_CODE VARCHAR2(1 BYTE)
67
 TAG_TWO_TYPE_CODE VARCHAR2(2 BYTE)
67
 TAG_TWO_TYPE_ID NUMBER(6,0)
67
 USER_ID VARCHAR2(100 BYTE)

Attribute Details

CONDITION_CODE

CC ID: 1374497
Data Storage Type: VARCHAR2(2 BYTE)
Required: No
Primary Key: No
Status: Active

CONDITION_ID

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

DATETIME

CC ID: 1374499
Data Storage Type: DATE
Required: No
Primary Key: No
Status: Active

DISENTANGLMENT_CODE

CC ID: 1374500
Data Storage Type: VARCHAR2(2 BYTE)
Required: No
Primary Key: No
Status: Active

INCIDENTAL_TAKE_ID

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

PHOTO_TAKEN_FLAG

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

SAMPLED_FLAG

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

SEQUENCE_NUMBER

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

SEX

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

TAG_ONE_NUMBER

CC ID: 1374506
Data Storage Type: VARCHAR2(12 BYTE)
Required: No
Primary Key: No
Status: Active

TAG_ONE_STATUS_CODE

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

TAG_ONE_TYPE_CODE

CC ID: 1374508
Data Storage Type: VARCHAR2(2 BYTE)
Required: No
Primary Key: No
Status: Active

TAG_ONE_TYPE_ID

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

TAG_TWO_NUMBER

CC ID: 1374510
Data Storage Type: VARCHAR2(12 BYTE)
Required: No
Primary Key: No
Status: Active

TAG_TWO_STATUS_CODE

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

TAG_TWO_TYPE_CODE

CC ID: 1374512
Data Storage Type: VARCHAR2(2 BYTE)
Required: No
Primary Key: No
Status: Active

TAG_TWO_TYPE_ID

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

USER_ID

CC ID: 1374514
Data Storage Type: VARCHAR2(100 BYTE)
Required: No
Primary Key: No
Status: Active

Catalog Details

Catalog Item ID: 75183
GUID: gov.noaa.nmfs.inport:75183
Metadata Record Created By: Rachel Wuest
Metadata Record Created: 2025-03-06 22:22+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