Table: OLS_MID_CRUISE_DETAIL
Alaska Fisheries Science Center
Entity
(ENT)
| ID: 12307
| Published / External
Created: 2012-04-19
|
Last Modified: 2022-08-09
Data Set (DS) | ID: 12269
ID: 12307
Entity (ENT)
* Discovery• First Pass
» Metadata Rubric
Item Identification
* » Title | Table: OLS_MID_CRUISE_DETAIL |
---|---|
Short Name | OLS_MID_CRUISE_DETAIL |
* Status | Completed |
Creation Date | |
Revision Date | |
• Publication Date | |
* » 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. |
* Purpose | |
Notes |
Loaded by batch 3083, 04-19-2012 13:25 |
Other Citation Details | |
• Supplemental Information | |
DOI (Digital Object Identifier) | |
DOI Registration Authority | |
DOI Issue Date |
Keywords
Theme Keywords
Thesaurus | Keyword |
---|---|
Temporal Keywords
Thesaurus | Keyword |
---|---|
* Spatial Keywords
Thesaurus | Keyword |
---|---|
Stratum Keywords
Thesaurus | Keyword |
---|---|
Instrument Keywords
Thesaurus | Keyword |
---|---|
Platform Keywords
Thesaurus | Keyword |
---|---|
Physical Location
• » Organization | |
---|---|
• » City | |
• » State/Province | |
• Country | |
• » Location Description |
Entity Information
Entity Type | Data Table |
---|---|
Active Version? | Y |
Alias | |
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. |
Change Summary |
Data Attributes
Attribute Summary
Score | Req'd? | PKey? | » Name | Data Storage Type | Description |
---|---|---|---|---|---|
100 | Yes | Yes | MID_CRUISE_SEQ | NUMBER | Mid cruise sequence |
100 | Yes | No | CRUISE | NUMBER | Cruise number the mid cruise pertains to. |
100 | Yes | No | STAFF_DEBRIEFER | NUMBER | Debriefer number (staff_id)creating mid cruise debriefing |
100 | Yes | No | CREATE_DATE | DATE | Date mid cruise created |
100 | Yes | No | LOCATION | VARCHAR2 | Location code for where mid cruise debriefing takes place. |
100 | No | No | LAST_UPDATED_BY | NUMBER | Last debriefer updating the mid cruise. |
100 | No | No | LAST_UPDATE_DATE | DATE | Date the mid cruise was last updated. |
100 | No | No | MID_CRUISE_COMMENT | CLOB | Discussion of the process used and results of the mid-cruise review. |
Attribute Details
Attribute Name | MID_CRUISE_SEQ |
---|---|
Seq. Order | 1 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | Yes |
Primary Key | Yes |
Precision | 9 |
Scale | 0 |
Status | Active |
Description |
Mid cruise sequence |
General Data Type | NUMBER |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | CRUISE |
---|---|
Seq. Order | 2 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | 9 |
Scale | 0 |
Status | Active |
Description |
Cruise number the mid cruise pertains to. |
General Data Type | NUMBER |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations |
NORPAC.OLS_OBSERVER_CRUISE |
Derivation | |
Validation Rules |
Attribute Name | STAFF_DEBRIEFER |
---|---|
Seq. Order | 3 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | 9 |
Scale | 0 |
Status | Active |
Description |
Debriefer number (staff_id)creating mid cruise debriefing |
General Data Type | NUMBER |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations |
NORPAC.OLS_LOV_STAFF |
Derivation | |
Validation Rules |
Attribute Name | CREATE_DATE |
---|---|
Seq. Order | 4 |
Data Storage Type | DATE |
Max Length | 7 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Date mid cruise created |
General Data Type | DATE |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | LOCATION |
---|---|
Seq. Order | 5 |
Data Storage Type | VARCHAR2 |
Max Length | 3 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Location code for where mid cruise debriefing takes place. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations |
NORPAC.OLS_LOV_LOCATION |
Derivation | |
Validation Rules |
Attribute Name | LAST_UPDATED_BY |
---|---|
Seq. Order | 6 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 9 |
Scale | 0 |
Status | Active |
Description |
Last debriefer updating the mid cruise. |
General Data Type | NUMBER |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | LAST_UPDATE_DATE |
---|---|
Seq. Order | 7 |
Data Storage Type | DATE |
Max Length | 7 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Date the mid cruise was last updated. |
General Data Type | DATE |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | MID_CRUISE_COMMENT |
---|---|
Seq. Order | 8 |
Data Storage Type | CLOB |
Max Length | 4000 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Discussion of the process used and results of the mid-cruise review. |
General Data Type | CLOB |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | |
---|---|
Seq. Order | |
Data Storage Type | |
Max Length | |
Precision | |
Scale | |
Required | |
Primary Key | |
Status | |
Description | |
General Data Type | |
Case Restriction | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Min Length | |
Unit of Measure | |
Display Example | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | |
---|---|
Seq. Order | |
Data Storage Type | |
Max Length | |
Precision | |
Scale | |
Required | |
Primary Key | |
Status | |
Description | |
General Data Type | |
Case Restriction | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Min Length | |
Unit of Measure | |
Display Example | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | |
---|---|
Seq. Order | |
Data Storage Type | |
Max Length | |
Precision | |
Scale | |
Required | |
Primary Key | |
Status | |
Description | |
General Data Type | |
Case Restriction | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Min Length | |
Unit of Measure | |
Display Example | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Support Roles
* » Support Role | |
---|---|
* » Date Effective From | |
Date Effective To | |
* » Contact | |
* Contact Instructions |
* » Support Role | |
---|---|
* » Date Effective From | |
Date Effective To | |
* » Contact | |
* Contact Instructions |
* » Support Role | |
---|---|
* » Date Effective From | |
Date Effective To | |
* » Contact | |
* Contact Instructions |
Extents
Currentness Reference |
---|
Extent Group 1
Extent Description |
---|
Extent Group 1 / Geographic Area
* » W° Bound | |
---|---|
* » E° Bound | |
* » N° Bound | |
* » S° Bound | |
* » Description |
Extent Group 1 / Vertical Extent
EPSG Code | |
---|---|
Vertical Minimum | |
Vertical Maximum |
Extent Group 1 / Time Frame
* » Time Frame Type | |
---|---|
* » Start | |
End | |
Alternate Start as of Info | |
Alternate End as of Info | |
Description |
Access Information
* » Security Class | |
---|---|
* Security Classification System |
|
Security Handling Description |
|
• Data Access Policy |
|
» Data Access Procedure |
|
• » Data Access Constraints |
|
• Data Use Constraints |
|
Metadata Access Constraints |
|
Metadata Use Constraints |
|
Distribution Information
Start Date | |
---|---|
End Date | |
» Download URL | |
Distributor | |
File Name | |
Description | |
File Date/Time | |
File Type | |
FGDC Content Type | |
File Size | |
Application Version | |
Compression | |
Review Status |
Start Date | |
---|---|
End Date | |
» Download URL | |
Distributor | |
File Name | |
Description | |
File Date/Time | |
File Type | |
FGDC Content Type | |
File Size | |
Application Version | |
Compression | |
Review Status |
Start Date | |
---|---|
End Date | |
» Download URL | |
Distributor | |
File Name | |
Description | |
File Date/Time | |
File Type | |
FGDC Content Type | |
File Size | |
Application Version | |
Compression | |
Review Status |
Activity Log
Activity Time | |
---|---|
Activity Type | |
Responsible Party | |
Description |
Activity Time | |
---|---|
Activity Type | |
Responsible Party | |
Description |
Activity Time | |
---|---|
Activity Type | |
Responsible Party | |
Description |
Issues
Issue Date | |
---|---|
Author | |
Issue |
Issue Date | |
---|---|
Author | |
Issue |
Issue Date | |
---|---|
Author | |
Issue |
FAQs
Date | |
---|---|
Author | |
Question | |
Answer |
Child Items
Rubric scores updated every 15m
Score | Type | Title |
---|---|---|
Related Items
Item Type | Relationship Type | Title |
---|---|---|
Catalog Details
Catalog Item ID | 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 Workflow State | Published / External |
Metadata Last Review Date | 2018-09-26 |
Metadata Review Frequency | 1 Year |
Metadata Next Review Date | 2019-09-26 |
Tags |
---|