Slide Menu
Search Help Show/Hide Menu

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