Table: FISHING_TIME_LOST
Entity (ENT) | Alaska Fisheries Science Center (AFSC)GUID: gov.noaa.nmfs.inport:7506 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
Fishing time lost contains the number of hours and reasons for lost fishing time during a trip.
DescriptionFishing 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
|
|
Name | Type | Description |
|---|---|---|---|---|
|
100
|
|
TRIP_SEQ | NUMBER | Sequence generated unique identifier of a trip |
|
100
|
|
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
| 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
| 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
| 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 |