[Logging Date Time: 2016-11-10 11:04:19,974] ===================================================================================== SQL Command - Statement Id: [GET_SEQUENCE] PreparedStatement : [select ud1_num as seq from EFORM_CODE where main_cd = 'SEQUENCE' and sub_cd = :param0 for update] [Logging Date Time: 2016-11-10 11:04:19,974] ===================================================================================== SQL Command - Statement Id: [GET_SEQUENCE] PreparedStatement : [select ud1_num as seq from EFORM_CODE where main_cd = 'SEQUENCE' and sub_cd = :param0 for update] [Logging Date Time: 2016-11-10 11:04:20,013] ===================================================================================== SQL Command - Statement Id: [GET_SEQUENCE] Parameters: [param0=[sub_cd,CONSENT_DATA]] [Logging Date Time: 2016-11-10 11:04:20,013] ===================================================================================== SQL Command - Statement Id: [GET_SEQUENCE] Parameters: [param0=[sub_cd,CONSENT_DATA]] [Logging Date Time: 2016-11-10 11:04:20,013] ===================================================================================== SQL Command - Statement Id: [GET_SEQUENCE] Types: [param0=[AnsiString, System.String]] [Logging Date Time: 2016-11-10 11:04:20,013] ===================================================================================== SQL Command - Statement Id: [GET_SEQUENCE] Types: [param0=[AnsiString, System.String]] [Logging Date Time: 2016-11-10 11:04:20,041] ===================================================================================== SQL Command - Statement Id: [UPDATE_SEQUENCE] PreparedStatement : [update EFORM_CODE set ud1_num = :param0 where main_cd = 'SEQUENCE' and sub_cd = :param1] [Logging Date Time: 2016-11-10 11:04:20,041] ===================================================================================== SQL Command - Statement Id: [UPDATE_SEQUENCE] PreparedStatement : [update EFORM_CODE set ud1_num = :param0 where main_cd = 'SEQUENCE' and sub_cd = :param1] [Logging Date Time: 2016-11-10 11:04:20,042] ===================================================================================== SQL Command - Statement Id: [UPDATE_SEQUENCE] Parameters: [param0=[ud1_num,1793], param1=[sub_cd,CONSENT_DATA]] [Logging Date Time: 2016-11-10 11:04:20,042] ===================================================================================== SQL Command - Statement Id: [UPDATE_SEQUENCE] Parameters: [param0=[ud1_num,1793], param1=[sub_cd,CONSENT_DATA]] [Logging Date Time: 2016-11-10 11:04:20,043] ===================================================================================== SQL Command - Statement Id: [UPDATE_SEQUENCE] Types: [param0=[Int32, System.Int32], param1=[AnsiString, System.String]] [Logging Date Time: 2016-11-10 11:04:20,043] ===================================================================================== SQL Command - Statement Id: [UPDATE_SEQUENCE] Types: [param0=[Int32, System.Int32], param1=[AnsiString, System.String]] [Logging Date Time: 2016-11-10 11:04:20,056] ===================================================================================== SQL Command - Statement Id: [UPDATE_CONSENT_MST] PreparedStatement : [UPDATE CONSENT_MST SET CONSENT_STATE = :param0 , COMPLETE_YN = :param1 , COMPLETE_DATETIME = TO_CHAR(SYSDATE,'YYYY-MM-DD hh24:mi:ss'), PAPER_YN = :param2 , MODIFY_USER_ID = :param3 , MODIFY_DATETIME = TO_CHAR(SYSDATE,'yyyy-mm-dd hh24:mi:ss'), MODIFY_USER_NAME = COM.FN_ZS_GETUSERNM( :param3 , TO_CHAR(SYSDATE, 'YYYYMMDD')) WHERE CONSENT_MST_RID = :param4] [Logging Date Time: 2016-11-10 11:04:20,056] ===================================================================================== SQL Command - Statement Id: [UPDATE_CONSENT_MST] PreparedStatement : [UPDATE CONSENT_MST SET CONSENT_STATE = :param0 , COMPLETE_YN = :param1 , COMPLETE_DATETIME = TO_CHAR(SYSDATE,'YYYY-MM-DD hh24:mi:ss'), PAPER_YN = :param2 , MODIFY_USER_ID = :param3 , MODIFY_DATETIME = TO_CHAR(SYSDATE,'yyyy-mm-dd hh24:mi:ss'), MODIFY_USER_NAME = COM.FN_ZS_GETUSERNM( :param3 , TO_CHAR(SYSDATE, 'YYYYMMDD')) WHERE CONSENT_MST_RID = :param4] [Logging Date Time: 2016-11-10 11:04:20,057] ===================================================================================== SQL Command - Statement Id: [UPDATE_CONSENT_MST] Parameters: [param0=[consentState,ELECTR_CMP], param1=[completeYn,Y], param2=[paperYn,N], param3=[userId,105066], param4=[consentMstRid,1842]] [Logging Date Time: 2016-11-10 11:04:20,057] ===================================================================================== SQL Command - Statement Id: [UPDATE_CONSENT_MST] Parameters: [param0=[consentState,ELECTR_CMP], param1=[completeYn,Y], param2=[paperYn,N], param3=[userId,105066], param4=[consentMstRid,1842]] [Logging Date Time: 2016-11-10 11:04:20,057] ===================================================================================== SQL Command - Statement Id: [UPDATE_CONSENT_MST] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String], param3=[AnsiString, System.String], param4=[Int32, System.Int32]] [Logging Date Time: 2016-11-10 11:04:20,057] ===================================================================================== SQL Command - Statement Id: [UPDATE_CONSENT_MST] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String], param3=[AnsiString, System.String], param4=[Int32, System.Int32]] [Logging Date Time: 2016-11-10 11:04:20,061] ===================================================================================== SQL Command - Statement Id: [INSERT_CONSENT_DATA] PreparedStatement : [insert into CONSENT_DATA ( CONSENT_DATA_RID, CONSENT_MST_RID, FORM_RID, DEVICE_TYPE, DEVICE_IDENT_NO, COMPLETE_YN, CREATE_USER_ID, CREATE_DATETIME, FORM_XML, DATA_XML ) values ( :param0 , :param1 , :param2 , :param3 , :param4 , :param5 , :param6 , TO_CHAR(SYSDATE,'yyyy-mm-dd hh24:mi:ss'), :param7 , :param8 )] [Logging Date Time: 2016-11-10 11:04:20,061] ===================================================================================== SQL Command - Statement Id: [INSERT_CONSENT_DATA] PreparedStatement : [insert into CONSENT_DATA ( CONSENT_DATA_RID, CONSENT_MST_RID, FORM_RID, DEVICE_TYPE, DEVICE_IDENT_NO, COMPLETE_YN, CREATE_USER_ID, CREATE_DATETIME, FORM_XML, DATA_XML ) values ( :param0 , :param1 , :param2 , :param3 , :param4 , :param5 , :param6 , TO_CHAR(SYSDATE,'yyyy-mm-dd hh24:mi:ss'), :param7 , :param8 )] [Logging Date Time: 2016-11-10 11:04:20,061] ===================================================================================== SQL Command - Statement Id: [INSERT_CONSENT_DATA] Parameters: [param0=[consentDataRid,1793], param1=[consentMstRid,1842], param2=[formRid,1307], param3=[deviceType,WIN], param4=[deviceIdentNo,16-101-33], param5=[completeYn,Y], param6=[userId,105066], param7=[formXml,System.Byte[]], param8=[dataXml,System.Byte[]]] [Logging Date Time: 2016-11-10 11:04:20,061] ===================================================================================== SQL Command - Statement Id: [INSERT_CONSENT_DATA] Parameters: [param0=[consentDataRid,1793], param1=[consentMstRid,1842], param2=[formRid,1307], param3=[deviceType,WIN], param4=[deviceIdentNo,16-101-33], param5=[completeYn,Y], param6=[userId,105066], param7=[formXml,System.Byte[]], param8=[dataXml,System.Byte[]]] [Logging Date Time: 2016-11-10 11:04:20,061] ===================================================================================== SQL Command - Statement Id: [INSERT_CONSENT_DATA] Types: [param0=[Int32, System.Int32], param1=[Int32, System.Int32], param2=[Int32, System.Int32], param3=[AnsiString, System.String], param4=[AnsiString, System.String], param5=[AnsiString, System.String], param6=[AnsiString, System.String], param7=[Binary, System.Byte[]], param8=[Binary, System.Byte[]]] [Logging Date Time: 2016-11-10 11:04:20,061] ===================================================================================== SQL Command - Statement Id: [INSERT_CONSENT_DATA] Types: [param0=[Int32, System.Int32], param1=[Int32, System.Int32], param2=[Int32, System.Int32], param3=[AnsiString, System.String], param4=[AnsiString, System.String], param5=[AnsiString, System.String], param6=[AnsiString, System.String], param7=[Binary, System.Byte[]], param8=[Binary, System.Byte[]]] [Logging Date Time: 2016-11-10 11:04:20,257] ===================================================================================== SQL Command - CLIP.eForm SaveDataAll ERROR : [System.NullReferenceException: 개체 참조가 개체의 인스턴스로 설정되지 않았습니다. 위치: CLIP.eForm.Consent.Dfh.WebService.ConsentSvc.imageUpload(SaveConsentDac dac, Hashtable paramHashTable, String userId, String patientCode, String visitType, String clnDate, String Dschdd, Int32 cretno, String ocrcode, Int32 consentMstRid, String consentState, String formCd, Int32 formRid, String dataXml, String imageFileJson, String certTarget, String certResult, String hosType, String createUserName) 파일 D:\TeamDFH_Consent\DFH-Consent\CLIP.e-Form.Consent.Dfh.Web\ConsentSvc.asmx.cs:줄 971 위치: CLIP.eForm.Consent.Dfh.WebService.ConsentSvc.SaveDataAll(String userId, String patientCode, String clnDeptCode, Int32 formRid, String formCd, Int32 consentMstRid, Int32 rewriteConsentMstRid, Int32 reissueConsentMstRid, String consentState, String paperYn, String formXml, String dataXml, String deviceType, String deviceIdentNo, String vistType, String hosType, String clnDate, String ward, String roomcd, String reasonForUseN, Int32 orderNo, String orderName, String orderCd, String ocrCode, Int32 cretno, String createUserName, String modifyUserName, String imageFileJson, String certTarget, String certResult, String dschdd, String mainDrId) 파일 D:\TeamDFH_Consent\DFH-Consent\CLIP.e-Form.Consent.Dfh.Web\ConsentSvc.asmx.cs:줄 901] [Logging Date Time: 2016-11-10 11:05:38,399] ===================================================================================== SQL Command - CLIP.eForm SaveCompleteAll param : clnDept[105066]patientCode[1715813]clnDeptCode[2010400000]formRid[1307]formCd[1300010589]consentMstRid[1842]rewriteConsentMstRid[1842]deviceType[WIN]vistType[O]hosType[111]clnDate[20161110]ward[]roomcd[]orderNo[111]orderName[코감기]orderCd[J00.000.08]ocrCode[2016111063775]cretno[1]createUserName[이봉렬]modifyUserName[이봉렬]imageFileJson[{ "imageFile1" : "201611/10/97dc0cc05db749a5b180fcc4ee92b15b_1.jpg", "imageFile2" : "201611/10/97dc0cc05db749a5b180fcc4ee92b15b_2.jpg" }]certTarget[278a4c26b11e2327060a0f51ddad21bea5f49f32e035bcd23d468b4cd2fc3^d57fffbbe6132bb57bbd045394b7f79a3ea62f5ad6f890e1f682d91cfc25a2]dschdd[20161110]consentState[ELECTR_CMP]mainDrId[105066]dataXml[460,2204,460,2204?455,2204,452,2204?450,2201,447,2201?444,2199,442,2196?442,2191,439,2185?434,2180,434,2172?434,2167,434,2156?439,2148,442,2138?444,2125,450,2111?455,2098,460,2085?471,2069,479,2056?487,2040,500,2027?511,2011,521,1995?532,1982,542,1966?556,1953,564,1939?577,1929,585,1918?593,1908,603,1900?609,1894,614,1894?616,1894,619,1894?622,1900,622,1905?619,1918,619,1929?616,1945,611,1958?609,1976,603,1995?595,2016,590,2040?585,2061,579,2085?577,2109,569,2130?564,2154,561,2172?558,2191,558,2201?558,2209,558,2215?561,2215,564,2212?569,2204,577,2193?582,2180,590,2167?595,2151,606,2138?614,2122,619,2111?627,2098,635,2088?643,2077,648,2072?651,2066,659,2061?664,2058,667,2058?669,2058,672,2058?675,2061,677,2066?677,2069,680,2074?680,2085,680,2093?685,2101,685,2111?685,2119,688,2130?688,2140,691,2148?691,2156,693,2159?696,2167,698,2167?701,2167,704,2159?706,2156,714,2148?717,2140,722,2130?728,2119,730,2111?736,2101,743,2090?749,2085,754,2074?759,2072,762,2066?770,2064,773,2064?773,2061,775,2064?778,2064,778,2066?781,2069,781,2072?783,2074,783,2077?783,2085,786,2088?788,2090,788,2096?791,2098,791,2101?796,2109,799,2111?799,2114,802,2117?804,2117,804,2119?807,2122,807,2122?810,2125,812,2125?815,2125,818,2122?823,2119,826,2117?831,2114,833,2111?836,2103,839,2101?841,2098,844,2096?844,2096466,1254,466,1254?460,1262,458,1265?458,1265,458,1265?458,1265,460,1265?460,1262,468,1254?471,1249,476,1244?484,1236,495,1222?503,1214,508,1206?516,1196,527,1188?534,1180,542,1172?550,1167,556,1159?564,1154,569,1151?572,1143,579,1140?582,1138,582,1138?582,1138,582,1140?579,1140,579,1146?577,1151,569,1156?566,1162,561,1169?558,1177,556,1185?553,1193,548,1201?548,1212,542,1217?542,1225,542,1233?542,1238,542,1244?542,1246,548,1249?550,1251,553,1251?556,1251,558,1251?561,1251,566,1251?569,1249,572,1249?577,1246,579,1249?579,1251,582,1257?582,1262,582,1267?582,1273,582,1275?582,1281669,1217,669,1217?672,1217,675,1214?677,1214,680,1212?685,1212,688,1209?691,1209,691,1206?693,1206,696,1201?698,1201,701,1199?701,1199,704,1196?704,1196640,1601,640,1601?632,1609,624,1619?619,1625,614,1632?609,1638,603,1646?598,1648,598,1648?598,1648,598,1648?603,1646,609,1638?614,1632,622,1627?632,1619,643,1609?651,1601,661,1593?672,1582,680,1574?691,1566,698,1561?706,1550,714,1548?722,1543,728,1540?730,1535,736,1535?741,1529,743,1529?743,1527,743,1527?746,1529,746,1535?746,1537,746,1540?746,1543,743,1545?743,1550,743,1553?741,1561,741,1564?741,1572,743,1577?743,1582,743,1593?743,1601,746,1609?746,1619,746,1627?746,1632,749,1643?749,1648,751,1656?754,1662,754,1664?757,1672,759,1675857,1638,857,1638?860,1638,860,1638?863,1635,865,1635?868,1635,870,1632?873,1630,873,1627?878,1625,881,1622?884,1619,884,1617?886,1609,889,1603?892,1601,894,1595?894,1590,897,1580?897,1574,900,1569?900,1566,900,1561?900,1556,900,1553?900,1550,897,1548?897,1548,894,1548?892,1548,892,1550?889,1553,886,1556?884,1561,884,1566?881,1569,881,1574?878,1580,878,1585?881,1590,881,1595?884,1601,886,1603?886,1606,892,1606?894,1609,897,1609?905,1606,910,1606?915,1603,921,1598?926,1595,937,1590?942,1585,945,1580?950,1572,950,1572995,1482,995,1482?995,1479,995,1479?995,1474,995,1479?992,1479,992,1482?992,1484,990,1490?987,1495,987,1500?982,1508,982,1513?982,1519,982,1521?982,1527,987,1529?987,1529,990,1535?992,1535,995,1535?1000,1529,1005,1529?1008,1527,1016,1527?1021,1524,1027,1521?1032,1521,1035,1519?1037,1519,1042,1519?1042,1519,1045,1519?1045,1519,1045,1521?1045,1524,1045,1527?1042,1529,1037,1535?1037,1540,1035,1543?1032,1548,1032,1550?1029,1553,1029,15531130,1397,1130,1397?1132,1389,1138,1386?1140,1384,1146,1381?1151,1381,1151,1381?1154,1381,1156,1381?1156,1381,1159,1384?1159,1384,1159,1389?1159,1392,1159,1397?1159,1402,1159,1408?1159,1413,1159,1418?1162,1426,1162,1431?1162,1434,1164,1439?1164,1442,1167,1445?1169,1447,1172,1447?1177,1453,1180,1453?1185,1453,1191,1447?1196,1447,1206,1445?1212,1442,1220,1439?1225,1434,1236,1431?1241,1429,1249,1426?1254,1421,1265,1416?1270,1416,1275,1413?1278,1410,1281,1408?1281,1408,1281,14081159,1460,1159,1460?1156,1463,1154,1466?1154,1468,1154,1468?1156,1466,1162,1463?1167,1460,1172,1458?1180,1455,1188,1447?1193,1445,1199,1439?1209,1437,1214,1431?1220,1429,1225,1426?1233,1421,1233,1421881,2267,881,2267?878,2273,878,2273?878,2273,878,2273?873,2267,873,2267?878,2265,878,2265?881,2262,884,2257?889,2254,894,2249?900,2241,908,2236?915,2228,923,2220?934,2207,945,2199?955,2185,966,2178?976,2167,990,2154?997,2146,1005,2138?1016,2130,1016,21301024,2103,1024,2103?1019,2109,1013,2114?1003,2117,1000,2122?997,2125,992,2127?990,2133,987,2138?982,2143,979,2148?979,2154,976,2159?976,2170,976,2178?976,2185,976,2199?976,2209,976,2225?979,2238,979,2254?982,2273,987,2289?987,2307,990,2323?992,2342,995,2363?997,2376,1000,2394?1003,2410,1005,2421?1008,2432,1013,2442?1016,2447,1019,2453?1021,2453,1024,24551106,2275,1106,2275?1109,2275,1109,2275?1109,2278,1109,2281?1109,2283,1106,2286?1106,2291,1103,2294?1103,2302,1103,2305?1103,2307,1103,2307?1106,2307,1106,2307?1109,2307,1111,2305?1114,2302,1119,2297?1124,2291,1130,2283?1135,2278,1138,2267?1143,2257,1146,2249?1154,2236,1156,2225?1162,2215,1164,2204?1167,2196,1169,2183?1169,2178,1172,2170?1172,2164,1172,2159?1172,2156,1169,2154?1167,2154,1164,2154?1162,2154,1159,2156?1154,2164,1146,2170?1143,2175,1138,2183?1132,2193,1130,2201?1124,2209,1119,2220?1117,2230,1114,2238?1111,2249,1111,2260?1109,2267,1109,2275?1111,2283,1111,2291?1114,2297,1117,2305?1124,2307,1127,2312?1132,2312,1138,2315?1143,2315,1151,2312?1159,2312,1164,2307?1172,2305,1180,22971315,2119,1315,2119?1315,2119,1315,2117?1315,2119,1310,2122?1310,2125,1304,2130?1302,2138,1296,2146?1291,2156,1283,2167?1278,2175,1273,2185?1270,2196,1265,2207?1262,2215,1257,2222?1257,2228,1262,2230?1262,2233,1265,2233?1270,2230,1275,2228?1281,2225,1291,2220?1296,2212,1304,2207?1310,2201,1320,2199?1326,2193,1331,2191?1334,2191,1336,2191?1339,2191,1344,2193?1344,2196,1344,2199?1344,2204,1339,2209?1336,2215,1334,2225?1328,2233,1323,2241?1318,2252,1310,2260?1304,2267,1299,2281?1291,2289,1283,2297?1278,2305,1273,2310?1267,23151357,2008,1357,2008?1363,1995,1371,1984?1376,1974,1381,1963?1384,1953,1386,1945?1392,1937,1397,1931?1400,1926,1400,1921?1400,1921,1402,1921?1402,1921,1402,1924?1402,1929,1402,1934?1400,1945,1400,1955?1397,1966,1392,1979?1389,1992,1389,2008?1386,2021,1384,2037?1384,2056,1381,2069?1381,2085,1384,2098?1384,2111,1386,2122?1389,2127,1392,2138?1397,2140,1400,2143?1402,2146,1408,2146?1413,2146,1416,2146?1421,2146,1426,2143?1431,2143,1434,2140?1437,2140,1439,2138?1442,2138,1445,2133?1445,2133,1447,2130?1447,2127,1445,2125?1445,2122,1442,2119?1437,2114,1434,2111?1429,2109,1426,2103?1416,2101,1410,2096?1405,2093,1397,2090?1386,2090,1378,2088?1371,2088,1360,2088?1349,2088,1339,2088?1331,2088,1323,2090?1318,2090,1310,20931606,2170,1606,2170?1603,2172,1603,2178?1601,2180,1598,2180?1598,2183,1598,2183?1598,2183,1598,2183?1598,2183,1601,2180?1603,2178,1606,2172?1611,2167,1619,2159?1625,2151,1630,2140?1635,2130,1646,2119?1651,2109,1656,2096?1659,2085,1662,2072?1667,2061,1672,2045?1672,2032,1675,2019?1677,2006,1677,1987?1680,1974,1680,1955?1680,1939,1683,1926?1683,1910,1683,1897?1683,1884,1680,1876?1680,1868,1677,1857?1677,1852,1675,1847?1672,1844,1667,1842?1662,1839,1659,1836?1654,1836,1651,1836?1646,1839,1643,1842?1635,1847,1632,1852?1627,1863,1625,1871?1622,1881,1619,1894?1617,1908,1611,1924?1611,1937,1611,1953?1617,1968,1619,1987?1622,2003,1625,2016?1630,2032,1635,2045?1646,2061,1651,2072?1659,2085,1667,2093?1677,2103,1685,2114?1691,2119,1701,2125?1709,2130,1714,2138?1720,2140,1728,2143?1733,2146,1736,2148?1738,21511550,1995,1550,1995?1550,1995,1553,1992?1564,1990,1572,1984?1582,1976,1598,1966?1617,1958,1632,1947?1651,1934,1675,1924?1693,1908,1717,1897?1741,1884,1765,1873?1786,1863,1786,1863]formXml[
460,2204,460,2204?455,2204,452,2204?450,2201,447,2201?444,2199,442,2196?442,2191,439,2185?434,2180,434,2172?434,2167,434,2156?439,2148,442,2138?444,2125,450,2111?455,2098,460,2085?471,2069,479,2056?487,2040,500,2027?511,2011,521,1995?532,1982,542,1966?556,1953,564,1939?577,1929,585,1918?593,1908,603,1900?609,1894,614,1894?616,1894,619,1894?622,1900,622,1905?619,1918,619,1929?616,1945,611,1958?609,1976,603,1995?595,2016,590,2040?585,2061,579,2085?577,2109,569,2130?564,2154,561,2172?558,2191,558,2201?558,2209,558,2215?561,2215,564,2212?569,2204,577,2193?582,2180,590,2167?595,2151,606,2138?614,2122,619,2111?627,2098,635,2088?643,2077,648,2072?651,2066,659,2061?664,2058,667,2058?669,2058,672,2058?675,2061,677,2066?677,2069,680,2074?680,2085,680,2093?685,2101,685,2111?685,2119,688,2130?688,2140,691,2148?691,2156,693,2159?696,2167,698,2167?701,2167,704,2159?706,2156,714,2148?717,2140,722,2130?728,2119,730,2111?736,2101,743,2090?749,2085,754,2074?759,2072,762,2066?770,2064,773,2064?773,2061,775,2064?778,2064,778,2066?781,2069,781,2072?783,2074,783,2077?783,2085,786,2088?788,2090,788,2096?791,2098,791,2101?796,2109,799,2111?799,2114,802,2117?804,2117,804,2119?807,2122,807,2122?810,2125,812,2125?815,2125,818,2122?823,2119,826,2117?831,2114,833,2111?836,2103,839,2101?841,2098,844,2096?844,2096466,1254,466,1254?460,1262,458,1265?458,1265,458,1265?458,1265,460,1265?460,1262,468,1254?471,1249,476,1244?484,1236,495,1222?503,1214,508,1206?516,1196,527,1188?534,1180,542,1172?550,1167,556,1159?564,1154,569,1151?572,1143,579,1140?582,1138,582,1138?582,1138,582,1140?579,1140,579,1146?577,1151,569,1156?566,1162,561,1169?558,1177,556,1185?553,1193,548,1201?548,1212,542,1217?542,1225,542,1233?542,1238,542,1244?542,1246,548,1249?550,1251,553,1251?556,1251,558,1251?561,1251,566,1251?569,1249,572,1249?577,1246,579,1249?579,1251,582,1257?582,1262,582,1267?582,1273,582,1275?582,1281669,1217,669,1217?672,1217,675,1214?677,1214,680,1212?685,1212,688,1209?691,1209,691,1206?693,1206,696,1201?698,1201,701,1199?701,1199,704,1196?704,1196640,1601,640,1601?632,1609,624,1619?619,1625,614,1632?609,1638,603,1646?598,1648,598,1648?598,1648,598,1648?603,1646,609,1638?614,1632,622,1627?632,1619,643,1609?651,1601,661,1593?672,1582,680,1574?691,1566,698,1561?706,1550,714,1548?722,1543,728,1540?730,1535,736,1535?741,1529,743,1529?743,1527,743,1527?746,1529,746,1535?746,1537,746,1540?746,1543,743,1545?743,1550,743,1553?741,1561,741,1564?741,1572,743,1577?743,1582,743,1593?743,1601,746,1609?746,1619,746,1627?746,1632,749,1643?749,1648,751,1656?754,1662,754,1664?757,1672,759,1675857,1638,857,1638?860,1638,860,1638?863,1635,865,1635?868,1635,870,1632?873,1630,873,1627?878,1625,881,1622?884,1619,884,1617?886,1609,889,1603?892,1601,894,1595?894,1590,897,1580?897,1574,900,1569?900,1566,900,1561?900,1556,900,1553?900,1550,897,1548?897,1548,894,1548?892,1548,892,1550?889,1553,886,1556?884,1561,884,1566?881,1569,881,1574?878,1580,878,1585?881,1590,881,1595?884,1601,886,1603?886,1606,892,1606?894,1609,897,1609?905,1606,910,1606?915,1603,921,1598?926,1595,937,1590?942,1585,945,1580?950,1572,950,1572995,1482,995,1482?995,1479,995,1479?995,1474,995,1479?992,1479,992,1482?992,1484,990,1490?987,1495,987,1500?982,1508,982,1513?982,1519,982,1521?982,1527,987,1529?987,1529,990,1535?992,1535,995,1535?1000,1529,1005,1529?1008,1527,1016,1527?1021,1524,1027,1521?1032,1521,1035,1519?1037,1519,1042,1519?1042,1519,1045,1519?1045,1519,1045,1521?1045,1524,1045,1527?1042,1529,1037,1535?1037,1540,1035,1543?1032,1548,1032,1550?1029,1553,1029,15531130,1397,1130,1397?1132,1389,1138,1386?1140,1384,1146,1381?1151,1381,1151,1381?1154,1381,1156,1381?1156,1381,1159,1384?1159,1384,1159,1389?1159,1392,1159,1397?1159,1402,1159,1408?1159,1413,1159,1418?1162,1426,1162,1431?1162,1434,1164,1439?1164,1442,1167,1445?1169,1447,1172,1447?1177,1453,1180,1453?1185,1453,1191,1447?1196,1447,1206,1445?1212,1442,1220,1439?1225,1434,1236,1431?1241,1429,1249,1426?1254,1421,1265,1416?1270,1416,1275,1413?1278,1410,1281,1408?1281,1408,1281,14081159,1460,1159,1460?1156,1463,1154,1466?1154,1468,1154,1468?1156,1466,1162,1463?1167,1460,1172,1458?1180,1455,1188,1447?1193,1445,1199,1439?1209,1437,1214,1431?1220,1429,1225,1426?1233,1421,1233,1421881,2267,881,2267?878,2273,878,2273?878,2273,878,2273?873,2267,873,2267?878,2265,878,2265?881,2262,884,2257?889,2254,894,2249?900,2241,908,2236?915,2228,923,2220?934,2207,945,2199?955,2185,966,2178?976,2167,990,2154?997,2146,1005,2138?1016,2130,1016,21301024,2103,1024,2103?1019,2109,1013,2114?1003,2117,1000,2122?997,2125,992,2127?990,2133,987,2138?982,2143,979,2148?979,2154,976,2159?976,2170,976,2178?976,2185,976,2199?976,2209,976,2225?979,2238,979,2254?982,2273,987,2289?987,2307,990,2323?992,2342,995,2363?997,2376,1000,2394?1003,2410,1005,2421?1008,2432,1013,2442?1016,2447,1019,2453?1021,2453,1024,24551106,2275,1106,2275?1109,2275,1109,2275?1109,2278,1109,2281?1109,2283,1106,2286?1106,2291,1103,2294?1103,2302,1103,2305?1103,2307,1103,2307?1106,2307,1106,2307?1109,2307,1111,2305?1114,2302,1119,2297?1124,2291,1130,2283?1135,2278,1138,2267?1143,2257,1146,2249?1154,2236,1156,2225?1162,2215,1164,2204?1167,2196,1169,2183?1169,2178,1172,2170?1172,2164,1172,2159?1172,2156,1169,2154?1167,2154,1164,2154?1162,2154,1159,2156?1154,2164,1146,2170?1143,2175,1138,2183?1132,2193,1130,2201?1124,2209,1119,2220?1117,2230,1114,2238?1111,2249,1111,2260?1109,2267,1109,2275?1111,2283,1111,2291?1114,2297,1117,2305?1124,2307,1127,2312?1132,2312,1138,2315?1143,2315,1151,2312?1159,2312,1164,2307?1172,2305,1180,22971315,2119,1315,2119?1315,2119,1315,2117?1315,2119,1310,2122?1310,2125,1304,2130?1302,2138,1296,2146?1291,2156,1283,2167?1278,2175,1273,2185?1270,2196,1265,2207?1262,2215,1257,2222?1257,2228,1262,2230?1262,2233,1265,2233?1270,2230,1275,2228?1281,2225,1291,2220?1296,2212,1304,2207?1310,2201,1320,2199?1326,2193,1331,2191?1334,2191,1336,2191?1339,2191,1344,2193?1344,2196,1344,2199?1344,2204,1339,2209?1336,2215,1334,2225?1328,2233,1323,2241?1318,2252,1310,2260?1304,2267,1299,2281?1291,2289,1283,2297?1278,2305,1273,2310?1267,23151357,2008,1357,2008?1363,1995,1371,1984?1376,1974,1381,1963?1384,1953,1386,1945?1392,1937,1397,1931?1400,1926,1400,1921?1400,1921,1402,1921?1402,1921,1402,1924?1402,1929,1402,1934?1400,1945,1400,1955?1397,1966,1392,1979?1389,1992,1389,2008?1386,2021,1384,2037?1384,2056,1381,2069?1381,2085,1384,2098?1384,2111,1386,2122?1389,2127,1392,2138?1397,2140,1400,2143?1402,2146,1408,2146?1413,2146,1416,2146?1421,2146,1426,2143?1431,2143,1434,2140?1437,2140,1439,2138?1442,2138,1445,2133?1445,2133,1447,2130?1447,2127,1445,2125?1445,2122,1442,2119?1437,2114,1434,2111?1429,2109,1426,2103?1416,2101,1410,2096?1405,2093,1397,2090?1386,2090,1378,2088?1371,2088,1360,2088?1349,2088,1339,2088?1331,2088,1323,2090?1318,2090,1310,20931606,2170,1606,2170?1603,2172,1603,2178?1601,2180,1598,2180?1598,2183,1598,2183?1598,2183,1598,2183?1598,2183,1601,2180?1603,2178,1606,2172?1611,2167,1619,2159?1625,2151,1630,2140?1635,2130,1646,2119?1651,2109,1656,2096?1659,2085,1662,2072?1667,2061,1672,2045?1672,2032,1675,2019?1677,2006,1677,1987?1680,1974,1680,1955?1680,1939,1683,1926?1683,1910,1683,1897?1683,1884,1680,1876?1680,1868,1677,1857?1677,1852,1675,1847?1672,1844,1667,1842?1662,1839,1659,1836?1654,1836,1651,1836?1646,1839,1643,1842?1635,1847,1632,1852?1627,1863,1625,1871?1622,1881,1619,1894?1617,1908,1611,1924?1611,1937,1611,1953?1617,1968,1619,1987?1622,2003,1625,2016?1630,2032,1635,2045?1646,2061,1651,2072?1659,2085,1667,2093?1677,2103,1685,2114?1691,2119,1701,2125?1709,2130,1714,2138?1720,2140,1728,2143?1733,2146,1736,2148?1738,21511550,1995,1550,1995?1550,1995,1553,1992?1564,1990,1572,1984?1582,1976,1598,1966?1617,1958,1632,1947?1651,1934,1675,1924?1693,1908,1717,1897?1741,1884,1765,1873?1786,1863,1786,1863
]certResult[] [Logging Date Time: 2016-11-10 11:05:52,978] ===================================================================================== SQL Command - Statement Id: [GET_SEQUENCE] PreparedStatement : [select ud1_num as seq from EFORM_CODE where main_cd = 'SEQUENCE' and sub_cd = :param0 for update] [Logging Date Time: 2016-11-10 11:05:52,978] ===================================================================================== SQL Command - Statement Id: [GET_SEQUENCE] PreparedStatement : [select ud1_num as seq from EFORM_CODE where main_cd = 'SEQUENCE' and sub_cd = :param0 for update] [Logging Date Time: 2016-11-10 11:05:52,979] ===================================================================================== SQL Command - Statement Id: [GET_SEQUENCE] Parameters: [param0=[sub_cd,CONSENT_DATA]] [Logging Date Time: 2016-11-10 11:05:52,979] ===================================================================================== SQL Command - Statement Id: [GET_SEQUENCE] Parameters: [param0=[sub_cd,CONSENT_DATA]] [Logging Date Time: 2016-11-10 11:05:52,979] ===================================================================================== SQL Command - Statement Id: [GET_SEQUENCE] Types: [param0=[AnsiString, System.String]] [Logging Date Time: 2016-11-10 11:05:52,979] ===================================================================================== SQL Command - Statement Id: [GET_SEQUENCE] Types: [param0=[AnsiString, System.String]] [Logging Date Time: 2016-11-10 11:05:52,987] ===================================================================================== SQL Command - Statement Id: [UPDATE_SEQUENCE] PreparedStatement : [update EFORM_CODE set ud1_num = :param0 where main_cd = 'SEQUENCE' and sub_cd = :param1] [Logging Date Time: 2016-11-10 11:05:52,987] ===================================================================================== SQL Command - Statement Id: [UPDATE_SEQUENCE] PreparedStatement : [update EFORM_CODE set ud1_num = :param0 where main_cd = 'SEQUENCE' and sub_cd = :param1] [Logging Date Time: 2016-11-10 11:05:52,989] ===================================================================================== SQL Command - Statement Id: [UPDATE_SEQUENCE] Parameters: [param0=[ud1_num,1793], param1=[sub_cd,CONSENT_DATA]] [Logging Date Time: 2016-11-10 11:05:52,989] ===================================================================================== SQL Command - Statement Id: [UPDATE_SEQUENCE] Parameters: [param0=[ud1_num,1793], param1=[sub_cd,CONSENT_DATA]] [Logging Date Time: 2016-11-10 11:05:52,989] ===================================================================================== SQL Command - Statement Id: [UPDATE_SEQUENCE] Types: [param0=[Int32, System.Int32], param1=[AnsiString, System.String]] [Logging Date Time: 2016-11-10 11:05:52,989] ===================================================================================== SQL Command - Statement Id: [UPDATE_SEQUENCE] Types: [param0=[Int32, System.Int32], param1=[AnsiString, System.String]] [Logging Date Time: 2016-11-10 11:06:04,314] ===================================================================================== SQL Command - Statement Id: [UPDATE_CONSENT_MST] PreparedStatement : [UPDATE CONSENT_MST SET CONSENT_STATE = :param0 , COMPLETE_YN = :param1 , COMPLETE_DATETIME = TO_CHAR(SYSDATE,'YYYY-MM-DD hh24:mi:ss'), PAPER_YN = :param2 , MODIFY_USER_ID = :param3 , MODIFY_DATETIME = TO_CHAR(SYSDATE,'yyyy-mm-dd hh24:mi:ss'), MODIFY_USER_NAME = COM.FN_ZS_GETUSERNM( :param3 , TO_CHAR(SYSDATE, 'YYYYMMDD')) WHERE CONSENT_MST_RID = :param4] [Logging Date Time: 2016-11-10 11:06:04,314] ===================================================================================== SQL Command - Statement Id: [UPDATE_CONSENT_MST] PreparedStatement : [UPDATE CONSENT_MST SET CONSENT_STATE = :param0 , COMPLETE_YN = :param1 , COMPLETE_DATETIME = TO_CHAR(SYSDATE,'YYYY-MM-DD hh24:mi:ss'), PAPER_YN = :param2 , MODIFY_USER_ID = :param3 , MODIFY_DATETIME = TO_CHAR(SYSDATE,'yyyy-mm-dd hh24:mi:ss'), MODIFY_USER_NAME = COM.FN_ZS_GETUSERNM( :param3 , TO_CHAR(SYSDATE, 'YYYYMMDD')) WHERE CONSENT_MST_RID = :param4] [Logging Date Time: 2016-11-10 11:06:04,314] ===================================================================================== SQL Command - Statement Id: [UPDATE_CONSENT_MST] Parameters: [param0=[consentState,ELECTR_CMP], param1=[completeYn,Y], param2=[paperYn,N], param3=[userId,105066], param4=[consentMstRid,1842]] [Logging Date Time: 2016-11-10 11:06:04,314] ===================================================================================== SQL Command - Statement Id: [UPDATE_CONSENT_MST] Parameters: [param0=[consentState,ELECTR_CMP], param1=[completeYn,Y], param2=[paperYn,N], param3=[userId,105066], param4=[consentMstRid,1842]] [Logging Date Time: 2016-11-10 11:06:04,314] ===================================================================================== SQL Command - Statement Id: [UPDATE_CONSENT_MST] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String], param3=[AnsiString, System.String], param4=[Int32, System.Int32]] [Logging Date Time: 2016-11-10 11:06:04,314] ===================================================================================== SQL Command - Statement Id: [UPDATE_CONSENT_MST] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String], param3=[AnsiString, System.String], param4=[Int32, System.Int32]] [Logging Date Time: 2016-11-10 11:06:06,338] ===================================================================================== SQL Command - Statement Id: [INSERT_CONSENT_DATA] PreparedStatement : [insert into CONSENT_DATA ( CONSENT_DATA_RID, CONSENT_MST_RID, FORM_RID, DEVICE_TYPE, DEVICE_IDENT_NO, COMPLETE_YN, CREATE_USER_ID, CREATE_DATETIME, FORM_XML, DATA_XML ) values ( :param0 , :param1 , :param2 , :param3 , :param4 , :param5 , :param6 , TO_CHAR(SYSDATE,'yyyy-mm-dd hh24:mi:ss'), :param7 , :param8 )] [Logging Date Time: 2016-11-10 11:06:06,338] ===================================================================================== SQL Command - Statement Id: [INSERT_CONSENT_DATA] PreparedStatement : [insert into CONSENT_DATA ( CONSENT_DATA_RID, CONSENT_MST_RID, FORM_RID, DEVICE_TYPE, DEVICE_IDENT_NO, COMPLETE_YN, CREATE_USER_ID, CREATE_DATETIME, FORM_XML, DATA_XML ) values ( :param0 , :param1 , :param2 , :param3 , :param4 , :param5 , :param6 , TO_CHAR(SYSDATE,'yyyy-mm-dd hh24:mi:ss'), :param7 , :param8 )] [Logging Date Time: 2016-11-10 11:06:06,339] ===================================================================================== SQL Command - Statement Id: [INSERT_CONSENT_DATA] Parameters: [param0=[consentDataRid,1793], param1=[consentMstRid,1842], param2=[formRid,1307], param3=[deviceType,WIN], param4=[deviceIdentNo,16-101-33], param5=[completeYn,Y], param6=[userId,105066], param7=[formXml,System.Byte[]], param8=[dataXml,System.Byte[]]] [Logging Date Time: 2016-11-10 11:06:06,339] ===================================================================================== SQL Command - Statement Id: [INSERT_CONSENT_DATA] Parameters: [param0=[consentDataRid,1793], param1=[consentMstRid,1842], param2=[formRid,1307], param3=[deviceType,WIN], param4=[deviceIdentNo,16-101-33], param5=[completeYn,Y], param6=[userId,105066], param7=[formXml,System.Byte[]], param8=[dataXml,System.Byte[]]] [Logging Date Time: 2016-11-10 11:06:06,339] ===================================================================================== SQL Command - Statement Id: [INSERT_CONSENT_DATA] Types: [param0=[Int32, System.Int32], param1=[Int32, System.Int32], param2=[Int32, System.Int32], param3=[AnsiString, System.String], param4=[AnsiString, System.String], param5=[AnsiString, System.String], param6=[AnsiString, System.String], param7=[Binary, System.Byte[]], param8=[Binary, System.Byte[]]] [Logging Date Time: 2016-11-10 11:06:06,339] ===================================================================================== SQL Command - Statement Id: [INSERT_CONSENT_DATA] Types: [param0=[Int32, System.Int32], param1=[Int32, System.Int32], param2=[Int32, System.Int32], param3=[AnsiString, System.String], param4=[AnsiString, System.String], param5=[AnsiString, System.String], param6=[AnsiString, System.String], param7=[Binary, System.Byte[]], param8=[Binary, System.Byte[]]] [Logging Date Time: 2016-11-10 11:06:23,887] ===================================================================================== SQL Command - CLIP.eForm SaveDataAll ERROR : [System.NullReferenceException: 개체 참조가 개체의 인스턴스로 설정되지 않았습니다. 위치: CLIP.eForm.Consent.Dfh.WebService.ConsentSvc.imageUpload(SaveConsentDac dac, Hashtable paramHashTable, String userId, String patientCode, String visitType, String clnDate, String Dschdd, Int32 cretno, String ocrcode, Int32 consentMstRid, String consentState, String formCd, Int32 formRid, String dataXml, String imageFileJson, String certTarget, String certResult, String hosType, String createUserName) 파일 D:\TeamDFH_Consent\DFH-Consent\CLIP.e-Form.Consent.Dfh.Web\ConsentSvc.asmx.cs:줄 971 위치: CLIP.eForm.Consent.Dfh.WebService.ConsentSvc.SaveDataAll(String userId, String patientCode, String clnDeptCode, Int32 formRid, String formCd, Int32 consentMstRid, Int32 rewriteConsentMstRid, Int32 reissueConsentMstRid, String consentState, String paperYn, String formXml, String dataXml, String deviceType, String deviceIdentNo, String vistType, String hosType, String clnDate, String ward, String roomcd, String reasonForUseN, Int32 orderNo, String orderName, String orderCd, String ocrCode, Int32 cretno, String createUserName, String modifyUserName, String imageFileJson, String certTarget, String certResult, String dschdd, String mainDrId) 파일 D:\TeamDFH_Consent\DFH-Consent\CLIP.e-Form.Consent.Dfh.Web\ConsentSvc.asmx.cs:줄 901] [Logging Date Time: 2016-11-10 11:12:47,582] ===================================================================================== SQL Command - Statement Id: [getDeptList] PreparedStatement : [SELECT ' ' as deptcd, '진료과' as deptnm, 0 as clincdeptdispseq, 0 as sort from dual UNION ALL SELECT deptcd, depthngnm as deptnm, clincdeptdispseq, 1 as sort FROM com.zsdddept WHERE instcd = :param0 AND TO_CHAR(CURRENT_DATE,'YYYYMMDD')>=valifromdd AND TO_CHAR(CURRENT_DATE,'YYYYMMDD')<=valitodd AND rcptuseyn = 'Y' ORDER BY clincdeptdispseq ASC] [Logging Date Time: 2016-11-10 11:12:47,582] ===================================================================================== SQL Command - Statement Id: [getDeptList] PreparedStatement : [SELECT ' ' as deptcd, '진료과' as deptnm, 0 as clincdeptdispseq, 0 as sort from dual UNION ALL SELECT deptcd, depthngnm as deptnm, clincdeptdispseq, 1 as sort FROM com.zsdddept WHERE instcd = :param0 AND TO_CHAR(CURRENT_DATE,'YYYYMMDD')>=valifromdd AND TO_CHAR(CURRENT_DATE,'YYYYMMDD')<=valitodd AND rcptuseyn = 'Y' ORDER BY clincdeptdispseq ASC] [Logging Date Time: 2016-11-10 11:12:47,633] ===================================================================================== SQL Command - Statement Id: [getDeptList] Parameters: [param0=[instcd,111]] [Logging Date Time: 2016-11-10 11:12:47,633] ===================================================================================== SQL Command - Statement Id: [getDeptList] Parameters: [param0=[instcd,111]] [Logging Date Time: 2016-11-10 11:12:47,633] ===================================================================================== SQL Command - Statement Id: [getDeptList] Types: [param0=[AnsiString, System.String]] [Logging Date Time: 2016-11-10 11:12:47,633] ===================================================================================== SQL Command - Statement Id: [getDeptList] Types: [param0=[AnsiString, System.String]] [Logging Date Time: 2016-11-10 11:12:47,847] ===================================================================================== SQL Command - Statement Id: [getDocList] PreparedStatement : [SELECT ' ' as doctorid, '진료의' as doctornm, 1 as sort from dual UNION ALL SELECT b.userid AS doctorid, b.usernm AS doctornm, 2 as sort FROM com.zsumusrd a INNER JOIN com.zsumusrb b ON a.userid = b.userid WHERE a.psnworkyn = 'N' AND a.dutplceinstcd = :param0 AND a.jobkindcd LIKE '03%' AND a.dutplcecd = :param1 AND :param2 BETWEEN a.fromdd AND a.todd AND :param2 BETWEEN b.userfromdd AND b.usertodd ORDER BY sort, doctorid] [Logging Date Time: 2016-11-10 11:12:47,847] ===================================================================================== SQL Command - Statement Id: [getDocList] PreparedStatement : [SELECT ' ' as doctorid, '진료의' as doctornm, 1 as sort from dual UNION ALL SELECT b.userid AS doctorid, b.usernm AS doctornm, 2 as sort FROM com.zsumusrd a INNER JOIN com.zsumusrb b ON a.userid = b.userid WHERE a.psnworkyn = 'N' AND a.dutplceinstcd = :param0 AND a.jobkindcd LIKE '03%' AND a.dutplcecd = :param1 AND :param2 BETWEEN a.fromdd AND a.todd AND :param2 BETWEEN b.userfromdd AND b.usertodd ORDER BY sort, doctorid] [Logging Date Time: 2016-11-10 11:12:47,847] ===================================================================================== SQL Command - Statement Id: [getDocList] Parameters: [param0=[instcd,111], param1=[orddeptcd, ], param2=[srchdd,20161110]] [Logging Date Time: 2016-11-10 11:12:47,847] ===================================================================================== SQL Command - Statement Id: [getDocList] Parameters: [param0=[instcd,111], param1=[orddeptcd, ], param2=[srchdd,20161110]] [Logging Date Time: 2016-11-10 11:12:47,847] ===================================================================================== SQL Command - Statement Id: [getDocList] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String]] [Logging Date Time: 2016-11-10 11:12:47,847] ===================================================================================== SQL Command - Statement Id: [getDocList] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String]] [Logging Date Time: 2016-11-10 11:12:48,493] ===================================================================================== SQL Command - Statement Id: [GET_USER_INFO] PreparedStatement : [select a.userid, a.usernm, b.dutplcecd, dept.depthngnm, dept.deptengabbr, b.jobkindcd, (select cdnm from com.zbcmcode code where code.cdgrupid = 'R0061' and code.cdid = b.jobkindcd and code.valitodd = '99991231') from com.zsumusrb a, com.zsumusrd b, com.zsdddept dept where a.dutinstcd = '111' and a.dutinstcd = b.dutplceinstcd and a.userid = b.userid and a.usertodd = b.todd and dept.instcd = a.dutinstcd and dept.deptcd = b.dutplcecd and dept.valitodd = '99991231' and b.psnworkyn = 'Y' and a.usertodd = '99991231' and b.userid = :param0] [Logging Date Time: 2016-11-10 11:12:48,493] ===================================================================================== SQL Command - Statement Id: [GET_USER_INFO] PreparedStatement : [select a.userid, a.usernm, b.dutplcecd, dept.depthngnm, dept.deptengabbr, b.jobkindcd, (select cdnm from com.zbcmcode code where code.cdgrupid = 'R0061' and code.cdid = b.jobkindcd and code.valitodd = '99991231') from com.zsumusrb a, com.zsumusrd b, com.zsdddept dept where a.dutinstcd = '111' and a.dutinstcd = b.dutplceinstcd and a.userid = b.userid and a.usertodd = b.todd and dept.instcd = a.dutinstcd and dept.deptcd = b.dutplcecd and dept.valitodd = '99991231' and b.psnworkyn = 'Y' and a.usertodd = '99991231' and b.userid = :param0] [Logging Date Time: 2016-11-10 11:12:48,493] ===================================================================================== SQL Command - Statement Id: [GET_USER_INFO] Parameters: [param0=[userid,104806]] [Logging Date Time: 2016-11-10 11:12:48,493] ===================================================================================== SQL Command - Statement Id: [GET_USER_INFO] Parameters: [param0=[userid,104806]] [Logging Date Time: 2016-11-10 11:12:48,493] ===================================================================================== SQL Command - Statement Id: [GET_USER_INFO] Types: [param0=[AnsiString, System.String]] [Logging Date Time: 2016-11-10 11:12:48,493] ===================================================================================== SQL Command - Statement Id: [GET_USER_INFO] Types: [param0=[AnsiString, System.String]] [Logging Date Time: 2016-11-10 11:12:48,731] ===================================================================================== SQL Command - Statement Id: [GET_TRMT_DATE_LIST] PreparedStatement : [SELECT indd as ClnDate, substr(indd, 1, 4) || '-' || substr(indd, 5, 2) || '-' || substr(indd, 7, 2) as ClnFormatDate, inpt.ordtype as VisitType, case when ordtype = 'O' then '외래' when ordtype = 'I' then '입원' when ordtype = 'E' then '응급' end as VisitTypeName, dept.deptengabbr as ClnDeptCode, dept.depthngnm as ClnDeptName, inpt.cretno FROM pam.pmihinpt inpt left outer join com.zsdddept dept on (dept.instcd = inpt.instcd and dept.deptcd = inpt.orddeptcd and dept.valitodd = '99991231') WHERE inpt.instcd = :param0 AND inpt.pid = :param1 AND inpt.indd = :param2 AND inpt.histstat = 'Y' AND inpt.mskind = 'M' union all SELECT orddd as ClnDate, substr(orddd, 1, 4) || '-' || substr(orddd, 5, 2) || '-' || substr(orddd, 7, 2) as ClnFormatDate, otpt.ordtype as VisitType, case when ordtype = 'O' then '외래' when ordtype = 'I' then '입원' when ordtype = 'E' then '응급' end as VisitTypeName, dept.deptengabbr as ClnDeptCode, dept.depthngnm as ClnDeptName, otpt.cretno FROM pam.pmohotpt otpt left outer join com.zsdddept dept on (dept.instcd = otpt.instcd and dept.deptcd = otpt.orddeptcd and dept.valitodd = '99991231') WHERE otpt.instcd = :param0 AND otpt.pid = :param1 AND otpt.orddd = :param2] [Logging Date Time: 2016-11-10 11:12:48,731] ===================================================================================== SQL Command - Statement Id: [GET_TRMT_DATE_LIST] PreparedStatement : [SELECT indd as ClnDate, substr(indd, 1, 4) || '-' || substr(indd, 5, 2) || '-' || substr(indd, 7, 2) as ClnFormatDate, inpt.ordtype as VisitType, case when ordtype = 'O' then '외래' when ordtype = 'I' then '입원' when ordtype = 'E' then '응급' end as VisitTypeName, dept.deptengabbr as ClnDeptCode, dept.depthngnm as ClnDeptName, inpt.cretno FROM pam.pmihinpt inpt left outer join com.zsdddept dept on (dept.instcd = inpt.instcd and dept.deptcd = inpt.orddeptcd and dept.valitodd = '99991231') WHERE inpt.instcd = :param0 AND inpt.pid = :param1 AND inpt.indd = :param2 AND inpt.histstat = 'Y' AND inpt.mskind = 'M' union all SELECT orddd as ClnDate, substr(orddd, 1, 4) || '-' || substr(orddd, 5, 2) || '-' || substr(orddd, 7, 2) as ClnFormatDate, otpt.ordtype as VisitType, case when ordtype = 'O' then '외래' when ordtype = 'I' then '입원' when ordtype = 'E' then '응급' end as VisitTypeName, dept.deptengabbr as ClnDeptCode, dept.depthngnm as ClnDeptName, otpt.cretno FROM pam.pmohotpt otpt left outer join com.zsdddept dept on (dept.instcd = otpt.instcd and dept.deptcd = otpt.orddeptcd and dept.valitodd = '99991231') WHERE otpt.instcd = :param0 AND otpt.pid = :param1 AND otpt.orddd = :param2] [Logging Date Time: 2016-11-10 11:12:48,731] ===================================================================================== SQL Command - Statement Id: [GET_TRMT_DATE_LIST] Parameters: [param0=[instcd,111], param1=[pid,], param2=[searchClnDate,false]] [Logging Date Time: 2016-11-10 11:12:48,731] ===================================================================================== SQL Command - Statement Id: [GET_TRMT_DATE_LIST] Parameters: [param0=[instcd,111], param1=[pid,], param2=[searchClnDate,false]] [Logging Date Time: 2016-11-10 11:12:48,732] ===================================================================================== SQL Command - Statement Id: [GET_TRMT_DATE_LIST] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String]] [Logging Date Time: 2016-11-10 11:12:48,732] ===================================================================================== SQL Command - Statement Id: [GET_TRMT_DATE_LIST] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String]] [Logging Date Time: 2016-11-10 11:12:48,799] ===================================================================================== SQL Command - Statement Id: [GET_TRMT_DATE_LIST] PreparedStatement : [SELECT indd as ClnDate, substr(indd, 1, 4) || '-' || substr(indd, 5, 2) || '-' || substr(indd, 7, 2) as ClnFormatDate, inpt.ordtype as VisitType, case when ordtype = 'O' then '외래' when ordtype = 'I' then '입원' when ordtype = 'E' then '응급' end as VisitTypeName, dept.deptengabbr as ClnDeptCode, dept.depthngnm as ClnDeptName, inpt.cretno FROM pam.pmihinpt inpt left outer join com.zsdddept dept on (dept.instcd = inpt.instcd and dept.deptcd = inpt.orddeptcd and dept.valitodd = '99991231') WHERE inpt.instcd = :param0 AND inpt.pid = :param1 AND inpt.indd = :param2 AND inpt.histstat = 'Y' AND inpt.mskind = 'M' union all SELECT orddd as ClnDate, substr(orddd, 1, 4) || '-' || substr(orddd, 5, 2) || '-' || substr(orddd, 7, 2) as ClnFormatDate, otpt.ordtype as VisitType, case when ordtype = 'O' then '외래' when ordtype = 'I' then '입원' when ordtype = 'E' then '응급' end as VisitTypeName, dept.deptengabbr as ClnDeptCode, dept.depthngnm as ClnDeptName, otpt.cretno FROM pam.pmohotpt otpt left outer join com.zsdddept dept on (dept.instcd = otpt.instcd and dept.deptcd = otpt.orddeptcd and dept.valitodd = '99991231') WHERE otpt.instcd = :param0 AND otpt.pid = :param1 AND otpt.orddd = :param2] [Logging Date Time: 2016-11-10 11:12:48,799] ===================================================================================== SQL Command - Statement Id: [GET_TRMT_DATE_LIST] PreparedStatement : [SELECT indd as ClnDate, substr(indd, 1, 4) || '-' || substr(indd, 5, 2) || '-' || substr(indd, 7, 2) as ClnFormatDate, inpt.ordtype as VisitType, case when ordtype = 'O' then '외래' when ordtype = 'I' then '입원' when ordtype = 'E' then '응급' end as VisitTypeName, dept.deptengabbr as ClnDeptCode, dept.depthngnm as ClnDeptName, inpt.cretno FROM pam.pmihinpt inpt left outer join com.zsdddept dept on (dept.instcd = inpt.instcd and dept.deptcd = inpt.orddeptcd and dept.valitodd = '99991231') WHERE inpt.instcd = :param0 AND inpt.pid = :param1 AND inpt.indd = :param2 AND inpt.histstat = 'Y' AND inpt.mskind = 'M' union all SELECT orddd as ClnDate, substr(orddd, 1, 4) || '-' || substr(orddd, 5, 2) || '-' || substr(orddd, 7, 2) as ClnFormatDate, otpt.ordtype as VisitType, case when ordtype = 'O' then '외래' when ordtype = 'I' then '입원' when ordtype = 'E' then '응급' end as VisitTypeName, dept.deptengabbr as ClnDeptCode, dept.depthngnm as ClnDeptName, otpt.cretno FROM pam.pmohotpt otpt left outer join com.zsdddept dept on (dept.instcd = otpt.instcd and dept.deptcd = otpt.orddeptcd and dept.valitodd = '99991231') WHERE otpt.instcd = :param0 AND otpt.pid = :param1 AND otpt.orddd = :param2] [Logging Date Time: 2016-11-10 11:12:48,800] ===================================================================================== SQL Command - Statement Id: [GET_TRMT_DATE_LIST] Parameters: [param0=[instcd,111], param1=[pid,], param2=[searchClnDate,false]] [Logging Date Time: 2016-11-10 11:12:48,800] ===================================================================================== SQL Command - Statement Id: [GET_TRMT_DATE_LIST] Parameters: [param0=[instcd,111], param1=[pid,], param2=[searchClnDate,false]] [Logging Date Time: 2016-11-10 11:12:48,800] ===================================================================================== SQL Command - Statement Id: [GET_TRMT_DATE_LIST] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String]] [Logging Date Time: 2016-11-10 11:12:48,800] ===================================================================================== SQL Command - Statement Id: [GET_TRMT_DATE_LIST] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String]] [Logging Date Time: 2016-11-10 11:12:49,025] ===================================================================================== SQL Command - Statement Id: [getDeptList] PreparedStatement : [SELECT ' ' as deptcd, '진료과' as deptnm, 0 as clincdeptdispseq, 0 as sort from dual UNION ALL SELECT deptcd, depthngnm as deptnm, clincdeptdispseq, 1 as sort FROM com.zsdddept WHERE instcd = :param0 AND TO_CHAR(CURRENT_DATE,'YYYYMMDD')>=valifromdd AND TO_CHAR(CURRENT_DATE,'YYYYMMDD')<=valitodd AND rcptuseyn = 'Y' ORDER BY clincdeptdispseq ASC] [Logging Date Time: 2016-11-10 11:12:49,025] ===================================================================================== SQL Command - Statement Id: [getDeptList] PreparedStatement : [SELECT ' ' as deptcd, '진료과' as deptnm, 0 as clincdeptdispseq, 0 as sort from dual UNION ALL SELECT deptcd, depthngnm as deptnm, clincdeptdispseq, 1 as sort FROM com.zsdddept WHERE instcd = :param0 AND TO_CHAR(CURRENT_DATE,'YYYYMMDD')>=valifromdd AND TO_CHAR(CURRENT_DATE,'YYYYMMDD')<=valitodd AND rcptuseyn = 'Y' ORDER BY clincdeptdispseq ASC] [Logging Date Time: 2016-11-10 11:12:49,026] ===================================================================================== SQL Command - Statement Id: [getDeptList] Parameters: [param0=[instcd,111]] [Logging Date Time: 2016-11-10 11:12:49,026] ===================================================================================== SQL Command - Statement Id: [getDeptList] Parameters: [param0=[instcd,111]] [Logging Date Time: 2016-11-10 11:12:49,026] ===================================================================================== SQL Command - Statement Id: [getDeptList] Types: [param0=[AnsiString, System.String]] [Logging Date Time: 2016-11-10 11:12:49,026] ===================================================================================== SQL Command - Statement Id: [getDeptList] Types: [param0=[AnsiString, System.String]] [Logging Date Time: 2016-11-10 11:12:49,117] ===================================================================================== SQL Command - Statement Id: [getDocList] PreparedStatement : [SELECT ' ' as doctorid, '진료의' as doctornm, 1 as sort from dual UNION ALL SELECT b.userid AS doctorid, b.usernm AS doctornm, 2 as sort FROM com.zsumusrd a INNER JOIN com.zsumusrb b ON a.userid = b.userid WHERE a.psnworkyn = 'N' AND a.dutplceinstcd = :param0 AND a.jobkindcd LIKE '03%' AND a.dutplcecd = :param1 AND :param2 BETWEEN a.fromdd AND a.todd AND :param2 BETWEEN b.userfromdd AND b.usertodd ORDER BY sort, doctorid] [Logging Date Time: 2016-11-10 11:12:49,117] ===================================================================================== SQL Command - Statement Id: [getDocList] PreparedStatement : [SELECT ' ' as doctorid, '진료의' as doctornm, 1 as sort from dual UNION ALL SELECT b.userid AS doctorid, b.usernm AS doctornm, 2 as sort FROM com.zsumusrd a INNER JOIN com.zsumusrb b ON a.userid = b.userid WHERE a.psnworkyn = 'N' AND a.dutplceinstcd = :param0 AND a.jobkindcd LIKE '03%' AND a.dutplcecd = :param1 AND :param2 BETWEEN a.fromdd AND a.todd AND :param2 BETWEEN b.userfromdd AND b.usertodd ORDER BY sort, doctorid] [Logging Date Time: 2016-11-10 11:12:49,118] ===================================================================================== SQL Command - Statement Id: [getDocList] Parameters: [param0=[instcd,111], param1=[orddeptcd, ], param2=[srchdd,20161110]] [Logging Date Time: 2016-11-10 11:12:49,118] ===================================================================================== SQL Command - Statement Id: [getDocList] Parameters: [param0=[instcd,111], param1=[orddeptcd, ], param2=[srchdd,20161110]] [Logging Date Time: 2016-11-10 11:12:49,118] ===================================================================================== SQL Command - Statement Id: [getDocList] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String]] [Logging Date Time: 2016-11-10 11:12:49,118] ===================================================================================== SQL Command - Statement Id: [getDocList] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String]] [Logging Date Time: 2016-11-10 11:12:57,250] ===================================================================================== SQL Command - Statement Id: [getDocList] PreparedStatement : [SELECT ' ' as doctorid, '진료의' as doctornm, 1 as sort from dual UNION ALL SELECT b.userid AS doctorid, b.usernm AS doctornm, 2 as sort FROM com.zsumusrd a INNER JOIN com.zsumusrb b ON a.userid = b.userid WHERE a.psnworkyn = 'N' AND a.dutplceinstcd = :param0 AND a.jobkindcd LIKE '03%' AND a.dutplcecd = :param1 AND :param2 BETWEEN a.fromdd AND a.todd AND :param2 BETWEEN b.userfromdd AND b.usertodd ORDER BY sort, doctorid] [Logging Date Time: 2016-11-10 11:12:57,250] ===================================================================================== SQL Command - Statement Id: [getDocList] PreparedStatement : [SELECT ' ' as doctorid, '진료의' as doctornm, 1 as sort from dual UNION ALL SELECT b.userid AS doctorid, b.usernm AS doctornm, 2 as sort FROM com.zsumusrd a INNER JOIN com.zsumusrb b ON a.userid = b.userid WHERE a.psnworkyn = 'N' AND a.dutplceinstcd = :param0 AND a.jobkindcd LIKE '03%' AND a.dutplcecd = :param1 AND :param2 BETWEEN a.fromdd AND a.todd AND :param2 BETWEEN b.userfromdd AND b.usertodd ORDER BY sort, doctorid] [Logging Date Time: 2016-11-10 11:12:57,251] ===================================================================================== SQL Command - Statement Id: [getDocList] Parameters: [param0=[instcd,111], param1=[orddeptcd,2010400000], param2=[srchdd,20161110]] [Logging Date Time: 2016-11-10 11:12:57,251] ===================================================================================== SQL Command - Statement Id: [getDocList] Parameters: [param0=[instcd,111], param1=[orddeptcd,2010400000], param2=[srchdd,20161110]] [Logging Date Time: 2016-11-10 11:12:57,251] ===================================================================================== SQL Command - Statement Id: [getDocList] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String]] [Logging Date Time: 2016-11-10 11:12:57,251] ===================================================================================== SQL Command - Statement Id: [getDocList] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String]] [Logging Date Time: 2016-11-10 11:13:00,760] ===================================================================================== SQL Command - Statement Id: [getOutPatList] PreparedStatement : [SELECT otpt.pid AS pid, substr(otpt.orddd,1,4) || '/' || substr(otpt.orddd,5,2) || '/' || substr(otpt.orddd,7,2) AS indd, otpt.cretno AS cretno, otpt.acptseqno AS seqno, otpt.instcd AS instcd, ptbs.hngnm AS hngnm, (select code.cdnm from com.zbcmcode code where code.cdgrupid = 'P0021' and code.valifromdd <= otpt.orddd and code.valitodd >= otpt.orddd and code.cdid = otpt.fsexamflag) AS fsexamflag, otpt.orddeptcd AS orddeptcd, otpt.orddrid AS doctorid, 1 AS hd, TRIM(ptbs.sex || '/' || LPAD(FLOOR(COM.FN_ZZ_GETAGE_EMR2('000000','0000000',otpt.orddd, 'B', ptbs.brthdd) / 12), 2, 0) || 'y' || LPAD(MOD(COM.FN_ZZ_GETAGE_EMR2('000000','0000000',otpt.orddd, 'B', ptbs.brthdd), 12), 2, 0) || 'm') AS sa, dept.depthngnm AS deptnm, dept.deptengabbr AS deptengabbr, usrb.usernm AS doctornm, (SELECT term.termengnm diagengnm FROM emr.mmohdiag diag, emr.mrtmterm term WHERE diag.pid = otpt.pid AND diag.orddd = otpt.orddd AND diag.cretno = otpt.cretno AND diag.orddeptcd = otpt.orddeptcd AND diag.instcd = otpt.instcd AND diag.diagcd = term.termcd AND diag.diagdd >= term.termfromdd AND diag.diagdd <= term.termtodd AND diag.instcd = term.instcd AND diag.diaghistcd = 'O' AND diag.diagtypecd = 'D' AND diag.diagkindcdflag = 'M' AND ROWNUM = 1) AS diagnm, 'N' AS dschnoti, 'N' AS roomcd, 'N' AS cnst, otpt.ordtype AS ordtype, (SELECT z.cdnm FROM com.zbcmcode z WHERE otpt.insukind = z.cdid AND z.cdgrupid = 'P0008' AND otpt.orddd BETWEEN z.valifromdd AND z.valitodd) AS bostyle, case when otpt.elbulbodstat='0' then '접수' when otpt.elbulbodstat = '1' then '대기' when otpt.elbulbodstat = '2' then '완료' when otpt.elbulbodstat = '3' then '보류' end AS elbulbodstat, substr(otpt.ordtm,1,2) || ':' || substr(otpt.ordtm,3,2) AS ordtm, otpt.centcd as centcd, cent.depthngnm as centnm, cent.deptengabbr as centengabbr, otpt.orddd FROM pam.pmohotpt otpt , pam.pmcmptbs ptbs , com.zsdddept dept , com.zsumusrb usrb , com.zsdddept cent WHERE otpt.histstat IN ('R', 'T') AND otpt.ordtype IN ('O', 'S') AND otpt.orddd = otpt.orgorddd AND otpt.cretno = otpt.orgcretno AND otpt.pid = ptbs.pid AND otpt.instcd = ptbs.instcd AND otpt.instcd = dept.instcd AND otpt.orddeptcd = dept.deptcd AND otpt.orddd >= dept.valifromdd AND otpt.orddd <= dept.valitodd AND otpt.orddrid = usrb.userid AND otpt.orddd >= usrb.userfromdd AND otpt.orddd <= usrb.usertodd AND otpt.instcd = cent.instcd(+) AND otpt.centcd = cent.deptcd(+) AND otpt.orddd >= cent.valifromdd(+) AND otpt.orddd <= cent.valitodd(+) AND otpt.orgorddd = :param0 AND otpt.orddd = :param0 AND otpt.instcd = :param1 AND otpt.orddeptcd = :param2 AND otpt.orddrid = :param3 AND otpt.etcordflag NOT IN ('M','J') AND otpt.medamtfreeresn NOT IN ('10') ORDER BY dept.deptengabbr, usrb.usernm, otpt.ordtm] [Logging Date Time: 2016-11-10 11:13:00,760] ===================================================================================== SQL Command - Statement Id: [getOutPatList] PreparedStatement : [SELECT otpt.pid AS pid, substr(otpt.orddd,1,4) || '/' || substr(otpt.orddd,5,2) || '/' || substr(otpt.orddd,7,2) AS indd, otpt.cretno AS cretno, otpt.acptseqno AS seqno, otpt.instcd AS instcd, ptbs.hngnm AS hngnm, (select code.cdnm from com.zbcmcode code where code.cdgrupid = 'P0021' and code.valifromdd <= otpt.orddd and code.valitodd >= otpt.orddd and code.cdid = otpt.fsexamflag) AS fsexamflag, otpt.orddeptcd AS orddeptcd, otpt.orddrid AS doctorid, 1 AS hd, TRIM(ptbs.sex || '/' || LPAD(FLOOR(COM.FN_ZZ_GETAGE_EMR2('000000','0000000',otpt.orddd, 'B', ptbs.brthdd) / 12), 2, 0) || 'y' || LPAD(MOD(COM.FN_ZZ_GETAGE_EMR2('000000','0000000',otpt.orddd, 'B', ptbs.brthdd), 12), 2, 0) || 'm') AS sa, dept.depthngnm AS deptnm, dept.deptengabbr AS deptengabbr, usrb.usernm AS doctornm, (SELECT term.termengnm diagengnm FROM emr.mmohdiag diag, emr.mrtmterm term WHERE diag.pid = otpt.pid AND diag.orddd = otpt.orddd AND diag.cretno = otpt.cretno AND diag.orddeptcd = otpt.orddeptcd AND diag.instcd = otpt.instcd AND diag.diagcd = term.termcd AND diag.diagdd >= term.termfromdd AND diag.diagdd <= term.termtodd AND diag.instcd = term.instcd AND diag.diaghistcd = 'O' AND diag.diagtypecd = 'D' AND diag.diagkindcdflag = 'M' AND ROWNUM = 1) AS diagnm, 'N' AS dschnoti, 'N' AS roomcd, 'N' AS cnst, otpt.ordtype AS ordtype, (SELECT z.cdnm FROM com.zbcmcode z WHERE otpt.insukind = z.cdid AND z.cdgrupid = 'P0008' AND otpt.orddd BETWEEN z.valifromdd AND z.valitodd) AS bostyle, case when otpt.elbulbodstat='0' then '접수' when otpt.elbulbodstat = '1' then '대기' when otpt.elbulbodstat = '2' then '완료' when otpt.elbulbodstat = '3' then '보류' end AS elbulbodstat, substr(otpt.ordtm,1,2) || ':' || substr(otpt.ordtm,3,2) AS ordtm, otpt.centcd as centcd, cent.depthngnm as centnm, cent.deptengabbr as centengabbr, otpt.orddd FROM pam.pmohotpt otpt , pam.pmcmptbs ptbs , com.zsdddept dept , com.zsumusrb usrb , com.zsdddept cent WHERE otpt.histstat IN ('R', 'T') AND otpt.ordtype IN ('O', 'S') AND otpt.orddd = otpt.orgorddd AND otpt.cretno = otpt.orgcretno AND otpt.pid = ptbs.pid AND otpt.instcd = ptbs.instcd AND otpt.instcd = dept.instcd AND otpt.orddeptcd = dept.deptcd AND otpt.orddd >= dept.valifromdd AND otpt.orddd <= dept.valitodd AND otpt.orddrid = usrb.userid AND otpt.orddd >= usrb.userfromdd AND otpt.orddd <= usrb.usertodd AND otpt.instcd = cent.instcd(+) AND otpt.centcd = cent.deptcd(+) AND otpt.orddd >= cent.valifromdd(+) AND otpt.orddd <= cent.valitodd(+) AND otpt.orgorddd = :param0 AND otpt.orddd = :param0 AND otpt.instcd = :param1 AND otpt.orddeptcd = :param2 AND otpt.orddrid = :param3 AND otpt.etcordflag NOT IN ('M','J') AND otpt.medamtfreeresn NOT IN ('10') ORDER BY dept.deptengabbr, usrb.usernm, otpt.ordtm] [Logging Date Time: 2016-11-10 11:13:00,761] ===================================================================================== SQL Command - Statement Id: [getOutPatList] Parameters: [param0=[srchdd,20161110], param1=[instcd,111], param2=[orddeptcd,2010400000], param3=[orddrid,107945]] [Logging Date Time: 2016-11-10 11:13:00,761] ===================================================================================== SQL Command - Statement Id: [getOutPatList] Parameters: [param0=[srchdd,20161110], param1=[instcd,111], param2=[orddeptcd,2010400000], param3=[orddrid,107945]] [Logging Date Time: 2016-11-10 11:13:00,761] ===================================================================================== SQL Command - Statement Id: [getOutPatList] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String], param3=[AnsiString, System.String]] [Logging Date Time: 2016-11-10 11:13:00,761] ===================================================================================== SQL Command - Statement Id: [getOutPatList] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String], param3=[AnsiString, System.String]] [Logging Date Time: 2016-11-10 11:13:03,933] ===================================================================================== SQL Command - Statement Id: [getOutPatList] PreparedStatement : [SELECT otpt.pid AS pid, substr(otpt.orddd,1,4) || '/' || substr(otpt.orddd,5,2) || '/' || substr(otpt.orddd,7,2) AS indd, otpt.cretno AS cretno, otpt.acptseqno AS seqno, otpt.instcd AS instcd, ptbs.hngnm AS hngnm, (select code.cdnm from com.zbcmcode code where code.cdgrupid = 'P0021' and code.valifromdd <= otpt.orddd and code.valitodd >= otpt.orddd and code.cdid = otpt.fsexamflag) AS fsexamflag, otpt.orddeptcd AS orddeptcd, otpt.orddrid AS doctorid, 1 AS hd, TRIM(ptbs.sex || '/' || LPAD(FLOOR(COM.FN_ZZ_GETAGE_EMR2('000000','0000000',otpt.orddd, 'B', ptbs.brthdd) / 12), 2, 0) || 'y' || LPAD(MOD(COM.FN_ZZ_GETAGE_EMR2('000000','0000000',otpt.orddd, 'B', ptbs.brthdd), 12), 2, 0) || 'm') AS sa, dept.depthngnm AS deptnm, dept.deptengabbr AS deptengabbr, usrb.usernm AS doctornm, (SELECT term.termengnm diagengnm FROM emr.mmohdiag diag, emr.mrtmterm term WHERE diag.pid = otpt.pid AND diag.orddd = otpt.orddd AND diag.cretno = otpt.cretno AND diag.orddeptcd = otpt.orddeptcd AND diag.instcd = otpt.instcd AND diag.diagcd = term.termcd AND diag.diagdd >= term.termfromdd AND diag.diagdd <= term.termtodd AND diag.instcd = term.instcd AND diag.diaghistcd = 'O' AND diag.diagtypecd = 'D' AND diag.diagkindcdflag = 'M' AND ROWNUM = 1) AS diagnm, 'N' AS dschnoti, 'N' AS roomcd, 'N' AS cnst, otpt.ordtype AS ordtype, (SELECT z.cdnm FROM com.zbcmcode z WHERE otpt.insukind = z.cdid AND z.cdgrupid = 'P0008' AND otpt.orddd BETWEEN z.valifromdd AND z.valitodd) AS bostyle, case when otpt.elbulbodstat='0' then '접수' when otpt.elbulbodstat = '1' then '대기' when otpt.elbulbodstat = '2' then '완료' when otpt.elbulbodstat = '3' then '보류' end AS elbulbodstat, substr(otpt.ordtm,1,2) || ':' || substr(otpt.ordtm,3,2) AS ordtm, otpt.centcd as centcd, cent.depthngnm as centnm, cent.deptengabbr as centengabbr, otpt.orddd FROM pam.pmohotpt otpt , pam.pmcmptbs ptbs , com.zsdddept dept , com.zsumusrb usrb , com.zsdddept cent WHERE otpt.histstat IN ('R', 'T') AND otpt.ordtype IN ('O', 'S') AND otpt.orddd = otpt.orgorddd AND otpt.cretno = otpt.orgcretno AND otpt.pid = ptbs.pid AND otpt.instcd = ptbs.instcd AND otpt.instcd = dept.instcd AND otpt.orddeptcd = dept.deptcd AND otpt.orddd >= dept.valifromdd AND otpt.orddd <= dept.valitodd AND otpt.orddrid = usrb.userid AND otpt.orddd >= usrb.userfromdd AND otpt.orddd <= usrb.usertodd AND otpt.instcd = cent.instcd(+) AND otpt.centcd = cent.deptcd(+) AND otpt.orddd >= cent.valifromdd(+) AND otpt.orddd <= cent.valitodd(+) AND otpt.orgorddd = :param0 AND otpt.orddd = :param0 AND otpt.instcd = :param1 AND otpt.orddeptcd = :param2 AND otpt.orddrid = :param3 AND otpt.etcordflag NOT IN ('M','J') AND otpt.medamtfreeresn NOT IN ('10') ORDER BY dept.deptengabbr, usrb.usernm, otpt.ordtm] [Logging Date Time: 2016-11-10 11:13:03,933] ===================================================================================== SQL Command - Statement Id: [getOutPatList] PreparedStatement : [SELECT otpt.pid AS pid, substr(otpt.orddd,1,4) || '/' || substr(otpt.orddd,5,2) || '/' || substr(otpt.orddd,7,2) AS indd, otpt.cretno AS cretno, otpt.acptseqno AS seqno, otpt.instcd AS instcd, ptbs.hngnm AS hngnm, (select code.cdnm from com.zbcmcode code where code.cdgrupid = 'P0021' and code.valifromdd <= otpt.orddd and code.valitodd >= otpt.orddd and code.cdid = otpt.fsexamflag) AS fsexamflag, otpt.orddeptcd AS orddeptcd, otpt.orddrid AS doctorid, 1 AS hd, TRIM(ptbs.sex || '/' || LPAD(FLOOR(COM.FN_ZZ_GETAGE_EMR2('000000','0000000',otpt.orddd, 'B', ptbs.brthdd) / 12), 2, 0) || 'y' || LPAD(MOD(COM.FN_ZZ_GETAGE_EMR2('000000','0000000',otpt.orddd, 'B', ptbs.brthdd), 12), 2, 0) || 'm') AS sa, dept.depthngnm AS deptnm, dept.deptengabbr AS deptengabbr, usrb.usernm AS doctornm, (SELECT term.termengnm diagengnm FROM emr.mmohdiag diag, emr.mrtmterm term WHERE diag.pid = otpt.pid AND diag.orddd = otpt.orddd AND diag.cretno = otpt.cretno AND diag.orddeptcd = otpt.orddeptcd AND diag.instcd = otpt.instcd AND diag.diagcd = term.termcd AND diag.diagdd >= term.termfromdd AND diag.diagdd <= term.termtodd AND diag.instcd = term.instcd AND diag.diaghistcd = 'O' AND diag.diagtypecd = 'D' AND diag.diagkindcdflag = 'M' AND ROWNUM = 1) AS diagnm, 'N' AS dschnoti, 'N' AS roomcd, 'N' AS cnst, otpt.ordtype AS ordtype, (SELECT z.cdnm FROM com.zbcmcode z WHERE otpt.insukind = z.cdid AND z.cdgrupid = 'P0008' AND otpt.orddd BETWEEN z.valifromdd AND z.valitodd) AS bostyle, case when otpt.elbulbodstat='0' then '접수' when otpt.elbulbodstat = '1' then '대기' when otpt.elbulbodstat = '2' then '완료' when otpt.elbulbodstat = '3' then '보류' end AS elbulbodstat, substr(otpt.ordtm,1,2) || ':' || substr(otpt.ordtm,3,2) AS ordtm, otpt.centcd as centcd, cent.depthngnm as centnm, cent.deptengabbr as centengabbr, otpt.orddd FROM pam.pmohotpt otpt , pam.pmcmptbs ptbs , com.zsdddept dept , com.zsumusrb usrb , com.zsdddept cent WHERE otpt.histstat IN ('R', 'T') AND otpt.ordtype IN ('O', 'S') AND otpt.orddd = otpt.orgorddd AND otpt.cretno = otpt.orgcretno AND otpt.pid = ptbs.pid AND otpt.instcd = ptbs.instcd AND otpt.instcd = dept.instcd AND otpt.orddeptcd = dept.deptcd AND otpt.orddd >= dept.valifromdd AND otpt.orddd <= dept.valitodd AND otpt.orddrid = usrb.userid AND otpt.orddd >= usrb.userfromdd AND otpt.orddd <= usrb.usertodd AND otpt.instcd = cent.instcd(+) AND otpt.centcd = cent.deptcd(+) AND otpt.orddd >= cent.valifromdd(+) AND otpt.orddd <= cent.valitodd(+) AND otpt.orgorddd = :param0 AND otpt.orddd = :param0 AND otpt.instcd = :param1 AND otpt.orddeptcd = :param2 AND otpt.orddrid = :param3 AND otpt.etcordflag NOT IN ('M','J') AND otpt.medamtfreeresn NOT IN ('10') ORDER BY dept.deptengabbr, usrb.usernm, otpt.ordtm] [Logging Date Time: 2016-11-10 11:13:03,934] ===================================================================================== SQL Command - Statement Id: [getOutPatList] Parameters: [param0=[srchdd,20161110], param1=[instcd,111], param2=[orddeptcd,2010400000], param3=[orddrid,107945]] [Logging Date Time: 2016-11-10 11:13:03,934] ===================================================================================== SQL Command - Statement Id: [getOutPatList] Parameters: [param0=[srchdd,20161110], param1=[instcd,111], param2=[orddeptcd,2010400000], param3=[orddrid,107945]] [Logging Date Time: 2016-11-10 11:13:03,934] ===================================================================================== SQL Command - Statement Id: [getOutPatList] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String], param3=[AnsiString, System.String]] [Logging Date Time: 2016-11-10 11:13:03,934] ===================================================================================== SQL Command - Statement Id: [getOutPatList] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String], param3=[AnsiString, System.String]] [Logging Date Time: 2016-11-10 11:13:08,786] ===================================================================================== SQL Command - Statement Id: [getOutPatList] PreparedStatement : [SELECT otpt.pid AS pid, substr(otpt.orddd,1,4) || '/' || substr(otpt.orddd,5,2) || '/' || substr(otpt.orddd,7,2) AS indd, otpt.cretno AS cretno, otpt.acptseqno AS seqno, otpt.instcd AS instcd, ptbs.hngnm AS hngnm, (select code.cdnm from com.zbcmcode code where code.cdgrupid = 'P0021' and code.valifromdd <= otpt.orddd and code.valitodd >= otpt.orddd and code.cdid = otpt.fsexamflag) AS fsexamflag, otpt.orddeptcd AS orddeptcd, otpt.orddrid AS doctorid, 1 AS hd, TRIM(ptbs.sex || '/' || LPAD(FLOOR(COM.FN_ZZ_GETAGE_EMR2('000000','0000000',otpt.orddd, 'B', ptbs.brthdd) / 12), 2, 0) || 'y' || LPAD(MOD(COM.FN_ZZ_GETAGE_EMR2('000000','0000000',otpt.orddd, 'B', ptbs.brthdd), 12), 2, 0) || 'm') AS sa, dept.depthngnm AS deptnm, dept.deptengabbr AS deptengabbr, usrb.usernm AS doctornm, (SELECT term.termengnm diagengnm FROM emr.mmohdiag diag, emr.mrtmterm term WHERE diag.pid = otpt.pid AND diag.orddd = otpt.orddd AND diag.cretno = otpt.cretno AND diag.orddeptcd = otpt.orddeptcd AND diag.instcd = otpt.instcd AND diag.diagcd = term.termcd AND diag.diagdd >= term.termfromdd AND diag.diagdd <= term.termtodd AND diag.instcd = term.instcd AND diag.diaghistcd = 'O' AND diag.diagtypecd = 'D' AND diag.diagkindcdflag = 'M' AND ROWNUM = 1) AS diagnm, 'N' AS dschnoti, 'N' AS roomcd, 'N' AS cnst, otpt.ordtype AS ordtype, (SELECT z.cdnm FROM com.zbcmcode z WHERE otpt.insukind = z.cdid AND z.cdgrupid = 'P0008' AND otpt.orddd BETWEEN z.valifromdd AND z.valitodd) AS bostyle, case when otpt.elbulbodstat='0' then '접수' when otpt.elbulbodstat = '1' then '대기' when otpt.elbulbodstat = '2' then '완료' when otpt.elbulbodstat = '3' then '보류' end AS elbulbodstat, substr(otpt.ordtm,1,2) || ':' || substr(otpt.ordtm,3,2) AS ordtm, otpt.centcd as centcd, cent.depthngnm as centnm, cent.deptengabbr as centengabbr, otpt.orddd FROM pam.pmohotpt otpt , pam.pmcmptbs ptbs , com.zsdddept dept , com.zsumusrb usrb , com.zsdddept cent WHERE otpt.histstat IN ('R', 'T') AND otpt.ordtype IN ('O', 'S') AND otpt.orddd = otpt.orgorddd AND otpt.cretno = otpt.orgcretno AND otpt.pid = ptbs.pid AND otpt.instcd = ptbs.instcd AND otpt.instcd = dept.instcd AND otpt.orddeptcd = dept.deptcd AND otpt.orddd >= dept.valifromdd AND otpt.orddd <= dept.valitodd AND otpt.orddrid = usrb.userid AND otpt.orddd >= usrb.userfromdd AND otpt.orddd <= usrb.usertodd AND otpt.instcd = cent.instcd(+) AND otpt.centcd = cent.deptcd(+) AND otpt.orddd >= cent.valifromdd(+) AND otpt.orddd <= cent.valitodd(+) AND otpt.orgorddd = :param0 AND otpt.orddd = :param0 AND otpt.instcd = :param1 AND otpt.orddeptcd = :param2 AND otpt.orddrid = :param3 AND otpt.etcordflag NOT IN ('M','J') AND otpt.medamtfreeresn NOT IN ('10') ORDER BY dept.deptengabbr, usrb.usernm, otpt.ordtm] [Logging Date Time: 2016-11-10 11:13:08,786] ===================================================================================== SQL Command - Statement Id: [getOutPatList] PreparedStatement : [SELECT otpt.pid AS pid, substr(otpt.orddd,1,4) || '/' || substr(otpt.orddd,5,2) || '/' || substr(otpt.orddd,7,2) AS indd, otpt.cretno AS cretno, otpt.acptseqno AS seqno, otpt.instcd AS instcd, ptbs.hngnm AS hngnm, (select code.cdnm from com.zbcmcode code where code.cdgrupid = 'P0021' and code.valifromdd <= otpt.orddd and code.valitodd >= otpt.orddd and code.cdid = otpt.fsexamflag) AS fsexamflag, otpt.orddeptcd AS orddeptcd, otpt.orddrid AS doctorid, 1 AS hd, TRIM(ptbs.sex || '/' || LPAD(FLOOR(COM.FN_ZZ_GETAGE_EMR2('000000','0000000',otpt.orddd, 'B', ptbs.brthdd) / 12), 2, 0) || 'y' || LPAD(MOD(COM.FN_ZZ_GETAGE_EMR2('000000','0000000',otpt.orddd, 'B', ptbs.brthdd), 12), 2, 0) || 'm') AS sa, dept.depthngnm AS deptnm, dept.deptengabbr AS deptengabbr, usrb.usernm AS doctornm, (SELECT term.termengnm diagengnm FROM emr.mmohdiag diag, emr.mrtmterm term WHERE diag.pid = otpt.pid AND diag.orddd = otpt.orddd AND diag.cretno = otpt.cretno AND diag.orddeptcd = otpt.orddeptcd AND diag.instcd = otpt.instcd AND diag.diagcd = term.termcd AND diag.diagdd >= term.termfromdd AND diag.diagdd <= term.termtodd AND diag.instcd = term.instcd AND diag.diaghistcd = 'O' AND diag.diagtypecd = 'D' AND diag.diagkindcdflag = 'M' AND ROWNUM = 1) AS diagnm, 'N' AS dschnoti, 'N' AS roomcd, 'N' AS cnst, otpt.ordtype AS ordtype, (SELECT z.cdnm FROM com.zbcmcode z WHERE otpt.insukind = z.cdid AND z.cdgrupid = 'P0008' AND otpt.orddd BETWEEN z.valifromdd AND z.valitodd) AS bostyle, case when otpt.elbulbodstat='0' then '접수' when otpt.elbulbodstat = '1' then '대기' when otpt.elbulbodstat = '2' then '완료' when otpt.elbulbodstat = '3' then '보류' end AS elbulbodstat, substr(otpt.ordtm,1,2) || ':' || substr(otpt.ordtm,3,2) AS ordtm, otpt.centcd as centcd, cent.depthngnm as centnm, cent.deptengabbr as centengabbr, otpt.orddd FROM pam.pmohotpt otpt , pam.pmcmptbs ptbs , com.zsdddept dept , com.zsumusrb usrb , com.zsdddept cent WHERE otpt.histstat IN ('R', 'T') AND otpt.ordtype IN ('O', 'S') AND otpt.orddd = otpt.orgorddd AND otpt.cretno = otpt.orgcretno AND otpt.pid = ptbs.pid AND otpt.instcd = ptbs.instcd AND otpt.instcd = dept.instcd AND otpt.orddeptcd = dept.deptcd AND otpt.orddd >= dept.valifromdd AND otpt.orddd <= dept.valitodd AND otpt.orddrid = usrb.userid AND otpt.orddd >= usrb.userfromdd AND otpt.orddd <= usrb.usertodd AND otpt.instcd = cent.instcd(+) AND otpt.centcd = cent.deptcd(+) AND otpt.orddd >= cent.valifromdd(+) AND otpt.orddd <= cent.valitodd(+) AND otpt.orgorddd = :param0 AND otpt.orddd = :param0 AND otpt.instcd = :param1 AND otpt.orddeptcd = :param2 AND otpt.orddrid = :param3 AND otpt.etcordflag NOT IN ('M','J') AND otpt.medamtfreeresn NOT IN ('10') ORDER BY dept.deptengabbr, usrb.usernm, otpt.ordtm] [Logging Date Time: 2016-11-10 11:13:08,787] ===================================================================================== SQL Command - Statement Id: [getOutPatList] Parameters: [param0=[srchdd,20161110], param1=[instcd,111], param2=[orddeptcd,2010400000], param3=[orddrid,107945]] [Logging Date Time: 2016-11-10 11:13:08,787] ===================================================================================== SQL Command - Statement Id: [getOutPatList] Parameters: [param0=[srchdd,20161110], param1=[instcd,111], param2=[orddeptcd,2010400000], param3=[orddrid,107945]] [Logging Date Time: 2016-11-10 11:13:08,787] ===================================================================================== SQL Command - Statement Id: [getOutPatList] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String], param3=[AnsiString, System.String]] [Logging Date Time: 2016-11-10 11:13:08,787] ===================================================================================== SQL Command - Statement Id: [getOutPatList] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String], param3=[AnsiString, System.String]] [Logging Date Time: 2016-11-10 11:13:18,275] ===================================================================================== SQL Command - Statement Id: [getOutPatList] PreparedStatement : [SELECT otpt.pid AS pid, substr(otpt.orddd,1,4) || '/' || substr(otpt.orddd,5,2) || '/' || substr(otpt.orddd,7,2) AS indd, otpt.cretno AS cretno, otpt.acptseqno AS seqno, otpt.instcd AS instcd, ptbs.hngnm AS hngnm, (select code.cdnm from com.zbcmcode code where code.cdgrupid = 'P0021' and code.valifromdd <= otpt.orddd and code.valitodd >= otpt.orddd and code.cdid = otpt.fsexamflag) AS fsexamflag, otpt.orddeptcd AS orddeptcd, otpt.orddrid AS doctorid, 1 AS hd, TRIM(ptbs.sex || '/' || LPAD(FLOOR(COM.FN_ZZ_GETAGE_EMR2('000000','0000000',otpt.orddd, 'B', ptbs.brthdd) / 12), 2, 0) || 'y' || LPAD(MOD(COM.FN_ZZ_GETAGE_EMR2('000000','0000000',otpt.orddd, 'B', ptbs.brthdd), 12), 2, 0) || 'm') AS sa, dept.depthngnm AS deptnm, dept.deptengabbr AS deptengabbr, usrb.usernm AS doctornm, (SELECT term.termengnm diagengnm FROM emr.mmohdiag diag, emr.mrtmterm term WHERE diag.pid = otpt.pid AND diag.orddd = otpt.orddd AND diag.cretno = otpt.cretno AND diag.orddeptcd = otpt.orddeptcd AND diag.instcd = otpt.instcd AND diag.diagcd = term.termcd AND diag.diagdd >= term.termfromdd AND diag.diagdd <= term.termtodd AND diag.instcd = term.instcd AND diag.diaghistcd = 'O' AND diag.diagtypecd = 'D' AND diag.diagkindcdflag = 'M' AND ROWNUM = 1) AS diagnm, 'N' AS dschnoti, 'N' AS roomcd, 'N' AS cnst, otpt.ordtype AS ordtype, (SELECT z.cdnm FROM com.zbcmcode z WHERE otpt.insukind = z.cdid AND z.cdgrupid = 'P0008' AND otpt.orddd BETWEEN z.valifromdd AND z.valitodd) AS bostyle, case when otpt.elbulbodstat='0' then '접수' when otpt.elbulbodstat = '1' then '대기' when otpt.elbulbodstat = '2' then '완료' when otpt.elbulbodstat = '3' then '보류' end AS elbulbodstat, substr(otpt.ordtm,1,2) || ':' || substr(otpt.ordtm,3,2) AS ordtm, otpt.centcd as centcd, cent.depthngnm as centnm, cent.deptengabbr as centengabbr, otpt.orddd FROM pam.pmohotpt otpt , pam.pmcmptbs ptbs , com.zsdddept dept , com.zsumusrb usrb , com.zsdddept cent WHERE otpt.histstat IN ('R', 'T') AND otpt.ordtype IN ('O', 'S') AND otpt.orddd = otpt.orgorddd AND otpt.cretno = otpt.orgcretno AND otpt.pid = ptbs.pid AND otpt.instcd = ptbs.instcd AND otpt.instcd = dept.instcd AND otpt.orddeptcd = dept.deptcd AND otpt.orddd >= dept.valifromdd AND otpt.orddd <= dept.valitodd AND otpt.orddrid = usrb.userid AND otpt.orddd >= usrb.userfromdd AND otpt.orddd <= usrb.usertodd AND otpt.instcd = cent.instcd(+) AND otpt.centcd = cent.deptcd(+) AND otpt.orddd >= cent.valifromdd(+) AND otpt.orddd <= cent.valitodd(+) AND otpt.orgorddd = :param0 AND otpt.orddd = :param0 AND otpt.instcd = :param1 AND otpt.orddeptcd = :param2 AND otpt.orddrid = :param3 AND otpt.etcordflag NOT IN ('M','J') AND otpt.medamtfreeresn NOT IN ('10') ORDER BY dept.deptengabbr, usrb.usernm, otpt.ordtm] [Logging Date Time: 2016-11-10 11:13:18,275] ===================================================================================== SQL Command - Statement Id: [getOutPatList] PreparedStatement : [SELECT otpt.pid AS pid, substr(otpt.orddd,1,4) || '/' || substr(otpt.orddd,5,2) || '/' || substr(otpt.orddd,7,2) AS indd, otpt.cretno AS cretno, otpt.acptseqno AS seqno, otpt.instcd AS instcd, ptbs.hngnm AS hngnm, (select code.cdnm from com.zbcmcode code where code.cdgrupid = 'P0021' and code.valifromdd <= otpt.orddd and code.valitodd >= otpt.orddd and code.cdid = otpt.fsexamflag) AS fsexamflag, otpt.orddeptcd AS orddeptcd, otpt.orddrid AS doctorid, 1 AS hd, TRIM(ptbs.sex || '/' || LPAD(FLOOR(COM.FN_ZZ_GETAGE_EMR2('000000','0000000',otpt.orddd, 'B', ptbs.brthdd) / 12), 2, 0) || 'y' || LPAD(MOD(COM.FN_ZZ_GETAGE_EMR2('000000','0000000',otpt.orddd, 'B', ptbs.brthdd), 12), 2, 0) || 'm') AS sa, dept.depthngnm AS deptnm, dept.deptengabbr AS deptengabbr, usrb.usernm AS doctornm, (SELECT term.termengnm diagengnm FROM emr.mmohdiag diag, emr.mrtmterm term WHERE diag.pid = otpt.pid AND diag.orddd = otpt.orddd AND diag.cretno = otpt.cretno AND diag.orddeptcd = otpt.orddeptcd AND diag.instcd = otpt.instcd AND diag.diagcd = term.termcd AND diag.diagdd >= term.termfromdd AND diag.diagdd <= term.termtodd AND diag.instcd = term.instcd AND diag.diaghistcd = 'O' AND diag.diagtypecd = 'D' AND diag.diagkindcdflag = 'M' AND ROWNUM = 1) AS diagnm, 'N' AS dschnoti, 'N' AS roomcd, 'N' AS cnst, otpt.ordtype AS ordtype, (SELECT z.cdnm FROM com.zbcmcode z WHERE otpt.insukind = z.cdid AND z.cdgrupid = 'P0008' AND otpt.orddd BETWEEN z.valifromdd AND z.valitodd) AS bostyle, case when otpt.elbulbodstat='0' then '접수' when otpt.elbulbodstat = '1' then '대기' when otpt.elbulbodstat = '2' then '완료' when otpt.elbulbodstat = '3' then '보류' end AS elbulbodstat, substr(otpt.ordtm,1,2) || ':' || substr(otpt.ordtm,3,2) AS ordtm, otpt.centcd as centcd, cent.depthngnm as centnm, cent.deptengabbr as centengabbr, otpt.orddd FROM pam.pmohotpt otpt , pam.pmcmptbs ptbs , com.zsdddept dept , com.zsumusrb usrb , com.zsdddept cent WHERE otpt.histstat IN ('R', 'T') AND otpt.ordtype IN ('O', 'S') AND otpt.orddd = otpt.orgorddd AND otpt.cretno = otpt.orgcretno AND otpt.pid = ptbs.pid AND otpt.instcd = ptbs.instcd AND otpt.instcd = dept.instcd AND otpt.orddeptcd = dept.deptcd AND otpt.orddd >= dept.valifromdd AND otpt.orddd <= dept.valitodd AND otpt.orddrid = usrb.userid AND otpt.orddd >= usrb.userfromdd AND otpt.orddd <= usrb.usertodd AND otpt.instcd = cent.instcd(+) AND otpt.centcd = cent.deptcd(+) AND otpt.orddd >= cent.valifromdd(+) AND otpt.orddd <= cent.valitodd(+) AND otpt.orgorddd = :param0 AND otpt.orddd = :param0 AND otpt.instcd = :param1 AND otpt.orddeptcd = :param2 AND otpt.orddrid = :param3 AND otpt.etcordflag NOT IN ('M','J') AND otpt.medamtfreeresn NOT IN ('10') ORDER BY dept.deptengabbr, usrb.usernm, otpt.ordtm] [Logging Date Time: 2016-11-10 11:13:18,275] ===================================================================================== SQL Command - Statement Id: [getOutPatList] Parameters: [param0=[srchdd,20161110], param1=[instcd,111], param2=[orddeptcd,2010400000], param3=[orddrid,105066]] [Logging Date Time: 2016-11-10 11:13:18,275] ===================================================================================== SQL Command - Statement Id: [getOutPatList] Parameters: [param0=[srchdd,20161110], param1=[instcd,111], param2=[orddeptcd,2010400000], param3=[orddrid,105066]] [Logging Date Time: 2016-11-10 11:13:18,275] ===================================================================================== SQL Command - Statement Id: [getOutPatList] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String], param3=[AnsiString, System.String]] [Logging Date Time: 2016-11-10 11:13:18,275] ===================================================================================== SQL Command - Statement Id: [getOutPatList] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String], param3=[AnsiString, System.String]] [Logging Date Time: 2016-11-10 11:13:28,937] ===================================================================================== SQL Command - Statement Id: [GET_USER_INFO] PreparedStatement : [select a.userid, a.usernm, b.dutplcecd, dept.depthngnm, dept.deptengabbr, b.jobkindcd, (select cdnm from com.zbcmcode code where code.cdgrupid = 'R0061' and code.cdid = b.jobkindcd and code.valitodd = '99991231') from com.zsumusrb a, com.zsumusrd b, com.zsdddept dept where a.dutinstcd = '111' and a.dutinstcd = b.dutplceinstcd and a.userid = b.userid and a.usertodd = b.todd and dept.instcd = a.dutinstcd and dept.deptcd = b.dutplcecd and dept.valitodd = '99991231' and b.psnworkyn = 'Y' and a.usertodd = '99991231' and b.userid = :param0] [Logging Date Time: 2016-11-10 11:13:28,937] ===================================================================================== SQL Command - Statement Id: [GET_USER_INFO] PreparedStatement : [select a.userid, a.usernm, b.dutplcecd, dept.depthngnm, dept.deptengabbr, b.jobkindcd, (select cdnm from com.zbcmcode code where code.cdgrupid = 'R0061' and code.cdid = b.jobkindcd and code.valitodd = '99991231') from com.zsumusrb a, com.zsumusrd b, com.zsdddept dept where a.dutinstcd = '111' and a.dutinstcd = b.dutplceinstcd and a.userid = b.userid and a.usertodd = b.todd and dept.instcd = a.dutinstcd and dept.deptcd = b.dutplcecd and dept.valitodd = '99991231' and b.psnworkyn = 'Y' and a.usertodd = '99991231' and b.userid = :param0] [Logging Date Time: 2016-11-10 11:13:28,937] ===================================================================================== SQL Command - Statement Id: [GET_USER_INFO] Parameters: [param0=[userid,105066]] [Logging Date Time: 2016-11-10 11:13:28,937] ===================================================================================== SQL Command - Statement Id: [GET_USER_INFO] Parameters: [param0=[userid,105066]] [Logging Date Time: 2016-11-10 11:13:28,937] ===================================================================================== SQL Command - Statement Id: [GET_USER_INFO] Types: [param0=[AnsiString, System.String]] [Logging Date Time: 2016-11-10 11:13:28,937] ===================================================================================== SQL Command - Statement Id: [GET_USER_INFO] Types: [param0=[AnsiString, System.String]] [Logging Date Time: 2016-11-10 11:13:28,992] ===================================================================================== SQL Command - Statement Id: [getPatientInfoOut] PreparedStatement : [SELECT a.orddeptcd, a.pid as IO_Pt_ID, to_char(a.cretno) as IO_CretNo, (select ptbs.sex || '/' || com.fn_zz_getageas(ptbs.rrgstno1, ptbs.rrgstno2, TO_CHAR(SYSDATE, 'YYYYMMDD'), 'A', ptbs.brthdd) from pam.pmcmptbs ptbs where ptbs.instcd = a.instcd and ptbs.pid = a.pid) as IO_sex_age_y_m, (select ptbs.hngnm from pam.pmcmptbs ptbs where ptbs.instcd = a.instcd and ptbs.pid = a.pid) as IO_Pt_Name, (select ptbs.rrgstno1 || '-' || substr(ptbs.rrgstno2, 1, 1) || '******' from pam.pmcmptbs ptbs where ptbs.instcd = a.instcd and ptbs.pid = a.pid) IO_JuminNo, '' as IO_Ward, '' as IO_roomNO, a.orddd as IO_ADdate, a.orddd as IO_Dschdd, a.ordtype as IO_VisitType, a.orddeptcd as IO_DeptCd, (select dept.deptengabbr from com.zsdddept dept where dept.deptcd = a.orddeptcd and dept.instcd = a.instcd and dept.valitodd >= a.orddd and dept.valifromdd <= a.orddd) as IO_DeptNm, COM.FN_ZS_GETDEPTNAME(a.instcd, a.orddeptcd, a.orddd) AS IO_Dept2, '' AS IO_OPdeptCd, '' AS IO_OPdeptNm, '' AS IO_OPdrNm, '' AS IO_OPdrId, (SELECT diag.diagcd FROM emr.mmohdiag diag WHERE diag.pid = a.pid AND diag.orddd = a.orddd AND diag.cretno = a.cretno AND diag.diaghistcd = 'O' AND diag.diagtypecd = 'D' AND diag.diagkindcdflag = 'M' AND diag.genrflagcd = a.ordtype and diag.orddeptcd = a.orddeptcd AND diag.diaghistno = (select max(diagh.diaghistno) from emr.mmohdiag diagh where diagh.pid = a.pid AND diagh.orddd = a.orddd AND diagh.cretno = a.cretno AND diagh.instcd = '111' AND diagh.diaghistcd = 'O' AND diagh.diagkindcdflag = 'M' AND diagh.genrflagcd = a.ordtype and diagh.orddeptcd = a.orddeptcd group by pid)) as IO_DxCd, (SELECT term.diaghngnm FROM emr.mmohdiag diag, emr.mmbvdiag term WHERE diag.pid = a.pid AND diag.orddd = a.orddd AND diag.cretno = a.cretno AND diag.instcd = term.instcd AND diag.diagcd = term.orgdiagcd AND diag.diaghistcd = 'O' AND diag.diagtypecd = 'D' AND diag.diagkindcdflag = 'M' AND diag.diagdd >= term.termfromdd AND diag.diagdd <= term.termtodd AND diag.diagdd >= term.diagattrfromdd AND diag.diagdd <= term.diagattrtodd AND diag.genrflagcd = a.ordtype and diag.orddeptcd = a.orddeptcd AND diag.diaghistno = (select max(diagh.diaghistno) from emr.mmohdiag diagh where diagh.pid = a.pid AND diagh.orddd = a.orddd AND diagh.cretno = a.cretno AND diagh.instcd = '111' AND diagh.diaghistcd = 'O' AND diagh.diagkindcdflag = 'M' AND diagh.genrflagcd = a.ordtype and diagh.orddeptcd = a.orddeptcd group by pid)) as IO_DxNm, COM.FN_ZS_GETUSERNM(a.orddrid, a.orddd) as IO_MaindrNm, '111' as IO_HosType, case when ex.bp is null then null else ex.bp end as IO_bp, case when ex.dm is null then null else ex.dm end as IO_dm, case when ex.heart is null then null else ex.heart end as IO_heart, case when ex.kidney is null then null else ex.kidney end as IO_kidney, case when ex.respiration is null then null else ex.respiration end as IO_respiration, case when ex.hx is null then null else ex.hx end as IO_hx, case when ex.allergy is null then null else ex.allergy end as IO_allergy, case when ex.drug is null then null else ex.drug end as IO_drug, case when ex.smoking is null then null else ex.smoking end as IO_smoking, case when ex.idio is null then null else ex.idio end as IO_idio, case when ex.nacrotics is null then null else ex.nacrotics end as IO_nacrotics, case when ex.airway is null then null else ex.airway end as IO_airway, case when ex.hemorrhage is null then null else ex.hemorrhage end as IO_hemorrhage, ex.etc IO_status_etc, '111' as IO_OrderNo, '111' as IO_PrintTime, a.ORDDRID as IO_MaindrId, COM.FN_ZS_GETUSERNM(a.ORDDRID, a.orddd) as IO_MaindrNm, '111' as IO_OcrCd, a.ORDDRID as IO_InputId, COM.FN_ZS_GETUSERNM(a.ORDDRID, a.orddd) as IO_InputNm, '111' as IO_SignImg FROM pam.pmohotpt a left outer join cmr.consent_data_ex ex on (ex.pid = a.pid and ex.cln_date = a.orddd) WHERE a.instcd = :param0 AND a.pid = :param1 AND a.orddd = :param2 AND a.cretno = :param3] [Logging Date Time: 2016-11-10 11:13:28,992] ===================================================================================== SQL Command - Statement Id: [getPatientInfoOut] PreparedStatement : [SELECT a.orddeptcd, a.pid as IO_Pt_ID, to_char(a.cretno) as IO_CretNo, (select ptbs.sex || '/' || com.fn_zz_getageas(ptbs.rrgstno1, ptbs.rrgstno2, TO_CHAR(SYSDATE, 'YYYYMMDD'), 'A', ptbs.brthdd) from pam.pmcmptbs ptbs where ptbs.instcd = a.instcd and ptbs.pid = a.pid) as IO_sex_age_y_m, (select ptbs.hngnm from pam.pmcmptbs ptbs where ptbs.instcd = a.instcd and ptbs.pid = a.pid) as IO_Pt_Name, (select ptbs.rrgstno1 || '-' || substr(ptbs.rrgstno2, 1, 1) || '******' from pam.pmcmptbs ptbs where ptbs.instcd = a.instcd and ptbs.pid = a.pid) IO_JuminNo, '' as IO_Ward, '' as IO_roomNO, a.orddd as IO_ADdate, a.orddd as IO_Dschdd, a.ordtype as IO_VisitType, a.orddeptcd as IO_DeptCd, (select dept.deptengabbr from com.zsdddept dept where dept.deptcd = a.orddeptcd and dept.instcd = a.instcd and dept.valitodd >= a.orddd and dept.valifromdd <= a.orddd) as IO_DeptNm, COM.FN_ZS_GETDEPTNAME(a.instcd, a.orddeptcd, a.orddd) AS IO_Dept2, '' AS IO_OPdeptCd, '' AS IO_OPdeptNm, '' AS IO_OPdrNm, '' AS IO_OPdrId, (SELECT diag.diagcd FROM emr.mmohdiag diag WHERE diag.pid = a.pid AND diag.orddd = a.orddd AND diag.cretno = a.cretno AND diag.diaghistcd = 'O' AND diag.diagtypecd = 'D' AND diag.diagkindcdflag = 'M' AND diag.genrflagcd = a.ordtype and diag.orddeptcd = a.orddeptcd AND diag.diaghistno = (select max(diagh.diaghistno) from emr.mmohdiag diagh where diagh.pid = a.pid AND diagh.orddd = a.orddd AND diagh.cretno = a.cretno AND diagh.instcd = '111' AND diagh.diaghistcd = 'O' AND diagh.diagkindcdflag = 'M' AND diagh.genrflagcd = a.ordtype and diagh.orddeptcd = a.orddeptcd group by pid)) as IO_DxCd, (SELECT term.diaghngnm FROM emr.mmohdiag diag, emr.mmbvdiag term WHERE diag.pid = a.pid AND diag.orddd = a.orddd AND diag.cretno = a.cretno AND diag.instcd = term.instcd AND diag.diagcd = term.orgdiagcd AND diag.diaghistcd = 'O' AND diag.diagtypecd = 'D' AND diag.diagkindcdflag = 'M' AND diag.diagdd >= term.termfromdd AND diag.diagdd <= term.termtodd AND diag.diagdd >= term.diagattrfromdd AND diag.diagdd <= term.diagattrtodd AND diag.genrflagcd = a.ordtype and diag.orddeptcd = a.orddeptcd AND diag.diaghistno = (select max(diagh.diaghistno) from emr.mmohdiag diagh where diagh.pid = a.pid AND diagh.orddd = a.orddd AND diagh.cretno = a.cretno AND diagh.instcd = '111' AND diagh.diaghistcd = 'O' AND diagh.diagkindcdflag = 'M' AND diagh.genrflagcd = a.ordtype and diagh.orddeptcd = a.orddeptcd group by pid)) as IO_DxNm, COM.FN_ZS_GETUSERNM(a.orddrid, a.orddd) as IO_MaindrNm, '111' as IO_HosType, case when ex.bp is null then null else ex.bp end as IO_bp, case when ex.dm is null then null else ex.dm end as IO_dm, case when ex.heart is null then null else ex.heart end as IO_heart, case when ex.kidney is null then null else ex.kidney end as IO_kidney, case when ex.respiration is null then null else ex.respiration end as IO_respiration, case when ex.hx is null then null else ex.hx end as IO_hx, case when ex.allergy is null then null else ex.allergy end as IO_allergy, case when ex.drug is null then null else ex.drug end as IO_drug, case when ex.smoking is null then null else ex.smoking end as IO_smoking, case when ex.idio is null then null else ex.idio end as IO_idio, case when ex.nacrotics is null then null else ex.nacrotics end as IO_nacrotics, case when ex.airway is null then null else ex.airway end as IO_airway, case when ex.hemorrhage is null then null else ex.hemorrhage end as IO_hemorrhage, ex.etc IO_status_etc, '111' as IO_OrderNo, '111' as IO_PrintTime, a.ORDDRID as IO_MaindrId, COM.FN_ZS_GETUSERNM(a.ORDDRID, a.orddd) as IO_MaindrNm, '111' as IO_OcrCd, a.ORDDRID as IO_InputId, COM.FN_ZS_GETUSERNM(a.ORDDRID, a.orddd) as IO_InputNm, '111' as IO_SignImg FROM pam.pmohotpt a left outer join cmr.consent_data_ex ex on (ex.pid = a.pid and ex.cln_date = a.orddd) WHERE a.instcd = :param0 AND a.pid = :param1 AND a.orddd = :param2 AND a.cretno = :param3] [Logging Date Time: 2016-11-10 11:13:28,993] ===================================================================================== SQL Command - Statement Id: [getPatientInfoOut] Parameters: [param0=[instcd,111], param1=[pid,1715813], param2=[orddd,20161110], param3=[cretno,1]] [Logging Date Time: 2016-11-10 11:13:28,993] ===================================================================================== SQL Command - Statement Id: [getPatientInfoOut] Parameters: [param0=[instcd,111], param1=[pid,1715813], param2=[orddd,20161110], param3=[cretno,1]] [Logging Date Time: 2016-11-10 11:13:28,993] ===================================================================================== SQL Command - Statement Id: [getPatientInfoOut] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String], param3=[AnsiString, System.String]] [Logging Date Time: 2016-11-10 11:13:28,993] ===================================================================================== SQL Command - Statement Id: [getPatientInfoOut] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String], param3=[AnsiString, System.String]] [Logging Date Time: 2016-11-10 11:13:29,263] ===================================================================================== SQL Command - Statement Id: [GET_TRMT_DATE_LIST] PreparedStatement : [SELECT indd as ClnDate, substr(indd, 1, 4) || '-' || substr(indd, 5, 2) || '-' || substr(indd, 7, 2) as ClnFormatDate, inpt.ordtype as VisitType, case when ordtype = 'O' then '외래' when ordtype = 'I' then '입원' when ordtype = 'E' then '응급' end as VisitTypeName, dept.deptengabbr as ClnDeptCode, dept.depthngnm as ClnDeptName, inpt.cretno FROM pam.pmihinpt inpt left outer join com.zsdddept dept on (dept.instcd = inpt.instcd and dept.deptcd = inpt.orddeptcd and dept.valitodd = '99991231') WHERE inpt.instcd = :param0 AND inpt.pid = :param1 AND inpt.indd = :param2 AND inpt.histstat = 'Y' AND inpt.mskind = 'M' union all SELECT orddd as ClnDate, substr(orddd, 1, 4) || '-' || substr(orddd, 5, 2) || '-' || substr(orddd, 7, 2) as ClnFormatDate, otpt.ordtype as VisitType, case when ordtype = 'O' then '외래' when ordtype = 'I' then '입원' when ordtype = 'E' then '응급' end as VisitTypeName, dept.deptengabbr as ClnDeptCode, dept.depthngnm as ClnDeptName, otpt.cretno FROM pam.pmohotpt otpt left outer join com.zsdddept dept on (dept.instcd = otpt.instcd and dept.deptcd = otpt.orddeptcd and dept.valitodd = '99991231') WHERE otpt.instcd = :param0 AND otpt.pid = :param1 AND otpt.orddd = :param2] [Logging Date Time: 2016-11-10 11:13:29,263] ===================================================================================== SQL Command - Statement Id: [GET_TRMT_DATE_LIST] PreparedStatement : [SELECT indd as ClnDate, substr(indd, 1, 4) || '-' || substr(indd, 5, 2) || '-' || substr(indd, 7, 2) as ClnFormatDate, inpt.ordtype as VisitType, case when ordtype = 'O' then '외래' when ordtype = 'I' then '입원' when ordtype = 'E' then '응급' end as VisitTypeName, dept.deptengabbr as ClnDeptCode, dept.depthngnm as ClnDeptName, inpt.cretno FROM pam.pmihinpt inpt left outer join com.zsdddept dept on (dept.instcd = inpt.instcd and dept.deptcd = inpt.orddeptcd and dept.valitodd = '99991231') WHERE inpt.instcd = :param0 AND inpt.pid = :param1 AND inpt.indd = :param2 AND inpt.histstat = 'Y' AND inpt.mskind = 'M' union all SELECT orddd as ClnDate, substr(orddd, 1, 4) || '-' || substr(orddd, 5, 2) || '-' || substr(orddd, 7, 2) as ClnFormatDate, otpt.ordtype as VisitType, case when ordtype = 'O' then '외래' when ordtype = 'I' then '입원' when ordtype = 'E' then '응급' end as VisitTypeName, dept.deptengabbr as ClnDeptCode, dept.depthngnm as ClnDeptName, otpt.cretno FROM pam.pmohotpt otpt left outer join com.zsdddept dept on (dept.instcd = otpt.instcd and dept.deptcd = otpt.orddeptcd and dept.valitodd = '99991231') WHERE otpt.instcd = :param0 AND otpt.pid = :param1 AND otpt.orddd = :param2] [Logging Date Time: 2016-11-10 11:13:29,264] ===================================================================================== SQL Command - Statement Id: [GET_TRMT_DATE_LIST] Parameters: [param0=[instcd,111], param1=[pid,1715813], param2=[searchClnDate,20161110]] [Logging Date Time: 2016-11-10 11:13:29,264] ===================================================================================== SQL Command - Statement Id: [GET_TRMT_DATE_LIST] Parameters: [param0=[instcd,111], param1=[pid,1715813], param2=[searchClnDate,20161110]] [Logging Date Time: 2016-11-10 11:13:29,264] ===================================================================================== SQL Command - Statement Id: [GET_TRMT_DATE_LIST] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String]] [Logging Date Time: 2016-11-10 11:13:29,264] ===================================================================================== SQL Command - Statement Id: [GET_TRMT_DATE_LIST] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String]] [Logging Date Time: 2016-11-10 11:13:29,365] ===================================================================================== SQL Command - Statement Id: [getPatientInfoOut] PreparedStatement : [SELECT a.orddeptcd, a.pid as IO_Pt_ID, to_char(a.cretno) as IO_CretNo, (select ptbs.sex || '/' || com.fn_zz_getageas(ptbs.rrgstno1, ptbs.rrgstno2, TO_CHAR(SYSDATE, 'YYYYMMDD'), 'A', ptbs.brthdd) from pam.pmcmptbs ptbs where ptbs.instcd = a.instcd and ptbs.pid = a.pid) as IO_sex_age_y_m, (select ptbs.hngnm from pam.pmcmptbs ptbs where ptbs.instcd = a.instcd and ptbs.pid = a.pid) as IO_Pt_Name, (select ptbs.rrgstno1 || '-' || substr(ptbs.rrgstno2, 1, 1) || '******' from pam.pmcmptbs ptbs where ptbs.instcd = a.instcd and ptbs.pid = a.pid) IO_JuminNo, '' as IO_Ward, '' as IO_roomNO, a.orddd as IO_ADdate, a.orddd as IO_Dschdd, a.ordtype as IO_VisitType, a.orddeptcd as IO_DeptCd, (select dept.deptengabbr from com.zsdddept dept where dept.deptcd = a.orddeptcd and dept.instcd = a.instcd and dept.valitodd >= a.orddd and dept.valifromdd <= a.orddd) as IO_DeptNm, COM.FN_ZS_GETDEPTNAME(a.instcd, a.orddeptcd, a.orddd) AS IO_Dept2, '' AS IO_OPdeptCd, '' AS IO_OPdeptNm, '' AS IO_OPdrNm, '' AS IO_OPdrId, (SELECT diag.diagcd FROM emr.mmohdiag diag WHERE diag.pid = a.pid AND diag.orddd = a.orddd AND diag.cretno = a.cretno AND diag.diaghistcd = 'O' AND diag.diagtypecd = 'D' AND diag.diagkindcdflag = 'M' AND diag.genrflagcd = a.ordtype and diag.orddeptcd = a.orddeptcd AND diag.diaghistno = (select max(diagh.diaghistno) from emr.mmohdiag diagh where diagh.pid = a.pid AND diagh.orddd = a.orddd AND diagh.cretno = a.cretno AND diagh.instcd = '111' AND diagh.diaghistcd = 'O' AND diagh.diagkindcdflag = 'M' AND diagh.genrflagcd = a.ordtype and diagh.orddeptcd = a.orddeptcd group by pid)) as IO_DxCd, (SELECT term.diaghngnm FROM emr.mmohdiag diag, emr.mmbvdiag term WHERE diag.pid = a.pid AND diag.orddd = a.orddd AND diag.cretno = a.cretno AND diag.instcd = term.instcd AND diag.diagcd = term.orgdiagcd AND diag.diaghistcd = 'O' AND diag.diagtypecd = 'D' AND diag.diagkindcdflag = 'M' AND diag.diagdd >= term.termfromdd AND diag.diagdd <= term.termtodd AND diag.diagdd >= term.diagattrfromdd AND diag.diagdd <= term.diagattrtodd AND diag.genrflagcd = a.ordtype and diag.orddeptcd = a.orddeptcd AND diag.diaghistno = (select max(diagh.diaghistno) from emr.mmohdiag diagh where diagh.pid = a.pid AND diagh.orddd = a.orddd AND diagh.cretno = a.cretno AND diagh.instcd = '111' AND diagh.diaghistcd = 'O' AND diagh.diagkindcdflag = 'M' AND diagh.genrflagcd = a.ordtype and diagh.orddeptcd = a.orddeptcd group by pid)) as IO_DxNm, COM.FN_ZS_GETUSERNM(a.orddrid, a.orddd) as IO_MaindrNm, '111' as IO_HosType, case when ex.bp is null then null else ex.bp end as IO_bp, case when ex.dm is null then null else ex.dm end as IO_dm, case when ex.heart is null then null else ex.heart end as IO_heart, case when ex.kidney is null then null else ex.kidney end as IO_kidney, case when ex.respiration is null then null else ex.respiration end as IO_respiration, case when ex.hx is null then null else ex.hx end as IO_hx, case when ex.allergy is null then null else ex.allergy end as IO_allergy, case when ex.drug is null then null else ex.drug end as IO_drug, case when ex.smoking is null then null else ex.smoking end as IO_smoking, case when ex.idio is null then null else ex.idio end as IO_idio, case when ex.nacrotics is null then null else ex.nacrotics end as IO_nacrotics, case when ex.airway is null then null else ex.airway end as IO_airway, case when ex.hemorrhage is null then null else ex.hemorrhage end as IO_hemorrhage, ex.etc IO_status_etc, '111' as IO_OrderNo, '111' as IO_PrintTime, a.ORDDRID as IO_MaindrId, COM.FN_ZS_GETUSERNM(a.ORDDRID, a.orddd) as IO_MaindrNm, '111' as IO_OcrCd, a.ORDDRID as IO_InputId, COM.FN_ZS_GETUSERNM(a.ORDDRID, a.orddd) as IO_InputNm, '111' as IO_SignImg FROM pam.pmohotpt a left outer join cmr.consent_data_ex ex on (ex.pid = a.pid and ex.cln_date = a.orddd) WHERE a.instcd = :param0 AND a.pid = :param1 AND a.orddd = :param2 AND a.cretno = :param3] [Logging Date Time: 2016-11-10 11:13:29,365] ===================================================================================== SQL Command - Statement Id: [getPatientInfoOut] PreparedStatement : [SELECT a.orddeptcd, a.pid as IO_Pt_ID, to_char(a.cretno) as IO_CretNo, (select ptbs.sex || '/' || com.fn_zz_getageas(ptbs.rrgstno1, ptbs.rrgstno2, TO_CHAR(SYSDATE, 'YYYYMMDD'), 'A', ptbs.brthdd) from pam.pmcmptbs ptbs where ptbs.instcd = a.instcd and ptbs.pid = a.pid) as IO_sex_age_y_m, (select ptbs.hngnm from pam.pmcmptbs ptbs where ptbs.instcd = a.instcd and ptbs.pid = a.pid) as IO_Pt_Name, (select ptbs.rrgstno1 || '-' || substr(ptbs.rrgstno2, 1, 1) || '******' from pam.pmcmptbs ptbs where ptbs.instcd = a.instcd and ptbs.pid = a.pid) IO_JuminNo, '' as IO_Ward, '' as IO_roomNO, a.orddd as IO_ADdate, a.orddd as IO_Dschdd, a.ordtype as IO_VisitType, a.orddeptcd as IO_DeptCd, (select dept.deptengabbr from com.zsdddept dept where dept.deptcd = a.orddeptcd and dept.instcd = a.instcd and dept.valitodd >= a.orddd and dept.valifromdd <= a.orddd) as IO_DeptNm, COM.FN_ZS_GETDEPTNAME(a.instcd, a.orddeptcd, a.orddd) AS IO_Dept2, '' AS IO_OPdeptCd, '' AS IO_OPdeptNm, '' AS IO_OPdrNm, '' AS IO_OPdrId, (SELECT diag.diagcd FROM emr.mmohdiag diag WHERE diag.pid = a.pid AND diag.orddd = a.orddd AND diag.cretno = a.cretno AND diag.diaghistcd = 'O' AND diag.diagtypecd = 'D' AND diag.diagkindcdflag = 'M' AND diag.genrflagcd = a.ordtype and diag.orddeptcd = a.orddeptcd AND diag.diaghistno = (select max(diagh.diaghistno) from emr.mmohdiag diagh where diagh.pid = a.pid AND diagh.orddd = a.orddd AND diagh.cretno = a.cretno AND diagh.instcd = '111' AND diagh.diaghistcd = 'O' AND diagh.diagkindcdflag = 'M' AND diagh.genrflagcd = a.ordtype and diagh.orddeptcd = a.orddeptcd group by pid)) as IO_DxCd, (SELECT term.diaghngnm FROM emr.mmohdiag diag, emr.mmbvdiag term WHERE diag.pid = a.pid AND diag.orddd = a.orddd AND diag.cretno = a.cretno AND diag.instcd = term.instcd AND diag.diagcd = term.orgdiagcd AND diag.diaghistcd = 'O' AND diag.diagtypecd = 'D' AND diag.diagkindcdflag = 'M' AND diag.diagdd >= term.termfromdd AND diag.diagdd <= term.termtodd AND diag.diagdd >= term.diagattrfromdd AND diag.diagdd <= term.diagattrtodd AND diag.genrflagcd = a.ordtype and diag.orddeptcd = a.orddeptcd AND diag.diaghistno = (select max(diagh.diaghistno) from emr.mmohdiag diagh where diagh.pid = a.pid AND diagh.orddd = a.orddd AND diagh.cretno = a.cretno AND diagh.instcd = '111' AND diagh.diaghistcd = 'O' AND diagh.diagkindcdflag = 'M' AND diagh.genrflagcd = a.ordtype and diagh.orddeptcd = a.orddeptcd group by pid)) as IO_DxNm, COM.FN_ZS_GETUSERNM(a.orddrid, a.orddd) as IO_MaindrNm, '111' as IO_HosType, case when ex.bp is null then null else ex.bp end as IO_bp, case when ex.dm is null then null else ex.dm end as IO_dm, case when ex.heart is null then null else ex.heart end as IO_heart, case when ex.kidney is null then null else ex.kidney end as IO_kidney, case when ex.respiration is null then null else ex.respiration end as IO_respiration, case when ex.hx is null then null else ex.hx end as IO_hx, case when ex.allergy is null then null else ex.allergy end as IO_allergy, case when ex.drug is null then null else ex.drug end as IO_drug, case when ex.smoking is null then null else ex.smoking end as IO_smoking, case when ex.idio is null then null else ex.idio end as IO_idio, case when ex.nacrotics is null then null else ex.nacrotics end as IO_nacrotics, case when ex.airway is null then null else ex.airway end as IO_airway, case when ex.hemorrhage is null then null else ex.hemorrhage end as IO_hemorrhage, ex.etc IO_status_etc, '111' as IO_OrderNo, '111' as IO_PrintTime, a.ORDDRID as IO_MaindrId, COM.FN_ZS_GETUSERNM(a.ORDDRID, a.orddd) as IO_MaindrNm, '111' as IO_OcrCd, a.ORDDRID as IO_InputId, COM.FN_ZS_GETUSERNM(a.ORDDRID, a.orddd) as IO_InputNm, '111' as IO_SignImg FROM pam.pmohotpt a left outer join cmr.consent_data_ex ex on (ex.pid = a.pid and ex.cln_date = a.orddd) WHERE a.instcd = :param0 AND a.pid = :param1 AND a.orddd = :param2 AND a.cretno = :param3] [Logging Date Time: 2016-11-10 11:13:29,366] ===================================================================================== SQL Command - Statement Id: [getPatientInfoOut] Parameters: [param0=[instcd,111], param1=[pid,1715813], param2=[orddd,20161110], param3=[cretno,1]] [Logging Date Time: 2016-11-10 11:13:29,366] ===================================================================================== SQL Command - Statement Id: [getPatientInfoOut] Parameters: [param0=[instcd,111], param1=[pid,1715813], param2=[orddd,20161110], param3=[cretno,1]] [Logging Date Time: 2016-11-10 11:13:29,366] ===================================================================================== SQL Command - Statement Id: [getPatientInfoOut] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String], param3=[AnsiString, System.String]] [Logging Date Time: 2016-11-10 11:13:29,366] ===================================================================================== SQL Command - Statement Id: [getPatientInfoOut] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String], param3=[AnsiString, System.String]] [Logging Date Time: 2016-11-10 11:13:29,467] ===================================================================================== SQL Command - Statement Id: [getPatientInfoOut] PreparedStatement : [SELECT a.orddeptcd, a.pid as IO_Pt_ID, to_char(a.cretno) as IO_CretNo, (select ptbs.sex || '/' || com.fn_zz_getageas(ptbs.rrgstno1, ptbs.rrgstno2, TO_CHAR(SYSDATE, 'YYYYMMDD'), 'A', ptbs.brthdd) from pam.pmcmptbs ptbs where ptbs.instcd = a.instcd and ptbs.pid = a.pid) as IO_sex_age_y_m, (select ptbs.hngnm from pam.pmcmptbs ptbs where ptbs.instcd = a.instcd and ptbs.pid = a.pid) as IO_Pt_Name, (select ptbs.rrgstno1 || '-' || substr(ptbs.rrgstno2, 1, 1) || '******' from pam.pmcmptbs ptbs where ptbs.instcd = a.instcd and ptbs.pid = a.pid) IO_JuminNo, '' as IO_Ward, '' as IO_roomNO, a.orddd as IO_ADdate, a.orddd as IO_Dschdd, a.ordtype as IO_VisitType, a.orddeptcd as IO_DeptCd, (select dept.deptengabbr from com.zsdddept dept where dept.deptcd = a.orddeptcd and dept.instcd = a.instcd and dept.valitodd >= a.orddd and dept.valifromdd <= a.orddd) as IO_DeptNm, COM.FN_ZS_GETDEPTNAME(a.instcd, a.orddeptcd, a.orddd) AS IO_Dept2, '' AS IO_OPdeptCd, '' AS IO_OPdeptNm, '' AS IO_OPdrNm, '' AS IO_OPdrId, (SELECT diag.diagcd FROM emr.mmohdiag diag WHERE diag.pid = a.pid AND diag.orddd = a.orddd AND diag.cretno = a.cretno AND diag.diaghistcd = 'O' AND diag.diagtypecd = 'D' AND diag.diagkindcdflag = 'M' AND diag.genrflagcd = a.ordtype and diag.orddeptcd = a.orddeptcd AND diag.diaghistno = (select max(diagh.diaghistno) from emr.mmohdiag diagh where diagh.pid = a.pid AND diagh.orddd = a.orddd AND diagh.cretno = a.cretno AND diagh.instcd = '111' AND diagh.diaghistcd = 'O' AND diagh.diagkindcdflag = 'M' AND diagh.genrflagcd = a.ordtype and diagh.orddeptcd = a.orddeptcd group by pid)) as IO_DxCd, (SELECT term.diaghngnm FROM emr.mmohdiag diag, emr.mmbvdiag term WHERE diag.pid = a.pid AND diag.orddd = a.orddd AND diag.cretno = a.cretno AND diag.instcd = term.instcd AND diag.diagcd = term.orgdiagcd AND diag.diaghistcd = 'O' AND diag.diagtypecd = 'D' AND diag.diagkindcdflag = 'M' AND diag.diagdd >= term.termfromdd AND diag.diagdd <= term.termtodd AND diag.diagdd >= term.diagattrfromdd AND diag.diagdd <= term.diagattrtodd AND diag.genrflagcd = a.ordtype and diag.orddeptcd = a.orddeptcd AND diag.diaghistno = (select max(diagh.diaghistno) from emr.mmohdiag diagh where diagh.pid = a.pid AND diagh.orddd = a.orddd AND diagh.cretno = a.cretno AND diagh.instcd = '111' AND diagh.diaghistcd = 'O' AND diagh.diagkindcdflag = 'M' AND diagh.genrflagcd = a.ordtype and diagh.orddeptcd = a.orddeptcd group by pid)) as IO_DxNm, COM.FN_ZS_GETUSERNM(a.orddrid, a.orddd) as IO_MaindrNm, '111' as IO_HosType, case when ex.bp is null then null else ex.bp end as IO_bp, case when ex.dm is null then null else ex.dm end as IO_dm, case when ex.heart is null then null else ex.heart end as IO_heart, case when ex.kidney is null then null else ex.kidney end as IO_kidney, case when ex.respiration is null then null else ex.respiration end as IO_respiration, case when ex.hx is null then null else ex.hx end as IO_hx, case when ex.allergy is null then null else ex.allergy end as IO_allergy, case when ex.drug is null then null else ex.drug end as IO_drug, case when ex.smoking is null then null else ex.smoking end as IO_smoking, case when ex.idio is null then null else ex.idio end as IO_idio, case when ex.nacrotics is null then null else ex.nacrotics end as IO_nacrotics, case when ex.airway is null then null else ex.airway end as IO_airway, case when ex.hemorrhage is null then null else ex.hemorrhage end as IO_hemorrhage, ex.etc IO_status_etc, '111' as IO_OrderNo, '111' as IO_PrintTime, a.ORDDRID as IO_MaindrId, COM.FN_ZS_GETUSERNM(a.ORDDRID, a.orddd) as IO_MaindrNm, '111' as IO_OcrCd, a.ORDDRID as IO_InputId, COM.FN_ZS_GETUSERNM(a.ORDDRID, a.orddd) as IO_InputNm, '111' as IO_SignImg FROM pam.pmohotpt a left outer join cmr.consent_data_ex ex on (ex.pid = a.pid and ex.cln_date = a.orddd) WHERE a.instcd = :param0 AND a.pid = :param1 AND a.orddd = :param2 AND a.cretno = :param3] [Logging Date Time: 2016-11-10 11:13:29,467] ===================================================================================== SQL Command - Statement Id: [getPatientInfoOut] PreparedStatement : [SELECT a.orddeptcd, a.pid as IO_Pt_ID, to_char(a.cretno) as IO_CretNo, (select ptbs.sex || '/' || com.fn_zz_getageas(ptbs.rrgstno1, ptbs.rrgstno2, TO_CHAR(SYSDATE, 'YYYYMMDD'), 'A', ptbs.brthdd) from pam.pmcmptbs ptbs where ptbs.instcd = a.instcd and ptbs.pid = a.pid) as IO_sex_age_y_m, (select ptbs.hngnm from pam.pmcmptbs ptbs where ptbs.instcd = a.instcd and ptbs.pid = a.pid) as IO_Pt_Name, (select ptbs.rrgstno1 || '-' || substr(ptbs.rrgstno2, 1, 1) || '******' from pam.pmcmptbs ptbs where ptbs.instcd = a.instcd and ptbs.pid = a.pid) IO_JuminNo, '' as IO_Ward, '' as IO_roomNO, a.orddd as IO_ADdate, a.orddd as IO_Dschdd, a.ordtype as IO_VisitType, a.orddeptcd as IO_DeptCd, (select dept.deptengabbr from com.zsdddept dept where dept.deptcd = a.orddeptcd and dept.instcd = a.instcd and dept.valitodd >= a.orddd and dept.valifromdd <= a.orddd) as IO_DeptNm, COM.FN_ZS_GETDEPTNAME(a.instcd, a.orddeptcd, a.orddd) AS IO_Dept2, '' AS IO_OPdeptCd, '' AS IO_OPdeptNm, '' AS IO_OPdrNm, '' AS IO_OPdrId, (SELECT diag.diagcd FROM emr.mmohdiag diag WHERE diag.pid = a.pid AND diag.orddd = a.orddd AND diag.cretno = a.cretno AND diag.diaghistcd = 'O' AND diag.diagtypecd = 'D' AND diag.diagkindcdflag = 'M' AND diag.genrflagcd = a.ordtype and diag.orddeptcd = a.orddeptcd AND diag.diaghistno = (select max(diagh.diaghistno) from emr.mmohdiag diagh where diagh.pid = a.pid AND diagh.orddd = a.orddd AND diagh.cretno = a.cretno AND diagh.instcd = '111' AND diagh.diaghistcd = 'O' AND diagh.diagkindcdflag = 'M' AND diagh.genrflagcd = a.ordtype and diagh.orddeptcd = a.orddeptcd group by pid)) as IO_DxCd, (SELECT term.diaghngnm FROM emr.mmohdiag diag, emr.mmbvdiag term WHERE diag.pid = a.pid AND diag.orddd = a.orddd AND diag.cretno = a.cretno AND diag.instcd = term.instcd AND diag.diagcd = term.orgdiagcd AND diag.diaghistcd = 'O' AND diag.diagtypecd = 'D' AND diag.diagkindcdflag = 'M' AND diag.diagdd >= term.termfromdd AND diag.diagdd <= term.termtodd AND diag.diagdd >= term.diagattrfromdd AND diag.diagdd <= term.diagattrtodd AND diag.genrflagcd = a.ordtype and diag.orddeptcd = a.orddeptcd AND diag.diaghistno = (select max(diagh.diaghistno) from emr.mmohdiag diagh where diagh.pid = a.pid AND diagh.orddd = a.orddd AND diagh.cretno = a.cretno AND diagh.instcd = '111' AND diagh.diaghistcd = 'O' AND diagh.diagkindcdflag = 'M' AND diagh.genrflagcd = a.ordtype and diagh.orddeptcd = a.orddeptcd group by pid)) as IO_DxNm, COM.FN_ZS_GETUSERNM(a.orddrid, a.orddd) as IO_MaindrNm, '111' as IO_HosType, case when ex.bp is null then null else ex.bp end as IO_bp, case when ex.dm is null then null else ex.dm end as IO_dm, case when ex.heart is null then null else ex.heart end as IO_heart, case when ex.kidney is null then null else ex.kidney end as IO_kidney, case when ex.respiration is null then null else ex.respiration end as IO_respiration, case when ex.hx is null then null else ex.hx end as IO_hx, case when ex.allergy is null then null else ex.allergy end as IO_allergy, case when ex.drug is null then null else ex.drug end as IO_drug, case when ex.smoking is null then null else ex.smoking end as IO_smoking, case when ex.idio is null then null else ex.idio end as IO_idio, case when ex.nacrotics is null then null else ex.nacrotics end as IO_nacrotics, case when ex.airway is null then null else ex.airway end as IO_airway, case when ex.hemorrhage is null then null else ex.hemorrhage end as IO_hemorrhage, ex.etc IO_status_etc, '111' as IO_OrderNo, '111' as IO_PrintTime, a.ORDDRID as IO_MaindrId, COM.FN_ZS_GETUSERNM(a.ORDDRID, a.orddd) as IO_MaindrNm, '111' as IO_OcrCd, a.ORDDRID as IO_InputId, COM.FN_ZS_GETUSERNM(a.ORDDRID, a.orddd) as IO_InputNm, '111' as IO_SignImg FROM pam.pmohotpt a left outer join cmr.consent_data_ex ex on (ex.pid = a.pid and ex.cln_date = a.orddd) WHERE a.instcd = :param0 AND a.pid = :param1 AND a.orddd = :param2 AND a.cretno = :param3] [Logging Date Time: 2016-11-10 11:13:29,468] ===================================================================================== SQL Command - Statement Id: [getPatientInfoOut] Parameters: [param0=[instcd,111], param1=[pid,1715813], param2=[orddd,20161110], param3=[cretno,1]] [Logging Date Time: 2016-11-10 11:13:29,468] ===================================================================================== SQL Command - Statement Id: [getPatientInfoOut] Parameters: [param0=[instcd,111], param1=[pid,1715813], param2=[orddd,20161110], param3=[cretno,1]] [Logging Date Time: 2016-11-10 11:13:29,468] ===================================================================================== SQL Command - Statement Id: [getPatientInfoOut] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String], param3=[AnsiString, System.String]] [Logging Date Time: 2016-11-10 11:13:29,468] ===================================================================================== SQL Command - Statement Id: [getPatientInfoOut] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String], param3=[AnsiString, System.String]] [Logging Date Time: 2016-11-10 11:13:29,558] ===================================================================================== SQL Command - Statement Id: [getPatientInfoOut] PreparedStatement : [SELECT a.orddeptcd, a.pid as IO_Pt_ID, to_char(a.cretno) as IO_CretNo, (select ptbs.sex || '/' || com.fn_zz_getageas(ptbs.rrgstno1, ptbs.rrgstno2, TO_CHAR(SYSDATE, 'YYYYMMDD'), 'A', ptbs.brthdd) from pam.pmcmptbs ptbs where ptbs.instcd = a.instcd and ptbs.pid = a.pid) as IO_sex_age_y_m, (select ptbs.hngnm from pam.pmcmptbs ptbs where ptbs.instcd = a.instcd and ptbs.pid = a.pid) as IO_Pt_Name, (select ptbs.rrgstno1 || '-' || substr(ptbs.rrgstno2, 1, 1) || '******' from pam.pmcmptbs ptbs where ptbs.instcd = a.instcd and ptbs.pid = a.pid) IO_JuminNo, '' as IO_Ward, '' as IO_roomNO, a.orddd as IO_ADdate, a.orddd as IO_Dschdd, a.ordtype as IO_VisitType, a.orddeptcd as IO_DeptCd, (select dept.deptengabbr from com.zsdddept dept where dept.deptcd = a.orddeptcd and dept.instcd = a.instcd and dept.valitodd >= a.orddd and dept.valifromdd <= a.orddd) as IO_DeptNm, COM.FN_ZS_GETDEPTNAME(a.instcd, a.orddeptcd, a.orddd) AS IO_Dept2, '' AS IO_OPdeptCd, '' AS IO_OPdeptNm, '' AS IO_OPdrNm, '' AS IO_OPdrId, (SELECT diag.diagcd FROM emr.mmohdiag diag WHERE diag.pid = a.pid AND diag.orddd = a.orddd AND diag.cretno = a.cretno AND diag.diaghistcd = 'O' AND diag.diagtypecd = 'D' AND diag.diagkindcdflag = 'M' AND diag.genrflagcd = a.ordtype and diag.orddeptcd = a.orddeptcd AND diag.diaghistno = (select max(diagh.diaghistno) from emr.mmohdiag diagh where diagh.pid = a.pid AND diagh.orddd = a.orddd AND diagh.cretno = a.cretno AND diagh.instcd = '111' AND diagh.diaghistcd = 'O' AND diagh.diagkindcdflag = 'M' AND diagh.genrflagcd = a.ordtype and diagh.orddeptcd = a.orddeptcd group by pid)) as IO_DxCd, (SELECT term.diaghngnm FROM emr.mmohdiag diag, emr.mmbvdiag term WHERE diag.pid = a.pid AND diag.orddd = a.orddd AND diag.cretno = a.cretno AND diag.instcd = term.instcd AND diag.diagcd = term.orgdiagcd AND diag.diaghistcd = 'O' AND diag.diagtypecd = 'D' AND diag.diagkindcdflag = 'M' AND diag.diagdd >= term.termfromdd AND diag.diagdd <= term.termtodd AND diag.diagdd >= term.diagattrfromdd AND diag.diagdd <= term.diagattrtodd AND diag.genrflagcd = a.ordtype and diag.orddeptcd = a.orddeptcd AND diag.diaghistno = (select max(diagh.diaghistno) from emr.mmohdiag diagh where diagh.pid = a.pid AND diagh.orddd = a.orddd AND diagh.cretno = a.cretno AND diagh.instcd = '111' AND diagh.diaghistcd = 'O' AND diagh.diagkindcdflag = 'M' AND diagh.genrflagcd = a.ordtype and diagh.orddeptcd = a.orddeptcd group by pid)) as IO_DxNm, COM.FN_ZS_GETUSERNM(a.orddrid, a.orddd) as IO_MaindrNm, '111' as IO_HosType, case when ex.bp is null then null else ex.bp end as IO_bp, case when ex.dm is null then null else ex.dm end as IO_dm, case when ex.heart is null then null else ex.heart end as IO_heart, case when ex.kidney is null then null else ex.kidney end as IO_kidney, case when ex.respiration is null then null else ex.respiration end as IO_respiration, case when ex.hx is null then null else ex.hx end as IO_hx, case when ex.allergy is null then null else ex.allergy end as IO_allergy, case when ex.drug is null then null else ex.drug end as IO_drug, case when ex.smoking is null then null else ex.smoking end as IO_smoking, case when ex.idio is null then null else ex.idio end as IO_idio, case when ex.nacrotics is null then null else ex.nacrotics end as IO_nacrotics, case when ex.airway is null then null else ex.airway end as IO_airway, case when ex.hemorrhage is null then null else ex.hemorrhage end as IO_hemorrhage, ex.etc IO_status_etc, '111' as IO_OrderNo, '111' as IO_PrintTime, a.ORDDRID as IO_MaindrId, COM.FN_ZS_GETUSERNM(a.ORDDRID, a.orddd) as IO_MaindrNm, '111' as IO_OcrCd, a.ORDDRID as IO_InputId, COM.FN_ZS_GETUSERNM(a.ORDDRID, a.orddd) as IO_InputNm, '111' as IO_SignImg FROM pam.pmohotpt a left outer join cmr.consent_data_ex ex on (ex.pid = a.pid and ex.cln_date = a.orddd) WHERE a.instcd = :param0 AND a.pid = :param1 AND a.orddd = :param2 AND a.cretno = :param3] [Logging Date Time: 2016-11-10 11:13:29,558] ===================================================================================== SQL Command - Statement Id: [getPatientInfoOut] PreparedStatement : [SELECT a.orddeptcd, a.pid as IO_Pt_ID, to_char(a.cretno) as IO_CretNo, (select ptbs.sex || '/' || com.fn_zz_getageas(ptbs.rrgstno1, ptbs.rrgstno2, TO_CHAR(SYSDATE, 'YYYYMMDD'), 'A', ptbs.brthdd) from pam.pmcmptbs ptbs where ptbs.instcd = a.instcd and ptbs.pid = a.pid) as IO_sex_age_y_m, (select ptbs.hngnm from pam.pmcmptbs ptbs where ptbs.instcd = a.instcd and ptbs.pid = a.pid) as IO_Pt_Name, (select ptbs.rrgstno1 || '-' || substr(ptbs.rrgstno2, 1, 1) || '******' from pam.pmcmptbs ptbs where ptbs.instcd = a.instcd and ptbs.pid = a.pid) IO_JuminNo, '' as IO_Ward, '' as IO_roomNO, a.orddd as IO_ADdate, a.orddd as IO_Dschdd, a.ordtype as IO_VisitType, a.orddeptcd as IO_DeptCd, (select dept.deptengabbr from com.zsdddept dept where dept.deptcd = a.orddeptcd and dept.instcd = a.instcd and dept.valitodd >= a.orddd and dept.valifromdd <= a.orddd) as IO_DeptNm, COM.FN_ZS_GETDEPTNAME(a.instcd, a.orddeptcd, a.orddd) AS IO_Dept2, '' AS IO_OPdeptCd, '' AS IO_OPdeptNm, '' AS IO_OPdrNm, '' AS IO_OPdrId, (SELECT diag.diagcd FROM emr.mmohdiag diag WHERE diag.pid = a.pid AND diag.orddd = a.orddd AND diag.cretno = a.cretno AND diag.diaghistcd = 'O' AND diag.diagtypecd = 'D' AND diag.diagkindcdflag = 'M' AND diag.genrflagcd = a.ordtype and diag.orddeptcd = a.orddeptcd AND diag.diaghistno = (select max(diagh.diaghistno) from emr.mmohdiag diagh where diagh.pid = a.pid AND diagh.orddd = a.orddd AND diagh.cretno = a.cretno AND diagh.instcd = '111' AND diagh.diaghistcd = 'O' AND diagh.diagkindcdflag = 'M' AND diagh.genrflagcd = a.ordtype and diagh.orddeptcd = a.orddeptcd group by pid)) as IO_DxCd, (SELECT term.diaghngnm FROM emr.mmohdiag diag, emr.mmbvdiag term WHERE diag.pid = a.pid AND diag.orddd = a.orddd AND diag.cretno = a.cretno AND diag.instcd = term.instcd AND diag.diagcd = term.orgdiagcd AND diag.diaghistcd = 'O' AND diag.diagtypecd = 'D' AND diag.diagkindcdflag = 'M' AND diag.diagdd >= term.termfromdd AND diag.diagdd <= term.termtodd AND diag.diagdd >= term.diagattrfromdd AND diag.diagdd <= term.diagattrtodd AND diag.genrflagcd = a.ordtype and diag.orddeptcd = a.orddeptcd AND diag.diaghistno = (select max(diagh.diaghistno) from emr.mmohdiag diagh where diagh.pid = a.pid AND diagh.orddd = a.orddd AND diagh.cretno = a.cretno AND diagh.instcd = '111' AND diagh.diaghistcd = 'O' AND diagh.diagkindcdflag = 'M' AND diagh.genrflagcd = a.ordtype and diagh.orddeptcd = a.orddeptcd group by pid)) as IO_DxNm, COM.FN_ZS_GETUSERNM(a.orddrid, a.orddd) as IO_MaindrNm, '111' as IO_HosType, case when ex.bp is null then null else ex.bp end as IO_bp, case when ex.dm is null then null else ex.dm end as IO_dm, case when ex.heart is null then null else ex.heart end as IO_heart, case when ex.kidney is null then null else ex.kidney end as IO_kidney, case when ex.respiration is null then null else ex.respiration end as IO_respiration, case when ex.hx is null then null else ex.hx end as IO_hx, case when ex.allergy is null then null else ex.allergy end as IO_allergy, case when ex.drug is null then null else ex.drug end as IO_drug, case when ex.smoking is null then null else ex.smoking end as IO_smoking, case when ex.idio is null then null else ex.idio end as IO_idio, case when ex.nacrotics is null then null else ex.nacrotics end as IO_nacrotics, case when ex.airway is null then null else ex.airway end as IO_airway, case when ex.hemorrhage is null then null else ex.hemorrhage end as IO_hemorrhage, ex.etc IO_status_etc, '111' as IO_OrderNo, '111' as IO_PrintTime, a.ORDDRID as IO_MaindrId, COM.FN_ZS_GETUSERNM(a.ORDDRID, a.orddd) as IO_MaindrNm, '111' as IO_OcrCd, a.ORDDRID as IO_InputId, COM.FN_ZS_GETUSERNM(a.ORDDRID, a.orddd) as IO_InputNm, '111' as IO_SignImg FROM pam.pmohotpt a left outer join cmr.consent_data_ex ex on (ex.pid = a.pid and ex.cln_date = a.orddd) WHERE a.instcd = :param0 AND a.pid = :param1 AND a.orddd = :param2 AND a.cretno = :param3] [Logging Date Time: 2016-11-10 11:13:29,558] ===================================================================================== SQL Command - Statement Id: [getPatientInfoOut] Parameters: [param0=[instcd,111], param1=[pid,1715813], param2=[orddd,20161110], param3=[cretno,1]] [Logging Date Time: 2016-11-10 11:13:29,558] ===================================================================================== SQL Command - Statement Id: [getPatientInfoOut] Parameters: [param0=[instcd,111], param1=[pid,1715813], param2=[orddd,20161110], param3=[cretno,1]] [Logging Date Time: 2016-11-10 11:13:29,559] ===================================================================================== SQL Command - Statement Id: [getPatientInfoOut] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String], param3=[AnsiString, System.String]] [Logging Date Time: 2016-11-10 11:13:29,559] ===================================================================================== SQL Command - Statement Id: [getPatientInfoOut] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String], param3=[AnsiString, System.String]] [Logging Date Time: 2016-11-10 11:13:30,230] ===================================================================================== SQL Command - Statement Id: [GET_CONSENT_LIST] PreparedStatement : [SELECT CM.CONSENT_MST_RID , DECODE(CM.CONSENT_STATE, 'TEMP' ,'임시저장', 'ELECTR_CMP', '서명', 'PAPER_OUT', '출력' , 'CERTIFY_CMP', '인증', 'UNFINISHED', '미작성', 'VERBAL', '구두') AS CONSENT_STATE_DISP , VEF.FORM_NAME AS CONSENT_NAME , CM.HOS_TYPE , CM.PID , CM.VISIT_TYPE , CM.ORDER_NO , CM.ORDER_CD , CM.ORDER_NAME , CM.CLN_DEPT_CD , (SELECT DEPTHNGNM FROM COM.ZSDDDEPT WHERE DEPTCD = CM.CLN_DEPT_CD and valitodd = '99991231' and instcd = '111') AS CLN_DEPT_NM , COM.FN_ZS_GETDEPTNAME('111', (select dept.deptcd from com.zsdddept dept where dept.instcd = '111' and dept.valitodd = '99991231' and dept.deptengabbr = CM.WARDCD), '99991231') as WARDCD , CM.ROOMCD , CM.FORM_RID , VEF.FORM_CD , VEF.FORM_GUID , C.PRNTCNT , CM.CONSENT_STATE AS CONSENT_STATE , CM.OCR_NUMBER , CM.COSIGN_DC_ID , CM.COSIGN_DC_NAME , CM.MODIFY_USER_ID AS CREATE_USER_ID , CM.MODIFY_USER_NAME AS CREATE_USER_NAME , CM.MODIFY_DATETIME AS CREATE_DATETIME , CM.CLN_DATE , CM.CRETNO , (SELECT OCRTAGPRNTYN FROM V_EFORM_FORMDOC F WHERE F.FORM_RID = CM.FORM_RID ) AS OCRTAGPRNTYN FROM CONSENT_MST CM INNER JOIN EFORM_DOCUMENT VEF ON VEF.FORM_RID = CM.FORM_RID, EMR.MRFMFORM C WHERE CM.USE_YN = 'Y' AND CM.PID = :param0 AND TO_CHAR(TO_DATE(CM.CREATE_DATETIME, 'YYYY-MM-DD HH24:MI:SS'), 'YYYYMMDD') BETWEEN :param1 and :param2 AND VEF.FORM_CD = C.FORMCD AND C.instcd = '111' AND C.formprogflag LIKE 'OCR%' AND C.formlevlcd != '-' AND SUBSTR (C.formtodt, 1, 8) = '99991231' AND CM.CONSENT_STATE IN ('UNFINISHED','TEMP') ORDER BY CONSENT_STATE DESC, CREATE_DATETIME DESC] [Logging Date Time: 2016-11-10 11:13:30,230] ===================================================================================== SQL Command - Statement Id: [GET_CONSENT_LIST] PreparedStatement : [SELECT CM.CONSENT_MST_RID , DECODE(CM.CONSENT_STATE, 'TEMP' ,'임시저장', 'ELECTR_CMP', '서명', 'PAPER_OUT', '출력' , 'CERTIFY_CMP', '인증', 'UNFINISHED', '미작성', 'VERBAL', '구두') AS CONSENT_STATE_DISP , VEF.FORM_NAME AS CONSENT_NAME , CM.HOS_TYPE , CM.PID , CM.VISIT_TYPE , CM.ORDER_NO , CM.ORDER_CD , CM.ORDER_NAME , CM.CLN_DEPT_CD , (SELECT DEPTHNGNM FROM COM.ZSDDDEPT WHERE DEPTCD = CM.CLN_DEPT_CD and valitodd = '99991231' and instcd = '111') AS CLN_DEPT_NM , COM.FN_ZS_GETDEPTNAME('111', (select dept.deptcd from com.zsdddept dept where dept.instcd = '111' and dept.valitodd = '99991231' and dept.deptengabbr = CM.WARDCD), '99991231') as WARDCD , CM.ROOMCD , CM.FORM_RID , VEF.FORM_CD , VEF.FORM_GUID , C.PRNTCNT , CM.CONSENT_STATE AS CONSENT_STATE , CM.OCR_NUMBER , CM.COSIGN_DC_ID , CM.COSIGN_DC_NAME , CM.MODIFY_USER_ID AS CREATE_USER_ID , CM.MODIFY_USER_NAME AS CREATE_USER_NAME , CM.MODIFY_DATETIME AS CREATE_DATETIME , CM.CLN_DATE , CM.CRETNO , (SELECT OCRTAGPRNTYN FROM V_EFORM_FORMDOC F WHERE F.FORM_RID = CM.FORM_RID ) AS OCRTAGPRNTYN FROM CONSENT_MST CM INNER JOIN EFORM_DOCUMENT VEF ON VEF.FORM_RID = CM.FORM_RID, EMR.MRFMFORM C WHERE CM.USE_YN = 'Y' AND CM.PID = :param0 AND TO_CHAR(TO_DATE(CM.CREATE_DATETIME, 'YYYY-MM-DD HH24:MI:SS'), 'YYYYMMDD') BETWEEN :param1 and :param2 AND VEF.FORM_CD = C.FORMCD AND C.instcd = '111' AND C.formprogflag LIKE 'OCR%' AND C.formlevlcd != '-' AND SUBSTR (C.formtodt, 1, 8) = '99991231' AND CM.CONSENT_STATE IN ('UNFINISHED','TEMP') ORDER BY CONSENT_STATE DESC, CREATE_DATETIME DESC] [Logging Date Time: 2016-11-10 11:13:30,231] ===================================================================================== SQL Command - Statement Id: [GET_CONSENT_LIST] Parameters: [param0=[patientCode,1715813], param1=[startDt,20010601], param2=[endDt,20161110]] [Logging Date Time: 2016-11-10 11:13:30,231] ===================================================================================== SQL Command - Statement Id: [GET_CONSENT_LIST] Parameters: [param0=[patientCode,1715813], param1=[startDt,20010601], param2=[endDt,20161110]] [Logging Date Time: 2016-11-10 11:13:30,231] ===================================================================================== SQL Command - Statement Id: [GET_CONSENT_LIST] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String]] [Logging Date Time: 2016-11-10 11:13:30,231] ===================================================================================== SQL Command - Statement Id: [GET_CONSENT_LIST] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String]] [Logging Date Time: 2016-11-10 11:13:39,695] ===================================================================================== SQL Command - CLIP.eForm SaveCompleteAll param : clnDept[105066]patientCode[1715813]clnDeptCode[2010400000]formRid[1307]formCd[1300010589]consentMstRid[1842]rewriteConsentMstRid[0]deviceType[WIN]vistType[O]hosType[111]clnDate[20161110]ward[]roomcd[]orderNo[111]orderName[코감기]orderCd[J00.000.08]ocrCode[2016111063775]cretno[1]createUserName[이봉렬]modifyUserName[이봉렬]imageFileJson[{ "imageFile1" : "201611/10/9b36d0dfc6a54d91ad7d8bafcd65a81c_1.jpg", "imageFile2" : "201611/10/9b36d0dfc6a54d91ad7d8bafcd65a81c_2.jpg" }]certTarget[278a4c26b11e2327060a0f51ddad21bea5f49f32e035bcd23d468b4cd2fc3^d57fffbbe6132bb57bbd045394b7f79a3ea62f5ad6f890e1f682d91cfc25a2]dschdd[20161110]consentState[ELECTR_CMP]mainDrId[105066]dataXml[460,2204,460,2204?455,2204,452,2204?450,2201,447,2201?444,2199,442,2196?442,2191,439,2185?434,2180,434,2172?434,2167,434,2156?439,2148,442,2138?444,2125,450,2111?455,2098,460,2085?471,2069,479,2056?487,2040,500,2027?511,2011,521,1995?532,1982,542,1966?556,1953,564,1939?577,1929,585,1918?593,1908,603,1900?609,1894,614,1894?616,1894,619,1894?622,1900,622,1905?619,1918,619,1929?616,1945,611,1958?609,1976,603,1995?595,2016,590,2040?585,2061,579,2085?577,2109,569,2130?564,2154,561,2172?558,2191,558,2201?558,2209,558,2215?561,2215,564,2212?569,2204,577,2193?582,2180,590,2167?595,2151,606,2138?614,2122,619,2111?627,2098,635,2088?643,2077,648,2072?651,2066,659,2061?664,2058,667,2058?669,2058,672,2058?675,2061,677,2066?677,2069,680,2074?680,2085,680,2093?685,2101,685,2111?685,2119,688,2130?688,2140,691,2148?691,2156,693,2159?696,2167,698,2167?701,2167,704,2159?706,2156,714,2148?717,2140,722,2130?728,2119,730,2111?736,2101,743,2090?749,2085,754,2074?759,2072,762,2066?770,2064,773,2064?773,2061,775,2064?778,2064,778,2066?781,2069,781,2072?783,2074,783,2077?783,2085,786,2088?788,2090,788,2096?791,2098,791,2101?796,2109,799,2111?799,2114,802,2117?804,2117,804,2119?807,2122,807,2122?810,2125,812,2125?815,2125,818,2122?823,2119,826,2117?831,2114,833,2111?836,2103,839,2101?841,2098,844,2096?844,2096466,1254,466,1254?460,1262,458,1265?458,1265,458,1265?458,1265,460,1265?460,1262,468,1254?471,1249,476,1244?484,1236,495,1222?503,1214,508,1206?516,1196,527,1188?534,1180,542,1172?550,1167,556,1159?564,1154,569,1151?572,1143,579,1140?582,1138,582,1138?582,1138,582,1140?579,1140,579,1146?577,1151,569,1156?566,1162,561,1169?558,1177,556,1185?553,1193,548,1201?548,1212,542,1217?542,1225,542,1233?542,1238,542,1244?542,1246,548,1249?550,1251,553,1251?556,1251,558,1251?561,1251,566,1251?569,1249,572,1249?577,1246,579,1249?579,1251,582,1257?582,1262,582,1267?582,1273,582,1275?582,1281669,1217,669,1217?672,1217,675,1214?677,1214,680,1212?685,1212,688,1209?691,1209,691,1206?693,1206,696,1201?698,1201,701,1199?701,1199,704,1196?704,1196640,1601,640,1601?632,1609,624,1619?619,1625,614,1632?609,1638,603,1646?598,1648,598,1648?598,1648,598,1648?603,1646,609,1638?614,1632,622,1627?632,1619,643,1609?651,1601,661,1593?672,1582,680,1574?691,1566,698,1561?706,1550,714,1548?722,1543,728,1540?730,1535,736,1535?741,1529,743,1529?743,1527,743,1527?746,1529,746,1535?746,1537,746,1540?746,1543,743,1545?743,1550,743,1553?741,1561,741,1564?741,1572,743,1577?743,1582,743,1593?743,1601,746,1609?746,1619,746,1627?746,1632,749,1643?749,1648,751,1656?754,1662,754,1664?757,1672,759,1675857,1638,857,1638?860,1638,860,1638?863,1635,865,1635?868,1635,870,1632?873,1630,873,1627?878,1625,881,1622?884,1619,884,1617?886,1609,889,1603?892,1601,894,1595?894,1590,897,1580?897,1574,900,1569?900,1566,900,1561?900,1556,900,1553?900,1550,897,1548?897,1548,894,1548?892,1548,892,1550?889,1553,886,1556?884,1561,884,1566?881,1569,881,1574?878,1580,878,1585?881,1590,881,1595?884,1601,886,1603?886,1606,892,1606?894,1609,897,1609?905,1606,910,1606?915,1603,921,1598?926,1595,937,1590?942,1585,945,1580?950,1572,950,1572995,1482,995,1482?995,1479,995,1479?995,1474,995,1479?992,1479,992,1482?992,1484,990,1490?987,1495,987,1500?982,1508,982,1513?982,1519,982,1521?982,1527,987,1529?987,1529,990,1535?992,1535,995,1535?1000,1529,1005,1529?1008,1527,1016,1527?1021,1524,1027,1521?1032,1521,1035,1519?1037,1519,1042,1519?1042,1519,1045,1519?1045,1519,1045,1521?1045,1524,1045,1527?1042,1529,1037,1535?1037,1540,1035,1543?1032,1548,1032,1550?1029,1553,1029,15531130,1397,1130,1397?1132,1389,1138,1386?1140,1384,1146,1381?1151,1381,1151,1381?1154,1381,1156,1381?1156,1381,1159,1384?1159,1384,1159,1389?1159,1392,1159,1397?1159,1402,1159,1408?1159,1413,1159,1418?1162,1426,1162,1431?1162,1434,1164,1439?1164,1442,1167,1445?1169,1447,1172,1447?1177,1453,1180,1453?1185,1453,1191,1447?1196,1447,1206,1445?1212,1442,1220,1439?1225,1434,1236,1431?1241,1429,1249,1426?1254,1421,1265,1416?1270,1416,1275,1413?1278,1410,1281,1408?1281,1408,1281,14081159,1460,1159,1460?1156,1463,1154,1466?1154,1468,1154,1468?1156,1466,1162,1463?1167,1460,1172,1458?1180,1455,1188,1447?1193,1445,1199,1439?1209,1437,1214,1431?1220,1429,1225,1426?1233,1421,1233,1421881,2267,881,2267?878,2273,878,2273?878,2273,878,2273?873,2267,873,2267?878,2265,878,2265?881,2262,884,2257?889,2254,894,2249?900,2241,908,2236?915,2228,923,2220?934,2207,945,2199?955,2185,966,2178?976,2167,990,2154?997,2146,1005,2138?1016,2130,1016,21301024,2103,1024,2103?1019,2109,1013,2114?1003,2117,1000,2122?997,2125,992,2127?990,2133,987,2138?982,2143,979,2148?979,2154,976,2159?976,2170,976,2178?976,2185,976,2199?976,2209,976,2225?979,2238,979,2254?982,2273,987,2289?987,2307,990,2323?992,2342,995,2363?997,2376,1000,2394?1003,2410,1005,2421?1008,2432,1013,2442?1016,2447,1019,2453?1021,2453,1024,24551106,2275,1106,2275?1109,2275,1109,2275?1109,2278,1109,2281?1109,2283,1106,2286?1106,2291,1103,2294?1103,2302,1103,2305?1103,2307,1103,2307?1106,2307,1106,2307?1109,2307,1111,2305?1114,2302,1119,2297?1124,2291,1130,2283?1135,2278,1138,2267?1143,2257,1146,2249?1154,2236,1156,2225?1162,2215,1164,2204?1167,2196,1169,2183?1169,2178,1172,2170?1172,2164,1172,2159?1172,2156,1169,2154?1167,2154,1164,2154?1162,2154,1159,2156?1154,2164,1146,2170?1143,2175,1138,2183?1132,2193,1130,2201?1124,2209,1119,2220?1117,2230,1114,2238?1111,2249,1111,2260?1109,2267,1109,2275?1111,2283,1111,2291?1114,2297,1117,2305?1124,2307,1127,2312?1132,2312,1138,2315?1143,2315,1151,2312?1159,2312,1164,2307?1172,2305,1180,22971315,2119,1315,2119?1315,2119,1315,2117?1315,2119,1310,2122?1310,2125,1304,2130?1302,2138,1296,2146?1291,2156,1283,2167?1278,2175,1273,2185?1270,2196,1265,2207?1262,2215,1257,2222?1257,2228,1262,2230?1262,2233,1265,2233?1270,2230,1275,2228?1281,2225,1291,2220?1296,2212,1304,2207?1310,2201,1320,2199?1326,2193,1331,2191?1334,2191,1336,2191?1339,2191,1344,2193?1344,2196,1344,2199?1344,2204,1339,2209?1336,2215,1334,2225?1328,2233,1323,2241?1318,2252,1310,2260?1304,2267,1299,2281?1291,2289,1283,2297?1278,2305,1273,2310?1267,23151357,2008,1357,2008?1363,1995,1371,1984?1376,1974,1381,1963?1384,1953,1386,1945?1392,1937,1397,1931?1400,1926,1400,1921?1400,1921,1402,1921?1402,1921,1402,1924?1402,1929,1402,1934?1400,1945,1400,1955?1397,1966,1392,1979?1389,1992,1389,2008?1386,2021,1384,2037?1384,2056,1381,2069?1381,2085,1384,2098?1384,2111,1386,2122?1389,2127,1392,2138?1397,2140,1400,2143?1402,2146,1408,2146?1413,2146,1416,2146?1421,2146,1426,2143?1431,2143,1434,2140?1437,2140,1439,2138?1442,2138,1445,2133?1445,2133,1447,2130?1447,2127,1445,2125?1445,2122,1442,2119?1437,2114,1434,2111?1429,2109,1426,2103?1416,2101,1410,2096?1405,2093,1397,2090?1386,2090,1378,2088?1371,2088,1360,2088?1349,2088,1339,2088?1331,2088,1323,2090?1318,2090,1310,20931606,2170,1606,2170?1603,2172,1603,2178?1601,2180,1598,2180?1598,2183,1598,2183?1598,2183,1598,2183?1598,2183,1601,2180?1603,2178,1606,2172?1611,2167,1619,2159?1625,2151,1630,2140?1635,2130,1646,2119?1651,2109,1656,2096?1659,2085,1662,2072?1667,2061,1672,2045?1672,2032,1675,2019?1677,2006,1677,1987?1680,1974,1680,1955?1680,1939,1683,1926?1683,1910,1683,1897?1683,1884,1680,1876?1680,1868,1677,1857?1677,1852,1675,1847?1672,1844,1667,1842?1662,1839,1659,1836?1654,1836,1651,1836?1646,1839,1643,1842?1635,1847,1632,1852?1627,1863,1625,1871?1622,1881,1619,1894?1617,1908,1611,1924?1611,1937,1611,1953?1617,1968,1619,1987?1622,2003,1625,2016?1630,2032,1635,2045?1646,2061,1651,2072?1659,2085,1667,2093?1677,2103,1685,2114?1691,2119,1701,2125?1709,2130,1714,2138?1720,2140,1728,2143?1733,2146,1736,2148?1738,21511550,1995,1550,1995?1550,1995,1553,1992?1564,1990,1572,1984?1582,1976,1598,1966?1617,1958,1632,1947?1651,1934,1675,1924?1693,1908,1717,1897?1741,1884,1765,1873?1786,1863,1786,1863]formXml[
460,2204,460,2204?455,2204,452,2204?450,2201,447,2201?444,2199,442,2196?442,2191,439,2185?434,2180,434,2172?434,2167,434,2156?439,2148,442,2138?444,2125,450,2111?455,2098,460,2085?471,2069,479,2056?487,2040,500,2027?511,2011,521,1995?532,1982,542,1966?556,1953,564,1939?577,1929,585,1918?593,1908,603,1900?609,1894,614,1894?616,1894,619,1894?622,1900,622,1905?619,1918,619,1929?616,1945,611,1958?609,1976,603,1995?595,2016,590,2040?585,2061,579,2085?577,2109,569,2130?564,2154,561,2172?558,2191,558,2201?558,2209,558,2215?561,2215,564,2212?569,2204,577,2193?582,2180,590,2167?595,2151,606,2138?614,2122,619,2111?627,2098,635,2088?643,2077,648,2072?651,2066,659,2061?664,2058,667,2058?669,2058,672,2058?675,2061,677,2066?677,2069,680,2074?680,2085,680,2093?685,2101,685,2111?685,2119,688,2130?688,2140,691,2148?691,2156,693,2159?696,2167,698,2167?701,2167,704,2159?706,2156,714,2148?717,2140,722,2130?728,2119,730,2111?736,2101,743,2090?749,2085,754,2074?759,2072,762,2066?770,2064,773,2064?773,2061,775,2064?778,2064,778,2066?781,2069,781,2072?783,2074,783,2077?783,2085,786,2088?788,2090,788,2096?791,2098,791,2101?796,2109,799,2111?799,2114,802,2117?804,2117,804,2119?807,2122,807,2122?810,2125,812,2125?815,2125,818,2122?823,2119,826,2117?831,2114,833,2111?836,2103,839,2101?841,2098,844,2096?844,2096466,1254,466,1254?460,1262,458,1265?458,1265,458,1265?458,1265,460,1265?460,1262,468,1254?471,1249,476,1244?484,1236,495,1222?503,1214,508,1206?516,1196,527,1188?534,1180,542,1172?550,1167,556,1159?564,1154,569,1151?572,1143,579,1140?582,1138,582,1138?582,1138,582,1140?579,1140,579,1146?577,1151,569,1156?566,1162,561,1169?558,1177,556,1185?553,1193,548,1201?548,1212,542,1217?542,1225,542,1233?542,1238,542,1244?542,1246,548,1249?550,1251,553,1251?556,1251,558,1251?561,1251,566,1251?569,1249,572,1249?577,1246,579,1249?579,1251,582,1257?582,1262,582,1267?582,1273,582,1275?582,1281669,1217,669,1217?672,1217,675,1214?677,1214,680,1212?685,1212,688,1209?691,1209,691,1206?693,1206,696,1201?698,1201,701,1199?701,1199,704,1196?704,1196640,1601,640,1601?632,1609,624,1619?619,1625,614,1632?609,1638,603,1646?598,1648,598,1648?598,1648,598,1648?603,1646,609,1638?614,1632,622,1627?632,1619,643,1609?651,1601,661,1593?672,1582,680,1574?691,1566,698,1561?706,1550,714,1548?722,1543,728,1540?730,1535,736,1535?741,1529,743,1529?743,1527,743,1527?746,1529,746,1535?746,1537,746,1540?746,1543,743,1545?743,1550,743,1553?741,1561,741,1564?741,1572,743,1577?743,1582,743,1593?743,1601,746,1609?746,1619,746,1627?746,1632,749,1643?749,1648,751,1656?754,1662,754,1664?757,1672,759,1675857,1638,857,1638?860,1638,860,1638?863,1635,865,1635?868,1635,870,1632?873,1630,873,1627?878,1625,881,1622?884,1619,884,1617?886,1609,889,1603?892,1601,894,1595?894,1590,897,1580?897,1574,900,1569?900,1566,900,1561?900,1556,900,1553?900,1550,897,1548?897,1548,894,1548?892,1548,892,1550?889,1553,886,1556?884,1561,884,1566?881,1569,881,1574?878,1580,878,1585?881,1590,881,1595?884,1601,886,1603?886,1606,892,1606?894,1609,897,1609?905,1606,910,1606?915,1603,921,1598?926,1595,937,1590?942,1585,945,1580?950,1572,950,1572995,1482,995,1482?995,1479,995,1479?995,1474,995,1479?992,1479,992,1482?992,1484,990,1490?987,1495,987,1500?982,1508,982,1513?982,1519,982,1521?982,1527,987,1529?987,1529,990,1535?992,1535,995,1535?1000,1529,1005,1529?1008,1527,1016,1527?1021,1524,1027,1521?1032,1521,1035,1519?1037,1519,1042,1519?1042,1519,1045,1519?1045,1519,1045,1521?1045,1524,1045,1527?1042,1529,1037,1535?1037,1540,1035,1543?1032,1548,1032,1550?1029,1553,1029,15531130,1397,1130,1397?1132,1389,1138,1386?1140,1384,1146,1381?1151,1381,1151,1381?1154,1381,1156,1381?1156,1381,1159,1384?1159,1384,1159,1389?1159,1392,1159,1397?1159,1402,1159,1408?1159,1413,1159,1418?1162,1426,1162,1431?1162,1434,1164,1439?1164,1442,1167,1445?1169,1447,1172,1447?1177,1453,1180,1453?1185,1453,1191,1447?1196,1447,1206,1445?1212,1442,1220,1439?1225,1434,1236,1431?1241,1429,1249,1426?1254,1421,1265,1416?1270,1416,1275,1413?1278,1410,1281,1408?1281,1408,1281,14081159,1460,1159,1460?1156,1463,1154,1466?1154,1468,1154,1468?1156,1466,1162,1463?1167,1460,1172,1458?1180,1455,1188,1447?1193,1445,1199,1439?1209,1437,1214,1431?1220,1429,1225,1426?1233,1421,1233,1421881,2267,881,2267?878,2273,878,2273?878,2273,878,2273?873,2267,873,2267?878,2265,878,2265?881,2262,884,2257?889,2254,894,2249?900,2241,908,2236?915,2228,923,2220?934,2207,945,2199?955,2185,966,2178?976,2167,990,2154?997,2146,1005,2138?1016,2130,1016,21301024,2103,1024,2103?1019,2109,1013,2114?1003,2117,1000,2122?997,2125,992,2127?990,2133,987,2138?982,2143,979,2148?979,2154,976,2159?976,2170,976,2178?976,2185,976,2199?976,2209,976,2225?979,2238,979,2254?982,2273,987,2289?987,2307,990,2323?992,2342,995,2363?997,2376,1000,2394?1003,2410,1005,2421?1008,2432,1013,2442?1016,2447,1019,2453?1021,2453,1024,24551106,2275,1106,2275?1109,2275,1109,2275?1109,2278,1109,2281?1109,2283,1106,2286?1106,2291,1103,2294?1103,2302,1103,2305?1103,2307,1103,2307?1106,2307,1106,2307?1109,2307,1111,2305?1114,2302,1119,2297?1124,2291,1130,2283?1135,2278,1138,2267?1143,2257,1146,2249?1154,2236,1156,2225?1162,2215,1164,2204?1167,2196,1169,2183?1169,2178,1172,2170?1172,2164,1172,2159?1172,2156,1169,2154?1167,2154,1164,2154?1162,2154,1159,2156?1154,2164,1146,2170?1143,2175,1138,2183?1132,2193,1130,2201?1124,2209,1119,2220?1117,2230,1114,2238?1111,2249,1111,2260?1109,2267,1109,2275?1111,2283,1111,2291?1114,2297,1117,2305?1124,2307,1127,2312?1132,2312,1138,2315?1143,2315,1151,2312?1159,2312,1164,2307?1172,2305,1180,22971315,2119,1315,2119?1315,2119,1315,2117?1315,2119,1310,2122?1310,2125,1304,2130?1302,2138,1296,2146?1291,2156,1283,2167?1278,2175,1273,2185?1270,2196,1265,2207?1262,2215,1257,2222?1257,2228,1262,2230?1262,2233,1265,2233?1270,2230,1275,2228?1281,2225,1291,2220?1296,2212,1304,2207?1310,2201,1320,2199?1326,2193,1331,2191?1334,2191,1336,2191?1339,2191,1344,2193?1344,2196,1344,2199?1344,2204,1339,2209?1336,2215,1334,2225?1328,2233,1323,2241?1318,2252,1310,2260?1304,2267,1299,2281?1291,2289,1283,2297?1278,2305,1273,2310?1267,23151357,2008,1357,2008?1363,1995,1371,1984?1376,1974,1381,1963?1384,1953,1386,1945?1392,1937,1397,1931?1400,1926,1400,1921?1400,1921,1402,1921?1402,1921,1402,1924?1402,1929,1402,1934?1400,1945,1400,1955?1397,1966,1392,1979?1389,1992,1389,2008?1386,2021,1384,2037?1384,2056,1381,2069?1381,2085,1384,2098?1384,2111,1386,2122?1389,2127,1392,2138?1397,2140,1400,2143?1402,2146,1408,2146?1413,2146,1416,2146?1421,2146,1426,2143?1431,2143,1434,2140?1437,2140,1439,2138?1442,2138,1445,2133?1445,2133,1447,2130?1447,2127,1445,2125?1445,2122,1442,2119?1437,2114,1434,2111?1429,2109,1426,2103?1416,2101,1410,2096?1405,2093,1397,2090?1386,2090,1378,2088?1371,2088,1360,2088?1349,2088,1339,2088?1331,2088,1323,2090?1318,2090,1310,20931606,2170,1606,2170?1603,2172,1603,2178?1601,2180,1598,2180?1598,2183,1598,2183?1598,2183,1598,2183?1598,2183,1601,2180?1603,2178,1606,2172?1611,2167,1619,2159?1625,2151,1630,2140?1635,2130,1646,2119?1651,2109,1656,2096?1659,2085,1662,2072?1667,2061,1672,2045?1672,2032,1675,2019?1677,2006,1677,1987?1680,1974,1680,1955?1680,1939,1683,1926?1683,1910,1683,1897?1683,1884,1680,1876?1680,1868,1677,1857?1677,1852,1675,1847?1672,1844,1667,1842?1662,1839,1659,1836?1654,1836,1651,1836?1646,1839,1643,1842?1635,1847,1632,1852?1627,1863,1625,1871?1622,1881,1619,1894?1617,1908,1611,1924?1611,1937,1611,1953?1617,1968,1619,1987?1622,2003,1625,2016?1630,2032,1635,2045?1646,2061,1651,2072?1659,2085,1667,2093?1677,2103,1685,2114?1691,2119,1701,2125?1709,2130,1714,2138?1720,2140,1728,2143?1733,2146,1736,2148?1738,21511550,1995,1550,1995?1550,1995,1553,1992?1564,1990,1572,1984?1582,1976,1598,1966?1617,1958,1632,1947?1651,1934,1675,1924?1693,1908,1717,1897?1741,1884,1765,1873?1786,1863,1786,1863
]certResult[]