shellfish_survey_fact_conf
Northwest Fisheries Science Center
Entity
(ENT)
| ID: 36444
| Published / External
Created: 2017-01-25
|
Last Modified: 2022-08-09
Data Set (DS) | ID: 30862
ID: 36444
Entity (ENT)
* Discovery• First Pass
» Metadata Rubric
Item Identification
* » Title | shellfish_survey_fact_conf |
---|---|
Short Name | |
* Status | |
Creation Date | |
Revision Date | |
• Publication Date | |
* » Abstract | |
* Purpose | |
Notes | |
Other Citation Details | |
• Supplemental Information | |
DOI (Digital Object Identifier) | |
DOI Registration Authority | |
DOI Issue Date |
Keywords
Theme Keywords
Thesaurus | Keyword |
---|---|
Temporal Keywords
Thesaurus | Keyword |
---|---|
* Spatial Keywords
Thesaurus | Keyword |
---|---|
Stratum Keywords
Thesaurus | Keyword |
---|---|
Instrument Keywords
Thesaurus | Keyword |
---|---|
Platform Keywords
Thesaurus | Keyword |
---|---|
Physical Location
• » Organization | |
---|---|
• » City | |
• » State/Province | |
• Country | |
• » Location Description |
Entity Information
Entity Type | Data Table |
---|---|
Active Version? | |
Alias | |
Schema Name | |
» Description |
Puget Sound recreational shellfishing survey |
Change Summary |
Data Attributes
Attribute Summary
Score | Req'd? | PKey? | » Name | Data Storage Type | Description |
---|---|---|---|---|---|
100 | No | No | b12g2_number_people_last_trip_hotels | int2 | Number people covered on last Puget Sound trip by self or household on hotels, motels, and B&B rounded to nearest dollar |
100 | No | No | other_mail_disposition_date_dim$record_type | varchar | date, month, or year record or reason record is unavailable |
100 | No | No | b7_1_miles_by_car_last_trip | int4 | Number of one way miles travelled by car to most recent Pugent Sound clam (not razor clams) or oyster trip |
100 | No | No | final_mail_disposition_date_dim$month_name | varchar | text representation of month |
100 | No | No | c6_period_of_closure | varchar | Period of closure for questions in section C6 |
100 | No | No | last_call_date_dim$month_abbrev | bpchar | three character representation of month in capital letters |
100 | No | No | b702_boat_travel_last_trip | varchar | Indicates if travel to most recent Pugent Sound clam (not razor clams) or oyster trip was by boat or not |
100 | No | No | sample_sex_whid | int2 | Warehouse identifier to gender from sample |
100 | No | No | a2b_days_harvesting_oysters | int2 | Number of days in the last 12 months spent recreationally harvesting oysters in Puget Sound including San Juan Islands, Strait of Juan de Fuca, and Hood Canal |
100 | No | No | d6_employment_hours | varchar | Employment hours (nonworking includes homemakers, retired, or currently unemployed, part time equates to 35 hours or less, full time equates to more than 35 hours) |
100 | No | No | d1_birth_year | int2 | Year of birth of respondent |
100 | No | No | q3_beach_access_harvesting_trip | varchar | On your harvesting trips in Puget Sound, do you typically harvest oysters or clams from a public beach or a private beach? |
100 | No | No | a2c_days_harvesting_crab | int2 | Number of days in the last 12 months spent recreationally harvesting crab in Puget Sound including San Juan Islands, Strait of Juan de Fuca, and Hood Canal |
100 | No | No | combo_2013 | varchar | Indicates if respondent purchased combination license in 2013 |
100 | No | No | last_call_date_dim$year | int4 | numeric representation of year |
100 | No | No | final_mail_disposition_date_dim$day_of_month | int2 | numeric representation of the day in month |
100 | No | No | other_mail_disposition_date_dim$month_name | varchar | text representation of month |
100 | No | No | survey_version | int2 | Number of the survey version |
100 | No | No | c4_period_of_closure | varchar | Period of closure for questions in section C4 |
100 | No | No | last_call_date_whid | int8 | Warehouse identifier for last call date |
100 | No | No | c4_1b_quantity_nonharvest_trips_most_used_beach_closed_all_season | int2 | Number of trips might take that do not include harvesting clams or oysters in Puget Sound at most used beach that was closed all season |
100 | No | No | b10_2_miles_by_boat_last_overnight_trip | int4 | Number of one way miles travelled by boat (not including ferry) to most used Pugent Sound clam (not razor clams) or oyster overnight trip |
100 | No | No | final_mail_disposition_date_dim$record_type | varchar | date, month, or year record or reason record is unavailable |
100 | No | No | b8_primary_purpose_clam_oyster | varchar | Indicates if most recent Puget Sound clam (not razor clams) or oyster trip was to catch clam or oysters |
100 | No | No | c4_type_of_closure | varchar | Type of closure for questions in section C4 |
100 | No | No | final_mail_disposition | varchar | Final mail disposition |
100 | No | No | b1103_target_horse_clams_last_trip | varchar | Indicates if horse clams were the target or harvested on last Puget Sound trip |
100 | No | No | prenotice_letter_mailed_date_dim$month_abbrev | bpchar | three character representation of month in capital letters |
100 | No | No | a2e_days_harvesting_other | int2 | Number of days in the last 12 months spent recreationally harvesting other shellfish in Puget Sound including San Juan Islands, Strait of Juan de Fuca, and Hood Canal |
100 | No | No | final_mail_disposition_date_dim$month_of_year | int2 | numeric representation of month of year |
100 | No | No | final_mail_disposition_date_whid | int8 | Warehouse identifier for final mail disposition date |
100 | No | No | post_card_mailed_date_whid | int8 | Warehouse identifier for post card mailed date |
100 | No | No | initial_survey_packet_mailed_date_dim$full_date | timestamp | full date value |
67 | No | No | sample_sex_dim$sex | varchar | |
100 | No | No | residential_zip | varchar | Residential zip |
100 | No | No | a10c_reason_spend_time_with_friends_or_others_rating | varchar | Respondent harvests clams or oysters in Puget Sound for the reason of spending time with friends or others given a rating system of 5 for strongly agree and 1 for strongly disagree |
100 | No | No | c5_2a_quantity_harvest_trips_most_used_beach_during_open_9_months | int2 | Number of trips might take to harvest clams or oysters in Puget Sound at most used beach during other months of 3 month closure |
100 | No | No | last_call_phone_disposition | varchar | Disposition of the last phone call |
100 | No | No | b11_3_number_kept_last_trip_horse_clams | int2 | Quantity of horse clams kept on last Puget Sound trip |
100 | No | No | residential_city | varchar | Residential city |
100 | No | No | c2a_quantity_harvest_trips_most_used_beach_open_all_season | int2 | Number of trips might take to harvest clams or oysters in Puget Sound at most used beach assuming no biotoxin or pollution closures |
100 | No | No | initial_survey_packet_mailed_date_whid | int8 | Warehouse identifier for initial survey packet mailed date |
100 | No | No | a10a_reason_spend_time_outdoors_rating | varchar | Respondent harvests clams or oysters in Puget Sound for the reason of spending time outdoors given a rating system |
100 | No | No | b12f1_money_spent_last_trip_camping | int2 | Money spent on last Puget Sound trip by self or household on campgrounds and trailer parks rounded to nearest dollar |
100 | No | No | b12h1_money_spent_last_trip_vaca_rental | int2 | Money spent on last Puget Sound trip by self or household on vacation rental rounded to nearest dollar |
100 | No | No | last_call_date_dim$month_of_year | int2 | numeric representation of month of year |
100 | No | No | b1101_target_steamer_clams_last_trip | varchar | Indicates if steam clams (manila, littleneck, butter, cockle, softshell, macoma) were the target or harvested on last Puget Sound trip |
100 | No | No | c6_1a_quantity_harvest_trips_most_used_beach_closed_1_month | int2 | Number of trips might take to harvest clams or oysters in Puget Sound at most used beach during 1 month closure |
100 | No | No | d7_hourly_wage_range | varchar | Approximate personal hourly wage rate range |
100 | No | No | b12eoth_other_transport_last_trip_type | varchar | Other transportation type on last Puget Sound trip |
100 | No | No | b12j2_number_people_last_trip_restaurants_bars | int2 | Number people covered on last Puget Sound trip by self or household on restaurants and bars rounded to nearest dollar |
100 | No | No | second_survey_packet_mailed_date_dim$year | int4 | numeric representation of year |
100 | No | No | a1_razor_clam_harvest | varchar | Have you harvested RAZOR CLAMS in Washington in the last 12 months? |
100 | No | No | final_mail_disposition_date_dim$full_date | timestamp | full date value |
100 | No | No | a9_range_other_beaches_used | varchar | Concatenated list of ranges of other beaches used nearby the most used beach to recreationally harvest shellfish in the last 12 months |
100 | No | No | a2d_days_harvesting_shrimp | int2 | Number of days in the last 12 months spent recreationally harvesting shrimp in Puget Sound including San Juan Islands, Strait of Juan de Fuca, and Hood Canal |
100 | No | No | a6_2_miles_by_boat_beach_most_used | int4 | Number of one way miles travelled by boat (not including ferry) to most used beach recreationally harvesting shellfish in the last 12 months measured to nearest mile |
100 | No | No | b12koth_other_lodging_food_last_trip_type | varchar | Other lodging or food type on last Puget Sound trip |
100 | No | No | b1104_target_oysters_last_trip | varchar | Indicates if oysters were the target or harvested on last Puget Sound trip |
100 | No | No | other_mail_disposition_date_dim$yyyymmdd | bpchar | text representation of year month day |
100 | No | No | b12k1_money_spent_last_trip_other_lodging_food | int2 | Money spent on last Puget Sound trip by self or household on other lodging or food rounded to nearest dollar |
100 | No | No | second_survey_packet_mailed_date_dim$month_abbrev | bpchar | three character representation of month in capital letters |
100 | No | No | sample_birth_date_dim$month_of_year | int2 | numeric representation of month of year |
100 | No | No | b12f2_number_people_last_trip_camping | int2 | Number people covered on last Puget Sound trip by self or household on campgrounds and trailer parks rounded to nearest dollar |
100 | No | No | c6_2b_quantity_nonharvest_trips_most_used_beach_during_opened_11_months | int2 | Number of trips might take that do not include harvesting clams or oysters in Puget Sound at most used beach during other months of 1 month closure |
100 | No | No | prenotice_letter_mailed_date_dim$month_of_year | int2 | numeric representation of month of year |
100 | No | No | b7_2_miles_by_boat_last_trip | int4 | Number of one way miles travelled by boat (not including ferry) to most used Pugent Sound clam (not razor clams) or oyster trip |
100 | No | No | c4_1c_quantity_harvest_trips_nearby_beach_most_used_closed_all_season | int2 | Number of trips might take to harvest clams or oysters in Puget Sound at a nearby fully open beach if most used was closed all season |
100 | No | No | b12a1_money_spent_last_trip_land_vehicle | int2 | Money spent on last Puget Sound trip by self or household on auto, truck, or RV fuel rounded to nearest dollar |
100 | No | No | sample_birth_date_dim$day_of_month | int2 | numeric representation of the day in month |
100 | No | No | c53_quantity_harvest_trips_nearby_beach_while_most_used_fully_open | int2 | Number of trips might take to harvest clams or oysters in Puget Sound at a nearby fully open beach while most used open |
100 | No | No | c5_type_of_closure | varchar | Type of closure for questions in section C5 |
100 | No | No | a4_beach_most_used_access_type | varchar | Type of access of the beach most used to recreationally harvest shellfish in the last 12 months |
100 | No | No | b1_month_last_trip | int2 | The month number of the last trip spent harvesting clams (not including razor clams) or oysters |
100 | No | No | c6_2a_quantity_harvest_trips_most_used_beach_during_opened_11_months | int2 | Number of trips might take to harvest clams or oysters in Puget Sound at most used beach during other months of 1 month closure |
100 | No | No | b12d1_money_spent_last_trip_ferry | int2 | Money spent on last Puget Sound trip by self or household on ferry rounded to nearest dollar |
100 | No | No | initial_survey_packet_mailed_date_dim$month_name | varchar | text representation of month |
100 | No | No | b703_foot_travel_last_trip | varchar | Indicates if travel to most recent Pugent Sound clam (not razor clams) or oyster trip was by foot or not |
100 | No | No | a10b_reason_spend_time_with_family_rating | varchar | Respondent harvests clams or oysters in Puget Sound for the reason of spending time with family given a rating system of 5 for strongly agree and 1 for strongly disagree |
100 | No | No | b11oth_other_targetted_last_trip_type | varchar | Other type targetted or harvested at last trip in Puget Sound |
100 | No | No | prenotice_letter_mailed_date_dim$month_name | varchar | text representation of month |
100 | No | No | b1105_target_other_last_trip | varchar | Indicates if other type were the target or harvested on last Puget Sound trip |
100 | No | No | which_survey_completed | int2 | Which survey number was completed |
100 | No | No | b11_4_number_kept_last_trip_oysters | int2 | Quantity of oysters kept on last Puget Sound trip |
100 | No | No | last_call_date_dim$month_name | varchar | text representation of month |
100 | No | No | second_survey_packet_mailed_date_dim$month_of_year | int2 | numeric representation of month of year |
100 | No | No | b13_harvest_shellfish_next_12_months_likely_rating | varchar | Likeliness surveyor will take a trip to Puget Sound to harvest shellfish |
100 | No | No | second_survey_packet_mailed_date_dim$yyyymmdd | bpchar | text representation of year month day |
100 | No | No | last_call_date_dim$yyyymmdd | bpchar | text representation of year month day |
100 | No | No | a10g_reason_provide_food_for_family_rating | varchar | Respondent harvests clams or oysters in Puget Sound for the reason of providing food for self or family given a rating system of 5 for strongly agree and 1 for strongly disagree |
100 | No | No | third_survey_packet_mailed_date_dim$month_name | varchar | text representation of month |
100 | No | No | q5_harvest_shellfish_rating_next_12_mo | varchar | During the next 12 months, how likely is it that you will take a trip where you harvest shellfish in Puget Sound? |
100 | No | No | a2eot1_other_shellfish_harvested | varchar | Other type of shellfish recreationally harvested in Puget Sound including the San Juan Islands, Strait of Juan de Fuca, and Hood Canal within the last 12 months |
100 | No | No | c3_1b_quantity_nonharvest_trips_most_used_beach_closed_all_season | int2 | Number of trips might take that do not include harvesting clams or oysters in Puget Sound at most used beach that was closed all season |
100 | No | No | b12b2_number_people_last_trip_water_vehicle | int2 | Number people covered on last Puget Sound trip by self or household on boat fuel rounded to nearest dollar |
100 | No | No | prenotice_letter_mailed_date_dim$yyyymmdd | bpchar | text representation of year month day |
100 | No | No | sample_birth_date_dim$record_type | varchar | date, month, or year record or reason record is unavailable |
100 | No | No | q6_respondent_birth_year | int | In what year were you born? |
100 | No | No | verified_address | varchar | Respondent verified address |
100 | No | No | initial_survey_packet_mailed_date_dim$day_of_month | int2 | numeric representation of the day in month |
100 | No | No | other_mail_disposition_date_dim$month_abbrev | bpchar | three character representation of month in capital letters |
100 | No | No | a10f_reason_eat_self_caught_rating | varchar | Respondent harvests clams or oysters in Puget Sound for the reason of eating something self caught given a rating system of 5 for strongly agree and 1 for strongly disagree |
100 | No | No | third_survey_packet_mailed_date_dim$year | int4 | numeric representation of year |
100 | No | No | d5_household_income_range | varchar | Best description of household total annual income before taxes |
100 | No | No | post_card_mailed_date_dim$full_date | timestamp | full date value |
100 | No | No | c6_additional_distance_to_nearby_fully_open_beach | varchar | Additional distance to nearby beach that is fully open for questions in section C6 |
100 | No | No | post_card_mailed_date_dim$month_name | varchar | text representation of month |
100 | No | No | third_survey_packet_mailed_date_dim$yyyymmdd | bpchar | text representation of year month day |
100 | No | No | b12e2_number_people_last_trip_other_transport | int2 | Number people covered on last Puget Sound trip by self or household on other transport rounded to nearest dollar |
100 | No | No | b4_hours_spent_harvesting_last_trip | int2 | The number of hours (rounded to nearest hour) spent harvesting clams or oysters on most recent Puget Sound trip |
100 | No | No | d4a_household_adult_size | int2 | Number of adults within household including self |
100 | No | No | other_mail_disposition_date_dim$year | int4 | numeric representation of year |
100 | No | No | c3_period_of_closure | varchar | Period of closure for questions in section C3 |
100 | No | No | a5_beach_most_used | varchar | Name of the beach most used to recreationally harvest shellfish in the last 12 months |
100 | No | No | last_call_date_dim$record_type | varchar | date, month, or year record or reason record is unavailable |
100 | No | No | c6_2c_quantity_harvest_trips_nearby_beach_during_most_used_opened_11_months | int2 | Number of trips might take to harvest clams or oysters in Puget Sound at a nearby fully open beach during other months of most used 1 month closure |
100 | No | No | c4_species_closed_to_harvest | varchar | Species that are closed to harvest for questions in section C4 |
100 | No | No | third_survey_packet_mailed_date_dim$full_date | timestamp | full date value |
67 | No | No | d2_sex_dim$sex_abbreviation | bpchar | |
100 | No | No | mail_comments | varchar | Mail comments |
100 | No | No | other_mail_disposition_date_dim$month_of_year | int2 | numeric representation of month of year |
100 | No | No | b1002_boat_travel_last_overnight_trip | varchar | Indicates if travel to most recent Pugent Sound clam (not razor clams) or oyster overnight trip was by boat or not |
100 | No | No | third_survey_packet_mailed_date_dim$record_type | varchar | date, month, or year record or reason record is unavailable |
100 | No | No | a7_ferry_travel_beach_most_used | varchar | Do you take a ferry as part of your trip to get to the beach you most often used? |
100 | No | No | c6_species_closed_to_harvest | varchar | Species that are closed to harvest for questions in section C6 |
100 | No | No | initial_survey_packet_mailed_date_dim$month_of_year | int2 | numeric representation of month of year |
100 | No | No | c63_quantity_harvest_trips_nearby_beach_while_most_used_fully_open | int2 | Number of trips might take to harvest clams or oysters in Puget Sound at a nearby fully open beach while most used open |
100 | No | No | prenotice_letter_mailed_date_dim$year | int4 | numeric representation of year |
100 | No | No | b12i2_number_people_last_trip_grocery | int2 | Number people covered on last Puget Sound trip by self or household on grocery and convvenience stores rounded to nearest dollar |
100 | No | No | initial_survey_packet_mailed_date_dim$record_type | varchar | date, month, or year record or reason record is unavailable |
100 | No | No | b1001_car_travel_last_overnight_trip | varchar | Indicates if travel to most recent Pugent Sound clam (not razor clams) or oyster overnight trip was by car or not |
100 | No | No | d3_education_level | varchar | Education level of respondent |
100 | No | No | b1003_foot_travel_last_overnight_trip | varchar | Indicates if travel to most recent Pugent Sound clam (not razor clams) or oyster overnight trip was by foot or not |
100 | No | No | b12i1_money_spent_last_trip_grocery | int2 | Money spent on last Puget Sound trip by self or household on grocery and convvenience stores rounded to nearest dollar |
100 | No | No | prenotice_letter_mailed_date_dim$full_date | timestamp | full date value |
100 | No | No | call_length | int2 | Length of call measured in minutes |
100 | No | No | initial_survey_packet_mailed_date_dim$month_abbrev | bpchar | three character representation of month in capital letters |
100 | No | No | post_card_mailed_date_dim$year | int4 | numeric representation of year |
100 | No | No | c5_1c_quantity_harvest_trips_nearby_beach_most_used_closed_3_months | int2 | Number of trips might take to harvest clams or oysters in Puget Sound at a nearby fully open beach during most used 3 month closure |
100 | No | No | sample_birth_date_dim$full_date | timestamp | full date value |
100 | No | No | prenotice_letter_mailed_date_dim$record_type | varchar | date, month, or year record or reason record is unavailable |
100 | No | No | b11_1_number_kept_last_trip_steamer_clams | int2 | Quantity of steam clams kept on last Puget Sound trip |
100 | No | No | b12h2_number_people_last_trip_vaca_rental | int2 | Number people covered on last Puget Sound trip by self or household on vacation rental rounded to nearest dollar |
100 | No | No | a2eot0_other_shellfish_harvested | varchar | Other type of shellfish recreationally harvested in Puget Sound including the San Juan Islands, Strait of Juan de Fuca, and Hood Canal within the last 12 months |
100 | No | No | post_card_mailed_date_dim$record_type | varchar | date, month, or year record or reason record is unavailable |
100 | No | No | other_mail_disposition | int2 | Other mail disposition |
100 | No | No | q1_taken_trips_harvesting_razor_clams | varchar | Have you taken any trips where you harvested razor clams in Washington in the last 12 months? |
100 | No | No | sample_birth_date_dim$month_name | varchar | text representation of month |
100 | No | No | sample_id | int2 | Shellfish survey sample ID |
100 | No | No | a3oth_name_of_city_near_beach_most_used | varchar | Name of city not in list nearest beach respondent uses most to harvest shellfish |
100 | No | No | a11_consume_clams_or_oyster_frequency | varchar | Frequency respondent eats meals containing clams or oysters harvested from Puget Sound |
100 | No | No | third_survey_packet_mailed_date_whid | int8 | Warehouse identifier for third survey packet mailed date |
100 | No | No | other_mail_disposition_date_dim$day_of_month | int2 | numeric representation of the day in month |
100 | No | No | third_survey_packet_mailed_date_dim$month_of_year | int2 | numeric representation of month of year |
100 | No | No | a8oth_other_lodging_most_used_type | varchar | Other type of lodging used for one or more overnight stays at the most often used beach recreationally harvesting shellfish |
100 | No | No | final_mail_disposition_date_dim$month_abbrev | bpchar | three character representation of month in capital letters |
100 | No | No | c5_period_of_closure | varchar | Period of closure for questions in section C5 |
100 | No | No | c3_species_closed_to_harvest | varchar | Species that are closed to harvest for questions in section C3 |
100 | No | No | post_card_mailed_date_dim$month_abbrev | bpchar | three character representation of month in capital letters |
100 | No | No | b11_2_number_kept_last_trip_geoduck_clams | int2 | Quantity of geoduck clams kept on last Puget Sound trip |
100 | No | No | b11_5_number_kept_last_trip_other | int2 | Quantity of other clams kept on last Puget Sound trip |
100 | No | No | c5_2c_quantity_harvest_trips_nearby_beach_during_most_used_open_9_months | int2 | Number of trips might take to harvest clams or oysters in Puget Sound at a nearby fully open beach during other months of most used 3 month closure |
100 | No | No | d4b_household_child_size | int2 | Number of children (under 18) within household |
100 | No | No | c3_1c_quantity_harvest_trips_nearby_beach_most_used_closed_all_season | int2 | Number of trips might take to harvest clams or oysters in Puget Sound at a nearby fully open beach if most used was closed all season |
100 | No | No | sample_birth_date_dim$year | int4 | numeric representation of year |
100 | No | No | final_mail_disposition_date_dim$yyyymmdd | bpchar | text representation of year month day |
100 | No | No | last_call_date_dim$full_date | timestamp | full date value |
100 | No | No | prenotice_letter_mailed_date_dim$day_of_month | int2 | numeric representation of the day in month |
100 | No | No | sample_birth_date_whid | int8 | Warehouse identifier for birthdate from sample |
100 | No | No | d2_sex_whid | int2 | Warehouse identifier of gender of respondent per questionaire |
100 | No | No | second_survey_packet_mailed_date_dim$record_type | varchar | date, month, or year record or reason record is unavailable |
100 | No | No | c5_2b_quantity_nonharvest_trips_most_used_beach_during_open_9_months | int2 | Number of trips might take that do not include harvesting clams or oysters in Puget Sound at most used beach during other months of 3 month closure |
100 | No | No | c3_2_quantity_harvest_trips_nearby_beach_most_used_not_closed_all_season | int2 | Number of trips might take to harvest clams or oysters in Puget Sound at a nearby fully open beach if most used was open all season |
100 | No | No | last_call_date_dim$day_of_month | int2 | numeric representation of the day in month |
100 | No | No | b701_car_travel_last_trip | varchar | Indicates if travel to most recent Pugent Sound clam (not razor clams) or oyster trip was by car or not |
100 | No | No | c3_1a_quantity_harvest_trips_most_used_beach_closed_all_season | int2 | Number of trips might take to harvest clams or oysters in Puget Sound at most used beach that was closed all season |
100 | No | No | a3_name_of_city_near_beach_most_used | varchar | Name of city from a list of cities that is nearest the beach respondent uses most to harvest shellfish |
100 | No | No | third_survey_packet_mailed_date_dim$month_abbrev | bpchar | three character representation of month in capital letters |
100 | No | No | c5_1a_quantity_harvest_trips_most_used_beach_closed_3_months | int2 | Number of trips might take to harvest clams or oysters in Puget Sound at most used beach during 3 month closure |
100 | No | No | c6_1b_quantity_nonharvest_trips_most_used_beach_closed_1_ month | int2 | Number of trips might take that do not include harvesting clams or oysters in Puget Sound at most used beach during 1 month closure |
100 | No | No | d8_2_paid_time_off_work | varchar | Indicates if respondent took paid time off (vacation, sick, etc.) to harvest shellfish |
100 | No | No | b9oth_other_lodging_type_last_trip | varchar | The type of lodging not available in list used one or more nights at most recent Puget Sound clam (not razor clams) or oyster trip |
100 | No | No | other_mail_disposition_date_dim$full_date | timestamp | full date value |
100 | No | No | second_survey_packet_mailed_date_dim$month_name | varchar | text representation of month |
100 | No | No | initial_survey_packet_mailed_date_dim$yyyymmdd | bpchar | text representation of year month day |
100 | No | No | a603_foot_travel_beach_most_used | varchar | Indicates if travel to most used beach to recreationally harvest shellfish in the last 12 month was by foot |
100 | No | No | second_survey_packet_mailed_date_dim$full_date | timestamp | full date value |
100 | No | No | c4_additional_distance_to_nearby_fully_open_beach | varchar | Additional distance to nearby beach that is fully open for questions in section C4 |
100 | No | No | third_survey_packet_mailed_date_dim$day_of_month | int2 | numeric representation of the day in month |
100 | No | No | c6_type_of_closure | varchar | Type of closure for questions in section C6 |
100 | No | No | b2_days_spent_last_trip | int2 | The number of days (partial days count as full days and includes travel) spent on the last whole trip to the most recent Puget Sound beach to harvest clam (not razor clams) or oysters |
100 | No | No | a8_lodging_beach_most_used | varchar | On the trip(s) you took to the beach you most often used, did you usually stay one or more nights in a house you own, a vacation rental, a hotel / motel, or a campground? |
100 | No | No | master_id | int2 | Shellfish survey master ID |
100 | No | No | b12c2_number_people_last_trip_parking_launch | int2 | Number people covered on last Puget Sound trip by self or household on parking or boat launch rounded to nearest dollar |
100 | No | No | b1102_target_geoduck_clams_last_trip | varchar | Indicates if geoduck clams were the target or harvested on last Puget Sound trip |
100 | No | No | second_survey_packet_mailed_date_dim$day_of_month | int2 | numeric representation of the day in month |
100 | No | No | a10e_reason_get_some_exercise_rating | varchar | Respondent harvests clams or oysters in Puget Sound for the reason of getting some exercise given a rating system of 5 for strongly agree and 1 for strongly disagree |
100 | No | No | c1_trip_months_list | varchar | Concatenated list of month names in which surveyor takes trips to harvest clams or oysters in Puget Sound |
100 | No | No | b10_1_miles_by_car_last_overnight_trip | int4 | Number of one way miles travelled by car to most recent Pugent Sound clam (not razor clams) or oyster overnight trip |
100 | No | No | d8_1_no_time_off_work | varchar | Indicates if respondent did not take time off to harvest shellfish |
100 | No | No | residential_street | varchar | Residential street address |
100 | No | No | c4_2_quantity_harvest_trips_nearby_beach_most_used_not_closed_all_season | int2 | Number of trips might take to harvest clams or oysters in Puget Sound at a nearby fully open beach if most used was open all season |
100 | No | No | prenotice_letter_mailed_date_whid | int8 | Warehouse identifier for prenotice letter mailed date |
100 | No | No | post_card_mailed_date_dim$yyyymmdd | bpchar | text representation of year month day |
100 | No | No | c6_1c_quantity_harvest_trips_nearby_beach_most_used_closed_1_month | int2 | Number of trips might take to harvest clams or oysters in Puget Sound at a nearby fully open beach during most used 1 month closure |
100 | No | No | final_mail_disposition_date_dim$year | int4 | numeric representation of year |
100 | No | No | b12a2_number_people_last_trip_land_vehicle | int2 | Number people covered on last Puget Sound trip by self or household on auto, truck, or RV fuel rounded to nearest dollar |
100 | No | No | b3_days_spent_harvesting_last_trip | int2 | The number of days (partial days count as full days and includes travel) spent harvesting clam (not razor clams) or oysters at the most recent Pugent Sound trip |
100 | No | No | sample_sex_dim$record_type | varchar | latitude record type or reason record is unavailable |
100 | No | No | b12c1_money_spent_last_trip_parking_launch | int2 | Money spent on last Puget Sound trip by self or household on parking or boat launch rounded to nearest dollar |
100 | No | No | a6_1_miles_by_car_beach_most_used | int4 | Number of one way miles travelled by car to most used beach recreationally harvesting shellfish in the last 12 months measured to nearest mile |
100 | No | No | c2b_quantity_nonharvest_trips_most_used_beach_open_all_season | int2 | Number of trips might take that do not include harvesting clams or oysters in Puget Sound at most used beach assuming no biotoxin or pollution closures |
100 | No | No | c5_additional_distance_to_nearby_fully_open_beach | varchar | Additional distance to nearby beach that is fully open for questions in section C5 |
100 | No | No | b12e1_money_spent_last_trip_other_transport | int2 | Money spent on last Puget Sound trip by self or household on other transport rounded to nearest dollar |
100 | No | No | sample_birth_date_dim$month_abbrev | bpchar | three character representation of month in capital letters |
100 | No | No | a601_car_travel_beach_most_used | varchar | Indicates if travel to most used beach to recreationally harvest shellfish in the last 12 month was by car |
100 | No | No | a602_boat_travel_beach_most_used | varchar | Indicates if travel to most used beach to recreationally harvest shellfish in the last 12 month was by boat |
67 | No | No | d2_sex_dim$sex | varchar | |
100 | No | No | b12j1_money_spent_last_trip_restaurants_bars | int2 | Money spent on last Puget Sound trip by self or household on restaurants and bars rounded to nearest dollar |
100 | No | No | a2eoth_other_shellfish_harvested | varchar | Other type of shellfish recreationally harvested in Puget Sound including the San Juan Islands, Strait of Juan de Fuca, and Hood Canal within the last 12 months |
100 | No | No | a2a_days_harvesting_clams | int2 | Number of days in the last 12 months spent recreationally harvesting clams (other than razor clams) in Puget Sound including San Juan Islands, Strait of Juan de Fuca, and Hood Canal |
100 | No | No | sample_birth_date_dim$yyyymmdd | bpchar | text representation of year month day |
100 | No | No | a10d_reason_relax_rating | varchar | Respondent harvests clams or oysters in Puget Sound for the reason of relaxing given a rating system of 5 for strongly agree and 1 for strongly disagree |
100 | No | No | post_card_mailed_date_dim$day_of_month | int2 | numeric representation of the day in month |
100 | No | No | initial_survey_packet_mailed_date_dim$year | int4 | numeric representation of year |
100 | No | No | d2_sex_dim$record_type | varchar | latitude record type or reason record is unavailable |
100 | No | No | b12g1_money_spent_last_trip_hotels | int2 | Money spent on last Puget Sound trip by self or household on hotels, motels, and B&B rounded to nearest dollar |
100 | No | No | b9_lodging_type_last_trip | varchar | The type of lodging used one or more nights at most recent Puget Sound clam (not razor clams) or oyster trip |
100 | No | No | other_mail_disposition_date_whid | int8 | Warehouse identifier for other mail disposition date |
100 | No | No | b5_beach_access_type_last_trip | varchar | Access type of the beach most recently used in the Puget Sound to harvest clams (not razor clams) or oysters |
100 | No | No | b12k2_number_people_last_trip_other_lodging_food | int2 | Number people covered on last Puget Sound trip by self or household on other lodging or food rounded to nearest dollar |
100 | No | No | c3_additional_distance_to_nearby_fully_open_beach | varchar | Additional distance to nearby beach that is fully open for questions in section C3 |
100 | No | No | shellfish_2013 | varchar | Indicates if respondent purchased shellfish license in 2013 |
100 | No | No | post_card_mailed_date_dim$month_of_year | int2 | numeric representation of month of year |
100 | No | No | c5_1b_quantity_nonharvest_trips_most_used_beach_closed_3_months | int2 | Number of trips might take that do not include harvesting clams or oysters in Puget Sound at most used beach during 3 month closure |
100 | No | No | c3_type_of_closure | varchar | Type of closure for questions in section C3 |
100 | No | No | second_survey_packet_mailed_date_whid | int8 | Warehouse identifier for second survey packet mailed date |
100 | No | No | d8_3_unpaid_time_off_work | varchar | Indicates if respondent took unpaid time off to harvest shellfish |
67 | No | No | sample_sex_dim$sex_abbreviation | bpchar | |
100 | No | No | c4_1a_quantity_harvest_trips_most_used_beach_closed_all_season | int2 | Number of trips might take to harvest clams or oysters in Puget Sound at most used beach that was closed all season |
100 | No | No | q7_respondent_income_range | varchar | Im going to read you some income categories. For classification purposes only, please tell me which income category best describes your households total annual income before taxes in 2012. When I read your household income category, please stop me. |
100 | No | No | b6_beach_name_last_trip | varchar | Name of most recent beach in Puget Sound to harvest clams (not razor clams) or oysters |
100 | No | No | q4_miles_travel_to_harvest_beach | int | Approximately how many one-way miles do you travel to get to the beach you most often use to harvest oysters or clams in Puget Sound? |
100 | No | No | b12d2_number_people_last_trip_ferry | int2 | Number people covered on last Puget Sound trip by self or household on ferry rounded to nearest dollar |
100 | No | No | d9_survey_comments | varchar | Additional comments from respondent |
100 | No | No | c5_species_closed_to_harvest | varchar | Species that are closed to harvest for questions in section C5 |
100 | No | No | b12b1_money_spent_last_trip_water_vehicle | int2 | Money spent on last Puget Sound trip by self or household on boat fuel rounded to nearest dollar |
100 | No | No | q2_taken_trips_harvesting_oysters_clams | varchar | Have you taken any trips where you harvested oysters or clams in Puget Sound in the last 12 months? |
Attribute Details
Attribute Name | b12g2_number_people_last_trip_hotels |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Number people covered on last Puget Sound trip by self or household on hotels, motels, and B&B rounded to nearest dollar |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 3-4 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | other_mail_disposition_date_dim$record_type |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
date, month, or year record or reason record is unavailable |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Date, Month, Year, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | b7_1_miles_by_car_last_trip |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Number of one way miles travelled by car to most recent Pugent Sound clam (not razor clams) or oyster trip |
General Data Type | |
Unit of Measure | mi |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 1-250 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | final_mail_disposition_date_dim$month_name |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 10 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
text representation of month |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | January, February, March, April, May, June, July, August, September, October, November, December |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | c6_period_of_closure |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 15 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Period of closure for questions in section C6 |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 12 months, 3 months |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | last_call_date_dim$month_abbrev |
---|---|
Seq. Order | |
Data Storage Type | bpchar |
Max Length | 3 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
three character representation of month in capital letters |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | JAN, FEB, MAR, APR, MAY, JUN, JUL, AUG, SEP, OCT, NOV, DEC |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | b702_boat_travel_last_trip |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 25 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Indicates if travel to most recent Pugent Sound clam (not razor clams) or oyster trip was by boat or not |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Travelled by Boat, Not Travelled by Boat |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | sample_sex_whid |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Warehouse identifier to gender from sample |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | a2b_days_harvesting_oysters |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 3 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Number of days in the last 12 months spent recreationally harvesting oysters in Puget Sound including San Juan Islands, Strait of Juan de Fuca, and Hood Canal |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | d6_employment_hours |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 20 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Employment hours (nonworking includes homemakers, retired, or currently unemployed, part time equates to 35 hours or less, full time equates to more than 35 hours) |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Nonworking, Part-time, Full-time |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | d1_birth_year |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Year of birth of respondent |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | q3_beach_access_harvesting_trip |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 25 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
On your harvesting trips in Puget Sound, do you typically harvest oysters or clams from a public beach or a private beach? |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | DON'T KNOW / NOT SURE, Private, Public, REFUSED |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | a2c_days_harvesting_crab |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 3 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Number of days in the last 12 months spent recreationally harvesting crab in Puget Sound including San Juan Islands, Strait of Juan de Fuca, and Hood Canal |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | combo_2013 |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 25 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Indicates if respondent purchased combination license in 2013 |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Combination License, No Combination License, NA |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | last_call_date_dim$year |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
numeric representation of year |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 1978+ |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | final_mail_disposition_date_dim$day_of_month |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
numeric representation of the day in month |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 1-31 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | other_mail_disposition_date_dim$month_name |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 10 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
text representation of month |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | January, February, March, April, May, June, July, August, September, October, November, December |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | survey_version |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Number of the survey version |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | c4_period_of_closure |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 15 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Period of closure for questions in section C4 |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 12 months, 3 months |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | last_call_date_whid |
---|---|
Seq. Order | |
Data Storage Type | int8 |
Max Length | 64 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Warehouse identifier for last call date |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | c4_1b_quantity_nonharvest_trips_most_used_beach_closed_all_season |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Number of trips might take that do not include harvesting clams or oysters in Puget Sound at most used beach that was closed all season |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 0-75 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | b10_2_miles_by_boat_last_overnight_trip |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Number of one way miles travelled by boat (not including ferry) to most used Pugent Sound clam (not razor clams) or oyster overnight trip |
General Data Type | |
Unit of Measure | mi |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 1.0 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | final_mail_disposition_date_dim$record_type |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
date, month, or year record or reason record is unavailable |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Date, Month, Year, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | b8_primary_purpose_clam_oyster |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 40 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Indicates if most recent Puget Sound clam (not razor clams) or oyster trip was to catch clam or oysters |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Clam or Oyster Primary Purpose, Clam or Oyster Not Primary Purpose |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | c4_type_of_closure |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 15 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Type of closure for questions in section C4 |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Biotoxin, Pollution |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | final_mail_disposition |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Final mail disposition |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Bad Address, Blank, Complete, Opt-Out, Refused/Didn't Shellfish |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | b1103_target_horse_clams_last_trip |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 25 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Indicates if horse clams were the target or harvested on last Puget Sound trip |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Horse Clam Target, Horse Clam Not Target |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | prenotice_letter_mailed_date_dim$month_abbrev |
---|---|
Seq. Order | |
Data Storage Type | bpchar |
Max Length | 3 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
three character representation of month in capital letters |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | JAN, FEB, MAR, APR, MAY, JUN, JUL, AUG, SEP, OCT, NOV, DEC |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | a2e_days_harvesting_other |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 3 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Number of days in the last 12 months spent recreationally harvesting other shellfish in Puget Sound including San Juan Islands, Strait of Juan de Fuca, and Hood Canal |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | final_mail_disposition_date_dim$month_of_year |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
numeric representation of month of year |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 1-12 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | final_mail_disposition_date_whid |
---|---|
Seq. Order | |
Data Storage Type | int8 |
Max Length | 64 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Warehouse identifier for final mail disposition date |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | post_card_mailed_date_whid |
---|---|
Seq. Order | |
Data Storage Type | int8 |
Max Length | 64 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Warehouse identifier for post card mailed date |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | initial_survey_packet_mailed_date_dim$full_date |
---|---|
Seq. Order | |
Data Storage Type | timestamp |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
full date value |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | sample_sex_dim$sex |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 20 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description | |
General Data Type | |
Unit of Measure | unspecified |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Any |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | residential_zip |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 10 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Residential zip |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | a10c_reason_spend_time_with_friends_or_others_rating |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 20 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Respondent harvests clams or oysters in Puget Sound for the reason of spending time with friends or others given a rating system of 5 for strongly agree and 1 for strongly disagree |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Strongly Agree, Agree, Feel Neutral, Disagree, Strongly Disagree |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | c5_2a_quantity_harvest_trips_most_used_beach_during_open_9_months |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Number of trips might take to harvest clams or oysters in Puget Sound at most used beach during other months of 3 month closure |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 0-98 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | last_call_phone_disposition |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Disposition of the last phone call |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | ANSWERING MACHINE, BREAK OFF DURING SCREENER, BUSY, CHANGED NUMBER, CLAIMS PREVIOUS INTERVIEW, COMPLETED SURVEY, INITIAL (HARD) REFUSAL, NO ANSWER, NON-RESIDENTIAL NUMBER, NON-WORKING NUMBER, OTHER LANGUAGE BARRIER / HEARING PROBLEM, OTHER PHONE PROBLEM, OTHER PHONE PROBLEMS, QUALIFIED REFUSAL, SPANISH LANGUAGE BARRIER, SPECIFIED CALLBACK, TERMINATE INVITATION, TERMINATE Q2, UNSPECIFIED CALLBACK, WRONG NUMBER |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | b11_3_number_kept_last_trip_horse_clams |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Quantity of horse clams kept on last Puget Sound trip |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 0-14 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | residential_city |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 80 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Residential city |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | c2a_quantity_harvest_trips_most_used_beach_open_all_season |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Number of trips might take to harvest clams or oysters in Puget Sound at most used beach assuming no biotoxin or pollution closures |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 0-75 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | initial_survey_packet_mailed_date_whid |
---|---|
Seq. Order | |
Data Storage Type | int8 |
Max Length | 64 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Warehouse identifier for initial survey packet mailed date |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | a10a_reason_spend_time_outdoors_rating |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 20 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Respondent harvests clams or oysters in Puget Sound for the reason of spending time outdoors given a rating system |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Strongly Agree, Agree, Feel Neutral, Disagree, Strongly Disagree |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | b12f1_money_spent_last_trip_camping |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Money spent on last Puget Sound trip by self or household on campgrounds and trailer parks rounded to nearest dollar |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 0-250 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | b12h1_money_spent_last_trip_vaca_rental |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Money spent on last Puget Sound trip by self or household on vacation rental rounded to nearest dollar |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 0-300 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | last_call_date_dim$month_of_year |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
numeric representation of month of year |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 1-12 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | b1101_target_steamer_clams_last_trip |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 25 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Indicates if steam clams (manila, littleneck, butter, cockle, softshell, macoma) were the target or harvested on last Puget Sound trip |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Steamer Clam Target, Steamer Clam Not Target |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | c6_1a_quantity_harvest_trips_most_used_beach_closed_1_month |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Number of trips might take to harvest clams or oysters in Puget Sound at most used beach during 1 month closure |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 0-75 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | d7_hourly_wage_range |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 20 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Approximate personal hourly wage rate range |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | $5.00-$9.99, $10.00-$14.99, $15.00-$19.99, $20.00-$29.99, $30.00-$39.99, $40.00-$49.99, $50.00-$59.99, $60.00-$74.99, $75.00 or More |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | b12eoth_other_transport_last_trip_type |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 40 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Other transportation type on last Puget Sound trip |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | b12j2_number_people_last_trip_restaurants_bars |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Number people covered on last Puget Sound trip by self or household on restaurants and bars rounded to nearest dollar |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 0-99 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | second_survey_packet_mailed_date_dim$year |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
numeric representation of year |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 1978+ |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | a1_razor_clam_harvest |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Have you harvested RAZOR CLAMS in Washington in the last 12 months? |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Razor Clams Harvested, Razor Clams Not Harvested, Don't Know/Not Sure Razor Clams Harvested, Refused Response Razor Clams Harvesed |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | final_mail_disposition_date_dim$full_date |
---|---|
Seq. Order | |
Data Storage Type | timestamp |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
full date value |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | a9_range_other_beaches_used |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 100 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Concatenated list of ranges of other beaches used nearby the most used beach to recreationally harvest shellfish in the last 12 months |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | None, Within 10 Miles, Between 11 and 20 Miles, Between 21 and 30 Miles, More than 30 miles |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | a2d_days_harvesting_shrimp |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 3 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Number of days in the last 12 months spent recreationally harvesting shrimp in Puget Sound including San Juan Islands, Strait of Juan de Fuca, and Hood Canal |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | a6_2_miles_by_boat_beach_most_used |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Number of one way miles travelled by boat (not including ferry) to most used beach recreationally harvesting shellfish in the last 12 months measured to nearest mile |
General Data Type | |
Unit of Measure | mi |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 1-22 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | b12koth_other_lodging_food_last_trip_type |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 60 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Other lodging or food type on last Puget Sound trip |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | CABIN RENTAL, FRIEND'S HOUSE, GROCERIES, HARDWARE, NA |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | b1104_target_oysters_last_trip |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 20 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Indicates if oysters were the target or harvested on last Puget Sound trip |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Oysters Target, Oysters Not Target |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | other_mail_disposition_date_dim$yyyymmdd |
---|---|
Seq. Order | |
Data Storage Type | bpchar |
Max Length | 8 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
text representation of year month day |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | b12k1_money_spent_last_trip_other_lodging_food |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Money spent on last Puget Sound trip by self or household on other lodging or food rounded to nearest dollar |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 0-2000 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | second_survey_packet_mailed_date_dim$month_abbrev |
---|---|
Seq. Order | |
Data Storage Type | bpchar |
Max Length | 3 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
three character representation of month in capital letters |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | JAN, FEB, MAR, APR, MAY, JUN, JUL, AUG, SEP, OCT, NOV, DEC |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | sample_birth_date_dim$month_of_year |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
numeric representation of month of year |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 1-12 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | b12f2_number_people_last_trip_camping |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Number people covered on last Puget Sound trip by self or household on campgrounds and trailer parks rounded to nearest dollar |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 0-5 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | c6_2b_quantity_nonharvest_trips_most_used_beach_during_opened_11_months |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Number of trips might take that do not include harvesting clams or oysters in Puget Sound at most used beach during other months of 1 month closure |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 0-67 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | prenotice_letter_mailed_date_dim$month_of_year |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
numeric representation of month of year |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 1-12 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | b7_2_miles_by_boat_last_trip |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Number of one way miles travelled by boat (not including ferry) to most used Pugent Sound clam (not razor clams) or oyster trip |
General Data Type | |
Unit of Measure | mi |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 2016/01/15 00:00:00.000 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | c4_1c_quantity_harvest_trips_nearby_beach_most_used_closed_all_season |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Number of trips might take to harvest clams or oysters in Puget Sound at a nearby fully open beach if most used was closed all season |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 0-75 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | b12a1_money_spent_last_trip_land_vehicle |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Money spent on last Puget Sound trip by self or household on auto, truck, or RV fuel rounded to nearest dollar |
General Data Type | |
Unit of Measure | dol |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | sample_birth_date_dim$day_of_month |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
numeric representation of the day in month |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 1-31 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | c53_quantity_harvest_trips_nearby_beach_while_most_used_fully_open |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Number of trips might take to harvest clams or oysters in Puget Sound at a nearby fully open beach while most used open |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 0-98 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | c5_type_of_closure |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 15 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Type of closure for questions in section C5 |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Biotoxin, Pollution |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | a4_beach_most_used_access_type |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 20 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Type of access of the beach most used to recreationally harvest shellfish in the last 12 months |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Private beach, Public beach, Don't Know/Not Sure, Refused |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | b1_month_last_trip |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
The month number of the last trip spent harvesting clams (not including razor clams) or oysters |
General Data Type | |
Unit of Measure | mon |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 1-12 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | c6_2a_quantity_harvest_trips_most_used_beach_during_opened_11_months |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Number of trips might take to harvest clams or oysters in Puget Sound at most used beach during other months of 1 month closure |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 0-80 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | b12d1_money_spent_last_trip_ferry |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Money spent on last Puget Sound trip by self or household on ferry rounded to nearest dollar |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 0-150 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | initial_survey_packet_mailed_date_dim$month_name |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 10 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
text representation of month |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | January, February, March, April, May, June, July, August, September, October, November, December |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | b703_foot_travel_last_trip |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 25 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Indicates if travel to most recent Pugent Sound clam (not razor clams) or oyster trip was by foot or not |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Travelled by Foot, Not Travelled by Foot |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | a10b_reason_spend_time_with_family_rating |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 20 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Respondent harvests clams or oysters in Puget Sound for the reason of spending time with family given a rating system of 5 for strongly agree and 1 for strongly disagree |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Strongly Agree, Agree, Feel Neutral, Disagree, Strongly Disagree |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | b11oth_other_targetted_last_trip_type |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Other type targetted or harvested at last trip in Puget Sound |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | BLUE MUSSLES AND BARNICKLE, BUTTER, BUTTER CLAMS, CLAMS, COCKLE, COCKLE, COCKLES, CRAB, CRAB DUNGENESS, LITTLE NECKS AND STEAMERS, LITTLE NECKS MANILA, MANILA, MUSSEL, MUSSELLS, MUSSELS, RED ROCK CRAB, REGISTERED WITH WSFW #42, SHRIMP, VARNISH CLAMS |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | prenotice_letter_mailed_date_dim$month_name |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 10 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
text representation of month |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | January, February, March, April, May, June, July, August, September, October, November, December |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | b1105_target_other_last_trip |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 20 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Indicates if other type were the target or harvested on last Puget Sound trip |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Other Target, Other Not Target |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | which_survey_completed |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Which survey number was completed |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | b11_4_number_kept_last_trip_oysters |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Quantity of oysters kept on last Puget Sound trip |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 0-999 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | last_call_date_dim$month_name |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 10 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
text representation of month |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | January, February, March, April, May, June, July, August, September, October, November, December |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | second_survey_packet_mailed_date_dim$month_of_year |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
numeric representation of month of year |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 1-12 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | b13_harvest_shellfish_next_12_months_likely_rating |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 40 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Likeliness surveyor will take a trip to Puget Sound to harvest shellfish |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Definitely Will Harvest Shellfish, Very Likely, Somewhat Likely, Very Unlikely, Definitely Will Not Harvest Shellfish |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | second_survey_packet_mailed_date_dim$yyyymmdd |
---|---|
Seq. Order | |
Data Storage Type | bpchar |
Max Length | 8 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
text representation of year month day |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | last_call_date_dim$yyyymmdd |
---|---|
Seq. Order | |
Data Storage Type | bpchar |
Max Length | 8 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
text representation of year month day |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | a10g_reason_provide_food_for_family_rating |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 20 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Respondent harvests clams or oysters in Puget Sound for the reason of providing food for self or family given a rating system of 5 for strongly agree and 1 for strongly disagree |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Strongly Agree, Agree, Feel Neutral, Disagree, Strongly Disagree |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | third_survey_packet_mailed_date_dim$month_name |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 10 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
text representation of month |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | January, February, March, April, May, June, July, August, September, October, November, December |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | q5_harvest_shellfish_rating_next_12_mo |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 40 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
During the next 12 months, how likely is it that you will take a trip where you harvest shellfish in Puget Sound? |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Definitely will harvest shellfish, Definitely will not harvest shellfish, Somewhat likely, Very likely, Very unlikely |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | a2eot1_other_shellfish_harvested |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 40 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Other type of shellfish recreationally harvested in Puget Sound including the San Juan Islands, Strait of Juan de Fuca, and Hood Canal within the last 12 months |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | c3_1b_quantity_nonharvest_trips_most_used_beach_closed_all_season |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Number of trips might take that do not include harvesting clams or oysters in Puget Sound at most used beach that was closed all season |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 0-75 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | b12b2_number_people_last_trip_water_vehicle |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Number people covered on last Puget Sound trip by self or household on boat fuel rounded to nearest dollar |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 1-8 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | prenotice_letter_mailed_date_dim$yyyymmdd |
---|---|
Seq. Order | |
Data Storage Type | bpchar |
Max Length | 8 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
text representation of year month day |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | sample_birth_date_dim$record_type |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
date, month, or year record or reason record is unavailable |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Date, Month, Year, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | q6_respondent_birth_year |
---|---|
Seq. Order | |
Data Storage Type | int |
Max Length | 10 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
In what year were you born? |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 1929-1995, Refused |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | verified_address |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Respondent verified address |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | RESPONDENT REFUSED TO PARTICIPATE IN MAIL SURVEY, YES, |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | initial_survey_packet_mailed_date_dim$day_of_month |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
numeric representation of the day in month |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 1-31 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | other_mail_disposition_date_dim$month_abbrev |
---|---|
Seq. Order | |
Data Storage Type | bpchar |
Max Length | 3 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
three character representation of month in capital letters |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | JAN, FEB, MAR, APR, MAY, JUN, JUL, AUG, SEP, OCT, NOV, DEC |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | a10f_reason_eat_self_caught_rating |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 20 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Respondent harvests clams or oysters in Puget Sound for the reason of eating something self caught given a rating system of 5 for strongly agree and 1 for strongly disagree |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Strongly Agree, Agree, Feel Neutral, Disagree, Strongly Disagree |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | third_survey_packet_mailed_date_dim$year |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
numeric representation of year |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 1978+ |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | d5_household_income_range |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 20 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Best description of household total annual income before taxes |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Less than $20,000, $20,000-$39,999, $40,000-59,999, $60,000-$79,999, $80,000-$99,999, $100,000-$124,999, $125,000-$149,999, $150,000 or More |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | post_card_mailed_date_dim$full_date |
---|---|
Seq. Order | |
Data Storage Type | timestamp |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
full date value |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | c6_additional_distance_to_nearby_fully_open_beach |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 20 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Additional distance to nearby beach that is fully open for questions in section C6 |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 30 miles away, 20 miles away, 10 miles away, 5 miles away |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | post_card_mailed_date_dim$month_name |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 10 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
text representation of month |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | January, February, March, April, May, June, July, August, September, October, November, December |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | third_survey_packet_mailed_date_dim$yyyymmdd |
---|---|
Seq. Order | |
Data Storage Type | bpchar |
Max Length | 8 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
text representation of year month day |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | b12e2_number_people_last_trip_other_transport |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Number people covered on last Puget Sound trip by self or household on other transport rounded to nearest dollar |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 2 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | b4_hours_spent_harvesting_last_trip |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
The number of hours (rounded to nearest hour) spent harvesting clams or oysters on most recent Puget Sound trip |
General Data Type | |
Unit of Measure | hr |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 1-30 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | d4a_household_adult_size |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Number of adults within household including self |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 1-6 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | other_mail_disposition_date_dim$year |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
numeric representation of year |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 1978+ |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | c3_period_of_closure |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 15 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Period of closure for questions in section C3 |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 12 months, 3 months |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | a5_beach_most_used |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 60 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Name of the beach most used to recreationally harvest shellfish in the last 12 months |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | last_call_date_dim$record_type |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
date, month, or year record or reason record is unavailable |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Date, Month, Year, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | c6_2c_quantity_harvest_trips_nearby_beach_during_most_used_opened_11_months |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Number of trips might take to harvest clams or oysters in Puget Sound at a nearby fully open beach during other months of most used 1 month closure |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 0-20 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | c4_species_closed_to_harvest |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 20 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Species that are closed to harvest for questions in section C4 |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Clams/Oysters, Razor Clams |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | third_survey_packet_mailed_date_dim$full_date |
---|---|
Seq. Order | |
Data Storage Type | timestamp |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
full date value |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | d2_sex_dim$sex_abbreviation |
---|---|
Seq. Order | |
Data Storage Type | bpchar |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description | |
General Data Type | |
Unit of Measure | unspecified |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Any |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | mail_comments |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 20 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Mail comments |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Remove from list, Was Forwarded |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | other_mail_disposition_date_dim$month_of_year |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
numeric representation of month of year |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 1-12 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | b1002_boat_travel_last_overnight_trip |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 25 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Indicates if travel to most recent Pugent Sound clam (not razor clams) or oyster overnight trip was by boat or not |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Travelled by Boat, Not Travelled by Boat |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | third_survey_packet_mailed_date_dim$record_type |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
date, month, or year record or reason record is unavailable |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Date, Month, Year, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | a7_ferry_travel_beach_most_used |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Do you take a ferry as part of your trip to get to the beach you most often used? |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | No, Yes |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | c6_species_closed_to_harvest |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 20 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Species that are closed to harvest for questions in section C6 |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Clams/Oysters, Razor Clams |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | initial_survey_packet_mailed_date_dim$month_of_year |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
numeric representation of month of year |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 1-12 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | c63_quantity_harvest_trips_nearby_beach_while_most_used_fully_open |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Number of trips might take to harvest clams or oysters in Puget Sound at a nearby fully open beach while most used open |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 0-36 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | prenotice_letter_mailed_date_dim$year |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
numeric representation of year |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 1978+ |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | b12i2_number_people_last_trip_grocery |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Number people covered on last Puget Sound trip by self or household on grocery and convvenience stores rounded to nearest dollar |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 0-99 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | initial_survey_packet_mailed_date_dim$record_type |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
date, month, or year record or reason record is unavailable |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Date, Month, Year, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | b1001_car_travel_last_overnight_trip |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 25 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Indicates if travel to most recent Pugent Sound clam (not razor clams) or oyster overnight trip was by car or not |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Travelled by Car, Not Travelled by Car |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | d3_education_level |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Education level of respondent |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Some High School, High School Graduate, Technical School, Some College, College Graduate or More |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | b1003_foot_travel_last_overnight_trip |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 25 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Indicates if travel to most recent Pugent Sound clam (not razor clams) or oyster overnight trip was by foot or not |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Travelled by Foot, Not Travelled by Foot |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | b12i1_money_spent_last_trip_grocery |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Money spent on last Puget Sound trip by self or household on grocery and convvenience stores rounded to nearest dollar |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 0-1500 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | prenotice_letter_mailed_date_dim$full_date |
---|---|
Seq. Order | |
Data Storage Type | timestamp |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
full date value |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | call_length |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Length of call measured in minutes |
General Data Type | |
Unit of Measure | min |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 0-17 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | initial_survey_packet_mailed_date_dim$month_abbrev |
---|---|
Seq. Order | |
Data Storage Type | bpchar |
Max Length | 3 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
three character representation of month in capital letters |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | JAN, FEB, MAR, APR, MAY, JUN, JUL, AUG, SEP, OCT, NOV, DEC |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | post_card_mailed_date_dim$year |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
numeric representation of year |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 1978+ |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | c5_1c_quantity_harvest_trips_nearby_beach_most_used_closed_3_months |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Number of trips might take to harvest clams or oysters in Puget Sound at a nearby fully open beach during most used 3 month closure |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 0-75 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | sample_birth_date_dim$full_date |
---|---|
Seq. Order | |
Data Storage Type | timestamp |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
full date value |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | prenotice_letter_mailed_date_dim$record_type |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
date, month, or year record or reason record is unavailable |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Date, Month, Year, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | b11_1_number_kept_last_trip_steamer_clams |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Quantity of steam clams kept on last Puget Sound trip |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 0-120 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | b12h2_number_people_last_trip_vaca_rental |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Number people covered on last Puget Sound trip by self or household on vacation rental rounded to nearest dollar |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 2.0 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | a2eot0_other_shellfish_harvested |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 40 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Other type of shellfish recreationally harvested in Puget Sound including the San Juan Islands, Strait of Juan de Fuca, and Hood Canal within the last 12 months |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | post_card_mailed_date_dim$record_type |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
date, month, or year record or reason record is unavailable |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Date, Month, Year, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | other_mail_disposition |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Other mail disposition |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | q1_taken_trips_harvesting_razor_clams |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 25 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Have you taken any trips where you harvested razor clams in Washington in the last 12 months? |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | DON'T KNOW / NOT SURE, No, REFUSED, Yes |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | sample_birth_date_dim$month_name |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 10 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
text representation of month |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | January, February, March, April, May, June, July, August, September, October, November, December |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | sample_id |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Shellfish survey sample ID |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | a3oth_name_of_city_near_beach_most_used |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Name of city not in list nearest beach respondent uses most to harvest shellfish |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | PENROSE, SAMISH ISLAND, SAMISH ISLAND BEACH, TOLOMIE |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | a11_consume_clams_or_oyster_frequency |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Frequency respondent eats meals containing clams or oysters harvested from Puget Sound |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Almost Never, About Once Per Year, Two or Three Times Per Year, Four to Ten Times Per Year, More Than Ten Times Per Year |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | third_survey_packet_mailed_date_whid |
---|---|
Seq. Order | |
Data Storage Type | int8 |
Max Length | 64 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Warehouse identifier for third survey packet mailed date |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | other_mail_disposition_date_dim$day_of_month |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
numeric representation of the day in month |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 1-31 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | third_survey_packet_mailed_date_dim$month_of_year |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
numeric representation of month of year |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 1-12 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | a8oth_other_lodging_most_used_type |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Other type of lodging used for one or more overnight stays at the most often used beach recreationally harvesting shellfish |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | BOAT, CABIN, CAMPING IN WOODS, FAMILY OWNED HOUSE, FAMILY OWNED VACATION HOME, FAMILY OWNS, FRIEND OWNED, FRIENDS, FRIEND'S, FRIEND'S BEACH HOUSE, FRIEND'S CABIN, FRIEND'S HOME, FRIEND'S HOUSE, FRIEND'S PLACE, LIVE ABOARD A BOAT, NA, NATIONAL FOREST CABIN, PARENTS (IN-LAWS), PARENT'S HOME, PARENT'S HOUSE, PRIVATE PROPERTY-CAMPING, RELATIONS, RELATIVE, RELATIVE'S HOME, STAY ON BOAT, STAY W/ FRIENDS, STAY WITH MY SON |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | final_mail_disposition_date_dim$month_abbrev |
---|---|
Seq. Order | |
Data Storage Type | bpchar |
Max Length | 3 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
three character representation of month in capital letters |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | JAN, FEB, MAR, APR, MAY, JUN, JUL, AUG, SEP, OCT, NOV, DEC |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | c5_period_of_closure |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 15 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Period of closure for questions in section C5 |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 12 months, 3 months |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | c3_species_closed_to_harvest |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 20 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Species that are closed to harvest for questions in section C3 |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Clams/Oysters, Razor Clams |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | post_card_mailed_date_dim$month_abbrev |
---|---|
Seq. Order | |
Data Storage Type | bpchar |
Max Length | 3 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
three character representation of month in capital letters |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | JAN, FEB, MAR, APR, MAY, JUN, JUL, AUG, SEP, OCT, NOV, DEC |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | b11_2_number_kept_last_trip_geoduck_clams |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Quantity of geoduck clams kept on last Puget Sound trip |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 0-20 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | b11_5_number_kept_last_trip_other |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Quantity of other clams kept on last Puget Sound trip |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 1-240 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | c5_2c_quantity_harvest_trips_nearby_beach_during_most_used_open_9_months |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Number of trips might take to harvest clams or oysters in Puget Sound at a nearby fully open beach during other months of most used 3 month closure |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 0-98 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | d4b_household_child_size |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Number of children (under 18) within household |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 0-5 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | c3_1c_quantity_harvest_trips_nearby_beach_most_used_closed_all_season |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Number of trips might take to harvest clams or oysters in Puget Sound at a nearby fully open beach if most used was closed all season |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 0-75 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | sample_birth_date_dim$year |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
numeric representation of year |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 1978+ |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | final_mail_disposition_date_dim$yyyymmdd |
---|---|
Seq. Order | |
Data Storage Type | bpchar |
Max Length | 8 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
text representation of year month day |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | last_call_date_dim$full_date |
---|---|
Seq. Order | |
Data Storage Type | timestamp |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
full date value |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | prenotice_letter_mailed_date_dim$day_of_month |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
numeric representation of the day in month |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 1-31 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | sample_birth_date_whid |
---|---|
Seq. Order | |
Data Storage Type | int8 |
Max Length | 64 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Warehouse identifier for birthdate from sample |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | d2_sex_whid |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Warehouse identifier of gender of respondent per questionaire |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | second_survey_packet_mailed_date_dim$record_type |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
date, month, or year record or reason record is unavailable |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Date, Month, Year, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | c5_2b_quantity_nonharvest_trips_most_used_beach_during_open_9_months |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Number of trips might take that do not include harvesting clams or oysters in Puget Sound at most used beach during other months of 3 month closure |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 0-98 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | c3_2_quantity_harvest_trips_nearby_beach_most_used_not_closed_all_season |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Number of trips might take to harvest clams or oysters in Puget Sound at a nearby fully open beach if most used was open all season |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 0-75 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | last_call_date_dim$day_of_month |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
numeric representation of the day in month |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 1-31 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | b701_car_travel_last_trip |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 25 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Indicates if travel to most recent Pugent Sound clam (not razor clams) or oyster trip was by car or not |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Travelled by Car, Not Travelled by Car |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | c3_1a_quantity_harvest_trips_most_used_beach_closed_all_season |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Number of trips might take to harvest clams or oysters in Puget Sound at most used beach that was closed all season |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 0-75 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | a3_name_of_city_near_beach_most_used |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Name of city from a list of cities that is nearest the beach respondent uses most to harvest shellfish |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Anacortes, Bellingham, Blaine, Bremerton, Brinnon, Everett, Hoodsport, Langly, Mount Vernon, Olympia, Orcas, Port Angeles, Port Townsend, Poulsbo, Seattle, Sekiu, Shelton, Tacoma, Other (SPECIFY) |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | third_survey_packet_mailed_date_dim$month_abbrev |
---|---|
Seq. Order | |
Data Storage Type | bpchar |
Max Length | 3 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
three character representation of month in capital letters |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | JAN, FEB, MAR, APR, MAY, JUN, JUL, AUG, SEP, OCT, NOV, DEC |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | c5_1a_quantity_harvest_trips_most_used_beach_closed_3_months |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Number of trips might take to harvest clams or oysters in Puget Sound at most used beach during 3 month closure |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 0-99 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | c6_1b_quantity_nonharvest_trips_most_used_beach_closed_1_ month |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Number of trips might take that do not include harvesting clams or oysters in Puget Sound at most used beach during 1 month closure |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 0-50 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | d8_2_paid_time_off_work |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 20 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Indicates if respondent took paid time off (vacation, sick, etc.) to harvest shellfish |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Paid Time Off, Not Paid Time Off |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | b9oth_other_lodging_type_last_trip |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The type of lodging not available in list used one or more nights at most recent Puget Sound clam (not razor clams) or oyster trip |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | other_mail_disposition_date_dim$full_date |
---|---|
Seq. Order | |
Data Storage Type | timestamp |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
full date value |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | second_survey_packet_mailed_date_dim$month_name |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 10 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
text representation of month |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | January, February, March, April, May, June, July, August, September, October, November, December |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | initial_survey_packet_mailed_date_dim$yyyymmdd |
---|---|
Seq. Order | |
Data Storage Type | bpchar |
Max Length | 8 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
text representation of year month day |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | a603_foot_travel_beach_most_used |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 25 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Indicates if travel to most used beach to recreationally harvest shellfish in the last 12 month was by foot |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Travelled by Foot, Not Travelled by Foot |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | second_survey_packet_mailed_date_dim$full_date |
---|---|
Seq. Order | |
Data Storage Type | timestamp |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
full date value |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | c4_additional_distance_to_nearby_fully_open_beach |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 20 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Additional distance to nearby beach that is fully open for questions in section C4 |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 30 miles away, 20 miles away, 10 miles away, 5 miles away |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | third_survey_packet_mailed_date_dim$day_of_month |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
numeric representation of the day in month |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 1-31 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | c6_type_of_closure |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 15 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Type of closure for questions in section C6 |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Biotoxin, Pollution |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | b2_days_spent_last_trip |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
The number of days (partial days count as full days and includes travel) spent on the last whole trip to the most recent Puget Sound beach to harvest clam (not razor clams) or oysters |
General Data Type | |
Unit of Measure | days |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 1-13 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | a8_lodging_beach_most_used |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
On the trip(s) you took to the beach you most often used, did you usually stay one or more nights in a house you own, a vacation rental, a hotel / motel, or a campground? |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | No. This is usually a day trip, House Respondent Owns, Vacation Rental, Hotel Motel or B&B, Campground or Trailer Park, Family or Friend's Home, Other |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | master_id |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Shellfish survey master ID |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | b12c2_number_people_last_trip_parking_launch |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Number people covered on last Puget Sound trip by self or household on parking or boat launch rounded to nearest dollar |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 1-4 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | b1102_target_geoduck_clams_last_trip |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 25 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Indicates if geoduck clams were the target or harvested on last Puget Sound trip |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Geoduck Clam Target, Geoduck Clam Not Target |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | second_survey_packet_mailed_date_dim$day_of_month |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
numeric representation of the day in month |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 1-31 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | a10e_reason_get_some_exercise_rating |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 20 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Respondent harvests clams or oysters in Puget Sound for the reason of getting some exercise given a rating system of 5 for strongly agree and 1 for strongly disagree |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Strongly Agree, Agree, Feel Neutral, Disagree, Strongly Disagree |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | c1_trip_months_list |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 100 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Concatenated list of month names in which surveyor takes trips to harvest clams or oysters in Puget Sound |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | January, February, March, April, May, June, July, August, September, October, November, December |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | b10_1_miles_by_car_last_overnight_trip |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Number of one way miles travelled by car to most recent Pugent Sound clam (not razor clams) or oyster overnight trip |
General Data Type | |
Unit of Measure | mi |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 0-80 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | d8_1_no_time_off_work |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 15 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Indicates if respondent did not take time off to harvest shellfish |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | No Time Off, Time Off |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | residential_street |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 150 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Residential street address |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | c4_2_quantity_harvest_trips_nearby_beach_most_used_not_closed_all_season |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Number of trips might take to harvest clams or oysters in Puget Sound at a nearby fully open beach if most used was open all season |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 0-98 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | prenotice_letter_mailed_date_whid |
---|---|
Seq. Order | |
Data Storage Type | int8 |
Max Length | 64 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Warehouse identifier for prenotice letter mailed date |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | post_card_mailed_date_dim$yyyymmdd |
---|---|
Seq. Order | |
Data Storage Type | bpchar |
Max Length | 8 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
text representation of year month day |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | c6_1c_quantity_harvest_trips_nearby_beach_most_used_closed_1_month |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Number of trips might take to harvest clams or oysters in Puget Sound at a nearby fully open beach during most used 1 month closure |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 0-18 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | final_mail_disposition_date_dim$year |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
numeric representation of year |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 1978+ |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | b12a2_number_people_last_trip_land_vehicle |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Number people covered on last Puget Sound trip by self or household on auto, truck, or RV fuel rounded to nearest dollar |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | b3_days_spent_harvesting_last_trip |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
The number of days (partial days count as full days and includes travel) spent harvesting clam (not razor clams) or oysters at the most recent Pugent Sound trip |
General Data Type | |
Unit of Measure | days |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 1-11 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | sample_sex_dim$record_type |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
latitude record type or reason record is unavailable |
General Data Type | |
Unit of Measure | NA |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Latitude, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | b12c1_money_spent_last_trip_parking_launch |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Money spent on last Puget Sound trip by self or household on parking or boat launch rounded to nearest dollar |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 0-800 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | a6_1_miles_by_car_beach_most_used |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Number of one way miles travelled by car to most used beach recreationally harvesting shellfish in the last 12 months measured to nearest mile |
General Data Type | |
Unit of Measure | mi |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 1-300 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | c2b_quantity_nonharvest_trips_most_used_beach_open_all_season |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Number of trips might take that do not include harvesting clams or oysters in Puget Sound at most used beach assuming no biotoxin or pollution closures |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 0-80 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | c5_additional_distance_to_nearby_fully_open_beach |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 20 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Additional distance to nearby beach that is fully open for questions in section C5 |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 30 miles away, 20 miles away, 10 miles away, 5 miles away |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | b12e1_money_spent_last_trip_other_transport |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Money spent on last Puget Sound trip by self or household on other transport rounded to nearest dollar |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 0-4 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | sample_birth_date_dim$month_abbrev |
---|---|
Seq. Order | |
Data Storage Type | bpchar |
Max Length | 3 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
three character representation of month in capital letters |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | JAN, FEB, MAR, APR, MAY, JUN, JUL, AUG, SEP, OCT, NOV, DEC |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | a601_car_travel_beach_most_used |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 25 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Indicates if travel to most used beach to recreationally harvest shellfish in the last 12 month was by car |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Travelled by Car, Not Travelled by Car |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | a602_boat_travel_beach_most_used |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 25 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Indicates if travel to most used beach to recreationally harvest shellfish in the last 12 month was by boat |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Travelled by Boat, Not Travelled by Boat |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | d2_sex_dim$sex |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 20 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description | |
General Data Type | |
Unit of Measure | unspecified |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Any |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | b12j1_money_spent_last_trip_restaurants_bars |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Money spent on last Puget Sound trip by self or household on restaurants and bars rounded to nearest dollar |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 0-400 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | a2eoth_other_shellfish_harvested |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 40 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Other type of shellfish recreationally harvested in Puget Sound including the San Juan Islands, Strait of Juan de Fuca, and Hood Canal within the last 12 months |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | a2a_days_harvesting_clams |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 3 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Number of days in the last 12 months spent recreationally harvesting clams (other than razor clams) in Puget Sound including San Juan Islands, Strait of Juan de Fuca, and Hood Canal |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | sample_birth_date_dim$yyyymmdd |
---|---|
Seq. Order | |
Data Storage Type | bpchar |
Max Length | 8 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
text representation of year month day |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | a10d_reason_relax_rating |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 20 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Respondent harvests clams or oysters in Puget Sound for the reason of relaxing given a rating system of 5 for strongly agree and 1 for strongly disagree |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Strongly Agree, Agree, Feel Neutral, Disagree, Strongly Disagree |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | post_card_mailed_date_dim$day_of_month |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
numeric representation of the day in month |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 1-31 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | initial_survey_packet_mailed_date_dim$year |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
numeric representation of year |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 1978+ |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | d2_sex_dim$record_type |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
latitude record type or reason record is unavailable |
General Data Type | |
Unit of Measure | NA |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Latitude, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | b12g1_money_spent_last_trip_hotels |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Money spent on last Puget Sound trip by self or household on hotels, motels, and B&B rounded to nearest dollar |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 0-150 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | b9_lodging_type_last_trip |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The type of lodging used one or more nights at most recent Puget Sound clam (not razor clams) or oyster trip |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | None, House Self Owned, Vacation Rental, Hotel Motel or B&B, Campground or Trailer Park, Family or Friend's Home, Other |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | other_mail_disposition_date_whid |
---|---|
Seq. Order | |
Data Storage Type | int8 |
Max Length | 64 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Warehouse identifier for other mail disposition date |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | b5_beach_access_type_last_trip |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 20 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Access type of the beach most recently used in the Puget Sound to harvest clams (not razor clams) or oysters |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Private Beach, Public Beach, Don't Know/Not Sure, Refused |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | b12k2_number_people_last_trip_other_lodging_food |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Number people covered on last Puget Sound trip by self or household on other lodging or food rounded to nearest dollar |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 1-10 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | c3_additional_distance_to_nearby_fully_open_beach |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 20 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Additional distance to nearby beach that is fully open for questions in section C3 |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 30 miles away, 20 miles away, 10 miles away, 5 miles away |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | shellfish_2013 |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 25 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Indicates if respondent purchased shellfish license in 2013 |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Shellfish License, No Shellfish License, NA |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | post_card_mailed_date_dim$month_of_year |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
numeric representation of month of year |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 1-12 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | c5_1b_quantity_nonharvest_trips_most_used_beach_closed_3_months |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Number of trips might take that do not include harvesting clams or oysters in Puget Sound at most used beach during 3 month closure |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 0-50 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | c3_type_of_closure |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 15 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Type of closure for questions in section C3 |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Biotoxin, Pollution |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | second_survey_packet_mailed_date_whid |
---|---|
Seq. Order | |
Data Storage Type | int8 |
Max Length | 64 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Warehouse identifier for second survey packet mailed date |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | d8_3_unpaid_time_off_work |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 20 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Indicates if respondent took unpaid time off to harvest shellfish |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Unpaid Time Off, Not Unpaid Time Off |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | sample_sex_dim$sex_abbreviation |
---|---|
Seq. Order | |
Data Storage Type | bpchar |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description | |
General Data Type | |
Unit of Measure | unspecified |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Any |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | c4_1a_quantity_harvest_trips_most_used_beach_closed_all_season |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Number of trips might take to harvest clams or oysters in Puget Sound at most used beach that was closed all season |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 0-75 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | q7_respondent_income_range |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Im going to read you some income categories. For classification purposes only, please tell me which income category best describes your households total annual income before taxes in 2012. When I read your household income category, please stop me. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Less than $20,000, More than $20,000 but less than $40,000, More than $40,000 but less than $60,000, More than $60,000 but less than $80,000, More than $80,000 but less than $100,000, More than $100,000 but less than $125,000, More than $125,000 but less than $150,000, More than $150,000, Refused |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | b6_beach_name_last_trip |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 60 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Name of most recent beach in Puget Sound to harvest clams (not razor clams) or oysters |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | q4_miles_travel_to_harvest_beach |
---|---|
Seq. Order | |
Data Storage Type | int |
Max Length | 25 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Approximately how many one-way miles do you travel to get to the beach you most often use to harvest oysters or clams in Puget Sound? |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 1-350, Don't know/Not Sure, Less than one mile |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | b12d2_number_people_last_trip_ferry |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Number people covered on last Puget Sound trip by self or household on ferry rounded to nearest dollar |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 1-8 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | d9_survey_comments |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 1000 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Additional comments from respondent |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | c5_species_closed_to_harvest |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 20 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Species that are closed to harvest for questions in section C5 |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Clams/Oysters, Razor Clams |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | b12b1_money_spent_last_trip_water_vehicle |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Money spent on last Puget Sound trip by self or household on boat fuel rounded to nearest dollar |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 0-100 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | q2_taken_trips_harvesting_oysters_clams |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 25 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Have you taken any trips where you harvested oysters or clams in Puget Sound in the last 12 months? |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | DON'T KNOW / NOT SURE, No, REFUSED, Yes |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | |
---|---|
Seq. Order | |
Data Storage Type | |
Max Length | |
Precision | |
Scale | |
Required | |
Primary Key | |
Status | |
Description | |
General Data Type | |
Case Restriction | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Min Length | |
Unit of Measure | |
Display Example | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | |
---|---|
Seq. Order | |
Data Storage Type | |
Max Length | |
Precision | |
Scale | |
Required | |
Primary Key | |
Status | |
Description | |
General Data Type | |
Case Restriction | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Min Length | |
Unit of Measure | |
Display Example | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | |
---|---|
Seq. Order | |
Data Storage Type | |
Max Length | |
Precision | |
Scale | |
Required | |
Primary Key | |
Status | |
Description | |
General Data Type | |
Case Restriction | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Min Length | |
Unit of Measure | |
Display Example | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Support Roles
* » Support Role | |
---|---|
* » Date Effective From | |
Date Effective To | |
* » Contact | |
* Contact Instructions |
* » Support Role | |
---|---|
* » Date Effective From | |
Date Effective To | |
* » Contact | |
* Contact Instructions |
* » Support Role | |
---|---|
* » Date Effective From | |
Date Effective To | |
* » Contact | |
* Contact Instructions |
Extents
Currentness Reference |
---|
Extent Group 1
Extent Description |
---|
Extent Group 1 / Geographic Area
* » W° Bound | |
---|---|
* » E° Bound | |
* » N° Bound | |
* » S° Bound | |
* » Description |
Extent Group 1 / Vertical Extent
EPSG Code | |
---|---|
Vertical Minimum | |
Vertical Maximum |
Extent Group 1 / Time Frame
* » Time Frame Type | |
---|---|
* » Start | |
End | |
Alternate Start as of Info | |
Alternate End as of Info | |
Description |
Access Information
* » Security Class | |
---|---|
* Security Classification System |
|
Security Handling Description |
|
• Data Access Policy |
|
» Data Access Procedure |
|
• » Data Access Constraints |
|
• Data Use Constraints |
|
Metadata Access Constraints |
|
Metadata Use Constraints |
|
Distribution Information
Start Date | |
---|---|
End Date | |
» Download URL | |
Distributor | |
File Name | |
Description | |
File Date/Time | |
File Type | |
FGDC Content Type | |
File Size | |
Application Version | |
Compression | |
Review Status |
Start Date | |
---|---|
End Date | |
» Download URL | |
Distributor | |
File Name | |
Description | |
File Date/Time | |
File Type | |
FGDC Content Type | |
File Size | |
Application Version | |
Compression | |
Review Status |
Start Date | |
---|---|
End Date | |
» Download URL | |
Distributor | |
File Name | |
Description | |
File Date/Time | |
File Type | |
FGDC Content Type | |
File Size | |
Application Version | |
Compression | |
Review Status |
Activity Log
Activity Time | |
---|---|
Activity Type | |
Responsible Party | |
Description |
Activity Time | |
---|---|
Activity Type | |
Responsible Party | |
Description |
Activity Time | |
---|---|
Activity Type | |
Responsible Party | |
Description |
Issues
Issue Date | |
---|---|
Author | |
Issue |
Issue Date | |
---|---|
Author | |
Issue |
Issue Date | |
---|---|
Author | |
Issue |
FAQs
Date | |
---|---|
Author | |
Question | |
Answer |
Child Items
Rubric scores updated every 15m
Score | Type | Title |
---|---|---|
Related Items
Item Type | Relationship Type | Title |
---|---|---|
Catalog Details
Catalog Item ID | 36444 |
---|---|
Metadata Record Created By | Jeffrey W Cowen |
Metadata Record Created | 2017-01-25 13:22+0000 |
Metadata Record Last Modified By | SysAdmin InPortAdmin |
» Metadata Record Last Modified | 2022-08-09 17:11+0000 |
Metadata Record Published | 2017-02-13 |
Owner Org | NWFSC |
Metadata Publication Status | Published Externally |
Do Not Publish? | N |
Metadata Workflow State | Published / External |
Metadata Last Review Date | 2017-02-13 |
Metadata Review Frequency | 1 Year |
Metadata Next Review Date | 2018-02-13 |
Tags |
---|