Module ↔ Table CRUD Matrix
Which source library creates/reads/updates/deletes which table, derived from DataWindow update targets and embedded SQL.
app_sec
| Table | Ops |
|---|---|
all_users | R |
codes | CRUD |
error | U |
event | R |
groups | R |
rowcount | U |
security_db_role | R |
security_groupings | R |
security_info | R |
security_menu_options | CRUD |
security_user_class | R |
security_user_class_user | R |
security_user_group | CRUD |
security_users | CRUD |
string | R |
successful | U |
then | U |
user_assignments | CRUD |
user_dept_group | CRUD |
user_info | CUD |
user_supervisor | CUD |
base
| Table | Ops |
|---|---|
addresses | R |
benefit_coverage_type_cd | R |
benefit_plans | R |
claim_lines | R |
claims | R |
consolidated_vendors | C |
contract_withholds | D |
contracts | U |
coverage_level_cd | R |
dep_member_sys_key | R |
drug_covr_pcs_std_trans | R |
drug_plan_exts | R |
eff_dt | R |
election_coverages | R |
elections | R |
exp_dt | R |
family | R |
fund_register | U |
group_enroll_opts | R |
group_option_vals | R |
groups | R |
load | R |
member_cat_val | R |
member_elect_exp_dt | R |
member_eligibilities | R |
members | R |
option_val_char | R |
panel_withholds | D |
pkg_rule_fulfillments | CUD |
plan_pkgs | R |
provider_address_vendors | U |
providers | U |
reason_codes | R |
user_info | R |
user_role_privs | R |
vendor | U |
vendor_addresses | RD |
vendor_contacts | D |
vendor_holds | D |
vendors | RD |
benplans
| Table | Ops |
|---|---|
benefit | U |
benefit_def_criterion | U |
benefit_def_diags | CRUD |
benefit_def_procs | CRUD |
benefit_defs | CRUD |
benefit_pkgs | CRUD |
benefit_plans | CRUD |
benefit_rule_tooth_types | R |
benefit_rules | CRUD |
codes | CRUD |
compound_ben_defs | CRUD |
coverages | R |
datastore | U |
diagnosis | U |
diagnosis_codes | CRUD |
diagnosis_groups | R |
dws | U |
event | R |
existing | U |
fails | U |
health_care_networks | CRUD |
modifiers | CRUD |
pkg_riders | CRUD |
pkg_rule_dependencies | CRUD |
pkg_rule_fulfillments | CRUD |
pkg_rule_requirements | CRUD |
pkg_rules | CRUD |
place_of_service_codes | CRUD |
plan_pkgs | CRUD |
pricing_plans | R |
procedure | U |
procedure_codes | CRUD |
procedure_groups | R |
reason_codes | R |
related | U |
rider_rules | CRUD |
riders | R |
rule_contingency_defs | CRUD |
rule_defs | CRUD |
second_opinion_lists | R |
specialties | CRUD |
sql | U |
tooth_types | R |
transactions | U |
um_entities | CRUD |
bensupport
| Table | Ops |
|---|---|
ada_surfaces_required | CRUD |
ada_teeth_required | CUD |
benefit_defs | R |
benefit_pkgs | R |
benefit_plans | R |
benefit_rule_tooth_types | CUD |
benefit_rules | R |
carryover_rules | CRUD |
code_keys | CRUD |
codes | CRUD |
diagnosis_code_groups | CRUD |
diagnosis_codes | CRUD |
diagnosis_groups | CRUD |
error | U |
group_coverages | CRUD |
groups | R |
if | U |
is | U |
level_sched_items | CRUD |
level_scheds | CRUD |
pkg_rules | R |
plan_pkgs | R |
procedure_code_groups | CRUD |
procedure_codes | CRUD |
procedure_groups | CRUD |
reason_codes | CRUD |
rounding_rules | CRUD |
second_opinion_lists | CRUD |
second_opinion_procs | CRUD |
statement | U |
step_rate_items | CRUD |
step_rate_scheds | CRUD |
successful | U |
tooth | U |
tooth_code_numbers | CRUD |
tooth_types | CRUD |
um_cm_serv_excl_proc_cd | CRUD |
billfunc
| Table | Ops |
|---|---|
addresses | R |
bill_charges | CRUD |
bill_charges_temp | CRUD |
bill_def_groups | R |
bill_def_option_vals | R |
bill_def_options | R |
bill_def_rules | R |
bill_defs | R |
bill_range_items | R |
bill_ranges | R |
bill_rate_allocs | R |
bill_rate_amts | R |
bill_rate_tables | R |
bill_rate_types | R |
bill_rate_vars | R |
bill_recalc_charges_temp | CRUD |
bill_receipts | R |
bill_rule_parm_details | R |
bill_rule_parms | R |
bill_rules | R |
bill_run_defs | R |
bill_runs | R |
codes | R |
coverages | R |
directory | U |
elections | R |
failed | U |
group_contacts | R |
group_coverages | R |
group_member_cat | CRUD |
group_options | R |
group_periods | CRUD |
groups | R |
health_care_networks | R |
letter_headers | R |
member_cat_val | R |
member_eligibilities | R |
members | R |
null | R |
plan_pkgs | R |
vendors | R |
billing
| Table | Ops |
|---|---|
addresses | R |
alloc_entities | CRUD |
allocations | U |
benefit_plans | R |
bill_charges | CRUD |
bill_def_groups | CRUD |
bill_def_option_vals | CRUD |
bill_def_options | R |
bill_def_rules | CRUD |
bill_defs | CRUD |
bill_range_items | CRUD |
bill_ranges | CRUD |
bill_rate_allocs | CRUD |
bill_rate_amts | CRUD |
bill_rate_tables | CRUD |
bill_rate_types | CRUD |
bill_rate_vars | R |
bill_recalc_charges | RD |
bill_receipts | CRUD |
bill_reports | CRUD |
bill_rule_parm_details | CRUD |
bill_rule_parms | CRUD |
bill_rules | CRUD |
bill_run_defs | CRUD |
bill_runs | CRUD |
check | U |
checks | U |
codes | CRUD |
coverages | R |
drop | U |
elections | R |
event | U |
failed | U |
fails | U |
group_member_cat | R |
group_options | R |
groups | CRUD |
grp_mbr_cat_val | R |
header | U |
health_care_networks | R |
member_eligibilities | R |
members | R |
pm_addresses | R |
process | U |
rate_groups | R |
report_data | CRUD |
report_objects | CRUD |
rule | U |
this | D |
vendor_addresses | R |
vendors | R |
chkrundw
| Table | Ops |
|---|---|
addresses | R |
bank_acct_info | R |
bank_forms | R |
benefit_defs | R |
benefit_rules | R |
claim_entries | R |
claim_line_pricing_rules | R |
claim_line_rules | R |
claim_lines | R |
claim_messages | CRUD |
claims | R |
claims_wdi_info | R |
codes | R |
fund_register | CRUD |
fundtrans | R |
groups | R |
members | R |
providers | R |
reason_codes | R |
vendors | R |
claims
| Table | Ops |
|---|---|
accident_claims | CRUD |
accident_diagnoses | CRUD |
accident_members | CRUD |
accidents | CRUD |
assigning | U |
audit_diagnosis_codes | CRUD |
audit_examiners | CUD |
audit_groups | CRUD |
audit_members | CUD |
audit_procedure_codes | CRUD |
audit_providers | CRUD |
benefit_defs | R |
benefit_pkgs | R |
claim | U |
claim_entries | R |
claim_entry_diag_codes | R |
claim_eob_info_details | CUD |
claim_eob_infos | CUD |
claim_letters_data | D |
claim_letters_hist | CRUD |
claim_letters_hist_claims | CRUD |
claim_line_accums | R |
claim_line_diag_codes | R |
claim_line_pricing_rules | CUD |
claim_line_rules | R |
claim_lines | CRUD |
claim_lines_before | R |
claim_messages | CRU |
claim_persons | R |
claim_status_order | R |
claim_statuses | R |
claim_statuses_history | R |
claims | RU |
claims_reprice_info | CR |
codes | CRUD |
compound_ben_defs | R |
diagnosis_codes | R |
dwo | R |
error | U |
event | R |
ext_adjust | CRUD |
failed | U |
family | R |
fund_register | R |
global_messages | R |
group_print_distribution | R |
groups | R |
health_care_networks | R |
letter | U |
li_claimline | R |
member | U |
member_accum_credits | CRUD |
member_accums | R |
member_cat_val | R |
members | R |
moon_negotiations | R |
outbound_edi_trading_partners | R |
outbound_edi_transactions | CR |
plan_pkgs | R |
providers | R |
reason_codes | CRUD |
report_archive | R |
rule_defs | R |
security_groupings | R |
security_user_class | R |
security_user_class_user | R |
security_user_group | R |
sql | U |
um_case_mgt_claims | CR |
um_rules | RU |
unlocked_claims | C |
user_dept_group | R |
user_info | R |
v_pkg_rules | R |
client
| Table | Ops |
|---|---|
addresses | CRUD |
batch_reports | CRUD |
benefits | R |
carriers | CRUD |
client_segment_groups | CRUD |
client_segments | R |
codes | CRUD |
coverages | R |
election_coverages | RUD |
elections | RUD |
error | U |
event | R |
family | R |
force_update | U |
general_cat | CRUD |
general_cat_val | R |
group_ancillary_coverages | CRUD |
group_ancillary_parms | CRUD |
group_contacts | CRUD |
group_coverages | CRUD |
group_enroll_opts | CRUD |
group_member_cat | CRUD |
group_option_vals | CRUD |
group_options | R |
group_periods | CRUD |
group_stoploss_coverage_rates | CRUD |
group_stoploss_coverages | CRUD |
group_stoploss_parms | CRUD |
groups | CRUD |
groups_excluded | R |
grp_chg_prop_hist | R |
grp_covr_elig_rules | CRUD |
grp_mbr_cat_val | CRUD |
ib_isvalid | U |
lstr_parms | R |
member_cat_val | R |
member_eligibilities | CRUD |
members | R |
reason_codes | R |
security_user_class_user | R |
security_user_group | CR |
stoploss_waivers | CRUD |
clmentry
| Table | Ops |
|---|---|
a | U |
benefit_defs | CRUD |
benefit_rules | R |
claim_entries | CUD |
claim_entry_diag_codes | CUD |
claim_lines | CUD |
claim_other_ins_infos | CUD |
claim_ub92_procedures | CUD |
claim_wdi_lines | CUD |
claims | CUD |
claims_anesthesia | CRUD |
claims_dental_info | CUD |
claims_hcfa_info | CUD |
claims_reimb_info | CUD |
claims_reprice_detail | CUD |
claims_reprice_info | CUD |
claims_sso_diagnosis | CUD |
claims_sso_info | CUD |
claims_ub92_info | CUD |
claims_ub92_itemized | CRUD |
claims_vision_info | CUD |
claims_wdi_info | CUD |
codes | R |
compound_ben_defs | R |
diagnosis_codes | R |
ext_output_transactions | R |
fund_register | CRUD |
fundtrans | R |
members | R |
pkg_rules | R |
plan_pkgs | R |
vendors | R |
clmforms
| Table | Ops |
|---|---|
addresses | R |
claim_entries | R |
claim_status_order | R |
claims | R |
family | R |
groups | R |
letter_headers | R |
members | R |
pm_addresses | R |
providers | R |
user_assignments | R |
user_info | R |
clmprint
| Table | Ops |
|---|---|
addresses | R |
benefit_plans | R |
benefit_rules | R |
claim_entries | CRUD |
claim_entry_diag_codes | R |
claim_line_rules | R |
claim_lines | R |
claim_other_ins_infos | R |
claim_ub92_conditions | R |
claim_wdi_lines | R |
claims | R |
claims_reimb_info | R |
claims_reprice_detail | CRUD |
claims_reprice_info | CUD |
claims_ub92_info | R |
claims_wdi_info | R |
diagnosis_codes | R |
fund_register | R |
group_enroll_opts | R |
health_care_networks | R |
members | R |
plan_pkgs | R |
pm_addresses | R |
providers | R |
reason_codes | R |
user_info | R |
clmrpt
| Table | Ops |
|---|---|
bank_acct_info | R |
bank_acct_info_grps | R |
benefit_defs | CRUD |
benefit_plans | R |
benefit_rules | R |
cigna_report_groups | CRUD |
claim_entries | R |
claim_entry_diag_codes | R |
claim_line_accums | R |
claim_line_rules | R |
claim_lines | R |
claim_messages | R |
claim_status_order | R |
claim_statuses | R |
claim_statuses_history | R |
claims | CRUD |
event | R |
family | R |
fund_register | R |
fundtrans | R |
global_messages | R |
group_coverages | R |
groups | CRUD |
lds_external | C |
member_accum_credits | R |
member_accums | R |
member_cat_val | R |
member_eligibilities | R |
members | R |
outbound_edi_transactions | CRUD |
pkg_rules | R |
plan_pkgs | R |
providers | R |
reason_codes | R |
security_user_class_user | R |
security_user_group | R |
vendors | R |
clmshare
| Table | Ops |
|---|---|
claim | U |
claim_entries | CUD |
claim_line_pricing_rules | CRUD |
claim_line_rules | CUD |
claim_lines | CUD |
claim_messages | CRUD |
claim_missing_teeth | CUD |
claim_other_ins_infos | CUD |
claim_pricing_rules | U |
claim_ub92_conditions | CUD |
claim_ub92_occurrences | CUD |
claim_ub92_procedures | CUD |
claim_ub92_values | CUD |
claims | CRUD |
claims_dental_info | CUD |
claims_hcfa_info | CUD |
claims_reimb_info | CUD |
claims_reprice_detail | CUD |
claims_reprice_info | CUD |
claims_sso_diagnosis | CUD |
claims_sso_info | CUD |
claims_sso_procedure | CUD |
claims_ub92_info | CUD |
claims_ub92_itemized | CRUD |
claims_vision_info | CUD |
claims_wdi_info | CUD |
client_segment_groups | R |
contracts | R |
election_coverages | R |
failed | U |
force_update | U |
global_messages | R |
groups | R |
health_care_networks | R |
member_cat_val | R |
messages | U |
modifiers | R |
no | U |
plan_pkgs | R |
pm_addresses | CR |
pricing_rules | R |
procedure_codes | R |
provider_add_log | CUD |
provider_address_vendors | C |
provider_addresses | CRU |
provider_alias_lookup | RU |
provider_tins | CR |
providers | CRUD |
security_groupings | R |
security_info | R |
security_users | R |
specialties | R |
status | U |
type_of_service_codes | R |
um_case_mgt_claims | CRUD |
um_rules | RU |
vendor_addresses | R |
vendors | R |
clmsproc
| Table | Ops |
|---|---|
accident_claims | CRUD |
accident_diagnoses | R |
accident_members | R |
accidents | R |
accumulators | U |
amount | U |
benefit_def_diags | CRUD |
benefit_def_procs | CRUD |
benefit_defs | CRUD |
benefit_pkgs | R |
benefit_plans | R |
benefit_rules | CRUD |
carryover_rules | R |
claim | U |
claim_entries | R |
claim_entry_diag_codes | R |
claim_eob_info_details | CRUD |
claim_file | R |
claim_line_accums | CRUD |
claim_line_diag_codes | R |
claim_line_payments | CRUD |
claim_line_rules | CRUD |
claim_line_um_rules | R |
claim_lines | CRUD |
claim_messages | R |
claim_precert_stub | CRUD |
claim_referral_stub | CRUD |
claim_status_order | R |
claim_statuses | R |
claim_statuses_history | R |
claim_ub92_occurrences | R |
claims | CRUD |
claims_reprice_detail | R |
claims_ub92_info | R |
claims_xref | R |
codes | R |
column | U |
compound_ben_defs | R |
coord_of_bens | CRUD |
data | U |
diagnosis_code_groups | R |
diagnosis_groups | R |
elections | R |
family | R |
fund_register | CRUD |
global_messages | R |
group_coverages | R |
group_periods | CRUD |
groups | R |
homer_detail | R |
homer_revenue | R |
level_sched_items | R |
level_scheds | R |
ll_row_count | U |
member_accum_credits | CRUD |
member_accums | CRUD |
member_cat_val | R |
member_eligibilities | R |
member_pcps | R |
members | R |
patient_sys_key | R |
pkg_rule_dependencies | R |
pkg_rule_fulfillments | CRUD |
pkg_rule_requirements | CRUD |
pkg_rules | R |
plan_pkgs | R |
procedure_code_groups | R |
procedure_groups | R |
provider_address_vendors | CRUD |
providers | R |
reason_codes | R |
rounding_rules | R |
rule_contingency_defs | R |
rule_defs | R |
successful | U |
temp_benefit_defs | RD |
test_claims | R |
um_benefit_definitions | R |
um_case_mgt_claims | CRUD |
um_cases | R |
um_cm_serv_excl_proc_cd | R |
um_diagnosis_codes | R |
um_diagnosis_groups | R |
um_procedure_codes | R |
um_procedure_groups | R |
um_rules | CRUD |
um_services | R |
v_pkg_rules | R |
wang_acm | R |
wang_claim_line_rules | CRUD |
wang_claim_lines | CRUD |
wang_claims | R |
wang_claims_xref | R |
wang_group_rule_map | CRUD |
wang_rej_map | R |
wang_rule_map | CRUD |
clmutils
| Table | Ops |
|---|---|
addresses | R |
benefit_defs | R |
benefit_rules | R |
birth_dt | R |
caremark_edi_table | CRUD |
claim | U |
claim_entries | RU |
claim_id | R |
claim_line_accums | R |
claim_line_diag_codes | R |
claim_lines | RU |
claim_messages | U |
claim_status_order | R |
claim_statuses | R |
claim_statuses_history | R |
claim_ub92_conditions | CRUD |
claim_ub92_occurrences | CRUD |
claim_ub92_procedures | CRUD |
claim_ub92_values | CRUD |
claims | RU |
claims_dental_info | R |
claims_hcfa_info | R |
claims_reprice_info | R |
claims_ub92_info | R |
codes | R |
corrections | U |
diagnosis_codes | R |
edi_in_repricing | CRU |
elections | R |
existing | U |
f_name | R |
from_dt | R |
gender_cd | R |
group_id | R |
groups | R |
health_care_networks | R |
l_name | R |
member_accum_credits | CRU |
member_accums | CRUD |
member_cat_val | R |
member_eligibilities | R |
member_sys_key | R |
members | R |
outbound | U |
outbound_edi_claim_table | CRUD |
outbound_edi_conditions_table | CRUD |
outbound_edi_dental_table | CRUD |
outbound_edi_line_table | CRUD |
outbound_edi_occurrences_table | CRUD |
outbound_edi_patient_table | CRUD |
outbound_edi_procedures_table | CRUD |
outbound_edi_provider_table | CRUD |
outbound_edi_subscriber_table | CRUD |
outbound_edi_transactions | CRUD |
outbound_edi_ub92_table | CRUD |
outbound_edi_values_table | CRUD |
package | U |
pkg_rules | CR |
pm_addresses | R |
procedure_codes | R |
providers | R |
reason_codes | R |
refill_ind | R |
rule | U |
rule_defs | CR |
rx_number | R |
security_user_class_user | R |
security_user_group | R |
soc_sec_no | R |
students | R |
table | U |
thru_dt | R |
cob
| Table | Ops |
|---|---|
addresses | CUD |
codes | CRUD |
coord_of_bens | CUD |
event | U |
force_update | U |
cobra
| Table | Ops |
|---|---|
cobra_early_term_letters | RU |
cobra_elect_persons | CRUD |
cobra_errors | CRUD |
cobra_event | CRUD |
cobra_letter_data | R |
cobra_letters | CRUD |
cobra_non_qual | CRU |
cobra_notification_requests | CRUD |
cobra_qb | CRUD |
cobra_rate_coverages | CUD |
cobra_rates_master | CRUD |
cobra_stub | CRUD |
codes | CRUD |
coverages | R |
database | U |
election_coverages | R |
elections | R |
error | U |
family | R |
group_coverages | R |
group_enroll_opts | R |
groups | R |
if | U |
it | U |
member_cat_val | R |
member_eligibilities | RU |
members | R |
question | U |
cobradw
| Table | Ops |
|---|---|
addresses | R |
cobra_early_term_letters | R |
cobra_elect_persons | R |
cobra_errors | R |
cobra_event | R |
cobra_letter_data | R |
cobra_letters | R |
cobra_non_qual | CRUD |
cobra_notification_requests | R |
cobra_qb | R |
cobra_rate_coverages | R |
cobra_rates_master | R |
codes | R |
election_coverages | R |
elections | R |
groups | R |
member_eligibilities | R |
members | R |
report_data | R |
cobrarpt
| Table | Ops |
|---|---|
addresses | R |
batch_reports | CRUD |
cobra_elect_persons | R |
cobra_errors | R |
cobra_event | R |
cobra_letter_data | R |
cobra_letters | R |
cobra_notification_requests | R |
cobra_qb | R |
cobra_rate_coverages | R |
cobra_rates | R |
cobra_rates_master | R |
cobra_stub | R |
cobra_terms | R |
dep_member_sys_key | R |
elect_member_sys_key | R |
election_coverages | R |
elections | R |
family | R |
group_coverages | R |
groups | R |
member_cat_val | R |
member_eligibilities | R |
members | R |
qe_elig_eff_dt | R |
security_user_class_user | R |
security_user_group | R |
drugplan
| Table | Ops |
|---|---|
addresses | R |
any | U |
codes | CRUD |
complete | U |
drug_covr_exp_trans | CRUD |
drug_covr_pcs_rxb_trans | CRUD |
drug_covr_pcs_std_trans | CRUD |
drug_covr_pcs_trans | CRUD |
drug_covr_restat_trans | CRUD |
drug_mbr_exts | CR |
drug_plan_exts | CRUD |
drugs_mbr_exts | C |
election_coverages | R |
elections | R |
error | U |
family | R |
group_coverages | R |
groups | R |
is | U |
member_cat_val | R |
member_eligibilities | R |
members | R |
security_user_class_user | R |
security_user_group | R |
students | R |
enrolaud
| Table | Ops |
|---|---|
addresses | R |
aud_trail_mbr | R |
coord_of_bens | R |
election_coverages | R |
elections | R |
family | CRUD |
member_cat_val | R |
member_eligibilities | R |
member_waiting_periods | R |
members | CRUD |
security_user_class_user | R |
security_user_group | R |
students | R |
enroll
| Table | Ops |
|---|---|
addresses | CRUD |
any | U |
carriers | R |
cobra_non_qual | R |
cobra_qb | R |
codes | CRUD |
contracts | R |
coord_of_bens | CRUD |
coverages | R |
custom_term_transactions | RUD |
drug_plan_exts | R |
election_coverages | CRUD |
election_riders | CRUD |
elections | CRUD |
error | U |
event | R |
fails | U |
family | CRUD |
flag | U |
for | U |
force_update | U |
goes | U |
group_contacts | R |
group_coverages | R |
group_enroll_opts | R |
group_member_cat | CRUD |
group_option_vals | R |
groups | CRUD |
grp_mbr_cat_val | CRUD |
hb1_members | CRUD |
hb1_payments | CRUD |
health_care_networks | R |
hipaa_transactions | CRUD |
if | U |
letter_headers | R |
logo | U |
long | R |
ls_covg_cd | R |
ls_field_code | R |
member_cat_val | CRUD |
member_eligibilities | CRUD |
member_pcps | CRUD |
member_waiting_periods | CRUD |
members | CRUD |
note_entities | CRUD |
note_key_codes | R |
note_keys | CR |
notes | CR |
pending | U |
plan_pkgs | R |
pm_addresses | R |
pm_contacts | R |
property | U |
provider_addresses | R |
provider_tins | R |
providers | R |
qmcso_custodians | CRUD |
qmcso_guardians | CUD |
question | U |
report_data | D |
report_hist | CRUD |
report_objects | D |
security_user_class_user | R |
security_user_group | R |
students | CUD |
successful | U |
them | U |
u_dw | R |
vendor_addresses | R |
vendors | R |
enrollutils
| Table | Ops |
|---|---|
benefit_plans | R |
claim_lines | R |
claim_status_order | R |
claims | R |
codes | R |
coverages | R |
election_coverages | CRUD |
elections | CRUD |
family | R |
fund_register | R |
group_coverages | CRUD |
group_periods | R |
groups | R |
ll_rc | U |
member_accum_credits | R |
member_eligibilities | CRUD |
members | RU |
enrolrpt
| Table | Ops |
|---|---|
addresses | R |
annual_statement_options | CRUD |
batch_reports | CRUD |
benefit_plans | R |
claim_entries | R |
claim_lines | R |
claim_messages | R |
claims | R |
cobra_event | R |
codes | CRUD |
coord_of_bens | R |
coverages | R |
drug_plan_exts | R |
election_coverages | R |
elections | R |
entire | U |
event | R |
family | R |
fund_register | R |
fundtrans | R |
group_coverages | R |
group_member_cat | R |
group_option_vals | R |
groups | R |
hb1_payments | R |
health_care_networks | R |
if | U |
letter_headers | R |
lstr_parms | R |
member | U |
member_cat_val | CRU |
member_eligibilities | RU |
member_pcps | R |
members | CRUD |
plan_pkgs | R |
provider_tins | R |
providers | R |
security_user_class_user | R |
security_user_group | R |
vendors | R |
funding
| Table | Ops |
|---|---|
addresses | R |
audit_groups | D |
bank_acct_info | CRUD |
bank_acct_info_grps | CR |
bank_forms | R |
benefit_coverage_type_cd | R |
capability | U |
check | UD |
check_log | CRUD |
checks | U |
claim_entries | R |
claim_entry_diag_codes | R |
claim_line_pricing_rules | R |
claim_lines | R |
claim_messages | CR |
claim_status_order | R |
claim_statuses | R |
claim_statuses_history | R |
claims | CRUD |
claims_ub92_info | R |
codes | CRUD |
coverage_level_cd | R |
coverages | R |
data | U |
dep_member_sys_key | R |
drug_card_groups | CUD |
drug_cards | CRUD |
eff_dt | R |
election_coverages | R |
elections | R |
event | R |
exp_dt | R |
expected | U |
failed | U |
fails | U |
flag | U |
fund | U |
fund_page_covrs | CRUD |
fund_page_grps | CRUD |
fund_pages | CRUD |
fund_register | CRUD |
funding_group_excludes | R |
fundpage | U |
fundtrans | CRUD |
group_coverages | R |
group_option_vals | R |
groups | CRUD |
grp_sched_funds | CRUD |
grp_sched_incls | CRUD |
member_cat_val | R |
member_eligibilities | R |
members | R |
new | U |
notify | U |
ome_resa_wire_xfer_adj | CRUD |
option_val_char | R |
paid | U |
plan_pkgs | R |
pm_addresses | R |
providers | R |
reconciliation | U |
report_hist | CD |
sched_comp | CRUD |
sched_run_comps | CRUD |
schedule_runs | CRUD |
security_groupings | R |
security_user_class_user | R |
security_user_group | R |
security_users | R |
specialties | R |
tables | C |
unless | U |
v_claim_members | R |
vendor_addresses | RUD |
vendors | CRUD |
homersys
| Table | Ops |
|---|---|
accident_types | CUD |
addresses | CRUD |
app_parms | R |
based | U |
batch_reports | CRUD |
claim_line_accums | D |
claims | R |
code_keys | CRUD |
codes | CRUD |
coord_of_bens | D |
drug_mbr_exts | D |
election_coverages | CRUD |
elections | CRUD |
event | R |
family | RD |
for | U |
fund_register | R |
general_cat | CRUD |
group_contacts | R |
group_coverages | R |
group_member_cat | R |
group_options | CRUD |
groups | R |
homer_versions | R |
id_card_req | D |
letter_headers | CRUD |
member_accum_credits | D |
member_accums | D |
member_cat_val | RD |
member_eligibilities | CRUD |
member_waiting_periods | D |
members | RD |
members_included | R |
note_entities | R |
notes | CUD |
security_groupings | R |
security_info | R |
security_template | R |
security_user_class | CRUD |
security_user_class_user | CRUD |
security_user_group | CRUD |
security_users | R |
state | R |
students | RD |
system_menu | R |
test_log | CUD |
this | U |
unsearchable_tins | R |
user_info | CRUD |
user_ini | CRUD |
idcard
| Table | Ops |
|---|---|
addresses | R |
drug_plan_exts | R |
elections | R |
function | U |
group_option_vals | R |
groups | R |
id | U |
id_card_req | CRUD |
member_eligibilities | R |
member_pcps | R |
members | R |
pm_contacts | R |
provider_addresses | R |
providers | CRUD |
requests | U |
those | U |
mailobj
| Table | Ops |
|---|---|
addresses | CRU |
carriers | R |
codes | R |
coord_of_bens | R |
group_contacts | R |
groups | R |
medical_directors | R |
members | R |
pm_addresses | CRU |
pm_contacts | R |
provider_addresses | R |
providers | R |
security_user_class_user | R |
security_user_group | R |
um_entities | R |
vendor_addresses | R |
vendors | R |
moon
| Table | Ops |
|---|---|
claim_entries | R |
claims | R |
codes | R |
edi_in_repricing | CRUD |
groups | R |
health_care_networks | R |
moon_negotiations | CRUD |
oon_product_claim_types | CRUD |
oon_product_groups | CRUD |
oon_product_hcn_exclusions | CRUD |
oon_products | CRUD |
outbound_edi_trading_partners | R |
pm_contacts | R |
product | UD |
provider_addresses | R |
providers | R |
table | U |
pfcapsrv
| Table | Ops |
|---|---|
array | U |
it | U |
messages | CRUD |
security_apps | CRUD |
security_groupings | CRUD |
security_info | R |
security_template | CRUD |
security_users | CRUD |
pfcdwsrv
| Table | Ops |
|---|---|
as_ext | R |
as_filename | R |
as_pathname | R |
characteristics | U |
error | U |
flags | U |
from | U |
function | U |
information | U |
itr_object | R |
key | U |
linked | U |
ls_presentation | R |
percentage | U |
print | U |
sequence | U |
status | U |
syntax | U |
pfcmain
| Table | Ops |
|---|---|
checks | U |
event | R |
failed | U |
fails | U |
flags | U |
its | U |
services | U |
that | U |
this | U |
were | U |
pfcwnsrv
| Table | Ops |
|---|---|
event | R |
it | U |
lin | U |
toolbarvisible | U |
pfedwsrv
| Table | Ops |
|---|---|
sql | U |
preex
| Table | Ops |
|---|---|
diagnosis_codes | R |
family | R |
groups | R |
members | R |
pre_existing_conditions | CUD |
security_user_group | R |
pricing
| Table | Ops |
|---|---|
benefit_defs | CRUD |
codes | CRUD |
conversion_factor_details | CRUD |
conversion_factors | CRUD |
diagnosis_codes | CUD |
diagnosis_groups | R |
drg_codes | CRUD |
drg_weight_details | CRUD |
drg_weights | CRUD |
event | R |
fee_schedule_details | CRUD |
fee_schedules | CRUD |
master_multipliers | CUD |
ourselves | U |
place_of_service_codes | R |
pricing_methods | CRUD |
pricing_plans | CRUD |
pricing_rule_diags | CRUD |
pricing_rule_procs | CRUD |
pricing_rules | CRUD |
procedure_codes | CRUD |
procedure_groups | R |
rbrvs_master_multipliers | R |
reason_codes | CRUD |
specialties | CRUD |
tiered_per_diem_details | CRUD |
tiered_per_diem_schedules | CRUD |
unit_schedule_details | CRUD |
unit_schedules | CRUD |
valid_methods | CRUD |
provider
| Table | Ops |
|---|---|
address | U |
addresses | R |
aetna_report_groups | R |
aetna_tmp | R |
benefit_rules | R |
caremark_report_audit | CRUD |
claim_id | R |
claim_line_rules | R |
claim_messages | R |
claim_status_order | R |
claim_statuses | R |
claims | R |
clearinghouse | U |
client_segment_groups | R |
client_segment_users | CRUD |
client_segments | CRUD |
codes | CRUD |
consolidated_vendors | C |
contacts | U |
contract_holds | CUD |
contract_pricing | CUD |
contract_withholds | CUD |
contracts | CUD |
dw | U |
dw_address | U |
election_coverages | R |
elections | R |
event | R |
fund_register | U |
global_messages | R |
group_coverages | R |
group_option_vals | R |
groups | R |
hcn | U |
hcn_contacts | CUD |
hcn_pricing | CUD |
hcn_withholds | CUD |
health_care_networks | CRUD |
il_cur_addr | U |
member_cat_val | R |
member_eligibilities | R |
members | R |
mmo_enrollment_work | CUD |
optum_report_audit | R |
outb_edi_clearhouse_contacts | CUD |
outb_edi_tradingpart_contacts | CUD |
outbound_edi_clearinghouses | CRUD |
outbound_edi_trading_partners | CRUD |
panel_pricing | CUD |
panel_withholds | CUD |
panels | CRUD |
patient_sys_key | R |
plan_pkgs | R |
pm_addresses | CRUD |
pm_contacts | CRUD |
ppo_census_ids | CRUD |
ppo_enrollment_work | CRUD |
ppo_group_work | CRUD |
print_1099s | CRUD |
provider | U |
provider_address_vendors | CRUD |
provider_addresses | CRUD |
provider_group_holds | CRUD |
provider_holds | CRUD |
provider_medicaid_ids | CRUD |
provider_npis | CRUD |
provider_panels | CRUD |
provider_specialties | CRUD |
provider_tins | CRUD |
provider_types | CRUD |
providers | CRUD |
reason_codes | R |
security_groupings | R |
security_user_class_user | R |
security_user_group | R |
security_users | CRUD |
specialties | CRUD |
trading | U |
unless | U |
unsearchable_tins | CRUD |
user_dept_group | R |
user_info | R |
vendor | U |
vendor_addresses | CRUD |
vendor_contacts | CUD |
vendor_holds | CRUD |
vendors | CRUD |
reprint
| Table | Ops |
|---|---|
addresses | R |
bank_acct_info | R |
bank_forms | R |
blob | U |
claim_entries | R |
claim_letters_data | C |
claim_letters_hist | CRUD |
claim_letters_hist_claims | C |
claims | RU |
codes | CRUD |
fails | U |
group_print_distribution | CRUD |
groups | R |
internal_payees | R |
letter_headers | R |
members | R |
pm_addresses | R |
print | U |
providers | R |
qmcso_custodians | R |
question | U |
reason_codes | CRUD |
report_hist | CRUD |
report_info | CRUD |
this | U |
user_info | R |
sales
| Table | Ops |
|---|---|
benefit_defs | CRUD |
benefit_rules | R |
claim_entries | R |
claim_entry_diag_codes | R |
claim_line_diag_codes | R |
claim_line_pricing_rules | R |
claim_line_rules | R |
claim_lines | R |
claim_messages | R |
claim_seq | R |
claims | R |
claims_ub92_info | R |
client_segments | R |
code_keys | CUD |
diag_cd | R |
diag_cd_type | R |
diagnosis_codes | R |
event | R |
fund_register | R |
fundtrans | R |
group_coverages | R |
groups | R |
hcn_id | R |
health_care_networks | R |
ibnr_work | CRD |
lag_triangle_work | CRD |
ldtm_from | R |
ldtm_thru | R |
member_cat_val | R |
members | R |
month_list | R |
new | U |
plan_pkgs | R |
providers | R |
reason_codes | R |
report_info | CRUD |
rpt_svc_cat_defs | CRD |
rpt_svc_cats | CRUD |
temp_report_groups | CRD |
v_fund_register_rpt | R |
v_fund_register_rpt_grp | R |
vendors | R |
stoploss
| Table | Ops |
|---|---|
addresses | R |
benefit_coverage_order | R |
benefit_defs | R |
benefit_rules | R |
carriers | CRUD |
claim_entries | R |
claim_entry_diag_codes | R |
claim_line_rules | R |
claim_lines | R |
claim_status_order | R |
claim_statuses | R |
claims | R |
code_display_seq | R |
code_value | R |
codes | R |
coverage_level_benefit_flg | R |
coverages | R |
diagnosis_codes | R |
election_coverages | R |
elections | R |
family | R |
for | U |
fund_register | R |
fundtrans | R |
group_contacts | R |
group_coverages | R |
group_stoploss_coverages | CRUD |
group_stoploss_parms | CRUD |
groups | CRUD |
id_card_req | CRUD |
id_card_setup | R |
member_cat_val | R |
member_eligibilities | R |
members | R |
patient_sys_key | R |
procedure_codes | R |
providers | R |
reason_codes | R |
rows | U |
sl_contract_coverages | CRUD |
sl_contract_domestic_tins | CRUD |
sl_contract_excl_plans | CRUD |
sl_contract_factors | CRUD |
sl_contract_groups | CRUD |
sl_contract_lasers | CRUD |
sl_contract_option_vals | CRUD |
sl_contract_options | R |
sl_contracts | CRUD |
status | U |
user_role_privs | R |
v_fund_register_rpt | R |
vendors | R |
svclog
| Table | Ops |
|---|---|
codes | R |
family | R |
flag | U |
groups | CRUD |
health_care_networks | CRUD |
medical_directors | CRUD |
members | R |
note_entities | CRUD |
note_key_codes | CRUD |
note_keys | CRD |
notes | CRUD |
occurs | U |
pm_addresses | R |
provider_addresses | R |
provider_tins | R |
providers | R |
security_groupings | R |
security_user_class_user | R |
security_user_group | R |
security_users | R |
um_cases | CRUD |
um_entities | R |
vendors | CRUD |
system
| Table | Ops |
|---|---|
addresses | R |
all_cons_columns | R |
archive | C |
batch | U |
batch_claim_priority_schedule | RD |
batch_process_exclude_messages | R |
batch_process_queue | CRU |
batch_schedules | RU |
benefits | R |
boolean | U |
characteristics | U |
claim_letters_data | R |
claim_letters_hist | R |
claim_letters_hist_claims | CRUD |
claim_messages | CRUD |
claim_statuses | R |
claims | RU |
codes | R |
coverages | R |
drug_plan_exts | R |
election_coverages | R |
elections | R |
family | R |
flags | U |
global_messages | R |
group_contacts | R |
group_coverages | R |
groups | R |
grp_mbr_cat_val | R |
hb1_members | R |
letter_headers | R |
li_char_pos | R |
member_eligibilities | R |
member_waiting_periods | R |
members | R |
of | U |
queue | U |
report | U |
report_archive | R |
report_data | CRUD |
report_objects | CRUD |
security_user_class_user | R |
security_user_group | R |
security_users | R |
security_users_db_role | CRUD |
um_cm
| Table | Ops |
|---|---|
benefit_defs | R |
billing | U |
calculated | U |
claim_entry_diag_codes | R |
claim_lines | R |
claims | R |
cm | U |
cm_billing | CRUD |
cm_case_involvements | CUD |
cm_involvements | R |
cm_potentials | CRUD |
codes | CRUD |
coord_of_bens | R |
db | D |
diagnosis_codes | R |
dw | U |
flags | U |
group_contacts | R |
group_coverages | R |
groups | R |
member_cat_val | R |
member_eligibilities | R |
members | R |
pricing_plans | D |
procedure_codes | R |
rules | U |
security_groupings | R |
security_user_class_user | R |
security_user_group | R |
security_users | R |
service | U |
um_benefit_definitions | CUD |
um_benefit_holds | CUD |
um_cases | CRUD |
um_diagnosis_code_holds | CUD |
um_diagnosis_codes | CRUD |
um_diagnosis_groups | D |
um_entities | CRUD |
um_hold_rules | CUD |
um_medical_reviews | D |
um_physicians | D |
um_procedure_code_holds | CUD |
um_procedure_codes | CUD |
um_procedure_groups | D |
um_provider_contacts | CRUD |
um_provider_holds | CUD |
um_rules | CUD |
um_services | CRUD |
user_assignments | R |
user_dept_group | R |
user_info | R |
um_main
| Table | Ops |
|---|---|
addresses | R |
benefit_defs | CRUD |
benefit_plans | R |
carriers | R |
claim_line_diag_codes | R |
claim_lines | R |
claim_messages | R |
claims | CRUD |
client_segment_users | R |
client_segments | R |
cm_triggers | R |
cobra_event | R |
cobra_qb | R |
cobra_stub | R |
codes | CUD |
contracts | R |
diagnosis_codes | CRUD |
diagnosis_groups | CRUD |
election_coverages | R |
elections | R |
event | R |
family | R |
fund_register | R |
fundtrans | R |
group_contacts | R |
group_coverages | R |
group_stoploss_parms | R |
groups | R |
health_care_networks | R |
medical_directors | CRUD |
member_cat_val | R |
member_eligibilities | R |
members | CRUD |
plan_pkgs | R |
procedure_codes | CRUD |
procedure_groups | CRUD |
providers | R |
security_user_class_user | R |
security_user_group | R |
um_appealer_types | CRUD |
um_case_dispositions | CRUD |
um_cases | CRUD |
um_categories | CRUD |
um_cm_possible_case_claim | R |
um_diagnosis_codes | CUD |
um_entities | R |
um_entity_warnings | R |
um_hold_messages | R |
um_medical_reviews | CUD |
um_notification_types | R |
um_notified_by | CRUD |
um_physician_types | R |
um_physicians | CUD |
um_procedure_codes | CUD |
um_provider_contacts | CRUD |
um_record_statuses | R |
um_review_outcomes | CRUD |
um_review_types | CRUD |
um_rules | R |
um_service_types | R |
um_warnings | R |
user_assignments | R |
user_info | R |
um_maint
| Table | Ops |
|---|---|
addresses | R |
capability | U |
claim_entries | R |
claim_entry_diag_codes | R |
claim_line_pricing_rules | R |
claim_lines | R |
claims | R |
claims_ub92_info | R |
cm_trigger_diag_codes | CRUD |
cm_trigger_proc_codes | CRUD |
cm_triggers | CRUD |
codes | R |
data | U |
dep_member_sys_key | R |
diagnosis_codes | R |
director | U |
election_coverages | R |
elections | R |
entity | U |
family | R |
fund_register | R |
group_enroll_opts | R |
group_option_vals | R |
groups | R |
health_care_networks | R |
medical_directors | CRUD |
member_cat_val | R |
member_eligibilities | R |
members | R |
plan_pkgs | R |
pm_addresses | R |
pricing_plans | R |
procedure_codes | R |
providers | R |
specialties | R |
sub_member_sys_key | R |
trigger | U |
um_entities | CRUD |
um_entity_medical_directors | CUD |
um_entity_warnings | CRUD |
um_warnings | CRUD |
unless | U |
w_um_warning_select | R |
um_ur
| Table | Ops |
|---|---|
benefit_defs | R |
benefit_plans | R |
calculated | U |
cm_billing | D |
cm_potentials | D |
db | D |
diagnosis_codes | R |
diagnosis_groups | R |
dw | U |
election_coverages | R |
flags | U |
health_care_networks | R |
member_eligibilities | R |
members | R |
plan_pkgs | R |
pricing_plans | D |
procedure_codes | R |
procedure_groups | R |
rules | U |
security_groupings | R |
service | U |
total_units_allowed | U |
um_benefit_definitions | CUD |
um_benefit_holds | CUD |
um_cases | CRUD |
um_diagnosis_code_holds | CUD |
um_diagnosis_codes | CRUD |
um_diagnosis_groups | CRUD |
um_entities | R |
um_hold_rules | CUD |
um_medical_reviews | D |
um_physicians | D |
um_procedure_code_holds | CUD |
um_procedure_codes | CUD |
um_procedure_groups | CUD |
um_provider_contacts | CRUD |
um_provider_holds | CUD |
um_rules | CUD |
um_services | CUD |
um_specialty_holds | CUD |
user_assignments | R |
user_dept_group | R |
user_info | R |