TL_RPTD_APP_VW2(SQL View) |
Index Back |
|---|---|
Latest Aprver for a time entryView used in pivot grids to show the latest approver for a given time entry. |
| SELECT X.EMPLID , X.EMPL_RCD , X.DUR , X.SEQ_NBR , X.PUNCH_TYPE , U.OPRID , disp_names.NAME_DISPLAY FROM PS_TL_APP_RPTD_XRF X , PS_EOAW_STEPINST S , PS_EOAW_USERINST U , PSOPRDEFN OPR , PS_NAMES disp_names WHERE X.RECNAME <> 'TL_APP_HDR' AND X.EOAWTHREAD_ID = S.EOAWTHREAD_ID AND X.EOAWPRCS_ID = S.EOAWPRCS_ID AND S.EOAWSTEP_INSTANCE = U.EOAWSTEP_INSTANCE AND U.OPRID = OPR.OPRID AND X.TRANSACTIONID = ( SELECT MAX(TRANSACTIONID) FROM PS_TL_APP_RPTD_XRF SUB WHERE SUB.EMPLID=X.EMPLID AND SUB.EMPL_RCD=X.EMPL_RCD AND SUB.DUR=X.DUR AND SUB.SEQ_NBR=X.SEQ_NBR AND SUB.PUNCH_TYPE=X.PUNCH_TYPE) AND X.EOAWTHREAD_ID = ( SELECT MAX(EOAWTHREAD_ID) FROM PS_TL_APP_RPTD_XRF SUB WHERE SUB.EMPLID=X.EMPLID AND SUB.EMPL_RCD=X.EMPL_RCD AND SUB.DUR=X.DUR AND SUB.SEQ_NBR=X.SEQ_NBR AND SUB.PUNCH_TYPE=X.PUNCH_TYPE AND SUB.TRANSACTIONID = X.TRANSACTIONID) AND S.EOAWSTEP_INSTANCE = ( SELECT MAX(SS.EOAWSTEP_INSTANCE) FROM PS_EOAW_STEPINST SS WHERE S.EOAWTHREAD_ID = SS.EOAWTHREAD_ID) AND U.EOAWUSTEP_INST_ID = ( SELECT MAX(US.EOAWUSTEP_INST_ID) FROM PS_EOAW_USERINST US WHERE U.EOAWSTEP_INSTANCE = US.EOAWSTEP_INSTANCE) AND disp_names.EMPLID = OPR.EMPLID AND disp_names.NAME_TYPE = 'PRI' AND disp_names.effdt = ( SELECT MAX(disp_enames.effdt) FROM PS_NAMES disp_enames WHERE disp_enames.EMPLID = disp_names.EMPLID AND disp_enames.NAME_TYPE = disp_names.NAME_TYPE AND disp_enames.effdt <= %CurrentDateIn) |
| # | 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 | Date Under Report associates time being reported, scheduled or paid, to a specific date. |
| 4 | SEQ_NBR | Number(15,0) | DECIMAL(15) NOT NULL | Sequence Number |
| 5 | PUNCH_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Global Punch Types
0=Elapsed 1=In 2=Out 3=Meal 4=Break 5=Transfer |
| 6 | ORIGINATORID | Character(30) | VARCHAR2(30) NOT NULL | Originator Identifier |
| 7 | APPROVER_NAME | Character(50) | VARCHAR2(50) NOT NULL | Approver Name |