-- MySQL dump 10.7
--
-- Host: 10.2.81.115    Database: unified_archive
-- ------------------------------------------------------
-- Server version	5.0.1-alpha-nt-max

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

--
-- Table structure for table `mast`
--

DROP TABLE IF EXISTS `mast`;
CREATE TABLE `mast` (
  `staff_group` varchar(4) NOT NULL default '',
  `principal` char(2) NOT NULL default '',
  `source_suffix` varchar(4) NOT NULL default '',
  `client_code` varchar(9) NOT NULL default '',
  `client_suffix` char(2) NOT NULL default '',
  `creator` varchar(8) NOT NULL default '',
  `create_date` varchar(26) NOT NULL default '',
  `charge_date` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `period_created` decimal(6,0) default NULL,
  `period_modified` decimal(6,0) default NULL,
  `hours` decimal(9,2) default NULL,
  `billing_rate_code` char(2) default NULL,
  `rate` decimal(16,3) default NULL,
  `amount` decimal(16,3) default NULL,
  `prebill_amount` decimal(16,3) default NULL,
  `discipline` char(2) default NULL,
  `description` varchar(15) default NULL,
  `bill_date` timestamp NOT NULL default '0000-00-00 00:00:00',
  `last_tsac_date` varchar(26) default NULL,
  `xfer_client_code` varchar(9) default NULL,
  `xfer_client_suffix` char(2) default NULL,
  `xfer_date` timestamp NOT NULL default '0000-00-00 00:00:00',
  `bill_id` char(3) default NULL,
  `create_status` char(1) default NULL,
  `billing_status` char(1) default NULL,
  `sort_key` char(1) default NULL,
  `hold_flag` char(1) default NULL,
  `charge_activity_date` varchar(26) default NULL,
  `modify_user` varchar(8) default NULL,
  `modify_date` varchar(26) default NULL,
  `rate_usd` decimal(16,3) default NULL,
  `amtusd` decimal(16,3) default NULL,
  `currency_code` char(3) default NULL,
  `orig_amount` decimal(16,3) default NULL,
  `orig_currency_code` char(3) default NULL,
  `prebill_amount_usd` decimal(16,3) default NULL,
  `practice_name` varchar(30) NOT NULL default '',
  `archive_period` decimal(6,0) NOT NULL default '0',
  PRIMARY KEY  (`creator`,`create_date`,`practice_name`,`archive_period`),
  KEY `idx_cc_bill_id_date` (`client_code`,`bill_date`,`bill_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `mast`
--


/*!40000 ALTER TABLE `mast` DISABLE KEYS */;
LOCK TABLES `mast` WRITE;
INSERT INTO `mast` VALUES ('0033','59','0000','0055ADV01','01','0033111','2001-01-27 13:39:53.375000','2001-01-01 00:00:00','200101','200106','0.00','','0.000','0.000','0.000','04','PREBILL','2001-01-01 00:00:00','2001-02-01 00:00:00',NULL,NULL,'2004-10-04 16:35:48','345','2','1','',NULL,'2001-01-01 00:00:00','X033111','2001-07-02 15:44:36','0.000','0.000','USD','0.000',NULL,'0.000','MKECAS','200409');
UNLOCK TABLES;
/*!40000 ALTER TABLE `mast` ENABLE KEYS */;

--
-- Table structure for table `practice`
--

DROP TABLE IF EXISTS `practice`;
CREATE TABLE `practice` (
  `practice_name` varchar(30) NOT NULL default '',
  `database_name` varchar(30) default NULL,
  `ts_version_control` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `bill_version_control` timestamp NOT NULL default '0000-00-00 00:00:00',
  `currency_code` char(3) default NULL,
  `locale_id` decimal(4,0) default NULL,
  `vat_yn` char(1) default NULL,
  `vat_percent` decimal(16,3) default NULL,
  `vat_tax_sourcesuffix` varchar(4) default NULL,
  `org_code` varchar(20) default NULL,
  `org_name` varchar(255) default NULL,
  `parent_practice` varchar(30) default NULL,
  `tax_authority` varchar(4) default NULL,
  `billing_rate_02percent` decimal(16,3) default NULL,
  `billing_rate_02descr` varchar(80) default NULL,
  `billts_workday` decimal(16,3) default NULL,
  `del_invoice_yn` char(1) default NULL,
  `pw_min_length` decimal(5,0) default NULL,
  `pw_mixed_char_req_yn` char(1) default NULL,
  `pw_aging_enabled_yn` char(1) default NULL,
  `pw_life_days` decimal(5,0) default NULL,
  `pw_warning_expiry_days` decimal(5,0) default NULL,
  `pw_warnings_after_expiration` decimal(5,0) default NULL,
  `archive_period` decimal(6,0) NOT NULL default '0',
  PRIMARY KEY  (`practice_name`,`archive_period`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `practice`
--


/*!40000 ALTER TABLE `practice` DISABLE KEYS */;
LOCK TABLES `practice` WRITE;
INSERT INTO `practice` VALUES ('MKEHLH','MKEHLH60','2003-09-30 00:00:00','2004-05-28 00:00:00','USD','1033','N',NULL,NULL,'MUSA','Milliman',NULL,'US','0.800','R&D','7.500','Y','0','N','N','0','0','0','200409'),('MKEPEN','MKEPEN60','2003-09-30 00:00:00','2004-05-28 00:00:00','USD','1033','N',NULL,NULL,'MUSA','Milliman',NULL,'US','0.800','R&D','7.500','Y','0','N','N','0','0','0','200409'),('MKELIF','MKELIF60','2003-09-30 00:00:00','2004-05-28 00:00:00','USD','1033','N',NULL,NULL,'MUSA','Milliman',NULL,'US','0.800','R&D','7.500','Y','0','N','N','0','0','0','200409'),('MKECAS','MKECAS60','2003-09-30 00:00:00','2004-05-28 00:00:00','USD','1033','N',NULL,NULL,'MUSA','Milliman',NULL,'US','0.800','R&D','7.500','Y','0','N','N','0','0','0','200409'),('SDHLH','SDHLH60','2003-09-30 00:00:00','2004-05-28 00:00:00','USD','1033','N',NULL,NULL,'MUSA','Milliman',NULL,'US','0.800','R&D','7.500','Y','0','N','N','0','0','0','200409'),('RDCAS','RDCAS60','2003-09-30 00:00:00','2004-05-28 00:00:00','USD','1033','N',NULL,NULL,'MUSA','Milliman',NULL,'US','0.800','R&D','7.500','Y','0','N','N','0','0','0','200409'),('TOKYO','TOKYO60','2003-09-30 00:00:00','2004-05-28 00:00:00','JPY','2057','N',NULL,NULL,'MUSA','Milliman',NULL,'US','0.800','R&D','8.000','Y','0','N','N','0','0','0','200409'),('HKLIF','HKLIF60','2003-09-30 00:00:00','2004-05-28 00:00:00','USD','1033','N',NULL,NULL,'MUSA','Milliman',NULL,'US','0.800','R&D','8.000','Y','0','N','N','0','0','0','200409'),('SFPEN','SFPEN60','2003-09-30 00:00:00','2004-05-28 00:00:00','USD','1033','N',NULL,NULL,'MUSA','Milliman',NULL,'US','0.800','R&D','7.500','Y','0','N','N','0','0','0','200409'),('SFCAS','SFCAS60','2003-09-30 00:00:00','2004-05-28 00:00:00','USD','1033','N',NULL,NULL,'MUSA','Milliman',NULL,'US','0.800','R&D','7.500','Y','0','N','N','0','0','0','200409'),('SFHLH','SFHLH60','2003-09-30 00:00:00','2004-05-28 00:00:00','USD','1033','N',NULL,NULL,'MUSA','Milliman',NULL,'US','0.800','R&D','7.500','Y','0','N','N','0','0','0','200409'),('SFSNL','SFSNL60','2003-09-30 00:00:00','2004-05-28 00:00:00','USD','1033','N',NULL,NULL,'MUSA','Milliman',NULL,'US','0.800','R&D','7.500','Y','0','N','N','0','0','0','200409'),('HTFLIF','HTFLIF60','2003-09-30 00:00:00','2004-05-28 00:00:00','USD','1033','N',NULL,NULL,'MUSA','Milliman',NULL,'US','0.800','R&D','7.500','Y','0','N','N','0','0','0','200409'),('HTFPEN','HTFPEN60','2003-09-30 00:00:00','2004-05-28 00:00:00','USD','1033','N',NULL,NULL,'MUSA','Milliman',NULL,'US','0.800','R&D','7.500','Y','0','N','N','0','0','0','200409'),('HTFHLH','HTFHLH60','2003-09-30 00:00:00','2004-05-28 00:00:00','USD','1033','N',NULL,NULL,'MUSA','Milliman',NULL,'US','0.800','R&D','7.500','Y','0','N','N','0','0','0','200409'),('STLPEN','STLPEN60','2003-09-30 00:00:00','2004-05-28 00:00:00','USD','1033','N',NULL,NULL,'MUSA','Milliman',NULL,'US','0.800','R&D','7.500','Y','0','N','N','0','0','0','200409'),('STLLIF','STLLIF60','2003-09-30 00:00:00','2004-05-28 00:00:00','USD','1033','N',NULL,NULL,'MUSA','Milliman',NULL,'US','0.800','R&D','7.500','Y','0','N','N','0','0','0','200409'),('STLKCI','STLKCI60','2003-09-30 00:00:00','2004-05-28 00:00:00','USD','1033','N',NULL,NULL,'MUSA','Milliman',NULL,'US','0.800','R&D','7.500','Y','0','N','N','0','0','0','200409'),('PHXLHL','PHXLHL60','2003-09-30 00:00:00','2004-05-28 00:00:00','USD','1033','N',NULL,NULL,'MUSA','Milliman',NULL,'US','0.800','R&D','7.500','Y','0','N','N','0','0','0','200409'),('INDLIF','INDLIF60','2003-09-30 00:00:00','2004-05-28 00:00:00','USD','1033','N',NULL,NULL,'MUSA','Milliman',NULL,'US','0.800','R&D','7.500','Y','0','N','N','0','0','0','200409'),('INDPEN','INDPEN60','2003-09-30 00:00:00','2004-05-28 00:00:00','USD','1033','N',NULL,NULL,'MUSA','Milliman',NULL,'US','0.800','R&D','7.500','Y','0','N','N','0','0','0','200409'),('INDHLH','INDHLH60','2003-09-30 00:00:00','2004-05-28 00:00:00','USD','1033','N',NULL,NULL,'MUSA','Milliman',NULL,'US','0.800','R&D','7.500','Y','0','N','N','0','0','0','200409'),('DENPEN','DENPEN60','2003-09-30 00:00:00','2004-05-28 00:00:00','USD','1033','N',NULL,NULL,'MUSA','Milliman',NULL,'US','0.800','R&D','8.000','Y','0','N','N','0','0','0','200409'),('DENLAT','DENLAT60','2003-09-30 00:00:00','2004-05-28 00:00:00','USD','1033','N',NULL,NULL,'MUSA','Milliman',NULL,'US','0.800','R&D','8.000','Y','0','N','N','0','0','0','200409'),('DENCAS','DENCAS60','2003-09-30 00:00:00','2004-05-28 00:00:00','USD','1033','N',NULL,NULL,'MUSA','Milliman',NULL,'US','0.800','R&D','8.000','Y','0','N','N','0','0','0','200409'),('DENHLH','DENHLH60','2003-09-30 00:00:00','2004-05-28 00:00:00','USD','1033','N',NULL,NULL,'MUSA','Milliman',NULL,'US','0.800','R&D','8.000','Y','0','N','N','0','0','0','200409'),('PTLPEN','PTLPEN60','2003-09-30 00:00:00','2004-05-28 00:00:00','USD','1033','N',NULL,NULL,'MUSA','Milliman',NULL,'US','0.800','R&D','7.500','Y','0','N','N','0','0','0','200409'),('PASCAS','PASCAS60','2003-09-30 00:00:00','2004-05-28 00:00:00','USD','1033','N',NULL,NULL,'MUSA','Milliman','PASCAS','US','0.800','R&D','7.500','Y','0','N','N','0','0','0','200409'),('PASPEN','PASPEN60','2003-09-30 00:00:00','2004-05-28 00:00:00','USD','1033','N',NULL,NULL,'MUSA','Milliman',NULL,'US','0.800','R&D','7.500','Y','0','N','N','0','0','0','200409'),('IRVMC','IRVMC60','2003-09-30 00:00:00','2004-05-28 00:00:00','USD','1033','N',NULL,NULL,'MUSA','Milliman',NULL,'US','0.800','R&D','8.000','Y','0','N','N','0','0','0','200409'),('IRVCAS','IRVCAS60','2003-09-30 00:00:00','2004-05-28 00:00:00','USD','1033','N',NULL,NULL,'MUSA','Milliman',NULL,'US','0.800','R&D','8.000','Y','0','N','N','0','0','0','200409'),('SEAHMG','SEAHMG60','2003-09-30 00:00:00','2004-05-28 00:00:00','USD','1033','N',NULL,NULL,'MUSA','Milliman',NULL,'US','0.800','R&D','7.500','Y','0','N','N','0','0','0','200409'),('SEALIF','SEALIF60','2003-09-30 00:00:00','2004-05-28 00:00:00','USD','1033','N',NULL,NULL,'MUSA','Milliman',NULL,'US','0.800','R&D','7.500','Y','0','N','N','0','0','0','200409'),('RMHEAL','RMHEAL60','2003-09-30 00:00:00','2004-05-28 00:00:00','USD','1033','N',NULL,NULL,'MUSA','Milliman',NULL,'US','0.800','R&D','7.500','Y','0','N','N','0','0','0','200409'),('PTLFUL','PTLFUL60','2003-09-30 00:00:00','2004-05-28 00:00:00','USD','1033','N',NULL,NULL,'MUSA','Milliman',NULL,'US','0.800','R&D','8.000','Y','0','N','N','0','0','0','200409'),('SEACRP','SEACRP60','2003-09-30 00:00:00','2004-05-28 00:00:00','USD','1033','N',NULL,NULL,'MUSA','Milliman',NULL,'US','0.800','R&D','7.500','Y','0','N','N','0','0','0','200409'),('CRPCOM','CRPCOM60','2003-09-30 00:00:00','2004-05-28 00:00:00','USD','1033','N',NULL,NULL,'MUSA','Milliman',NULL,'US','0.800','R&D','7.500','Y','0','N','N','0','0','0','200409'),('SEAADA','SEAADA60','2003-09-30 00:00:00','2004-05-28 00:00:00','USD','1033','N',NULL,NULL,'MUSA','Milliman',NULL,'US','0.800','R&D','7.500','Y','0','N','N','0','0','0','200409'),('SEACAS','SEACAS60','2003-09-30 00:00:00','2004-05-28 00:00:00','USD','1033','N',NULL,NULL,'MUSA','Milliman',NULL,'US','0.800','R&D','7.500','Y','0','N','N','0','0','0','200409'),('NYCAS','NYCAS60','2003-09-30 00:00:00','2004-05-28 00:00:00','USD','1033','N',NULL,NULL,'MUSA','Milliman',NULL,'US','0.800','R&D','7.500','Y','0','N','N','0','0','0','200409'),('SEAJLP','SEAJLP60','2003-09-30 00:00:00','2004-05-28 00:00:00','USD','1033','N',NULL,NULL,'MUSA','Milliman',NULL,'US','0.800','R&D','7.500','Y','0','N','N','0','0','0','200409'),('SEASYS','SEASYS60','2003-09-30 00:00:00','2004-05-28 00:00:00','USD','1033','N',NULL,NULL,'MUSA','Milliman',NULL,'US','0.800','R&D','7.500','Y','0','N','N','0','0','0','200409'),('SDHMG','SDHMG60','2003-09-30 00:00:00','2004-05-28 00:00:00','USD','1033','N',NULL,NULL,'MUSA','Milliman','SEAHMG','US','0.800','R&D','7.500','Y','0','N','N','0','0','0','200409'),('NYPEN','NYPEN60','2003-09-30 00:00:00','2004-05-28 00:00:00','USD','1033','N',NULL,NULL,'MUSA','Milliman',NULL,'US','0.800','R&D','7.500','Y','0','N','N','0','0','0','200409'),('CHITGN','CHITGN60','2003-09-30 00:00:00','2004-05-28 00:00:00','USD','1033','N',NULL,NULL,'MUSA','Milliman',NULL,'US','0.800','R&D','7.500','Y','0','N','N','0','0','0','200409'),('CHIMSA','CHIMSA60','2003-09-30 00:00:00','2004-05-28 00:00:00','USD','1033','N',NULL,NULL,'MUSA','Milliman',NULL,'US','0.800','R&D','7.500','Y','0','N','N','0','0','0','200409'),('CHIPEN','CHIPEN60','2003-09-30 00:00:00','2004-05-28 00:00:00','USD','1033','N',NULL,NULL,'MUSA','Milliman',NULL,'US','0.800','R&D','7.500','Y','0','N','N','0','0','0','200409'),('ALBPEN','ALBPEN60','2003-09-30 00:00:00','2004-05-28 00:00:00','USD','1033','N',NULL,NULL,'MUSA','Milliman',NULL,'US','0.800','R&D','8.000','Y','0','N','N','0','0','0','200409'),('NYLFHL','NYLFHL60','2003-09-30 00:00:00','2004-05-28 00:00:00','USD','1033','N',NULL,NULL,'MUSA','Milliman',NULL,'US','0.800','R&D','7.500','Y','0','N','N','0','0','0','200409'),('ALBLIF','ALBLIF60','2003-09-30 00:00:00','2004-05-28 00:00:00','USD','1033','N',NULL,NULL,'MUSA','Milliman',NULL,'US','0.800','R&D','8.000','Y','0','N','N','0','0','0','200409'),('BOSCAS','BOSCAS60','2003-09-30 00:00:00','2004-05-28 00:00:00','USD','1033','N',NULL,NULL,'MUSA','Milliman',NULL,'US','0.800','R&D','7.500','Y','0','N','N','0','0','0','200409'),('BOSLIF','BOSLIF60','2003-09-30 00:00:00','2004-05-28 00:00:00','USD','1033','N',NULL,NULL,'MUSA','Milliman',NULL,'US','0.800','R&D','7.500','Y','0','N','N','0','0','0','200409'),('MELDB','MELDB60','2003-09-30 00:00:00','2004-05-28 00:00:00','USD','1033','N',NULL,NULL,'MUSA','Milliman','NYPEN','US','0.800','R&D','7.500','Y','0','N','N','0','0','0','200409'),('MELDC','MELDC60','2003-09-30 00:00:00','2004-05-28 00:00:00','USD','1033','N',NULL,NULL,'MUSA','Milliman',NULL,'US','0.800','R&D',NULL,'Y','0','N','N','0','0','0','200409'),('NYECON','NYECON60','2003-09-30 00:00:00','2004-05-28 00:00:00','USD','1033','N',NULL,NULL,'MUSA','Milliman',NULL,'US','0.800','R&D',NULL,'Y','0','N','N','0','0','0','200409'),('NJDC','NJDC60','2003-09-30 00:00:00','2004-05-28 00:00:00','USD','1033','N',NULL,NULL,'MUSA','Milliman',NULL,'US','0.800','R&D',NULL,'Y','0','N','N','0','0','0','200409'),('NJPEN','NJPEN60','2003-09-30 00:00:00','2004-05-28 00:00:00','USD','1033','N',NULL,NULL,'MUSA','Milliman',NULL,'US','0.800','R&D',NULL,'Y','0','N','N','0','0','0','200409'),('RDPEN','RDPEN60','2003-09-30 00:00:00','2004-05-28 00:00:00','USD','1033','N',NULL,NULL,'MUSA','Milliman',NULL,'US','0.800','R&D',NULL,'Y','0','N','N','0','0','0','200409'),('CHIREI','CHIREI60','2003-09-30 00:00:00','2004-05-28 00:00:00','USD','1033','N',NULL,NULL,'MUSA','Milliman',NULL,'US','0.800','R&D',NULL,'Y','0','N','N','0','0','0','200409'),('PHLINV','PHLINV60','2003-09-30 00:00:00','2004-05-28 00:00:00','USD','1033','N',NULL,NULL,'MUSA','Milliman',NULL,'US','0.800','R&D',NULL,'Y','0','N','N','0','0','0','200409'),('CHICAS','CHICAS60','2003-09-30 00:00:00','2004-05-28 00:00:00','USD','1033','N',NULL,NULL,'MUSA','Milliman',NULL,'US','0.800','R&D',NULL,'Y','0','N','N','0','0','0','200409'),('RDLIF','RDLIF60','2003-09-30 00:00:00','2004-05-28 00:00:00','USD','1033','N',NULL,NULL,'MUSA','Milliman',NULL,'US','0.800','R&D',NULL,'Y','0','N','N','0','0','0','200409'),('RDHLH','RDHLH60','2003-09-30 00:00:00','2004-05-28 00:00:00','USD','1033','N',NULL,NULL,'MUSA','Milliman',NULL,'US','0.800','R&D',NULL,'Y','0','N','N','0','0','0','200409'),('WARDC','WARDC60','2003-09-30 00:00:00','2004-05-28 00:00:00','USD','1033','N',NULL,NULL,'MUSA','Milliman',NULL,'US','0.800','R&D',NULL,'Y','0','N','N','0','0','0','200409'),('CHILIF','CHILIF60','2003-09-30 00:00:00','2004-05-28 00:00:00','USD','1033','N',NULL,NULL,'MUSA','Milliman',NULL,'US','0.800','R&D',NULL,'Y','0','N','N','0','0','0','200409'),('SALTLK','SALTLK60','2003-09-30 00:00:00','2004-05-28 00:00:00','USD','1033','N',NULL,NULL,'MUSA','Milliman',NULL,'US','0.800','R&D',NULL,'Y','0','N','N','0','0','0','200409'),('NYMLLR','NYMLLR60','2003-09-30 00:00:00','2004-05-28 00:00:00','USD','1033','N',NULL,NULL,'MUSA','Milliman',NULL,'US','0.800','R&D',NULL,'Y','0','N','N','0','0','0','200409'),('MANCAS','MANCAS60','2003-09-30 00:00:00','2004-05-28 00:00:00','USD','1033','N',NULL,NULL,'MUSA','Milliman','BOSCAS','US','0.800','R&D',NULL,'Y','0','N','N','0','0','0','200409'),('COLHLH','COLHLH60','2003-09-30 00:00:00','2004-05-28 00:00:00','USD','1033','N',NULL,NULL,'MUSA','Milliman',NULL,'US','0.800','R&D',NULL,'Y','0','N','N','0','0','0','200409'),('BLKLNG','BLKLNG60','2003-09-30 00:00:00','2004-05-28 00:00:00','USD','1033','N',NULL,NULL,'MUSA','Milliman',NULL,'US','0.800','R&D',NULL,'Y','0','N','N','0','0','0','200409'),('MAHLH','MAHLH60','2003-09-30 00:00:00','2004-05-28 00:00:00','USD','1033','N',NULL,NULL,'MUSA','Milliman',NULL,'US','0.800','R&D',NULL,'Y','0','N','N','0','0','0','200409'),('COLCIT','COLCIT60','2003-09-30 00:00:00','2004-05-28 00:00:00','USD','1033','N',NULL,NULL,'MUSA','Milliman',NULL,'US','0.800','R&D',NULL,'Y','0','N','N','0','0','0','200409'),('MINHLH','MINHLH60','2003-09-30 00:00:00','2004-05-28 00:00:00','USD','1033','N',NULL,NULL,'MUSA','Milliman',NULL,'US','0.800','R&D','8.000','Y','0','N','N','0','0','0','200409'),('MINLIF','MINLIF60','2003-09-30 00:00:00','2004-05-28 00:00:00','USD','1033','N',NULL,NULL,'MUSA','Milliman',NULL,'US','0.800','R&D','8.000','Y','0','N','N','0','0','0','200409'),('MINPEN','MINPEN60','2003-09-30 00:00:00','2004-05-28 00:00:00','USD','1033','N',NULL,NULL,'MUSA','Milliman',NULL,'US','0.800','R&D','8.000','Y','0','N','N','0','0','0','200409'),('AUSHLH','AUSHLH60','2003-09-30 00:00:00','2004-05-28 00:00:00','USD','1033','N',NULL,NULL,'MUSA','Milliman',NULL,'US','0.800','R&D','8.000','Y','0','N','N','0','0','0','200409'),('BOISE','BOISE60','2003-09-30 00:00:00','2004-05-28 00:00:00','USD','1033','N',NULL,NULL,'MUSA','Milliman','SEAPEN','US','0.800','R&D','8.000','Y','0','N','N','0','0','0','200409'),('BENCOM','BENCOM60','2003-09-30 00:00:00','2004-05-28 00:00:00','USD','1033','N',NULL,NULL,'MUSA','Milliman',NULL,'US','0.800','R&D','7.500','Y','0','N','N','0','0','0','200409'),('SEACMP','SEACMP60','2003-09-30 00:00:00','2004-05-28 00:00:00','USD','1033','N',NULL,NULL,'MUSA','Milliman',NULL,'US','0.800','R&D','7.500','Y','0','N','N','0','0','0','200409'),('SEADC','SEADC60','2003-09-30 00:00:00','2004-05-28 00:00:00','USD','1033','N',NULL,NULL,'MUSA','Milliman',NULL,'US','0.800','R&D','7.500','Y','0','N','N','0','0','0','200409'),('SEAHLH','SEAHLH60','2003-09-30 00:00:00','2004-05-28 00:00:00','USD','1033','N',NULL,NULL,'MUSA','Milliman',NULL,'US','0.800','R&D','7.500','Y','0','N','N','0','0','0','200409'),('SEAITC','SEAITC60','2003-09-30 00:00:00','2004-05-28 00:00:00','USD','1033','N',NULL,NULL,'MUSA','Milliman',NULL,'US','0.800','R&D','7.500','Y','0','N','N','0','0','0','200409'),('SEAPEN','SEAPEN60','2003-09-30 00:00:00','2004-05-28 00:00:00','USD','1033','N',NULL,NULL,'MUSA','Milliman',NULL,'US','0.800','R&D','7.500','Y','0','N','N','0','0','0','200409'),('CHICAP','CHICAP60','2003-09-30 00:00:00','2004-05-28 00:00:00','USD','1033','N',NULL,NULL,'MUSA','Milliman',NULL,'US','0.800','R&D','7.500','Y','0','N','N','0','0','0','200409'),('ATLCAS','ATLCAS60','2003-09-30 00:00:00','2004-05-28 00:00:00','USD','1033','N',NULL,NULL,'MUSA','Milliman','GRVCAS','US','0.800','R&D','7.500','Y','0','N','N','0','0','0','200409'),('ATLHLH','ATLHLH60','2003-09-30 00:00:00','2004-05-28 00:00:00','USD','1033','N',NULL,NULL,'MUSA','Milliman',NULL,'US','0.800','R&D','7.500','Y','0','N','N','0','0','0','200409'),('ATLLIF','ATLLIF60','2003-09-30 00:00:00','2004-05-28 00:00:00','USD','1033','N',NULL,NULL,'MUSA','Milliman',NULL,'US','0.800','R&D','7.500','Y','0','N','N','0','0','0','200409'),('ATLPEN','ATLPEN60','2003-09-30 00:00:00','2004-05-28 00:00:00','USD','1033','N',NULL,NULL,'MUSA','Milliman',NULL,'US','0.800','R&D','7.500','Y','0','N','N','0','0','0','200409'),('GRVCAS','GRVCAS60','2003-09-30 00:00:00','2004-05-28 00:00:00','USD','1033','N',NULL,NULL,'MUSA','Milliman',NULL,'US','0.800','R&D','7.500','Y','0','N','N','0','0','0','200409'),('TAMPA','TAMPA60','2003-09-30 00:00:00','2004-05-28 00:00:00','USD','1033','N',NULL,NULL,'MUSA','Milliman',NULL,'US','0.800','R&D','7.500','Y','0','N','N','0','0','0','200409'),('TAMPIH','TAMPIH60','2003-09-30 00:00:00','2004-05-28 00:00:00','USD','1033','N',NULL,NULL,'MUSA','Milliman',NULL,'US','0.800','R&D','7.500','Y','0','N','N','0','0','0','200409'),('PTMHLH','PTMHLH60','2003-09-30 00:00:00','2004-05-28 00:00:00','USD','1033','N',NULL,NULL,'MUSA','Milliman','MAHLH','US','0.800','R&D','7.500','Y','0','N','N','0','0','0','200409'),('BERMUD','BERMUD60','2003-09-30 00:00:00','2004-05-28 00:00:00','USD','1033','N',NULL,NULL,'MUSA','Milliman',NULL,'US','0.800','R&D','7.500','Y','0','N','N','0','0','0','200409'),('DLSCAS','DLSCAS60','2003-09-30 00:00:00','2004-05-28 00:00:00','USD','1033','N',NULL,NULL,'MUSA','Milliman',NULL,'US','0.800','R&D','8.000','Y','0','N','N','0','0','0','200409'),('DLSDLT','DLSDLT60','2003-09-30 00:00:00','2004-05-28 00:00:00','USD','1033','N',NULL,NULL,'MUSA','Milliman',NULL,'US','0.800','R&D',NULL,'Y','0','N','N','0','0','0','200409'),('DLSDLW','DLSDLW60','2003-09-30 00:00:00','2004-05-28 00:00:00','USD','1033','N',NULL,NULL,'MUSA','Milliman',NULL,'US','0.800','R&D',NULL,'Y','0','N','N','0','0','0','200409'),('DLSLIF','DLSLIF60','2003-09-30 00:00:00','2004-05-28 00:00:00','USD','1033','N',NULL,NULL,'MUSA','Milliman',NULL,'US','0.800','R&D',NULL,'Y','0','N','N','0','0','0','200409'),('DLSPEN','DLSPEN60','2003-09-30 00:00:00','2004-05-28 00:00:00','USD','1033','N',NULL,NULL,'MUSA','Milliman',NULL,'US','0.800','R&D',NULL,'Y','0','N','N','0','0','0','200409'),('HOUHLH','HOUHLH60','2003-09-30 00:00:00','2004-05-28 00:00:00','USD','1033','N',NULL,NULL,'MUSA','Milliman',NULL,'US','0.800','R&D','7.500','Y','0','N','N','0','0','0','200409'),('HOUPEN','HOUPEN60','2003-09-30 00:00:00','2004-05-28 00:00:00','USD','1033','N',NULL,NULL,'MUSA','Milliman',NULL,'US','0.800','R&D','7.500','Y','0','N','N','0','0','0','200409'),('HOURAL','HOURAL60','2003-09-30 00:00:00','2004-05-28 00:00:00','USD','1033','N',NULL,NULL,'MUSA','Milliman',NULL,'US','0.800','R&D','7.500','Y','0','N','N','0','0','0','200409'),('OMAHLH','OMAHLH60','2003-09-30 00:00:00','2004-05-28 00:00:00','USD','1033','N',NULL,NULL,'MUSA','Milliman',NULL,'US','0.800','R&D','7.500','Y','0','N','N','0','0','0','200409'),('OMALIF','OMALIF60','2003-09-30 00:00:00','2004-05-28 00:00:00','USD','1033','N',NULL,NULL,'MUSA','Milliman',NULL,'US','0.800','R&D','7.500','Y','0','N','N','0','0','0','200409'),('OMAPEN','OMAPEN60','2003-09-30 00:00:00','2004-05-28 00:00:00','USD','1033','N',NULL,NULL,'MUSA','Milliman',NULL,'US','0.800','R&D','7.500','Y','0','N','N','0','0','0','200409'),('PHLCAS','PHLCAS60','2003-09-30 00:00:00','2004-05-28 00:00:00','USD','1033','N',NULL,NULL,'MUSA','Milliman',NULL,'US','0.800','R&D','7.500','Y','0','N','N','0','0','0','200409'),('PHLHLH','PHLHLH60','2003-09-30 00:00:00','2004-05-28 00:00:00','USD','1033','N',NULL,NULL,'MUSA','Milliman',NULL,'US','0.800','R&D','7.500','Y','0','N','N','0','0','0','200409'),('PHLJPC','PHLJPC60','2003-09-30 00:00:00','2004-05-28 00:00:00','USD','1033','N',NULL,NULL,'MUSA','Milliman',NULL,'US','0.800','R&D','7.500','Y','0','N','N','0','0','0','200409'),('PHLLIF','PHLLIF60','2003-09-30 00:00:00','2004-05-28 00:00:00','USD','1033','N',NULL,NULL,'MUSA','Milliman',NULL,'US','0.800','R&D','7.500','Y','0','N','N','0','0','0','200409'),('PHLPEN','PHLPEN60','2003-09-30 00:00:00','2004-05-28 00:00:00','USD','1033','N',NULL,NULL,'MUSA','Milliman',NULL,'US','0.800','R&D','7.500','Y','0','N','N','0','0','0','200409'),('PHLDR','PHLDR60','2003-09-30 00:00:00','2004-05-28 00:00:00','USD','1033','N',NULL,NULL,'MUSA','Milliman',NULL,'US','0.800','R&D','7.500','Y','0','N','N','0','0','0','200409'),('PHLPAD','PHLPAD60','2003-09-30 00:00:00','2004-05-28 00:00:00','USD','1033','N',NULL,NULL,'MUSA','Milliman',NULL,'US','0.800','R&D','7.500','Y','0','N','N','0','0','0','200409'),('WDCRES','WDCRES60','2003-09-30 00:00:00','2004-05-28 00:00:00','USD','1033','N',NULL,NULL,'MUSA','Milliman',NULL,'US','0.800','R&D','7.500','Y','0','N','N','0','0','0','200409'),('WDCPEN','WDCPEN60','2003-09-30 00:00:00','2004-05-28 00:00:00','USD','1033','N',NULL,NULL,'MUSA','Milliman',NULL,'US','0.800','R&D','7.500','Y','0','N','N','0','0','0','200409'),('SEAJNT','SEAJNT60','2003-09-30 00:00:00','2004-05-28 00:00:00','USD','1033','N',NULL,NULL,'MUSA','Milliman',NULL,'US','0.800','R&D','7.500','Y','0','N','N','0','0','0','200409'),('DESPEN','DESPEN60','2003-10-30 00:00:00','2004-05-29 00:00:00','USD','1033','N',NULL,NULL,'MUSA','Milliman','DLSPEN','US','0.800','R&D','8.000','Y','0','N','N','0','0','0','200409'),('SFINVC','SFINVC60','2003-09-30 00:00:00','2004-05-28 00:00:00','USD','1033','N',NULL,NULL,'MUSA','Milliman',NULL,'US','0.800','R&D','7.500','Y','0','N','N','0','0','0','200409'),('ATLCIT','ATLCIT60','2003-09-30 00:00:00','2004-05-28 00:00:00','USD','1033','N',NULL,NULL,'MUSA','Milliman','COLCIT','US','0.800','R&D','7.500','Y','0','N','N','0','0','0','200409'),('SEACIT','SEACIT60','2003-09-30 00:00:00','2004-05-28 00:00:00','USD','1033','N',NULL,NULL,'MUSA','Milliman','COLCIT','US','0.800','R&D','7.500','Y','0','N','N','0','0','0','200409'),('NYNIT','NYNIT60','2003-09-30 00:00:00','2004-05-28 00:00:00','USD','1033','N',NULL,NULL,'MUSA','Milliman',NULL,'US','0.800','R&D','7.500','Y','0','N','N','0','0','0','200409'),('SEANIT','SEANIT60','2003-09-30 00:00:00','2004-05-28 00:00:00','USD','1033','N',NULL,NULL,'MUSA','Milliman','NYNIT','US','0.800','R&D','7.500','Y','0','N','N','0','0','0','200409'),('BZLLIF','BZLLIF60','2003-09-30 00:00:00','2004-05-28 00:00:00','USD','3082','N',NULL,NULL,'MUSA','Milliman',NULL,'US','0.800','R&D','7.500','Y','0','N','N','0','0','0','200409'),('UKLIF','UKLIF60','2003-09-30 00:00:00','2004-05-28 00:00:00','GBP','2057','Y','17.500','2800','MUSA','Milliman',NULL,'INTL','0.800','R&D','7.000','Y','0','N','N','0','0','0','200409'),('TOKUSD','TOKUSD60','2003-09-30 00:00:00','2004-05-28 00:00:00','USD','1033','N',NULL,NULL,'MUSA','Milliman',NULL,'US','0.800','R&D','7.500','Y','0','N','N','0','0','0','200409'),('CHICCD','CHICCD60','2003-09-30 00:00:00','2004-05-28 00:00:00','USD','1033','N',NULL,NULL,'MUSA','Milliman',NULL,'US','0.800','R&D','7.500','Y','0','N','N','0','0','0','200409'),('ATLAST','ATLAST60','2003-09-30 00:00:00','2004-05-28 00:00:00','USD','1033','N',NULL,NULL,'MUSA','Milliman',NULL,'US','0.800','R&D','7.500','Y','0','N','N','0','0','0','200409'),('CHICPL','CHICPL60','2003-09-30 00:00:00','2004-05-28 00:00:00','USD','1033','N',NULL,NULL,'MUSA','Milliman',NULL,'US','0.800','R&D','7.500','Y','0','N','N','0','0','0','200409'),('PHLCPL','PHLCPL60','2003-09-30 00:00:00','2004-05-28 00:00:00','USD','1033','N',NULL,NULL,'MUSA','Milliman','CHICPL','US','0.800','R&D','7.500','Y','0','N','N','0','0','0','200409'),('ATLPNC','ATLPNC60','2003-09-30 00:00:00','2004-05-28 00:00:00','USD','1033','N',NULL,NULL,'MUSA','Milliman',NULL,'US','0.800','R&D','7.500','Y','0','N','N','0','0','0','200409'),('HTFTRI','HTFTRI60','2003-09-30 00:00:00','2004-05-28 00:00:00','USD','1033','N',NULL,NULL,'MUSA','Milliman',NULL,'US','0.800','R&D','7.500','Y','0','N','N','0','0','0','200409'),('BZLLFR','BZLLFR60','2003-09-30 00:00:00','2004-05-28 00:00:00','BRL','3082','N',NULL,NULL,'MUSA','Milliman',NULL,'US','0.800','R&D','7.500','Y','0','N','N','0','0','0','200409'),('PRNCAS','PRNCAS60','2003-09-30 00:00:00','2004-05-28 00:00:00','USD','1033','N',NULL,NULL,'MUSA','Milliman',NULL,'US','0.800','R&D','7.500','Y','0','N','N','0','0','0','200409'),('NORINV','NORINV60','2003-09-30 00:00:00','2004-05-28 00:00:00','USD','1033','N',NULL,NULL,'MUSA','Milliman',NULL,'US','0.800','R&D','7.000','Y','0','N','N','0','0','0','200409'),('DENHAW','DENHAW60','2003-09-30 00:00:00','2004-05-28 00:00:00','USD','1033','N',NULL,NULL,'MUSA','Milliman',NULL,'US','0.800','R&D','8.000','Y','0','N','N','0','0','0','200409'),('ATLAIT','ATLAIT60','2003-09-30 00:00:00','2004-05-28 00:00:00','USD','1033','N',NULL,NULL,'MUSA','Milliman',NULL,'US','0.800','R&D','7.500','Y','0','N','N','0','0','0','200409'),('SEAAIT','SEAAIT60','2003-09-30 00:00:00','2004-05-28 00:00:00','USD','1033','N',NULL,NULL,'MUSA','Milliman','ATLAIT','US','0.800','R&D','7.500','Y','0','N','N','0','0','0','200409'),('MEXSAL','MEXSAL60','2003-09-30 00:00:00','2004-05-28 00:00:00','MXN','2058','N',NULL,NULL,'MUSA','Milliman',NULL,'INTL','0.800','R&D','7.500','Y','0','N','N','0','0','0','200409'),('FASFOC','FASFOC60','2003-09-30 00:00:00','2004-05-28 00:00:00','USD','1033','N',NULL,NULL,'MUSA','Milliman',NULL,'US','0.800','R&D','7.500','Y','0','N','N','0','0','0','200409'),('LONLIF','LONLIF60','2003-09-30 00:00:00','2004-05-28 00:00:00','EUR','2057','N',NULL,NULL,'MUSA','Milliman',NULL,'INTL','0.800','R&D','7.000','Y','0','N','N','0','0','0','200409'),('PARLIF','PARLIF60','2003-09-30 00:00:00','2004-05-28 00:00:00','EUR','1036','N',NULL,NULL,'MUSA','Milliman',NULL,'INTL','0.800','R&D','7.000','Y','0','N','N','0','0','0','200409'),('MDRLIF','MDRLIF60','2003-09-30 00:00:00','2004-05-28 00:00:00','EUR','3082','N',NULL,NULL,'MUSA','Milliman',NULL,'INTL','0.800','R&D','7.000','Y','0','N','N','0','0','0','200409'),('MLNLIF','MLNLIF670','2003-09-30 00:00:00','2004-05-28 00:00:00','EUR','1040','N',NULL,NULL,'MUSA','Milliman',NULL,'INTL','0.800','R&D','7.000','Y','0','N','N','0','0','0','200409'),('DLSBRC','DLSBRC60','2003-09-30 00:00:00','2004-05-28 00:00:00','USD','1033','N',NULL,NULL,'MUSA','Milliman',NULL,'US','0.800','R&D','8.000','Y','0','N','N','0','0','0','200409'),('CHIYEN','CHIYEN60','2003-09-30 00:00:00','2004-05-28 00:00:00','JPY','1033','N',NULL,NULL,'MUSA','Milliman',NULL,'US','0.800','R&D',NULL,'Y','0','N','N','0','0','0','200409'),('MKEMIT','MKEMIT60','2003-09-30 00:00:00','2004-05-28 00:00:00','USD','1033','N',NULL,NULL,'MUSA','Milliman',NULL,'US','0.800','R&D','7.500','Y','0','N','N','0','0','0','200409'),('HTFHJP','HTFHJP60','2003-09-30 00:00:00','2004-05-28 00:00:00','USD','1033','N',NULL,NULL,'MUSA','Milliman',NULL,'US','0.800','R&D','7.500','Y','0','N','N','0','0','0','200409');
UNLOCK TABLES;
/*!40000 ALTER TABLE `practice` ENABLE KEYS */;

--
-- Table structure for table `practice_client`
--

DROP TABLE IF EXISTS `practice_client`;
CREATE TABLE `practice_client` (
  `practice_name` varchar(30) NOT NULL default '',
  `client_center` varchar(4) NOT NULL default '',
  `creator` varchar(8) default NULL,
  `create_date` varchar(26) default NULL,
  `modify_user` varchar(8) default NULL,
  `modify_date` varchar(26) default NULL,
  `archive_period` decimal(6,0) NOT NULL default '0',
  PRIMARY KEY  (`practice_name`,`client_center`,`archive_period`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `practice_client`
--


/*!40000 ALTER TABLE `practice_client` DISABLE KEYS */;
LOCK TABLES `practice_client` WRITE;
INSERT INTO `practice_client` VALUES ('NJPEN','0140','NYCONV','2002-02-15 11:19:50.718000',NULL,NULL,'200409'),('NJPEN','0335','NYCONV','2002-02-15 11:19:50.734000',NULL,NULL,'200409'),('CHITGN','0166','SID','2000-11-03 00:00:00.000000','SID','2000-11-03 00:00:00.000000','200409'),('CHITGN','0089','SID','2000-11-03 00:00:00.000000','SID','2000-11-03 00:00:00.000000','200409'),('CHIMSA','0091','SID','2000-11-03 00:00:00.000000','SID','2000-11-03 00:00:00.000000','200409'),('CHIPEN','0094','SID','2000-11-03 00:00:00.000000','SID','2000-11-03 00:00:00.000000','200409'),('ALBPEN','0152','SID','2000-11-03 00:00:00.000000',NULL,NULL,'200409'),('NYLFHL','0028','SID','2000-11-05 00:00:00.000000',NULL,'2000-11-05 00:00:00.000000','200409'),('NYLFHL','0050','SID','2000-11-05 00:00:00.000000',NULL,'2000-11-05 00:00:00.000000','200409'),('ALBLIF','0081','SID','2000-11-05 00:00:00.000000',NULL,NULL,'200409'),('ALBLIF','0090','SID','2000-11-05 00:00:00.000000',NULL,NULL,'200409'),('BOSCAS','0157','SID','2000-11-05 00:00:00.000000',NULL,NULL,'200409'),('BOSCAS','0147','SID','2000-11-05 00:00:00.000000',NULL,NULL,'200409'),('BOSCAS','0115','SID','2000-11-05 00:00:00.000000',NULL,NULL,'200409'),('BOSLIF','0141','SID','2000-11-06 00:00:00.000000',NULL,NULL,'200409'),('BOSLIF','0191','SID','2000-11-06 00:00:00.000000',NULL,NULL,'200409'),('NYPEN','0056','NYCONV','2002-02-15 11:19:50.734000',NULL,NULL,'200409'),('NYPEN','0057','NYCONV','2002-02-15 11:19:50.750000',NULL,NULL,'200409'),('NYECON','0125','SID','2000-11-12 00:00:00.000000',NULL,NULL,'200409'),('MKEPEN','0038','SID','2000-12-29 00:00:00.000000',NULL,NULL,'200409'),('ATLCAS','0134','SID','2001-04-08 12:18:00.000000',NULL,NULL,'200409'),('DESPEN','0082','SID','2002-08-01 00:00:00.000000',NULL,NULL,'200409'),('CHICAS','0126','SID','2000-11-15 00:00:00.000000',NULL,NULL,'200409'),('RDLIF','0931','SID','2000-11-15 00:00:00.000000',NULL,'2000-11-15 00:00:00.000000','200409'),('RDHLH','0932','SID','2000-11-15 00:00:00.000000',NULL,'2000-11-15 00:00:00.000000','200409'),('CHILIF','0017','SID','2000-11-03 00:00:00.000000',NULL,'2000-11-03 00:00:00.000000','200409'),('CHILIF','0101','SID','2000-11-03 00:00:00.000000',NULL,'2000-11-03 00:00:00.000000','200409'),('CHILIF','0118','SID','2000-11-03 00:00:00.000000',NULL,'2000-11-03 00:00:00.000000','200409'),('CHILIF','0146','SID','2000-11-03 00:00:00.000000',NULL,'2000-11-03 00:00:00.000000','200409'),('SALTLK','0175','SID','2000-11-15 00:00:00.000000',NULL,NULL,'200409'),('SALTLK','0149','SID','2000-11-15 00:00:00.000000',NULL,NULL,'200409'),('SALTLK','0148','SID','2000-11-15 00:00:00.000000',NULL,NULL,'200409'),('NYPEN','0099','NYCONV','2002-02-15 11:19:50.765000',NULL,NULL,'200409'),('CHILIF','0047','SID','2000-11-27 00:00:00.000000',NULL,NULL,'200409'),('NYCAS','0010','SID','2000-11-02 00:00:00.000000',NULL,'2000-11-02 00:00:00.000000','200409'),('NYCAS','0015','SID','2000-11-02 00:00:00.000000',NULL,'2000-11-02 00:00:00.000000','200409'),('NYPEN','0140','NYCONV','2002-02-15 11:19:50.781000',NULL,NULL,'200409'),('BLKLNG','0079','SID','2001-01-23 00:00:00.000000',NULL,'2001-01-23 00:00:00.000000','200409'),('HTFLIF','0114','SID','2001-01-21 00:00:00.000000',NULL,NULL,'200409'),('SEAHMG','0280','SID','2001-03-15 00:00:00.000000',NULL,NULL,'200409'),('ATLLIF','0084','SID','2001-04-08 12:18:00.000000',NULL,NULL,'200409'),('ATLPEN','0013','SID','2001-04-08 12:18:00.000000',NULL,NULL,'200409'),('ATLHLH','0007','SID','2001-04-08 12:18:00.000000',NULL,NULL,'200409'),('GRVCAS','0134','SID','2001-04-08 12:18:00.000000',NULL,NULL,'200409'),('SEAITC','0004','SID','2001-04-16 00:00:00.000000',NULL,NULL,'200409'),('SEAITC','0305','SID','2001-04-08 00:00:00.000000',NULL,NULL,'200409'),('SEAPEN','0119','SID','2001-04-08 00:00:00.000000',NULL,NULL,'200409'),('SEAPEN','0075','SID','2001-04-08 00:00:00.000000',NULL,NULL,'200409'),('SEAPEN','0153','SID','2001-04-08 00:00:00.000000',NULL,NULL,'200409'),('SEACMP','0127','SID','2001-04-08 00:00:00.000000',NULL,NULL,'200409'),('SEADC','0033','SID','2001-04-08 00:00:00.000000',NULL,NULL,'200409'),('BENCOM','0110','SID','2001-04-08 00:00:00.000000',NULL,NULL,'200409'),('SEAPEN','0012','SID','2001-04-08 00:00:00.000000',NULL,NULL,'200409'),('SEAITC','0303','SID','2001-04-08 00:00:00.000000',NULL,NULL,'200409'),('SEAPEN','0003','SID','2001-04-08 00:00:00.000000',NULL,NULL,'200409'),('SEAPEN','0014','SID','2001-04-08 00:00:00.000000',NULL,NULL,'200409'),('TAMPIH','0130','SID','2001-04-08 00:00:00.000000',NULL,NULL,'200409'),('SEAPEN','0077','SID','2001-04-08 00:00:00.000000',NULL,NULL,'200409'),('SEAITC','0302','SID','2001-04-08 00:00:00.000000',NULL,NULL,'200409'),('SEAHLH','0301','SID','2001-04-08 00:00:00.000000',NULL,NULL,'200409'),('SEAPEN','0029','SID','2001-04-08 00:00:00.000000',NULL,NULL,'200409'),('TAMPA','0190','SID','2001-04-08 00:00:00.000000',NULL,NULL,'200409'),('SEAITC','0304','SID','2001-04-08 00:00:00.000000',NULL,NULL,'200409'),('CHICAP','0250','SID','2004-04-27 00:00:00.000000',NULL,NULL,'200409'),('SEACMP','0270','SID','2002-08-12 00:00:00.000000',NULL,NULL,'200409'),('MAHLH','0124','SID','2001-04-03 00:00:00.000000',NULL,'2001-04-03 00:00:00.000000','200409'),('AUSHLH','0245','SID','2001-04-03 00:00:00.000000',NULL,'2001-04-03 00:00:00.000000','200409'),('COLCIT','0306','SID','2002-08-12 00:00:00.000000',NULL,NULL,'200409'),('MINHLH','0145','SID','2001-04-03 00:00:00.000000',NULL,NULL,'200409'),('MINLIF','0159','SID','2001-04-03 00:00:00.000000',NULL,NULL,'200409'),('MINPEN','0044','SID','2001-04-17 00:00:00.000000',NULL,NULL,'200409'),('PTMHLH','0124','SID','2001-04-29 00:00:00.000000',NULL,NULL,'200409'),('CHIYEN','0347','SID','2004-01-23 00:00:00.000000',NULL,NULL,'200409'),('DLSPEN','0082','SID','2001-05-06 00:00:00.000000',NULL,NULL,'200409'),('HOUHLH','0024','SID','2001-05-06 00:00:00.000000',NULL,NULL,'200409'),('HOUPEN','0039','SID','2001-05-06 00:00:00.000000',NULL,NULL,'200409'),('HOUPEN','0074','SID','2001-05-06 00:00:00.000000',NULL,NULL,'200409'),('DLSLIF','0035','SID','2001-05-06 00:00:00.000000',NULL,NULL,'200409'),('DLSLIF','0165','SID','2001-05-06 00:00:00.000000',NULL,NULL,'200409'),('DLSDLW','0049','SID','2001-05-06 00:00:00.000000',NULL,NULL,'200409'),('DLSCAS','0172','SID','2001-05-06 00:00:00.000000',NULL,NULL,'200409'),('DLSDLT','0018','SID','2001-05-06 00:00:00.000000',NULL,NULL,'200409'),('HOURAL','0177','SID','2001-05-06 00:00:00.000000',NULL,NULL,'200409'),('OMAHLH','0189','SID','2001-05-06 00:00:00.000000',NULL,NULL,'200409'),('OMALIF','0046','SID','2001-05-06 00:00:00.000000',NULL,NULL,'200409'),('OMAPEN','0043','SID','2001-05-06 00:00:00.000000',NULL,NULL,'200409'),('OMAPEN','0031','SID','2001-05-06 00:00:00.000000',NULL,NULL,'200409'),('OMAPEN','0121','SID','2001-05-06 00:00:00.000000',NULL,NULL,'200409'),('OMAPEN','0059','SID','2001-05-06 00:00:00.000000',NULL,NULL,'200409'),('PHLCAS','0025','SID','2001-05-06 00:00:00.000000',NULL,NULL,'200409'),('PHLCAS','0062','SID','2001-05-06 00:00:00.000000',NULL,NULL,'200409'),('PHLCAS','0063','SID','2001-05-06 00:00:00.000000',NULL,NULL,'200409'),('MEXSAL','0412','SID','2004-05-24 00:00:00.000000',NULL,NULL,'200409'),('PHLDR','0150','SID','2001-05-06 00:00:00.000000',NULL,NULL,'200409'),('WDCPEN','0360','SID','2001-05-06 00:00:00.000000',NULL,NULL,'200409'),('WDCPEN','0036','SID','2001-05-06 00:00:00.000000',NULL,NULL,'200409'),('WDCRES','0093','SID','2001-05-06 00:00:00.000000',NULL,NULL,'200409'),('BERMUD','0104','SID','2001-05-06 00:00:00.000000',NULL,NULL,'200409'),('SEAJNT','0009','SID','2001-05-28 00:00:00.000000',NULL,NULL,'200409'),('TOKYO','0353','SID','2001-06-08 00:00:00.000000','SID1','2003-05-02 00:00:00.000000','200409'),('DESPEN','0169','SID','2002-08-01 00:00:00.000000',NULL,NULL,'200409'),('DENLAT','0211','SID','2002-01-23 00:00:00.000000',NULL,NULL,'200409'),('HKLIF','0402','SID','2002-01-02 00:00:00.000000',NULL,NULL,'200409'),('CHILIF','0246','SID','2002-01-11 00:00:00.000000',NULL,NULL,'200409'),('NYPEN','0188','NYCONV','2002-02-15 11:19:50.796000',NULL,NULL,'200409'),('NYPEN','0196','NYCONV','2002-02-15 11:19:50.828000',NULL,NULL,'200409'),('NYPEN','0335','NYCONV','2002-02-15 11:19:50.843000',NULL,NULL,'200409'),('MELDB','0188','NYCONV','2002-02-15 11:19:50.859000',NULL,NULL,'200409'),('MELDB','0196','NYCONV','2002-02-15 11:19:50.875000',NULL,NULL,'200409'),('MELDB','0335','NYCONV','2002-02-15 11:19:50.890000',NULL,NULL,'200409'),('MKECAS','0193','SID','2001-04-03 00:00:00.000000','SID','2001-04-03 00:00:00.000000','200409'),('ATLCIT','0306','SID','2002-08-12 00:00:00.000000',NULL,NULL,'200409'),('SEACIT','0306','SID','2002-08-12 00:00:00.000000',NULL,NULL,'200409'),('SEANIT','0307','SID','2002-08-12 00:00:00.000000',NULL,NULL,'200409'),('NYNIT','0307','SID','2002-08-12 00:00:00.000000',NULL,NULL,'200409'),('BZLLIF','0406','SID','2002-09-04 00:00:00.000000',NULL,NULL,'200409'),('INDHLH','0129','SID','2000-10-23 00:00:00.000000',NULL,'2000-10-23 00:00:00.000000','200409'),('INDHLH','0034','SID','2000-10-12 00:00:00.000000',NULL,'2000-10-12 00:00:00.000000','200409'),('UKLIF','0404','SID','2002-12-10 00:00:00.000000',NULL,NULL,'200409'),('UKLIF','0407','SID','2002-12-13 00:00:00.000000',NULL,NULL,'200409'),('NYCAS','0213','SID','2002-12-28 00:00:00.000000',NULL,NULL,'200409'),('NYCAS','0214','SID','2002-12-28 00:00:00.000000',NULL,NULL,'200409'),('NYCAS','0215','SID','2002-12-28 00:00:00.000000',NULL,NULL,'200409'),('NYCAS','0216','SID','2002-12-28 00:00:00.000000',NULL,NULL,'200409'),('TOKUSD','0171','SID','2000-08-14 00:00:00.000000','SID1','2003-05-02 00:00:00.000000','200409'),('TOKUSD','0053','SID','2000-09-08 00:00:00.000000','SID1','2003-05-02 00:00:00.000000','200409'),('TOKUSD','0198','SID','2000-08-14 00:00:00.000000','SID1','2003-05-02 00:00:00.000000','200409'),('MANCAS','0147','SID','2003-03-12 00:00:00.000000',NULL,NULL,'200409'),('CHICCD','0210','SID','2003-01-30 00:00:00.000000',NULL,NULL,'200409'),('MKEHLH','0026','SID','2000-08-06 00:00:00.000000','SID','2000-08-06 00:00:00.000000','200409'),('MKEPEN','0006','SID','2000-08-06 00:00:00.000000','SID','2000-08-06 00:00:00.000000','200409'),('MKEPEN','0051','SID','2000-08-06 00:00:00.000000','SID','2000-08-06 00:00:00.000000','200409'),('MKEPEN','0085','SID','2000-08-06 00:00:00.000000','SID','2000-08-06 00:00:00.000000','200409'),('MKECAS','0106','SID','2000-08-06 00:00:00.000000','SID','2000-08-06 00:00:00.000000','200409'),('MKECAS','0055','SID','2000-08-06 00:00:00.000000','SID','2000-08-06 00:00:00.000000','200409'),('MKECAS','0048','SID','2000-08-06 00:00:00.000000','SID','2000-08-06 00:00:00.000000','200409'),('MKELIF','0023','SID','2000-08-06 00:00:00.000000','SID','2000-08-06 00:00:00.000000','200409'),('SDHLH','0136','SID','2000-08-13 00:00:00.000000','SID','2000-08-13 00:00:00.000000','200409'),('SDHLH','0362','SID','2000-08-13 00:00:00.000000','SID','2000-08-13 00:00:00.000000','200409'),('SDHLH','0365','SID','2000-08-13 00:00:00.000000','SID','2000-08-13 00:00:00.000000','200409'),('SDHLH','0368','SID','2000-08-13 00:00:00.000000','SID','2000-08-13 00:00:00.000000','200409'),('RDCAS','0933','SID','2000-08-13 00:00:00.000000','SID','2000-08-13 00:00:00.000000','200409'),('MANCAS','0115','SID','2003-03-12 00:00:00.000000',NULL,NULL,'200409'),('MANCAS','0157','SID','2003-03-12 00:00:00.000000',NULL,NULL,'200409'),('TOKYO','0199','SID','2000-08-14 00:00:00.000000','SID1','2003-05-02 00:00:00.000000','200409'),('ATLAST','0242','SID','2003-03-15 00:00:00.000000',NULL,NULL,'200409'),('CHICPL','0243','STEVE','2003-03-20 00:00:00.000000',NULL,NULL,'200409'),('HKLIF','0401','SID','2000-10-05 00:00:00.000000','SID','2000-10-05 00:00:00.000000','200409'),('SFPEN','0030','SID','2000-10-10 00:00:00.000000','SID','2000-10-10 00:00:00.000000','200409'),('SFCAS','0095','SID','2000-10-10 00:00:00.000000','SID','2000-10-10 00:00:00.000000','200409'),('SFCAS','0132','SID','2000-10-10 00:00:00.000000','SID','2000-10-10 00:00:00.000000','200409'),('SFCAS','0133','SID','2000-10-10 00:00:00.000000','SID','2000-10-10 00:00:00.000000','200409'),('SFHLH','0096','SID','2000-10-10 00:00:00.000000','SID','2000-10-10 00:00:00.000000','200409'),('SFHLH','0139','SID','2000-10-10 00:00:00.000000','SID','2000-10-10 00:00:00.000000','200409'),('SFHLH','0143','SID','2000-10-10 00:00:00.000000','SID','2000-10-10 00:00:00.000000','200409'),('SFHLH','0960','SID','2000-10-10 00:00:00.000000','SID','2000-10-10 00:00:00.000000','200409'),('SFHLH','0961','SID','2000-10-10 00:00:00.000000','SID','2000-10-10 00:00:00.000000','200409'),('SFHLH','0962','SID','2000-10-10 00:00:00.000000','SID','2000-10-10 00:00:00.000000','200409'),('SFHLH','0963','SID','2000-10-10 00:00:00.000000','SID','2000-10-10 00:00:00.000000','200409'),('SFHLH','0964','SID','2000-10-10 00:00:00.000000','SID','2000-10-10 00:00:00.000000','200409'),('SFHLH','0965','SID','2000-10-10 00:00:00.000000','SID','2000-10-10 00:00:00.000000','200409'),('SFHLH','0966','SID','2000-10-10 00:00:00.000000','SID','2000-10-10 00:00:00.000000','200409'),('SFHLH','0967','SID','2000-10-10 00:00:00.000000','SID','2000-10-10 00:00:00.000000','200409'),('SFHLH','0968','SID','2000-10-10 00:00:00.000000','SID','2000-10-10 00:00:00.000000','200409'),('SFSNL','0186','SID','2000-10-10 00:00:00.000000','SID','2000-10-10 00:00:00.000000','200409'),('HTFLIF','0027','SID','2000-10-10 00:00:00.000000','SID','2000-10-10 00:00:00.000000','200409'),('HTFPEN','0054','SID','2000-10-10 00:00:00.000000','SID','2000-10-10 00:00:00.000000','200409'),('HTFPEN','0122','SID','2000-10-10 00:00:00.000000','SID','2000-10-10 00:00:00.000000','200409'),('HTFPEN','0194','SID','2000-10-10 00:00:00.000000','SID','2000-10-10 00:00:00.000000','200409'),('HTFHLH','0167','SID','2000-10-10 00:00:00.000000','SID','2000-10-10 00:00:00.000000','200409'),('STLPEN','0052','SID','2000-10-10 00:00:00.000000','SID','2000-10-10 00:00:00.000000','200409'),('STLPEN','0086','SID','2000-10-10 00:00:00.000000','SID','2000-10-10 00:00:00.000000','200409'),('STLPEN','0105','SID','2000-10-10 00:00:00.000000','SID','2000-10-10 00:00:00.000000','200409'),('STLLIF','0116','SID','2000-10-10 00:00:00.000000','SID','2000-10-10 00:00:00.000000','200409'),('STLKCI','0164','SID','2000-10-10 00:00:00.000000','SID','2000-10-10 00:00:00.000000','200409'),('PHXLHL','0069','SID','2000-10-10 00:00:00.000000','SID','2000-10-10 00:00:00.000000','200409'),('INDPEN','0037','SID','2000-10-10 00:00:00.000000','SID','2000-10-10 00:00:00.000000','200409'),('INDLIF','0022','SID','2000-10-10 00:00:00.000000','SID','2000-10-10 00:00:00.000000','200409'),('INDHLH','0032','SID','2000-10-10 00:00:00.000000','SID','2000-10-10 00:00:00.000000','200409'),('INDHLH','0185','SID','2000-10-10 00:00:00.000000','SID','2000-10-10 00:00:00.000000','200409'),('DENPEN','0016','SID','2000-10-10 00:00:00.000000','SID','2000-10-10 00:00:00.000000','200409'),('DENPEN','0071','SID','2000-10-10 00:00:00.000000','SID','2000-10-10 00:00:00.000000','200409'),('DENPEN','0100','SID','2000-10-10 00:00:00.000000','SID','2000-10-10 00:00:00.000000','200409'),('COLHLH','0142','SID','2000-11-28 00:00:00.000000',NULL,NULL,'200409'),('DENCAS','0109','SID','2000-10-10 00:00:00.000000',NULL,NULL,'200409'),('DENHLH','0154','SID','2000-10-10 00:00:00.000000',NULL,NULL,'200409'),('PTLPEN','0080','SID','2000-10-10 00:00:00.000000',NULL,NULL,'200409'),('PTLPEN','0088','SID','2000-10-10 00:00:00.000000',NULL,NULL,'200409'),('PTLPEN','0107','SID','2000-10-10 00:00:00.000000',NULL,NULL,'200409'),('PTLPEN','0162','SID','2000-10-10 00:00:00.000000',NULL,NULL,'200409'),('PASCAS','0040','SID','2000-10-10 00:00:00.000000',NULL,NULL,'200409'),('PASCAS','0097','SID','2000-10-10 00:00:00.000000',NULL,NULL,'200409'),('PASCAS','0123','SID','2000-10-10 00:00:00.000000',NULL,NULL,'200409'),('PASPEN','0020','SID','2000-10-12 00:00:00.000000',NULL,'2000-10-12 00:00:00.000000','200409'),('PASPEN','0111','SID','2000-10-12 00:00:00.000000',NULL,'2000-10-12 00:00:00.000000','200409'),('PHLCPL','0243','STEVE','2003-03-20 00:00:00.000000',NULL,NULL,'200409'),('IRVMC','0178','SID','2000-10-12 00:00:00.000000',NULL,NULL,'200409'),('IRVMC','0363','SID','2000-10-12 00:00:00.000000',NULL,NULL,'200409'),('IRVCAS','0161','SID','2000-10-12 00:00:00.000000',NULL,NULL,'200409'),('IRVCAS','0160','SID','2000-10-12 00:00:00.000000',NULL,NULL,'200409'),('SEAHMG','0192','SID','2000-10-12 00:00:00.000000','SID','2000-10-12 00:00:00.000000','200409'),('SEAHMG','0202','SID','2000-10-12 00:00:00.000000','SID','2000-10-12 00:00:00.000000','200409'),('SEAHMG','0203','SID','2000-10-12 00:00:00.000000','SID','2000-10-12 00:00:00.000000','200409'),('SEAHMG','0204','SID','2000-10-12 00:00:00.000000','SID','2000-10-12 00:00:00.000000','200409'),('SEAHMG','0205','SID','2000-10-12 00:00:00.000000','SID','2000-10-12 00:00:00.000000','200409'),('SEAHMG','0206','SID','2000-10-12 00:00:00.000000','SID','2000-10-12 00:00:00.000000','200409'),('SEAHMG','0207','SID','2000-10-12 00:00:00.000000','SID','2000-10-12 00:00:00.000000','200409'),('SEAHMG','0208','SID','2000-10-12 00:00:00.000000','SID','2000-10-12 00:00:00.000000','200409'),('SEAHMG','0292','SID','2000-10-12 00:00:00.000000','SID','2000-10-12 00:00:00.000000','200409'),('SEALIF','0008','SID','2000-10-12 00:00:00.000000','SID','2000-10-12 00:00:00.000000','200409'),('SEALIF','0061','SID','2000-10-12 00:00:00.000000','SID','2000-10-12 00:00:00.000000','200409'),('SEALIF','0045','SID','2000-10-12 00:00:00.000000','SID','2000-10-12 00:00:00.000000','200409'),('RMHEAL','0011','SID','2000-10-13 00:00:00.000000','SID','2000-10-13 00:00:00.000000','200409'),('PTLFUL','0144','SID','2000-10-15 00:00:00.000000','SID','2000-10-15 00:00:00.000000','200409'),('SEACRP','0009','SID','2000-10-15 00:00:00.000000','SID','2000-10-15 00:00:00.000000','200409'),('CRPCOM','0019','SID','2000-10-15 00:00:00.000000','SID','2000-10-15 00:00:00.000000','200409'),('SEAADA','0170','SID','2000-10-15 00:00:00.000000','SID','2000-10-15 00:00:00.000000','200409'),('SEACAS','0138','SID','2000-10-15 00:00:00.000000','SID','2000-10-15 00:00:00.000000','200409'),('RDPEN','0930','SID','2000-12-05 00:00:00.000000',NULL,NULL,'200409'),('SFHLH','0173','SID','2002-01-17 00:00:00.000000',NULL,NULL,'200409'),('SEASYS','0180','SID','2000-10-15 00:00:00.000000',NULL,NULL,'200409'),('SEAJLP','0151','SID','2000-10-15 00:00:00.000000',NULL,NULL,'200409'),('PASCAS','0331','SID','2000-10-17 00:00:00.000000',NULL,'2000-10-17 00:00:00.000000','200409'),('PASCAS','0321','SID','2000-10-17 00:00:00.000000',NULL,'2000-10-17 00:00:00.000000','200409'),('PASCAS','0311','SID','2000-10-17 00:00:00.000000',NULL,'2000-10-17 00:00:00.000000','200409'),('RMHEAL','0511','SID','2000-10-23 00:00:00.000000',NULL,'2000-10-23 00:00:00.000000','200409'),('TOKUSD','0181','SID','2000-08-14 00:00:00.000000','SID1','2003-05-02 00:00:00.000000','200409'),('DENLAT','0065','SID','2000-10-10 00:00:00.000000','SID','2000-10-10 00:00:00.000000','200409'),('MKECAS','0108','SID','2001-04-03 00:00:00.000000','SID','2001-04-03 00:00:00.000000','200409'),('SFINVC','0212','SID','2002-01-17 14:07:48.546000',NULL,NULL,'200409'),('HTFTRI','0221','SID','2003-04-23 07:56:39.750000',NULL,NULL,'200409'),('ATLPNC','0225','SID','2003-04-23 07:56:53.437000',NULL,NULL,'200409'),('PHLLIF','0128','SID','2002-01-02 00:00:00.000000',NULL,NULL,'200409'),('BZLLFR','0408','SID','2003-05-02 07:27:00.156000',NULL,NULL,'200409'),('PHLPEN','0078','SID','2001-05-06 00:00:00.000000',NULL,NULL,'200409'),('PHLPEN','0083','SID','2001-05-06 00:00:00.000000',NULL,NULL,'200409'),('PHLJPC','0102','SID','2001-05-06 00:00:00.000000',NULL,NULL,'200409'),('PHLPAD','0098','SID','2001-05-06 00:00:00.000000',NULL,NULL,'200409'),('PHLINV','0182','SID','2001-05-06 00:00:00.000000',NULL,'2002-07-09 00:00:00.000000','200409'),('HTFHLH','0187','SID','2003-05-14 00:00:00.000000',NULL,NULL,'200409'),('TOKUSD','0405','SID','2003-05-08 00:00:00.000000',NULL,NULL,'200409'),('SEAITC','0308','SID','2003-05-30 00:00:00.000000',NULL,NULL,'200409'),('PHLHLH','0041','SID','2001-05-06 00:00:00.000000',NULL,NULL,'200409'),('PHLLIF','0042','SID','2001-05-06 00:00:00.000000',NULL,NULL,'200409'),('PHLLIF','0058','SID','2001-05-06 00:00:00.000000',NULL,NULL,'200409'),('PHLLIF','0158','SID','2001-05-06 00:00:00.000000',NULL,NULL,'200409'),('CHILIF','0231','SID','2003-06-05 00:00:00.000000',NULL,NULL,'200409'),('CHILIF','0431','SID','2003-08-10 00:00:00.000000',NULL,NULL,'200409'),('SEALIF','0432','SID','2003-08-10 00:00:00.000000',NULL,NULL,'200409'),('PRNCAS','0247','SID','2003-08-14 00:00:00.000000',NULL,NULL,'200409'),('NYECON','0325','SID','2003-08-28 00:00:00.000000',NULL,NULL,'200409'),('PASCAS','0160','SID','2004-09-01 00:00:00.000000',NULL,NULL,'200409'),('BZLLIF','0416','SID','2003-09-30 00:00:00.000000',NULL,NULL,'200409'),('BZLLFR','0418','SID','2003-09-30 00:00:00.000000',NULL,NULL,'200409'),('LONLIF','0452','SID','2004-01-12 00:00:00.000000',NULL,NULL,'200409'),('DENHAW','0240','SID','2003-10-03 00:00:00.000000',NULL,NULL,'200409'),('BOISE','0003','SID','2003-10-21 00:00:00.000000',NULL,NULL,'200409'),('BOISE','0012','SID','2003-10-21 00:00:00.000000',NULL,NULL,'200409'),('BOISE','0014','SID','2003-10-21 00:00:00.000000',NULL,NULL,'200409'),('BOISE','0029','SID','2003-10-21 00:00:00.000000',NULL,NULL,'200409'),('BOISE','0075','SID','2003-10-21 00:00:00.000000',NULL,NULL,'200409'),('BOISE','0077','SID','2003-10-21 00:00:00.000000',NULL,NULL,'200409'),('BOISE','0119','SID','2003-10-21 00:00:00.000000',NULL,NULL,'200409'),('BOISE','0153','SID','2003-10-21 00:00:00.000000',NULL,NULL,'200409'),('SEAAIT','0309','SID','2003-12-01 00:00:00.000000',NULL,NULL,'200409'),('ATLAIT','0309','SID','2003-12-01 00:00:00.000000',NULL,NULL,'200409'),('FASFOC','0220','SID','2004-01-05 00:00:00.000000',NULL,NULL,'200409'),('PARLIF','0453','SID','2004-01-12 00:00:00.000000',NULL,NULL,'200409'),('MDRLIF','0454','SID','2004-01-12 00:00:00.000000',NULL,NULL,'200409'),('MLNLIF','0455','SID','2004-01-12 00:00:00.000000',NULL,NULL,'200409'),('DLSBRC','0169','SID','2001-05-06 00:00:00.000000',NULL,NULL,'200409'),('NYCAS','0218','SID','2004-01-21 00:00:00.000000',NULL,NULL,'200409'),('HTFHJP','0234','SID','2004-01-24 00:00:00.000000',NULL,NULL,'200409'),('MKEMIT','0312','SID','2004-01-24 00:00:00.000000',NULL,NULL,'200409'),('INDPEN','0370','SID','2004-06-08 00:00:00.000000',NULL,NULL,'200409'),('PASCAS','0161','SID','2004-09-01 00:00:00.000000',NULL,NULL,'200409'),('TOKYO','0371','SID','2004-07-07 00:00:00.000000',NULL,NULL,'200409'),('PHLINV','0249','SID','2003-09-22 00:00:00.000000',NULL,NULL,'200409');
UNLOCK TABLES;
/*!40000 ALTER TABLE `practice_client` ENABLE KEYS */;

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