TRANSACTIONIDEOAWDEFN_IDEMPLIDEMPL_RCDDURSEQ_NBRTL_PAY_VW_FL(SQL View) |
Index Back |
|---|---|
TL Paytime Fluid approvalsTL Paytime Fluid approvals-Line Details Record |
| SELECT DISTINCT X.TRANSACTIONID ,X.EOAWDEFN_ID ,X.EMPLID ,X.EMPL_RCD ,X.DUR ,X.SEQ_NBR ,%Sql(TL_TOCHAR1,TL_QUANTITY) %CONCAT' '%Concat A.XLATSHORTNAME ,T.TRC ,T.TRC %CONCAT' - '%Concat TRC.DESCR ,T.CURRENCY_CD ,T.EST_GROSS ,CASE WHEN TL_QUANTITY <0 THEN 'Yes' ELSE 'No' END ,T.TASKGROUP FROM PS_TL_APP_PAY_LINE X , PS_TL_PAYABLE_TIME T , PS_TL_TRC_TBL TRC ,PSXLATITEM A WHERE X.EMPLID=T.EMPLID AND X.EMPL_RCD=T.EMPL_RCD AND X.DUR=T.DUR AND X.SEQ_NBR=T.SEQ_NBR AND TRC.TRC=T.TRC AND TRC.EFFDT = ( SELECT MAX(EFFDT) FROM PS_TL_TRC_TBL TRC2 WHERE TRC2.TRC=TRC.TRC AND TRC2.EFFDT <=T.DUR) AND TRC.EFF_STATUS='A' AND A.FIELDNAME ='TRC_TYPE' AND A.FIELDVALUE=TRC.TRC_TYPE AND A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PSXLATITEM B WHERE B.FIELDNAME = A.FIELDNAME AND B.FIELDVALUE = A.FIELDVALUE AND B.EFFDT <= %CurrentDateIn ) AND A.EFF_STATUS='A' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | TRANSACTIONID |
Number(10,0) | DECIMAL(10) NOT NULL | Transaction Identifier |
| 2 | EOAWDEFN_ID |
Character(30) | VARCHAR2(30) NOT NULL | Approval Framework Definition ID |
| 3 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 4 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 5 | DUR |
Date(10) | DATE | Date Under Report associates time being reported, scheduled or paid, to a specific date. |
| 6 | SEQ_NBR |
Number(15,0) | DECIMAL(15) NOT NULL | Sequence Number |
| 7 | DESCR20 | Character(20) | VARCHAR2(20) NOT NULL | Description |
| 8 | TRC | Character(5) | VARCHAR2(5) NOT NULL | Time Reporting Code used to report time in Time and Labor |
| 9 | DESCR40 | Character(40) | VARCHAR2(40) NOT NULL | Description |
| 10 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 11 | EST_GROSS | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Estimated Gross |
| 12 | DESCR10 | Character(10) | VARCHAR2(10) NOT NULL | Description field of length 10 |
| 13 | TASKGROUP | Character(10) | VARCHAR2(10) NOT NULL | Taskgroup |