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_TRAINING_CLASS

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

Summary

Abstract

Observer training takes place in a formal classroom environment. This entity represents an instance of a class of a particular type held at a centain date or date range

Description

Observer training takes place in a formal classroom environment. This entity represents an instance of a class of a particular type held at a centain date or date range

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
TRAINING_CLASS_SEQ
NUMBER 		Sequence generated unique identifier for an OLS_Training_Class Record.
STAFF_ID
NUMBER 		Sequence generated unique identifier of an employee.
TYPE_CODE
VARCHAR2 		Three Letter Code identifying duration, fishery or segment to which an observer training session applies.
START_DATE
DATE 		Date that the class is scheduled to start
END_DATE
DATE 		Date that the class is scheduled to end.
CLASS_STATUS
VARCHAR2 		The status of a class. scheduled, in session, completed, cancelled.
LOCATION_CODE
VARCHAR2 		Code identifing where the class is to take place

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_TRAINING_CLASS
Short Name: OLS_TRAINING_CLASS
Status: Completed
Abstract:

Observer training takes place in a formal classroom environment. This entity represents an instance of a class of a particular type held at a centain date or date range
Notes:

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

Entity Information

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

Observer training takes place in a formal classroom environment. This entity represents an instance of a class of a particular type held at a centain date or date range

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 Primary Key TRAINING_CLASS_SEQ NUMBER Sequence generated unique identifier for an OLS_Training_Class Record.
100
 STAFF_ID NUMBER Sequence generated unique identifier of an employee.
100
 TYPE_CODE VARCHAR2 Three Letter Code identifying duration, fishery or segment to which an observer training session applies.
100
 START_DATE DATE Date that the class is scheduled to start
100
 END_DATE DATE Date that the class is scheduled to end.
100
 CLASS_STATUS VARCHAR2 The status of a class. scheduled, in session, completed, cancelled.
100
 LOCATION_CODE VARCHAR2 Code identifing where the class is to take place

Attribute Details

TRAINING_CLASS_SEQ

CC ID: 65361
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 an OLS_Training_Class Record.
General Data Type: NUMBER

STAFF_ID

CC ID: 65362
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 of an employee.
General Data Type: NUMBER
Foreign Key Relations:

NORPAC.OLS_LOV_STAFF

TYPE_CODE

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

Three Letter Code identifying duration, fishery or segment to which an observer training session applies.
General Data Type: VARCHAR2
Foreign Key Relations:

NORPAC.OLS_LOV_TRAINING_TYPE

START_DATE

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

Date that the class is scheduled to start
General Data Type: DATE

END_DATE

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

Date that the class is scheduled to end.
General Data Type: DATE

CLASS_STATUS

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

The status of a class. scheduled, in session, completed, cancelled.
General Data Type: VARCHAR2

LOCATION_CODE

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

Code identifing where the class is to take place
General Data Type: VARCHAR2
Foreign Key Relations:

NORPAC.OLS_LOV_LOCATION

Catalog Details

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