HRS_LIST_APP_VW (SQL View)	Index Back
Applicant Lists Applicant Lists

HRS_LIST_APP_VW

(SQL View)

Applicant Lists

SELECT B.HRS_PERSON_ID , B.HRS_LST_ID , C.NAME_DISPLAY , %DateNull , D.HRS_APP_PREF_CONT ,' ' ,' ' FROM PS_HRS_LIST A , PS_HRS_LIST_APPL B ,PS_HRS_APP_NAME_I C , PS_HRS_APPLICANT_I D WHERE A.HRS_LST_ID = B.HRS_LST_ID AND B.HRS_PERSON_ID = C.HRS_PERSON_ID AND B.HRS_PERSON_ID = D.HRS_PERSON_ID AND A.HRS_LST_TYPE IN ('APPL','SSRL') AND HRS_LST_FREEZE<>'Y' AND (A.HRS_SAVE_UNTIL IS NULL OR A.HRS_SAVE_UNTIL >=%CurrentDateIn)

# 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_LST_ID Number(15,0) DECIMAL(15) NOT NULL List ID

3 NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Display Name - name formatted for Display based on the Country

4 HRS_CNTCT_DT Date(10) DATE Contact Date

5 HRS_APP_PREF_CONT Character(1) VARCHAR2(1) NOT NULL Preferred Method of Contact
E=EMail
M=Mail
N=Not Specified
P=Phone

6 HRS_APP_PREF_CNTCT Character(70) VARCHAR2(70) NOT NULL Preferred Contact

7 HRS_LAST_CNTCT_BY Character(11) VARCHAR2(11) NOT NULL Last Contacted By

#	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_LST_ID	Number(15,0)	DECIMAL(15) NOT NULL	List ID
3	NAME_DISPLAY	Character(50)	VARCHAR2(50) NOT NULL	Display Name - name formatted for Display based on the Country
4	HRS_CNTCT_DT	Date(10)	DATE	Contact Date
5	HRS_APP_PREF_CONT	Character(1)	VARCHAR2(1) NOT NULL	Preferred Method of Contact E=EMail M=Mail N=Not Specified P=Phone
6	HRS_APP_PREF_CNTCT	Character(70)	VARCHAR2(70) NOT NULL	Preferred Contact
7	HRS_LAST_CNTCT_BY	Character(11)	VARCHAR2(11) NOT NULL	Last Contacted By