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_REQUIREMENT

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

Summary

Abstract

This entity represents the intersection of the set of mandatory requirements and an observer, as well as the precidence of the requirement. For example: a three week training always satisfies a four day training requirement. A one day training may be waived. A four day may be required in lieu of a one day training if an observer is having performance issues.

Description

This entity represents the intersection of the set of mandatory requirements and an observer, as well as the precidence of the requirement. For example: a three week training always satisfies a four day training requirement. A one day training may be waived. A four day may be required in lieu of a one day training if an observer is having performance issues.

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
REQUIREMENT_SEQ
NUMBER 		unique pk seq number
REQUIREMENT_CODE
VARCHAR2 		Unique Alpha code identifying an observer qualifying requirement
OBSERVER_SEQ
NUMBER 		A unique number that identifies a specific observer.
REQ_SATSFD_SEQ
NUMBER 		FK to list of requirement status codes indicating stage or condition of requirement satisfaction.
DATE_SATISFIED
DATE 		The data that training or time at seq qualification was completed.
OTHER_DESCRIPTION
VARCHAR2 		Comments relating to this traing or days at sea requirement.
REQUIREMENT_ADD_DATE
DATE 		Date requirement was added to the observer
REQUIREMENT_ADD_BY
VARCHAR2 		staff member who added requirement

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_REQUIREMENT
Short Name: OLS_OBSERVER_REQUIREMENT
Status: Completed
Abstract:

This entity represents the intersection of the set of mandatory requirements and an observer, as well as the precidence of the requirement. For example: a three week training always satisfies a four day training requirement. A one day training may be waived. A four day may be required in lieu of a one day training if an observer is having performance issues.
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 represents the intersection of the set of mandatory requirements and an observer, as well as the precidence of the requirement. For example: a three week training always satisfies a four day training requirement. A one day training may be waived. A four day may be required in lieu of a one day training if an observer is having performance issues.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 Primary Key REQUIREMENT_SEQ NUMBER unique pk seq number
100
 REQUIREMENT_CODE VARCHAR2 Unique Alpha code identifying an observer qualifying requirement
100
 OBSERVER_SEQ NUMBER A unique number that identifies a specific observer.
100
 REQ_SATSFD_SEQ NUMBER FK to list of requirement status codes indicating stage or condition of requirement satisfaction.
100
 DATE_SATISFIED DATE The data that training or time at seq qualification was completed.
100
 OTHER_DESCRIPTION VARCHAR2 Comments relating to this traing or days at sea requirement.
100
 REQUIREMENT_ADD_DATE DATE Date requirement was added to the observer
100
 REQUIREMENT_ADD_BY VARCHAR2 staff member who added requirement

Attribute Details

REQUIREMENT_SEQ

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

unique pk seq number
General Data Type: NUMBER

REQUIREMENT_CODE

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

Unique Alpha code identifying an observer qualifying requirement
General Data Type: VARCHAR2
Foreign Key Relations:

NORPAC.OLS_LOV_REQUIREMENT

OBSERVER_SEQ

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

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

NORPAC.OLS_OBSERVER

REQ_SATSFD_SEQ

CC ID: 65314
Seq. Order: 4
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 9
Scale: 0
Status: Active
Description:

FK to list of requirement status codes indicating stage or condition of requirement satisfaction.
General Data Type: NUMBER

DATE_SATISFIED

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

The data that training or time at seq qualification was completed.
General Data Type: DATE

OTHER_DESCRIPTION

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

Comments relating to this traing or days at sea requirement.
General Data Type: VARCHAR2

REQUIREMENT_ADD_DATE

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

Date requirement was added to the observer
General Data Type: DATE

REQUIREMENT_ADD_BY

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

staff member who added requirement
General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 12316
GUID: gov.noaa.nmfs.inport:12316
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