CREATE DATABASE  IF NOT EXISTS `fy2013` /*!40100 DEFAULT CHARACTER SET latin1 */;
USE `fy2013`;
-- MySQL dump 10.13  Distrib 5.6.13, for Win32 (x86)
--
-- Host: 127.0.0.1    Database: fy2013
-- ------------------------------------------------------
-- Server version	5.5.37

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

--
-- Table structure for table `compensation`
--

DROP TABLE IF EXISTS `compensation`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `compensation` (
  `Employee_ID` varchar(45) NOT NULL,
  `Reviewed_By_Senior` varchar(20) DEFAULT NULL,
  `Payroll_Entity` varchar(30) DEFAULT NULL,
  `Regular_Salary_` decimal(12,2) DEFAULT NULL,
  `Bonus-Incentive_` decimal(12,2) DEFAULT NULL,
  `Long_Term_Incentive_` decimal(12,2) DEFAULT NULL,
  `Payment_for_Waived_Medical_Insurance` decimal(12,2) DEFAULT NULL,
  `Beneflex_Credit_Hackley` decimal(12,2) DEFAULT NULL,
  `Payments_of_Compensation_Previously_Deferred` decimal(12,2) DEFAULT NULL,
  `Taxable_SERP_Payment` decimal(12,2) DEFAULT NULL,
  `Severance_Payments` decimal(12,2) DEFAULT NULL,
  `Tax_Gross_Ups_Paid` decimal(12,2) DEFAULT NULL,
  `PTO_Cashed_Out` decimal(12,2) DEFAULT NULL,
  `PTO_Paid_Out_Upon_Termination-Other/Special` decimal(12,2) DEFAULT NULL,
  `Personal_Use_of_Company_Car` decimal(12,2) DEFAULT NULL,
  `Car_Allowance` decimal(12,2) DEFAULT NULL,
  `Non-accountable_expenses` decimal(12,2) DEFAULT NULL,
  `Taxable_cell_phone` decimal(12,2) DEFAULT NULL,
  `Housing_Provided_by_Employer_Taxable/Exec_Commuting_Expense` decimal(12,2) DEFAULT NULL,
  `Group_Term_Life_Insurance_in_Excess_of_$50,000_Coverage` decimal(12,2) DEFAULT NULL,
  `Taxable_Moving_Expenses` decimal(12,2) DEFAULT NULL,
  `Taxable_Country_Club_Initiation_Fees/Dues` decimal(12,2) DEFAULT NULL,
  `Taxable_Gifts_Including_Gift_Cards` decimal(12,2) DEFAULT NULL,
  `Taxable_Educational_Assistance` decimal(12,2) DEFAULT NULL,
  `Companion_Travel` decimal(12,2) DEFAULT NULL,
  `Split_Dollar_Life_Insurance` decimal(12,2) DEFAULT NULL,
  `Forgiveness_of_Loan_and/or_Interest` decimal(12,2) DEFAULT NULL,
  `Short_Term_Disability_Paid_by_Third_Party` decimal(12,2) DEFAULT NULL,
  `Amounts_Includible_in_Income_Under_457b/457f_Vested` decimal(12,2) DEFAULT NULL,
  `Capital_Accum._Payouts_from_Frozen_Plan_Home_Office_Only` decimal(12,2) DEFAULT NULL,
  `Restoration_Plan_Home_Office_Only` decimal(12,2) DEFAULT NULL,
  `Executive_Benefits_Home_Office_Only` decimal(12,2) DEFAULT NULL,
  `Personal_Productivity_&_Development_A/C_Home_Office_Only` decimal(12,2) DEFAULT NULL,
  `Flexible_Spending_Account` decimal(12,2) DEFAULT NULL,
  `Benefit_Premium_Contributions` decimal(12,2) DEFAULT NULL,
  `Elective_Deferred_Compensation_Nonqualified_Plan` decimal(12,2) DEFAULT NULL,
  `Total_Per_Form_W-2,_Box_5` decimal(12,2) DEFAULT NULL,
  `Future_Severance_Payments_-_Eligible_But_Not_Yet_Paid` decimal(12,2) DEFAULT NULL,
  `Contrib._to_Defined_Benefit_Pension_does_not_incl_ER_403b_match` decimal(12,2) DEFAULT NULL,
  `Employer_403b_Match_Tax_Dept_will_obtain` decimal(12,2) DEFAULT NULL,
  `Other_Deferred_Compensation_Not_Salary_Deferred` decimal(12,2) DEFAULT NULL,
  `SERP_Credit` decimal(12,2) DEFAULT NULL,
  `Defined_Restoration_Plan_Accrual_Home_Office_Only` decimal(12,2) DEFAULT NULL,
  `Long-Term_Incentive_Plan_Accrual_Home_Office_Only` decimal(12,2) DEFAULT NULL,
  `Health_Insurance` decimal(12,2) DEFAULT NULL,
  `Dental_Insurance_` decimal(12,2) DEFAULT NULL,
  `Vision_Insurance_` decimal(12,2) DEFAULT NULL,
  `Life_Insurance_` decimal(12,2) DEFAULT NULL,
  `ST_Disability` decimal(12,2) DEFAULT NULL,
  `LT_Disability` decimal(12,2) DEFAULT NULL,
  `Long-Term_Care_Insurance` decimal(12,2) DEFAULT NULL,
  `Housing_Provided_by_the_Employer` decimal(12,2) DEFAULT NULL,
  `Educational_Assistance` decimal(12,2) DEFAULT NULL,
  `Dependent_Care_Assistance_-_Employer_paid` decimal(12,2) DEFAULT NULL,
  `Adoption_Assistance` decimal(12,2) DEFAULT NULL,
  `Supplemental_Survivor` decimal(12,2) DEFAULT NULL,
  `Variable_Universal_Life` decimal(12,2) DEFAULT NULL,
  `Pre-Tax_Contrib_to_Flexible_Spending_A/C_Health_&_Dep_Care` decimal(12,2) DEFAULT NULL,
  `Previously_Reported` decimal(12,2) DEFAULT NULL,
  `Notes` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`Employee_ID`),
  CONSTRAINT `Comp Foreign Key` FOREIGN KEY (`Employee_ID`) REFERENCES `employee_info` (`Employee ID`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `compensation`
--

LOCK TABLES `compensation` WRITE;
/*!40000 ALTER TABLE `compensation` DISABLE KEYS */;
/*!40000 ALTER TABLE `compensation` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `employee_info`
--

DROP TABLE IF EXISTS `employee_info`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `employee_info` (
  `Employee ID` varchar(45) NOT NULL,
  `Employee Name` varchar(45) DEFAULT NULL,
  `Employee Title` varchar(45) DEFAULT NULL,
  `Payroll Entity` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`Employee ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `employee_info`
--

LOCK TABLES `employee_info` WRITE;
/*!40000 ALTER TABLE `employee_info` DISABLE KEYS */;
/*!40000 ALTER TABLE `employee_info` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `part_vii_info`
--

DROP TABLE IF EXISTS `part_vii_info`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `part_vii_info` (
  `Emmployee ID` varchar(45) NOT NULL,
  `Tax Return ID` varchar(45) NOT NULL,
  `Hours Devoted` int(5) DEFAULT NULL,
  `Voting` varchar(10) DEFAULT NULL,
  `Independent` varchar(10) DEFAULT NULL,
  `Type` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`Emmployee ID`,`Tax Return ID`),
  KEY `fk 2_idx` (`Tax Return ID`),
  CONSTRAINT `fk 1` FOREIGN KEY (`Emmployee ID`) REFERENCES `employee_info` (`Employee ID`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `fk 2` FOREIGN KEY (`Tax Return ID`) REFERENCES `tax_return_names` (`Tax Return ID`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `part_vii_info`
--

LOCK TABLES `part_vii_info` WRITE;
/*!40000 ALTER TABLE `part_vii_info` DISABLE KEYS */;
/*!40000 ALTER TABLE `part_vii_info` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tax_return_names`
--

DROP TABLE IF EXISTS `tax_return_names`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tax_return_names` (
  `Tax Return ID` varchar(45) NOT NULL DEFAULT '',
  `Tax Return Name` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`Tax Return ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tax_return_names`
--

LOCK TABLES `tax_return_names` WRITE;
/*!40000 ALTER TABLE `tax_return_names` DISABLE KEYS */;
INSERT INTO `tax_return_names` VALUES ('TH-CA','Trinity Health California'),('TH-ID','Trinity Health Idaho'),('TH-Main','Trinity Health Parent');
/*!40000 ALTER TABLE `tax_return_names` 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 */;

-- Dump completed on 2014-05-24 19:50:48