' & vitalUpdated & '' & vitalSkipped & '—' /> ' & woundUpdated & '' & woundSkipped & '' & woundPhotos & '' /> ' /> ' /> ' /> ' />

#htmlEditFormat(arguments.methodName)# Request / Response Trace

Timestamp: #dateFormat(now(), 'mm/dd/yyyy')# #timeFormat(now(), 'HH:mm:ss')#

HTTP Status: #val(arguments.httpStatus)#

Success: #successFlag#

Message: #htmlEditFormat(arguments.responseSnapshot.message)#
#vitalsWoundsHtml#

Exact Failure Detail

Explanation: #htmlEditFormat(arguments.context.errorDetail.explanation)#

Failed at: #htmlEditFormat(arguments.context.errorDetail.failed_at)#

Failed step: #htmlEditFormat(arguments.context.errorDetail.failed_step)#

Why: #htmlEditFormat(arguments.context.errorDetail.why)#

How to fix: #htmlEditFormat(arguments.context.errorDetail.how_to_fix)#

 
#htmlEditFormat(errorDetailJson)#

Context

#htmlEditFormat(ctxKey)# #htmlEditFormat(isSimpleValue(arguments.context[ctxKey]) ? arguments.context[ctxKey] : serializeJSON(arguments.context[ctxKey]))#

scheduleQuery Dump (strict match: Assmt_ID + Emp_ID + Status=0)

#htmlEditFormat(scheduleQueryJson)#

schedulesForAssmt Dump (diagnostic: this Assmt_ID, any Emp_ID / Status, up to 25)

#htmlEditFormat(schedulesForAssmtJson)#

schedulesForPatient Dump (diagnostic: assessment Patient_ID + Emp_ID, any Status, up to 25)

#htmlEditFormat(schedulesForPatientJson)#

Request Payload

#htmlEditFormat(requestJson)#

Response Payload

#htmlEditFormat(responseJson)#

Automated trace from mobile_app.cfc #htmlEditFormat(arguments.methodName)#

 SELECT pEmployee.Emp_ID, pEmployee.Loc_ID FROM hhapowerpath.pEmployee WHERE pEmployee.Emp_ID = AND pEmployee.Emp_Type = 'Employee' AND pEmployee.Status = 0 LIMIT 1 SELECT SCHEMA_NAME FROM information_schema.schemata WHERE SCHEMA_NAME = #serializeJSON(errJson)# #serializeJSON(errJson)# #serializeJSON(errJson)# #serializeJSON(errJson)# #serializeJSON(errJson)# #serializeJSON(errJson)# #serializeJSON(buildProgressNotesApiErrorJson(request.mobile_pgnotes_last_error))#

Mobile downloadProgressNotesTemplate failed

Timestamp: #dateFormat(now(), 'mm/dd/yyyy')# #timeFormat(now(), 'HH:mm:ss')#

Server: #htmlEditFormat(cgi.server_name)#

IP: #htmlEditFormat(cgi.remote_addr)#

Request URI / query: #htmlEditFormat(structKeyExists(cgi, 'request_url') ? cgi.request_url : (structKeyExists(cgi, 'script_name') ? cgi.script_name : ''))#

Query string: #htmlEditFormat(structKeyExists(cgi, 'query_string') ? cgi.query_string : '')#

Exact error (API / client)

MESSAGE: #htmlEditFormat(exMsg)#

DETAIL: #htmlEditFormat(exDetail)#

QUERY ERROR: #htmlEditFormat(exQueryErr)#

JSON returned to app:

#apiJsonSafe#

Request context

Schedule_ID#htmlEditFormat("" & structKeyExists(ctx, 'scheduleId') ? ctx.scheduleId : '')#
Emp_ID#htmlEditFormat("" & structKeyExists(ctx, 'empId') ? ctx.empId : '')#
Agency (Loc_ID)#htmlEditFormat("" & structKeyExists(ctx, 'locId') ? ctx.locId : '')#
Agency schema#htmlEditFormat("" & structKeyExists(ctx, 'agencySchema') ? ctx.agencySchema : '')#
Patient_ID#htmlEditFormat("" & structKeyExists(ctx, 'patientId') ? ctx.patientId : '')#
Assmt_ID#htmlEditFormat("" & structKeyExists(ctx, 'assmtId') ? ctx.assmtId : '')#
Visit_Type#htmlEditFormat("" & structKeyExists(ctx, 'visitType') ? ctx.visitType : '')#
Skill#htmlEditFormat("" & structKeyExists(ctx, 'skill') ? ctx.skill : '')#
download_label#htmlEditFormat("" & structKeyExists(ctx, 'downloadLabel') ? ctx.downloadLabel : '')#
Template#htmlEditFormat("" & structKeyExists(ctx, 'templatePath') ? ctx.templatePath : '')#

Exception details

Type#htmlEditFormat(structKeyExists(ex, 'type') ? ex.type : '')#
Message#htmlEditFormat(exMsg)#
Detail#htmlEditFormat(exDetail)#
Extended info#htmlEditFormat(structKeyExists(ex, 'Extended_Info') ? ex.Extended_Info : (structKeyExists(ex, 'extendedInfo') ? ex.extendedInfo : ''))#
Query name#htmlEditFormat(structKeyExists(ex, 'queryName') ? ex.queryName : '')#
DataSource#htmlEditFormat(structKeyExists(ex, 'DataSource') ? ex.DataSource : (structKeyExists(ex, 'datasource') ? ex.datasource : ''))#
Native error code#htmlEditFormat("" & (structKeyExists(ex, 'nativeErrorCode') ? ex.nativeErrorCode : (structKeyExists(ex, 'NativeErrorCode') ? ex.NativeErrorCode : '')))#
SQLState#htmlEditFormat("" & (structKeyExists(ex, 'sqlState') ? ex.sqlState : (structKeyExists(ex, 'SQLState') ? ex.SQLState : '')))#
Query error#htmlEditFormat(exQueryErr)#
SQL
#htmlEditFormat(exSql)#

Tag context (first frame)

Tag: #htmlEditFormat(structKeyExists(ex.TagContext[1], 'tag') ? ex.TagContext[1].tag : '')#

Template: #htmlEditFormat(structKeyExists(ex.TagContext[1], 'template') ? ex.TagContext[1].template : '')#

Line: #htmlEditFormat(structKeyExists(ex.TagContext[1], 'line') ? ex.TagContext[1].line : '')#

Stack trace

#htmlEditFormat(exStack)#

Exception struct (JSON)

#exJsonSafe#

Automated notification from mobile_app.cfc downloadProgressNotesTemplate

Admission Summary HTML download failed

