| Description |
SQL
Query (please drag select and copy to your clipboard) to
paste into:
C:\Program Files\Chirosoft\Applications\SQLExec32.exe
Double-click on the SQLExec32.exe by finding it via "My
Computer". Then, in SQLExec32.exe, paste the desired SQL query
and click "Execute" to run.
WARNING: You MUST have a backup of your data before running
any query. These queries are not reversible at any price. Your
backup is your only solution if you run something by accident.
Please be careful! |
| In ChiroOffice's procedure catalog, this
changes all SERVICE and PRODUCT procedures to a status of "Inactive".
This is intended for a user to inactivate all codes and then manually
activate their small number of codes. |
UPDATE tblProcedure INNER JOIN
tblProcedureCategory ON tblProcedure.Category = tblProcedureCategory.ID SET
tblProcedure.Status = "Inactive"
WHERE (((tblProcedureCategory.Type)="S")) OR (((tblProcedureCategory.Type)="P")); |
| This changes all entries in the
diagnosis catalog to "Inactive". This way, a user can
activate the limited number of diagnoses used. |
UPDATE tblDiagnosis SET tblDiagnosis.Status = "Inactive"; |
| In ChiroOffice, this initializes
all treatment plan packages with a zero slot value to a value of one. |
UPDATE tblCPVModality SET
tblCPVModality.Slot = 1
WHERE (((tblCPVModality.Slot)=0)); |
| In ChiroOffice or ChiroPad, delete
all patients from the signed-in list. |
DELETE tblCheckIn.*
FROM tblCheckIn; |
| In ChiroOffice, this changes all
transactions with a TOS of "9" to a TOS of "1". |
UPDATE tblTransaction SET tblTransaction.TOS = "1"
WHERE (((tblTransaction.TOS)="9")); |
| This query deletes all SOAP
finding records that have been entered with a date more futuristic than now.
This is user when a user's computer time was dated in the future, likely due
to a battery problem. |
DELETE CP_DSD.ReplicationModified
FROM CP_DSD
WHERE (((CP_DSD.ReplicationModified)>Now())); |
| Delete old plain text format notes
from Summer 2002 or later database. WARNING: NEVER RUN THIS ON A
DATABASE FROM A SOFTWARE RELEASE EARLIER THAN SUMMER 2002. |
DELETE CP_DSI.Chart
FROM CP_DSI
WHERE (((CP_DSI.Chart) Not Like "")); |
| Globally change form type of
Internet Disk Image to form type of HCFA 1500. Note: THIS IS NOT
REVERSIBLE IN MOST CASES. |
UPDATE tblClaimCarrierDetail SET
tblClaimCarrierDetail.FormType = 0
WHERE (((tblClaimCarrierDetail.FormType)=2));
UPDATE tblThirdParty SET tblThirdParty.FormType = 0
WHERE (((tblThirdParty.FormType)=2)); |
| Globally change specific carriers
to Internet Disk Image form type. Example involves three carriers:
United Health Care (UHC), Aetna (AETNA), and Cigna (CIGNA). The
capitalized ID's are the catalog ID's of the carriers. Note:
This is not reversible in most cases. |
UPDATE tblClaimCarrierDetail INNER
JOIN tblThirdParty ON tblClaimCarrierDetail.CarrierCreated =
tblThirdParty.Created SET tblClaimCarrierDetail.FormType = 2,
tblThirdParty.FormType = 2
WHERE (((tblThirdParty.ID)="UHC")) OR (((tblThirdParty.ID)="AETNA")) OR (((tblThirdParty.ID)="CIGNA"));
|
|
Sets all patients to NOT print a receipt automatically.
|
UPDATE tblFinancial
SET tblFinancial.Receipt=0;
|
