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_LOV_REQUIREMENT

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

Summary

Abstract

This entity represents the list of conditions and requirements. The implimentation will facilitate software in determining training for new and returning observers.

Description

This entity represents the list of conditions and requirements. The implimentation will facilitate software in determining training for new and returning observers.

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
REQUIREMENT_CODE
VARCHAR2 		Unique Alpha code identifying an observer qualifying requirement
DESCRIPTION
VARCHAR2 		Text describing this requirement.
ACTIVE_DATE
DATE 		Mandatory date after which qualification must be met
RETIRED_DATE
DATE 		Date after which this qualification requirement no longer applies.
REQUIREMENT_GROUP
VARCHAR2 		Indciates a group of requirements that is used with the group level to determine when a requirement is superceded.
REQUIREMENT_LEVEL_GROUP
NUMBER 		used with the group to determine when a requirement is superceded. A higher level in the group can supercede a lower level.

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_LOV_REQUIREMENT
Short Name: OLS_LOV_REQUIREMENT
Status: Completed
Abstract:

This entity represents the list of conditions and requirements. The implimentation will facilitate software in determining training for new and returning observers.
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 list of conditions and requirements. The implimentation will facilitate software in determining training for new and returning observers.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 Primary Key REQUIREMENT_CODE VARCHAR2 Unique Alpha code identifying an observer qualifying requirement
100
 DESCRIPTION VARCHAR2 Text describing this requirement.
100
 ACTIVE_DATE DATE Mandatory date after which qualification must be met
100
 RETIRED_DATE DATE Date after which this qualification requirement no longer applies.
100
 REQUIREMENT_GROUP VARCHAR2 Indciates a group of requirements that is used with the group level to determine when a requirement is superceded.
100
 REQUIREMENT_LEVEL_GROUP NUMBER used with the group to determine when a requirement is superceded. A higher level in the group can supercede a lower level.

Attribute Details

REQUIREMENT_CODE

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

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

DESCRIPTION

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

Text describing this requirement.
General Data Type: VARCHAR2

ACTIVE_DATE

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

Mandatory date after which qualification must be met
General Data Type: DATE

RETIRED_DATE

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

Date after which this qualification requirement no longer applies.
General Data Type: DATE

REQUIREMENT_GROUP

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

Indciates a group of requirements that is used with the group level to determine when a requirement is superceded.
General Data Type: VARCHAR2

REQUIREMENT_LEVEL_GROUP

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

used with the group to determine when a requirement is superceded. A higher level in the group can supercede a lower level.
General Data Type: NUMBER

Catalog Details

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