HCSC_SS_RSR_LNG

(SQL View)
 Index Back

Report Search Language View

Parent View : GP_SS_RPT_VW

SELECT RPT1.COUNTRY , RPT.HCSC_SS_GROUP_ID , RPT1.REPORT_ID , RPT1.LANGUAGE_CD , RPT1.DESCR60 FROM PS_HCSC_SS_CTL_LNG RPT1 , PS_HCSC_SS_RPT_CTL RPT WHERE %EffdtCheck(HCSC_SS_CTL_LNG RPT2, RPT1, %CURRENTDATEIN) AND RPT1.COUNTRY = RPT.COUNTRY AND RPT1.REPORT_ID = RPT.REPORT_ID AND RPT1.EFFDT = RPT.EFFDT

  • Related Language Record for HCSC_SS_RPTSRCH

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

    Prompt Table: COUNTRY1_VW

    2 HCSC_SS_GROUP_ID Character(10) VARCHAR2(10) NOT NULL Group ID
    3 REPORT_ID Character(8) VARCHAR2(8) NOT NULL Report Identifier
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description