Table: ATLW_RECORD_SET_STATUS
Entity (ENT) | Alaska Fisheries Science Center (AFSC)GUID: gov.noaa.nmfs.inport:7357 | Updated: August 9, 2022 | Published / External
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 |