TL_AP_PYTIME_VW(SQL View) |
Index Back |
---|---|
Payable Time by TRC CategoryPayable 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 |