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_TEST_SCORE

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

Summary

Description

Keeps a training score for an observer test during training. Retakes of test are indicated by the RETAKE_FLAG.

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
TEST_SCORE_SEQ
NUMBER 		Sequence generated unique identifier for a test score.
TEST_SEQ
NUMBER 		Sequence generated unique identifier for a test instrument
OBSERVER_TRAINING_SEQ
NUMBER 		seq for class the observer was enrolled in to take the test
EXAMINATION_DATE
DATE 		Date that the test was taken.
SCORE
NUMBER 		Quantitative measurement of performance for a test instance, defined as the raw number of correct answers.
PERCENT_CORRECT
NUMBER 		Percentage answered correctly. This value is computed by the trainer and not validated.
RETAKE_FLAG
VARCHAR2 		identifier if this score is from a repeat instance of this test

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_TEST_SCORE
Short Name: OLS_TEST_SCORE
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:

Keeps a training score for an observer test during training. Retakes of test are indicated by the RETAKE_FLAG.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 Primary Key TEST_SCORE_SEQ NUMBER Sequence generated unique identifier for a test score.
100
 TEST_SEQ NUMBER Sequence generated unique identifier for a test instrument
100
 OBSERVER_TRAINING_SEQ NUMBER seq for class the observer was enrolled in to take the test
100
 EXAMINATION_DATE DATE Date that the test was taken.
100
 SCORE NUMBER Quantitative measurement of performance for a test instance, defined as the raw number of correct answers.
100
 PERCENT_CORRECT NUMBER Percentage answered correctly. This value is computed by the trainer and not validated.
100
 RETAKE_FLAG VARCHAR2 identifier if this score is from a repeat instance of this test

Attribute Details

TEST_SCORE_SEQ

CC ID: 65354
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 score.
General Data Type: NUMBER

TEST_SEQ

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

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

NORPAC.OLS_LOV_TEST

OBSERVER_TRAINING_SEQ

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

seq for class the observer was enrolled in to take the test
General Data Type: NUMBER
Foreign Key Relations:

NORPAC.OLS_OBSERVER_TRAINING

EXAMINATION_DATE

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

Date that the test was taken.
General Data Type: DATE

SCORE

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

Quantitative measurement of performance for a test instance, defined as the raw number of correct answers.
General Data Type: NUMBER

PERCENT_CORRECT

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

Percentage answered correctly. This value is computed by the trainer and not validated.
General Data Type: NUMBER

RETAKE_FLAG

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

identifier if this score is from a repeat instance of this test
General Data Type: VARCHAR2

Catalog Details

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