Timestamp: #dateFormat(now(), 'mm/dd/yyyy')# #timeFormat(now(), 'HH:mm:ss')#

Server: #htmlEditFormat(cgi.server_name)#

IP: #htmlEditFormat(cgi.remote_addr)#

Request URI / query: #htmlEditFormat(structKeyExists(cgi, 'request_url') ? cgi.request_url : (structKeyExists(cgi, 'script_name') ? cgi.script_name : ''))#

Query string: #htmlEditFormat(structKeyExists(cgi, 'query_string') ? cgi.query_string : '')#

Exact error

MESSAGE: #htmlEditFormat(exMsg)#

DETAIL: #htmlEditFormat(exDetail)#

QUERY ERROR: #htmlEditFormat(exQueryErr)#

Error JSON:

#apiJsonSafe#

Request context

Patient_ID#htmlEditFormat("" & structKeyExists(ctx, 'patientId') ? ctx.patientId : '')#
Assmt_ID#htmlEditFormat("" & structKeyExists(ctx, 'assmtId') ? ctx.assmtId : '')#
Admit_ID#htmlEditFormat("" & structKeyExists(ctx, 'admitId') ? ctx.admitId : '')#
Agency (Loc_ID)#htmlEditFormat("" & structKeyExists(ctx, 'locId') ? ctx.locId : '')#
Agency schema#htmlEditFormat("" & structKeyExists(ctx, 'agencySchema') ? ctx.agencySchema : '')#
download_label#htmlEditFormat("" & structKeyExists(ctx, 'downloadLabel') ? ctx.downloadLabel : '')#
Template#htmlEditFormat("" & structKeyExists(ctx, 'templatePath') ? ctx.templatePath : '')#

Exception details

Type#htmlEditFormat(structKeyExists(ex, 'type') ? ex.type : '')#
Message#htmlEditFormat(exMsg)#
Detail#htmlEditFormat(exDetail)#
Extended info#htmlEditFormat(structKeyExists(ex, 'Extended_Info') ? ex.Extended_Info : (structKeyExists(ex, 'extendedInfo') ? ex.extendedInfo : ''))#
Query name#htmlEditFormat(structKeyExists(ex, 'queryName') ? ex.queryName : '')#
DataSource#htmlEditFormat(structKeyExists(ex, 'DataSource') ? ex.DataSource : (structKeyExists(ex, 'datasource') ? ex.datasource : ''))#
Native error code#htmlEditFormat("" & (structKeyExists(ex, 'nativeErrorCode') ? ex.nativeErrorCode : (structKeyExists(ex, 'NativeErrorCode') ? ex.NativeErrorCode : '')))#
SQLState#htmlEditFormat("" & (structKeyExists(ex, 'sqlState') ? ex.sqlState : (structKeyExists(ex, 'SQLState') ? ex.SQLState : '')))#
Query error#htmlEditFormat(exQueryErr)#
SQL
#htmlEditFormat(exSql)#

Tag context (first frame)

Tag: #htmlEditFormat(structKeyExists(ex.TagContext[1], 'tag') ? ex.TagContext[1].tag : '')#

Template: #htmlEditFormat(structKeyExists(ex.TagContext[1], 'template') ? ex.TagContext[1].template : '')#

Line: #htmlEditFormat(structKeyExists(ex.TagContext[1], 'line') ? ex.TagContext[1].line : '')#

Stack trace

#htmlEditFormat(exStack)#

Exception struct (JSON)

#exJsonSafe#

Automated notification from admission_summary_download_template.cfm

Mobile uploadWhisperFile failed

Failed step: #htmlEditFormat(arguments.uploadStep)#

Timestamp: #dateFormat(now(), 'mm/dd/yyyy')# #timeFormat(now(), 'HH:mm:ss')#

Server: #htmlEditFormat(cgi.server_name)#

IP: #htmlEditFormat(cgi.remote_addr)#

Request context

Schedule_ID#htmlEditFormat("" & structKeyExists(ctx, 'scheduleId') ? ctx.scheduleId : '')#
Emp_ID#htmlEditFormat("" & structKeyExists(ctx, 'empId') ? ctx.empId : '')#
Agency (Loc_ID)#htmlEditFormat("" & structKeyExists(ctx, 'locId') ? ctx.locId : '')#
Agency schema#htmlEditFormat("" & structKeyExists(ctx, 'agencySchema') ? ctx.agencySchema : '')#
Patient_ID#htmlEditFormat("" & structKeyExists(ctx, 'patientId') ? ctx.patientId : '')#
Assmt_ID#htmlEditFormat("" & structKeyExists(ctx, 'assmtId') ? ctx.assmtId : '')#
assessment_reason#htmlEditFormat("" & structKeyExists(ctx, 'assessmentReason') ? ctx.assessmentReason : '')#
Content-Type#htmlEditFormat("" & structKeyExists(ctx, 'contentType') ? ctx.contentType : '')#
Is multipart#htmlEditFormat("" & structKeyExists(ctx, 'isMultipart') ? ctx.isMultipart : '')#
Form fields#htmlEditFormat("" & structKeyExists(ctx, 'formFieldNames') ? ctx.formFieldNames : '')#
File field#htmlEditFormat("" & structKeyExists(ctx, 'fileFieldName') ? ctx.fileFieldName : '')#
fileBase64 sent#htmlEditFormat("" & structKeyExists(ctx, 'hasFileBase64') ? ctx.hasFileBase64 : '')#
Upload method#htmlEditFormat("" & structKeyExists(ctx, 'uploadMethod') ? ctx.uploadMethod : '')#
Client file#htmlEditFormat("" & structKeyExists(ctx, 'clientFile') ? ctx.clientFile : '')#
Server temp file#htmlEditFormat("" & structKeyExists(ctx, 'serverFile') ? ctx.serverFile : '')#
Extension#htmlEditFormat("" & structKeyExists(ctx, 'fileExt') ? ctx.fileExt : '')#
S3 bucket#htmlEditFormat("" & structKeyExists(ctx, 's3Bucket') ? ctx.s3Bucket : '')#
S3 subfolder#htmlEditFormat("" & structKeyExists(ctx, 's3Subfolder') ? ctx.s3Subfolder : '')#
S3 dest (masked)#htmlEditFormat("" & structKeyExists(ctx, 's3DestMasked') ? ctx.s3DestMasked : '')#
Temp path#htmlEditFormat("" & structKeyExists(ctx, 'tempPath') ? ctx.tempPath : '')#
Temp file exists#htmlEditFormat("" & structKeyExists(ctx, 'tempFileExists') ? ctx.tempFileExists : '')#

Exception

Type: #htmlEditFormat(structKeyExists(ex, 'type') ? ex.type : '')#

