Metadata Rubric

100%

6 / 6

SEFSC Metadata Library > Social Science Research Group Projects > Economic Data Collections for Gulf of Mexico &... > Economic Data Collection for Gulf of Mexico Sou... >

Table: CODES_SEARCH

Entity (ENT) | Southeast Fisheries Science Center (SEFSC)
GUID: gov.noaa.nmfs.inport:5284 | Updated: August 9, 2022 | Published / External

Summary

Item Identification

Entity Info

Data Attributes

Catalog Details

Abstract

A control table for storing the last search query for a user.

Description

A control table for storing the last search query for a user.

Entity Type
Data Table

Data Attribute / Type	Description
USERNAME VARCHAR2	The user making the query.
TABLE_NAME VARCHAR2	The name of the table being queried
COLUMN_NAME1 VARCHAR2	The name of the first column used to filter the results.
DATA_TYPE1 VARCHAR2	The data type of the first column used to filter the results.
OPERATOR1 VARCHAR2	The operator applied to the first column used to filter the results.
COLUMN_VALUE1 VARCHAR2	The search value for the first column used to filter the results.
LOGICAL_OPERATOR VARCHAR2	The logical operator (AND \| OR) used when query includes 2 query clauses.
COLUMN_NAME2 VARCHAR2	The name of the second column used to filter the results.
DATA_TYPE2 VARCHAR2	The data type of the second column used to filter the results.
OPERATOR2 VARCHAR2	The operator applied to the second column used to filter the results.
COLUMN_VALUE2 VARCHAR2	The operator applied to the second column used to filter the results.
SORT1 VARCHAR2	The first column used to sort results by.
ASCDESC1 VARCHAR2	Whether the first sort field is in ASCENDING (ASC) or DESCENDING (DESC) order.
SORT2 VARCHAR2	The second column used to sort results by.
ASCDESC2 VARCHAR2	Whether the second sort field is in ASCENDING (ASC) or DESCENDING (DESC) order.

Data Attribute / Type

Description

USERNAME
VARCHAR2

The user making the query.

TABLE_NAME
VARCHAR2

The name of the table being queried

COLUMN_NAME1
VARCHAR2

The name of the first column used to filter the results.

DATA_TYPE1
VARCHAR2

The data type of the first column used to filter the results.

OPERATOR1
VARCHAR2

The operator applied to the first column used to filter the results.

COLUMN_VALUE1
VARCHAR2

The search value for the first column used to filter the results.

LOGICAL_OPERATOR
VARCHAR2

The logical operator (AND | OR) used when query includes 2 query clauses.

COLUMN_NAME2
VARCHAR2

The name of the second column used to filter the results.

DATA_TYPE2
VARCHAR2

The data type of the second column used to filter the results.

OPERATOR2
VARCHAR2

The operator applied to the second column used to filter the results.

COLUMN_VALUE2
VARCHAR2

The operator applied to the second column used to filter the results.

SORT1
VARCHAR2

The first column used to sort results by.

ASCDESC1
VARCHAR2

Whether the first sort field is in ASCENDING (ASC) or DESCENDING (DESC) order.

SORT2
VARCHAR2

The second column used to sort results by.

ASCDESC2
VARCHAR2

Whether the second sort field is in ASCENDING (ASC) or DESCENDING (DESC) order.

No Child Items for this record.

No contact information is available for this record.

Please contact the owner organization (SEFSC) for inquiries on this record.

Title:	Table: CODES_SEARCH
Short Name:	CODES_SEARCH
Status:	Completed
Abstract:	A control table for storing the last search query for a user.
Notes:	Loaded by batch 1643, 10-10-2007 10:43

Entity Type:	Data Table
Active Version?:	Yes
Schema Name:	EC_SRV_GS
Description:	A control table for storing the last search query for a user.

Attribute Summary

	Name	Type	Description
100	USERNAME	VARCHAR2	The user making the query.
100	TABLE_NAME	VARCHAR2	The name of the table being queried
100	COLUMN_NAME1	VARCHAR2	The name of the first column used to filter the results.
100	DATA_TYPE1	VARCHAR2	The data type of the first column used to filter the results.
100	OPERATOR1	VARCHAR2	The operator applied to the first column used to filter the results.
100	COLUMN_VALUE1	VARCHAR2	The search value for the first column used to filter the results.
100	LOGICAL_OPERATOR	VARCHAR2	The logical operator (AND \| OR) used when query includes 2 query clauses.
100	COLUMN_NAME2	VARCHAR2	The name of the second column used to filter the results.
100	DATA_TYPE2	VARCHAR2	The data type of the second column used to filter the results.
100	OPERATOR2	VARCHAR2	The operator applied to the second column used to filter the results.
100	COLUMN_VALUE2	VARCHAR2	The operator applied to the second column used to filter the results.
100	SORT1	VARCHAR2	The first column used to sort results by.
100	ASCDESC1	VARCHAR2	Whether the first sort field is in ASCENDING (ASC) or DESCENDING (DESC) order.
100	SORT2	VARCHAR2	The second column used to sort results by.
100	ASCDESC2	VARCHAR2	Whether the second sort field is in ASCENDING (ASC) or DESCENDING (DESC) order.

Name

Type

Description

100

USERNAME

VARCHAR2

The user making the query.

100

TABLE_NAME

VARCHAR2

The name of the table being queried

100

COLUMN_NAME1

VARCHAR2

The name of the first column used to filter the results.

100

DATA_TYPE1

VARCHAR2

The data type of the first column used to filter the results.

100

OPERATOR1

VARCHAR2

The operator applied to the first column used to filter the results.

100

COLUMN_VALUE1

VARCHAR2

