Previous  Next          Contents  Index  Navigation  Glossary  Library

Planning

One of the first tasks you need to perform is to identify which data you want to extract from the database to include in your standard letters. You need to identify the select statements to use to provide you with the data as the content of your letters. Oracle HRMS supplies you with SQL*Plus scripts as templates to help you do this. You also need to identify the text that you want to include as the body of your letters.

The next decision you need to make is whether to associate your standard letters with student enrollment or applicant assignment statuses.

If you do want to link your standard letters to student enrollment or applicant assignment statuses, your next decision is to identify which student enrollment or applicant assignment statuses you want to trigger your standard letters. For example, do you want to link your standard enrollment confirmation letter to the status Placed so that the letter is triggered when you set a student's enrollment status to Placed? Alternatively, do you want to link your standard rejection letter to the status Rejected so that it is triggered when an applicant's assignment status is set to Rejected?

Performing the Next Step:

See: Writing a SQL*Plus Script for MultiMate or WordPerfect

See: Writing a SQL*Plus Script for Microsoft Word

         Previous  Next          Contents  Index  Navigation  Glossary  Library