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

Entity (ENT)  |  Pacific Islands Regional Office (PIRO)
GUID: gov.noaa.nmfs.inport:21936  |  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
PAGENUM
NUMBER
OBSERVERNUM
TEXT
RANK
TEXT
BEGINTIME
DATE/TIME
ENDTIME
DATE/TIME
ENDDATE
DATE/TIME
LATDEG
NUMBER
LATMIN
NUMBER
LATN
TEXT
LONGDEG
NUMBER
LONGMIN
NUMBER
LONGW
TEXT
VESSELACTIVITY
TEXT
DETERRENTS
TEXT
GEARENCOUNTER
TEXT
DISTANCEVESSEL
NUMBER
DISTANCEGEAR
NUMBER
SPECIESNAME1
TEXT
SPECIESCODE1
TEXT
BESTESTIMATE1
NUMBER
HIGH1
NUMBER
LOW1
NUMBER
INJURED1
NUMBER
DIED1
NUMBER
CARCASS1
NUMBER
TAGS1
YES/NO
PHOTOS1
YES/NO
SPECIMEN1
YES/NO
SKETCHES1
YES/NO
IDENTCHARACTERISTICS1
MEMO
NARRATIVE1
MEMO
SPECIESNAME2
TEXT
SPECIESCODE2
TEXT
BESTESTIMATE2
TEXT
HIGH2
TEXT
LOW2
TEXT
INJURED2
TEXT
DIED2
TEXT
CARCASS2
TEXT
TAGS2
YES/NO
PHOTOS2
YES/NO
SPECIMENS2
YES/NO
SKETCHES2
YES/NO
IDENTCHARACTERISTICS2
MEMO
NARRATIVE2
MEMO
SPECIESNAME3
TEXT
SPECIESCODE3
TEXT
BESTESTIMATE3
NUMBER
HIGH3
NUMBER
LOW3
NUMBER
INJURED3
NUMBER
DIED3
NUMBER
CARCASS3
NUMBER
TAGS3
YES/NO
PHOTOS3
YES/NO
SPECIMENS3
YES/NO
SKETCHES3
YES/NO
IDENTCHARACTERISTICS3
MEMO
NARRATIVE3
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: tblProtSpecLog
Short Name: Protected Species Log
Status: In Work

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
67
 Primary Key TRIPNUM TEXT
67
 BEGINDATE DATE/TIME
67
 Primary Key PAGENUM NUMBER
67
 OBSERVERNUM TEXT
67
 RANK TEXT
67
 BEGINTIME DATE/TIME
67
 ENDTIME DATE/TIME
67
 ENDDATE DATE/TIME
67
 LATDEG NUMBER
67
 LATMIN NUMBER
67
 LATN TEXT
67
 LONGDEG NUMBER
67
 LONGMIN NUMBER
67
 LONGW TEXT
67
 VESSELACTIVITY TEXT
67
 DETERRENTS TEXT
67
 GEARENCOUNTER TEXT
67
 DISTANCEVESSEL NUMBER
67
 DISTANCEGEAR NUMBER
67
 SPECIESNAME1 TEXT
67
 SPECIESCODE1 TEXT
67
 BESTESTIMATE1 NUMBER
67
 HIGH1 NUMBER
67
 LOW1 NUMBER
67
 INJURED1 NUMBER
67
 DIED1 NUMBER
67
 CARCASS1 NUMBER
67
 TAGS1 YES/NO
67
 PHOTOS1 YES/NO
67
 SPECIMEN1 YES/NO
67
 SKETCHES1 YES/NO
67
 IDENTCHARACTERISTICS1 MEMO
67
 NARRATIVE1 MEMO
67
 SPECIESNAME2 TEXT
67
 SPECIESCODE2 TEXT
67
 BESTESTIMATE2 TEXT
67
 HIGH2 TEXT
67
 LOW2 TEXT
67
 INJURED2 TEXT
67
 DIED2 TEXT
67
 CARCASS2 TEXT
67
 TAGS2 YES/NO
67
 PHOTOS2 YES/NO
67
 SPECIMENS2 YES/NO
67
 SKETCHES2 YES/NO
67
 IDENTCHARACTERISTICS2 MEMO
67
 NARRATIVE2 MEMO
67
 SPECIESNAME3 TEXT
67
 SPECIESCODE3 TEXT
67
 BESTESTIMATE3 NUMBER
67
 HIGH3 NUMBER
67
 LOW3 NUMBER
67
 INJURED3 NUMBER
67
 DIED3 NUMBER
67
 CARCASS3 NUMBER
67
 TAGS3 YES/NO
67
 PHOTOS3 YES/NO
67
 SPECIMENS3 YES/NO
67
 SKETCHES3 YES/NO
67
 IDENTCHARACTERISTICS3 MEMO
67
 NARRATIVE3 MEMO

Attribute Details

TRIPNUM

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

BEGINDATE

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

PAGENUM

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

OBSERVERNUM

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

RANK

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

BEGINTIME

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

ENDTIME

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

ENDDATE

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

LATDEG

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

LATMIN

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

LATN

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

LONGDEG

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

LONGMIN

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

LONGW

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

VESSELACTIVITY

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

DETERRENTS

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

GEARENCOUNTER

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

DISTANCEVESSEL

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

DISTANCEGEAR

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

SPECIESNAME1

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

SPECIESCODE1

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

BESTESTIMATE1

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

HIGH1

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

LOW1

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

INJURED1

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

DIED1

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

CARCASS1

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

TAGS1

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

PHOTOS1

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

SPECIMEN1

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

SKETCHES1

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

IDENTCHARACTERISTICS1

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

NARRATIVE1

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

SPECIESNAME2

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

SPECIESCODE2

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

BESTESTIMATE2

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

HIGH2

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

LOW2

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

INJURED2

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

DIED2

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

CARCASS2

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

TAGS2

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

PHOTOS2

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

SPECIMENS2

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

SKETCHES2

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

IDENTCHARACTERISTICS2

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

NARRATIVE2

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

SPECIESNAME3

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

SPECIESCODE3

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

BESTESTIMATE3

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

HIGH3

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

LOW3

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

INJURED3

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

DIED3

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

CARCASS3

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

TAGS3

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

PHOTOS3

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

SPECIMENS3

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

SKETCHES3

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

IDENTCHARACTERISTICS3

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

NARRATIVE3

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

Catalog Details

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