| Account |
|
|
|
|
|
|
|
|
|
|
| CustNo |
CustName |
Broker |
Executive |
Carrier |
CarrierDate |
EnrollDate |
Enrolled |
Industry |
ZipIn |
ZipOut |
|
| varchar2(10) |
varchar2(30) |
varchar2(30) |
varchar2(30) |
varchar2(30) |
date |
date |
int |
int |
int |
int |
|
|
|
| Industry |
|
| Code |
Description |
|
| int |
varchar2(15) |
|
|
|
|
|
| Contact |
|
|
| ContactName |
Addr1 |
Addr2 |
City |
State |
Zip |
Zip4 |
AreaCode |
Phone |
Email |
|
| varchar2(30) |
varchar2(30) |
varchar2(30) |
varchar2(30) |
char(2) |
int |
int |
int |
int |
varchar2(50) |
|
|
|
| Plan |
|
|
| CustNo |
ModelType |
AnnMaxIn |
AnnMaxOut |
CommBrok |
CommGA |
EmpContrib |
PctEnrolled |
DualChoice |
OrthoMax |
ModelCfg |
|
| varchar2(15) |
int |
decimal |
decimal |
decimal |
decimal |
decimal |
decimal |
char(1) |
decimal |
varchar2(10) |
|
|
|
| Tier |
|
|
| CustNo |
ModelType |
Parameter |
NetworkOut |
Level1 |
Level2 |
Level3 |
Level4 |
|
|
| varchar2(15) |
int |
varchar2(15) |
char(1) |
decimal |
decimal |
decimal |
decimal |
|
|
|
| ModelConfig |
|
| CfgCode |
Description |
Ortho |
Perio |
Endo |
Surg |
|
|
|
| int |
varchar2(30) |
char(1) |
int |
int |
int |
|
|
|
| ModelType |
|
|
| TypeCode |
Description |
|
|
|
|
| int |
varchar2(30) |
|
|
|
|
|
|
|
|
|
|
|
|
|
|