Table: VERS_APPORTION
Entity (ENT) | Northeast Fisheries Science Center (NEFSC)GUID: gov.noaa.nmfs.inport:34230 | Updated: August 9, 2022 | Published / External
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details
Data Attributes
Attribute Summary
|
|
Name | Type | Description |
|---|---|---|---|---|
|
100
|
|
TRIP_ID | NUMBER | Unique trip identifier |
|
100
|
|
LANDING_NUM | NUMBER | Sequential number of landing events |
|
100
|
|
APPOR_NUM | NUMBER | Sequential number of apportionment events within a landing |
|
100
|
SPECIES_ITIS | VARCHAR2 | ACCSP species ITIS code | |
|
100
|
MARKET_CODE | VARCHAR2 | ACCSP market code of the apportioned catch | |
|
100
|
GRADE_CODE | VARCHAR2 | ACCSP grade code of the apportioned catch | |
|
100
|
APPOR_AMOUNT | NUMBER | Quantity entered for species apportionment to a dealer | |
|
100
|
APPOR_AMOUNT_UOM | VARCHAR2 | Unit of measure for APPOR_AMOUNT | |
|
100
|
DEALER_PERMIT | VARCHAR2 | Dealer identifier of the dealer purchasing catch | |
|
100
|
ISSUING_AGENCY | VARCHAR2 | Government agency which issued the dealer permit (eg. state or federal) | |
|
100
|
SOLD_DATE | DATE | Date on which catch was sold to the dealer | |
|
100
|
APPOR_ENTRY_DATE_GMT | DATE | Datetime (UTC) at which the apportionment record was entered into the ELB | |
|
100
|
UPLOAD_DATE_GMT | DATE | Datetime (UTC) at which the submitted data was loaded to NEFSC servers | |
|
100
|
CD_DISPOSITION_CODE | VARCHAR2 | ACCSP disposition code for the apportioned catch |
Attribute Details
TRIP_ID
CC ID: 343939
| Seq. Order: | 1 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | Yes |
| Primary Key: | Yes |
| Precision: | 14 |
| Scale: | 0 |
| Status: | Active |
| Description: |
Unique trip identifier |
| General Data Type: | NUMBER |
| Foreign Key Relations: |
FVTR.VERS_LANDING |
LANDING_NUM
CC ID: 343940
| Seq. Order: | 2 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | Yes |
| Primary Key: | Yes |
| Precision: | 2 |
| Scale: | 0 |
| Status: | Active |
| Description: |
Sequential number of landing events |
| General Data Type: | NUMBER |
| Foreign Key Relations: |
FVTR.VERS_LANDING |
APPOR_NUM
CC ID: 343944
| Seq. Order: | 3 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | Yes |
| Primary Key: | Yes |
| Precision: | 2 |
| Scale: | 0 |
| Status: | Active |
| Description: |
Sequential number of apportionment events within a landing |
| General Data Type: | NUMBER |
SPECIES_ITIS
CC ID: 343935
| Seq. Order: | 4 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 11 |
| Required: | Yes |
| Primary Key: | No |
| Status: | Active |
| Description: |
ACCSP species ITIS code |
| General Data Type: | VARCHAR2 |
| Foreign Key Relations: |
FVTR.FVTR_SPECIES_CODES |
MARKET_CODE
CC ID: 343936
| Seq. Order: | 5 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | Yes |
| Primary Key: | No |
| Status: | Active |
| Description: |
ACCSP market code of the apportioned catch |
| General Data Type: | VARCHAR2 |
| Foreign Key Relations: |
FVTR.FVTR_SPECIES_CODES |
GRADE_CODE
CC ID: 343937
| Seq. Order: | 6 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | Yes |
| Primary Key: | No |
| Status: | Active |
| Description: |
ACCSP grade code of the apportioned catch |
| General Data Type: | VARCHAR2 |
| Foreign Key Relations: |
FVTR.FVTR_SPECIES_CODES |
APPOR_AMOUNT
CC ID: 343945
| Seq. Order: | 7 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 8 |
| Scale: | 1 |
| Status: | Active |
| Description: |
Quantity entered for species apportionment to a dealer |
| General Data Type: | NUMBER |
APPOR_AMOUNT_UOM
CC ID: 343938
| Seq. Order: | 8 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | Yes |
| Primary Key: | No |
| Status: | Active |
| Description: |
Unit of measure for APPOR_AMOUNT |
| General Data Type: | VARCHAR2 |
| Foreign Key Relations: |
FVTR.FVTR_SPECIES_CODES |
DEALER_PERMIT
CC ID: 343933
| Seq. Order: | 9 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 15 |
| Required: | Yes |
| Primary Key: | No |
| Status: | Active |
| Description: |
Dealer identifier of the dealer purchasing catch |
| General Data Type: | VARCHAR2 |
| Foreign Key Relations: |
FVTR.FVTR_DEALERS |
ISSUING_AGENCY
CC ID: 343932
| Seq. Order: | 10 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 30 |
| Required: | Yes |
| Primary Key: | No |
| Status: | Active |
| Description: |
Government agency which issued the dealer permit (eg. state or federal) |
| General Data Type: | VARCHAR2 |
| Foreign Key Relations: |
FVTR.FVTR_DEALERS |
SOLD_DATE
CC ID: 343941
| Seq. Order: | 11 |
|---|---|
| Data Storage Type: | DATE |
| Max Length: | 7 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Date on which catch was sold to the dealer |
| General Data Type: | DATE |
APPOR_ENTRY_DATE_GMT
CC ID: 343942
| Seq. Order: | 12 |
|---|---|
| Data Storage Type: | DATE |
| Max Length: | 7 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Datetime (UTC) at which the apportionment record was entered into the ELB |
| General Data Type: | DATE |
UPLOAD_DATE_GMT
CC ID: 343943
| Seq. Order: | 13 |
|---|---|
| Data Storage Type: | DATE |
| Max Length: | 7 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Datetime (UTC) at which the submitted data was loaded to NEFSC servers |
| General Data Type: | DATE |
CD_DISPOSITION_CODE
CC ID: 343934
| Seq. Order: | 14 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 3 |
| Required: | Yes |
| Primary Key: | No |
| Status: | Active |
| Description: |
ACCSP disposition code for the apportioned catch |
| General Data Type: | VARCHAR2 |
| Foreign Key Relations: |
FVTR.FVTR_DISPOSITIONS |