ESP MISSING PATIENT REPORT-OPN (526)    SORT TEMPLATE (.401)

This sort template allows VA Police staff to generate a report listing
all Missing Patient Reaction investigations with a Case Status of 'Open'.

• COMPUTED FIELD CODE:   S Y(1)=$S($D(^ESP(912,D0,10,D1,0)):^(0),1:"") S X=$S('$D(^ESP(912.7,+$P(Y(1),U,1),0)):"",1:$P(^(0),U,1)) I D1>0 S X(1)=X
  FROM VALUE INTERNAL:   NOMz
  FROM VALUE EXTERNAL:   NON
  TO VALUE INTERNAL:   NONZ
  TO VALUE EXTERNAL:   NONZ
• COMPUTED FIELD CODE:   S Y(1)=$S($D(^ESP(912,D0,10,D1,0)):^(0),1:"") S X=$S('$D(^ESP(912.8,+$P(Y(1),U,2),0)):"",1:$P(^(0),U,1)) I D1>0 S X(2)=X
  FROM VALUE INTERNAL:   MISSINFz
  FROM VALUE EXTERNAL:   MISSING
  TO VALUE INTERNAL:   MISSINGZ
  TO VALUE EXTERNAL:   MISSINGZ
• COMPUTED FIELD CODE:   S Y(2)=$C(59)_$S($D(^DD(912,5.05,0)):$P(^(0),U,3),1:""),Y(1)=$S($D(^ESP(912,D0,5)):^(5),1:"") S X=$P($P(Y(2),$C(59)_$P(Y(1),U,5)_":",2),$C(59),1)'="REOPENED" I D0>0 S X(3)=X
• COMPUTED FIELD CODE:   S Y(2)=$C(59)_$S($D(^DD(912,.08,0)):$P(^(0),U,3),1:""),Y(1)=$S($D(^ESP(912,D0,0)):^(0),1:"") S X=$P($P(Y(2),$C(59)_$P(Y(1),U,8)_":",2),$C(59),1)="OPEN" I D0>0 S X(4)=X