APP_CHANGEREASON_LOV
Entity (ENT) | Northwest Fisheries Science Center (NWFSC)GUID: gov.noaa.nmfs.inport:32690 | Updated: August 9, 2022 | Published / External
Item Identification
Title: | APP_CHANGEREASON_LOV |
---|---|
Short Name: | APP_CHANGEREASON_LOV |
Status: | Planned |
Abstract: |
Table used by the SPS web application to track reasons why data has been updated. |
Entity Information
Entity Type: | Data Table |
---|---|
Active Version?: | Yes |
Schema Name: | SPS |
Description: |
Table used by the SPS web application to track reasons why data has been updated. |
Data Attributes
Attribute Summary
![]() |
![]() |
Name | Type | Description |
---|---|---|---|---|
100
|
![]() |
ID | NUMBER | 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. |
100
|
REASON | VARCHAR2 | 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). | |
100
|
ACTION_TYPE | VARCHAR2 | Short code used by the application. |
Attribute Details
ID
CC ID: 324117
Data Storage Type: | NUMBER |
---|---|
Max Length: | 22 |
Required: | Yes |
Primary Key: | Yes |
Status: | Active |
Description: |
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. |
General Data Type: | NUMBER |
REASON
CC ID: 324118
Data Storage Type: | VARCHAR2 |
---|---|
Max Length: | 200 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
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). |
General Data Type: | VARCHAR2 |
ACTION_TYPE
CC ID: 324119
Data Storage Type: | VARCHAR2 |
---|---|
Max Length: | 20 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Short code used by the application. |
General Data Type: | VARCHAR2 |
Catalog Details
Catalog Item ID: | 32690 |
---|---|
GUID: | gov.noaa.nmfs.inport:32690 |
Metadata Record Created By: | Jeffrey W Cowen |
Metadata Record Created: | 2016-05-09 14:19+0000 |
Metadata Record Last Modified By: | SysAdmin InPortAdmin |
Metadata Record Last Modified: | 2022-08-09 17:11+0000 |
Metadata Record Published: | 2016-05-11 |
Owner Org: | NWFSC |
Metadata Publication Status: | Published Externally |
Do Not Publish?: | N |
Metadata Last Review Date: | 2016-05-11 |
Metadata Review Frequency: | 1 Year |
Metadata Next Review Date: | 2017-05-11 |