# ************************************************************
# Sequel Pro SQL dump
# Version 4541
#
# http://www.sequelpro.com/
# https://github.com/sequelpro/sequelpro
#
# Host: localhost (MySQL 5.5.5-10.4.11-MariaDB)
# Database: era_stage
# Generation Time: 2020-11-18 20:28:34 +0000
# ************************************************************


/*!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 */;
/*!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 */;

CREATE DATABASE IF NOT EXISTS `era_stage`;

# Dump of table era_stage_bpr_financial_information_0
# ------------------------------------------------------------

DROP TABLE IF EXISTS `era_stage_bpr_financial_information_0`;

CREATE TABLE `era_stage_bpr_financial_information_0` (
  `parent_id` int(11) DEFAULT NULL `field_format`='BPR.[*].parent_id',
  `parent_name` char(3) COLLATE utf8_unicode_ci DEFAULT NULL `field_format`='BPR.[*].parent_name',
  `financial_information_id` int(11) DEFAULT NULL `field_format`='BPR.[*].id',
  `transaction_handling_code` char(2) COLLATE utf8_unicode_ci DEFAULT NULL `field_format`='BPR.[*].elements.[*].e0',
  `total_act_provider_payment_amt` float(16,2) DEFAULT NULL `field_format`='BPR.[*].elements.[*].e1',
  `credit_debit_flag_code` char(1) COLLATE utf8_unicode_ci DEFAULT NULL `field_format`='BPR.[*].elements.[*].e2',
  `payment_method_code` char(3) COLLATE utf8_unicode_ci DEFAULT NULL `field_format`='BPR.[*].elements.[*].e3',
  `payment_format_code` char(10) COLLATE utf8_unicode_ci DEFAULT NULL `field_format`='BPR.[*].elements.[*].e4',
  `payer_id` char(10) COLLATE utf8_unicode_ci DEFAULT NULL `field_format`='BPR.[*].elements.[*].e9',
  `payer_supplemental_id` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL `field_format`='BPR.[*].elements.[*].e10',
  `check_eft_effective_date` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL `field_format`='BPR.[*].elements.[*].e15'
) ENGINE=CONNECT DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci `table_type`=JSON `file_name`='/Users/kunlu/Projects/BillingSquad/edi-notes/schema/sql/test/4010largeremit.ARA.parsed.json' `option_list`='limit=10000';

LOCK TABLES `era_stage_bpr_financial_information_0` WRITE;
/*!40000 ALTER TABLE `era_stage_bpr_financial_information_0` DISABLE KEYS */;

INSERT INTO `era_stage_bpr_financial_information_0` (`parent_id`, `parent_name`, `financial_information_id`, `transaction_handling_code`, `total_act_provider_payment_amt`, `credit_debit_flag_code`, `payment_method_code`, `payment_format_code`, `payer_id`, `payer_supplemental_id`, `check_eft_effective_date`)
VALUES
	(0,'ST',0,'I',25327.59,'C','ACH','CCP','1480952857','','20180129');

/*!40000 ALTER TABLE `era_stage_bpr_financial_information_0` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table era_stage_n1_entity_identification_0
# ------------------------------------------------------------

DROP TABLE IF EXISTS `era_stage_n1_entity_identification_0`;

CREATE TABLE `era_stage_n1_entity_identification_0` (
  `parent_id` int(11) DEFAULT NULL `field_format`='N1.[*].parent_id',
  `parent_name` char(3) COLLATE utf8_unicode_ci DEFAULT NULL `field_format`='N1.[*].parent_name',
  `entity_id` int(11) DEFAULT NULL `field_format`='N1.[*].id',
  `entity_id_code` char(3) COLLATE utf8_unicode_ci DEFAULT NULL `field_format`='N1.[*].elements.[*].e0',
  `entity_name` varchar(60) COLLATE utf8_unicode_ci DEFAULT NULL `field_format`='N1.[*].elements.[*].e1',
  `entity_id_code_qualifier` char(2) COLLATE utf8_unicode_ci DEFAULT NULL `field_format`='N1.[*].elements.[*].e2',
  `entity_identifier` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL `field_format`='N1.[*].elements.[*].e3',
  `entity_relationship_code` char(2) COLLATE utf8_unicode_ci DEFAULT NULL `field_format`='N1.[*].elements.[*].e4',
  `entity_legacy_id_code` char(3) COLLATE utf8_unicode_ci DEFAULT NULL `field_format`='N1.[*].elements.[*].e5'
) ENGINE=CONNECT DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci `table_type`=JSON `file_name`='/Users/kunlu/Projects/BillingSquad/edi-notes/schema/sql/test/4010largeremit.ARA.parsed.json' `option_list`='limit=10000';

LOCK TABLES `era_stage_n1_entity_identification_0` WRITE;
/*!40000 ALTER TABLE `era_stage_n1_entity_identification_0` DISABLE KEYS */;

INSERT INTO `era_stage_n1_entity_identification_0` (`parent_id`, `parent_name`, `entity_id`, `entity_id_code`, `entity_name`, `entity_id_code_qualifier`, `entity_identifier`, `entity_relationship_code`, `entity_legacy_id_code`)
VALUES
	(0,'ST',0,'PR','KS BC & BS','XV','00031','',''),
	(0,'ST',1,'PE','TOPEKA EAR NOSE & THROAT PA','FI','030464956','','');

/*!40000 ALTER TABLE `era_stage_n1_entity_identification_0` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table era_stage_trn_trace_number_0
# ------------------------------------------------------------

DROP TABLE IF EXISTS `era_stage_trn_trace_number_0`;

CREATE TABLE `era_stage_trn_trace_number_0` (
  `parent_id` int(11) DEFAULT NULL `field_format`='TRN.[*].parent_id',
  `parent_name` char(3) COLLATE utf8_unicode_ci DEFAULT NULL `field_format`='TRN.[*].parent_name',
  `trace_number_id` int(11) DEFAULT NULL `field_format`='TRN.[*].id',
  `trace_type_code` char(2) COLLATE utf8_unicode_ci DEFAULT NULL `field_format`='TRN.[*].elements.[*].e0',
  `check_eft_trace_number` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL `field_format`='TRN.[*].elements.[*].e1',
  `payer_id` char(10) COLLATE utf8_unicode_ci DEFAULT NULL `field_format`='TRN.[*].elements.[*].e2',
  `payer_supplemental_id` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL `field_format`='TRN.[*].elements.[*].e3'
) ENGINE=CONNECT DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci `table_type`=JSON `file_name`='/Users/kunlu/Projects/BillingSquad/edi-notes/schema/sql/test/4010largeremit.ARA.parsed.json' `option_list`='limit=10000';

LOCK TABLES `era_stage_trn_trace_number_0` WRITE;
/*!40000 ALTER TABLE `era_stage_trn_trace_number_0` DISABLE KEYS */;

INSERT INTO `era_stage_trn_trace_number_0` (`parent_id`, `parent_name`, `trace_number_id`, `trace_type_code`, `check_eft_trace_number`, `payer_id`, `payer_supplemental_id`)
VALUES
	(0,'ST',0,'1','0292161','1480952857','680292161');

/*!40000 ALTER TABLE `era_stage_trn_trace_number_0` ENABLE KEYS */;
UNLOCK TABLES;



/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_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 */;
