[613] | 1 | QACI20 ; OAKOIFO/TKW - DATA MIGRATION - BUILD SUPPORTING TABLE AND ROC DATA TO MIGRATE (CONT.) ;01/12/2007 11:48
|
---|
| 2 | ;;2.0;Patient Representative;**19**;07/25/1995;Build 55
|
---|
| 3 | ;
|
---|
| 4 | EN ; Read through ROCs, check for errors and if QACI0=0, move data to staging area.
|
---|
| 5 | F ROCIEN=0:0 S ROCIEN=$O(^QA(745.1,ROCIEN)) Q:'ROCIEN S ROC0=$G(^(ROCIEN,0)) D
|
---|
| 6 | . S DOTCNT=DOTCNT+1 I DOTCNT=200 W "." S DOTCNT=0
|
---|
| 7 | . S X="" F I=2:1:16 S X=X_$P(ROC0,"^",I)
|
---|
| 8 | . S OLDROC=$P(ROC0,"^")
|
---|
| 9 | . ; If ROC has no ROC number, or nothing but a ROC number, delete it.
|
---|
| 10 | . I X=""!(OLDROC="") S DIK="^QA(745.1,",DA=ROCIEN D ^DIK Q
|
---|
| 11 | . ; Convert ROC Number to PATS format
|
---|
| 12 | . S ROCNO=$$CONVROC^QACI2C(OLDROC)
|
---|
| 13 | . I ROCNO'?3N.E1"."9N D ERROC^QACI2A(OLDROC,"ROC number is not correctly formatted") Q
|
---|
| 14 | . ; Quit if ROC has already been migrated.
|
---|
| 15 | . I $D(^XTMP("QACMIGR","ROC","D",ROCNO)) S X=^(ROCNO) D Q
|
---|
| 16 | .. I X="" S ^XTMP("QACMIGR","ROC","D",ROCNO)=ROCIEN Q
|
---|
| 17 | .. I X'=ROCIEN D ERROC^QACI2A(OLDROC_" IEN: "_ROCIEN," is a duplicate ROC number")
|
---|
| 18 | .. Q
|
---|
| 19 | . ; Generate an error for duplicate ROC numbers
|
---|
| 20 | . I $D(^XTMP("QACMIGR","ROC","U",ROCNO_" "))!($D(^XTMP("QACMIGR","ROC","E",OLDROC_" "))) D Q
|
---|
| 21 | .. D ERROC^QACI2A(OLDROC_" IEN: "_ROCIEN," is a duplicate ROC number") Q
|
---|
| 22 | . ; Extract date of contact, convert to 'Oracle friendly' format
|
---|
| 23 | . I $P(ROC0,"^",2)="" D ERROC^QACI2A(OLDROC,"DATE OF CONTACT is missing") Q
|
---|
| 24 | . D DT^DILF("X",$P(ROC0,"^",2),.CONDATE)
|
---|
| 25 | . I CONDATE>0 S CONDATE=$$FMTE^XLFDT(CONDATE,5)
|
---|
| 26 | . I CONDATE'?1.2N1"/"1.2N1"/"4N D ERROC^QACI2A(OLDROC,"DATE OF CONTACT is invalid")
|
---|
| 27 | . ; Kill ROC from list of ROCs whose data was changed during migration
|
---|
| 28 | . ; and initialize variables indicating ROC was changed
|
---|
| 29 | . D:'QACI0
|
---|
| 30 | .. K ^XTMP("QACMIGR","ROC","C",OLDROC_" ")
|
---|
| 31 | .. S (EDITEBY,EDITIBY,EDITDIV,EDITITXT,EDITRTXT)=0 Q
|
---|
| 32 | . S ROC2=$G(^QA(745.1,ROCIEN,2)),ROC7=$G(^(7))
|
---|
| 33 | . ;
|
---|
| 34 | . ; Get station number
|
---|
| 35 | . S STATION=$P(ROC0,"^",16) I STATION]"" D Q:STATION=""
|
---|
| 36 | .. I '$D(QACDIV(STATION)) D ERROC^QACI2A(OLDROC,"DIVISION pointer "_+STATION_" not in MEDICAL CENTER DIVISION file") Q
|
---|
| 37 | .. S STATION=$$STA^XUAF4(STATION)
|
---|
| 38 | .. I STATION="" D ERROC^QACI2A(OLDROC,"DIVISION pointer "_+STATION_" is invalid or has no Station Number") Q
|
---|
| 39 | .. I '$D(^XTMP("QACMIGR","STDINSTITUTION",STATION)) D ERROC^QACI2A(OLDROC,"DIVISION "_STATION_" is not a valid national station")
|
---|
| 40 | .. Q
|
---|
| 41 | . E D
|
---|
| 42 | .. S STATION=$P(ROC0,"."),EDITDIV=1
|
---|
| 43 | .. I '$$LKUP^XUAF4(STATION) D ERROC^QACI2A(OLDROC,"STATION number part of ROC number is invalid.") Q
|
---|
| 44 | .. I '$D(^XTMP("QACMIGR","STDINSTITUTION",STATION)) D ERROC^QACI2A(OLDROC,"DIVISION "_STATION_" is not a valid national station")
|
---|
| 45 | .. Q
|
---|
| 46 | . ;
|
---|
| 47 | . ; Get Patient IEN
|
---|
| 48 | . S DFN=$P(ROC0,"^",3) I DFN]"" D
|
---|
| 49 | .. I 'DFN!('$D(^DPT(+DFN))) D ERROC^QACI2A(OLDROC,"PATIENT pointer "_+DFN_" is invalid") Q
|
---|
| 50 | .. ; build data for pats_patient table
|
---|
| 51 | .. S PATSERR=0 D PTDATA^QACI2B(PARENT,DFN,QACI0,.PATSERR,.PATSCNT)
|
---|
| 52 | .. I PATSERR D ERROC^QACI2A(OLDROC,"PATIENT has invalid data--see ref data report") Q
|
---|
| 53 | . ;
|
---|
| 54 | . ;Extract and convert to Id value--contacting_entity, treatment_status
|
---|
| 55 | . I 'QACI0 D
|
---|
| 56 | .. S X=$P(ROC0,"^",10),CE=$S(X="":10,$G(CE(X)):CE(X),1:10)
|
---|
| 57 | .. S X=$P(ROC2,"^",2) D
|
---|
| 58 | ... I X]"",$G(TS(X)) S TS=TS(X) Q
|
---|
| 59 | ... S TS=$S(DFN="":5,1:4) Q
|
---|
| 60 | .. Q
|
---|
| 61 | . ;
|
---|
| 62 | . ; Get hospital location data
|
---|
| 63 | . S HL=$P(ROC0,"^",12)
|
---|
| 64 | . ;
|
---|
| 65 | . ; Get Pats User data
|
---|
| 66 | . S INFOBY=+$P(ROC0,"^",6),ENTBY=+$P(ROC0,"^",7)
|
---|
| 67 | . I 'ENTBY S ENTBY=INFOBY,EDITEBY=1
|
---|
| 68 | . I 'INFOBY S INFOBY=ENTBY,EDITIBY=1
|
---|
| 69 | . I 'INFOBY D ERROC^QACI2A(OLDROC,"INFO TAKEN BY and ENTERED BY are both NULL")
|
---|
| 70 | . D:INFOBY
|
---|
| 71 | .. I '$D(^VA(200,INFOBY,0)) D ERROC^QACI2A(OLDROC,"INFO TAKEN BY pointer "_+INFOBY_" is invalid") Q
|
---|
| 72 | .. ; build data for pats_user table
|
---|
| 73 | .. S PATSERR=0 D USERDATA^QACI2B(PARENT,INFOBY,"U",QACI0,.PATSERR,.PATSCNT)
|
---|
| 74 | .. I PATSERR D ERROC^QACI2A(OLDROC,"INFO TAKER has invalid data--see USER on ref data report") Q
|
---|
| 75 | . I ENTBY,ENTBY'=INFOBY D
|
---|
| 76 | .. I '$D(^VA(200,ENTBY,0)) D ERROC^QACI2A(OLDROC,"ENTERED BY pointer "_+ENTBY_" is invalid") Q
|
---|
| 77 | .. ; build data for pats_user table
|
---|
| 78 | .. S PATSERR=0 D USERDATA^QACI2B(PARENT,ENTBY,"U",QACI0,.PATSERR,.PATSCNT)
|
---|
| 79 | .. I PATSERR D ERROC^QACI2A(OLDROC,"ENTERED BY has invalid data--see USER on ref data report") Q
|
---|
| 80 | . ;
|
---|
| 81 | . ; If telephone no.is null but name of contact is not, set telephone toa single space.
|
---|
| 82 | . S PHONE=$P(ROC0,"^",9),PHDESC=$P(ROC0,"^",8)
|
---|
| 83 | . I PHONE]"",$$TXTERR^QACI2C(PHONE,30) D ERROC^QACI2A(OLDROC,"TELEPHONE NO. too long or contains control characters")
|
---|
| 84 | . I PHDESC]"",$$TXTERR^QACI2C(PHDESC,30) D ERROC^QACI2A(OLDROC,"NAME OF CONTACT too long or contains control characters")
|
---|
| 85 | . I PHDESC]"",PHONE="" S PHONE=" "
|
---|
| 86 | . ;
|
---|
| 87 | . ; Get resolution date
|
---|
| 88 | . S RESDATE=$P(ROC7,"^") I RESDATE]"" D
|
---|
| 89 | .. D DT^DILF("X",$P(ROC7,"^"),.RESDATE)
|
---|
| 90 | .. I RESDATE>0 S RESDATE=$$FMTE^XLFDT(RESDATE,5)
|
---|
| 91 | .. I RESDATE'?1.2N1"/"1.2N1"/"4N D ERROC^QACI2A(OLDROC,"DATE RESOLVED is invalid")
|
---|
| 92 | .. Q
|
---|
| 93 | . ;
|
---|
| 94 | . ; Get ROC Status
|
---|
| 95 | . S STATUS=$P(ROC7,"^",2) I STATUS'="O",STATUS'="C" D ERROC^QACI2A(OLDROC,"STATUS not set to either Open or Closed")
|
---|
| 96 | . ;
|
---|
| 97 | . ; Get Congressional Contact
|
---|
| 98 | . S CC=$P(ROC0,"^",13),CCNAME=""
|
---|
| 99 | . I CC]"" D
|
---|
| 100 | .. I '$D(^QA(745.4,+CC,0)) D ERROC^QACI2A(OLDROC,"CONGRESSIONAL CONTACT pointer "_+CC_" is invalid") Q
|
---|
| 101 | .. S CCNAME=$P($G(^QA(745.4,+CC,0)),"^") S:CCNAME="" CCNAME="** no name **"
|
---|
| 102 | .. I $D(^XTMP("QACMIGR","CC","E",+CC)) D ERROC^QACI2A(OLDROC,"CONGRESSIONAL CONTACT "_CCNAME_" invalid--see ref data report")
|
---|
| 103 | .. Q
|
---|
| 104 | . ;
|
---|
| 105 | . ; Get 'Is internal appeal?' flag
|
---|
| 106 | . S INTAPPL=$P(ROC2,"^",7),INTAPPL=$S(INTAPPL="Y":1,1:0)
|
---|
| 107 | . ;
|
---|
| 108 | . ; Get Eligibility Status and Category at time ROC was entered
|
---|
| 109 | . D ELIGCAT^QACI2B(.ELIGSTAT,.CATEGORY,ROC0)
|
---|
| 110 | . ;
|
---|
| 111 | . ; Get rollup status
|
---|
| 112 | . S RLUPSTAT=0 I $P($G(^QA(745.1,ROCIEN,7)),"^",6)=3 S RLUPSTAT=1
|
---|
| 113 | . ;
|
---|
| 114 | . ; Build Issue Text and Resolution Text into output global
|
---|
| 115 | . N RESERR
|
---|
| 116 | . D BLDTXT^QACI2C(ROCNO,ROCIEN,QACI0,.ROCCNT,.RESERR,.EDITITXT,.EDITRTXT)
|
---|
| 117 | . ;
|
---|
| 118 | . ; If not called from ^QACI0, Build data for report of fields changed for migration.
|
---|
| 119 | . I 'QACI0,(EDITEBY+EDITIBY+EDITDIV+EDITITXT+EDITRTXT)>0 D
|
---|
| 120 | .. Q:$D(^XTMP("QACMIGR","ROC","E",OLDROC_" "))
|
---|
| 121 | .. S ^XTMP("QACMIGR","ROC","C",OLDROC_" ")=EDITEBY_"^"_EDITIBY_"^"_EDITDIV_"^"_EDITITXT_"^"_EDITRTXT
|
---|
| 122 | .. Q
|
---|
| 123 | . ; Build main ROC data - if called from ^QACI0, just set node.
|
---|
| 124 | . I QACI0 S ^XTMP("QACMIGR","ROC","U",ROCNO_" ",1)=""
|
---|
| 125 | . E S ^XTMP("QACMIGR","ROC","U",ROCNO_" ",1)=ROCNO_"^MAIN^"_CONDATE_"^"_DFN_"^"_INFOBY_"^"_ENTBY_"^"_TS_"^"_CCNAME_"^"_STATUS_"^"_STATION_"^"_RESDATE_"^"_PHDESC_"^"_PHONE_"^"_CE_"^"_INTAPPL_"^"_ELIGSTAT_"^"_CATEGORY_"^"_RLUPSTAT_"^"
|
---|
| 126 | . ;
|
---|
| 127 | . ; Build Issue Code combinations into output global
|
---|
| 128 | . S ISSERR=$$ENISS^QACI2D(ROCIEN,ROCNO,OLDROC,QACI0,.ROCCNT,.RESERR,HL,PARENT,STATION,.PATSCNT)
|
---|
| 129 | . I ISSERR K ^XTMP("QACMIGR","ROC","U",ROCNO_" ")
|
---|
| 130 | . ; Build Methods of Contact into output global
|
---|
| 131 | . S (MOC,MOCSTR)=""
|
---|
| 132 | . S X=$P(ROC0,"^",11)
|
---|
| 133 | . I X]"" S MOC=$G(MOC(X)) I MOC="" D ERROC^QACI2A(OLDROC,"SOURCE OF CONTACT is invalid")
|
---|
| 134 | . I MOC]"" S MOCSTR=MOC_"^"
|
---|
| 135 | . F I=0:0 S I=$O(^QA(745.1,ROCIEN,12,I)) Q:'I S X=$P($G(^(I,0)),"^") D:X]""
|
---|
| 136 | .. S MOC=$G(MOC(X))
|
---|
| 137 | .. I MOC="" D ERROC^QACI2A(OLDROC,"SOURCE(S) OF CONTACT are invalid") Q
|
---|
| 138 | .. S MOCSTR=MOCSTR_MOC_"^" Q
|
---|
| 139 | . I MOCSTR]"" D
|
---|
| 140 | .. ; If called from ^QACI0, we don't need to save data
|
---|
| 141 | .. Q:QACI0
|
---|
| 142 | .. Q:$D(^XTMP("QACMIGR","ROC","E",OLDROC_" "))
|
---|
| 143 | .. S ROCCNT=ROCCNT+1
|
---|
| 144 | .. S ^XTMP("QACMIGR","ROC","U",ROCNO_" ",ROCCNT)=ROCNO_"^MOC^"_MOCSTR
|
---|
| 145 | .. Q
|
---|
| 146 | . I $D(^XTMP("QACMIGR","ROC","E",OLDROC_" ")) K ^XTMP("QACMIGR","ROC","U",ROCNO_" ") Q
|
---|
| 147 | . S PATSCNT("ROC")=PATSCNT("ROC")+1
|
---|
| 148 | . Q
|
---|
| 149 | Q
|
---|
| 150 | ;
|
---|
| 151 | ;
|
---|