RC_SSSLNFLV_LNG (SQL View)	Index Back
Self Service Top Solution Solutions to display on Top Solutions fluid page.

RC_SSSLNFLV_LNG

(SQL View)

Self Service Top Solution

Solutions to display on Top Solutions fluid page.

SELECT A.SEQNUM , A.SOLUTION_ID , B.LANGUAGE_CD , B.RC_SUMMARY , B.SOLUTION_DESCR FROM PS_RC_SS_SOLUTION A , PS_RC_SOLUTION_LNG B WHERE A.SETID=B.SETID AND A.SOLUTION_ID=B.SOLUTION_ID

Related Language Record for RC_SS_SOLN_FLVW

Parent record: RC_SELF_SERVICE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number

2 SOLUTION_ID Number(15,0) DECIMAL(15) NOT NULL Solution ID

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

4 RC_SUMMARY Character(80) VARCHAR2(80) NOT NULL Typically a summary of a long field.

5 SOLUTION_DESCR Long Character CLOB Solution Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SEQNUM	Number(3,0)	SMALLINT NOT NULL	Sequence Number
2	SOLUTION_ID	Number(15,0)	DECIMAL(15) NOT NULL	Solution ID
3	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
4	RC_SUMMARY	Character(80)	VARCHAR2(80) NOT NULL	Typically a summary of a long field.
5	SOLUTION_DESCR	Long Character	CLOB	Solution Description