Table: CODE_TABLE_LIST
Entity (ENT) | Southeast Fisheries Science Center (SEFSC)GUID: gov.noaa.nmfs.inport:5286 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
A control table that controls what tables are viewable and editable from the code maintenance module.
DescriptionA 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
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
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
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
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
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
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
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
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
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
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 |