Table: CODES_SEARCH
Entity (ENT) | Southeast Fisheries Science Center (SEFSC)GUID: gov.noaa.nmfs.inport:5284 | Updated: August 9, 2022 | Published / External
Item Identification
| 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 Information
| 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. |
Data Attributes
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. |
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 Details
| 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 |