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_TEST

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

Summary

Description

Information on tests given during various training classes.

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
TEST_SEQ
NUMBER 		Sequence generated unique identifier for a test instrument
TEST_SEQ_IN_CLASS
NUMBER 		Order the tests are given in a class
DESCRIPTION
VARCHAR2 		Descriptive text of the format, purpose and evaluation for this version of this examination.
MINIMUM_PASS
NUMBER 		Percentage as a whole number that is required to pass this test
MANDATORY_FLAG
VARCHAR2 		Boolean indicator of whether or not this emanination is mandatory for certification at this level.
CLASS_TYPE_CODE
VARCHAR2 		Class that the test is for e.g. 3WK
END_DATE
DATE 		last date the test was used or when it was replaced

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_TEST
Short Name: OLS_LOV_TEST
Status: Completed
Notes:

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

Entity Information

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

Information on tests given during various training classes.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 Primary Key TEST_SEQ NUMBER Sequence generated unique identifier for a test instrument
100
 TEST_SEQ_IN_CLASS NUMBER Order the tests are given in a class
100
 DESCRIPTION VARCHAR2 Descriptive text of the format, purpose and evaluation for this version of this examination.
100
 MINIMUM_PASS NUMBER Percentage as a whole number that is required to pass this test
100
 MANDATORY_FLAG VARCHAR2 Boolean indicator of whether or not this emanination is mandatory for certification at this level.
100
 CLASS_TYPE_CODE VARCHAR2 Class that the test is for e.g. 3WK
100
 END_DATE DATE last date the test was used or when it was replaced

Attribute Details

TEST_SEQ

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

Sequence generated unique identifier for a test instrument
General Data Type: NUMBER

TEST_SEQ_IN_CLASS

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

Order the tests are given in a class
General Data Type: NUMBER

DESCRIPTION

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

Descriptive text of the format, purpose and evaluation for this version of this examination.
General Data Type: VARCHAR2

MINIMUM_PASS

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

Percentage as a whole number that is required to pass this test
General Data Type: NUMBER

MANDATORY_FLAG

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

Boolean indicator of whether or not this emanination is mandatory for certification at this level.
General Data Type: VARCHAR2

CLASS_TYPE_CODE

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

Class that the test is for e.g. 3WK
General Data Type: VARCHAR2
Foreign Key Relations:

NORPAC.OLS_LOV_TRAINING_TYPE

END_DATE

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

last date the test was used or when it was replaced
General Data Type: DATE

Catalog Details

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