Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
SEFSC Metadata Library > Social Science Research Group Projects > Trip Cost Data > SSRG Socioeconomic Panel >

Table: FLS_TRIP_LOCATIONS

Entity (ENT)  |  Southeast Fisheries Science Center (SEFSC)
GUID: gov.noaa.nmfs.inport:6873  |  Updated: August 9, 2022  |  Published / External 
Summary
Item Identification
Physical Location
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

Identifies Trip Locations Per Trip

Description

Identifies Trip Locations Per Trip

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
LOCATION_TYPE
VARCHAR2 		Identifies trip locations (e.g. Departure, Landing, Sale, etc.)Validation:The domain LOCATION_TYPE ensures that only locations that have been previously defined in the system can be entered.
LOCATION_KEY
NUMBER 		If the row changed had location information, this key is provided to identify the appropriate location record within the logbook.
EVENT_DATE
DATE 		Date when the event defined by the location type (e.g., landing, departure, etc.) occurred.Validation:A valid date is ensured by the use of the DATE data type of the column. The column is optional and may be left empty.
LOGBOOK_KEY
NUMBER 		Foreign key to the FLS_TRIPS and other master tables.Validation:A foreign key enforces that trip information must have been entered into the FLS_TRIP table before location data can be added.
PORT_CODE_FIPS
VARCHAR2 		FIPS port code. Leading zeroes were added to make it compatible with thestandard FIPS place codes upon which it is based.Validation:The column is mandatary and cannot be left empty.
COUNTRY_CODE_FIPS
VARCHAR2 		Country where the dealership is located.Validation:The country code must be a valid FIPS country.The country code is mandatory and cannot be left empty.
COUNTY_CODE_NMFS
VARCHAR2 		The legacy pc field, state, is called state_code_nmfs in the FLS master tables.The official three digit NMFS county code. The code is left padded with zeroes.Validation:A foreign key to the table FLS_COUNTY_CODES_NMFS ensures that the codes entered are valid. The codes should be entered with leading zeroes.This column is mandatory and cannot be left empty.
STATE_CODE_NMFS
VARCHAR2 		State where the Area Fished Code is valid. The State Codes are assigned and maintained by the National Marine Fisheries Service.Validation:There is a foreign key relationship on this column with the table FLS_STATE_CODES_NMFS. This means that no rows can be added to this table if the state code is not found in the state code table. This ensures that no mysterious codes are added to the table.This column is also mandatory, which means that it cannot be left empty.
UNLOAD_DATE
DATE 		Date when the vessel unloaded the catch at the landing site.Validation:The date must be valid and cannot be null. The unload date must be greater thanor equal to start date (i.e. departure date) A warning is issued if the unloaddate is less than the landing date.

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

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

Item Identification

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

Identifies Trip Locations Per Trip
Notes:

Loaded by batch 2043, 12-20-2007 08:10

Physical Location

Organization: Southeast Fisheries Science Center
City: Miami
State/Province: FL
Country: USA

Entity Information

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

Identifies Trip Locations Per Trip

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 LOCATION_TYPE VARCHAR2 Identifies trip locations (e.g. Departure, Landing, Sale, etc.)Validation:The domain LOCATION_TYPE ensures that only locations that have been previously defined in the system can be entered.
100
 Primary Key LOCATION_KEY NUMBER If the row changed had location information, this key is provided to identify the appropriate location record within the logbook.
100
 EVENT_DATE DATE Date when the event defined by the location type (e.g., landing, departure, etc.) occurred.Validation:A valid date is ensured by the use of the DATE data type of the column. The column is optional and may be left empty.
100
 LOGBOOK_KEY NUMBER Foreign key to the FLS_TRIPS and other master tables.Validation:A foreign key enforces that trip information must have been entered into the FLS_TRIP table before location data can be added.
100
 PORT_CODE_FIPS VARCHAR2 FIPS port code. Leading zeroes were added to make it compatible with thestandard FIPS place codes upon which it is based.Validation:The column is mandatary and cannot be left empty.
100
 COUNTRY_CODE_FIPS VARCHAR2 Country where the dealership is located.Validation:The country code must be a valid FIPS country.The country code is mandatory and cannot be left empty.
