Other / Unclassified

Provisional schema

Reconstructed from application binaries (DataWindow bindings and embedded SQL), not from Oracle DDL. Column types are the application's declared types; constraints, indexes, triggers and exact server types are unknown until an Oracle DDL export is reconciled.

Key relationships (inferred from join usage)

Cardinality is indicative only; verify against DDL.

Tables

ada_surfaces_required

Used by modules: bensupport

Column	Declared type
proc_cd	char(13)

ada_teeth_required

Used by modules: bensupport

Column	Declared type
proc_cd	char(13)

aetna_report_groups

Used by modules: provider

Column	Declared type
file_suffix	char(20)
group_number	decimal(0)

aetna_tmp

Used by modules: provider

Column	Declared type
data	char(4000)

all_users

Used by modules: app_sec

Column	Declared type
user_id	—
username	—

alloc_entities

Used by modules: billing

Column	Declared type
alloc_entity_cd	char(15)
alloc_entity_sys_key	number
description	char(50)

annual_statement_options

Used by modules: enrolrpt

Column	Declared type
active_hours	decimal(1)
contingent_benef_ind	char(1)
customize_instructions	char(285)
group_id	char(15)
incl_add_dependents_ind	char(1)
incl_all_coverage_ind	char(1)
incl_partner_ind	char(1)
incl_salary_ind	char(1)
incl_ssn_ind	char(1)
instruction_fts_irs_custom	char(285)
location_instructions	char(1)
print_division_name_ind	char(1)
spouse_eligibility_cd	char(1)

any

Used by modules: drugplan, enroll

(referenced in SQL; no column details captured)

aud_trail_mbr

Used by modules: enrolaud

Column	Declared type
audit_activity	char(3)
audit_dt	datetime
audit_user_id	char(8)
chg_comment	char(2000)
chg_desc	char(2000)
dep_member_sys_key	decimal(0)
sub_member_sys_key	decimal(0)
tbl_key	char(500)
tbl_name	char(30)

batch_reports

Used by modules: client, cobrarpt, enrolrpt, homersys

Column	Declared type
allow_run_events	char(1)
allow_times	char(1)
report_cd	decimal(0)
report_dw	char(50)
report_name	char(50)
report_parameter_window	char(50)
report_type	char(20)

calculated

Used by modules: um_cm, um_ur

(referenced in SQL; no column details captured)

capability

Used by modules: funding, um_maint

(referenced in SQL; no column details captured)

carriers

Used by modules: client, enroll, mailobj, stoploss, um_main

Column	Declared type
active_ind	char(1)
addr_no	decimal(0)
carrier_cd	—
carrier_name	char(50)
carrier_sys_key	decimal(0), number
contact_name	char(50)
display_name	char(50)
e_mail_addr	char(40)
fax_no	char(13)
phone_no	char(13)
waiver_ind	char(1)

carryover_rules

Used by modules: bensupport, clmsproc

Column	Declared type
carryover_rule_cd	char(10)
carryover_rule_sys_key	decimal(0), number
description	char(40)
pct	decimal(0), decimal(2)
period_length	decimal(0)
period_type_cd	char(10)
rule_fulfillment_flg	char(1)

characteristics

Used by modules: pfcdwsrv, system

(referenced in SQL; no column details captured)

cigna_report_groups

Used by modules: clmrpt

Column	Declared type
group_id	char(15)
policy_number	char(10)

codes

Used by modules: app_sec, benplans, bensupport, billfunc, billing, chkrundw, claims, client, clmentry, clmsproc, clmutils, cob, cobra, cobradw, drugplan, enroll, enrollutils, enrolrpt, funding, homersys, mailobj, moon, pricing, provider, reprint, sales, stoploss, svclog, system, um_cm, um_main, um_maint

Column	Declared type
code_desc	char(50)
code_display	char(10)
code_display_seq	decimal(0), number
code_key	char(10), char(13)
code_short_desc	char(10)
code_value	char(10), char(40)
contract_level_display	char(10)
contract_period_display	char(10)
create_dt	datetime
create_user_id	char(8)
edit_mode	number
eff_dt	datetime
exp_dt	datetime
updt_dt	datetime
updt_user_id	char(8)

compound_ben_defs

Used by modules: benplans, claims, clmentry, clmsproc

Column	Declared type
benefit_def_sys_key	decimal(0)
child_def_sys_key	decimal(0)
parent_key	number

consolidated_vendors

Used by modules: base, provider

(referenced in SQL; no column details captured)

contract_holds

Used by modules: provider

