FO_APP_AVAIL_VW

(SQL View)
 Index Back

FO_APP_AVAIL_VW


SELECT A.APPLID , A.PLACEMENT_TYPE , A.DESIRED_SHIFT_M , A.DESIRED_SHIFT_T , A.DESIRED_SHIFT_W , A.DESIRED_SHIFT_TH , A.DESIRED_SHIFT_FR , A.DESIRED_SHIFT_SA , A.DESIRED_SHIFT_SU , A.DESIRED_START_DT , A.DESIRED_END_DT , A.DESIRED_HOURS , A.OVERTIME , A.FT_STUDENT , A.TRANSPORT_AVAIL , A.PAY_FREQ_ABBRV , A.MIN_RATE , A.APP_DT FROM PS_FO_APP_AVAIL A WHERE A.DESIRED_START_DT = ( SELECT MAX(B.DESIRED_START_DT) FROM PS_FO_APP_AVAIL B WHERE A.APPLID = B.APPLID)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 APPLID Character(11) VARCHAR2(11) NOT NULL External Job Applicant ID
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