Report_PlanAuthDetails_sp


Parameters

Name Type Mode
@UserID int IN
@Filter varchar IN
@sortBy varchar IN
@page int IN
@RecsPerPage int IN
@ChildStatus varchar IN
@IDvalue varchar IN
@LastName varchar IN
@FirstName varchar IN
@BirthDateFrom varchar IN
@BirthDateTo varchar IN
@ProgramID varchar IN
@CaseStatusID varchar IN
@BirthDateCondition varchar IN
@PatientSite varchar IN
@Borough varchar IN
@Site varchar IN
@authDtRgFrom varchar IN
@authDtRgTo varchar IN
@Modifierid varchar IN
@ServiceTypeID varchar IN
@Procedureid varchar IN
@ifspdateFixed varchar IN
@ifspdFrom varchar IN
@ifspdTo varchar IN
@IfspTypeID varchar IN
@UnitOpt varchar IN
@billingunit varchar IN
@AuthTypeID varchar IN
@UsedOpt varchar IN
@Unitused varchar IN
@AuthStatusID varchar IN
@IfspStatusID 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
@ProAssigned varchar IN
@AssignStatus varchar IN
@Cat varchar IN
@SubCat varchar IN
@dateTimeSheet varchar IN
@Comments varchar IN
@AuthStartRangeFrom varchar IN
@AuthStartRangeTo varchar IN
@AuthEndRangeFrom varchar IN
@AuthEndRangeTo varchar IN
@AuthServiceDateRangeFrom varchar IN
@AuthServiceDateRangeTo varchar IN
@ProviderRateCondition varchar IN
@ProviderRate int IN
@rateTypeID varchar IN
@groupingID varchar IN
@PaysourceID varchar IN
@admissionDateFrom varchar IN
@admissionDateTo varchar IN
@dischargedDateFrom varchar IN
@dischargedDateTo varchar IN
@declinedDateFrom varchar IN
@declinedDateTo varchar IN
@agingOutDateFrom varchar IN
@agingOutDateTo varchar IN
@admissionDate varchar IN
@declinedDate varchar IN
@agingOutDate varchar IN
@dischargedDate varchar IN
@DischargedReasons varchar IN
@dofaCondition varchar IN
@dofaDateQuery varchar IN
@dofaFrom varchar IN
@dofaTo varchar IN
@UserSite varchar IN
@UserProgram varchar IN
@UserStatus varchar IN
@PDistrict varchar IN
@CaseSite varchar IN
@AuthPANum varchar IN
@AuthPACondition varchar IN
@Unmatched varchar IN
@referralFirstName varchar IN
@referralLastName varchar IN
@referralReasons varchar IN
@fosterCare varchar IN
@referralDate varchar IN
@referralDateFrom varchar IN
@referralDateTo varchar IN
@DOHReferralDate varchar IN
@DOHReferralDateFrom varchar IN
@DOHReferralDateTo varchar IN
@SPlanDate varchar IN
@SPlanDateFrom varchar IN
@SPlanDateTo varchar IN
@DeclinedReasons varchar IN
@ReferralSources1 varchar IN
@ReferralSources2 varchar IN
@debug varchar IN
@GenericTreeLoad varchar IN
@FieldsToDisplay varchar IN
@FieldsToGroup varchar IN
@OrderByFields varchar IN
@UserCalculationConfig varchar IN
@AdminCalculationConfig varchar IN
@PublishedUserCalculationConfig varchar IN
@PublishedAdminCalculationConfig varchar IN
@KeyId int IN
@Order varchar IN
@pkID int IN
@pkName varchar IN
@GridFilter varchar IN
@ScheduleVisit varchar IN
@ClaimType varchar IN
@IsGetTherapistRoleAndRate varchar IN
@MissingPrescription varchar IN
@Market varchar IN
@BillingApp int IN

Definition