RO_DEFN_SRC_LVW (SQL View)	Index Back
Source Codes Language View Language View for Source Code View for ACE reports

RO_DEFN_SRC_LVW

(SQL View)

Source Codes Language View

Language View for Source Code View for ACE reports

SELECT SETID , SOURCE_CD , language_cd , DESCR50 FROM PS_RO_DEFNSRCE_LNG UNION SELECT 'AASR' , 'ALLSRC' , LANGUAGE_CD , %Substring(MESSAGE_TEXT, 1, 50) FROM PSMSGCATLANG WHERE MESSAGE_SET_NBR = 17834 AND MESSAGE_NBR = 4065

Related Language Record for RO_DEFN_SRC_VW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID_SOURCE Character(5) VARCHAR2(5) NOT NULL MOC SETID Field

2 SOURCE_CD Character(6) VARCHAR2(6) NOT NULL Source Code

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

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID_SOURCE	Character(5)	VARCHAR2(5) NOT NULL	MOC SETID Field
2	SOURCE_CD	Character(6)	VARCHAR2(6) NOT NULL	Source Code
3	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
4	DESCR50	Character(50)	VARCHAR2(50) NOT NULL	Description of length 50