Slide Menu
Search Help Show/Hide Menu

Item Identification

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

Stores Error Messages Encountered during migration process

Notes:

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

Entity Information

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

Stores Error Messages Encountered during migration process

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
SEQUENCE_NUMBER VARCHAR2 TIP Sequence Number
100
RECORD_TYPE VARCHAR2 TIP Record Type
100
REPLICATE NUMBER TIP Replicate Number
100
SAMPLE_NUMBER NUMBER TIP Sample Number
100
LINE_NUMBER NUMBER TIP Line Number
100
USERID VARCHAR2 ID of the Person assigned to the data migrated
100
EXCEPTION_DATE DATE Date Time/Stamp Of Migration Failure
100
EXCEPTION_MESSAGE VARCHAR2 Error Message
100
NEW_AGENCY VARCHAR2 New Agency Code

Attribute Details

SEQUENCE_NUMBER

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

TIP Sequence Number

General Data Type: VARCHAR2

RECORD_TYPE

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

TIP Record Type

General Data Type: VARCHAR2

REPLICATE

CC ID: 22636
Seq. Order: 3
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 2
Scale: 0
Status: Active
Description:

TIP Replicate Number

General Data Type: NUMBER

SAMPLE_NUMBER

CC ID: 22637
Seq. Order: 4
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 2
Scale: 0
Status: Active
Description:

TIP Sample Number

General Data Type: NUMBER

LINE_NUMBER

CC ID: 22638
Seq. Order: 5
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 3
Scale: 0
Status: Active
Description:

TIP Line Number

General Data Type: NUMBER

USERID

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

ID of the Person assigned to the data migrated

General Data Type: VARCHAR2

EXCEPTION_DATE

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

Date Time/Stamp Of Migration Failure

General Data Type: DATE

EXCEPTION_MESSAGE

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

Error Message

General Data Type: VARCHAR2

NEW_AGENCY

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

New Agency Code

General Data Type: VARCHAR2

Catalog Details

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