Maintenance Notice: Tuesday May 21 @ 12pm-1:30pm Eastern. InPort and its associated services will be under maintenance and unavailable for the deployment of InPort Release 5.3.6. Downtime Schedule Tuesday, May 21, 2024 12:00pm - 1:30pm Eastern / 9:00am - 10:30am Pacific / 6:00am - 8:30am Hawaii Impacted Areas - InPort Website: https://www.fisheries.noaa.gov/inport - InPort WAF: h...
View All
Search Help Show/Hide Menu
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Description

Tracks who is the current inseason advisor.

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
PERMIT
NUMBER
Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau
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.
OLS_STAFF_ID
VARCHAR2
FK to ols_lov_staff for the staff advisor for this permit.
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.
MESSAGE_PERMIT_SEQ
NUMBER
Primary key unique for each row.
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.
SUB_ADVISOR_START_DATE
DATE
The start date for the substitute advisor. If this column is null then the advisor is the primary advisor.

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: 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