SF_EMPLOYEE_VW

(SQL View)
Index Back

Employee View - Stdnt Fin

Student Financials Employee View

SELECT A.EMPLID, A.EMPL_RCD, A.EFFDT, A.COMPANY, A.DEPTID, A.POSITION_NBR, A.EMPL_STATUS, A.FULL_PART_TIME, A.STD_HOURS, A.OFFICER_CD, A.GRADE, A.PAYGROUP FROM PS_JOB A WHERE A.EFFSEQ = (SELECT MAX(B.EFFSEQ) FROM PS_JOB B WHERE B.EMPLID = A.EMPLID AND B.EMPL_RCD = A.EMPL_RCD AND B.EFFDT = A.EFFDT)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
3 EFFDT Date(10) DATE Effective Date

Default Value: %date

4 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
5 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
6 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number
7 EMPL_STATUS Character(1) VARCHAR2(1) NOT NULL Payroll Status
A=Active
D=Deceased
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
8 FULL_PART_TIME Character(1) VARCHAR2(1) NOT NULL Full/Part Time
D=On Demand
F=Full-Time
P=Part-Time
9 STD_HOURS Number(7,2) DECIMAL(6,2) NOT NULL Standard Hours
10 OFFICER_CD Character(1) VARCHAR2(1) NOT NULL Officer Code
C=Chairman
D=Director
N=None
O=Officer
P=President
S=Secretary
T=Treasurer
V=Vice President
11 GRADE Character(3) VARCHAR2(3) NOT NULL Salary Grade
12 PAYGROUP Character(3) VARCHAR2(3) NOT NULL Pay Group