Account Creation Issues: We have received reports of issues with creating new user accounts and linking accounts to CAM, and are currently investigating the root cause. In the meantime: - If you're experiencing errors creating new users, please use the "Quick Add" feature instead (click the "Quick Add" button on the Manage Users page). - If you're experiencing errors linking CAM accoun...
View All
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 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Description

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

Entity Information

Data Attribute / Type Description
CONDITION_CODE
VARCHAR2(2 BYTE)
CONDITION_ID
NUMBER(6,0)
DATETIME
DATE
DISENTANGLMENT_CODE
VARCHAR2(2 BYTE)
INCIDENTAL_TAKE_ID
NUMBER(6,0)
PHOTO_TAKEN_FLAG
VARCHAR2(1 BYTE)
SAMPLED_FLAG
VARCHAR2(1 BYTE)
SEQUENCE_NUMBER
NUMBER(3,0)
SEX
VARCHAR2(1 BYTE)
TAG_ONE_NUMBER
VARCHAR2(12 BYTE)
TAG_ONE_STATUS_CODE
VARCHAR2(1 BYTE)
TAG_ONE_TYPE_CODE
VARCHAR2(2 BYTE)
TAG_ONE_TYPE_ID
NUMBER(6,0)
TAG_TWO_NUMBER
VARCHAR2(12 BYTE)
TAG_TWO_STATUS_CODE
VARCHAR2(1 BYTE)
TAG_TWO_TYPE_CODE
VARCHAR2(2 BYTE)
TAG_TWO_TYPE_ID
NUMBER(6,0)
USER_ID
VARCHAR2(100 BYTE)

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

Please contact the owner organization (AFSC) for inquiries on this record.

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