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... > Pacific Islands Region Observer Program System >

Table: Checklist

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

Item Identification

Title: Table: Checklist
Short Name: Checklist
Status: In Work

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
67
 Primary Key CHECKLISTID INT
67
 TRIPID INT
67
 FOBISSUEDYN CHAR
67
 FOBNUMBER INT
67
 INCIDENTYN CHAR
67
 PLACEMENTCHECKLISTYN CHAR
67
 PSINVOICEYN CHAR
67
 USFWSYN CHAR
67
 CITESYN CHAR
67
 DATAQCYN CHAR
67
 SPECIMENLOGYN CHAR
67
 BIOLOGICALYN CHAR
67
 DOCNOTEBOOKYN CHAR
67
 ECONOMICDATAYN CHAR
67
 TAGFORMSYN CHAR
67
 PHOTOLOGYN CHAR
67
 IMAGESDOWNLOADEDYN CHAR
67
 SPECIESVERIFIEDYN CHAR
67
 PHOTOSLABELEDYN CHAR
67
 PHOTOSDELETEDYN CHAR
67
 CAMERABAGNUM VARCHAR
67
 CAMERACONDITION CHAR
67
 CAMERACDNUM VARCHAR
67
 CAMERACONDITIONCOMMENTS VARCHAR
67
 CAMERACASECONDITION CHAR
67
 CAMERACASECONDITIONCOMMENTS VARCHAR
67
 GPSCONDITION CHAR
67
 GPSCDNUM VARCHAR
67
 GPSCONDITIONCOMMENTS VARCHAR
67
 SATELLITEPHONECONDITION CHAR
67
 SATELLITEPHONECDNUM VARCHAR
67
 SATELLITEPHONECONDITIONCOMMENTS VARCHAR
67
 PLBCONDITION CHAR
67
 PLBEXPDATE DATE
67
 EPIRBCONDITION CHAR
67
 EPIRBEXPDATE DATE
67
 LODSYN CHAR
67
 BLUEYN CHAR
67
 OPERATIONSYN CHAR
67
 REVIEWEDYN CHAR
67
 LODSVALIDATIONSYN CHAR
67
 DATAREADBACKYN CHAR
67
 DATAQCVERIFIEDYN CHAR
67
 GREENPENCILDISCUSSIONYN CHAR
67
 CURRENTFORMSYN CHAR
67
 BOOKSYN CHAR
67
 TRAININGEVALYN CHAR
67
 DAYSSPENTDEBRIEFING INT
67
 FOBRETURNEDYN CHAR
67
 FOBRETURNEDON DATETIME
67
 FOBRETURNEDTO INT
67
 EVALEMAILSENTYN CHAR
67
 FINALIZEDYN CHAR
67
 LASTUPDATE DATETIME
67
 LASTUPDATEBY INT

Attribute Details

CHECKLISTID

CC ID: 178501
Seq. Order: 1
Data Storage Type: INT
Max Length: 4
Required: Yes
Primary Key: Yes
Precision: 10
Status: Active

TRIPID

CC ID: 178502
Seq. Order: 2
Data Storage Type: INT
Max Length: 4
Required: No
Primary Key: No
Precision: 10
Status: Active

FOBISSUEDYN

CC ID: 178503
Seq. Order: 3
Data Storage Type: CHAR
Max Length: 1
Required: No
Primary Key: No
Status: Active

FOBNUMBER

CC ID: 178504
Seq. Order: 4
Data Storage Type: INT
Max Length: 4
Required: No
Primary Key: No
Precision: 10
Status: Active

INCIDENTYN

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

PLACEMENTCHECKLISTYN

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

PSINVOICEYN

CC ID: 178507
Seq. Order: 7
Data Storage Type: CHAR
Max Length: 1
Required: No
Primary Key: No
Status: Active

USFWSYN

CC ID: 178508
Seq. Order: 8
Data Storage Type: CHAR
Max Length: 1
Required: No
Primary Key: No
Status: Active

