Table: ATL_MESSAGE_PERMIT
Entity (ENT) | Alaska Fisheries Science Center (AFSC)GUID: gov.noaa.nmfs.inport:9734 | Updated: August 9, 2022 | Published / External
Data Attributes
Attribute Summary
|
|
Name | Type | Description |
|---|---|---|---|---|
|
100
|
|
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
| 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
| 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
| 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
| 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
| Data Storage Type: | NUMBER |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Primary key unique for each row. |
SUB_ADVISOR_END_DATE
| 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
| 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. |