Metadata Rubric

100%

6 / 6

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

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

	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.

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