TL_UNPRC_ALL_VW(SQL View) |
Index Back |
|---|---|
Unprocessed Payable TImeAll Empls View |
| SELECT A.EMPLID , A.EMPL_RCD , A.DUR , B.TRC_TYPE , A.TRC , A.PAYABLE_STATUS , A.TL_QUANTITY , A.TL_PYBL_REASON_CD FROM PS_TL_PAYABLE_TIME A , PS_TL_TRC_TBL B WHERE A.TRC = B.TRC AND A.PAYABLE_STATUS IN ('NA','AP', 'ES', 'RP','SP','TP') AND A.RT_SOURCE <> 'AM' AND B.EFFDT = ( SELECT MAX(B1.EFFDT) FROM PS_TL_TRC_TBL B1 WHERE B1.TRC = B.TRC AND B1.EFFDT <= %CurrentDateIn AND B1.EFF_STATUS = 'A') |
| # | 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 Rcd Nbr |
| 3 | DUR |
Date(10) | DATE | Date Under Report associates time being reported, scheduled or paid, to a specific date. |
| 4 | TRC_TYPE |
Character(1) | VARCHAR2(1) NOT NULL |
This defines TRC Type of Hours,Amounts ,Units
A=Amount H=Hours U=Units |
| 5 | TRC | Character(5) | VARCHAR2(5) NOT NULL |
Time Reporting Code used to report time in Time and Labor
Prompt Table: TL_TRC_TBL |
| 6 | PAYABLE_STATUS | Character(2) | VARCHAR2(2) NOT NULL |
Payable Status
AP=Approved CL=Closed DL=Diluted ES=Estimated IG=Ignore NA=Needs Approval NP=No Pay OE=Online Estimate PD=Distributed RP=Rejected by Payroll RV=Reversed Check SP=Sent to Payroll TP=Taken by Payroll |
| 7 | TL_QUANTITY | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | This field represents the measure of Work in hrs,amount etc., |
| 8 | TL_PYBL_REASON_CD | Character(3) | VARCHAR2(3) NOT NULL |
Payable Reason Code
CAN=Cancelled CRV=Reversed MRJ=Manual Reject NDS=Not Distributed NOP=Not OK to Pay NSP=Not Sent to Payroll NUS=Not Used PNP=Not Processed in Payroll PPS=Prior Period Adjustment RAJ=Record Adjustment |