TL_DSH_PTTRC_VW(SQL View) |
Index Back |
|---|---|
TL Dshbd Payable Time TRC Vw |
| SELECT DISTINCT P.EMPLID , P.EMPL_RCD , P.DUR , P.TASKGROUP , SUM(P.TL_QUANTITY) , SUM(P.EST_GROSS) , SUM(P.LBR_DIST_AMT) , SUM(P.DILUTED_GROSS) , P.CURRENCY_CD , P.PAYABLE_STATUS , P.PROJECT_ID , P.TRC , T.TRC_SUM_CATEGORY , T.TRC_TYPE , T.FACTOR_MULT , T.DESCRSHORT FROM PS_TL_PAYABLE_TIME P LEFT OUTER JOIN PS_TL_DSH_TRCAT_VW T ON T.TRC = P.TRC GROUP BY P.EMPLID , P.EMPL_RCD , P.DUR , P.TASKGROUP , P.CURRENCY_CD , P.PAYABLE_STATUS , P.PROJECT_ID , P.TRC , T.TRC_SUM_CATEGORY , T.TRC_TYPE , T.FACTOR_MULT , T.DESCRSHORT |
| # | 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 | TASKGROUP | Character(10) | VARCHAR2(10) NOT NULL |
Taskgroup
Prompt Table: TL_TASKGRP_TBL |
| 5 | TL_QUANTITY | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | This field represents the measure of Work in hrs,amount etc., |
| 6 | EST_GROSS | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Estimated Gross |
| 7 | LBR_DIST_AMT | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Labor Distribution Amount |
| 8 | DILUTED_GROSS | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Diluted Labor Distribution Amt |
| 9 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table: CURRENCY_CD_TBL |
| 10 | PAYABLE_STATUS | Character(2) | VARCHAR2(2) NOT NULL |
Payable Status
AP=Approved CL=Closed DL=Diluted DN=Denied ES=Estimated IG=Ignore NA=Needs Approval NP=No Pay OE=Online Estimate PB=Pushed Back PD=Distributed RP=Rejected by Payroll RV=Reversed Check SP=Sent to Payroll TP=Taken by Payroll |
| 11 | PROJECT_ID | Character(15) | VARCHAR2(15) NOT NULL |
Project/Grant
Prompt Table: %EDIT_PROJECT |
| 12 | TRC | Character(5) | VARCHAR2(5) NOT NULL |
Time Reporting Code used to report time in Time and Labor
Prompt Table: TL_TRC_TBL |
| 13 | TRC_SUM_CATEGORY | Character(6) | VARCHAR2(6) NOT NULL | TRC Category |
| 14 | TRC_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
This defines TRC Type of Hours,Amounts ,Units
A=Amount H=Hours U=Units |
| 15 | FACTOR_MULT | Signed Number(11,4) | DECIMAL(9,4) NOT NULL | Multiplication Factor |
| 16 | TL_CHT_GROUP_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Group |