Search Help Show/Hide Menu
Summary
Item Identification
Entity Info
Catalog Details

Summary

Abstract

This Package contains the code that reads and logs data errors within the initial load and processing of data in the NORPAC data set. Data streams come from electronic submissions via ATLAS, data input of faxed observer reports, and from the editing and debriefing process. Since the deployed version of ATLAS is refreshed only annually, error checking on the client will require augmentation by rigorous validation. Data keypunched from faxed forms is not validated at the source and must be reviewed prior to loading into the production table set. Finally edits may affect or invalidate related information in child or parent tables which are not verified by trigger logic. Consequently the entire set of scipts must be executed, and any errors iteratively logged.

The package body is organized by transaction table and private procedures call each in the logical validation order.

Description

This package contains the code that reads and logs data errors within the initial load and processing of data in the NORPAC data set. Data streams come from electronic submissions via ATLAS, data input of faxed observer reports, and from the editing and debriefing process. Since the deployed version of ATLAS is refreshed only annually, error checking on the client will require augmentation by rigorous validation. Data keypunched from faxed forms is not validated at the source and must be reviewed prior to loading into the production table set. Finally, edits may affect or invalidate related information in child or parent tables which are not verified by trigger logic. Consequently, the entire set of scripts must be executed, and any errors iteratively logged.

The package body is organized by transaction table and private procedures call each in the logical validation order.

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

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

Item Identification

Title: Package: ATL_ERRORS
Short Name: Package: ATL_ERRORS
Status: In Work
Abstract:

This Package contains the code that reads and logs data errors within the initial load and processing of data in the NORPAC data set. Data streams come from electronic submissions via ATLAS, data input of faxed observer reports, and from the editing and debriefing process. Since the deployed version of ATLAS is refreshed only annually, error checking on the client will require augmentation by rigorous validation. Data keypunched from faxed forms is not validated at the source and must be reviewed prior to loading into the production table set. Finally edits may affect or invalidate related information in child or parent tables which are not verified by trigger logic. Consequently the entire set of scipts must be executed, and any errors iteratively logged.

The package body is organized by transaction table and private procedures call each in the logical validation order.

Entity Information

Entity Type: Other
Active Version?: No
Schema Name: NORPAC
Description:

This package contains the code that reads and logs data errors within the initial load and processing of data in the NORPAC data set. Data streams come from electronic submissions via ATLAS, data input of faxed observer reports, and from the editing and debriefing process. Since the deployed version of ATLAS is refreshed only annually, error checking on the client will require augmentation by rigorous validation. Data keypunched from faxed forms is not validated at the source and must be reviewed prior to loading into the production table set. Finally, edits may affect or invalidate related information in child or parent tables which are not verified by trigger logic. Consequently, the entire set of scripts must be executed, and any errors iteratively logged.

The package body is organized by transaction table and private procedures call each in the logical validation order.

Catalog Details

Catalog Item ID: 7485
GUID: gov.noaa.nmfs.inport:7485
Metadata Record Created By: Doug Turnbull
Metadata Record Created: 2008-03-27 13:30+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