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

Summary

Abstract

Lists Possible Reason Data is changed

Description

Lists Possible Reason Data is changed

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
CHANGE_REASON_ID
NUMBER
A numeric code for the change reason
CHANGE_REASON_NAME
VARCHAR2
Mnemonic Of Change Reason
CHANGE_REASON_DESC
VARCHAR2
Longer Description Of The Change Reason
IS_ACTIVE_FLAG
NUMBER
Is this record active

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

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

Item Identification

Title: Table: EDC_CHANGE_REASON
Short Name: EDC_CHANGE_REASON
Status: Completed
Abstract:

Lists Possible Reason Data is changed

Notes:

Loaded by batch 2043, 12-20-2007 08:10

Physical Location

Organization: Southeast Fisheries Science Center
City: Miami
State/Province: FL
Country: USA

Entity Information

Entity Type: Data Table
Active Version?: Yes
Schema Name: FLS
Description:

Lists Possible Reason Data is changed

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key CHANGE_REASON_ID NUMBER A numeric code for the change reason
100
CHANGE_REASON_NAME VARCHAR2 Mnemonic Of Change Reason
100
CHANGE_REASON_DESC VARCHAR2 Longer Description Of The Change Reason
100
IS_ACTIVE_FLAG NUMBER Is this record active

Attribute Details

CHANGE_REASON_ID

CC ID: 24524
Seq. Order: 1
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: Yes
Precision: 38
Status: Active
Description:

A numeric code for the change reason

General Data Type: NUMBER

CHANGE_REASON_NAME

CC ID: 24525
Seq. Order: 2
Data Storage Type: VARCHAR2
Max Length: 40
Required: Yes
Primary Key: No
Status: Active
Description:

Mnemonic Of Change Reason

General Data Type: VARCHAR2

CHANGE_REASON_DESC

CC ID: 24526
Seq. Order: 3
Data Storage Type: VARCHAR2
Max Length: 200
Required: No
Primary Key: No
Status: Active
Description:

Longer Description Of The Change Reason

General Data Type: VARCHAR2

IS_ACTIVE_FLAG

CC ID: 24527
Seq. Order: 4
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 1
Scale: 0
Status: Active
Description:

Is this record active

General Data Type: NUMBER

Catalog Details

Catalog Item ID: 6852
GUID: gov.noaa.nmfs.inport:6852
Metadata Record Created By: Lee M Weinberger
Metadata Record Created: 2007-12-20 08:10+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:10+0000
Metadata Record Published: 2021-05-07
Owner Org: SEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2021-05-07
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2022-05-07