Table: FLS_TRIP_LOCATIONS
Southeast Fisheries Science Center
Entity
(ENT)
| ID: 6873
| Published / External
Created: 2007-12-20
|
Last Modified: 2022-08-09
Data Set (DS) | ID: 6802
ID: 6873
Entity (ENT)
* Discovery• First Pass
» Metadata Rubric
Item Identification
* » Title | Table: FLS_TRIP_LOCATIONS |
---|---|
Short Name | FLS_TRIP_LOCATIONS |
* Status | Completed |
Creation Date | |
Revision Date | |
• Publication Date | |
* » Abstract |
Identifies Trip Locations Per Trip |
* Purpose | |
Notes |
Loaded by batch 2043, 12-20-2007 08:10 |
Other Citation Details | |
• Supplemental Information | |
DOI (Digital Object Identifier) | |
DOI Registration Authority | |
DOI Issue Date |
Keywords
Theme Keywords
Thesaurus | Keyword |
---|---|
Temporal Keywords
Thesaurus | Keyword |
---|---|
* Spatial Keywords
Thesaurus | Keyword |
---|---|
Stratum Keywords
Thesaurus | Keyword |
---|---|
Instrument Keywords
Thesaurus | Keyword |
---|---|
Platform Keywords
Thesaurus | Keyword |
---|---|
Physical Location
• » Organization | Southeast Fisheries Science Center |
---|---|
• » City | Miami |
• » State/Province | FL |
• Country | USA |
• » Location Description |
Entity Information
Entity Type | Data Table |
---|---|
Active Version? | Y |
Alias | |
Schema Name | FLS |
» Description |
Identifies Trip Locations Per Trip |
Change Summary |
Data Attributes
Attribute Summary
Score | Req'd? | PKey? | » Name | Data Storage Type | Description |
---|---|---|---|---|---|
100 | Yes | No | 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 | Yes | Yes | LOCATION_KEY | NUMBER | If the row changed had location information, this key is provided to identify the appropriate location record within the logbook. |
100 | No | No | 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 | Yes | No | 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 | No | No | 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 | Yes | No | 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 | Yes | No | 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 | Yes | No | 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 | No | No | 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
Attribute Name | LOCATION_TYPE |
---|---|
Seq. Order | 1 |
Data Storage Type | VARCHAR2 |
Max Length | 5 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | |
Scale | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | LOCATION_KEY |
---|---|
Seq. Order | 2 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | EVENT_DATE |
---|---|
Seq. Order | 3 |
Data Storage Type | DATE |
Max Length | 7 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | LOGBOOK_KEY |
---|---|
Seq. Order | 4 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | PORT_CODE_FIPS |
---|---|
Seq. Order | 5 |
Data Storage Type | VARCHAR2 |
Max Length | 5 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | COUNTRY_CODE_FIPS |
---|---|
Seq. Order | 6 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | |
Scale | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | COUNTY_CODE_NMFS |
---|---|
Seq. Order | 7 |
Data Storage Type | VARCHAR2 |
Max Length | 3 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | |
Scale | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | STATE_CODE_NMFS |
---|---|
Seq. Order | 8 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | |
Scale | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | UNLOAD_DATE |
---|---|
Seq. Order | 9 |
Data Storage Type | DATE |
Max Length | 7 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | |
---|---|
Seq. Order | |
Data Storage Type | |
Max Length | |
Precision | |
Scale | |
Required | |
Primary Key | |
Status | |
Description | |
General Data Type | |
Case Restriction | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Min Length | |
Unit of Measure | |
Display Example | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | |
---|---|
Seq. Order | |
Data Storage Type | |
Max Length | |
Precision | |
Scale | |
Required | |
Primary Key | |
Status | |
Description | |
General Data Type | |
Case Restriction | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Min Length | |
Unit of Measure | |
Display Example | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | |
---|---|
Seq. Order | |
Data Storage Type | |
Max Length | |
Precision | |
Scale | |
Required | |
Primary Key | |
Status | |
Description | |
General Data Type | |
Case Restriction | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Min Length | |
Unit of Measure | |
Display Example | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Support Roles
* » Support Role | |
---|---|
* » Date Effective From | |
Date Effective To | |
* » Contact | |
* Contact Instructions |
* » Support Role | |
---|---|
* » Date Effective From | |
Date Effective To | |
* » Contact | |
* Contact Instructions |
* » Support Role | |
---|---|
* » Date Effective From | |
Date Effective To | |
* » Contact | |
* Contact Instructions |
Extents
Currentness Reference |
---|
Extent Group 1
Extent Description |
---|
Extent Group 1 / Geographic Area
* » W° Bound | |
---|---|
* » E° Bound | |
* » N° Bound | |
* » S° Bound | |
* » Description |
Extent Group 1 / Vertical Extent
EPSG Code | |
---|---|
Vertical Minimum | |
Vertical Maximum |
Extent Group 1 / Time Frame
* » Time Frame Type | |
---|---|
* » Start | |
End | |
Alternate Start as of Info | |
Alternate End as of Info | |
Description |
Access Information
* » Security Class | |
---|---|
* Security Classification System |
|
Security Handling Description |
|
• Data Access Policy |
|
» Data Access Procedure |
|
• » Data Access Constraints |
|
• Data Use Constraints |
|
Metadata Access Constraints |
|
Metadata Use Constraints |
|
Distribution Information
Start Date | |
---|---|
End Date | |
» Download URL | |
Distributor | |
File Name | |
Description | |
File Date/Time | |
File Type | |
FGDC Content Type | |
File Size | |
Application Version | |
Compression | |
Review Status |
Start Date | |
---|---|
End Date | |
» Download URL | |
Distributor | |
File Name | |
Description | |
File Date/Time | |
File Type | |
FGDC Content Type | |
File Size | |
Application Version | |
Compression | |
Review Status |
Start Date | |
---|---|
End Date | |
» Download URL | |
Distributor | |
File Name | |
Description | |
File Date/Time | |
File Type | |
FGDC Content Type | |
File Size | |
Application Version | |
Compression | |
Review Status |
Activity Log
Activity Time | |
---|---|
Activity Type | |
Responsible Party | |
Description |
Activity Time | |
---|---|
Activity Type | |
Responsible Party | |
Description |
Activity Time | |
---|---|
Activity Type | |
Responsible Party | |
Description |
Issues
Issue Date | |
---|---|
Author | |
Issue |
Issue Date | |
---|---|
Author | |
Issue |
Issue Date | |
---|---|
Author | |
Issue |
FAQs
Date | |
---|---|
Author | |
Question | |
Answer |
Child Items
Rubric scores updated every 15m
Score | Type | Title |
---|---|---|
Related Items
Item Type | Relationship Type | Title |
---|---|---|
Catalog Details
Catalog Item ID | 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 Workflow State | Published / External |
Metadata Last Review Date | 2021-05-07 |
Metadata Review Frequency | 1 Year |
Metadata Next Review Date | 2022-05-07 |
Tags |
---|