7358
Table: ATLW_RECORD_STATUS
ATLW_RECORD_STATUS
Entity
Published / External
7284
AFSC/FMA/North Pacific Groundfish and Halibut Observer Program, Post 2008 Fishery Statistics.
Data Set
Completed
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.
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.
Loaded by batch 2164, 03-27-2008 10:42
Data Table
Yes
NORPAC
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.
1
RECORD_STATUS_SEQ
NUMBER
22
Yes
Yes
9
0
Active
Sequence Generated Unique Identifier for records that are currently queued for loading.
NUMBER
2
RECORD_SET_STATUS_SEQ
NUMBER
22
Yes
Yes
9
0
Active
Sequence generated unique identifier of a record set header
NUMBER
3
CRUISE
NUMBER
22
Yes
Yes
8
0
Active
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.
NUMBER
4
TABLE_NAME
VARCHAR2
30
Yes
No
Active
Table name from which a record is inserted, updated or deleted.
VARCHAR2
5
PK1_COLUMN_NAME
VARCHAR2
30
Yes
No
Active
Primary key column name for the referenced table.
VARCHAR2
6
PK1_VALUE
VARCHAR2
9
Yes
No
Active
Primary key column value for the referenced table.
VARCHAR2
7
PK2_COLUMN_NAME
VARCHAR2
30
No
No
Active
Compound primary key column name for the referenced table.
VARCHAR2
8
PK2_VALUE
VARCHAR2
9
No
No
Active
Compound primary key column value for the referenced table.
VARCHAR2
9
STATUS_CODE
VARCHAR2
1
Yes
No
Active
This attribute identifies the action taken on this record. Valid Values I = Insert, U = Update, D = delete
VARCHAR2
10
TRANSMISSION_RECEIVED_DATE
DATE
7
No
No
Active
Timestamp for the date that the record status was loaded into the working tables.
DATE
gov.noaa.nmfs.inport:7358
Doug Turnbull
2008-03-27T10:42:08
SysAdmin InPortAdmin
2022-08-09T17:11:02
2018-09-26
Alaska Fisheries Science Center
AFSC
7600 Sand Point Way N.E., Building 4
Seattle
WA
98115
USA
http://www.afsc.noaa.gov
0700-1700 Pacific Time
1001
Public
No
2018-09-26
1 Year
2019-09-26