TL_AP_PYTIME_VW

(SQL View)
Index Back

Payable Time by TRC Category

Payable Time by TRC Category pending Approvals view.

SELECT DISTINCT P.EMPLID , P.EMPL_RCD , T.TRC_SUM_CATEGORY ,P.DUR ,P.TL_QUANTITY , T.TRC_TYPE , X.XLATLONGNAME FROM PS_TL_PAYABLE_TIME P , PS_TL_TRC_TBL T ,PSXLATITEM X WHERE P.PAYABLE_STATUS ='NA' AND T.EFF_STATUS = 'A' 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.EFFDT <= %CurrentDateIn AND T1.EFF_STATUS ='A') AND X.FIELDNAME ='TRC_TYPE' AND X.FIELDVALUE = T.TRC_TYPE AND X.EFFDT = ( SELECT MAX (X1.EFFDT) FROM PSXLATITEM X1 WHERE X1.FIELDNAME=X.FIELDNAME AND X1.FIELDVALUE =X.FIELDVALUE AND X1.EFF_STATUS ='A' AND X1.EFFDT <= %CurrentDateIn)

# 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 TRC_SUM_CATEGORY Character(6) VARCHAR2(6) NOT NULL TRC Category
4 DUR Date(10) DATE Date Under Report associates time being reported, scheduled or paid, to a specific date.
5 TL_QUANTITY Signed Number(20,6) DECIMAL(18,6) NOT NULL This field represents the measure of Work in hrs,amount etc.,
6 TRC_TYPE Character(1) VARCHAR2(1) NOT NULL This defines TRC Type of Hours,Amounts ,Units
A=Amount
H=Hours
U=Units
7 DESCR Character(30) VARCHAR2(30) NOT NULL Description