RC_PHONE_VW3 (SQL View)	Index Back
View for Phone Call Center application view for Phone.

RC_PHONE_VW3

(SQL View)

View for Phone

Call Center application view for Phone.

SELECT DISTINCT D.SETID , A.PHONE , %Substring(C.BO_NAME_DISPLAY,1,50) , C.NAME_AC , B.DESCR FROM PS_BO_SRCH_PHN A , PS_CM_PURP_TYPE B , PS_BO_NAME C , PS_BC D , PS_BO_REL REL WHERE A.ROLE_TYPE_ID = 8 AND A.BO_CM_USE_TYPE = 'R' AND A.CM_PURPOSE_TYPE_ID = B.CM_PURPOSE_TYPE_ID AND A.BO_ID = C.BO_ID AND C.PRIMARY_IND = 'Y' AND A.BO_ID = REL.BO_ID_1 AND REL.REL_TYPE_ID IN (10, 9, 14, 13) AND REL.START_DT <= %CurrentDateIn AND REL.END_DT > %CurrentDateIn AND REL.BO_ID_2 = D.BO_ID AND D.CUST_STATUS = 'A'

Related Language Record: RC_PHONELVW3

# 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_PHONE Character(24) VARCHAR2(24) NOT NULL This is the phone field used in case search. The reason is to have the ability to enter partial value for the phone and search on it. The standard PHONE field has a format mask associated with it, which does not permit entering partial values.

3 BO_NAME Character(50) VARCHAR2(50) NOT NULL Name Description of Business Object

4 BO_NAME_AC Character(50) VARCHAR2(50) NOT NULL Name Description of Business Object

5 RC_PURP_TYPE_DESCR Character(30) VARCHAR2(30) NOT NULL Short Description

#	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_PHONE	Character(24)	VARCHAR2(24) NOT NULL	This is the phone field used in case search. The reason is to have the ability to enter partial value for the phone and search on it. The standard PHONE field has a format mask associated with it, which does not permit entering partial values.
3	BO_NAME	Character(50)	VARCHAR2(50) NOT NULL	Name Description of Business Object
4	BO_NAME_AC	Character(50)	VARCHAR2(50) NOT NULL	Name Description of Business Object
5	RC_PURP_TYPE_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Short Description