ESP CASE BY DIVISION (710)    SORT TEMPLATE (.401)

Name Value
NAME ESP CASE BY DIVISION
SORT FIELD DATA
  • FILE OR SUBFILE NO.:   912
    GET CODE:   S Y(1)=$S($D(^ESP(912,D0,0)):^(0),1:"") S X=$S('$D(^DG(40.8,+$P(Y(1),U,7),0)):"",1:$P(^(0),U,1)) I D0>0 S DISX(1)=X
    QUERY CONDITION:   I DISX(1)'=""
    DESCRIPTION OF SORT:   FACILITY not null
    DATA TYPE FOR SORTING:   FREE TEXT
    COMPUTED FIELD CODE:   S Y(1)=$S($D(^ESP(912,D0,0)):^(0),1:"") S X=$S('$D(^DG(40.8,+$P(Y(1),U,7),0)):"",1:$P(^(0),U,1)) I D0>0 S DISX(1)=X
    FIELD NAME:   FACILITY
    SORT QUALIFIERS BEFORE FIELD:   ".07
  • FILE OR SUBFILE NO.:   912
    GET CODE:   S DISX(2)=$P($G(^ESP(912,D0,0)),U,3)
    QUERY CONDITION:   I DISX(2)'=""
    DESCRIPTION OF SORT:   DATE/TIME OF OFFENSE not null
    SEARCH EFFICIENCY RATING:   0.1818
    PROBABILITY RATING:   0.1818
    DATA TYPE FOR SORTING:   DATE/TIME
    FIELD NO.:   .03
    FIELD NAME:   DATE/TIME OF OFFENSE
DATE CREATED 1999-07-22 08:56:00
READ ACCESS @
FILE ESP OFFENSE REPORT
WRITE ACCESS @
DATE LAST USED 2000-03-07 00:00:00