RSF_TFP_LANG_VW

(SQL View)
 Index Back

Active Timeframe Periods

View of all Active Timeframe Periods for all related languages

SELECT A.TIMEFRAME_PERIOD , B.LANGUAGE_CD , B.DESCR FROM PS_RSF_TF_PERIOD A , PS_RSF_TF_PERD_LNG B WHERE A.TIMEFRAME_ID = B.TIMEFRAME_ID AND A.PERIOD_ID = B.PERIOD_ID AND A.RSF_PERIOD_USE IN ( 'A', 'S')

  • Related Language Record for RSF_TFP_A_VW RSF_TFP_VW

  • Parent record: RSF_TF_DEFN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 TIMEFRAME_PERIOD Character(32) VARCHAR2(32) NOT NULL Time Frame
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description