Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
NEFSC Metadata Library > Data Management Systems (DMS) > Vessel Electronic Reporting System (VERS) >

Table: VERS_LANDING

Entity (ENT)  |  Northeast Fisheries Science Center (NEFSC)
GUID: gov.noaa.nmfs.inport:34243  |  Updated: August 9, 2022  |  Published / External 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

Table contains landing level records for electronically reported data

Description

Table contains landing level records for electronically reported data

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
TRIP_ID
NUMBER 		Unique trip identifier
LANDING_NUM
NUMBER 		Unique identifier for the landing event
LAND_PORT_STATE
VARCHAR2 		State code for the state in which the land port is located
LAND_PORT_PLACE
VARCHAR2 		Port code for the port of landing
LAND_PORT_COUNTY
VARCHAR2 		County code for the county in which the land port is located
LAND_DATE_GMT
DATE 		Datetime (UTC) when the vessel landed
LAND_ENTRY_DATE_GMT
DATE 		Datetime (UTC) at which the landing record was entered into the ELB
UPLOAD_DATE_GMT
DATE 		Datetime (UTC) at which the submitted data was loaded to NEFSC servers

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

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

Item Identification

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

Table contains landing level records for electronically reported data
Notes:

Loaded by batch 9189, 08-11-2016 10:02

Entity Information

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

Table contains landing level records for electronically reported data

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 Primary Key TRIP_ID NUMBER Unique trip identifier
100
 Primary Key LANDING_NUM NUMBER Unique identifier for the landing event
100
 LAND_PORT_STATE VARCHAR2 State code for the state in which the land port is located
100
 LAND_PORT_PLACE VARCHAR2 Port code for the port of landing
100
 LAND_PORT_COUNTY VARCHAR2 County code for the county in which the land port is located
100
 LAND_DATE_GMT DATE Datetime (UTC) when the vessel landed
100
 LAND_ENTRY_DATE_GMT DATE Datetime (UTC) at which the landing record was entered into the ELB
100
 UPLOAD_DATE_GMT DATE Datetime (UTC) at which the submitted data was loaded to NEFSC servers

Attribute Details

TRIP_ID

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

Unique trip identifier
General Data Type: NUMBER
Foreign Key Relations:

FVTR.VERS_TRIP

LANDING_NUM

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

Unique identifier for the landing event
General Data Type: NUMBER

LAND_PORT_STATE

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

State code for the state in which the land port is located
General Data Type: VARCHAR2
Foreign Key Relations:

FVTR.FVTR_PORTS

LAND_PORT_PLACE

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

Port code for the port of landing
General Data Type: VARCHAR2
Foreign Key Relations:

FVTR.FVTR_PORTS

LAND_PORT_COUNTY

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

County code for the county in which the land port is located
General Data Type: VARCHAR2
Foreign Key Relations:

FVTR.FVTR_PORTS

LAND_DATE_GMT

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

Datetime (UTC) when the vessel landed
General Data Type: DATE

LAND_ENTRY_DATE_GMT

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

Datetime (UTC) at which the landing record was entered into the ELB
General Data Type: DATE

UPLOAD_DATE_GMT

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

Datetime (UTC) at which the submitted data was loaded to NEFSC servers
General Data Type: DATE

Catalog Details

Catalog Item ID: 34243
GUID: gov.noaa.nmfs.inport:34243
Metadata Record Created By: Patricia L Jones
Metadata Record Created: 2016-08-11 10:02+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2016-08-23
Owner Org: NEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2016-08-23
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2017-08-23