21854
Pacific Islands Region Observer Program System
PIROPS
Data Set
Published / External
9045
Pacific Islands Regional Office Observer Program
Project
In Work
This system integrates the longline debriefing steps and procedures for Hawaii and American Samoa into one tool to standardize and streamline the debriefing process. PIROPS is web-based intranet application available through a browser that is accessible to observers, debriefers, Observer Program Management, Contractor, and Admins.
The purpose of this web-based tool is to standardize and streamline the debriefing steps and process by accessing one portal. This tools eliminates the need to utilize different applications (MS Excel, MS Word, MS Access, Email etc) to perform the debriefing duties by having all data in one place. It will also ensure that debriefing steps are not accidentally overlooked or missed and ensures that users are all on the proverbial same page.
Theme
PARR Exclusion
Non-Environmental Data
Theme
data editing report
Theme
green pencil
Theme
inadequate meals
Theme
incident report
Theme
notes on observers
Theme
observer activity/trainings
Theme
observer feedback on trainings
Theme
observer sea days
Theme
photo search
Theme
photos/videos
Theme
post cruise
Theme
red pencil 1
Theme
red pencil queue
Theme
red pencil verification
Theme
reports
Theme
trip checklist
Theme
trip details
Theme
trip evaluation
Theme
trip notes
Theme
trip overview
Theme
trip search
Theme
users
Theme
vessel arrival info
Theme
vessel history
Spatial
North-Central Pacific Ocean
Pacific Islands Regional Office
Honolulu
HI
United States of America
Data Set
Database
Continually
Table (digital)
Not Applicable
Not Applicable
Not Applicable
21855
Table: Announcements
Announcements
Published / External
In Work
1
ID
INT
4
Yes
Yes
10
Active
2
ANNOUNCEMENT
VARCHAR
2500
No
No
Active
21856
Table: Checklist
Checklist
Published / External
In Work
1
CHECKLISTID
INT
4
Yes
Yes
10
Active
2
TRIPID
INT
4
No
No
10
Active
3
FOBISSUEDYN
CHAR
1
No
No
Active
4
FOBNUMBER
INT
4
No
No
10
Active
5
INCIDENTYN
CHAR
1
No
No
Active
6
PLACEMENTCHECKLISTYN
CHAR
1
No
No
Active
7
PSINVOICEYN
CHAR
1
No
No
Active
8
USFWSYN
CHAR
1
No
No
Active
9
CITESYN
CHAR
1
No
No
Active
10
DATAQCYN
CHAR
1
No
No
Active
11
SPECIMENLOGYN
CHAR
1
No
No
Active
12
BIOLOGICALYN
CHAR
1
No
No
Active
13
DOCNOTEBOOKYN
CHAR
1
No
No
Active
14
ECONOMICDATAYN
CHAR
1
No
No
Active
15
TAGFORMSYN
CHAR
1
No
No
Active
16
PHOTOLOGYN
CHAR
1
No
No
Active
17
IMAGESDOWNLOADEDYN
CHAR
1
No
No
Active
18
SPECIESVERIFIEDYN
CHAR
1
No
No
Active
19
PHOTOSLABELEDYN
CHAR
1
No
No
Active
20
PHOTOSDELETEDYN
CHAR
1
No
No
Active
21
CAMERABAGNUM
VARCHAR
50
No
No
Active
22
CAMERACONDITION
CHAR
1
No
No
Active
23
CAMERACDNUM
VARCHAR
50
No
No
Active
24
CAMERACONDITIONCOMMENTS
VARCHAR
500
No
No
Active
25
CAMERACASECONDITION
CHAR
1
No
No
Active
26
CAMERACASECONDITIONCOMMENTS
VARCHAR
500
No
No
Active
27
GPSCONDITION
CHAR
1
No
No
Active
28
GPSCDNUM
VARCHAR
50
No
No
Active
29
GPSCONDITIONCOMMENTS
VARCHAR
500
No
No
Active
30
SATELLITEPHONECONDITION
CHAR
1
No
No
Active
31
SATELLITEPHONECDNUM
VARCHAR
50
No
No
Active
32
SATELLITEPHONECONDITIONCOMMENTS
VARCHAR
500
No
No
Active
33
PLBCONDITION
CHAR
1
No
No
Active
34
PLBEXPDATE
DATE
3
No
No
Active
35
EPIRBCONDITION
CHAR
1
No
No
Active
36
EPIRBEXPDATE
DATE
3
No
No
Active
37
LODSYN
CHAR
1
No
No
Active
38
BLUEYN
CHAR
1
No
No
Active
39
OPERATIONSYN
CHAR
1
No
No
Active
40
REVIEWEDYN
CHAR
1
No
No
Active
41
LODSVALIDATIONSYN
CHAR
1
No
No
Active
42
DATAREADBACKYN
CHAR
1
No
No
Active
43
DATAQCVERIFIEDYN
CHAR
1
No
No
Active
44
GREENPENCILDISCUSSIONYN
CHAR
1
No
No
Active
45
CURRENTFORMSYN
CHAR
1
No
No
Active
46
BOOKSYN
CHAR
1
No
No
Active
47
TRAININGEVALYN
CHAR
1
No
No
Active
48
DAYSSPENTDEBRIEFING
INT
4
No
No
10
Active
49
FOBRETURNEDYN
CHAR
1
No
No
Active
50
FOBRETURNEDON
DATETIME
8
No
No
Active
51
FOBRETURNEDTO
INT
4
No
No
10
Active
52
EVALEMAILSENTYN
CHAR
1
No
No
Active
53
FINALIZEDYN
CHAR
1
No
No
Active
54
LASTUPDATE
DATETIME
8
No
No
Active
55
LASTUPDATEBY
INT
4
No
No
10
Active
21857
Table: Feedback
Feedback
Published / External
In Work
1
ID
INT
4
Yes
No
10
Active
2
COMMENT
VARCHAR
2500
No
No
Active
3
RESPONSE
VARCHAR
2500
No
No
Active
4
COMMENTFROM
INT
4
No
No
10
Active
5
COMMENTPOSTED
DATETIME
8
No
No
Active
6
STATUS
INT
4
No
No
10
Active
7
LASTUPDATE
DATETIME
8
No
No
Active
8
LASTUPDATEBY
INT
4
No
No
10
Active
21858
Table: GreenPencil
GreenPencil
Published / External
In Work
1
ID
INT
4
Yes
Yes
10
Active
2
TRIPID
INT
4
No
No
10
Active
3
GEARINVENTORY
VARCHAR
-1
No
No
Active
4
GEARINVENTORY2
VARCHAR
-1
No
No
Active
5
PLACEMENTCHECKLIST
VARCHAR
-1
No
No
Active
6
PLACEMENTCHECKLIST2
VARCHAR
-1
No
No
Active
7
ECONOMICDATA
VARCHAR
-1
No
No
Active
8
ECONOMICDATA2
VARCHAR
-1
No
No
Active
9
WCPFC
VARCHAR
-1
No
No
Active
10
WCPFC2
VARCHAR
-1
No
No
Active
11
TRIPSPECIFICATIONS
VARCHAR
-1
No
No
Active
12
TRIPSPECIFICATIONS2
VARCHAR
-1
No
No
Active
13
SETANDHAUL
VARCHAR
-1
No
No
Active
14
SETANDHAUL2
VARCHAR
-1
No
No
Active
15
SEABIRDMITIGATION
VARCHAR
-1
No
No
Active
16
SEABIRDMITIGATION2
VARCHAR
-1
No
No
Active
17
GEARCONFIGURATION
VARCHAR
-1
No
No
Active
18
GEARCONFIGURATION2
VARCHAR
-1
No
No
Active
19
PSEVENTLOG
VARCHAR
-1
No
No
Active
20
PSEVENTLOG2
VARCHAR
-1
No
No
Active
21
CATCHEVENTLOG
VARCHAR
-1
No
No
Active
22
CATCHEVENTLOG2
VARCHAR
-1
No
No
Active
23
SEATURTLEFORM
VARCHAR
-1
No
No
Active
24
SEATURTLEFORM2
VARCHAR
-1
No
No
Active
25
MMAMMALFORM
VARCHAR
-1
No
No
Active
26
MMAMMALFORM2
VARCHAR
-1
No
No
Active
27
SEABIRDFORM
VARCHAR
-1
No
No
Active
28
SEABIRDFORM2
VARCHAR
-1
No
No
Active
29
PHOTOLOG
VARCHAR
-1
No
No
Active
30
PHOTOLOG2
VARCHAR
-1
No
No
Active
31
SPECIMENLOG
VARCHAR
-1
No
No
Active
32
SPECIMENLOG2
VARCHAR
-1
No
No
Active
33
TAGEVENT
VARCHAR
-1
No
No
Active
34
TAGEVENT2
VARCHAR
-1
No
No
Active
35
SKETCH
VARCHAR
-1
No
No
Active
36
SKETCH2
VARCHAR
-1
No
No
Active
37
DQSHEET
VARCHAR
-1
No
No
Active
38
DQSHEET2
VARCHAR
-1
No
No
Active
39
REPORTSFILED
VARCHAR
-1
No
No
Active
40
REPORTSFILED2
VARCHAR
-1
No
No
Active
41
PSPAPERWORK
VARCHAR
-1
No
No
Active
42
PSPAPERWORK2
VARCHAR
-1
No
No
Active
43
GENERALCOMMENTS
VARCHAR
-1
No
No
Active
44
GENERALCOMMENTS2
VARCHAR
-1
No
No
Active
45
FINALIZEDYN
CHAR
1
No
No
Active
46
OBSERVERSIGNATUREYN
CHAR
1
No
No
Active
47
NOTES
VARCHAR
2500
No
No
Active
48
OBSLASTUPDATE
DATETIME
8
No
No
Active
49
OBSLASTUPDATEBY
INT
4
No
No
10
Active
50
LASTUPDATE
DATETIME
8
No
No
Active
51
LASTUPDATEBY
INT
4
No
No
10
Active
21859
Table: Incident
Incident
Published / External
In Work
1
INCIDENTID
INT
4
Yes
Yes
10
Active
2
TRIPID
INT
4
No
No
10
Active
3
LATITUDE
VARCHAR
5
No
No
Active
4
LATITUDE2
VARCHAR
5
No
No
Active
5
LATITUDE3
CHAR
1
No
No
Active
6
LONGITUDE
VARCHAR
5
No
No
Active
7
LONGITUDE2
VARCHAR
5
No
No
Active
8
LONGITUDE3
CHAR
1
No
No
Active
9
STARTDATE
DATE
3
No
No
Active
10
STARTTIME
TIME
5
No
No
Active
11
ENDDATE
DATE
3
No
No
Active
12
ENDTIME
TIME
5
No
No
Active
13
INCIDENTTYPEID
INT
4
No
No
10
Active
14
INCIDENTDESCRIPTION
VARCHAR
-1
No
No
Active
15
FINALIZED
CHAR
1
No
No
Active
16
REPORTSIGNEDON
DATETIME
8
No
No
Active
17
REPORTSENTON
DATETIME
8
No
No
Active
18
ELLASTUPDATEBY
INT
4
No
No
10
Active
19
ELLASTUPDATE
DATETIME
8
No
No
Active
20
LASTUPDATE
DATETIME
8
No
No
Active
21
LASTUPDATEBY
INT
4
No
No
10
Active
21860
Table: Lookup_ABCD
Lookup_ABCD
Published / External
In Work
1
ID
CHAR
1
Yes
Yes
Active
2
DESCRIPTION
CHAR
1
No
No
Active
21861
Table: Lookup_ABCDNA
Lookup_ABCDNA
Published / External
In Work
1
ID
CHAR
1
Yes
Yes
Active
2
DESCRIPTION
VARCHAR
12
No
No
Active
21868
Table: Lookup_DorS
Lookup_DorS
Published / External
In Work
1
ID
CHAR
1
Yes
Yes
Active
2
DESCRIPTION
VARCHAR
11
No
No
Active
21869
Table: Lookup_ExperimentalTripType
Lookup_ExperimentalTripType
Published / External
In Work
1
ID
INT
4
Yes
Yes
10
Active
2
DESCRIPTION
VARCHAR
50
No
No
Active
3
ALIAS
CHAR
2
No
No
Active
4
REFCODE
CHAR
3
No
No
Active
21871
Table: Lookup_FOBNums
Lookup_FOBNums
Published / External
In Work
1
ID
INT
4
Yes
Yes
10
Active
2
DESCRIPTION
VARCHAR
2
No
No
Active
21873
Table: Lookup_HookCount
Lookup_HookCount
Published / External
In Work
1
ID
INT
4
Yes
Yes
10
Active
2
DESCRIPTION
VARCHAR
2
No
No
Active
21874
Table: Lookup_IncidentType
Lookup_IncidentType
Published / External
In Work
1
ID
INT
4
Yes
Yes
10
Active
2
DESCRIPTION
VARCHAR
30
No
No
Active
21875
Table: Lookup_LatOrLong
Lookup_LatOrLong
Published / External
In Work
1
ID
CHAR
1
Yes
Yes
Active
2
DESCRIPTION
VARCHAR
5
No
No
Active
21876
Table: Lookup_MeasureMethod
Lookup_MeasureMethod
Published / External
In Work
1
ID
INT
4
Yes
Yes
10
Active
2
DESCRIPTION
VARCHAR
50
No
No
Active
21877
Table: Lookup_Number
Lookup_Number
Published / External
In Work
1
ID
INT
4
Yes
Yes
10
Active
2
DESCRIPTION
VARCHAR
2
No
No
Active
21878
Table: Lookup_Port
Lookup_Port
Published / External
In Work
1
ID
INT
4
Yes
Yes
10
Active
2
DESCRIPTION
VARCHAR
50
No
No
Active
3
SHORTDESCRIPTION
VARCHAR
4
No
No
Active
21879
Table: Lookup_Roles
Lookup_Roles
Published / External
In Work
1
ID
VARCHAR
2
Yes
Yes
Active
2
DESCRIPTION
VARCHAR
50
No
No
Active
21880
Table: Lookup_RptExportFormat
Lookup_RptExportFormat
Published / External
In Work
1
ID
INT
4
Yes
No
10
Active
2
DESCRIPTION
VARCHAR
20
No
No
Active
21881
Table: Lookup_Status1
Lookup_Status1
Published / External
In Work
1
ID
INT
4
Yes
Yes
10
Active
2
DESCRIPTION
VARCHAR
20
No
No
Active
21882
Table: Lookup_TripStatus
Lookup_TripStatus
Published / External
In Work
1
ID
INT
4
Yes
Yes
10
Active
2
DESCRIPTION
VARCHAR
50
No
No
Active
3
ADMINONLY
CHAR
1
No
No
Active
21883
Table: Lookup_Vessel
Lookup_Vessel
Published / External
In Work
1
ID
INT
4
Yes
Yes
10
Active
2
DESCRIPTION
VARCHAR
50
No
No
Active
21884
Table: Lookup_YesNo
Lookup_YesNo
Published / External
In Work
1
ID
CHAR
1
Yes
No
Active
2
DESCRIPTION
VARCHAR
8
No
No
Active
21885
Table: Media
Media
Published / External
In Work
1
ID
INT
4
Yes
No
10
Active
2
TRIPID
INT
4
No
No
10
Active
3
NOTES
VARCHAR
-1
No
No
Active
4
UPLOADFILENAME
VARCHAR
95
No
No
Active
5
UPLOADFILEEXTENSION
VARCHAR
5
No
No
Active
6
UPLOADCONTENTTYPE
VARCHAR
50
No
No
Active
7
DATEVIDEOTAKEN
DATETIME
8
No
No
Active
8
LASTUPDATE
DATETIME
8
No
No
Active
9
LASTUPDATEBY
INT
4
No
No
10
Active
21886
Table: My
My
Published / External
In Work
1
ID
INT
4
Yes
Yes
10
Active
2
NOTES
VARCHAR
-1
No
No
Active
3
PID
INT
4
No
No
10
Active
21887
Table: MyTrips
MyTrips
Published / External
In Work
1
SHORTCUTID
INT
4
Yes
Yes
10
Active
2
USERID
INT
4
No
No
10
Active
3
TRIPID
INT
4
No
No
10
Active
21888
Table: NotesOnObservers
NotesOnObservers
Published / External
In Work
1
ID
INT
4
Yes
Yes
10
Active
2
OBSERVERID
INT
4
Yes
No
10
Active
3
NOTES
VARCHAR
2500
Yes
No
Active
4
STATUS
CHAR
1
No
No
Active
5
LASTUPDATE
DATETIME
8
Yes
No
Active
6
LASTUPDATEBY
INT
4
Yes
No
10
Active
21889
Table: ObserverTrainings
ObserverTrainings
Published / External
In Work
1
ID
INT
4
Yes
Yes
10
Active
2
OBSERVERID
INT
4
Yes
No
10
Active
3
TRAININGTYPE
VARCHAR
50
Yes
No
Active
4
TRAININGDATE
DATE
3
No
No
Active
21890
Table: Persons
Persons
Published / External
In Work
1
PERSONID
INT
4
Yes
Yes
10
Active
2
LASTNAME
VARCHAR
50
No
No
Active
3
FIRSTNAME
VARCHAR
50
No
No
Active
4
EMAIL
VARCHAR
70
No
No
Active
5
PHONE
CHAR
12
No
No
Active
6
EMPLOYER
VARCHAR
50
No
No
Active
7
ACTIVE
CHAR
1
No
No
Active
8
ROLE
VARCHAR
2
No
No
Active
9
USERNAME
VARCHAR
50
No
No
Active
10
ISADMINYN
CHAR
1
No
No
Active
11
NEWOBSERVER
CHAR
1
No
No
Active
21891
Table: PIROPS_System
PIROPS_System
Published / External
In Work
1
ID
INT
4
Yes
Yes
10
Active
2
VALUE
VARCHAR
50
No
No
Active
3
VALUEDESCRIPTION
VARCHAR
50
No
No
Active
21892
Table: PostCruise
PostCruise
Published / External
In Work
1
POSTCRUISEID
INT
4
Yes
Yes
10
Active
2
TRIPID
INT
4
No
No
10
Active
3
VESSELINFO
VARCHAR
2500
No
No
Active
4
COLLECTSPECIMENSYN
CHAR
1
No
No
Active
5
COLLECTSPECIMENS_WHYNO
VARCHAR
500
No
No
Active
6
GEARPROBLEMSYN
CHAR
1
No
No
Active
7
GEARPROBLEMS_WHYYES
VARCHAR
500
No
No
Active
8
OTHERPERFORMDUTIESYN
CHAR
1
No
No
Active
9
OTHERPERFORMDUTIES_WHYYES
VARCHAR
500
No
No
Active
10
SEEHOOKSYN
CHAR
1
No
No
Active
11
SEEHOOKS_WHYNO
VARCHAR
500
No
No
Active
12
HOWOBTAINHOOKCOUNTID
INT
4
No
No
10
Active
13
HOWOBTAINHOOKCOUNT_WHYOTHER
VARCHAR
500
No
No
Active
14
DATAGIVENTOCAPTAINYN
CHAR
1
No
No
Active
15
DATAGIVENTOCAPTAIN_WHYYES
VARCHAR
500
No
No
Active
16
DATAFROMCAPTAINYN
CHAR
1
No
No
Active
17
DATAFROMCAPTAIN_WHYYES
VARCHAR
500
No
No
Active
18
TURTLEINTERACTIONYN
CHAR
1
No
No
Active
19
TURTLEINTERACTION_WHYYES
VARCHAR
500
No
No
Active
20
ADEQUATEMEALSYN
CHAR
1
No
No
Active
21
ADEQUATEMEALS_WHYNO
VARCHAR
500
No
No
Active
22
DEHOOKBYCATCHYN
CHAR
1
No
No
Active
23
DEHOOKBYCATCH_WHYYES
VARCHAR
500
No
No
Active
24
ANYTIMENOTONDECKYN
CHAR
1
No
No
Active
25
ANYTIMENOTONDECK_WHYYES
VARCHAR
500
No
No
Active
26
WEARPFDYN
CHAR
1
No
No
Active
27
WEARPFD_WHYNO
VARCHAR
500
No
No
Active
28
TRYONSURVIVALSUITYN
CHAR
1
No
No
Active
29
TRYONSURVIVALSUIT_WHYNO
VARCHAR
500
No
No
Active
30
CHECKTURTLEPOLEYN
CHAR
1
No
No
Active
31
CHECKTURTLEPOLE_WHYNO
VARCHAR
500
No
No
Active
32
CHECKGEARYN
CHAR
1
No
No
Active
33
CHECKGEAR_WHYNO
VARCHAR
500
No
No
Active
34
SEABIRDINTERACTIONYN
CHAR
1
No
No
Active
35
CREWPREVENTIDYN
CHAR
1
No
No
Active
36
ENCOURAGEDTOSLEEPYN
CHAR
1
No
No
Active
37
NOWHEELWATCHESYN
CHAR
1
No
No
Active
38
SAFETYCOMPROMISEDYN
CHAR
1
No
No
Active
39
PHYSICALINJURIESYN
CHAR
1
No
No
Active
40
FLOATLINESLESSTHAN20YN
CHAR
1
No
No
Active
41
BASKETSLESSTHAN15YN
CHAR
1
No
No
Active
42
MARINECASUALTYYN
CHAR
1
No
No
Active
43
SAFETYDRILLSYN
CHAR
1
No
No
Active
44
MINIMMERSIONSUITSYN
CHAR
1
No
No
Active
45
SEABIRDMITIGATIONYN
CHAR
1
No
No
Active
46
SAFETYEQUIPMOVEDYN
CHAR
1
No
No
Active
47
VESSELACCESSYN
CHAR
1
No
No
Active
48
PAPERCAPTAINYN
CHAR
1
No
No
Active
49
HARRASSMENTYN
CHAR
1
No
No
Active
50
MARPOLYN
CHAR
1
No
No
Active
51
TRANSFERCREWYN
CHAR
1
No
No
Active
52
BEDBUGSYN
CHAR
1
No
No
Active
53
SHARKFINSREMOVEDYN
CHAR
1
No
No
Active
54
TUNAMEASUREID
INT
4
No
No
10
Active
55
SHARKMEASUREID
INT
4
No
No
10
Active
56
SHARKSTUNASMEASUREID
INT
4
No
No
10
Active
57
FISHTRANSFERYN
CHAR
1
No
No
Active
58
RINSECAMERAYN
CHAR
1
No
No
Active
59
TESTEPIRBYN
CHAR
1
No
No
Active
60
CHECKSATPHONEYN
CHAR
1
No
No
Active
61
SIGHTMARINEMAMMALSYN
CHAR
1
No
No
Active
62
LOBSTERPHYLLOSOMA
INT
4
No
No
10
Active
63
IMPORTANTLESSON
VARCHAR
1500
No
No
Active
64
FIRSTTRIP_1
INT
4
No
No
10
Active
65
FIRSTTRIP_1TEXT
VARCHAR
1500
No
No
Active
66
FIRSTTRIP_11
INT
4
No
No
10
Active
67
FIRSTTRIP_1TEXT1
VARCHAR
1500
No
No
Active
68
FIRSTTRIP_2
CHAR
1
No
No
Active
69
FIRSTTRIP_2TEXT
VARCHAR
1500
No
No
Active
70
FIRSTTRIP_3
INT
4
No
No
10
Active
71
FIRSTTRIP_3TEXT
VARCHAR
1500
No
No
Active
72
FIRSTTRIP_4
CHAR
1
No
No
Active
73
FIRSTTRIP_4TEXT
VARCHAR
1500
No
No
Active
74
FIRSTTRIP_5
INT
4
No
No
10
Active
75
FIRSTTRIP_5TEXT
VARCHAR
1500
No
No
Active
76
LASTUPDATE
DATETIME
8
No
No
Active
77
LASTUPDATEBY
INT
4
No
No
10
Active
21893
Table: RedPencil
RedPencil
Published / External
In Work
1
ID
INT
4
Yes
Yes
10
Active
2
TRIPID
INT
4
No
No
10
Active
3
GEARINVENTORY
VARCHAR
-1
No
No
Active
4
PLACEMENTCHECKLIST
VARCHAR
-1
No
No
Active
5
ECONOMICDATA
VARCHAR
-1
No
No
Active
6
WCPFC
VARCHAR
-1
No
No
Active
7
TRIPSPECIFICATIONS
VARCHAR
-1
No
No
Active
8
SETANDHAUL
VARCHAR
-1
No
No
Active
9
SEABIRDMITIGATION
VARCHAR
-1
No
No
Active
10
GEARCONFIGURATION
VARCHAR
-1
No
No
Active
11
PSEVENTLOG
VARCHAR
-1
No
No
Active
12
CATCHEVENTLOG
VARCHAR
-1
No
No
Active
13
SEATURTLEFORM
VARCHAR
-1
No
No
Active
14
MMAMMALFORM
VARCHAR
-1
No
No
Active
15
SEABIRDFORM
VARCHAR
-1
No
No
Active
16
PHOTOLOG
VARCHAR
-1
No
No
Active
17
SPECIMENLOG
VARCHAR
-1
No
No
Active
18
TAGEVENT
VARCHAR
-1
No
No
Active
19
SKETCH
VARCHAR
-1
No
No
Active
20
DQSHEET
VARCHAR
-1
No
No
Active
21
GENERALCOMMENTS
VARCHAR
-1
No
No
Active
22
FULLREADBACKYN
CHAR
1
No
No
Active
23
FINALIZEDYN
CHAR
1
No
No
Active
24
LASTUPDATE
DATETIME
8
No
No
Active
25
LASTUPDATEBY
INT
4
No
No
10
Active
21894
Table: RedPencil2
RedPencil2
Published / External
In Work
1
ID
INT
4
Yes
Yes
10
Active
2
TRIPID
INT
4
No
No
10
Active
3
GEARINVENTORY
VARCHAR
-1
No
No
Active
4
PLACEMENTCHECKLIST
VARCHAR
-1
No
No
Active
5
ECONOMICDATA
VARCHAR
-1
No
No
Active
6
WCPFC
VARCHAR
-1
No
No
Active
7
TRIPSPECIFICATIONS
VARCHAR
-1
No
No
Active
8
SETANDHAUL
VARCHAR
-1
No
No
Active
9
SEABIRDMITIGATION
VARCHAR
-1
No
No
Active
10
GEARCONFIGURATION
VARCHAR
-1
No
No
Active
11
PSEVENTLOG
VARCHAR
-1
No
No
Active
12
CATCHEVENTLOG
VARCHAR
-1
No
No
Active
13
SEATURTLEFORM
VARCHAR
-1
No
No
Active
14
MMAMMALFORM
VARCHAR
-1
No
No
Active
15
SEABIRDFORM
VARCHAR
-1
No
No
Active
16
PHOTOLOG
VARCHAR
-1
No
No
Active
17
SPECIMENLOG
VARCHAR
-1
No
No
Active
18
TAGEVENT
VARCHAR
-1
No
No
Active
19
SKETCH
VARCHAR
-1
No
No
Active
20
DQSHEET
VARCHAR
-1
No
No
Active
21
GENERALCOMMENTS
VARCHAR
-1
No
No
Active
22
FINALIZEDYN
CHAR
1
No
No
Active
23
LASTUPDATE
DATETIME
8
No
No
Active
24
LASTUPDATEBY
INT
4
No
No
10
Active
21895
Table: Reminders
Reminders
Published / External
In Work
1
REMINDERID
INT
4
Yes
Yes
10
Active
2
USERID
INT
4
No
No
10
Active
3
TRIPID
INT
4
No
No
10
Active
4
DUEDATE
DATE
3
No
No
Active
5
TITLE
VARCHAR
150
No
No
Active
6
FROMUSERID
INT
4
No
No
10
Active
7
CREATEDON
DATETIME
8
No
No
Active
21896
Table: Reports
Reports
Published / External
In Work
1
ID
INT
4
Yes
Yes
10
Active
2
REPORTTITLE
VARCHAR
50
No
No
Active
3
EXPORTFILENAME
VARCHAR
50
No
No
Active
4
EXPORTFORMAT
INT
4
No
No
10
Active
5
ALLOWEMAIL
CHAR
1
No
No
Active
6
EMAILTO
VARCHAR
250
No
No
Active
7
SUBJECT
VARCHAR
250
No
No
Active
8
BODY
VARCHAR
250
No
No
Active
21897
Table: Sets
Sets
Published / External
In Work
1
ID
INT
4
Yes
Yes
10
Active
2
TRIPID
INT
4
No
No
10
Active
3
SETNUM
INT
4
No
No
10
Active
4
SETDATE
DATE
3
No
No
Active
5
LOGBOOKPAGE
VARCHAR
7
No
No
Active
6
LASTUPDATE
DATETIME
8
No
No
Active
7
LASTUPDATEBY
INT
4
No
No
10
Active
21898
Table: sysdiagrams
sysdiagrams
Published / External
In Work
1
NAME
NVARCHAR
128
Yes
No
Active
2
PRINCIPAL_ID
INT
4
Yes
No
10
Active
3
DIAGRAM_ID
INT
4
Yes
Yes
10
Active
4
VERSION
INT
4
No
No
10
Active
5
DEFINITION
VARBINARY
-1
No
No
Active
21899
Table: TrainingSurvey
TrainingSurvey
Published / External
In Work
1
ID
INT
4
Yes
Yes
10
Active
2
FULLNAME
VARCHAR
50
No
No
Active
3
TRAININGDATE
DATE
3
No
No
Active
4
SAFETY
TINYINT
1
No
No
Active
5
SAFETY_TEXT
VARCHAR
1500
No
No
Active
6
IDPRESENTATIONS
TINYINT
1
No
No
Active
7
IDPRESENTATIONS_TEXT
VARCHAR
1500
No
No
Active
8
IDMATERIALS
TINYINT
1
No
No
Active
9
IDMATERIALS_TEXT
VARCHAR
1500
No
No
Active
10
TEST
TINYINT
1
No
No
Active
11
TEST_TEXT
VARCHAR
1500
No
No
Active
12
FIELDTRIPS
TINYINT
1
No
No
Active
13
FIELDTRIPS_TEXT
VARCHAR
1500
No
No
Active
14
MANUALPRESENTATIONS
TINYINT
1
No
No
Active
15
MANUALPRESENTATIONS_TEXT
VARCHAR
1500
No
No
Active
16
HOMEWORK
TINYINT
1
No
No
Active
17
HOMEWORK_TEXT
VARCHAR
1500
No
No
Active
18
PRACTICALFINAL
TINYINT
1
No
No
Active
19
PRACTICALFINAL_TEXT
VARCHAR
1500
No
No
Active
20
PRESENTERS
TINYINT
1
No
No
Active
21
PRESENTERS_TEXT
VARCHAR
1500
No
No
Active
22
HOWTOIMPROVE
VARCHAR
1500
No
No
Active
23
APPREHENSIONS
VARCHAR
1500
No
No
Active
24
LASTUPDATE
DATETIME
8
No
No
Active
25
LASTUPDATEBY
VARCHAR
50
No
No
Active
21900
Table: Trip
Trip
Published / External
In Work
1
TRIPID
INT
4
Yes
Yes
10
Active
2
TRIPNUM
NVARCHAR
7
No
No
Active
3
VESSELNAME
VARCHAR
50
No
No
Active
4
PERMITNUM
VARCHAR
20
No
No
Active
5
OPERATOR
VARCHAR
50
No
No
Active
6
OPERATORID
INT
4
No
No
10
Active
7
SATPHONENUM
VARCHAR
15
No
No
Active
8
DEPARTUREDATE
DATE
3
No
No
Active
9
DEPARTUREPORTID
INT
4
No
No
10
Active
10
ARRIVALDATE
DATE
3
No
No
Active
11
ARRIVALPORTID
INT
4
No
No
10
Active
12
TRIPTYPE
CHAR
1
No
No
Active
13
EXPERIMENTALTRIP
CHAR
1
No
No
Active
14
EXPERIMENTALTRIPTYPEID
INT
4
No
No
10
Active
15
TRIPSTATUSID
INT
4
No
No
10
Active
16
INITIALDEBRIEFERID
INT
4
No
No
10
Active
17
OKTODELETEPHOTOSYN
CHAR
1
No
No
Active
18
VESSELARRIVALEMAILSENT
DATETIME
8
No
No
Active
19
VESSELARRIVALEMAILSENTBY
INT
4
No
No
10
Active
20
NOTES
VARCHAR
2500
No
No
Active
21
LASTUPDATE
DATETIME
8
No
No
Active
22
LASTUPDATEBY
INT
4
No
No
10
Active
21901
Table: Upload
Upload
Published / External
In Work
1
ID
INT
4
Yes
Yes
10
Active
2
TRIPID
INT
4
No
No
10
Active
3
INCIDENTID
INT
4
No
No
10
Active
4
UPLOADFILE
VARBINARY
-1
No
No
Active
5
NOTES
VARCHAR
-1
No
No
Active
6
UPLOADFILENAME
VARCHAR
75
No
No
Active
7
UPLOADCONTENTTYPE
VARCHAR
50
No
No
Active
8
LASTUPDATE
DATETIME
8
No
No
Active
9
LASTUPDATEBY
INT
4
No
No
10
Active
21946
View: View_Debriefers
View_Debriefers
Published / External
In Work
1
TRIPID
INT
4
Yes
No
10
Active
2
GREENCOUNT
INT
4
Yes
No
10
Active
3
REDCOUNT
INT
4
Yes
No
10
Active
4
RED2COUNT
INT
4
Yes
No
10
Active
5
FULLNAME
VARCHAR
102
No
No
Active
6
LASTUPDATE
DATETIME
8
No
No
Active
Data Steward
2012-12
Person
Kelly, John D
john.d.kelly@noaa.gov
1845 Wasp Boulevard
Honolulu
HI
96818
USA
808-725-5100
808-725-5217
Phone or email
Distributor
2012-12
Person
Kelly, John D
john.d.kelly@noaa.gov
1845 Wasp Boulevard
Honolulu
HI
96818
USA
808-725-5100
808-725-5217
Phone or email
Metadata Contact
2012-12
Person
Love, John
john.love@noaa.gov
1845 Wasp Boulevard
Honolulu
HI
96818
USA
808-725-5073
Phone or email
Originator
2012-12
Organization
Pacific Islands Regional Office
PIRO
1845 Wasp Boulevard, Bldg 176
Honolulu
HI
96818
USA
Point of Contact
2012-12
Person
Forney, Eric
eric.forney@noaa.gov
1845 Wasp Boulevard
Honolulu
HI
96818
USA
808-725-5103
808-725-5217
Phone or email
North-Central Pacific Ocean
Continuing
2013-08
Sensitive
Access is restricted to authorized individuals who have submitted a signed non-disclosure agreement or to USCG, OLE, DHS and OSHA. This non-disclosure agreement must be renewed on an annual basis.
Submit a data request to the Observer Program Manager, Operations Coordinator and the Fishery Information Specialist. If needed also submit a signed non-disclosure agreement (blank copy can be provided upon request). Upon approval of the data request by the Observer Program Manager or the Operations Coordinator the Fishery Information Specialist will coordinate with the data requester on fulfilling the data request. Observer Incident or Injury & Safety Reports that involve USCG, OLE, DHS or OSHA are submitted to them.
Only individuals with a signed non-disclosure agreement on file, or in the case of observer Incident or Injury & Safety Reports, USCG, OLE, DHS or OSHA, may access these data.
Data must not be shared with non-authorized individuals.
http://laysan/PIROPS
Intranet site
Web-based application available through a browser. SQL Server 2008 backend: to store all data, including backing up the data. Secure Access: Authenticated login, differentiated profiles for appropriate access to data.
Checks and automatic reminders to ensure all steps are followed.
Not Applicable
Functionality of program includes prompts and reminders to ensure all steps are followed and completed.
Yes
Unknown
No
Yes
Immediate - to authorized users
Other
Not Applicable
Daily backup PIRO-IT
During the debriefing process the observer and debriefer complete their respective post-trip tasks, reports and requirements.
21855
Entity
Table: Announcements
21856
Entity
Table: Checklist
21857
Entity
Table: Feedback
21858
Entity
Table: GreenPencil
21859
Entity
Table: Incident
21860
Entity
Table: Lookup_ABCD
21861
Entity
Table: Lookup_ABCDNA
21868
Entity
Table: Lookup_DorS
21869
Entity
Table: Lookup_ExperimentalTripType
21871
Entity
Table: Lookup_FOBNums
21873
Entity
Table: Lookup_HookCount
21874
Entity
Table: Lookup_IncidentType
21875
Entity
Table: Lookup_LatOrLong
21876
Entity
Table: Lookup_MeasureMethod
21877
Entity
Table: Lookup_Number
21878
Entity
Table: Lookup_Port
21879
Entity
Table: Lookup_Roles
21880
Entity
Table: Lookup_RptExportFormat
21881
Entity
Table: Lookup_Status1
21882
Entity
Table: Lookup_TripStatus
21883
Entity
Table: Lookup_Vessel
21884
Entity
Table: Lookup_YesNo
21885
Entity
Table: Media
21886
Entity
Table: My
21887
Entity
Table: MyTrips
21888
Entity
Table: NotesOnObservers
21889
Entity
Table: ObserverTrainings
21891
Entity
Table: PIROPS_System
21890
Entity
Table: Persons
21892
Entity
Table: PostCruise
21893
Entity
Table: RedPencil
21894
Entity
Table: RedPencil2
21895
Entity
Table: Reminders
21896
Entity
Table: Reports
21897
Entity
Table: Sets
21899
Entity
Table: TrainingSurvey
21900
Entity
Table: Trip
21901
Entity
Table: Upload
21898
Entity
Table: sysdiagrams
21946
Entity
View: View_Debriefers
gov.noaa.nmfs.inport:21854
Eric Forney
2014-07-11T16:15:12
SysAdmin InPortAdmin
2022-08-09T17:11:03
2015-12-03
Pacific Islands Regional Office
PIRO
1845 Wasp Boulevard, Bldg 176
Honolulu
HI
96818
USA
1001
Public
No
2015-12-03
1 Year
2016-12-03