MM_OBSERVER
Entity (ENT) | Alaska Fisheries Science Center (AFSC)GUID: gov.noaa.nmfs.inport:75191 | Updated: May 21, 2025 | Published / External
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
|
|
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 |