HCSC_RTG_RECLVW (SQL View)	Index Back
Ratings Cross-Ref Tbl Rel Lng Use this view to select the records on defined on the tools record definition where Ratings Sub-record is present. This is the Related Langauge table.

HCSC_RTG_RECLVW

(SQL View)

Ratings Cross-Ref Tbl Rel Lng

Use this view to select the records on defined on the tools record definition where Ratings Sub-record is present. This is the Related Langauge table.

SELECT R.RECNAME , L.LANGUAGE_CD , L.RECDESCR FROM PSRECDEFN R , PSRECDEFNLANG L WHERE R.RECNAME = L.RECNAME AND R.RECNAME IN ( SELECT DISTINCT F.RECNAME FROM PSRECFIELD F WHERE F.FIELDNAME = 'HCSC_RTG_XREFSB')

Related Language Record for HCSC_RTG_REC_VW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 HCSC_RTG_REC_XREF Character(15) VARCHAR2(15) NOT NULL Cross Reference Table

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

3 DESCR Character(30) VARCHAR2(30) NOT NULL Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	HCSC_RTG_REC_XREF	Character(15)	VARCHAR2(15) NOT NULL	Cross Reference Table
2	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description