| 1 | ECV3RPC ;ALB/ACS;Event Capture Spreadsheet Data Validation ;Oct 13, 2000
 | 
|---|
| 2 |  ;;2.0; EVENT CAPTURE ;**25,47,49,61,72**;8 May 96
 | 
|---|
| 3 |  ;
 | 
|---|
| 4 |  ;-----------------------------------------------------------------------
 | 
|---|
| 5 |  ;  Validates the following Event Capture Spreadsheet Upload fields:
 | 
|---|
| 6 |  ;    1. DSS UNIT IEN, DSS UNIT NUMBER, DSS UNIT NAME
 | 
|---|
| 7 |  ;    2. ORDERING SECTION
 | 
|---|
| 8 |  ;    3. PROCEDURE CODE
 | 
|---|
| 9 |  ;    4. CATEGORY
 | 
|---|
| 10 |  ;
 | 
|---|
| 11 |  ;-----------------------------------------------------------------------
 | 
|---|
| 12 |  ;
 | 
|---|
| 13 |  ;--Set up error flag
 | 
|---|
| 14 |  S ECERRFLG=0
 | 
|---|
| 15 |  ;
 | 
|---|
| 16 |  ;--GET DSS Unit IEN--
 | 
|---|
| 17 |  S ECDSSIEN=""
 | 
|---|
| 18 |  ; -Check for DSS Unit IEN first
 | 
|---|
| 19 |  I ECUNITV'="",(ECUNITV'=+ECUNITV) D
 | 
|---|
| 20 |  . S ECERRMSG=$P($T(DSS1^ECV3RPC),";;",2)
 | 
|---|
| 21 |  . S ECCOLERR=ECUNITPC
 | 
|---|
| 22 |  . D ERROR
 | 
|---|
| 23 |  I ECUNITV,'ECERRFLG,$D(^ECD(ECUNITV,0)) S ECDSSIEN=ECUNITV
 | 
|---|
| 24 |  I ECUNITV,'ECERRFLG,'$D(^ECD(ECUNITV,0)) D
 | 
|---|
| 25 |  . ; DSS unit ien not found on VistA
 | 
|---|
| 26 |  . S ECERRMSG=$P($T(DSS1^ECV3RPC),";;",2)
 | 
|---|
| 27 |  . S ECCOLERR=ECUNITPC
 | 
|---|
| 28 |  . D ERROR
 | 
|---|
| 29 |  . Q
 | 
|---|
| 30 |  ; -Check for DSS Unit Number
 | 
|---|
| 31 |  I ECDCMV'="",'$D(^ECD("C",ECDCMV)) D
 | 
|---|
| 32 |  . ; DSS Unit Number not found on VistA
 | 
|---|
| 33 |  . S ECERRMSG=$P($T(DSS2^ECV3RPC),";;",2)
 | 
|---|
| 34 |  . S ECCOLERR=ECDCMPC
 | 
|---|
| 35 |  . D ERROR
 | 
|---|
| 36 |  I 'ECERRFLG,ECDCMV'="",$D(^ECD("C",ECDCMV)) S ECDSSIEN=$O(^ECD("C",ECDCMV,0))
 | 
|---|
| 37 |  ;Check if the next record is a match
 | 
|---|
| 38 |  I 'ECERRFLG,'ECDSSIEN,ECDCMV'="",$D(^ECD("C",ECDCMV)) D
 | 
|---|
| 39 |  . S ECDSSIEN=$O(^ECD("C",ECDCMV,0))
 | 
|---|
| 40 |  . I '$D(^ECD("C",ECDCMV)) D
 | 
|---|
| 41 |  . . ; DSS Unit Number not found on VistA
 | 
|---|
| 42 |  . . S ECERRMSG=$P($T(DSS2^ECV3RPC),";;",2)
 | 
|---|
| 43 |  . . S ECCOLERR=ECDCMPC
 | 
|---|
| 44 |  . . D ERROR
 | 
|---|
| 45 |  . . Q
 | 
|---|
| 46 |  ; -Check for DSS Unit Name
 | 
|---|
| 47 |  I ECDSSV'="",'$D(^ECD("B",ECDSSV)) D
 | 
|---|
| 48 |  . S ECERRMSG=$P($T(DSS3^ECV3RPC),";;",2)
 | 
|---|
| 49 |  . S ECCOLERR=ECDSSPC
 | 
|---|
| 50 |  . D ERROR
 | 
|---|
| 51 |  ; 
 | 
|---|
| 52 |  I 'ECERRFLG,'ECDSSIEN,ECDSSV'="",$D(^ECD("B",ECDSSV)) S ECDSSIEN=$O(^ECD("B",ECDSSV,0))
 | 
