Table: RECORD_STATUS
Entity (ENT) | Alaska Fisheries Science Center (AFSC)GUID: gov.noaa.nmfs.inport:7547 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
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.
DescriptionThis 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 |
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: 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
Name | Type | Description | ||
---|---|---|---|---|
100
|
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
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
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
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
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
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
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
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
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
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 |