1. Mapping masterlayanan dengan modality code.
   Daftar code ada di table: modalitycodes
2. Create table pacs_order_mwl, pacs_result_series

CREATE TABLE `pacs_order_mwl` (
  `AccessionNumber` char(15) NOT NULL DEFAULT '',
  `MEDRECID` char(50) NOT NULL DEFAULT '',
  `RegID` char(20) NOT NULL DEFAULT '',
  `TrxLayananID` bigint(20) unsigned NOT NULL DEFAULT '0',
  `TrxDepartemenID` bigint(20) NOT NULL DEFAULT '0',
  `StudyIUID` char(100) NOT NULL DEFAULT '',
  `ScheduledProcStepID` char(20) NOT NULL DEFAULT '',
  `CreatedDateTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `NA` enum('N','Y') NOT NULL DEFAULT 'N',
  PRIMARY KEY (`AccessionNumber`,`TrxLayananID`),
  KEY `x_medrec` (`MEDRECID`),
  KEY `x_regid` (`RegID`),
  KEY `x_trx` (`TrxLayananID`),
  KEY `x_dttm` (`CreatedDateTime`),
  KEY `x_na` (`NA`),
  KEY `TrxDepartemenID` (`TrxDepartemenID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


CREATE TABLE `pacs_result_series` (
  `AccessionNumber` char(15) NOT NULL DEFAULT '',
  `MEDRECID` char(50) NOT NULL DEFAULT '',
  `RegID` char(20) NOT NULL DEFAULT '',
  `TrxLayananID` bigint(20) unsigned NOT NULL DEFAULT '0',
  `TrxDepartemenID` bigint(20) NOT NULL DEFAULT '0',
  `StudyIUID` char(100) NOT NULL DEFAULT '',
  `StudyDescription` char(200) NOT NULL DEFAULT '',
  `StudyDatetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `SeriesIUID` char(100) NOT NULL DEFAULT '',
  `SeriesNumber` int(10) unsigned NOT NULL DEFAULT '0',
  `SeriesDescription` char(200) NOT NULL DEFAULT '',
  `NumberOfInstance` int(10) unsigned NOT NULL DEFAULT '0',
  `SOPIUID` char(100) NOT NULL DEFAULT '',
  `CreatedDateTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `Published` enum('N','Y') NOT NULL DEFAULT 'N',
  `PublisheDateTime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `NA` enum('N','Y') NOT NULL DEFAULT 'N',
  PRIMARY KEY (`AccessionNumber`,`SeriesIUID`),
  UNIQUE KEY `x_uk` (`StudyIUID`,`SeriesIUID`),
  KEY `x_acs` (`AccessionNumber`),
  KEY `x_medrec` (`MEDRECID`),
  KEY `x_regid` (`RegID`),
  KEY `x_trx` (`TrxLayananID`),
  KEY `x_sdttm` (`StudyDatetime`),
  KEY `x_dttm` (`CreatedDateTime`),
  KEY `x_na` (`NA`),
  KEY `x_pub` (`Published`),
  KEY `TrxDepartemenID` (`TrxDepartemenID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;