32697
RECORD_HISTORY
RECORD_HISTORY
Entity
Published / External
17904
SPS Abundance - Salmon spawner abundance data compilation and database management
Data Set
Planned
Stores journaled row-level transactions (insert, update, delete) performed on tables with BIUDR journaling triggers.
Data Table
Yes
SPS
Stores journaled row-level transactions (insert, update, delete) performed on tables with BIUDR journaling triggers.
ACTION
VARCHAR2
30
No
No
Active
What action occurred to create this history record?
VARCHAR2
COL_TIMESTAMP
TIMESTAMP(4)
11
No
No
Active
4 decimal second at which the history record was created.
TIMESTAMP(4)
DATESTAMP
DATE
7
No
No
Active
Date of the history record creation.
DATE
HISTORY
CLOB
4000
No
No
Active
Statement describing how THIS RECORD was changed by this transaction including WHEN and by WHOM.
CLOB
USERNAME
VARCHAR2
60
No
No
Active
User that has performed the action resulting in the history record creation.,
VARCHAR2
KEY_ID
NUMBER
22
No
No
Active
Primary key of the record for which this history record applies.
NUMBER
SCHEMA_NAME
VARCHAR2
30
No
No
Active
Database schema in which the table exists.
VARCHAR2
TABLE_NAME
VARCHAR2
30
No
No
Active
Name of the table for the history record.
VARCHAR2
KEY_COLUMN
VARCHAR2
30
No
No
Active
Name of the primary key column.
VARCHAR2
gov.noaa.nmfs.inport:32697
Jeffrey Cowen
2016-05-09T14:19:54
SysAdmin InPortAdmin
2022-08-09T17:11:00
2016-05-11
Northwest Fisheries Science Center
NWFSC
2725 Montlake Boulevard East
Seattle
WA
98112
USA
206-860-3200
http://www.nwfsc.noaa.gov
1001
Public
No
2016-05-11
1 Year
2017-05-11