Metadata Rubric

100%

6 / 6

Alaska Fisheries Science Center Metadata Librar... > Fisheries Management and Analysis Division > North Pacific (NORPAC) Groundfish and Halibut O... > AFSC/FMA/North Pacific Groundfish and Halibut O... >

Table: ATL_ERROR_LOG

Entity (ENT) | Alaska Fisheries Science Center (AFSC)
GUID: gov.noaa.nmfs.inport:9662 | Updated: August 9, 2022 | Published / External

Summary

Item Identification

Entity Info

Data Attributes

Catalog Details

Abstract

This entity provides inseason managers with a record of of load and edit errors which require review and correction. This provides a permanent record of data transmission errors and timestamps their resolution.

Description

Entity Type
Data Table

Data Attribute / Type	Description
ERROR_LOG_ID NUMBER	Sequence generated unique identifier for an error log entry
ERROR_NUMBER NUMBER	Unique user defined error number between -20000 and -21000
CRUISE NUMBER	Cruise number from Atlas which generated error.
YEAR NUMBER	Year extracted from sysdate when error was recorded to facilitate reporting.
TABLE_NAME VARCHAR2	Name of the table for which loading or editing error was recorded.
PK1_COLUMN_NAME VARCHAR2	Name of the first primary key column.
PK1_VALUE VARCHAR2	Atlas Norpac unique record identifier of record that generated the error. Usually this is numeric but it may be Alpha in the case of a compound primary key.
PK2_COLUMN_NAME VARCHAR2	Name of the second primary key column.
PK2_VALUE VARCHAR2	Atlas Norpac unique record identifier of record that generated the error. Usually this is numeric but it may be Alpha in the case of a compound primary key.
LOADING_LEVEL VARCHAR2	This attribute identifies the loading process where the error occured ATL - atlas production tables, INS - Inseason ETL, DOM - Domestic ETL.
RESOLVED_CODE VARCHAR2	Identifying code which indicates that the error was addressed Y, an overide was requested R, Defaults to N.
RESOLVED_BY VARCHAR2	Inseason advisor who addressed and resolved the error. Mandatory when resolved flag set to Y.
RESOLVED_DATE DATE	Timestamp when resolved flag was set to Y
ADMIN_OVERRIDE_FLAG VARCHAR2	Error Scripts will not allow the loading of data to Inseason or Domestic Tables if errors (99, 50) are logged. If an administrator desires, unresolved errors may be ignored and records moved by setting this flag to Yes.
COMMENTS VARCHAR2	Optional discussion - particularly useful in the case of management setting the admin_overide_flag to Yes and loading data with known errors.
PERMIT VARCHAR2	Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau
ACTIVE_FLAG VARCHAR2	When a new error is logged it defaults to active. Whe data is validated all the logged errors are set to inactive(N). If found again the flag is reset to active(Y) or if not present the error log record is added.

Data Attribute / Type

Description

ERROR_LOG_ID
NUMBER

Sequence generated unique identifier for an error log entry

ERROR_NUMBER
NUMBER

Unique user defined error number between -20000 and -21000

CRUISE
NUMBER

Cruise number from Atlas which generated error.

YEAR
NUMBER

Year extracted from sysdate when error was recorded to facilitate reporting.

TABLE_NAME
VARCHAR2

Name of the table for which loading or editing error was recorded.

PK1_COLUMN_NAME
VARCHAR2

Name of the first primary key column.

PK1_VALUE
VARCHAR2

Atlas Norpac unique record identifier of record that generated the error. Usually this is numeric but it may be Alpha in the case of a compound primary key.

PK2_COLUMN_NAME
VARCHAR2

Name of the second primary key column.

PK2_VALUE
VARCHAR2

Atlas Norpac unique record identifier of record that generated the error. Usually this is numeric but it may be Alpha in the case of a compound primary key.

LOADING_LEVEL
VARCHAR2

This attribute identifies the loading process where the error occured ATL - atlas production tables, INS - Inseason ETL, DOM - Domestic ETL.

