TE_STATUS_VW(SQL View) |
Index Back |
|---|---|
MTE for render status viewMobile Time Entry for render status View |
| SELECT A.EMPLID AS EMPLID , B.DATE_UNDER_RPT AS DATE_UNDER_RPT , A.TIME_SHEET_STATUS AS EX_LINE_STATUS FROM PS_EX_TIME_HDR A , PS_EX_TIME_DTL_DLY B WHERE A.TIME_SHEET_ID = B.TIME_SHEET_ID AND A.VERSION_NUM = B.VERSION_NUM AND A.VERSION_NUM = ( SELECT MAX(A1.VERSION_NUM) FROM PS_EX_TIME_HDR A1 WHERE A1.TIME_SHEET_ID = A.TIME_SHEET_ID) AND %DateDiff(%CurrentDateIn, B.DATE_UNDER_RPT) >= -90 UNION SELECT A.EMPLID AS EMPLID , B.DATE_UNDER_RPT AS DATE_UNDER_RPT , A.TIME_SHEET_STATUS AS EX_LINE_STATUS FROM PS_EX_TIME_HDR A , PS_EX_TIME_POL_DLY B WHERE A.TIME_SHEET_ID = B.TIME_SHEET_ID AND A.VERSION_NUM = B.VERSION_NUM AND A.VERSION_NUM = ( SELECT MAX(A1.VERSION_NUM) FROM PS_EX_TIME_HDR A1 WHERE A1.TIME_SHEET_ID = A.TIME_SHEET_ID) AND %DateDiff(%CurrentDateIn, B.DATE_UNDER_RPT) >= -90 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | DATE_UNDER_RPT | Date(10) | DATE | Date Under Report |
| 3 | EX_LINE_STATUS | Character(3) | VARCHAR2(3) NOT NULL |
The Line Status of an Expenses transaction (i.e. Expense Report, Cash Advance, Travel Authorization, Time Report)
ADJ=Adjusted APR=Approved APY=Approved for Payment CLS=Closed DEN=Denied DNA=Denied by Approver DNC=Denied DNU=Denied by Auditor ESC=Escheated Payment HDA=Hold by Approver HDU=Hold by Auditor HLD=Hold MFS=Marked For Submit OPN=Open PAR=Approvals in Process PD=Paid PND=Pending PRO=In Process RAP=Approved STG=Staged SUB=Submitted XML=Submitted, Pending Validation |