32692
DATA_LOADING_LOG
DATA_LOADING_LOG
Entity
Published / External
17904
SPS Abundance - Salmon spawner abundance data compilation and database management
Data Set
Planned
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 Table
Yes
SPS
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_LOADED_BY
VARCHAR2
200
No
No
Active
The name of the person who executed the data parsing procedures.
VARCHAR2
INPUT_RECORDS
NUMBER
22
No
No
Active
The total number of records in the source table prior to data parsing.
NUMBER
NEW_CATCH_TOTAL
NUMBER
22
No
No
Active
The sum of catch reported for a population after data has been loaded.
NUMBER
NEW_END_YEAR
NUMBER
22
No
No
Active
The latest year that data was reported for a population after new data has been loaded.
NUMBER
NWR_POPULATION_NAME
VARCHAR2
400
No
No
Active
The name of the population that has been added or updated.
VARCHAR2
PREV_CATCH_TOTAL
NUMBER
22
No
No
Active
The sum of catch reported for a population prior to data loading of new data.
NUMBER
SOURCE_TABLE
VARCHAR2
30
No
No
Active
The name of the temporary table that was to store the data prior to parsing into base tables.
VARCHAR2
PROCESSED_DATE
DATE
7
No
No
Active
The date the data was parsed into base tables.
DATE
PROCESSED_RECORDS
NUMBER
22
No
No
Active
The total number of records that were processed during data parsing.
NUMBER
PSGS_ADDED
VARCHAR2
4000
No
No
Active
The number of Population Groups that have been added.
VARCHAR2
PSGS_NOT_FOUND
VARCHAR2
4000
No
No
Active
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.
VARCHAR2
SOURCE_SPREADSHEET
VARCHAR2
100
No
No
Active
The name of the spreadsheet that contained the data prior to loading into the database.
VARCHAR2
PREV_END_YEAR
NUMBER
22
No
No
Active
The latest year that data was reported for a population prior to data loading of new data.
NUMBER
gov.noaa.nmfs.inport:32692
Jeffrey Cowen
2016-05-09T14:19:47
SysAdmin InPortAdmin
2022-08-09T17:11:00
2016-05-11
Northwest Fisheries Science Center
NWFSC
2725 Montlake Boulevard East
Seattle
WA
98112
USA
206-860-3200
http://www.nwfsc.noaa.gov
1001
Public
No
2016-05-11
1 Year
2017-05-11