EMPLIDEMPL_RCDDURAP=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
TL_PYBL_TMS_VW(SQL View) |
Index Back |
|---|---|
Payable Time SummaryView introduced for payable time presentation on timesheet page. Summarizes Qty and Est Gross by EE,RCD,DUR,TRC, status and currency. |
| SELECT EMPLID , EMPL_RCD , DUR , TRC , PAYABLE_STATUS , SUM(TL_QUANTITY) , SUM(EST_GROSS) , CURRENCY_CD FROM PS_TL_PAYABLE_TIME WHERE PAYABLE_STATUS<>'IG' AND ORIG_SEQ_NBR=0 GROUP BY EMPLID , EMPL_RCD , DUR , TRC , PAYABLE_STATUS , 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 NOT NULL | 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 | 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 |
| 6 | TL_QUANTITY | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | This field represents the measure of Work in hrs,amount etc., |
| 7 | EST_GROSS | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Estimated Gross |
| 8 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |