Findings

40 of 40 findings for AFL · audit 2025-11-04T14:22:00Z.

Filters

Severity

Module

Dashboard impact

Source object

Field

Status

All findings

Severity	Module	Dashboard impact	Source object	Field	Issue	Records	% affected	Recommended fix
T1 · Critical	Capacity and HR	Staff Capacity, Scheduling and Attendance	insights.StaffSchedule	ScheduledHours	A share of schedule rows resolve to Unknown scheduled hours, which makes utilization, fill rate and capacity forecasting unreliable.	118,224	32.7%	Correct schedule templates and appointment durations in Scheduling so every row resolves to real hours.
T1 · Critical	Capacity and HR	Clinical Productivity, Staff Capacity	insights.StaffSchedule	WorkedHours	A share of delivered sessions resolve to Unknown worked hours, so productivity cannot be compared against schedule.	96,508	28.2%	Ensure sessions are converted and timed correctly in Clinical > Sessions before period close.
T1 · Critical	Authorizations	Authorization Renewal, Authorization Utilization	dw2.FactAuthorization	AuthEndDate	12.6% of authorizations have no end date, so they never enter the expiring-authorization window.	61,262	12.6%	Backfill AuthEndDate from the payor approval letter and make the field required at authorization entry in CentralReach.
T1 · Critical	Financial	Payments and Collections, Revenue Cycle	dw2.FactPayment	PaymentPostedDate	31.8% of payments have no posted date, so collections aging and cash velocity are unreliable.	59,912	31.8%	Repost the affected payments with their remittance dates and automate posting-date capture from the 835.
T1 · Critical	Authorizations	Authorization Renewal, Executive Leadership	dw2.FactAuthorization	AuthManager	Some authorizations have no Auth Manager assigned, so nobody owns the renewal follow-up and expiring approvals surface late.	48,310	23.1%	Assign an Auth Manager to every active authorization in Billing > Authorizations and default it from the client's primary BCBA.
T1 · Critical	Clinical Productivity	97153 Productivity, Clinical Productivity	dw2.FactAppointment	RenderingProviderId	3.8% of converted appointments have no rendering provider, so those units fall out of 97153 productivity.	45,765	3.8%	Correct the affected appointments and block conversion when a rendering provider is not set.
T1 · Critical	Financial	Payor Mix, Revenue Cycle	dw2.FactClaim	PayorId	10.7% of claims have no payor key, so payor mix and contracted-rate analysis exclude them.	45,130	10.7%	Resolve the unmapped payors and add a claim-scrubbing rule that rejects submission without a payor key.
T1 · Critical	Authorizations	Authorization Utilization	dw2.FactAuthorization	AuthorizationGroup	Some authorization records are missing the authorization group identifier. This can cause authorization utilization dashboards to undercount or misattribute authorized hours.	33,942	15.8%	Populate the Authorization Group on each authorization and require it at entry.
T1 · Critical	Authorizations	Authorization Utilization	dw2.FactAuthorization	AuthorizedUnits	5.9% of authorizations carry no authorized unit count, breaking utilization percentage math.	28,686	5.9%	Re-key authorized units for the affected authorizations and add a validation rule blocking save when units are blank.
T1 · Critical	Authorizations	Authorization Utilization, 97153 Productivity	dw2.FactAuthorization	ServiceCode	Some authorizations have no service code, so authorized hours cannot be matched against delivered hours.	21,887	10.4%	Attach the correct service code to each authorization in Billing > Service Codes and re-link affected authorizations.
T1 · Critical	Capacity and HR	Staff Capacity, Caseload and Care Team	dw2.DimStaff	TerminationDate	41.3% of inactive staff have no termination date, so capacity models keep counting departed clinicians.	612	41.3%	Reconcile the HR roster against CentralReach and set termination dates for all inactive staff.
T1 · Critical	Capacity and HR	97153 Productivity, 97155 Supervision	dw2.DimStaff	ProviderPrimaryRole	Some providers are missing a Primary Role. This may cause provider productivity, utilization, and supervision dashboards to group providers incorrectly or exclude them from role-based reporting.	388	25.9%	Set the Primary Role on each provider record in the Provider Profile.
T1 · Critical	Capacity and HR	Staff Capacity	dw2.DimStaff	HireDate	7.5% of staff records have no hire date, breaking tenure and ramp-up analysis.	111	7.5%	Backfill hire dates from HR system of record and make the field mandatory in onboarding.
T1 · Critical	Financial	Payments and Collections, Revenue Cycle	dw2.FactPayment	RemittanceBatchId	Expected column RemittanceBatchId is absent from the payment fact table.	0	—	Add the remittance batch key so payments can be reconciled to deposits end to end.
T2 · High	Clinical Productivity	97155 Supervision, Executive Leadership	insights.SessionNote	NoteSignedDate	15.9% of session notes have no signed date, so documentation compliance cannot be measured.	153,028	15.9%	Enforce signature capture at note close and reconcile the unsigned backlog weekly.
T2 · High	Authorizations	Authorization Renewal, Executive Leadership	dw2.FactAuthorization	OwnerStaffId	28.8% of authorizations have no assigned owner, so renewal accountability cannot be routed.	140,028	28.8%	Assign an owner to every active authorization and default owner from the client's primary BCBA on creation.
T2 · High	Clinical Productivity	97155 Supervision, Clinical Productivity	dw2.FactAppointment	SupervisingProviderId	36.6% of 97155-eligible sessions lack a supervising provider, understating supervision ratios.	105,450	36.6%	Stamp the supervising provider at scheduling time and backfill the last 90 days from the schedule template.
T2 · High	Financial	Revenue Cycle, Executive Leadership	dw2.FactClaim	ClaimStatus	22.4% of claims have no status value, so denial and rework reporting is incomplete.	94,477	22.4%	Map all clearinghouse status codes into the warehouse status domain and reprocess the backlog.
T2 · High	Capacity and HR	Staff Capacity, Scheduling and Attendance	insights.StaffAvailability	AvailableHours	30.2% of availability rows have no hours, so open capacity is understated.	91,470	30.2%	Require availability templates for all billable staff and refresh them each scheduling cycle.
T2 · High	Clinical Productivity	Clinical Productivity, 97155 Supervision	insights.SessionNote	SessionDataCollection	Some clinical sessions are missing the expected activity and data-collection fields, so medical necessity cannot be evidenced from the record.	88,961	23.6%	Require data collection on session close in Clinical > Sessions and reconcile the open backlog weekly.
T2 · High	Financial	Payments and Collections	dw2.FactPayment	AdjustmentReasonCode	45.1% of adjustments carry no reason code, hiding the true cause of revenue leakage.	84,969	45.1%	Require CARC/RARC capture on posting and backfill from remittance files where available.
T2 · High	Capacity and HR	Staff Capacity, Clinical Productivity	insights.StaffAvailability	DailyAvailableHours	Some staff have no daily available hours configured, so utilization has no denominator and appears artificially high.	74,115	31.1%	Configure daily availability for every billable provider in the Provider Profile.
T2 · High	Capacity and HR	Caseload and Care Team, 97155 Supervision	dw2.FactCaseload	CareTeamProviderRole	Some care team assignments have no provider role, so caseload balancing and supervision coverage cannot be evaluated.	58,233	26.5%	Set the provider role on each assignment in the Client Care Team.
T2 · High	Authorizations	Payor Mix, Revenue Cycle	dw2.FactAuthorization	PayorPlan	Some authorizations are not linked to a payor plan, so payor-level utilization and revenue views exclude them.	29,401	20.6%	Link every authorization to its funding source in Payor / Funding Source setup.
T2 · High	Financial	Payor Mix, Revenue Cycle	insights.PayorContract	ContractedRate	38.6% of contract lines have no contracted rate, so expected-versus-actual reimbursement cannot be computed.	1,229	38.6%	Load the current fee schedules per payor and version them with effective dates.
T2 · High	Capacity and HR	Staff Capacity, Executive Leadership	dw2.DimStaff	FteStatus	33.9% of staff have no FTE status, so deliverable-hour capacity is estimated rather than measured.	502	33.9%	Populate FTE status for every active clinician and align the value list with payroll classifications.
T2 · High	Authorizations	Executive Leadership, Scheduling and Attendance	dw2.DimClient	ClientOfficeLocation	Some clients have no office location, so caseload and delivery cannot be reported by site.	412	17.4%	Set the office location on each Client Profile.
T2 · High	Capacity and HR	Staff Capacity, Executive Leadership	dw2.DimStaff	ProviderOfficeLocation	Some providers have no office location, so site-level staffing and utilization comparisons are incomplete.	296	19.7%	Assign an office location on the Provider Profile for every active provider.
T2 · High	Authorizations	Payor Mix, Authorization Utilization	dw2.DimPayor	PayorGroup	25.7% of payors are not mapped to a payor group, fragmenting payor-level authorization reporting.	55	25.7%	Complete the payor group mapping table and enforce it as a required dimension attribute.
T2 · High	Authorizations	Authorization Renewal	insights.AuthorizationUtilization	AuthorizationOwnerName	Expected column AuthorizationOwnerName is absent from the legacy insights view.	0	—	Extend the insights view to join DimStaff so owner names resolve without a client-side lookup.
T2 · High	Capacity and HR	Staff Capacity, Caseload and Care Team	insights.StaffAvailability	SupervisorStaffId	Expected column SupervisorStaffId is missing from the availability view.	0	—	Add the supervisor key so capacity can be rolled up by supervisory pod.
T3 · Medium	Clinical Productivity	Clinical Productivity, Scheduling and Attendance	dw2.FactBilledUnit	PlaceOfService	28.6% of billed units carry no place of service, blocking telehealth versus in-clinic analysis.	317,151	28.6%	Default place of service from the appointment location and correct historical rows in bulk.
T3 · Medium	Authorizations	Authorization Renewal	dw2.FactAuthorization	RenewalFlag	Renewal flag is populated on only 62.8% of records, weakening renewal pipeline segmentation.	180,870	37.2%	Derive the renewal flag in the warehouse from prior-authorization linkage rather than manual entry.
T3 · Medium	Capacity and HR	Caseload and Care Team	dw2.FactCaseload	CareTeamRole	35.1% of caseload assignments have no care team role, preventing role-based caseload balancing.	76,679	35.1%	Standardize care team roles and apply them retroactively to active assignments.
T3 · Medium	Clinical Productivity	Clinical Productivity, 97155 Supervision	insights.ClientGoal	GoalLastDataDate	Clinical goals for active clients have no recent data, which reads to payors as a lapse in data collection.	12,744	35.8%	Review active programs in Clinical > Goals / Learning Trees and resume or retire stale targets.
T3 · Medium	Financial	Payor Mix	insights.PayorContract	EffectiveDate	29.8% of contract lines have no effective date, so rate history cannot be reconstructed.	949	29.8%	Add effective and termination dates to every contract line during the next fee schedule load.
T3 · Medium	Financial	Payments and Collections, Payor Mix	insights.ARAging	PayorGroupName	Expected column PayorGroupName is missing from the AR aging view.	0	—	Join the payor group dimension into the aging view for payor-level collections reporting.
T3 · Medium	Clinical Productivity	97155 Supervision	insights.SessionNote	SupervisionMinutes	Expected column SupervisionMinutes is not present in the legacy note view.	0	—	Add SupervisionMinutes to the view so 97155 minute-level compliance can be computed in the warehouse.
T4 · Low	Financial	Payments and Collections, Executive Leadership	dw2.FactClaim	WriteOffReason	51.4% of write-offs have no reason, limiting root-cause analysis of lost revenue.	216,792	51.4%	Adopt a controlled write-off reason list and require it for any adjustment above a set threshold.
T4 · Low	Capacity and HR	Staff Capacity	insights.TimeOffRequest	ApprovedFlag	27.5% of time-off requests have no approval flag, adding noise to forward capacity.	23,682	27.5%	Close out stale time-off requests and require an approval decision within five business days.