RESOLVED_CODE
VARCHAR2

Identifying code which indicates that the error was addressed Y, an overide was requested R, Defaults to N.

RESOLVED_BY
VARCHAR2

Inseason advisor who addressed and resolved the error. Mandatory when resolved flag set to Y.

RESOLVED_DATE
DATE

Timestamp when resolved flag was set to Y

ADMIN_OVERRIDE_FLAG
VARCHAR2

Error Scripts will not allow the loading of data to Inseason or Domestic Tables if errors (99, 50) are logged. If an administrator desires, unresolved errors may be ignored and records moved by setting this flag to Yes.

COMMENTS
VARCHAR2

Optional discussion - particularly useful in the case of management setting the admin_overide_flag to Yes and loading data with known errors.

PERMIT
VARCHAR2

Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau

ACTIVE_FLAG
VARCHAR2

When a new error is logged it defaults to active. Whe data is validated all the logged errors are set to inactive(N). If found again the flag is reset to active(Y) or if not present the error log record is added.

No Child Items for this record.

No contact information is available for this record.

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

Title:	Table: ATL_ERROR_LOG
Short Name:	ATL_ERROR_LOG
Status:	Completed
Abstract:	This entity provides inseason managers with a record of of load and edit errors which require review and correction. This provides a permanent record of data transmission errors and timestamps their resolution.
Notes:	Loaded by batch 2390, 06-30-2009 16:11

Entity Type:	Data Table
Active Version?:	Yes
Schema Name:	NORPAC
Description:	This entity provides inseason managers with a record of of load and edit errors which require review and correction. This provides a permanent record of data transmission errors and timestamps their resolution.

Attribute Summary

	Name	Type	Description
100	ERROR_LOG_ID	NUMBER	Sequence generated unique identifier for an error log entry
100	ERROR_NUMBER	NUMBER	Unique user defined error number between -20000 and -21000
100	CRUISE	NUMBER	Cruise number from Atlas which generated error.
100	YEAR	NUMBER	Year extracted from sysdate when error was recorded to facilitate reporting.
100	TABLE_NAME	VARCHAR2	Name of the table for which loading or editing error was recorded.
100	PK1_COLUMN_NAME	VARCHAR2	Name of the first primary key column.
100	PK1_VALUE	VARCHAR2	Atlas Norpac unique record identifier of record that generated the error. Usually this is numeric but it may be Alpha in the case of a compound primary key.
100	PK2_COLUMN_NAME	VARCHAR2	Name of the second primary key column.
100	PK2_VALUE	VARCHAR2	Atlas Norpac unique record identifier of record that generated the error. Usually this is numeric but it may be Alpha in the case of a compound primary key.
100	LOADING_LEVEL	VARCHAR2	This attribute identifies the loading process where the error occured ATL - atlas production tables, INS - Inseason ETL, DOM - Domestic ETL.
100	RESOLVED_CODE	VARCHAR2	Identifying code which indicates that the error was addressed Y, an overide was requested R, Defaults to N.
100	RESOLVED_BY	VARCHAR2	Inseason advisor who addressed and resolved the error. Mandatory when resolved flag set to Y.
100	RESOLVED_DATE	DATE	Timestamp when resolved flag was set to Y
100	ADMIN_OVERRIDE_FLAG	VARCHAR2	Error Scripts will not allow the loading of data to Inseason or Domestic Tables if errors (99, 50) are logged. If an administrator desires, unresolved errors may be ignored and records moved by setting this flag to Yes.
100	COMMENTS	VARCHAR2	Optional discussion - particularly useful in the case of management setting the admin_overide_flag to Yes and loading data with known errors.
100	PERMIT	VARCHAR2	Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau
100	ACTIVE_FLAG	VARCHAR2	When a new error is logged it defaults to active. Whe data is validated all the logged errors are set to inactive(N). If found again the flag is reset to active(Y) or if not present the error log record is added.

Name

Type

Description

100

ERROR_LOG_ID

NUMBER

Sequence generated unique identifier for an error log entry

