| TITLE | VALUE | |
|---|---|---|
| NAME | DSIYUTL EQSCH EQUIP SEARCH | |
| DESCRIPTION | Searches the EQUIPMENT INV. (#6914) file by requested field. | |
| TAG | EQSCH | |
| ROUTINE | DSIYUTL | |
| INPUT PARAMETERS | SEQUENCE NUMBER | 1 |
| INPUT PARAMETER | TERM | |
| DESCRIPTION | What to search for | |
| PARAMETER TYPE | LITERAL | |
| REQUIRED | NO | |
| MAXIMUM DATA LENGTH | 30 | |
| INPUT PARAMETERS | SEQUENCE NUMBER | 2 |
| INPUT PARAMETER | SCHBY | |
| DESCRIPTION | BY 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 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. | |
| PARAMETER TYPE | LITERAL | |
| REQUIRED | YES | |
| MAXIMUM DATA LENGTH | 5 | |
| INPUT PARAMETERS | SEQUENCE NUMBER | 3 |
| INPUT PARAMETER | USE | |
| DESCRIPTION | USE 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 string (USE="") When calling this from the turn-in screen, use "^1^2^3^5^" to indicate all use statuses EXCEPT for "TURNED-IN" | |
| PARAMETER TYPE | LITERAL | |
| REQUIRED | NO | |
| MAXIMUM DATA LENGTH | 20 | |
| INPUT PARAMETERS | SEQUENCE NUMBER | 4 |
| INPUT PARAMETER | NOREC | |
| DESCRIPTION | NOREC The number of records to return Not Required If not entered, All matching records will be returned | |
| PARAMETER TYPE | LITERAL | |
| REQUIRED | NO | |
| MAXIMUM DATA LENGTH | 4 | |
| INPUT PARAMETERS | SEQUENCE NUMBER | 5 |
| INPUT PARAMETER | SCHTXT | |
| DESCRIPTION | SCHTXT Finds the TERM anywhere within the string for specific searches. Slower search as Xref's can't be used | |
| PARAMETER TYPE | LITERAL | |
| REQUIRED | NO | |
| MAXIMUM DATA LENGTH | 1 | |
| INPUT PARAMETERS | SEQUENCE NUMBER | 6 |
| INPUT PARAMETER | DSIYNEXT | |
| DESCRIPTION | TYPE OF EQ - 'NX' NON-EXPENDABLE EQ;'BSE' BUILDING SERVICE EQ;'EXP' FOR 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 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. | |
| PARAMETER TYPE | LITERAL | |
| REQUIRED | NO | |
| MAXIMUM DATA LENGTH | 45 | |
| RETURN VALUE TYPE | GLOBAL ARRAY | |
| RETURN PARAMETER DESCRIPTION | Returns a list of search results in format: DSIYRET(1)="-1^Error Message" for errors DSIYRET(1)="0^Warning Message" for warnings DSIYRET(IEN)= P1=IEN P2=MANUFACTURER P3=ITEM NAME 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 | |
| AVAILABILITY | ||
| INACTIVE | ||
| CLIENT MANAGER | ||
| WORD WRAP ON | TRUE | |
| VERSION | ||
| SUPPRESS RDV USER SETUP | ||
| APP PROXY ALLOWED | ||