Table: ODDS_STRATA_INPT
Entity (ENT) | Alaska Fisheries Science Center (AFSC)GUID: gov.noaa.nmfs.inport:18865 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
This table created as a record of the inputs referenced to create ODDS_VESSEL_SAMPLE_PLAN, ODDS_USER_VESSEL, and CAMS_USER entries depending on the year, quarter, vessel sample plan, and contact.
DescriptionThis table created as a record of the inputs referenced to create ODDS_VESSEL_SAMPLE_PLAN, ODDS_USER_VESSEL, and CAMS_USER entries depending on the year, quarter, vessel sample plan, and contact.
Entity Information
Entity Type
Data Table
Data Attribute / Type | Description |
---|---|
INPT_STRATA_SEQ
NUMBER |
primary key sequence number |
FISHING_YEAR
NUMBER |
Fishing year input applies to |
SAMPLE_PLAN_SEQ
NUMBER |
sample plan seq( strata) for the input vessel |
AKR_VESSEL_ID
NUMBER |
AK region vessel id |
INPT_STATUS
VARCHAR2 |
Text generated by the ODDS application, describing the action which triggered the creation of a vessel strata input record. |
FISHING_QUARTER
NUMBER |
Fishing quarter , used for vessel selection sample plan seq = 1 (not observed) or 2(observed) |
OWNER_USER_ID
VARCHAR2 |
User id added to cams for vessel owner |
TEMP_OWNER_PASSWORD
VARCHAR2 |
Temporary password added for owner. User changes on first use. |
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: | Table: ODDS_STRATA_INPT |
---|---|
Short Name: | ODDS_STRATA_INPT |
Status: | Completed |
Abstract: |
This table created as a record of the inputs referenced to create ODDS_VESSEL_SAMPLE_PLAN, ODDS_USER_VESSEL, and CAMS_USER entries depending on the year, quarter, vessel sample plan, and contact. |
Notes: |
Loaded by batch 4561, 04-30-2013 18:33 |
Entity Information
Entity Type: | Data Table |
---|---|
Active Version?: | Yes |
Schema Name: | NORPAC |
Description: |
This table created as a record of the inputs referenced to create ODDS_VESSEL_SAMPLE_PLAN, ODDS_USER_VESSEL, and CAMS_USER entries depending on the year, quarter, vessel sample plan, and contact. |
Data Attributes
Attribute Summary
Name | Type | Description | ||
---|---|---|---|---|
100
|
INPT_STRATA_SEQ | NUMBER | primary key sequence number | |
100
|
FISHING_YEAR | NUMBER | Fishing year input applies to | |
100
|
SAMPLE_PLAN_SEQ | NUMBER | sample plan seq( strata) for the input vessel | |
100
|
AKR_VESSEL_ID | NUMBER | AK region vessel id | |
100
|
INPT_STATUS | VARCHAR2 | Text generated by the ODDS application, describing the action which triggered the creation of a vessel strata input record. | |
100
|
FISHING_QUARTER | NUMBER | Fishing quarter , used for vessel selection sample plan seq = 1 (not observed) or 2(observed) | |
100
|
OWNER_USER_ID | VARCHAR2 | User id added to cams for vessel owner | |
100
|
TEMP_OWNER_PASSWORD | VARCHAR2 | Temporary password added for owner. User changes on first use. |
Attribute Details
INPT_STRATA_SEQ
Seq. Order: | 1 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | Yes |
Status: | Active |
Description: |
primary key sequence number |
General Data Type: | NUMBER |
FISHING_YEAR
Seq. Order: | 2 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
Fishing year input applies to |
General Data Type: | NUMBER |
SAMPLE_PLAN_SEQ
Seq. Order: | 3 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
sample plan seq( strata) for the input vessel |
General Data Type: | NUMBER |
Foreign Key Relations: |
NORPAC.ODDS_LOV_SAMPLE_PLAN |
AKR_VESSEL_ID
Seq. Order: | 4 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
AK region vessel id |
General Data Type: | NUMBER |
INPT_STATUS
Seq. Order: | 5 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 500 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Text generated by the ODDS application, describing the action which triggered the creation of a vessel strata input record. |
General Data Type: | VARCHAR2 |
FISHING_QUARTER
Seq. Order: | 6 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
Fishing quarter , used for vessel selection sample plan seq = 1 (not observed) or 2(observed) |
General Data Type: | NUMBER |
OWNER_USER_ID
Seq. Order: | 7 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 200 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
User id added to cams for vessel owner |
General Data Type: | VARCHAR2 |
TEMP_OWNER_PASSWORD
Seq. Order: | 8 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 256 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Temporary password added for owner. User changes on first use. |
General Data Type: | VARCHAR2 |
Catalog Details
Catalog Item ID: | 18865 |
---|---|
GUID: | gov.noaa.nmfs.inport:18865 |
Metadata Record Created By: | Doug Turnbull |
Metadata Record Created: | 2013-04-30 18:33+0000 |
Metadata Record Last Modified By: | SysAdmin InPortAdmin |
Metadata Record Last Modified: | 2022-08-09 17:11+0000 |
Metadata Record Published: | 2016-05-18 |
Owner Org: | AFSC |
Metadata Publication Status: | Published Externally |
Do Not Publish?: | N |
Metadata Last Review Date: | 2016-05-18 |
Metadata Review Frequency: | 1 Year |
Metadata Next Review Date: | 2017-05-18 |