Column	Declared type
contract_sys_key	number
end_dt	datetime
end_dt_type	char(10)
hold_reason	char(10)
start_dt	datetime

contract_pricing

Used by modules: provider

Column	Declared type
contract_sys_key	number
eff_dt	datetime
exp_dt	datetime
pricing_plan_sys_key	number

contract_withholds

Used by modules: base, provider

Column	Declared type
contract_sys_key	number
eff_dt	datetime
exp_dt	datetime
exp_reason	char(10)
vendor_sys_key	number
withhold_flg	char(1)
withhold_pct	decimal(3)
withhold_type	char(10)

contracts

Used by modules: base, clmshare, enroll, homersys, provider, um_main

Column	Declared type
contract_sys_key	number
contract_type	char(10)
drg_base_multiplier	decimal(4)
drg_cap_rate	decimal(2)
eff_dt	datetime
enrollment_limit	number
exp_dt	datetime
exp_reason	char(10)
hcn_sys_key	number
network_provider_id	char(25)
new_patient_flg	char(1)
pcp_flg	char(1)
provider_sys_key	number
ra_format	char(10)
rownum	number
vendor_sys_key	number
withhold_flg	char(1)

conversion_factor_details

Used by modules: pricing

Column	Declared type
base_multiplier	decimal(3)
conversion_detail_sys_key	number
conversion_factor_sys_key	number
eff_dt	datetime
exp_dt	datetime
malpractice_multiplier	decimal(3)
practice_multiplier	decimal(3)
proc_cd_end	char(13)
proc_cd_start	char(13)
proc_cd_type	char(10)
time_multiplier	decimal(3)
work_multiplier	decimal(3)
zip_code	char(3)

conversion_factors

Used by modules: pricing

Column	Declared type
conversion_factor_sys_key	decimal(0)
create_dt	datetime
name	char(50)
updt_dt	datetime

custom_term_transactions

Used by modules: enroll

Column	Declared type
dep_member_sys_key	decimal(0), number
exp_cd	char(10)
lock_cd	—
sub_member_sys_key	number

data

Used by modules: clmsproc, funding, um_maint

(referenced in SQL; no column details captured)

db

Used by modules: um_cm, um_ur

(referenced in SQL; no column details captured)

dep_member_sys_key

Used by modules: base, cobrarpt, funding, um_maint

(referenced in SQL; no column details captured)

drg_codes

Used by modules: pricing

Column	Declared type
description	char(65)
drg_cd	char(3)

drg_weight_details

Used by modules: pricing

Column	Declared type
drg_cd	char(3)
drg_weight	decimal(4)
drg_weight_sys_key	decimal(0)
from_dt	datetime
thru_dt	datetime

drg_weights

Used by modules: pricing

Column	Declared type
create_dt	datetime
drg_weight_sys_key	decimal(0)
name	char(50)
updt_dt	datetime

dw

Used by modules: provider, um_cm, um_ur

(referenced in SQL; no column details captured)

eff_dt

Used by modules: base, funding

(referenced in SQL; no column details captured)

error

Used by modules: app_sec, bensupport, claims, client, cobra, drugplan, enroll, pfcdwsrv

(referenced in SQL; no column details captured)

event

Used by modules: app_sec, benplans, billing, claims, client, clmrpt, cob, enroll, enrolrpt, funding, homersys, pfcmain, pfcwnsrv, pricing, provider, sales, um_main

(referenced in SQL; no column details captured)

existing

Used by modules: benplans, clmutils

(referenced in SQL; no column details captured)

exp_dt

Used by modules: base, funding

(referenced in SQL; no column details captured)

ext_adjust

Used by modules: claims

Column	Declared type
adjust_type	char(10)
create_dt	datetime
ext_adjust_seq	decimal(0)
new_ext_claim_id	char(17)
old_claim_id	char(17)
old_ext_claim_id	char(17)
status_cd	char(20)

ext_output_transactions

Used by modules: clmentry, clmrpt

Column	Declared type
processed_dt	datetime

failed

Used by modules: billfunc, billing, claims, clmshare, funding, pfcmain

(referenced in SQL; no column details captured)

fails

Used by modules: benplans, billing, enroll, funding, pfcmain, reprint

(referenced in SQL; no column details captured)

flag

Used by modules: enroll, funding, svclog

(referenced in SQL; no column details captured)

flags

Used by modules: pfcdwsrv, pfcmain, system, um_cm, um_ur

(referenced in SQL; no column details captured)

for

Used by modules: enroll, homersys, stoploss

