FO_EMPL_VW

(SQL View)
 Index Back

Staffing General Employee view


SELECT J.EMPLID , J.EMPL_RCD , J.EFFDT , P.NAME , P.PER_STATUS , J.PAY_SYSTEM_FLG , J.EMPL_TYPE , J.JOBCODE , J.DEPTID , J.LOCATION , J.COMPANY , J.BUSINESS_UNIT , J.PAYGROUP , J.GP_PAYGROUP , J.TAX_LOCATION_CD , J.EMPL_STATUS , J.FLSA_STATUS FROM PS_JOB J , PS_PERSONAL_DATA P WHERE J.EMPLID = P.EMPLID AND J.EFFSEQ = ( SELECT MAX(EFFSEQ) FROM PS_JOB JJ WHERE JJ.EMPLID = J.EMPLID AND JJ.EMPL_RCD = J.EMPL_RCD AND JJ.EFFDT = J.EFFDT)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 EMPL_RCD_NUM Number(3,0) SMALLINT NOT NULL Project Employee Job Record #
3 EFFDT Date(10) DATE Effective Date
4 NAME Character(50) VARCHAR2(50) NOT NULL Name
5 PER_STATUS Character(1) VARCHAR2(1) NOT NULL Personnel Status
E=Employee
N=Non-Employee
6 PAY_SYSTEM_FLG Character(2) VARCHAR2(2) NOT NULL Payroll System
GB=European
GP=Global Payroll
GS=German/Swiss Payroll
NA=North American Payroll
OT=Other
PI=Payroll Interface
7 EMPL_TYPE Character(1) VARCHAR2(1) NOT NULL Employee Type
E=Exception Hourly
H=Hourly
N=Not Applicable
S=Salaried
8 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code
9 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
10 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
11 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
12 BUSINESS_UNIT_HR Character(5) VARCHAR2(5) NOT NULL Business Unit HR
13 PAYGROUP Character(3) VARCHAR2(3) NOT NULL Pay Group
14 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Pay Group
15 TAX_LOCATION_CD Character(10) VARCHAR2(10) NOT NULL Tax Location Code
16 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
17 FLSA_STATUS Character(1) VARCHAR2(1) NOT NULL FLSA Status
A=Administrative
E=Executive
M=Management
N=Nonexempt
O=Outside Salesperson
P=Professional
X=No FLSA Required