Bulk Import AI - Authentication Failed!

Timestamp: #DateFormat(Now(), 'mm/dd/yyyy')# #TimeFormat(Now(), 'HH:mm:ss')#

Reason: Invalid API Key

Agency ID: #arguments.agency_id#

Employee ID: #arguments.emp_id#

IP Address: #CGI.REMOTE_ADDR#

User Agent: #CGI.HTTP_USER_AGENT#

Provided Key (masked): #Left(arguments.appkey, 10)#***

Security Alert: Unauthorized access attempt detected.

This is an automated security notification from the Bulk Import AI API

Bulk Import AI - Authentication Error!

Timestamp: #DateFormat(Now(), 'mm/dd/yyyy')# #TimeFormat(Now(), 'HH:mm:ss')#

Agency ID: #arguments.agency_id#

Employee ID: #arguments.emp_id#

IP Address: #CGI.REMOTE_ADDR#

User Agent: #CGI.HTTP_USER_AGENT#

Error Details:

Error Type: #cfcatch.type#

Error Message: #cfcatch.message#

Error Detail: #cfcatch.detail#

File: #cfcatch.TagContext[1].template#

Line: #cfcatch.TagContext[1].line#

Stack Trace:

#cfcatch.stacktrace#

This is an automated error notification from the Bulk Import AI API

Bulk Import AI - Patient Data Imported Successfully!

Agency ID: #arguments.agencyID#

Employee ID: #arguments.empID#

Patient ID: #arguments.patientID#

Assessment ID: #arguments.assessmentID#

Website: #arguments.websiteName#

Timestamp: #DateFormat(Now(), 'mm/dd/yyyy')# #TimeFormat(Now(), 'HH:mm:ss')#

Encryption IDs and AppKeys:

Field	Original (Encrypted)	Decrypted Value	Was Encrypted
Agency_ID	`#htmlEditFormat(arguments.originalAgencyID)#`	`#htmlEditFormat(arguments.decryptedAgencyID)#`	#iif(arguments.decryptedAgencyID NEQ arguments.originalAgencyID, DE('Yes'), DE('No'))#
Emp_ID	`#htmlEditFormat(arguments.originalEmpID)#`	`#htmlEditFormat(arguments.decryptedEmpID)#`	#iif(arguments.decryptedEmpID NEQ arguments.originalEmpID, DE('Yes'), DE('No'))#
Patient_ID	`#htmlEditFormat(arguments.originalPatientID)#`	`#htmlEditFormat(arguments.decryptedPatientID)#`	#iif(arguments.decryptedPatientID NEQ arguments.originalPatientID, DE('Yes'), DE('No'))#
Assessment_ID	`#htmlEditFormat(arguments.originalAssessmentID)#`	`#htmlEditFormat(arguments.decryptedAssessmentID)#`	#iif(arguments.decryptedAssessmentID NEQ arguments.originalAssessmentID, DE('Yes'), DE('No'))#
appkey	`#htmlEditFormat(arguments.originalAppKey)#`	`#htmlEditFormat(arguments.decryptedAppKey)#`	#iif(len(arguments.decryptedAppKey) GT 0 AND arguments.decryptedAppKey NEQ arguments.originalAppKey, DE('Yes'), DE('No'))#

