Create the Database Tables

To create the database tables, you must have a standard Oracle or SQL Server database installed and running either on your computer or on a network computer accessible to your machine. To run the sample files, modifications are required for the Systems script and the Create User Code Data script. These changes are described below. Do not delete or change any of the existing processing codes or systems.

Before you begin these procedures, complete the steps under Regenerate the Application.

To Define Systems for the Sample Files

1. In the Projects window, expand the eIndex project, expand eView Application - Person, and then expand Database Script.

2. Under Database Script, check out and open the Systems file.

3. Add the following SQL statements after the existing insert statement and before the end statement.

   insert into sbyn_systems (systemcode, description, status, id_length, format, input_mask, value_mask, create_date, create_userid) values (’CBMC’, ’CB MED CENTER’, ’A’, 9, ’[0-9]{9}’, ’DDD-DDD-DDD’, ’DDD^DDD^DDD’, TO_DATE(v_date, ’MM/DD/YYYY’), v_user);

   insert into sbyn_systems (systemcode, description, status, id_length, format, input_mask, value_mask, create_date, create_userid) values (’WHC’, ’WAYFIELD HOME CARE’, ’A’, 7, ’[0-9]{7}’, ’DD-DDD-DD’, ’DD^DDD^DD’, TO_DATE(v_date, ’MM/DD/YYYY’), v_user);

4. Save and close the file.

5. Define user codes as described below.

To Define User Codes for the Sample Files

1. In the Projects window, expand the eIndex project, expand eView Application - Person, and then expand Database Script.

2. Under Database Script, check out and open the Create User Code Data file.

3. Add the following SQL statements to the end of the file.

   insert into sbyn_user_code (code_list, code, descr, format, input_mask, value_mask) values (’AUXIDDEF’, ’ACCT’, ’ACCOUNT NUMBER’, ’[0-9]{8}’, ’D-DDD-DDDD’, ’D^DDD^DDDD’); commit;

4. Save and close the file.

5. Create the database tables as described below.

To Create the Database Tables

1. If you have not done so already, create a standard database using Oracle or SQL Server database tools.

2. Use SQL*Plus to create a user for the database. Use the following script as a sample, entering the user name and password of the Sun Master Patient Index user who will create the database files and provide the connection from the EDM and eWays.

   create user username identified by password;

   grant connect, resource to <username>;

   commit;

3. In the Projects window, expand the eIndex project, expand eView Application - Person, and then expand the Database Script folder.

4. Right-click Database Script, and then select Properties.

5. On the Properties window, do the following.

   1. For Oracle: In the Database Server field, change <hostname> to the name of the computer on which the database resides, change the port number if you are not using the default, and change <SID> to the SID name of the Sun Master Patient Index database. You can enter “localhost” for the hostname if the database is on your local computer.

   2. For SQL Server: In the Database Server field, delete the default value and replace it with jdbc:sqlserver://server:port;databaseName=database, where server is the name of the computer on which the database resides, port is the port number the database is listening on, and database is the name of the database.

   3. In the User field, enter the user ID for the user you created in step 2 above.

   4. In the Password field, enter the password for the user you created in step 2 above.

   5. Close the dialog box.

6. Under Database Script, right-click Create Person Database, click Run, and then click OK on the Information dialog box.

7. Run Create User Indexes as above.

8. Run Systems as above.

9. Run Code List as above.

10. Run Create User Code Data as above.

11. Continue to Configure the Connectivity Maps.