|---|
| 53 |  I 'ECERRFLG,'ECDSSIEN,ECDSSV'="",'$D(^ECD("B",ECDSSV)) D
 | 
|---|
| 54 |  . N ECNXTDSS
 | 
|---|
| 55 |  . S ECNXTDSS=$O(^ECD("B",ECDSSV))
 | 
|---|
| 56 |  . I ECDSSV=$E(ECNXTDSS,1,$L(ECDSSV)) S ECDSSIEN=$O(^ECD("B",ECNXTDSS,0))
 | 
|---|
| 57 |  . ;
 | 
|---|
| 58 |  . I ECDSSV'=$E(ECNXTDSS,1,$L(ECDSSV)) D
 | 
|---|
| 59 |  . . ; DSS unit name not found on VistA
 | 
|---|
| 60 |  . . S ECERRMSG=$P($T(DSS3^ECV3RPC),";;",2)
 | 
|---|
| 61 |  . . S ECCOLERR=ECDSSPC
 | 
|---|
| 62 |  . . D ERROR
 | 
|---|
| 63 |  . . Q
 | 
|---|
| 64 |  . Q
 | 
|---|
| 65 |  ;
 | 
|---|
| 66 |  ;--Validate Ordering section or derive from DSS Unit IEN--
 | 
|---|
| 67 |  I ECOSV'="" D
 | 
|---|
| 68 |  . S ECOSIEN=$O(^ECC(723,"B",ECOSV,0))
 | 
|---|
| 69 |  . I ECOSIEN="" D
 | 
|---|
| 70 |  . . ; Ordering Section "B" x-ref doesn't exist
 | 
|---|
| 71 |  . . S ECERRMSG=$P($T(ORDSEC1^ECV3RPC),";;",2)
 | 
|---|
| 72 |  . . S ECCOLERR=ECOSPC
 | 
|---|
| 73 |  . . D ERROR
 | 
|---|
| 74 |  . . Q
 | 
|---|
| 75 |  . Q
 | 
|---|
| 76 |  I ECOSV="" D
 | 
|---|
| 77 |  . I 'ECDSSIEN D
 | 
|---|
| 78 |  . . ; Unable to derive Ordering section from DSS Unit
 | 
|---|
| 79 |  . . S ECERRMSG=$P($T(ORDSEC2^ECV3RPC),";;",2)
 | 
|---|
| 80 |  . . S ECCOLERR=ECOSPC
 | 
|---|
| 81 |  . . D ERROR
 | 
|---|
| 82 |  . . Q
 | 
|---|
| 83 |  . I ECDSSIEN D
 | 
|---|
| 84 |  . . S ECOSIEN=$P(^ECD(ECDSSIEN,0),U,3)
 | 
|---|
| 85 |  . . I ECOSIEN="" D
 | 
|---|
| 86 |  . . . ; Unable to derive Ordering section from DSS Unit
 | 
|---|
| 87 |  . . . S ECERRMSG=$P($T(ORDSEC2^ECV3RPC),";;",2)
 | 
|---|
| 88 |  . . . S ECCOLERR=ECOSPC
 | 
|---|
| 89 |  . . . D ERROR
 | 
|---|
| 90 |  . . . Q
 | 
|---|
| 91 |  . . Q
 | 
|---|
| 92 |  ;
 | 
|---|
| 93 |  ;--Procedure must be a National Procedure, Local Procedure,   --
 | 
|---|
| 94 |  ;--or a CPT code, and the EC Event Code Screen must be active --
 | 
|---|
| 95 |  N ECFOUND,ECPI,ECDT
 | 
|---|
| 96 |  S ECERRFLG=0,ECFOUND=0
 | 
|---|
| 97 |  S %DT="XST",X=$G(ECENCV,"NOW") D ^%DT S ECDT=+Y
 | 
|---|
| 98 |  ; Check for National Procedure code (D x-ref)
 | 
|---|
| 99 |  I $D(^EC(725,"D",ECPROCV)) D
 | 
|---|
| 100 |  . S ECPROCV=$O(^EC(725,"D",ECPROCV,0))_";EC(725,"
 | 
|---|
| 101 |  . S ECPI=$P($G(^EC(725,ECPROCV,0)),"^",5)
 | 
|---|
| 102 |  . I ECPI="" S ECFOUND=1 Q
 | 
|---|
| 103 |  . S ECPI=$$CPT^ICPTCOD(ECPI,ECDT) I +ECPI>0,$P(ECPI,"^",7) S ECFOUND=1
 | 
