18865
Table: ODDS_STRATA_INPT
ODDS_STRATA_INPT
Entity
Published / External
18871
AFSC/FMA/Observer Declare and Deploy (Resturcture)
Data Set
Completed
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.
Loaded by batch 4561, 04-30-2013 18:33
Data Table
Yes
NORPAC
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.
1
INPT_STRATA_SEQ
NUMBER
22
Yes
Yes
Active
primary key sequence number
NUMBER
2
FISHING_YEAR
NUMBER
22
Yes
No
38
Active
Fishing year input applies to
NUMBER
3
SAMPLE_PLAN_SEQ
NUMBER
22
Yes
No
Active
sample plan seq( strata) for the input vessel
NUMBER
NORPAC.ODDS_LOV_SAMPLE_PLAN
4
AKR_VESSEL_ID
NUMBER
22
Yes
No
38
Active
AK region vessel id
NUMBER
5
INPT_STATUS
VARCHAR2
500
No
No
Active
Text generated by the ODDS application, describing the action which triggered the creation of a vessel strata input record.
VARCHAR2
6
FISHING_QUARTER
NUMBER
22
No
No
38
Active
Fishing quarter , used for vessel selection sample plan seq = 1 (not observed) or 2(observed)
NUMBER
7
OWNER_USER_ID
VARCHAR2
200
No
No
Active
User id added to cams for vessel owner
VARCHAR2
8
TEMP_OWNER_PASSWORD
VARCHAR2
256
No
No
Active
Temporary password added for owner. User changes on first use.
VARCHAR2
gov.noaa.nmfs.inport:18865
Doug Turnbull
2013-04-30T18:33:21
SysAdmin InPortAdmin
2022-08-09T17:11:08
2016-05-18
Alaska Fisheries Science Center
AFSC
7600 Sand Point Way N.E., Building 4
Seattle
WA
98115
USA
http://www.afsc.noaa.gov
0700-1700 Pacific Time
1001
Public
No
2016-05-18
1 Year
2017-05-18