TL_UNPROC_PY_VW(SQL View) |
Index Back |
---|---|
Unporcessed Payable TIme |
SELECT EMPLID , EMPL_RCD , DUR , PAYABLE_STATUS , TRC , TL_QUANTITY , PAY_SYSTEM ,TL_PYBL_REASON_CD FROM PS_TL_PAYABLE_TIME WHERE PAYABLE_STATUS IN ('NA','AP', 'ES', 'RP','SP','TP') AND RT_SOURCE <> 'AM' |
# | 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 | 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 |
5 | TRC | Character(5) | VARCHAR2(5) NOT NULL | Time Reporting Code used to report time in Time and Labor |
6 | TL_QUANTITY | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | This field represents the measure of Work in hrs,amount etc., |
7 | PAY_SYSTEM | Character(4) | VARCHAR2(4) NOT NULL |
Payroll System
GP=Global Payroll NA=North American Payroll |
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 |