Slide Menu
Search Help Show/Hide Menu

Item Identification

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

Table Of Valid COndition Types

Notes:

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

Keywords

Theme Keywords

Thesaurus Keyword
UNCONTROLLED
None code tables
None condition landed

Entity Information

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

Table Of Valid COndition Types

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key ID NUMBER Sequential Key
100
NAME VARCHAR2 Condition Type Name
100
CREATED_BY_USER_ID VARCHAR2 User creating Record
100
CREATED_DATE DATE Date/Time stamp of record creation
100
DESCRIPTION VARCHAR2 Longer Description Of Condition Type
100
MODIFIED_BY_USER_ID VARCHAR2 User modifying record
100
MODIFIED_DATE DATE Date/Time stamp of when record was modifed
100
CODE VARCHAR2 data from the WEIGHT_TYPE columns from old TIP database

Attribute Details

ID

CC ID: 22843
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

NAME

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

Condition Type Name

General Data Type: VARCHAR2

CREATED_BY_USER_ID

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

User creating Record

General Data Type: VARCHAR2

CREATED_DATE

CC ID: 22846
Seq. Order: 4
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

DESCRIPTION

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

Longer Description Of Condition Type

General Data Type: VARCHAR2

MODIFIED_BY_USER_ID

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

User modifying record

General Data Type: VARCHAR2

MODIFIED_DATE

CC ID: 22849
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 modifed

General Data Type: DATE

CODE

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

data from the WEIGHT_TYPE columns from old TIP database

General Data Type: VARCHAR2

Catalog Details

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