RC_CLOSE_SS_VW (SQL View)	Index Back
Close Reason Code View for SS Self-Service Close Reason Code View.

RC_CLOSE_SS_VW

(SQL View)

Close Reason Code View for SS

Self-Service Close Reason Code View.

SELECT SETID , REASON_CD , DESCR1 FROM PS_RB_REASON_CD A WHERE REASON_TYPE = 'CLSD' AND A.EFF_STATUS = 'A' AND A.EFFDT = ( SELECT MAX(EFFDT) FROM PS_RB_REASON_CD B WHERE A.REASON_CD = B.REASON_CD AND B.EFFDT <= %CurrentDateIn AND A.SETID = B.SETID)

Related Language Record: RC_CLOSE_SS_LNG

# 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.

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

3 RC_DESCR_SS Character(30) VARCHAR2(30) NOT NULL Description to be shown on Self-Service Pages

#	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.
2	RC_CLOSE_REASON_CD	Character(10)	VARCHAR2(10) NOT NULL	Case Close Reason Code. This is being used in SS
3	RC_DESCR_SS	Character(30)	VARCHAR2(30) NOT NULL	Description to be shown on Self-Service Pages