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.

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
Metadata Record Created By: Jeffrey W Cowen
Metadata Record Created: 2016-05-09 14:19+0000
Metadata Record Last Modified By: Jeffrey W Cowen
Metadata Record Last Modified: 2016-05-11 17:05+0000
Metadata Record Published: 2016-05-11
Owner Org: NWFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2017-05-12
Linking Share Level: Across the InPort Catalog