32690
APP_CHANGEREASON_LOV
APP_CHANGEREASON_LOV
Entity
Published / External
17904
SPS Abundance - Salmon spawner abundance data compilation and database management
Data Set
Planned
Table used by the SPS web application to track reasons why data has been updated.
Data Table
Yes
SPS
Table used by the SPS web application to track reasons why data has been updated.
ACTION_TYPE
VARCHAR2
20
No
No
Active
Short code used by the application.
VARCHAR2
REASON
VARCHAR2
200
No
No
Active
A description of why the data was changed. Acceptable values are: Recalculated data, Obtained updated legacy data, Obtained new data and added, Low confidence in data and deleted, Other (Explain in the Edit Note).
VARCHAR2
ID
NUMBER
22
Yes
Yes
Active
Database-generated primary key (unique identifier) for each APP_CHANGEREASON_LOV record, created by an internal sequence generator and used by the database to maintain referential integrity. This ID is not designed to be managed by users. This primary key constraint is named APP_CHANGEREASON_LOV_PK.
NUMBER
gov.noaa.nmfs.inport:32690
Jeffrey Cowen
2016-05-09T14:19:46
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