SELECT * FROM #Request.prefix_db_agency#.pSchedules
WHERE Schedule_ID =
AND status = 0
SELECT * FROM #Request.prefix_db_lookup#.Adjustment_codes_lookup
WHERE Status = 0
SELECT * FROM #Request.prefix_db_agency#.Visits_payments
WHERE Schedule_ID =
AND Payment_ID =
AND status = 0
SELECT * FROM #Request.prefix_db_lookup#.Adjustment_codes_lookup
WHERE Status = 0
UPDATE #Request.prefix_db_agency#.pSchedules
SET
payment = '#arguments.payment#',
payment = '0.00',
write_offamount = '#arguments.write_offamount#',
write_offamount = '0.00',
write_offcode = '#arguments.write_offcode#',
write_offcodesecond = '#arguments.write_offcodesecond#',
second_write_offamount = '#arguments.second_write_offamount#',
second_write_offamount = '0.00',
second_write_offcode = '#arguments.second_write_offcode#',
second_write_offcodesecond = '#arguments.second_write_offcodesecond#',
third_write_offamount = '#arguments.third_write_offamount#',
third_write_offamount = '0.00',
third_write_offcode = '#arguments.third_write_offcode#',
third_write_offcodesecond = '#arguments.third_write_offcodesecond#',
fourth_write_offamount = '#arguments.fourth_write_offamount#',
fourth_write_offamount = '0.00',
fourth_write_offcode = '#arguments.fourth_write_offcode#',
fourth_write_offcodesecond = '#arguments.fourth_write_offcodesecond#',
Date_Change = ,
Change_by =
WHERE Schedule_ID =
AND status = 0
SELECT 1 AS n FROM #Request.prefix_db_agency#.Payments
WHERE Payment_ID =
AND IFNULL(Payment_Lock,0) = 1
UPDATE #Request.prefix_db_agency#.Visits_payments
SET Status = 2
WHERE Schedule_ID =
AND Payment_ID =
AND status = 0
INSERT INTO #Request.prefix_db_agency#.Visits_payments
(
Schedule_ID, Payment_ID,payment,write_offamount,write_offcode,write_offcodesecond,second_write_offamount,second_write_offcode,
second_write_offcodesecond,third_write_offamount,third_write_offcode,third_write_offcodesecond,
fourth_write_offamount, fourth_write_offcode,fourth_write_offcodesecond,adjust_contract_balance,
Date_Create,Created_by,Date_Change,Change_by
)
VALUES
(
,
,
'#arguments.payment#''0.00',
'#arguments.write_offamount#''0.00',
,
,
'#arguments.second_write_offamount#''0.00',
,
,
'#arguments.third_write_offamount#''0.00',
,
,
'#arguments.fourth_write_offamount#''0.00',
,
,
,
,
,
,
)
SELECT * FROM #Request.prefix_db_lookup#.cron_835
WHERE Agency_ID = '#session.agencyid#'
AND status = 0
AND Remit_No = '#arguments.Remit_No#'
AND CLP_ID = '#arguments.CLP_ID#'
ORDER BY Remit_No ASC
INSERT into #Request.prefix_db_agency#.pDeposit
(Date_Deposit,Payer_ID, Date_Create,Date_Check, Deposit_Type, Check_Total, Remit_No,
Internal_Control_number,HCPCS,Writeoff_Amount,Visit_Date,
Pay_Name, Net_Total, Record_Created_Date, Record_Modified_Date)
VALUES
('#Date_Deposit#','#Payer_ID#','#toddaydate#','#Date_Check#','#Deposit_Type#', '#Check_Total#','#Remit_No#',
'#ICN#','#Revenue_Code#','#Dep_Writeoff_Amount#','#Visit_Date#',
'#Pay_Name#','#Net_Total#', #now()#,#now()#)
UPDATE #Request.prefix_db_agency#.Invoices
SET outlier = '#Adjustment_Amount_2#'
WHERE Internal_control_number = '#ICN#'
AND (IFNULL(Invoice_Lock,0) <> 1)
UPDATE #Request.prefix_db_agency#.Invoices
SET Seq_Amount = '#Seq_Amount#',
Seq_code = '#Seq_Code#'
WHERE Invoice_ID = '#Invoice_ID#'
AND (IFNULL(Invoice_Lock,0) <> 1)
SELECT Invoice_ID FROM #Request.prefix_db_agency#.Invoices
WHERE Internal_control_number = '#ICN#'
AND deleted <> 1
SELECT Invoice_ID,Seq_Amount,Seq_code,outlier FROM #Request.prefix_db_agency#.Invoices
WHERE Invoice_ID = '#Invoice_ID#'
INSERT INTO #Request.prefix_db_agency#.Payments(
Invoice_ID, PatientPayer_ID, PaymentDate, Amount, PaymentMethod, EFT_Amount, EFT_No, Claim,
Pay_Seq_Amount,Pay_Seq_Code,Pay_outlier,
Comments, WriteOffAmount, WriteOffType, Deleted, Internal_control_number)
VALUES
('#Invoice_ID#','#Payer_ID#','#Date_Deposit#', '#total_paymentamount#','Electronic','#Check_Total#','#Remit_No#',
'#ICN#','#get_inv.Seq_Amount#','#get_inv.Seq_code#', '#get_inv.outlier#',
'Auto claim payment processing', '#total_WriteOffAmount#','#Adjustment_Code#', 0, '#ICN#')
SELECT LAST_INSERT_ID() as LastInsertID
INSERT INTO #Request.prefix_db_agency#.Visits_payments
(
Schedule_ID, Payment_ID,payment,write_offamount,write_offcode,write_offcodesecond,
Date_Create,Created_by,Date_Change,Change_by
)
VALUES
(
,
,
'#Paid_amount#''0.00',
'#Adjustment_Amount#''0.00',
,
,
,
,
,
)
UPDATE #Request.prefix_db_lookup#.cron_835
SET payment_pushed = 1
WHERE Agency_ID = '#session.agencyid#'
AND status = 0
AND Remit_No = '#arguments.Remit_No#'
AND CLP_ID = '#arguments.CLP_ID#'
AND ICN NOT IN ()
UPDATE #Request.prefix_db_lookup#.cron_835
SET status = 1
WHERE Agency_ID =
AND status = 0
AND payment_pushed = 0
AND Remit_No =
AND CLP_ID =
UPDATE #Request.prefix_db_agency#.Payments SET
Payment_Lock =
,Record_Modified_By =
,Record_Modified_Date = #now()#
WHERE Payment_ID =
AND Invoice_ID IN (SELECT Invoice_ID FROM #Request.prefix_db_agency#.Invoices WHERE Agency_ID = AND Deleted <> 1)
UPDATE #Request.prefix_db_agency#.Payments
SET Deleted =
WHERE Payment_ID =
AND Invoice_ID =
AND (IFNULL(Payment_Lock,0) <> 1)
SELECT COLUMN_NAME
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_SCHEMA='#Request.prefix_db_agency#' AND TABLE_NAME = 'Payments'
AND COLUMN_NAME NOT IN ('cdate_cdarte')
INSERT INTO #Request.prefix_db_agency#.Payments_history
(#myList#)
SELECT #myList# FROM #Request.prefix_db_agency#.Payments
WHERE Payment_ID IN ()
SELECT LAST_INSERT_ID() as LastInsertID
UPDATE #Request.prefix_db_agency#.Payments_history
SET record_timestamp = #now()#
WHERE Pay_his_ID = #Pay_his_ID#
SELECT COLUMN_NAME
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_SCHEMA='#Request.prefix_db_agency#' AND TABLE_NAME = 'Invoices'
AND COLUMN_NAME NOT IN ('cdate_cdarte');
INSERT INTO #Request.prefix_db_agency#.Invoices_history
(#myList#)
SELECT #myList# FROM #Request.prefix_db_agency#.Invoices
WHERE Invoice_ID IN ()
SELECT LAST_INSERT_ID() as LastInsertID
UPDATE #Request.prefix_db_agency#.Invoices_history
SET record_timestamp = #now()#
WHERE Inv_his_ID = #Inv_his_ID#
SELECT i.Invoice_Id, IFNULL(i.Invoice_Lock, 0) AS Invoice_Lock
FROM #Request.prefix_db_agency#.Invoices i
WHERE i.Invoice_Id =
AND i.Agency_Id =
AND i.Deleted <> 1
UPDATE #Request.prefix_db_agency#.Invoices
SET ContractTotal = ,
Record_Modified_By = ,
Record_Modified_Date =
WHERE Invoice_Id =
AND Agency_Id =
AND IFNULL(Invoice_Lock, 0) <> 1
UPDATE #Request.prefix_db_agency#.pAssessments
SET F299 = ,
F298 =
WHERE Assmt_ID =
AND Status = 0