Centricity SQL Queries
| Add | Order | Name / Notes | |
|---|---|---|---|
| Edit | Run | 0 |
DBs with procedure (99512) setup
|
| Edit | Run | 0 |
Visits where Korsuva was billed
|
| Edit | Run | 0 |
Calcitriol setups
|
| Edit | Run | 1 |
PHOS BINDER procedures in Patient Visits
Shows all the occurrences of the PHOS BINDER procedure in all the patient visits |
| Edit | Run | 5 |
Visits with value code 68 or 80 - used to see which clients were manually adding these
|
| Edit | Run | 10 |
get custom rules (SAVE)
|
| Edit | Run | 10 |
Dupe AY Modifiers defined
|
| Edit | Run | 10 |
Logged in CPS users
This will show who is logged into every Centricpty/athenaPractice database, based on their Centricity/athenaPractice user, NOT their active directory user |
| Edit | Run | 12 |
Databases where Race is required
|
| Edit | Run | 18 |
KEEP - Phos Binder TDAPA $
|
| Edit | Run | 18 |
Visits with CPT Code j0911
|
| Edit | Run | 22 |
Ins Carriers with a value in the ledger field
|
| Edit | Run | 99 |
KEEP - Lists Ins carrier along with Ledger field and Collections Group
Shows the status of the ledger field for each insurance carrier |
| Edit | Run | 100 |
J0607 & J0608 codes in ProceduresFeeSchedule table
|
| Edit | Run | 175 |
DBs without license and patient count
|
| Edit | Run | 999 |
Phos binder Fee Schedules
|