Slide Menu
Jump to Section...
Maintenance Notice: Tuesday May 21 @ 12pm-1:30pm Eastern. InPort and its associated services will be under maintenance and unavailable for the deployment of InPort Release 5.3.6. Downtime Schedule Tuesday, May 21, 2024 12:00pm - 1:30pm Eastern / 9:00am - 10:30am Pacific / 6:00am - 8:30am Hawaii Impacted Areas - InPort Website: https://www.fisheries.noaa.gov/inport - InPort WAF: h...
View All
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 

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