(referenced in SQL; no column details captured)

force_update

Used by modules: client, clmshare, cob, enroll

(referenced in SQL; no column details captured)

function

Used by modules: idcard, pfcdwsrv

(referenced in SQL; no column details captured)

general_cat

Used by modules: client, homersys

Column	Declared type
mandatory_for_grp_flg	char(1)
mbr_cat_applied_cd	char(10)
member_cat_cd	char(10)
member_cat_reqd_flg	char(1)
val_saved_as_cd	char(10)

general_cat_val

Used by modules: client

Column	Declared type
member_cat_cd	—
member_cat_val_cd	—

global_messages

Used by modules: claims, clmrpt, clmshare, clmsproc, provider, system

Column	Declared type
action	char(2000)
area	char(10)
category	char(20)
control_cd	char(10)
description	char(2000), char(50)
glob_msg_number	number
glob_msg_type	char(10)
message_seq_no	number

grp_chg_prop_hist

Used by modules: client

Column	Declared type
chg_child_group_id	—
chg_parent_group_id	—

grp_covr_elig_rules

Used by modules: client

Column	Declared type
benefit_coverage_cd	char(15)
benefit_coverage_type_cd	char(10)
edit_mode	number
eff_dt	datetime
exp_dt	datetime
group_id	char(15)
member_cat_cd	char(10)
member_cat_val_cd	char(10)

grp_mbr_cat_val

Used by modules: billing, client, enroll, system

Column	Declared type
applied_to_members_dt	datetime
edit_mode	number
group_id	char(15)
mbr_cat_val_eff_dt	datetime
mbr_cat_val_exp_dt	datetime
member_cat_cd	char(10)
member_cat_val_cd	char(10)
unapplied_chg_flg	char(1)

grp_sched_funds

Used by modules: funding

Column	Declared type
comp_id	decimal(0)
fund_page_code	char(10)

grp_sched_incls

Used by modules: funding

Column	Declared type
comp_id	decimal(0)
group_id	char(15)

hb1_members

Used by modules: enroll, system

Column	Declared type
coverage_type_cd	char(10)
create_dt	datetime
create_user_id	char(8)
dep_member_sys_key	decimal(0)
eff_dt	datetime
exp_cd	char(10)
exp_dt	datetime
monthly_premium	decimal(2)
sub_member_sys_key	decimal(0)

hb1_payments

Used by modules: enroll, enrolrpt

Column	Declared type
amt	decimal(2)
check_no	char(10)
dep_member_sys_key	decimal(0)
eff_dt	datetime
paid_thru_dt	datetime
recv_dt	datetime
sub_member_sys_key	decimal(0)

health_care_networks

Used by modules: benplans, billfunc, billing, claims, clmprint, clmrpt, clmshare, clmutils, enroll, enrolrpt, homersys, moon, provider, sales, svclog, um_main, um_maint, um_ur

Column	Declared type
add_contracts_flg	char(1)
add_providers_flg	char(1)
census_format	char(10)
client_segment	char(10)
code_review_flg	char(1)
contract_flg	char(1)
electronically_paid_flg	char(1)
hcn	char(50)
hcn_id	char(10)
hcn_name	char(50)
hcn_sys_key	decimal(0), number
name	char(50), char(77)
reason_sys_key	decimal(0)
reject_non_reprice_flg	char(1)
segment	char(10)
selected	number
type	char(10)
type_cd	char(10)

homer_detail

Used by modules: clmsproc

Column	Declared type
homer_detail_claimed	decimal(2)
homer_detail_date	datetime
homer_detail_discount	decimal(2)
homer_detail_hcpcs_code	char(5)
homer_detail_seq_no	—
homer_detail_ssnumber	—
homer_detail_ucr_used	decimal(2)
homer_detail_worksheet	—

homer_revenue

Used by modules: clmsproc

Column	Declared type
homer_revenue_claimed	decimal(2)
homer_revenue_code	char(3)
homer_revenue_discount	decimal(2)
homer_revenue_seq_no	—
homer_revenue_ssnumber	—
homer_revenue_units	decimal(0)
homer_revenue_worksheet	—

ibnr_work

Used by modules: sales

Column	Declared type
coverage	char(10)
ee_count	number
group_id	—
ibnr_amt	number
ibnr_count	number
member_count	number
paid_month	datetime

id_card_req

Used by modules: homersys, idcard, stoploss

