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_TRAINING

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

Summary

Abstract

This entity represents a record of the training classes that observer has been enrolled in and or attended.

Description

This entity represents a record of the training classes that observer has been enrolled in and or attended.

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
OBSERVER_TRAINING_SEQ
NUMBER 		Unique identifier of an observer training record.
OBSERVER_SEQ
NUMBER 		FK identifier of an OLS observer record.
TRAINING_CLASS_SEQ
NUMBER 		FK Identifier of an OLS training class record
OBSERVER_CLASS_GRADE
VARCHAR2 		Passed, Failed, Dropped, No Show, Dismissed etc
TRAINING_COMMENT
VARCHAR2 		Training comments about the observers work in the class
REGISTRATION_DATE
DATE 		date enrolled in class

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_TRAINING
Short Name: OLS_OBSERVER_TRAINING
Status: Completed
Abstract:

This entity represents a record of the training classes that observer has been enrolled in and or attended.
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 a record of the training classes that observer has been enrolled in and or attended.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 Primary Key OBSERVER_TRAINING_SEQ NUMBER Unique identifier of an observer training record.
100
 OBSERVER_SEQ NUMBER FK identifier of an OLS observer record.
100
 TRAINING_CLASS_SEQ NUMBER FK Identifier of an OLS training class record
100
 OBSERVER_CLASS_GRADE VARCHAR2 Passed, Failed, Dropped, No Show, Dismissed etc
100
 TRAINING_COMMENT VARCHAR2 Training comments about the observers work in the class
100
 REGISTRATION_DATE DATE date enrolled in class

Attribute Details

OBSERVER_TRAINING_SEQ

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

Unique identifier of an observer training record.
General Data Type: NUMBER

OBSERVER_SEQ

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

FK identifier of an OLS observer record.
General Data Type: NUMBER
Foreign Key Relations:

NORPAC.OLS_OBSERVER

TRAINING_CLASS_SEQ

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

FK Identifier of an OLS training class record
General Data Type: NUMBER
Foreign Key Relations:

NORPAC.OLS_TRAINING_CLASS

OBSERVER_CLASS_GRADE

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

Passed, Failed, Dropped, No Show, Dismissed etc
General Data Type: VARCHAR2

TRAINING_COMMENT

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

Training comments about the observers work in the class
General Data Type: VARCHAR2

REGISTRATION_DATE

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

date enrolled in class
General Data Type: DATE

Catalog Details

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