Table: OLS_MID_CRUISE_DETAIL
Entity (ENT) | Alaska Fisheries Science Center (AFSC)GUID: gov.noaa.nmfs.inport:12307 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
Contains mid cruise comments for an observers cruise created by debriefing staff. A mid cruise review may be required for new observers or those for whom data or process problems have been identified by inseason staff. The comments recorded here provide guidance to debriefing personnel and provide information to inseason advisors about progress or areas of continued concern.
DescriptionContains mid cruise comments for an observers cruise created by debriefing staff. A mid cruise review may be required for new observers or those for whom data or process problems have been identified by inseason staff. The comments recorded here provide guidance to debriefing personnel and provide information to inseason advisors about progress or areas of continued concern.
Entity Information
Entity Type
Data Table
Data Attribute / Type | Description |
---|---|
MID_CRUISE_SEQ
NUMBER |
Mid cruise sequence |
CRUISE
NUMBER |
Cruise number the mid cruise pertains to. |
STAFF_DEBRIEFER
NUMBER |
Debriefer number (staff_id)creating mid cruise debriefing |
CREATE_DATE
DATE |
Date mid cruise created |
LOCATION
VARCHAR2 |
Location code for where mid cruise debriefing takes place. |
LAST_UPDATED_BY
NUMBER |
Last debriefer updating the mid cruise. |
LAST_UPDATE_DATE
DATE |
Date the mid cruise was last updated. |
MID_CRUISE_COMMENT
CLOB |
Discussion of the process used and results of the mid-cruise review. |
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_MID_CRUISE_DETAIL |
---|---|
Short Name: | OLS_MID_CRUISE_DETAIL |
Status: | Completed |
Abstract: |
Contains mid cruise comments for an observers cruise created by debriefing staff. A mid cruise review may be required for new observers or those for whom data or process problems have been identified by inseason staff. The comments recorded here provide guidance to debriefing personnel and provide information to inseason advisors about progress or areas of continued concern. |
Notes: |
Loaded by batch 3083, 04-19-2012 13:25 |
Entity Information
Entity Type: | Data Table |
---|---|
Active Version?: | Yes |
Schema Name: | NORPAC |
Description: |
Contains mid cruise comments for an observers cruise created by debriefing staff. A mid cruise review may be required for new observers or those for whom data or process problems have been identified by inseason staff. The comments recorded here provide guidance to debriefing personnel and provide information to inseason advisors about progress or areas of continued concern. |
Data Attributes
Attribute Summary
Name | Type | Description | ||
---|---|---|---|---|
100
|
MID_CRUISE_SEQ | NUMBER | Mid cruise sequence | |
100
|
CRUISE | NUMBER | Cruise number the mid cruise pertains to. | |
100
|
STAFF_DEBRIEFER | NUMBER | Debriefer number (staff_id)creating mid cruise debriefing | |
100
|
CREATE_DATE | DATE | Date mid cruise created | |
100
|
LOCATION | VARCHAR2 | Location code for where mid cruise debriefing takes place. | |
100
|
LAST_UPDATED_BY | NUMBER | Last debriefer updating the mid cruise. | |
100
|
LAST_UPDATE_DATE | DATE | Date the mid cruise was last updated. | |
100
|
MID_CRUISE_COMMENT | CLOB | Discussion of the process used and results of the mid-cruise review. |
Attribute Details
MID_CRUISE_SEQ
Seq. Order: | 1 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | Yes |
Precision: | 9 |
Scale: | 0 |
Status: | Active |
Description: |
Mid cruise sequence |
General Data Type: | NUMBER |
CRUISE
Seq. Order: | 2 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Precision: | 9 |
Scale: | 0 |
Status: | Active |
Description: |
Cruise number the mid cruise pertains to. |
General Data Type: | NUMBER |
Foreign Key Relations: |
NORPAC.OLS_OBSERVER_CRUISE |
STAFF_DEBRIEFER
Seq. Order: | 3 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Precision: | 9 |
Scale: | 0 |
Status: | Active |
Description: |
Debriefer number (staff_id)creating mid cruise debriefing |
General Data Type: | NUMBER |
Foreign Key Relations: |
NORPAC.OLS_LOV_STAFF |
CREATE_DATE
Seq. Order: | 4 |
---|---|
Data Storage Type: | DATE |
Max Length: | 7 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Date mid cruise created |
General Data Type: | DATE |
LOCATION
Seq. Order: | 5 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Location code for where mid cruise debriefing takes place. |
General Data Type: | VARCHAR2 |
Foreign Key Relations: |
NORPAC.OLS_LOV_LOCATION |
LAST_UPDATED_BY
Seq. Order: | 6 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 9 |
Scale: | 0 |
Status: | Active |
Description: |
Last debriefer updating the mid cruise. |
General Data Type: | NUMBER |
LAST_UPDATE_DATE
Seq. Order: | 7 |
---|---|
Data Storage Type: | DATE |
Max Length: | 7 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Date the mid cruise was last updated. |
General Data Type: | DATE |
MID_CRUISE_COMMENT
Seq. Order: | 8 |
---|---|
Data Storage Type: | CLOB |
Max Length: | 4000 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Discussion of the process used and results of the mid-cruise review. |
General Data Type: | CLOB |
Catalog Details
Catalog Item ID: | 12307 |
---|---|
GUID: | gov.noaa.nmfs.inport:12307 |
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 |