Column	Declared type
benefit_coverage_cd	char(15)
benefit_coverage_type_cd	char(10)
cobra_flg	char(1)
coverage_level_cd	char(10)
covr_eff_dt	datetime
f_name	char(25)
group_id	—
group_name	char(50)
id_req_batch_id	—
l_name	char(25)
m_name	char(25)
member_sys_key	decimal(0)
req_complete_dt	datetime
req_complete_ind	char(1)
soc_sec_no	char(9)

id_card_setup

Used by modules: stoploss

Column	Declared type
benefit_coverage_cd	—
benefit_coverage_type_cd	—
group_id	—

if

Used by modules: bensupport, cobra, enroll, enrolrpt

(referenced in SQL; no column details captured)

is

Used by modules: bensupport, drugplan

(referenced in SQL; no column details captured)

it

Used by modules: cobra, pfcapsrv, pfcwnsrv

(referenced in SQL; no column details captured)

lag_triangle_work

Used by modules: sales

Column	Declared type
grouping	—
month1	decimal(0)
month10	decimal(0)
month11	decimal(0)
month12	decimal(0)
month2	decimal(0)
month3	decimal(0)
month4	decimal(0)
month5	decimal(0)
month6	decimal(0)
month7	decimal(0)
month8	decimal(0)
month9	decimal(0)
row_month	datetime

level_sched_items

Used by modules: bensupport, clmsproc

Column	Declared type
coverage_level_cd	char(10)
flat_amount	number
level_sched_sys_key	number
member_cat_cd	char(10)
member_cat_multiplier	number
rounding_rule_sys_key	decimal(0), number
step_rate_sys_key	decimal(0), number

level_scheds

Used by modules: bensupport, clmsproc

Column	Declared type
create_dt	datetime
create_user_id	char(8)
description	char(40)
level_sched_cd	char(10)
level_sched_sys_key	decimal(0), number
updt_dt	datetime
updt_user_id	char(8)

lstr_parms

Used by modules: client, enrolrpt

Column	Declared type
category_code	—
coverage_levels	—
dw_name	—
groups	—
rpt_date	—
rpt_name	—

master_multipliers

Used by modules: pricing

Column	Declared type
from_dt	datetime
multiplier	decimal(4)
thru_dt	datetime
unit_type_cd	char(10)

medical_directors

Used by modules: mailobj, svclog, um_main, um_maint

Column	Declared type
addr_no	decimal(0)
e_mail_addr	char(40)
f_name	char(25)
fax_no	char(13)
l_name	char(25)
m_name	char(25)
medical_director_sys_key	decimal(0), number
phone_no	char(13)
specialty	char(10)
suffix	char(10)
title	char(10)
type_cd	char(10)

messages

Used by modules: clmshare, pfcapsrv

Column	Declared type
msgbutton	char(17)
msgdefaultbutton	long
msgicon	char(12)
msgid	char(40)
msgprint	char(1)
msgseverity	long
msgtext	char(255)
msgtitle	char(255)
msguserinput	char(1)

modifiers

Used by modules: benplans, clmshare

Column	Declared type
anes_ind	—
description	char(40)
modifier	char(2)

month_list

Used by modules: sales

Column	Declared type
first_day	—

new

Used by modules: funding, sales

(referenced in SQL; no column details captured)

ome_resa_wire_xfer_adj

Used by modules: funding

Column	Declared type
adj_type_cd	char(10)
amount	decimal(2)
coverage_type_cd	char(10)
group_id	char(15)
note	char(50)
tran_date	datetime

oon_product_claim_types

Used by modules: moon

Column	Declared type
allowance_days	number
claim_type	char(10)
from_dt	datetime
minimum_claimed_amt	number
override_all_cm	char(1)
override_cm_negotiated_rates	char(1)
override_manual_price	char(1)
pay_by_days	number
product	char(20)
retention_days	number
threshold_claimed_amt	number
thru_dt	datetime

oon_product_groups

Used by modules: moon

Column	Declared type
from_dt	datetime
group_id	char(15)
product	char(20)
thru_dt	datetime

oon_product_hcn_exclusions

Used by modules: moon

Column	Declared type
from_dt	datetime
hcn_sys_key	number
product	char(20)
thru_dt	datetime

oon_products

Used by modules: moon

Column	Declared type
comments	char(2000)
description	char(255)
product	char(20)

option_val_char

Used by modules: base, funding

(referenced in SQL; no column details captured)

optum_report_audit

Used by modules: provider

Column	Declared type
add_user	char(16)
end_dt	datetime
run_dt	datetime
start_dt	datetime

outb_edi_clearhouse_contacts

Used by modules: provider

Column	Declared type
clearinghouse_id	char(10)
contact_no	decimal(0)
rownum	number