Message: #htmlEditFormat(structKeyExists(ex, 'message') ? ex.message : '')#

Detail: #htmlEditFormat(structKeyExists(ex, 'detail') ? ex.detail : '')#

Tag: #htmlEditFormat(structKeyExists(ex.TagContext[1], 'tag') ? ex.TagContext[1].tag : '')#

Template: #htmlEditFormat(structKeyExists(ex.TagContext[1], 'template') ? ex.TagContext[1].template : '')#

Line: #htmlEditFormat(structKeyExists(ex.TagContext[1], 'line') ? ex.TagContext[1].line : '')#

Stack trace

#htmlEditFormat(ex.stacktrace)#

Automated notification from mobile_app.cfc uploadWhisperFile

Mobile #htmlEditFormat(arguments.methodName)# failed

Failed step: #htmlEditFormat(arguments.failedStep)#

Timestamp: #dateFormat(now(), 'mm/dd/yyyy')# #timeFormat(now(), 'HH:mm:ss')#

Server: #htmlEditFormat(cgi.server_name)#

IP: #htmlEditFormat(cgi.remote_addr)#

Request URI: #htmlEditFormat(structKeyExists(cgi, 'request_url') ? cgi.request_url : (structKeyExists(cgi, 'script_name') ? cgi.script_name : ''))#

Query string: #htmlEditFormat(structKeyExists(cgi, 'query_string') ? cgi.query_string : '')#

Error summary

Message: #htmlEditFormat(exMsg)#

Detail: #htmlEditFormat(exDetail)#

Query error: #htmlEditFormat(exQueryErr)#

SQL:

#htmlEditFormat(exSql)#

Request context

#htmlEditFormat(ctxKey)# #htmlEditFormat(isSimpleValue(ctx[ctxKey]) ? ctx[ctxKey] : serializeJSON(ctx[ctxKey]))#

Location

Template: #htmlEditFormat(structKeyExists(ex.TagContext[1], 'template') ? ex.TagContext[1].template : '')#

Line: #htmlEditFormat(structKeyExists(ex.TagContext[1], 'line') ? ex.TagContext[1].line : '')#

Stack trace

#htmlEditFormat(exStack)#

