Search Help Show/Hide Menu
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

Table used by the SPS web application to track reasons why data has been updated.

Description

Table used by the SPS web application to track reasons why data has been updated.

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
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.
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).
ACTION_TYPE
VARCHAR2
Short code used by the application.

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

Please contact the owner organization (NWFSC) for inquiries on this record.

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

Rubric Score Primary Key? Name Type Description
100
Primary Key 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