Stop-Loss

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

sl_contract_coverages

Used by modules: stoploss

Column	Declared type
benefit_coverage_type_cd	char(10)
sl_contract_sys_key	number

sl_contract_domestic_tins

Used by modules: stoploss

Column	Declared type
sl_contract_sys_key	number
tin	number
tin_type	char(10)

sl_contract_excl_plans

Used by modules: stoploss

Column	Declared type
benefit_coverage_cd	char(15)
benefit_coverage_type_cd	char(10)
sl_contract_sys_key	number

sl_contract_factors

Used by modules: stoploss

Column	Declared type
benefit_coverage_type_cd	char(15)
coverage_level_cd	char(10)
factor_amt	number
factor_type_cd	char(10)
factor_units	number
sl_contract_sys_key	number
start_dt	datetime

sl_contract_groups

Used by modules: stoploss

Column	Declared type
eff_dt	datetime
exp_dt	datetime
group_id	char(15)
sl_contract_sys_key	number

sl_contract_lasers

Used by modules: stoploss

Column	Declared type
deductible_amt	number
dep_member_sys_key	number
incurred_from_dt	datetime
incurred_thru_dt	datetime
paid_from_dt	datetime
paid_thru_dt	datetime
sl_contract_sys_key	number
sub_member_sys_key	number

sl_contract_option_vals

Used by modules: stoploss

Column	Declared type
eff_dt	datetime
exp_dt	datetime
option_val_cd	char(10)
option_val_char	char(50)
option_val_dt	datetime
option_val_no	number
sl_contract_option_cd	char(10)
sl_contract_sys_key	number

sl_contract_options

Used by modules: stoploss

Column	Declared type
code_key	char(10)
option_cd	char(10)
sl_contract_option_cd	—
val_saved_as_cd	char(10)

sl_contracts

Used by modules: stoploss

Column	Declared type
aggr_specific_amt	number
carrier_sys_key	number
contract_level_cd	char(10)
contract_period_cd	char(10)
contract_reimb_limit	number
corridor_pct	number
deductible_amt	number
description	char(50)
end_dt	datetime
incurred_from_dt	datetime
incurred_thru_dt	datetime
max_change_pct	number
member_reimb_limit	number
min_attachment_amt	number
min_attachment_pct	number
notes	char(2000)
paid_from_dt	datetime
paid_thru_dt	datetime
policy_no	char(20)
reim_domestic_pct	number
reim_standard_pct	number
run_in_limit_amt	number
run_in_period_length	number
run_in_period_type_cd	char(10)
run_out_period_length	number
run_out_period_type_cd	char(10)
sl_contract_cd	char(20)
sl_contract_sys_key	number
start_dt	datetime
tlo_attachment_amt	number
tlo_exercised_flg	char(1)
tlo_period_length	number
tlo_period_type_cd	char(10)

stoploss_waivers

Used by modules: client

Column	Declared type
create_user_id	char(8)
incur_from_dt	datetime
incur_thru_dt	datetime
member_sys_key	decimal(0)
waiver_from_dt	datetime
waiver_thru_dt	datetime