| Name |
Type |
Mode |
| @UserID |
int |
IN |
| @Filter |
varchar |
IN |
| @dynField |
varchar |
IN |
| @dynQuery |
varchar |
IN |
| @PatientStatus |
varchar |
IN |
| @LastName |
varchar |
IN |
| @FirstName |
varchar |
IN |
| @BillingTypeID |
varchar |
IN |
| @BirthDateFrom |
varchar |
IN |
| @BirthDateTo |
varchar |
IN |
| @PatientSite |
varchar |
IN |
| @Borough |
varchar |
IN |
| @IFSPDatefixed |
varchar |
IN |
| @ifspdFrom |
varchar |
IN |
| @ifspdTo |
varchar |
IN |
| @AuthStartRangeFrom |
varchar |
IN |
| @AuthStartRangeTo |
varchar |
IN |
| @AuthEndRangeFrom |
varchar |
IN |
| @AuthEndRangeTo |
varchar |
IN |
| @IfspTypeID |
varchar |
IN |
| @UnitOpt |
varchar |
IN |
| @billingunit |
varchar |
IN |
| @AuthTypeID |
varchar |
IN |
| @UsedOpt |
varchar |
IN |
| @Unitused |
varchar |
IN |
| @AuthStatusID |
varchar |
IN |
| @RemainOpt |
varchar |
IN |
| @UnitRemain |
varchar |
IN |
| @Waiver |
varchar |
IN |
| @MinOpt |
varchar |
IN |
| @Minute |
varchar |
IN |
| @location |
varchar |
IN |
| @dayOpt |
varchar |
IN |
| @Day |
varchar |
IN |
| @SUFrom |
varchar |
IN |
| @SUTo |
varchar |
IN |
| @weekOpt |
varchar |
IN |
| @Week |
varchar |
IN |
| @prescripStatus |
varchar |
IN |
| @numOfRefillsFrom |
varchar |
IN |
| @numOfRefillsTo |
varchar |
IN |
| @Route |
varchar |
IN |
| @doseFrom |
varchar |
IN |
| @doseTo |
varchar |
IN |
| @quantityFrom |
varchar |
IN |
| @quantityTo |
varchar |
IN |
| @Refill |
varchar |
IN |
| @frequencyFrom |
varchar |
IN |
| @frequencyTo |
varchar |
IN |
| @daysBtwnRefFrom |
varchar |
IN |
| @daysBtwnRefTo |
varchar |
IN |
| @startdateFixed |
varchar |
IN |
| @startDateFrom |
varchar |
IN |
| @startDateTo |
varchar |
IN |
| @enddateFixed |
varchar |
IN |
| @endDateFrom |
varchar |
IN |
| @endDateTo |
varchar |
IN |
| @prescripType |
varchar |
IN |