5446 ALS_TEMP_LAND_PUERTO_RICO Entity Published / External 1919 Puerto Rico Commercial Landings Statistics 1983 and more recent in Accumulated Landings System (ALS) Compatible Format Data Set Completed Pre-validation table for processing the load of Puerto RIco landings data. Loaded by batch 1725, 10-16-2007 05:43 Theme landings Theme staging table Spatial puerto rico Southeast Fisheries Science Center Miami FL USA 75 Virginia Beach Drive Miami, FL 33149 Data Table Yes ALS Pre-validation table for processing the load of Puerto RIco landings data. 1 MONTH_LANDED VARCHAR2 2 No No Active Two Character Month Landed VARCHAR2 2 YEAR_LANDED VARCHAR2 4 No No Active 4 character Year Landed VARCHAR2 3 STATE_LANDED VARCHAR2 2 No No Active State Code Landed. This is laways loaded with the NMFS STate Code For Puerto Rico. VARCHAR2 4 FISHING_CENTER VARCHAR2 3 No No Active Fishing Center Code. VARCHAR2 5 DEALER VARCHAR2 9 No No Active Dealer Code. Added For compatibility with other ALS Tables. This is column is always filled with all 9s as the Dealer is unknown. VARCHAR2 6 WATER_BODY VARCHAR2 4 No No Active Water Body Code VARCHAR2 7 GEAR VARCHAR2 3 No No Active NMFS Gear Code (If One exists. It is generated between a cross table Of Erdman Gear Codes to NMFS Gear Code) VARCHAR2 8 SPECIES VARCHAR2 4 No No Active NMFS Species Code (If One exists. It is generated between a cross table Of Erdman Species Codes to NMFS Species Codes) VARCHAR2 9 SHELL_OR_FINFISH VARCHAR2 1 No No Active Finfish or shell fish code. VARCHAR2 10 POUNDS NUMBER 22 No No 9 0 Active Pounds Caught. (Whole weight) NUMBER 11 VALUE NUMBER 22 No No 9 0 Active Value in dollars NUMBER 12 SECTION VARCHAR2 1 No No Active Section Code, Added for compatibility with ALS.ALS_LANDINGS VARCHAR2 13 PRICE NUMBER 22 No No 7 3 Active Price payed for fish. (In dollars) NUMBER 14 DISTANCE VARCHAR2 1 No No Active Distance From Shore Code. Added for compatibility with ALS.ALS_LANDINGS. VARCHAR2 15 STATE_CAUGHT VARCHAR2 2 No No Active State Caught. Added For compatibility WIth ALS.ALS_LANDINGS VARCHAR2 16 LANDING_DATE DATE 7 No No Active Actual Date animal was landed. DATE 17 PR_ID_CODE VARCHAR2 6 No No Active Identification Code asigned to Record by Puerto Rico data manager VARCHAR2 18 PR_GEAR VARCHAR2 3 No No Active Erdman Gear Code VARCHAR2 19 NUMBER_OF_TRIPS NUMBER 22 No No 2 0 Active Number Of Trips NUMBER 20 PR_SPECIES VARCHAR2 3 No No Active Erdman Species Code VARCHAR2 21 GEAR_QTY NUMBER 22 No No 4 0 Active Number Of Gear NUMBER 22 GEAR_HOURS NUMBER 22 No No 3 0 Active Soak Time NUMBER 23 DAY_LANDED VARCHAR2 2 No No Active Day landed. Derived from landing date VARCHAR2 24 RNUMBER NUMBER 22 No No 6 0 Active Record Number of Record In Question In file loaded NUMBER 25 USERID VARCHAR2 30 No No Active Oracle Id Of The Person Loading The Data VARCHAR2 26 SOURCE_FILE VARCHAR2 20 No No Active Source File used to load data. VARCHAR2 27 MINIMUM_DEPTH NUMBER 22 No No 4 0 Active Minimum Depth Fished NUMBER 28 MAXIMUM_DEPTH NUMBER 22 No No 4 0 Active Maximum Depth Fished NUMBER 29 TRIP_TICKET_NUMBER VARCHAR2 11 No No Active Trip Ticket Number VARCHAR2 Confidential Password Restricted. Rule of 3: Data summaries must include at least 3 dealers to be considered non-confidential. See: NOAA FORM 58-5 (1-84) TRANSMITTAL 127, National Oceanic and Atmospheric Administration NOAA Administrative Order 216-100 NOAA ADMINISTRATIVE ORDER SERIES Date of Issuance: July 26, 1994 Confidential data may only be released to entities having a signed non-disclosure agreement on file with the Director of the Information Resources Management Division (IRMD). Otherwise, confidentiality may be suppressed by the following methods used for aggregation of confidential data: Data that are submitted as confidential can be released to the public under the following circumstances: 1. Combined or aggregated data. Confidential data can be released if the data are aggregated or summarized in a manner that prevents the identification of the person or organization that submitted the data. The "rule of three" and identification of majority allocations" are the primary data suppression methods. 2. Obscure (scramble) or remove the data identifier. For some types of data, confidential data Can be released as non-confidential if the identity of the person, vessel, company, etc. that submitted the data is not included or is scrambled as part of the data that are released. 3. Submitter. Confidential data collected under federal authority Can be released to the original entity (person, vessel, business, etc.) that sUbmitted the data. 4. Confidential data waived. The protection of confidential data can be waived by the person or business that submitted the data. See NOAA Administrative Order 216-100 NOAA ADMINISTRATIVE ORDER SERIES Date of Issuance: July 26, 1994 These standards and procedures apply to all employees of the SEFSC that need access to confidential fisheries statistics. This includes full time or term employees, contractors, volunteers, and/or other employees associated with the SEFSC, but not directly employed by either organization. Any SEFSC employee that needs or desires access to confidential data must have read NOA 216-100 and submitted a signed nondisclosure statement to the Director, Information Resources Management Division (IRMD). The non-disclosure statement must be approved by the Director of IRMD and maintained on file by IRMD. It is the responsibility of the Director of IRMD to certifY upon request, that a person or organization that requests access to confidential data is authorized access to those data. All employees that have access to and/or use confidential data (federal and nonfederal) are responsible to protect those data from unauthorized access or release. Contractors or grantees that have an agreement with NMFS can be granted access to confidential data as an authorized user (See NOA 216-100 1 Section 6.03e). It should be clearly understood that confidential data cannot be released simply by an individual signing a nondisclosure statement. There must be a clear and demonstrable need for the confidential data that are requested as part of a contract or grant. Confidential data can only be released for the specific contract or grant. Upon completion of the contract or grant, the recipient must either return the data or state that it has been destroyed. The contractor or grantee cannot use the data for any purpose other than the uses stated in the agreement. The Contracting Officers Technical Representative (COTR) or the Technical Monitor (TM) that has been assigned to the contract or grant, respectively, has the following? responsibilities: 1. The COTR/TM has the responsibility to determine whether the contractor/grantee is eligible to receive the confidential data that are requested in the agreement. 2. The COTR/TM has the responsibility to assure that all persons included in the agreement have read NOA 2l6-l00 and have signed a nondisclosure statement. A statement must be signed by each person that will have access to the confidential data under the agreement, i.e., a blanket statement cannot be used for the company or firm. The COTR/TM also has the responsibility to make sure that the Director, IRMD has signed and approved the nondisclosure statement and the statement is on file with IRMD. 3. The COTR/TM has the responsibility to assure that confidential data are not released in any publication, report, oral presentation, or other means to the public by the contractor or grantee. To access confidential data a completed non-disclosure agreement must be on file with NOAA-SEFSC. Otherwise Data that are submitted as confidential can be released to the public under the following circumstances: 1. Combined or aggregated data. Confidential data can be released if the data are aggregated or summarized in a manner that prevents the identification of the person or organization that submitted the data. The "rule of three" and identification of majority allocations" are the primary data suppression methods. 2. Obscure (scramble) or remove the data identifier. For some types of data, confidential data Can be released as non-confidential if the identity of the person, vessel, company, etc. that submitted the data is not included or is scrambled as part of the data that are released. 3. Submitter. Confidential data collected under federal authority Can be released to the original entity (person, vessel, business, etc.) that sUbmitted the data. 4. Confidential data waived. The protection of confidential data can be waived by the person or business that submitted the data. NOAA/SEFSC Internal use only. Non-published Metadata access is restricted. Published Metadata is available to the public. Only use Published Metadata 2016-11-02 Change column POUNDS format Bennett, Joshua Pounds column re-formatted to NUMBER (9,3) from Number (9,0). No more rounding of imports from Caribbean Commercial Landings. gov.noaa.nmfs.inport:5446 Lee Weinberger 2007-10-16T05:43:40 SysAdmin InPortAdmin 2022-08-09T17:10:59 2021-05-06 Southeast Fisheries Science Center SEFSC 75 Virginia Beach Drive Miami FL 33149 USA (305)361-5761 www.sefsc.noaa.gov 8:00 a.m. - 4:30 p.m. EST 1001 Public No 2021-05-06 1 Year 2022-05-06