RC_TIME_VW(SQL View) |
Index Back |
---|---|
Time ReportTime 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 |