12269
AFSC/FMA/Observer Logistics System (OLS)
AFSC/FMA/Observer Logistics System
Data Set
Published / External
7290
North Pacific (NORPAC) Groundfish and Halibut Observer Data Dictionary December 2007 - Present
Project
In Work
2012
Alaska groundfish fisheries observers have been monitoring domestic groundfish fishing activities in the U.S. Exclusive Economic Zone (EEZ) off Alaska for over twenty years. The Fisheries Monitoring and Analysis Division staff has been responsible for training, briefing, debriefing and oversight of these observers. The Observer Logistics System, launched in December 2011, is the current computer tool used for observer logistics and contains data on individual observers back to 1990.
The Observer Logistics System is used by AFSC staff to manage and track observer contracts, deployment, training and debriefing. The system allows the staff to add, update, and report on the observer logistics data as needed.
The technology of Application Express (APEX 4.1) with JAVA script browser painting in an Oracle 11.2g instance replaced an Oracle Forms and Reports-based system, adding new functionality and tables to provide greater system flexibility and easier work flow. The Observer Logistics System is web-based and is started by the user client by navigating to the NORPAC main menu URL with a web browser. The observer deployment and sampling histories summarize individual observers experience and are used to determine observer pay and leadership qualifications.
The main menu includes:
1. Observer Data
2. Cruise Data
3. Debriefing Data
4. Training Data
5. Debriefing Reports
6. At Sea Reports
7. Training Reports
Individual staff members have computer access only to certain data and reports according to their assigned roles.
Theme
atsea
Theme
badge
Theme
briefing
Theme
class
Theme
contractor
Theme
cruise
Theme
debriefing
Theme
decertification
Theme
deployment history
Theme
enrollment
Theme
evaluation
Theme
fma
Theme
grade
Theme
identification number
Theme
logistics
Theme
midcruise
Theme
npgop
Theme
observer
Theme
photograph
Theme
report
Theme
sampling history
Theme
schedule
Theme
seadays
Theme
seattle
Theme
staff
Theme
statistics
Theme
training
Temporal
briefing date
Temporal
class date
Temporal
debrief date
Temporal
diembark date
Temporal
embark date
Spatial
afsc
Spatial
alaska
Spatial
anchorage
Spatial
dutch harbor
Spatial
kodiak
Spatial
washington
Alaska Fisheries Science Center
Seattle
WA
USA
Data Set
Database
As Needed
Table (digital)
Modelled in Oracle Designer
Paul Packer
https://sites.google.com/a/noaa.gov/afsc-home/it-services/data-management-and-metadata-1?pli=1
N/A
N/A
N/A
N/A
12279
Table: ATL_LOV_VESSEL
ATL_LOV_VESSEL
Published / External
Completed
The lov_vessel table is populated from the VessPlnt table in Norpac. A vessel is identified by a leading A in the vessel_code field.
Loaded by batch 3083, 04-19-2012 13:25
Data Table
Yes
NORPAC
The lov_vessel table is populated from the VessPlnt table in Norpac. A vessel is identified by a leading A in the vessel_code field.
1
VESSEL_SEQ
NUMBER
22
Yes
Yes
9
0
Active
Sequence Generated unique identifier of an Atlas vessel record. The lov vessel table combines the vessplant and catcher boat code tables.
NUMBER
2
VESSEL_CODE
VARCHAR2
6
Yes
No
Active
VessPlnt code from old NORPAC system. This code may ultimately be retired, but is essential to the transitional ETL from Atlas to Inseason and Domestic.
VARCHAR2
3
NAME
VARCHAR2
50
No
No
Active
Name a vessel - inherited from the NORPAC data set
VARCHAR2
4
PERMIT
VARCHAR2
6
No
No
Active
Unique Code identifying a vessel - inherited from the NORPAC data set and created by the RAM division in Juneau
VARCHAR2
5
ADFG_NUMBER
VARCHAR2
6
No
No
Active
Alaska Dept of Fish and Game unique vessel identifier.
VARCHAR2
6
COAST_GUARD_NUMBER
NUMBER
22
No
No
7
0
Active
USCG Registration Number.
NUMBER
7
LENGTH
NUMBER
22
No
No
3
0
Active
Mandatory length of a vessel from the regional office LOA.
NUMBER
8
COMMUNICATION_CODE
NUMBER
22
No
No
3
0
Active
Indicates how observer data is transmitted from vessel
NUMBER
12280
Table: CRUISE_VESSEL
CRUISE_VESSEL
Published / External
Completed
This table provides information about the fishing operation that was performed on this cruise_vessel trip.
Loaded by batch 3083, 04-19-2012 13:25
Data Table
Yes
NORPAC
This table provides information about the fishing operation that was performed on this cruise_vessel trip.
1
TRIPS_JOIN
NUMBER
22
Yes
Yes
8
0
Active
An assigned number (up to eight digits) that uniquely identifies each cruise_vessel trip.
NUMBER
2
CRUISE
NUMBER
22
Yes
No
8
0
Active
A unique five-digit number assigned to the observer for the length of their contract period. This number alone identifies and groups a set of observer information.
NUMBER
NORPAC.CRUISES
3
VESSEL
VARCHAR2
6
Yes
No
Active
A unique four-digit, alpha-numeric code identifying each vessel that contracts for observer coverage. All vessel codes begin with the alpha code A, followed by a three-digit number, or for plants, the codes begin with the alpha code P, followed by a three-digit number.
VARCHAR2
NORPAC.VESSPLNT
4
DATE_OF_ENTRY
DATE
7
Yes
No
Active
The date in which this entry was made.
DATE
5
VESSEL_TYPE
NUMBER
22
No
No
2
0
Active
A one-digit numeric code that indicates whether the vessel processes fish or delivers it to a processing plant where: 1 = a catcher processor vessel, 2 = a mothership or a ship that receives unsorted codends from other vessels, 3 = a catcher only vessel that delivers unprocessed fish to a shoreside or floating plant or vessel, 4 = a mothership that receives sorted codends, 5 = a vessel that sells the majority of their catch over the side to other fishing vessels who will utilize the fish for bait, 6 = vessels that discard all catch from a haul; would be used for codend dumping of an entire haul (added January 2004).
NUMBER
6
GEAR_TYPE
NUMBER
22
No
No
2
0
Active
A one- or two-digit numeric code that indicates the kind of fishing gear used by the vessel, where: 1 = non-pelagic trawl, 2 = pelagic trawl, 3 = unknown or mixed trawl, 4 = pair trawl, 5 = shrimp trawl, 6 = pot or trap, 7 = jig, 8 = longline, 9 = gill net, and 10 = Scottish seine.
NUMBER
NORPAC.DOMESTIC_GEAR
7
FORM_A
VARCHAR2
1
No
No
Active
A one digit code identifying whether data was collected for this form, N = no; Y = yes; blank = not applicable.
VARCHAR2
8
FORM_1
VARCHAR2
1
No
No
Active
A one digit code identifying whether data was collected for this form, N = no; Y = yes; blank = not applicable (other characters have no meaning).
VARCHAR2
9
FORM_2
VARCHAR2
1
No
No
Active
A one digit code identifying whether data was collected for this form, N = no; Y = yes; blank = not applicable (other characters have no meaning).
VARCHAR2
10
FORM_3
VARCHAR2
1
No
No
Active
A one digit code identifying whether data was collected for this form, N = no; Y = yes; blank = not applicable (other characters have no meaning).
VARCHAR2
11
FORM_3REP
VARCHAR2
1
No
No
Active
A one digit code identifying whether data was collected for this form, N = no; Y = yes; blank = not applicable (other characters have no meaning).
VARCHAR2
12
FORM_7
VARCHAR2
1
No
No
Active
A one digit code identifying whether data was collected for this form, N = no; Y = yes; blank = not applicable (other characters have no meaning).
VARCHAR2
13
FORM_9
VARCHAR2
1
No
No
Active
A one digit code identifying whether data was collected for this form, N = no; Y = yes; blank = not applicable (other characters have no meaning).
VARCHAR2
14
FORM_10
VARCHAR2
1
No
No
Active
A one digit code identifying whether data was collected for this form, N = no; Y = yes; blank = not applicable (other characters have no meaning).
VARCHAR2
15
FORM_11
VARCHAR2
1
No
No
Active
A one digit code identifying whether data was collected for this form, N = no; Y = yes; blank = not applicable (other characters have no meaning).
VARCHAR2
16
CREW_COUNT
NUMBER
22
No
No
4
0
Active
The number of crew members aboard the vessel.
NUMBER
17
CAPTAINS
VARCHAR2
3
No
No
Active
Responses are: Yes; No; blank. Uncertain what this means.
VARCHAR2
18
CAPTAIN1_NAME
VARCHAR2
40
No
No
Active
The name of the first captain during this deployment.
VARCHAR2
19
CAPTAIN1_FROM_DATE
DATE
7
No
No
Active
The beginning date for the first captain.
DATE
20
CAPTAIN1_TO_DATE
DATE
7
No
No
Active
The ending date for the first captain.
DATE
21
CAPTAIN2_NAME
VARCHAR2
40
No
No
Active
The name of the second captain (if any) during this deployment.
VARCHAR2
22
CAPTAIN2_FROM_DATE
DATE
7
No
No
Active
The beginning date for the second captain (if any).
DATE
23
CAPTAIN2_TO_DATE
DATE
7
No
No
Active
The ending date for the second captain (if any).
DATE
24
DEPLOYMENT_SCORE
NUMBER
22
No
No
1
0
Active
The score awarded the observer for this deployment, 0 = did not meet expectations, 1 = met or exceeded expectations, 2 = exceeded expectations (was used prior to 2007), 9 = could not evaluate due to sickness.
NUMBER
NORPAC.DEPLOYMENT_SCORE
25
DATA_STATUS
VARCHAR2
2
No
No
Active
Old two digit alpha codes formerly used to identify the current status of a cruise-vessel as it went through the data entry process.
VARCHAR2
NORPAC.DATA_STATUS_CODES
26
JOB_NUMBER
VARCHAR2
6
No
No
Active
An assigned number (up to six digits) that identifies a set of cruises sent to an outside vendor for keying (is no longer used).
VARCHAR2
27
ZERO_SAMPLED_HAULS_FLAG
VARCHAR2
1
No
No
Active
Is no longer used.
VARCHAR2
28
WOC_FLAG
VARCHAR2
1
No
No
Active
A one digit code (Y = yes; N = no) which indicates whether the cruise-vessel deployment operated off the Washington-Oregon-California coast or not.
VARCHAR2
29
GOA_FLAG
VARCHAR2
1
No
No
Active
A one digit code (Y = yes; N = no) which indicates whether the cruise-vessel deployment operated in the Gulf of Alaska or not.
VARCHAR2
30
BSA_FLAG
VARCHAR2
1
No
No
Active
A one digit code (Y = yes; N = no) which indicates whether the cruise-vessel deployment operated in the Bering Sea/Aleutian Islands or not.
VARCHAR2
31
MORE_CAPTAINS
VARCHAR2
1
No
No
Active
Responses are: Y; N. Uncertain what this means.
VARCHAR2
32
DATE_OF_CHANGE
DATE
7
No
No
Active
Date of the most recent change to the record.
DATE
33
VHS_OHS
VARCHAR2
1
No
No
Active
A one digit code identifying whether data was collected for this form, N = no; Y = yes; blank = not applicable.
VARCHAR2
34
DATA_VERIFICATION_FLAG
VARCHAR2
1
No
No
Active
A one digit code identifying whether data from this deployment has been verified or not, N = no; Y = yes.
VARCHAR2
35
DATA_MOVED_FLAG
VARCHAR2
1
Yes
No
Active
A one digit code identifying whether data from this deployment has been moved to the database, N = no; Y = yes. No longer collected after 2007.
VARCHAR2
36
DATA_COLLECTED_FLAG
VARCHAR2
1
No
No
Active
A one digit code identifying whether data was collected during this deployment, N = no; Y = yes, blank = deployment not yet completed.
VARCHAR2
12281
View: OLS_CRUISE_VESSPLNT_V
OLS_CRUISE_VESSPLNT_V
Published / External
Completed
Loaded by batch 3083, 04-19-2012 13:25
Data View
Yes
NORPAC
1
SOURCE
VARCHAR2
6
No
No
Active
VARCHAR2
2
VESSEL_PLANT_SEQ
NUMBER
22
No
No
9
0
Active
NUMBER
3
TRIP_CODE
VARCHAR2
3
No
No
Active
VARCHAR2
4
CRUISE
NUMBER
22
No
No
9
0
Active
NUMBER
5
VESSPLNT
VARCHAR2
6
No
No
Active
VARCHAR2
6
NAME
VARCHAR2
50
No
No
Active
VARCHAR2
7
PERMIT
VARCHAR2
6
No
No
Active
VARCHAR2
8
ADFG_NUMBER
VARCHAR2
6
No
No
Active
VARCHAR2
9
COAST_GUARD_NUMBER
NUMBER
22
No
No
38
Active
NUMBER
10
LENGTH
NUMBER
22
No
No
38
Active
NUMBER
11
LOCATION
VARCHAR2
50
No
No
Active
VARCHAR2
12
EMBARK_DATE
DATE
7
No
No
Active
DATE
13
DISEMBARK_DATE
DATE
7
No
No
Active
DATE
12282
Table: OLS_DATA_EDITOR_COMMENT
OLS_DATA_EDITOR_COMMENT
Published / External
Completed
Loaded by batch 3083, 04-19-2012 13:25
Data Table
Yes
NORPAC
Debriefer or data editor comments for changes made to observer data for a cruise vessel
1
DATA_EDITOR_SEQ
NUMBER
22
Yes
Yes
9
0
Active
primary seq key uniquely identifies each comment
NUMBER
2
VESSEL_PLANT_SEQ
NUMBER
22
Yes
No
9
0
Active
Foreign key to OLS_VESSEL_PLANT the edit changes are for
NUMBER
3
EDITOR_COMMENT
CLOB
4000
No
No
Active
Editor comments for vessel or plant data changes
CLOB
4
ADDED_BY
VARCHAR2
20
No
No
Active
User adding editor comment
VARCHAR2
5
LAST_UPDATED
DATE
7
No
No
Active
Date last editor comment was added or updated
DATE
6
LAST_UPDATED_BY
VARCHAR2
20
No
No
Active
user who last updated the editor comments
VARCHAR2
12283
Table: OLS_DEBRIEFED_VESSPLANT
OLS_DEBRIEFED_VESSPLANT
Published / External
Completed
An observer debriefing may include more than one deployment to a vessel or plant. This entity represents the intersection of the debriefing schedule (which encompasses an entire cruise) with the individual vessels or plants that are being debriefed.
Loaded by batch 3083, 04-19-2012 13:25
Data Table
Yes
NORPAC
An observer debriefing may include more than one deployment to a vessel or plant. This entity represents the intersection of the debriefing schedule (which encompasses an entire cruise) with the individual vessels or plants that are being debriefed.
1
VESSEL_PLANT_SEQ
NUMBER
22
Yes
Yes
9
0
Active
Sequence generated value for an observer deployment record.
NUMBER
NORPAC.OLS_VESSEL_PLANT
2
SCHEDULE_SEQ
NUMBER
22
Yes
Yes
9
0
Active
Sequence generated unique identifie for a debriefing schedule event.
NUMBER
NORPAC.OLS_DEBRIEFING_SCHEDULE
3
SCORE
NUMBER
22
Yes
No
4
0
Active
Each segment of an observer cruise is scored for effectiveness and quality. This attibute represents the intersetion of a debrifing at the cruise level and the vessel or plant on which the observer was deployed.
NUMBER
12284
Table: OLS_DEBRIEFING_COMMENT
OLS_DEBRIEFING_COMMENT
Published / External
Completed
Comments may be recorded by the debriefer about any or all segments included in an observer debriefing. These comments are not constrained except to 4000 characters.
Loaded by batch 3083, 04-19-2012 13:25
Data Table
Yes
NORPAC
Comments may be recorded by the debriefer about any or all segments included in an observer debriefing. These comments are not constrained except to 4000 characters.
1
COMMENT_SEQ
NUMBER
22
Yes
Yes
9
0
Active
Sequence generated unique identifier of debriefer comments during an observer debriefing
NUMBER
2
SCHEDULE_SEQ
NUMBER
22
Yes
No
9
0
Active
Sequence generated unique identifie for a debriefing schedule event.
NUMBER
NORPAC.OLS_DEBRIEFING_SCHEDULE
3
CRUISE
NUMBER
22
Yes
No
9
0
Active
Cruise number debriefing comment applies to.
NUMBER
4
CREATED_BY
VARCHAR2
30
No
No
Active
Oracle User
VARCHAR2
5
COMMENTS
CLOB
4000
No
No
Active
Freeform text of a debriefers remarks.
CLOB
12285
Table: OLS_DEBRIEFING_EVALUATION
OLS_DEBRIEFING_EVALUATION
Published / External
Completed
This entity records the question answer pairs that are selected during a debriefing evaluation.
Loaded by batch 3083, 04-19-2012 13:25
Data Table
Yes
NORPAC
This entity records the question answer pairs that are selected during a debriefing evaluation.
1
EVALUATION_SEQ
NUMBER
22
Yes
Yes
9
0
Active
Sequence generated evaluation linking a cruise to a set of question answer pairs.
NUMBER
2
QUESTION_SEQ
NUMBER
22
Yes
No
9
0
Active
Sequence generated unique identifier for a debriefing evaluation answer, applied here as a FK to ols_eval_quest_ans.
NUMBER
NORPAC.OLS_EVAL_QUEST_ANS
3
ANSWER_SEQ
NUMBER
22
Yes
No
9
0
Active
Sequence generated unique identifier for a debriefing evaluation, applied here as a FK to ols_eval_quest_ans
NUMBER
NORPAC.OLS_EVAL_QUEST_ANS
4
CRUISE
NUMBER
22
Yes
No
9
0
Active
Sequence generated cruise number.
NUMBER
NORPAC.OLS_OBSERVER_CRUISE
5
EVALUATION_COMMENT
VARCHAR2
4000
No
No
Active
Free form comments
VARCHAR2
12286
Table: OLS_DEBRIEFING_SCHEDULE
OLS_DEBRIEFING_SCHEDULE
Published / External
Completed
This entity represents the scheduling details of an observer debriefing. Debriefings are for an entire cruise, but have specific references to each plant or vessel of deployment.
Loaded by batch 3083, 04-19-2012 13:25
Data Table
Yes
NORPAC
This entity represents the scheduling details of an observer debriefing. Debriefings are for an entire cruise, but have specific references to each plant or vessel of deployment.
1
SCHEDULE_SEQ
NUMBER
22
Yes
Yes
9
0
Active
Sequence generated unique identifie for a debriefing schedule event.
NUMBER
2
CRUISE
NUMBER
22
Yes
No
9
0
Active
Sequence generated cruise number.
NUMBER
NORPAC.OLS_OBSERVER_CRUISE
3
LOCATION_CODE
VARCHAR2
3
Yes
No
Active
Three Letter Alpha code identifying the location at which an observer debriefing is scheduled.
VARCHAR2
NORPAC.OLS_LOV_LOCATION
4
SCHEDULER_STAFF_ID
NUMBER
22
Yes
No
9
0
Active
Sequence generated unique identifier of an employee that scheduled debriefing, here invoked as a foreign key to the OLS_LOV_STAFF table.
NUMBER
NORPAC.OLS_LOV_STAFF
5
DEBRIEFER_STAFF_ID
NUMBER
22
No
No
9
0
Active
staff member conducting the debriefing
NUMBER
NORPAC.OLS_LOV_STAFF
6
CHECK_IN_STAFF_ID
NUMBER
22
No
No
9
0
Active
staff id who checked in observer for debriefing
NUMBER
NORPAC.OLS_LOV_STAFF
7
CHECK_IN_DATE
DATE
7
No
No
Active
date observer was checked in for debriefing
DATE
8
SCHEDULED_DEBRIEF_DATE
DATE
7
Yes
No
Active
Date that the observer registers to begin the vessel and observer surveys
DATE
9
DEBRIEF_START_DATE
DATE
7
No
No
Active
Date recorded by the assigned debriefer as Date debriefing started
DATE
10
DEBRIEF_END_DATE
DATE
7
No
No
Active
date the debriefing evaluation was completed
DATE
11
DEBRIEFING_COMPLETION_DATE
DATE
7
No
No
Active
Date that this debriefing process was completed.
DATE
12
OBSERVER_RELEASE_DATE
DATE
7
No
No
Active
Date that the observer was released regardless of debriefing status.
DATE
12287
Table: OLS_EVAL_QUEST_ANS
OLS_EVAL_QUEST_ANS
Published / External
Completed
Loaded by batch 3083, 04-19-2012 13:25
Data Table
Yes
NORPAC
Ties a question to possible set of answers for a debriefing question
1
ANSWER_SEQ
NUMBER
22
Yes
Yes
9
0
Active
Sequence generated unique identifier for a debriefing evaluation answer, applied here as a FK to ols_lov_answer.
NUMBER
NORPAC.OLS_LOV_ANSWER
2
QUESTION_SEQ
NUMBER
22
Yes
Yes
9
0
Active
Sequence generated unique identifier for a debriefing evaluation question, applied here as a FK to ols_lov_question.
NUMBER
NORPAC.OLS_LOV_QUESTION
3
ACTIVE_FLAG
VARCHAR2
1
Yes
No
Active
Binary identifier of whether the question is available to the evaluation or not. When set to N, this supresses all instances of this question and its set of answers that exist in ols_eval_quest_ans object from the GUI presentation layer.
VARCHAR2
12288
Table: OLS_LOGISTICS_COMMENT
OLS_LOGISTICS_COMMENT
Published / External
Completed
Inseason staff comments about observer data during cruise
Loaded by batch 3083, 04-19-2012 13:25
Data Table
Yes
NORPAC
Inseason staff comments about observer data during cruise
1
LOGISTICS_COMMENT_SEQ
NUMBER
22
Yes
No
38
Active
Sequence generated unique identifier of the comment.
NUMBER
2
VESSEL_PLANT_SEQ
NUMBER
22
Yes
No
38
Active
vessel or plant seq which the comment pertains to.
NUMBER
NORPAC.OLS_VESSEL_PLANT
3
LOGISTICS_COMMENT
VARCHAR2
2000
Yes
No
Active
Logistics - debriefing staff comment for vessel plant
VARCHAR2
4
ADDED_BY
VARCHAR2
20
Yes
No
Active
logistics or debriefing staff adding the comment for the vessel- plant - cruise
VARCHAR2
5
LAST_UPDATED
DATE
7
No
No
Active
logistics or debriefing staff adding the comment for the vessel- plant - cruise
DATE
12289
Table: OLS_LOV_ANSWER
OLS_LOV_ANSWER
Published / External
Completed
This entity represents the list of unique valid answers to debriefing evaluation questions. Note common answers (Yes, No etc) are reusable.
Loaded by batch 3083, 04-19-2012 13:25
Data Table
Yes
NORPAC
This entity represents the list of unique valid answers to debriefing evaluation questions. Note common answers (Yes, No etc) are reusable.
1
ANSWER_SEQ
NUMBER
22
Yes
Yes
9
0
Active
Sequence generated unique identifier for a debriefing evaluation
NUMBER
2
TEXT
VARCHAR2
500
Yes
No
Active
Answer text which is presented to the debrifer and observer.
VARCHAR2
12290
Table: OLS_LOV_CONTRACT_CLOSE_REASON
OLS_LOV_CONTRACT_CLOSE_REASON
Published / External
Completed
List of valid values for which an observer contract may be closed prior to its scheduled completion date.
Loaded by batch 3083, 04-19-2012 13:25
Data Table
Yes
NORPAC
List of valid values for which an observer contract may be closed prior to its scheduled completion date.
1
CONTRACT_END_REASON
VARCHAR2
3
Yes
Yes
Active
code used to close a contract not closed for normal closing .
VARCHAR2
2
DESCRIPTION
VARCHAR2
40
Yes
No
Active
description of the reason code for not normal contract close .
VARCHAR2
12291
Table: OLS_LOV_CONTRACT_STATUS
OLS_LOV_CONTRACT_STATUS
Published / External
Completed
This entity represents the list of valid status of an observer contract at a given point of time.
Loaded by batch 3083, 04-19-2012 13:25
Data Table
Yes
NORPAC
This entity represents the list of valid status of an observer contract at a given point of time.
1
CONTRACT_STATUS
VARCHAR2
1
Yes
Yes
Active
Contract status code indicating what phase the contract is in.
VARCHAR2
2
DESCRIPTION
VARCHAR2
20
Yes
No
Active
Descriptive text for the contract status
VARCHAR2
12292
Table: OLS_LOV_EMPLOYER
OLS_LOV_EMPLOYER
Published / External
Completed
List of Companies certified as observer providers. Observers are trained, certified and equiped by NMFS, however are employed by private staffing companies.
Loaded by batch 3083, 04-19-2012 13:25
Data Table
Yes
NORPAC
List of Companies certified as observer providers. Observers are trained, certified and equiped by NMFS, however are employed by private staffing companies.
1
EMPLOYER_CODE
VARCHAR2
3
Yes
Yes
Active
Three letter acronym forced to all caps representing a unique observer contractor - This value is inherited from the old observer logistics system.
VARCHAR2
2
NAME
VARCHAR2
50
Yes
No
Active
Mixed Case company name (DBA) for an observer contractor.
VARCHAR2
3
EMPLOYER_TYPE
VARCHAR2
1
Yes
No
Active
Alpha Code Domain identifying the observer contractors relationship with NMFS (D - Direct, C - Contractor, S - Subcontractor)
VARCHAR2
4
ADDRESS
VARCHAR2
50
No
No
Active
Street address for an observer contractor.
VARCHAR2
5
CITY
VARCHAR2
25
No
No
Active
Address - City
VARCHAR2
6
STATE
VARCHAR2
2
No
No
Active
US State Code
VARCHAR2
7
ZIP
VARCHAR2
10
No
No
Active
US Postal Code
VARCHAR2
8
ACTIVE_FLAG
VARCHAR2
1
Yes
No
Active
Boolean indicater for currently operating
VARCHAR2
9
MANAGER
VARCHAR2
50
No
No
Active
Company Contact for observer affairs.
VARCHAR2
10
EMAIL
VARCHAR2
50
No
No
Active
Primary email adderss for manager.
VARCHAR2
11
PHONE
NUMBER
22
No
No
16
0
Active
Primary phone number for manager
NUMBER
12
FAX
NUMBER
22
No
No
16
0
Active
Primary fax number for observer contracting firm.
NUMBER
13
NOTES
VARCHAR2
500
No
No
Active
Notes regarding observer contractor or procedures.
VARCHAR2
12293
Table: OLS_LOV_LOCATION
OLS_LOV_LOCATION
Published / External
Completed
This entity represents the location at which an observer debriefing is scheduled.
Loaded by batch 3083, 04-19-2012 13:25
Data Table
Yes
NORPAC
This entity represents the location at which an observer debriefing is scheduled.
1
LOCATION_CODE
VARCHAR2
3
Yes
Yes
Active
Three Letter Alpha code identifying the location at which an observer debriefing is scheduled.
VARCHAR2
2
DESCRIPTION
VARCHAR2
50
Yes
No
Active
Full name of location at which debriefings ar scheduled. e.g. SEATTLE WA
VARCHAR2
12294
Table: OLS_LOV_QUESTION
OLS_LOV_QUESTION
Published / External
Completed
This entity Combines the question text to a set and subset for presentation to the debriefer.
Loaded by batch 3083, 04-19-2012 13:25
Data Table
Yes
NORPAC
This entity Combines the question text to a set and subset for presentation to the debriefer.
1
QUESTION_SEQ
NUMBER
22
Yes
Yes
9
0
Active
Sequence generated unique identifier for a debriefing evaluation question.
NUMBER
2
QUESTION_NUMBER
NUMBER
22
Yes
No
3
0
Active
Presentation order of the questions
NUMBER
3
QUESTION_TEXT_SEQ
NUMBER
22
Yes
No
9
0
Active
Sequence generated unique identifier of an evaluation question
NUMBER
NORPAC.OLS_LOV_QUESTION_TEXT
4
QUESTION_SUBSET_SEQ
NUMBER
22
Yes
No
9
0
Active
Sequence generated unique identifier of a question subset record.
NUMBER
NORPAC.OLS_LOV_QUESTION_SUBSET
5
QUESTION_SET_SEQ
NUMBER
22
Yes
No
9
0
Active
Sequence generated unique identifier of a question set record
NUMBER
NORPAC.OLS_LOV_QUESTION_SET
6
ACTIVE_FLAG
VARCHAR2
1
Yes
No
Active
Binary identifier of whether the question is available to the evaluation or not
VARCHAR2
12295
Table: OLS_LOV_QUESTION_SET
OLS_LOV_QUESTION_SET
Published / External
Completed
This entity represents the broad categories to which a question may be displayed. For example: Trawl, Longliner, Plant, Combination
Loaded by batch 3083, 04-19-2012 13:25
Data Table
Yes
NORPAC
This entity represents the broad categories to which a question may be displayed. For example: Trawl, Longliner, Plant, Combination
1
QUESTION_SET_SEQ
NUMBER
22
Yes
Yes
9
0
Active
Sequence generated unique identifier of a question set record
NUMBER
2
DESCRIPTION
VARCHAR2
250
Yes
No
Active
Description of the set of question ( trawl, longline, both etc)
VARCHAR2
12296
Table: OLS_LOV_QUESTION_SUBSET
OLS_LOV_QUESTION_SUBSET
Published / External
Completed
This entity represent the grouping of questions within a set as for example logbook
Loaded by batch 3083, 04-19-2012 13:25
Data Table
Yes
NORPAC
This entity represent the grouping of questions within a set as for example logbook
1
QUESTION_SUBSET_SEQ
NUMBER
22
Yes
Yes
9
0
Active
Sequence generated unique identifier of a question subset record.
NUMBER
2
DESCRIPTION
VARCHAR2
250
Yes
No
Active
Text describing the question subset e.g. 'LOGBOOK'
VARCHAR2
12297
Table: OLS_LOV_QUESTION_TEXT
OLS_LOV_QUESTION_TEXT
Published / External
Completed
This entity contains the text of a question which may be applied to multiple sets and subsets for presentation.
Loaded by batch 3083, 04-19-2012 13:25
Data Table
Yes
NORPAC
This entity contains the text of a question which may be applied to multiple sets and subsets for presentation.
1
QUESTION_TEXT_SEQ
NUMBER
22
Yes
Yes
9
0
Active
Sequence generated unique identifier of an evaluation question
NUMBER
2
TEXT
VARCHAR2
250
Yes
No
Active
Test of the question which is presented to the debrifer and observer.
VARCHAR2
12298
Table: OLS_LOV_REQMNT_SATSFD_CDS
OLS_LOV_REQMNT_SATSFD_CDS
Published / External
Completed
codes to indicate how an observer requirement was satisfied or met.
Loaded by batch 3083, 04-19-2012 13:25
Data Table
Yes
NORPAC
codes to indicate how an observer requirement was satisfied or met.
1
REQ_SATSFD_SEQ
NUMBER
22
Yes
Yes
9
0
Active
unique code to indicate how a requirement was staisfied.
NUMBER
2
DESCRIPTION
VARCHAR2
20
Yes
No
Active
description of requirement satified code
VARCHAR2
12299
Table: OLS_LOV_REQUIREMENT
OLS_LOV_REQUIREMENT
Published / External
Completed
This entity represents the list of conditions and requirements. The implimentation will facilitate software in determining training for new and returning observers.
Loaded by batch 3083, 04-19-2012 13:25
Data Table
Yes
NORPAC
This entity represents the list of conditions and requirements. The implimentation will facilitate software in determining training for new and returning observers.
1
REQUIREMENT_CODE
VARCHAR2
10
Yes
Yes
Active
Unique Alpha code identifying an observer qualifying requirement
VARCHAR2
2
DESCRIPTION
VARCHAR2
150
Yes
No
Active
Text describing this requirement.
VARCHAR2
3
ACTIVE_DATE
DATE
7
Yes
No
Active
Mandatory date after which qualification must be met
DATE
4
RETIRED_DATE
DATE
7
No
No
Active
Date after which this qualification requirement no longer applies.
DATE
5
REQUIREMENT_GROUP
VARCHAR2
4
No
No
Active
Indciates a group of requirements that is used with the group level to determine when a requirement is superceded.
VARCHAR2
6
REQUIREMENT_LEVEL_GROUP
NUMBER
22
No
No
3
0
Active
used with the group to determine when a requirement is superceded. A higher level in the group can supercede a lower level.
NUMBER
12300
Table: OLS_LOV_STAFF
OLS_LOV_STAFF
Published / External
Completed
List of FMA debriefing, and training personnel. This table was renamed from the old norpac STAFF
Loaded by batch 3083, 04-19-2012 13:25
Data Table
Yes
NORPAC
List of FMA debriefing, and training personnel. This table was renamed from the old norpac STAFF
1
STAFF_ID
NUMBER
22
Yes
Yes
9
0
Active
Sequence derived unique identifier of an employee.
NUMBER
2
STAFF_CODE
VARCHAR2
3
Yes
No
Active
Three Letter acroynym uniquely identifying an employee.
VARCHAR2
3
NAME
VARCHAR2
60
Yes
No
Active
Full Name of Employee
VARCHAR2
4
ACTIVE_FLAG
VARCHAR2
1
No
No
Active
Boolean indicator of employee status. Active(T) Inactive(F)
VARCHAR2
5
ORACLE_USERID
VARCHAR2
30
No
No
Active
OFIS assigned Oracle user name
VARCHAR2
6
EMAIL_ADDRESS
VARCHAR2
60
No
No
Active
Email address of the debriefer-inseason advisor.
VARCHAR2
12301
Table: OLS_LOV_STAFF_ROLE
OLS_LOV_STAFF_ROLE
Published / External
Completed
FMA staff fill a number of overlapping job responsibilites and roles. Among these are debriefer, trainer, inseason advision. In prior iterations this was tracked by a series of flags on the staff table. This is now expanded to include temporal information as well. This entity represents the list of roles to which a staff member may be assigned.
Loaded by batch 3083, 04-19-2012 13:25
Data Table
Yes
NORPAC
FMA staff fill a number of overlapping job responsibilites and roles. Among these are debriefer, trainer, inseason advision. In prior iterations this was tracked by a series of flags on the staff table. This is now expanded to include temporal information as well. This entity represents the list of roles to which a staff member may be assigned.
1
ROLE_CODE
VARCHAR2
10
Yes
Yes
Active
Alpha code uniquely identifying a staff members primary job performance roles.
VARCHAR2
2
DESCRIPTION
VARCHAR2
500
Yes
No
Active
Brief descrition of the role identified by a unique code.
VARCHAR2
12302
Table: OLS_LOV_TEST
OLS_LOV_TEST
Published / External
Completed
Loaded by batch 3083, 04-19-2012 13:25
Data Table
Yes
NORPAC
Information on tests given during various training classes.
1
TEST_SEQ
NUMBER
22
Yes
Yes
9
0
Active
Sequence generated unique identifier for a test instrument
NUMBER
2
TEST_SEQ_IN_CLASS
NUMBER
22
Yes
No
9
0
Active
Order the tests are given in a class
NUMBER
3
DESCRIPTION
VARCHAR2
500
Yes
No
Active
Descriptive text of the format, purpose and evaluation for this version of this examination.
VARCHAR2
4
MINIMUM_PASS
NUMBER
22
Yes
No
3
0
Active
Percentage as a whole number that is required to pass this test
NUMBER
5
MANDATORY_FLAG
VARCHAR2
1
Yes
No
Active
Boolean indicator of whether or not this emanination is mandatory for certification at this level.
VARCHAR2
6
CLASS_TYPE_CODE
VARCHAR2
3
Yes
No
Active
Class that the test is for e.g. 3WK
VARCHAR2
NORPAC.OLS_LOV_TRAINING_TYPE
7
END_DATE
DATE
7
No
No
Active
last date the test was used or when it was replaced
DATE
12303
Table: OLS_LOV_TRAINING_LEVEL
OLS_LOV_TRAINING_LEVEL
Published / External
Completed
This entity is adapted from the old logistics system Training_Levels. It represents the purpose in terms of deployment, specialized, and optional training.
Loaded by batch 3083, 04-19-2012 13:25
Data Table
Yes
NORPAC
This entity is adapted from the old logistics system Training_Levels. It represents the purpose in terms of deployment, specialized, and optional training.
1
TRAINING_LEVEL_SEQ
NUMBER
22
Yes
Yes
9
0
Active
Sequence generated training level unique identifier.
NUMBER
2
DESCRITIPION
VARCHAR2
150
Yes
No
Active
Descriptive text of purpose and result of training.
VARCHAR2
3
CRUISE_ASSIGN_FLAG
VARCHAR2
1
No
No
Active
Yes-No identifier if this is required for the creation of an observer cruise record.
VARCHAR2
12304
Table: OLS_LOV_TRAINING_TYPE
OLS_LOV_TRAINING_TYPE
Published / External
Completed
This entitiy is the list of valid class duration and scope descriptions including inception date and retirement date e.g. 5DY, 5CQ etc.
Loaded by batch 3083, 04-19-2012 13:25
Data Table
Yes
NORPAC
This entitiy is the list of valid class duration and scope descriptions including inception date and retirement date e.g. 5DY, 5CQ etc.
1
TYPE_CODE
VARCHAR2
3
Yes
Yes
Active
Three Letter Code identifying duration, fishery or segment to which an observer training session applies.
VARCHAR2
2
TRAINING_LEVEL_SEQ
NUMBER
22
Yes
No
9
0
Active
Sequence generated training level unique identifier.
NUMBER
NORPAC.OLS_LOV_TRAINING_LEVEL
3
DESCRIPTION
VARCHAR2
50
No
No
Active
Description of training length, fishery, segment and purpose.
VARCHAR2
4
ACTIVE_DATE
DATE
7
Yes
No
Active
Date from which this training is available to be assigned.
DATE
5
RETIRED_DATE
DATE
7
No
No
Active
Date from which this training will no longer be available.
DATE
12305
Table: OLS_LOV_TRIP_CODES
OLS_LOV_TRIP_CODES
Published / External
Completed
This entity represents the list of valid roles that an observer may be assume during an assignment to a vessel or a plant.
Loaded by batch 3083, 04-19-2012 13:25
Data Table
Yes
NORPAC
This entity represents the list of valid roles that an observer may be assume during an assignment to a vessel or a plant.
1
TRIP_CODE
VARCHAR2
3
Yes
Yes
Active
trip code describes the observers role on a cruise deployment
VARCHAR2
2
TRIP_DESCRIPTION
VARCHAR2
45
No
No
Active
description of the trip code or observer role on a cruise
VARCHAR2
12306
Table: OLS_LOV_USER_PAGES
OLS_LOV_USER_PAGES
Published / External
Completed
Defines what roles in oracle have what access to what pages in an apex application. This table provides the vehicle by which user access (through granted database roles) to various sections of the APEX user interface is controled.
Loaded by batch 3083, 04-19-2012 13:25
Data Table
Yes
NORPAC
Defines what roles in oracle have what access to what pages in an apex application. This table provides the vehicle by which user access (through granted database roles) to various sections of the APEX user interface is controled.
1
USER_PAGES_SEQ
NUMBER
22
Yes
No
9
0
Active
Oracle sequence generated unique identifier of a user page permissions record.
NUMBER
2
APPLICATION_ID
NUMBER
22
Yes
No
38
Active
APEX application id for the application being controlled
NUMBER
3
PAGE_NUMBER
NUMBER
22
Yes
No
38
Active
APEX application page number
NUMBER
4
ROLE
VARCHAR2
30
Yes
No
Active
Oracle role controlling the page access
VARCHAR2
5
READ
VARCHAR2
1
Yes
No
Active
Flag indicating the permission to allow role to read page
VARCHAR2
6
ADD_UPDATE
VARCHAR2
1
Yes
No
Active
Y|N to allow role toadd - update page
VARCHAR2
7
DELETE_DATA
VARCHAR2
1
Yes
No
Active
indicates if user role can delete data on an application page.
VARCHAR2
12307
Table: OLS_MID_CRUISE_DETAIL
OLS_MID_CRUISE_DETAIL
Published / External
Completed
Contains mid cruise comments for an observers cruise created by debriefing staff. A mid cruise review may be required for new observers or those for whom data or process problems have been identified by inseason staff. The comments recorded here provide guidance to debriefing personnel and provide information to inseason advisors about progress or areas of continued concern.
Loaded by batch 3083, 04-19-2012 13:25
Data Table
Yes
NORPAC
Contains mid cruise comments for an observers cruise created by debriefing staff. A mid cruise review may be required for new observers or those for whom data or process problems have been identified by inseason staff. The comments recorded here provide guidance to debriefing personnel and provide information to inseason advisors about progress or areas of continued concern.
1
MID_CRUISE_SEQ
NUMBER
22
Yes
Yes
9
0
Active
Mid cruise sequence
NUMBER
2
CRUISE
NUMBER
22
Yes
No
9
0
Active
Cruise number the mid cruise pertains to.
NUMBER
NORPAC.OLS_OBSERVER_CRUISE
3
STAFF_DEBRIEFER
NUMBER
22
Yes
No
9
0
Active
Debriefer number (staff_id)creating mid cruise debriefing
NUMBER
NORPAC.OLS_LOV_STAFF
4
CREATE_DATE
DATE
7
Yes
No
Active
Date mid cruise created
DATE
5
LOCATION
VARCHAR2
3
Yes
No
Active
Location code for where mid cruise debriefing takes place.
VARCHAR2
NORPAC.OLS_LOV_LOCATION
6
LAST_UPDATED_BY
NUMBER
22
No
No
9
0
Active
Last debriefer updating the mid cruise.
NUMBER
7
LAST_UPDATE_DATE
DATE
7
No
No
Active
Date the mid cruise was last updated.
DATE
8
MID_CRUISE_COMMENT
CLOB
4000
No
No
Active
Discussion of the process used and results of the mid-cruise review.
CLOB
12308
Table: OLS_MONITOR
OLS_MONITOR
Published / External
Completed
Contains mid cruise comments for an observers cruise created by debriefing staff. A mid cruise review may be required for new observers or those for whom data or process problems have been identified by inseason staff. The comments recorded here provide guidance to debriefing personnel and provide information to inseason advisors about progress or areas of continued concern.
Loaded by batch 3083, 04-19-2012 13:25
Data Table
Yes
NORPAC
Contains mid cruise comments for an observers cruise created by debriefing staff. A mid cruise review may be required for new observers or those for whom data or process problems have been identified by inseason staff. The comments recorded here provide guidance to debriefing personnel and provide information to inseason advisors about progress or areas of continued concern.
1
MONITOR_SEQ
NUMBER
22
Yes
No
38
Active
Unique identifier for a application monitor record.
NUMBER
2
USER_NAME
VARCHAR2
10
Yes
No
Active
user name that posted the entry into the table
VARCHAR2
3
APPLICATION
VARCHAR2
30
Yes
No
Active
application name that posted the entry.
VARCHAR2
4
MODULE
VARCHAR2
30
Yes
No
Active
module name that posted the entry
VARCHAR2
5
OLS_MONITOR_DATE
DATE
7
Yes
No
Active
date entry was posted to the table
DATE
6
MSG
VARCHAR2
100
No
No
Active
message posted by application module
VARCHAR2
7
MSG_TYPE
VARCHAR2
1
No
No
Active
message type posted, usually an error
VARCHAR2
12309
Table: OLS_OBSERVER
OLS_OBSERVER
Published / External
Completed
This entity rpresents the list of past and current observers, as well as information critical to FMA for current deployment and future availability.
Loaded by batch 3083, 04-19-2012 13:25
Data Table
Yes
NORPAC
This entity rpresents the list of past and current observers, as well as information critical to FMA for current deployment and future availability.
1
OBSERVER_SEQ
NUMBER
22
Yes
Yes
9
0
Active
A unique number that identifies a specific observer.
NUMBER
2
FIRST_NAME
VARCHAR2
30
Yes
No
Active
The first name of the observer.
VARCHAR2
3
LAST_NAME
VARCHAR2
30
Yes
No
Active
The last name of the observer.
VARCHAR2
4
MIDDLE_NAME
VARCHAR2
30
No
No
Active
The middle name of the observer.
VARCHAR2
5
LAST_PHYSICAL_DATE
DATE
7
No
No
Active
Date of the observers last physical and determination of fitness for duty.
DATE
6
REHIRE_STATUS_CODE
VARCHAR2
2
Yes
No
Active
A two-digit alpha code indicating the rehire status of the observer. EL = eligible for rehire; NE = not eligible for rehire; NA = not applicable (hasn't gone out yet).
VARCHAR2
7
RESUME_ON_FILE_FLAG
VARCHAR2
1
Yes
No
Active
A one-digit alpha code indicating whether the observer's resume is on file or not. Y = Yes; N = No.
VARCHAR2
8
CREATE_DATE
DATE
7
No
No
Active
Date record was input into database. Timestamped by the server
DATE
9
LAST_UPDATE_DATE
DATE
7
No
No
Active
Date data record was last altered. First entered in Date data record was last altered.
DATE
10
LAST_UPDATED_BY
VARCHAR2
30
Yes
No
Active
User whose session who last altered data record.
VARCHAR2
11
CON_AGREE_DATE
DATE
7
No
No
Active
Date of latest confidentiality agreement
DATE
12
LETTER_UNDERSTAND_DATE
DATE
7
No
No
Active
Date of latest letter of understanding
DATE
13
DATE_OF_BIRTH
DATE
7
No
No
Active
Observer Birth Date
DATE
14
SEX_CODE
VARCHAR2
1
No
No
Active
Observers sex code ( May not be known)
VARCHAR2
12310
View: OLS_OBSERVER_COMMENTS_V
OLS_OBSERVER_COMMENTS_V
Published / External
Completed
Summarizes the all observer contracts to satisfy old norpac reports requirements
Loaded by batch 3083, 04-19-2012 13:25
Data View
Yes
NORPAC
Summarizes the all observer contracts to satisfy old norpac reports requirements
1
CRUISE
NUMBER
22
No
No
9
0
Active
Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record.
NUMBER
2
PERMIT
VARCHAR2
6
No
No
Active
Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau
VARCHAR2
3
VESSEL_PLANT_SEQ
NUMBER
22
No
No
38
Active
Sequence generated value for an observer deployment record.
NUMBER
4
COMMENT_TYPE
CHAR
3
No
No
Active
Type of comment.
CHAR
5
STAFF_ID
VARCHAR2
30
No
No
Active
Sequence derived unique identifier of an employee.
VARCHAR2
6
COMMENTS
VARCHAR2
4000
No
No
Active
FMA staff-entered comments regarding an observer deployment.
VARCHAR2
12311
Table: OLS_OBSERVER_CONTACT
OLS_OBSERVER_CONTACT
Published / External
Completed
Loaded by batch 3083, 04-19-2012 13:25
Data Table
Yes
NORPAC
Contact information for an observer.
1
OBSERVER_CONTACT_SEQ
NUMBER
22
Yes
Yes
9
0
Active
Sequence generated uniquie identifier of a contact record.
NUMBER
2
OBSERVER_SEQ
NUMBER
22
Yes
No
9
0
Active
A unique number that identifies a specific observer.
NUMBER
NORPAC.OLS_OBSERVER
3
ADDRESS_LINE_1
VARCHAR2
60
No
No
Active
First line of street Address or POBox
VARCHAR2
4
ADDRESS_LINE_2
VARCHAR2
60
No
No
Active
Second optional line of an address.
VARCHAR2
5
CITY
VARCHAR2
60
No
No
Active
Address City
VARCHAR2
6
STATE_CODE
VARCHAR2
30
No
No
Active
State or Province of Address
VARCHAR2
7
COUNTRY
VARCHAR2
30
No
No
Active
Address Country
VARCHAR2
8
POSTAL_CODE
VARCHAR2
10
No
No
Active
US or other postal code.
VARCHAR2
9
EMAIL_ADDRESS
VARCHAR2
60
No
No
Active
Contact Email Address
VARCHAR2
10
PHONE_NUMBER
VARCHAR2
15
No
No
Active
Country Code, City Code and Phone number for this contact record.
VARCHAR2
11
FRIMARY_CONTACT_FLAG
VARCHAR2
1
Yes
No
Active
Binary indicator of Primary Contact Record. Only one record may be identified a primary at any time.
VARCHAR2
12
BEGIN_EFFECTIVE_DATE
DATE
7
Yes
No
Active
Date record becomes effective
DATE
13
END_EFFECTIVE_DATE
DATE
7
No
No
Active
Date record ought to be retired.
DATE
12312
Table: OLS_OBSERVER_CONTRACT
OLS_OBSERVER_CONTRACT
Published / External
Completed
Loaded by batch 3083, 04-19-2012 13:25
Data Table
Yes
NORPAC
Contract iformation for every contract an observer has had.
1
CONTRACT_NUMBER
NUMBER
22
Yes
Yes
9
0
Active
Unique identifier of a contract between an observer provider and an observer.
NUMBER
2
OBSERVER_SEQ
NUMBER
22
Yes
No
9
0
Active
A unique number that identifies a specific observer.
NUMBER
NORPAC.OLS_OBSERVER
3
EMPLOYER_CODE
VARCHAR2
3
Yes
No
Active
Three letter acronym forced to all caps representing a unique observer contractor
VARCHAR2
NORPAC.OLS_LOV_EMPLOYER
4
CONTRACT_STATUS
VARCHAR2
1
Yes
No
Active
Domain of valid contract status' (T- In Training, N - Not Deployed, D - Deployed, S - Deployed Scheduled, C - Closed, I - In Debriefing, E - Evaluated)
VARCHAR2
NORPAC.OLS_LOV_CONTRACT_STATUS
5
CREATE_DATE
DATE
7
Yes
No
Active
System generated timestamp for the date that contract record was created.
DATE
6
CREATED_BY
VARCHAR2
30
Yes
No
Active
System identified user who created this record
VARCHAR2
7
LAST_UPDATE_DATE
DATE
7
No
No
Active
System generated timestamp executed by after update trigger.
DATE
8
LAST_UPDATED_BY
VARCHAR2
30
No
No
Active
System identified user who updated this record
VARCHAR2
9
CONTRACT_END_DATE
DATE
7
No
No
Active
Contract close out or end date
DATE
10
CONTRACT_COMMENT
VARCHAR2
100
No
No
Active
close out comment if abnormal contract end
VARCHAR2
11
CONTRACT_ENDED_BY_USER
VARCHAR2
30
No
No
Active
User who closed or ended the contract.
VARCHAR2
12
CONTRACT_END_REASON
VARCHAR2
3
No
No
Active
Reason code for contract end
VARCHAR2
NORPAC.OLS_LOV_CONTRACT_CLOSE_
13
CONTRACT_END_REASON_COMMENT
VARCHAR2
200
No
No
Active
Comment added when contract not ended normally. Required for end reason code of other.
VARCHAR2
12313
Table: OLS_OBSERVER_CRUISE
OLS_OBSERVER_CRUISE
Published / External
Completed
This entity represents the intersection of the catch account and logistics subsystems. While an observer contract usually contains a singe cruise, some unique instances prevent this from being a subtype of OLS_Observer_Contract.
Loaded by batch 3083, 04-19-2012 13:25
Data Table
Yes
NORPAC
This entity represents the intersection of the catch account and logistics subsystems. While an observer contract usually contains a singe cruise, some unique instances prevent this from being a subtype of OLS_Observer_Contract.
1
CRUISE
NUMBER
22
Yes
Yes
9
0
Active
Sequence generated cruise number.
NUMBER
2
CONTRACT_NUMBER
NUMBER
22
Yes
No
9
0
Active
Unique identifier of a contract between an observer provider and an observer.
NUMBER
NORPAC.OLS_OBSERVER_CONTRACT
3
DEPLOYMENT_DATE
DATE
7
No
No
Active
Date of initial deployment of the Observer to the field.
DATE
4
DATE_OF_ENTRY
DATE
7
Yes
No
Active
Time stamp of record creation
DATE
12314
View: OLS_OBSERVER_CRUISE_VESSEL_V
OLS_OBSERVER_CRUISE_VESSEL_V
Published / External
Completed
Loaded by batch 3083, 04-19-2012 13:25
Data View
Yes
NORPAC
This entity represents the list of observers, as well as information about their deployments.
1
VESSEL_PLANT_SEQ
NUMBER
22
Yes
No
9
0
Active
Sequence generated value for an observer deployment record.
NUMBER
2
CRUISE
NUMBER
22
Yes
No
9
0
Active
Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record.
NUMBER
3
PERMIT
VARCHAR2
6
No
No
Active
Unique code identifying a vessel or processor - inherited from the NORPAC data set and created by the RAM division in Juneau
VARCHAR2
4
OBSERVER_SEQ
NUMBER
22
Yes
No
9
0
Active
Sequence generated value for an observer
NUMBER
5
LAST_NAME
VARCHAR2
30
Yes
No
Active
Last name of observer.
VARCHAR2
6
FIRST_NAME
VARCHAR2
30
Yes
No
Active
First name of observer.
VARCHAR2
7
DATE_OF_BIRTH
DATE
7
No
No
Active
Observer's date of birth.
DATE
8
TRIPS_JOIN
NUMBER
22
Yes
No
8
0
Active
An assigned number (up to eight digits) that uniquely identifies each cruise_vessel trip.
NUMBER
12315
Table: OLS_OBSERVER_PHOTO_ID
OLS_OBSERVER_PHOTO_ID
Published / External
Completed
Loaded by batch 3083, 04-19-2012 13:25
Data Table
Yes
NORPAC
Table of observer id photos for observer badge.
1
PHOTO_BLOB
BLOB
4000
No
No
Active
The observer photo as a blob
BLOB
2
OBSERVER_JOIN
NUMBER
22
Yes
No
6
0
Active
Observer number for the photo
NUMBER
12316
Table: OLS_OBSERVER_REQUIREMENT
OLS_OBSERVER_REQUIREMENT
Published / External
Completed
This entity represents the intersection of the set of mandatory requirements and an observer, as well as the precidence of the requirement. For example: a three week training always satisfies a four day training requirement. A one day training may be waived. A four day may be required in lieu of a one day training if an observer is having performance issues.
Loaded by batch 3083, 04-19-2012 13:25
Data Table
Yes
NORPAC
This entity represents the intersection of the set of mandatory requirements and an observer, as well as the precidence of the requirement. For example: a three week training always satisfies a four day training requirement. A one day training may be waived. A four day may be required in lieu of a one day training if an observer is having performance issues.
1
REQUIREMENT_SEQ
NUMBER
22
Yes
Yes
9
0
Active
unique pk seq number
NUMBER
2
REQUIREMENT_CODE
VARCHAR2
10
Yes
No
Active
Unique Alpha code identifying an observer qualifying requirement
VARCHAR2
NORPAC.OLS_LOV_REQUIREMENT
3
OBSERVER_SEQ
NUMBER
22
Yes
No
9
0
Active
A unique number that identifies a specific observer.
NUMBER
NORPAC.OLS_OBSERVER
4
REQ_SATSFD_SEQ
NUMBER
22
No
No
9
0
Active
FK to list of requirement status codes indicating stage or condition of requirement satisfaction.
NUMBER
5
DATE_SATISFIED
DATE
7
No
No
Active
The data that training or time at seq qualification was completed.
DATE
6
OTHER_DESCRIPTION
VARCHAR2
1000
No
No
Active
Comments relating to this traing or days at sea requirement.
VARCHAR2
7
REQUIREMENT_ADD_DATE
DATE
7
No
No
Active
Date requirement was added to the observer
DATE
8
REQUIREMENT_ADD_BY
VARCHAR2
30
No
No
Active
staff member who added requirement
VARCHAR2
12317
Table: OLS_OBSERVER_TRAINING
OLS_OBSERVER_TRAINING
Published / External
Completed
This entity represents a record of the training classes that observer has been enrolled in and or attended.
Loaded by batch 3083, 04-19-2012 13:25
Data Table
Yes
NORPAC
This entity represents a record of the training classes that observer has been enrolled in and or attended.
1
OBSERVER_TRAINING_SEQ
NUMBER
22
Yes
Yes
9
0
Active
Unique identifier of an observer training record.
NUMBER
2
OBSERVER_SEQ
NUMBER
22
Yes
No
9
0
Active
FK identifier of an OLS observer record.
NUMBER
NORPAC.OLS_OBSERVER
3
TRAINING_CLASS_SEQ
NUMBER
22
Yes
No
9
0
Active
FK Identifier of an OLS training class record
NUMBER
NORPAC.OLS_TRAINING_CLASS
4
OBSERVER_CLASS_GRADE
VARCHAR2
1
No
No
Active
Passed, Failed, Dropped, No Show, Dismissed etc
VARCHAR2
5
TRAINING_COMMENT
VARCHAR2
2500
No
No
Active
Training comments about the observers work in the class
VARCHAR2
6
REGISTRATION_DATE
DATE
7
Yes
No
Active
date enrolled in class
DATE
12318
Table: OLS_OBS_EMERGENCY_CONTACT
OLS_OBS_EMERGENCY_CONTACT
Published / External
Completed
This entity represents the list of people who ought to be contacted in the event of any critical event during an observer deployment.
Loaded by batch 3083, 04-19-2012 13:25
Data Table
Yes
NORPAC
This entity represents the list of people who ought to be contacted in the event of any critical event during an observer deployment.
1
EMERGENCY_CONTACT_SEQ
NUMBER
22
Yes
Yes
9
0
Active
Sequence generated unique identifier of this emergency contact record
NUMBER
2
OBSERVER_SEQ
NUMBER
22
Yes
No
9
0
Active
A unique number that identifies a specific observer.
NUMBER
NORPAC.OLS_OBSERVER
3
NAME
VARCHAR2
150
Yes
No
Active
Full name of contact
VARCHAR2
4
RELATIONSHIP
VARCHAR2
30
No
No
Active
Relationship to Observer.
VARCHAR2
5
ADDRESS_LINE_1
VARCHAR2
60
No
No
Active
First line of street Address or PO Box
VARCHAR2
6
ADDRESS_LINE_2
VARCHAR2
60
No
No
Active
Second optional line of an address.
VARCHAR2
7
CITY
VARCHAR2
60
No
No
Active
Address City
VARCHAR2
8
STATE_CODE
VARCHAR2
30
No
No
Active
State or Province of Address
VARCHAR2
9
COUNTRY
VARCHAR2
30
No
No
Active
Address Country
VARCHAR2
10
POSTAL_CODE
VARCHAR2
10
No
No
Active
US or other postal code.
VARCHAR2
11
EMAIL_ADDRESS
VARCHAR2
60
No
No
Active
Contact Email Address
VARCHAR2
12
PHONE_NUMBER
VARCHAR2
15
No
No
Active
Country Code, City Code and Phone number for this contact record.
VARCHAR2
13
BEGIN_EFFECTIVE_DATE
DATE
7
Yes
No
Active
Date record becomes effective
DATE
14
END_EFFECTIVE_DATE
DATE
7
No
No
Active
Date record ought to be retired.
DATE
15
FRIMARY_CONTACT_FLAG
VARCHAR2
1
Yes
No
Active
Binary indicator of Primary Contact Record.
VARCHAR2
12319
Table: OLS_PAGES_MENU
OLS_PAGES_MENU
Published / External
Completed
Used by apex plugin to create a DHTL menu for an application. Identifies the relationship between links in the menu and their urls.
Loaded by batch 3083, 04-19-2012 13:25
Data Table
Yes
NORPAC
Used by apex plugin to create a DHTL menu for an application. Identifies the relationship between links in the menu and their urls.
1
MENU_ID
NUMBER
22
Yes
Yes
9
0
Active
primary id for this table (menu-id)
NUMBER
2
MENU_TITLE
VARCHAR2
64
No
No
Active
title as it will appear in the menu
VARCHAR2
3
MENU_TOOLTIP
VARCHAR2
255
No
No
Active
tooltip that may appear when the mouse is over a menu-item
VARCHAR2
4
MENU_TARGET
VARCHAR2
64
No
No
Active
when you're using frames you can populate this differently
VARCHAR2
5
APEX_APP_ID
NUMBER
22
No
No
38
Active
the application_id in which this menu is used
NUMBER
6
APEX_PAGEID
NUMBER
22
No
No
38
Active
the page-id from the apex_application_pages view
NUMBER
7
MENU_URL
VARCHAR2
255
No
No
Active
you can use this to link outside of your apex application
VARCHAR2
8
MENU_PARENTID
NUMBER
22
No
No
38
Active
the menu_id of the parent
NUMBER
9
MENU_ORDER
NUMBER
22
No
No
38
Active
here you can change the order in which menu-items are shown
NUMBER
12320
Table: OLS_STAFF_ROLE
OLS_STAFF_ROLE
Published / External
Completed
FMA staff fill a number of overlapping job responsibilites and roles. Among these are debriefer, trainer, inseason advision. In prior iterations this was tracked by a series of flags on the staff table.
Loaded by batch 3083, 04-19-2012 13:25
Data Table
Yes
NORPAC
FMA staff fill a number of overlapping job responsibilites and roles. Among these are debriefer, trainer, inseason advision. In prior iterations this was tracked by a series of flags on the staff table.
1
ROLE_CODE
VARCHAR2
10
Yes
Yes
Active
Alpha code uniquely identifying a staff members primary job performance roles.
VARCHAR2
NORPAC.OLS_LOV_STAFF_ROLE
2
STAFF_ID
NUMBER
22
Yes
Yes
9
0
Active
Sequence generated unique identifier of an employee, here invoked as a foreign key to the OLS_LOV_STAFF table.
NUMBER
NORPAC.OLS_LOV_STAFF
3
DATE_ASSIGNED
DATE
7
Yes
No
Active
Date when personnel are assigned a new functional role.
DATE
4
DATE_RELIEVED
DATE
7
No
No
Active
Date when a staff member is releived of a specific responsibility.
DATE
5
COMMENTS
VARCHAR2
4000
No
No
Active
Comments - usually management notes as to reasons and purposes.
VARCHAR2
12321
Table: OLS_TEST_SCORE
OLS_TEST_SCORE
Published / External
Completed
Loaded by batch 3083, 04-19-2012 13:25
Data Table
Yes
NORPAC
Keeps a training score for an observer test during training. Retakes of test are indicated by the RETAKE_FLAG.
1
TEST_SCORE_SEQ
NUMBER
22
Yes
Yes
9
0
Active
Sequence generated unique identifier for a test score.
NUMBER
2
TEST_SEQ
NUMBER
22
Yes
No
9
0
Active
Sequence generated unique identifier for a test instrument
NUMBER
NORPAC.OLS_LOV_TEST
3
OBSERVER_TRAINING_SEQ
NUMBER
22
Yes
No
9
0
Active
seq for class the observer was enrolled in to take the test
NUMBER
NORPAC.OLS_OBSERVER_TRAINING
4
EXAMINATION_DATE
DATE
7
Yes
No
Active
Date that the test was taken.
DATE
5
SCORE
NUMBER
22
Yes
No
4
0
Active
Quantitative measurement of performance for a test instance, defined as the raw number of correct answers.
NUMBER
6
PERCENT_CORRECT
NUMBER
22
Yes
No
3
0
Active
Percentage answered correctly. This value is computed by the trainer and not validated.
NUMBER
7
RETAKE_FLAG
VARCHAR2
1
Yes
No
Active
identifier if this score is from a repeat instance of this test
VARCHAR2
12322
Table: OLS_TRAINING_CLASS
OLS_TRAINING_CLASS
Published / External
Completed
Observer training takes place in a formal classroom environment. This entity represents an instance of a class of a particular type held at a centain date or date range
Loaded by batch 3083, 04-19-2012 13:25
Data Table
Yes
NORPAC
Observer training takes place in a formal classroom environment. This entity represents an instance of a class of a particular type held at a centain date or date range
1
TRAINING_CLASS_SEQ
NUMBER
22
Yes
Yes
9
0
Active
Sequence generated unique identifier for an OLS_Training_Class Record.
NUMBER
2
STAFF_ID
NUMBER
22
Yes
No
9
0
Active
Sequence generated unique identifier of an employee.
NUMBER
NORPAC.OLS_LOV_STAFF
3
TYPE_CODE
VARCHAR2
3
Yes
No
Active
Three Letter Code identifying duration, fishery or segment to which an observer training session applies.
VARCHAR2
NORPAC.OLS_LOV_TRAINING_TYPE
4
START_DATE
DATE
7
Yes
No
Active
Date that the class is scheduled to start
DATE
5
END_DATE
DATE
7
No
No
Active
Date that the class is scheduled to end.
DATE
6
CLASS_STATUS
VARCHAR2
1
Yes
No
Active
The status of a class. scheduled, in session, completed, cancelled.
VARCHAR2
7
LOCATION_CODE
VARCHAR2
3
Yes
No
Active
Code identifing where the class is to take place
VARCHAR2
NORPAC.OLS_LOV_LOCATION
12323
Table: OLS_VESSEL_PLANT
OLS_VESSEL_PLANT
Published / External
Completed
This entity represents the deployment, and the current role, of an observer to a vessel or processing plant. This differs from the atl_cruise_vessel and atl_cruise_plant objects in that the deployment is for all observers and the atl_ tables reference only the lead observer (cruise) in that deployment
Loaded by batch 3083, 04-19-2012 13:25
Data Table
Yes
NORPAC
This entity represents the deployment, and the current role, of an observer to a vessel or processing plant. This differs from the atl_cruise_vessel and atl_cruise_plant objects in that the deployment is for all observers and the atl_ tables reference only the lead observer (cruise) in that deployment
1
VESSEL_PLANT_SEQ
NUMBER
22
Yes
Yes
9
0
Active
Sequence generated value for an observer deployment record.
NUMBER
2
PERMIT
VARCHAR2
6
No
No
Active
Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau
VARCHAR2
3
CRUISE
NUMBER
22
Yes
No
9
0
Active
Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record.
NUMBER
NORPAC.OLS_OBSERVER_CRUISE
4
EMBARK_DATE
DATE
7
Yes
No
Active
Date of embarkation
DATE
5
DISEMBARK_DATE
DATE
7
No
No
Active
Date of disembarkation
DATE
6
TRIP_CODE
VARCHAR2
3
No
No
Active
indicates if sole observer , lead observer, or second observer on deployment
VARCHAR2
NORPAC.OLS_LOV_TRIP_CODES
7
SUBCONTRACTOR_CODE
VARCHAR2
3
No
No
Active
subcontractor employer code
VARCHAR2
Data Steward
2010-01-01
Person
Narita, Renold E
ren.narita@noaa.gov
206 526 6697
Distributor
2012
Person
Blair, Julie A
julie.blair@noaa.gov
7600 Sandpoint Way NE
Seattle
WA
98115
USA
206 526 4053
(206)526-4066
0700-1630
FMA
Metadata Contact
2012
Person
Blair, Julie A
julie.blair@noaa.gov
7600 Sandpoint Way NE
Seattle
WA
98115
USA
206 526 4053
(206)526-4066
0700-1630
julie.blair@noaa.gov
Point of Contact
2012
Person
Packer, Paul
Paul.Packer@noaa.gov
206 526 4730
paul.packer@noaa.gov
Point of Contact
2012
Person
Campbell, Glenn
glenn.campbell@noaa.gov
glenn.campbell@noaa.gov
Publication Date
166.53333333333
-117.63333333333
65.85
31.61666666667
Internal to the Alaska Fisheries Science Center
Observer deployment to North Pacific Ocean, Bering Sea and Aleutian Islands region, Gulf of Alaska region.Geographic data, however, is not part of the Observer Logistics System data system. The two main AFSC observer training centers were in Seattle, Washington and Anchorage, Alaska, with field stations in Kodiak and Dutch Harbor Alaska.
Continuing
2012-01-01
Confidential
Confidential Proprietary data under Magnuson-Stevens
Access is restricted to personnel authorized in accordance with NOAA Administrative Order 216-100. A signed non-disclosure agreement must be on file for all authorized personnel requesting access to the data.
Read and sign System Access Application. Contact Ren Narita at :Ren.Narita@noaa.gov for more information.
Access is restricted to personnel authorized in accordance with NOAA Administrative Order 216-100. A signed non-disclosure agreement must be on file for all authorized personnel requesting access to the data.
on aggregated data none
None
None
http://www.afsc.noaa.gov/FMA/default.htm
These data are confidential and may only be accessed from FMA Division
N/A
Not Applicable
Oracle 11.2g Instance; Application interface was developed in APEX4.1 with Java Script browser painting.
N/A
N/A
N/A
N/A
None
N/A
N/A
N/A
N/A
N/A
These are not biological data. Quality is assured by the accuracy required to deploy observers.
Yes
Unknown
No
Yes
N/A
N/A
Confidential under Magnusson Stevens.
No Archiving Intended
N/A
RAID 1 Drives, Tape backup, Complete data histories maintained
These data are the logistics and training records of all observer deployments after 2011
12279
Entity
Table: ATL_LOV_VESSEL
12280
Entity
Table: CRUISE_VESSEL
12282
Entity
Table: OLS_DATA_EDITOR_COMMENT
12283
Entity
Table: OLS_DEBRIEFED_VESSPLANT
12284
Entity
Table: OLS_DEBRIEFING_COMMENT
12285
Entity
Table: OLS_DEBRIEFING_EVALUATION
12286
Entity
Table: OLS_DEBRIEFING_SCHEDULE
12287
Entity
Table: OLS_EVAL_QUEST_ANS
12288
Entity
Table: OLS_LOGISTICS_COMMENT
12289
Entity
Table: OLS_LOV_ANSWER
12290
Entity
Table: OLS_LOV_CONTRACT_CLOSE_REASON
12291
Entity
Table: OLS_LOV_CONTRACT_STATUS
12292
Entity
Table: OLS_LOV_EMPLOYER
12293
Entity
Table: OLS_LOV_LOCATION
12294
Entity
Table: OLS_LOV_QUESTION
12295
Entity
Table: OLS_LOV_QUESTION_SET
12296
Entity
Table: OLS_LOV_QUESTION_SUBSET
12297
Entity
Table: OLS_LOV_QUESTION_TEXT
12298
Entity
Table: OLS_LOV_REQMNT_SATSFD_CDS
12299
Entity
Table: OLS_LOV_REQUIREMENT
12300
Entity
Table: OLS_LOV_STAFF
12301
Entity
Table: OLS_LOV_STAFF_ROLE
12302
Entity
Table: OLS_LOV_TEST
12303
Entity
Table: OLS_LOV_TRAINING_LEVEL
12304
Entity
Table: OLS_LOV_TRAINING_TYPE
12305
Entity
Table: OLS_LOV_TRIP_CODES
12306
Entity
Table: OLS_LOV_USER_PAGES
12307
Entity
Table: OLS_MID_CRUISE_DETAIL
12308
Entity
Table: OLS_MONITOR
12309
Entity
Table: OLS_OBSERVER
12311
Entity
Table: OLS_OBSERVER_CONTACT
12312
Entity
Table: OLS_OBSERVER_CONTRACT
12313
Entity
Table: OLS_OBSERVER_CRUISE
12315
Entity
Table: OLS_OBSERVER_PHOTO_ID
12316
Entity
Table: OLS_OBSERVER_REQUIREMENT
12317
Entity
Table: OLS_OBSERVER_TRAINING
12318
Entity
Table: OLS_OBS_EMERGENCY_CONTACT
12319
Entity
Table: OLS_PAGES_MENU
12320
Entity
Table: OLS_STAFF_ROLE
12321
Entity
Table: OLS_TEST_SCORE
12322
Entity
Table: OLS_TRAINING_CLASS
12323
Entity
Table: OLS_VESSEL_PLANT
12281
Entity
View: OLS_CRUISE_VESSPLNT_V
12310
Entity
View: OLS_OBSERVER_COMMENTS_V
12314
Entity
View: OLS_OBSERVER_CRUISE_VESSEL_V
gov.noaa.nmfs.inport:12269
Doug Turnbull
2012-04-18T19:15:33
SysAdmin InPortAdmin
2023-10-17T16:12:07
2018-09-26
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
2018-09-26
1 Year
2019-09-26