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: tblBottomfishGearCatchLog

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

Summary

Entity Information

Data Attribute / Type Description
TRIPNUM
TEXT
BEGINDATE
DATE/TIME
STATION
NUMBER
PAGENUM
NUMBER
OBSERVERNUM
TEXT
BEGINSEARCH
DATE/TIME
ENDSEARCH
DATE/TIME
STATIONTYPE
TEXT
ENDDATE
DATE/TIME
BEAUFORT
TEXT
PROTSPEC
YES/NO
TARGETSPECIES
TEXT
NUMLINES
NUMBER
LINEMATERIAL
TEXT
LINETEST
NUMBER
LEADERMATERIAL
TEXT
LEADERTEST
NUMBER
HOOKSMAX
NUMBER
HOOKSMIN
NUMBER
HOOKTYPE
TEXT
SIZE
TEXT
WEIGHTSIZE
NUMBER
BAITTYPE
TEXT
CHUMTYPE
TEXT
SHARKLINE
YES/NO
BEGINTIME
DATE/TIME
ENDTIME
DATE/TIME
BEGINDEPTH
NUMBER
ENDDEPTH
NUMBER
BEGINLATDEG
NUMBER
BEGINLATMIN
NUMBER
BEGINLATN
TEXT
ENDLATDEG
NUMBER
ENDLATMIN
NUMBER
ENDLATN
TEXT
BEGINLONGDEG
NUMBER
BEGINLONGMIN
NUMBER
BEGINLONGW
TEXT
ENDLONGDEG
NUMBER
ENDLONGMIN
NUMBER
ENDLONGW
TEXT
COMMENTS
MEMO
LOGBOOKPAGENUM
TEXT
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: tblBottomfishGearCatchLog
Short Name: Bottomfish Gear Catch Log
Status: In Work

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
67
 Primary Key TRIPNUM TEXT
67
 Primary Key BEGINDATE DATE/TIME
67
 Primary Key STATION NUMBER
67
 Primary Key PAGENUM NUMBER
67
 OBSERVERNUM TEXT
67
 BEGINSEARCH DATE/TIME
67
 ENDSEARCH DATE/TIME
67
 STATIONTYPE TEXT
67
 ENDDATE DATE/TIME
67
 BEAUFORT TEXT
67
 PROTSPEC YES/NO
67
 TARGETSPECIES TEXT
67
 NUMLINES NUMBER
67
 LINEMATERIAL TEXT
67
 LINETEST NUMBER
67
 LEADERMATERIAL TEXT
67
 LEADERTEST NUMBER
67
 HOOKSMAX NUMBER
67
 HOOKSMIN NUMBER
67
 HOOKTYPE TEXT
67
 SIZE TEXT
67
 WEIGHTSIZE NUMBER
67
 BAITTYPE TEXT
67
 CHUMTYPE TEXT
67
 SHARKLINE YES/NO
67
 BEGINTIME DATE/TIME
67
 ENDTIME DATE/TIME
67
 BEGINDEPTH NUMBER
67
 ENDDEPTH NUMBER
67
 BEGINLATDEG NUMBER
67
 BEGINLATMIN NUMBER
67
 BEGINLATN TEXT
67
 ENDLATDEG NUMBER
67
 ENDLATMIN NUMBER
67
 ENDLATN TEXT
67
 BEGINLONGDEG NUMBER
67
 BEGINLONGMIN NUMBER
67
 BEGINLONGW TEXT
67
 ENDLONGDEG NUMBER
67
 ENDLONGMIN NUMBER
67
 ENDLONGW TEXT
67
 COMMENTS MEMO
67
 LOGBOOKPAGENUM TEXT
67
 BFID AUTONUMBER

Attribute Details

TRIPNUM

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

BEGINDATE

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

STATION

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

PAGENUM

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

OBSERVERNUM

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

BEGINSEARCH

CC ID: 179159
Seq. Order: 6
Data Storage Type: DATE/TIME
Max Length: 8
Required: No
Primary Key: No
Status: Active

ENDSEARCH

CC ID: 179160
Seq. Order: 7
Data Storage Type: DATE/TIME
Max Length: 8
Required: No
Primary Key: No
Status: Active

STATIONTYPE

CC ID: 179161
Seq. Order: 8
Data Storage Type: TEXT
Max Length: 1
Required: No
Primary Key: No
Status: Active

ENDDATE

CC ID: 179162
Seq. Order: 9
Data Storage Type: DATE/TIME
Max Length: 8
Required: No
Primary Key: No
Status: Active

BEAUFORT

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

PROTSPEC

CC ID: 179164
Seq. Order: 11
Data Storage Type: YES/NO
Max Length: 1
Required: No
Primary Key: No
Status: Active

TARGETSPECIES

CC ID: 179165
Seq. Order: 12
Data Storage Type: TEXT
Max Length: 3
Required: No
Primary Key: No
Status: Active

NUMLINES

CC ID: 179166
Seq. Order: 13
Data Storage Type: NUMBER
Max Length: 2
Required: No
Primary Key: No
Status: Active

