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

Entity (ENT)  |  Pacific Islands Regional Office (PIRO)
GUID: gov.noaa.nmfs.inport:21943  |  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
TROLLNUM
NUMBER
PAGENUM
NUMBER
OBSERVERNUM
TEXT
BEGINTIME
DATE/TIME
ENDDATE
DATE/TIME
PROTSPEC
YES/NO
BEAUFORT
TEXT
ENDTIME
DATE/TIME
BEGINLATDEG
NUMBER
BEGINLATMIN
NUMBER
BEGINLATN
TEXT
ENDLATDEG
NUMBER
ENDLATMIN
NUMBER
ENDLATN
TEXT
BEGINLONGDEG
NUMBER
BEGINLONGMIN
NUMBER
BEGINLONGW
TEXT
ENDLONGDEG
NUMBER
ENDLONGMIN
NUMBER
ENDLONGW
TEXT
NUMLINES
NUMBER
COMMENTS
MEMO
LOGBOOKPAGENUM
TEXT

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: tblTrollLog
Short Name: Troll 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 TROLLNUM NUMBER
67
 Primary Key PAGENUM NUMBER
67
 OBSERVERNUM TEXT
67
 BEGINTIME DATE/TIME
67
 ENDDATE DATE/TIME
67
 PROTSPEC YES/NO
67
 BEAUFORT TEXT
67
 ENDTIME DATE/TIME
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
 NUMLINES NUMBER
67
 COMMENTS MEMO
67
 LOGBOOKPAGENUM TEXT

Attribute Details

TRIPNUM

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

BEGINDATE

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

TROLLNUM

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

PAGENUM

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

OBSERVERNUM

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

BEGINTIME

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

ENDDATE

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

PROTSPEC

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

BEAUFORT

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

ENDTIME

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

BEGINLATDEG

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

BEGINLATMIN

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

BEGINLATN

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

ENDLATDEG

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

ENDLATMIN

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

ENDLATN

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

BEGINLONGDEG

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

BEGINLONGMIN

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

BEGINLONGW

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

ENDLONGDEG

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

ENDLONGMIN

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

ENDLONGW

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

NUMLINES

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

COMMENTS

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

LOGBOOKPAGENUM

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

Catalog Details

Catalog Item ID: 21943
GUID: gov.noaa.nmfs.inport:21943
Metadata Record Created By: Eric Forney
Metadata Record Created: 2014-07-14 20:16+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