INSERT IGNORE INTO #Request.prefix_db_agency#.pPtPayer
(
Patient_ID,Status,Payer_ID,Record_Creation_Date,Created_by,Record_Mod_Date,Change_by
)
VALUES
(
,
,
,
,
,
,
)
SELECT LAST_INSERT_ID() as PtPayer_ID
INSERT IGNORE INTO #Request.prefix_db_agency#.pAdmit
(
Patient_ID,Status,Date_Create,Created_by,Date_Change,Change_by
)
VALUES
(
,
,
,
,
,
)
SELECT LAST_INSERT_ID() as PtAdmit_ID
SELECT IFNULL(MAX(Assmt_ID),0)+1 As pAssmt_ID FROM #Request.prefix_db_agency#.pAssessments
INSERT IGNORE INTO #Request.prefix_db_agency#.pAssessments
(
Assmt_ID,Admit_ID,Patient_ID,Loc_ID,status,F26,F176,F177,F178,Record_Creation_Date,Record_Created_By,Record_Mod_Date,Record_Mod_By
)
VALUES
(
,
,
,
,
,
,
,
,
,
,
,
,
)
INSERT INTO #Request.prefix_db_agency#.pAuths
(
Patient_ID,Assmt_ID,PtPayer_ID,Status,Skill,Total_Visits,Date_Create,Created_by,Date_Change,Change_by
)
VALUES
(
,
,
,
,
,
,
,
,
,
)
SELECT LAST_INSERT_ID() as Auth_ID
INSERT IGNORE INTO #Request.prefix_db_agency#.pSchedule
(
Patient_ID, Auth_ID, PtPayer_ID, Pay_ID,Status, Skill, Visit_no, Date_Create, Created_by, Date_Change, Change_by
)
VALUES
(
,
,
,
,
,
,
,
,
,
,
)
SELECT * FROM #Request.prefix_db_agency#.pAssessments
WHERE
Patient_ID =
AND Assmt_ID =
UPDATE #Request.prefix_db_agency#.pAssessments
SET
status = ,
Record_Mod_Date = ,
Record_Mod_By =
WHERE
Patient_ID =
AND Assmt_ID =
INSERT IGNORE INTO #Request.prefix_db_agency#.pAssessments
(
Assmt_ID,Admit_ID,Patient_ID,Loc_ID,status,F26,F176,F177,F178,Record_Creation_Date,Record_Created_By,Record_Mod_Date,Record_Mod_By
)
VALUES
(
,
,
,
,
,
,
,
,
,
,
,
,
)
SELECT * FROM #Request.prefix_db_agency#.pAuths
WHERE Patient_ID =
AND Assmt_ID =
SELECT * FROM getpAuth WHERE Skill =
UPDATE #Request.prefix_db_agency#.pAuths
SET
Total_Visits = ,
Date_Change = ,
Change_by =
WHERE
Patient_ID =
AND Assmt_ID =
AND Skill =
SELECT * FROM #Request.prefix_db_agency#.pSchedule
WHERE Patient_ID =
AND Auth_ID =
AND PtPayer_ID =
SELECT * FROM getpSchedule
WHERE Skill =
AND Visit_no =
UPDATE #Request.prefix_db_agency#.pSchedule
SET Status = ,
Date_Change = ,
Change_by =
WHERE Schedule_ID =
INSERT IGNORE INTO #Request.prefix_db_agency#.pSchedule
(
Patient_ID, Auth_ID, PtPayer_ID, Pay_ID,Status, Skill, Visit_no, Date_Create, Created_by, Date_Change, Change_by
)
VALUES
(
,
,
,
,
,
,
,
,
,
,
)
UPDATE #Request.prefix_db_agency#.pSchedule
SET
Status = ,
Date_Change = ,
Change_by =
WHERE
Patient_ID =
AND Auth_ID =
AND PtPayer_ID =
AND Skill =
AND Visit_no =