Slide Menu
Jump to Section...
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/Observer Logistics System (OLS) >

Table: OLS_OBSERVER

Entity (ENT)  |  Alaska Fisheries Science Center (AFSC)
GUID: gov.noaa.nmfs.inport:12309  |  Updated: August 9, 2022  |  Published / External 

Item Identification

Title: Table: OLS_OBSERVER
Short Name: OLS_OBSERVER
Status: Completed
Abstract:

This entity rpresents the list of past and current observers, as well as information critical to FMA for current deployment and future availability.
Notes:

Loaded by batch 3083, 04-19-2012 13:25

Entity Information

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

This entity rpresents the list of past and current observers, as well as information critical to FMA for current deployment and future availability.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 Primary Key OBSERVER_SEQ NUMBER A unique number that identifies a specific observer.
100
 FIRST_NAME VARCHAR2 The first name of the observer.
100
 LAST_NAME VARCHAR2 The last name of the observer.
100
 MIDDLE_NAME VARCHAR2 The middle name of the observer.
100
 LAST_PHYSICAL_DATE DATE Date of the observers last physical and determination of fitness for duty.
100
 REHIRE_STATUS_CODE 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
 RESUME_ON_FILE_FLAG VARCHAR2 A one-digit alpha code indicating whether the observer's resume is on file or not. Y = Yes; N = No.
100
 CREATE_DATE DATE Date record was input into database. Timestamped by the server
100
 LAST_UPDATE_DATE DATE Date data record was last altered. First entered in Date data record was last altered.
100
 LAST_UPDATED_BY VARCHAR2 User whose session who last altered data record.
100
 CON_AGREE_DATE DATE Date of latest confidentiality agreement
100
 LETTER_UNDERSTAND_DATE DATE Date of latest letter of understanding
100
 DATE_OF_BIRTH DATE Observer Birth Date
100
 SEX_CODE VARCHAR2 Observers sex code ( May not be known)

Attribute Details

OBSERVER_SEQ

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

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

FIRST_NAME

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

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

LAST_NAME

CC ID: 65253
Seq. Order: 3
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: 65254
Seq. Order: 4
Data Storage Type: VARCHAR2
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

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

LAST_PHYSICAL_DATE

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

Date of the observers last physical and determination of fitness for duty.
General Data Type: DATE

REHIRE_STATUS_CODE

CC ID: 65256
Seq. Order: 6
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

RESUME_ON_FILE_FLAG

CC ID: 65257
Seq. Order: 7
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

CREATE_DATE

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

Date record was input into database. Timestamped by the server
General Data Type: DATE

LAST_UPDATE_DATE

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

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

LAST_UPDATED_BY

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

User whose session who last altered data record.
General Data Type: VARCHAR2

CON_AGREE_DATE

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

Date of latest confidentiality agreement
General Data Type: DATE

LETTER_UNDERSTAND_DATE

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

Date of latest letter of understanding
General Data Type: DATE

DATE_OF_BIRTH

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

Observer Birth Date
General Data Type: DATE

SEX_CODE

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

Observers sex code ( May not be known)
General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 12309
GUID: gov.noaa.nmfs.inport:12309
Metadata Record Created By: Doug Turnbull
Metadata Record Created: 2012-04-19 13:25+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