RC_COLLREC_VWLG (SQL View)	Index Back
Collection Record Language This is a related language record of Call Center Collection Record.

RC_COLLREC_VWLG

(SQL View)

Collection Record Language

This is a related language record of Call Center Collection Record.

SELECT AL.SRCH_COLLECTN_NAME %Concat ' ' %Concat AL.RECNAME , AL.LANGUAGE_CD , %TrimSubstr(BL.DESCR,1,29) %Concat ' - ' %Concat %TrimSubstr(CL.RECDESCR,1,28) FROM PS_RB_SRCHIDX_HDLG AL , PS_RB_SRCH_PARMSLN BL , PSRECDEFNLANG CL WHERE AL.SRCH_COLLECTN_NAME = BL.SRCH_COLLECTN_NAME AND AL.LANGUAGE_CD = BL.LANGUAGE_CD AND AL.RECNAME = CL.RECNAME AND AL.LANGUAGE_CD = CL.LANGUAGE_CD

Related Language Record for RC_COLL_REC_VW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50

2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

3 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	DESCR50	Character(50)	VARCHAR2(50) NOT NULL	Description of length 50
2	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
3	DESCR60	Character(60)	VARCHAR2(60) NOT NULL	Description