21854 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 Announcements Published / External In Work 1 ID INT 4 Yes Yes 10 Active 2 ANNOUNCEMENT VARCHAR 2500 No No Active 21856 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 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 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 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 Lookup_ABCD Published / External In Work 1 ID CHAR 1 Yes Yes Active 2 DESCRIPTION CHAR 1 No No Active 21861 Lookup_ABCDNA Published / External In Work 1 ID CHAR 1 Yes Yes Active 2 DESCRIPTION VARCHAR 12 No No Active 21868 Lookup_DorS Published / External In Work 1 ID CHAR 1 Yes Yes Active 2 DESCRIPTION VARCHAR 11 No No Active 21869 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 Lookup_FOBNums Published / External In Work 1 ID INT 4 Yes Yes 10 Active 2 DESCRIPTION VARCHAR 2 No No Active 21873 Lookup_HookCount Published / External In Work 1 ID INT 4 Yes Yes 10 Active 2 DESCRIPTION VARCHAR 2 No No Active 21874 Lookup_IncidentType Published / External In Work 1 ID INT 4 Yes Yes 10 Active 2 DESCRIPTION VARCHAR 30 No No Active 21875 Lookup_LatOrLong Published / External In Work 1 ID CHAR 1 Yes Yes Active 2 DESCRIPTION VARCHAR 5 No No Active 21876 Lookup_MeasureMethod Published / External In Work 1 ID INT 4 Yes Yes 10 Active 2 DESCRIPTION VARCHAR 50 No No Active 21877 Lookup_Number Published / External In Work 1 ID INT 4 Yes Yes 10 Active 2 DESCRIPTION VARCHAR 2 No No Active 21878 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 Lookup_Roles Published / External In Work 1 ID VARCHAR 2 Yes Yes Active 2 DESCRIPTION VARCHAR 50 No No Active 21880 Lookup_RptExportFormat Published / External In Work 1 ID INT 4 Yes No 10 Active 2 DESCRIPTION VARCHAR 20 No No Active 21881 Lookup_Status1 Published / External In Work 1 ID INT 4 Yes Yes 10 Active 2 DESCRIPTION VARCHAR 20 No No Active 21882 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 Lookup_Vessel Published / External In Work 1 ID INT 4 Yes Yes 10 Active 2 DESCRIPTION VARCHAR 50 No No Active 21884 Lookup_YesNo Published / External In Work 1 ID CHAR 1 Yes No Active 2 DESCRIPTION VARCHAR 8 No No Active 21885 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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_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 2025-11-11 Person Graham, David Erik david.graham@noaa.gov 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 2025-11-11 Person Graham, David Erik david.graham@noaa.gov 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 2025-11-11 Person Graham, David Erik david.graham@noaa.gov 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 21856 Entity 21857 Entity 21858 Entity 21859 Entity 21860 Entity 21861 Entity 21868 Entity 21869 Entity 21871 Entity 21873 Entity 21874 Entity 21875 Entity 21876 Entity 21877 Entity 21878 Entity 21879 Entity 21880 Entity 21881 Entity 21882 Entity 21883 Entity 21884 Entity 21885 Entity 21886 Entity 21887 Entity 21888 Entity 21889 Entity 21891 Entity 21890 Entity 21892 Entity 21893 Entity 21894 Entity 21895 Entity 21896 Entity 21897 Entity 21899 Entity 21900 Entity 21901 Entity 21898 Entity 21946 Entity gov.noaa.nmfs.inport:21854 Eric Forney 2014-07-11T16:15:12 Matthew Long 2025-11-11T21:34:06 2015-12-03 Pacific Islands Regional Office PIRO 1845 Wasp Boulevard, Bldg 176 Honolulu HI 96818 USA 1001 Public No No 2015-12-03 1 Year 2016-12-03