Table Descriptions and Contents

SQL> desc Account

Name Null? Type

----------------------------------------- -------- ----------------------------

CUSTNO NOT NULL VARCHAR2(15)

CUSTNAME VARCHAR2(30)

BROKER VARCHAR2(30)

EXECUTIVE VARCHAR2(30)

CARRIER VARCHAR2(30)

CARRIERDATE DATE

ENROLLDATE DATE

ENROLLED NUMBER(38)

INDUSTRY NUMBER(38)

ZIPIN NUMBER(38)

ZIPOUT NUMBER(38)

SQL> select * from Account;

CUSTNO CUSTNAME BROKER EXECUTIVE CARRIER

--------------- ------------------------- ------------------------- ------------------------- --------------------------

20031001SMI001 John B. Smith Franklin & Wong Sam Seaborn National Iniquity

20031015ZEL001 Alicia J. Zelaya Jennifer Wallace, LLC Rubio Manolo Nebraska Mutual

20031023NAR001 Ramesh K. Narayan Harmony Tea & Spice Patricia Parakeet Rare Earth Derivatives

20031031ENG001 Joyce English Franklin & Wong Sam Seaborn Castle Spring, Inc.

20030917JAB001 Ahmad V. Jabbar Jerry Rigg, Inc. Harold Potter, Esq. Do-Itashimashita Amenities

20031001SMI002 Albert Hoffman Smith Tabernanthe Iboga Sam Seaborn National Iniquity

CUSTNAME CARRIERDA ENROLLDAT ENROLLED INDUSTRY ZIPIN ZIPOUT

------------------------- --------- --------- ---------- ---------- ---------- ----------

John B. Smith 22-JAN-99 08-DEC-55 638 2 922 944

Alicia J. Zelaya 11-FEB-99 06-MAR-96 2012 4 949 954

Ramesh K. Narayan 13-JUL-99 18-AUG-79 249 1 922 944

Joyce English 12-NOV-01 28-AUG-99 90 3 922 944

Ahmad V. Jabbar 17-JAN-02 28-APR-00 700 2 916 217

Albert Hoffman Smith 02-MAY-03 13-OCT-01 150 2 922 944

6 rows selected.

SQL> desc Industry

Name Null? Type

----------------------------------------- -------- ----------------------------

CODE NOT NULL NUMBER(38)

DESCRIPTION NOT NULL VARCHAR2(15)

SQL> select * from Industry;

CODE DESCRIPTION

---------- ---------------

1 Presenters

2 Professionals

3 Aware

4 Clerical

5 Semi-skilled

SQL> desc Contact

Name Null? Type

----------------------------------------- -------- ----------------------------

CONTACTNAME NOT NULL VARCHAR2(30)

ADDR1 VARCHAR2(30)

ADDR2 VARCHAR2(30)

CITY VARCHAR2(30)

STATE CHAR(2)

ZIP NUMBER(38)

ZIP4 NUMBER(38)

AREACODE NUMBER(38)

PHONE NUMBER(38)

EMAIL VARCHAR2(50)

SQL> select * from Contact;

CONTACTNAME ADDR1 ADDR2 CITY ST ZIP ZIP4

------------------------------ ------------------------------ ------------------------------ --------------- -- ---------- ----------

John B. Smith 3321 Castle Rock Road Route 3 Spring CA 95403 9876

Franklin & Wong 291 Berry Ave. Apt. G Bellair AZ 29123 2343

Sam Seaborn 1600 Pennsylvania Ave. West Wing Washington DC 20002 9861

National Iniquity 18 Omaha Lane Mutual NB 23976

Alicia J. Zelaya 975 Fire Oak Ave. Humble MI 27363

Jennifer Wallace, LLC 960 Fire Oak Ave. Apt. 2343 Humble MI 27361 2343

Rubio Manolo General Delivery Macon MS 19234 1234

Nebraska Mutual 78A Prudential Circle 783rd Floor, Back Room Omaha NB 23976 2355

Harmony Tea & Spice 12 Happy Lane Paradise CA 77777 7777

Ramesh K. Narayan 29877 Longview Court Pico Rivera CA 23948 7657

Patricia Parakeet 23A Third Street San Rafael CA 94901 1234

Rare Earth Derivatives The Geysers Route 49 Geyserville CA 92602