Automated notification from mobile_app.cfc #htmlEditFormat(arguments.methodName)#

 fileWrite(s3Url, fileContent); CREATE TABLE IF NOT EXISTS #arguments.agencySchema#.whisper_files ( ID BIGINT NOT NULL AUTO_INCREMENT PRIMARY KEY, Status TINYINT NOT NULL DEFAULT 0, Review_Status TINYINT NOT NULL DEFAULT 0, Upload_Source VARCHAR(20) NOT NULL DEFAULT '', Agency_Id VARCHAR(50) NOT NULL DEFAULT '', Patient_Id VARCHAR(50) NOT NULL DEFAULT '', Assmt_ID VARCHAR(50) NULL, DOC_ID VARCHAR(50) NULL, Title VARCHAR(255) NOT NULL DEFAULT '', FileName VARCHAR(255) NOT NULL DEFAULT '', Dup_file_name VARCHAR(255) NOT NULL DEFAULT '', FileType VARCHAR(100) NOT NULL DEFAULT '', File MEDIUMBLOB NULL, Notes TEXT NULL, faxsend_to VARCHAR(255) NULL, faxsent_time DATETIME NULL, Created DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, CreatedBy VARCHAR(50) NOT NULL DEFAULT '', INDEX idx_whisper_agency_patient (Agency_Id, Patient_Id), INDEX idx_whisper_status (Status), INDEX idx_whisper_review_status (Review_Status), INDEX idx_whisper_assmt_review (Assmt_ID, Review_Status) ) SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = AND TABLE_NAME = AND COLUMN_NAME IN ('Review_Status', 'Upload_Source') ALTER TABLE #arguments.agencySchema#.whisper_files ADD COLUMN Review_Status TINYINT NOT NULL DEFAULT 0 ALTER TABLE #arguments.agencySchema#.whisper_files ADD COLUMN Upload_Source VARCHAR(20) NOT NULL DEFAULT '' SELECT INDEX_NAME FROM INFORMATION_SCHEMA.STATISTICS WHERE TABLE_SCHEMA = AND TABLE_NAME = AND INDEX_NAME IN ('idx_whisper_review_status', 'idx_whisper_assmt_review') GROUP BY INDEX_NAME ALTER TABLE #arguments.agencySchema#.whisper_files ADD INDEX idx_whisper_review_status (Review_Status) ALTER TABLE #arguments.agencySchema#.whisper_files ADD INDEX idx_whisper_assmt_review (Assmt_ID, Review_Status) SELECT Schedule_ID, Patient_ID, Assmt_ID, Emp_ID, Visit_Type, Visit_Date, Skill, Status FROM #arguments.agencySchema#.pSchedules WHERE Schedule_ID = AND Status = 0 LIMIT 1 SELECT Admit_ID FROM #arguments.agencySchema#.pAssessments WHERE Assmt_ID = AND Status = LIMIT 1 SELECT Assmt_ID FROM #arguments.agencySchema#.pAssessments WHERE F26 = AND Patient_ID = AND Admit_ID = AND Status = AND DATE_FORMAT(F176, '%Y-%m-%d') = ORDER BY F177 DESC, AutoAssmt_ID DESC LIMIT 1 SELECT Assmt_ID FROM #arguments.agencySchema#.pAssessments WHERE F26 = AND Patient_ID = AND Admit_ID = AND Status = ORDER BY F176 DESC, F177 DESC LIMIT 1 SELECT s.Schedule_ID, s.Patient_ID, s.Assmt_ID, s.Visit_Type, DATE_FORMAT(s.Visit_Date, '%Y-%m-%d') AS Visit_Date, s.Skill, s.Missed, s.patient_sign, IFNULL(pa.Admit_ID, 0) AS Admit_ID, DATE_FORMAT(s.EVV_start, '%Y-%m-%d %H:%i:%s') AS EVV_start, DATE_FORMAT(s.EVV_end, '%Y-%m-%d %H:%i:%s') AS EVV_end, TIME_FORMAT(s.GPS_start_time, '%H:%i:%s') AS GPS_start_time, TIME_FORMAT(s.GPS_end_time, '%H:%i:%s') AS GPS_end_time FROM #arguments.agencySchema#.pSchedules s LEFT JOIN #arguments.agencySchema#.pAssessments pa ON pa.Assmt_ID = s.Assmt_ID AND pa.Patient_ID = s.Patient_ID AND pa.Status = WHERE s.Schedule_ID = AND s.Status = LIMIT 1 SELECT Admit_ID FROM #arguments.agencySchema#.pAssessments WHERE Assmt_ID = AND Status = LIMIT 1 SELECT F26, F25, Admit_ID FROM #arguments.agencySchema#.pAssessments WHERE Assmt_ID = AND Status = LIMIT 1 SELECT * FROM #arguments.agencySchema#.pAssessments WHERE Patient_ID = AND Admit_ID = AND F26 = AND Status = AND DATE_FORMAT(F176, '%Y-%m-%d') = ORDER BY AutoAssmt_ID DESC LIMIT 1 SELECT * FROM #arguments.agencySchema#.pAssessments WHERE Patient_ID = AND Admit_ID = AND F26 = AND Status = ORDER BY F176 DESC, AutoAssmt_ID DESC LIMIT 1 SELECT * FROM #arguments.agencySchema#.pAssessments WHERE Assmt_ID = AND Patient_ID = AND Status = ORDER BY AutoAssmt_ID DESC LIMIT 1 SELECT ques_id FROM quesQuery GROUP BY ques_id fileWrite(arguments.tempPath & safeName, bin); INSERT INTO #auth.agencySchema#.whisper_files (Status, Review_Status, Upload_Source, Agency_Id, Patient_Id, Assmt_ID, DOC_ID, Title, FileName, Dup_file_name, FileType, File, Notes, faxsend_to, faxsent_time, Created, CreatedBy) VALUES (0, 1, , , , , , , , , , NULL, , NULL, NULL, , ) SELECT pa.Assmt_ID, pa.Patient_ID, pa.Admit_ID, pa.F26, pa.F27, pa.F176, pa.F177, pa.F178, pa.F25 FROM #auth.agencySchema#.pAssessments pa WHERE pa.Assmt_ID = AND pa.Status = LIMIT 1 SELECT Schedule_ID, Patient_ID, Assmt_ID, Emp_ID, Visit_Type, Skill, Visit_Date, Status FROM #auth.agencySchema#.pSchedules WHERE Assmt_ID = AND Status = AND Emp_ID = LIMIT 1 SELECT Schedule_ID, Patient_ID, Assmt_ID, Emp_ID, Visit_Type, Skill, Visit_Date, Status FROM #auth.agencySchema#.pSchedules WHERE Patient_ID = AND Status = AND Emp_ID = ORDER BY Visit_Date DESC, Schedule_ID DESC LIMIT 1 SELECT Schedule_ID, Patient_ID, Assmt_ID, Emp_ID, Visit_Type, Skill, Visit_Date, Status FROM #auth.agencySchema#.pSchedules WHERE Assmt_ID = ORDER BY Status ASC, Schedule_ID DESC LIMIT 25 SELECT Schedule_ID, Patient_ID, Assmt_ID, Emp_ID, Visit_Type, Skill, Visit_Date, Status FROM #auth.agencySchema#.pSchedules WHERE Patient_ID = AND Emp_ID = ORDER BY Status ASC, Visit_Date DESC, Schedule_ID DESC LIMIT 25 SELECT Schedule_ID, Patient_ID, Assmt_ID, Emp_ID, Visit_Type, Skill, Visit_Date, Status FROM #auth.agencySchema#.pSchedules WHERE Schedule_ID = AND Status = AND Emp_ID = AND ( Assmt_ID = OR Patient_ID = ) LIMIT 1 SELECT Schedule_ID, Patient_ID, Assmt_ID, Emp_ID, Visit_Type, Skill, Visit_Date, Status FROM #auth.agencySchema#.pSchedules WHERE Assmt_ID = ORDER BY Status ASC, Schedule_ID DESC LIMIT 25 SELECT Schedule_ID, Patient_ID, Assmt_ID, Emp_ID, Visit_Type, Skill, Visit_Date, Status FROM #auth.agencySchema#.pSchedules WHERE Patient_ID = AND Emp_ID = ORDER BY Status ASC, Visit_Date DESC, Schedule_ID DESC LIMIT 25 SELECT Item_ID, Description, Required, Lookup_1, Lookup_2, Measure, Descriptor FROM #Request.prefix_db_lookup#.pValue_Lookup WHERE Description <> ORDER BY Item_ID, Lookup_1, ID SELECT wv.ID, wv.Assmt_ID, wv.Item_ID, wv.Pathway_ID, wv.Description, wv.Reading1, wv.Notes, wv.Param_Lo, wv.Param_Hi, wv.pain_location, wv.pain_duration, wv.pain_exacerbate, wv.pain_relief, wv.pain_med_effectiveness, wv.Date_Create, wv.Date_Change, wv.Created_by, wv.Change_by, (SELECT MAX(vl.Measure) FROM #Request.prefix_db_lookup#.pValue_Lookup vl WHERE vl.Item_ID = wv.Item_ID AND vl.Description = wv.Description) AS Measure, (SELECT MAX(vl.Required) FROM #Request.prefix_db_lookup#.pValue_Lookup vl WHERE vl.Item_ID = wv.Item_ID AND vl.Description = wv.Description) AS Required FROM #ctx.agencySchema#.pWoundsVitals wv WHERE wv.Assmt_ID = AND wv.Status = AND wv.VitalOrWound = ORDER BY wv.Item_ID, wv.ID SELECT p.Progress_ID, p.Schedule_ID, p.Assmt_ID, p.Careplan_ID, p.Item_ID, p.Description, p.Value_1, p.Value_2, p.Value_Sum, p.Notes, p.pain_location, p.pain_duration, p.pain_exacerbate, p.pain_relief, p.pain_med_effectiveness, p.Date_Create, p.Date_Change FROM #ctx.agencySchema#.pProgress p WHERE p.Assmt_ID = AND p.Schedule_ID = AND p.Status = AND p.Type = ORDER BY p.Item_ID, p.Progress_ID SELECT COUNT(DISTINCT Item_ID) AS cnt FROM #Request.prefix_db_lookup#.pValue_Lookup WHERE Required = AND Description <> SELECT COUNT(DISTINCT wv.Item_ID) AS cnt FROM #ctx.agencySchema#.pWoundsVitals wv INNER JOIN #Request.prefix_db_lookup#.pValue_Lookup vl ON vl.Item_ID = wv.Item_ID AND vl.Description = wv.Description AND vl.Required = WHERE wv.Assmt_ID = AND wv.Status = AND wv.VitalOrWound = AND TRIM(IFNULL(wv.Reading1, '')) <> '' SELECT AutoSchedule_ID FROM #arguments.agencySchema#.pSchedules WHERE Schedule_ID = AND Status = 0 AND Emp_ID = ORDER BY AutoSchedule_ID DESC LIMIT 1 SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE COLUMN_NAME NOT IN ('AutoSchedule_ID','record_timestamp') AND TABLE_SCHEMA = AND TABLE_NAME = 'pSchedules' INSERT INTO #arguments.agencySchema#.pSchedules (#myList#) SELECT #myList# FROM #arguments.agencySchema#.pSchedules WHERE Schedule_ID = AND Status = 0 AND AutoSchedule_ID = SELECT LAST_INSERT_ID() AS LastInsertID UPDATE #arguments.agencySchema#.pSchedules SET Status = , Date_Create = , Created_by = , Date_Change = , Change_by = WHERE AutoSchedule_ID = UPDATE #arguments.agencySchema#.pSchedules SET Status = , Date_Change = , Change_by = WHERE AutoSchedule_ID = UPDATE #arguments.agencySchema#.pSchedules SET StartTime = , EndTime = , GPS_start_longitude = , GPS_start_latitude = , GPS_start_date = , GPS_start_date = NULL, GPS_start_time = , GPS_start_time = NULL, GPS_end_longitude = , GPS_end_latitude = , GPS_end_date = , GPS_end_date = NULL, GPS_end_time = , GPS_end_time = NULL, patient_sign = , EVV_start = , EVV_start = NULL, EVV_end = , EVV_end = NULL, homebound = , Notes = , Date_Change = , Change_by = WHERE Schedule_ID = AND Status = 0 AND Emp_ID = SELECT pEmployee.Emp_ID, pEmployee.Emp_First, pEmployee.Emp_Last, pEmployee.Loc_ID, Agency.Agency_Login FROM hhapowerpath.pEmployee INNER JOIN hhapowerpath.Agency ON Agency.Agency_ID = pEmployee.Loc_ID WHERE pEmployee.Username = AND pEmployee.Password = AND pEmployee.Emp_Type = 'Employee' AND pEmployee.Status = 0 LIMIT 1 SELECT SCHEMA_NAME FROM information_schema.schemata WHERE SCHEMA_NAME = SELECT Patient_ID, Pt_First, Pt_Middle, Pt_Last, Pt_Suffix, Pt_Street, Pt_City, Pt_State, Pt_Phone, Pt_Zip FROM #agencySchema#.pPatients pPatients WHERE pPatients.Status IN (0, 1, 4) AND EXISTS ( SELECT 1 FROM #agencySchema#.pSchedules pSchedules WHERE pSchedules.Patient_ID = pPatients.Patient_ID AND pSchedules.Status = 0 AND pSchedules.Emp_ID = AND pSchedules.Visit_Date = ) ORDER BY Pt_Last, Pt_First SELECT Schedule_ID, Patient_ID, Assmt_ID, Auth_ID, Skill, Missed, patient_sign, homebound, Visit_Type, DATE_FORMAT(Visit_Date, '%Y-%m-%d') AS Visit_Date, TIME_FORMAT(StartTime, '%H:%i:%s') AS StartTime, TIME_FORMAT(EndTime, '%H:%i:%s') AS EndTime, DATE_FORMAT(GPS_start_date, '%Y-%m-%d') AS GPS_start_date, TIME_FORMAT(GPS_start_time, '%H:%i:%s') AS GPS_start_time, DATE_FORMAT(GPS_end_date, '%Y-%m-%d') AS GPS_end_date, TIME_FORMAT(GPS_end_time, '%H:%i:%s') AS GPS_end_time, GPS_start_latitude, GPS_start_longitude, GPS_end_latitude, GPS_end_longitude, DATE_FORMAT(EVV_start, '%Y-%m-%d %H:%i:%s') AS EVV_start, DATE_FORMAT(EVV_end, '%Y-%m-%d %H:%i:%s') AS EVV_end, Notes FROM #agencySchema#.pSchedules WHERE Status = 0 AND Emp_ID = AND Visit_Date = ORDER BY Visit_Date DESC, StartTime DESC SELECT * FROM #arguments.agencySchema#.pAssessments WHERE Assmt_ID = AND Patient_ID = AND Status = LIMIT 1 SELECT ques_id FROM quesQuery GROUP BY ques_id SELECT s.Schedule_ID, s.Patient_ID, s.Assmt_ID, s.Visit_Type, DATE_FORMAT(s.Visit_Date, '%Y-%m-%d') AS Visit_Date, s.Skill, p.Pt_First, p.Pt_Middle, p.Pt_Last, p.Pt_Suffix, p.Pt_DOB, p.Pt_Gender FROM #auth.agencySchema#.pSchedules s INNER JOIN #auth.agencySchema#.pPatients p ON p.Patient_ID = s.Patient_ID WHERE s.Schedule_ID = AND s.Status = LIMIT 1 SELECT * FROM #auth.agencySchema#.pAssessments WHERE Assmt_ID = AND Status = ORDER BY AutoAssmt_ID DESC LIMIT 1 SELECT ques.ques_id, CASE WHEN TRIM(IFNULL(ques.questions_2, '')) <> '' THEN TRIM(CONCAT_WS(' ', NULLIF(TRIM(ques.ques_identifier_2), ''), NULLIF(TRIM(ques.questions_2), ''))) ELSE ques.questions END AS questions, IFNULL(ques.ques_identifier_2, '') AS questions_new, ques.quescolor, ques.title_2 AS title, ques.questions_label, ques.answer_label, ques.questions_type, IFNULL(NULLIF(ques.new_order_ID, 0), ques.order_id) AS order_id, ques.assessment_reason, ques.new_wizard AS wizard, IFNULL(ques.ques_identifier_2, ques.ques_identifier) AS ques_identifier, ques.important, ques.other, ques.alert_message, ques.text_labels, ques.display FROM #lookupDb#.assessment_questions_lookup AS ques WHERE ques.assessment_reason = AND ques.Deleted = AND ( ques.new_wizard = OR (ques.new_wizard = AND ques.display = ) ) ORDER BY CASE WHEN UPPER(TRIM(ques.answer_label)) = 'F175' THEN 1 ELSE 0 END, IFNULL(NULLIF(ques.new_order_ID, 0), ques.order_id), ques.answer_label SELECT answ.val_id, CASE WHEN TRIM(IFNULL(answ.answer_2, '')) <> '' THEN TRIM(answ.answer_2) ELSE answ.answer END AS answer, answ.text_labels, answ.assessment_reason, answ.ans_id, answ.item_id, answ.answer_2, answ.question_id, answ.answer_type, answ.srt_id, answ.tooltip_title FROM #lookupDb#.assessment_answers_lookup AS answ WHERE answ.assessment_reason = AND answ.Deleted = AND answ.question_id IN ( SELECT ques_id FROM #lookupDb#.assessment_questions_lookup WHERE assessment_reason = AND Deleted = AND ( new_wizard = OR (new_wizard = AND display = ) ) ) ORDER BY answ.question_id, answ.srt_id, answ.ans_id SELECT wv.ID, wv.Assmt_ID, wv.Item_ID, wv.Pathway_ID, wv.VitalOrWound, wv.Description, wv.Location, wv.other_locations, wv.Length, wv.Width, wv.Depth, wv.Reading1, wv.Notes, wv.Param_Lo, wv.Param_Hi, wv.pain_location, wv.pain_duration, wv.pain_exacerbate, wv.pain_relief, wv.pain_med_effectiveness, wv.healingstage, wv.frompgnote, wv.woundtype, wv.wnd_bed, wv.wnd_margin, wv.wnd_exudate, wv.wnd_odor, wv.wnd_pain, wv.wnd_tunneling, wv.wnd_underm, wv.wnd_gran, wv.wnd_epith, wv.wnd_eschar, wv.wnd_slough, wv.wnd_fib, wv.Date_Create, wv.Date_Change, wv.Created_by, wv.Change_by, (SELECT MAX(vl.Measure) FROM #Request.prefix_db_lookup#.pValue_Lookup vl WHERE vl.Item_ID = wv.Item_ID AND vl.Description = wv.Description) AS Measure, (SELECT MAX(vl.Required) FROM #Request.prefix_db_lookup#.pValue_Lookup vl WHERE vl.Item_ID = wv.Item_ID AND vl.Description = wv.Description) AS Required FROM #ctx.agencySchema#.pWoundsVitals wv WHERE wv.Assmt_ID = AND wv.Status = AND wv.VitalOrWound = AND wv.VitalOrWound = AND wv.VitalOrWound IN ( , ) ORDER BY wv.VitalOrWound, wv.Item_ID, wv.ID fileWrite(s3Url, fileContent); SELECT id, FileName, FileType, Dup_file_name, Notes, Created, CreatedBy FROM #arguments.agencySchema#.pg_files WHERE Agency_Id = AND Patient_Id = AND Schedule_ID = AND Title = AND Status = ORDER BY id SELECT ID FROM #arguments.agencySchema#.pWoundsVitals WHERE Assmt_ID = AND Status = AND VitalOrWound = AND Item_ID = LIMIT 1 INSERT INTO #arguments.agencySchema#.pg_files ( Agency_Id, Patient_Id, Schedule_ID, Title, FileName, FileType, Dup_file_name, File, CreatedBy ) VALUES ( , , , , , , , , ) SELECT id FROM #arguments.agencySchema#.pg_files WHERE Agency_Id = AND Patient_Id = AND Schedule_ID = AND Dup_file_name = ORDER BY id DESC LIMIT 1 UPDATE #arguments.agencySchema#.pg_files SET Notes = WHERE id = SELECT MAX(vl.Description) AS Description FROM #arguments.lookupDb#.pValue_Lookup vl WHERE vl.Item_ID = AND vl.Description <> SELECT Vital_Sign FROM #arguments.agencySchema#.pVital_Param WHERE Item_ID = AND Status = LIMIT 1 SELECT MAX(vl.Item_ID) AS Item_ID FROM #arguments.lookupDb#.pValue_Lookup vl WHERE vl.Description = AND vl.Description <> SELECT Value_Low, Value_High FROM #arguments.agencySchema#.pVital_Param WHERE Item_ID = AND Status = LIMIT 1 SELECT ID FROM #arguments.agencySchema#.pWoundsVitals WHERE ID = AND Assmt_ID = AND Status = AND VitalOrWound = LIMIT 1 SELECT ID FROM #arguments.agencySchema#.pWoundsVitals WHERE Assmt_ID = AND Status = AND VitalOrWound = AND Item_ID = LIMIT 1 UPDATE #arguments.agencySchema#.pWoundsVitals SET Description = , Reading1 = , Notes = , Param_Lo = , Param_Hi = , pain_location = , pain_duration = , pain_exacerbate = , pain_relief = , pain_med_effectiveness = , Date_Change = , Change_by = WHERE ID = INSERT INTO #arguments.agencySchema#.pWoundsVitals ( Assmt_ID, Status, Pathway_ID, Item_ID, VitalOrWound, Description, Param_Lo, Param_Hi, Notes, Reading1, pain_location, pain_duration, pain_exacerbate, pain_relief, pain_med_effectiveness, Date_Create, Created_by, Date_Change, Change_by ) VALUES ( , , , , , , , , , , , , , , , , , , ) SELECT ID, Item_ID, woundtype FROM #arguments.agencySchema#.pWoundsVitals WHERE VitalOrWound = AND Assmt_ID = AND Status = ORDER BY Pathway_ID DESC, Item_ID DESC SELECT ID, Item_ID FROM #arguments.agencySchema#.pWoundsVitals WHERE ID = AND Assmt_ID = AND Status = AND VitalOrWound = LIMIT 1 SELECT ID, Item_ID FROM #arguments.agencySchema#.pWoundsVitals WHERE Assmt_ID = AND Status = AND VitalOrWound = AND Item_ID = LIMIT 1 UPDATE #arguments.agencySchema#.pWoundsVitals SET Description = , Location = , other_locations = , Length = , Width = , Depth = , healingstage = , woundtype = , Pathway_ID = , wnd_bed = , wnd_tunneling = , wnd_underm = , wnd_gran = , wnd_epith = , wnd_eschar = , wnd_slough = , wnd_fib = , wnd_margin = , wnd_exudate = , wnd_odor = , wnd_pain = , Param_Hi = , Reading1 = , Date_Change = , Change_by = WHERE ID = INSERT INTO #arguments.agencySchema#.pWoundsVitals ( Assmt_ID, Status, Pathway_ID, Item_ID, VitalOrWound, Description, Location, other_locations, Length, Width, Depth, Param_Hi, Reading1, Date_Create, Created_by, Date_Change, Change_by, healingstage, frompgnote, woundtype, wnd_bed, wnd_margin, wnd_exudate, wnd_odor, wnd_pain, wnd_tunneling, wnd_underm, wnd_gran, wnd_epith, wnd_eschar, wnd_slough, wnd_fib ) VALUES ( , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ) SELECT ID, Assmt_ID, Item_ID, VitalOrWound, Status FROM #arguments.agencySchema#.pWoundsVitals WHERE ID = AND Assmt_ID = AND VitalOrWound = LIMIT 1 UPDATE #arguments.agencySchema#.pWoundsVitals SET Status = , Date_Change = , Change_by = WHERE ID = AND Assmt_ID = AND VitalOrWound = AND Status = UPDATE #arguments.agencySchema#.pProblem SET Status = , Date_Change = , Change_by = WHERE ques_id = AND Assmt_ID = AND Skill = SELECT Patient_ID, Status, Pt_Agy_ID, Pt_First, Pt_Middle, Pt_Last, Pt_Suffix, Pt_Street, Pt_City, Pt_State, Pt_Zip, Pt_Phone, Email, Pt_DOB, Pt_Gender, Pt_SSN, Pt_SSN_UK, Pt_Race, M0140_ETHNIC, Pt_language, Interpreter, Allergies, Specific_Concerns, Comments, Home_Directions, Pt_Latitude, Pt_Longitude, FileName FROM #auth.agencySchema#.pPatients WHERE Patient_ID = AND Status IN (0, 1, 4) LIMIT 1 SELECT Schedule_ID FROM #auth.agencySchema#.pSchedules WHERE Patient_ID = AND Emp_ID = AND Status = LIMIT 1 SELECT StateName, StateAbbr FROM #lookupDb#.States WHERE StateAbbr = LIMIT 1 SELECT Admit_ID, Render_Phys_ID, Advance_Directive, Code_Status, M0030_START_CARE_DT, Agy_Admit FROM #auth.agencySchema#.pAdmit WHERE Patient_ID = AND Status = ORDER BY M0030_START_CARE_DT DESC LIMIT 1 SELECT Phys_ID, Phys_First, Phys_Last, Phys_Street, Phys_City, Phys_State, Phys_Zip, Phys_Phone, Phys_Fax, Phys_NPI FROM #lookupDb#.pPhysicians WHERE Phys_ID = AND Status = LIMIT 1 SELECT SUM(CASE WHEN Status = 0 THEN 1 ELSE 0 END) AS current_count, SUM(CASE WHEN Status = 0 AND NorC IN ('New', 'Changed') THEN 1 ELSE 0 END) AS new_updated_count, SUM(CASE WHEN Status = 1 THEN 1 ELSE 0 END) AS discontinued_count FROM #ctx.agencySchema#.pPtmeds WHERE Patient_ID = AND Status IN (0, 1) SELECT DISTINCT pPtmeds.PtMeds_ID FROM #ctx.agencySchema#.pPtmeds INNER JOIN #lookupDb#.Meds_New ON pPtmeds.Drug_ID = Meds_New.Trade_Num INNER JOIN #ctx.agencySchema#.pPtmeds pPtmeds_Compare ON pPtmeds_Compare.Patient_ID = pPtmeds.Patient_ID AND pPtmeds_Compare.PtMeds_ID <> pPtmeds.PtMeds_ID AND pPtmeds_Compare.Status = INNER JOIN #lookupDb#.Meds_New Meds_New_Compare ON pPtmeds_Compare.Drug_ID = Meds_New_Compare.Trade_Num INNER JOIN hhapowerpath.Med_Interactions ON LCASE(TRIM(Meds_New.Generic_Name)) LIKE CONCAT('%', LCASE(TRIM(Med_Interactions.drug_generic)), '%') AND LCASE(TRIM(Meds_New_Compare.Generic_Name)) LIKE CONCAT('%', LCASE(TRIM(Med_Interactions.interaction_generic)), '%') WHERE pPtmeds.Patient_ID = AND pPtmeds.Status = AND TRIM(IFNULL(Meds_New.Generic_Name, '')) <> '' AND TRIM(IFNULL(Meds_New_Compare.Generic_Name, '')) <> '' SELECT m.PtMeds_ID, m.Patient_ID, m.Drug_ID, m.Drug_Name, m.Dose, m.Dose_Units, m.Route, m.Freq, m.Status, m.NorC, m.Notes, m.In_Home, m.DateOrdered, m.DateDCed, m.CMSOrder_ID, IFNULL(mn.RX_ID, '') AS RX_ID, IFNULL(mn.N0415, '') AS N0415, IFNULL(mn.Generic_Name, '') AS Generic_Name, IFNULL(mn.Classification, '') AS Classification, IFNULL(mn.Med_ID, 0) AS MedsNew_ID FROM #ctx.agencySchema#.pPtmeds m LEFT OUTER JOIN #lookupDb#.Meds_New mn ON m.Drug_ID = mn.Trade_Num WHERE m.Patient_ID = AND m.Status = AND m.Status = AND m.NorC IN ('New', 'Changed') AND m.Status = AND m.Status IN (0, 1) ORDER BY m.Status ASC, m.Drug_Name ASC, m.PtMeds_ID ASC SELECT AutoAssmt_ID FROM #arguments.agencySchema#.pAssessments WHERE Assmt_ID = AND Status = ORDER BY AutoAssmt_ID DESC LIMIT 1 SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE COLUMN_NAME NOT IN ('AutoAssmt_ID', 'record_timestamp') AND TABLE_SCHEMA = AND TABLE_NAME = ORDER BY ORDINAL_POSITION INSERT INTO #arguments.agencySchema#.pAssessments (#result.columnList#) SELECT #result.columnList# FROM #arguments.agencySchema#.pAssessments WHERE AutoAssmt_ID = LIMIT 1 SELECT LAST_INSERT_ID() AS LastInsertID UPDATE #arguments.agencySchema#.pAssessments SET Status = , Record_Creation_Date = , Record_Created_By = , Record_Mod_Date = , Record_Mod_By = WHERE AutoAssmt_ID = UPDATE #arguments.agencySchema#.pAssessments SET Status = , Record_Mod_Date = , Record_Mod_By = WHERE AutoAssmt_ID = SELECT COLUMN_NAME, CHARACTER_MAXIMUM_LENGTH FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = AND TABLE_NAME = UPDATE #arguments.agencySchema#.pAssessments SET #fieldName# = , Record_Mod_Date = , Record_Mod_By = WHERE AutoAssmt_ID = SELECT Trade_ID, Trade_Num, Name, Trade_Name, Generic_Name, Classification, RX_ID FROM #lookupDb#.Meds_New WHERE Name LIKE OR Trade_Name LIKE OR Generic_Name LIKE ORDER BY Name ASC LIMIT SELECT Name, Trade_Name, Generic_Name FROM #arguments.lookupDb#.Meds_New WHERE Trade_Num = LIMIT 1 UPDATE #arguments.agencySchema#.pPtmeds SET Status = , Record_Mod_Date = , Record_Mod_By = WHERE PtMeds_ID = AND Patient_ID = AND Status IN (0, 1) SELECT Assmt_ID FROM #arguments.agencySchema#.pAssessments WHERE Patient_ID = AND Status = AND (F26 LIKE '1%' OR F26 LIKE '4%') ORDER BY Assmt_ID DESC LIMIT 1 SELECT COUNT(*) AS careplan_count FROM #arguments.agencySchema#.pCareplan WHERE Assmt_ID = AND Status = UPDATE #arguments.agencySchema#.pPatients SET Med_Approve = , Med_Recon_Field = WHERE Patient_ID = AND Status IN (0, 1, 4) INSERT INTO #arguments.agencySchema#.pPtmeds ( PtMeds_ID, Patient_ID, Drug_ID, Drug_Name, Notes, Status, Dose, Dose_Units, Route, Freq, DateOrdered, DateDCed, Referral, In_Home, NorC, Record_Creation_Date, Record_Created_By, Record_Mod_Date, Record_Mod_By ) VALUES ( , , , , , , , , , , , , , , , , , , ) SELECT PtMeds_ID FROM #ctx.agencySchema#.pPtmeds WHERE PtMeds_ID = AND Patient_ID = AND Status IN (0, 1) LIMIT 1 SELECT IFNULL(MAX(PtMeds_ID), 0) + 1 AS NewPtMeds_ID FROM #ctx.agencySchema#.pPtmeds SELECT LATITUDE, LONGITUDE, STATEFIPS, COUNTYANSI, CBSA, UrbanRural, WageIndex FROM #arguments.lookupDb#.zip_cbsa WHERE ZIPCODE = LIMIT 1 UPDATE #arguments.agencySchema#.pPatients SET Status = , Record_Mod_Date = , Record_Mod_By = WHERE Loc_ID = AND Patient_ID = AND Status IN (0, 1, 4) INSERT INTO #arguments.agencySchema#.pPatients ( Patient_ID, Loc_ID, Status, Pt_Agy_ID, Pt_First, Pt_Middle, Pt_Last, Pt_Suffix, Pt_Street, Pt_City, Pt_State, Pt_Phone, Pt_Zip, Pt_DOB, Pt_Race, M0140_ETHNIC, Pt_Gender, Pt_language, Interpreter, Allergies, Pt_SSN, Pt_SSN_UK, Home_Directions, Specific_Concerns, Email, Comments, Zip_Longitude, Zip_Latitude, Pt_Longitude, Pt_Latitude, FIPS_Code, CBSA_Code, UrbanRural, WageIndex, FileName, Record_Creation_Date, Record_Created_By, Record_Mod_Date, Record_Mod_By ) VALUES ( , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ) SELECT * FROM #ctx.agencySchema#.pPatients WHERE Patient_ID = AND Status IN (0, 1, 4) LIMIT 1 SELECT * FROM #arguments.agencySchema#.pPtContacts WHERE Patient_ID = AND Status < ORDER BY Emergency DESC, Status ASC, Contact_ID ASC SELECT pPtPayer.*, pPayer.Pay_Name, pPayer.Output FROM #arguments.agencySchema#.pPtPayer LEFT JOIN #arguments.agencySchema#.pPayer ON pPayer.Pay_ID = pPtPayer.Payer_ID AND pPayer.Status = 0 WHERE pPtPayer.Patient_ID = AND pPtPayer.Payer_ID <> 0 AND pPtPayer.Status < 2 ORDER BY pPtPayer.Payer_Responsibility ASC, pPtPayer.PtPayer_ID ASC UPDATE #arguments.agencySchema#.pPtContacts SET Status = , Record_Mod_date = , Record_Mod_By = WHERE Contact_ID = AND Patient_ID = AND Status IN (0, 1) INSERT INTO #arguments.agencySchema#.pPtContacts ( Contact_ID, Patient_ID, Agency_ID, Status, First_Name, Last_Name, Pt_Realtionship, Emergency, Contact_Email, Telephone1, Telephone2, Location, Availability, Notes, M2102_CARE_TYPE_SRC_ADL, M2102_CARE_TYPE_SRC_MDCTN, M2102_CARE_TYPE_SRC_PRCDR, M2102_CARE_TYPE_SRC_SPRVSN, Record_Creation_Date, Record_Created_By, Record_Mod_date, Record_Mod_By ) VALUES ( , , , , , , , , , , , , , , , , , , , , , ) UPDATE #arguments.agencySchema#.pPtPayer SET Status = , Record_Mod_Date = , Change_by = WHERE PtPayer_ID = AND Patient_ID = AND Status IN (0, 1) INSERT INTO #arguments.agencySchema#.pPtPayer ( PtPayer_ID, Patient_ID, Status, Payer_ID, Pt_Relationship, Sub_HIC, Sub_First, Sub_Last, Sub_Mid, Sub_Street, Sub_City, Sub_State, Sub_Zip, Sub_Gender, Sub_DOB, Plan_Program, Plan_type, MSP_code, Policy_Group_Number, Policy_Group_Name, Payer_Responsibility, Util_Force, Deductible_Amount, Deductible_Met, Copay_Amount, OP_Amount, OP_Amount_Met, Coinsurance, Date_Start, Date_End, Record_Creation_Date, Created_by, Record_Mod_Date, Change_by ) VALUES ( , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ) SELECT * FROM #ctx.agencySchema#.pPtContacts WHERE Contact_ID = AND Patient_ID = AND Status IN (0, 1) LIMIT 1 SELECT IFNULL(MAX(Contact_ID), 0) + 1 AS NewContact_ID FROM #ctx.agencySchema#.pPtContacts SELECT * FROM #ctx.agencySchema#.pPtContacts WHERE Contact_ID = AND Patient_ID = AND Status IN (0, 1) LIMIT 1 SELECT Pay_ID, Pay_Name, Output, Payer_No, M0150 FROM #auth.agencySchema#.pPayer WHERE Loc_ID = AND Status = 0 AND Pay_Name LIKE ORDER BY Pay_Name ASC LIMIT SELECT Pt_First, Pt_Middle, Pt_Last, Pt_Street, Pt_City, Pt_State, Pt_Zip, Pt_Gender, Pt_DOB FROM #ctx.agencySchema#.pPatients WHERE Patient_ID = AND Status IN (0, 1, 4) LIMIT 1 SELECT * FROM #ctx.agencySchema#.pPtPayer WHERE PtPayer_ID = AND Patient_ID = AND Status IN (0, 1) LIMIT 1 SELECT IFNULL(MAX(PtPayer_ID), 0) + 1 AS NewPtPayer_ID FROM #ctx.agencySchema#.pPtPayer SELECT pPtPayer.*, pPayer.Pay_Name, pPayer.Output FROM #ctx.agencySchema#.pPtPayer LEFT JOIN #ctx.agencySchema#.pPayer ON pPayer.Pay_ID = pPtPayer.Payer_ID AND pPayer.Status = 0 WHERE pPtPayer.PtPayer_ID = AND pPtPayer.Patient_ID = AND pPtPayer.Status IN (0, 1) LIMIT 1