Slide Menu
Search Help Show/Hide Menu

Item Identification

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

Cross Reference Table Used To Separate Codes When In Old Tip System The Length Type and Unit were in the same Code

Notes:

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

Entity Information

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

Cross Reference Table Used To Separate Codes When In Old Tip System The Length Type and Unit were in the same Code

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key NUMERIC_CODE VARCHAR2 COmbined Length Type and Unit COde
100
LENGTH_TYPE_1 VARCHAR2 Length Type
100
LENGTH_UNIT_1 VARCHAR2 Length Unit
100
LENGTH_TYPE_2 VARCHAR2 Length Type
100
LENGTH_UNIT_2 VARCHAR2 Length Unit

Attribute Details

NUMERIC_CODE

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

COmbined Length Type and Unit COde

General Data Type: VARCHAR2

LENGTH_TYPE_1

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

Length Type

General Data Type: VARCHAR2

LENGTH_UNIT_1

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

Length Unit

General Data Type: VARCHAR2

LENGTH_TYPE_2

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

Length Type

General Data Type: VARCHAR2

LENGTH_UNIT_2

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

Length Unit

General Data Type: VARCHAR2

Catalog Details

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