outb_edi_tradingpart_contacts

Used by modules: provider

Column	Declared type
contact_no	decimal(0)
rownum	number
trading_partner_id	char(10)

panel_pricing

Used by modules: provider

Column	Declared type
eff_dt	datetime
exp_dt	datetime
panel_sys_key	number
pricing_plan_sys_key	number

panel_withholds

Used by modules: base, provider

Column	Declared type
eff_dt	datetime
exp_dt	datetime
exp_reason	char(10)
panel_sys_key	number
vendor_sys_key	number
withhold_flg	char(1)
withhold_pct	decimal(3)
withhold_type	char(10)

panels

Used by modules: provider

Column	Declared type
client_segment	char(10)
eff_dt	datetime
exp_dt	datetime
exp_reason	char(10)
hcn_sys_key	number
name	char(50)
panel_id	char(15)
panel_sys_key	number
rownum	number
withhold_flg	char(1)

patient_sys_key

Used by modules: clmsproc, provider, stoploss

(referenced in SQL; no column details captured)

pkg_riders

Used by modules: benplans

Column	Declared type
benefit_pkg_sys_key	decimal(0)
eff_dt	datetime
exp_dt	datetime
rider_sys_key	decimal(0)

pkg_rule_dependencies

Used by modules: benplans, clmsproc

Column	Declared type
accum_sys_key	decimal(0)
accum_type_cd	char(10)
apply_pct	decimal(2)
benefit_pkg_sys_key	decimal(0)
benefit_rule_sys_key	decimal(0)
eff_dt	datetime

pkg_rule_fulfillments

Used by modules: base, benplans, clmsproc

Column	Declared type
benefit_pkg_sys_key	decimal(0), number
benefit_rule_sys_key	decimal(0), number
eff_dt	datetime
fulfilled_benefit_rule_sys_key	decimal(0), number

pkg_rule_requirements

Used by modules: benplans, clmsproc

Column	Declared type
accum_sys_key	decimal(0)
accum_type_cd	char(10)
benefit_pkg_sys_key	decimal(0)
benefit_rule_sys_key	decimal(0)
eff_dt	datetime
max_value	decimal(2)
min_value	decimal(2)
zero_val_flg	char(1)

pkg_rules

Used by modules: benplans, bensupport, clmentry, clmrpt, clmsproc, clmutils

Column	Declared type
accum_sys_key	decimal(0), number
auth_indicator	char(1)
benefit_pkg_sys_key	decimal(0), number
benefit_rule_sys_key	decimal(0), number
dep_flg	char(1)
description	char(40)
eff_dt	datetime
exp_dt	datetime
pcp_indicator	char(1)
pre_admission_indicator	char(1)
pre_certification_indicator	char(1)
priority	decimal(0)
referral_indicator	char(1)
spouse_flg	char(1)
subscriber_flg	char(1)

place_of_service_codes

Used by modules: benplans, pricing

Column	Declared type
description	char(50)
mapped_place_of_service_cd	char(2)
place_of_service_cd	char(2)

pm_addresses

Used by modules: billing, clmforms, clmprint, clmshare, clmutils, enroll, funding, homersys, mailobj, provider, reprint, svclog, um_cm, um_main, um_maint, um_ur

Column	Declared type
addr1	char(40)
addr2	char(40)
addr_no	decimal(0)
city	char(40)
client_segment	char(10)
country	char(40)
rownum	number
state	char(2)
std_addr_flg	char(1)
zip	char(9)

pm_contacts

Used by modules: enroll, idcard, mailobj, moon, provider, um_cm, um_main, um_ur

Column	Declared type
addr_no	number
comments	char(100)
contact_cat_cd	char(10)
contact_no	number
email_addr	char(50)
f_name	char(25)
fax_no	char(13)
l_name	char(25)
m_name	char(25)
phone_ext_no	char(6)
phone_no	char(13)
position	char(40)
title_cd	char(10)

print

Used by modules: pfcdwsrv, reprint

(referenced in SQL; no column details captured)

procedure_code_groups

Used by modules: bensupport, clmsproc

Column	Declared type
proc_cd	char(13)
proc_cd_type	char(10)
proc_group_sys_key	decimal(0)

procedure_codes

Used by modules: benplans, bensupport, clmentry, clmshare, clmutils, pricing, stoploss, um_cm, um_main, um_maint, um_ur

