| [613] | 1 | ECV2RPC ;ALB/ACS;Event Capture Spreadsheet Validation;07 Aug 01
 | 
|---|
 | 2 |  ;;2.0; EVENT CAPTURE ;**25,30,49**;8 May 96
 | 
|---|
 | 3 |  ;
 | 
|---|
 | 4 |  ;-----------------------------------------------------------------------
 | 
|---|
 | 5 |  ;       Validates the following Event Capture spreadsheet fields:
 | 
|---|
 | 6 |  ;       1. Location
 | 
|---|
 | 7 |  ;       2. Patient SSN
 | 
|---|
 | 8 |  ;       3. Patient Name
 | 
|---|
 | 9 |  ;-----------------------------------------------------------------------
 | 
|---|
 | 10 |  ;=======================================================================
 | 
|---|
 | 11 |  ;MODIFICATIONS
 | 
|---|
 | 12 |  ;08/2001    EC*2.0*30  Updated the error message for Location
 | 
|---|
 | 13 |  ;=======================================================================
 | 
|---|
 | 14 |  ;
 | 
|---|
 | 15 |  ;--Set up error flag
 | 
|---|
 | 16 |  S ECERRFLG=0
 | 
|---|
 | 17 |  ;
 | 
|---|
 | 18 |  ;--Location must be on the Institution file
 | 
|---|
 | 19 |  I '$D(^DIC(4,ECSTAV)),'$D(^DIC(4,"D",ECSTAV)) D 
 | 
|---|
 | 20 |  . ; Location not on the VistA file
 | 
|---|
 | 21 |  . S ECERRMSG=$P($T(STA1^ECV2RPC),";;",2)
 | 
|---|
 | 22 |  . S ECCOLERR=ECSTAPC
 | 
|---|
 | 23 |  . D ERROR
 | 
|---|
 | 24 |  . Q
 | 
|---|
 | 25 |  ;Check for multiple station number entries
 | 
|---|
 | 26 |  N LOC,C,STR
 | 
|---|
 | 27 |  S (LOC,C)=0,STR=""
 | 
|---|
 | 28 |  F  S LOC=$O(^DIC(4,"D",ECSTAV,LOC)) Q:'LOC  S C=C+1 D
 | 
|---|
 | 29 |  . S LOC(LOC)=ECSTAV_", Location IEN "_LOC_", "_$P(^DIC(4,LOC,0),"^")
 | 
|---|
 | 30 |  I C>1 S LOC=0 F  S LOC=$O(LOC(LOC)) Q:'LOC  D
 | 
|---|
 | 31 |  . S ECERRMSG=$P($T(STA2^ECV2RPC),";;",2)_LOC(LOC)
 | 
|---|
 | 32 |  . S ECCOLERR=ECSTAPC
 | 
|---|
 | 33 |  . D ERROR
 | 
|---|
 | 34 |  I C=1,$D(^DIC(4,"D",ECSTAV)) S ECSTAV=$O(^DIC(4,"D",ECSTAV,"")) ;get ien
 | 
|---|
 | 35 |  ;
 | 
|---|
 | 36 |  ;--Patient SSN must be on the Patient file--
 | 
|---|
 | 37 |  N ECNAME4,ECNAME3,ECNAME2,ECNAME1,ECVNAME4,ECVNAME3
 | 
|---|
 | 38 |  N ECVNAME2,ECVNAME1,ECVNAME,ECSSNNUM
 | 
|---|
 | 39 |  S (ECSSNIEN,ECERRFLG)=0,ECSSNNUM=+ECSSNV
 | 
|---|
 | 40 |  I $L(ECSSNNUM)>9!$L(ECSSNV)>10 D
 | 
|---|
 | 41 |  . ; User has entered an SSN that is too long
 | 
|---|
 | 42 |  . S ECERRMSG=$P($T(SSN5^ECV2RPC),";;",2)
 | 
|---|
 | 43 |  . S ECCOLERR=ECSSNPC
 | 
|---|
 | 44 |  . D ERROR
 | 
|---|
 | 45 |  . Q
 | 
|---|
 | 46 |  I 'ECERRFLG D
 | 
|---|
 | 47 |  . ; -add leading zeros if needed
 | 
|---|
 | 48 |  . I $L(ECSSNNUM)<9 S ECSSNV=$E("000000000",1,9-$L(ECSSNNUM))_ECSSNNUM
 | 
|---|
 | 49 |  . I $L(ECSSNV)>10 D 
 | 
|---|
 | 50 |  . . ; User has entered an invalid SSN
 | 
|---|
 | 51 |  . . S ECERRMSG=$P($T(SSN5^ECV2RPC),";;",2)
 | 
|---|
 | 52 |  . . S ECCOLERR=ECSSNPC
 | 
|---|
 | 53 |  . . D ERROR
 | 