Joyce English 7 Pueblo Drive Marinwood San Rafael CA 95403 6287

Castle Spring, Inc. 2936 Calistoga Road Calistoga CA 95503

Ahmad V. Jabbar 12 Ronyx Road Manhattan New York NY 10357 7612

Jerry Rigg, Inc. 69 Potomac San Francisco CA 93487 4123

Harold Potter, Esq. 13 Friday Woohoo WA 60909 1234

Do-Itashimashita Amenities Jiu-Ichi Takogama Itai Ichiban Yokohama JA 9099 2344

Albert Hoffman Smith Sandoz, Inc. 25 Diethylamide Place Basel SZ 12345 6789

Tabernanthe Iboga 19 Swampy Bottom Slough Baton Rouge LA 23587 1111

20 rows selected.

CONTACTNAME AREACODE PHONE EMAIL

------------------------------ ---------- ---------- --------------------------------------------------

John B. Smith 219 8737472 mxpyzlgriffen@alot.com

Franklin & Wong 876 9876543 spazmoid@frankenberry.net

Sam Seaborn 213 9630212 deputycommunicationsdirector@whitehouse.gov

National Iniquity 789 6752345 sales@nationaliniquity.com

Alicia J. Zelaya 234 9835456 abc@123.com

Jennifer Wallace, LLC 789 6778347 zelayasmom@comcast.net

Rubio Manolo 378 2357876 mail@macon.gov

Nebraska Mutual 789 6758987 callmeacab@rain.net

Harmony Tea & Spice 223 9876234 unbearable@ecstasy.com

Ramesh K. Narayan 234 2345767 asdf@typical.com

Patricia Parakeet 415 4536277 patpkeet@pittypotty.com

Rare Earth Derivatives 707 7123787 getready@rareearth.com

Joyce English 415 5079523 jenglish@yahoo.net

Castle Spring, Inc. 707 2378765 waterheater@castlespring.com

Ahmad V. Jabbar 345 3883721 av.jabbar@comcast.net

Jerry Rigg, Inc. 415 7892837 oddjobs@jrigg.com

Harold Potter, Esq. 345 2341267 wizard@woohoo.net

Do-Itashimashita Amenities 987 1234567 haidozo@sodes.ka

Albert Hoffman Smith 12 3456789 serotoninja@ehyobaybe.org

Tabernanthe Iboga 872 8712323 tiboga@mystery.net

SQL> desc Plan

Name Null? Type

----------------------------------------- -------- ----------------------------

CUSTNO NOT NULL VARCHAR2(15)

MODELTYPE NOT NULL NUMBER(38)

ANNMAXIN NUMBER(6,2)

ANNMAXOUT NUMBER(6,2)

COMMBROK NUMBER(4,2)

COMMGA NUMBER(4,2)

EMPCONTRIB NUMBER(4,2)

PCTENROLLED NUMBER(4,2)

DUALCHOICE CHAR(1)

ORTHOMAX NUMBER(7,2)

MODELCFG VARCHAR2(10)

SQL> select * from Plan;

CUSTNO MODELTYPE ANNMAXIN ANNMAXOUT COMMBROK COMMGA EMPCONTRIB PCTENROLLED D ORTHOMAX MODELCFG

--------------- ---------- ---------- ---------- ---------- ---------- ---------- ----------- - ---------- ----------

20031001SMI001 0 1000 1000 8 3 75 60 N 1500 default

20031001SMI001 1 1000 1000 8 3 75 50 N 1500 default

20031001SMI001 2 1000 1500 7 4 70 65 Y 2000 p3e2s3o1

20031001SMI001 3 1200 1500 7 4 70 50 Y 2000 p3e2s3o0

20031015ZEL001 0 1000 1000 8 3 75 50 N 1500 default

20031015ZEL001 1 1000 1000 8 3 75 50 N 1500 default

20031015ZEL001 2 1250 1250 7 3 80 70 N 1500 p3e3s3o1

20031023NAR001 0 1000 1000 8 3 75 50 N 1500 default

20031023NAR001 1 1500 2000 6 2 80 80 Y 1000 default

20031031ENG001 0 1000 1000 8 3 75 50 N 1500 default

