Understanding the Prospect Delete and Application Delete Processes

You can only delete prospect records and applications for which you have appropriate recruiting center and application center security.

See Campus Solutions Application Fundamentals: Understanding Recruiting and Admissions Security.

You can delete prospect records and applications:

• Individually

• In a group

Use the group delete process to delete groups of prospect records or applications that you no longer want to keep in your database—for example, once a semester, you might delete all prospect records that are five years old and for which no application exists. You might use the individual delete process at the end of each day, to delete prospect records or applications entered in error.

You can delete all academic career information for prospects or applicants or only information for a specific academic career, when multiple careers exist. In either case, the processes delete prospect or applicant data from all tables in which the data resides.

You also have the option to delete the communications, checklists, and comments (3Cs) associated with the prospect record or application.

Before running the delete process, you can access the holding table to remove records that you no longer want to delete or to change the 3Cs that you want to delete.

Important:

The Prospect Delete and Application Delete processes are designed strictly as cleanup tools. They are not to be used to delete an ID from the database. PeopleSoft Campus Community has the ID Delete function for that task.

How Prospect Delete and Application Delete Relate to ID Delete

Although the Prospect Delete and Application Delete processes remove prospect records and applications from database tables, the identification number and personal data still remain in the system. If you need to delete this information, use the ID Delete functionality.

The ID Delete process, because of its primary objective to maintain referential integrity, searches for the presence of critical data in high-level tables before it deletes individual identification numbers. If it finds no data for the identification number, it proceeds with the deletion. However, if it does find data, it cancels the deletion and displays a message of explanation.

The Prospect Delete and Application Delete processes prepare records for ID Delete when:

• No other prospect record or application exists.

• No student record exists for a matriculated applicant or active student.

• No student financial record exists.

When you create prospect records and applications, the system writes a corresponding row to the STDNT_CAREER table for each career of the prospect or applicant. The STDNT_CAREER table is one of the control tables that the ID Delete process searches before it deletes an identification number. To ensure that you can delete an identification number after a corresponding prospect record or application is deleted, the Prospect Delete and Application Delete processes check for critical data elements to determine if the identification number for the prospect or applicant meets certain conditions. If the identification number meets those conditions and if it meets all the requirements of the ID Delete feature, then the processes delete the identification number from the STDNT_CAREER table and the identification number becomes eligible for ID delete.

Likewise, when your institution processes application fees and enrollment deposits, the system writes a corresponding row to the ITEM_SF table, and this data flows up to the ACCOUNT_SF table (one of the four control tables in the ID Delete feature). In the ITEM_SF table, the Applicant Delete process changes the Application Number Deleted field from No, the default, to Yes.

The Prospect Delete and Application Delete processes remove data from the ID Delete control tables only if the data came from Recruiting and Admissions processes. They do not remove data that originated from other applications in PeopleSoft Campus Solutions.