Downtime Notice: Thursday, May 29 @ 2:00pm Eastern. InPort and its associated services will be under maintenance and unavailable for the deployment of InPort Release 6.0.2. Downtime Schedule May 29, 2025 2:00pm - 3:00pm Eastern / 11:00am - 12:00pm Pacific / 8:00am - 9:00am Hawaii Impacted Areas - InPort Website: https://www.fisheries.noaa.gov/inport - InPort WAF: https://www.fisheri...
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 >

AMMOP_SAMPLE

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

Summary

Description

This table contains observer samples. The sample is the root of all AMMOP data collection

Entity Information

Data Attribute / Type Description
ADAPTIVE_SAMPLING
VARCHAR2(1 BYTE) 		Adaptive sampling used: Y=Yes, N=No.
BEGIN_DATE
DATE 		Date sample was begun.
BEGIN_TIME
NUMBER(4,0) 		Time sample was begun. Military time
CFEC_PERMIT
VARCHAR2(70 BYTE) 		Permit fisherman was fishing with.
COMMENTS
VARCHAR2(2048 BYTE) 		Additional information.
DEBRIEFED_BY_INITIALS
VARCHAR2(3 BYTE) 		For Form Tracking Purposes: Person who debriefed.
DEBRIEFED_DATE
DATE 		For Form Tracking Purposes: Date debriefed.
DELIVERIES_LOCATION_ID
NUMBER(6,0) 		Delivery location type code. References AMMOP_DELIVERY_LOCATION_CODE
DELIVERIES_LOCATION_NAME
VARCHAR2(256 BYTE) 		Name of location where retained species were delivered.
DELIVERIES_TOTAL
VARCHAR2(6 BYTE) 		Total number of deliveries.
END_DATE
DATE 		Date sample ended.
END_TIME
NUMBER(4,0) 		Time sample ended. Military time
ENTERED_BY_INITIALS
VARCHAR2(3 BYTE) 		For Form Tracking Purposes: Person who entered
ENTERED_DATE
DATE 		For Form Tracking Purposes: Entered date
FISHERY_ID
NUMBER(6,0) 		Part of the identifier for the fishery sampled.
FISHERY_SEQUENCE
NUMBER(3,0) 		Part of the identifier for the fishery sampled.
GEOGRAPHIC_REGION
VARCHAR2(64 BYTE) 		Geographic region where fishery was sampled.
HAULS_CONFIRMED_AFTER_OBS_DPT
VARCHAR2(6 BYTE) 		Confirmed number of hauls not observed after observer departure.
HAULS_EXPECTED_AFTER_OBS_DPT
VARCHAR2(6 BYTE) 		Primary permit holders expected number of hauls after observer departure.
HAULS_EXPECTED_FOR_DAY
VARCHAR2(6 BYTE) 		Permit holders expected number of hauls for day.
HAULS_NOT_OBSERVED_OBS1_P
VARCHAR2(64 BYTE) 		Number of hauls not observed prior to observer arrival. Observer 1. P=Count of Partially Observed
HAULS_NOT_OBSERVED_OBS1_T
VARCHAR2(64 BYTE) 		Number of hauls not observed prior to observer arrival. Observer 1. Total=P+W
HAULS_NOT_OBSERVED_OBS1_W
VARCHAR2(6 BYTE) 		Number of hauls not observed prior to observer arrival. Observer 1. W=The whole number count of hauls that were missed entirely
HAULS_NOT_OBSERVED_OBS2_P
VARCHAR2(64 BYTE) 		Number of hauls not observed prior to observer arrival. Observer 2. P=Count of Partially Observed
HAULS_NOT_OBSERVED_OBS2_T
VARCHAR2(64 BYTE) 		Number of hauls not observed prior to observer arrival. Observer 2. Total=P+W
HAULS_NOT_OBSERVED_OBS2_W
VARCHAR2(6 BYTE) 		Number of hauls not observed prior to observer arrival. Observer 2. W=The whole number count of hauls that were missed entirely
HAULS_NOT_OBSERVED_PRE_OBS_P
VARCHAR2(64 BYTE) 		Number of hauls not observed during observer presence. Partially missed
HAULS_NOT_OBSERVED_PRE_OBS_T
VARCHAR2(64 BYTE) 		Number of hauls not observed during observer presence. Total=P+W
HAULS_NOT_OBSERVED_PRE_OBS_W
VARCHAR2(6 BYTE) 		Number of hauls not observed during observer presence. The whole number count of hauls that were missed entirely.
HAULS_NOT_OBSERVED_TOTAL_P
VARCHAR2(64 BYTE) 		Total of individual partial hauls not observed
HAULS_NOT_OBSERVED_TOTAL_T
VARCHAR2(64 BYTE) 		Total of totals of individual hauls not observed
HAULS_NOT_OBSERVED_TOTAL_W
VARCHAR2(6 BYTE) 		Total of individual whole hauls not observed
HAULS_OBSERVED_OBS1_P
VARCHAR2(6 BYTE) 		Total number of individual hauls observed. Observer 1. P=Partially Observed.
HAULS_OBSERVED_OBS1_T
VARCHAR2(6 BYTE) 		Total number of individual hauls observed. Observer 1. Total=W+P.
HAULS_OBSERVED_OBS1_W
VARCHAR2(6 BYTE) 		Total number of individual hauls observed. Observer 1. W=Wholly observed.
HAULS_OBSERVED_OBS2_P
VARCHAR2(6 BYTE) 		Total number of individual hauls observed. Observer 2. P=Partially Observed.
HAULS_OBSERVED_OBS2_T
VARCHAR2(6 BYTE) 		Total number of individual hauls observed. Observer 2. Total=W+P.
HAULS_OBSERVED_OBS2_W
VARCHAR2(6 BYTE) 		Total number of individual hauls observed. Observer 2. W=Wholly observed.
HAULS_OBSERVED_TOTAL_P
VARCHAR2(6 BYTE) 		Total of individual partial hauls observed
HAULS_OBSERVED_TOTAL_T
VARCHAR2(6 BYTE) 		Total of totals of individual hauls observed
HAULS_OBSERVED_TOTAL_W
VARCHAR2(6 BYTE) 		Total of individual whole hauls observed
ID
NUMBER(6,0) 		Unique table ID value. Populated by AMMOP_SAMPLE_SEQ
MM_INCIDENTAL_TAKES
VARCHAR2(6 BYTE) 		Total number of marine mammal incidental takes.
OBSERVER_ID
NUMBER(6,0) 		Primary observer that collected sample. References MM_OBSERVER
OPERATION_TYPE_ID
NUMBER(6,0) 		Operation type. References AMMOP_OPERATION_TYPE_CODE
PRIMARY_SPECIES_RETAINED_ID
NUMBER(6,0) 		ID for code of primary species retained. References AGENCY_SPECIE
PRIMARY_SPECIES_RETAINED_NAME
VARCHAR2(128 BYTE) 		Name of primary species retained.
PRIMARY_SPECIES_RETAINED_TOTAL
VARCHAR2(6 BYTE) 		Total number of primary species retained.
RECEIVED_DATE
DATE 		For Form Tracking Purposes: Date Received.
RECEIVED_INITIALS
VARCHAR2(3 BYTE) 		For Form Tracking Purposes: Person who received.
REVIEWED_BY_INITIALS
VARCHAR2(3 BYTE) 		For Form Tracking Purposes: Person who reviewed
REVIEWED_DATE
DATE 		For Form Tracking Purposes: Reviewed date
SAMPLE_ID
VARCHAR2(10 BYTE) 		The unique id entered by the observer. It contains the observer id as well as a 3 digit sample id. It may contain a secondary observer id as well.
SAMPLE_TYPE_ID
NUMBER(6,0) 		Sample type used. References AMMOP_SAMPLE_TYPE_CODE
SEABIRD_INCIDENTAL_TAKES
VARCHAR2(6 BYTE) 		Total number of seabird incidental takes.
SELECTION_TYPE_ID
NUMBER(6,0) 		Selection method used to select permit. References AMMOP_SELECTION_TYPE_CODE
VALIDATION_DATE
DATE 		Date on which sample was checked and found valid according to business rules

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: AMMOP_SAMPLE

