5446
Table: ALS_TEMP_LAND_PUERTO_RICO
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