Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
NWFSC Metadata Library > CB (Conservation Biology) Division > SPS Abundance - Salmon spawner abundance data c... >

DATA_LOADING_LOG

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

Summary

Abstract

Table used by the data loading procedures to track the source of the population data and if a population has been updated it tracks summarized data values of the changes.

Description

Table used by the data loading procedures to track the source of the population data and if a population has been updated it tracks summarized data values of the changes.

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
SOURCE_SPREADSHEET
VARCHAR2 		The name of the spreadsheet that contained the data prior to loading into the database.
SOURCE_TABLE
VARCHAR2 		The name of the temporary table that was to store the data prior to parsing into base tables.
PROCESSED_DATE
DATE 		The date the data was parsed into base tables.
DATA_LOADED_BY
VARCHAR2 		The name of the person who executed the data parsing procedures.
NWR_POPULATION_NAME
VARCHAR2 		The name of the population that has been added or updated.
PSGS_NOT_FOUND
VARCHAR2 		List of any Population Groups that do not exist in the base tables. This indicates that there is either a new population or the data has an error.
PSGS_ADDED
VARCHAR2 		The number of Population Groups that have been added.
INPUT_RECORDS
NUMBER 		The total number of records in the source table prior to data parsing.
PROCESSED_RECORDS
NUMBER 		The total number of records that were processed during data parsing.
PREV_END_YEAR
NUMBER 		The latest year that data was reported for a population prior to data loading of new data.
NEW_END_YEAR
NUMBER 		The latest year that data was reported for a population after new data has been loaded.
PREV_CATCH_TOTAL
NUMBER 		The sum of catch reported for a population prior to data loading of new data.
NEW_CATCH_TOTAL
NUMBER 		The sum of catch reported for a population after data has been loaded.

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

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

Item Identification

Title: DATA_LOADING_LOG
Short Name: DATA_LOADING_LOG
Status: Planned
Abstract:

Table used by the data loading procedures to track the source of the population data and if a population has been updated it tracks summarized data values of the changes.

Entity Information

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

Table used by the data loading procedures to track the source of the population data and if a population has been updated it tracks summarized data values of the changes.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 SOURCE_SPREADSHEET VARCHAR2 The name of the spreadsheet that contained the data prior to loading into the database.
100
 SOURCE_TABLE VARCHAR2 The name of the temporary table that was to store the data prior to parsing into base tables.
100
 PROCESSED_DATE DATE The date the data was parsed into base tables.
100
 DATA_LOADED_BY VARCHAR2 The name of the person who executed the data parsing procedures.
100
 NWR_POPULATION_NAME VARCHAR2 The name of the population that has been added or updated.
100
 PSGS_NOT_FOUND VARCHAR2 List of any Population Groups that do not exist in the base tables. This indicates that there is either a new population or the data has an error.
100
 PSGS_ADDED VARCHAR2 The number of Population Groups that have been added.
100
 INPUT_RECORDS NUMBER The total number of records in the source table prior to data parsing.
100
 PROCESSED_RECORDS NUMBER The total number of records that were processed during data parsing.
100
 PREV_END_YEAR NUMBER The latest year that data was reported for a population prior to data loading of new data.
100
 NEW_END_YEAR NUMBER The latest year that data was reported for a population after new data has been loaded.
100
 PREV_CATCH_TOTAL NUMBER The sum of catch reported for a population prior to data loading of new data.
100
 NEW_CATCH_TOTAL NUMBER The sum of catch reported for a population after data has been loaded.

Attribute Details

SOURCE_SPREADSHEET

CC ID: 324126
Data Storage Type: VARCHAR2
Max Length: 100
Required: No
Primary Key: No
Status: Active
Description:

The name of the spreadsheet that contained the data prior to loading into the database.
General Data Type: VARCHAR2

SOURCE_TABLE

CC ID: 324127
Data Storage Type: VARCHAR2
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

The name of the temporary table that was to store the data prior to parsing into base tables.
General Data Type: VARCHAR2

PROCESSED_DATE

CC ID: 324128
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

The date the data was parsed into base tables.
General Data Type: DATE

DATA_LOADED_BY

CC ID: 324129
Data Storage Type: VARCHAR2
Max Length: 200
Required: No
Primary Key: No
Status: Active
Description:

The name of the person who executed the data parsing procedures.
General Data Type: VARCHAR2

NWR_POPULATION_NAME

CC ID: 324130
Data Storage Type: VARCHAR2
Max Length: 400
Required: No
Primary Key: No
Status: Active
Description:

The name of the population that has been added or updated.
General Data Type: VARCHAR2

PSGS_NOT_FOUND

CC ID: 324131
Data Storage Type: VARCHAR2
Max Length: 4000
Required: No
Primary Key: No
Status: Active
Description:

List of any Population Groups that do not exist in the base tables. This indicates that there is either a new population or the data has an error.
General Data Type: VARCHAR2

PSGS_ADDED

CC ID: 324132
Data Storage Type: VARCHAR2
Max Length: 4000
Required: No
Primary Key: No
Status: Active
Description:

The number of Population Groups that have been added.
General Data Type: VARCHAR2

INPUT_RECORDS

CC ID: 324133
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

The total number of records in the source table prior to data parsing.
General Data Type: NUMBER

PROCESSED_RECORDS

CC ID: 324134
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

The total number of records that were processed during data parsing.
General Data Type: NUMBER

PREV_END_YEAR

CC ID: 324135
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

The latest year that data was reported for a population prior to data loading of new data.
General Data Type: NUMBER

NEW_END_YEAR

CC ID: 324136
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

The latest year that data was reported for a population after new data has been loaded.
General Data Type: NUMBER

PREV_CATCH_TOTAL

CC ID: 324137
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

The sum of catch reported for a population prior to data loading of new data.
General Data Type: NUMBER

NEW_CATCH_TOTAL

CC ID: 324138
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

The sum of catch reported for a population after data has been loaded.
General Data Type: NUMBER

Catalog Details

Catalog Item ID: 32692
GUID: gov.noaa.nmfs.inport:32692
Metadata Record Created By: Jeffrey W Cowen
Metadata Record Created: 2016-05-09 14:19+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2016-05-11
Owner Org: NWFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2016-05-11
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2017-05-11