|---|
| 104 |  ; Check for local procedure code (DL x-ref)
 | 
|---|
| 105 |  I 'ECFOUND,$D(^EC(725,"DL",ECPROCV)) D
 | 
|---|
| 106 |  . S ECPROCV=$O(^EC(725,"DL",ECPROCV,0))_";EC(725,"
 | 
|---|
| 107 |  . S ECPI=$P($G(^EC(725,ECPROCV,0)),"^",5)
 | 
|---|
| 108 |  . I ECPI="" S ECFOUND=1 Q
 | 
|---|
| 109 |  . S ECPI=$$CPT^ICPTCOD(ECPI,ECDT) I +ECPI>0,$P(ECPI,"^",7)  S ECFOUND=1
 | 
|---|
| 110 |  ; Check for CPT code (B x-ref)
 | 
|---|
| 111 |  I 'ECFOUND S ECPI=$$CPT^ICPTCOD(ECPROCV,ECDT) I +ECPI>0,$P(ECPI,"^",7) D
 | 
|---|
| 112 |  . S ECPROCV=$P(ECPI,"^")_";ICPT("
 | 
|---|
| 113 |  . S ECFOUND=1
 | 
|---|
| 114 |  ;
 | 
|---|
| 115 |  I 'ECFOUND D
 | 
|---|
| 116 |  . ; Invalid procedure code
 | 
|---|
| 117 |  . S ECERRMSG=$P($T(PROC1^ECV3RPC),";;",2)
 | 
|---|
| 118 |  . S ECCOLERR=ECPROCPC
 | 
|---|
| 119 |  . D ERROR
 | 
|---|
| 120 |  . Q
 | 
|---|
| 121 |  ;
 | 
|---|
| 122 |  ; -Category must exist on the Event Capture Category file
 | 
|---|
| 123 |  I ECCATV="" S ECCATIEN=0
 | 
|---|
| 124 |  I ECCATV'="" D
 | 
|---|
| 125 |  . I $D(^EC(726,"B",ECCATV)) S ECCATIEN=$O(^EC(726,"B",ECCATV,0))
 | 
|---|
| 126 |  . I '$D(^EC(726,"B",ECCATV)) D
 | 
|---|
| 127 |  . . ; B cross reference not found for category
 | 
|---|
| 128 |  . . S ECERRMSG=$P($T(CAT1^ECV3RPC),";;",2)
 | 
|---|
| 129 |  . . S ECCOLERR=ECCATPC
 | 
|---|
| 130 |  . . D ERROR
 | 
|---|
| 131 |  . . Q
 | 
|---|
| 132 |  ;
 | 
|---|
| 133 |  ; -check for active Event Code screen
 | 
|---|
| 134 |  N ECEVNT,ECSNODE,ECSDATA,ECSFOUND
 | 
|---|
| 135 |  I 'ECERRFLG D
 | 
|---|
| 136 |  . S ECEVNT=ECSTAV_"-"_ECDSSIEN_"-"_ECCATIEN_"-"_ECPROCV
 | 
|---|
| 137 |  . S (ECSNODE,ECSFOUND)=0
 | 
|---|
| 138 |  . F  S ECSNODE=$O(^ECJ(ECSNODE)) Q:ECSNODE=""  D
 | 
|---|
| 139 |  . . S ECSDATA=$G(^ECJ(ECSNODE,0))
 | 
|---|
| 140 |  . . I ECEVNT=$P(ECSDATA,U,1) D
 | 
|---|
| 141 |  . . . S ECSFOUND=1
 | 
|---|
| 142 |  . . . I $P(ECSDATA,U,2)'="" D
 | 
|---|
| 143 |  . . . . ; Event Code screen inactive
 | 
|---|
| 144 |  . . . . S ECERRMSG=$P($T(PROC2^ECV3RPC),";;",2)
 | 
|---|
| 145 |  . . . . S ECCOLERR=ECPROCPC
 | 
|---|
| 146 |  . . . . D ERROR
 | 
|---|
| 147 |  . . . . Q
 | 
|---|
| 148 |  . . . Q
 | 
|---|
| 149 |  . . Q
 | 
|---|
| 150 |  . Q
 | 
|---|
| 151 |  ;
 | 
|---|
| 152 |  ;Generate error if event code screen not found
 | 
|---|
| 153 |  I 'ECERRFLG,'ECSFOUND,ECDSSIEN D
 | 
|---|
| 154 |  . ; Event Code screen not found
 | 
|---|
| 155 |  . S ECERRMSG=$P($T(PROC3^ECV3RPC),";;",2)
 | 
|---|
| 156 |  . S ECCOLERR=ECPROCPC
 | 
