Slide Menu
Jump to Section...
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 

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