RC_TIME_BI_VW (SQL View)	Index Back
Billable Time Report Billable Time Report for case.

RC_TIME_BI_VW

(SQL View)

Billable Time Report

Billable Time Report for case.

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 l.BILLABLE_SW = 'Y' 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