TL_TIMESUM_R_VW(SQL View) |
Index Back |
|---|---|
Timesummary for Reported TimeSum of TL_QUANTITY by TRC for each day |
| SELECT R.EMPLID , R.EMPL_RCD , R.DUR , R.TRC , R.REPORTED_STATUS , A.DESCR , SUM(TL_QUANTITY) , CASE WHEN A.TRC_TYPE = ' ' THEN 'H' ELSE A.TRC_TYPE END , A.CURRENCY_CD FROM PS_TL_RPTD_TIME R LEFT OUTER JOIN PS_TL_TRC_PAY_VW A ON A.TRC = R.TRC GROUP BY R.EMPLID , R.EMPL_RCD , R.DUR , R.TRC , R.REPORTED_STATUS , A.DESCR ,A.TRC_TYPE , A.CURRENCY_CD |
| # | 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 | TRC | Character(5) | VARCHAR2(5) NOT NULL | Time Reporting Code used to report time in Time and Labor |
| 5 | REPORTED_STATUS | Character(2) | VARCHAR2(2) NOT NULL |
Reported Status
AP=Approved DN=Denied IP=Approval In Process NA=Needs Approval NW=New PB=Pushed Back PR=Processed SB=Submitted SV=Saved |
| 6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 7 | TL_QUANTITY | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | This field represents the measure of Work in hrs,amount etc., |
| 8 | TRC_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
This defines TRC Type of Hours,Amounts ,Units
A=Amount H=Hours U=Units |
| 9 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |