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_OBSERVER

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

Summary

Description

Records and codes the names and employer of AMMOP observers and field staff. Note that names can be redundant; each year a new code letter is applied designating observers, bird observers if present, and skiff drivers.

Entity Information

Data Attribute / Type Description
BEGIN_DATE
DATE 		Begin date useage
CODE
VARCHAR2(3 BYTE) 		AMMOP code for program workers
EMPLOYER_ID
NUMBER(6,0) 		Unique database id for worker's employer
EMPLOYER_NAME
VARCHAR2(60 BYTE) 		Name of worker's employer
END_DATE
DATE 		Begin end useage
FIRST_NAME
VARCHAR2(20 BYTE) 		First name
FULL_NAME
VARCHAR2(60 BYTE) 		Full name
INDIVIDUAL_ID
NUMBER(6,0) 		The unique identifier of a AMMOP worker
LAST_NAME
VARCHAR2(20 BYTE) 		Last name
MIDDLE_INITIAL
VARCHAR2(1 BYTE) 		Middle initial
NAME_SUFFIX
VARCHAR2(5 BYTE) 		Name suffix

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_OBSERVER

Entity Information

Description:

Records and codes the names and employer of AMMOP observers and field staff. Note that names can be redundant; each year a new code letter is applied designating observers, bird observers if present, and skiff drivers.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 BEGIN_DATE DATE Begin date useage
100
 CODE VARCHAR2(3 BYTE) AMMOP code for program workers
100
 EMPLOYER_ID NUMBER(6,0) Unique database id for worker's employer
100
 EMPLOYER_NAME VARCHAR2(60 BYTE) Name of worker's employer
100
 END_DATE DATE Begin end useage
100
 FIRST_NAME VARCHAR2(20 BYTE) First name
100
 FULL_NAME VARCHAR2(60 BYTE) Full name
100
 INDIVIDUAL_ID NUMBER(6,0) The unique identifier of a AMMOP worker
100
 LAST_NAME VARCHAR2(20 BYTE) Last name
100
 MIDDLE_INITIAL VARCHAR2(1 BYTE) Middle initial
100
 NAME_SUFFIX VARCHAR2(5 BYTE) Name suffix

Attribute Details

BEGIN_DATE

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

Begin date useage

CODE

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

AMMOP code for program workers

EMPLOYER_ID

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

Unique database id for worker's employer

EMPLOYER_NAME

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

Name of worker's employer

END_DATE

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

Begin end useage

FIRST_NAME

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

First name

FULL_NAME

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

Full name

INDIVIDUAL_ID

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

The unique identifier of a AMMOP worker

LAST_NAME

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

Last name

MIDDLE_INITIAL

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

Middle initial

NAME_SUFFIX

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

Name suffix

Catalog Details

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