100
 COUNTY_CODE_NMFS VARCHAR2 The legacy pc field, state, is called state_code_nmfs in the FLS master tables.The official three digit NMFS county code. The code is left padded with zeroes.Validation:A foreign key to the table FLS_COUNTY_CODES_NMFS ensures that the codes entered are valid. The codes should be entered with leading zeroes.This column is mandatory and cannot be left empty.
100
 STATE_CODE_NMFS VARCHAR2 State where the Area Fished Code is valid. The State Codes are assigned and maintained by the National Marine Fisheries Service.Validation:There is a foreign key relationship on this column with the table FLS_STATE_CODES_NMFS. This means that no rows can be added to this table if the state code is not found in the state code table. This ensures that no mysterious codes are added to the table.This column is also mandatory, which means that it cannot be left empty.
100
 UNLOAD_DATE DATE Date when the vessel unloaded the catch at the landing site.Validation:The date must be valid and cannot be null. The unload date must be greater thanor equal to start date (i.e. departure date) A warning is issued if the unloaddate is less than the landing date.

Attribute Details

LOCATION_TYPE

CC ID: 25036
Seq. Order: 1
Data Storage Type: VARCHAR2
Max Length: 5
Required: Yes
Primary Key: No
Status: Active
Description:

Identifies trip locations (e.g. Departure, Landing, Sale, etc.)Validation:The domain LOCATION_TYPE ensures that only locations that have been previously defined in the system can be entered.
General Data Type: VARCHAR2

LOCATION_KEY

CC ID: 25037
Seq. Order: 2
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: Yes
Precision: 10
Scale: 0
Status: Active
Description:

If the row changed had location information, this key is provided to identify the appropriate location record within the logbook.
General Data Type: NUMBER

EVENT_DATE

CC ID: 25038
Seq. Order: 3
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Date when the event defined by the location type (e.g., landing, departure, etc.) occurred.Validation:A valid date is ensured by the use of the DATE data type of the column. The column is optional and may be left empty.
General Data Type: DATE

LOGBOOK_KEY

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

Foreign key to the FLS_TRIPS and other master tables.Validation:A foreign key enforces that trip information must have been entered into the FLS_TRIP table before location data can be added.
General Data Type: NUMBER

PORT_CODE_FIPS

CC ID: 25040
Seq. Order: 5
Data Storage Type: VARCHAR2
Max Length: 5
Required: No
Primary Key: No
Status: Active
Description:

FIPS port code. Leading zeroes were added to make it compatible with thestandard FIPS place codes upon which it is based.Validation:The column is mandatary and cannot be left empty.
General Data Type: VARCHAR2

COUNTRY_CODE_FIPS

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

Country where the dealership is located.Validation:The country code must be a valid FIPS country.The country code is mandatory and cannot be left empty.
General Data Type: VARCHAR2

COUNTY_CODE_NMFS

CC ID: 25042
Seq. Order: 7
Data Storage Type: VARCHAR2
Max Length: 3
Required: Yes
Primary Key: No
Status: Active
Description:

The legacy pc field, state, is called state_code_nmfs in the FLS master tables.The official three digit NMFS county code. The code is left padded with zeroes.Validation:A foreign key to the table FLS_COUNTY_CODES_NMFS ensures that the codes entered are valid. The codes should be entered with leading zeroes.This column is mandatory and cannot be left empty.
General Data Type: VARCHAR2

STATE_CODE_NMFS

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

State where the Area Fished Code is valid. The State Codes are assigned and maintained by the National Marine Fisheries Service.Validation:There is a foreign key relationship on this column with the table FLS_STATE_CODES_NMFS. This means that no rows can be added to this table if the state code is not found in the state code table. This ensures that no mysterious codes are added to the table.This column is also mandatory, which means that it cannot be left empty.
General Data Type: VARCHAR2

UNLOAD_DATE

CC ID: 25035
Seq. Order: 9
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Date when the vessel unloaded the catch at the landing site.Validation:The date must be valid and cannot be null. The unload date must be greater thanor equal to start date (i.e. departure date) A warning is issued if the unloaddate is less than the landing date.
General Data Type: DATE

Catalog Details

Catalog Item ID: 6873
GUID: gov.noaa.nmfs.inport:6873
Metadata Record Created By: Lee M Weinberger
Metadata Record Created: 2007-12-20 08:10+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:10+0000
Metadata Record Published: 2021-05-07
Owner Org: SEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2021-05-07
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2022-05-07