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

Entity (ENT)  |  Pacific Islands Regional Office (PIRO)
GUID: gov.noaa.nmfs.inport:21936  |  Updated: August 9, 2022  |  Published / External 

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