100

ERROR_NUMBER

NUMBER

Unique user defined error number between -20000 and -21000

100

CRUISE

NUMBER

Cruise number from Atlas which generated error.

100

YEAR

NUMBER

Year extracted from sysdate when error was recorded to facilitate reporting.

100

TABLE_NAME

VARCHAR2

Name of the table for which loading or editing error was recorded.

100

PK1_COLUMN_NAME

VARCHAR2

Name of the first primary key column.

100

PK1_VALUE

VARCHAR2

Atlas Norpac unique record identifier of record that generated the error. Usually this is numeric but it may be Alpha in the case of a compound primary key.

100

PK2_COLUMN_NAME

VARCHAR2

Name of the second primary key column.

100

PK2_VALUE

VARCHAR2

Atlas Norpac unique record identifier of record that generated the error. Usually this is numeric but it may be Alpha in the case of a compound primary key.

100

LOADING_LEVEL

VARCHAR2

This attribute identifies the loading process where the error occured ATL - atlas production tables, INS - Inseason ETL, DOM - Domestic ETL.

100

RESOLVED_CODE

VARCHAR2

Identifying code which indicates that the error was addressed Y, an overide was requested R, Defaults to N.

100

RESOLVED_BY

VARCHAR2

Inseason advisor who addressed and resolved the error. Mandatory when resolved flag set to Y.

100

RESOLVED_DATE

DATE

Timestamp when resolved flag was set to Y

100

ADMIN_OVERRIDE_FLAG

VARCHAR2

100

COMMENTS

VARCHAR2

Optional discussion - particularly useful in the case of management setting the admin_overide_flag to Yes and loading data with known errors.

100

PERMIT

VARCHAR2

Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau

100

ACTIVE_FLAG

VARCHAR2

Attribute Details

ERROR_LOG_ID

CC ID: 38158

Seq. Order:	1
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	Yes
Precision:	9
Scale:	0
Status:	Active
Description:	Sequence generated unique identifier for an error log entry
General Data Type:	NUMBER

ERROR_NUMBER

CC ID: 38159

Seq. Order:	2
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	No
Precision:	5
Scale:	0
Status:	Active
Description:	Unique user defined error number between -20000 and -21000
General Data Type:	NUMBER
Foreign Key Relations:	NORPAC.ATL_ERROR

CRUISE

CC ID: 38157

Seq. Order:	3
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	No
Precision:	10
Scale:	0
Status:	Active
Description:	Cruise number from Atlas which generated error.
General Data Type:	NUMBER

YEAR

CC ID: 38170

Seq. Order:	4
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	No
Precision:	4
Scale:	0
Status:	Active
Description:	Year extracted from sysdate when error was recorded to facilitate reporting.
General Data Type:	NUMBER

TABLE_NAME

CC ID: 38169

Seq. Order:	5
Data Storage Type:	VARCHAR2
Max Length:	32
Required:	No
Primary Key:	No
Status:	Active
Description:	Name of the table for which loading or editing error was recorded.
General Data Type:	VARCHAR2

PK1_COLUMN_NAME

CC ID: 38162

Seq. Order:	6
Data Storage Type:	VARCHAR2
Max Length:	32
Required:	No
Primary Key:	No
Status:	Active
Description:	Name of the first primary key column.
General Data Type:	VARCHAR2

PK1_VALUE

CC ID: 38163

Seq. Order:	7
Data Storage Type:	VARCHAR2
Max Length:	20
Required:	No
Primary Key:	No
Status:	Active
Description:	Atlas Norpac unique record identifier of record that generated the error. Usually this is numeric but it may be Alpha in the case of a compound primary key.
General Data Type:	VARCHAR2

PK2_COLUMN_NAME

CC ID: 38164

Seq. Order:	8
Data Storage Type:	VARCHAR2
Max Length:	32
Required:	No
Primary Key:	No
Status:	Active
Description:	Name of the second primary key column.
General Data Type:	VARCHAR2

PK2_VALUE

CC ID: 38165

