DSIYUTL EQSCH EQUIP SEARCH (3837)    REMOTE PROCEDURE (8994)

Name Value
NAME DSIYUTL EQSCH EQUIP SEARCH
TAG EQSCH
ROUTINE DSIYUTL
RETURN VALUE TYPE GLOBAL ARRAY
WORD WRAP ON TRUE
DESCRIPTION
Searches the EQUIPMENT INV. (#6914) file by requested field.
INPUT PARAMETER
  • TERM
    PARAMETER TYPE:   LITERAL
    MAXIMUM DATA LENGTH:   30
    REQUIRED:   NO
    SEQUENCE NUMBER:   1
    DESCRIPTION:   
    What to search for
    
  • SCHBY
    PARAMETER TYPE:   LITERAL
    MAXIMUM DATA LENGTH:   5
    REQUIRED:   YES
    SEQUENCE NUMBER:   2
    DESCRIPTION:   
    BY
    MO:     Search by Model (XREF "EC")
    SN:     Search by Serial # (XREF FC")
    EC:     Search by Equipment Category (XREF "G") - Allows Full Field Search
    LO:     Search by Location (XREF "D") - Allows Full Field Search
    LI:     Search by Local Identifier (XREF "L")
    AV:     Search by Asset Value - NOTE - this search is not included in the
                    By "ALL" functionality
    AD:     Search by CMR/EIL (Xref "AD") - allows full field search, included
                    in search by "ALL" functionality
    PO:     Search by PO# (Xref "M") - allows full field search, included in
     
                    search by "ALL" functionality
    RD:     Search by Replacement Date no xref
    AR:     Search by EQ type - xref "AR"
    PI:     Search by Inventory Date - no xref
    CSN:    Search by Category Stock # - Xref "J" 
    ALL:    Search by all above except for "AV"
     
    When calling this from the Turn-In screen, use "", or "ALL" to search all 
    fields.
    Allows searching by the following fields:
     
    EN:     Search by Equipment ID (XREF "B")
    MA:     Search by Manufacturer (XREF "K") - Allows Full Field Search
    MF:     Search by Manufacturer's Equipment Name (XREF "H")
                    This is the default search if nothing supplied
                    Allows Full Field Search
    
  • USE
    PARAMETER TYPE:   LITERAL
    MAXIMUM DATA LENGTH:   20
    REQUIRED:   NO
    SEQUENCE NUMBER:   3
    DESCRIPTION:   
    USE
    string (USE="")
     
    When calling this from the turn-in screen, use "^1^2^3^5^" to indicate 
    all use statuses EXCEPT for "TURNED-IN"
    Use Status for this piece of equipment - SET included in the DD entry
    for 6914,20 field in Equipment Management File
    Required
     
    Multiple USE criteria can be sent - they should be started,separated and 
    ended with "^" - i.e., "^1^4^5^"
     
    If the user does not select any USE statuses, continue to send a null 
    
  • NOREC
    PARAMETER TYPE:   LITERAL
    MAXIMUM DATA LENGTH:   4
    REQUIRED:   NO
    SEQUENCE NUMBER:   4
    DESCRIPTION:   
    NOREC
     
    The number of records to return
    Not Required
    If not entered, All matching records will be returned
    
  • SCHTXT
    PARAMETER TYPE:   LITERAL
    MAXIMUM DATA LENGTH:   1
    REQUIRED:   NO
    SEQUENCE NUMBER:   5
    DESCRIPTION:   
    SCHTXT
     
    Finds the TERM anywhere within the string for specific searches.  Slower 
    search as Xref's can't be used
    
  • TIFLAG
    PARAMETER TYPE:   LITERAL
    MAXIMUM DATA LENGTH:   10
    REQUIRED:   NO
    SEQUENCE NUMBER:   6
    DESCRIPTION:   
    TIFLAG
    a turn-in requst - all equipment in the same turn-in request need to hbe 
    for the same CMR.
     
    Indicates whether this search is coming from the Turn-In Screen.  If it 
    does come from Turn-In, all CMR's have to match.
     
    The appropriate values for this field are:
    "*" Indicates that this is a new turn-in request - first piece of 
    equipment
    CMR IEN = send the CMR IEN if this is a subsequent piece of equipment for 
    
  • DSIYNEXT
    PARAMETER TYPE:   LITERAL
    MAXIMUM DATA LENGTH:   45
    REQUIRED:   NO
    SEQUENCE NUMBER:   6
    DESCRIPTION:   
    TYPE OF EQ - 'NX' NON-EXPENDABLE EQ;'BSE' BUILDING SERVICE EQ;'EXP' FOR 
     
    If the user indicates they want to move down through the data - send
    1^the last IEN from the last search
     
    If the user indicates they want to move up through the data - send
    -1^the first IEN from the last search
     
    All other parameters (TERM, BY, USE, NOREC, SCHTXT) need to be sent 
    exactly as they were for the original search in this session.
    EXPENDABLE EQ;'ALL' FOR ALL
    This parameter is only used when the user is asking for more data for a 
    search (pressing pageup/pagedown at the end of the data, etc.)  This will 
    allow the RPC to grab the next set of data to display to the user.
     
    Format is:
     
    MOVE^FIRST/LAST IEN
    
RETURN PARAMETER DESCRIPTION
Returns a list of search results in format:
   P4=MODEL
   P5=SERIAL
   P6=STATUS
   P7=PO#
   P8=EQUIPMENT CATEGORY
   P9=CMR
   P10=ACQUISITION DATE
   P11=TOTAL ASSET VALUE
   P12=LOCATION
   P13=PREV LOC
 
   P14=OWNER/DEPT
   P15=LAST INV DATE
   P16=REPLACEMENT DATE
   P17=WARRANTY END DATE
   P18=ENTERED BY
   P19=DATE ENTERED
DSIYRET(1)="-1^Error Message" for errors
DSIYRET(1)="0^Warning Message" for warnings
 
DSIYRET(IEN)=
   P1=IEN
   P2=MANUFACTURER
   P3=ITEM NAME