FO_FSEARCH_VW

(SQL View)
 Index Back

Staffing Available Search View

Staffing Front Office Available Search View SELECT A.CANDIDATE_ID , A.CANDIDATE_TYPE , A.NAME , A.PER_STATUS , A.EMPL_STATUS ,A.PHONE ,A.CITY ,A.STATE , B.PAY_FREQ_ABBRV , B.MIN_RATE ,A.FO_BRANCH ,A.OPRID , A.PER_STATUS , A.FIRST_NAME , A.LAST_NAME FROM %Table(FO_CANDIDATE_W) A , %Table(FO_CAND_AVAIL) B WHERE A.CANDIDATE_ID = B.CANDIDATE_ID

SELECT A.CANDIDATE_ID , A.CANDIDATE_TYPE , A.NAME , A.PER_STATUS , A.EMPL_STATUS , A.PHONE , A.CITY , A.STATE , B.PAY_FREQ_ABBRV , B.MIN_RATE , A.FO_BRANCH , A.OPRID , A.PER_STATUS , A.FIRST_NAME , A.LAST_NAME FROM %Table(FO_CANDIDATE_W) A , %Table(FO_CAND_AVAIL) B WHERE A.CANDIDATE_ID = B.CANDIDATE_ID

# 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 CANDIDATE_TYPE Character(1) VARCHAR2(1) NOT NULL Candidate Type
A=Applicant
E=Employee
3 NAME Character(50) VARCHAR2(50) NOT NULL Name
4 PER_STATUS Character(1) VARCHAR2(1) NOT NULL Personnel Status
E=Employee
N=Non-Employee
5 EMPL_STATUS Character(1) VARCHAR2(1) NOT NULL Employee Status
A=Active
D=Deceased
I=Inactive
L=Leave of Absence
P=Leave With Pay
Q=Retired With Pay
R=Retired
S=Suspended
T=Terminated
U=Terminated With Pay
V=Terminated Pension Pay Out
W=Short Work Break
X=Retired-Pension Administration
6 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone
7 CITY Character(30) VARCHAR2(30) NOT NULL City
8 STATE Character(6) VARCHAR2(6) NOT NULL State
9 PAY_FREQ_ABBRV Character(1) VARCHAR2(1) NOT NULL Pay Frequency
B=Bi-weeky
H=Hour
M=Month
Y=Year
10 MIN_RATE Number(19,6) DECIMAL(18,6) NOT NULL Minimum Acceptable Pay Rate
11 FO_BRANCH Character(5) VARCHAR2(5) NOT NULL Business Unit
12 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
13 FO_PER_STATUS Character(1) VARCHAR2(1) NOT NULL Personnel Status (sibling of PER_STATUS but with option A = Applicant).
A=Applicant
E=Employee
N=Non-Employee
14 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
15 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name