PRCH OBLIGATED 1358 LIST (860)    SORT TEMPLATE (.401)

Name Value
NAME PRCH OBLIGATED 1358 LIST
DESCRIPTION
This is a new option to support a new FPDS report for the Austin 
Automation Center (AAC).
 
This sort template is used to find purchase orders generated from 1358 
obligations with a dollar value of $0 and higher. The resulting list 
can include vendors and contract information if they were entered when 
the 1358's were created. Users are required to enter a date range for 
this option. It is recommended that the printout be done in landscape 
mode with a right margin of 132 characters.
SORT FIELD DATA
  • FILE OR SUBFILE NO.:   442
    GET CODE:   S DISX(1)=$P($G(^PRC(442,D0,1)),U,15)
    QUERY CONDITION:   I (DISX(1)]]3110614.999999)&(DISX(1)']]3110620.24)
    DESCRIPTION OF SORT:   P.O. DATE from Jun 15,2011 to Jun 20,2011@24:00
    SEARCH EFFICIENCY RATING:   32.6667
    PROBABILITY RATING:   0.9703
    DATA TYPE FOR SORTING:   DATE/TIME
    FIELD NO.:   .1
    FIELD NAME:   P.O. DATE
    SORT QUALIFIERS BEFORE FIELD:   @
    FROM VALUE INTERNAL:   3110614.999999
    FROM VALUE EXTERNAL:   061511
    FROM VALUE PRINTABLE:   Jun 15,2011
    TO VALUE INTERNAL:   3110620.24
    TO VALUE EXTERNAL:   062011@2400
    TO VALUE PRINTABLE:   Jun 20,2011@24:00
    CROSS REFERENCE DATA:   ^PRC(442,"AB",^PRC(442,^2
  • FILE OR SUBFILE NO.:   442
    GET CODE:   S DISX(2)=$P($G(^PRC(442,D0,0)),U)
    QUERY CONDITION:   I DISX(2)'=""
    DESCRIPTION OF SORT:   PURCHASE ORDER NUMBER not null
    SEARCH EFFICIENCY RATING:   0
    PROBABILITY RATING:   0
    DATA TYPE FOR SORTING:   FREE TEXT
    FIELD NO.:   .01
    FIELD NAME:   PURCHASE ORDER NUMBER
    SORT QUALIFIERS BEFORE FIELD:   @
    CROSS REFERENCE DATA:   ^PRC(442,"B",^PRC(442,^2
  • FILE OR SUBFILE NO.:   442
    GET CODE:   S Y(1)=$S($D(^PRC(442,D0,0)):^(0),1:"") S X=$P($G(^PRCD(442.5,+$P(Y(1),U,2),0)),U) I D0>0 S DISX(3)=X
    QUERY CONDITION:   I DISX(3)="1358 OBLIGATION"
    DESCRIPTION OF SORT:   METHOD OF PROCESSING equals 1358 OBLIGATION
    SEARCH EFFICIENCY RATING:   4.9412
    PROBABILITY RATING:   0.8317
    DATA TYPE FOR SORTING:   FREE TEXT
    COMPUTED FIELD CODE:   S Y(1)=$S($D(^PRC(442,D0,0)):^(0),1:"") S X=$P($G(^PRCD(442.5,+$P(Y(1),U,2),0)),U) I D0>0 S DISX(3)=X
    FIELD NAME:   METHOD OF PROCESSING
    SORT QUALIFIERS BEFORE FIELD:   @".02
    FROM VALUE INTERNAL:   1358 OBLIGATIOMz
    FROM VALUE EXTERNAL:   1358 OBLIGATION
    TO VALUE INTERNAL:   1358 OBLIGATION
    TO VALUE EXTERNAL:   1358 OBLIGATION
    CROSS REFERENCE DATA:   ^PRC(442,"F",^PRC(442,^2
    POINT TO CROSS REFERENCE:   ^PRCD(442.5,"B",
DATE CREATED 2011-06-14 15:36:00
READ ACCESS @
FILE PROCUREMENT & ACCOUNTING TRANSACTIONS
WRITE ACCESS @
DATE LAST USED 2011-06-30 00:00:00