[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
|
---|