Table: ATL_DO_NOT_LOAD_CRUISE
Entity (ENT) | Alaska Fisheries Science Center (AFSC)GUID: gov.noaa.nmfs.inport:9659 | Updated: August 9, 2022 | Published / External
Item Identification
| Title: | Table: ATL_DO_NOT_LOAD_CRUISE |
|---|---|
| Short Name: | ATL_DO_NOT_LOAD_CRUISE |
| Status: | Completed |
| Abstract: |
If an observer has more than one cruise in the same contract. Data from the field ought to be loaded for only the active cruise. This table provides the list of cruises for which data is currently static. The table is referenced by the atl_load_norpac.load_atl_tables procedure. |
| Notes: |
Loaded by batch 2390, 06-30-2009 16:11 |
Entity Information
| Entity Type: | Data Table |
|---|---|
| Active Version?: | Yes |
| Schema Name: | NORPAC |
| Description: |
If an observer has more than one cruise in the same contract. Data from the field ought to be loaded for only the active cruise. This table provides the list of cruises for which data is currently static. The table is referenced by the atl_load_norpac.load_atl_tables procedure. |
Data Attributes
Attribute Summary
|
|
Name | Type | Description |
|---|---|---|---|---|
|
100
|
|
CRUISE | NUMBER | Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record. In this table a listed cruise is held static to automated data loading. |
|
100
|
COMMENTS | VARCHAR2 | Optional discussion - particularly useful in the case loading data with known errors or when the data for a cruise is frozen for a reason other than multiple cruises in a contract. |
Attribute Details
CRUISE
| Seq. Order: | 1 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | Yes |
| Primary Key: | Yes |
| Precision: | 8 |
| Scale: | 0 |
| Status: | Active |
| Description: |
Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record. In this table a listed cruise is held static to automated data loading. |
| General Data Type: | NUMBER |
COMMENTS
| Seq. Order: | 2 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 500 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Optional discussion - particularly useful in the case loading data with known errors or when the data for a cruise is frozen for a reason other than multiple cruises in a contract. |
| General Data Type: | VARCHAR2 |
Catalog Details
| Catalog Item ID: | 9659 |
|---|---|
| GUID: | gov.noaa.nmfs.inport:9659 |
| Metadata Record Created By: | Doug Turnbull |
| Metadata Record Created: | 2009-06-30 16:11+0000 |
| Metadata Record Last Modified By: | SysAdmin InPortAdmin |
| Metadata Record Last Modified: | 2022-08-09 17:11+0000 |
| Metadata Record Published: | 2018-09-26 |
| Owner Org: | AFSC |
| Metadata Publication Status: | Published Externally |
| Do Not Publish?: | N |
| Metadata Last Review Date: | 2018-09-26 |
| Metadata Review Frequency: | 1 Year |
| Metadata Next Review Date: | 2019-09-26 |