Table: ATLW_RECORD_SET_STATUS
Entity (ENT) | Alaska Fisheries Science Center (AFSC)GUID: gov.noaa.nmfs.inport:7357 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
This entity represents the header information for the list of records which will or has been trasmitted to AFSC. It identifies the cruise which owns the records to be transmitted, the status of the transmission, and the version of atlas which created the transmission.
DescriptionThis entity represents the header information for the list of records which will or has been trasmitted to AFSC. It identifies the cruise which owns the records to be transmitted, the status of the transmission, and the version of atlas which created the transmission.
Entity Information
Entity Type
Data Table
Data Attribute / Type | Description |
---|---|
RECORD_SET_STATUS_SEQ
NUMBER |
Sequence generated unique identifier of a record set header |
TRANSMIT_CODE
VARCHAR2 |
This code identifies the transmission state of this record. Valid Values N = New, P = Prepared, T = Transmitted, R = Resent) |
ATLAS_VERSION
NUMBER |
Version of atlas. This is initialized at each new installation. |
PREPARED_DATE_TIME
DATE |
Timestamp posted by the iinitiating program. When a record set is prepared for transmission this attribute contains the system time. This need not necessiarily be accurate, but must be sequentially consistent. |
TEST_DATA_FLAG
VARCHAR2 |
Identifies a record set as test or production data. Defaults to (N)o - Data is Production |
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_SET_STATUS |
---|---|
Short Name: | ATLW_RECORD_SET_STATUS |
Status: | Completed |
Abstract: |
This entity represents the header information for the list of records which will or has been trasmitted to AFSC. It identifies the cruise which owns the records to be transmitted, the status of the transmission, and the version of atlas which created the transmission. |
Purpose: |
Data are transmitted as a batch from the Atlas Client to AFSC. This table captures the transmission by batch and has no analog in the production table set. |
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 header information for the list of records which will or has been trasmitted to AFSC. It identifies the cruise which owns the records to be transmitted, the status of the transmission, and the version of atlas which created the transmission. |
Data Attributes
Attribute Summary
Name | Type | Description | ||
---|---|---|---|---|
100
|
RECORD_SET_STATUS_SEQ | NUMBER | Sequence generated unique identifier of a record set header | |
100
|
TRANSMIT_CODE | VARCHAR2 | This code identifies the transmission state of this record. Valid Values N = New, P = Prepared, T = Transmitted, R = Resent) | |
100
|
ATLAS_VERSION | NUMBER | Version of atlas. This is initialized at each new installation. | |
100
|
PREPARED_DATE_TIME | DATE | Timestamp posted by the iinitiating program. When a record set is prepared for transmission this attribute contains the system time. This need not necessiarily be accurate, but must be sequentially consistent. | |
100
|
TEST_DATA_FLAG | VARCHAR2 | Identifies a record set as test or production data. Defaults to (N)o - Data is Production |
Attribute Details
RECORD_SET_STATUS_SEQ
Seq. Order: | 1 |
---|---|
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 |
TRANSMIT_CODE
Seq. Order: | 2 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
This code identifies the transmission state of this record. Valid Values N = New, P = Prepared, T = Transmitted, R = Resent) |
General Data Type: | VARCHAR2 |
ATLAS_VERSION
Seq. Order: | 3 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 3 |
Scale: | 2 |
Status: | Active |
Description: |
Version of atlas. This is initialized at each new installation. |
General Data Type: | NUMBER |
PREPARED_DATE_TIME
Seq. Order: | 4 |
---|---|
Data Storage Type: | DATE |
Max Length: | 7 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Timestamp posted by the iinitiating program. When a record set is prepared for transmission this attribute contains the system time. This need not necessiarily be accurate, but must be sequentially consistent. |
General Data Type: | DATE |
TEST_DATA_FLAG
Seq. Order: | 5 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Identifies a record set as test or production data. Defaults to (N)o - Data is Production |
General Data Type: | VARCHAR2 |
Catalog Details
Catalog Item ID: | 7357 |
---|---|
GUID: | gov.noaa.nmfs.inport:7357 |
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 |