| NAME |
DSIYTDWO DSIYTECH TODAY STATS |
| TAG |
DSIYTECH |
| ROUTINE |
DSIYTDWO |
| RETURN VALUE TYPE |
GLOBAL ARRAY |
| WORD WRAP ON |
TRUE |
| DESCRIPTION |
DSIYTECH
Returns statistics by technician. This RPC can be easily changed if
different statistics are needed for Work Orders.
As of Build 63, it includes:
Statistics for Work Orders assigned within the last DAYS # of days
Statistics for Work Orders open for more than DAYS # of days
|
| INPUT PARAMETER |
-
- NOREC
- PARAMETER TYPE: LITERAL
- MAXIMUM DATA LENGTH: 4
- REQUIRED: NO
- SEQUENCE NUMBER: 1
- DESCRIPTION:
NOREC
The # of records to return.
-
- SEC
- PARAMETER TYPE: LITERAL
- MAXIMUM DATA LENGTH: 1
- REQUIRED: YES
- SEQUENCE NUMBER: 2
- DESCRIPTION:
SEC
Make sure the correct DAYS parameter is sent to match the statistic you
are trying to return
Which type of data to return?
As of build 63, the available types are:
"A" Work Orders assigned within the last DAYS # of days
"O" Work Orders open for more than DAYS # of days
-
- DAYS
- PARAMETER TYPE: LITERAL
- MAXIMUM DATA LENGTH: 3
- REQUIRED: YES
- SEQUENCE NUMBER: 3
- DESCRIPTION:
DAYS
The number of DAYS to use for the statistic being returned. If the
statistic is not based on days, 0 can be sent.
-
- PMWO
- PARAMETER TYPE: LITERAL
- MAXIMUM DATA LENGTH: 1
- REQUIRED: NO
- SEQUENCE NUMBER: 4
- DESCRIPTION:
PMWO
Whether or not to return Preventive Maintenance Work Orders in this
statistic.
"" Only return non-PM Work Orders
"A" Return all Work Orders
"P" Only return PM Work Orders
-
- SCHED
- PARAMETER TYPE: LITERAL
- MAXIMUM DATA LENGTH: 1
- REQUIRED: NO
- SEQUENCE NUMBER: 5
- DESCRIPTION:
Flag to determine whether to schedule as a report. 1=schedule, 0=do not
schedule, defaults to 0.
-
- ESTART
- PARAMETER TYPE: LITERAL
- MAXIMUM DATA LENGTH: 30
- REQUIRED: NO
- SEQUENCE NUMBER: 6
- DESCRIPTION:
Date/time to start scheduled report.
-
- STATION
- PARAMETER TYPE: LITERAL
- MAXIMUM DATA LENGTH: 12
- REQUIRED: NO
- SEQUENCE NUMBER: 7
- DESCRIPTION:
FILTER BY STATION
|
| RETURN PARAMETER DESCRIPTION |
RETURN PARAMETER
p3: Work Order Number
p4: Task Description
p5: Date Entered
p6: Priority
p7: Location
p8: Equipment IEN
p9: Manufacturer
p10: Model
p11: Shop
p12: Technician Name
p13: Status
p14: User can edit WO 1=yes
p15: PM Status
p16: Date Closed
DSIYRET("TITLE")=$$$^Dataset Title
DSIYRET(1)= "-1^Error Message" for problems
DSIYRET(1)= "0^Warning Message^Technician Name" if nothing returned
technician name is returned for header
DSIYRET(WONUM)=the following pieces:
p1: Work Order IEN
p2: Original Work Order #
|
