HCSC_RTG_REC_VW

(SQL View)
 Index Back

Ratings Cross-Ref Tables

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

SELECT D.RECNAME , D.RECDESCR FROM PSRECDEFN D WHERE EXISTS ( SELECT 1 FROM PSRECFIELD F WHERE F.FIELDNAME = 'HCSC_RTG_XREFSB' AND D.RECNAME = F.RECNAME)

  • Related Language Record: HCSC_RTG_RECLVW

    • # 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 DESCR Character(30) VARCHAR2(30) NOT NULL Description