Back to Home

On Base Feed Empty

Overview

There is potential for the OnBase feed job to not import any audits overnight. This is caused by an error in the job due to Account Numbers.

Steps

  1. Run Script 1 from CIWSQLXP1125 SOBI_QUALITY
  2. Find the offending record and either
    • Fix the account number to the correct one by searching dbo.CEM_IntakeForm with the account name
    • Consult with Beth to see if the record should be deleted or given a different account number
  3. Update the option1 value for the OnBaseFeed LookupCategory in the Reference Setup page to be yesterday's date. Verify CDSFeed LookupCategory's option 1 value is still set to today.
  4. Request the sampling job runs again in BMRS for GCEM009D

Considerations

Group Number is the same thing as Account Number. We have two different fields depending on the source of the data. In the steps above, if the issue is with Group Number instead of Account Number, make the same changes but for Group Number instead.

Script 1

select * from [dbo].[CIM_IntakeForm_OnBase] where len([Account Number]) > 12 and [Last Updated] > getdate() - 2
select * from [dbo].[CIM_IntakeForm_OnBase] where len([Account Number]) > 12 and [Last Updated] > getdate() - 2

select * from [dbo].[CIM_IntakeForm_OnBase] where (ISNUMERIC([Group Number]) != 1 and len([Group Number]) > 0) and [Last Updated] > getdate() - 2
select * from [dbo].[CIM_IntakeForm_OnBase] where (ISNUMERIC([Account Number]) != 1 and len([Account Number]) > 0) and [Last Updated] > getdate() - 2