|---|
 | 54 |  . . Q
 | 
|---|
 | 55 |  . I 'ECERRFLG,$L(ECSSNV)=10 D
 | 
|---|
 | 56 |  . . I $E(ECSSNV,10,10)'="P" D
 | 
|---|
 | 57 |  . . . ; Invalid SSN
 | 
|---|
 | 58 |  . . . S ECERRMSG=$P($T(SSN5^ECV2RPC),";;",2)
 | 
|---|
 | 59 |  . . . S ECCOLERR=ECSSNPC
 | 
|---|
 | 60 |  . . . D ERROR
 | 
|---|
 | 61 |  . . Q
 | 
|---|
 | 62 |  . I 'ECERRFLG,'$D(^DPT("SSN",ECSSNV)) D
 | 
|---|
 | 63 |  . . ; No SSN x-ref on patient file
 | 
|---|
 | 64 |  . . S ECERRMSG=$P($T(SSN1^ECV2RPC),";;",2)
 | 
|---|
 | 65 |  . . S ECCOLERR=ECSSNPC
 | 
|---|
 | 66 |  . . D ERROR
 | 
|---|
 | 67 |  . . Q
 | 
|---|
 | 68 |  . Q
 | 
|---|
 | 69 |  I 'ECERRFLG D
 | 
|---|
 | 70 |  . ; -get SSN IEN
 | 
|---|
 | 71 |  . S ECSSNIEN=$O(^DPT("SSN",ECSSNV,0))
 | 
|---|
 | 72 |  . I 'ECSSNIEN D
 | 
|---|
 | 73 |  . . S ECERRMSG=$P($T(SSN2^ECV2RPC),";;",2)
 | 
|---|
 | 74 |  . . S ECCOLERR=ECSSNPC
 | 
|---|
 | 75 |  . . D ERROR
 | 
|---|
 | 76 |  . . Q
 | 
|---|
 | 77 |  . Q
 | 
|---|
 | 78 |  I 'ECERRFLG,'$D(^DPT(ECSSNIEN,0)) D
 | 
|---|
 | 79 |  . ; SSN record not found
 | 
|---|
 | 80 |  . S ECERRMSG=$P($T(SSN3^ECV2RPC),";;",2)
 | 
|---|
 | 81 |  . S ECCOLERR=ECSSNPC
 | 
|---|
 | 82 |  . D ERROR
 | 
|---|
 | 83 |  . Q
 | 
|---|
 | 84 |  ;
 | 
|---|
 | 85 |  I 'ECERRFLG D
 | 
|---|
 | 86 |  . ; -Compare patient file ssn to patient ssn
 | 
|---|
 | 87 |  . S ECVSSN=$P(^DPT(ECSSNIEN,0),U,9)
 | 
|---|
 | 88 |  . I ECVSSN'=ECSSNV D
 | 
|---|
 | 89 |  . . ; Spreadsheet ssn doesn't match vista
 | 
|---|
 | 90 |  . . S ECERRMSG=$P($T(SSN4^ECV2RPC),";;",2)
 | 
|---|
 | 91 |  . . S ECCOLERR=ECSSNPC
 | 
|---|
 | 92 |  . . D ERROR
 | 
|---|
 | 93 |  . . Q
 | 
|---|
 | 94 |  . Q
 | 
|---|
 | 95 |  ;--Patient Name must match VistA name--
 | 
|---|
 | 96 |  I 'ECERRFLG D
 | 
|---|
 | 97 |  . S ECVNAME=$P(^DPT(ECSSNIEN,0),U,1)
 | 
|---|
 | 98 |  . I '$D(ECVNAME) D
 | 
|---|
 | 99 |  . . ; Patient name missing from VistA file
 | 
|---|
 | 100 |  . . S ECERRMSG=$P($T(NAME1^ECV2RPC),";;",2)
 | 
|---|
 | 101 |  . . S ECCOLERR=ECSSNPC
 | 
|---|
 | 102 |  . . D ERROR
 | 
|---|
 | 103 |  . . Q
 | 
|---|
 | 104 |  . Q
 | 
|---|
 | 105 |  I 'ECERRFLG,'ECDECPAT D
 | 
|---|
 | 106 |  . N DFN,VADM S DFN=ECSSNIEN D 2^VADPT I +VADM(6) D
 | 
|---|
 | 107 |  . . S ECERRMSG="WARNING: [PATIENT DIED ON "_$P(VADM(6),U,2)_"]"
 | 
|---|
 | 108 |  . . S ECCOLERR=ECSSNPC
 | 
|---|
 | 109 |  . . D ERROR
 | 
|---|
 | 110 |  I 'ECERRFLG D
 | 
|---|
 | 111 |  . S ECVNAME4=$E(ECVNAME,1,4),ECNAME4=$E(ECPATV,1,4)
 | 