20031031ENG001 1 1000 1500 8 3 75 40 Y 1250 default

20031031ENG001 3 1000 1300 7 3 60 30 N 1200 p3e2s3o0

20030917JAB001 0 1000 1000 8 3 60 60 Y 1500 p3e3s3o0

20031001SMI002 0 1000 1000 8 3 75 50 N 1500 default

14 rows selected.

SQL> desc Tier

Name Null? Type

----------------------------------------- -------- ----------------------------

CUSTNO NOT NULL VARCHAR2(15)

MODELTYPE NOT NULL NUMBER(38)

PARAMETER NOT NULL VARCHAR2(15)

NETWORKOUT NOT NULL CHAR(1)

LEVEL1 NUMBER(5,2)

LEVEL2 NUMBER(5,2)

LEVEL3 NUMBER(5,2)

LEVEL4 NUMBER(5,2)

SQL> select * from Tier;

CUSTNO MODELTYPE PARAMETER N LEVEL1 LEVEL2 LEVEL3 LEVEL4

--------------- ---------- --------------- - ---------- ---------- ---------- ----------

20031001SMI001 0 deductible N 0 50 50 50

20031001SMI001 0 deductible Y 50 50 50 50

20031001SMI001 0 coinsurance N 80 80 50 50

20031001SMI001 0 coinsurance Y 80 60 50 50

20031001SMI001 0 waiting N 0 0 6 12

20031001SMI001 0 waiting Y 0 0 12 18

20031001SMI001 1 deductible N 0 50 50 50

20031001SMI001 1 deductible Y 50 50 50 50

20031001SMI001 1 coinsurance N 80 80 50 50

20031001SMI001 1 coinsurance Y 80 60 50 50

Tier, cont’d

CUSTNO MODELTYPE PARAMETER N LEVEL1 LEVEL2 LEVEL3 LEVEL4

--------------- ---------- --------------- - ---------- ---------- ---------- ----------

20031001SMI001 1 waiting N 0 0 6 12

20031001SMI001 1 waiting Y 0 0 12 18

20031001SMI001 2 deductible N 45 50 50 50

20031001SMI001 2 deductible Y 50 50 50 50

20031001SMI001 2 coinsurance N 80 80 50 50

20031001SMI001 2 coinsurance Y 80 60 50 50

20031001SMI001 2 waiting N 0 0 6 12

20031001SMI001 2 waiting Y 0 0 12 18

20031001SMI001 3 deductible N 0 50 50 50

20031001SMI001 3 deductible Y 50 50 50 50

20031001SMI001 3 coinsurance N 80 80 50 50

20031001SMI001 3 coinsurance Y 80 60 50 50

20031001SMI001 3 waiting N 0 0 6 12

20031001SMI001 3 waiting Y 0 0 12 18

20031015ZEL001 0 deductible N 0 50 50 50

20031015ZEL001 0 deductible Y 50 50 50 50

20031015ZEL001 0 coinsurance N 80 80 50 50

20031015ZEL001 0 coinsurance Y 80 60 50 50

20031015ZEL001 0 waiting N 0 0 6 12

20031015ZEL001 0 waiting Y 0 0 12 18

20031015ZEL001 1 deductible N 0 50 50 50

20031015ZEL001 1 deductible Y 50 50 50 50

20031015ZEL001 1 coinsurance N 80 80 50 50

20031015ZEL001 1 coinsurance Y 80 60 50 50

20031015ZEL001 1 waiting N 0 0 6 12

20031015ZEL001 1 waiting Y 0 0 12 18

20031015ZEL001 2 deductible N 0 50 50 50

20031015ZEL001 2 deductible Y 50 50 50 50

20031015ZEL001 2 coinsurance N 80 80 50 50

20031015ZEL001 2 coinsurance Y 80 60 50 50

20031015ZEL001 2 waiting N 0 0 6 12

20031015ZEL001 2 waiting Y 0 0 12 18

20031023NAR001 0 deductible N 0 50 50 50

20031023NAR001 0 deductible Y 50 50 50 50

20031023NAR001 0 coinsurance N 80 80 50 50

20031023NAR001 0 coinsurance Y 80 60 50 50

20031023NAR001 0 waiting N 0 0 6 12

20031023NAR001 0 waiting Y 0 0 12 18

