Search Help Show/Hide Menu
Summary
Item Identification
Data Attributes
Catalog Details

Summary

Entity Information

Data Attribute / Type Description
BOTTOMFISHID
AUTONUMBER
TRIPNUM
TEXT
EFFORTDATE
DATE/TIME
PAGENUM
NUMBER
STATION
NUMBER
STATIONTYPE
TEXT
BEGINSEARCH
DATE/TIME
ENDSEARCH
DATE/TIME
BEGINTIME
DATE/TIME
BEGINDEPTH
NUMBER
BEGINLATDEG
NUMBER
BEGINLATMIN
NUMBER
BEGINLATN
TEXT
BEGINLONGDEG
NUMBER
BEGINLONGMIN
NUMBER
BEGINLONGW
TEXT
ENDTIME
DATE/TIME
ENDDEPTH
NUMBER
ENDLATDEG
NUMBER
ENDLATMIN
NUMBER
ENDLONGDEG
NUMBER
ENDLONGMIN
NUMBER
ENDLONGW
TEXT
BEAUFORT
TEXT
PROTSPEC
YES/NO

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: tblsubfrmBottomfishEffortLog
Short Name: Bottomfish Effort Log Subform
Status: In Work

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
67
BOTTOMFISHID AUTONUMBER
67
Primary Key TRIPNUM TEXT
67
Primary Key EFFORTDATE DATE/TIME
67
Primary Key PAGENUM NUMBER
67
Primary Key STATION NUMBER
67
STATIONTYPE TEXT
67
BEGINSEARCH DATE/TIME
67
ENDSEARCH DATE/TIME
67
BEGINTIME DATE/TIME
67
BEGINDEPTH NUMBER
67
BEGINLATDEG NUMBER
67
BEGINLATMIN NUMBER
67
BEGINLATN TEXT
67
BEGINLONGDEG NUMBER
67
BEGINLONGMIN NUMBER
67
BEGINLONGW TEXT
67
ENDTIME DATE/TIME
67
ENDDEPTH NUMBER
67
ENDLATDEG NUMBER
67
ENDLATMIN NUMBER
67
ENDLONGDEG NUMBER
67
ENDLONGMIN NUMBER
67
ENDLONGW TEXT
67
BEAUFORT TEXT
67
PROTSPEC YES/NO

Attribute Details

BOTTOMFISHID

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

TRIPNUM

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

EFFORTDATE

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

PAGENUM

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

STATION

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

STATIONTYPE

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

BEGINSEARCH

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

ENDSEARCH

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

BEGINTIME

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

BEGINDEPTH

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

BEGINLATDEG

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

BEGINLATMIN

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

BEGINLATN

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

BEGINLONGDEG

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

BEGINLONGMIN

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

BEGINLONGW

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

ENDTIME

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

ENDDEPTH

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

ENDLATDEG

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

ENDLATMIN

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

ENDLONGDEG

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

ENDLONGMIN

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

ENDLONGW

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

BEAUFORT

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

PROTSPEC

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

Catalog Details

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