The search value for the first column used to filter the results.

100

LOGICAL_OPERATOR

VARCHAR2

The logical operator (AND | OR) used when query includes 2 query clauses.

100

COLUMN_NAME2

VARCHAR2

The name of the second column used to filter the results.

100

DATA_TYPE2

VARCHAR2

The data type of the second column used to filter the results.

100

OPERATOR2

VARCHAR2

The operator applied to the second column used to filter the results.

100

COLUMN_VALUE2

VARCHAR2

The operator applied to the second column used to filter the results.

100

SORT1

VARCHAR2

The first column used to sort results by.

100

ASCDESC1

VARCHAR2

Whether the first sort field is in ASCENDING (ASC) or DESCENDING (DESC) order.

100

SORT2

VARCHAR2

The second column used to sort results by.

100

ASCDESC2

VARCHAR2

Whether the second sort field is in ASCENDING (ASC) or DESCENDING (DESC) order.

Attribute Details

USERNAME

CC ID: 15343

Seq. Order:	1
Data Storage Type:	VARCHAR2
Max Length:	30
Required:	Yes
Primary Key:	No
Status:	Active
Description:	The user making the query.
General Data Type:	VARCHAR2

TABLE_NAME

CC ID: 15342

Seq. Order:	2
Data Storage Type:	VARCHAR2
Max Length:	100
Required:	No
Primary Key:	No
Status:	Active
Description:	The name of the table being queried
General Data Type:	VARCHAR2

COLUMN_NAME1

CC ID: 15341

Seq. Order:	3
Data Storage Type:	VARCHAR2
Max Length:	100
Required:	No
Primary Key:	No
Status:	Active
Description:	The name of the first column used to filter the results.
General Data Type:	VARCHAR2

DATA_TYPE1

CC ID: 15340

Seq. Order:	4
Data Storage Type:	VARCHAR2
Max Length:	100
Required:	No
Primary Key:	No
Status:	Active
Description:	The data type of the first column used to filter the results.
General Data Type:	VARCHAR2

OPERATOR1

CC ID: 15339

Seq. Order:	5
Data Storage Type:	VARCHAR2
Max Length:	20
Required:	No
Primary Key:	No
Status:	Active
Description:	The operator applied to the first column used to filter the results.
General Data Type:	VARCHAR2

COLUMN_VALUE1

CC ID: 15338

Seq. Order:	6
Data Storage Type:	VARCHAR2
Max Length:	200
Required:	No
Primary Key:	No
Status:	Active
Description:	The search value for the first column used to filter the results.
General Data Type:	VARCHAR2

LOGICAL_OPERATOR

CC ID: 15337

Seq. Order:	7
Data Storage Type:	VARCHAR2
Max Length:	20
Required:	No
Primary Key:	No
Status:	Active
Description:	The logical operator (AND \| OR) used when query includes 2 query clauses.
General Data Type:	VARCHAR2

COLUMN_NAME2

CC ID: 15336

Seq. Order:	8
Data Storage Type:	VARCHAR2
Max Length:	100
Required:	No
Primary Key:	No
Status:	Active
Description:	The name of the second column used to filter the results.
General Data Type:	VARCHAR2

DATA_TYPE2

CC ID: 15335

Seq. Order:	9
Data Storage Type:	VARCHAR2
Max Length:	100
Required:	No
Primary Key:	No
Status:	Active
Description:	The data type of the second column used to filter the results.
General Data Type:	VARCHAR2

OPERATOR2

CC ID: 15334

Seq. Order:	10
Data Storage Type:	VARCHAR2
Max Length:	20
Required:	No
Primary Key:	No
Status:	Active
Description:	The operator applied to the second column used to filter the results.
General Data Type:	VARCHAR2

COLUMN_VALUE2

CC ID: 15333

Seq. Order:	11
Data Storage Type:	VARCHAR2
Max Length:	200
Required:	No
Primary Key:	No
Status:	Active
Description:	The operator applied to the second column used to filter the results.
General Data Type:	VARCHAR2

SORT1

CC ID: 15332

Seq. Order:	12
Data Storage Type:	VARCHAR2
Max Length:	100
Required:	No
Primary Key:	No
Status:	Active
Description:	The first column used to sort results by.
General Data Type:	VARCHAR2

ASCDESC1

CC ID: 15331

Seq. Order:	13
Data Storage Type:	VARCHAR2
Max Length:	5
Required:	No
Primary Key:	No
Status:	Active
Description:	Whether the first sort field is in ASCENDING (ASC) or DESCENDING (DESC) order.
General Data Type:	VARCHAR2

SORT2

CC ID: 15330

Seq. Order:	14
Data Storage Type:	VARCHAR2
Max Length:	100
Required:	No
Primary Key:	No
Status:	Active
Description:	The second column used to sort results by.
General Data Type:	VARCHAR2

ASCDESC2

CC ID: 15329

Seq. Order:	15
Data Storage Type:	VARCHAR2
Max Length:	5
Required:	No
Primary Key:	No
Status:	Active
Description:	Whether the second sort field is in ASCENDING (ASC) or DESCENDING (DESC) order.
General Data Type:	VARCHAR2

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

Table: CODES_SEARCH

Summary

Entity Information

Child Items

Contact Information

Item Identification

Entity Information

Data Attributes

Attribute Summary

Attribute Details

USERNAME

TABLE_NAME

COLUMN_NAME1

DATA_TYPE1

OPERATOR1

COLUMN_VALUE1

LOGICAL_OPERATOR

COLUMN_NAME2

DATA_TYPE2

OPERATOR2

COLUMN_VALUE2

SORT1

ASCDESC1

SORT2

ASCDESC2

Catalog Details