Resetting Generated Communications

Important! Letter Generation (Letter Gen) is a deprecated product. It is strongly recommended that you use Communication Generation (Comm Gen) instead. For more information on Comm Gen, see Understanding the Communication Generation Process

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

  • Communication Generation Datefield.

  • Communication Completed option.

  • Date Activity Completed field.

  • Unsuccessful Outcome option with its Reason field.

  • Language, Method, and Process Used fields.

  • View Generated Communication link (only for Communication Generation process and if setup allows it).

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

  • Campus Community > Communications > Reset Communication

  • Contributor Relations > Communications > Process Communications > Reset Communication

  • Contributor Relations > Session Management > Acknowledgements > Generate Acknowledgements > 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 (Campus Community > Communications > Reset Communication).

Field or Control

Description

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 drop-down list box 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=' '