XU-CLINICAL TRAINEE LIST (847)    SORT TEMPLATE (.401)

Name Value
NAME XU-CLINICAL TRAINEE LIST
SORT FIELD DATA
  • FILE OR SUBFILE NO.:   200
    GET CODE:   S Y(1)=$S($D(^VA(200,D0,12)):^(12),1:"") S X=$P($G(^USC(8932.2,+$P(Y(1),U,2),0)),U)'="" I D0>0 S DISX(1)=X
    QUERY CONDITION:   I (DISX(1)]]0)&(DISX(1)']]1)
    DESCRIPTION OF SORT:   (#12.2)'=""""
    DATA TYPE FOR SORTING:   FREE TEXT
    COMPUTED FIELD CODE:   S Y(1)=$S($D(^VA(200,D0,12)):^(12),1:"") S X=$P($G(^USC(8932.2,+$P(Y(1),U,2),0)),U)'="" I D0>0 S DISX(1)=X
    FIELD NAME:   (#12.2)'=""
    SORT QUALIFIERS BEFORE FIELD:   @"B
    SORT QUALIFIERS AFTER FIELD:   ;L1
  • FILE OR SUBFILE NO.:   200
    GET CODE:   X DPP(2,"OVF0",9.3) S X=X="NO",Y(7)=$G(X) S X="NO",Y(8)=$G(X) S X=1,Y(9)=$G(X) S X="YES",X=$S(Y(3):Y(4),Y(7):Y(8),Y(9):X) I D0>0 S DISX(2)=X
    QUERY CONDITION:   I DISX(2)'=""
    DESCRIPTION OF SORT:   $S((#12.6)=""YES"":""YES"",(#12.6)=""NO"":""NO"",1:""YES"") not null
    DATA TYPE FOR SORTING:   FREE TEXT
    COMPUTED FIELD CODE:   X DPP(2,"OVF0",9.3) S X=X="NO",Y(7)=$G(X) S X="NO",Y(8)=$G(X) S X=1,Y(9)=$G(X) S X="YES",X=$S(Y(3):Y(4),Y(7):Y(8),Y(9):X) I D0>0 S DISX(2)=X
    OVERFLOW DATA:
    • FIRST SUBSCRIPT FOR OVERFLOW:   OVF0
      SECOND SUBSCRIPT FOR OVERFLOW:   9.2
      OVERFLOW CODE:   S Y(2)=$C(59)_$P($G(^DD(200,12.6,0)),U,3),Y(6)=$C(59)_$P($G(^DD(200,12.6,0)),U,3),Y(1)=$S($D(^VA(200,D0,12)):^(12),1:"")
    • FIRST SUBSCRIPT FOR OVERFLOW:   OVF0
      SECOND SUBSCRIPT FOR OVERFLOW:   9.3
      OVERFLOW CODE:   X DPP(2,"OVF0",9.2) S X=$P($P(Y(2),$C(59)_$P(Y(1),U,6)_":",2),$C(59))="YES",Y(3)=$G(X) S X="YES",Y(4)=$G(X),Y(5)=$G(X) S X=$P($P(Y(6),$C(59)_$P(Y(1),U,6)_":",2),$C(59))
    FIELD NAME:   $S((#12.6)="YES":"YES",(#12.6)="NO":"NO",1:"YES")
    SORT QUALIFIERS BEFORE FIELD:   "
    SORT QUALIFIERS AFTER FIELD:   ;"TRAINEE?: ";S1
  • FILE OR SUBFILE NO.:   200
    GET CODE:   S Y(1)=$S($D(^VA(200,D0,12)):^(12),1:"") S X=$P($G(^DIC(4,+$P(Y(1),U,4),0)),U) I D0>0 S DISX(3)=X
    QUERY CONDITION:   I DISX(3)'=""
    DESCRIPTION OF SORT:   VHA TRAINING FACILITY not null
    DATA TYPE FOR SORTING:   FREE TEXT
    COMPUTED FIELD CODE:   S Y(1)=$S($D(^VA(200,D0,12)):^(12),1:"") S X=$P($G(^DIC(4,+$P(Y(1),U,4),0)),U) I D0>0 S DISX(3)=X
    FIELD NAME:   VHA TRAINING FACILITY
    SORT QUALIFIERS BEFORE FIELD:   "12.4
    SORT QUALIFIERS AFTER FIELD:   ;"TRAINING FACILITY: "
DATE CREATED 2005-03-21 08:16:00
READ ACCESS @
FILE NEW PERSON
WRITE ACCESS @
DATE LAST USED 2005-08-01 00:00:00