Encryption Key Available: Yes (Length: #len(Application.enckey)#)

Encryption Key Available: No

Import Results:

Patient AI ID: #arguments.insertedPatientID# (#arguments.patientAction#)

Emergency Contact: #iif(arguments.contactInserted, DE('Inserted'), DE('Updated'))# (ID: #arguments.insertedContactID#)

Payer/Subscriber: #iif(arguments.payerInserted, DE('Inserted'), DE('Updated'))# (ID: #arguments.insertedPayerID#)

Admission Record: #iif(arguments.admitInserted, DE('Inserted'), DE('Updated'))# (ID: #arguments.insertedAdmitID#)

Medications: #arguments.medicationCount# record(s) inserted

Problems/Diagnoses: #arguments.problemCount# record(s) inserted/updated

Extracted Data (JSON):

#htmlEditFormat(arguments.extractedJSONString)#

Partial Errors:

#err#

Debug Information:

Datasource: #Application.DataSrc#
Agency Database: #arguments.agency_db#
Transaction Status: Committed Successfully

This is an automated notification from the Bulk Import AI API

Bulk Import AI - Patient Data Import Failed!

Agency ID: #arguments.agencyID#

Employee ID: #arguments.empID#

Patient ID: #arguments.patientID#

Assessment ID: #arguments.assessmentID#

Website: #arguments.websiteName#

Timestamp: #DateFormat(Now(), 'mm/dd/yyyy')# #TimeFormat(Now(), 'HH:mm:ss')#

Error Information:

Error Type: #errorType#

Error Message: #errorMessage#

Error Detail: #errorDetail#

File: #errorTagContext[1].template#

Line: #errorTagContext[1].line#

Encryption IDs and AppKeys:

Field	Original (Encrypted)	Decrypted Value	Was Encrypted
Agency_ID	`#htmlEditFormat(arguments.originalAgencyID)#`	`#htmlEditFormat(arguments.decryptedAgencyID)#`	#iif(arguments.decryptedAgencyID NEQ arguments.originalAgencyID, DE('Yes'), DE('No'))#
Emp_ID	`#htmlEditFormat(arguments.originalEmpID)#`	`#htmlEditFormat(arguments.decryptedEmpID)#`	#iif(arguments.decryptedEmpID NEQ arguments.originalEmpID, DE('Yes'), DE('No'))#
Patient_ID	`#htmlEditFormat(arguments.originalPatientID)#`	`#htmlEditFormat(arguments.decryptedPatientID)#`	#iif(arguments.decryptedPatientID NEQ arguments.originalPatientID, DE('Yes'), DE('No'))#
Assessment_ID	`#htmlEditFormat(arguments.originalAssessmentID)#`	`#htmlEditFormat(arguments.decryptedAssessmentID)#`	#iif(arguments.decryptedAssessmentID NEQ arguments.originalAssessmentID, DE('Yes'), DE('No'))#
appkey	`#htmlEditFormat(arguments.originalAppKey)#`	`#htmlEditFormat(arguments.decryptedAppKey)#`	#iif(len(arguments.decryptedAppKey) GT 0 AND arguments.decryptedAppKey NEQ arguments.originalAppKey, DE('Yes'), DE('No'))#

Encryption Key Available: Yes (Length: #len(Application.enckey)#)

Encryption Key Available: No

Partial Import Results (before error):

Patient AI ID: #arguments.insertedPatientID#
Medications: #arguments.medicationCount# record(s)
Problems/Diagnoses: #arguments.problemCount# record(s)

Previous Errors:

#err#

Extracted Data (JSON):

#htmlEditFormat(arguments.extractedJSONString)#

Stack Trace:

#htmlEditFormat(errorStacktrace)#

This is an automated error notification from the Bulk Import AI API

processPatientData Exception Error

Timestamp: #DateFormat(Now(), 'mm/dd/yyyy')# #TimeFormat(Now(), 'HH:mm:ss')#

Agency ID: #arguments.agencyID#

Employee ID: #arguments.empID#

Patient ID: #arguments.patientID#

Agency Database: #arguments.agency_db#

Error Information:

Error Type: #errorType#

Error Message: #errorMessage#

Error Detail: #errorDetail#

File: #errorTagContext[1].template#

Line: #errorTagContext[1].line#

Input Data (pPatient):

#htmlEditFormat(serializeJSON(arguments.data.pPatient))#

No pPatient data provided

Stack Trace:

#htmlEditFormat(errorStacktrace)#

This is an automated error notification from the Bulk Import AI API

#arguments.moduleName# Exception Error

Timestamp: #DateFormat(Now(), 'mm/dd/yyyy')# #TimeFormat(Now(), 'HH:mm:ss')#

Module: #arguments.moduleName#

Agency ID: #arguments.agencyID#

Employee ID: #arguments.empID#

Patient ID: #arguments.patientID#

Agency Database: #arguments.agency_db#

Error Information:

Error Type: #errorType#

Error Message: #errorMessage#

Error Detail: #errorDetail#

File: #errorTagContext[1].template#

Line: #errorTagContext[1].line#

Input Data:

#htmlEditFormat(serializeJSON(arguments.inputData))#

Stack Trace:

#htmlEditFormat(errorStacktrace)#

This is an automated error notification from the Bulk Import AI API

Update Action Notification

Timestamp: #DateFormat(Now(), 'mm/dd/yyyy')# #TimeFormat(Now(), 'HH:mm:ss')#

Action: #arguments.action#

Table: #arguments.table#

Record ID: #arguments.recordID#

Agency ID: #arguments.agencyID#

Employee ID: #arguments.empID#

Patient ID: #arguments.patientID#

Agency Database: #arguments.agency_db#

Rows Affected: #arguments.rowsAffected#

SQL Query:

#htmlEditFormat(arguments.querySQL)#

This is an automated notification from the Bulk Import AI API

Query Dump - All Executed Queries

Timestamp: #DateFormat(Now(), 'mm/dd/yyyy')# #TimeFormat(Now(), 'HH:mm:ss')#

Agency ID: #arguments.agencyID#

Employee ID: #arguments.empID#

Patient ID: #arguments.patientID#

Agency Database: #arguments.agency_db#

Total Queries: #arrayLen(request.bulk_import_queries)#

All Queries:

Query Name: #queryInfo.name#

Timestamp: #DateFormat(queryInfo.timestamp, 'mm/dd/yyyy')# #TimeFormat(queryInfo.timestamp, 'HH:mm:ss')#

Record Count: #queryInfo.recordCount#

SQL:

#htmlEditFormat(queryInfo.sql)#

This is an automated query dump from the Bulk Import AI API

SELECT pt_ai_id FROM #agency_db#.patients_ai WHERE status = 0 AND Patient_ID = AND Pt_First = AND Pt_Last = AND Pt_DOB = ORDER BY pt_ai_id DESC LIMIT 1 UPDATE #agency_db#.patients_ai SET Pt_First = , Pt_Last = , Pt_DOB = , Pt_Gender = , Payer_Name = , policy_id_no = , Pt_Street = , Pt_City = , Pt_State = , Pt_Zip = , Pt_Phone = , Pt_Race = , M0140_ETHNIC = , Pt_language = , Interpreter = , Allergies = , Pt_SSN = , Email = , Specific_Concerns = , F181 = , F149 = , F150 = , F70 = , F151 = , F253 = , F138 = , F139 = , F141 = , F154 = , modified_date = , modified_by = WHERE pt_ai_id = AND status = 0 INSERT INTO #agency_db#.patients_ai ( Pt_First, Pt_Last, Pt_DOB, Pt_Gender, Payer_ID, Payer_Name, policy_id_no, Pt_Street, Pt_City, Pt_State, Pt_Zip, Pt_Phone, Pt_Race, M0140_ETHNIC, Pt_language, Interpreter, Allergies, Pt_SSN, Email, Specific_Concerns, F181, F149, F150, F70, F151, F253, F138, F139, F141, F154, start_of_care_date, start_of_care_type, status, created_date, created_by, modified_date, modified_by ) VALUES ( , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ) SELECT LAST_INSERT_ID() AS last_id UPDATE #agency_db#.patients_ai SET Patient_ID = , modified_date = , modified_by = WHERE pt_ai_id = AND (Patient_ID IS NULL OR Patient_ID = 0) AND status = 0 SELECT Patient_ID, Pt_First, Pt_Last FROM #agency_db#.pPatients WHERE Patient_ID = AND status IN (0,1,4) LIMIT 1 UPDATE #agency_db#.pPatients SET Pt_Middle = , Pt_Suffix = , Pt_Street = , Pt_City = , Pt_State = , Pt_Zip = , Pt_Phone = , Pt_DOB = , Pt_Agy_ID = , Pt_Race = , M0140_ETHNIC = , Pt_language = , Interpreter = , Allergies = , Pt_SSN = , Email = , Specific_Concerns = , Record_Mod_Date = , Record_Mod_By = WHERE Patient_ID = AND status IN (0,1,4) INSERT INTO #agency_db#.ptmeds_ai ( Patient_ID, Patient_AI_ID, Drug_ID, Status, DateOrdered, DateDCed, Drug_Name, Dose, Dose_Units, Route, Freq, Notes, Date_Create, Created_by, Date_Change, Change_by, record_timestamp ) VALUES ( , , , , , , , , , , , , , , , , ) SELECT Contact_ID FROM #agency_db#.pt_contacts_ai WHERE Patient_AI_ID = AND First_Name = AND Last_Name = AND Status = 0 LIMIT 1 INSERT INTO #agency_db#.pt_contacts_ai ( Patient_AI_ID, First_Name, Last_Name, Relationship, Is_Emergency, Email, Telephone1, Telephone2, Date_Create, Created_by, Date_Change, Change_by, Status ) VALUES ( , , , , , , , , , , , , ) UPDATE #agency_db#.pt_contacts_ai SET Relationship = , Is_Emergency = , Email = , Telephone1 = , Telephone2 = , Date_Change = , Change_by = WHERE Contact_ID = AND Status = 0 SELECT Payer_AI_ID FROM #agency_db#.pt_payer_ai WHERE Patient_AI_ID = AND Payer_Name = AND Status = 0 LIMIT 1 INSERT INTO #agency_db#.pt_payer_ai ( Patient_AI_ID, Payer_ID, Payer_Name, Policy_ID_No, Subscriber_HIC, Subscriber_Relationship, Subscriber_First_Name, Subscriber_Last_Name, Date_Create, Created_by, Date_Change, Change_by, Status ) VALUES ( , , , , , , , , , , , , ) UPDATE #agency_db#.pt_payer_ai SET Policy_ID_No = , Subscriber_HIC = , Subscriber_Relationship = , Subscriber_First_Name = , Subscriber_Last_Name = , Date_Change = , Change_by = WHERE Payer_AI_ID = AND Status = 0 SELECT Admit_ID FROM #agency_db#.pt_admit_ai WHERE Patient_AI_ID = AND Assmt_ID = AND Status = 0 LIMIT 1 INSERT INTO #agency_db#.pt_admit_ai ( Patient_AI_ID, Assmt_ID, M0104_PHYSN_RFRL_DT, Date_F2F, Refer_Phys_ID, Render_Phys_ID, MD_Clinical_Condition, MD_Homebound, Advance_Directive, Advance_DirectiveDate, Code_Status, Date_Create, Created_by, Date_Change, Change_by, Status ) VALUES ( , , , , , , , , , , , , , , , ) UPDATE #agency_db#.pt_admit_ai SET M0104_PHYSN_RFRL_DT = , Date_F2F = , Refer_Phys_ID = , Render_Phys_ID = , MD_Clinical_Condition = , MD_Homebound = , Advance_Directive = , Advance_DirectiveDate = , Code_Status = , Date_Change = , Change_by = WHERE Admit_ID = AND Status = 0 SELECT Admit_ID FROM #agency_db#.pAdmit WHERE Patient_ID = AND Status = 0 ORDER BY Admit_ID DESC LIMIT 1 SELECT Problem_ID FROM #agency_db#.problems_ai WHERE Patient_AI_ID = AND Assmt_ID = AND Description = AND Status = 0 LIMIT 1 INSERT INTO #agency_db#.problems_ai ( Patient_AI_ID, Assmt_ID, Status, M0_No, Description, Answer, Severity, dx_order, Oasis_Deficits, Date_Create, Created_by, Date_Change, Change_by, record_timestamp ) VALUES ( , , , , , , , , , , , , , ) UPDATE #agency_db#.problems_ai SET dx_order = , Date_Change = , Change_by = , record_timestamp = WHERE Problem_ID = AND Status = 0

Problems Successfully Inserted

Timestamp: #DateFormat(Now(), 'mm/dd/yyyy')# #TimeFormat(Now(), 'HH:mm:ss')#

Agency ID: #arguments.Agency_ID#

Employee ID: #arguments.Emp_ID#

Patient ID: #arguments.Patient_ID#

Assessment ID: #arguments.Assessment_ID#

Agency Database: #agency_db#

Patient AI ID: #insertedPatientID#

Insertion Summary:

Problems Inserted: #problemResult.problemCount#

Problem IDs: #arrayToList(problemResult.problemIDs, ", ")#

Errors:

#htmlEditFormat(err)#

Input Problems Data:

#htmlEditFormat(serializeJSON(data.pProblem.description))#

Note: Problems have been inserted into #agency_db#.problems_ai table with status=0.
Next Step: Call sync_problems_action.cfm to sync these problems from problems_ai to pProblem table.

This is an automated notification from the Bulk Import AI API

Bulk Import AI - Sync Failed

Timestamp: #DateFormat(Now(), 'mm/dd/yyyy')# #TimeFormat(Now(), 'HH:mm:ss')#

Agency ID: #arguments.Agency_ID#

Patient ID: #arguments.Patient_ID#

Error Details:

Error Type: #htmlEditFormat(cfcatch.type)#

Error Message: #htmlEditFormat(cfcatch.message)#

Error Detail: #htmlEditFormat(cfcatch.detail)#

Stack Trace:

#htmlEditFormat(left(cfcatch.stackTrace, 2000))#

Bulk Import AI - Sync NOT Called

Timestamp: #DateFormat(Now(), 'mm/dd/yyyy')# #TimeFormat(Now(), 'HH:mm:ss')#

Agency ID: #arguments.Agency_ID#

Agency Database: #agency_db#

Patient ID: #arguments.Patient_ID#

Assessment ID: #arguments.Assessment_ID#

Employee ID: #arguments.Emp_ID#

Reason:

Patient_ID is 0 or negative - Sync will NOT be called

Condition: arguments.Patient_ID GT 0 = FALSE

sync_ai_patients_admit.cfm was NOT included because Patient_ID is invalid