RC_TIME_VW

(SQL View)
Index Back

Time Report

Time Report for case. Time recorded on case that agents have been worked on. Regardless if it's billable time or not. It used to subtract time from prepaid for agreement of external no pricing.

SELECT t.CASE_ID , t.BUSINESS_UNIT , l.PERSON_ID , SUM(DTL_TOTAL) FROM %Table(RF_TIME) t , %Table(RF_TIME_LINE) l WHERE t.BUSINESS_UNIT = l.BUSINESS_UNIT AND t.TIME_SHEET_ID = l.TIME_SHEET_ID AND t.CASE_ID <> 0 AND l.PERSON_ID <> ' ' GROUP BY t.CASE_ID, t.BUSINESS_UNIT, l.PERSON_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 CASE_ID Number(15,0) DECIMAL(15) NOT NULL Case ID. This is a unique ID assigned to a case when it is saved. Unique ID is ensured by getting the next value from the auto-numbering table and updating the table.
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
3 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID
4 DTL_TOTAL Signed Number(9,4) DECIMAL(7,4) NOT NULL Total