Column	Declared type
create_dt	datetime
create_user_id	char(8)
proc_cd	char(13)
proc_cd_anes_ind	char(1)
proc_cd_claim_type	char(10)
proc_cd_days	char(1)
proc_cd_desc	char(60), char(80)
proc_cd_eff_dt	datetime
proc_cd_exp_dt	datetime
proc_cd_hpr	char(1)
proc_cd_observation_ind	char(1)
proc_cd_short_desc	char(25), char(80)
proc_cd_status	char(1)
proc_cd_type	char(10)
revenue_desc	char(25)
updt_dt	datetime
updt_user_id	char(8)

procedure_groups

Used by modules: benplans, bensupport, clmentry, clmsproc, pricing, um_main, um_ur

Column	Declared type
create_dt	datetime
create_user_id	char(8)
proc_group_cd	char(10)
proc_group_desc	char(80)
proc_group_sys_key	decimal(0)
updt_dt	datetime
updt_user_id	char(8)

qmcso_custodians

Used by modules: enroll, reprint

Column	Declared type
dep_member_sys_key	number
ee_custodial_guardian	char(1)
eff_dt	datetime
exp_dt	datetime
qmcso_custodian_sys_key	number
sub_member_sys_key	number
vendor_sys_key	number

qmcso_guardians

Used by modules: enroll

Column	Declared type
addr_no	decimal(0)
dep_member_sys_key	decimal(0)
eff_dt	datetime
f_name	char(25)
l_name	char(25)
m_name	char(25)
qmcso_guardian_sys_key	decimal(0)
sub_member_sys_key	decimal(0)

question

Used by modules: cobra, enroll, reprint

(referenced in SQL; no column details captured)

report_archive

Used by modules: claims, system

Column	Declared type
cd_label	char(10)
claim_letter_user_id	char(8)
create_dt	datetime
create_user_id	char(8)
file_name	char(40)
group_id	char(15)
item_id	char(40)
last_request_dt	datetime
orig_run_dt	datetime
report_sys_key	decimal(0)
report_type_cd	char(10)
updt_dt	datetime
updt_user_id	char(8)

report_data

Used by modules: billing, cobradw, enroll, system

Column	Declared type
action_cd	char(10)
action_dt	datetime
archive_location	char(40)
archive_media	char(40)
create_dt	datetime
description	char(255)
disposition_cd	char(10)
object_type_cd	char(10)
report_cat_cd	char(10)
report_data_sys_key	decimal(0)

report_info

Used by modules: reprint, sales

Column	Declared type
allow_ext_view	char(1)
control_cd	char(10)
create_dt	datetime
create_user_id	char(8)
description	char(50)
override_reissue_days	decimal(0)
parameter_mask	char(50)
reason_sys_key	decimal(0)
report_cd	char(10)
report_dw	char(50)
report_dw2	char(50)
report_object	char(50)
report_type_cd	char(10)
updt_dt	datetime
updt_user_id	char(8)

report_objects

Used by modules: billing, enroll, system

Column	Declared type
report_data_sys_key	decimal(0)
report_object_seq_no	decimal(0)

rider_rules

Used by modules: benplans

Column	Declared type
benefit_pkg_sys_key	decimal(0)
benefit_rule_sys_key	decimal(0)
eff_dt	datetime
rider_action_flg	char(1)
rider_sys_key	decimal(0)

riders

Used by modules: benplans

Column	Declared type
description	char(40)
rider_cd	char(10)
rider_sys_key	decimal(0)

rounding_rules

Used by modules: bensupport, clmsproc

Column	Declared type
description	char(40)
direction	char(10)
rounding_rule_cd	char(10)
rounding_rule_sys_key	number
significance	decimal(0), number

rpt_svc_cat_defs

Used by modules: sales

Column	Declared type
rpt_svc_cat_sys_key	—

rpt_svc_cats

Used by modules: sales

Column	Declared type
client_segment	char(10)
rpt_svc_cat_sys_key	decimal(0)
rpt_type	char(10)
svc_cat_cd	char(50)

rule

Used by modules: billing, clmutils

(referenced in SQL; no column details captured)

rule_contingency_defs

Used by modules: benplans, clmsproc

Column	Declared type
benefit_def_sys_key	decimal(0), number
benefit_rule_sys_key	decimal(0), number

rule_defs

Used by modules: benplans, claims, clmsproc, clmutils

Column	Declared type
benefit_def_sys_key	number
benefit_rule_sys_key	decimal(0), number

rules

Used by modules: um_cm, um_ur

(referenced in SQL; no column details captured)

sched_comp

Used by modules: funding

Column	Declared type
comp_desc	char(40)
comp_id	decimal(0)
run_type_cd	char(10)

