PRPF DAYS BETWEEN DATES (614)    SORT TEMPLATE (.401)

This template allows the supervisor/fiscal auditor to examine transactions
which have differing values for the transaction date and the date the
transaction was entered.

• FILE OR SUBFILE NO.:   470.1
  GET CODE:   S DISX(1)=$P($G(^PRPF(470.1,D0,0)),U,6)
  QUERY CONDITION:   I DISX(1)]]2970200.99999
  DESCRIPTION OF SORT:   DATE TRANSACTION ENTERED from 2/1/97
  SEARCH EFFICIENCY RATING:   100.0000
  PROBABILITY RATING:   1.0000
  DATA TYPE FOR SORTING:   DATE/TIME
  FIELD NO.:   5
  FIELD NAME:   DATE TRANSACTION ENTERED
  FROM VALUE INTERNAL:   2970200.99999
  FROM VALUE EXTERNAL:   2 1 97
  FROM VALUE PRINTABLE:   2/1/97
  TO VALUE INTERNAL:   z
  CROSS REFERENCE DATA:   ^PRPF(470.1,"AC",^PRPF(470.1,^2
• FILE OR SUBFILE NO.:   470.1
  GET CODE:   X $P(^DD(470.1,5.5,0),U,5,99) S Y(1)=X S X=Y(1)'=0 I D0>0 S DISX(2)=X
  QUERY CONDITION:   I DISX(2)
  DESCRIPTION OF SORT:   DAYS BETWEEN DATES'=0
  DATA TYPE FOR SORTING:   FREE TEXT
  COMPUTED FIELD CODE:   X $P(^DD(470.1,5.5,0),U,5,99) S Y(1)=X S X=Y(1)'=0 I D0>0 S DISX(2)=X
  FIELD NAME:   DAYS BETWEEN DATES'=0
  SORT QUALIFIERS BEFORE FIELD:   '"@B
  SORT QUALIFIERS AFTER FIELD:   ;L1