| Note |
|---|
NOTE: You will need access to TCIDP in order to perform this operation. When using tc_user schema for TCIDP, tables will be listed under Synonyms. |
Determine which application is being referred to by running the attached query in TOAD, replacing the text “INSERT_TC_USER_ID” with the user’s TC User ID.
See script below
From the list of results, determine which application is the one to be removed. There is usually only one application with Pending Tasks, but not always. If need be, confirm with the client. Appplicaion Date The date of the application is a good reference point. The application date is the Date Created column in the results for the first task of the application. The client may also provide just the due date, then the application date determined by subtracting 10 days from the due date (more or less).
Once the application to be removed has been identified, get the relative application_id and related_application_id values from the list of results.
In TOAD, go to table UA019_TASK and locate ALL RECORDS where ua019_task.applicaion_id is equal to either the application_id or related_application_id value from #3 above. Update the value for TASK_STATUS_CD ua019_task.task_status_cd to 3 (Declined). Note: Under the tc_user schema in TOAD for TCIDP tables will be listed under Synonyms.
The prepared query might look like as follows, since we obtain application_id and related_application_id from the query in step 2 and use it in the where clause):
select * from UA019_TASK where application_id = 34603 or application_id=34551; (Returns 6 records)Update UA019_TASK set task_status_cd = 3 where application_id = 34603 or application_id=34551; (Updated 6 records, in this case, just one record is pending but we still need to update all 6 records since the related application id should be taken into consideration)
In TOAD, go to table AA009_APPLICATION and locate any records (max. 2) with the application_id or related_application_id values. Update the value for aa009_application.application_status_cd to 3 (Declined).
The prepared query might look like as follows:
select * from AA009_APPLICATION where application_id = 34603 or application_id=34551 ; (returns 2 records)Update AA009_APPLICATION Set application_status_cd = 3 where application_id = 34603 or application_id=34551; (Updated 2 records)
Notify user.
TCID Application Locator
...