csv file
Alaska Fisheries Science Center
Entity
(ENT)
| ID: 32493
| Published / External
Created: 2016-04-20
|
Last Modified: 2022-08-09
Data Set (DS) | ID: 24141
ID: 32493
Entity (ENT)
* Discovery• First Pass
» Metadata Rubric
Item Identification
* » Title | csv file |
---|---|
Short Name | csv file |
* Status | In Work |
Creation Date | |
Revision Date | |
• Publication Date | |
* » Abstract |
business survey |
* Purpose | |
Notes |
Loaded by FGDC Metadata Uploader, batch 8627, 04-20-2016 12:19 |
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 | |
---|---|
Active Version? | |
Alias | |
Schema Name | |
» Description |
business survey |
Change Summary |
Data Attributes
Attribute Summary
Score | Req'd? | PKey? | » Name | Data Storage Type | Description |
---|---|---|---|---|---|
100 | No | No | ID | numeric | survey identifier assigned by PSMFC |
100 | No | No | BOOKLET_ID | text | survey booklet identifier assigned by PSMFC |
100 | No | No | YEAR | numeric | year of survey |
100 | No | No | A1_BNAME | open ended text | respondent identification: sport fish business name |
100 | No | No | A1_LICNUM | open ended text | respondent identification: ADF&G sport fish business owner license number |
100 | No | No | A2_COUNTOWN | numeric | respondent identification: vessels owned |
100 | No | No | A2_COUNTLEASE | numeric | respondent identification: vessels leased |
100 | No | No | A2_COUNTNONRESP | numeric | respondent identification: vessels, own/lease not specified |
100 | No | No | B1_FTES | numeric | # of employees: guides/full-time/early shoulder |
100 | No | No | B1_FTMS | numeric | # of employees: guides/full-time/main season |
100 | No | No | B1_FTLS | numeric | # of employees: guides/full-time/late shoulder |
100 | No | No | B1_FTOS | numeric | # of employees: guides/full-time/off season |
100 | No | No | B1_PTES | numeric | # of employees: guides/part-time/early shoulder |
100 | No | No | B1_PTMS | numeric | # of employees: guides/part-time/main season |
100 | No | No | B1_PTLS | numeric | # of employees: guides/part-time/late shoulder |
100 | No | No | B1_PTOS | numeric | # of employees: guides/part-time/off season |
100 | No | No | B2_FTES | numeric | # of employees: other crew/full-time/early shoulder |
100 | No | No | B2_FTMS | numeric | # of employees: other crew/full-time/main season |
100 | No | No | B2_FTLS | numeric | # of employees: other crew/full-time/late shoulder |
100 | No | No | B2_FTOS | numeric | # of employees: other crew/full-time/off season |
100 | No | No | B2_PTES | numeric | # of employees: other crew/part-time/early shoulder |
100 | No | No | B2_PTMS | numeric | # of employees: other crew/part-time/main season |
100 | No | No | B2_PTLS | numeric | # of employees: other crew/part-time/late shoulder |
100 | No | No | B2_PTOS | numeric | # of employees: other crew/part-time/off season |
100 | No | No | B3_FTES | numeric | # of employees: shore/full-time/early shoulder |
100 | No | No | B3_FTMS | numeric | # of employees: shore/full-time/main season |
100 | No | No | B3_FTLS | numeric | # of employees: shore/full-time/late shoulder |
100 | No | No | B3_FTOS | numeric | # of employees: shore/full-time/off season |
100 | No | No | B3_PTES | numeric | # of employees: shore/part-time/early shoulder |
100 | No | No | B3_PTMS | numeric | # of employees: shore/part-time/main season |
100 | No | No | B3_PTLS | numeric | # of employees: shore/part-time/late shoulder |
100 | No | No | B3_PTOS | numeric | # of employees: shore/part-time/off season |
100 | No | No | B4_GUIDE | numeric | employee pay: guides |
100 | No | No | B4_CREW | numeric | employee pay: other crew |
100 | No | No | B4_SHORE | numeric | employee pay: shore employees |
100 | No | No | B5_GUIDEWAGE | binary | employee pay, wage option: guide |
100 | No | No | B5_GUIDESAL | binary | employee pay, salary option: guide |
100 | No | No | B5_GUIDESHARE | binary | employee pay, share option: guide |
100 | No | No | B5_GUIDEOTH | binary | employee pay, other option: guide |
100 | No | No | B5_GUIDEOTHDESC | open ended text | employee pay, other option description: guide |
100 | No | No | B5_CREWWAGE | binary | employee pay, wage option: other crew |
100 | No | No | B5_CREWSAL | binary | employee pay, salary option: other crew |
100 | No | No | B5_CREWSHARE | binary | employee pay, share option: other crew |
100 | No | No | B5_CREWOTH | binary | employee pay, other option: other crew |
100 | No | No | B5_CREWOTH_DESC | open ended text | employee pay, other option description: other crew |
100 | No | No | B5_SHOREWAGE | binary | employee pay, wage option: shore employee |
100 | No | No | B5_SHORESAL | binary | employee pay, salary option: shore employee |
100 | No | No | B5_SHORESHARE | binary | employee pay, share option: shore employee |
100 | No | No | B5_SHOREOTH | binary | employee pay, other option: shore employee |
100 | No | No | B5_SHOREOTH_DESC | open ended text | employee pay, other option description: shore employee |
100 | No | No | C1_FISHONLY | binary | trip offerings, fishing only option |
100 | No | No | C1_FISHHUNT | binary | trip offerings, combination fishing and hunting option |
100 | No | No | C1_FISHTOUR | binary | trip offerings, combination fishing and tour option |
100 | No | No | C1_TOURONLY | binary | trip offerings, tour only option |
100 | No | No | C1_OUTFIT | binary | trip offerings, outfitting option |
100 | No | No | C1_GAMETRANS | binary | trip offerings, game transport option |
100 | No | No | C1_GENTRANS | binary | trip offerings, general transportation option |
100 | No | No | C1_EVENT | binary | trip offerings, event hosting option |
100 | No | No | C1_RESEARCH | binary | trip offerings, research or oil spill services option |
100 | No | No | C1_OTHER | binary | trip offerings, other services option |
100 | No | No | C1_OTHERDESC | open ended text | trip offerings, other services description |
100 | No | No | C2_2HALF | binary | trip offerings: 2-species/half-day: not offered option |
100 | No | No | C2_2HALF_I | numeric | trip offerings: 2-species/half-day: individual price |
100 | No | No | C2_2HALF_B | numeric | trip offerings: 2-species/half-day: boat price |
100 | No | No | C2_23Q | binary | trip offerings: 2-species/three-quarter day: not offered option |
100 | No | No | C2_23Q_I | numeric | trip offerings: 2-species/three-quarter day: individual price |
100 | No | No | C2_23Q_B | numeric | trip offerings: 2-species/three-quarter day: boat price |
100 | No | No | C2_2FULL | binary | trip offerings: 2-species/full day: not offered option |
100 | No | No | C2_2FULL_I | numeric | trip offerings: 2-species/full day: individual price |
100 | No | No | C2_2FULL_B | numeric | trip offerings: 2-species/full day: boat price |
100 | No | No | C2_2NIGHT | binary | trip offerings: 2-species/overnight: not offered option |
100 | No | No | C2_2NIGHT_I | numeric | trip offerings: 2-species/overnight: individual price |
100 | No | No | C2_2NIGHT_B | numeric | trip offerings: 2-species/overnight: boat price |
100 | No | No | C2_2MULTI | binary | trip offerings: 2-species/multi-day: not offered option |
100 | No | No | C2_2MULTI_I | numeric | trip offerings: 2-species/multi-day: individual price |
100 | No | No | C2_2MULTI_B | numeric | trip offerings: 2-species/multi-day: boat price |
100 | No | No | C2_MULTIHALF | binary | trip offerings: multi-species/half-day: not offered option |
100 | No | No | C2_MULTIHALF_I | numeric | trip offerings: multi-species/half-day: individual price |
100 | No | No | C2_MULTIHALF_B | numeric | trip offerings: multi-species/half-day: boat price |
100 | No | No | C2_MULTI3Q | binary | trip offerings: multi-species/three-quarter day: not offered option |
100 | No | No | C2_MULTI3Q_I | numeric | trip offerings: multi-species/three-quarter day: individual price |
100 | No | No | C2_MULTI3Q_B | numeric | trip offerings: multi-species/three-quarter day: boat price |
100 | No | No | C2_MULTIFULL | binary | trip offerings: multi-species/full day: not offered option |
100 | No | No | C2_MULTIFULL_I | numeric | trip offerings: multi-species/full day: individual price |
100 | No | No | C2_MULTIFULL_B | numeric | trip offerings: multi-species/full day: boat price |
100 | No | No | C2_MULTINIGHT | binary | trip offerings: multi-species/overnight: not offered option |
100 | No | No | C2_MULTINIGHT_I | numeric | trip offerings: multi-species/overnight: individual price |
100 | No | No | C2_MULTINIGHT_B | numeric | trip offerings: multi-species/overnight: boat price |
100 | No | No | C2_MULTIMULTI | binary | trip offerings: multi-species/multi-day: not offered option |
100 | No | No | C2_MULTIMULTI_I | numeric | trip offerings: multi-species/multi-day: individual price |
100 | No | No | C2_MULTIMULTI_B | numeric | trip offerings: multi-species/multi-day: boat price |
100 | No | No | C3_HALHALF | binary | trip offerings: halibut/half-day: not offered option |
100 | No | No | C3_HALHALF_I | numeric | trip offerings: halibut/half-day: individual price |
100 | No | No | C3_HALHALF_B | numeric | trip offerings: halibut/half-day: boat price |
100 | No | No | C3_HAL3Q | binary | trip offerings: halibut/three-quarter day: not offered option |
100 | No | No | C3_HAL3Q_I | numeric | trip offerings: halibut/three-quarter day: individual price |
100 | No | No | C3_HAL3Q_B | numeric | trip offerings: halibut/three-quarter day: boat price |
100 | No | No | C3_HALFULL | binary | trip offerings: halibut/full day: not offered option |
100 | No | No | C3_HALFULL_I | numeric | trip offerings: halibut/full day: individual price |
100 | No | No | C3_HALFULL_B | numeric | trip offerings: halibut/full day: boat price |
100 | No | No | C3_HALNIGHT | binary | trip offerings: halibut/overnight: not offered option |
100 | No | No | C3_HALNIGHT_I | numeric | trip offerings: halibut/overnight: individual price |
100 | No | No | C3_HALNIGHT_B | numeric | trip offerings: halibut/overnight: boat price |
100 | No | No | C3_HALMULTI | binary | trip offerings: halibut/multi-day: not offered option |
100 | No | No | C3_HALMULTI_I | numeric | trip offerings: halibut/multi-day: individual price |
100 | No | No | C3_HALMULTI_B | numeric | trip offerings: halibut/multi-day: boat price |
100 | No | No | C3_SALHALF | binary | trip offerings: salmon/half-day: not offered option |
100 | No | No | C3_SALHALF_I | numeric | trip offerings: salmon/half-day: individual price |
100 | No | No | C3_SALHALF_B | numeric | trip offerings: salmon/half-day: boat price |
100 | No | No | C3_SAL3Q | binary | trip offerings: salmon/three-quarter day: not offered option |
100 | No | No | C3_SAL3Q_I | numeric | trip offerings: salmon/three-quarter day: individual price |
100 | No | No | C3_SAL3Q_B | numeric | trip offerings: salmon/three-quarter day: boat price |
100 | No | No | C3_SALFULL | binary | trip offerings: salmon/full day: not offered option |
100 | No | No | C3_SALFULL_I | numeric | trip offerings: salmon/full day: individual price |
100 | No | No | C3_SALFULL_B | numeric | trip offerings: salmon/full day: boat price |
100 | No | No | C3_SALNIGHT | binary | trip offerings: salmon/overnight: not offered option |
100 | No | No | C3_SALNIGHT_I | numeric | trip offerings: salmon/overnight: individual price |
100 | No | No | C3_SALNIGHT_B | numeric | trip offerings: salmon/overnight: boat price |
100 | No | No | C3_SALMULTI | binary | trip offerings: salmon/multi-day: not offered option |
100 | No | No | C3_SALMULTI_I | numeric | trip offerings: salmon/multi-day: individual price |
100 | No | No | C3_SALMULTI_B | numeric | trip offerings: salmon/multi-day: boat price |
100 | No | No | C3_OTHHALF | binary | trip offerings: other species/half-day: not offered option |
100 | No | No | C3_OTHHALF_I | numeric | trip offerings: other species/half-day: individual price |
100 | No | No | C3_OTHHALF_B | numeric | trip offerings: other species/half-day: boat price |
100 | No | No | C3_OTH3Q | binary | trip offerings: other species/three-quarter day: not offered option |
100 | No | No | C3_OTH3Q_I | numeric | trip offerings: other species/three-quarter day: individual price |
100 | No | No | C3_OTH3Q_B | numeric | trip offerings: other species/three-quarter day: boat price |
100 | No | No | C3_OTHFULL | binary | trip offerings: other species/full day: not offered option |
100 | No | No | C3_OTHFULL_I | numeric | trip offerings: other species/full day: individual price |
100 | No | No | C3_OTHFULL_B | numeric | trip offerings: other species/full day: boat price |
100 | No | No | C3_OTHNIGHT | binary | trip offerings: other species/overnight: not offered option |
100 | No | No | C3_OTHNIGHT_I | numeric | trip offerings: other species/overnight: individual price |
100 | No | No | C3_OTHNIGHT_B | numeric | trip offerings: other species/overnight: boat price |
100 | No | No | C3_OTHMULTI | binary | trip offerings: other species/multi-day: not offered option |
100 | No | No | C3_OTHMULTI_I | numeric | trip offerings: other species/multi-day: individual price |
100 | No | No | C3_OTHMULTI_B | numeric | trip offerings: other species/multi-day: boat price |
100 | No | No | C4_LD | binary | fishing-related services: long-distance fishing: not offered option |
100 | No | No | C4_LD_INC | binary | fishing-related services: long-distance fishing: included in trip package option |
100 | No | No | C4_LD_FEE | binary | fishing-related services: long-distance fishing: added fee option |
100 | No | No | C4_LD_AMT | numeric | fishing-related services: long-distance fishing: added fee amount |
100 | No | No | C4_LD_FEEBASE | text | fishing-related services: long-distance fishing: other basis indicator |
100 | No | No | C4_CLEAN1 | binary | fishing-related services: fish cleaning (h/g): not offered option |
100 | No | No | C4_CLEAN1_INC | binary | fishing-related services: fish cleaning (h/g): included in trip package option |
100 | No | No | C4_CLEAN1_FEE | binary | fishing-related services: fish cleaning (h/g): added fee option |
100 | No | No | C4_CLEAN1_AMT | numeric | fishing-related services: fish cleaning (h/g): added fee amount |
100 | No | No | C4_CLEAN1_FEEBASE | text | fishing-related services: fish cleaning (h/g): other basis indicator |
100 | No | No | C4_CLEAN2 | binary | fishing-related services: fish cleaning (skinning, etc.): not offered option |
100 | No | No | C4_CLEAN2_INC | binary | fishing-related services: fish cleaning (skinning, etc.): included in trip package option |
100 | No | No | C4_CLEAN2_FEE | binary | fishing-related services: fish cleaning (skinning, etc.): added fee option |
100 | No | No | C4_CLEAN2_AMT | numeric | fishing-related services: fish cleaning (skinning, etc.): added fee amount |
100 | No | No | C4_CLEAN2_FEEBASE | text | fishing-related services: fish cleaning (skinning, etc.): other basis indicator |
100 | No | No | C4_PACK | binary | fishing-related services: packing and shipping: not offered option |
100 | No | No | C4_PACK_INC | binary | fishing-related services: packing and shipping: included in trip package option |
100 | No | No | C4_PACK_FEE | binary | fishing-related services: packing and shipping: added fee option |
100 | No | No | C4_PACK_AMT | numeric | fishing-related services: packing and shipping: added fee amount |
100 | No | No | C4_PACK_FEEBASE | text | fishing-related services: packing and shipping: other basis indicator |
100 | No | No | C4_TRAN | binary | fishing-related services: transport to/from vessel: not offered option |
100 | No | No | C4_TRAN_INC | binary | fishing-related services: transport to/from vessel: included in trip package option |
100 | No | No | C4_TRAN_FEE | binary | fishing-related services: transport to/from vessel: added fee option |
100 | No | No | C4_TRAN_AMT | numeric | fishing-related services: transport to/from vessel: added fee amount |
100 | No | No | C4_TRAN_FEEBASE | text | fishing-related services: transport to/from vessel: other basis indicator |
100 | No | No | C4_SLODGE | binary | fishing-related services: on-shore lodging: not offered option |
100 | No | No | C4_SLODGE_INC | binary | fishing-related services: on-shore lodging: included in trip package option |
100 | No | No | C4_SLODGE_FEE | binary | fishing-related services: on-shore lodging: added fee option |
100 | No | No | C4_SLODGE_AMT | numeric | fishing-related services: on-shore lodging: added fee amount |
100 | No | No | C4_SLODGE_FEEBASE | text | fishing-related services: on-shore lodging: other basis indicator |
100 | No | No | C4_VLODGE | binary | fishing-related services: on-vessel lodging: not offered option |
100 | No | No | C4_VLODGE_INC | binary | fishing-related services: on-vessel lodging: included in trip package option |
100 | No | No | C4_VLODGE_FEE | binary | fishing-related services: on-vessel lodging: added fee option |
100 | No | No | C4_VLODGE_AMT | numeric | fishing-related services: on-vessel lodging: added fee amount |
100 | No | No | C4_VLODGE_FEEBASE | text | fishing-related services: on-vessel lodging: other basis indicator |
100 | No | No | C4_MEAL | binary | fishing-related services: cooked meals: not offered option |
100 | No | No | C4_MEAL_INC | binary | fishing-related services: cooked meals: included in trip package option |
100 | No | No | C4_MEAL_FEE | binary | fishing-related services: cooked meals: added fee option |
100 | No | No | C4_MEAL_AMT | numeric | fishing-related services: cooked meals: added fee amount |
100 | No | No | C4_MEAL_FEEBASE | text | fishing-related services: cooked meals: other basis indicator |
100 | No | No | C4_BEV | binary | fishing-related services: beverages/snacks: not offered option |
100 | No | No | C4_BEV_INC | binary | fishing-related services: beverages/snacks: included in trip package option |
100 | No | No | C4_BEV_FEE | binary | fishing-related services: beverages/snacks: added fee option |
100 | No | No | C4_BEV_AMT | numeric | fishing-related services: beverages/snacks: added fee amount |
100 | No | No | C4_BEV_FEEBASE | text | fishing-related services: beverages/snacks: other basis indicator |
100 | No | No | C4_BAIT | binary | fishing-related services: bait: not offered option |
100 | No | No | C4_BAIT_INC | binary | fishing-related services: bait: included in trip package option |
100 | No | No | C4_BAIT_FEE | binary | fishing-related services: bait: added fee option |
100 | No | No | C4_BAIT_AMT | numeric | fishing-related services: bait: added fee amount |
100 | No | No | C4_BAIT_FEEBASE | text | fishing-related services: bait: other basis indicator |
100 | No | No | C4_ICE | binary | fishing-related services: ice: not offered option |
100 | No | No | C4_ICE_INC | binary | fishing-related services: ice: included in trip package option |
100 | No | No | C4_ICE_FEE | binary | fishing-related services: ice: added fee option |
100 | No | No | C4_ICE_AMT | numeric | fishing-related services: ice: added fee amount |
100 | No | No | C4_ICE_FEEBASE | binary | fishing-related services: ice: other basis indicator |
100 | No | No | C4_FGEAR | binary | fishing-related services: fishing gear: not offered option |
100 | No | No | C4_FGEAR_INC | binary | fishing-related services: fishing gear: included in trip package option |
100 | No | No | C4_FGEAR_FEE | binary | fishing-related services: fishing gear: added fee option |
100 | No | No | C4_FGEAR_AMT | numeric | fishing-related services: fishing gear: added fee amount |
100 | No | No | C4_FGEAR_FEEBASE | binary | fishing-related services: fishing gear: other basis indicator |
100 | No | No | C4_OGEAR | binary | fishing-related services: other gear: not offered option |
100 | No | No | C4_OGEAR_INC | binary | fishing-related services: other gear: included in trip package option |
100 | No | No | C4_OGEAR_FEE | binary | fishing-related services: other gear: added fee option |
100 | No | No | C4_OGEAR_AMT | numeric | fishing-related services: other gear: added fee amount |
100 | No | No | C4_OGEAR_FEEBASE | binary | fishing-related services: other gear: other basis indicator |
100 | No | No | C4_SOUV | binary | fishing-related services: souvenirs: not offered option |
100 | No | No | C4_SOUV_INC | binary | fishing-related services: souvenirs: included in trip package option |
100 | No | No | C4_SOUV_FEE | binary | fishing-related services: souvenirs: added fee option |
100 | No | No | C4_SOUV_AMT | numeric | fishing-related services: souvenirs: added fee amount |
100 | No | No | C4_SOUV_FEEBASE | numeric | fishing-related services: souvenirs: other basis indicator |
100 | No | No | C4_OTH | binary | fishing-related services: other: not offered option |
100 | No | No | C4_OTH_INC | binary | fishing-related services: other: included in trip package option |
100 | No | No | C4_OTH_FEE | binary | fishing-related services: other: added fee option |
100 | No | No | C4_OTH_AMT | numeric | fishing-related services: other: added fee amount |
100 | No | No | C4_OTH_FEEBASE | numeric | fishing-related services: other: other basis indicator |
100 | No | No | C4_OTH_DESC | open ended text | fishing-related services: other: description |
100 | No | No | C5_LODGE | binary | fishing-related services: paid lodging offered option |
100 | No | No | C6_TRIPDIR_SEATS | numeric | revenue: charter trips, direct client payment: seats sold |
100 | No | No | C6_TRIPDIR_TRIPS | numeric | revenue: charter trips, direct client payment: total trips |
100 | No | No | C6_TRIPDIR_REV | numeric | revenue: charter trips, direct client payment: revenue |
100 | No | No | C6_TRIPINDIR_SEATS | numeric | revenue: charter trips, agent payment: seats sold |
100 | No | No | C6_TRIPINDIR_TRIPS | numeric | revenue: charter trips, agent payment: total trips |
100 | No | No | C6_TRIPINDIR_REV | numeric | revenue: charter trips, agent payment: revenue |
100 | No | No | C6_NFTRIP_CLIENTS | numeric | revenue: non-fishing charter trips: seats sold |
100 | No | No | C6_NFTRIP_TRIPS | numeric | revenue: non-fishing charter trips: total trips |
100 | No | No | C6_NFTRIP_REV | numeric | revenue: non-fishing charter trips: revenue |
100 | No | No | C6_REFER | numeric | revenue: referrals: total referrals |
100 | No | No | C6_REFER_REV | numeric | revenue: referrals: revenue |
100 | No | No | C6_PERMSALE | numeric | revenue: CHP sales: endorsements sold |
100 | No | No | C6_PERMSALE_REV | numeric | revenue: CHP sales: revenue |
100 | No | No | C6_PERMLEASE | numeric | revenue: CHP leases: endorsements leased |
100 | No | No | C6_PERMLEASE_REV | numeric | revenue: CHP leases: revenue |
100 | No | No | D1_FUELVES | numeric | costs: vessel fuel |
100 | No | No | D1_FISHPROC | numeric | costs: fish handling, processing, packaging, shipping |
100 | No | No | D1_FEES | numeric | costs: broker or agent referral/commission fees |
100 | No | No | D1_VESCLEAN | numeric | costs: vessel cleaning |
100 | No | No | D1_SUPPLIES | numeric | costs: supplies |
100 | No | No | D1_VESOTHER | numeric | costs: other vessel or trip operating expenses |
100 | No | No | D1_PAYROLL | numeric | costs: non-wage payroll costs |
100 | No | No | D1_UTIL | numeric | costs: utilities |
100 | No | No | D1_RM | numeric | costs: repair and maintenance |
100 | No | No | D1_INS | numeric | costs: insurance |
100 | No | No | D1_TRAVEL | numeric | costs: travel, meals, entertainment |
100 | No | No | D1_OFFICE | numeric | costs: office and general supplies |
100 | No | No | D1_SERVICES | numeric | costs: legal and professional services |
100 | No | No | D1_FINAN | numeric | costs: financial services |
100 | No | No | D1_TAX | numeric | costs: taxes and licensing fees |
100 | No | No | D1_FUELVEH | numeric | costs: vehicle fuel costs |
100 | No | No | D1_GENERAL | numeric | costs: other general overhead expenses |
100 | No | No | D2_VESCASH | numeric | capital expenses: vessels and related equipment: cash payment |
100 | No | No | D2_VESINV | numeric | capital expenses: vessels and related equipment: new investment |
100 | No | No | D2_VEHCASH | numeric | capital expenses: vehicles: cash payment |
100 | No | No | D2_VEHINV | numeric | capital expenses: vehicles: new investment |
100 | No | No | D2_GEARCASH | numeric | capital expenses: fishing gear, tackle, safety equipment: cash payment |
100 | No | No | D2_GEARINV | numeric | capital expenses: fishing gear, tackle, safety equipment: new investment |
100 | No | No | D2_OTHCASH | numeric | capital expenses: other machinery and equipment: cash payment |
100 | No | No | D2_OTHINV | numeric | capital expenses: other machinery and equipment: new investment |
100 | No | No | D2_MOORCASH | numeric | capital expenses: moorage/slip, boatyard and storage space: cash payment |
100 | No | No | D2_MOORINV | numeric | capital expenses: moorage/slip, boatyard and storage space: new investment |
100 | No | No | D2_SHORECASH | numeric | capital expenses: office space, lodging, shore-side facilities: cash payment |
100 | No | No | D2_SHOREINV | numeric | capital expenses: office space, lodging, shore-side facilities: new investment |
100 | No | No | D2_PERMITCASH | numeric | capital expenses: transferable fishing permits and licenses: cash payment |
100 | No | No | D2_PERMITINV | numeric | capital expenses: transferable fishing permits and licenses: new investment |
100 | No | No | D2_OBUSCASH | numeric | capital expenses: other business-related property and assets: cash payment |
100 | No | No | D2_OBUSINV | numeric | capital expenses: other business-related property and assets: new investment |
100 | No | No | E1_RETURN | numeric | clients: percentage of clients that were return customers or referrals from previous customers |
100 | No | No | E2_ADVBOOK | numeric | clients: percentage of clients booking 1 month of more in advance |
100 | No | No | E3_SHORTBOOK | numeric | clients: percentage of clients booking less than 48 hours in advance |
100 | No | No | E4_INDBOOK | numeric | clients: percentage of clients booked independent |
100 | No | No | E4_CRUISEBOOK | numeric | clients: percentage of clients booked through cruise ship |
100 | No | No | E4_CHARTERBOOK | numeric | clients: percentage of clients booked through charter booking service |
100 | No | No | E4_AGENTBOOK | numeric | clients: percentage of clients booked through general travel agent |
100 | No | No | F1_CCORP | Y/N | business and household: C corporation option |
100 | No | No | F2_STRUCTURE | numeric | business and household: business structure type |
100 | No | No | F2_OTHERDESC | open ended text | business and household: other business structure description |
100 | No | No | F3_SHARE | numeric | business and household: percentage share of business by household |
100 | No | No | F4_GUIDE | numeric | business and household: household members working as guides |
100 | No | No | F4_CREW | numeric | business and household: household members working as other crew |
100 | No | No | F4_SHORE | numeric | business and household: household members working on shore |
100 | No | No | F5_INCOME | numeric | business and household: percentage of income from business |
100 | No | No | F6_CHARTER | binary | business and household: work related to charter business option |
100 | No | No | F6_AKFISH | binary | business and household: worked in AK, fishing not related to charter business |
100 | No | No | F6_AKNOFISH | binary | business and household: worked in AK, non-fishing job |
100 | No | No | F6_AKRES | binary | business and household: lived in AK, did not work |
100 | No | No | F6_NONAKFISH | binary | business and household: worked outside AK, fishing not related to charter business |
100 | No | No | F6_NONAKNOFISH | binary | business and household: worked outside AK, non-fishing job |
100 | No | No | F6_NONAKRES | binary | business and household: lived outside AK, did not work |
100 | No | No | COMMENTS_A | binary | survey comments: section A1/A2 flag |
100 | No | No | COMMENTS_B123 | binary | survey comments: section B1/B2/B3 flag |
100 | No | No | COMMENTS_B45 | binary | survey comments: section B4/B5 flag |
100 | No | No | COMMENTS_C1 | binary | survey comments: section C1 flag |
100 | No | No | COMMENTS_C2 | binary | survey comments: section C2 flag |
100 | No | No | COMMENTS_C3 | binary | survey comments: section C3 flag |
100 | No | No | COMMENTS_C45 | binary | survey comments: section C4/C5 flag |
100 | No | No | COMMENTS_C6 | binary | survey comments: section C6 flag |
100 | No | No | COMMENTS_D1 | binary | survey comments: section D1 flag |
100 | No | No | COMMENTS_D2 | binary | survey comments: section D2 flag |
100 | No | No | COMMENTS_E | binary | survey comments: section E flag |
100 | No | No | COMMENTS_F | binary | survey comments: section F flag |
100 | No | No | COMMENTS_SURVEY | binary | survey comments: general survey flag |
Attribute Details
Attribute Name | ID |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
survey identifier assigned by PSMFC |
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 | BOOKLET_ID |
---|---|
Seq. Order | |
Data Storage Type | text |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
survey booklet identifier assigned by PSMFC |
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 | YEAR |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
year of survey |
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 | A1_BNAME |
---|---|
Seq. Order | |
Data Storage Type | open ended text |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
respondent identification: sport fish business name |
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 | A1_LICNUM |
---|---|
Seq. Order | |
Data Storage Type | open ended text |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
respondent identification: ADF&G sport fish business owner license number |
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 | A2_COUNTOWN |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
respondent identification: vessels owned |
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 | A2_COUNTLEASE |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
respondent identification: vessels leased |
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 | A2_COUNTNONRESP |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
respondent identification: vessels, own/lease not specified |
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 | B1_FTES |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
# of employees: guides/full-time/early shoulder |
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 | B1_FTMS |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
# of employees: guides/full-time/main season |
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 | B1_FTLS |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
# of employees: guides/full-time/late shoulder |
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 | B1_FTOS |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
# of employees: guides/full-time/off season |
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 | B1_PTES |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
# of employees: guides/part-time/early shoulder |
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 | B1_PTMS |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
# of employees: guides/part-time/main season |
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 | B1_PTLS |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
# of employees: guides/part-time/late shoulder |
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 | B1_PTOS |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
# of employees: guides/part-time/off season |
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 | B2_FTES |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
# of employees: other crew/full-time/early shoulder |
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 | B2_FTMS |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
# of employees: other crew/full-time/main season |
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 | B2_FTLS |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
# of employees: other crew/full-time/late shoulder |
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 | B2_FTOS |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
# of employees: other crew/full-time/off season |
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 | B2_PTES |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
# of employees: other crew/part-time/early shoulder |
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 | B2_PTMS |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
# of employees: other crew/part-time/main season |
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 | B2_PTLS |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
# of employees: other crew/part-time/late shoulder |
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 | B2_PTOS |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
# of employees: other crew/part-time/off season |
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_FTES |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
# of employees: shore/full-time/early shoulder |
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_FTMS |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
# of employees: shore/full-time/main season |
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_FTLS |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
# of employees: shore/full-time/late shoulder |
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_FTOS |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
# of employees: shore/full-time/off season |
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_PTES |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
# of employees: shore/part-time/early shoulder |
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_PTMS |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
# of employees: shore/part-time/main season |
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_PTLS |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
# of employees: shore/part-time/late shoulder |
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_PTOS |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
# of employees: shore/part-time/off season |
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 | B4_GUIDE |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
employee pay: guides |
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 | B4_CREW |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
employee pay: other crew |
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 | B4_SHORE |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
employee pay: shore employees |
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_GUIDEWAGE |
---|---|
Seq. Order | |
Data Storage Type | binary |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
employee pay, wage option: guide |
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_GUIDESAL |
---|---|
Seq. Order | |
Data Storage Type | binary |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
employee pay, salary option: guide |
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_GUIDESHARE |
---|---|
Seq. Order | |
Data Storage Type | binary |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
employee pay, share option: guide |
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_GUIDEOTH |
---|---|
Seq. Order | |
Data Storage Type | binary |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
employee pay, other option: guide |
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_GUIDEOTHDESC |
---|---|
Seq. Order | |
Data Storage Type | open ended text |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
employee pay, other option description: guide |
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_CREWWAGE |
---|---|
Seq. Order | |
Data Storage Type | binary |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
employee pay, wage option: other crew |
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_CREWSAL |
---|---|
Seq. Order | |
Data Storage Type | binary |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
employee pay, salary option: other crew |
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_CREWSHARE |
---|---|
Seq. Order | |
Data Storage Type | binary |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
employee pay, share option: other crew |
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_CREWOTH |
---|---|
Seq. Order | |
Data Storage Type | binary |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
employee pay, other option: other crew |
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_CREWOTH_DESC |
---|---|
Seq. Order | |
Data Storage Type | open ended text |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
employee pay, other option description: other crew |
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_SHOREWAGE |
---|---|
Seq. Order | |
Data Storage Type | binary |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
employee pay, wage option: shore employee |
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_SHORESAL |
---|---|
Seq. Order | |
Data Storage Type | binary |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
employee pay, salary option: shore employee |
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_SHORESHARE |
---|---|
Seq. Order | |
Data Storage Type | binary |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
employee pay, share option: shore employee |
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_SHOREOTH |
---|---|
Seq. Order | |
Data Storage Type | binary |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
employee pay, other option: shore employee |
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_SHOREOTH_DESC |
---|---|
Seq. Order | |
Data Storage Type | open ended text |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
employee pay, other option description: shore employee |
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 | C1_FISHONLY |
---|---|
Seq. Order | |
Data Storage Type | binary |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
trip offerings, fishing only option |
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 | C1_FISHHUNT |
---|---|
Seq. Order | |
Data Storage Type | binary |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
trip offerings, combination fishing and hunting option |
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 | C1_FISHTOUR |
---|---|
Seq. Order | |
Data Storage Type | binary |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
trip offerings, combination fishing and tour option |
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 | C1_TOURONLY |
---|---|
Seq. Order | |
Data Storage Type | binary |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
trip offerings, tour only option |
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 | C1_OUTFIT |
---|---|
Seq. Order | |
Data Storage Type | binary |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
trip offerings, outfitting option |
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 | C1_GAMETRANS |
---|---|
Seq. Order | |
Data Storage Type | binary |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
trip offerings, game transport option |
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 | C1_GENTRANS |
---|---|
Seq. Order | |
Data Storage Type | binary |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
trip offerings, general transportation option |
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 | C1_EVENT |
---|---|
Seq. Order | |
Data Storage Type | binary |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
trip offerings, event hosting option |
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 | C1_RESEARCH |
---|---|
Seq. Order | |
Data Storage Type | binary |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
trip offerings, research or oil spill services option |
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 | C1_OTHER |
---|---|
Seq. Order | |
Data Storage Type | binary |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
trip offerings, other services option |
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 | C1_OTHERDESC |
---|---|
Seq. Order | |
Data Storage Type | open ended text |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
trip offerings, other services description |
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 | C2_2HALF |
---|---|
Seq. Order | |
Data Storage Type | binary |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
trip offerings: 2-species/half-day: not offered option |
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 | C2_2HALF_I |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
trip offerings: 2-species/half-day: individual price |
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 | C2_2HALF_B |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
trip offerings: 2-species/half-day: boat price |
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 | C2_23Q |
---|---|
Seq. Order | |
Data Storage Type | binary |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
trip offerings: 2-species/three-quarter day: not offered option |
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 | C2_23Q_I |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
trip offerings: 2-species/three-quarter day: individual price |
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 | C2_23Q_B |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
trip offerings: 2-species/three-quarter day: boat price |
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 | C2_2FULL |
---|---|
Seq. Order | |
Data Storage Type | binary |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
trip offerings: 2-species/full day: not offered option |
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 | C2_2FULL_I |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
trip offerings: 2-species/full day: individual price |
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 | C2_2FULL_B |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
trip offerings: 2-species/full day: boat price |
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 | C2_2NIGHT |
---|---|
Seq. Order | |
Data Storage Type | binary |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
trip offerings: 2-species/overnight: not offered option |
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 | C2_2NIGHT_I |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
trip offerings: 2-species/overnight: individual price |
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 | C2_2NIGHT_B |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
trip offerings: 2-species/overnight: boat price |
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 | C2_2MULTI |
---|---|
Seq. Order | |
Data Storage Type | binary |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
trip offerings: 2-species/multi-day: not offered option |
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 | C2_2MULTI_I |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
trip offerings: 2-species/multi-day: individual price |
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 | C2_2MULTI_B |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
trip offerings: 2-species/multi-day: boat price |
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 | C2_MULTIHALF |
---|---|
Seq. Order | |
Data Storage Type | binary |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
trip offerings: multi-species/half-day: not offered option |
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 | C2_MULTIHALF_I |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
trip offerings: multi-species/half-day: individual price |
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 | C2_MULTIHALF_B |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
trip offerings: multi-species/half-day: boat price |
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 | C2_MULTI3Q |
---|---|
Seq. Order | |
Data Storage Type | binary |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
trip offerings: multi-species/three-quarter day: not offered option |
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 | C2_MULTI3Q_I |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
trip offerings: multi-species/three-quarter day: individual price |
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 | C2_MULTI3Q_B |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
trip offerings: multi-species/three-quarter day: boat price |
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 | C2_MULTIFULL |
---|---|
Seq. Order | |
Data Storage Type | binary |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
trip offerings: multi-species/full day: not offered option |
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 | C2_MULTIFULL_I |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
trip offerings: multi-species/full day: individual price |
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 | C2_MULTIFULL_B |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
trip offerings: multi-species/full day: boat price |
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 | C2_MULTINIGHT |
---|---|
Seq. Order | |
Data Storage Type | binary |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
trip offerings: multi-species/overnight: not offered option |
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 | C2_MULTINIGHT_I |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
trip offerings: multi-species/overnight: individual price |
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 | C2_MULTINIGHT_B |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
trip offerings: multi-species/overnight: boat price |
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 | C2_MULTIMULTI |
---|---|
Seq. Order | |
Data Storage Type | binary |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
trip offerings: multi-species/multi-day: not offered option |
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 | C2_MULTIMULTI_I |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
trip offerings: multi-species/multi-day: individual price |
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 | C2_MULTIMULTI_B |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
trip offerings: multi-species/multi-day: boat price |
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_HALHALF |
---|---|
Seq. Order | |
Data Storage Type | binary |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
trip offerings: halibut/half-day: not offered option |
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_HALHALF_I |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
trip offerings: halibut/half-day: individual price |
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_HALHALF_B |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
trip offerings: halibut/half-day: boat price |
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_HAL3Q |
---|---|
Seq. Order | |
Data Storage Type | binary |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
trip offerings: halibut/three-quarter day: not offered option |
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_HAL3Q_I |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
trip offerings: halibut/three-quarter day: individual price |
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_HAL3Q_B |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
trip offerings: halibut/three-quarter day: boat price |
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_HALFULL |
---|---|
Seq. Order | |
Data Storage Type | binary |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
trip offerings: halibut/full day: not offered option |
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_HALFULL_I |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
trip offerings: halibut/full day: individual price |
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_HALFULL_B |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
trip offerings: halibut/full day: boat price |
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_HALNIGHT |
---|---|
Seq. Order | |
Data Storage Type | binary |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
trip offerings: halibut/overnight: not offered option |
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_HALNIGHT_I |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
trip offerings: halibut/overnight: individual price |
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_HALNIGHT_B |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
trip offerings: halibut/overnight: boat price |
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_HALMULTI |
---|---|
Seq. Order | |
Data Storage Type | binary |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
trip offerings: halibut/multi-day: not offered option |
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_HALMULTI_I |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
trip offerings: halibut/multi-day: individual price |
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_HALMULTI_B |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
trip offerings: halibut/multi-day: boat price |
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_SALHALF |
---|---|
Seq. Order | |
Data Storage Type | binary |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
trip offerings: salmon/half-day: not offered option |
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_SALHALF_I |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
trip offerings: salmon/half-day: individual price |
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_SALHALF_B |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
trip offerings: salmon/half-day: boat price |
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_SAL3Q |
---|---|
Seq. Order | |
Data Storage Type | binary |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
trip offerings: salmon/three-quarter day: not offered option |
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_SAL3Q_I |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
trip offerings: salmon/three-quarter day: individual price |
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_SAL3Q_B |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
trip offerings: salmon/three-quarter day: boat price |
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_SALFULL |
---|---|
Seq. Order | |
Data Storage Type | binary |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
trip offerings: salmon/full day: not offered option |
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_SALFULL_I |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
trip offerings: salmon/full day: individual price |
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_SALFULL_B |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
trip offerings: salmon/full day: boat price |
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_SALNIGHT |
---|---|
Seq. Order | |
Data Storage Type | binary |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
trip offerings: salmon/overnight: not offered option |
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_SALNIGHT_I |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
trip offerings: salmon/overnight: individual price |
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_SALNIGHT_B |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
trip offerings: salmon/overnight: boat price |
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_SALMULTI |
---|---|
Seq. Order | |
Data Storage Type | binary |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
trip offerings: salmon/multi-day: not offered option |
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_SALMULTI_I |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
trip offerings: salmon/multi-day: individual price |
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_SALMULTI_B |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
trip offerings: salmon/multi-day: boat price |
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_OTHHALF |
---|---|
Seq. Order | |
Data Storage Type | binary |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
trip offerings: other species/half-day: not offered option |
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_OTHHALF_I |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
trip offerings: other species/half-day: individual price |
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_OTHHALF_B |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
trip offerings: other species/half-day: boat price |
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_OTH3Q |
---|---|
Seq. Order | |
Data Storage Type | binary |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
trip offerings: other species/three-quarter day: not offered option |
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_OTH3Q_I |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
trip offerings: other species/three-quarter day: individual price |
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_OTH3Q_B |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
trip offerings: other species/three-quarter day: boat price |
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_OTHFULL |
---|---|
Seq. Order | |
Data Storage Type | binary |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
trip offerings: other species/full day: not offered option |
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_OTHFULL_I |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
trip offerings: other species/full day: individual price |
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_OTHFULL_B |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
trip offerings: other species/full day: boat price |
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_OTHNIGHT |
---|---|
Seq. Order | |
Data Storage Type | binary |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
trip offerings: other species/overnight: not offered option |
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_OTHNIGHT_I |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
trip offerings: other species/overnight: individual price |
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_OTHNIGHT_B |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
trip offerings: other species/overnight: boat price |
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_OTHMULTI |
---|---|
Seq. Order | |
Data Storage Type | binary |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
trip offerings: other species/multi-day: not offered option |
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_OTHMULTI_I |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
trip offerings: other species/multi-day: individual price |
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_OTHMULTI_B |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
trip offerings: other species/multi-day: boat price |
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_LD |
---|---|
Seq. Order | |
Data Storage Type | binary |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
fishing-related services: long-distance fishing: not offered option |
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_LD_INC |
---|---|
Seq. Order | |
Data Storage Type | binary |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
fishing-related services: long-distance fishing: included in trip package option |
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_LD_FEE |
---|---|
Seq. Order | |
Data Storage Type | binary |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
fishing-related services: long-distance fishing: added fee option |
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_LD_AMT |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
fishing-related services: long-distance fishing: added fee amount |
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_LD_FEEBASE |
---|---|
Seq. Order | |
Data Storage Type | text |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
fishing-related services: long-distance fishing: other basis indicator |
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_CLEAN1 |
---|---|
Seq. Order | |
Data Storage Type | binary |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
fishing-related services: fish cleaning (h/g): not offered option |
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_CLEAN1_INC |
---|---|
Seq. Order | |
Data Storage Type | binary |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
fishing-related services: fish cleaning (h/g): included in trip package option |
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_CLEAN1_FEE |
---|---|
Seq. Order | |
Data Storage Type | binary |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
fishing-related services: fish cleaning (h/g): added fee option |
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_CLEAN1_AMT |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
fishing-related services: fish cleaning (h/g): added fee amount |
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_CLEAN1_FEEBASE |
---|---|
Seq. Order | |
Data Storage Type | text |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
fishing-related services: fish cleaning (h/g): other basis indicator |
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_CLEAN2 |
---|---|
Seq. Order | |
Data Storage Type | binary |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
fishing-related services: fish cleaning (skinning, etc.): not offered option |
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_CLEAN2_INC |
---|---|
Seq. Order | |
Data Storage Type | binary |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
fishing-related services: fish cleaning (skinning, etc.): included in trip package option |
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_CLEAN2_FEE |
---|---|
Seq. Order | |
Data Storage Type | binary |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
fishing-related services: fish cleaning (skinning, etc.): added fee option |
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_CLEAN2_AMT |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
fishing-related services: fish cleaning (skinning, etc.): added fee amount |
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_CLEAN2_FEEBASE |
---|---|
Seq. Order | |
Data Storage Type | text |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
fishing-related services: fish cleaning (skinning, etc.): other basis indicator |
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_PACK |
---|---|
Seq. Order | |
Data Storage Type | binary |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
fishing-related services: packing and shipping: not offered option |
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_PACK_INC |
---|---|
Seq. Order | |
Data Storage Type | binary |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
fishing-related services: packing and shipping: included in trip package option |
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_PACK_FEE |
---|---|
Seq. Order | |
Data Storage Type | binary |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
fishing-related services: packing and shipping: added fee option |
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_PACK_AMT |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
fishing-related services: packing and shipping: added fee amount |
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_PACK_FEEBASE |
---|---|
Seq. Order | |
Data Storage Type | text |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
fishing-related services: packing and shipping: other basis indicator |
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_TRAN |
---|---|
Seq. Order | |
Data Storage Type | binary |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
fishing-related services: transport to/from vessel: not offered option |
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_TRAN_INC |
---|---|
Seq. Order | |
Data Storage Type | binary |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
fishing-related services: transport to/from vessel: included in trip package option |
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_TRAN_FEE |
---|---|
Seq. Order | |
Data Storage Type | binary |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
fishing-related services: transport to/from vessel: added fee option |
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_TRAN_AMT |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
fishing-related services: transport to/from vessel: added fee amount |
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_TRAN_FEEBASE |
---|---|
Seq. Order | |
Data Storage Type | text |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
fishing-related services: transport to/from vessel: other basis indicator |
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_SLODGE |
---|---|
Seq. Order | |
Data Storage Type | binary |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
fishing-related services: on-shore lodging: not offered option |
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_SLODGE_INC |
---|---|
Seq. Order | |
Data Storage Type | binary |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
fishing-related services: on-shore lodging: included in trip package option |
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_SLODGE_FEE |
---|---|
Seq. Order | |
Data Storage Type | binary |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
fishing-related services: on-shore lodging: added fee option |
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_SLODGE_AMT |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
fishing-related services: on-shore lodging: added fee amount |
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_SLODGE_FEEBASE |
---|---|
Seq. Order | |
Data Storage Type | text |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
fishing-related services: on-shore lodging: other basis indicator |
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_VLODGE |
---|---|
Seq. Order | |
Data Storage Type | binary |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
fishing-related services: on-vessel lodging: not offered option |
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_VLODGE_INC |
---|---|
Seq. Order | |
Data Storage Type | binary |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
fishing-related services: on-vessel lodging: included in trip package option |
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_VLODGE_FEE |
---|---|
Seq. Order | |
Data Storage Type | binary |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
fishing-related services: on-vessel lodging: added fee option |
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_VLODGE_AMT |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
fishing-related services: on-vessel lodging: added fee amount |
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_VLODGE_FEEBASE |
---|---|
Seq. Order | |
Data Storage Type | text |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
fishing-related services: on-vessel lodging: other basis indicator |
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_MEAL |
---|---|
Seq. Order | |
Data Storage Type | binary |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
fishing-related services: cooked meals: not offered option |
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_MEAL_INC |
---|---|
Seq. Order | |
Data Storage Type | binary |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
fishing-related services: cooked meals: included in trip package option |
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_MEAL_FEE |
---|---|
Seq. Order | |
Data Storage Type | binary |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
fishing-related services: cooked meals: added fee option |
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_MEAL_AMT |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
fishing-related services: cooked meals: added fee amount |
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_MEAL_FEEBASE |
---|---|
Seq. Order | |
Data Storage Type | text |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
fishing-related services: cooked meals: other basis indicator |
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_BEV |
---|---|
Seq. Order | |
Data Storage Type | binary |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
fishing-related services: beverages/snacks: not offered option |
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_BEV_INC |
---|---|
Seq. Order | |
Data Storage Type | binary |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
fishing-related services: beverages/snacks: included in trip package option |
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_BEV_FEE |
---|---|
Seq. Order | |
Data Storage Type | binary |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
fishing-related services: beverages/snacks: added fee option |
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_BEV_AMT |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
fishing-related services: beverages/snacks: added fee amount |
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_BEV_FEEBASE |
---|---|
Seq. Order | |
Data Storage Type | text |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
fishing-related services: beverages/snacks: other basis indicator |
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_BAIT |
---|---|
Seq. Order | |
Data Storage Type | binary |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
fishing-related services: bait: not offered option |
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_BAIT_INC |
---|---|
Seq. Order | |
Data Storage Type | binary |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
fishing-related services: bait: included in trip package option |
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_BAIT_FEE |
---|---|
Seq. Order | |
Data Storage Type | binary |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
fishing-related services: bait: added fee option |
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_BAIT_AMT |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
fishing-related services: bait: added fee amount |
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_BAIT_FEEBASE |
---|---|
Seq. Order | |
Data Storage Type | text |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
fishing-related services: bait: other basis indicator |
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_ICE |
---|---|
Seq. Order | |
Data Storage Type | binary |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
fishing-related services: ice: not offered option |
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_ICE_INC |
---|---|
Seq. Order | |
Data Storage Type | binary |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
fishing-related services: ice: included in trip package option |
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_ICE_FEE |
---|---|
Seq. Order | |
Data Storage Type | binary |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
fishing-related services: ice: added fee option |
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_ICE_AMT |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
fishing-related services: ice: added fee amount |
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_ICE_FEEBASE |
---|---|
Seq. Order | |
Data Storage Type | binary |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
fishing-related services: ice: other basis indicator |
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_FGEAR |
---|---|
Seq. Order | |
Data Storage Type | binary |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
fishing-related services: fishing gear: not offered option |
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_FGEAR_INC |
---|---|
Seq. Order | |
Data Storage Type | binary |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
fishing-related services: fishing gear: included in trip package option |
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_FGEAR_FEE |
---|---|
Seq. Order | |
Data Storage Type | binary |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
fishing-related services: fishing gear: added fee option |
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_FGEAR_AMT |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
fishing-related services: fishing gear: added fee amount |
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_FGEAR_FEEBASE |
---|---|
Seq. Order | |
Data Storage Type | binary |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
fishing-related services: fishing gear: other basis indicator |
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_OGEAR |
---|---|
Seq. Order | |
Data Storage Type | binary |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
fishing-related services: other gear: not offered option |
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_OGEAR_INC |
---|---|
Seq. Order | |
Data Storage Type | binary |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
fishing-related services: other gear: included in trip package option |
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_OGEAR_FEE |
---|---|
Seq. Order | |
Data Storage Type | binary |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
fishing-related services: other gear: added fee option |
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_OGEAR_AMT |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
fishing-related services: other gear: added fee amount |
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_OGEAR_FEEBASE |
---|---|
Seq. Order | |
Data Storage Type | binary |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
fishing-related services: other gear: other basis indicator |
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_SOUV |
---|---|
Seq. Order | |
Data Storage Type | binary |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
fishing-related services: souvenirs: not offered option |
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_SOUV_INC |
---|---|
Seq. Order | |
Data Storage Type | binary |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
fishing-related services: souvenirs: included in trip package option |
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_SOUV_FEE |
---|---|
Seq. Order | |
Data Storage Type | binary |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
fishing-related services: souvenirs: added fee option |
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_SOUV_AMT |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
fishing-related services: souvenirs: added fee amount |
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_SOUV_FEEBASE |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
fishing-related services: souvenirs: other basis indicator |
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_OTH |
---|---|
Seq. Order | |
Data Storage Type | binary |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
fishing-related services: other: not offered option |
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_OTH_INC |
---|---|
Seq. Order | |
Data Storage Type | binary |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
fishing-related services: other: included in trip package option |
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_OTH_FEE |
---|---|
Seq. Order | |
Data Storage Type | binary |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
fishing-related services: other: added fee option |
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_OTH_AMT |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
fishing-related services: other: added fee amount |
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_OTH_FEEBASE |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
fishing-related services: other: other basis indicator |
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_OTH_DESC |
---|---|
Seq. Order | |
Data Storage Type | open ended text |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
fishing-related services: other: description |
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_LODGE |
---|---|
Seq. Order | |
Data Storage Type | binary |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
fishing-related services: paid lodging offered option |
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_TRIPDIR_SEATS |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
revenue: charter trips, direct client payment: seats sold |
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_TRIPDIR_TRIPS |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
revenue: charter trips, direct client payment: total trips |
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_TRIPDIR_REV |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
revenue: charter trips, direct client payment: revenue |
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_TRIPINDIR_SEATS |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
revenue: charter trips, agent payment: seats sold |
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_TRIPINDIR_TRIPS |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
revenue: charter trips, agent payment: total trips |
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_TRIPINDIR_REV |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
revenue: charter trips, agent payment: revenue |
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_NFTRIP_CLIENTS |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
revenue: non-fishing charter trips: seats sold |
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_NFTRIP_TRIPS |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
revenue: non-fishing charter trips: total trips |
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_NFTRIP_REV |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
revenue: non-fishing charter trips: revenue |
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_REFER |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
revenue: referrals: total referrals |
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_REFER_REV |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
revenue: referrals: revenue |
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_PERMSALE |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
revenue: CHP sales: endorsements sold |
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_PERMSALE_REV |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
revenue: CHP sales: revenue |
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_PERMLEASE |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
revenue: CHP leases: endorsements leased |
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_PERMLEASE_REV |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
revenue: CHP leases: revenue |
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 | D1_FUELVES |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
costs: vessel fuel |
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 | D1_FISHPROC |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
costs: fish handling, processing, packaging, shipping |
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 | D1_FEES |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
costs: broker or agent referral/commission fees |
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 | D1_VESCLEAN |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
costs: vessel cleaning |
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 | D1_SUPPLIES |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
costs: supplies |
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 | D1_VESOTHER |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
costs: other vessel or trip operating expenses |
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 | D1_PAYROLL |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
costs: non-wage payroll costs |
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 | D1_UTIL |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
costs: utilities |
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 | D1_RM |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
costs: repair and maintenance |
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 | D1_INS |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
costs: insurance |
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 | D1_TRAVEL |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
costs: travel, meals, entertainment |
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 | D1_OFFICE |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
costs: office and general supplies |
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 | D1_SERVICES |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
costs: legal and professional services |
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 | D1_FINAN |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
costs: financial services |
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 | D1_TAX |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
costs: taxes and licensing fees |
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 | D1_FUELVEH |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
costs: vehicle fuel costs |
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 | D1_GENERAL |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
costs: other general overhead expenses |
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_VESCASH |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
capital expenses: vessels and related equipment: cash payment |
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_VESINV |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
capital expenses: vessels and related equipment: new investment |
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_VEHCASH |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
capital expenses: vehicles: cash payment |
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_VEHINV |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
capital expenses: vehicles: new investment |
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_GEARCASH |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
capital expenses: fishing gear, tackle, safety equipment: cash payment |
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_GEARINV |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
capital expenses: fishing gear, tackle, safety equipment: new investment |
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_OTHCASH |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
capital expenses: other machinery and equipment: cash payment |
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_OTHINV |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
capital expenses: other machinery and equipment: new investment |
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_MOORCASH |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
capital expenses: moorage/slip, boatyard and storage space: cash payment |
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_MOORINV |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
capital expenses: moorage/slip, boatyard and storage space: new investment |
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_SHORECASH |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
capital expenses: office space, lodging, shore-side facilities: cash payment |
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_SHOREINV |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
capital expenses: office space, lodging, shore-side facilities: new investment |
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_PERMITCASH |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
capital expenses: transferable fishing permits and licenses: cash payment |
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_PERMITINV |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
capital expenses: transferable fishing permits and licenses: new investment |
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_OBUSCASH |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
capital expenses: other business-related property and assets: cash payment |
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_OBUSINV |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
capital expenses: other business-related property and assets: new investment |
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 | E1_RETURN |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
clients: percentage of clients that were return customers or referrals from previous customers |
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 | E2_ADVBOOK |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
clients: percentage of clients booking 1 month of more in advance |
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 | E3_SHORTBOOK |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
clients: percentage of clients booking less than 48 hours in advance |
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 | E4_INDBOOK |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
clients: percentage of clients booked independent |
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 | E4_CRUISEBOOK |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
clients: percentage of clients booked through cruise ship |
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 | E4_CHARTERBOOK |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
clients: percentage of clients booked through charter booking service |
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 | E4_AGENTBOOK |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
clients: percentage of clients booked through general travel agent |
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 | F1_CCORP |
---|---|
Seq. Order | |
Data Storage Type | Y/N |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
business and household: C corporation option |
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 | F2_STRUCTURE |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
business and household: business structure type |
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 | F2_OTHERDESC |
---|---|
Seq. Order | |
Data Storage Type | open ended text |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
business and household: other business structure description |
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 | F3_SHARE |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
business and household: percentage share of business by household |
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 | F4_GUIDE |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
business and household: household members working as guides |
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 | F4_CREW |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
business and household: household members working as other crew |
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 | F4_SHORE |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
business and household: household members working on shore |
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 | F5_INCOME |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
business and household: percentage of income from business |
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 | F6_CHARTER |
---|---|
Seq. Order | |
Data Storage Type | binary |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
business and household: work related to charter business option |
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 | F6_AKFISH |
---|---|
Seq. Order | |
Data Storage Type | binary |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
business and household: worked in AK, fishing not related to charter business |
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 | F6_AKNOFISH |
---|---|
Seq. Order | |
Data Storage Type | binary |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
business and household: worked in AK, non-fishing job |
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 | F6_AKRES |
---|---|
Seq. Order | |
Data Storage Type | binary |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
business and household: lived in AK, did not work |
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 | F6_NONAKFISH |
---|---|
Seq. Order | |
Data Storage Type | binary |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
business and household: worked outside AK, fishing not related to charter business |
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 | F6_NONAKNOFISH |
---|---|
Seq. Order | |
Data Storage Type | binary |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
business and household: worked outside AK, non-fishing job |
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 | F6_NONAKRES |
---|---|
Seq. Order | |
Data Storage Type | binary |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
business and household: lived outside AK, did not work |
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 | COMMENTS_A |
---|---|
Seq. Order | |
Data Storage Type | binary |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
survey comments: section A1/A2 flag |
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 | COMMENTS_B123 |
---|---|
Seq. Order | |
Data Storage Type | binary |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
survey comments: section B1/B2/B3 flag |
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 | COMMENTS_B45 |
---|---|
Seq. Order | |
Data Storage Type | binary |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
survey comments: section B4/B5 flag |
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 | COMMENTS_C1 |
---|---|
Seq. Order | |
Data Storage Type | binary |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
survey comments: section C1 flag |
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 | COMMENTS_C2 |
---|---|
Seq. Order | |
Data Storage Type | binary |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
survey comments: section C2 flag |
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 | COMMENTS_C3 |
---|---|
Seq. Order | |
Data Storage Type | binary |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
survey comments: section C3 flag |
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 | COMMENTS_C45 |
---|---|
Seq. Order | |
Data Storage Type | binary |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
survey comments: section C4/C5 flag |
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 | COMMENTS_C6 |
---|---|
Seq. Order | |
Data Storage Type | binary |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
survey comments: section C6 flag |
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 | COMMENTS_D1 |
---|---|
Seq. Order | |
Data Storage Type | binary |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
survey comments: section D1 flag |
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 | COMMENTS_D2 |
---|---|
Seq. Order | |
Data Storage Type | binary |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
survey comments: section D2 flag |
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 | COMMENTS_E |
---|---|
Seq. Order | |
Data Storage Type | binary |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
survey comments: section E flag |
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 | COMMENTS_F |
---|---|
Seq. Order | |
Data Storage Type | binary |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
survey comments: section F flag |
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 | COMMENTS_SURVEY |
---|---|
Seq. Order | |
Data Storage Type | binary |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
survey comments: general survey flag |
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 | |
---|---|
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 | 32493 |
---|---|
Metadata Record Created By | Angie Greig |
Metadata Record Created | 2016-04-20 12:20+0000 |
Metadata Record Last Modified By | SysAdmin InPortAdmin |
» Metadata Record Last Modified | 2022-08-09 17:11+0000 |
Metadata Record Published | 2017-02-08 |
Owner Org | AFSC |
Metadata Publication Status | Published Externally |
Do Not Publish? | N |
Metadata Workflow State | Published / External |
Metadata Last Review Date | 2017-02-08 |
Metadata Review Frequency | 1 Year |
Metadata Next Review Date | 2018-02-08 |
Tags |
---|