Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
SEFSC Metadata Library > Sustainable Fisheries > Highly Migratory Species Branch > Recreational Billfish Survey > Recreational Billfish Survey (RBS) >

Table: CHANGES_HISTORY

Entity (ENT)  |  Southeast Fisheries Science Center (SEFSC)
GUID: gov.noaa.nmfs.inport:6230  |  Updated: August 9, 2022  |  Published / External 
Summary
Item Identification
Keywords
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

Audit/Changes Table

Description

Audit/Changes Table

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
ID
NUMBER 		Sequential Key To This Table
TOURNAMENT_CODE
NUMBER 		Tournament Code
TOURNAMENT_YEAR
NUMBER 		Year Tournament Took Place
REPORT_DATE
DATE 		Reporting Date
TABLE_NAME
VARCHAR2 		Table That was changed
COLUMN_NAME
VARCHAR2 		Column That was changed
OLD_VALUE
VARCHAR2 		Value That Was Changed
NEW_VALUE
VARCHAR2 		New Value (what it is changed to)
CHANGE_DATE
DATE 		Date/Time stamp Record Was Changed

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: CHANGES_HISTORY
Short Name: CHANGES_HISTORY
Status: Completed
Abstract:

Audit/Changes Table
Notes:

Loaded by batch 1863, 11-02-2007 09:24

Keywords

Theme Keywords

Thesaurus Keyword
UNCONTROLLED
None Data Audits

Entity Information

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

Audit/Changes Table

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 ID NUMBER Sequential Key To This Table
100
 TOURNAMENT_CODE NUMBER Tournament Code
100
 TOURNAMENT_YEAR NUMBER Year Tournament Took Place
100
 REPORT_DATE DATE Reporting Date
100
 TABLE_NAME VARCHAR2 Table That was changed
100
 COLUMN_NAME VARCHAR2 Column That was changed
100
 OLD_VALUE VARCHAR2 Value That Was Changed
100
 NEW_VALUE VARCHAR2 New Value (what it is changed to)
100
 CHANGE_DATE DATE Date/Time stamp Record Was Changed

Attribute Details

ID

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

Sequential Key To This Table
General Data Type: NUMBER

TOURNAMENT_CODE

CC ID: 20562
Seq. Order: 2
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Tournament Code
General Data Type: NUMBER

TOURNAMENT_YEAR

CC ID: 20563
Seq. Order: 3
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Year Tournament Took Place
General Data Type: NUMBER

REPORT_DATE

CC ID: 20564
Seq. Order: 4
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Reporting Date
General Data Type: DATE

TABLE_NAME

CC ID: 20565
Seq. Order: 5
Data Storage Type: VARCHAR2
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

Table That was changed
General Data Type: VARCHAR2

COLUMN_NAME

CC ID: 20566
Seq. Order: 6
Data Storage Type: VARCHAR2
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

Column That was changed
General Data Type: VARCHAR2

OLD_VALUE

CC ID: 20567
Seq. Order: 7
Data Storage Type: VARCHAR2
Max Length: 100
Required: No
Primary Key: No
Status: Active
Description:

Value That Was Changed
General Data Type: VARCHAR2

NEW_VALUE

CC ID: 20568
Seq. Order: 8
Data Storage Type: VARCHAR2
Max Length: 100
Required: No
Primary Key: No
Status: Active
Description:

New Value (what it is changed to)
General Data Type: VARCHAR2

CHANGE_DATE

CC ID: 20569
Seq. Order: 9
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Date/Time stamp Record Was Changed
General Data Type: DATE

Catalog Details

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