CAS_FILE_IMPORT
Entity (ENT) | Alaska Fisheries Science Center (AFSC)GUID: gov.noaa.nmfs.inport:75381 | Updated: March 25, 2025 | Published / External
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
|
|
Name | Type | Description |
|---|---|---|---|---|
|
100
|
|
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 |