TL_PT_PG_LANG

(SQL View)
 Index Back

Rel Lang View for TL_PT_PG_VW

Related language view for TL_PT_PG_VW

SELECT P.EMPLID , P.EMPL_RCD , P.DUR , P.SEQ_NBR , L.LANGUAGE_CD , T.TRC_SUM_CATEGORY , CASE WHEN %TrimSubstr(T.TRC_SUM_CATEGORY,1,6) = '' THEN %Coalesce((SELECT M.MESSAGE_TEXT FROM PSMSGCATLANG M WHERE M.MESSAGE_SET_NBR = 13504 AND M.MESSAGE_NBR = 11200 AND M.LANGUAGE_CD = L.LANGUAGE_CD), 'Not Categorized') ELSE %Coalesce((SELECT TL.DESCR FROM PS_TL_TRC_CAT_LANG TL WHERE TL.TRC_SUM_CATEGORY = T.TRC_SUM_CATEGORY AND TL.LANGUAGE_CD = L.LANGUAGE_CD), ' ') END FROM PS_TL_PAYABLE_TIME P , PS_TL_JOB_EMPL_DAT J , PS_TL_TRC_TBL T , PSLANGUAGES L WHERE P.EMPLID = J.EMPLID AND P.EMPL_RCD = J.EMPL_RCD AND P.TRC = T.TRC AND T.EFFDT = ( SELECT MAX(T1.EFFDT) FROM PS_TL_TRC_TBL T1 WHERE T1.TRC = T.TRC AND T1.EFF_STATUS = 'A')

  • Related Language Record for TL_PT_PG_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
    3 DUR Date(10) DATE Date Under Report associates time being reported, scheduled or paid, to a specific date.
    4 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
    5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 TRC_SUM_CATEGORY Character(6) VARCHAR2(6) NOT NULL TRC Category
    7 DESCR Character(30) VARCHAR2(30) NOT NULL Description