HR_MO_JOB_VW

(SQL View)
 Index Back

Mse Over Job vw

Mouse Over Data; This view retrieve all Job data needed for the employee Pop Up Page.

SELECT A.EMPLID , A.EMPL_RCD , A.EFFDT , A.PER_ORG , A.DEPTID , A.DEPT_ENTRY_DT , A.JOBCODE , A.JOB_ENTRY_DT , A.POSITION_NBR , A.POSITION_ENTRY_DT , A.EMPL_STATUS , A.HR_STATUS , A.LOCATION , A.COMPANY , A.SAL_ADMIN_PLAN , A.GRADE , A.GRADE_ENTRY_DT , A.BUSINESS_UNIT , A.SETID_DEPT , A.SETID_JOBCODE , A.SETID_LOCATION , A.SETID_SALARY , A.REG_REGION , RG.COUNTRY , A.REPORTS_TO , A.ESTABID , A.PAY_SYSTEM_FLG , A.PAYGROUP , A.GP_PAYGROUP , A.FULL_PART_TIME , A.STD_HOURS , A.STEP FROM PS_JOB A , PS_REG_REGION_TBL RG WHERE A.EffSeq = ( SELECT MAX(D.EffSeq) FROM PS_JOB D WHERE D.EmplID = A.EmplID AND D.EMPL_RCD = A.EMPL_RCD AND D.EffDt = A.EffDt) AND RG.REG_REGION = A.REG_REGION

# 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 Record
3 EFFDT Date(10) DATE Effective Date

Default Value: %date

4 PER_ORG Character(3) VARCHAR2(3) NOT NULL Defines the Organizational Relationship(s) that a Person has to the Organization. These are Employee, Contingent Worker, and Persons of Interest.
CWR=Contingent Worker
EMP=Employee
POI=Person of Interest
5 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

Prompt Table: DEPT_TBL

6 DEPT_ENTRY_DT Date(10) DATE Department Entry Date
7 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code

Prompt Table: JOBCODE_TBL

8 JOB_ENTRY_DT Date(10) DATE Job Entry Date
9 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number
10 POSITION_ENTRY_DT Date(10) DATE Position Entry Date
11 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
12 HR_STATUS Character(1) VARCHAR2(1) NOT NULL HR Status
A=Active
I=Inactive
13 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

Prompt Table: LOCATION_TBL

14 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

Prompt Table: COMPANY_TBL

15 SAL_ADMIN_PLAN Character(4) VARCHAR2(4) NOT NULL Salary Administration Plan
16 GRADE Character(3) VARCHAR2(3) NOT NULL Salary Grade

Prompt Table: SAL_GRADE_TBL

17 GRADE_ENTRY_DT Date(10) DATE Grade Entry Date
18 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
19 SETID_DEPT Character(5) VARCHAR2(5) NOT NULL Department Set ID
20 SETID_JOBCODE Character(5) VARCHAR2(5) NOT NULL Job Code Set ID
21 SETID_LOCATION Character(5) VARCHAR2(5) NOT NULL Location Set ID
22 SETID_SALARY Character(5) VARCHAR2(5) NOT NULL Salary Set ID
23 REG_REGION Character(5) VARCHAR2(5) NOT NULL Regulatory Region
24 REG_REGION_COUNTRY Character(3) VARCHAR2(3) NOT NULL Reg Region Country
25 REPORTS_TO Character(8) VARCHAR2(8) NOT NULL Reports To Position Number
26 ESTABID Character(12) VARCHAR2(12) NOT NULL Establishment ID
27 PAY_SYSTEM_FLG Character(2) VARCHAR2(2) NOT NULL Payroll System
GP=Global Payroll
NA=Payroll for North America
OT=Other
PI=Payroll Interface
28 PAYGROUP Character(3) VARCHAR2(3) NOT NULL Pay Group
29 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group
30 FULL_PART_TIME Character(1) VARCHAR2(1) NOT NULL Full/Part Time
D=On Demand
F=Full-Time
P=Part-Time
31 STD_HOURS Number(7,2) DECIMAL(6,2) NOT NULL Standard Hours
32 STEP Number(2,0) SMALLINT NOT NULL Step