|
·ÖÀർº½ |
 |
|
|
|
|
×ÊÔ´´óС£º |
×ÊÔ´ÀàÐÍ£ºÎĵµ |
ÏÂÔØ»ý·Ö£º 21 |
|
|
|
×ÊÔ´½éÉÜ |
|
À¶ÔÏPACS¼¯³É½Ó¿Ú˵Ã÷
1. »ñÈ¡HIS¡¢LIS¡¢EMRÐÅÏ¢
ÔÚ»ñÈ¡HIS¡¢LIS¡¢EMRÐÅÏ¢ÉϲÉÓÃÊý¾Ý¿âÖ±Á¬¼¼Êõ¡£¾ßÌåÁ÷³ÌÈçÏ£º
RISµÇ¼Çʱͨ¹ýHISºÅ´ÓHIS»ñÈ¡²¡È˵ÄÏàÓ¦¼ì²éÐÅÏ¢´æÈëRISÊý¾Ý¿â£¨HIS±ØÐèÈ·±£Ìṩ¸øRISµÄÐÅÏ¢Öк¬ÓÐΨһ±êʶһ¸ö¼ì²éµÄºÅA£¨ÈçÉêÇëµ¥ºÅ£©£©£¬RISдÍ걨¸æºó£¬HISͨ¹ýÕâ¸ö¼ì²éºÅAÀ´µ÷ÔÄPACSµÄ±¨¸æ¼°Ó°Ïñ¡£
£¨HISºÅ£©
£¨¼ì²éºÅA£©
1.1. PACSÊý¾Ý¿âµÇ¼
Óû§Ãû³Æ£ºPACS
Óû§ÃÜÂ룺PACS
Óû§È¨ÏÞ£º±íSELECTȨÏÞ£¬½Ó¿Ú´æ´¢¹ý³ÌÖ´ÐÐȨÏÞ
Óû§Ê¹ÓÃÊý¾Ý±í£º ÏêϸÊý¾Ý½á¹¹¼°ËµÃ÷¼ûºó
£¨1£©PAT_MASTE_INDEX ²¡ÈËÖ÷¼Ç¼
£¨2£©EXAM_APPOINTS ²¡È˼ì²éÔ¤Ô¼
£¨3£©EXAM_MASTER ¼ì²éÖ÷¼Ç¼
£¨4£©EXAM_ITEMS ¼ì²éÏîÄ¿Ã÷ϸ
1.2. HIS½Ó¿Ú´æ´¢¹ý³Ì˵Ã÷
create or replace procedure Exam_Pacs_Proc
(vOperation in integer, --¹¦ÄܲÙ×÷·ûºÅ
vExamNo in varchar2, --¼ì²éºÅ
vResult in out integer, --½á¹¹ºÅ
vResultInfo in out varchar2,--½á¹ûÐÅÏ¢
vAppointData in Date, --ԤԼʱ¼ä
vAppointNotice in varchar2, --Ô¤Ô¼×¢ÒâÊÂÏî
vReserveParm1 in out varchar2, --±£Áô²ÎÊý1
vReserveParm2 in out varchar2 --±£Áô²ÎÊý2
) is
/*********************************************************
PACS ½Ó¿Úµ÷Óú¯Êý
²Ù×÷²ÎÊý£º
vOperation£º0 --°ïÖú
1 --ÉêÇëÈ·ÈϹý³Ì,Ô¤Ô¼×¢ÒâÊÂÏî
2 --¼ì²éÒѾִÐÐ
3 --³õÕﱨ¸æÍê³É
4 --È·Èϱ¨¸æÍê³É
5 --Ô¤Ô¼×¢ÒâÊÂÏî
6 --±¨¸æ·¢ÉúÐÞ¸Ä֪ͨ
vExamNo ¼ì²éºÅ ³ý¹¦ÄÜ0ÍâÈ«²¿Ê¹ÓÃ
vResult ·µ»ØÖ´Ðнá¹û ÕýÈ··µ»Øµ÷Óù¦Äܺţ¬´íÎó·µ»Ø<0´íÎóÂë
vResultInfo Ö´Ðнá¹û ·¢Éú´íÎóʱ·µ»Ø´íÎóÐÅÏ¢
vAppointData Ô¤Ô¼¼ì²éʱ¼ä ¹¦ÄÜ5ʹÓÃ
vAppointNotice ¼ì²é×¢ÒâÊÂÏî ¹¦ÄÜ5ʹÓÃ
**********************************************************/
1.3. PACSÏà¹ØHIS±íÊý¾Ý½á¹¹ËµÃ÷
1. ²¡ÈËÖ÷Ë÷Òý PAT_MASTER_INDEX
×Ö¶ÎÖÐÎÄÃû³Æ ×Ö¶ÎÃû ÀàÐÍ ³¤¶È ˵Ã÷
²¡È˱êʶºÅ PATIENT_ID C 10 ²¡ÈËΨһ±êʶºÅ£¬¿ÉÒÔÓÉÓû§¸³Óè¾ßÌåµÄº¬Ò壬È磺²¡°¸ºÅ£¬ÃÅÕïºÅµÈ
סԺºÅ INP_NO C 6 ¿ÉÑ¡µÄ²¡È˱êʶ£¬¿ÉΪ¿Õ
ÐÕÃû NAME C 8 ²¡ÈËÐÕÃû
ÐÕÃûÆ´Òô NAME_PHONETIC C 16 ²¡ÈËÐÕÃûÆ´Òô£¬´óд£¬×Ö¼äÓÃÒ»¸ö¿Õ¸ñ·Ö¸ô£¬³¬³¤½Ø¶Ï
ÐÔ±ð SEX C 4 ÄС¢Å®¡¢Î´Öª£¬±¾ÏµÍ³¶¨Ò壬¼û1.1ÐÔ±ð×Öµä
³öÉúÈÕÆÚ DATE_OF_BIRTH D
³öÉúµØ BIRTH_PLACE C 6 Ö¸¶¨Ê¡ÊÐÏØ£¬Ê¹ÓôúÂ룬¼û2.2ÐÐÕþÇø×Öµä
¹ú¼® CITIZENSHIP C 2 ʹÓùú¼Ò´úÂ룬¼û2.1¹ú¼Ò¼°µØÇø×Öµä
Ãñ×å NATION C 10 Ãñ×广·¶Ãû³Æ£¬¼û1.3Ãñ×å×Öµä
Éí·ÝÖ¤ºÅ ID_NO C 18
Éí·Ý IDENTITY C 10 ÓÉÉí·ÝµÇ¼Ç×ÓϵͳÉú³É£¬×¡ÔºµÇ¼Ç×ÓϵͳÔÚ°ìÀíÈëԺʱ¸üС£Ê¹Óù淶Ãû³Æ£¬ÓÉÓû§¶¨Ò壬¼û1.6Éí·Ý×Öµä
·Ñ±ð CHARGE_TYPE C 8 ÓÉÉí·ÝµÇ¼Ç×ÓϵͳÉú³É£¬×¡ÔºµÇ¼Ç×ÓϵͳÔÚ°ìÀíÈëԺʱ¸üС£Ê¹Óù淶Ãû³Æ£¬ÓÉÓû§¶¨Ò壬¼û1.9·Ñ±ð×Öµä
ºÏͬµ¥Î» UNIT_IN_CONTRACT C 11 Èç¹û²¡ÈËËùÔÚµ¥Î»Îª±¾Ò½ÔºµÄºÏͬµ¥Î»»òÌåϵµ¥Î»£¬ÔòʹÓôúÂ룬·ñÔòΪ¿Õ¡£ÓÉÉí·ÝµÇ¼Ç×ÓϵͳÉú³É£¬×¡ÔºµÇ¼Ç×ÓϵͳÔÚ°ìÀíÈëԺʱ¸üС£´úÂëÓÉÓû§¶¨Ò壬¼û2.4ºÏͬµ¥Î»¼Ç¼
ͨÐŵØÖ· MAILING_ADDRESS C 40 Ö¸ÓÀ¾ÃͨÐŵØÖ·
ÓÊÕþ±àÂë ZIP_CODE C 6 ¶ÔӦͨÐŵØÖ·µÄÓÊÕþ±àÂë
¼ÒÍ¥µç»°ºÅÂë PHONE_NUMBER_HOME C 16
µ¥Î»µç»°ºÅÂë PHONE_NUMBER_BUSINESS C 16
ÁªÏµÈËÐÕÃû NEXT_OF_KIN C 8 ²¡È˵ÄÇ×ÊôÐÕÃû
ÓëÁªÏµÈ˹ØÏµ RELATIONSHIP C 2 ·òÆÞ¡¢¸¸×ӵȣ¬Ê¹ÓôúÂ룬¼û1.19Éç»á¹ØÏµ×Öµä
ÁªÏµÈ˵ØÖ· NEXT_OF_KIN_ADDR C 40
ÁªÏµÈËÓÊÕþ±àÂë NEXT_OF_KIN_ZIP_CODE C 6
ÁªÏµÈ˵绰ºÅÂë NEXT_OF_KIN_PHONE C 16
ÉϴξÍÕïÈÕÆÚ LAST_VISIT_DATE D ÓɹҺÅÓëÔ¤Ô¼×Óϵͳ¸ù¾Ý¾ÍÕï¼Ç¼Ìîд
ÖØÒªÈËÎï±êÖ¾ VIP_INDICATOR N 1 1-VIP 0-·ÇVIP
½¨¿¨ÈÕÆÚ CREATE_DATE D
²Ù×÷Ô± OPERATOR C 8 ×îºóÐ޸ı¾¼Ç¼µÄ²Ù×÷Ô±ÐÕÃû
Íó´ø±êÖ¾ºÅ WRISTBAND_ID C 15 ²¡ÈËÍó´ø±êÖ¾
2. ¼ì²éÔ¤Ô¼¼Ç¼ EXAM_APPOINTS
×Ö¶ÎÖÐÎÄÃû³Æ ×Ö¶ÎÃû ÀàÐÍ ³¤¶È ˵Ã÷
ÉêÇëÐòºÅ EXAM_NO C 10 ÿ¸ö¼ì²éÉêÇëÔÚÕû¸öϵͳ·¶Î§ÄÚ£¬ÓøÃÐòºÅΨһ±êʶ£¬ÐòºÅ¿É²ÉÓü¯ÖзÖÅ䷽ʽ£¬ÐòºÅµÄ×é³É¿ÉÓÉÉêÇëÈÕÆÚ¼ÓÉÏÒ»¸ö˳ÐòºÅ»òʹÓÃÀÛ¼ÆÐòºÅ
²¡È˱êʶºÅ PATIENT_ID C 10 ²»ÒªÇóÉêÇëµÄ²¡È˱ØÐë¾ß±¸Ö÷Ë÷Òý£¬µ«¶Ô¾ßÓÐÖ÷Ë÷ÒýµÄ²¡ÈËʹÓôËÏî
סԺ±êʶ VISIT_ID N 2 ¶ÔÔÚÔº²¡ÈËÊÊÓÃ
¼ì²éºÅÀà±ð LOCAL_ID_CLASS C 1 ÿÖÖ¼ì²é£¬ÔÊÐíʹÓø÷×Ô±¾µØµÄ±êʶºÅ£¬È磺³¬ÉùºÅ¡¢X¹âºÅ£¬±¾×Ö¶ÎÓÃÓÚÇø·Ö²»Í¬ÀàÐ͵ı¾µØ±êʶºÅ£¬ÓÉÓû§¶¨Òå
¼ì²é±êʶºÅ PATIENT_LOCAL_ID C 6 È磺³¬ÉùºÅ¡¢X¹âºÅ£¬Óë¼ì²é±êʶºÅÀà±ðÒ»Æð¹¹³É¼ì²éÖ÷Ë÷ÒýµÄΨһ±êʶ
ÐÕÃû NAME C 8 ²¡ÈËÐÕÃû£¬·Ç¿Õ
ÐÕÃûÆ´Òô NAME_PHONETIC C 16 ²¡ÈËÐÕÃûÆ´Òô£¬´óд£¬×Ö¼äÓÃÒ»¸ö¿Õ¸ñ·Ö¸ô£¬³¬³¤½Ø¶Ï
ÐÔ±ð SEX C 4 ²¡ÈËÐÔ±ð£¬ÄС¢Å®¡¢Î´ÖªµÈ£¬¼û1.1ÐÔ±ð×Öµä
³öÉúÈÕÆÚ DATE_OF_BIRTH D ²¡È˳öÉúÈÕÆÚ
³öÉúµØ BIRTH_PLACE C 6 »ò³ÆÎª¼®¹á£¬Ê¹ÓôúÂ룬±¾ÏµÍ³¶¨Ò壬¼û2.2ÐÐÕþÇø×Öµä
Éí·Ý IDENTITY C 10 ʹÓù淶Ãû³Æ£¬È磺ʦÒÔÉÏ¡¢ÍÅÒÔÏ¡¢Õ½Ê¿µÈ£¬Óû§¶¨Ò壬¼û1.6Éí·Ý×Öµä
·Ñ±ð CHARGE_TYPE C 8 ʹÓù淶Ãû³Æ£¬È磺¹«·Ñ¡¢×Ô·Ñ¡¢ÆäËûµÈ£¬Óû§¶¨Ò壬¼û1.9·Ñ±ð×Öµä
ͨÐŵØÖ· MAILING_ADDRESS C 40
ÓÊÕþ±àÂë ZIP_CODE C 6 Êý×ÖÐÍ×Ö·û
ÁªÏµµç»° PHONE_NUMBER C 16
¼ì²éÀà±ð EXAM_CLASS C 6 Çø·Ö¸÷Àà¼ì²é£¬Ê¹Óù淶Ãû³Æ£¬Óû§¶¨Ò壬¼û3.3¼ì²éÀà±ð×Öµä
¼ì²é×ÓÀà EXAM_SUB_CLASS C 8 Çø·ÖÒ»ÖÖ¼ì²éÀà±ðϵĸ÷×ÓÀ࣬È糬ÉùÀàϵĸ¹²¿¡¢ÐÄÔà¡¢¸¾²úµÈ×ÓÀ࣬ʹÓù淶Ãû³Æ£¬Óû§¶¨Ò壬¼û3.4¼ì²é×ÓÀà×Öµä
ÁÙ´²Ö¢×´ CLIN_SYMP C 400 ÕýÎÄÃèÊö
ÌåÕ÷ PHYS_SIGN C 400 ÕýÎÄÃèÊö
Ïà¹Ø»¯Ñé½á¹û RELEVANT_LAB_TEST C 200 ÕýÎÄÃèÊö
ÆäËûÕï¶Ï RELEVANT_DIAG C 400 ÒÀ¿¿ÆäËû¼ì²éÊֶεõ½µÄÓйØÕï¶Ï
ÁÙ´²Õï¶Ï CLIN_DIAG C 80 Ö÷ÒªÁÙ´²Õï¶Ï£¬ÕýÎÄÃèÊö
¼ì²é·½Ê½ EXAM_MODE C 1 ÃèÊö¼ì²éµÄ³¡Ëù£¬±¾ÏµÍ³¶¨Ò壬A=²¡·¿ B=¼ì²é¿ÆÊÒ
¼ì²é·Ö×é EXAM_GROUP C 16 ÓÃÓÚ±êʶԤԼÅŶӶÓÁС£Ã¿¸ö¶ÓÁгÆÎªÒ»¸ö¼ì²é×é¡£Ëü¿ÉÄÜÊÇһ̨ÒÇÆ÷¶ÔÓ¦¶à¸ö¼ì²éÏîÄ¿¹¹³ÉµÄÅŶӶÓÁУ¬Ò²¿ÉÄÜÊǶą̀ÒÇÆ÷¶ÔÓ¦Ò»¸ö¼ì²éÏîÄ¿¹¹³ÉµÄÒ»¸öÅŶӶÓÁÐ
|
|
ÏÂÔØµØÖ· |
|
|
|
|
|