RE_SAR_REP_VW

(SQL View)
 Index Back

Recent SAR Exec. Performance

View of Recent SAR Exec. Performance

SELECT A.BUSINESS_UNIT , A.SAR_ID , A.SAR_NAME , A.SAR_START_DT , A.ESTIMATED_COMP_DT , %DateDiff(A.SAR_START_DT,A.ESTIMATED_COMP_DT ) AS ESTIMATED_DIFF , A.ACTUAL_COMP_DT , %DateDiff(A.SAR_START_DT,A.ACTUAL_COMP_DT) AS ACTUAL_DIFF , %DateDiff(A.ESTIMATED_COMP_DT,A.ACTUAL_COMP_DT) AS DIFFERENCE , ( CASE WHEN %DateDiff(A.ACTUAL_COMP_DT,%CURRENTDATEIN) >= 0 AND %DateDiff(A.ACTUAL_COMP_DT,%CURRENTDATEIN) <= 30 THEN 1 ELSE 0 END ) AS THIRTY_DAYS , ( CASE WHEN %DateDiff(A.ACTUAL_COMP_DT,%CURRENTDATEIN) >= 31 AND %DateDiff(A.ACTUAL_COMP_DT,%CURRENTDATEIN) <= 60 THEN 1 ELSE 0 END ) AS SIXTY_DAYS , ( CASE WHEN %DateDiff(A.ACTUAL_COMP_DT,%CURRENTDATEIN) >= 61 AND %DateDiff(A.ACTUAL_COMP_DT,%CURRENTDATEIN) <= 180 THEN 1 ELSE 0 END ) AS SIX_MONTHS FROM PS_RE_SAR_DETAIL A WHERE A.SAR_STATUS = '5'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 SAR_ID Character(15) VARCHAR2(15) NOT NULL SAR ID
3 SAR_NAME Character(60) VARCHAR2(60) NOT NULL Site Acquisition Request Name
4 SAR_START_DT Date(10) DATE Commencement
5 ESTIMATED_COMP_DT Date(10) DATE Estimated Completion Date
6 PERIOD1_UNITS Signed Number(7,0) DECIMAL(6) NOT NULL Number of Periods represents the period range.
7 ACTUAL_COMP_DT Date(10) DATE Actual Completion Date
8 PERIOD2_UNITS Signed Number(7,0) DECIMAL(6) NOT NULL Number of Periods represents the period range.
9 PERIOD3_UNITS Signed Number(7,0) DECIMAL(6) NOT NULL Number of Periods represents the period range.
10 THIRTY_DAYS Number(6,0) INTEGER NOT NULL Recently Acquired Paglet Field
11 SIXTY_DAYS Number(6,0) INTEGER NOT NULL Recently Acquired Paglet Field
12 SIX_MONTHS Number(6,0) INTEGER NOT NULL Recently Acquired Paglet Field