RC_TM_SRCH_VW (SQL View)	Index Back
Time Log Header View of time from a case from the Time Log Header table

RC_TM_SRCH_VW

(SQL View)

Time Log Header

View of time from a case from the Time Log Header table

SELECT TIME_SHEET_ID , BUSINESS_UNIT , CASE_ID FROM PS_RF_TIME WHERE CASE_ID > 0

# 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 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Default Value: OPR_DEF_TBL_RB.BUSINESS_UNIT
Prompt Table: SP_BU_RC_NONVW

3 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.