Entity Information

Description:

This table contains observer samples. The sample is the root of all AMMOP data collection

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 ADAPTIVE_SAMPLING VARCHAR2(1 BYTE) Adaptive sampling used: Y=Yes, N=No.
100
 BEGIN_DATE DATE Date sample was begun.
100
 BEGIN_TIME NUMBER(4,0) Time sample was begun. Military time
100
 CFEC_PERMIT VARCHAR2(70 BYTE) Permit fisherman was fishing with.
100
 COMMENTS VARCHAR2(2048 BYTE) Additional information.
100
 DEBRIEFED_BY_INITIALS VARCHAR2(3 BYTE) For Form Tracking Purposes: Person who debriefed.
100
 DEBRIEFED_DATE DATE For Form Tracking Purposes: Date debriefed.
100
 DELIVERIES_LOCATION_ID NUMBER(6,0) Delivery location type code. References AMMOP_DELIVERY_LOCATION_CODE
100
 DELIVERIES_LOCATION_NAME VARCHAR2(256 BYTE) Name of location where retained species were delivered.
100
 DELIVERIES_TOTAL VARCHAR2(6 BYTE) Total number of deliveries.
100
 END_DATE DATE Date sample ended.
100
 END_TIME NUMBER(4,0) Time sample ended. Military time