|---|
| 157 |  . D ERROR
 | 
|---|
| 158 |  . Q
 | 
|---|
| 159 |  ;
 | 
|---|
| 160 |  I 'ECERRFLG,'ECFILDUP D
 | 
|---|
| 161 |  .;Check for duplicate uploaded record base on Loc_DSS Unit_Category_Proc
 | 
|---|
| 162 |  .;Date_Procedure
 | 
|---|
| 163 |  . N ECDUP,ECNAM,ECPNAM,ECI,ECX,Y,ECPRV,ECPROV
 | 
|---|
| 164 |  . S (ECDA,ECDUP)=0
 | 
|---|
| 165 |  . F  S ECDA=$O(^ECH("ADT",ECSTAV,ECSSNIEN,ECDSSIEN,ECDT,ECDA)) Q:'ECDA  D  I ECDUP Q
 | 
|---|
| 166 |  . . S ECX=$G(^ECH(ECDA,0)) I ECX="" Q
 | 
|---|
| 167 |  . . I $P(ECX,U,8)'=ECCATIEN Q
 | 
|---|
| 168 |  . . I $P(ECX,U,9)'=ECPROCV Q
 | 
|---|
| 169 |  . . S ECPNAM="",ECDUP=1
 | 
|---|
| 170 |  . . K ECPRV S ECPROV=$$GETPRV^ECPRVMUT(ECDA,.ECPRV)
 | 
|---|
| 171 |  . . F ECI=1:1:3 S Y=$O(ECPRV("")) I Y'="" D
 | 
|---|
| 172 |  . . . S ECNAM=$P(ECPRV(Y),U,2) K ECPRV(Y)
 | 
|---|
| 173 |  . . . S ECPNAM=ECPNAM_" "_$P(ECNAM,",")_","_$E($P(ECNAM,",",2))
 | 
|---|
| 174 |  . . S ECERRMSG="**DUPLICATE** "
 | 
|---|
| 175 |  . . S ECERRMSG=ECERRMSG_" Clinic: "_$$GET1^DIQ(44,$P(ECX,U,19),.01,"I")
 | 
|---|
| 176 |  . . S ECERRMSG=ECERRMSG_" Order Sect: "_$$GET1^DIQ(723,$P(ECX,U,12),.01,"I")
 | 
|---|
| 177 |  . . S ECERRMSG=ECERRMSG_" Provider: "_ECPNAM
 | 
|---|
| 178 |  . . S ECNAM=$$GET1^DIQ(200,$P(ECX,U,13),.01,"I")
 | 
|---|
| 179 |  . . S ECERRMSG=ECERRMSG_" Entered: "_$P(ECNAM,",")_","_$E($P(ECNAM,",",2))
 | 
|---|
| 180 |  . . S ECCOLERR=ECSTAPC    ;(???)
 | 
|---|
| 181 |  . . D ERROR
 | 
|---|
| 182 |  Q
 | 
|---|
| 183 | ERROR ;--Set up array entry to contain the following:
 | 
|---|
| 184 |  ;1. record number
 | 
|---|
| 185 |  ;2. column number on spreadsheet containing the record number
 | 
|---|
| 186 |  ;3. column number on spreadsheet containing the data in error
 | 
|---|
| 187 |  ;4. error message
 | 
|---|
| 188 |  ;
 | 
|---|
| 189 |  S ECINDEX=ECINDEX+1
 | 
|---|
| 190 |  S RESULTS(ECINDEX)=ECRECV_"^"_ECRECPC_"^"_ECCOLERR_"^"_ECERRMSG_"^"
 | 
|---|
| 191 |  S ECERRFLG=1
 | 
|---|
| 192 |  Q
 | 
|---|
| 193 |  ;
 | 
|---|
| 194 | DSS1 ;;Invalid DSS Unit IEN
 | 
|---|
| 195 | DSS2 ;;Invalid DSS Unit Number
 | 
|---|
| 196 | DSS3 ;;Invalid DSS Unit Name
 | 
|---|
| 197 | ORDSEC1 ;;Ordering Section "B" x-ref not on Med Specialty file(#723)
 | 
|---|
| 198 | ORDSEC2 ;;Unable to derive Ordering Section from DSS Unit
 | 
|---|
| 199 | PROC1 ;;Procedure/CPT invalid
 | 
|---|
| 200 | PROC2 ;;Procedure/CPT invalid for this Station and DSS Unit
 | 
|---|
| 201 | PROC3 ;;Event Code screen not found
 | 
|---|
| 202 | CAT1 ;;Category "B" x-ref not on EC Category file(#726)
 | 
|---|