Search Help Show/Hide Menu
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

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

Description

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

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
OBSERVER_SEQ
NUMBER
A unique number that identifies a specific observer.
FIRST_NAME
VARCHAR2
The first name of the observer.
LAST_NAME
VARCHAR2
The last name of the observer.
MIDDLE_NAME
VARCHAR2
The middle name of the observer.
LAST_PHYSICAL_DATE
DATE
Date of the observers last physical and determination of fitness for duty.
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).
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.
CREATE_DATE
DATE
Date record was input into database. Timestamped by the server
LAST_UPDATE_DATE
DATE
Date data record was last altered. First entered in Date data record was last altered.
LAST_UPDATED_BY
VARCHAR2
User whose session who last altered data record.
CON_AGREE_DATE
DATE
Date of latest confidentiality agreement
LETTER_UNDERSTAND_DATE
DATE
Date of latest letter of understanding
DATE_OF_BIRTH
DATE
Observer Birth Date
SEX_CODE
VARCHAR2
Observers sex code ( May not be known)

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