100
 ENTERED_BY_INITIALS VARCHAR2(3 BYTE) For Form Tracking Purposes: Person who entered
100
 ENTERED_DATE DATE For Form Tracking Purposes: Entered date
100
 FISHERY_ID NUMBER(6,0) Part of the identifier for the fishery sampled.
100
 FISHERY_SEQUENCE NUMBER(3,0) Part of the identifier for the fishery sampled.
100
 GEOGRAPHIC_REGION VARCHAR2(64 BYTE) Geographic region where fishery was sampled.
100
 HAULS_CONFIRMED_AFTER_OBS_DPT VARCHAR2(6 BYTE) Confirmed number of hauls not observed after observer departure.
100
 HAULS_EXPECTED_AFTER_OBS_DPT VARCHAR2(6 BYTE) Primary permit holders expected number of hauls after observer departure.
100
 HAULS_EXPECTED_FOR_DAY VARCHAR2(6 BYTE) Permit holders expected number of hauls for day.
100
 HAULS_NOT_OBSERVED_OBS1_P VARCHAR2(64 BYTE) Number of hauls not observed prior to observer arrival. Observer 1. P=Count of Partially Observed
100
 HAULS_NOT_OBSERVED_OBS1_T VARCHAR2(64 BYTE) Number of hauls not observed prior to observer arrival. Observer 1. Total=P+W
100
 HAULS_NOT_OBSERVED_OBS1_W VARCHAR2(6 BYTE) Number of hauls not observed prior to observer arrival. Observer 1. W=The whole number count of hauls that were missed entirely
100
 HAULS_NOT_OBSERVED_OBS2_P VARCHAR2(64 BYTE) Number of hauls not observed prior to observer arrival. Observer 2. P=Count of Partially Observed
100
 HAULS_NOT_OBSERVED_OBS2_T VARCHAR2(64 BYTE) Number of hauls not observed prior to observer arrival. Observer 2. Total=P+W
100
 HAULS_NOT_OBSERVED_OBS2_W VARCHAR2(6 BYTE) Number of hauls not observed prior to observer arrival. Observer 2. W=The whole number count of hauls that were missed entirely
100
 HAULS_NOT_OBSERVED_PRE_OBS_P VARCHAR2(64 BYTE) Number of hauls not observed during observer presence. Partially missed
100
 HAULS_NOT_OBSERVED_PRE_OBS_T VARCHAR2(64 BYTE) Number of hauls not observed during observer presence. Total=P+W
100
 HAULS_NOT_OBSERVED_PRE_OBS_W VARCHAR2(6 BYTE) Number of hauls not observed during observer presence. The whole number count of hauls that were missed entirely.
100
 HAULS_NOT_OBSERVED_TOTAL_P VARCHAR2(64 BYTE) Total of individual partial hauls not observed
100
 HAULS_NOT_OBSERVED_TOTAL_T VARCHAR2(64 BYTE) Total of totals of individual hauls not observed
100
 HAULS_NOT_OBSERVED_TOTAL_W VARCHAR2(6 BYTE) Total of individual whole hauls not observed
100
 HAULS_OBSERVED_OBS1_P VARCHAR2(6 BYTE) Total number of individual hauls observed. Observer 1. P=Partially Observed.
100
 HAULS_OBSERVED_OBS1_T VARCHAR2(6 BYTE) Total number of individual hauls observed. Observer 1. Total=W+P.
100
 HAULS_OBSERVED_OBS1_W VARCHAR2(6 BYTE) Total number of individual hauls observed. Observer 1. W=Wholly observed.
100
 HAULS_OBSERVED_OBS2_P VARCHAR2(6 BYTE) Total number of individual hauls observed. Observer 2. P=Partially Observed.
