EX_TRMAP_AW_VW2

(SQL View)
 Index Back

MAP Urgency for Time Reports

View used to determine Urgency for MAP for Time Reports

SELECT DISTINCT H.TIME_SHEET_ID , H.VERSION_NUM , H.CREATION_DT , H.SUBMISSION_DATE , U.OPRID FROM PS_EX_TIME_HDR H , PS_EX_TIME_AW X , PS_EOAW_STEPINST S , PS_EOAW_USERINST U WHERE H.TIME_SHEET_ID = X.TIME_SHEET_ID AND X.EOAWTHREAD_ID = S.EOAWTHREAD_ID AND X.EOAWPRCS_ID = S.EOAWPRCS_ID AND X.EOAWDEFN_ID = S.EOAWDEFN_ID AND S.EOAWSTEP_INSTANCE = U.EOAWSTEP_INSTANCE AND X.EOAWTHREAD_ID = ( CASE WHEN EXISTS ( SELECT EOAWTHREAD_STATUS FROM PS_EX_TIME_AW C1 WHERE H.TIME_SHEET_ID = C1.TIME_SHEET_ID AND C1.RECNAME = 'EX_TR_HDR_AW_VW' AND C1.EOAWTHREAD_STATUS = 'P') THEN ( SELECT MIN(X1.EOAWTHREAD_ID) FROM PS_EX_TIME_AW X1 WHERE X1.TIME_SHEET_ID = X.TIME_SHEET_ID) WHEN EXISTS ( SELECT EOAWTHREAD_STATUS FROM PS_EX_TIME_AW C1 WHERE H.TIME_SHEET_ID = C1.TIME_SHEET_ID AND C1.RECNAME = 'EX_TR_LN_AW_VW' AND C1.EOAWTHREAD_STATUS = 'P') THEN ( SELECT MAX(X1.EOAWTHREAD_ID) FROM PS_EX_TIME_AW X1 WHERE X1.TIME_SHEET_ID = X.TIME_SHEET_ID) END ) AND H.VERSION_NUM = 1

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 TIME_SHEET_ID Character(10) VARCHAR2(10) NOT NULL Time Sheet Unique Identifier (System Generated)
2 VERSION_NUM Number(3,0) SMALLINT NOT NULL Version Number
3 SUBMISSION_DATE Date(10) DATE Submission Date
4 CREATION_DT Date(10) DATE Creation Date
5 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).