HRS_PRF_SRCH_VW (SQL View)	Index Back
Applicant Profile Interface This Interface view is to retrieve all the applicant profiles.

HRS_PRF_SRCH_VW

(SQL View)

Applicant Profile Interface

This Interface view is to retrieve all the applicant profiles.

SELECT HRS_PERSON_ID ,HRS_PROFILE_SEQ ,HRS_SUBMITTED_BY ,HRS_SUBMITTED_DTTM FROM PS_HRS_APP_PROFILE A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 HRS_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL Person Id

2 HRS_PROFILE_SEQ Number(3,0) SMALLINT NOT NULL Profile sequece
Default Value: 0

3 HRS_SUBMITTED_BY Character(15) VARCHAR2(15) NOT NULL submitted by

4 HRS_SUBMITTED_DTTM DateTime(26) TIMESTAMP Submitted Date Time

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	HRS_PERSON_ID	Number(15,0)	DECIMAL(15) NOT NULL	Person Id
2	HRS_PROFILE_SEQ	Number(3,0)	SMALLINT NOT NULL	Profile sequece Default Value: 0
3	HRS_SUBMITTED_BY	Character(15)	VARCHAR2(15) NOT NULL	submitted by
4	HRS_SUBMITTED_DTTM	DateTime(26)	TIMESTAMP	Submitted Date Time