Slide Menu
Search Help Show/Hide Menu

Item Identification

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

Stores General statistics on the run of the migration.

Notes:

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

Entity Information

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

Stores General statistics on the run of the migration.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
USERID VARCHAR2 User assigned responsibility for migrated records
100
NEW_AGENCY VARCHAR2 New Agency Code
100
RUN_DATE DATE Date Migration is run
100
INTERVIEW_INSERTS NUMBER Number Of New Interview Records
100
INTERVIEW_EXCEPTIONS NUMBER Number Of Exception detected while loading the Interview table
100
EFFORT_INSERTS NUMBER Number Of New Effort Records
100
EFFORT_EXCEPTIONS NUMBER Number of Effort Records where an error was detected
100
LANDING_INSERTS NUMBER Number Of Landings Records To Be inserted
100
LANDING_EXCEPTIONS NUMBER of Landing Records where an error was detected
100
SAMPLE_INSERTS NUMBER Number Of New Sample Records
100
SAMPLE_EXCEPTIONS NUMBER of Sample Records where an error was detected
100
OBSERVATION_INSERTS NUMBER Number Of New Observation Records
100
OBSERVATION_EXCEPTIONS NUMBER of Observation Records where an error was detected
100
OBSERVATION_SAMPLE_INSERTS NUMBER Number Of New Observation Sample Records
100
OBSERVATION_SAMPLE_EXCEPTIONS NUMBER of Observation Sample Records where an error was detected
100
USERID_OF_LOADER VARCHAR2 ID of person who is running migration program.

Attribute Details

USERID

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

User assigned responsibility for migrated records

General Data Type: VARCHAR2

NEW_AGENCY

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

New Agency Code

General Data Type: VARCHAR2

RUN_DATE

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

Date Migration is run

General Data Type: DATE

INTERVIEW_INSERTS

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

Number Of New Interview Records

General Data Type: NUMBER

INTERVIEW_EXCEPTIONS

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

Number Of Exception detected while loading the Interview table

General Data Type: NUMBER

EFFORT_INSERTS

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

Number Of New Effort Records

General Data Type: NUMBER

EFFORT_EXCEPTIONS

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

Number of Effort Records where an error was detected

General Data Type: NUMBER

LANDING_INSERTS

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

Number Of Landings Records To Be inserted

General Data Type: NUMBER

LANDING_EXCEPTIONS

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

of Landing Records where an error was detected

General Data Type: NUMBER

SAMPLE_INSERTS

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

Number Of New Sample Records

General Data Type: NUMBER

SAMPLE_EXCEPTIONS

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

of Sample Records where an error was detected

General Data Type: NUMBER

OBSERVATION_INSERTS

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

Number Of New Observation Records

General Data Type: NUMBER

OBSERVATION_EXCEPTIONS

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

of Observation Records where an error was detected

General Data Type: NUMBER

OBSERVATION_SAMPLE_INSERTS

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

Number Of New Observation Sample Records

General Data Type: NUMBER

OBSERVATION_SAMPLE_EXCEPTIONS

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

of Observation Sample Records where an error was detected

General Data Type: NUMBER

USERID_OF_LOADER

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

ID of person who is running migration program.

General Data Type: VARCHAR2

Catalog Details

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