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

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

Summary

Entity Information

Data Attribute / Type Description
TROLLID
AUTONUMBER
TRIPNUM
TEXT
BEGINDATE
DATE/TIME
TROLLNUM
NUMBER
PAGENUM
NUMBER
LINENUM
NUMBER
SPECIESNAME
TEXT
SPECIESCODE
TEXT
FORKLENGTH
NUMBER
DISPOSITION
TEXT
DAMAGE
TEXT
TAGS
YES/NO
PHOTOS
YES/NO
SPECIMENS
YES/NO
SKETCHES
YES/NO
NOTES
MEMO

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: tblsubfrmTrollLog
Short Name: Troll Log Subform
Status: In Work

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
67
 TROLLID AUTONUMBER
67
 Primary Key TRIPNUM TEXT
67
 Primary Key BEGINDATE DATE/TIME
67
 Primary Key TROLLNUM NUMBER
67
 Primary Key PAGENUM NUMBER
67
 Primary Key LINENUM NUMBER
67
 SPECIESNAME TEXT
67
 SPECIESCODE TEXT
67
 FORKLENGTH NUMBER
67
 DISPOSITION TEXT
67
 DAMAGE TEXT
67
 TAGS YES/NO
67
 PHOTOS YES/NO
67
 SPECIMENS YES/NO
67
 SKETCHES YES/NO
67
 NOTES MEMO

Attribute Details

TROLLID

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

TRIPNUM

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

BEGINDATE

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

TROLLNUM

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

PAGENUM

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

LINENUM

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

SPECIESNAME

CC ID: 179445
Seq. Order: 7
Data Storage Type: TEXT
Max Length: 50
Required: No
Primary Key: No
Status: Active

SPECIESCODE

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

FORKLENGTH

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

DISPOSITION

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

DAMAGE

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

TAGS

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

PHOTOS

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

SPECIMENS

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

SKETCHES

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

NOTES

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

Catalog Details

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