EX_ED_EXCEPT_VW

(SQL View)
 Index Back

EX Sheet Exceptions

This view returns the total number of exceptions per expense report.

SELECT A.SHEET_ID , SUM((CASE WHEN A.OUT_OF_POLICY = 'Y' THEN 1 ELSE 0 END) + (CASE WHEN A.PREF_MRCH_NOT_USED = 'Y' THEN 1 ELSE 0 END) + (CASE WHEN A.DUPLICATES_EXIST = 'Y' THEN 1 ELSE 0 END) + (CASE WHEN A.OLDER_TRANSACTION = 'Y' THEN 1 ELSE 0 END) + (CASE WHEN A.NO_RECEIPT_FLG = 'Y' THEN 1 ELSE 0 END)) FROM PS_EX_SHEET_LINE A GROUP BY A.SHEET_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SHEET_ID Character(10) VARCHAR2(10) NOT NULL Report ID
2 EXCEPTION_NUM Number(3,0) SMALLINT NOT NULL Exception Flag