Getting Started With Sun Master Patient Index

ProcedureTo 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.