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: RBS_AUDIT

Entity (ENT)  |  Southeast Fisheries Science Center (SEFSC)
GUID: gov.noaa.nmfs.inport:6246  |  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
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)
ID
NUMBER 		Sequential Key To This Table
MODIFICATION_DATE
DATE 		Date/Time stamp of change
RATIONALE
VARCHAR2 		Reason For change
RECORD_ID
NUMBER 		Foreign Key to Record That was changed
MODIFIED_BY
VARCHAR2 		Id of changer of the record

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

Audit/Changes Table
Notes:

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

Keywords

Theme Keywords

Thesaurus Keyword
UNCONTROLLED
None Audit Tables

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
 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
 Primary Key ID NUMBER Sequential Key To This Table
100
 MODIFICATION_DATE DATE Date/Time stamp of change
100
 RATIONALE VARCHAR2 Reason For change
100
 RECORD_ID NUMBER Foreign Key to Record That was changed
100
 MODIFIED_BY VARCHAR2 Id of changer of the record

Attribute Details

TABLE_NAME

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

Table That was changed
General Data Type: VARCHAR2

COLUMN_NAME

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

Column That was changed
General Data Type: VARCHAR2

OLD_VALUE

CC ID: 20674
Seq. Order: 3
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: 20675
Seq. Order: 4
Data Storage Type: VARCHAR2
Max Length: 100
Required: Yes
Primary Key: No
Status: Active
Description:

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

ID

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

Sequential Key To This Table
General Data Type: NUMBER

MODIFICATION_DATE

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

Date/Time stamp of change
General Data Type: DATE

RATIONALE

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

Reason For change
General Data Type: VARCHAR2

RECORD_ID

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

Foreign Key to Record That was changed
General Data Type: NUMBER

MODIFIED_BY

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

Id of changer of the record
General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 6246
GUID: gov.noaa.nmfs.inport:6246
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