MAG REPORT 4 (898)    SORT TEMPLATE (.401)

Name Value
NAME MAG REPORT 4
SORT FIELD DATA
  • FILE OR SUBFILE NO.:   2005
    GET CODE:   S Y(1)=$S($D(^MAG(2005,D0,100)):^(100),1:"") S X=$P($G(^DIC(4,+$P(Y(1),U,3),0)),U) I D0>0 S DISX(1)=X
    QUERY CONDITION:   I (DISX(1)]]"@z")&(DISX(1)']]"ZZZ")
    DESCRIPTION OF SORT:   ACQUISITION SITE from A to ZZZ
    SEARCH EFFICIENCY RATING:   0.0000
    PROBABILITY RATING:   0.0000
    DATA TYPE FOR SORTING:   FREE TEXT
    COMPUTED FIELD CODE:   S Y(1)=$S($D(^MAG(2005,D0,100)):^(100),1:"") S X=$P($G(^DIC(4,+$P(Y(1),U,3),0)),U) I D0>0 S DISX(1)=X
    FIELD NAME:   ACQUISITION SITE
    SORT QUALIFIERS BEFORE FIELD:   +#".05
    FROM VALUE INTERNAL:   @z
    FROM VALUE EXTERNAL:   A
    TO VALUE INTERNAL:   ZZZ
    TO VALUE EXTERNAL:   ZZZ
    CROSS REFERENCE DATA:   ^MAG(2005,"D",^MAG(2005,^2
    POINT TO CROSS REFERENCE:   ^DIC(4,"B",
  • FILE OR SUBFILE NO.:   2005
    GET CODE:   S DISX(2)=$P($G(^MAG(2005,D0,2)),U)
    QUERY CONDITION:   I (DISX(2)]]2600100.999999)&(DISX(2)']]3060606.24)
    DESCRIPTION OF SORT:   DATE/TIME IMAGE SAVED from Jan 1,1960 to Jun 6,2006@24:00
    SEARCH EFFICIENCY RATING:   0.0000
    PROBABILITY RATING:   0.0000
    DATA TYPE FOR SORTING:   DATE/TIME
    FIELD NO.:   7
    FIELD NAME:   DATE/TIME IMAGE SAVED
    SORT QUALIFIERS BEFORE FIELD:   '
    FROM VALUE INTERNAL:   2600100.999999
    FROM VALUE EXTERNAL:   Jan 1,1960
    FROM VALUE PRINTABLE:   Jan 1,1960
    TO VALUE INTERNAL:   3060606.24
    TO VALUE EXTERNAL:   Jun 6,2006@2400
    TO VALUE PRINTABLE:   Jun 6,2006@24:00
  • FILE OR SUBFILE NO.:   2005.01
    GET CODE:   S Y(1)=$S($D(^MAG(2005,D0,5,D1,0)):^(0),1:"") S X=$P($G(^MAG(2005.2,+$P(Y(1),U,1),0)),U) I D1>0 S DISX(3)=X
    QUERY CONDITION:   I DISX(3)']]"ZZZ"
    DESCRIPTION OF SORT:   EXPORT LOCATION to ZZZ (includes nulls)
    DATA TYPE FOR SORTING:   FREE TEXT
    COMPUTED FIELD CODE:   S Y(1)=$S($D(^MAG(2005,D0,5,D1,0)):^(0),1:"") S X=$P($G(^MAG(2005.2,+$P(Y(1),U,1),0)),U) I D1>0 S DISX(3)=X
    MULTIPLE FIELD DATA:
    • MULT.FILE OR SUBFILE NO.:   2005
      NODE:   5
    FIELD NAME:   EXPORT LOCATION
    SORT QUALIFIERS BEFORE FIELD:   ".01
    FROM VALUE INTERNAL:   ?z
    FROM VALUE EXTERNAL:   @
    TO VALUE INTERNAL:   ZZZ
    TO VALUE EXTERNAL:   ZZZ
  • FILE OR SUBFILE NO.:   2005
    GET CODE:   S Y(1)=$S($D(^MAG(2005,D0,40)):^(40),1:"") S X=$P($G(^MAG(2005.83,+$P(Y(1),U,3),0)),U) I D0>0 S DISX(4)=X
    QUERY CONDITION:   I (DISX(4)]]"MEANRz")&(DISX(4)']]"MEANSZ")
    DESCRIPTION OF SORT:   TYPE INDEX from MEANS to MEANSZ
    DATA TYPE FOR SORTING:   FREE TEXT
    COMPUTED FIELD CODE:   S Y(1)=$S($D(^MAG(2005,D0,40)):^(40),1:"") S X=$P($G(^MAG(2005.83,+$P(Y(1),U,3),0)),U) I D0>0 S DISX(4)=X
    FIELD NAME:   TYPE INDEX
    SORT QUALIFIERS BEFORE FIELD:   +"42
    FROM VALUE INTERNAL:   MEANRz
    FROM VALUE EXTERNAL:   MEANS
    TO VALUE INTERNAL:   MEANSZ
    TO VALUE EXTERNAL:   MEANSZ
DATE CREATED 2006-11-21 08:12:00
READ ACCESS @
FILE IMAGE
WRITE ACCESS @
DATE LAST USED 2006-11-28 00:00:00