Slide Menu
Search Help Show/Hide Menu

Item Identification

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

Table of weight unit conversions to allow conversion to standard Kilograms

Notes:

Loaded by batch 2006, 12-03-2007 10:40

Keywords

Theme Keywords

Thesaurus Keyword
UNCONTROLLED
None weight conversion

Entity Information

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

Table of weight unit conversions to allow conversion to standard Kilograms

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key ID NUMBER Sequential Key
100
CREATED_BY_USER_ID VARCHAR2 User Who created The record
100
CREATED_DATE DATE Date/Time Stamp Of Record Creation
100
NAME VARCHAR2 DecodeOf Mnemonic Code
100
DESCRIPTION VARCHAR2 An extra description of the name (if necessary)
100
MODIFIED_BY_USER_ID VARCHAR2 Oracle Id that last changed this record
100
MODIFIED_DATE DATE Date/Time Stamp of When record was modified
100
CODE VARCHAR2 Mnemonic Code For Weight Units
100
CONVERSION_COEFFICIENT NUMBER Factor to convert weight to kilograms

Attribute Details

ID

CC ID: 23427
Seq. Order: 1
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: Yes
Precision: 38
Status: Active
Description:

Sequential Key

General Data Type: NUMBER

CREATED_BY_USER_ID

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

User Who created The record

General Data Type: VARCHAR2

CREATED_DATE

CC ID: 23429
Seq. Order: 3
Data Storage Type: DATE
Max Length: 7
Required: Yes
Primary Key: No
Status: Active
Description:

Date/Time Stamp Of Record Creation

General Data Type: DATE

NAME

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

DecodeOf Mnemonic Code

General Data Type: VARCHAR2

DESCRIPTION

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

An extra description of the name (if necessary)

General Data Type: VARCHAR2

MODIFIED_BY_USER_ID

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

Oracle Id that last changed this record

General Data Type: VARCHAR2

MODIFIED_DATE

CC ID: 23433
Seq. Order: 7
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Date/Time Stamp of When record was modified

General Data Type: DATE

CODE

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

Mnemonic Code For Weight Units

General Data Type: VARCHAR2

CONVERSION_COEFFICIENT

CC ID: 23435
Seq. Order: 9
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Factor to convert weight to kilograms

General Data Type: NUMBER

Catalog Details

Catalog Item ID: 6689
GUID: gov.noaa.nmfs.inport:6689
Metadata Record Created By: Lee M Weinberger
Metadata Record Created: 2007-12-03 10:40+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