-
Notifications
You must be signed in to change notification settings - Fork 0
/
db_tables.txt
343 lines (343 loc) · 5.62 KB
/
db_tables.txt
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
act_proc_matrix_dsc
activity
activity_detail
activity_detail_dsc
activity_dsc
activity_error
activity_log
activity_procedure_addon
activity_procedure_clm
activity_procedure_clm_mod
activity_procedure_matrix
activity_program_matrix
addendum
address
admin_co_pay
admin_co_pay_matrix
admin_co_pay_matrix_lic
admin_group
admin_order_status
alert
allergy_entry
audit_dataedit
audit_delete_values
audit_log
audit_page_title
audit_row_delete
cash_sheet
cash_sheet_line
cf_data
cf_data_hist
claim
claim_batch
claim_batch_line
claim_bill_next
claim_bill_next_item
claim_diag
claim_engine_run
claim_error
claim_followup_comment
claim_item
claim_item_activity
claim_item_edit_audit
claim_item_line
claim_item_modifier
claim_note
claim_rollup
claim_value_code
client
client_allergy
client_auth_proc_modif
client_auth_procedure
client_balance
client_black_box
client_black_box_staff
client_co_pay
client_co_pay_matrix
client_co_pay_matrix_lic
client_consent
client_episode
client_episode_org_map
client_episode_prefs
client_episode_triag
client_group
client_guarantor
client_guarantor_mix
client_liability
client_liability_mem
client_liability_mem_exp
client_medication
client_message
client_payer_auth
client_payer_plan
client_payer_plan_date
client_pcp
client_pharmacy
client_program
client_program_code
client_program_date
client_program_unbillable
client_provider
client_record_inv
client_record_inv_change
client_relationship
client_scanned_document
client_sliding_scale
client_staff
client_view
client_view_attempt
clinical_recon
clinician_allergy_entry
clinician_ord_medication
clinician_user
code_system
collection_assignment
collection_assignment_clms
cs_batch
cs_batch_client
cs_batch_client_aging
cs_batch_client_claim
cs_batch_client_claim_tran
deposit
deposit_activity
deposit_audit
descriptor
descriptor_mapped_value
document
document_audit
document_grouping
document_signature
document_signature_pad
document_status
dsm_diag_category
dsm_diag_category_range
dsm_diagnosis
dyn_hcfa
edi_270_batch
edi_270_detail
edi_271
edi_271_eb_dates
edi_271_eligible
edi_271_reference
edi_271_request_val
edi_271_subscriber
edi_271_subscriber_benefit
edi_835
edi_835_adj_org
edi_835_adj_org_matrix
edi_835_adj_org_payer_plan
edi_835_adjustment
edi_835_adjustment_reason
edi_835_plb
edi_835_reference
edi_835_service
edi_835_transaction
edi_837
edi_837_element
edi_837_level
edi_code
edi_type
episode_type
error
erx_allergy
erx_client
erx_drug
erx_medication
erx_notification
erx_pharmacy
erx_prescription
erx_prescription_status
erx_sig
failed_login
ffs_batch
ffs_batch_line
ffs_batch_line_err
ffs_batch_line_hx
gl_code_activity
gl_code_date
gl_code_org_prog
gl_code_organization
gl_code_payer
gl_code_population
gl_code_prog_act
gl_code_program
gl_detail
gl_error
gl_map
guarantor
intake_followup
intake_tracking
ip_log
licensure
location
macsis_adm_dis
macsis_adm_dis_data
macsis_client_sig_pad
macsis_enrollment_form
macsis_enrollment_form_d
macsis_enrollment_verify
master_modifier
master_modifier_detail
master_modifier_org_map
master_person_index
measure
measure_question
measure_question_val
measure_section
measure_subtotal
medication
medication_dispense
medication_entry
medication_org_map
menu
menu_org_map
menu_priv
menu_system
menu_system_org_map
mod_call_log
mod_employmt
mod_eval_management
mod_goals_addr_summary
mod_lab_result
mod_lab_result_dtl
mod_legal
mod_living_ed
mod_manual_med_rec
mod_med_diag_cat
mod_medication
mod_memo_note
mod_pcp_signature
mod_pcp_signature_cbx
mod_referral
mod_service_addition
mod_service_detail
mod_service_detail_sb
mod_sub_abuse_dtl_dsc
mod_substance_abuse
mod_substance_abuse_date
mod_substance_abuse_dsc
mod_substance_abuse_dtl
mod_teds_noms
mod_tobacco
mod_tplan_entity
mod_tplan_entity_dtl
mod_tplan_entity_map
mod_tplan_master
mod_trans_discharge
mod_tx_diag
mod_tx_diag_axis
mod_tx_dx
mod_tx_dx_code
mod_tx_dx_code_spec_sev
mod_tx_dx_diag
mod_tx_dx_diag_spec_sev
mod_tx_dx_info
mod_tx_plan
mod_tx_plan_client_prog
mod_tx_plan_entity
mod_tx_plan_entity_act
mod_tx_plan_entity_hx
mod_tx_plan_entity_info
mod_tx_plan_info
mod_tx_plan_note
mod_tx_plan_note_addr
mod_vitals
module
mv_billing_error
mv_claim
mv_client
mv_client_diagnosis
mv_client_document
mv_client_dsm5_diag
mv_client_dsm5_diag_dtl
mv_impact_data
mv_impact_data_response
mv_payment
mv_scheduled_activities
mv_staff
mv_transactions
non_billable_failed_act
non_billable_failed_claim
ord_code
ord_generic
ord_lab
ord_lab_clinician
ord_lab_clinician_test
ord_medication
order_config_setup
order_config_type
order_group
order_master
order_master_type
order_module
order_module_status
organization
organization_config
organization_relative
payer
payer_org
payer_panel
payer_panel_org_map
payer_plan
payer_plan_benefit
payer_plan_benefit_fee
payer_plan_config
payer_plan_contact
payer_plan_org
payer_provider
payment_activity
payment_claim_adjustment
payment_detail
payment_line
payment_post
person
person_address
person_alias
person_contact
person_contact_phone
person_demo
person_demo_dsc_data
person_name
person_reminder_pref
privilege_group
procedure
procedure_fee
program
program_org_map
qsi_user
qsi_user_date
referral_source
refund
refund_activity
scanned_document
scanned_document_keyword
service_doc
service_doc_matrix
service_doc_module
service_doc_reject
service_doc_setup
service_location_code
srp_episode
staff
staff_credential
staff_credential_primary
staff_history
staff_history_data
staff_history_org
staff_privilege
staff_shift
staff_supervisory_group
state_reporting_batch
state_reporting_batch_dtl
tran_type
trans_reason
transaction
transaction_period
treatment_plan_grid
treatment_plan_grid_assmt
treatment_plan_grid_diag
treatment_plan_grid_goal
treatment_plan_grid_lab
treatment_plan_grid_obj
tx_plan_grid_obj_int
tx_plan_grid_sub_prob