CRF_SAMPLE_20190321
Pacific Islands Fisheries Science Center
Entity
(ENT)
| ID: 56039
| Published / External
Created: 2019-04-12
|
Last Modified: 2022-08-09
Data Set (DS) | ID: 20969
ID: 56039
Entity (ENT)
* Discovery• First Pass
» Metadata Rubric
Item Identification
* » Title | CRF_SAMPLE_20190321 |
---|---|
Short Name | CRF_SAMPLE_20190321 |
* Status | On Going |
Creation Date | |
Revision Date | |
• Publication Date | |
* » Abstract |
. |
* Purpose | |
Notes | |
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? | |
Alias | |
Schema Name | |
» Description |
. |
Change Summary |
Data Attributes
Attribute Summary
Score | Req'd? | PKey? | » Name | Data Storage Type | Description |
---|---|---|---|---|---|
100 | Yes | Yes | BFISH | VARCHAR2 | Id for survey Mission: BFISH_Year_Season (e.g. BFISH_2017_F). |
100 | No | No | SAMPLE_ID | VARCHAR2 | Concatinated unique ID for collected sample: Year("000"), Month("00"), Day("00"), Sample_Start_time hour("00"), Sample_start_time minute("00"), Captain_CD. |
100 | No | No | SAMPLE_DATE | DATE | Local Date sample was collected. |
100 | No | No | VESSEL | VARCHAR2 | Name of vessel from which sample was collected. |
100 | No | No | CAPTAIN | VARCHAR2 | Name of captain commanding the vessel from which the sample was collected. |
100 | No | No | CAPTAIN_CD | VARCHAR2 | 4 letter code for captain's name. |
100 | No | No | OBSERVER | VARCHAR2 | Name of observer on board the vessel from which the sample was collected. |
100 | No | No | TARGET_GRID_ID | VARCHAR2 | Id for primary sampling unit that was targeted for sampling. |
100 | No | No | PSU | VARCHAR2 | Id for primary sampling unit in which the sample was collected. |
100 | No | No | SAMPLE_MEAN_DEPTH_M | NUMBER | Mean depth of all drifts within sample. Units for values are meters. |
100 | No | No | WIND_SPEED_KT | NUMBER | Average wind speed while sample was being collected. Units for values are knots. Measures are reported with a precision of 3. |
100 | No | No | WAVE_HEIGHT_FT | NUMBER | Average wave height while sample was being collected. Units for values are feet. Measures are reported with a precision of 3. |
100 | No | No | CURRENT_CD | VARCHAR2 | Was the current good for catching fish. |
100 | No | No | SAMPLE_START_TIME | VARCHAR2 | Local time sampling began (i.e. start time of first drift). |
100 | No | No | SAMPLE_END_TIME | VARCHAR2 | Local time sampling concluded (i.e. end time of last drift). |
100 | No | No | SAMPLE_NOTES | VARCHAR2 | Any notes regarding the sample. |
100 | No | No | ENTERED_BY | VARCHAR2 | Name of data entry technician. |
100 | Yes | Yes | SEQUENCE_NR | VARCHAR2 | Consecutive number added to each record. Starts with 00000001 for each BFISH (Survey Mission) |
100 | No | No | CREATE_DTM | DATE | Date and time this record was added to the database (populated by trigger; field added in August 2019. |
100 | No | No | CREATED_BY | VARCHAR2 | Application Express or Oracle username of the person creating this record (populated by trigger); field added in August 2019. |
100 | No | No | LAST_MOD_DTM | DATE | Date and time this record was last modified (populated by trigger); field added in August 2019. |
100 | No | No | LAST_MOD_BY | VARCHAR2 | Application Express or Oracle username of the person who last modified this record (populated by trigger); field added in August 2019. |
Attribute Details
Attribute Name | BFISH |
---|---|
Seq. Order | 1 |
Data Storage Type | VARCHAR2 |
Max Length | 12 |
Min Length | |
Required | Yes |
Primary Key | Yes |
Precision | |
Scale | |
Status | Active |
Description |
Id for survey Mission: BFISH_Year_Season (e.g. BFISH_2017_F). |
General Data Type | CHARACTER |
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 | SAMPLE_ID |
---|---|
Seq. Order | 2 |
Data Storage Type | VARCHAR2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Concatinated unique ID for collected sample: Year("000"), Month("00"), Day("00"), Sample_Start_time hour("00"), Sample_start_time minute("00"), Captain_CD. |
General Data Type | CHARACTER |
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 | SAMPLE_DATE |
---|---|
Seq. Order | 3 |
Data Storage Type | DATE |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Local Date sample was collected. |
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 | VESSEL |
---|---|
Seq. Order | 4 |
Data Storage Type | VARCHAR2 |
Max Length | 25 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Name of vessel from which sample was collected. |
General Data Type | CHARACTER |
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 | CAPTAIN |
---|---|
Seq. Order | 5 |
Data Storage Type | VARCHAR2 |
Max Length | 25 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Name of captain commanding the vessel from which the sample was collected. |
General Data Type | CHARACTER |
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 | CAPTAIN_CD |
---|---|
Seq. Order | 6 |
Data Storage Type | VARCHAR2 |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
4 letter code for captain's name. |
General Data Type | CHARACTER |
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 | OBSERVER |
---|---|
Seq. Order | 7 |
Data Storage Type | VARCHAR2 |
Max Length | 25 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Name of observer on board the vessel from which the sample was collected. |
General Data Type | CHARACTER |
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 | TARGET_GRID_ID |
---|---|
Seq. Order | 8 |
Data Storage Type | VARCHAR2 |
Max Length | 5 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Id for primary sampling unit that was targeted for sampling. |
General Data Type | CHARACTER |
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 | PSU |
---|---|
Seq. Order | 9 |
Data Storage Type | VARCHAR2 |
Max Length | 5 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Id for primary sampling unit in which the sample was collected. |
General Data Type | CHARACTER |
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 | SAMPLE_MEAN_DEPTH_M |
---|---|
Seq. Order | 10 |
Data Storage Type | NUMBER |
Max Length | 3 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Mean depth of all drifts within sample. Units for values are meters. |
General Data Type | NUMBER |
Unit of Measure | meters |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | WIND_SPEED_KT |
---|---|
Seq. Order | 11 |
Data Storage Type | NUMBER |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | 1 |
Status | Active |
Description |
Average wind speed while sample was being collected. Units for values are knots. Measures are reported with a precision of 3. |
General Data Type | NUMBER |
Unit of Measure | knots |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | WAVE_HEIGHT_FT |
---|---|
Seq. Order | 12 |
Data Storage Type | NUMBER |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | 1 |
Status | Active |
Description |
Average wave height while sample was being collected. Units for values are feet. Measures are reported with a precision of 3. |
General Data Type | NUMBER |
Unit of Measure | feet |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | CURRENT_CD |
---|---|
Seq. Order | 13 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Was the current good for catching fish. |
General Data Type | CHARACTER |
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 | SAMPLE_START_TIME |
---|---|
Seq. Order | 14 |
Data Storage Type | VARCHAR2 |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Local time sampling began (i.e. start time of first drift). |
General Data Type | CHARACTER |
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 | SAMPLE_END_TIME |
---|---|
Seq. Order | 15 |
Data Storage Type | VARCHAR2 |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Local time sampling concluded (i.e. end time of last drift). |
General Data Type | CHARACTER |
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 | SAMPLE_NOTES |
---|---|
Seq. Order | 16 |
Data Storage Type | VARCHAR2 |
Max Length | 500 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Any notes regarding the sample. |
General Data Type | CHARACTER |
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 | ENTERED_BY |
---|---|
Seq. Order | 17 |
Data Storage Type | VARCHAR2 |
Max Length | 20 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Name of data entry technician. |
General Data Type | CHARACTER |
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 | SEQUENCE_NR |
---|---|
Seq. Order | 18 |
Data Storage Type | VARCHAR2 |
Max Length | 8 |
Min Length | 8 |
Required | Yes |
Primary Key | Yes |
Precision | |
Scale | |
Status | Active |
Description |
Consecutive number added to each record. Starts with 00000001 for each BFISH (Survey Mission) |
General Data Type | CHARACTER |
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 | CREATE_DTM |
---|---|
Seq. Order | 19 |
Data Storage Type | DATE |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Date and time this record was added to the database (populated by trigger; field added in August 2019. |
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 | CREATED_BY |
---|---|
Seq. Order | 20 |
Data Storage Type | VARCHAR2 |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Application Express or Oracle username of the person creating this record (populated by trigger); field added in August 2019. |
General Data Type | CHARACTER |
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_MOD_DTM |
---|---|
Seq. Order | 21 |
Data Storage Type | DATE |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Date and time this record was last modified (populated by trigger); field added in August 2019. |
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 | LAST_MOD_BY |
---|---|
Seq. Order | 22 |
Data Storage Type | VARCHAR2 |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Application Express or Oracle username of the person who last modified this record (populated by trigger); field added in August 2019. |
General Data Type | CHARACTER |
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 | 56039 |
---|---|
Metadata Record Created By | Brent M Miyamoto |
Metadata Record Created | 2019-04-12 22:22+0000 |
Metadata Record Last Modified By | SysAdmin InPortAdmin |
» Metadata Record Last Modified | 2022-08-09 17:11+0000 |
Metadata Record Published | 2019-08-21 |
Owner Org | PIFSC |
Metadata Publication Status | Published Externally |
Do Not Publish? | N |
Metadata Workflow State | Published / External |
Metadata Last Review Date | 2019-08-21 |
Metadata Review Frequency | 1 Year |
Metadata Next Review Date | 2020-08-21 |
Tags |
---|