HR_TBHSRCH_VW (SQL View)	Index Back
Hire Request View This view is used as a search record for Manage Hire Detail component. The value in SRC_KEY maps to the HRTMPL_SEQ field on the TBH staging tables.

HR_TBHSRCH_VW

(SQL View)

Hire Request View

This view is used as a search record for Manage Hire Detail component. The value in SRC_KEY maps to the HRTMPL_SEQ field on the TBH staging tables.

SELECT HIRE_REQUEST_ID , SRC_KEY FROM PS_HR_REQUEST

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 HIRE_REQUEST_ID Number(10,0) DECIMAL(10) NOT NULL Hire Request ID

2 SRC_KEY Character(254) VARCHAR2(254) NOT NULL Hire Request Source Key

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	HIRE_REQUEST_ID	Number(10,0)	DECIMAL(10) NOT NULL	Hire Request ID
2	SRC_KEY	Character(254)	VARCHAR2(254) NOT NULL	Hire Request Source Key