Search Help Show/Hide Menu
Summary
Item Identification
Data Attributes
Catalog Details

Summary

Abstract

A temporary storage location used for importing Excel files that contain a list of archive records.

Entity Information

Data Attribute / Type Description
FILE_IMPORT_SEQ
NUMBER
A database-generated primary key that provides a unique sequential number for each record.
IMPORTED_BLOB
BLOB
A file imported in Excel or CSV format that contains a list of archive records.
FILE_NAME
VARCHAR2 (50 Byte)
The name of the file that has been imported.
MIME_TYPE
VARCHAR2 (100 Byte)
The MIME type of the file, indicating its format or content type.
CREATED_ON
DATE
The date when the file was imported.

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

Please contact the owner organization (AFSC) for inquiries on this record.

Item Identification

Title: CAS_FILE_IMPORT
Abstract:

A temporary storage location used for importing Excel files that contain a list of archive records.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key FILE_IMPORT_SEQ NUMBER A database-generated primary key that provides a unique sequential number for each record.
100
IMPORTED_BLOB BLOB A file imported in Excel or CSV format that contains a list of archive records.
100
FILE_NAME VARCHAR2 (50 Byte) The name of the file that has been imported.
100
MIME_TYPE VARCHAR2 (100 Byte) The MIME type of the file, indicating its format or content type.
100
CREATED_ON DATE The date when the file was imported.

Attribute Details

FILE_IMPORT_SEQ

CC ID: 1378107
Seq. Order: 1
Data Storage Type: NUMBER
Required: Yes
Primary Key: Yes
Status: Active
Description:

A database-generated primary key that provides a unique sequential number for each record.

IMPORTED_BLOB

CC ID: 1378108
Seq. Order: 2
Data Storage Type: BLOB
Required: No
Primary Key: No
Status: Active
Description:

A file imported in Excel or CSV format that contains a list of archive records.

FILE_NAME

CC ID: 1378109
Seq. Order: 3
Data Storage Type: VARCHAR2 (50 Byte)
Required: No
Primary Key: No
Status: Active
Description:

The name of the file that has been imported.

MIME_TYPE

CC ID: 1378110
Seq. Order: 4
Data Storage Type: VARCHAR2 (100 Byte)
Required: No
Primary Key: No
Status: Active
Description:

The MIME type of the file, indicating its format or content type.

CREATED_ON

CC ID: 1378111
Seq. Order: 5
Data Storage Type: DATE
Required: No
Primary Key: No
Status: Active
Description:

The date when the file was imported.

Default Value: SYSDATE

Catalog Details

Catalog Item ID: 75381
GUID: gov.noaa.nmfs.inport:75381
Metadata Record Created By: Martin Park
Metadata Record Created: 2025-03-25 21:43+0000
Metadata Record Last Modified By: Martin Park
Metadata Record Last Modified: 2025-03-25 23:13+0000
Metadata Record Published: 2025-03-25
Owner Org: AFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Review Frequency: 1 Year