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