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

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

Item Identification

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

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
67
 Primary Key INCIDENTID INT
67
 TRIPID INT
67
 LATITUDE VARCHAR
67
 LATITUDE2 VARCHAR
67
 LATITUDE3 CHAR
67
 LONGITUDE VARCHAR
67
 LONGITUDE2 VARCHAR
67
 LONGITUDE3 CHAR
67
 STARTDATE DATE
67
 STARTTIME TIME
67
 ENDDATE DATE
67
 ENDTIME TIME
67
 INCIDENTTYPEID INT
67
 INCIDENTDESCRIPTION VARCHAR
67
 FINALIZED CHAR
67
 REPORTSIGNEDON DATETIME
67
 REPORTSENTON DATETIME
67
 ELLASTUPDATEBY INT
67
 ELLASTUPDATE DATETIME
67
 LASTUPDATE DATETIME
67
 LASTUPDATEBY INT

Attribute Details

INCIDENTID

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

TRIPID

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

LATITUDE

CC ID: 178568
Seq. Order: 3
Data Storage Type: VARCHAR
Max Length: 5
Required: No
Primary Key: No
Status: Active

LATITUDE2

CC ID: 178569
Seq. Order: 4
Data Storage Type: VARCHAR
Max Length: 5
Required: No
Primary Key: No
Status: Active

LATITUDE3

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

LONGITUDE

CC ID: 178571
Seq. Order: 6
Data Storage Type: VARCHAR
Max Length: 5
Required: No
Primary Key: No
Status: Active

LONGITUDE2

CC ID: 178572
Seq. Order: 7
Data Storage Type: VARCHAR
Max Length: 5
Required: No
Primary Key: No
Status: Active

LONGITUDE3

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

STARTDATE

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

STARTTIME

CC ID: 178575
Seq. Order: 10
Data Storage Type: TIME
Max Length: 5
Required: No
Primary Key: No
Status: Active

ENDDATE

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

ENDTIME

CC ID: 178577
Seq. Order: 12
Data Storage Type: TIME
Max Length: 5
Required: No
Primary Key: No
Status: Active

INCIDENTTYPEID

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

INCIDENTDESCRIPTION

CC ID: 178579
Seq. Order: 14
Data Storage Type: VARCHAR
Max Length: -1
Required: No
Primary Key: No
Status: Active

FINALIZED

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

REPORTSIGNEDON

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

REPORTSENTON

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

ELLASTUPDATEBY

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

ELLASTUPDATE

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

LASTUPDATE

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

LASTUPDATEBY

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

Related Items

Item Type Relationship Type Title
Data Set (DS) Cross Reference Incident Report - Legacy
Data Set (DS) Cross Reference Injury & Safety Report - Legacy

Catalog Details

Catalog Item ID: 21859
GUID: gov.noaa.nmfs.inport:21859
Metadata Record Created By: Eric Forney
Metadata Record Created: 2014-07-11 17:14+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2016-03-30
Owner Org: PIRO
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2016-03-30
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2017-03-30