100
 HAULS_OBSERVED_OBS2_T VARCHAR2(6 BYTE) Total number of individual hauls observed. Observer 2. Total=W+P.
100
 HAULS_OBSERVED_OBS2_W VARCHAR2(6 BYTE) Total number of individual hauls observed. Observer 2. W=Wholly observed.
100
 HAULS_OBSERVED_TOTAL_P VARCHAR2(6 BYTE) Total of individual partial hauls observed
100
 HAULS_OBSERVED_TOTAL_T VARCHAR2(6 BYTE) Total of totals of individual hauls observed
100
 HAULS_OBSERVED_TOTAL_W VARCHAR2(6 BYTE) Total of individual whole hauls observed
100
 ID NUMBER(6,0) Unique table ID value. Populated by AMMOP_SAMPLE_SEQ
100
 MM_INCIDENTAL_TAKES VARCHAR2(6 BYTE) Total number of marine mammal incidental takes.
100
 OBSERVER_ID NUMBER(6,0) Primary observer that collected sample. References MM_OBSERVER
100
 OPERATION_TYPE_ID NUMBER(6,0) Operation type. References AMMOP_OPERATION_TYPE_CODE
100
 PRIMARY_SPECIES_RETAINED_ID NUMBER(6,0) ID for code of primary species retained. References AGENCY_SPECIE
100
 PRIMARY_SPECIES_RETAINED_NAME VARCHAR2(128 BYTE) Name of primary species retained.
100
 PRIMARY_SPECIES_RETAINED_TOTAL VARCHAR2(6 BYTE) Total number of primary species retained.
100
 RECEIVED_DATE DATE For Form Tracking Purposes: Date Received.
100
 RECEIVED_INITIALS VARCHAR2(3 BYTE) For Form Tracking Purposes: Person who received.
100
 REVIEWED_BY_INITIALS VARCHAR2(3 BYTE) For Form Tracking Purposes: Person who reviewed
100
 REVIEWED_DATE DATE For Form Tracking Purposes: Reviewed date
100
 SAMPLE_ID VARCHAR2(10 BYTE) The unique id entered by the observer. It contains the observer id as well as a 3 digit sample id. It may contain a secondary observer id as well.
100
 SAMPLE_TYPE_ID NUMBER(6,0) Sample type used. References AMMOP_SAMPLE_TYPE_CODE
100
 SEABIRD_INCIDENTAL_TAKES VARCHAR2(6 BYTE) Total number of seabird incidental takes.
100
 SELECTION_TYPE_ID NUMBER(6,0) Selection method used to select permit. References AMMOP_SELECTION_TYPE_CODE
100
 VALIDATION_DATE DATE Date on which sample was checked and found valid according to business rules

Attribute Details

ADAPTIVE_SAMPLING

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

Adaptive sampling used: Y=Yes, N=No.

BEGIN_DATE

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

Date sample was begun.

BEGIN_TIME

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

Time sample was begun. Military time

CFEC_PERMIT

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

Permit fisherman was fishing with.

COMMENTS

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

Additional information.

DEBRIEFED_BY_INITIALS

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

For Form Tracking Purposes: Person who debriefed.

DEBRIEFED_DATE

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

For Form Tracking Purposes: Date debriefed.

DELIVERIES_LOCATION_ID

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

Delivery location type code. References AMMOP_DELIVERY_LOCATION_CODE

DELIVERIES_LOCATION_NAME

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

Name of location where retained species were delivered.

DELIVERIES_TOTAL

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

Total number of deliveries.

END_DATE

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

Date sample ended.

END_TIME

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

Time sample ended. Military time

ENTERED_BY_INITIALS

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

For Form Tracking Purposes: Person who entered

ENTERED_DATE

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

For Form Tracking Purposes: Entered date

FISHERY_ID

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

Part of the identifier for the fishery sampled.

FISHERY_SEQUENCE

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

Part of the identifier for the fishery sampled.

GEOGRAPHIC_REGION

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

Geographic region where fishery was sampled.

HAULS_CONFIRMED_AFTER_OBS_DPT

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

Confirmed number of hauls not observed after observer departure.

HAULS_EXPECTED_AFTER_OBS_DPT

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

Primary permit holders expected number of hauls after observer departure.

HAULS_EXPECTED_FOR_DAY

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

Permit holders expected number of hauls for day.

