Search Help Show/Hide Menu
Metadata Rubric
50%
3 / 6
View Report
PIRO Metadata Library > Pacific Islands Regional Office Observer Progra... > Hawaii Bottomfish Observer Program > Bottomfish Observer Database - Legacy >

Table: tblBottomfishEffortLog

Entity (ENT)  |  Pacific Islands Regional Office (PIRO)
GUID: gov.noaa.nmfs.inport:21927  |  Updated: August 9, 2022  |  Published / External 
Summary
Item Identification
Data Attributes
Catalog Details

Summary

Entity Information

Data Attribute / Type Description
TRIPNUM
TEXT
EFFORTDATE
DATE/TIME
PAGENUM
NUMBER
OBSERVERNUM
TEXT
LOGBOOKPAGENUM
TEXT
COMMENTS
MEMO
BFID
AUTONUMBER

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

Please contact the owner organization (PIRO) for inquiries on this record.

Item Identification

Title: Table: tblBottomfishEffortLog
Short Name: Bottomfish Effort Log
Status: In Work

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
67
 Primary Key TRIPNUM TEXT
67
 Primary Key EFFORTDATE DATE/TIME
67
 Primary Key PAGENUM NUMBER
67
 OBSERVERNUM TEXT
67
 LOGBOOKPAGENUM TEXT
67
 COMMENTS MEMO
67
 BFID AUTONUMBER

Attribute Details

TRIPNUM

CC ID: 179147
Seq. Order: 1
Data Storage Type: TEXT
Max Length: 6
Required: Yes
Primary Key: Yes
Status: Active

EFFORTDATE

CC ID: 179148
Seq. Order: 2
Data Storage Type: DATE/TIME
Max Length: 8
Required: Yes
Primary Key: Yes
Status: Active

PAGENUM

CC ID: 179149
Seq. Order: 3
Data Storage Type: NUMBER
Max Length: 4
Required: Yes
Primary Key: Yes
Status: Active

OBSERVERNUM

CC ID: 179150
Seq. Order: 4
Data Storage Type: TEXT
Max Length: 4
Required: No
Primary Key: No
Status: Active

LOGBOOKPAGENUM

CC ID: 179151
Seq. Order: 5
Data Storage Type: TEXT
Max Length: 10
Required: No
Primary Key: No
Status: Active

COMMENTS

CC ID: 179152
Seq. Order: 6
Data Storage Type: MEMO
Max Length: 63999
Required: No
Primary Key: No
Status: Active

BFID

CC ID: 179153
Seq. Order: 7
Data Storage Type: AUTONUMBER
Max Length: 4
Required: No
Primary Key: No
Status: Active

Catalog Details

Catalog Item ID: 21927
GUID: gov.noaa.nmfs.inport:21927
Metadata Record Created By: Eric Forney
Metadata Record Created: 2014-07-14 19:53+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2015-12-03
Owner Org: PIRO
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2015-12-03
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2016-12-03