TL_PAY_VW_FL_LN

(SQL View)
 Index Back

TL Paytime Fluid approvals

TL Paytime Fluid approvals-Line details Related Language Record

SELECT DISTINCT X.TRANSACTIONID , X.EOAWDEFN_ID , X.EMPLID , X.EMPL_RCD , X.DUR , X.SEQ_NBR , TRC.LANGUAGE_CD , %Sql(TL_TOCHAR1, TL_QUANTITY) %Concat ' ' %Concat A.XLATSHORTNAME , T.TRC , T.TRC %Concat ' - ' %Concat TRC.DESCR , T.CURRENCY_CD , CASE WHEN TL_QUANTITY < 0 THEN 'Yes' ELSE 'No' END , T.TASKGROUP FROM PS_TL_APP_PAY_LINE X , PS_TL_PAYABLE_TIME T , PS_TL_TRC_LANG TRC , PS_TL_TRC_TBL TRC1 , PSXLATITEMLANG A WHERE X.EMPLID = T.EMPLID AND X.EMPL_RCD = T.EMPL_RCD AND X.DUR = T.DUR AND X.SEQ_NBR = T.SEQ_NBR AND TRC.TRC = T.TRC AND TRC.EFFDT = ( SELECT MAX(EFFDT) FROM PS_TL_TRC_TBL TRC2 WHERE TRC2.TRC = TRC.TRC AND TRC2.EFFDT <= T.DUR) AND A.FIELDNAME = 'TRC_TYPE' AND A.FIELDVALUE = TRC1.TRC_TYPE AND TRC.TRC = TRC1.TRC AND TRC.EFFDT = TRC1.EFFDT AND A.LANGUAGE_CD = TRC.LANGUAGE_CD AND A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PSXLATITEMLANG B WHERE B.FIELDNAME = A.FIELDNAME AND B.FIELDVALUE = A.FIELDVALUE AND B.EFFDT <= %CurrentDateIn)

  • Related Language Record for TL_PAY_VW_FL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 TRANSACTIONID Number(10,0) DECIMAL(10) NOT NULL Transaction Identifier
    2 EOAWDEFN_ID Character(30) VARCHAR2(30) NOT NULL Approval Framework Definition ID
    3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    4 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
    5 DUR Date(10) DATE Date Under Report associates time being reported, scheduled or paid, to a specific date.
    6 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
    7 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    8 DESCR20 Character(20) VARCHAR2(20) NOT NULL Description
    9 TRC Character(5) VARCHAR2(5) NOT NULL Time Reporting Code used to report time in Time and Labor
    10 DESCR40 Character(40) VARCHAR2(40) NOT NULL Description
    11 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
    12 DESCR10 Character(10) VARCHAR2(10) NOT NULL Description field of length 10
    13 TASKGROUP Character(10) VARCHAR2(10) NOT NULL Taskgroup