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

Summary

Abstract

This entity represents the list of records which will or has been trasmitted to AFSC. It identifies the table, unique identifier, action status (CRUD), and transmission status of each record.

Description

This entity represents the list of records which will or has been trasmitted to AFSC. It identifies the table, unique identifier, action status (CRUD), and transmission status of each record.

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
RECORD_STATUS_SEQ
NUMBER
Sequence Generated Unique Identifier for records that are currently queued for loading.
RECORD_SET_STATUS_SEQ
NUMBER
Sequence generated unique identifier of a record set header
CRUISE
NUMBER
Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record. Here it identifies which cruise this element in the recordset belongs to.
TABLE_NAME
VARCHAR2
Table name from which a record is inserted, updated or deleted.
PK1_COLUMN_NAME
VARCHAR2
Primary key column name for the referenced table.
PK1_VALUE
VARCHAR2
Primary key column value for the referenced table.
PK2_COLUMN_NAME
VARCHAR2
Compound primary key column name for the referenced table.
PK2_VALUE
VARCHAR2
Compound primary key column value for the referenced table.
STATUS_CODE
VARCHAR2
This attribute identifies the action taken on this record. Valid Values I = Insert, U = Update, D = delete
TRANSMISSION_RECEIVED_DATE
DATE
Timestamp for the date that the record status was loaded into the working tables.

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: Table: ATLW_RECORD_STATUS
Short Name: ATLW_RECORD_STATUS
Status: Completed
Abstract:

This entity represents the list of records which will or has been trasmitted to AFSC. It identifies the table, unique identifier, action status (CRUD), and transmission status of each record.

Purpose:

Working Tables accept the raw data from field transmissions or data entry. They are unconstrained, Relational integrity data validation is performed when data are loaded into NORPAC transaction tables. Error checking is performed by batch processes on production data.

Notes:

Loaded by batch 2164, 03-27-2008 10:42

Entity Information

Entity Type: Data Table
Active Version?: Yes
Schema Name: NORPAC
Description:

This entity represents the list of records which will or has been trasmitted to AFSC. It identifies the table, unique identifier, action status (CRUD), and transmission status of each record.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key RECORD_STATUS_SEQ NUMBER Sequence Generated Unique Identifier for records that are currently queued for loading.
100
Primary Key RECORD_SET_STATUS_SEQ NUMBER Sequence generated unique identifier of a record set header
100
Primary Key CRUISE NUMBER Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record. Here it identifies which cruise this element in the recordset belongs to.
100
TABLE_NAME VARCHAR2 Table name from which a record is inserted, updated or deleted.
100
PK1_COLUMN_NAME VARCHAR2 Primary key column name for the referenced table.
100
PK1_VALUE VARCHAR2 Primary key column value for the referenced table.
100
PK2_COLUMN_NAME VARCHAR2 Compound primary key column name for the referenced table.
100
PK2_VALUE VARCHAR2 Compound primary key column value for the referenced table.
100
STATUS_CODE VARCHAR2 This attribute identifies the action taken on this record. Valid Values I = Insert, U = Update, D = delete
100
TRANSMISSION_RECEIVED_DATE DATE Timestamp for the date that the record status was loaded into the working tables.

Attribute Details

RECORD_STATUS_SEQ

CC ID: 28440
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 records that are currently queued for loading.

General Data Type: NUMBER

RECORD_SET_STATUS_SEQ

CC ID: 28439
Seq. Order: 2
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: Yes
Precision: 9
Scale: 0
Status: Active
Description:

Sequence generated unique identifier of a record set header

General Data Type: NUMBER

CRUISE

CC ID: 28434
Seq. Order: 3
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: Yes
Precision: 8
Scale: 0
Status: Active
Description:

Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record. Here it identifies which cruise this element in the recordset belongs to.

General Data Type: NUMBER

TABLE_NAME

CC ID: 28442
Seq. Order: 4
Data Storage Type: VARCHAR2
Max Length: 30
Required: Yes
Primary Key: No
Status: Active
Description:

Table name from which a record is inserted, updated or deleted.

General Data Type: VARCHAR2

PK1_COLUMN_NAME

CC ID: 28435
Seq. Order: 5
Data Storage Type: VARCHAR2
Max Length: 30
Required: Yes
Primary Key: No
Status: Active
Description:

Primary key column name for the referenced table.

General Data Type: VARCHAR2

PK1_VALUE

CC ID: 28436
Seq. Order: 6
Data Storage Type: VARCHAR2
Max Length: 9
Required: Yes
Primary Key: No
Status: Active
Description:

Primary key column value for the referenced table.

General Data Type: VARCHAR2

PK2_COLUMN_NAME

CC ID: 28437
Seq. Order: 7
Data Storage Type: VARCHAR2
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

Compound primary key column name for the referenced table.

General Data Type: VARCHAR2

PK2_VALUE

CC ID: 28438
Seq. Order: 8
Data Storage Type: VARCHAR2
Max Length: 9
Required: No
Primary Key: No
Status: Active
Description:

Compound primary key column value for the referenced table.

General Data Type: VARCHAR2

STATUS_CODE

CC ID: 28441
Seq. Order: 9
Data Storage Type: VARCHAR2
Max Length: 1
Required: Yes
Primary Key: No
Status: Active
Description:

This attribute identifies the action taken on this record. Valid Values I = Insert, U = Update, D = delete

General Data Type: VARCHAR2

TRANSMISSION_RECEIVED_DATE

CC ID: 28443
Seq. Order: 10
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Timestamp for the date that the record status was loaded into the working tables.

General Data Type: DATE

Catalog Details

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