| 1 | OREORV1 ; SLC/GDU - Orderable Items Records Validation [10/15/04 09:16]
 | 
|---|
| 2 |  ;;3.0;ORDER ENTRY/RESULTS REPORTING;**217**;Dec 17,1997
 | 
|---|
| 3 |  ;OREORV1 - Orderable Items Record Validation
 | 
|---|
| 4 |  ;
 | 
|---|
| 5 |  ;BUG FIX FOR NOIS CASES:
 | 
|---|
| 6 |  ;DAN-0204-42157, ALB-1001-51034, SBY-0803-30443, NJH-0402-20607
 | 
|---|
| 7 |  ;
 | 
|---|
| 8 |  ;Scans the ^ORD(101.43, file and does the following:
 | 
|---|
| 9 |  ;  1. Counts the total number of entries in ^ORD(101.43,
 | 
|---|
| 10 |  ;  2. Determines if a source record ien is stored in the ID field of
 | 
|---|
| 11 |  ;     file 101.43.
 | 
|---|
| 12 |  ;  3. Determines if a package code is stored in the ID field of file
 | 
|---|
| 13 |  ;     101.43.
 | 
|---|
| 14 |  ;  4. Determines if the package code matches the expected pattern of 
 | 
|---|
| 15 |  ;     99XXX (XXX are 3 upper case letters).
 | 
|---|
| 16 |  ;  5. Using the interface standard (documented in OE/RR V3 Package
 | 
|---|
| 17 |  ;     Interface Specifications, July 2001) it determines if the
 | 
|---|
| 18 |  ;     package code is one that it can test for. If it can not be tested
 | 
|---|
| 19 |  ;     for it is considered requiring manual confirmation. It counts the
 | 
|---|
| 20 |  ;     number of OI records needing manual confirmation, subtotaled by
 | 
|---|
| 21 |  ;     package.
 | 
|---|
| 22 |  ;  6. If the OI record can be tested for a source record and one is
 | 
|---|
| 23 |  ;     found it is considered validated. It counts the number of
 | 
|---|
| 24 |  ;      validated OI records and gives subtotals by package. 
 | 
|---|
| 25 |  ;  7. If the OI record can be tested for a source record and one is not
 | 
|---|
| 26 |  ;     found it is considered invalid. It counts the number of OI records
 | 
|---|
| 27 |  ;     considered invalid. It subtotals by the active flag. It subtotals
 | 
|---|
| 28 |  ;     by package. It will flag active records as inactive effective
 | 
|---|
| 29 |  ;     immediately.
 | 
|---|
| 30 |  ;
 | 
|---|
| 31 |  ;This routine builds the temp global ^TMP($J,"OIC"
 | 
|---|
| 32 |  ;All of this information is written to a temporary global.
 | 
|---|
| 33 |  ;This is its structure:
 | 
|---|
| 34 |  ;$J    - The M system variable for job number
 | 
|---|
| 35 |  ;OIC   - Orderable Item Check
 | 
|---|
| 36 |  ;OIIEN - Orderable Item Internal Entry Number
 | 
|---|
| 37 |  ;OIIF  - Orderable Item Inactive Flag
 | 
|---|
| 38 |  ;OIN   - Orderable Item Name
 | 
|---|
| 39 |  ;OIPC  - Orderable Item OIPC
 | 
|---|
| 40 |  ;Note all totals are calculated at run time.
 | 
|---|
| 41 |  ;^TMP($J,"OIC",0)=Total records processed
 | 
|---|
| 42 |  ;^TMP($J,"OIC",1)=Total records with null ID field
 | 
|---|
| 43 |  ;^TMP($J,"OIC",1,OIIEN)=Null
 | 
|---|
| 44 |  ;^TMP($J,"OIC",1,"B",OIN)=OIIEN^OIIF
 | 
|---|
| 45 |  ;^TMP($J,"OIC",2)=Total records with null source IENs
 | 
|---|
| 46 |  ;^TMP($J,"OIC",2,OIIEN)=Null
 | 
|---|
| 47 |  ;^TMP($J,"OIC",2,"B",OIN)=OIIEN^OIIF
 | 
|---|
| 48 |  ;^TMP($J,"OIC",3)=Total records with null source package codes
 | 
|---|
| 49 |  ;^TMP($J,"OIC",3,OIIEN)=Null
 | 
|---|
| 50 |  ;^TMP($J,"OIC",3,"B",OIN)=OIIEN^OIIF
 | 
|---|
| 51 |  ;^TMP($J,"OIC",4)=Total records with bad source package codes
 | 
|---|
| 52 |  ;^TMP($J,"OIC",4,OIPC)=Total by package
 | 
|---|
| 53 |  ;^TMP($J,"OIC",4,OIPC,OIIEN)=Null
 | 
|---|
| 54 |  ;^TMP($J,"OIC",4,OIPC,"B",OIN)=OIIEN^OIIF
 | 
|---|
| 55 |  ;^TMP($J,"OIC",5)=Total records not part of current specification
 | 
|---|
| 56 |  ;^TMP($J,"OIC",5,OIPC)=Total by package code
 | 
|---|
| 57 |  ;^TMP($J,"OIC",5,OIPC,OIIEN)=Null
 | 
|---|
| 58 |  ;^TMP($J,"OIC",5,OIPC,"B",OIN)= OIIEN^OIIF
 | 
|---|
| 59 |  ;^TMP($J,"OIC",6)=Total validated records
 | 
|---|
| 60 |  ;^TMP($J,"OIC",6,OIPC)=Total by package code
 | 
|---|
| 61 |  ;^TMP($J,"OIC",7)=Total records with no matching source records
 | 
|---|
| 62 |  ;^TMP($J,"OIC",7,"A")=Total active records
 | 
|---|
| 63 |  ;^TMP($J,"OIC",7,"A",OIPC)=Total by package code
 | 
|---|
| 64 |  ;^TMP($J,"OIC",7,"A",OIPC,OIIEN)=Null
 | 
|---|
| 65 |  ;^TMP($J,"OIC",7,"A",OIPC,"B",OIN)= OIIEN^OIIF
 | 
|---|
| 66 |  ;^TMP($J,"OIC",7,"I")=Total inactive records
 | 
|---|
| 67 |  ;^TMP($J,"OIC",7,"I",OIPC)=Total by package code
 | 
|---|
| 68 |  ;^TMP($J,"OIC",7,"I",OIPC,OIIEN)=Null
 | 
|---|
| 69 |  ;^TMP($J,"OIC",7,"I",OIPC,"B",OIN)= OIIEN^OIIF
 | 
|---|
| 70 |  ;
 | 
|---|
| 71 |  ;External References
 | 
|---|
| 72 |  ;  $$FIND1^DIC    DBIA 2051
 | 
|---|
| 73 |  ;  UPDATE^DIE     DBIA 2053
 | 
|---|
| 74 |  ;  FDA^DILF       DBIA 2054
 | 
|---|
| 75 |  ;  $$GET1^DIQ     DBIA 2056
 | 
|---|
| 76 |  ;
 | 
|---|
| 77 | OIIDIS ;Orderable Item ID Index Scan
 | 
|---|
| 78 |  ;Scan the ^ORD(101.43 and builds a list of orderable items with no
 | 
|---|
| 79 |  ;match in the source files.
 | 
|---|
| 80 |  ;  ID    - ID, field # 2, from file 101.43
 | 
|---|
| 81 |  ;  IA    - INACTIVATED, field # .1, from file 101.43.
 | 
|---|
| 82 |  ;  IF    - Inactive flag
 | 
|---|
| 83 |  ;          If IA is null then it is set to A for active.
 | 
|---|
| 84 |  ;          If IA is not null then it is set to I for inactive.
 | 
|---|
| 85 |  ;  IEN   - Internal Entry Number of record from file 101.43
 | 
|---|
| 86 |  ;  NAME  - NAME, field # .01, from file 101.43
 | 
|---|
| 87 |  ;  SRIEN - Source Record Internal Entry Number, 1st piece ID
 | 
|---|
| 88 |  ;  SRP   - Source Record Package, 2nd piece ID
 | 
|---|
| 89 |  ;  SRC   - Source Record Check
 | 
|---|
| 90 |  ;          0 - source record does not exist
 | 
|---|
| 91 |  ;          1 - source record exist
 | 
|---|
| 92 |  ;  U     - Fileman, Kernel default delimiter variable, value of "^".
 | 
|---|
| 93 |  ;          U is not newed or deleted.
 | 
|---|
| 94 |  N AF,IA,ID,IF,IEN,NAME,SRIEN,SRP,SRC,X
 | 
|---|
| 95 |  S U="^"
 | 
|---|
| 96 |  K ^TMP($J,"OIC")
 | 
|---|
| 97 |  F X=0:1:7 S ^TMP($J,"OIC",X)=0
 | 
|---|
| 98 |  S IEN=0 F  S IEN=$O(^ORD(101.43,IEN)) Q:'IEN  D
 | 
|---|
| 99 |  . S (ID,IF,NAME,SRIEN,SRP)="",SRC=0
 | 
|---|
| 100 |  . S ^TMP($J,"OIC",0)=$$CI(^TMP($J,"OIC",0))
 | 
|---|
| 101 |  . S NAME=$$GET1^DIQ(101.43,IEN,.01)
 | 
|---|
| 102 |  . S ID=$$GET1^DIQ(101.43,IEN,2)
 | 
|---|
| 103 |  . S IA=$$GET1^DIQ(101.43,IEN,.1)
 | 
|---|
| 104 |  . S IF=$S(IA="":"A",1:"I")
 | 
|---|
| 105 |  . I ID="" D BUILD(1,IEN,ID,IA,IF,NAME,SRP) Q
 | 
|---|
| 106 |  . S SRIEN=$P(ID,";")
 | 
|---|
| 107 |  . S SRP=$P(ID,";",2)
 | 
|---|
| 108 |  . I SRIEN="" D BUILD(2,IEN,ID,IA,IF,NAME,SRP) Q
 | 
|---|
| 109 |  . I SRP="" D BUILD(3,IEN,ID,IA,IF,NAME,SRP) Q
 | 
|---|
| 110 |  . I SRP'?1."99"3U D BUILD(4,IEN,ID,IA,IF,NAME,SRP) Q
 | 
|---|
| 111 |  . I $$PC(SRP)=0 D BUILD(5,IEN,ID,IA,IF,NAME,SRP) Q
 | 
|---|
| 112 |  . S SRC=$$SRC(SRP,SRIEN)
 | 
|---|
| 113 |  . I SRC>0 D BUILD(6,IEN,ID,IA,IF,NAME,SRP) Q
 | 
|---|
| 114 |  . D BUILD(7,IEN,ID,IA,IF,NAME,SRP)
 | 
|---|
| 115 |  Q
 | 
|---|
| 116 | BUILD(NODE,OIIEN,OIID,OIIA,OIIF,OIN,OISRP) ;
 | 
|---|
| 117 |  ;Build the temp OIC global
 | 
|---|
| 118 |  ;Variables passed to BUILD
 | 
|---|
| 119 |  ;  NODE  - Node to be written to
 | 
|---|
| 120 |  ;          1 = ID field is null
 | 
|---|
| 121 |  ;          2 = 1st piece of ID field is null
 | 
|---|
| 122 |  ;          3 = 2nd piece of ID field is null
 | 
|---|
| 123 |  ;          4 = 2nd piece of ID field is not properly formatted
 | 
|---|
| 124 |  ;          5 = 2nd piece of ID field is a package code not
 | 
|---|
| 125 |  ;              part of current interface specification and
 | 
|---|
| 126 |  ;              must be manually validated
 | 
|---|
| 127 |  ;          6 = OI record is considered valid
 | 
|---|
| 128 |  ;          7 = OI record has no matching source record
 | 
|---|
| 129 |  ;  OIIEN - Orderable Item IEN
 | 
|---|
| 130 |  ;  OIID  - Orderable Item ID field
 | 
|---|
| 131 |  ;  OIIA  - Orderable Item INACTIVE field
 | 
|---|
| 132 |  ;  OIIF  - Orderable Item Inactive Flag
 | 
|---|
| 133 |  ;  OIN   - Orderable Item Name
 | 
|---|
| 134 |  ;  OISRP - Orderable Item Source Record Package
 | 
|---|
| 135 |  ;Local variable
 | 
|---|
| 136 |  ;  EM    - Error message returned by FDA^DILF
 | 
|---|
| 137 |  ;  FDA   - FileMan Data Array, output of FDA^DILF, an input
 | 
|---|
| 138 |  ;          array variable for UPDATE^DIE
 | 
|---|
| 139 |  N EM,FDA
 | 
|---|
| 140 |  S ^TMP($J,"OIC",NODE)=$$CI(^TMP($J,"OIC",NODE))
 | 
|---|
| 141 |  I NODE=1!(NODE=2)!(NODE=3) D  Q
 | 
|---|
| 142 |  . S ^TMP($J,"OIC",NODE,OIIEN)=""
 | 
|---|
| 143 |  . S ^TMP($J,"OIC",NODE,"B",OIN)=OIIEN_U_$P(OIIA,"@")
 | 
|---|
| 144 |  I NODE=4!(NODE=5) D  Q
 | 
|---|
| 145 |  . S:$D(^TMP($J,"OIC",NODE,OISRP))=0 ^TMP($J,"OIC",NODE,OISRP)=0
 | 
|---|
| 146 |  . S ^TMP($J,"OIC",NODE,OISRP)=$$CI(^TMP($J,"OIC",NODE,OISRP))
 | 
|---|
| 147 |  . S ^TMP($J,"OIC",NODE,OISRP,OIIEN)=""
 | 
|---|
| 148 |  . S ^TMP($J,"OIC",NODE,OISRP,"B",OIN)=OIIEN_U_$P(OIIA,"@")
 | 
|---|
| 149 |  I NODE=6 D  Q
 | 
|---|
| 150 |  . S:$D(^TMP($J,"OIC",NODE,OISRP))=0 ^TMP($J,"OIC",NODE,OISRP)=0
 | 
|---|
| 151 |  . S ^TMP($J,"OIC",NODE,OISRP)=$$CI(^TMP($J,"OIC",NODE,OISRP)) Q
 | 
|---|
| 152 |  S:$D(^TMP($J,"OIC",NODE,OIIF))=0 ^TMP($J,"OIC",NODE,OIIF)=0
 | 
|---|
| 153 |  S ^TMP($J,"OIC",NODE,OIIF)=$$CI(^TMP($J,"OIC",NODE,OIIF))
 | 
|---|
| 154 |  S:$D(^TMP($J,"OIC",NODE,OIIF,OISRP))=0 ^TMP($J,"OIC",NODE,OIIF,OISRP)=0
 | 
|---|
| 155 |  S ^TMP($J,"OIC",NODE,OIIF,OISRP)=$$CI(^TMP($J,"OIC",NODE,OIIF,OISRP))
 | 
|---|
| 156 |  S ^TMP($J,"OIC",NODE,OIIF,OISRP,OIIEN)=""
 | 
|---|
| 157 |  I OIIF="A" D
 | 
|---|
| 158 |  . D FDA^DILF(101.43,OIIEN_",",.1,"R","T","FDA")
 | 
|---|
| 159 |  . D UPDATE^DIE("E","FDA",OIIEN_",","EM")
 | 
|---|
| 160 |  I OIIA="" S OIIA=$$GET1^DIQ(101.43,OIIEN,.1)
 | 
|---|
| 161 |  S ^TMP($J,"OIC",NODE,OIIF,OISRP,"B",OIN)=OIIEN_U_$P(OIIA,"@")
 | 
|---|
| 162 |  Q
 | 
|---|
| 163 | PC(PK) ;Package Check
 | 
|---|
| 164 |  ;Returns 1 if it is one of the source packages in July 2001 specs doc
 | 
|---|
| 165 |  ;Returns 0 if not one of the source packages in July 2001 specs doc
 | 
|---|
| 166 |  ;Variable passed to PC
 | 
|---|
| 167 |  ;  PK   - Package of the source record
 | 
|---|
| 168 |  S PK=$S(PK="99CON":1,PK="99FHD":1,PK="99FHT":1,PK="99LRT":1,PK="99ORD":1,PK="99PRC":1,PK="99PRO":1,PK="99PSP":1,PK="99RAP":1,1:0)
 | 
|---|
| 169 |  Q PK
 | 
|---|
| 170 | SRC(PK,SRI) ;Source Record Check
 | 
|---|
| 171 |  ;Returns 1 if source record is found, 0 if not
 | 
|---|
| 172 |  ;Variables passed to SRC
 | 
|---|
| 173 |  ;  PK   - Package of the source record
 | 
|---|
| 174 |  ;  SRI  - Source Record IEN
 | 
|---|
| 175 |  ;Local Variables
 | 
|---|
| 176 |  ;  FN   - File Number of source record. Determined by package code.
 | 
|---|
| 177 |  ;  FR   - Found Record, it is the return value.
 | 
|---|
| 178 |  ;         It is equal to 1 if source record found, 0 if not
 | 
|---|
| 179 |  ;  ORLV - Lookup Value, input variable for $$FIND1^DIC 
 | 
|---|
| 180 |  N ERR,FN,FR,ORLV
 | 
|---|
| 181 |  S FN=$S(PK="99CON":123.5,PK="99FHD":111,PK="99FHT":118.2,PK="99LRT":60,PK="99ORD":101.43,PK="99PRC":123.3,PK="99PRO":101,PK="99PSP":50.7,1:71)
 | 
|---|
| 182 |  S ORLV="`"_SRI
 | 
|---|
| 183 |  S FR=$$FIND1^DIC(FN,"","",.ORLV,"","","ERR")
 | 
|---|
| 184 |  Q FR
 | 
|---|
| 185 | CI(CNT) ;Counter
 | 
|---|
| 186 |  ;  CNT - Counter
 | 
|---|
| 187 |  S CNT=CNT+1
 | 
|---|
| 188 |  Q CNT
 | 
|---|