Slide Menu
Search Help Show/Hide Menu

Item Identification

Title: Table: tblInjurySafetysubform
Short Name: Injury & Safety Subform
Status: In Work

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
67
INJURYSAFETYSUBFORMID AUTONUMBER
67
INCIDENTTYPE TEXT
67
TYPEOFINCIDENT TEXT
67
NARRATIVE MEMO
67
TRIPNUMBER TEXT
67
LATITUDEDEGREES NUMBER
67
LATITUDEMINUTES NUMBER
67
LATITUDENS TEXT
67
LONGITUDEDEGREES NUMBER
67
LONGITUDEMINUTES NUMBER
67
LONGITUDEEW TEXT
67
INCIDENTDATE DATE/TIME
67
INCIDENTTIME DATE/TIME

Attribute Details

INJURYSAFETYSUBFORMID

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

INCIDENTTYPE

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

TYPEOFINCIDENT

CC ID: 179127
Seq. Order: 3
Data Storage Type: TEXT
Max Length: 30
Required: No
Primary Key: No
Status: Active

NARRATIVE

CC ID: 179128
Seq. Order: 4
Data Storage Type: MEMO
Max Length: 63999
Required: No
Primary Key: No
Status: Active

TRIPNUMBER

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

LATITUDEDEGREES

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

LATITUDEMINUTES

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

LATITUDENS

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

LONGITUDEDEGREES

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

LONGITUDEMINUTES

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

LONGITUDEEW

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

INCIDENTDATE

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

INCIDENTTIME

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

Catalog Details

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