SF_EMPLOYEE_VW(SQL View) |
Index Back |
---|---|
Employee View - Stdnt FinStudent 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 |