HRS_APL_WOUPD_V (SQL View)	Index Back
Applicants w/o activities This view returns applicants whose info are not updated in n days.

HRS_APL_WOUPD_V

(SQL View)

Applicants w/o activities

This view returns applicants whose info are not updated in n days.

SELECT A.HRS_PERSON_ID , A.APP_PER_STATUS , A.STATUS_CODE , ' ' , A.HRS_ROW_UPD_DTTM FROM PS_HRS_APPLICANT A , PS_HRS_SRCHIDX_SDP B WHERE B.PTSF_SBO_NAME = 'HC_HRS_APPLICANT' AND %DatePart(A.HRS_ROW_UPD_DTTM) >= B.FROM_DATE AND ((B.HRS_DAYS_IDX <> 0 AND %DatePart(A.HRS_ROW_UPD_DTTM) < %DateAdd(%CurrentDateIn,- B.HRS_DAYS_IDX)) OR (B.HRS_DAYS_IDX = 0 AND B.DAYS <> 0 AND %DatePart(A.HRS_ROW_UPD_DTTM) < %DateAdd(%CurrentDateIn,- B.DAYS)))

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 APP_PER_STATUS Character(1) VARCHAR2(1) NOT NULL Identifies the type of applicant - External Applicant, Employee or Non-Employee
A=External Applicant
E=Employee
N=Non-Employee

3 STATUS_CODE Character(3) VARCHAR2(3) NOT NULL Identifies a status.

4 HRS_LOGICAL_DELETE Character(1) VARCHAR2(1) NOT NULL Indicates row has been logically deleted.

5 HRS_ROW_UPD_DTTM DateTime(26) TIMESTAMP Row Updated DateTime

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	HRS_PERSON_ID	Number(15,0)	DECIMAL(15) NOT NULL	Person Id
2	APP_PER_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Identifies the type of applicant - External Applicant, Employee or Non-Employee A=External Applicant E=Employee N=Non-Employee
3	STATUS_CODE	Character(3)	VARCHAR2(3) NOT NULL	Identifies a status.
4	HRS_LOGICAL_DELETE	Character(1)	VARCHAR2(1) NOT NULL	Indicates row has been logically deleted.
5	HRS_ROW_UPD_DTTM	DateTime(26)	TIMESTAMP	Row Updated DateTime