RC_REASON_SOLN (SQL Table)	Index Back
Reason Solution Interface Tbl This Table is used to store the Link the between Closed Reason and Solution ID. In Self-Service, users are allowed to close a case. User has to select a reason to close a case or enter a reason for closing a case. If the case is closed using a pre-defined reason, then system looks in this inteface to get the solution ID. If no solution ID exists then, creates on and attaches with this reason code. System Admin can change the Reason Code and Solution Link using Reason - Solution Link Page.

RC_REASON_SOLN

(SQL Table)

Reason Solution Interface Tbl

This Table is used to store the Link the between Closed Reason and Solution ID. In Self-Service, users are allowed to close a case. User has to select a reason to close a case or enter a reason for closing a case. If the case is closed using a pre-defined reason, then system looks in this inteface to get the solution ID. If no solution ID exists then, creates on and attaches with this reason code. System Admin can change the Reason Code and Solution Link using Reason - Solution Link Page.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.
Default Value: OPR_DEF_TBL_RB.SETID
Prompt Table: SP_SETID_NONVW

2 RC_CLOSE_REASON_CD Character(10) VARCHAR2(10) NOT NULL Case Close Reason Code. This is being used in SS
Prompt Table: RC_CLOSE_SS_VW

3 REASON_TYPE Character(4) VARCHAR2(4) NOT NULL Reason Type used to define reason codes
AGBA=Agreement Billing Adjustment
CABA=Case Billing Adjustment
CLSD=Reason Closed
ITRD=Reason Interested
ROPN=Reason Re-opened
SOBA=Svc Order Billing Adjustment

4 SOLUTION_ID Number(15,0) DECIMAL(15) NOT NULL Solution ID
Prompt Table: RC_SOLUTION

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	This field is used to store the value of SetID on various setup tables. Default Value: OPR_DEF_TBL_RB.SETID Prompt Table: SP_SETID_NONVW
2	RC_CLOSE_REASON_CD	Character(10)	VARCHAR2(10) NOT NULL	Case Close Reason Code. This is being used in SS Prompt Table: RC_CLOSE_SS_VW
3	REASON_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Reason Type used to define reason codes AGBA=Agreement Billing Adjustment CABA=Case Billing Adjustment CLSD=Reason Closed ITRD=Reason Interested ROPN=Reason Re-opened SOBA=Svc Order Billing Adjustment
4	SOLUTION_ID	Number(15,0)	DECIMAL(15) NOT NULL	Solution ID Prompt Table: RC_SOLUTION