Slide Menu
Search Help Show/Hide Menu

Item Identification

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

Table that contains information about data flow into the Domestic Longline System. This information is generated automatically by the data loading program and requires no input from the users.

Notes:

Loaded by batch 5871, 04-20-2015 08:47

Entity Information

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

Table that contains information about data flow into the Domestic Longline System. This information is generated automatically by the data loading program and requires no input from the users.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
BATCH_NUMBER VARCHAR2 Number that identifies a group of trips. This 4 digits number is extracted from the source file which represent two digit year and a sequential two digit code (yy##).
100
SOURCE_FILE VARCHAR2 Name of the ASCII file tha was loaded.
100
FOLDER VARCHAR2 Place where the source file was found by the time it was loaded.
100
NO_RECORDS NUMBER Number of records that were loaded into interim tables.
100
LOAD_DATE DATE Date on which the data were loaded into the interim tables of the Domestic Longline System.
100
NUMBER_MOVED_TO_MASTER NUMBER Number of Records moved into master table by source files.
100
MOVED_TO_MASTER_DATE DATE Date in which the source file was moved into master table.
100
DELETED_BY VARCHAR2 Oracle Id of who deleted the all of the data for the same Source File
100
DELETION_DATE DATE The Date/Time stamp for deletion
100
DATA_TYPE VARCHAR2 Type of data loaded. Trip or Effort portion.
100
USERID VARCHAR2 User ID of the person who loaded the data into interim tables.

Attribute Details

BATCH_NUMBER

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

Number that identifies a group of trips. This 4 digits number is extracted from the source file which represent two digit year and a sequential two digit code (yy##).

General Data Type: VARCHAR2

SOURCE_FILE

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

Name of the ASCII file tha was loaded.

General Data Type: VARCHAR2

FOLDER

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

Place where the source file was found by the time it was loaded.

General Data Type: VARCHAR2

NO_RECORDS

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

Number of records that were loaded into interim tables.

General Data Type: NUMBER

LOAD_DATE

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

Date on which the data were loaded into the interim tables of the Domestic Longline System.

General Data Type: DATE

NUMBER_MOVED_TO_MASTER

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

Number of Records moved into master table by source files.

General Data Type: NUMBER

MOVED_TO_MASTER_DATE

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

Date in which the source file was moved into master table.

General Data Type: DATE

DELETED_BY

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

Oracle Id of who deleted the all of the data for the same Source File

General Data Type: VARCHAR2

DELETION_DATE

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

The Date/Time stamp for deletion

General Data Type: DATE

DATA_TYPE

CC ID: 197654
Seq. Order: 10
Data Storage Type: VARCHAR2
Max Length: 15
Required: No
Primary Key: No
Status: Active
Description:

Type of data loaded. Trip or Effort portion.

General Data Type: VARCHAR2

USERID

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

User ID of the person who loaded the data into interim tables.

General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 24494
GUID: gov.noaa.nmfs.inport:24494
Metadata Record Created By: Allison Shideler
Metadata Record Created: 2015-04-20 08:47+0000
Metadata Record Last Modified By: Lee M Weinberger
Metadata Record Last Modified: 2021-05-06 22:24+0000
Metadata Record Published: 2021-05-06
Owner Org: SEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2022-05-07