Seq. Order:	9
Data Storage Type:	VARCHAR2
Max Length:	20
Required:	No
Primary Key:	No
Status:	Active
Description:	Atlas Norpac unique record identifier of record that generated the error. Usually this is numeric but it may be Alpha in the case of a compound primary key.
General Data Type:	VARCHAR2

LOADING_LEVEL

CC ID: 38160

Seq. Order:	10
Data Storage Type:	VARCHAR2
Max Length:	3
Required:	No
Primary Key:	No
Status:	Active
Description:	This attribute identifies the loading process where the error occured ATL - atlas production tables, INS - Inseason ETL, DOM - Domestic ETL.
General Data Type:	VARCHAR2

RESOLVED_CODE

CC ID: 38167

Seq. Order:	11
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Identifying code which indicates that the error was addressed Y, an overide was requested R, Defaults to N.
General Data Type:	VARCHAR2

RESOLVED_BY

CC ID: 38166

Seq. Order:	12
Data Storage Type:	VARCHAR2
Max Length:	60
Required:	No
Primary Key:	No
Status:	Active
Description:	Inseason advisor who addressed and resolved the error. Mandatory when resolved flag set to Y.
General Data Type:	VARCHAR2

RESOLVED_DATE

CC ID: 38168

Seq. Order:	13
Data Storage Type:	DATE
Max Length:	7
Required:	No
Primary Key:	No
Status:	Active
Description:	Timestamp when resolved flag was set to Y
General Data Type:	DATE

ADMIN_OVERRIDE_FLAG

CC ID: 38155

Seq. Order:	14
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Error Scripts will not allow the loading of data to Inseason or Domestic Tables if errors (99, 50) are logged. If an administrator desires, unresolved errors may be ignored and records moved by setting this flag to Yes.
General Data Type:	VARCHAR2

COMMENTS

CC ID: 38156

Seq. Order:	15
Data Storage Type:	VARCHAR2
Max Length:	500
Required:	No
Primary Key:	No
Status:	Active
Description:	Optional discussion - particularly useful in the case of management setting the admin_overide_flag to Yes and loading data with known errors.
General Data Type:	VARCHAR2

PERMIT

CC ID: 38161

Seq. Order:	16
Data Storage Type:	VARCHAR2
Max Length:	6
Required:	No
Primary Key:	No
Status:	Active
Description:	Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau
General Data Type:	VARCHAR2

ACTIVE_FLAG

CC ID: 38154

Seq. Order:	17
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	Yes
Primary Key:	No
Status:	Active
Description:	When a new error is logged it defaults to active. Whe data is validated all the logged errors are set to inactive(N). If found again the flag is reset to active(Y) or if not present the error log record is added.
General Data Type:	VARCHAR2

Catalog Item ID:	9662
GUID:	gov.noaa.nmfs.inport:9662
Metadata Record Created By:	Doug Turnbull
Metadata Record Created:	2009-06-30 16:11+0000
Metadata Record Last Modified By:	SysAdmin InPortAdmin
Metadata Record Last Modified:	2022-08-09 17:11+0000
Metadata Record Published:	2018-09-26
Owner Org:	AFSC
Metadata Publication Status:	Published Externally
Do Not Publish?:	N
Metadata Last Review Date:	2018-09-26
Metadata Review Frequency:	1 Year
Metadata Next Review Date:	2019-09-26

Table: ATL_ERROR_LOG

Summary

Entity Information

Child Items

Contact Information

Item Identification

Entity Information

Data Attributes

Attribute Summary

Attribute Details

ERROR_LOG_ID

ERROR_NUMBER

CRUISE

YEAR

TABLE_NAME

PK1_COLUMN_NAME

PK1_VALUE

PK2_COLUMN_NAME

PK2_VALUE

LOADING_LEVEL

RESOLVED_CODE

RESOLVED_BY

RESOLVED_DATE

ADMIN_OVERRIDE_FLAG

COMMENTS

PERMIT

ACTIVE_FLAG

Catalog Details