| 1 | DINIT124 ;SFISC/MKO-SORT TEMPLATE FILE ;1:13 PM  13 Nov 1998
 | 
|---|
| 2 |  ;;22.0;VA FileMan;;Mar 30, 1999
 | 
|---|
| 3 |  ;Per VHA Directive 10-93-142, this routine should not be modified.
 | 
|---|
| 4 |  F I=1:2 S X=$T(Q+I) Q:X=""  S Y=$E($T(Q+I+1),4,999),X=$E(X,4,999) S:$A(Y)=126 I=I+1,Y=$E(Y,2,999)_$E($T(Q+I+1),5,99) S:$A(Y)=61 Y=$E(Y,2,999) S @X=Y
 | 
|---|
| 5 |  G ^DINIT125
 | 
|---|
| 6 | Q Q
 | 
|---|
| 7 |  ;;^DD(.4014,9,3)
 | 
|---|
| 8 |  ;;=First ^ piece null, second piece=static part of cross-reference, third piece=global reference, 4th piece=number of variable subscripts to get to (and including) record number.
 | 
|---|
| 9 |  ;;^DD(.4014,9,21,0)
 | 
|---|
| 10 |  ;;=^^8^8^2930115^
 | 
|---|
| 11 |  ;;^DD(.4014,9,21,1,0)
 | 
|---|
| 12 |  ;;= Piece 1 is always null
 | 
|---|
| 13 |  ;;^DD(.4014,9,21,2,0)
 | 