CITESYN

CC ID: 178509
Seq. Order: 9
Data Storage Type: CHAR
Max Length: 1
Required: No
Primary Key: No
Status: Active

DATAQCYN

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

SPECIMENLOGYN

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

BIOLOGICALYN

CC ID: 178512
Seq. Order: 12
Data Storage Type: CHAR
Max Length: 1
Required: No
Primary Key: No
Status: Active

DOCNOTEBOOKYN

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

ECONOMICDATAYN

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

TAGFORMSYN

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

PHOTOLOGYN

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

IMAGESDOWNLOADEDYN

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

SPECIESVERIFIEDYN

CC ID: 178518
Seq. Order: 18
Data Storage Type: CHAR
Max Length: 1
Required: No
Primary Key: No
Status: Active

PHOTOSLABELEDYN

CC ID: 178519
Seq. Order: 19
Data Storage Type: CHAR
Max Length: 1
Required: No
Primary Key: No
Status: Active

PHOTOSDELETEDYN

CC ID: 178520
Seq. Order: 20
Data Storage Type: CHAR
Max Length: 1
Required: No
Primary Key: No
Status: Active

CAMERABAGNUM

CC ID: 178521
Seq. Order: 21
Data Storage Type: VARCHAR
Max Length: 50
Required: No
Primary Key: No
Status: Active

CAMERACONDITION

CC ID: 178522
Seq. Order: 22
Data Storage Type: CHAR
Max Length: 1
Required: No
Primary Key: No
Status: Active

CAMERACDNUM

CC ID: 178523
Seq. Order: 23
Data Storage Type: VARCHAR
Max Length: 50
Required: No
Primary Key: No
Status: Active

CAMERACONDITIONCOMMENTS

CC ID: 178524
Seq. Order: 24
Data Storage Type: VARCHAR
Max Length: 500
Required: No
Primary Key: No
Status: Active

CAMERACASECONDITION

CC ID: 178525
Seq. Order: 25
Data Storage Type: CHAR
Max Length: 1
Required: No
Primary Key: No
Status: Active

CAMERACASECONDITIONCOMMENTS

CC ID: 178526
Seq. Order: 26
Data Storage Type: VARCHAR
Max Length: 500
Required: No
Primary Key: No
Status: Active

GPSCONDITION

CC ID: 178527
Seq. Order: 27
Data Storage Type: CHAR
Max Length: 1
Required: No
Primary Key: No
Status: Active

GPSCDNUM

CC ID: 178528
Seq. Order: 28
Data Storage Type: VARCHAR
Max Length: 50
Required: No
Primary Key: No
Status: Active

GPSCONDITIONCOMMENTS

CC ID: 178529
Seq. Order: 29
Data Storage Type: VARCHAR
Max Length: 500
Required: No
Primary Key: No
Status: Active

SATELLITEPHONECONDITION

CC ID: 178530
Seq. Order: 30
Data Storage Type: CHAR
Max Length: 1
Required: No
Primary Key: No
Status: Active

SATELLITEPHONECDNUM

CC ID: 178531
Seq. Order: 31
Data Storage Type: VARCHAR
Max Length: 50
Required: No
Primary Key: No
Status: Active

SATELLITEPHONECONDITIONCOMMENTS

CC ID: 178532
Seq. Order: 32
Data Storage Type: VARCHAR
Max Length: 500
Required: No
Primary Key: No
Status: Active

PLBCONDITION

CC ID: 178533
Seq. Order: 33
Data Storage Type: CHAR
Max Length: 1
Required: No
Primary Key: No
Status: Active

PLBEXPDATE

CC ID: 178534
Seq. Order: 34
Data Storage Type: DATE
Max Length: 3
Required: No
Primary Key: No
Status: Active

EPIRBCONDITION

CC ID: 178535
Seq. Order: 35
Data Storage Type: CHAR
Max Length: 1
Required: No
Primary Key: No
Status: Active

