Slide Menu
Search Help Show/Hide Menu

Item Identification

Title: Table: RECORD_STATUS
Short Name: 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.

Notes:

Loaded by batch 2204, 03-28-2008 14:09

Entity Information

Entity Type: Data Table
Active Version?: Yes
Schema Name: TURNBULLD
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
RECORD_SET_STATUS_SEQ NUMBER Sequence generated unique identifier of a record set header
100
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

Attribute Details

RECORD_STATUS_SEQ

CC ID: 29803
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: 29802
Seq. Order: 2
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 9
Scale: 0
Status: Active
Description:

Sequence generated unique identifier of a record set header

General Data Type: NUMBER
Foreign Key Relations:

TURNBULLD.RECORD_SET_STATUS

CRUISE

CC ID: 29797
Seq. Order: 3
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
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: 29805
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: 29798
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: 29799
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: 29800
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: 29801
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: 29804
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

Catalog Details

Catalog Item ID: 7547
GUID: gov.noaa.nmfs.inport:7547
Metadata Record Created By: Doug Turnbull
Metadata Record Created: 2008-03-28 14:10+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2016-05-04
Owner Org: AFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2016-05-04
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2017-05-04