Return to Navigation

Resetting Generated Communications

A successful run of the Communication Generation or Letter Generation process updates the following items on the communication record for each processed ID:

When the items are updated, the process sets the communication to Communication Completed, and neither the Communication Generation process nor the Letter Generation process will process that ID again for that communication.

If you need to generate the communication again or reset the fields (for example, if you mistakenly used the wrong template or selected the wrong IDs to process), then you must either manually navigate to each processed ID's Person or Organization Communication Management component and clear the Communication Completed check box, or use the Reset Communications page to reset the communication.

You can specify which of the processed IDs to reset: All IDs, All Person IDs, All Org IDs, One Person ID, or One Org ID.

Resetting clears the information from the communication record, refreshes the processing tables, and deletes from the XML storage tables. The Letter Generation process does not use processing tables that need to be refreshed.

Note: You must run reset the communication to refresh the processing tables if the Communication Generation process ends abnormally.

Page Name

Definition Name

Navigation

Usage

Reset Communication

SCC_CG_RESET

  • select Campus Community, then select Communications, then select Reset Communication

  • select Contributor Relations, then select Communications, then select Process Communications, then select Reset Communication

  • select Contributor Relations, then select Session Management, then select Acknowledgements, then select Generate Acknowledgements, then select Reset Communication

Reset the communications generated by the Communication Generation process or the Letter Generation process by clearing the Communication Completed check box and resetting the other values populated by the processes.

Also reset the Communication Generation process tables if the process ended abnormally.

Access the Reset Communication page (select Campus Community, then select Communications, then select Reset Communication).

Image: Reset Communication page

This example illustrates the fields and controls on the Reset Communication page. You can find definitions for the fields and controls later on this page.

Reset Communication page

Field or Control

Definition

Process instance, Run Date/Time, and Run Status

Select the process instance number for which you want to reset a generated communication.

Process instance numbers are available only for a process run status of Success, No Success, Warning, Delete, Error, or Cancelled.

When the process instance number has a run status of Success, the Reset Communication process clears all process information that the Communication Generation process or the Letter Generation process added to the communication record for each processed ID.

When the process instance number has a run status of No Success, Warning, Delete, Error, or Cancelled, the Reset Communication process clears all of the processing tables, so that you can run the process to generate the communication again.

ID Selection, Person ID, and Org ID

Specify which IDs within the process instance to reset. Only the IDs generated in the specified process instance are available.

  • Enter All IDs to reset all of the processed IDs.

  • Enter All Person IDs or All Org IDs to reset all of the person IDs or all of the organization IDs that were processed.

  • If you enter One Person ID or One Org ID, the Person ID or the Org ID field appears. You must enter the ID.

Click the Run button to invoke the SCC_CG_RESET Application Engine process. The system does the following:

  1. Clears rows in the process tables that were used for the specific Communication Generation run.

    The process tables are: SCC_COMMGEN_AET, SCC_CG_PRCS_AET, SCC_CG_MERG_TBL, SCC_CG_PRCS_TBL and SCC_CG_TRGT.

  2. Identifies the communications to reset based on the ID Selection dropdown on the run control page.

  3. For each communication identified in step 2, deletes from the XML storage tables (SCC_CG_ATTDET, SCC_CGR_ATTREL, SCC_ORG_CTC_ATT, SCC_ORG_DPT_ATT and SCC_ORG_LOC_ATT).

  4. For each communication identified in step 2, updates the process-related fields on the PS_COMMUNICATION table:

    • COMPLETED_COMM='N'

    • COMPLETED_ID=' '

    • COMPLETED_DT =%DateNull

    • UNSUCCESSFUL='N'

    • OUTCOME_REASON=' '

    • LETTER_PRINTED_DT=%DateNull

    • PROCESS_INSTANCE=0

    • SCC_COMM_MTHD=' '

    • SCC_COMM_LANG=' '

    • SCC_COMM_PROC=' '