FO_CAND_AVAIL

(SQL View)
 Index Back

SELECT A.CANDIDATE_ID , %Coalesce(B.PLACEMENT_TYPE, C.PLACEMENT_TYPE) , %Coalesce(B.DESIRED_SHIFT_M, C.DESIRED_SHIFT_M) , %Coalesce(B.DESIRED_SHIFT_T, C.DESIRED_SHIFT_T) , %Coalesce(B.DESIRED_SHIFT_W, C.DESIRED_SHIFT_W) , %Coalesce(B.DESIRED_SHIFT_TH, C.DESIRED_SHIFT_TH) , %Coalesce(B.DESIRED_SHIFT_FR, C.DESIRED_SHIFT_FR) , %Coalesce(B.DESIRED_SHIFT_SA, C.DESIRED_SHIFT_SA) , %Coalesce(B.DESIRED_SHIFT_SU, C.DESIRED_SHIFT_SU) , %Coalesce(B.DESIRED_START_DT, C.DESIRED_START_DT) , %Coalesce(B.DESIRED_END_DT, C.DESIRED_END_DT) , %Coalesce(B.DESIRED_HOURS, C.DESIRED_HOURS) , %Coalesce(B.OVERTIME, C.OVERTIME) , %Coalesce(B.FT_STUDENT, C.FT_STUDENT) , %Coalesce(B.TRANSPORT_AVAIL, C.TRANSPORT_AVAIL) , %Coalesce(B.PAY_FREQ_ABBRV, C.PAY_FREQ_ABBRV) , %Coalesce(B.MIN_RATE, C.MIN_RATE) , %Coalesce(B.APP_DT, C.APP_DT) FROM PS_FO_CANDIDATE_W A , PS_FO_APP_AVAIL_VW B , PS_FO_EMP_AVAIL_VW C WHERE A.CANDIDATE_ID = C.EMPLID (+) AND A.CANDIDATE_ID = B.APPLID (+)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 CANDIDATE_ID Character(11) VARCHAR2(11) NOT NULL Used as a general ID for anything from Employee id to other types of ID like asset and material.
2 PLACEMENT_TYPE Character(1) VARCHAR2(1) NOT NULL Placement Type
B=Temp & Career
C=Career
L=Leasing
N=Contract
P=Payrolling
T=Temp
3 DESIRED_SHIFT_M Character(1) VARCHAR2(1) NOT NULL Monday Shift
4 DESIRED_SHIFT_T Character(1) VARCHAR2(1) NOT NULL Tuesday Shift
5 DESIRED_SHIFT_W Character(1) VARCHAR2(1) NOT NULL Wednesday Shift
6 DESIRED_SHIFT_TH Character(1) VARCHAR2(1) NOT NULL Thursday Shift
7 DESIRED_SHIFT_FR Character(1) VARCHAR2(1) NOT NULL Friday Shift
8 DESIRED_SHIFT_SA Character(1) VARCHAR2(1) NOT NULL Saturday Shift
9 DESIRED_SHIFT_SU Character(1) VARCHAR2(1) NOT NULL Sunday Shift
10 DESIRED_START_DT Date(10) DATE Desired Start Date
11 DESIRED_END_DT Date(10) DATE Last Date Available
12 DESIRED_HOURS Number(4,1) DECIMAL(3,1) NOT NULL Desired Hours Per Week
13 OVERTIME Character(1) VARCHAR2(1) NOT NULL Overtime OK?
14 FT_STUDENT Character(1) VARCHAR2(1) NOT NULL Full-Time Student
15 TRANSPORT_AVAIL Character(1) VARCHAR2(1) NOT NULL Transport Availability
A=Always Available
N=N/A
P=Public Transportation
16 PAY_FREQ_ABBRV Character(1) VARCHAR2(1) NOT NULL Pay Frequency
B=Bi-weeky
H=Hour
M=Month
Y=Year
17 MIN_RATE Number(19,6) DECIMAL(18,6) NOT NULL Minimum Acceptable Pay Rate
18 APP_DT Date(10) DATE Application Date