sched_run_comps

Used by modules: funding

Column	Declared type
comp_id	decimal(0)
run_id	decimal(0)

schedule_runs

Used by modules: funding

Column	Declared type
activity_reqd_flg	char(1)
nightly_cd	char(10)
run_active_flg	char(1)
run_desc	char(40)
run_dt	datetime
run_id	decimal(0)

second_opinion_lists

Used by modules: benplans, bensupport

Column	Declared type
create_dt	datetime
create_user_id	char(8)
description	char(40)
penalize_all_flg	char(1)
penalty_max	decimal(2), number
penalty_pct	decimal(2), number
second_opinion_cd	char(10)
second_opinion_sys_key	decimal(0), number
updt_dt	datetime
updt_user_id	char(8)

second_opinion_procs

Used by modules: bensupport

Column	Declared type
create_dt	datetime
create_user_id	char(8)
proc_cd	char(13)
proc_cd_type	char(10)
second_opinion_sys_key	decimal(0), number
updt_dt	datetime
updt_user_id	char(8)

service

Used by modules: um_cm, um_ur

(referenced in SQL; no column details captured)

specialties

Used by modules: benplans, clmshare, funding, pricing, provider, um_maint

Column	Declared type
anes_ind	char(1)
description	char(50)
matria_spec_cd	—
specialty	char(10)

sql

Used by modules: benplans, claims, pfedwsrv

(referenced in SQL; no column details captured)

status

Used by modules: clmshare, pfcdwsrv, stoploss

(referenced in SQL; no column details captured)

step_rate_items

Used by modules: bensupport

Column	Declared type
max_value	number
min_value	number
rate_amount	number
step_rate_sys_key	number

step_rate_scheds

Used by modules: bensupport

Column	Declared type
child_updt_dt	datetime
child_updt_user_id	char(8)
create_dt	datetime
create_user_id	char(8)
description	char(40)
step_rate_cd	char(10)
step_rate_sys_key	number
updt_dt	datetime
updt_user_id	char(8)

successful

Used by modules: app_sec, bensupport, clmsproc, enroll

(referenced in SQL; no column details captured)

table

Used by modules: clmutils, moon

(referenced in SQL; no column details captured)

temp_benefit_defs

Used by modules: clmsproc

Column	Declared type
benefit_def_sys_key	—
lock_seq_no	—
rule_order	—

temp_report_groups

Used by modules: sales

Column	Declared type
group_id	—
report_seq	—

test_log

Used by modules: homersys

Column	Declared type
build	char(10)
complete_dt	datetime
log_type	char(10)
module	char(10)
prog_objects	char(80)
prog_priority	char(8)
prog_user_id	char(8)
prog_user_notes	char(250)
request_dt	datetime
request_user_id	char(8)
system_msg	char(300)
test_log_database	char(50)
test_log_sys_key	decimal(0)
user_details	char(300)
user_msg	char(300)
user_priority	char(8)
version	char(30)
window	char(50)

this

Used by modules: billing, homersys, pfcmain, reprint

(referenced in SQL; no column details captured)

tiered_per_diem_details

Used by modules: pricing

Column	Declared type
days_from	decimal(0)
days_thru	decimal(0)
from_dt	datetime
per_diem_amt	decimal(2)
per_diem_type_cd	char(10)
thru_dt	datetime
tiered_per_diem_detail_sys_key	number
tiered_per_diem_sys_key	number

tiered_per_diem_schedules

Used by modules: pricing

Column	Declared type
create_dt	datetime
name	char(50)
tiered_per_diem_sys_key	decimal(0)
updt_dt	datetime

tooth_code_numbers

Used by modules: bensupport

Column	Declared type
tooth_number	char(2)
tooth_type_sys_key	decimal(0)

tooth_types

Used by modules: benplans, bensupport

Column	Declared type
description	char(40)
tooth_type_cd	char(10)
tooth_type_sys_key	number

type_of_service_codes

Used by modules: clmshare

Column	Declared type
anes_ind	—
type_of_service_cd	—

unit_schedule_details

Used by modules: pricing

Column	Declared type
base_units	decimal(2)
eff_dt	datetime
exp_dt	datetime
malpractice_units	decimal(2)
modifier	char(2)
practice_units	decimal(2)
proc_cd	char(13)
proc_cd_type	char(10)
time_units	decimal(2)
unit_detail_sys_key	number
unit_sys_key	number
work_units	decimal(2)
zip_code	char(3)

unit_schedules

Used by modules: pricing

