Table: GPS_LOAD_HISTORY
Entity (ENT) | Northeast Fisheries Science Center (NEFSC)GUID: gov.noaa.nmfs.inport:34567 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
Contains a single entry for each FLDRS generated GPS Polling file uploaded, serves as a means to track GPS upload status
DescriptionContains 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
Name | Type | Description | ||
---|---|---|---|---|
100
|
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
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
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
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
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
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
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 |