
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
DROP TABLE IF EXISTS `fields_meta_data`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `fields_meta_data` (
  `id` varchar(255) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `vname` varchar(255) DEFAULT NULL,
  `comments` varchar(255) DEFAULT NULL,
  `help` varchar(255) DEFAULT NULL,
  `custom_module` varchar(255) DEFAULT NULL,
  `type` varchar(255) DEFAULT NULL,
  `len` int(11) DEFAULT NULL,
  `required` tinyint(1) DEFAULT '0',
  `default_value` varchar(2000) DEFAULT NULL,
  `date_modified` datetime DEFAULT NULL,
  `deleted` tinyint(1) DEFAULT '0',
  `audited` tinyint(1) DEFAULT '0',
  `massupdate` tinyint(1) DEFAULT '0',
  `duplicate_merge` smallint(6) DEFAULT '0',
  `reportable` tinyint(1) DEFAULT '1',
  `importable` varchar(255) DEFAULT NULL,
  `ext1` varchar(255) DEFAULT NULL,
  `ext2` varchar(255) DEFAULT NULL,
  `ext3` varchar(255) DEFAULT NULL,
  `ext4` text,
  PRIMARY KEY (`id`),
  KEY `idx_meta_id_del` (`id`,`deleted`),
  KEY `idx_meta_cm_del` (`custom_module`,`deleted`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `fields_meta_data` WRITE;
/*!40000 ALTER TABLE `fields_meta_data` DISABLE KEYS */;
INSERT INTO `fields_meta_data` VALUES ('Accountsabn_c','abn_c','LBL_ABN',NULL,NULL,'Accounts','varchar',15,0,NULL,'2014-04-15 13:53:21',0,0,0,0,1,'true',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Accountsadministrator_t_c','administrator_t_c','LBL_ADMINISTRATOR_T',NULL,NULL,'Accounts','varchar',255,0,NULL,'2016-03-14 23:24:34',0,0,0,0,1,'true',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Accountsassets_default_c','assets_default_c','LBL_ASSETS_DEFAULT',NULL,NULL,'Accounts','int',255,0,NULL,'2014-04-15 14:09:57',0,0,0,0,1,'true',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Accountsassets_net_c','assets_net_c','LBL_ASSETS_NET',NULL,NULL,'Accounts','int',255,0,NULL,'2014-04-15 14:11:33',0,0,0,0,1,'true',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Accountsassets_per_member_c','assets_per_member_c','LBL_ASSETS_PER_MEMBER',NULL,NULL,'Accounts','int',255,0,NULL,'2019-02-28 06:23:53',0,0,0,0,1,'false',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Accountsassets_total_c','assets_total_c','LBL_ASSETS_TOTAL',NULL,NULL,'Accounts','int',255,0,NULL,'2014-04-15 14:17:37',0,0,0,0,1,'true',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Accountsbase_rate','base_rate','LBL_CURRENCY_RATE','','','Accounts','decimal',26,0,NULL,'2016-06-22 01:05:39',0,0,0,1,1,'true','','','','');
INSERT INTO `fields_meta_data` VALUES ('Accountscolor_code_c','color_code_c','LBL_COLOR_CODE','','','Accounts','text',NULL,0,'','2014-07-17 11:42:37',0,0,0,0,1,'true','','4','20','');
INSERT INTO `fields_meta_data` VALUES ('Accountscurrency_id','currency_id','','','','Accounts','currency_id',36,0,NULL,'2016-06-22 01:05:39',0,0,0,1,1,'true','','','','');
INSERT INTO `fields_meta_data` VALUES ('Accountsextended_description_c','extended_description_c','LBL_EXTENDED_DESCRIPTION',NULL,NULL,'Accounts','htmltext',NULL,0,NULL,'2014-04-15 14:24:15',0,0,0,0,1,'true',NULL,'40','80',NULL);
INSERT INTO `fields_meta_data` VALUES ('Accountsfeature_switches_account_c','feature_switches_account_c','LBL_FEATURE_SWITCHES_ACCOUNT','','','Accounts','longtextarea',NULL,0,'','2017-06-14 06:02:45',0,0,0,1,1,'true','','10','40','');
INSERT INTO `fields_meta_data` VALUES ('Accountsfees_actuary_c','fees_actuary_c','LBL_FEES_ACTUARY',NULL,NULL,'Accounts','int',255,0,NULL,'2014-04-15 14:01:20',0,0,0,0,1,'true',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Accountsfees_admin_c','fees_admin_c','LBL_FEES_ADMIN',NULL,NULL,'Accounts','int',255,0,NULL,'2014-04-15 14:05:31',0,0,0,0,1,'true',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Accountsfees_audit_c','fees_audit_c','LBL_FEES_AUDIT',NULL,NULL,'Accounts','int',255,0,NULL,'2014-04-15 14:25:19',0,0,0,0,1,'true',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Accountsfees_director_c','fees_director_c','LBL_FEES_DIRECTOR',NULL,NULL,'Accounts','int',255,0,NULL,'2014-04-15 14:27:27',0,0,0,0,1,'true',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Accountsfees_mgt_c','fees_mgt_c','LBL_FEES_MGT',NULL,NULL,'Accounts','int',255,0,NULL,'2014-04-15 14:28:37',0,0,0,0,1,'true',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Accountsfees_other_c','fees_other_c','LBL_FEES_OTHER',NULL,NULL,'Accounts','int',255,0,NULL,'2014-04-15 14:29:30',0,0,0,0,1,'true',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Accountsfees_total_c','fees_total_c','LBL_FEES_TOTAL',NULL,NULL,'Accounts','int',255,0,NULL,'2014-04-15 14:35:09',0,0,0,0,1,'true',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Accountsfee_account_c','fee_account_c','LBL_FEE_ACCOUNT_C',NULL,NULL,'Accounts','currency',26,0,NULL,'2018-09-10 01:22:07',0,0,0,1,1,'true',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Accountsfee_account_pc_c','fee_account_pc_c','LBL_FEE_ACCOUNT_PC_C',NULL,NULL,'Accounts','decimal',18,0,'0.0000','2018-09-18 06:58:42',0,0,0,1,1,'true','4',NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Accountsfee_fund_rebate_c','fee_fund_rebate_c','LBL_FEE_FUND_REBATE',NULL,NULL,'Accounts','decimal',18,0,'0.0000','2018-09-18 06:59:22',0,0,0,1,1,'true','4',NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Accountsfee_regulatory_reform_c','fee_regulatory_reform_c','LBL_FEE_REGULATORY_REFORM_C',NULL,NULL,'Accounts','currency',26,0,NULL,'2018-09-07 04:35:09',0,0,0,1,1,'true',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Accountsfp_afsl_c','fp_afsl_c','LBL_FP_AFSL',NULL,NULL,'Accounts','text',NULL,0,NULL,'2014-04-15 14:36:41',0,0,0,0,1,'true',NULL,'10','120',NULL);
INSERT INTO `fields_meta_data` VALUES ('Accountsfp_online_c','fp_online_c','LBL_FP_ONLINE',NULL,'What is the depth and sophistication of the online planning capability?','Accounts','text',NULL,0,NULL,'2014-04-15 14:39:19',0,0,0,0,1,'true',NULL,'10','80',NULL);
INSERT INTO `fields_meta_data` VALUES ('Accountsfp_other_online_tools_c','fp_other_online_tools_c','LBL_FP_OTHER_ONLINE_TOOLS',NULL,'What other online tools does the fund offer','Accounts','text',NULL,0,NULL,'2014-04-15 14:40:39',0,0,0,0,1,'true',NULL,'10','80',NULL);
INSERT INTO `fields_meta_data` VALUES ('Accountsfp_planner_num_c','fp_planner_num_c','LBL_FP_PLANNER_NUM',NULL,NULL,'Accounts','int',255,0,NULL,'2014-04-15 14:41:46',0,0,0,0,1,'true',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Accountsfp_planner_price_c','fp_planner_price_c','LBL_FP_PLANNER_PRICE',NULL,NULL,'Accounts','text',NULL,0,NULL,'2014-04-15 14:44:21',0,0,0,0,1,'true',NULL,'10','80',NULL);
INSERT INTO `fields_meta_data` VALUES ('Accountsfp_planner_services_c','fp_planner_services_c','LBL_FP_PLANNER_SERVICES',NULL,NULL,'Accounts','text',NULL,0,NULL,'2014-04-15 14:45:22',0,0,0,0,1,'true',NULL,'10','80',NULL);
INSERT INTO `fields_meta_data` VALUES ('Accountsfp_planner_type_c','fp_planner_type_c','LBL_FP_PLANNER_TYPE',NULL,NULL,'Accounts','enum',100,0,NULL,'2014-04-15 14:47:47',0,0,0,0,1,'true','fp_planner_type_0',NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Accountsfund_advice_fee_c','fund_advice_fee_c','LBL_FUND_ADVICE_FEE_C',NULL,NULL,'Accounts','varchar',255,0,NULL,'2018-09-11 03:44:05',0,0,0,1,1,'true',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Accountsfund_benefit_structure_c','fund_benefit_structure_c','LBL_FUND_BENEFIT_STRUCTURE',NULL,NULL,'Accounts','enum',100,0,NULL,'2014-04-15 14:48:52',0,0,1,0,1,'true','benefit_structure_0',NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Accountsfund_contact_details_c','fund_contact_details_c','LBL_FUND_CONTACT_DETAILS','','','Accounts','varchar',255,0,'','2017-07-28 03:11:44',0,0,0,1,1,'true','','','','');
INSERT INTO `fields_meta_data` VALUES ('Accountsfund_content_preference_c','fund_content_preference_c','LBL_FUND_CONTENT_PREFERENCE','','','Accounts','enum',100,0,'','2015-12-09 13:15:39',0,0,1,1,1,'true','fund_content_preference_list','','','');
INSERT INTO `fields_meta_data` VALUES ('Accountsfund_logo_c','fund_logo_c','LBL_FUND_LOGO','','','Accounts','image',255,0,NULL,'2014-07-02 13:52:17',0,0,0,0,1,'true','','120','','');
INSERT INTO `fields_meta_data` VALUES ('Accountsfund_pds_c','fund_pds_c','LBL_FUND_PDS_C',NULL,NULL,'Accounts','url',255,0,NULL,'2018-09-11 04:07:34',0,0,0,1,1,'true',NULL,NULL,'0','_blank');
INSERT INTO `fields_meta_data` VALUES ('Accountsfund_pricing_c','fund_pricing_c','LBL_FUND_PRICING',NULL,NULL,'Accounts','text',NULL,0,NULL,'2014-04-15 14:49:49',0,0,0,0,1,'true',NULL,'10','80',NULL);
INSERT INTO `fields_meta_data` VALUES ('Accountsfund_public_offer_status_c','fund_public_offer_status_c','LBL_FUND_PUBLIC_OFFER_STATUS',NULL,NULL,'Accounts','enum',100,0,NULL,'2014-04-15 14:50:55',0,0,0,0,1,'true','fund_public_offer_status_list',NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Accountsfund_type_c','fund_type_c','LBL_FUND_TYPE',NULL,NULL,'Accounts','enum',100,0,NULL,'2014-04-15 14:51:45',0,0,0,0,1,'true','fund_type_0',NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Accountsinv_current_default_c','inv_current_default_c','LBL_INV_CURRENT_DEFAULT','','the current investment default option','Accounts','text',NULL,0,'','2014-04-30 12:37:40',0,0,0,0,1,'true','','10','80','');
INSERT INTO `fields_meta_data` VALUES ('Accountsinv_mix_aust_equities_c','inv_mix_aust_equities_c','LBL_INV_MIX_AUST_EQUITIES',NULL,NULL,'Accounts','int',3,0,NULL,'2014-04-15 14:53:53',0,0,0,0,1,'true',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Accountsinv_mix_aust_fi_c','inv_mix_aust_fi_c','LBL_INV_MIX_AUST_FI',NULL,NULL,'Accounts','int',3,0,NULL,'2014-04-15 14:55:21',0,0,0,0,1,'true',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Accountsinv_mix_cash_c','inv_mix_cash_c','LBL_INV_MIX_CASH',NULL,NULL,'Accounts','int',3,0,NULL,'2014-04-15 14:56:48',0,0,0,0,1,'true',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Accountsinv_mix_intl_equities_c','inv_mix_intl_equities_c','LBL_INV_MIX_INTL_EQUITIES',NULL,NULL,'Accounts','int',3,0,NULL,'2014-04-15 14:58:22',0,0,0,0,1,'true',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Accountsinv_mix_intl_fi_c','inv_mix_intl_fi_c','LBL_INV_MIX_INTL_FI',NULL,NULL,'Accounts','int',3,0,NULL,'2014-04-15 14:59:38',0,0,0,0,1,'true',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Accountsinv_mix_listed_prop_c','inv_mix_listed_prop_c','LBL_INV_MIX_LISTED_PROP',NULL,NULL,'Accounts','int',3,0,NULL,'2014-04-15 15:01:03',0,0,0,0,1,'true',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Accountsinv_mix_other_c','inv_mix_other_c','LBL_INV_MIX_OTHER',NULL,NULL,'Accounts','int',3,0,NULL,'2014-04-15 15:02:37',0,0,0,0,1,'true',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Accountsinv_mix_unlisted_property_c','inv_mix_unlisted_property_c','LBL_INV_MIX_UNLISTED_PROPERTY',NULL,NULL,'Accounts','int',3,0,NULL,'2014-04-15 15:03:55',0,0,0,0,1,'true',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Accountsinv_offer_c','inv_offer_c','LBL_INV_OFFER',NULL,NULL,'Accounts','text',NULL,0,NULL,'2014-04-15 15:06:04',0,0,0,0,1,'true',NULL,'10','80',NULL);
INSERT INTO `fields_meta_data` VALUES ('Accountsinv_options_num_c','inv_options_num_c','LBL_INV_OPTIONS_NUM',NULL,NULL,'Accounts','int',5,0,NULL,'2014-04-15 13:51:14',0,0,0,0,1,'true',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Accountsmembers_num_c','members_num_c','LBL_MEMBERS_NUM',NULL,NULL,'Accounts','int',255,0,NULL,'2014-04-15 15:12:02',0,0,0,0,1,'true',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Accountsmembers_num_pension_c','members_num_pension_c','LBL_MEMBERS_NUM_PENSION',NULL,NULL,'Accounts','int',255,0,NULL,'2014-04-15 15:13:53',0,0,0,0,1,'true',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Accountsmembers_percent_pension_c','members_percent_pension_c','LBL_MEMBERS_PERCENT_PENSION',NULL,NULL,'Accounts','int',255,0,NULL,'2019-02-28 06:43:54',0,0,0,0,1,'false',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Accountsmrm_comms_c','mrm_comms_c','LBL_MRM_COMMS','What platforms, tools, and technologies are being used to communicate with members','What are the main communications provided to members','Accounts','text',NULL,0,NULL,'2014-04-15 15:17:07',0,0,0,0,1,'true',NULL,'10','80',NULL);
INSERT INTO `fields_meta_data` VALUES ('Accountsmrm_integration_c','mrm_integration_c','LBL_MRM_INTEGRATION',NULL,'how integrated are the systems and communicatioins','Accounts','text',NULL,0,NULL,'2014-04-15 15:18:24',0,0,0,0,1,'true',NULL,'10','80',NULL);
INSERT INTO `fields_meta_data` VALUES ('Accountsmrm_personalisation_c','mrm_personalisation_c','LBL_MRM_PERSONALISATION',NULL,'to what degree is member communication personalised','Accounts','text',NULL,0,NULL,'2014-04-15 15:19:24',0,0,0,0,1,'true',NULL,'10','80',NULL);
INSERT INTO `fields_meta_data` VALUES ('Accountsmrm_priorities_c','mrm_priorities_c','LBL_MRM_PRIORITIES',NULL,'what are the priorities','Accounts','text',NULL,0,NULL,'2014-04-15 15:22:55',0,0,0,0,1,'true',NULL,'10','80',NULL);
INSERT INTO `fields_meta_data` VALUES ('Accountsmrm_segmentation_c','mrm_segmentation_c','LBL_MRM_SEGMENTATION',NULL,'What segmentation model(s) are being used','Accounts','text',NULL,0,NULL,'2014-04-15 15:24:04',0,0,0,0,1,'true',NULL,'10','80',NULL);
INSERT INTO `fields_meta_data` VALUES ('Accountsmrm_tools_c','mrm_tools_c','LBL_MRM_TOOLS','What platforms, tools, and technologies are being used to communicate with members','What platforms, tools, and technologies are being used to communicate with members','Accounts','text',NULL,0,NULL,'2014-04-30 09:24:47',0,0,0,0,1,'true',NULL,'10','80',NULL);
INSERT INTO `fields_meta_data` VALUES ('Accountsportal_url_c','portal_url_c','LBL_PORTAL_URL','','URL for the portal, i.e http://supered.web.loadedstage.com','Accounts','url',255,0,'','2017-04-11 07:05:10',0,0,0,1,1,'true','','','0','_blank');
INSERT INTO `fields_meta_data` VALUES ('Accountssuppliers_current_c','suppliers_current_c','LBL_SUPPLIERS_CURRENT',NULL,NULL,'Accounts','text',NULL,0,NULL,'2014-04-15 15:21:51',0,0,0,0,1,'true',NULL,'10','80',NULL);
INSERT INTO `fields_meta_data` VALUES ('Accountssuppliers_ifs_link_c','suppliers_ifs_link_c','LBL_SUPPLIERS_IFS_LINK',NULL,'Is this fund aligned to IFS?','Accounts','bool',255,0,'0','2014-04-15 15:28:39',0,0,0,0,1,'true',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Accountstemp_c','temp_c','LBL_TEMP',NULL,NULL,'Accounts','varchar',255,0,NULL,'2019-03-05 01:04:39',0,0,0,0,1,'false',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Accountstheme_c','theme_c','LBL_THEME',NULL,NULL,'Accounts','enum',100,0,'acme','2016-08-02 03:49:35',0,0,1,1,1,'true','account_theme_list',NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Accountstotal_fund_assets_c','total_fund_assets_c','LBL_TOTAL_FUND_ASSETS',NULL,NULL,'Accounts','int',255,0,NULL,'2019-02-28 06:23:06',0,0,0,0,1,'false',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Accountstotal_members_c','total_members_c','LBL_TOTAL_MEMBERS',NULL,NULL,'Accounts','int',255,0,NULL,'2019-02-28 06:25:11',0,0,0,0,1,'false',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsab_test_id_c','ab_test_id_c','LBL_AB_TEST_ID',NULL,NULL,'Contacts','varchar',255,0,NULL,'2018-04-06 04:14:09',0,0,0,1,1,'true',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsadnl_super_contributioions_c','adnl_super_contributioions_c','LBL_ADNL_SUPER_CONTRIBUTIOIONS','','','Contacts','currency',26,0,'','2014-05-27 10:23:26',0,0,0,0,1,'true','','','','');
INSERT INTO `fields_meta_data` VALUES ('Contactsadvice_ready_to_proceed_c','advice_ready_to_proceed_c','LBL_ADVICE_READY_TO_PROCEED',NULL,NULL,'Contacts','bool',255,0,'0','2018-09-14 01:57:30',0,0,0,1,1,'true',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsadvice_status_c','advice_status_c','LBL_ADVICE_STATUS',NULL,NULL,'Contacts','enum',100,0,NULL,'2015-03-23 02:26:18',0,0,1,0,1,'true','Advice_Status_list',NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsage_death_c','age_death_c','LBL_AGE_DEATH',NULL,NULL,'Contacts','int',3,0,NULL,'2014-05-06 00:54:36',0,0,0,0,1,'true',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsage_float_c','age_float_c','LBL_AGE_FLOAT',NULL,NULL,'Contacts','float',20,0,NULL,'2019-02-28 05:42:18',0,0,0,0,1,'false','1',NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsage_months_c','age_months_c','LBL_AGE_MONTHS',NULL,NULL,'Contacts','int',4,0,NULL,'2019-02-22 07:44:02',0,0,0,0,1,'false',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsage_retirement_c','age_retirement_c','LBL_AGE_RETIREMENT',NULL,'At what age does the person want to retire?','Contacts','int',2,0,NULL,'2014-05-02 13:19:23',0,1,0,0,1,'true',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsannuity_income_c','annuity_income_c','LBL_ANNUITY_INCOME','','','Contacts','currency',26,0,'0','2016-09-09 05:33:57',0,0,0,1,1,'true','','','','');
INSERT INTO `fields_meta_data` VALUES ('Contactsapc_age_eligibility_c','apc_age_eligibility_c','LBL_APC_AGE_ELIGIBILITY',NULL,NULL,'Contacts','enum',100,0,NULL,'2018-07-20 00:58:49',0,0,1,1,1,'true','blank_true_false_list',NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsapc_amount_c','apc_amount_c','LBL_APC_AMOUNT',NULL,NULL,'Contacts','currency',26,0,'0','2018-07-20 01:00:01',0,0,0,1,1,'true',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsapc_amount_type_c','apc_amount_type_c','LBL_APC_AMOUNT_TYPE',NULL,NULL,'Contacts','enum',100,0,NULL,'2018-07-20 01:01:54',0,0,1,1,1,'true','ap_amount_type_list',NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsapc_apec_mongo_id_c','apc_apec_mongo_id_c','LBL_APC_APEC_MONGO_ID',NULL,NULL,'Contacts','varchar',255,0,NULL,'2018-07-20 01:14:13',0,0,0,1,1,'true',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsapc_application_eligibility_c','apc_application_eligibility_c','LBL_APC_APPLICATION_ELIGIBILITY',NULL,NULL,'Contacts','enum',100,0,NULL,'2018-08-13 04:11:30',0,0,1,1,1,'true','blank_true_false_list',NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsapc_assessable_assets_c','apc_assessable_assets_c','LBL_APC_ASSESSABLE_ASSETS',NULL,NULL,'Contacts','currency',26,0,'0','2018-07-20 01:03:23',0,0,0,1,1,'true',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsapc_assessable_income_c','apc_assessable_income_c','LBL_APC_ASSESSABLE_INCOME',NULL,NULL,'Contacts','currency',26,0,'0','2018-07-20 01:05:27',0,0,0,1,1,'true',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsapc_combined_amount_c','apc_combined_amount_c','LBL_APC_COMBINED_AMOUNT',NULL,NULL,'Contacts','currency',26,0,'0','2018-07-20 06:51:29',0,0,0,1,1,'true',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsapc_combined_amount_type_c','apc_combined_amount_type_c','LBL_APC_COMBINED_AMOUNT_TYPE',NULL,NULL,'Contacts','enum',100,0,NULL,'2018-07-20 01:06:57',0,0,1,1,1,'true','ap_amount_type_list',NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsapc_mongo_id_c','apc_mongo_id_c','LBL_APC_MONGO_ID',NULL,NULL,'Contacts','varchar',255,0,NULL,'2018-07-20 01:15:15',0,0,0,1,1,'true',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsapc_residency_eligibility_c','apc_residency_eligibility_c','LBL_APC_RESIDENCY_ELIGIBILITY',NULL,NULL,'Contacts','enum',100,0,NULL,'2018-07-20 01:08:22',0,0,1,1,1,'true','blank_true_false_list',NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsapc_test_assets_amount_c','apc_test_assets_amount_c','LBL_APC_TEST_ASSETS_AMOUNT',NULL,NULL,'Contacts','currency',26,0,'0','2018-07-20 01:09:11',0,0,0,1,1,'true',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsapc_test_assets_amount_type_c','apc_test_assets_amount_type_c','LBL_APC_TEST_ASSETS_AMOUNT_TYPE',NULL,NULL,'Contacts','enum',100,0,NULL,'2018-07-20 01:11:09',0,0,1,1,1,'true','ap_amount_type_list',NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsapc_test_income_amount_c','apc_test_income_amount_c','LBL_APC_TEST_INCOME_AMOUNT',NULL,NULL,'Contacts','currency',26,0,'0','2018-07-20 01:12:07',0,0,0,1,1,'true',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsapc_test_income_amount_type_c','apc_test_income_amount_type_c','LBL_APC_TEST_INCOME_AMOUNT_TYPE',NULL,NULL,'Contacts','enum',100,0,NULL,'2018-07-20 01:13:09',0,0,1,1,1,'true','ap_amount_type_list',NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsap_age_eligibility_c','ap_age_eligibility_c','LBL_AP_AGE_ELIGIBILITY_C',NULL,NULL,'Contacts','enum',100,0,NULL,'2017-12-12 05:03:00',0,0,1,1,1,'true','blank_true_false_list',NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsap_amount_c','ap_amount_c','LBL_AP_AMOUNT',NULL,'$ amount person receives in age pension','Contacts','currency',26,0,'0','2018-05-22 01:52:34',0,1,0,0,1,'false',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsap_amount_t1_c','ap_amount_t1_c','LBL_AP_AMOUNT_T1',NULL,NULL,'Contacts','currency',26,0,'0','2018-05-17 04:42:32',0,0,0,1,1,'true',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsap_amount_t2_c','ap_amount_t2_c','LBL_AP_AMOUNT_T2',NULL,NULL,'Contacts','currency',26,0,'0','2018-05-17 04:44:35',0,0,0,1,1,'true',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsap_amount_type_c','ap_amount_type_c','LBL_AP_AMOUNT_TYPE',NULL,NULL,'Contacts','enum',100,0,NULL,'2018-05-22 01:49:11',0,0,1,1,1,'true','ap_amount_type_list',NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsap_amount_type_t1_c','ap_amount_type_t1_c','LBL_AP_AMOUNT_TYPE_T1',NULL,NULL,'Contacts','enum',100,0,NULL,'2018-05-17 04:52:13',0,0,1,1,1,'true','ap_amount_type_list',NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsap_amount_type_t2_c','ap_amount_type_t2_c','LBL_AP_AMOUNT_TYPE_T2',NULL,NULL,'Contacts','enum',100,0,NULL,'2018-05-17 04:54:06',0,0,1,1,1,'true','ap_amount_type_list',NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsap_apec_mongo_id_c','ap_apec_mongo_id_c','LBL_AP_APEC_MONGO_ID',NULL,NULL,'Contacts','varchar',255,0,NULL,'2018-07-20 00:48:55',0,0,0,1,1,'true',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsap_apec_mongo_id_t1_c','ap_apec_mongo_id_t1_c','LBL_AP_APEC_MONGO_ID_T1',NULL,NULL,'Contacts','varchar',255,0,NULL,'2018-07-20 00:50:16',0,0,0,1,1,'true',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsap_apec_mongo_id_t2_c','ap_apec_mongo_id_t2_c','LBL_AP_APEC_MONGO_ID_T2',NULL,NULL,'Contacts','varchar',255,0,NULL,'2018-07-20 00:51:04',0,0,0,1,1,'true',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsap_application_date_c','ap_application_date_c','LBL_AP_APPLICATION_DATE',NULL,NULL,'Contacts','date',NULL,0,NULL,'2018-08-13 04:04:06',0,0,1,1,1,'true',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsap_application_date_t1_c','ap_application_date_t1_c','LBL_AP_APPLICATION_DATE_T1',NULL,NULL,'Contacts','date',NULL,0,NULL,'2018-08-13 04:06:31',0,0,1,1,1,'true',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsap_application_date_t2_c','ap_application_date_t2_c','LBL_AP_APPLICATION_DATE_T2',NULL,NULL,'Contacts','date',NULL,0,NULL,'2018-08-13 04:08:45',0,0,1,1,1,'true',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsap_application_date_text_c','ap_application_date_text_c','LBL_AP_APPLICATION_DATE_TEXT',NULL,NULL,'Contacts','varchar',255,0,NULL,'2018-08-13 04:03:07',0,0,0,1,1,'true',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsap_application_date_text_t1_c','ap_application_date_text_t1_c','LBL_AP_APPLICATION_DATE_TEXT_T1',NULL,NULL,'Contacts','varchar',255,0,NULL,'2018-08-13 04:07:44',0,0,0,1,1,'true',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsap_application_date_text_t2_c','ap_application_date_text_t2_c','LBL_AP_APPLICATION_DATE_TEXT_T2',NULL,NULL,'Contacts','varchar',255,0,NULL,'2018-08-13 04:09:59',0,0,0,1,1,'true',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsap_application_type_c','ap_application_type_c','LBL_AP_APPLICATION_TYPE',NULL,NULL,'Contacts','enum',100,0,NULL,'2017-11-30 06:58:36',0,1,1,1,1,'true','ap_application_type_list',NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsap_assessable_assets_c','ap_assessable_assets_c','LBL_AP_ASSESSABLE_ASSETS',NULL,NULL,'Contacts','currency',26,0,NULL,'2017-12-17 02:45:35',0,1,0,1,1,'true',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsap_assessable_assets_t1_c','ap_assessable_assets_t1_c','LBL_AP_ASSESSABLE_ASSETS_T1_C',NULL,NULL,'Contacts','currency',26,0,'0','2018-05-22 03:16:53',0,1,0,1,1,'true',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsap_assessable_assets_t2_c','ap_assessable_assets_t2_c','LBL_AP_ASSESSABLE_ASSETS_T2_C',NULL,NULL,'Contacts','currency',26,0,'0','2018-05-22 03:16:05',0,1,0,1,1,'true',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsap_assessable_income_c','ap_assessable_income_c','LBL_AP_ASSESSABLE_INCOME',NULL,NULL,'Contacts','currency',26,0,NULL,'2017-12-17 02:46:19',0,1,0,1,1,'true',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsap_assessable_income_t1_c','ap_assessable_income_t1_c','LBL_AP_ASSESSABLE_INCOME_T1_C',NULL,NULL,'Contacts','currency',26,0,'0','2018-05-22 02:48:03',0,1,0,1,1,'true',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsap_assessable_income_t2_c','ap_assessable_income_t2_c','LBL_AP_ASSESSABLE_INCOME_T2_C',NULL,NULL,'Contacts','currency',26,0,'0','2018-05-22 02:31:41',0,1,0,1,1,'true',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsap_australia_post_sent_date_c','ap_australia_post_sent_date_c','LBL_AP_AUSTRALIA_POST_SENT_DATE',NULL,NULL,'Contacts','date',NULL,0,NULL,'2018-03-27 05:19:54',0,0,1,1,1,'true',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsap_australia_post_tracking_c','ap_australia_post_tracking_c','LBL_AP_AUSTRALIA_POST_TRACKING',NULL,NULL,'Contacts','varchar',255,0,NULL,'2018-03-27 05:13:57',0,0,0,1,1,'true',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsap_centrelink_receipt_date_c','ap_centrelink_receipt_date_c','LBL_AP_CENTRELINK_RECEIPT_DATE',NULL,NULL,'Contacts','date',NULL,0,NULL,'2018-03-27 05:12:32',0,0,1,1,1,'true',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsap_centrelink_receipt_number_c','ap_centrelink_receipt_number_c','LBL_AP_CENTRELINK_RECEIPT_NUMBER',NULL,NULL,'Contacts','varchar',255,0,NULL,'2018-03-27 05:11:09',0,0,0,1,1,'true',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsap_combined_amount_c','ap_combined_amount_c','LBL_AP_COMBINED_AMOUNT',NULL,NULL,'Contacts','currency',26,0,'0','2018-07-20 01:16:50',0,0,0,1,1,'true',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsap_combined_amount_t1_c','ap_combined_amount_t1_c','LBL_AP_COMBINED_AMOUNT_T1',NULL,NULL,'Contacts','currency',26,0,'0','2018-07-20 01:17:43',0,0,0,1,1,'true',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsap_combined_amount_t2_c','ap_combined_amount_t2_c','LBL_AP_COMBINED_AMOUNT_T2',NULL,NULL,'Contacts','currency',26,0,'0','2018-07-20 01:18:42',0,0,0,1,1,'true',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsap_combined_amount_type_c','ap_combined_amount_type_c','LBL_AP_COMBINED_AMOUNT_TYPE',NULL,NULL,'Contacts','enum',100,0,NULL,'2018-03-05 04:50:00',0,0,1,1,1,'true','ap_amount_type_list',NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsap_combined_amount_type_t1_c','ap_combined_amount_type_t1_c','LBL_AP_COMBINED_AMOUNT_TYPE_T1_C',NULL,NULL,'Contacts','enum',100,0,NULL,'2018-05-22 03:20:41',0,0,1,1,1,'true','ap_amount_type_list',NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsap_combined_amount_type_t2_c','ap_combined_amount_type_t2_c','LBL_AP_COMBINED_AMOUNT_TYPE_T2',NULL,NULL,'Contacts','enum',100,0,NULL,'2018-05-22 03:21:49',0,0,1,1,1,'true','ap_amount_type_list',NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsap_completed_sections_count_c','ap_completed_sections_count_c','LBL_AP_COMPLETED_SECTIONS_COUNT',NULL,NULL,'Contacts','int',255,0,NULL,'2018-05-01 04:16:48',0,0,0,0,1,'false',NULL,'6',NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsap_date_c','ap_date_c','LBL_AP_DATE_C',NULL,NULL,'Contacts','date',NULL,0,NULL,'2018-05-22 03:29:48',0,0,1,1,1,'true',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsap_date_t1_c','ap_date_t1_c','LBL_AP_DATE_T1_C',NULL,NULL,'Contacts','date',NULL,0,NULL,'2018-05-22 02:43:56',0,0,1,1,1,'true',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsap_date_t2_c','ap_date_t2_c','LBL_AP_DATE_T2',NULL,NULL,'Contacts','date',NULL,0,NULL,'2018-05-22 02:55:59',0,0,1,1,1,'true',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsap_date_text_c','ap_date_text_c','LBL_AP_DATE_TEXT',NULL,NULL,'Contacts','varchar',255,0,NULL,'2018-05-22 03:04:34',0,0,0,1,1,'true',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsap_date_text_t1_c','ap_date_text_t1_c','LBL_AP_DATE_TEXT_T1',NULL,NULL,'Contacts','varchar',255,0,NULL,'2018-05-22 02:58:34',0,0,0,1,1,'true',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsap_date_text_t2_c','ap_date_text_t2_c','LBL_AP_DATE_TEXT_T2',NULL,NULL,'Contacts','varchar',255,0,NULL,'2018-05-22 03:01:20',0,0,0,1,1,'true',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsap_deemed_income_c','ap_deemed_income_c','LBL_AP_DEEMED_INCOME',NULL,NULL,'Contacts','currency',26,0,'0','2018-05-08 23:44:15',0,0,0,1,1,'true',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsap_deemed_income_t1_c','ap_deemed_income_t1_c','LBL_AP_DEEMED_INCOME_T1',NULL,NULL,'Contacts','currency',26,0,'0','2018-05-17 05:06:38',0,0,0,1,1,'true',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsap_deemed_income_t2_c','ap_deemed_income_t2_c','LBL_AP_DEEMED_INCOME_T2',NULL,NULL,'Contacts','currency',26,0,'0','2018-05-17 05:08:15',0,0,0,1,1,'true',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsap_eligibility_date_c','ap_eligibility_date_c','LBL_AP_ELIGIBILITY_DATE',NULL,NULL,'Contacts','date',NULL,0,NULL,'2018-05-17 05:29:58',0,0,1,1,1,'true',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsap_eligibility_date_t1_c','ap_eligibility_date_t1_c','LBL_AP_ELIGIBILITY_DATE_T1',NULL,NULL,'Contacts','date',NULL,0,NULL,'2018-05-17 04:48:04',0,0,1,1,1,'true',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsap_eligibility_date_t2_c','ap_eligibility_date_t2_c','LBL_AP_ELIGIBILITY_DATE_T2',NULL,NULL,'Contacts','date',NULL,0,NULL,'2018-05-17 04:55:54',0,0,1,1,1,'true',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsap_eligibility_date_text_c','ap_eligibility_date_text_c','LBL_AP_ELIGIBILITY_DATE_TEXT',NULL,NULL,'Contacts','varchar',255,0,NULL,'2018-05-22 01:16:24',0,0,0,1,1,'true',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsap_eligibility_date_text_t1_c','ap_eligibility_date_text_t1_c','LBL_AP_ELIGIBILITY_DATE_TEXT_T1',NULL,NULL,'Contacts','varchar',255,0,NULL,'2018-05-17 05:04:59',0,0,0,1,1,'true',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsap_eligibility_date_text_t2_c','ap_eligibility_date_text_t2_c','LBL_AP_ELIGIBILITY_DATE_TEXT_T2',NULL,NULL,'Contacts','varchar',255,0,NULL,'2018-05-17 05:02:34',0,0,0,1,1,'true',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsap_person1_app_date_c','ap_person1_app_date_c','LBL_AP_PERSON1_APP_DATE_C',NULL,NULL,'Contacts','date',NULL,0,NULL,'2018-08-24 04:13:14',0,0,1,1,1,'true',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsap_person1_app_date_text_c','ap_person1_app_date_text_c','LBL_AP_PERSON1_APP_DATE_TEXT_C',NULL,NULL,'Contacts','varchar',255,0,NULL,'2018-08-24 04:15:57',0,0,0,1,1,'true',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsap_person2_app_date_c','ap_person2_app_date_c','LBL_AP_PERSON2_APP_DATE_C',NULL,NULL,'Contacts','date',NULL,0,NULL,'2018-08-24 04:14:22',0,0,1,1,1,'true',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsap_person2_app_date_text_c','ap_person2_app_date_text_c','LBL_AP_PERSON2_APP_DATE_TEXT_C',NULL,NULL,'Contacts','varchar',255,0,NULL,'2018-08-24 04:20:40',0,0,0,1,1,'true',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsap_residency_eligibility_c','ap_residency_eligibility_c','LBL_AP_RESIDENCY_ELIGIBILITY_C',NULL,NULL,'Contacts','enum',100,0,NULL,'2017-12-12 05:08:18',0,0,1,1,1,'true','blank_true_false_list',NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsap_test_assets_amount_c','ap_test_assets_amount_c','LBL_AP_TEST_ASSETS_AMOUNT',NULL,'$ amount of pension eligible from the assets test','Contacts','currency',26,0,NULL,'2017-12-17 02:37:39',0,1,0,1,1,'true',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsap_test_assets_amount_t1_c','ap_test_assets_amount_t1_c','LBL_AP_TEST_ASSETS_AMOUNT_T1_C',NULL,'$ amount of pension eligible from the assets test','Contacts','currency',26,0,'0','2018-05-22 02:21:37',0,1,0,1,1,'true',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsap_test_assets_amount_t2_c','ap_test_assets_amount_t2_c','LBL_AP_TEST_ASSETS_AMOUNT_T2_C',NULL,'$ amount of pension eligible from the assets test','Contacts','currency',26,0,'0','2018-05-22 02:23:21',0,1,0,1,1,'true',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsap_test_assets_amount_type_c','ap_test_assets_amount_type_c','LBL_AP_TEST_ASSETS_AMOUNT_TYPE',NULL,NULL,'Contacts','enum',100,0,NULL,'2018-01-02 05:36:16',0,0,1,1,1,'true','ap_amount_type_list',NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsap_test_assets_amt_type_t1_c','ap_test_assets_amt_type_t1_c','LBL_AP_TEST_ASSETS_AMT_TYPE_T1',NULL,NULL,'Contacts','enum',100,0,NULL,'2018-05-22 03:01:13',0,0,1,1,1,'true','ap_amount_type_list',NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsap_test_assets_amt_type_t2_c','ap_test_assets_amt_type_t2_c','LBL_AP_TEST_ASSETS_AMT_TYPE_T2',NULL,NULL,'Contacts','enum',100,0,NULL,'2018-05-22 03:03:34',0,0,1,1,1,'true','ap_amount_type_list',NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsap_test_income_amount_c','ap_test_income_amount_c','LBL_AP_TEST_INCOME_AMOUNT',NULL,'$ amount of pension eligible from the income test','Contacts','currency',26,0,NULL,'2017-12-17 02:38:37',0,1,0,1,1,'true',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsap_test_income_amount_t1_c','ap_test_income_amount_t1_c','LBL_AP_TEST_INCOME_AMOUNT_T1_C',NULL,'$ amount of pension eligible from the income test','Contacts','currency',26,0,'0','2018-05-22 02:25:49',0,1,0,1,1,'true',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsap_test_income_amount_t2_c','ap_test_income_amount_t2_c','LBL_AP_TEST_INCOME_AMOUNT_T2_C',NULL,'$ amount of pension eligible from the income test','Contacts','currency',26,0,'0','2018-05-22 02:26:51',0,1,0,1,1,'true',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsap_test_income_amount_type_c','ap_test_income_amount_type_c','LBL_AP_TEST_INCOME_AMOUNT_TYPE',NULL,NULL,'Contacts','enum',100,0,NULL,'2018-01-02 05:41:51',0,0,1,1,1,'true','ap_amount_type_list',NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsap_test_income_amt_type_t1_c','ap_test_income_amt_type_t1_c','LBL_AP_TEST_INCOME_AMT_TYPE_T1',NULL,NULL,'Contacts','enum',100,0,NULL,'2018-05-22 03:15:02',0,0,1,1,1,'true','ap_amount_type_list',NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsap_test_income_amt_type_t2_c','ap_test_income_amt_type_t2_c','LBL_AP_TEST_INCOME_AMT_TYPE_T2',NULL,NULL,'Contacts','enum',100,0,NULL,'2018-05-22 03:17:58',0,0,1,1,1,'true','ap_amount_type_list',NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsars_competencies_value_c','ars_competencies_value_c','LBL_ARS_COMPETENCIES_VALUE','','','Contacts','int',255,0,'','2016-01-29 03:54:03',0,0,0,1,1,'true','','','','');
INSERT INTO `fields_meta_data` VALUES ('Contactsars_data_value_c','ars_data_value_c','LBL_ARS_DATA_VALUE','','','Contacts','int',255,0,'','2016-01-29 03:53:15',0,0,0,1,1,'true','','','','');
INSERT INTO `fields_meta_data` VALUES ('Contactsars_engagement_value_c','ars_engagement_value_c','LBL_ARS_ENGAGEMENT_VALUE','','','Contacts','int',255,0,'','2015-01-13 22:30:35',0,0,0,0,1,'true','0','','','');
INSERT INTO `fields_meta_data` VALUES ('Contactsars_outcome_value_c','ars_outcome_value_c','LBL_ARS_OUTCOME_VALUE','','','Contacts','int',255,0,'','2015-01-13 22:28:41',0,0,0,0,1,'true','0','','','');
INSERT INTO `fields_meta_data` VALUES ('Contactsars_overall_value_c','ars_overall_value_c','LBL_ARS_OVERALL_VALUE',NULL,NULL,'Contacts','int',255,0,NULL,'2019-02-19 04:03:51',0,0,0,0,1,'false','0',NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsassets_total_addl_income_c','assets_total_addl_income_c','LBL_ASSETS_TOTAL_ADDL_INCOME',NULL,NULL,'Contacts','currency',26,0,NULL,'2014-10-22 01:29:47',0,0,0,0,1,'true',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsassets_total_inv_assets_c','assets_total_inv_assets_c','LBL_ASSETS_TOTAL_INV_ASSETS',NULL,NULL,'Contacts','currency',26,0,'0','2019-02-28 05:59:45',0,0,0,0,1,'false',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsassets_total_non_super_c','assets_total_non_super_c','LBL_ASSETS_TOTAL_NON_SUPER',NULL,NULL,'Contacts','currency',26,0,NULL,'2014-05-06 23:49:40',0,0,0,0,1,'true',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsassets_total_primary_super_c','assets_total_primary_super_c','LBL_ASSETS_TOTAL_PRIMARY_SUPER_C',NULL,NULL,'Contacts','currency',26,0,'0','2019-02-28 06:03:51',0,0,0,0,1,'false',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsassets_total_super_c','assets_total_super_c','LBL_ASSETS_TOTAL_SUPER',NULL,NULL,'Contacts','currency',26,0,'0','2019-02-28 06:05:00',0,0,0,0,1,'false',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsassets_total_super_other_c','assets_total_super_other_c','LBL_ASSETS_TOTAL_SUPER_OTHER_C',NULL,NULL,'Contacts','currency',26,0,'0','2019-02-28 06:02:44',0,1,0,0,1,'false',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsasset_annuitisation_c','asset_annuitisation_c','LBL_ASSET_ANNUITISATION','','','Contacts','decimal',8,0,'','2016-09-05 00:31:27',0,0,0,1,1,'true','4','','','');
INSERT INTO `fields_meta_data` VALUES ('Contactsatps_proxy_c','atps_proxy_c','LBL_ATPS_PROXY','','','Contacts','currency',26,0,'0','2015-07-09 04:56:13',0,0,0,0,1,'true','','','','');
INSERT INTO `fields_meta_data` VALUES ('Contactsbase_rate','base_rate','LBL_CURRENCY_RATE','','','Contacts','decimal',26,0,NULL,'2014-05-02 13:24:49',0,0,0,0,1,'true','','','','');
INSERT INTO `fields_meta_data` VALUES ('Contactschargebee_customer_id_c','chargebee_customer_id_c','LBL_CHARGEBEE_CUSTOMER_ID',NULL,NULL,'Contacts','varchar',255,0,NULL,'2018-01-22 08:03:51',0,0,0,1,1,'true',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactscheck_ap_application_type_c','check_ap_application_type_c','LBL_CHECK_AP_APPLICATION_TYPE_C',NULL,NULL,'Contacts','enum',100,0,NULL,'2018-01-23 05:07:47',0,0,1,1,1,'true','ap_application_type_list',NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsconfidence_c','confidence_c','LBL_CONFIDENCE',NULL,NULL,'Contacts','decimal',18,0,NULL,'2017-03-14 00:56:30',0,0,0,1,1,'true','2',NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactscount_articles_c','count_articles_c','LBL_COUNT_ARTICLES',NULL,NULL,'Contacts','int',255,0,NULL,'2015-02-24 02:43:32',0,0,0,0,1,'false','0',NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactscount_badges_c','count_badges_c','LBL_COUNT_BADGES','','','Contacts','int',255,0,'','2015-02-24 02:45:04',0,0,0,0,1,'true','','','','');
INSERT INTO `fields_meta_data` VALUES ('Contactscount_competencies_c','count_competencies_c','LBL_COUNT_COMPETENCIES',NULL,NULL,'Contacts','int',5,0,NULL,'2018-05-01 04:20:02',0,0,0,0,1,'false',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactscount_profile_completion_c','count_profile_completion_c','LBL_COUNT_PROFILE_COMPLETION',NULL,NULL,'Contacts','int',255,0,NULL,'2019-02-19 04:09:40',0,0,0,0,1,'false',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactscurrency_id','currency_id','LBL_CURRENCY',NULL,NULL,'Contacts','currency_id',36,0,NULL,'2014-04-02 11:23:05',0,0,0,0,1,'true',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsdashboard_tile_1_c','dashboard_tile_1_c','LBL_DASHBOARD_TILE_1',NULL,NULL,'Contacts','varchar',255,0,NULL,'2015-12-10 22:43:16',0,0,0,0,1,'false',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsdashboard_tile_2_c','dashboard_tile_2_c','LBL_DASHBOARD_TILE_2',NULL,NULL,'Contacts','varchar',255,0,NULL,'2019-02-19 04:28:14',0,0,0,0,1,'false',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsdashboard_tile_3_c','dashboard_tile_3_c','LBL_DASHBOARD_TILE_3',NULL,NULL,'Contacts','varchar',255,0,NULL,'2019-02-19 04:29:00',0,0,0,0,1,'false',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsdeath_cover_c','death_cover_c','LBL_DEATH_COVER','','','Contacts','currency',26,0,'0','2016-01-28 09:55:26',0,0,0,1,1,'true','','','','');
INSERT INTO `fields_meta_data` VALUES ('Contactsdeath_weekly_premium_c','death_weekly_premium_c','LBL_DEATH_WEEKLY_PREMIUM','','','Contacts','currency',26,0,'0','2016-01-28 09:57:52',0,0,0,1,1,'true','','','','');
INSERT INTO `fields_meta_data` VALUES ('Contactsdebt_current_value_c','debt_current_value_c','LBL_DEBT_CURRENT_VALUE','','','Contacts','currency',26,0,'','2014-05-27 11:01:43',0,0,0,0,1,'true','','','','');
INSERT INTO `fields_meta_data` VALUES ('Contactsdebt_type_c','debt_type_c','LBL_DEBT_TYPE',NULL,NULL,'Contacts','enum',100,0,NULL,'2014-05-27 12:06:46',0,0,1,0,1,'true','debt_type_list',NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsdefaultprofile_prompts_count_c','defaultprofile_prompts_count_c','LBL_DEFAULTPROFILE_PROMPTS_COUNT',NULL,NULL,'Contacts','longtextarea',NULL,0,NULL,'2018-04-20 03:36:08',0,0,0,0,1,'false',NULL,'4','20',NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsdisplay_next_action_1_c','display_next_action_1_c','LBL_DISPLAY_NEXT_ACTION_1',NULL,NULL,'Contacts','bool',255,0,'0','2019-02-19 04:56:49',0,0,0,0,1,'false',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsdisplay_next_action_2_c','display_next_action_2_c','LBL_DISPLAY_NEXT_ACTION_2',NULL,NULL,'Contacts','bool',255,0,'0','2019-02-19 05:00:05',0,0,0,0,1,'false',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsdisplay_rif_sidebar_msg_c','display_rif_sidebar_msg_c','LBL_DISPLAY_RIF_SIDEBAR_MSG',NULL,NULL,'Contacts','bool',255,0,'0','2019-02-19 04:23:47',0,0,0,0,1,'false',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsemail_verified_c','email_verified_c','LBL_EMAIL_VERIFIED',NULL,NULL,'Contacts','bool',255,0,'0','2018-01-09 22:32:22',0,0,0,1,1,'true',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsemployment_status_c','employment_status_c','LBL_EMPLOYMENT_STATUS',NULL,NULL,'Contacts','enum',100,0,'Employed','2014-10-22 01:33:02',0,0,1,0,1,'true','employment_status_list',NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsest_date_load_paid_off_c','est_date_load_paid_off_c','LBL_EST_DATE_LOAD_PAID_OFF',NULL,NULL,'Contacts','date',NULL,0,NULL,'2014-05-27 11:21:53',0,0,1,0,1,'true',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsexpenses_current_c','expenses_current_c','LBL_EXPENSES_CURRENT',NULL,NULL,'Contacts','currency',26,0,'0','2017-12-11 07:37:17',0,0,0,1,1,'true',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsexternal_member_id_c','external_member_id_c','LBL_EXTERNAL_MEMBER_ID','','','Contacts','varchar',255,0,'','2016-01-28 10:00:34',0,0,0,1,1,'true','','','','');
INSERT INTO `fields_meta_data` VALUES ('Contactsfeature_switches_account_c','feature_switches_account_c','LBL_FEATURE_SWITCHES_ACCOUNT','','','Contacts','longtextarea',NULL,0,'','2017-06-14 06:04:21',0,0,0,1,1,'true','','10','20','');
INSERT INTO `fields_meta_data` VALUES ('Contactsfeature_switches_c','feature_switches_c','LBL_FEATURE_SWITCHES',NULL,NULL,'Contacts','longtextarea',NULL,0,NULL,'2018-01-10 08:58:17',0,1,0,0,1,'true',NULL,'4','20',NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsfeature_switches_segment_c','feature_switches_segment_c','LBL_FEATURE_SWITCHES_SEGMENT',NULL,NULL,'Contacts','longtextarea',NULL,0,NULL,'2017-09-29 04:59:05',0,0,0,0,1,'false',NULL,'10','20',NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsfund_data_date_c','fund_data_date_c','LBL_FUND_DATA_DATE',NULL,NULL,'Contacts','date',NULL,0,NULL,'2018-10-18 03:08:15',0,0,1,1,1,'true',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsgender_c','gender_c','LBL_GENDER','','','Contacts','enum',100,0,'','2014-04-02 11:23:05',0,0,0,0,1,'true','gender_list','','','');
INSERT INTO `fields_meta_data` VALUES ('Contactsgenerate_handover_report_c','generate_handover_report_c','LBL_GENERATE_HANDOVER_REPORT',NULL,NULL,'Contacts','bool',255,0,'0','2018-11-30 00:26:25',0,0,0,1,1,'true',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactshealth_check_c','health_check_c','LBL_HEALTH_CHECK',NULL,NULL,'Contacts','enum',100,0,NULL,'2017-12-11 01:00:12',0,0,1,1,1,'true','health_check_list',NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactshome_ownership_c','home_ownership_c','LBL_HOME_OWNERSHIP',NULL,NULL,'Contacts','enum',100,0,'rent','2015-08-28 05:18:12',0,0,1,0,1,'true','home_ownership_list',NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsincome_addl_contributions_c','income_addl_contributions_c','LBL_INCOME_ADDL_CONTRIBUTIONS','additional super contributions to super (% of pre-tax income)','additional super contributions to super (% of pre-tax income)','Contacts','int',2,0,NULL,'2014-05-02 13:20:31',0,1,0,0,1,'true',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsincome_addl_contrib_c','income_addl_contrib_c','LBL_INCOME_ADDL_CONTRIB_C',NULL,NULL,'Contacts','currency',26,0,NULL,'2016-05-31 03:23:05',0,0,0,0,1,'false',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsincome_amount_per_year_c','income_amount_per_year_c','LBL_INCOME_AMOUNT_PER_YEAR','','','Contacts','currency',26,0,'','2014-05-27 10:31:21',0,0,0,0,1,'true','','','','');
INSERT INTO `fields_meta_data` VALUES ('Contactsincome_current_c','income_current_c','LBL_INCOME_CURRENT',NULL,NULL,'Contacts','currency',26,0,NULL,'2014-04-02 11:23:05',0,0,0,0,1,'true',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsincome_current_growth_c','income_current_growth_c','LBL_INCOME_CURRENT_GROWTH',NULL,'expected growth per annum in personal income','Contacts','int',2,0,NULL,'2014-04-02 11:23:05',0,0,0,0,1,'true',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsincome_desired_p_c','income_desired_p_c','LBL_INCOME_DESIRED_P',NULL,NULL,'Contacts','int',255,0,NULL,'2019-02-28 05:56:55',0,0,0,0,1,'false',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsincome_end_date_c','income_end_date_c','LBL_INCOME_END_DATE','','','Contacts','date',NULL,0,'','2014-05-27 10:34:28',0,0,1,0,1,'true','','','','');
INSERT INTO `fields_meta_data` VALUES ('Contactsincome_expected_retirement_c','income_expected_retirement_c','LBL_INCOME_EXPECTED_RETIREMENT',NULL,NULL,'Contacts','int',255,0,NULL,'2014-05-02 15:08:31',0,1,0,0,1,'true',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsincome_expected_retire_high_c','income_expected_retire_high_c','LBL_INCOME_EXPECTED_RETIRE_HIGH',NULL,NULL,'Contacts','int',255,0,NULL,'2014-05-02 13:31:48',0,1,0,0,1,'true',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsincome_frequency_c','income_frequency_c','LBL_INCOME_FREQUENCY',NULL,NULL,'Contacts','enum',100,0,'weekly','2015-12-02 05:14:49',0,0,1,0,1,'true','income_frequency_list',NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsincome_required_p_c','income_required_p_c','LBL_INCOME_REQUIRED_P',NULL,NULL,'Contacts','int',255,0,NULL,'2019-02-28 05:56:17',0,0,0,0,1,'false',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsincome_retirement_desired_c','income_retirement_desired_c','LBL_INCOME_RETIREMENT_DESIRED',NULL,NULL,'Contacts','currency',26,0,NULL,'2016-05-31 03:20:35',0,0,0,0,1,'false',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsincome_retirement_required_c','income_retirement_required_c','LBL_INCOME_RETIREMENT_REQUIRED',NULL,NULL,'Contacts','currency',26,0,NULL,'2016-05-31 03:21:07',0,0,0,0,1,'false',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsincome_start_date_c','income_start_date_c','LBL_INCOME_START_DATE','','','Contacts','date',NULL,0,'','2014-05-27 10:33:12',0,0,1,0,1,'true','','','','');
INSERT INTO `fields_meta_data` VALUES ('Contactsincome_type_c','income_type_c','LBL_INCOME_TYPE',NULL,NULL,'Contacts','enum',100,0,NULL,'2016-03-02 07:25:04',0,0,1,0,1,'true','income_type_list',NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsinvestment_current_value_c','investment_current_value_c','LBL_INVESTMENT_CURRENT_VALUE','','','Contacts','currency',26,0,'','2014-05-27 11:50:46',0,0,0,0,1,'true','','','','');
INSERT INTO `fields_meta_data` VALUES ('Contactsinvestment_risk_c','investment_risk_c','LBL_INVESTMENT_RISK',NULL,NULL,'Contacts','float',3,0,NULL,'2014-05-02 13:23:27',0,1,0,0,1,'true','1',NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsinvestment_strategy_c','investment_strategy_c','LBL_INVESTMENT_STRATEGY',NULL,NULL,'Contacts','enum',100,0,NULL,'2014-05-02 13:21:47',0,1,0,0,1,'true','investment_strategy_list',NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsinvestment_type_c','investment_type_c','LBL_INVESTMENT_TYPE',NULL,NULL,'Contacts','enum',100,0,NULL,'2014-05-27 12:05:35',0,0,1,0,1,'true','investments_type_list',NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsinvestor_c','investor_c','LBL_INVESTOR','','','Contacts','bool',255,0,'0','2014-04-02 11:23:05',0,0,0,0,1,'true','','','','');
INSERT INTO `fields_meta_data` VALUES ('Contactsinvolvement_c','involvement_c','LBL_INVOLVEMENT',NULL,NULL,'Contacts','decimal',18,0,NULL,'2017-03-14 00:56:55',0,0,0,1,1,'true','2',NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsip_cover_c','ip_cover_c','LBL_IP_COVER','','','Contacts','currency',26,0,'0','2016-01-28 09:57:22',0,0,0,1,1,'true','','','','');
INSERT INTO `fields_meta_data` VALUES ('Contactsip_weekly_premium_c','ip_weekly_premium_c','LBL_IP_WEEKLY_PREMIUM','','','Contacts','currency',26,0,'0','2016-01-28 09:59:04',0,0,0,1,1,'true','','','','');
INSERT INTO `fields_meta_data` VALUES ('Contactsis_guest_c','is_guest_c','LBL_IS_GUEST',NULL,NULL,'Contacts','bool',255,0,'0','2017-12-11 06:15:09',0,0,0,1,1,'true',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactslast_login_c','last_login_c','LBL_LAST_LOGIN','','','Contacts','datetimecombo',NULL,0,'','2014-09-18 12:55:15',0,0,1,0,1,'true','','','','');
INSERT INTO `fields_meta_data` VALUES ('Contactslast_logout_c','last_logout_c','LBL_LAST_LOGOUT',NULL,NULL,'Contacts','datetimecombo',NULL,0,NULL,'2018-01-11 11:33:13',0,1,1,1,1,'true',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsliab_total_home_other_loans_c','liab_total_home_other_loans_c','LBL_LIAB_TOTAL_HOME_OTHER_LOANS',NULL,NULL,'Contacts','currency',26,0,'0','2019-03-03 23:16:27',0,0,0,0,1,'false',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsliab_total_inv_loans_c','liab_total_inv_loans_c','LBL_LIAB_TOTAL_INV_LOANS',NULL,NULL,'Contacts','currency',26,0,'0','2019-02-28 06:00:37',0,0,0,0,1,'false',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactslife_journey_c','life_journey_c','LBL_LIFE_JOURNEY','','','Contacts','varchar',255,0,'','2017-01-20 07:10:24',0,0,0,1,1,'true','','','','');
INSERT INTO `fields_meta_data` VALUES ('Contactslinkedin_c','linkedin_c','LBL_LINKEDIN','','','Contacts','url',255,0,'','2014-05-06 01:54:59',0,0,0,0,1,'true','','','','_self');
INSERT INTO `fields_meta_data` VALUES ('Contactslsw_amount_c','lsw_amount_c','LBL_LSW_AMOUNT',NULL,NULL,'Contacts','currency',26,0,'0','2019-02-28 06:01:51',0,0,0,0,1,'false',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactslsw_first_year_c','lsw_first_year_c','LBL_LSW_FIRST_YEAR','','','Contacts','int',4,0,'','2014-05-27 11:25:27',0,0,0,0,1,'true','','','','');
INSERT INTO `fields_meta_data` VALUES ('Contactslsw_type_c','lsw_type_c','LBL_LSW_TYPE',NULL,NULL,'Contacts','enum',100,0,NULL,'2014-05-27 12:08:11',0,0,1,0,1,'true','lump_sum_withdrawals_list',NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsmain_retirement_concerns_c','main_retirement_concerns_c','LBL_MAIN_RETIREMENT_CONCERNS',NULL,NULL,'Contacts','multienum',100,0,'^^','2017-12-11 00:59:33',0,0,1,1,1,'true','main_retirement_concerns_list',NULL,NULL,'a:2:{s:7:\"default\";s:2:\"^^\";s:10:\"dependency\";s:0:\"\";}');
INSERT INTO `fields_meta_data` VALUES ('Contactsmaritalstatus_c','maritalstatus_c','LBL_MARITALSTATUS',NULL,NULL,'Contacts','enum',100,0,NULL,'2018-01-04 06:58:39',0,0,1,0,1,'true','maritalstatus_list',NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsmember_hash_c','member_hash_c','LBL_MEMBER_HASH',NULL,NULL,'Contacts','encrypt',255,0,NULL,'2014-10-22 01:54:30',0,0,0,0,1,'true',NULL,NULL,'varchar',NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsmember_id_c','member_id_c','LBL_MEMBER_ID',NULL,NULL,'Contacts','varchar',255,0,NULL,'2015-12-21 06:19:10',0,0,0,0,1,'true',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsmember_password_c','member_password_c','LBL_MEMBER_PASSWORD',NULL,NULL,'Contacts','varchar',255,0,'7a39b46ec5a158d06e96cecf1b22d2b59482335063f9eeb00dc9fa17101d6071','2014-10-22 01:43:34',0,0,0,0,1,'true',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsmotivation_c','motivation_c','LBL_MOTIVATION',NULL,NULL,'Contacts','decimal',18,0,NULL,'2017-03-14 00:57:27',0,0,0,1,1,'true','2',NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsoptimisation_flag_c','optimisation_flag_c','LBL_OPTIMISATION_FLAG_C',NULL,NULL,'Contacts','bool',255,0,'0','2014-10-22 01:46:31',0,0,0,0,1,'true',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsoptrif_advice_status_c','optrif_advice_status_c','LBL_OPTRIF_ADVICE_STATUS',NULL,NULL,'Contacts','enum',100,0,NULL,'2015-03-23 01:49:58',0,0,1,0,1,'true','Advice_Status_list',NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsoptrif_date_created_c','optrif_date_created_c','LBL_OPTRIF_DATE_CREATED',NULL,NULL,'Contacts','datetimecombo',NULL,0,NULL,'2015-03-23 01:52:59',0,0,1,0,1,'true',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsoptrif_strong_c','optrif_strong_c','LBL_OPTRIF_STRONG','','','Contacts','currency',26,0,'0','2015-03-23 02:18:56',0,0,0,0,1,'true','','','','');
INSERT INTO `fields_meta_data` VALUES ('Contactsoptrif_verystrong_c','optrif_verystrong_c','LBL_OPTRIF_VERYSTRONG','','','Contacts','currency',26,0,'0','2015-05-08 04:10:42',0,0,0,0,1,'true','','','','');
INSERT INTO `fields_meta_data` VALUES ('Contactsoptrif_veryweak_c','optrif_veryweak_c','LBL_OPTRIF_VERYWEAK',NULL,NULL,'Contacts','currency',26,0,'0','2015-03-23 02:25:49',0,0,0,0,1,'true',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsoptrif_weak_c','optrif_weak_c','LBL_OPTRIF_WEAK','','','Contacts','currency',26,0,'0','2015-03-23 01:55:12',0,0,0,0,1,'true','','','','');
INSERT INTO `fields_meta_data` VALUES ('Contactspension_flag_c','pension_flag_c','LBL_PENSION_FLAG','','','Contacts','bool',255,0,'1','2015-09-24 12:15:56',0,0,0,1,1,'true','','','','');
INSERT INTO `fields_meta_data` VALUES ('Contactsper_salary_yearly_total_c','per_salary_yearly_total_c','LBL_PER_SALARY_YEARLY_TOTAL','','','Contacts','currency',26,0,'','2014-05-27 10:20:38',0,0,0,0,1,'true','','','','');
INSERT INTO `fields_meta_data` VALUES ('Contactspilot_status_c','pilot_status_c','LBL_PILOT_STATUS','','','Contacts','enum',100,0,'Not_Included','2017-02-06 05:00:20',0,0,1,1,1,'true','Pilot_Status_list','','','');
INSERT INTO `fields_meta_data` VALUES ('Contactspreferred_article_type_c','preferred_article_type_c','LBL_PREFERRED_ARTICLE_TYPE','','','Contacts','enum',100,0,'','2015-12-09 13:39:47',0,0,1,1,1,'true','article_type_list','','','');
INSERT INTO `fields_meta_data` VALUES ('Contactsprocess_1_completed_c','process_1_completed_c','LBL_PROCESS_1_COMPLETED','','','Contacts','bool',255,0,'0','2016-11-17 23:31:12',0,0,0,1,1,'true','','','','');
INSERT INTO `fields_meta_data` VALUES ('Contactsprocess_2_completed_c','process_2_completed_c','LBL_PROCESS_2_COMPLETED','','','Contacts','bool',255,0,'0','2016-11-17 23:31:43',0,0,0,1,1,'true','','','','');
INSERT INTO `fields_meta_data` VALUES ('Contactsprocess_3_completed_c','process_3_completed_c','LBL_PROCESS_3_COMPLETED','','','Contacts','bool',255,0,'0','2016-11-18 01:02:19',0,0,0,1,1,'true','','','','');
INSERT INTO `fields_meta_data` VALUES ('Contactsprocess_attributes_c','process_attributes_c','LBL_PROCESS_ATTRIBUTES',NULL,NULL,'Contacts','text',NULL,0,'{}','2018-01-16 05:26:59',0,0,0,1,1,'true',NULL,'4','20',NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsprocess_trigger_c','process_trigger_c','LBL_PROCESS_TRIGGER',NULL,NULL,'Contacts','text',NULL,0,'{}','2018-01-16 05:26:05',0,0,0,1,1,'true',NULL,'4','20',NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsprofile_prompts_count_c','profile_prompts_count_c','LBL_PROFILE_PROMPTS_COUNT',NULL,NULL,'Contacts','longtextarea',NULL,0,NULL,'2014-10-22 01:49:41',0,0,0,0,1,'true',NULL,'4','20',NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsreferrer_c','referrer_c','LBL_REFERRER','','','Contacts','varchar',100,0,'','2016-10-31 05:27:15',0,0,0,1,1,'true','','','','');
INSERT INTO `fields_meta_data` VALUES ('Contactsrepeat_no_of_years_c','repeat_no_of_years_c','LBL_REPEAT_NO_OF_YEARS','','','Contacts','int',255,0,'','2014-05-27 11:27:14',0,0,0,0,1,'true','','','','');
INSERT INTO `fields_meta_data` VALUES ('Contactsresetpw_token_c','resetpw_token_c','LBL_RESETPW_TOKEN_C','','','Contacts','varchar',255,0,'','2015-11-04 09:08:16',0,1,0,1,1,'true','','','','');
INSERT INTO `fields_meta_data` VALUES ('Contactsresetpw_trigger_c','resetpw_trigger_c','LBL_RESETPW_TRIGGER','','','Contacts','bool',255,0,'0','2015-11-04 09:06:50',0,1,0,1,1,'true','','','','');
INSERT INTO `fields_meta_data` VALUES ('Contactsretirement_vs_current_age_c','retirement_vs_current_age_c','LBL_RETIREMENT_VS_CURRENT_AGE',NULL,NULL,'Contacts','decimal',18,0,NULL,'2019-02-19 04:36:35',0,0,0,0,1,'false','8',NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsre_one_off_expenses_amount_c','re_one_off_expenses_amount_c','LBL_RE_ONE_OFF_EXPENSES_AMOUNT',NULL,NULL,'Contacts','currency',26,0,'0','2017-12-11 00:58:26',0,0,0,1,1,'true',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsre_one_off_expenses_list_c','re_one_off_expenses_list_c','LBL_RE_ONE_OFF_EXPENSES_LIST',NULL,NULL,'Contacts','multienum',100,0,'^^','2017-12-11 01:02:25',0,0,1,1,1,'true','re_one_off_expenses_list',NULL,NULL,'a:2:{s:7:\"default\";s:2:\"^^\";s:10:\"dependency\";s:0:\"\";}');
INSERT INTO `fields_meta_data` VALUES ('Contactsri_date_created_c','ri_date_created_c','LBL_RI_DATE_CREATED','','','Contacts','datetimecombo',NULL,0,'','2015-03-11 02:43:05',0,0,1,0,1,'true','','','','');
INSERT INTO `fields_meta_data` VALUES ('Contactsri_strong_c','ri_strong_c','LBL_RI_STRONG','','','Contacts','currency',26,0,'0','2015-03-11 02:35:17',0,0,0,0,1,'true','','','','');
INSERT INTO `fields_meta_data` VALUES ('Contactsri_verystrong_c','ri_verystrong_c','LBL_RI_VERYSTRONG','','','Contacts','currency',26,0,'0','2015-03-11 02:37:34',0,0,0,0,1,'true','','','','');
INSERT INTO `fields_meta_data` VALUES ('Contactsri_veryweak_c','ri_veryweak_c','LBL_RI_VERYWEAK','','','Contacts','currency',26,0,'0','2015-03-11 02:38:20',0,0,0,0,1,'true','','','','');
INSERT INTO `fields_meta_data` VALUES ('Contactsri_weak_c','ri_weak_c','LBL_RI_WEAK','','','Contacts','currency',26,0,'0','2015-03-11 02:36:03',0,0,0,0,1,'true','','','','');
INSERT INTO `fields_meta_data` VALUES ('Contactssegmentation_engagement_c','segmentation_engagement_c','LBL_SEGMENTATION_ENGAGEMENT',NULL,NULL,'Contacts','enum',100,0,NULL,'2017-04-04 00:06:00',0,1,0,0,1,'true','segmentation_engagement_list',NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactssegmentation_lifestage_c','segmentation_lifestage_c','LBL_SEGMENTATION_LIFESTAGE',NULL,NULL,'Contacts','enum',100,0,NULL,'2014-05-02 13:15:51',0,0,0,0,1,'true','segmentation_lifestage_c_list',NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactssegmentation_situation_c','segmentation_situation_c','LBL_SEGMENTATION_SITUATION',NULL,NULL,'Contacts','enum',100,0,NULL,'2014-05-02 13:17:05',0,0,0,0,1,'true','segmentation_situation_list',NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsshow_splash_next_c','show_splash_next_c','LBL_SHOW_SPLASH_NEXT',NULL,NULL,'Contacts','bool',255,0,'1','2014-10-22 01:50:22',0,0,0,0,1,'true',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactssimulation_demo_link_c','simulation_demo_link_c','LBL_SIMULATION_DEMO_LINK',NULL,NULL,'Contacts','html',NULL,0,NULL,'2014-05-07 04:29:24',0,0,0,0,1,'true',NULL,NULL,'text','<p><a href=\"http://supered-portal.web.loadedstage.com/#/knowledge/4\" target=\"_blank\">Run Simulation Demo</a></p>');
INSERT INTO `fields_meta_data` VALUES ('Contactssimulation_engine_c','simulation_engine_c','LBL_SIMULATION_ENGINE',NULL,NULL,'Contacts','enum',100,0,'v01','2016-02-03 23:05:58',0,1,1,0,1,'true','simulation_engine_list',NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactssimulation_iterations_c','simulation_iterations_c','LBL_SIMULATION_ITERATIONS',NULL,NULL,'Contacts','int',3,0,NULL,'2014-04-02 11:23:05',0,0,0,0,1,'true',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactssimulation_link_c','simulation_link_c','LBL_SIMULATION_LINK',NULL,NULL,'Contacts','enhancedurl',250,0,NULL,'2019-02-19 04:32:23',0,0,0,0,1,'false',NULL,NULL,NULL,'_blank');
INSERT INTO `fields_meta_data` VALUES ('Contactssimulation_link_text_c','simulation_link_text_c','LBL_SIMULATION_LINK_TEXT',NULL,NULL,'Contacts','varchar',255,0,NULL,'2019-02-19 04:33:16',0,0,0,0,1,'false',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactssoa_flag_c','soa_flag_c','LBL_SOA_FLAG',NULL,NULL,'Contacts','bool',255,0,'0','2014-10-22 01:53:03',0,0,0,0,1,'true',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactssplash_page_c','splash_page_c','LBL_SPLASH_PAGE',NULL,NULL,'Contacts','varchar',255,0,NULL,'2018-03-07 05:57:47',0,0,0,1,1,'true',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsstart_date_with_fund_c','start_date_with_fund_c','LBL_START_DATE_WITH_FUND','','','Contacts','date',NULL,0,'','2016-01-28 09:59:49',0,0,1,1,1,'true','','','','');
INSERT INTO `fields_meta_data` VALUES ('Contactssteps_c','steps_c','LBL_STEPS',NULL,NULL,'Contacts','longtextarea',NULL,0,NULL,'2016-11-18 00:43:01',0,0,0,0,1,'true',NULL,'4','22',NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactssteps_c_defauls_c','steps_c_defauls_c','LBL_STEPS_C_DEFAULS','','','Contacts','longtextarea',NULL,0,'','2014-11-21 03:54:41',0,0,0,0,1,'true','','4','20','');
INSERT INTO `fields_meta_data` VALUES ('Contactssteps_c_default_c','steps_c_default_c','LBL_STEPS_C_DEFAULT',NULL,NULL,'Contacts','longtextarea',NULL,0,NULL,'2018-04-20 03:33:53',0,1,0,0,1,'false',NULL,'4','20',NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactstfn_c','tfn_c','LBL_TFN',NULL,NULL,'Contacts','varchar',255,0,NULL,'2018-05-21 01:36:20',0,0,0,1,1,'true',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactstotal_interactions_count_c','total_interactions_count_c','LBL_TOTAL_INTERACTIONS_COUNT',NULL,NULL,'Contacts','int',255,0,NULL,'2019-02-28 05:33:01',0,0,0,0,1,'false',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactstotal_profile_completion_c','total_profile_completion_c','LBL_TOTAL_PROFILE_COMPLETION',NULL,NULL,'Contacts','decimal',6,0,NULL,'2014-10-22 01:52:23',0,0,0,0,1,'true','2',NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactstpd_cover_c','tpd_cover_c','LBL_TPD_COVER','','','Contacts','currency',26,0,'0','2016-01-28 09:56:59',0,0,0,1,1,'true','','','','');
INSERT INTO `fields_meta_data` VALUES ('Contactstpd_weekly_premium_c','tpd_weekly_premium_c','LBL_TPD_WEEKLY_PREMIUM','','','Contacts','currency',26,0,'0','2016-01-28 09:58:15',0,0,0,1,1,'true','','','','');
INSERT INTO `fields_meta_data` VALUES ('Contactstrigger_account_activation_c','trigger_account_activation_c','LBL_TRIGGER_ACCOUNT_ACTIVATION',NULL,NULL,'Contacts','bool',255,0,'0','2018-06-07 06:13:51',0,0,0,1,1,'true',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactstrigger_email_verification_c','trigger_email_verification_c','LBL_TRIGGER_EMAIL_VERIFICATION',NULL,NULL,'Contacts','bool',255,0,'0','2018-01-16 06:01:36',0,1,0,1,1,'true',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsttr_flag_c','ttr_flag_c','LBL_TTR_FLAG',NULL,NULL,'Contacts','bool',255,0,'0','2014-10-22 01:45:49',0,0,0,0,1,'true',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsuic_contribution_c','uic_contribution_c','LBL_UIC_CONTRIBUTION','','','Contacts','bool',255,0,'0','2015-04-08 06:05:14',0,0,0,0,1,'true','','','','');
INSERT INTO `fields_meta_data` VALUES ('Contactsuic_desired_income_c','uic_desired_income_c','LBL_UIC_DESIRED_INCOME','','','Contacts','bool',255,0,'0','2015-04-08 06:07:41',0,0,0,0,1,'true','','','','');
INSERT INTO `fields_meta_data` VALUES ('Contactsuic_personal_investment_str_c','uic_personal_investment_str_c','LBL_UIC_PERSONAL_INVESTMENT_STR','','','Contacts','bool',255,0,'0','2015-04-08 06:08:49',0,0,0,0,1,'true','','','','');
INSERT INTO `fields_meta_data` VALUES ('Contactsuic_required_income_c','uic_required_income_c','LBL_UIC_REQUIRED_INCOME','','','Contacts','bool',255,0,'0','2015-04-08 06:06:53',0,0,0,0,1,'true','','','','');
INSERT INTO `fields_meta_data` VALUES ('Contactsuic_retirement_age_c','uic_retirement_age_c','LBL_UIC_RETIREMENT_AGE','','','Contacts','bool',255,0,'0','2015-04-08 06:04:03',0,0,0,0,1,'true','','','','');
INSERT INTO `fields_meta_data` VALUES ('Contactsuic_runout_age_c','uic_runout_age_c','LBL_UIC_RUNOUT_AGE','','','Contacts','bool',255,0,'0','2015-04-08 06:06:02',0,0,0,0,1,'true','','','','');
INSERT INTO `fields_meta_data` VALUES ('Contactsuic_system_c','uic_system_c','LBL_UIC_SYSTEM',NULL,NULL,'Contacts','int',255,0,NULL,'2015-10-22 12:10:04',0,0,0,1,1,'true',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsunderstanding_c','understanding_c','LBL_UNDERSTANDING',NULL,NULL,'Contacts','decimal',18,0,NULL,'2017-03-14 00:55:30',0,0,0,1,1,'true','2',NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsuserincomefrequency_c','userincomefrequency_c','LBL_USERINCOMEFREQUENCY',NULL,NULL,'Contacts','enum',100,0,NULL,'2016-03-02 07:20:29',0,0,1,1,1,'true','userincomefrequency_list',NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsuserincometype_c','userincometype_c','LBL_USERINCOMETYPE',NULL,NULL,'Contacts','enum',100,0,NULL,'2016-03-03 05:26:55',0,0,1,1,1,'true','userincometype_c_list',NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Contactsusersalsacavailable_c','usersalsacavailable_c','LBL_USERSALSACAVAILABLE',NULL,NULL,'Contacts','bool',255,0,'0','2016-03-02 07:13:11',0,0,0,1,1,'true',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Documentsaccount_id_c','account_id_c','LBL_FUND_ARTICLE_AUTHOR_ACCOUNT_ID','','','Documents','id',36,0,NULL,'2015-12-09 13:21:19',0,0,0,1,0,'true','','','','');
INSERT INTO `fields_meta_data` VALUES ('Documentsannuity_income_slider_c','annuity_income_slider_c','LBL_ANNUITY_INCOME_SLIDER',NULL,NULL,'Documents','bool',255,0,'0','2016-09-09 05:29:47',0,0,0,1,1,'true',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Documentsannuity_slider_c','annuity_slider_c','LBL_ANNUITY_SLIDER',NULL,NULL,'Documents','bool',255,0,'0','2016-09-05 00:24:27',0,0,0,1,1,'true',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Documentsarticle_author_c','article_author_c','LBL_ARTICLE_AUTHOR','','','Documents','relate',255,0,NULL,'2015-12-09 13:26:33',0,0,0,1,1,'true','','Users','user_id_c','');
INSERT INTO `fields_meta_data` VALUES ('Documentsarticle_id_c','article_id_c','LBL_ARTICLE_ID',NULL,NULL,'Documents','int',255,0,NULL,'2016-05-10 23:35:29',0,0,0,0,1,'true',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Documentsarticle_profile_field_c','article_profile_field_c','LBL_ARTICLE_PROFILE_FIELD','','','Documents','enum',100,0,'','2015-11-20 06:25:43',0,0,1,1,1,'true','article_profile_field_list','','','');
INSERT INTO `fields_meta_data` VALUES ('Documentsarticle_type_c','article_type_c','LBL_ARTICLE_TYPE','','','Documents','enum',100,0,'','2015-12-09 13:25:55',0,0,1,1,1,'true','article_type_list','','','');
INSERT INTO `fields_meta_data` VALUES ('Documentsattributes_c','attributes_c','LBL_ATTRIBUTES',NULL,NULL,'Documents','text',NULL,0,'{}','2015-11-13 13:19:03',0,0,0,0,1,'true',NULL,'4','80',NULL);
INSERT INTO `fields_meta_data` VALUES ('Documentsbodyhtml2_c','bodyhtml2_c','LBL_BODYHTML2','','','Documents','htmltext',NULL,0,'','2015-07-20 23:08:53',0,0,0,1,1,'true','','15','150','');
INSERT INTO `fields_meta_data` VALUES ('Documentsbodyhtml_c','bodyhtml_c','LBL_BODYHTML',NULL,NULL,'Documents','htmltext',NULL,0,NULL,'2015-07-01 00:52:26',0,0,0,0,1,'true',NULL,'15','150',NULL);
INSERT INTO `fields_meta_data` VALUES ('Documentsbodytext_c','bodytext_c','LBL_BODYTEXT',NULL,NULL,'Documents','text',NULL,0,NULL,'2015-07-01 00:54:42',0,0,0,0,1,'true',NULL,'15','150',NULL);
INSERT INTO `fields_meta_data` VALUES ('Documentsconfidence_slider_c','confidence_slider_c','LBL_CONFIDENCE_SLIDER','','','Documents','bool',255,0,'0','2017-01-11 12:51:33',0,0,0,1,1,'true','','','','');
INSERT INTO `fields_meta_data` VALUES ('Documentscta_description_c','cta_description_c','LBL_CTA_DESCRIPTION',NULL,NULL,'Documents','varchar',255,0,NULL,'2016-04-18 07:09:21',0,0,0,1,1,'true',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Documentscta_text_c','cta_text_c','LBL_CTA_TEXT','','','Documents','varchar',255,0,'','2016-04-18 06:29:56',0,0,0,1,1,'true','','','','');
INSERT INTO `fields_meta_data` VALUES ('Documentscustom_stylesheet_url_c','custom_stylesheet_url_c','LBL_CUSTOM_STYLESHEET_URL','','','Documents','varchar',255,0,'','2017-02-16 05:42:29',0,0,0,1,1,'true','','','','');
INSERT INTO `fields_meta_data` VALUES ('Documentsdisplaycalcsalsac_c','displaycalcsalsac_c','LBL_DISPLAYCALCSALSAC','','','Documents','bool',255,0,'0','2016-03-03 05:30:37',0,0,0,1,1,'true','','','','');
INSERT INTO `fields_meta_data` VALUES ('Documentsfund_article_author_c','fund_article_author_c','LBL_FUND_ARTICLE_AUTHOR','','','Documents','relate',255,0,NULL,'2015-12-09 13:21:19',0,0,0,1,1,'true','','Accounts','account_id_c','');
INSERT INTO `fields_meta_data` VALUES ('Documentsiconfile_c','iconfile_c','LBL_ICONFILE',NULL,NULL,'Documents','image',255,0,NULL,'2015-07-01 00:55:52',0,0,0,0,1,'true',NULL,'120',NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Documentsiconurl_c','iconurl_c','LBL_ICONURL',NULL,NULL,'Documents','url',255,0,NULL,'2015-07-01 00:56:26',0,0,0,0,1,'true',NULL,NULL,NULL,'_self');
INSERT INTO `fields_meta_data` VALUES ('Documentsinvolvement_slider_c','involvement_slider_c','LBL_INVOLVEMENT_SLIDER','','','Documents','bool',255,0,'0','2017-01-11 12:52:29',0,0,0,1,1,'true','','','','');
INSERT INTO `fields_meta_data` VALUES ('Documentslead_c','lead_c','LBL_LEAD',NULL,NULL,'Documents','text',NULL,0,NULL,'2015-07-01 00:59:35',0,0,0,0,1,'true',NULL,'4','20',NULL);
INSERT INTO `fields_meta_data` VALUES ('Documentsmediaisvideo_c','mediaisvideo_c','LBL_MEDIAISVIDEO','','','Documents','bool',255,0,'0','2014-07-02 10:49:40',0,0,0,0,1,'true','','','','');
INSERT INTO `fields_meta_data` VALUES ('Documentsmediaurl_c','mediaurl_c','LBL_MEDIAURL','','','Documents','url',255,0,'','2014-07-02 10:53:01',0,0,0,0,1,'true','','','','_self');
INSERT INTO `fields_meta_data` VALUES ('Documentsmotivation_slider_c','motivation_slider_c','LBL_MOTIVATION_SLIDER','','','Documents','bool',255,0,'0','2017-01-11 12:50:56',0,0,0,1,1,'true','','','','');
INSERT INTO `fields_meta_data` VALUES ('Documentspdf_appendix_c','pdf_appendix_c','LBL_PDF_APPENDIX',NULL,NULL,'Documents','text',NULL,0,NULL,'2018-03-13 01:58:17',0,0,0,1,1,'true',NULL,'30','150',NULL);
INSERT INTO `fields_meta_data` VALUES ('Documentspdf_field_map_c','pdf_field_map_c','LBL_PDF_FIELD_MAP',NULL,NULL,'Documents','text',NULL,0,NULL,'2018-02-02 03:51:06',0,0,0,1,1,'true',NULL,'30','150',NULL);
INSERT INTO `fields_meta_data` VALUES ('Documentsposterimagefile_c','posterimagefile_c','LBL_POSTERIMAGEFILE',NULL,NULL,'Documents','image',255,0,NULL,'2015-07-01 00:57:05',0,0,0,0,1,'true',NULL,'120',NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Documentsposterimageurl_c','posterimageurl_c','LBL_POSTERIMAGEURL',NULL,NULL,'Documents','url',255,0,NULL,'2015-07-01 00:57:41',0,0,0,0,1,'true',NULL,NULL,NULL,'_self');
INSERT INTO `fields_meta_data` VALUES ('Documentssave_revisions_c','save_revisions_c','LBL_SAVE_REVISIONS',NULL,NULL,'Documents','bool',255,0,'1','2017-06-28 23:51:18',0,0,0,1,1,'true',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Documentsslider_age_r_c','slider_age_r_c','LBL_SLIDER_AGE_R','','','Documents','bool',255,0,'0','2014-07-02 10:54:46',0,0,0,0,1,'true','','','','');
INSERT INTO `fields_meta_data` VALUES ('Documentsslider_conts_c','slider_conts_c','LBL_SLIDER_CONTS','','','Documents','bool',255,0,'0','2014-07-02 10:56:27',0,0,0,0,1,'true','','','','');
INSERT INTO `fields_meta_data` VALUES ('Documentsslider_desiredincome_c','slider_desiredincome_c','LBL_SLIDER_DESIREDINCOME','','','Documents','bool',255,0,'0','2014-07-02 11:00:58',0,0,0,0,1,'true','','','','');
INSERT INTO `fields_meta_data` VALUES ('Documentsslider_requiredincome_c','slider_requiredincome_c','LBL_SLIDER_REQUIREDINCOME','','','Documents','bool',255,0,'0','2014-07-02 10:58:08',0,0,0,0,1,'true','','','','');
INSERT INTO `fields_meta_data` VALUES ('Documentsswitch_optimise_c','switch_optimise_c','LBL_SWITCH_OPTIMISE','','','Documents','bool',255,0,'0','2014-07-02 10:51:38',0,0,0,0,1,'true','','','','');
INSERT INTO `fields_meta_data` VALUES ('Documentsswitch_pension_c','switch_pension_c','LBL_SWITCH_PENSION','','','Documents','bool',255,0,'0','2015-09-24 12:14:06',0,0,0,1,1,'true','','','','');
INSERT INTO `fields_meta_data` VALUES ('Documentsswitch_run_out_c','switch_run_out_c','LBL_SWITCH_RUN_OUT','','','Documents','bool',255,0,'0','2014-07-28 08:31:16',0,0,0,0,1,'true','','','','');
INSERT INTO `fields_meta_data` VALUES ('Documentsswitch_ttr_c','switch_ttr_c','LBL_SWITCH_TTR','','','Documents','bool',255,0,'0','2014-07-02 10:59:37',0,0,0,0,1,'true','','','','');
INSERT INTO `fields_meta_data` VALUES ('Documentstile_icon_c','tile_icon_c','LBL_TILE_ICON','','','Documents','varchar',255,0,'','2016-04-18 06:51:58',0,0,0,1,1,'true','','','','');
INSERT INTO `fields_meta_data` VALUES ('Documentstile_title_c','tile_title_c','LBL_TILE_TITLE','','','Documents','varchar',255,0,'','2016-04-18 06:50:52',0,0,0,1,1,'true','','','','');
INSERT INTO `fields_meta_data` VALUES ('Documentstopic_c','topic_c','LBL_TOPIC',NULL,NULL,'Documents','multienum',100,0,'[Null]','2015-07-01 00:58:15',0,0,1,0,1,'true','Knowledge_Centre_Topics',NULL,NULL,'a:1:{s:10:\"dependency\";s:107:\"or(contains($template_type,\"article\"),contains($template_type,\"checklist\"),contains($template_type,\"info\"))\";}');
INSERT INTO `fields_meta_data` VALUES ('Documentsunderstanding_slider_c','understanding_slider_c','LBL_UNDERSTANDING_SLIDER','','','Documents','bool',255,0,'0','2017-01-11 12:52:03',0,0,0,1,1,'true','','','','');
INSERT INTO `fields_meta_data` VALUES ('Documentsuser_id_c','user_id_c','LBL_ARTICLE_AUTHOR_USER_ID','','','Documents','id',36,0,NULL,'2015-12-09 13:26:33',0,0,0,1,0,'true','','','','');
INSERT INTO `fields_meta_data` VALUES ('Notesfull_description_c','full_description_c','LBL_FULL_DESCRIPTION',NULL,NULL,'Notes','text',NULL,0,NULL,'2014-04-16 13:44:35',0,0,0,0,1,'true',NULL,'20','80',NULL);
INSERT INTO `fields_meta_data` VALUES ('Notesnotify_management_c','notify_management_c','LBL_NOTIFY_MANAGEMENT',NULL,NULL,'Notes','bool',255,0,'0','2014-04-16 13:45:54',0,0,0,0,1,'true',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Opportunitiesauthority_c','authority_c','LBL_AUTHORITY',NULL,NULL,'Opportunities','text',NULL,0,NULL,'2014-04-15 15:34:02',0,0,0,0,1,'true',NULL,'10','80',NULL);
INSERT INTO `fields_meta_data` VALUES ('Opportunitiesbudget_c','budget_c','LBL_BUDGET',NULL,NULL,'Opportunities','text',NULL,0,NULL,'2014-04-15 15:34:50',0,0,0,0,1,'true',NULL,'10','80',NULL);
INSERT INTO `fields_meta_data` VALUES ('Opportunitiescharge_amount_c','charge_amount_c','LBL_CHARGE_AMOUNT',NULL,NULL,'Opportunities','currency',26,0,'0','2018-09-20 04:35:09',0,0,0,1,1,'true',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Opportunitiesclose_plan_c','close_plan_c','LBL_CLOSE_PLAN',NULL,NULL,'Opportunities','enhancedurl',255,0,'http://mrm.supered.com.au/#bwc/index.php?module=Opportunities&action=ShowOrgChart&record={id}','2019-02-26 06:41:15',0,0,0,0,1,'false',NULL,NULL,NULL,'_self');
INSERT INTO `fields_meta_data` VALUES ('Opportunitiesexpected_amount_c','expected_amount_c','LBL_EXPECTED_AMOUNT',NULL,NULL,'Opportunities','currency',26,0,'0','2019-02-26 06:45:46',0,0,0,0,1,'false',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Opportunitiesneeds_c','needs_c','LBL_NEEDS',NULL,NULL,'Opportunities','text',NULL,0,NULL,'2014-04-15 15:35:41',0,0,0,0,1,'true',NULL,'10','80',NULL);
INSERT INTO `fields_meta_data` VALUES ('Opportunitiesprocess_attributes_c','process_attributes_c','LBL_PROCESS_ATTRIBUTES',NULL,NULL,'Opportunities','text',NULL,0,'{}','2018-01-16 05:27:39',0,0,0,1,1,'true',NULL,'4','20',NULL);
INSERT INTO `fields_meta_data` VALUES ('Opportunitiesprocess_trigger_c','process_trigger_c','LBL_PROCESS_TRIGGER',NULL,'This field has been added to trigger processes across modules','Opportunities','text',NULL,0,'{}','2018-01-16 05:28:08',0,0,0,1,1,'true',NULL,'4','20',NULL);
INSERT INTO `fields_meta_data` VALUES ('Opportunitiesrating_c','rating_c','LBL_RATING','','','Opportunities','enum',100,0,NULL,'2014-04-02 11:23:05',0,0,0,0,1,'true','rating_list',NULL,NULL,'');
INSERT INTO `fields_meta_data` VALUES ('Opportunitiesrisks_c','risks_c','LBL_RISKS',NULL,NULL,'Opportunities','text',NULL,0,NULL,'2014-04-15 15:37:35',0,0,0,0,1,'true',NULL,'10','80',NULL);
INSERT INTO `fields_meta_data` VALUES ('Opportunitiesstrategy_c','strategy_c','LBL_STRATEGY',NULL,NULL,'Opportunities','text',NULL,0,NULL,'2014-04-15 15:36:38',0,0,0,0,1,'true',NULL,'10','80',NULL);
INSERT INTO `fields_meta_data` VALUES ('Opportunitiestimeframe_c','timeframe_c','LBL_TIMEFRAME',NULL,NULL,'Opportunities','text',NULL,0,NULL,'2014-04-15 15:38:35',0,0,0,0,1,'true',NULL,'10','80',NULL);
INSERT INTO `fields_meta_data` VALUES ('ProspectListsauto_sync_reports_c','auto_sync_reports_c','LBL_AUTO_SYNC_REPORTS','Auto sync','Auto sync','ProspectLists','bool',255,0,NULL,'2017-11-28 06:52:43',0,0,0,0,1,'true',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('se_adviceadvice_engine_version_c','advice_engine_version_c','LBL_ADVICE_ENGINE_VERSION','','','se_advice','varchar',255,0,'','2014-06-20 10:12:48',0,0,0,0,1,'true','','','','');
INSERT INTO `fields_meta_data` VALUES ('se_adviceadvice_status_c','advice_status_c','LBL_ADVICE_STATUS',NULL,NULL,'se_advice','enum',100,0,NULL,'2015-02-26 06:28:09',0,0,1,0,1,'true','Advice_Status_list',NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('se_adviceadvice_type_c','advice_type_c','LBL_ADVICE_TYPE',NULL,NULL,'se_advice','enum',100,0,NULL,'2018-10-12 02:43:40',0,0,1,1,1,'true','advice_type_list',NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('se_adviceappstate_json_c','appstate_json_c','LBL_APPSTATE_JSON_C','','','se_advice','longtextarea',NULL,0,'','2014-08-07 05:33:56',0,0,0,0,1,'true','','10','150','');
INSERT INTO `fields_meta_data` VALUES ('se_adviceemail_soa_c','email_soa_c','LBL_EMAIL_SOA','','','se_advice','bool',255,0,'0','2014-08-07 05:28:59',0,0,0,0,1,'true','','','','');
INSERT INTO `fields_meta_data` VALUES ('se_adviceexecute_advice_c','execute_advice_c','LBL_EXECUTE_ADVICE','','','se_advice','bool',255,0,'0','2014-10-03 11:20:04',0,0,0,0,1,'true','','','','');
INSERT INTO `fields_meta_data` VALUES ('se_advicegenerate_soa_c','generate_soa_c','LBL_GENERATE_SOA','','','se_advice','bool',255,0,'0','2014-08-07 05:23:59',0,0,0,0,1,'true','','','','');
INSERT INTO `fields_meta_data` VALUES ('se_advicemember_id_c','member_id_c','LBL_MEMBER_ID','','','se_advice','varchar',255,0,'','2015-05-11 06:23:01',0,1,0,0,1,'false','','','','');
INSERT INTO `fields_meta_data` VALUES ('se_advicemember_name_c','member_name_c','LBL_MEMBER_NAME','','','se_advice','varchar',255,0,'','2015-05-11 06:21:42',0,1,0,0,1,'false','','','','');
INSERT INTO `fields_meta_data` VALUES ('se_advicenew_investment_risk_c','new_investment_risk_c','LBL_NEW_INVESTMENT_RISK','','','se_advice','decimal',18,0,'','2014-10-03 11:07:08',0,0,0,0,1,'true','1','','','');
INSERT INTO `fields_meta_data` VALUES ('se_adviceold_investment_risk_c','old_investment_risk_c','LBL_OLD_INVESTMENT_RISK','','','se_advice','decimal',18,0,'','2014-10-03 11:05:41',0,0,0,0,1,'true','1','','','');
INSERT INTO `fields_meta_data` VALUES ('se_advicerife_mongo_id_c','rife_mongo_id_c','LBL_RIFE_MONGO_ID',NULL,NULL,'se_advice','varchar',255,0,NULL,'2018-11-15 02:48:54',0,0,0,1,1,'true',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('se_advicesoa_content_c','soa_content_c','LBL_SOA_CONTENT',NULL,NULL,'se_advice','text',NULL,0,NULL,'2018-10-12 03:39:59',0,0,0,1,1,'true',NULL,'4','20',NULL);
INSERT INTO `fields_meta_data` VALUES ('se_advicesoa_content_hash_c','soa_content_hash_c','LBL_SOA_CONTENT_HASH',NULL,NULL,'se_advice','varchar',255,0,NULL,'2018-10-16 01:17:27',0,0,0,1,1,'true',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('SE_Documentinteractionsarticle_completed_c','article_completed_c','LBL_ARTICLE_COMPLETED','','','SE_Documentinteractions','bool',255,0,'0','2014-10-09 06:47:04',0,0,0,0,1,'true','','','','');
INSERT INTO `fields_meta_data` VALUES ('SE_Documentinteractionsdocument_name_c','document_name_c','LBL_DOCUMENT_NAME',NULL,NULL,'SE_Documentinteractions','varchar',255,0,NULL,'2019-02-25 04:58:19',0,0,0,0,1,'false',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('SE_Documentinteractionsend_page_viewed_c','end_page_viewed_c','LBL_END_PAGE_VIEWED',NULL,NULL,'SE_Documentinteractions','bool',255,0,'0','2014-10-09 06:11:17',0,0,0,0,1,'false',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('SE_Documentinteractionsend_video_viewed_c','end_video_viewed_c','LBL_END_VIDEO_VIEWED','','','SE_Documentinteractions','bool',255,0,'0','2017-08-04 01:31:33',0,0,0,1,1,'true','','','','');
INSERT INTO `fields_meta_data` VALUES ('SE_Documentinteractionsinteraction_article_id_c','interaction_article_id_c','LBL_INTERACTION_ARTICLE_ID',NULL,NULL,'SE_Documentinteractions','varchar',255,0,NULL,'2019-02-25 05:05:52',0,1,0,0,1,'false',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('SE_Documentinteractionsprocess_trigger_c','process_trigger_c','LBL_PROCESS_TRIGGER',NULL,NULL,'SE_Documentinteractions','text',NULL,0,'{}','2018-02-02 02:43:24',0,0,0,1,1,'true',NULL,'4','20',NULL);
INSERT INTO `fields_meta_data` VALUES ('SE_Documentinteractionsrevision_viewed_url_c','revision_viewed_url_c','LBL_REVISION_VIEWED_URL',NULL,NULL,'SE_Documentinteractions','url',255,0,'/#bwc/index.php?module=DocumentRevisions&action=DetailView&record={revision_viewed}','2017-09-13 05:09:11',0,0,0,1,1,'true',NULL,NULL,'1','_self');
INSERT INTO `fields_meta_data` VALUES ('SE_Documentinteractionsroutecurrent_c','routecurrent_c','LBL_ROUTECURRENT',NULL,NULL,'SE_Documentinteractions','varchar',255,0,NULL,'2015-08-06 00:54:26',0,0,0,1,1,'true',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('SE_Documentinteractionsroutefrom_c','routefrom_c','LBL_ROUTEFROM','','','SE_Documentinteractions','varchar',255,0,'','2015-08-06 00:54:51',0,0,0,1,1,'true','','','','');
INSERT INTO `fields_meta_data` VALUES ('SE_Documentinteractionsrouteto_c','routeto_c','LBL_ROUTETO','','','SE_Documentinteractions','varchar',255,0,'','2015-08-06 00:55:23',0,0,0,1,1,'true','','','','');
INSERT INTO `fields_meta_data` VALUES ('SE_Documentinteractionsslider_updated_c','slider_updated_c','LBL_SLIDER_UPDATED','','','SE_Documentinteractions','bool',255,0,'0','2014-10-02 01:43:51',0,0,0,0,1,'true','','','','');
INSERT INTO `fields_meta_data` VALUES ('SE_ExtendedContactFieldsdefinition_json_c','definition_json_c','LBL_DEFINITION_JSON',NULL,NULL,'SE_ExtendedContactFields','longtextarea',NULL,0,NULL,'2017-10-15 23:26:34',0,0,0,1,1,'true',NULL,'4','20',NULL);
INSERT INTO `fields_meta_data` VALUES ('SE_ExtendedContactValuesnumeric_value_c','numeric_value_c','LBL_NUMERIC_VALUE',NULL,NULL,'SE_ExtendedContactValues','decimal',18,0,NULL,'2017-12-13 04:53:35',0,0,0,0,1,'false','2',NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('SE_FLCompetencyResultexpired_c','expired_c','LBL_EXPIRED',NULL,NULL,'SE_FLCompetencyResult','bool',255,0,'0','2016-02-16 06:09:00',0,0,0,0,1,'false',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('SE_FLCompetencyResultexpiry_date_c','expiry_date_c','LBL_EXPIRY_DATE','','','SE_FLCompetencyResult','date',NULL,0,'','2015-12-09 13:09:05',0,0,1,1,1,'true','','','','');
INSERT INTO `fields_meta_data` VALUES ('SE_FL_Competencycompetency_id_c','competency_id_c','LBL_COMPETENCY_ID','','an integer id number','SE_FL_Competency','int',255,0,'','2016-02-18 04:26:59',0,0,0,1,1,'true','','','','');
INSERT INTO `fields_meta_data` VALUES ('SE_FL_Competencyvalidity_time_c','validity_time_c','LBL_VALIDITY_TIME',NULL,NULL,'SE_FL_Competency','int',255,0,'12','2015-12-10 04:36:12',0,0,0,1,1,'true',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('SE_Instructionsinstruction_type_c','instruction_type_c','LBL_INSTRUCTION_TYPE',NULL,NULL,'SE_Instructions','enum',100,0,NULL,'2018-05-14 03:16:12',0,0,1,1,1,'true','instructions_type_list',NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('se_InvestmentOptionsasset_alloc_au_ib_c','asset_alloc_au_ib_c','LBL_ASSET_ALLOC_AU_IB','','','se_InvestmentOptions','decimal',18,0,'0.0000','2016-01-22 12:56:57',0,0,0,1,1,'true','4','','','');
INSERT INTO `fields_meta_data` VALUES ('se_InvestmentOptionsasset_alloc_hf_c','asset_alloc_hf_c','LBL_ASSET_ALLOC_HF','','','se_InvestmentOptions','decimal',18,0,'','2016-01-22 12:53:31',0,0,0,1,1,'true','4','','','');
INSERT INTO `fields_meta_data` VALUES ('se_InvestmentOptionsasset_alloc_i_e_uh_c','asset_alloc_i_e_uh_c','LBL_ASSET_ALLOC_I_E_UH','','','se_InvestmentOptions','decimal',18,0,'','2016-01-22 12:47:00',0,0,0,1,1,'true','4','','','');
INSERT INTO `fields_meta_data` VALUES ('se_InvestmentOptionsasset_alloc_i_ib_c','asset_alloc_i_ib_c','LBL_ASSET_ALLOC_I_IB','','','se_InvestmentOptions','decimal',18,0,'0.0000','2017-02-28 04:23:30',0,0,0,1,1,'true','4','','','');
INSERT INTO `fields_meta_data` VALUES ('se_InvestmentOptionsasset_alloc_i_i_c','asset_alloc_i_i_c','LBL_ASSET_ALLOC_I_I',NULL,NULL,'se_InvestmentOptions','decimal',18,0,'0.0000','2016-01-22 12:52:58',0,0,0,1,1,'true','4',NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('se_InvestmentOptionsasset_alloc_p_c','asset_alloc_p_c','LBL_ASSET_ALLOC_P',NULL,NULL,'se_InvestmentOptions','decimal',18,0,'0.0000','2018-09-06 01:09:02',0,0,0,1,1,'true','4',NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('se_InvestmentOptionsconfidence_in_modeling_c','confidence_in_modeling_c','LBL_CONFIDENCE_IN_MODELING',NULL,NULL,'se_InvestmentOptions','decimal',18,0,NULL,'2018-08-16 02:58:34',0,0,0,1,1,'true','4',NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('se_InvestmentOptionsfee_base_c','fee_base_c','LBL_FEE_BASE','Percentage base fee',NULL,'se_InvestmentOptions','decimal',18,0,'0.000000','2018-09-06 01:37:03',0,0,0,1,1,'true','6',NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('se_InvestmentOptionsfee_borrowing_cost_c','fee_borrowing_cost_c','LBL_FEE_BORROWING_COST_C',NULL,NULL,'se_InvestmentOptions','decimal',18,0,'0.0000','2018-11-26 02:51:04',0,0,0,1,1,'true','4',NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('se_InvestmentOptionsfee_buy_spread_c','fee_buy_spread_c','LBL_FEE_BUY_SPREAD','Percentage buy spread',NULL,'se_InvestmentOptions','decimal',18,0,'0.000000','2018-09-06 02:00:23',0,0,0,1,1,'true','6',NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('se_InvestmentOptionsfee_icr_c','fee_icr_c','LBL_FEE_ICR_C',NULL,NULL,'se_InvestmentOptions','decimal',18,0,'0.000000','2018-09-06 01:24:50',0,0,0,1,1,'true','6',NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('se_InvestmentOptionsfee_investment_c','fee_investment_c','LBL_FEE_INVESTMENT_C',NULL,NULL,'se_InvestmentOptions','decimal',18,0,'0.000000','2018-09-06 01:26:48',0,0,0,1,1,'true','6',NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('se_InvestmentOptionsfee_option_rebate_c','fee_option_rebate_c','LBL_FEE_OPTION_REBATE_C',NULL,NULL,'se_InvestmentOptions','decimal',18,0,'0.000000','2018-09-20 01:23:48',0,0,0,1,1,'true','6',NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('se_InvestmentOptionsfee_perf_c','fee_perf_c','LBL_FEE_PERF','Percentage performance fee','','se_InvestmentOptions','decimal',18,0,'0.000000','2016-01-22 12:42:47',0,0,0,1,1,'true','6','','','');
INSERT INTO `fields_meta_data` VALUES ('se_InvestmentOptionsfee_sell_spread_c','fee_sell_spread_c','LBL_FEE_SELL_SPREAD','Percentage sell spread',NULL,'se_InvestmentOptions','decimal',18,0,'0.000000','2018-09-06 02:02:10',0,0,0,1,1,'true','6',NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('se_InvestmentOptionsfund_name_c','fund_name_c','LBL_FUND_NAME',NULL,NULL,'se_InvestmentOptions','varchar',255,0,NULL,'2014-11-19 04:05:38',0,0,0,0,1,'false',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('se_InvestmentOptionsglidepath_end_c','glidepath_end_c','LBL_GLIDEPATH_END','End age of the glidepath','','se_InvestmentOptions','decimal',18,0,'','2016-01-22 12:40:38',0,0,0,1,1,'true','2','','','');
INSERT INTO `fields_meta_data` VALUES ('se_InvestmentOptionsglidepath_start_c','glidepath_start_c','LBL_GLIDEPATH_START','Start age of the glidepath','','se_InvestmentOptions','decimal',18,0,'','2016-01-22 12:38:28',0,0,0,1,1,'true','2','','','');
INSERT INTO `fields_meta_data` VALUES ('se_InvestmentOptionsinvestment_option_type_c','investment_option_type_c','LBL_INVESTMENT_OPTION_TYPE',NULL,NULL,'se_InvestmentOptions','enum',100,0,NULL,'2018-08-01 03:57:10',0,0,1,1,1,'true','investment_option_type_list',NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('se_InvestmentOptionsis_default_c','is_default_c','LBL_IS_DEFAULT','When creating the guest contact for an account, the Investment Option that is ticked will be selected to create an Investment for that guest.','','se_InvestmentOptions','bool',255,0,'0','2015-12-10 23:01:22',0,0,0,1,1,'true','','','','');
INSERT INTO `fields_meta_data` VALUES ('se_InvestmentOptionsoptimal_option_c','optimal_option_c','LBL_OPTIMAL_OPTION',NULL,NULL,'se_InvestmentOptions','float',18,1,'0.0000','2017-02-16 12:11:54',0,0,0,0,1,'true','4',NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('se_InvestmentOptionsother_parameters_c','other_parameters_c','LBL_OTHER_PARAMETERS',NULL,NULL,'se_InvestmentOptions','text',NULL,0,NULL,'2017-02-16 10:35:08',0,1,0,1,1,'true',NULL,'4','20',NULL);
INSERT INTO `fields_meta_data` VALUES ('se_Investmentsassets_inv_assets_c','assets_inv_assets_c','LBL_ASSETS_INV_ASSETS',NULL,NULL,'se_Investments','currency',26,0,'0','2019-02-25 05:27:32',0,0,0,0,1,'false',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('se_Investmentsassets_primary_super_c','assets_primary_super_c','LBL_ASSETS_PRIMARY_SUPER',NULL,NULL,'se_Investments','currency',26,0,'0','2019-02-25 05:24:39',0,0,0,0,1,'false',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('se_Investmentsassets_total_other_super_c','assets_total_other_super_c','LBL_ASSETS_TOTAL_OTHER_SUPER',NULL,NULL,'se_Investments','currency',26,0,'0','2019-02-25 05:25:05',0,0,0,0,1,'false',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('se_Investmentsbase_rate','base_rate','LBL_CURRENCY_RATE','','','se_Investments','decimal',26,0,NULL,'2015-09-02 09:28:57',0,0,0,1,1,'true','','','','');
INSERT INTO `fields_meta_data` VALUES ('se_Investmentsclassification_c','classification_c','LBL_CLASSIFICATION','','','se_Investments','enum',100,0,'Assets','2014-06-19 10:38:03',0,0,1,0,1,'true','classification_list','','','');
INSERT INTO `fields_meta_data` VALUES ('se_Investmentsfund_name_c','fund_name_c','LBL_FUND_NAME',NULL,NULL,'se_Investments','varchar',255,0,NULL,'2019-02-25 05:26:13',0,0,0,0,1,'false',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('se_Investmentsliab_home_other_loans_c','liab_home_other_loans_c','LBL_LIAB_HOME_OTHER_LOANS',NULL,NULL,'se_Investments','currency',26,0,'0','2019-02-25 05:28:58',0,0,0,0,1,'false',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('se_Investmentsliab_inv_loans_c','liab_inv_loans_c','LBL_LIAB_INV_LOANS',NULL,NULL,'se_Investments','currency',26,0,'0','2019-02-25 05:28:05',0,0,0,0,1,'false',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('se_Investmentslsw_amount_c','lsw_amount_c','LBL_LSW_AMOUNT',NULL,NULL,'se_Investments','currency',26,0,'0','2019-02-25 05:29:23',0,0,0,0,1,'false',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('se_Investmentsmeta_data_c','meta_data_c','LBL_META_DATA',NULL,NULL,'se_Investments','text',NULL,0,NULL,'2017-12-14 22:14:35',0,0,0,1,1,'true',NULL,'4','20',NULL);
INSERT INTO `fields_meta_data` VALUES ('se_Investmentsother_parameters_c','other_parameters_c','LBL_OTHER_PARAMETERS','','','se_Investments','text',NULL,0,'','2016-10-12 04:00:33',0,0,0,1,1,'true','','4','20','');
INSERT INTO `fields_meta_data` VALUES ('se_Investmentssurvey_field_id_c','survey_field_id_c','LBL_SURVEY_FIELD_ID',NULL,NULL,'se_Investments','varchar',255,0,NULL,'2018-01-30 04:10:06',0,0,0,1,1,'true',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('SE_MemberAdviceTopicsscore_c','score_c','LBL_SCORE',NULL,NULL,'SE_MemberAdviceTopics','decimal',18,0,'0','2015-12-11 05:28:34',0,1,0,1,1,'true','2',NULL,'1',NULL);
INSERT INTO `fields_meta_data` VALUES ('SE_Questionnairedefinition_json_c','definition_json_c','LBL_DEFINITION_JSON',NULL,NULL,'SE_Questionnaire','longtextarea',NULL,0,NULL,'2018-01-09 00:22:05',0,0,0,1,1,'true',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('SE_Relationshipsdate_ended_c','date_ended_c','LBL_DATE_ENDED',NULL,NULL,'SE_Relationships','date',NULL,0,NULL,'2017-11-02 00:37:18',0,0,1,1,1,'true',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('SE_Relationshipsdate_started_c','date_started_c','LBL_DATE_STARTED',NULL,NULL,'SE_Relationships','date',NULL,0,NULL,'2017-11-02 00:36:36',0,0,1,1,1,'true',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('SE_Relationshipshousehold_member_type_c','household_member_type_c','LBL_HOUSEHOLD_MEMBER_TYPE',NULL,NULL,'SE_Relationships','enum',100,0,NULL,'2017-11-01 05:28:33',0,0,1,1,1,'true','household_member_type_list',NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('SE_Relationshipsrelationship_type_c','relationship_type_c','LBL_RELATIONSHIP_TYPE',NULL,NULL,'SE_Relationships','enum',100,0,NULL,'2018-03-15 07:51:50',0,0,1,1,1,'true','maritalstatus_list',NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('SE_RequiredCompetenciesrc_contact_profile_rules_c','rc_contact_profile_rules_c','LBL_RC_CONTACT_PROFILE_RULES',NULL,NULL,'SE_RequiredCompetencies','text',NULL,0,NULL,'2016-01-04 11:03:53',0,0,0,1,1,'true',NULL,'10','20',NULL);
INSERT INTO `fields_meta_data` VALUES ('SE_Segmentfeature_switches_segment_c','feature_switches_segment_c','LBL_FEATURE_SWITCHES_SEGMENT',NULL,NULL,'SE_Segment','longtextarea',NULL,0,NULL,'2018-09-16 23:33:45',0,1,0,1,1,'true',NULL,'10','40',NULL);
INSERT INTO `fields_meta_data` VALUES ('SE_Segmentprofile_prompts_segment_c','profile_prompts_segment_c','LBL_PROFILE_PROMPTS_SEGMENT',NULL,NULL,'SE_Segment','longtextarea',NULL,0,NULL,'2018-09-16 23:34:28',0,1,0,1,1,'true',NULL,'4','20',NULL);
INSERT INTO `fields_meta_data` VALUES ('SE_Segmentsteps_c_segment_c','steps_c_segment_c','LBL_STEPS_C_SEGMENT',NULL,NULL,'SE_Segment','longtextarea',NULL,0,NULL,'2018-09-16 23:35:08',0,1,0,1,1,'true',NULL,'4','20',NULL);
INSERT INTO `fields_meta_data` VALUES ('Taskschecklist_cta_label_c','checklist_cta_label_c','LBL_CHECKLIST_CTA_LABEL',NULL,NULL,'Tasks','varchar',50,0,NULL,'2017-03-28 10:57:33',0,0,0,1,1,'true',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Taskschecklist_url_c','checklist_url_c','LBL_CHECKLIST_URL','','','Tasks','url',255,0,'','2017-03-09 05:57:44',0,0,0,1,1,'true','','','','_blank');
INSERT INTO `fields_meta_data` VALUES ('Taskscompleted_description_c','completed_description_c','LBL_COMPLETED_DESCRIPTION',NULL,NULL,'Tasks','text',NULL,0,NULL,'2018-07-19 04:52:09',0,0,0,1,1,'true',NULL,'4','20',NULL);
INSERT INTO `fields_meta_data` VALUES ('Tasksphase_c','phase_c','LBL_PHASE',NULL,NULL,'Tasks','enum',100,0,NULL,'2014-04-15 15:40:04',0,0,1,0,1,'true','phase_list',NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Tasksshow_in_portal_c','show_in_portal_c','LBL_SHOW_IN_PORTAL',NULL,NULL,'Tasks','bool',255,0,'0','2017-03-09 05:59:37',0,0,0,1,1,'true',NULL,NULL,NULL,NULL);
INSERT INTO `fields_meta_data` VALUES ('Taskstheme_c','theme_c','LBL_THEME','','','Tasks','enum',100,0,NULL,'2014-04-02 11:23:05',0,0,1,0,1,'true','theme_list',NULL,NULL,'');
/*!40000 ALTER TABLE `fields_meta_data` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