|---|
 | 112 |  . S ECVNAME3=$E(ECVNAME,1,3),ECNAME3=$E(ECPATV,1,3)
 | 
|---|
 | 113 |  . S ECVNAME2=$E(ECVNAME,1,2),ECNAME2=$E(ECPATV,1,2)
 | 
|---|
 | 114 |  . S ECVNAME1=$E(ECVNAME,1,1),ECNAME1=$E(ECPATV,1,1)
 | 
|---|
 | 115 |  . I ECNAME1'=ECVNAME1 D
 | 
|---|
 | 116 |  . . ; First char of name doesn't match
 | 
|---|
 | 117 |  . . S ECERRMSG=$P($T(NAME5^ECV2RPC),";;",2)
 | 
|---|
 | 118 |  . . S ECCOLERR=ECPATLPC
 | 
|---|
 | 119 |  . . D ERROR
 | 
|---|
 | 120 |  . . Q
 | 
|---|
 | 121 |  . I 'ECERRFLG,ECNAME2'=ECVNAME2 D
 | 
|---|
 | 122 |  . . ; First 2 chars of name doesn't match
 | 
|---|
 | 123 |  . . S ECERRMSG=$P($T(NAME2^ECV2RPC),";;",2)
 | 
|---|
 | 124 |  . . S ECCOLERR=ECPATLPC
 | 
|---|
 | 125 |  . . D ERROR
 | 
|---|
 | 126 |  . . Q
 | 
|---|
 | 127 |  . I 'ECERRFLG,(ECNAME3'=ECVNAME3) D
 | 
|---|
 | 128 |  . . ; First 3 chars of name doesn't match
 | 
|---|
 | 129 |  . . S ECERRMSG=$P($T(NAME3^ECV2RPC),";;",2)
 | 
|---|
 | 130 |  . . S ECCOLERR=ECPATLPC
 | 
|---|
 | 131 |  . . D ERROR
 | 
|---|
 | 132 |  . . Q
 | 
|---|
 | 133 |  . I 'ECERRFLG,(ECNAME4'=ECVNAME4) D
 | 
|---|
 | 134 |  . . ; First 4 chars of name doesn't match
 | 
|---|
 | 135 |  . . S ECERRMSG=$P($T(NAME4^ECV2RPC),";;",2)
 | 
|---|
 | 136 |  . . S ECCOLERR=ECPATLPC
 | 
|---|
 | 137 |  . . D ERROR
 | 
|---|
 | 138 |  . . Q
 | 
|---|
 | 139 |  . Q
 | 
|---|
 | 140 |  Q
 | 
|---|
 | 141 |  ;
 | 
|---|
 | 142 | ERROR ;--Set up array entry to contain the following:
 | 
|---|
 | 143 |  ;1. record number
 | 
|---|
 | 144 |  ;2. column number on spreadsheet containing the record number
 | 
|---|
 | 145 |  ;3. column number on spreadsheet containing the data in error
 | 
|---|
 | 146 |  ;4. error message
 | 
|---|
 | 147 |  ;
 | 
|---|
 | 148 |  S ECINDEX=ECINDEX+1
 | 
|---|
 | 149 |  S RESULTS(ECINDEX)=ECRECV_"^"_ECRECPC_"^"_ECCOLERR_"^"_ECERRMSG_"^"
 | 
|---|
 | 150 |  S ECERRFLG=1
 | 
|---|
 | 151 |  Q
 | 
|---|
 | 152 |  ;
 | 
|---|
 | 153 |  ;Error messages:
 | 
|---|
 | 154 |  ;
 | 
|---|
 | 155 | STA1 ;;Location not on institution file(#4)
 | 
|---|
 | 156 | STA2 ;;Multiple entries found for Location/Station #
 | 
|---|
 | 157 | SSN1 ;;No SSN x-ref on patient file(#2)
 | 
|---|
 | 158 | SSN2 ;;No SSN entry on patient file(#2)
 | 
|---|
 | 159 | SSN3 ;;No internal entry on patient file(#2) for ssn x-ref
 | 
|---|
 | 160 | SSN4 ;;SSN doesn't match SSN on patient file(#2)
 | 
|---|
 | 161 | SSN5 ;;SSN invalid
 | 
|---|
 | 162 | NAME1 ;;Patient Name is missing from VistA patient file(#2)
 | 
|---|
 | 163 | NAME2 ;;First 2 chars of patient last name don't match VistA
 | 
|---|
 | 164 | NAME3 ;;First 3 chars of patient last name don't match VistA
 | 
|---|
 | 165 | NAME4 ;;First 4 chars of patient last name don't match VistA
 | 
|---|
 | 166 | NAME5 ;;First char of patient last name doesn't match VistA
 | 
|---|