20031023NAR001 1 deductible N 0 50 50 50

20031023NAR001 1 deductible Y 50 50 50 50

20031023NAR001 1 coinsurance N 80 80 50 50

20031023NAR001 1 coinsurance Y 80 60 50 50

20031023NAR001 1 waiting N 0 0 6 12

20031023NAR001 1 waiting Y 0 0 12 18

20031031ENG001 0 deductible N 0 50 50 50

20031031ENG001 0 deductible Y 50 50 50 50

20031031ENG001 0 coinsurance N 80 80 50 50

20031031ENG001 0 coinsurance Y 80 60 50 50

20031031ENG001 0 waiting N 0 0 6 12

20031031ENG001 0 waiting Y 0 0 12 18

20031031ENG001 1 deductible N 0 50 50 50

20031031ENG001 1 deductible Y 50 50 50 50

20031031ENG001 1 coinsurance N 80 80 50 50

20031031ENG001 1 coinsurance Y 80 60 50 50

20031031ENG001 1 waiting N 0 0 6 12

20031031ENG001 1 waiting Y 0 0 12 18

20031031ENG001 3 deductible N 0 50 50 50

20031031ENG001 3 deductible Y 50 50 50 50

20031031ENG001 3 coinsurance N 80 80 50 50

20031031ENG001 3 coinsurance Y 80 60 50 50

20031031ENG001 3 waiting N 0 0 6 12

Tier, cont’d

CUSTNO MODELTYPE PARAMETER N LEVEL1 LEVEL2 LEVEL3 LEVEL4

--------------- ---------- --------------- - ---------- ---------- ---------- ----------

20031031ENG001 3 waiting Y 0 0 12 18

20030917JAB001 0 deductible N 0 50 50 50

20030917JAB001 0 deductible Y 50 50 50 50

20030917JAB001 0 coinsurance N 80 80 50 50

20030917JAB001 0 coinsurance Y 80 60 50 50

20030917JAB001 0 waiting N 0 0 6 12

20030917JAB001 0 waiting Y 0 0 12 18

20031001SMI002 0 deductible N 0 50 50 50

20031001SMI002 0 deductible Y 50 50 50 50

20031001SMI002 0 coinsurance N 80 80 50 50

20031001SMI002 0 coinsurance Y 80 60 50 50

20031001SMI002 0 waiting N 0 0 6 12

20031001SMI002 0 waiting Y 0 0 12 18

84 rows selected.

SQL> desc ModelConfig

Name Null? Type

----------------------------------------- -------- ----------------------------

CFGCODE NOT NULL VARCHAR2(10)

DESCRIPTION NOT NULL VARCHAR2(30)

ORTHO CHAR(1)

PERIO NUMBER(38)

ENDO NUMBER(38)

SURG NUMBER(38)

SQL> select * from ModelConfig;

CFGCODE DESCRIPTION O PERIO ENDO SURG

---------- ------------------------------ - ---------- ---------- ----------

default standard config N 2 2 3

p2e2s2o0 minimal standard N 2 2 2

p2e2s2o1 minimal w/ortho Y 2 2 2

p2e2s3o1 standard w/ortho Y 2 2 3

p2e3s2o0 endo N 2 3 2

p2e3s2o1 endo w/ortho Y 2 3 2

p2e3s3o0 endo & surg N 2 3 3

p2e3s3o1 endo & surg w/ortho Y 2 3 3

p3e2s2o0 minimal perio N 3 2 2

p3e2s2o1 perio w/ortho Y 3 2 2

p3e2s3o0 perio & surg N 3 2 3

p3e2s3o1 perio & surg w/ortho Y 3 2 3

p3e3s2o0 perio & endo N 3 3 2

p3e3s2o1 perio & endo w/ortho Y 3 3 2

p3e3s3o0 perio & endo & surg N 3 3 3

p3e3s3o1 perio & endo & surgw/ortho Y 3 3 3

16 rows selected.

SQL> desc ModelType

Name Null? Type

----------------------------------------- -------- ----------------------------

TYPECODE NOT NULL NUMBER(38)

DESCRIPTION VARCHAR2(30)

SQL> select * from ModelType;

TYPECODE DESCRIPTION

---------- ------------------------------

0 default

1 current

2 proposed

3 saved working