Table: TIP_CODES_SEARCH

Southeast Fisheries Science Center
Entity (ENT) | ID: 6602 | Published / External
Created: 2007-12-03   |   Last Modified: 2021-11-04

Parent: TIPONLINE Control Table
Data Set (DS) | ID: 6572

ID: 6602
Entity (ENT)

* Discovery
• First Pass
» Metadata Rubric

Item Identification

* » Title Table: TIP_CODES_SEARCH
Short Name TIP_CODES_SEARCH
* Status Completed
Creation Date  
Revision Date  
• Publication Date  
* » Abstract

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

Loaded by batch 2005, 12-03-2007 10:12
Other Citation Details
• Supplemental Information
DOI (Digital Object Identifier)  
DOI Registration Authority  
DOI Issue Date  

Keywords

Theme Keywords

Thesaurus Keyword
   
   
   

Temporal Keywords

Thesaurus Keyword
   
   
   

* Spatial Keywords

Thesaurus Keyword
   
   
   

Stratum Keywords

Thesaurus Keyword
   
   
   

Instrument Keywords

Thesaurus Keyword
   
   
   

Platform Keywords

Thesaurus Keyword
   
   
   

Physical Location

• » Organization  
• » City  
• » State/Province  
• Country  
• » Location Description

Entity Information

Entity Type Data Table
Active Version? Y
Alias  
Schema Name TIPONLINE
» Description

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

Data Attributes

Attribute Summary

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

Attribute Details

Attribute Name USERNAME
Seq. Order 1
Data Storage Type VARCHAR2
Max Length 30
Min Length  
Required Yes
Primary Key No
Precision  
Scale  
Status Active
Description

USERNAME Used in query for Code Search
General Data Type VARCHAR2
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name TABLE_NAME
Seq. Order 2
Data Storage Type VARCHAR2
Max Length 100
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

Table of Oracle Table searched.
General Data Type VARCHAR2
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name COLUMN_NAME1
Seq. Order 3
Data Storage Type VARCHAR2
Max Length 100
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

First Column Name
General Data Type VARCHAR2
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name DATA_TYPE1
Seq. Order 4
Data Storage Type VARCHAR2
Max Length 100
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

Dta Type Of First Column
General Data Type VARCHAR2
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name OPERATOR1
Seq. Order 5
Data Storage Type VARCHAR2
Max Length 20
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

Mathematical Operator to use for the first search condition
General Data Type VARCHAR2
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name COLUMN_VALUE1
Seq. Order 6
Data Storage Type VARCHAR2
Max Length 200
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

Data Value For First Column
General Data Type VARCHAR2
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name LOGICAL_OPERATOR
Seq. Order 7
Data Storage Type VARCHAR2
Max Length 20
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

Logical operator to use for sort
General Data Type VARCHAR2
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name COLUMN_NAME2
Seq. Order 8
Data Storage Type VARCHAR2
Max Length 100
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

Second Column Name
General Data Type VARCHAR2
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name DATA_TYPE2
Seq. Order 9
Data Storage Type VARCHAR2
Max Length 100
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

Data Type of the second column
General Data Type VARCHAR2
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name OPERATOR2
Seq. Order 10
Data Storage Type VARCHAR2
Max Length 20
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

Logical Operator
General Data Type VARCHAR2
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name COLUMN_VALUE2
Seq. Order 11
Data Storage Type VARCHAR2
Max Length 200
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

Data Value For Second Column
General Data Type VARCHAR2
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name SORT1
Seq. Order 12
Data Storage Type VARCHAR2
Max Length 100
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

First Column used for sort
General Data Type VARCHAR2
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name ASCDESC1
Seq. Order 13
Data Storage Type VARCHAR2
Max Length 5
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

Specifies whether first sort is ascending or descending
General Data Type VARCHAR2
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name SORT2
Seq. Order 14
Data Storage Type VARCHAR2
Max Length 100
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

Second Column used for court
General Data Type VARCHAR2
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name ASCDESC2
Seq. Order 15
Data Storage Type VARCHAR2
Max Length 5
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

Specifies whether seconf sort is ascending or descending
General Data Type VARCHAR2
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name
Seq. Order
Data Storage Type
Max Length
Precision
Scale
Required
Primary Key
Status
Description
General Data Type
Case Restriction
Format Mask
Null Value
Null Value Meaning
Min Length
Unit of Measure
Display Example
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules
Attribute Name
Seq. Order
Data Storage Type
Max Length
Precision
Scale
Required
Primary Key
Status
Description
General Data Type
Case Restriction
Format Mask
Null Value
Null Value Meaning
Min Length
Unit of Measure
Display Example
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules
Attribute Name
Seq. Order
Data Storage Type
Max Length
Precision
Scale
Required
Primary Key
Status
Description
General Data Type
Case Restriction
Format Mask
Null Value
Null Value Meaning
Min Length
Unit of Measure
Display Example
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Support Roles

» At least one Distributor Org, one Metadata Contact, one Point of Contact, and one Data Steward should be listed.
* » Support Role
* » Date Effective From
Date Effective To
* » Contact
* Contact Instructions
* » Support Role
* » Date Effective From
Date Effective To
* » Contact
* Contact Instructions
* » Support Role
* » Date Effective From
Date Effective To
* » Contact
* Contact Instructions

Extents

Currentness Reference  

Extent Group 1

Extent Description

Extent Group 1 / Geographic Area

* » W° Bound
* » E° Bound
* » N° Bound
* » S° Bound
* » Description

Extent Group 1 / Vertical Extent

EPSG Code
Vertical Minimum
Vertical Maximum

Extent Group 1 / Time Frame

* » Time Frame Type
* » Start
End
Alternate Start as of Info
Alternate End as of Info
Description

Access Information

* » Security Class  
* Security Classification System  
 
Security Handling Description  
 
• Data Access Policy  
 
» Data Access Procedure  
 
• » Data Access Constraints  
 
• Data Use Constraints  
 
Metadata Access Constraints  
 
Metadata Use Constraints  
 

Distribution Information

Start Date
End Date
» Download URL
Distributor
File Name
Description
File Date/Time
File Type
FGDC Content Type
File Size
Application Version
Compression
Review Status
Start Date
End Date
» Download URL
Distributor
File Name
Description
File Date/Time
File Type
FGDC Content Type
File Size
Application Version
Compression
Review Status
Start Date
End Date
» Download URL
Distributor
File Name
Description
File Date/Time
File Type
FGDC Content Type
File Size
Application Version
Compression
Review Status

Activity Log

Activity Time
Activity Type
Responsible Party
Description
Activity Time
Activity Type
Responsible Party
Description
Activity Time
Activity Type
Responsible Party
Description

Issues

Issue Date
Author
Issue
Issue Date
Author
Issue
Issue Date
Author
Issue

FAQs

Date
Author
Question
Answer

Child Items

Rubric scores updated every 15m

Score Type Title
     
     
     

Related Items

Item Type Relationship Type Title
     
     
     

Catalog Details

Catalog Item ID 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 Workflow State Published / External
Metadata Last Review Date  
Metadata Review Frequency 1 Year
Metadata Next Review Date  
Tags