affiliate_plan.type 1 - Percent revenue 2 - Per Sign Up affiliate_tran.type 1 - Gift certificate sale via directory 2 - Sign up 3 - Billing affiliate_tran.status 0 - Pending 1 - Paid amount has been calculated billing.billing_status -3 - Missing brand merchant info -2 - Missing org CC info -1 - Unable to process 0 - Not processed 1 - Processed billing.billing_hold -3 - Pay by check -1 - Locked 0 - Not on hold 1 - On hold billing_calc.type 1 - GCs 2 - Websites 11 - Directory GCs billing_item_type -1 - Void 0 - Adjustment 1 - GC 2 - AR 3 - Monthly Fee 4 - Taxable Adjustment 5 - Domain name related 6 - Billing Option (e.g. signup or setup fee) 11 - Directory GC billing_option.option_available -1 IGC signup fee 0 option no longer available 1 post-signup option billing_tran.status -3 - Charge back -2 - Voided at processor -1 - Unable to process 0 - Not Processed/Processing 1 - Processed 2 - Applied future credit forward to invoice billing_tran.type 0 - AUTH_CAPTURE 2 - CAPTURE_ONLY client_address.phone_1_type client_address.phone_2_type NULL - undefined 1 - Cell 2 - Home 3 - Work 4 - Other client_address.address_type 0 - main address 1 - org billing address 2 - org locations 3 - GC recipients client_address.phone_1_type, phone_2_type 1 - Cell 2 - Home 3 - Work 4 - Other client.registration_type 0 - By org 1 - On-line 2 - API 3 - Facebook client.email_status 0 - Good email address 1 - Bad formatting of email address client_journal.atom_type 1 - email campaign (email_marketing.email_marketing stored in atom) 2 - unsubscribe via e-mail campaign (email_marketing.email_marketing stored in atom) 3 - review reminder (email_marketing.email_marketing stored in atom) 4 - queue_social (queue_social.queue_social stored in atom) email_design.logo_pos 0 - Do not show logo 1 - Upper right 2 - Lower right 3 - Lower left 4 - Upper left email_design.restricted 0 - No restrictions on design 1 - Restricted; cannot copy design, and cannot change start date in email marketing to before default start date email_marketing.client_type 0 - select all client types, otherwise, select only the client types listed (comma delimited list) email_marketing.type 0 - email campaigns 1 - transactional emails 2 - special use emails (e.g., daily deals) email_marketing.campaign_type 0 - No special type 1 - Joy of Spa campaign email_marketing.marketing_list_opt 0 - Clients must be IN the specified list(s) 1 - Clients must NOT BE IN the specified list(s) email_queue.atom_type 1 - Client Journal entry email_queue_deferred.atom_type 1 - Client Journal entry event_service_option.type 1 - GCs only 2 - Both GCs and appointments 3 - Appointments only event.event_type 1 - Special 2 - Occasion 3 - Announcement 4 - Other 5 - Default "special" 6 - Referral Code 7 - Boomtime Deals 8 - Boomtime Sweepstakes event.process (Deals, event_type = 7) 0 - Deal is ongoing 1 - Deal has tipped, is not processed 2 - Deal has tipped and is fully processed event.process (Sweepstakes, event_type = 8) 0 - Sweepstakes is open 2 - Sweepstakes is closed, and winner was selected event.special_type 1 - Featured services 2 - Percentage discount 3 - Buy one, get one 4 - Instant Offer event.type 1 - GCs only 2 - Both GCs and appointments 3 - Appointments only event_org_client.type 1 - Sweepstakes event_org_client.status 0 - Invited by a friend, hasn't entered yet 1 - Entered sweepstakes 2 - Won sweepstakes gift_amount.transaction_type 0 - Initial purchase 1 - Redeem 2 - Add value 3 - Void 4 - Expire gift.delivery 0 - None 1 - Email 2 - Print gift.value_type 0 - Dollar amount 1 - Service gift.millennium_transaction NULL - No Millennium integration -1 - Failed in Millennium integration 0 - Pending Millennium integration >0 - Millennium gift certificate atom gift.source 0 - No channel specified 1 - via Facebook 87 - Shows full CC for unprocessed manual regardless of entered_date gift_amount.transaction_type 0 - Initial purchase 1 - Redeemed 2 - Add value 3 - Voided gift_design.logo_pos 0 - Upper left 1 - Upper right 2 - Lower right 3 - Lower left 4 - Center gift_type.sold_via: 0 - Retail 1 - On-line 2 - Rewards 3 - Rewards (Automatic Redemption) gift_type.expiration_length 0 - None 1+ - Number of months instant_pop.type 1 - 2up or 4up 8x11 marketing_list.type 0 - Email signup 1 - Daily Deals 2 - Internal use offer_type.offer_base event birthday anniversary onetime signup org.booking_type 1 - Call for appointment / reservations 2 - Online Booking with confirmation 3 - Website link 4 - SpaBooker 5 - OpenTable org.client_id 0 - don't track 1 - make optional 2 - automatically assign 3 - required org.dollar_or_service 0 - Both dollar amount and services 1 - Dollar amount only 2 - Services only org.processing_cc_type 0 - Manual 1 - Authorize.Net 2 - PayPal org.org_type 1 - Spa 2 - Salon 3 - Salon/Spa 4 - Massage Therapist org.status -2 - Inactive -1 - Cancelled 1 - Active 2 - Staging 3 - Implementing 4 - Prospect 5 - Probation 11 - Test 12 - Admin Add these together... { org.service_gc 0 - None 1 - Linked 2 - Embedded org.service_website 0 - None 1 - Services (never used) 2 - Services and Template org.service_level 0 - Directory 1 - IGC only 2 - IGC 2009 features 3 - Marketing Suite 4 - Marketing Suite Plus 5 - Custom Marketing System org.service_custom 0 - None 1 - Self service 2 - Full service 3 - Custom design } ...to get: org.service_gc, service_website, service_level and service_custom - (0,0,0,0) Directory Only org.service_option (not a real field) 0 - (0,0,0,0) Directory Only 1 - (1,0,2,0) Linked 2 - (1,0,1,1) IGC Only 3 - (1,0,3,2) Integrated 4 - (2,2,2,0) Website 5 - (1,2,2,0) Website upgrading 6 - (2,2,3,1) Dynamic (self) 7 - (1,2,3,1) Dynamic (self) upgrading 8 - (2,2,3,2) Dynamic (theme) 9 - (1,2,3,2) Dynamic (theme) upgrading 10 - (2,2,3,3) Dynamic (custom) 11 - (1,2,3,3) Dynamic (custom) upgrading 12 - (1,0,4,2) Integrated Plus 13 - (2,2,4,1) Dynamic (self) Plus 14 - (1,2,4,1) Dynamic (self) Plus upgrading 15 - (2,2,4,2) Dynamic (theme) Plus 16 - (1,2,4,2) Dynamic (theme) Plus upgrading 17 - (2,2,4,3) Dynamic (custom) Plus 18 - (1,2,4,3) Dynamic (custom) Plus upgrading 19 - (1,0,5,2) CMS Integrated 20 - (2,2,5,1) CMS Dynamic (self) 21 - (1,2,5,1) CMS Dynamic (self) upgrading 22 - (2,2,5,2) CMS Dynamic (theme) 23 - (1,2,5,2) CMS Dynamic (theme) upgrading 24 - (2,2,5,3) CMS Dynamic (custom) 25 - (1,2,4,3) CMS Dynamic (custom) upgrading org_amazon.token_type 1 - recipient (no fees) org_amazon.token_status -1 - inactive/cancelled 0 - pending return from cbui 1 - active org_analysis.analysis_point How many points this org scored, from the formula. org_analysis.max_point The maximum points the org could have scored. Note that the maximum varies depending on the org type org_analysis.website_active 0 - site could not be opened 1 - site is active org_analysis.website_link 0 - IGC link not found on site 1 - site contains link to IGC, but not on home page 2 - site contains link to IGC on home page org_analysis.schedule_link 0 - scheduling link not found on site 1 - site contains link to scheduling, but not on home page 2 - site contains link to scheduling on home page org_analysis.jos_link 0 - No link to Joy of Spa was found 1 - Link to Joy of Spa found, but not on home page 2 - Link to Joy of Spa found on home page org_analysis.website_widget (No applicable for dynamic orgs) 0 - Link to event widget not found 1 - Link to event widget found, but not on home page 2 - Link to event widget found on home page org_analysis.email_created How many email marketing campaigns exist for this org org_analysis.custom_email How many email marketing campaigns did this org added themselves org_analysis.offer_created How many offers exist for this org org_analysis.bogo How many BOGO offers this org has org_analysis.article_created How many articles (blog entries) this org has created org_analysis.igc_email_per The percentage of email addresses that came from the IGC process org_analysis.event_service How many events have services org_analysis.gc_design How many custom GC designs the org has created org_client.org_inactive 0 - NOT inactive 1 - inactive org_client.org_opt_in (setting for sending marketing emails to client) -2 - Allows cron job to queue initial 'email confirmation' message into queue_social (within 24-48 hrs) -1 - Confirmation email sent, waiting for client to opt-in or not 0 - Not opted in 1 - Opted in org_client.sms_marketing, (was called 'sms_confirm'. Setting for sending sms messages to client) -2 - Allows cron job to queue initial 'sms confirmation message' into queue_social (within 24-48 hrs) -1 - Confirmation message sent, waiting for client to opt-in or not 0 - Not opted in 1 - Opted in org_client.booking_reminder 0 - none 1 - sms (text) messages 2 - email org_client.source 0 - Default 1 - 2 - Mailing List (Google) 3 - Mailing List (Yahoo) 4 - 5 - via Newsletter sign up (subscribe) 6 - via org Import org_client.signup_offer 0 - No action 1 - Sign up offer sent org_client.birthday_offer NULL - no action date - date last birthday offer was sent org_client.anniversary_offer NULL - no action date - date last anniversary offer was sent org_status.status -3 - Locked out -2 - Inactive -1 - Temporarily Inactive, Locked out 0 - Temporarily Inactive 1 - Active 2 - Not billed org_tran.processing 0 - Manual 1 - Authorize.net 2 - PayPal 3 - SpaBooker 4 - Amazon FPS 5 - Rewards 6 - Stripe org_tran.source 1 - Gift 2 - Request 3 - Booking 4 - Rewards 5 - Checkout org_tran.type 0 - Authorize and capture 1 - Authorize 2 - Capture only (used to record the result of external authorizations, e.g. manual processing) 3 - Credit 4 - Void 5 - Capture 6 - Gift (used for rewards) org_tran.status -1 - All attempts failed 0 - Not processed 1 - Successfully processed org_gift_design.popularity: 0 - None 1 - Event-specific most popular 2 - Secondary most popular 3 - Most popular page.type 1 - Header 2 - Main 3 - Snippet 4 - Linked page 5 - Article (Blog) page page_backup.backup 0 - System (via maintenance) 1 - Administrative (Boomtime professional) 2 - User page_nav_backup.backup 0 - System (via maintenance) 1 - Administrative (Boomtime professional) 2 - User payment.payment_type 1 - stripe 2 - cash 3 - check 4 - gc 5 - manual_cc invoice.discount_type 0 - No Discount 1 - Percentage 2 - Dollar invoice_line.discount_type 0 - No Discount 1 - Percentage 2 - Dollar invoice_line.gratuity_type 0 - No Gratuity 1 - Percentage 2 - Dollar invoice_line.taxable 0 - Not Taxable 1 - Default Service Tax 2 - Default Goods Tax 3 - Other invoice_line.package 0 - Not a Package 1 - Package queue_social.status -1 - Failed: no further attempts will be made 0 - Not posted 1 - Posted queue_social.type 1 - Twitter post 2 - Facebook post 3 - Text message (e.g., booking reminders) 4 - Text message to professionals referral_code.type 0 - Attached to an event 1 - Limited use % discount 2 - Limited use value discount request.status -2 - Unable to schedule -1 - No response from client 0 - Open 1 - Scheduled review.review_type 1 - IGC review 2 - Org review service_cat.tax_type 0 - not taxed 1 - taxed at the default service rate in org 2 - taxed at a user-defined rate in the category row service.tax_type 0 - not taxed 1 - taxed at the default category rate in service_cat 2 - taxed at user-defined rate in the service row stripe_gift_tran.stripe_gift_tran This is the gift_amount atom imported to this table. stripe_gift_tran.amount_refunded This is the amount stripe reports refunded. This is not refunded commission, but the actual amount of the refund. This will be non-zero for any refund. stripe_gift_tran.commission the percent commission for the org at the time of the transaction. stripe_gift_tran.stripe_reported_commission_amount The commission, in pennies, we recieved from the transaction This number does not appear to be updated in the event that we refund a full transaction, and thus the commission as well. stripe_gift_tran.transaction_type Taken from gift_amount. 0 - Initial purchase 3 - Void task.type 1 - All service types 2 - Linked and Website 3 - Linked only 4 - Website only 5 - Embedded only tran.source 1 - gift tran.type 0 - Process manually 1 - Process on-line tran.status -2 - Voided -1 - Failed 0 - Not processed 1 - Processed template.type 1 - Linked CSS 2 - Site CSS 3 - Component CSS template_build.action 1 - Background 2 - Logo 3 - Gradient 4 - Logo on gradient template_build.orientation 0 - Horizontal 1 - Vertical template_build.pos 0 - Upper left 1 - Upper right 2 - Lower right 3 - Lower left 4 - Center template_include.type 0 - Before 1 - After twilio_log.type 1 - Click to Call Voice 2 - Outbound Voice (currently not used) 3 - Inbound SMS 4 - Outbound SMS 5 - Provisioned number 6 - Inbound Prof SMS (currently not used) 7 - Outbound Prof SMS 8 - Inbound Voice twlio_log.action Null - No specific action 1 - Subscribe 2 - Unsubscribe visit.atom_type 1 - client_journal (client_journal.client_journal stored in atom) website_backup.backup 0 - System (via maintenance) 1 - Administrative (Boomtime professional) 2 - User edb.e.valid -1 - invalid 0 - unknown 1 - accepts all 2 - valid edb.e.reason 0 - unknown (if e.valid = -1) -5 - manual blacklist -4 - demoted spam complaint -3 - demoted multiple soft-bounce -2 - demoted hard-bounce -1 - demoted manually set to invalid 1 - invalid address 2 - invalid domain 3 - invalid account 4 - disposable (if e.valid = 2) 1 - manually set to valid 2 - promoted sends with opens+clicks and no bounces or complaints 3 - promoted reserved 4 - promoted reserved