Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
Alaska Fisheries Science Center Metadata Librar... > Fisheries Management and Analysis Division > North Pacific (NORPAC) Groundfish and Halibut O... > AFSC/FMA/North Pacific Groundfish and Halibut O... >

Table: OBSERVERS

Entity (ENT)  |  Alaska Fisheries Science Center (AFSC)
GUID: gov.noaa.nmfs.inport:9756  |  Updated: August 9, 2022  |  Published / External 
Summary
Item Identification
Keywords
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

The observers table is at the intersection of the ATL and Domestic data sets. As the redevelopment of the NORPAC system extends into observer logistics this object may change in name and structure.

Description

This table contains information about a specific observer.

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
OBSERVER_JOIN
NUMBER 		A unique number that identifies a specific observer.
LAST_NAME
VARCHAR2 		The last name of the observer.
MIDDLE_NAME
VARCHAR2 		The middle name of the observer.
FIRST_NAME
VARCHAR2 		The first name of the observer.
EMAIL_ADDRESS
VARCHAR2 		The e-mail address of the observer.
HOLD_LEVEL2_CERTIFICATION_FLAG
VARCHAR2 		A one-digit alpha code. Y = Yes, the observer has Level 2 status; N = No, the observer does not have Level 2 status.
REHIRE_STATUS
VARCHAR2 		A two-digit alpha code indicating the rehire status of the observer. EL = eligible for rehire; NE = not eligible for rehire; NA = not applicable (hasn't gone out yet).
SEX
VARCHAR2 		The sex of the observer. M = Male; F = Female; U = Unknown.
DATE_OF_BIRTH
DATE 		The date of the observer's birth.
PERMANENT_ADDRESS
VARCHAR2 		The permanent street address of the observer.
PERMANENT_CITY
VARCHAR2 		The permanent city address of the observe
PERMANENT_STATE
VARCHAR2 		The permanent state address of the observer
PERMANENT_ZIPCODE
VARCHAR2 		The permanent zipcode of the observer.
PERMANENT_PHONE
NUMBER 		The permanent phone number of the observe
PREVIOUS_NAME
VARCHAR2 		Any previous name of the observer.
RESUME_ON_FILE
VARCHAR2 		A one-digit alpha code indicating whether the observer's resume is on file or not. Y = Yes; N = No.
LAST_PHYSICAL_DATE
DATE 		The date of the observer's last physical.
ARCHIVED_FILE
VARCHAR2 		A one-digit alpha code indicating whether the observer's file is present or not. Y = Yes; N = No.
PHOTO_PRESENT
VARCHAR2 		A one-digit alpha code indicating whether the observer's photo is on file or not. Y = Yes; N = No.
CREATE_DATE
DATE 		Date record was input into database.
CREATED_BY
VARCHAR2 		Person who loaded data into database.
LAST_UPDATE_DATE
DATE 		Date data record was last altered. First entered in December 2003.
LAST_UPDATED_BY
VARCHAR2 		Person who last altered data record. First entered in December 2003.

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: Table: OBSERVERS
Short Name: OBSERVERS
Status: Completed
Abstract:

The observers table is at the intersection of the ATL and Domestic data sets. As the redevelopment of the NORPAC system extends into observer logistics this object may change in name and structure.
Notes:

Loaded by batch 2390, 06-30-2009 16:11

Keywords

Theme Keywords

Thesaurus Keyword
UNCONTROLLED
None AFSC
None ATL
None ATLAS
None BYCATCH
None FMA
None GROUNDFISH
None NORPAC
None OBSERVER

Spatial Keywords

Thesaurus Keyword
UNCONTROLLED
None AI
None ALEUTIAN ISLANDS
None BERING SEA
None BS
None BSAI
None GOA
None GULF OF ALASKA

Entity Information

Entity Type: Data Table
Active Version?: Yes
Schema Name: NORPAC
Description:

This table contains information about a specific observer.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 Primary Key OBSERVER_JOIN NUMBER A unique number that identifies a specific observer.
100
 LAST_NAME VARCHAR2 The last name of the observer.
100
 MIDDLE_NAME VARCHAR2 The middle name of the observer.
100
 FIRST_NAME VARCHAR2 The first name of the observer.
100
 EMAIL_ADDRESS VARCHAR2 The e-mail address of the observer.
100
 HOLD_LEVEL2_CERTIFICATION_FLAG VARCHAR2 A one-digit alpha code. Y = Yes, the observer has Level 2 status; N = No, the observer does not have Level 2 status.
100
 REHIRE_STATUS VARCHAR2 A two-digit alpha code indicating the rehire status of the observer. EL = eligible for rehire; NE = not eligible for rehire; NA = not applicable (hasn't gone out yet).
100
 SEX VARCHAR2 The sex of the observer. M = Male; F = Female; U = Unknown.
100
 DATE_OF_BIRTH DATE The date of the observer's birth.
100
 PERMANENT_ADDRESS VARCHAR2 The permanent street address of the observer.
100
 PERMANENT_CITY VARCHAR2 The permanent city address of the observe
100
 PERMANENT_STATE VARCHAR2 The permanent state address of the observer
100
 PERMANENT_ZIPCODE VARCHAR2 The permanent zipcode of the observer.
100
 PERMANENT_PHONE NUMBER The permanent phone number of the observe
100
 PREVIOUS_NAME VARCHAR2 Any previous name of the observer.
100
 RESUME_ON_FILE VARCHAR2 A one-digit alpha code indicating whether the observer's resume is on file or not. Y = Yes; N = No.
100
 LAST_PHYSICAL_DATE DATE The date of the observer's last physical.
100
 ARCHIVED_FILE VARCHAR2 A one-digit alpha code indicating whether the observer's file is present or not. Y = Yes; N = No.
100
 PHOTO_PRESENT VARCHAR2 A one-digit alpha code indicating whether the observer's photo is on file or not. Y = Yes; N = No.
100
 CREATE_DATE DATE Date record was input into database.
100
 CREATED_BY VARCHAR2 Person who loaded data into database.
100
 LAST_UPDATE_DATE DATE Date data record was last altered. First entered in December 2003.
100
 LAST_UPDATED_BY VARCHAR2 Person who last altered data record. First entered in December 2003.

Attribute Details

OBSERVER_JOIN

CC ID: 39012
Seq. Order: 1
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: Yes
Precision: 6
Scale: 0
Status: Active
Description:

A unique number that identifies a specific observer.
General Data Type: NUMBER

LAST_NAME

CC ID: 39007
Seq. Order: 2
Data Storage Type: VARCHAR2
Max Length: 30
Required: Yes
Primary Key: No
Status: Active
Description:

The last name of the observer.
General Data Type: VARCHAR2

MIDDLE_NAME

CC ID: 39011
Seq. Order: 3
Data Storage Type: VARCHAR2
Max Length: 15
Required: No
Primary Key: No
Status: Active
Description:

The middle name of the observer.
General Data Type: VARCHAR2

FIRST_NAME

CC ID: 39005
Seq. Order: 4
Data Storage Type: VARCHAR2
Max Length: 15
Required: Yes
Primary Key: No
Status: Active
Description:

The first name of the observer.
General Data Type: VARCHAR2

EMAIL_ADDRESS

CC ID: 39004
Seq. Order: 5
Data Storage Type: VARCHAR2
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

The e-mail address of the observer.
General Data Type: VARCHAR2

HOLD_LEVEL2_CERTIFICATION_FLAG

CC ID: 39006
Seq. Order: 6
Data Storage Type: VARCHAR2
Max Length: 1
Required: Yes
Primary Key: No
Status: Active
Description:

A one-digit alpha code. Y = Yes, the observer has Level 2 status; N = No, the observer does not have Level 2 status.

General Data Type: VARCHAR2

REHIRE_STATUS

CC ID: 39020
Seq. Order: 7
Data Storage Type: VARCHAR2
Max Length: 2
Required: Yes
Primary Key: No
Status: Active
Description:

A two-digit alpha code indicating the rehire status of the observer. EL = eligible for rehire; NE = not eligible for rehire; NA = not applicable (hasn't gone out yet).
General Data Type: VARCHAR2
Foreign Key Relations:

NORPAC.REHIRE_STATUS_CODES

SEX

CC ID: 39022
Seq. Order: 8
Data Storage Type: VARCHAR2
Max Length: 1
Required: Yes
Primary Key: No
Status: Active
Description:

The sex of the observer. M = Male; F = Female; U = Unknown.
General Data Type: VARCHAR2

DATE_OF_BIRTH

CC ID: 39003
Seq. Order: 9
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

The date of the observer's birth.
General Data Type: DATE

PERMANENT_ADDRESS

CC ID: 39013
Seq. Order: 10
Data Storage Type: VARCHAR2
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

The permanent street address of the observer.
General Data Type: VARCHAR2

PERMANENT_CITY

CC ID: 39014
Seq. Order: 11
Data Storage Type: VARCHAR2
Max Length: 25
Required: No
Primary Key: No
Status: Active
Description:

The permanent city address of the observe
General Data Type: VARCHAR2

PERMANENT_STATE

CC ID: 39016
Seq. Order: 12
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

The permanent state address of the observer
General Data Type: VARCHAR2

PERMANENT_ZIPCODE

CC ID: 39017
Seq. Order: 13
Data Storage Type: VARCHAR2
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

The permanent zipcode of the observer.
General Data Type: VARCHAR2

PERMANENT_PHONE

CC ID: 39015
Seq. Order: 14
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 10
Scale: 0
Status: Active
Description:

The permanent phone number of the observe
General Data Type: NUMBER

PREVIOUS_NAME

CC ID: 39019
Seq. Order: 15
Data Storage Type: VARCHAR2
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

Any previous name of the observer.
General Data Type: VARCHAR2

RESUME_ON_FILE

CC ID: 39021
Seq. Order: 16
Data Storage Type: VARCHAR2
Max Length: 1
Required: Yes
Primary Key: No
Status: Active
Description:

A one-digit alpha code indicating whether the observer's resume is on file or not. Y = Yes; N = No.

General Data Type: VARCHAR2

LAST_PHYSICAL_DATE

CC ID: 39008
Seq. Order: 17
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

The date of the observer's last physical.
General Data Type: DATE

ARCHIVED_FILE

CC ID: 39000
Seq. Order: 18
Data Storage Type: VARCHAR2
Max Length: 1
Required: Yes
Primary Key: No
Status: Active
Description:

A one-digit alpha code indicating whether the observer's file is present or not. Y = Yes; N = No.
General Data Type: VARCHAR2

PHOTO_PRESENT

CC ID: 39018
Seq. Order: 19
Data Storage Type: VARCHAR2
Max Length: 1
Required: Yes
Primary Key: No
Status: Active
Description:

A one-digit alpha code indicating whether the observer's photo is on file or not. Y = Yes; N = No.
General Data Type: VARCHAR2

CREATE_DATE

CC ID: 39002
Seq. Order: 20
Data Storage Type: DATE
Max Length: 7
Required: Yes
Primary Key: No
Status: Active
Description:

Date record was input into database.
General Data Type: DATE

CREATED_BY

CC ID: 39001
Seq. Order: 21
Data Storage Type: VARCHAR2
Max Length: 30
Required: Yes
Primary Key: No
Status: Active
Description:

Person who loaded data into database.
General Data Type: VARCHAR2

LAST_UPDATE_DATE

CC ID: 39010
Seq. Order: 22
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Date data record was last altered. First entered in December 2003.
General Data Type: DATE

LAST_UPDATED_BY

CC ID: 39009
Seq. Order: 23
Data Storage Type: VARCHAR2
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

Person who last altered data record. First entered in December 2003.
General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 9756
GUID: gov.noaa.nmfs.inport:9756
Metadata Record Created By: Doug Turnbull
Metadata Record Created: 2009-06-30 16:11+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2018-09-26
Owner Org: AFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2018-09-26
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2019-09-26