TE_SHE_MOD_VW

(SQL View)
 Index Back

MTE Time Sheet Mode View

Mobile Time Entry Time Sheet Mode View

SELECT A.TIME_SHEET_ID AS TIME_SHEET_ID , A.VERSION_NUM AS VERSION_NUM , A.LINE_NBR AS LINE_NBR , MAX(B.DATE_UNDER_RPT) AS DATE_UNDER_RPT , MAX(A.BUSINESS_UNIT_PC) AS BUSINESS_UNIT_PC , MAX(A.PROJECT_ID) AS PROJECT_ID , MAX(A.ACTIVITY_ID) AS ACTIVITY_ID , '' AS TRC , SUM(B.TIME_QUANTITY) AS TIME_QUANTITY , MAX(A.BILLING_ACTION) AS BILLING_ACTION FROM PS_EX_TIME_DTL A LEFT JOIN PS_EX_TIME_DTL_DLY B ON A.TIME_SHEET_ID = B.TIME_SHEET_ID AND A.VERSION_NUM = B.VERSION_NUM AND A.LINE_NBR = B.LINE_NBR GROUP BY A.TIME_SHEET_ID , A.VERSION_NUM , A.LINE_NBR UNION ALL SELECT A.TIME_SHEET_ID AS TIME_SHEET_ID , A.VERSION_NUM AS VERSION_NUM , A.LINE_NBR AS LINE_NBR , MAX(B.DATE_UNDER_RPT) AS DATE_UNDER_RPT , '' AS BUSINESS_UNIT_PC , '' AS PROJECT_ID , '' AS ACTIVITY_ID , MAX(A.TRC) AS TRC , SUM(B.TIME_QUANTITY) AS TIME_QUANTITY , '' AS BILLING_ACTION FROM PS_EX_TIME_POL A , PS_EX_TIME_POL_DLY B WHERE A.TIME_SHEET_ID = B.TIME_SHEET_ID AND A.VERSION_NUM = B.VERSION_NUM AND A.LINE_NBR = B.LINE_NBR GROUP BY A.TIME_SHEET_ID, A.VERSION_NUM, A.LINE_NBR

# 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 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
4 DATE_UNDER_RPT Date(10) DATE Date Under Report
5 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit
6 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
7 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID
8 TRC Character(5) VARCHAR2(5) NOT NULL Time Reporting Code
9 TIME_QUANTITY Signed Number(16,2) DECIMAL(14,2) NOT NULL Time Quantity
10 BILLING_ACTION Character(1) VARCHAR2(1) NOT NULL Billing Action
B=Billable
I=Internal
P=Personal
U=Nonbillable