Slide Menu
System Maintenance Notice, Sunday, January 23, 2022 @ 8am-2pm Eastern. The Operations Team will be performing system maintenance on all server environments. During this scheduled downtime, InPort will not be available.
View All
Search Help Show/Hide Menu

Item Identification

Title: Table: TIP_CODES_SEARCH
Short Name: TIP_CODES_SEARCH
Status: Completed
Abstract:

COntrol Table used for the searching of codes and specifying the order for which the codes may be displayed.

Notes:

Loaded by batch 2005, 12-03-2007 10:12

Entity Information

Entity Type: Data Table
Active Version?: Yes
Schema Name: TIPONLINE
Description:

COntrol Table used for the searching of codes and specifying the order for which the codes may be displayed.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
USERNAME VARCHAR2 USERNAME Used in query for Code Search
100
TABLE_NAME VARCHAR2 Table of Oracle Table searched.
100
COLUMN_NAME1 VARCHAR2 First Column Name
100
DATA_TYPE1 VARCHAR2 Dta Type Of First Column
100
OPERATOR1 VARCHAR2 Mathematical Operator to use for the first search condition
100
COLUMN_VALUE1 VARCHAR2 Data Value For First Column
100
LOGICAL_OPERATOR VARCHAR2 Logical operator to use for sort
100
COLUMN_NAME2 VARCHAR2 Second Column Name
100
DATA_TYPE2 VARCHAR2 Data Type of the second column
100
OPERATOR2 VARCHAR2 Logical Operator
100
COLUMN_VALUE2 VARCHAR2 Data Value For Second Column
100
SORT1 VARCHAR2 First Column used for sort
100
ASCDESC1 VARCHAR2 Specifies whether first sort is ascending or descending
100
SORT2 VARCHAR2 Second Column used for court
100
ASCDESC2 VARCHAR2 Specifies whether seconf sort is ascending or descending

Attribute Details

USERNAME

CC ID: 22750
Seq. Order: 1
Data Storage Type: VARCHAR2
Max Length: 30
Required: Yes
Primary Key: No
Status: Active
Description:

USERNAME Used in query for Code Search

General Data Type: VARCHAR2

TABLE_NAME

CC ID: 22751
Seq. Order: 2
Data Storage Type: VARCHAR2
Max Length: 100
Required: No
Primary Key: No
Status: Active
Description:

Table of Oracle Table searched.

General Data Type: VARCHAR2

COLUMN_NAME1

CC ID: 22752
Seq. Order: 3
Data Storage Type: VARCHAR2
Max Length: 100
Required: No
Primary Key: No
Status: Active
Description:

First Column Name

General Data Type: VARCHAR2

DATA_TYPE1

CC ID: 22753
Seq. Order: 4
Data Storage Type: VARCHAR2
Max Length: 100
Required: No
Primary Key: No
Status: Active
Description:

Dta Type Of First Column

General Data Type: VARCHAR2

OPERATOR1

CC ID: 22754
Seq. Order: 5
Data Storage Type: VARCHAR2
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

Mathematical Operator to use for the first search condition

General Data Type: VARCHAR2

COLUMN_VALUE1

CC ID: 22755
Seq. Order: 6
Data Storage Type: VARCHAR2
Max Length: 200
Required: No
Primary Key: No
Status: Active
Description:

Data Value For First Column

General Data Type: VARCHAR2

LOGICAL_OPERATOR

CC ID: 22756
Seq. Order: 7
Data Storage Type: VARCHAR2
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

Logical operator to use for sort

General Data Type: VARCHAR2

COLUMN_NAME2

CC ID: 22757
Seq. Order: 8
Data Storage Type: VARCHAR2
Max Length: 100
Required: No
Primary Key: No
Status: Active
Description:

Second Column Name

General Data Type: VARCHAR2

DATA_TYPE2

CC ID: 22758
Seq. Order: 9
Data Storage Type: VARCHAR2
Max Length: 100
Required: No
Primary Key: No
Status: Active
Description:

Data Type of the second column

General Data Type: VARCHAR2

OPERATOR2

CC ID: 22759
Seq. Order: 10
Data Storage Type: VARCHAR2
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

Logical Operator

General Data Type: VARCHAR2

COLUMN_VALUE2

CC ID: 22760
Seq. Order: 11
Data Storage Type: VARCHAR2
Max Length: 200
Required: No
Primary Key: No
Status: Active
Description:

Data Value For Second Column

General Data Type: VARCHAR2

SORT1

CC ID: 22761
Seq. Order: 12
Data Storage Type: VARCHAR2
Max Length: 100
Required: No
Primary Key: No
Status: Active
Description:

First Column used for sort

General Data Type: VARCHAR2

ASCDESC1

CC ID: 22762
Seq. Order: 13
Data Storage Type: VARCHAR2
Max Length: 5
Required: No
Primary Key: No
Status: Active
Description:

Specifies whether first sort is ascending or descending

General Data Type: VARCHAR2

SORT2

CC ID: 22763
Seq. Order: 14
Data Storage Type: VARCHAR2
Max Length: 100
Required: No
Primary Key: No
Status: Active
Description:

Second Column used for court

General Data Type: VARCHAR2

ASCDESC2

CC ID: 22764
Seq. Order: 15
Data Storage Type: VARCHAR2
Max Length: 5
Required: No
Primary Key: No
Status: Active
Description:

Specifies whether seconf sort is ascending or descending

General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 6602
GUID: gov.noaa.nmfs.inport:6602
Metadata Record Created By: Lee M Weinberger
Metadata Record Created: 2007-12-03 10:12+0000
Metadata Record Last Modified By: Lee M Weinberger
Metadata Record Last Modified: 2021-11-04 13:14+0000
Metadata Record Published: 2021-11-04
Owner Org: SEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2022-11-05