Table: OLS_LOV_TRAINING_TYPE
Entity (ENT) | Alaska Fisheries Science Center (AFSC)GUID: gov.noaa.nmfs.inport:12304 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
This entitiy is the list of valid class duration and scope descriptions including inception date and retirement date e.g. 5DY, 5CQ etc.
DescriptionThis entitiy is the list of valid class duration and scope descriptions including inception date and retirement date e.g. 5DY, 5CQ etc.
Entity Information
Entity Type
Data Table
Data Attribute / Type | Description |
---|---|
TYPE_CODE
VARCHAR2 |
Three Letter Code identifying duration, fishery or segment to which an observer training session applies. |
TRAINING_LEVEL_SEQ
NUMBER |
Sequence generated training level unique identifier. |
DESCRIPTION
VARCHAR2 |
Description of training length, fishery, segment and purpose. |
ACTIVE_DATE
DATE |
Date from which this training is available to be assigned. |
RETIRED_DATE
DATE |
Date from which this training will no longer be available. |
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_TRAINING_TYPE |
---|---|
Short Name: | OLS_LOV_TRAINING_TYPE |
Status: | Completed |
Abstract: |
This entitiy is the list of valid class duration and scope descriptions including inception date and retirement date e.g. 5DY, 5CQ etc. |
Notes: |
Loaded by batch 3083, 04-19-2012 13:25 |
Entity Information
Entity Type: | Data Table |
---|---|
Active Version?: | Yes |
Schema Name: | NORPAC |
Description: |
This entitiy is the list of valid class duration and scope descriptions including inception date and retirement date e.g. 5DY, 5CQ etc. |
Data Attributes
Attribute Summary
![]() |
![]() |
Name | Type | Description |
---|---|---|---|---|
100
|
![]() |
TYPE_CODE | VARCHAR2 | Three Letter Code identifying duration, fishery or segment to which an observer training session applies. |
100
|
TRAINING_LEVEL_SEQ | NUMBER | Sequence generated training level unique identifier. | |
100
|
DESCRIPTION | VARCHAR2 | Description of training length, fishery, segment and purpose. | |
100
|
ACTIVE_DATE | DATE | Date from which this training is available to be assigned. | |
100
|
RETIRED_DATE | DATE | Date from which this training will no longer be available. |
Attribute Details
TYPE_CODE
Seq. Order: | 1 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | Yes |
Primary Key: | Yes |
Status: | Active |
Description: |
Three Letter Code identifying duration, fishery or segment to which an observer training session applies. |
General Data Type: | VARCHAR2 |
TRAINING_LEVEL_SEQ
Seq. Order: | 2 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Precision: | 9 |
Scale: | 0 |
Status: | Active |
Description: |
Sequence generated training level unique identifier. |
General Data Type: | NUMBER |
Foreign Key Relations: |
NORPAC.OLS_LOV_TRAINING_LEVEL |
DESCRIPTION
Seq. Order: | 3 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 50 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Description of training length, fishery, segment and purpose. |
General Data Type: | VARCHAR2 |
ACTIVE_DATE
Seq. Order: | 4 |
---|---|
Data Storage Type: | DATE |
Max Length: | 7 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Date from which this training is available to be assigned. |
General Data Type: | DATE |
RETIRED_DATE
Seq. Order: | 5 |
---|---|
Data Storage Type: | DATE |
Max Length: | 7 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Date from which this training will no longer be available. |
General Data Type: | DATE |
Catalog Details
Catalog Item ID: | 12304 |
---|---|
GUID: | gov.noaa.nmfs.inport:12304 |
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 |