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
83%
5 / 6
View Report
Alaska Fisheries Science Center Metadata Librar... > Fisheries Management and Analysis Division > AMMOP > AMMOP Oracle database 1999 - 2013 >

MM_INCIDENTAL_BIRD_SAMPLE

Entity (ENT)  |  Alaska Fisheries Science Center (AFSC)
GUID: gov.noaa.nmfs.inport:75180  |  Updated: May 21, 2025  |  Published / External 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Description

Captures hard copy Marine Bird (now Seabird) Sample Form.

Entity Information

Data Attribute / Type Description
BROOD_PATCH_CODE
VARCHAR2(2 BYTE) 		AMMOP code for brood patch from Seabird Sample Form
BROOD_PATCH_DESCRIPTION
VARCHAR2(60 BYTE) 		Description of brood patch condition
BROOD_PATCH_ID
NUMBER(6,0) 		Unique database identifier for brood patch code
COMMENTS
VARCHAR2(2000 BYTE) 		Observer text regarding collection
CULMEN_LENGTH
NUMBER(3,0) 		Culmen length in mm
FAT_INDEX_CODE
VARCHAR2(2 BYTE) 		AMMOP code for fat index from Seabird Sample Form
FAT_INDEX_DESCRIPTION
VARCHAR2(100 BYTE) 		Description of fat index condition
FAT_INDEX_ID
NUMBER(6,0) 		Unique database identifier for fat index code
FEATHER_CODE
VARCHAR2(2 BYTE) 		AMMOP code for feathers from Seabird Sample Form
FEATHER_DESCRIPTION
VARCHAR2(60 BYTE) 		Description of feather loss
FEATHER_ID
NUMBER(6,0) 		Unique database identifier for feather code
HEADBILL
NUMBER(3,0) 		Headbill length in mm
INCIDENTAL_TAKE_ID
NUMBER(6,0) 		Unique database identifier for take
OTHER_SAMPLE_COUNT
NUMBER(2,0) 		Not including the whole carcass, how many additional samples were collected?
PHASE_CODE
VARCHAR2(1 BYTE) 		AMMOP code for plumage phase from Seabird Sample Form
PHASE_DESCRIPTION
VARCHAR2(60 BYTE) 		Description of plumage phase
PHASE_ID
NUMBER(6,0) 		Unique database identifier for phase code
RETAINED_HEAD_FEET_FLAG
VARCHAR2(1 BYTE) 		If the seabird was not retained whole, were the head & feet collected?
RETAINED_STOMACH_FLAG
VARCHAR2(1 BYTE) 		If the seabird was not retained whole, was the stomach collected?
RETAINED_WHOLE_FLAG
VARCHAR2(1 BYTE) 		Was the seabird retained whole?
SEQUENCE_NUMBER
NUMBER(3,0) 		Sequential number assigned to take by trip
TARSUS_LENGTH
NUMBER(3,0) 		Tarsus length in mm
WEIGHT
NUMBER(4,0) 		Weight in grams
WING_CHORD
NUMBER(3,0) 		Wing chord length in cm

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_BIRD_SAMPLE

Entity Information

Description:

Captures hard copy Marine Bird (now Seabird) Sample Form.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 BROOD_PATCH_CODE VARCHAR2(2 BYTE) AMMOP code for brood patch from Seabird Sample Form
100
 BROOD_PATCH_DESCRIPTION VARCHAR2(60 BYTE) Description of brood patch condition
100
 BROOD_PATCH_ID NUMBER(6,0) Unique database identifier for brood patch code
100
 COMMENTS VARCHAR2(2000 BYTE) Observer text regarding collection
100
 CULMEN_LENGTH NUMBER(3,0) Culmen length in mm
100
 FAT_INDEX_CODE VARCHAR2(2 BYTE) AMMOP code for fat index from Seabird Sample Form
100
 FAT_INDEX_DESCRIPTION VARCHAR2(100 BYTE) Description of fat index condition
100
 FAT_INDEX_ID NUMBER(6,0) Unique database identifier for fat index code
100
 FEATHER_CODE VARCHAR2(2 BYTE) AMMOP code for feathers from Seabird Sample Form
100
 FEATHER_DESCRIPTION VARCHAR2(60 BYTE) Description of feather loss
100
 FEATHER_ID NUMBER(6,0) Unique database identifier for feather code
100
 HEADBILL NUMBER(3,0) Headbill length in mm
100
 INCIDENTAL_TAKE_ID NUMBER(6,0) Unique database identifier for take
100
 OTHER_SAMPLE_COUNT NUMBER(2,0) Not including the whole carcass, how many additional samples were collected?
100
 PHASE_CODE VARCHAR2(1 BYTE) AMMOP code for plumage phase from Seabird Sample Form
100
 PHASE_DESCRIPTION VARCHAR2(60 BYTE) Description of plumage phase
100
 PHASE_ID NUMBER(6,0) Unique database identifier for phase code
100
 RETAINED_HEAD_FEET_FLAG VARCHAR2(1 BYTE) If the seabird was not retained whole, were the head & feet collected?
100
 RETAINED_STOMACH_FLAG VARCHAR2(1 BYTE) If the seabird was not retained whole, was the stomach collected?
100
 RETAINED_WHOLE_FLAG VARCHAR2(1 BYTE) Was the seabird retained whole?
100
 SEQUENCE_NUMBER NUMBER(3,0) Sequential number assigned to take by trip
100
 TARSUS_LENGTH NUMBER(3,0) Tarsus length in mm
100
 WEIGHT NUMBER(4,0) Weight in grams
100
 WING_CHORD NUMBER(3,0) Wing chord length in cm

Attribute Details

BROOD_PATCH_CODE

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

AMMOP code for brood patch from Seabird Sample Form

BROOD_PATCH_DESCRIPTION

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

Description of brood patch condition

BROOD_PATCH_ID

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

Unique database identifier for brood patch code

COMMENTS

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

Observer text regarding collection

CULMEN_LENGTH

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

Culmen length in mm

FAT_INDEX_CODE

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

AMMOP code for fat index from Seabird Sample Form

FAT_INDEX_DESCRIPTION

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

Description of fat index condition

FAT_INDEX_ID

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

Unique database identifier for fat index code

FEATHER_CODE

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

AMMOP code for feathers from Seabird Sample Form

FEATHER_DESCRIPTION

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

Description of feather loss

FEATHER_ID

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

Unique database identifier for feather code

HEADBILL

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

Headbill length in mm

INCIDENTAL_TAKE_ID

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

Unique database identifier for take

OTHER_SAMPLE_COUNT

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

Not including the whole carcass, how many additional samples were collected?

PHASE_CODE

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

AMMOP code for plumage phase from Seabird Sample Form

PHASE_DESCRIPTION

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

Description of plumage phase

PHASE_ID

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

Unique database identifier for phase code

RETAINED_HEAD_FEET_FLAG

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

If the seabird was not retained whole, were the head & feet collected?

RETAINED_STOMACH_FLAG

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

If the seabird was not retained whole, was the stomach collected?

RETAINED_WHOLE_FLAG

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

Was the seabird retained whole?

SEQUENCE_NUMBER

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

Sequential number assigned to take by trip

TARSUS_LENGTH

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

Tarsus length in mm

WEIGHT

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

Weight in grams

WING_CHORD

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

Wing chord length in cm

Catalog Details

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