Slide Menu
Jump to Section...
Maintenance Notice: Tuesday May 21 @ 12pm-1:30pm Eastern. InPort and its associated services will be under maintenance and unavailable for the deployment of InPort Release 5.3.6. Downtime Schedule Tuesday, May 21, 2024 12:00pm - 1:30pm Eastern / 9:00am - 10:30am Pacific / 6:00am - 8:30am Hawaii Impacted Areas - InPort Website: https://www.fisheries.noaa.gov/inport - InPort WAF: h...
View All
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 

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