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

Summary

Abstract

Fishing time lost contains the number of hours and reasons for lost fishing time during a trip.

Description

Fishing time lost contains the number of hours and reasons for lost fishing time during a trip.

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
TRIP_SEQ
NUMBER
Sequence generated unique identifier of a trip
TIME_LOST_CODE
VARCHAR2
Reason code for lost fishing time.
HOURS
NUMBER
Number of hours lost rounded to the nearest hour.

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

Please contact the owner organization (AFSC) for inquiries on this record.

Item Identification

Title: Table: FISHING_TIME_LOST
Short Name: FISHING_TIME_LOST
Status: Completed
Abstract:

Fishing time lost contains the number of hours and reasons for lost fishing time during a trip.

Notes:

Loaded by batch 2204, 03-28-2008 14:09

Entity Information

Entity Type: Data Table
Active Version?: Yes
Schema Name: TURNBULLD
Description:

Fishing time lost contains the number of hours and reasons for lost fishing time during a trip.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key TRIP_SEQ NUMBER Sequence generated unique identifier of a trip
100
Primary Key TIME_LOST_CODE VARCHAR2 Reason code for lost fishing time.
100
HOURS NUMBER Number of hours lost rounded to the nearest hour.

Attribute Details

TRIP_SEQ

CC ID: 29545
Seq. Order: 1
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: Yes
Precision: 9
Scale: 0
Status: Active
Description:

Sequence generated unique identifier of a trip

General Data Type: NUMBER
Foreign Key Relations:

TURNBULLD.FMA_TRIP

TIME_LOST_CODE

CC ID: 29544
Seq. Order: 2
Data Storage Type: VARCHAR2
Max Length: 10
Required: Yes
Primary Key: Yes
Status: Active
Description:

Reason code for lost fishing time.

General Data Type: VARCHAR2
Foreign Key Relations:

TURNBULLD.LOV_TIME_LOST_REASON

HOURS

CC ID: 29543
Seq. Order: 3
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 3
Scale: 0
Status: Active
Description:

Number of hours lost rounded to the nearest hour.

General Data Type: NUMBER

Catalog Details

Catalog Item ID: 7506
GUID: gov.noaa.nmfs.inport:7506
Metadata Record Created By: Doug Turnbull
Metadata Record Created: 2008-03-28 14:09+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2016-05-04
Owner Org: AFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2016-05-04
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2017-05-04