HRS_APP_CURR_I

(SQL View)
 Index Back

Search Vw-Applicant/EE

The APPLICANT_DATA view is a search record used in Recruitment to access applicant records (employees and outside applicants).

SELECT A.HRS_PERSON_ID , A.APPLID , B.HRS_SUBMITTED_DTTM , A.EMPLID , A.STATUS_CODE , A.STATUS_REASON , A.STATUS_DT , A.APP_PER_STATUS , B.APPLIC_PURGE_DT , A.SEX , A.BIRTHDATE , A.BIRTHPLACE , A.BIRTHCOUNTRY , A.BIRTHSTATE , B.HIGHEST_EDUC_LVL , B.LANG_CD , B.YEARS_OF_EXP , B.HRS_REPORT_DEFN_ID , B.HRS_REPORT_TMPL_ID , B.LETTER_PRINTED_DT , B.TRAVELLING , B.RELOCATE , B.UNION_CD , B.DESIRED_HOURS , B.MIN_RATE , B.CURRENCY_CD , B.DESIRED_START_DT , B.DESIRED_FULL_PART , B.DESIRED_REG_TEMP , B.DESIRED_SHIFT , B.MON , B.TUES , B.WED , B.THURS , B.FRI , B.SAT , B.SUN , B.BUSINESS_UNIT , B.HRS_DES_LOC1 , B.HRS_DES_LOC2 , B.PAY_FREQ_ABBRV , B.HRS_TRAVEL_PERCENT , B.GEOG_PREFER , D.OPEN_STS_IND FROM PS_HRS_APPLICANT A ,PS_HRS_APP_PROFILE B ,PS_HRS_STS_APP_I D WHERE B.HRS_PERSON_ID = A.HRS_PERSON_ID AND B.HRS_SUBMITTED_DTTM = ( SELECT MAX(B1.HRS_SUBMITTED_DTTM ) FROM PS_HRS_APP_PROFILE B1 WHERE A.HRS_PERSON_ID = B1.HRS_PERSON_ID) AND D.STATUS_CODE = A.STATUS_CODE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 HRS_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL Person Id
2 APPLID Character(11) VARCHAR2(11) NOT NULL External Job Applicant ID

Prompt Table: HRS_APPLICANT_I

3 HRS_SUBMITTED_DTTM DateTime(26) TIMESTAMP Submitted Date Time
4 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: HRS_PERSON_NM_I

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

Prompt Table: HRS_STS_APP_I

6 STATUS_REASON Character(3) VARCHAR2(3) NOT NULL Identifies a reason associated with a particular status.

Prompt Table: HRS_RSN_APP_I

7 STATUS_DT Date(10) DATE Status Date

Default Value: %date

8 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

Default Value: A

9 APPLIC_PURGE_DT Date(10) DATE Store date by which applicant records are to be deleted as part of the applicant purge process
10 SEX Character(1) VARCHAR2(1) NOT NULL Gender
F=Female
M=Male
U=Unknown
X=Indeterminate/Intersex/Unspec

Default Value: U

11 BIRTHDATE Date(10) DATE Date of Birth
12 BIRTHPLACE Character(30) VARCHAR2(30) NOT NULL Birth Location
13 BIRTHCOUNTRY Character(3) VARCHAR2(3) NOT NULL Birth Country

Prompt Table: HRS_COUNTRY_VW

14 BIRTHSTATE Character(6) VARCHAR2(6) NOT NULL Birth State

Prompt Table: BIRTHSTATE_VW

15 HIGHEST_EDUC_LVL Character(2) VARCHAR2(2) NOT NULL Highest Education Level

Default Value: A

16 LANG_CD Character(3) VARCHAR2(3) NOT NULL Language Code
CFR=Canadian French
DAN=Danish
DUT=Dutch
ENG=English
ESP=Spanish
FRA=French
GER=German
GRK=Greek
INE=International English
ITA=Italian
JPN=Japanese
KOR=Korean
POR=Portuguese
SVE=Swedish
THA=Thai
ZHS=Simplified Chinese
ZHT=Traditional Chinese
17 YEARS_OF_EXP Number(5,1) DECIMAL(4,1) NOT NULL Years of Work Experience

Default Value: 0

18 HRS_REPORT_DEFN_ID Character(12) VARCHAR2(12) NOT NULL The Fusion Publisher Report Definition ID used by Recruiting
19 HRS_REPORT_TMPL_ID Character(30) VARCHAR2(30) NOT NULL The Fusion publisher Report template ID used by RS.
20 LETTER_PRINTED_DT Date(10) DATE Date letter was printed
21 TRAVELLING Character(1) VARCHAR2(1) NOT NULL Willing to Travel

Y/N Table Edit

Default Value: N

22 RELOCATE Character(1) VARCHAR2(1) NOT NULL Willing to Relocate

Y/N Table Edit

Default Value: N

23 UNION_CD Character(3) VARCHAR2(3) NOT NULL Union Code
24 DESIRED_HOURS Number(4,1) DECIMAL(3,1) NOT NULL Desired Hours Per Week
25 MIN_RATE Number(19,6) DECIMAL(18,6) NOT NULL Minimum Acceptable Pay Rate
26 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
27 DESIRED_START_DT Date(10) DATE Desired Start Date
28 DESIRED_FULL_PART Character(1) VARCHAR2(1) NOT NULL Full/Part-Time
E=Either
F=Full-Time
P=Part-Time
29 DESIRED_REG_TEMP Character(1) VARCHAR2(1) NOT NULL Regular/Temporary
E=Either
R=Regular
T=Temporary
30 DESIRED_SHIFT Character(1) VARCHAR2(1) NOT NULL Desired Shift
1=1
2=2
3=3
A=Any
C=Compressed
N=Not Applicable
R=Rotating
31 MON Character(1) VARCHAR2(1) NOT NULL Monday

Default Value: Y

32 TUES Character(1) VARCHAR2(1) NOT NULL Tuesday

Default Value: Y

33 WED Character(1) VARCHAR2(1) NOT NULL Wednesday

Default Value: Y

34 THURS Character(1) VARCHAR2(1) NOT NULL Thursday

Default Value: Y

35 FRI Character(1) VARCHAR2(1) NOT NULL Friday

Default Value: Y

36 SAT Character(1) VARCHAR2(1) NOT NULL Saturday
37 SUN Character(1) VARCHAR2(1) NOT NULL Sunday
38 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
39 HRS_DES_LOC1 Number(15,0) DECIMAL(15) NOT NULL Desired Location 1

Prompt Table: HRS_LOC_I

40 HRS_DES_LOC2 Number(15,0) DECIMAL(15) NOT NULL Desired Location 2

Prompt Table: HRS_LOC_I

41 PAY_FREQ_ABBRV Character(1) VARCHAR2(1) NOT NULL Pay Frequency
A=Annual
B=Bi-weeky
H=Hour
M=Month
Y=Year
42 HRS_TRAVEL_PERCENT Character(1) VARCHAR2(1) NOT NULL Travel percent
0=None
1=<= 25%
2=26 - 50 %
3=51 - 75 %
4=76 - 100 %
43 GEOG_PREFER Long Character CLOB Geographic Preference
44 OPEN_STS_IND Character(1) VARCHAR2(1) NOT NULL Indicates an open state.