SCMCTP (912)    SORT TEMPLATE (.401)

Template to screen TEAM PURPOSE field, entry OIF OEF.

• FILE OR SUBFILE NO.:   404.51
  GET CODE:   S DISX(1)=$P($G(^SCTM(404.51,D0,0)),U)
  QUERY CONDITION:   I (DISX(1)]]"AAA@z")&(DISX(1)']]"ZZZZZZZZ")
  DESCRIPTION OF SORT:   NAME from AAAA to ZZZZZZZZ
  SEARCH EFFICIENCY RATING:   0.0638
  PROBABILITY RATING:   0.0600
  DATA TYPE FOR SORTING:   FREE TEXT
  FIELD NO.:   .01
  FIELD NAME:   NAME
  FROM VALUE INTERNAL:   AAA@z
  FROM VALUE EXTERNAL:   AAAA
  TO VALUE INTERNAL:   ZZZZZZZZ
  TO VALUE EXTERNAL:   ZZZZZZZZ
  CROSS REFERENCE DATA:   ^SCTM(404.51,"B",^SCTM(404.51,^2
• FILE OR SUBFILE NO.:   404.51
  GET CODE:   S Y(1)=$S($D(^SCTM(404.51,D0,0)):^(0),1:"") S X=$P($G(^SD(403.47,+$P(Y(1),U,3),0)),U) I D0>0 S DISX(2)=X
  QUERY CONDITION:   I (DISX(2)]]"OIF OEEz")&(DISX(2)']]"OIF OEFZZZ")
  DESCRIPTION OF SORT:   TEAM PURPOSE from OIF OEF to OIF OEFZZZ
  DATA TYPE FOR SORTING:   FREE TEXT
  COMPUTED FIELD CODE:   S Y(1)=$S($D(^SCTM(404.51,D0,0)):^(0),1:"") S X=$P($G(^SD(403.47,+$P(Y(1),U,3),0)),U) I D0>0 S DISX(2)=X
  FIELD NAME:   TEAM PURPOSE
  SORT QUALIFIERS BEFORE FIELD:   ".03
  FROM VALUE INTERNAL:   OIF OEEz
  FROM VALUE EXTERNAL:   OIF OEF
  TO VALUE INTERNAL:   OIF OEFZZZ
  TO VALUE EXTERNAL:   OIF OEFZZZ