Table: CODE_COLUMNS
Entity (ENT) | Southeast Fisheries Science Center (SEFSC)GUID: gov.noaa.nmfs.inport:5285 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
A control table that shows for each table what columns are editable in the code maintenance modules.
DescriptionA control table that shows for each table what columns are editable in the code maintenance modules.
Entity Information
Entity Type
Data Table
Data Attribute / Type | Description |
---|---|
TABLE_NAME
VARCHAR2 |
The name of the table user can edit in the code maintenance module. |
COLUMN_NAME
VARCHAR2 |
The name of the column in the table that user can edit in the code maintenance module. |
DATA_TYPE
VARCHAR2 |
The data type (i.e. number, date, varchar2, ...) of the column in the table that user can edit in the code maintenance module. |
DATA_LENGTH
NUMBER |
The data length of the column in the table that user can edit in the code maintenance module. |
NULLABLE
VARCHAR2 |
Nullable (Y=yes, N=No) for whether null values are allowed in the column in the table that user can edit in the code maintenance module. |
COL_SCREEN_ORDER
NUMBER |
The order in which the column will appear on screen in the code maintenance module. |
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_COLUMNS |
---|---|
Short Name: | CODE_COLUMNS |
Status: | Completed |
Abstract: |
A control table that shows for each table what columns are editable in the code maintenance modules. |
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 shows for each table what columns are editable in the code maintenance modules. |
Data Attributes
Attribute Summary
Name | Type | Description | ||
---|---|---|---|---|
100
|
TABLE_NAME | VARCHAR2 | The name of the table user can edit in the code maintenance module. | |
100
|
COLUMN_NAME | VARCHAR2 | The name of the column in the table that user can edit in the code maintenance module. | |
100
|
DATA_TYPE | VARCHAR2 | The data type (i.e. number, date, varchar2, ...) of the column in the table that user can edit in the code maintenance module. | |
100
|
DATA_LENGTH | NUMBER | The data length of the column in the table that user can edit in the code maintenance module. | |
100
|
NULLABLE | VARCHAR2 | Nullable (Y=yes, N=No) for whether null values are allowed in the column in the table that user can edit in the code maintenance module. | |
100
|
COL_SCREEN_ORDER | NUMBER | The order in which the column will appear on screen in the code maintenance module. |
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 user can edit in the code maintenance module. |
General Data Type: | VARCHAR2 |
COLUMN_NAME
Seq. Order: | 2 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 30 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
The name of the column in the table that user can edit in the code maintenance module. |
General Data Type: | VARCHAR2 |
DATA_TYPE
Seq. Order: | 3 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 106 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The data type (i.e. number, date, varchar2, ...) of the column in the table that user can edit in the code maintenance module. |
General Data Type: | VARCHAR2 |
DATA_LENGTH
Seq. Order: | 4 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
The data length of the column in the table that user can edit in the code maintenance module. |
General Data Type: | NUMBER |
NULLABLE
Seq. Order: | 5 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Nullable (Y=yes, N=No) for whether null values are allowed in the column in the table that user can edit in the code maintenance module. |
General Data Type: | VARCHAR2 |
COL_SCREEN_ORDER
Seq. Order: | 6 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
The order in which the column will appear on screen in the code maintenance module. |
General Data Type: | NUMBER |
Catalog Details
Catalog Item ID: | 5285 |
---|---|
GUID: | gov.noaa.nmfs.inport:5285 |
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 |