EX_SUB_APPR_VW

(SQL View)
 Index Back

EX Submission to Approval View

Expense Submission to Approval View

SELECT A.SHEET_ID , B.MAX_LINE_NBR , B.MAX_DISTRIB_LINE , ROUND(%DateDiff((CASE WHEN A.RESUBMISSION_DT IS NULL THEN A.SUBMISSION_DATE ELSE A.RESUBMISSION_DT END), A.APPROVAL_DT) ,2) AS SUB_APPR FROM PS_EX_SHEET_HDR A , PS_EX_MAX_LN_DL_VW B , PS_EX_SHEET_LINE C , PS_EX_SHEET_DIST D WHERE A.SHEET_STATUS = 'APY' AND A.SHEET_ID = B.SHEET_ID AND B.SHEET_ID = C.SHEET_ID AND C.SHEET_ID = D.SHEET_ID AND B.MAX_LINE_NBR = C.LINE_NBR AND B.MAX_LINE_NBR = D.LINE_NBR AND B.MAX_DISTRIB_LINE = D.DISTRIB_LINE_NUM

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SHEET_ID Character(10) VARCHAR2(10) NOT NULL Report ID
2 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
3 DISTRIB_LINE_NUM Number(5,0) INTEGER NOT NULL Distribution Line
4 EX_SUB_TO_APPR Signed Number(14,2) DECIMAL(12,2) NOT NULL Expense Submission to Approval