RSP_TFP_LANG_VW

(SQL View)
 Index Back

RSP Timeframe related lang rec

Related language record for Strategic Planning timeframes.

SELECT A.PERIOD_TYPE , 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', 'D')

  • Parent record: RSF_TF_DEFN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PERIOD_TYPE Character(1) VARCHAR2(1) NOT NULL Quota Definition Period Type
    A=Annual
    B=Bi-Weekly
    D=Daily
    M=Monthly
    Q=Quarterly
    S=Semi-Annual
    W=Weekly
    2 TIMEFRAME_PERIOD Character(32) VARCHAR2(32) NOT NULL Time Frame
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description