HAULS_NOT_OBSERVED_OBS1_P

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

Number of hauls not observed prior to observer arrival. Observer 1. P=Count of Partially Observed

HAULS_NOT_OBSERVED_OBS1_T

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

Number of hauls not observed prior to observer arrival. Observer 1. Total=P+W

HAULS_NOT_OBSERVED_OBS1_W

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

Number of hauls not observed prior to observer arrival. Observer 1. W=The whole number count of hauls that were missed entirely

HAULS_NOT_OBSERVED_OBS2_P

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

Number of hauls not observed prior to observer arrival. Observer 2. P=Count of Partially Observed

HAULS_NOT_OBSERVED_OBS2_T

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

Number of hauls not observed prior to observer arrival. Observer 2. Total=P+W

HAULS_NOT_OBSERVED_OBS2_W

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

Number of hauls not observed prior to observer arrival. Observer 2. W=The whole number count of hauls that were missed entirely

HAULS_NOT_OBSERVED_PRE_OBS_P

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

Number of hauls not observed during observer presence. Partially missed

HAULS_NOT_OBSERVED_PRE_OBS_T

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

Number of hauls not observed during observer presence. Total=P+W

HAULS_NOT_OBSERVED_PRE_OBS_W

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

Number of hauls not observed during observer presence. The whole number count of hauls that were missed entirely.

HAULS_NOT_OBSERVED_TOTAL_P

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

Total of individual partial hauls not observed

HAULS_NOT_OBSERVED_TOTAL_T

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

Total of totals of individual hauls not observed

HAULS_NOT_OBSERVED_TOTAL_W

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

Total of individual whole hauls not observed

HAULS_OBSERVED_OBS1_P

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

Total number of individual hauls observed. Observer 1. P=Partially Observed.

HAULS_OBSERVED_OBS1_T

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

Total number of individual hauls observed. Observer 1. Total=W+P.

HAULS_OBSERVED_OBS1_W

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

Total number of individual hauls observed. Observer 1. W=Wholly observed.

HAULS_OBSERVED_OBS2_P

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

Total number of individual hauls observed. Observer 2. P=Partially Observed.

HAULS_OBSERVED_OBS2_T

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

Total number of individual hauls observed. Observer 2. Total=W+P.

HAULS_OBSERVED_OBS2_W

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

Total number of individual hauls observed. Observer 2. W=Wholly observed.

HAULS_OBSERVED_TOTAL_P

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

Total of individual partial hauls observed

HAULS_OBSERVED_TOTAL_T

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

Total of totals of individual hauls observed

HAULS_OBSERVED_TOTAL_W

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

Total of individual whole hauls observed

ID

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

Unique table ID value. Populated by AMMOP_SAMPLE_SEQ

MM_INCIDENTAL_TAKES

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

Total number of marine mammal incidental takes.

OBSERVER_ID

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

Primary observer that collected sample. References MM_OBSERVER

OPERATION_TYPE_ID

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

Operation type. References AMMOP_OPERATION_TYPE_CODE

PRIMARY_SPECIES_RETAINED_ID

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

ID for code of primary species retained. References AGENCY_SPECIE

PRIMARY_SPECIES_RETAINED_NAME

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

Name of primary species retained.

PRIMARY_SPECIES_RETAINED_TOTAL

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

Total number of primary species retained.

RECEIVED_DATE

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

For Form Tracking Purposes: Date Received.

RECEIVED_INITIALS

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

For Form Tracking Purposes: Person who received.

REVIEWED_BY_INITIALS

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

For Form Tracking Purposes: Person who reviewed

REVIEWED_DATE

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

For Form Tracking Purposes: Reviewed date

SAMPLE_ID

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

The unique id entered by the observer. It contains the observer id as well as a 3 digit sample id. It may contain a secondary observer id as well.

SAMPLE_TYPE_ID

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

Sample type used. References AMMOP_SAMPLE_TYPE_CODE

SEABIRD_INCIDENTAL_TAKES

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

Total number of seabird incidental takes.

SELECTION_TYPE_ID

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

Selection method used to select permit. References AMMOP_SELECTION_TYPE_CODE

VALIDATION_DATE

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

Date on which sample was checked and found valid according to business rules

Catalog Details

Catalog Item ID: 75097
GUID: gov.noaa.nmfs.inport:75097
Metadata Record Created By: Rachel Wuest
Metadata Record Created: 2025-03-05 18:51+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