/*
 Navicat Premium Data Transfer

 Source Server         : Localhost
 Source Server Type    : MySQL
 Source Server Version : 50534
 Source Host           : localhost
 Source Database       : itrims_angular

 Target Server Type    : MySQL
 Target Server Version : 50534
 File Encoding         : utf-8

 Date: 03/06/2017 17:07:24 PM
*/

SET NAMES utf8;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `employment_verifications`
-- ----------------------------
DROP TABLE IF EXISTS `employment_verifications`;
CREATE TABLE `employment_verifications` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `order_id` mediumint(9) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  `type_id` char(1) DEFAULT NULL,
  `other_name_used` varchar(255) DEFAULT NULL,
  `fees` decimal(9,2) DEFAULT NULL,
  `is_flagged` char(1) DEFAULT NULL,
  `organization_id` mediumint(9) DEFAULT NULL,
  `contact` varchar(255) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `department` varchar(255) DEFAULT NULL,
  `street_address1` varchar(255) DEFAULT NULL,
  `street_address2` varchar(255) DEFAULT NULL,
  `city` varchar(255) DEFAULT NULL,
  `state_id` varchar(255) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `fax` varchar(255) DEFAULT NULL,
  `zip` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,

  `employment_prev_position` varchar(100) DEFAULT NULL,
  `employment_start_date` varchar(50) DEFAULT NULL,
  `employment_end_date` varchar(50) DEFAULT NULL,
  `employment_reason_for_leaving` varchar(255) DEFAULT NULL,
  `employment_salary` varchar(50) DEFAULT NULL,
  `employment_eligible_for_rehire` char(1) DEFAULT NULL,
  `employment_disciplinary_action` char(1) DEFAULT NULL,
  `employment_disciplinary_action_explanation` text DEFAULT NULL,

  `resp_employment_prev_position` varchar(100) DEFAULT NULL,
  `resp_employment_start_date` varchar(50) DEFAULT NULL,
  `resp_employment_end_date` varchar(50) DEFAULT NULL,
  `resp_employment_reason_for_leaving` varchar(255) DEFAULT NULL,
  `resp_employment_salary` varchar(50) DEFAULT NULL,
  `resp_employment_eligible_for_rehire` char(1) DEFAULT NULL,
  `resp_employment_disciplinary_action` char(1) DEFAULT NULL,
  `resp_employment_disciplinary_action_explanation` text DEFAULT NULL,

  `affiliation_position` varchar(100) DEFAULT NULL,
  `affiliation_date_on_staff` varchar(50) DEFAULT NULL,
  `affiliation_medical_staff_status` varchar(50) DEFAULT NULL,
  `affiliation_medical_staff_category` varchar(50) DEFAULT NULL,
  `affiliation_admitting_privileges` varchar(10) DEFAULT NULL COMMENT "Yes/No",
  `affiliation_in_good_standing` char(1) DEFAULT NULL,
  `affiliation_any_discipline` char(1) DEFAULT NULL,
  `affiliation_any_discipline_explanation` text DEFAULT NULL,

  `resp_affiliation_position` varchar(100) DEFAULT NULL,
  `resp_affiliation_date_on_staff` varchar(50) DEFAULT NULL,
  `resp_affiliation_medical_staff_status` varchar(50) DEFAULT NULL,
  `resp_affiliation_medical_staff_category` varchar(50) DEFAULT NULL,
  `resp_affiliation_admitting_privileges` varchar(10) DEFAULT NULL COMMENT "Yes/No",
  `resp_affiliation_in_good_standing` char(1) DEFAULT NULL,
  `resp_affiliation_any_discipline` char(1) DEFAULT NULL,
  `resp_affiliation_any_discipline_explanation` text DEFAULT NULL,

  `residency_program` varchar(100) DEFAULT NULL,
  `residency_start_date` varchar(50) DEFAULT NULL,
  `residency_end_date` varchar(50) DEFAULT NULL,
  `residency_status` varchar(255) DEFAULT NULL,
  `residency_standing` varchar(50) DEFAULT NULL,
  `residency_program_completion_date` varchar(50) DEFAULT NULL,
  `residency_unable_to_verify_explanation` text DEFAULT NULL,

  `resp_residency_program` varchar(100) DEFAULT NULL,
  `resp_residency_start_date` varchar(50) DEFAULT NULL,
  `resp_residency_end_date` varchar(50) DEFAULT NULL,
  `resp_residency_status` varchar(255) DEFAULT NULL,
  `resp_residency_standing` varchar(50) DEFAULT NULL,
  `resp_residency_program_completion_date` varchar(50) DEFAULT NULL,
  `resp_residency_unable_to_verify_explanation` text DEFAULT NULL,


  `verified_by_src` varchar(255) DEFAULT NULL,
  `verified_by_emp` varchar(255) DEFAULT NULL,
  `verified_date` varchar(255) DEFAULT NULL,
  `verification_status` varchar(255) DEFAULT NULL,
  `employee` varchar(255) DEFAULT NULL,
  `last_update` varchar(255) DEFAULT NULL,
  `added_by_recruiter` char(1) DEFAULT NULL,
  `hard_copies_required` char(1) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=26 DEFAULT CHARSET=latin1;

SET FOREIGN_KEY_CHECKS = 1;
