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.

RC_TIME_VW

(SQL View)

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

#	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