Routines

Routines

Name	Type	Language	Deterministic	Return Type	Security Restriction	Comments
SecureCommunicationDB_Signup_sp	PROCEDURE	SQL	false
Report_IFSP_ForFormattedReport_sp_ServiceSummary	PROCEDURE	SQL	false
UpdateBBSResults	PROCEDURE	SQL	false
CalculateEndingBalance	PROCEDURE	SQL	false
dt_getobjwithprop_u	PROCEDURE	SQL	false
getAgencyCategoryFromID_sp	PROCEDURE	SQL	false
getStatus_fn	FUNCTION	SQL	false	varchar
Apps_Signup_sp	PROCEDURE	SQL	false
BackupDB_DeleteOld_sp	PROCEDURE	SQL	false
dt_getpropertiesbyid_u	PROCEDURE	SQL	false
addItem6_fn	FUNCTION	SQL	false	varchar
addItem12_fn	FUNCTION	SQL	false	varchar
yn	FUNCTION	SQL	false	varchar
dt_getpropertiesbyid_vcs	PROCEDURE	SQL	false
dt_checkoutobject	PROCEDURE	SQL	false
ics_InvoiceItems_sp	PROCEDURE	SQL	false
dt_displayoaerror	PROCEDURE	SQL	false
Auto_Change_Case_Status_sp	PROCEDURE	SQL	false
addItem26_fn	FUNCTION	SQL	false	varchar
getClientStats_sp	PROCEDURE	SQL	false
CopyRPT_sp	PROCEDURE	SQL	false
Report_SCSubclaims_sp_ForFormattedReport_sp_Claims	PROCEDURE	SQL	false
LogUserInfo_sp	PROCEDURE	SQL	false
login_sp	PROCEDURE	SQL	false
dt_adduserobject_vcs	PROCEDURE	SQL	false
getProgram_fn	FUNCTION	SQL	false	varchar
updateAgencyAndInsertAgreement_sp	PROCEDURE	SQL	false
SignUpAgency_sp	PROCEDURE	SQL	false
get_Acency_LoginUrl_sp	PROCEDURE	SQL	false
dt_isundersourcecontrol	PROCEDURE	SQL	false
dt_validateloginparams_u	PROCEDURE	SQL	false
getLegalAgreementsFromAgreementType_sp	PROCEDURE	SQL	false
AutomaticallyInsertGaps_sp	PROCEDURE	SQL	false
dt_checkinobject	PROCEDURE	SQL	false
updateExportHistory_sp	PROCEDURE	SQL	false
addItem9_fn	FUNCTION	SQL	false	varchar
addItem21_fn	FUNCTION	SQL	false	varchar
addItem29_fn	FUNCTION	SQL	false	varchar
dt_verstamp006	PROCEDURE	SQL	false
Auto_Change_Enrollment_EndDate_sp	PROCEDURE	SQL	false
addItem1_fn	FUNCTION	SQL	false	varchar
TableToDataDictionary_Isc2	PROCEDURE	SQL	false
getLegalAgreementsFromAgreementCode_sp	PROCEDURE	SQL	false
dt_vcsenabled	PROCEDURE	SQL	false
Automatically_Delete_Draft_sp	PROCEDURE	SQL	false
getCriteria_sp	PROCEDURE	SQL	false
Automatically_Close_Plans_sp	PROCEDURE	SQL	false
Get_CPIDs_sp	PROCEDURE	SQL	false
dt_dropuserobjectbyid	PROCEDURE	SQL	false
dt_adduserobject	PROCEDURE	SQL	false
getAgencyAddressFromID_sp	PROCEDURE	SQL	false
getOutputs_sp	PROCEDURE	SQL	false
addItem4_fn	FUNCTION	SQL	false	varchar
getModifier_fn	FUNCTION	SQL	false	varchar
dt_whocheckedout_u	PROCEDURE	SQL	false
CollectActiveAccessUsers_sp	PROCEDURE	SQL	false
Report_IFSP_ForFormattedReport_sp_ModifierName	PROCEDURE	SQL	false
addItem24_fn	FUNCTION	SQL	false	varchar
execQlSQLics2_sp	PROCEDURE	SQL	false
sp_renamediagram	PROCEDURE	SQL	false
Report_IFSP_ForFormattedReport_sp	PROCEDURE	SQL	false
getAllClientEmails_sp	PROCEDURE	SQL	false
getCategory	PROCEDURE	SQL	false
AutoChangeClaimStatusToNonBillWhenErrorCodeICS17_sp	PROCEDURE	SQL	false
BackupAllClientDBs_TEMP_sp	PROCEDURE	SQL	false
Report_SCSubclaims_sp_ForFormattedReport_sp	PROCEDURE	SQL	false
createNewFieldAndDataDictionary_sp	PROCEDURE	SQL	false
Report_SCSubclaimsForFormattedReport_sp_GroupByProvider	PROCEDURE	SQL	false
addItem13_fn	FUNCTION	SQL	false	varchar
sp_helpdiagramdefinition	PROCEDURE	SQL	false
addItem7_fn	FUNCTION	SQL	false	varchar
InsertAgreement_sp	PROCEDURE	SQL	false
AutomaticallyCorrectWrongAuthUnitsUsed_sp	PROCEDURE	SQL	false
dt_displayoaerror_u	PROCEDURE	SQL	false
getServiceOrdersFromPackage_sp	PROCEDURE	SQL	false
getAgencyCategoryFromCompany_sp	PROCEDURE	SQL	false
Report_SCSubclaimsForFormattedReport_sp_Patients	PROCEDURE	SQL	false
Report_IFSP_ForFormattedReport_sp_ServiceUtilization	PROCEDURE	SQL	false
dt_isundersourcecontrol_u	PROCEDURE	SQL	false
dt_whocheckedout	PROCEDURE	SQL	false
dt_getpropertiesbyid	PROCEDURE	SQL	false
Auto_Change_Assignment_By_Case_Status_sp	PROCEDURE	SQL	false
Auto_Change_Auhorization_By_Case_Status_sp	PROCEDURE	SQL	false
udf_StripHTML	FUNCTION	SQL	false	varchar
addItem2_fn	FUNCTION	SQL	false	varchar
ra_ApplyAll835Files_sp	PROCEDURE	SQL	false
dt_checkinobject_u	PROCEDURE	SQL	false
Automatically_Close_Plans_After_X_Days_sp	PROCEDURE	SQL	false
getFinancialTransactionsForFormattedReport_sp	PROCEDURE	SQL	false
dt_validateloginparams	PROCEDURE	SQL	false
fn_diagramobjects	FUNCTION	SQL	false	int
addItem19_fn	FUNCTION	SQL	false	varchar
getAgencySupportUserID_sp	PROCEDURE	SQL	false
spDatabases_AutomatedJob_mod	PROCEDURE	SQL	false
BackupClientDB_sp	PROCEDURE	SQL	false
dt_removefromsourcecontrol	PROCEDURE	SQL	false
sp_helpdiagrams	PROCEDURE	SQL	false
addItem5_fn	FUNCTION	SQL	false	varchar
dataIngegrityChecks_sp	PROCEDURE	SQL	false
sp_alterdiagram	PROCEDURE	SQL	false
dt_setpropertybyid_u	PROCEDURE	SQL	false
Automatically_Close_Authorization_sp	PROCEDURE	SQL	false
dt_addtosourcecontrol	PROCEDURE	SQL	false
getAgencyClaimDetails_sp	PROCEDURE	SQL	false
getClaimSearchListForFormattedReport_sp	PROCEDURE	SQL	false
dt_setpropertybyid	PROCEDURE	SQL	false
Report_QuickNote_ForFormattedReport_sp	PROCEDURE	SQL	false
getStats_sp	PROCEDURE	SQL	false
getAgencyNameFromSignupCode_sp	PROCEDURE	SQL	false
Report_SCSubclaimsForFormattedReport__sp_GroupBySite	PROCEDURE	SQL	false
getDataSources_sp_Test	PROCEDURE	SQL	false
MonthlyInvoice_sp	PROCEDURE	SQL	false
getAllClientData_sp	PROCEDURE	SQL	false
getBillingUnit_fn	FUNCTION	SQL	false	int
dt_generateansiname	PROCEDURE	SQL	false
dt_droppropertiesbyid	PROCEDURE	SQL	false
getAllClientProvCount_sp	PROCEDURE	SQL	false
addItem20_fn	FUNCTION	SQL	false	varchar
BackupAllClientDBs_sp	PROCEDURE	SQL	false
addItem8_fn	FUNCTION	SQL	false	varchar
InitialCap	FUNCTION	SQL	false	varchar
createNewAction_sp	PROCEDURE	SQL	false
getAllBillingStatus_sp	PROCEDURE	SQL	false
getAllClientAvg_sp	PROCEDURE	SQL	false
dt_getobjwithprop	PROCEDURE	SQL	false
CollectGroups_sp	PROCEDURE	SQL	false
getDataSources_sp	PROCEDURE	SQL	false
CollectRoles_sp	PROCEDURE	SQL	false
AssignAppsToCompany_sp	PROCEDURE	SQL	false
addItem17_fn	FUNCTION	SQL	false	varchar
sp_creatediagram	PROCEDURE	SQL	false
getAgencyNameFromAgreementCode_sp	PROCEDURE	SQL	false
dt_addtosourcecontrol_u	PROCEDURE	SQL	false
getAgreementFromSignupCode_sp	PROCEDURE	SQL	false
dt_checkoutobject_u	PROCEDURE	SQL	false
getLegalContentForAgreement_sp	PROCEDURE	SQL	false
sp_dropdiagram	PROCEDURE	SQL	false
addPages_sp	PROCEDURE	SQL	false
Report_SCSubclaimsForFormattedReport__sp_GroupBySite1	PROCEDURE	SQL	false
dt_getpropertiesbyid_vcs_u	PROCEDURE	SQL	false
addItem3_fn	FUNCTION	SQL	false	varchar
getServiceOrdersFromAgreementCode_sp	PROCEDURE	SQL	false
get_ProgramTypes_sp	PROCEDURE	SQL	false
sp_upgraddiagrams	PROCEDURE	SQL	false