Column	Declared type
create_dt	datetime
name	char(50)
unit_sys_key	decimal(0)
updt_dt	datetime

unless

Used by modules: funding, provider, um_maint

(referenced in SQL; no column details captured)

unsearchable_tins

Used by modules: homersys, provider

Column	Declared type
tin	number
tin_type	char(10)

v_claim_members

Used by modules: funding

Column	Declared type
claim_id	—
earliest_from_dt	datetime
patient_f_name	char(25)
patient_l_name	char(25)
patient_m_name	char(25)
patient_member_id	char(15)
patient_sys_key	number
sub_f_name	char(25)
sub_l_name	char(25)
sub_m_name	char(25)
sub_member_id	char(15)
sub_member_sys_key	number
total_claimed_amt	decimal(2)

v_fund_register_rpt

Used by modules: sales, stoploss

Column	Declared type
applied_amt	decimal(2), number
applied_dt	datetime
claim_id	char(17)
group_id	char(15)
paid_dt	—
payable_amt	—
payee_cd	char(10)
payee_sys_key	—
payment_type_cd	char(10)
register_dt	datetime
register_sys_key	—
waiver_ind	char(1)
worksheet_ind	—

v_fund_register_rpt_grp

Used by modules: sales

Column	Declared type
applied_amt	decimal(2)
applied_dt	datetime
claim_id	—
discount_amt	number
fund_page_sys_key	—
group_id	char(15)
payee_cd	—
payee_sys_key	—
payment_type_cd	char(10)
register_sys_key	number
report_seq	—
type_of_claim	—
worksheet_ind	—

v_pkg_rules

Used by modules: claims, clmsproc

Column	Declared type
accum_sys_key	number
auth_indicator	char(1)
benefit_pkg_sys_key	number
benefit_rule_sys_key	number
dep_flg	char(1)
eff_dt	datetime
exp_dt	datetime
pcp_indicator	char(1)
pre_admission_indicator	char(1)
pre_certification_indicator	char(1)
priority	number
referral_indicator	char(1)
rule_order	char(32)
spouse_flg	char(1)
subscriber_flg	char(1)

valid_methods

Used by modules: pricing

Column	Declared type
method	char(10)
pricing_type	char(10)

wang_acm

Used by modules: clmsproc

Column	Declared type
accum_amt	number
accum_sys_key	char(0)
accum_type	char(0)
carryover_amt	number
dep_member_sys_key	number
from_dt	datetime
sub_member_sys_key	number
thru_dt	datetime
wang_accum	number
wang_amt	decimal(2)
wang_dep	char(1)
wang_from	char(6)
wang_ssn	char(9)
wang_thru	char(6)

wang_claim_line_rules

Used by modules: clmsproc

Column	Declared type
benefit_rule_sys_key	number
claim_id	char(17)
claim_line_rule_sys_key	number
claim_seq	number
reason_sys_key	number
retain_amt	decimal(2)

wang_claim_lines

Used by modules: clmsproc

Column	Declared type
allowed_after_coi_amt	decimal(2)
allowed_after_copay_amt	decimal(2)
allowed_after_ded_amt	decimal(2)
allowed_amt	decimal(2)
benefit_amt	decimal(2)
claim_id	char(17)
claim_seq	decimal(0)
claimed_amt	decimal(2)
considered_amt	decimal(2)
paid_by_other_sources_amt	decimal(2)
payable_amt	decimal(2)
rate_charged_amt	decimal(2)
reprice_allow_extended	decimal(2)
reprice_allow_per_unit	decimal(2)
reprice_discount_amt	decimal(2)

wang_claims

Used by modules: clmsproc

Column	Declared type
claim_id	—
sub_member_sys_key	—

wang_claims_xref

Used by modules: clmsproc

Column	Declared type
claim_id	—
clm_detail_seq	decimal(0)
clm_revenue_seq	decimal(0)
clm_ssnumber	—
clm_worksheet	—

wang_group_rule_map

Used by modules: clmsproc

Column	Declared type
benefit_rule_sys_key	number
master_group_id	char(15)
wang_accum	number

wang_rej_map

Used by modules: clmsproc

Column	Declared type
map_reason_cd	char(10)
map_rule_cd	char(15)
reason_sys_key	decimal(0)
rule_period_length	number
rule_period_type_cd	char(10)
rule_type_cd	char(10)
wang_desc	char(100)
wang_rej_cd	decimal(0)

wang_rule_map

Used by modules: clmsproc

Column	Declared type
benefit_rule_sys_key	number
wang_accum	number