|---|
| 14 |  ;;= Piece 2 is the static part of the cross-reference: ex. DIZ(662001,"B",
 | 
|---|
| 15 |  ;;^DD(.4014,9,21,3,0)
 | 
|---|
| 16 |  ;;= Piece 3 is the global reference: ex. DIZ(662001,
 | 
|---|
| 17 |  ;;^DD(.4014,9,21,4,0)
 | 
|---|
| 18 |  ;;= Piece 4 tells FileMan how many variable subscripts must be sorted
 | 
|---|
| 19 |  ;;^DD(.4014,9,21,5,0)
 | 
|---|
| 20 |  ;;=through to get to the record number, plus 1 for the record number
 | 
|---|
| 21 |  ;;^DD(.4014,9,21,6,0)
 | 
|---|
| 22 |  ;;=itself.  ex. for a regular cross-reference, ^DIZ(662001,"B",X,DA),
 | 
|---|
| 23 |  ;;^DD(.4014,9,21,7,0)
 | 
|---|
| 24 |  ;;=the number is 2.  One for the value of the X subscript, and one for the
 | 
|---|
| 25 |  ;;^DD(.4014,9,21,8,0)
 | 
|---|
| 26 |  ;;=record number itself (DA).
 | 
|---|
| 27 |  ;;^DD(.4014,9,23,0)
 | 
|---|
| 28 |  ;;=^^6^6^2930115^
 | 
|---|
| 29 |  ;;^DD(.4014,9,23,1,0)
 | 
|---|
| 30 |  ;;=The IX nodes are normally derived by FileMan during the entry of sort
 | 
|---|
| 31 |  ;;^DD(.4014,9,23,2,0)
 | 
|---|
| 32 |  ;;=fields (in routine XR^DIP).  However, they can also be passed to the
 | 
|---|
| 33 |  ;;^DD(.4014,9,23,3,0)
 | 
|---|
| 34 |  ;;=print (^DIP) in the BY(0) variable to cause FileMan to either use a MUMPS
 | 
|---|
| 35 |  ;;^DD(.4014,9,23,4,0)
 | 
|---|
| 36 |  ;;=type cross-reference, or a previously sorted list of record numbers.
 | 
|---|
| 37 |  ;;^DD(.4014,9,23,5,0)
 | 
|---|
| 38 |  ;;=Fileman sometimes builds the IX node prior to calling the print, as in
 | 
|---|
| 39 |  ;;^DD(.4014,9,23,6,0)
 | 
|---|
| 40 |  ;;=the INQUIRE option, where the user then goes on to print the records.
 | 
|---|
| 41 |  ;;^DD(.4014,9,"DT")
 | 
|---|
| 42 |  ;;=2930115
 | 
|---|
| 43 |  ;;^DD(.4014,9.5,0)
 | 
|---|
| 44 |  ;;=POINT TO CROSS REFERENCE^F^^PTRIX;E1,245^K:$L(X)>245!($L(X)<1) X
 | 
|---|
| 45 |  ;;^DD(.4014,9.5,3)
 | 
|---|
| 46 |  ;;=Enter global reference for "B" index of .01 field on pointed-to file.  Answer must be 1-245 characters in length.
 | 
|---|
| 47 |  ;;^DD(.4014,9.5,21,0)
 | 
|---|
| 48 |  ;;=^^7^7^2931221^
 | 
|---|
| 49 |  ;;^DD(.4014,9.5,21,1,0)
 | 
|---|
| 50 |  ;;=This node will exist only if the sort field is a pointer, if the sort
 | 
|---|
| 51 |  ;;^DD(.4014,9.5,21,2,0)
 | 
|---|
| 52 |  ;;=field has a regular cross-reference, if the .01 field on the pointed-to
 | 
|---|
| 53 |  ;;^DD(.4014,9.5,21,3,0)
 | 
|---|
| 54 |  ;;=file has a "B" index, and if the .01 field on the pointed-to file is
 | 
|---|
| 55 |  ;;^DD(.4014,9.5,21,4,0)
 | 
|---|
| 56 |  ;;=either a numeric, date, set-of-codes or free-text field, and does not have
 | 
|---|
| 57 |  ;;^DD(.4014,9.5,21,5,0)
 | 
|---|
| 58 |  ;;=an output transform.  If this node exists, it will be set to the static
 | 
|---|
| 59 |  ;;^DD(.4014,9.5,21,6,0)
 | 
|---|
| 60 |  ;;=part of the global reference of the "B" index on the pointed-to file. (ex.
 | 
|---|
| 61 |  ;;^DD(.4014,9.5,21,7,0)
 | 
|---|
| 62 |  ;;=^DIZ(662001,"B",).
 | 
|---|
| 63 |  ;;^DD(.4014,9.5,"DT")
 | 
|---|
| 64 |  ;;=2931221
 | 
|---|
| 65 |  ;;^DD(.4014,10,0)
 | 
|---|
| 66 |  ;;=GET CODE^K^^GET;E1,245^K:$L(X)>245 X D:$D(X) ^DIM
 | 
|---|
| 67 |  ;;^DD(.4014,10,3)
 | 
|---|
| 68 |  ;;=This is Standard MUMPS code used to extract the sort field from a record.
 | 
|---|
| 69 |  ;;^DD(.4014,10,9)
 | 
|---|
| 70 |  ;;=@
 | 
|---|
| 71 |  ;;^DD(.4014,10,21,0)
 | 
|---|
| 72 |  ;;=^^3^3^2930115^
 | 
|---|
| 73 |  ;;^DD(.4014,10,21,1,0)
 | 
|---|
| 74 |  ;;=The GET CODE is MUMPS code that is executed after a record (or sub-record)
 | 
|---|
| 75 |  ;;^DD(.4014,10,21,2,0)
 | 
|---|
| 76 |  ;;=has been selected.  The code extracts the SORT field from that record
 | 
|---|
| 77 |  ;;^DD(.4014,10,21,3,0)
 | 
|---|
| 78 |  ;;=into a local variable.
 | 
|---|
| 79 |  ;;^DD(.4014,10,23,0)
 | 
|---|
| 80 |  ;;=^^1^1^2930115^
 | 
|---|
| 81 |  ;;^DD(.4014,10,23,1,0)
 | 
|---|
| 82 |  ;;=GET CODE can be generated by a call to FileMan routine GET^DIOU.
 | 
|---|
| 83 |  ;;^DD(.4014,10,"DT")
 | 
|---|
| 84 |  ;;=2930115
 | 
|---|
| 85 |  ;;^DD(.4014,11,0)
 | 
|---|
| 86 |  ;;=QUERY CONDITION^K^^QCON;E1,245^K:$L(X)>245 X D:$D(X) ^DIM
 | 
|---|
| 87 |  ;;^DD(.4014,11,3)
 | 
|---|
| 88 |  ;;=This is Standard MUMPS code used to test the field to see whether it meets the query condition (ex., whether it's within the from/to range specified by the user).
 | 
|---|
| 89 |  ;;^DD(.4014,11,9)
 | 
|---|
| 90 |  ;;=@
 | 
|---|
| 91 |  ;;^DD(.4014,11,21,0)
 | 
|---|
| 92 |  ;;=^^5^5^2930115^
 | 
|---|
| 93 |  ;;^DD(.4014,11,21,1,0)
 | 
|---|
| 94 |  ;;=The QUERY CONDITION is MUMPS code that takes a field in a local variable,
 | 
|---|
| 95 |  ;;^DD(.4014,11,21,2,0)
 | 
|---|
| 96 |  ;;=and executes some query condition.  The results of executing the code
 | 
|---|
| 97 |  ;;^DD(.4014,11,21,3,0)
 | 
|---|
| 98 |  ;;=will return a truth value of TRUE if the field met the condition, or
 | 
|---|
| 99 |  ;;^DD(.4014,11,21,4,0)
 | 
|---|
| 100 |  ;;=FALSE if not.  It is used, for example, to see whether a SORT FIELD falls
 | 
|---|
| 101 |  ;;^DD(.4014,11,21,5,0)
 | 
|---|
| 102 |  ;;=within the FROM/TO range requested by the user.
 | 
|---|
| 103 |  ;;^DD(.4014,11,23,0)
 | 
|---|
| 104 |  ;;=^^2^2^2930115^
 | 
|---|
| 105 |  ;;^DD(.4014,11,23,1,0)
 | 
|---|
| 106 |  ;;=The QUERY CONDITION code is generated by various calls to FileMan
 | 
|---|
| 107 |  ;;^DD(.4014,11,23,2,0)
 | 
|---|
| 108 |  ;;=routines DIOC*.
 | 
|---|
| 109 |  ;;^DD(.4014,11,"DT")
 | 
|---|
| 110 |  ;;=2930115
 | 
|---|
| 111 |  ;;^DD(.4014,12,0)
 | 
|---|
| 112 |  ;;=DESCRIPTION OF SORT^F^^TXT;E1,200^K:$L(X)>200!($L(X)<1) X
 | 
|---|
| 113 |  ;;^DD(.4014,12,3)
 | 
|---|
| 114 |  ;;=Answer must be 1-200 characters in length.  Text explaining the query condition (field name and what conditions must be met in order for the record to be selected).
 | 
|---|
| 115 |  ;;^DD(.4014,12,21,0)
 | 
|---|
| 116 |  ;;=^^4^4^2930115^
 | 
|---|
| 117 |  ;;^DD(.4014,12,21,1,0)
 | 
|---|
| 118 |  ;;=This field contains a brief textual description of the SORT FIELD and
 | 
|---|
| 119 |  ;;^DD(.4014,12,21,2,0)
 | 
|---|
| 120 |  ;;=the SORT CRITERIA used on it (i.e., the from/to values).  This
 | 
|---|
| 121 |  ;;^DD(.4014,12,21,3,0)
 | 
|---|
| 122 |  ;;=description can be printed in the heading of a report, at the users
 | 
|---|
| 123 |  ;;^DD(.4014,12,21,4,0)
 | 
|---|
| 124 |  ;;=request.
 | 
|---|
| 125 |  ;;^DD(.4014,12,23,0)
 | 
|---|
| 126 |  ;;=^^2^2^2930115^
 | 
|---|
| 127 |  ;;^DD(.4014,12,23,1,0)
 | 
|---|
| 128 |  ;;=This text is build as the developer answers the FROM/TO questions
 | 
|---|
| 129 |  ;;^DD(.4014,12,23,2,0)
 | 
|---|
| 130 |  ;;=during the SORT sequence.
 | 
|---|
| 131 |  ;;^DD(.4014,12,"DT")
 | 
|---|
| 132 |  ;;=2930115
 | 
|---|
| 133 |  ;;^DD(.4014,13,0)
 | 
|---|
| 134 |  ;;=SEARCH EFFICIENCY RATING^NJ9,4^^SER;1^K:+X'=X!(X>9999.9999)!(X<0)!(X?.E1"."5N.N) X
 | 
|---|
| 135 |  ;;^DD(.4014,13,3)
 | 
|---|
| 136 |  ;;=Type a Number between 0 and 9999.9999, 4 Decimal Digits.  Search efficiency number returned by Query Optimizer Routine.
 | 
|---|
| 137 |  ;;^DD(.4014,13,21,0)
 | 
|---|
| 138 |  ;;=^^7^7^2930125^
 | 
|---|
| 139 |  ;;^DD(.4014,13,21,1,0)
 | 
|---|
| 140 |  ;;=Fields are assigned a search efficiency rating based on the number of
 | 
|---|
| 141 |  ;;^DD(.4014,13,21,2,0)
 | 
|---|
| 142 |  ;;=hits found for the query (or sort) condition.  The fewer the hits, the
 | 
|---|
| 143 |  ;;^DD(.4014,13,21,3,0)
 | 
|---|
| 144 |  ;;=higher the rating.  A high rating indicates the criteria will more quickly
 | 
|---|
| 145 |  ;;^DD(.4014,13,21,4,0)
 | 
|---|
| 146 |  ;;=cut down the number of records to be processed.  The rating will be
 | 
|---|
| 147 |  ;;^DD(.4014,13,21,5,0)
 | 
|---|
| 148 |  ;;=higher if the field has a cross-reference.  The field with the highest
 | 
|---|
| 149 |  ;;^DD(.4014,13,21,6,0)
 | 
|---|
| 150 |  ;;=rating is used to do the initial loop through the file during the sort
 | 
|---|
| 151 |  ;;^DD(.4014,13,21,7,0)
 | 
|---|
| 152 |  ;;=phase.
 | 
|---|
| 153 |  ;;^DD(.4014,13,23,0)
 | 
|---|
| 154 |  ;;=^^1^1^2930125^
 | 
|---|
| 155 |  ;;^DD(.4014,13,23,1,0)
 | 
|---|
| 156 |  ;;=Calculated in the Query Optimizer routine ^DIOQ.
 | 
|---|
| 157 |  ;;^DD(.4014,13,"DT")
 | 
|---|
| 158 |  ;;=2930125
 | 
|---|
| 159 |  ;;^DD(.4014,14,0)
 | 
|---|
| 160 |  ;;=PROBABILITY RATING^NJ9,4^^SER;2^K:+X'=X!(X>9999.9999)!(X<0)!(X?.E1"."5N.N) X
 | 
|---|
| 161 |  ;;^DD(.4014,14,3)
 | 
|---|
| 162 |  ;;=Type a Number between 0 and 9999.9999, 4 Decimal Digits.  Probability of field meeting the sort criteria--returned by Query Optimizer routine.
 | 
|---|
| 163 |  ;;^DD(.4014,14,21,0)
 | 
|---|
| 164 |  ;;=^^6^6^2930125^^
 | 
|---|