Slide Menu
Search Help Show/Hide Menu

Item Identification

Title: Table: OLS_LOV_TRAINING_LEVEL
Short Name: OLS_LOV_TRAINING_LEVEL
Status: Completed
Abstract:

This entity is adapted from the old logistics system Training_Levels. It represents the purpose in terms of deployment, specialized, and optional training.

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 is adapted from the old logistics system Training_Levels. It represents the purpose in terms of deployment, specialized, and optional training.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key TRAINING_LEVEL_SEQ NUMBER Sequence generated training level unique identifier.
100
DESCRITIPION VARCHAR2 Descriptive text of purpose and result of training.
100
CRUISE_ASSIGN_FLAG VARCHAR2 Yes-No identifier if this is required for the creation of an observer cruise record.

Attribute Details

TRAINING_LEVEL_SEQ

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

Sequence generated training level unique identifier.

General Data Type: NUMBER

DESCRITIPION

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

Descriptive text of purpose and result of training.

General Data Type: VARCHAR2

CRUISE_ASSIGN_FLAG

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

Yes-No identifier if this is required for the creation of an observer cruise record.

General Data Type: VARCHAR2

Catalog Details

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