Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
NEFSC Metadata Library > Fishery Monitoring & Research Division (FMRD) > Northeast Cooperative Research Program (NCRP) > Northeast Electronic Reporting System (NERS) >

Table: GPS_LOAD_HISTORY

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

Summary

Abstract

Contains a single entry for each FLDRS generated GPS Polling file uploaded, serves as a means to track GPS upload status

Description

Contains a single entry for each FLDRS generated GPS Polling file uploaded, serves as a means to track GPS upload status

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
GPD_TRIP_ID
NUMBER 		Unique trip identifier generated in FLDRS software
GLM_LOAD_METHOD
NUMBER 		GPS Database Load Method; supporting table GPS_LOAD_METHOD
ORIGINAL_RECORDS
NUMBER 		Number of records in raw file
LOADED_RECORDS
NUMBER 		Number of records loaded to database
GPS_LOAD_DATE
DATE 		Date data uploaded
COMMENTS
VARCHAR2 		Additonal Comments

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: GPS_LOAD_HISTORY
Short Name: GPS_LOAD_HISTORY
Status: Completed
Abstract:

Contains a single entry for each FLDRS generated GPS Polling file uploaded, serves as a means to track GPS upload status
Notes:

Loaded by batch 9249, 09-01-2016 13:11

Entity Information

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

Contains a single entry for each FLDRS generated GPS Polling file uploaded, serves as a means to track GPS upload status

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 Primary Key GPD_TRIP_ID NUMBER Unique trip identifier generated in FLDRS software
100
 GLM_LOAD_METHOD NUMBER GPS Database Load Method; supporting table GPS_LOAD_METHOD
100
 ORIGINAL_RECORDS NUMBER Number of records in raw file
100
 LOADED_RECORDS NUMBER Number of records loaded to database
100
 GPS_LOAD_DATE DATE Date data uploaded
100
 COMMENTS VARCHAR2 Additonal Comments

Attribute Details

GPD_TRIP_ID

CC ID: 347782
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 generated in FLDRS software
General Data Type: NUMBER

GLM_LOAD_METHOD

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

GPS Database Load Method; supporting table GPS_LOAD_METHOD
General Data Type: NUMBER

ORIGINAL_RECORDS

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

Number of records in raw file
General Data Type: NUMBER

LOADED_RECORDS

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

Number of records loaded to database
General Data Type: NUMBER

GPS_LOAD_DATE

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

Date data uploaded
General Data Type: DATE

COMMENTS

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

Additonal Comments
General Data Type: VARCHAR2

Catalog Details

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