XU-CLINICAL INACTIVE TRAINEE (848)    SORT TEMPLATE (.401)

Name Value
NAME XU-CLINICAL INACTIVE TRAINEE
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:   S DISX(2)=$P($G(^VA(200,D0,12)),U,6)
    QUERY CONDITION:   I DISX(2)="N"
    DESCRIPTION OF SORT:   CLINICAL CORE TRAINEE equals N (NO)
    SEARCH EFFICIENCY RATING:   0.9703
    PROBABILITY RATING:   0.9703
    DATA TYPE FOR SORTING:   SET OF CODES
    FIELD NO.:   12.6
    FIELD NAME:   CLINICAL CORE TRAINEE
    SORT QUALIFIERS AFTER FIELD:   ;"ACTIVE TRAINEE?: "
    FROM VALUE INTERNAL:   Mz
    FROM VALUE EXTERNAL:   NO
    FROM VALUE PRINTABLE:   N (NO)
    TO VALUE INTERNAL:   N
    TO VALUE EXTERNAL:   NO
    TO VALUE PRINTABLE:   N (NO)
  • 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:08:00
READ ACCESS @
FILE NEW PERSON
WRITE ACCESS @
DATE LAST USED 2005-08-01 00:00:00