XU-CLINICAL TRAINEE TRANSB (845)    SORT TEMPLATE (.401)

Name Value
NAME XU-CLINICAL TRAINEE TRANSB
SORT FIELD DATA
  • FILE OR SUBFILE NO.:   200
    GET CODE:   S DISX(1)=$P($G(^VA(200,D0,12)),U,5)
    QUERY CONDITION:   I (DISX(1)]]3040805.999999)&(DISX(1)']]3050707.24)
    DESCRIPTION OF SORT:   DATE TRANSMITTED TO OAA from Aug 6,2004 to Jul 7,2005@24:00
    SEARCH EFFICIENCY RATING:   24.2500
    PROBABILITY RATING:   0.9604
    DATA TYPE FOR SORTING:   DATE/TIME
    FIELD NO.:   12.5
    FIELD NAME:   DATE TRANSMITTED TO OAA
    SORT QUALIFIERS BEFORE FIELD:   +
    SORT QUALIFIERS AFTER FIELD:   ;S1
    FROM VALUE INTERNAL:   3040805.999999
    FROM VALUE EXTERNAL:   T-360
    FROM VALUE PRINTABLE:   Aug 6,2004
    TO VALUE INTERNAL:   3050707.24
    TO VALUE EXTERNAL:   Jul 7,2005@2400
    TO VALUE PRINTABLE:   Jul 7,2005@24:00
    CROSS REFERENCE DATA:   ^VA(200,"AOAA",^VA(200,^2
  • 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(2)=X
    QUERY CONDITION:   I DISX(2)="SAN FRANCISCO"
    DESCRIPTION OF SORT:   VHA TRAINING FACILITY equals SAN FRANCISCO
    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(2)=X
    FIELD NAME:   VHA TRAINING FACILITY
    SORT QUALIFIERS BEFORE FIELD:   +"12.4
    SORT QUALIFIERS AFTER FIELD:   ;S1
    FROM VALUE INTERNAL:   SAN FRANCISCNz
    FROM VALUE EXTERNAL:   SAN FRANCISCO
    TO VALUE INTERNAL:   SAN FRANCISCO
    TO VALUE EXTERNAL:   SAN FRANCISCO
  • FILE OR SUBFILE NO.:   200
    GET CODE:   S DISX(3)=$P($G(^VA(200,D0,0)),U)
    QUERY CONDITION:   I DISX(3)'=""
    DESCRIPTION OF SORT:   NAME not null
    SEARCH EFFICIENCY RATING:   0
    PROBABILITY RATING:   0
    DATA TYPE FOR SORTING:   FREE TEXT
    FIELD NO.:   .01
    FIELD NAME:   NAME
    CROSS REFERENCE DATA:   ^VA(200,"B",^VA(200,^2
DATE CREATED 2004-09-01 06:15:00
READ ACCESS @
FILE NEW PERSON
WRITE ACCESS @
DATE LAST USED 2005-08-01 00:00:00