System, Security & Reference

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

addresses

Used by modules: base, billfunc, billing, chkrundw, client, clmforms, clmprint, clmutils, cob, cobradw, cobrarpt, drugplan, enrolaud, enroll, enrolrpt, funding, homersys, idcard, mailobj, provider, reprint, stoploss, system, um_main, um_maint

Column	Declared type
addr1	char(40)
addr2	char(40)
addr_no	decimal(0), number
addr_no2	decimal(0)
addr_type_cd	char(10)
audit_eff_dt	datetime
city	char(40)
country	char(40)
county	char(25)
create_dt	datetime
create_user_id	—
edit_mode	number
mail_addr2	char(40)
mail_addr3	char(40)
member_address	char(40)
member_apt	char(40)
member_city	char(40)
member_state	char(2)
member_zip	char(9)
min_audit_dt	datetime
rownum	number
state	char(2)
std_addr_flg	char(1)
updt_dt	—
updt_user_id	—
usa_flag	number
zip	char(9)

code_keys

Used by modules: bensupport, homersys, sales

Column	Declared type
code_key	char(10)
code_key_desc	char(40)
create_dt	datetime
create_user_id	char(8)
updt_dt	datetime
updt_user_id	char(8)

letter_headers

Used by modules: billfunc, clmforms, enroll, enrolrpt, homersys, reprint, system

Column	Declared type
font_size	number
group_id	char(15)
letter_type	char(10)
line1	char(80)
line2	char(80)
line3	char(80)
line4	char(80)
line5	char(80)
line6	char(80)
logo_characters	char(25)
logo_font	char(25)
override_phone_no	char(13)
override_phone_no_800	char(13)
override_phone_no_did	char(13)
override_phone_no_ext	char(5)

note_entities

Used by modules: enroll, homersys, svclog

Column	Declared type
entity_type	char(20)
entity_type_sys_key	decimal(0), number

note_key_codes

Used by modules: enroll, svclog

Column	Declared type
key_text	char(20)
note_key_code_sys_key	number
note_key_type_cd	char(10)

note_keys

Used by modules: enroll, svclog

Column	Declared type
note_key_code_sys_key	—
note_sys_key	—

notes

Used by modules: enroll, homersys, svclog

Column	Declared type
create_dt	datetime
create_user	char(8)
create_user_id	char(8)
entity_sys_key	char(255)
entity_type_sys_key	decimal(0), number
member_sys_key	—
note_sys_key	decimal(0), number
note_text	char(32759)
note_type_cd	—
text	char(32759)
updt_dt	datetime
updt_user_id	char(8)
vip_flg	—
vip_ind	char(1)

report_hist

Used by modules: enroll, funding, reprint

Column	Declared type
batch_id	char(40)
check_number	decimal(0)
create_dt	datetime
create_user_id	char(8)
dw_object	char(50)
format_type	char(10)
formtype	char(10)
group_id	char(15)
initial_prt_flg	char(1)
last_request_dt	datetime
last_user_request_id	char(8)
orig_run_dt	datetime
payee_sys_key	decimal(0)
prt_flg	char(1)
recipient_id	char(15)
recipient_type	char(2)
report_desc	char(200)
report_sys_key	decimal(0)
report_type_cd	char(10)
worksheet_number	char(15)

security_apps

Used by modules: pfcapsrv

Column	Declared type
application	char(32)
description	char(128)

security_db_role

Used by modules: app_sec

Column	Declared type
db_role	—
db_role_desc	—

security_groupings

Used by modules: app_sec, claims, clmshare, funding, homersys, pfcapsrv, provider, svclog, um_cm, um_ur

Column	Declared type
group_name	char(16)
user_name	char(16)

security_info

Used by modules: app_sec, clmshare, homersys, pfcapsrv

Column	Declared type
application	—
control	char(254)
status	char(1)
user_name	—
window	char(64)

security_menu_options

Used by modules: app_sec

Column	Declared type
menu	char(100)
name	char(16)
name_type	char(10)
setting	char(1)

security_template

Used by modules: homersys, pfcapsrv

Column	Declared type
application	char(32)
control	char(128)
description	char(254)
object_type	char(24)
window	char(64)

security_user_class

Used by modules: app_sec, claims, homersys

Column	Declared type
user_class	char(10)
user_class_desc	char(50)

security_user_class_user

Used by modules: app_sec, claims, client, clmrpt, clmutils, cobrarpt, drugplan, enrolaud, enroll, enrolrpt, funding, homersys, mailobj, provider, svclog, system, um_cm, um_main

Column	Declared type
name	char(16)
user_class	char(10)

security_user_group

Used by modules: app_sec, claims, client, clmrpt, clmutils, cobrarpt, drugplan, enrolaud, enroll, enrolrpt, funding, homersys, mailobj, preex, provider, svclog, system, um_cm, um_main

Column	Declared type
group_id	char(15)
user_class	—
user_id	—

security_users

Used by modules: app_sec, clmshare, funding, homersys, pfcapsrv, provider, svclog, system, um_cm

Column	Declared type
description	char(32), char(50)
name	char(16)
priority	decimal(0), long
user_type	decimal(0), long

security_users_db_role

Used by modules: system

Column	Declared type
db_role	char(30)
name	char(16)

state

Used by modules: homersys

Column	Declared type
claim_dollars	number
state	char(2)
state_full	—
union_cd	number

system_menu

Used by modules: homersys

Column	Declared type
display_order	decimal(0)
menu	char(30)
parameter	char(50)
sys_menu_option	char(30)
window_to_open	char(40)

user_assignments

Used by modules: app_sec, clmforms, um_cm, um_main, um_ur

Column	Declared type
benefit_coverage_type_cd	char(10)
create_dt	datetime
create_user_id	char(8)
group_id	char(15)
name	char(16)
user_asgn_end_initial	char(1)
user_asgn_start_initial	char(1)

user_dept_group

Used by modules: app_sec, claims, homersys, provider, um_cm, um_ur

Column	Declared type
dept_group	char(10), char(16)
dept_group_desc	char(25)
group_name	char(16)
group_name_level	number

user_info

Used by modules: app_sec, base, claims, clmforms, clmprint, homersys, provider, reprint, um_cm, um_main, um_ur

Column	Declared type
control_cd	char(10)
create_dt	datetime
create_user_id	char(8)
location	char(10)
name	char(16)
phone_ext	char(5)
phone_no	char(13)
phone_no_800	char(13)
phone_no_did	char(13)
user_info_f_name	char(25)
user_info_l_name	char(25)
user_info_m_name	char(25)

user_ini

Used by modules: homersys

Column	Declared type
key_name	char(50)
key_value	char(2000)
section_name	char(50)
set_bold	number
set_italic	number
username	char(30)

user_role_privs

Used by modules: base, stoploss

(referenced in SQL; no column details captured)

user_supervisor

Used by modules: app_sec

Column	Declared type
dept_group	char(10)
name	char(16)
name_supervisor	char(16)