HCSC_RTG_DFNLVW

(SQL View)
 Index Back

Ratings Defn Current VW Rel Ln

This is the Ratings definition related language table.

SELECT D1.HCSC_RTG_CD , D1.EFFDT , DLG1.LANGUAGE_CD , DLG1.DESCR254 FROM PS_HCSC_RTG_DEFN D1 , PS_HCSC_RTG_DFN_LG DLG1 WHERE D1.EFF_STATUS = 'A' AND D1.EFFDT = ( SELECT MAX(X.EFFDT) FROM PS_HCSC_RTG_DEFN X WHERE X.HCSC_RTG_CD = D1.HCSC_RTG_CD AND X.EFFDT <= %CurrentDateOut) AND D1.HCSC_RTG_CD = DLG1.HCSC_RTG_CD AND D1.EFFDT = DLG1.EFFDT

  • Related Language Record for HCSC_RTG_DEFNVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 HCSC_RTG_CD Character(30) VARCHAR2(30) NOT NULL Ratings Identification
    2 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254