EPIRBEXPDATE

CC ID: 178536
Seq. Order: 36
Data Storage Type: DATE
Max Length: 3
Required: No
Primary Key: No
Status: Active

LODSYN

CC ID: 178537
Seq. Order: 37
Data Storage Type: CHAR
Max Length: 1
Required: No
Primary Key: No
Status: Active

BLUEYN

CC ID: 178538
Seq. Order: 38
Data Storage Type: CHAR
Max Length: 1
Required: No
Primary Key: No
Status: Active

OPERATIONSYN

CC ID: 178539
Seq. Order: 39
Data Storage Type: CHAR
Max Length: 1
Required: No
Primary Key: No
Status: Active

REVIEWEDYN

CC ID: 178540
Seq. Order: 40
Data Storage Type: CHAR
Max Length: 1
Required: No
Primary Key: No
Status: Active

LODSVALIDATIONSYN

CC ID: 178541
Seq. Order: 41
Data Storage Type: CHAR
Max Length: 1
Required: No
Primary Key: No
Status: Active

DATAREADBACKYN

CC ID: 178542
Seq. Order: 42
Data Storage Type: CHAR
Max Length: 1
Required: No
Primary Key: No
Status: Active

DATAQCVERIFIEDYN

CC ID: 178543
Seq. Order: 43
Data Storage Type: CHAR
Max Length: 1
Required: No
Primary Key: No
Status: Active

GREENPENCILDISCUSSIONYN

CC ID: 178544
Seq. Order: 44
Data Storage Type: CHAR
Max Length: 1
Required: No
Primary Key: No
Status: Active

CURRENTFORMSYN

CC ID: 178545
Seq. Order: 45
Data Storage Type: CHAR
Max Length: 1
Required: No
Primary Key: No
Status: Active

BOOKSYN

CC ID: 178546
Seq. Order: 46
Data Storage Type: CHAR
Max Length: 1
Required: No
Primary Key: No
Status: Active

TRAININGEVALYN

CC ID: 178547
Seq. Order: 47
Data Storage Type: CHAR
Max Length: 1
Required: No
Primary Key: No
Status: Active

DAYSSPENTDEBRIEFING

CC ID: 178548
Seq. Order: 48
Data Storage Type: INT
Max Length: 4
Required: No
Primary Key: No
Precision: 10
Status: Active

FOBRETURNEDYN

CC ID: 178549
Seq. Order: 49
Data Storage Type: CHAR
Max Length: 1
Required: No
Primary Key: No
Status: Active

FOBRETURNEDON

CC ID: 178550
Seq. Order: 50
Data Storage Type: DATETIME
Max Length: 8
Required: No
Primary Key: No
Status: Active

FOBRETURNEDTO

CC ID: 178551
Seq. Order: 51
Data Storage Type: INT
Max Length: 4
Required: No
Primary Key: No
Precision: 10
Status: Active

EVALEMAILSENTYN

CC ID: 178552
Seq. Order: 52
Data Storage Type: CHAR
Max Length: 1
Required: No
Primary Key: No
Status: Active

FINALIZEDYN

CC ID: 178553
Seq. Order: 53
Data Storage Type: CHAR
Max Length: 1
Required: No
Primary Key: No
Status: Active

LASTUPDATE

CC ID: 178554
Seq. Order: 54
Data Storage Type: DATETIME
Max Length: 8
Required: No
Primary Key: No
Status: Active

LASTUPDATEBY

CC ID: 178555
Seq. Order: 55
Data Storage Type: INT
Max Length: 4
Required: No
Primary Key: No
Precision: 10
Status: Active

Related Items

Item Type Relationship Type Title
Document (DOC) Cross Reference Debriefer Arrival Checklist

Catalog Details

Catalog Item ID: 21856
GUID: gov.noaa.nmfs.inport:21856
Metadata Record Created By: Eric Forney
Metadata Record Created: 2014-07-11 17:02+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