Slide Menu
Jump to Section...
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/North Pacific Groundfish and Halibut O... >

Table: ATL_MESSAGE_PERMIT

Entity (ENT)  |  Alaska Fisheries Science Center (AFSC)
GUID: gov.noaa.nmfs.inport:9734  |  Updated: August 9, 2022  |  Published / External 

Item Identification

Title: Table: ATL_MESSAGE_PERMIT
Short Name: ATL_MESSAGE_PERMIT
Status: Completed
Notes:

Loaded by batch 2390, 06-30-2009 16:11

Entity Information

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

Tracks who is the current inseason advisor.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 Primary Key PERMIT NUMBER Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau
100
 PRIMARY_ADVISOR_FLAG VARCHAR2 Column contains 'Y' or 'N' to indicate if the staff member is the primary advisor for the vessel. Primary advisors are responsible for the vessel a majority of the time, but may on occassion need to have another staff cover the inseason communications duties (during vacation or field assignments for e.g.). If the staff in question has the primary advisor flag set to 'Y' and current advisor flag set to 'N', another staff is currently monitoring messages for the vessel.
100
 OLS_STAFF_ID VARCHAR2 FK to ols_lov_staff for the staff advisor for this permit.
100
 PC_DUMMY_BOAT_FLAG VARCHAR2 A value of 'Y' denotes this permit is used strictly for Atlas advising purposes. An observer is not actually deployed to the vessel.
100
 MESSAGE_PERMIT_SEQ NUMBER Primary key unique for each row.
100
 SUB_ADVISOR_END_DATE DATE The End date for the substitute inseason advisor. If this column is null then the advisor is the primary advisor.
100
 SUB_ADVISOR_START_DATE DATE The start date for the substitute advisor. If this column is null then the advisor is the primary advisor.

Attribute Details

PERMIT

CC ID: 38749
Seq. Order: 1
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: Yes
Precision: 38
Status: Active
Description:

Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau
General Data Type: NUMBER

PRIMARY_ADVISOR_FLAG

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

Column contains 'Y' or 'N' to indicate if the staff member is the primary advisor for the vessel. Primary advisors are responsible for the vessel a majority of the time, but may on occassion need to have another staff cover the inseason communications duties (during vacation or field assignments for e.g.). If the staff in question has the primary advisor flag set to 'Y' and current advisor flag set to 'N', another staff is currently monitoring messages for the vessel.
General Data Type: VARCHAR2

OLS_STAFF_ID

CC ID: 786547
Data Storage Type: VARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

FK to ols_lov_staff for the staff advisor for this permit.

PC_DUMMY_BOAT_FLAG

CC ID: 786548
Data Storage Type: VARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

A value of 'Y' denotes this permit is used strictly for Atlas advising purposes. An observer is not actually deployed to the vessel.

MESSAGE_PERMIT_SEQ

CC ID: 786550
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Primary key unique for each row.

SUB_ADVISOR_END_DATE

CC ID: 786551
Data Storage Type: DATE
Required: No
Primary Key: No
Status: Active
Description:

The End date for the substitute inseason advisor. If this column is null then the advisor is the primary advisor.

SUB_ADVISOR_START_DATE

CC ID: 786552
Data Storage Type: DATE
Required: No
Primary Key: No
Status: Active
Description:

The start date for the substitute advisor. If this column is null then the advisor is the primary advisor.

Catalog Details

Catalog Item ID: 9734
GUID: gov.noaa.nmfs.inport:9734
Metadata Record Created By: Doug Turnbull
Metadata Record Created: 2009-06-30 16:11+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