LINEMATERIAL

CC ID: 179167
Seq. Order: 14
Data Storage Type: TEXT
Max Length: 1
Required: No
Primary Key: No
Status: Active

LINETEST

CC ID: 179168
Seq. Order: 15
Data Storage Type: NUMBER
Max Length: 2
Required: No
Primary Key: No
Status: Active

LEADERMATERIAL

CC ID: 179169
Seq. Order: 16
Data Storage Type: TEXT
Max Length: 1
Required: No
Primary Key: No
Status: Active

LEADERTEST

CC ID: 179170
Seq. Order: 17
Data Storage Type: NUMBER
Max Length: 2
Required: No
Primary Key: No
Status: Active

HOOKSMAX

CC ID: 179171
Seq. Order: 18
Data Storage Type: NUMBER
Max Length: 2
Required: No
Primary Key: No
Status: Active

HOOKSMIN

CC ID: 179172
Seq. Order: 19
Data Storage Type: NUMBER
Max Length: 2
Required: No
Primary Key: No
Status: Active

HOOKTYPE

CC ID: 179173
Seq. Order: 20
Data Storage Type: TEXT
Max Length: 1
Required: No
Primary Key: No
Status: Active

SIZE

CC ID: 179174
Seq. Order: 21
Data Storage Type: TEXT
Max Length: 2
Required: No
Primary Key: No
Status: Active

WEIGHTSIZE

CC ID: 179175
Seq. Order: 22
Data Storage Type: NUMBER
Max Length: 2
Required: No
Primary Key: No
Status: Active

BAITTYPE

CC ID: 179176
Seq. Order: 23
Data Storage Type: TEXT
Max Length: 1
Required: No
Primary Key: No
Status: Active

CHUMTYPE

CC ID: 179177
Seq. Order: 24
Data Storage Type: TEXT
Max Length: 1
Required: No
Primary Key: No
Status: Active

SHARKLINE

CC ID: 179178
Seq. Order: 25
Data Storage Type: YES/NO
Max Length: 1
Required: No
Primary Key: No
Status: Active

BEGINTIME

CC ID: 179179
Seq. Order: 26
Data Storage Type: DATE/TIME
Max Length: 8
Required: No
Primary Key: No
Status: Active

ENDTIME

CC ID: 179180
Seq. Order: 27
Data Storage Type: DATE/TIME
Max Length: 8
Required: No
Primary Key: No
Status: Active

BEGINDEPTH

CC ID: 179181
Seq. Order: 28
Data Storage Type: NUMBER
Max Length: 4
Required: No
Primary Key: No
Status: Active

ENDDEPTH

CC ID: 179182
Seq. Order: 29
Data Storage Type: NUMBER
Max Length: 4
Required: No
Primary Key: No
Status: Active

BEGINLATDEG

CC ID: 179183
Seq. Order: 30
Data Storage Type: NUMBER
Max Length: 2
Required: No
Primary Key: No
Status: Active

BEGINLATMIN

CC ID: 179184
Seq. Order: 31
Data Storage Type: NUMBER
Max Length: 4
Required: No
Primary Key: No
Status: Active

BEGINLATN

CC ID: 179185
Seq. Order: 32
Data Storage Type: TEXT
Max Length: 1
Required: No
Primary Key: No
Status: Active

ENDLATDEG

CC ID: 179186
Seq. Order: 33
Data Storage Type: NUMBER
Max Length: 2
Required: No
Primary Key: No
Status: Active

ENDLATMIN

CC ID: 179187
Seq. Order: 34
Data Storage Type: NUMBER
Max Length: 4
Required: No
Primary Key: No
Status: Active

ENDLATN

CC ID: 179188
Seq. Order: 35
Data Storage Type: TEXT
Max Length: 1
Required: No
Primary Key: No
Status: Active

BEGINLONGDEG

CC ID: 179189
Seq. Order: 36
Data Storage Type: NUMBER
Max Length: 2
Required: No
Primary Key: No
Status: Active

BEGINLONGMIN

CC ID: 179190
Seq. Order: 37
Data Storage Type: NUMBER
Max Length: 4
Required: No
Primary Key: No
Status: Active

BEGINLONGW

CC ID: 179191
Seq. Order: 38
Data Storage Type: TEXT
Max Length: 1
Required: No
Primary Key: No
Status: Active

ENDLONGDEG

CC ID: 179192
Seq. Order: 39
Data Storage Type: NUMBER
Max Length: 2
Required: No
Primary Key: No
Status: Active

ENDLONGMIN

CC ID: 179193
Seq. Order: 40
Data Storage Type: NUMBER
Max Length: 4
Required: No
Primary Key: No
Status: Active

ENDLONGW

CC ID: 179194
Seq. Order: 41
Data Storage Type: TEXT
Max Length: 1
Required: No
Primary Key: No
Status: Active

COMMENTS

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

LOGBOOKPAGENUM

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

BFID

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

Catalog Details

Catalog Item ID: 21928
GUID: gov.noaa.nmfs.inport:21928
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