Routines

Routines

Name	Type	Language	Deterministic	Return Type	Security Restriction	Comments
GetAuthWithoutAssignmentsFromLatestPlan_sp	PROCEDURE	SQL	false
Report_IFSP_ForFormattedReport_sp_ServiceSummary	PROCEDURE	SQL	false
Report_Invoice_sp	PROCEDURE	SQL	false
getOverlapClaimInfo	FUNCTION	SQL	false	varchar
DeleteSignature_sp	PROCEDURE	SQL	false
GetSignaturesByFormSubmissonId_sp	PROCEDURE	SQL	false
UpdateAllDueDatesWithLinkToId_sp	PROCEDURE	SQL	false
Report_getCheckLists_Paging_sp	PROCEDURE	SQL	false
AddUpdateClassroom_sp	PROCEDURE	SQL	false
Report_AssignmentsWithServiceDateInfo_sp	PROCEDURE	SQL	false
AddAttendaceForAllEnrollments_sp	PROCEDURE	SQL	false
Report_BatchInvoices_sp	PROCEDURE	SQL	false
getOverlappingClaims_sp	PROCEDURE	SQL	false
Report_EvaluationConfirmation_sp	PROCEDURE	SQL	false
GetArticleTicketApps_sp	PROCEDURE	SQL	false
ReportClaimPayrollList_sp_NEW	PROCEDURE	SQL	false
CheckValidIp_fn	FUNCTION	SQL	false	bit
Report_Packages_sp	PROCEDURE	SQL	false
GetAlertsToRefresh_sp	PROCEDURE	SQL	false
Report_getCheckLists_New_sp	PROCEDURE	SQL	false
VoteTicket_sp	PROCEDURE	SQL	false
UpdatAllDueDates_sp	PROCEDURE	SQL	false
getClaimIds_From_ClaimsReport	PROCEDURE	SQL	false
check_ics78_fn	FUNCTION	SQL	false	varchar
Report_PatientProvPlanReview_ForReport_sp	PROCEDURE	SQL	false
Report_getTickets_sp	PROCEDURE	SQL	false
getServiceTypes_sp	PROCEDURE	SQL	false
ChangeStatusCheckList_sp	PROCEDURE	SQL	false
Report_AuthWithFirstVisit_sp	PROCEDURE	SQL	false
SaveTicketFollowers_sp	PROCEDURE	SQL	false
sp_renamediagram	PROCEDURE	SQL	false
getProgramTypes	PROCEDURE	SQL	false
CloneOutcomesAndObjectives_sp	PROCEDURE	SQL	false
UpdateAlertCalculation_sp	PROCEDURE	SQL	false
GetWorkDayDifference_fn	FUNCTION	SQL	false	int
UpdateAuthNumberForSCclaims_sp	PROCEDURE	SQL	false
AddUpdateTutionAttendanceCodes_sp	PROCEDURE	SQL	false
Report_SCSubclaimsForFormattedReport_sp_GroupByProvider	PROCEDURE	SQL	false
GetClaimSummaryByClaimId_sp	PROCEDURE	SQL	false
GetAlertSummaries_sp	PROCEDURE	SQL	false
Report_DeletedBilling_sp	PROCEDURE	SQL	false
GetCaseAssignmentsByProviderId_sp	PROCEDURE	SQL	false
IsDeletedClaim	FUNCTION	SQL	false	bit
CheckBatchErrorsByCPID_sp	PROCEDURE	SQL	false
Report_CaseNotes_sp	PROCEDURE	SQL	false
Report_Comments_sp	PROCEDURE	SQL	false
GetFormConnectionInfoByEntryId_fn	FUNCTION	SQL	false	nvarchar
Report_AppAndFeature_sp	PROCEDURE	SQL	false
AddPaymentTransaction_sp	PROCEDURE	SQL	false
CheckAttendance_sp	PROCEDURE	SQL	false
Report_SCSubclaimsForFormattedReport_sp_Patients	PROCEDURE	SQL	false
Report_Attendance_sp	PROCEDURE	SQL	false
GetProvidersByRoles_sp	PROCEDURE	SQL	false
Report_EiEscrow_sp	PROCEDURE	SQL	false
GetUnAppliedClaims_sp	PROCEDURE	SQL	false
getClaimSearchList_ByApp_sp	PROCEDURE	SQL	false
AddTicketCommentAndUpdateTicket_sp	PROCEDURE	SQL	false
getFinancialTransactionsForFormattedReport_sp	PROCEDURE	SQL	false
Report_CaseDiagnosis_sp	PROCEDURE	SQL	false
Report_DeletedInvoice_sp	PROCEDURE	SQL	false
InsertAuthorizationAssignment_sp	PROCEDURE	SQL	false
getBatchInvoiceSCClaimsEiHub_sp	PROCEDURE	SQL	false
Report_GenerateTransactions_sp	PROCEDURE	SQL	false
getClaimSearchList_RowNum_NoTemp_sp_for_Dashboard	PROCEDURE	SQL	false
sp_alterdiagram	PROCEDURE	SQL	false
GetAuthorizationAssignment_sp	PROCEDURE	SQL	false
GetLayersByType_sp	PROCEDURE	SQL	false
Report_TotalActivity_sp	PROCEDURE	SQL	false
HandleDraftFormFileAfterSavingVisit_sp	PROCEDURE	SQL	false
Report_PatientEvaluation_sp	PROCEDURE	SQL	false
UpdateAllDueDates_sp	PROCEDURE	SQL	false
Report_AssignmentListing_sp	PROCEDURE	SQL	false
Report_SCSubclaimsForFormattedReport__sp_GroupBySite	PROCEDURE	SQL	false
getReportsTemplate_sp	PROCEDURE	SQL	false
Dashboard_getClaimSearchList_RowNum_NoTemp_sp	PROCEDURE	SQL	false
getOPRAEiHub_fn	FUNCTION	SQL	false	varchar
AddAndRemoveFavoriteFeature_sp	PROCEDURE	SQL	false
getBatchPatientsNyEihub_sp	PROCEDURE	SQL	false
getBillingUnit_fn	FUNCTION	SQL	false	int
GetCheckLogsByPaySourceClaim	PROCEDURE	SQL	false
AddUpdateTuitionTransaction_sp	PROCEDURE	SQL	false
Report_Patients_sp	PROCEDURE	SQL	false
AddUpdateTransactionCategory_sp	PROCEDURE	SQL	false
Report_ProviderCaseLoad_sp	PROCEDURE	SQL	false
GetKeyValueFromCriteria	FUNCTION	SQL	false	varchar
check_ics77_fn	FUNCTION	SQL	false	varchar
getCheckListsCount_sp	PROCEDURE	SQL	false
Report_Cases_w_CustomFields_sp	PROCEDURE	SQL	false
RefreshAndGetAlertCount_sp	PROCEDURE	SQL	false
GetPlacements_sp	PROCEDURE	SQL	false
AddUpdateModiferServiceSetting_sp	PROCEDURE	SQL	false
userRoles	FUNCTION	SQL	false	varchar
sp_creatediagram	PROCEDURE	SQL	false
LogUserActivity_sp	PROCEDURE	SQL	false
Report_ProviderSignature_sp	PROCEDURE	SQL	false
getStickyNotes	PROCEDURE	SQL	false
getClaimICD9CodesExcludeDes	FUNCTION	SQL	false	varchar
check_ics83_fn	FUNCTION	SQL	false	varchar
UpdateCalculation_sp	PROCEDURE	SQL	false
Report_835Import_sp	PROCEDURE	SQL	false
check_ics76_fn	FUNCTION	SQL	false	varchar
GetDuplicateClaimInfoIcs6_sp	PROCEDURE	SQL	false
getAlertCount_sp	PROCEDURE	SQL	false
GetChargeTransactionByInvoice_sp	PROCEDURE	SQL	false
Report_DaycareEnrollment_sp	PROCEDURE	SQL	false
GetDataTakeActionClaim_sp	PROCEDURE	SQL	false
Report_Custom_DataSource_sp	PROCEDURE	SQL	false
splitstring	FUNCTION	SQL	false	TABLE
SignSignature_sp	PROCEDURE	SQL	false
CalcDueDate_fn	FUNCTION	SQL	false	datetime
Report_SCSubclaims_sp_ForFormattedReport_sp_Claims	PROCEDURE	SQL	false
Report_UserWithTrackingFields_sp	PROCEDURE	SQL	false
GetTicketFolder	PROCEDURE	SQL	false
getClaimICD9FullNames	FUNCTION	SQL	false	varchar
addDeletedHistory_sp	PROCEDURE	SQL	false
GetAuthorizationAssignmentsByAuthId_sp	PROCEDURE	SQL	false
getClaimCPTExcludeCodeDes	FUNCTION	SQL	false	varchar
GetAttendance_sp	PROCEDURE	SQL	false
getClaimCPTFullNames	FUNCTION	SQL	false	varchar
Action_18_sp	PROCEDURE	SQL	false
GetActiveUsersForTicketFollow_sp	PROCEDURE	SQL	false
UnVoteTicket_sp	PROCEDURE	SQL	false
GetFormSubmissionsByEntryIdAndLocation_sp	PROCEDURE	SQL	false
DueDateCalculation_sp	PROCEDURE	SQL	false
AddAttendance_sp	PROCEDURE	SQL	false
Report_PlanAuth_w_CaseCustomFields	PROCEDURE	SQL	false
splitStringByCharacter_fn	FUNCTION	SQL	false	TABLE
GetEvalAuthorizations_sp	PROCEDURE	SQL	false
Report_AuthPrescriptions_sp	PROCEDURE	SQL	false
GetDuplicateClaimInfoIcs77_sp	PROCEDURE	SQL	false
getStickyNotes_sp	PROCEDURE	SQL	false
Report_CaseListing_sp	PROCEDURE	SQL	false
GetFormCaseStatusByEntryId_fn	FUNCTION	SQL	false	nvarchar
Report_Auth_Calculation_sp	PROCEDURE	SQL	false
GetDueDate_fn	FUNCTION	SQL	false	datetime
getLayerTypeName_fn	FUNCTION	SQL	false	varchar
Report_IFSP_ForFormattedReport_sp_ModifierName	PROCEDURE	SQL	false
GetoverlapClaimInfoIcs56_sp	PROCEDURE	SQL	false
Report_IFSP_ForFormattedReport_sp	PROCEDURE	SQL	false
Report_PayrollPreview_sp	PROCEDURE	SQL	false
getDataEntryDropDownNew_sp	PROCEDURE	SQL	false
Report_SCSubclaims_sp_ForFormattedReport_sp	PROCEDURE	SQL	false
UnFollowTicket_sp	PROCEDURE	SQL	false
check_ics87_fn	FUNCTION	SQL	false	varchar
sp_helpdiagramdefinition	PROCEDURE	SQL	false
Report_People_w_ServicesProvided_sp	PROCEDURE	SQL	false
GetClaimTransactionsByClaimId_sp	PROCEDURE	SQL	false
getServiceSummary_fn	FUNCTION	SQL	false	varchar
Report_TuitionInvoice_sp	PROCEDURE	SQL	false
CheckOrderSignature_fn	FUNCTION	SQL	false	bit
GetAppsAssignedReport_sp	PROCEDURE	SQL	false
GetVisitFiles_sp	PROCEDURE	SQL	false
GetClaimDetails_sp	PROCEDURE	SQL	false
GetPaysourceNameByInvoice_sp	PROCEDURE	SQL	false
Report_IFSP_ForFormattedReport_sp_ServiceUtilization	PROCEDURE	SQL	false
check_ics86_fn	FUNCTION	SQL	false	varchar
IsSupervisor_fn	FUNCTION	SQL	false	bit
getRaFilesListNew_sp	PROCEDURE	SQL	false
StrToTable	FUNCTION	SQL	false	TABLE
HandleDraftFormFileAfterSavingScNote_sp	PROCEDURE	SQL	false
getAssigned_fn	FUNCTION	SQL	false	varchar
Report_UserActivity_sp	PROCEDURE	SQL	false
fn_diagramobjects	FUNCTION	SQL	false	int
FollowTicket_sp	PROCEDURE	SQL	false
SaveAttachmentAndCreateComment_sp	PROCEDURE	SQL	false
DeductAuthWaivers_sp	PROCEDURE	SQL	false
addDeletedBilling_sp	PROCEDURE	SQL	false
sp_helpdiagrams	PROCEDURE	SQL	false
check_se15_fn	FUNCTION	SQL	false	varchar
SaveWaiveCoVisitMakeupVisitCodes_sp	PROCEDURE	SQL	false
GetEnrollmentsAttendance_sp	PROCEDURE	SQL	false
Report_EiMedicaid_sp	PROCEDURE	SQL	false
check_ics81_fn	FUNCTION	SQL	false	varchar
getClaimSearchListForFormattedReport_sp	PROCEDURE	SQL	false
GetClassroomAttendance_sp	PROCEDURE	SQL	false
DeleteAttendace_sp	PROCEDURE	SQL	false
Report_QuickNote_ForFormattedReport_sp	PROCEDURE	SQL	false
getBatchInvoicesEiHub_sp	PROCEDURE	SQL	false
Report_Transactions_sp	PROCEDURE	SQL	false
GetCheckLogs	PROCEDURE	SQL	false
updatePaySource_sp	PROCEDURE	SQL	false
UndoBatchInvoices_sp	PROCEDURE	SQL	false
addDeletedInvoice_sp	PROCEDURE	SQL	false
IPAddressToInteger_fn	FUNCTION	SQL	false	bigint
getBatchLog_ByApp_sp	PROCEDURE	SQL	false
check_ics80_fn	FUNCTION	SQL	false	varchar
Report_NightlyJobChangedRecords_sp	PROCEDURE	SQL	false
GetDiagnosesByCaseId	PROCEDURE	SQL	false
RecalculateBillingRate_sp	PROCEDURE	SQL	false
GetInfoToCreateAssignment_sp	PROCEDURE	SQL	false
Report_People_Custom_sp	PROCEDURE	SQL	false
sp_dropdiagram	PROCEDURE	SQL	false
GetOverlapClaimInfoIcs55_sp	PROCEDURE	SQL	false
AddUpdateDefaultForm_sp	PROCEDURE	SQL	false
getBatchInvoiceCPTLinesEiHub_sp	PROCEDURE	SQL	false
Report_SCSubclaimsForFormattedReport__sp_GroupBySite1	PROCEDURE	SQL	false
sp_upgraddiagrams	PROCEDURE	SQL	false