Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
SEFSC Metadata Library > Social Science Research Group Projects > Economic Data Collections for Gulf of Mexico &... > Economic Data Collection for Gulf of Mexico Sou... >

Table: CODE_TABLE_LIST

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

Summary

Abstract

A control table that controls what tables are viewable and editable from the code maintenance module.

Description

A control table that controls what tables are viewable and editable from the code maintenance module.

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
TABLE_NAME
VARCHAR2 		The name of the table viewable or editable by the code maintenance module.
DATA_MANAGER
VARCHAR2 		The highest access given to the role of data manager for this table: N=none,V=view only,E=Editable
DATA_ENTRY
VARCHAR2 		The highest access given to the role of data entry for this table: N=none,V=view only,E=Editable
ADMINISTRATOR
VARCHAR2 		The highest access given to the role of administrator for this table: N=none,V=view only,E=Editable
IS_PUBLIC
VARCHAR2 		Whether this table is public, YES or NO
CREATED_BY_USER_ID
VARCHAR2 		A control field listing the user_id of the record creator.
CREATED_DATE
DATE 		A control field listing the system time when the record was created.
MODIFIED_BY_USER_ID
VARCHAR2 		A control field listing the user_id of the person modifying the record.
MODIFIED_DATE
DATE 		A control field listing the system time when the record was last modfied.

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

A control table that controls what tables are viewable and editable from the code maintenance module.
Notes:

Loaded by batch 1643, 10-10-2007 10:43

Entity Information

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

A control table that controls what tables are viewable and editable from the code maintenance module.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 TABLE_NAME VARCHAR2 The name of the table viewable or editable by the code maintenance module.
100
 DATA_MANAGER VARCHAR2 The highest access given to the role of data manager for this table: N=none,V=view only,E=Editable
100
 DATA_ENTRY VARCHAR2 The highest access given to the role of data entry for this table: N=none,V=view only,E=Editable
100
 ADMINISTRATOR VARCHAR2 The highest access given to the role of administrator for this table: N=none,V=view only,E=Editable
100
 IS_PUBLIC VARCHAR2 Whether this table is public, YES or NO
100
 CREATED_BY_USER_ID VARCHAR2 A control field listing the user_id of the record creator.
100
 CREATED_DATE DATE A control field listing the system time when the record was created.
100
 MODIFIED_BY_USER_ID VARCHAR2 A control field listing the user_id of the person modifying the record.
100
 MODIFIED_DATE DATE A control field listing the system time when the record was last modfied.

Attribute Details

TABLE_NAME

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

The name of the table viewable or editable by the code maintenance module.
General Data Type: VARCHAR2

DATA_MANAGER

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

The highest access given to the role of data manager for this table: N=none,V=view only,E=Editable
General Data Type: VARCHAR2

DATA_ENTRY

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

The highest access given to the role of data entry for this table: N=none,V=view only,E=Editable
General Data Type: VARCHAR2

ADMINISTRATOR

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

The highest access given to the role of administrator for this table: N=none,V=view only,E=Editable
General Data Type: VARCHAR2

IS_PUBLIC

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

Whether this table is public, YES or NO
General Data Type: VARCHAR2

CREATED_BY_USER_ID

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

A control field listing the user_id of the record creator.
General Data Type: VARCHAR2

CREATED_DATE

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

A control field listing the system time when the record was created.
General Data Type: DATE

MODIFIED_BY_USER_ID

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

A control field listing the user_id of the person modifying the record.
General Data Type: VARCHAR2

MODIFIED_DATE

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

A control field listing the system time when the record was last modfied.
General Data Type: DATE

Catalog Details

Catalog Item ID: 5286
GUID: gov.noaa.nmfs.inport:5286
Metadata Record Created By: Lee M Weinberger
Metadata Record Created: 2007-10-10 10:43+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+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