Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
Alaska Fisheries Science Center Metadata Librar... > Fisheries Management and Analysis Division > Observer Restructure (ODDS) > AFSC/FMA/Observer Declare and Deploy (Resturctu... >

Table: ODDS_VESSEL_SAMPLE_PLAN

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

Summary

Abstract

This tracks the strata a vessel is in for a given time period

Description

This tracks the strata a vessel is in for a given time period

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
VESSEL_SAMPLE_PLAN_SEQ
NUMBER 		PK sequence number
VESSEL_SEQ
NUMBER 		Sequence number of the vessel to which this strata applies.
SAMPLE_PLAN_SEQ
NUMBER 		Sequence number of the strata in which is the vessel.
BEGIN_DATE
DATE 		Effective start date vessel is in strata
END_DATE
DATE 		Effective end date the vessel is in the strata
OBSERVER_TYPE_SEQ
NUMBER 		Observer type for vessel strata. Not used at this time.

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

This tracks the strata a vessel is in for a given time period
Purpose:

This tracks the strata a vessel is in for a given time period
Notes:

Loaded by batch 4561, 04-30-2013 18:33

Entity Information

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

This tracks the strata a vessel is in for a given time period
Change Summary:

This tracks the strata a vessel is in for a given time period

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 Primary Key VESSEL_SAMPLE_PLAN_SEQ NUMBER PK sequence number
100
 VESSEL_SEQ NUMBER Sequence number of the vessel to which this strata applies.
100
 SAMPLE_PLAN_SEQ NUMBER Sequence number of the strata in which is the vessel.
100
 BEGIN_DATE DATE Effective start date vessel is in strata
100
 END_DATE DATE Effective end date the vessel is in the strata
100
 OBSERVER_TYPE_SEQ NUMBER Observer type for vessel strata. Not used at this time.

Attribute Details

VESSEL_SAMPLE_PLAN_SEQ

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

PK sequence number
General Data Type: NUMBER

VESSEL_SEQ

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

Sequence number of the vessel to which this strata applies.
General Data Type: NUMBER
Foreign Key Relations:

NORPAC.ATL_LOV_VESSEL

SAMPLE_PLAN_SEQ

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

Sequence number of the strata in which is the vessel.
General Data Type: NUMBER
Foreign Key Relations:

NORPAC.ODDS_LOV_SAMPLE_PLAN

BEGIN_DATE

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

Effective start date vessel is in strata
General Data Type: DATE

END_DATE

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

Effective end date the vessel is in the strata
General Data Type: DATE

OBSERVER_TYPE_SEQ

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

Observer type for vessel strata. Not used at this time.
General Data Type: NUMBER
Foreign Key Relations:

NORPAC.ODDS_LOV_OBSERVER_TYPE

Catalog Details

Catalog Item ID: 18870
GUID: gov.noaa.nmfs.inport:18870
Metadata Record Created By: Doug Turnbull
Metadata Record Created: 2013-04-30 18:33+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2016-05-18
Owner Org: AFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2016-05-18
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2017-05-18