HRS_JO_AINFO_VW (SQL View)	Index Back
Position Applied For - Max Req Maximum app dt for position applied for record for an applicant for each requisition.

HRS_JO_AINFO_VW

(SQL View)

Position Applied For - Max Req

Maximum app dt for position applied for record for an applicant for each requisition.

SELECT A.HRS_RCMNT_ID ,A.HRS_PROFILE_SEQ ,A.STATUS_REASON ,A.HRS_STATUS_DT ,A.HRS_ROW_UPD_DTTM ,PROF.PREV_EMPL_BY_COMPY ,CASE WHEN A.HRS_SUBMIT_SOURCE = 'C' THEN PROF.HRS_SUBMITTED_DTTM WHEN A.HRS_SUBMIT_SOURCE = 'T' THEN A.HRS_ROW_ADD_DTTM ELSE PROF.HRS_SUBMITTED_DTTM END FROM PS_HRS_RCMNT A , PS_HRS_APP_PROFILE PROF WHERE PROF.HRS_PERSON_ID = A.HRS_PERSON_ID AND PROF.HRS_PROFILE_SEQ = A.HRS_PROFILE_SEQ AND A.HRS_LOGICAL_DELETE = 'N'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 HRS_RCMNT_ID Number(15,0) DECIMAL(15) NOT NULL App Tracking Recruitment ID

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

3 STATUS_REASON Character(3) VARCHAR2(3) NOT NULL Identifies a reason associated with a particular status.
Prompt Table: HRS_RSN_JO_I

4 HRS_STATUS_DT Date(10) DATE Recruiting Solutions Status Date field

5 HRS_ROW_UPD_DTTM DateTime(26) TIMESTAMP Row Updated DateTime

6 PREV_EMPL_BY_COMPY Character(1) VARCHAR2(1) NOT NULL Previously Employed by Company
N=No
Y=Yes

7 HRS_SUBMITTED_DTTM DateTime(26) TIMESTAMP Submitted Date Time

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	HRS_RCMNT_ID	Number(15,0)	DECIMAL(15) NOT NULL	App Tracking Recruitment ID
2	HRS_PROFILE_SEQ	Number(3,0)	SMALLINT NOT NULL	Profile sequece
3	STATUS_REASON	Character(3)	VARCHAR2(3) NOT NULL	Identifies a reason associated with a particular status. Prompt Table: HRS_RSN_JO_I
4	HRS_STATUS_DT	Date(10)	DATE	Recruiting Solutions Status Date field
5	HRS_ROW_UPD_DTTM	DateTime(26)	TIMESTAMP	Row Updated DateTime
6	PREV_EMPL_BY_COMPY	Character(1)	VARCHAR2(1) NOT NULL	Previously Employed by Company N=No Y=Yes
7	HRS_SUBMITTED_DTTM	DateTime(26)	TIMESTAMP	Submitted Date Time