HR_EH_JOB_VW

(SQL View)
 Index Back

Header ID Job View

Header Data; This view retrieve all Job data needed for the Employee Header.

SELECT A.EMPLID , A.EMPL_RCD , A.EFFDT , A.EFFSEQ , A.PER_ORG , A.DEPTID , A.DEPT_ENTRY_DT , A.JOBCODE , A.JOB_ENTRY_DT , A.POSITION_NBR , A.POSITION_ENTRY_DT , A.REG_TEMP , 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 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence
5 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
6 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

Prompt Table: DEPT_TBL

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

Prompt Table: JOBCODE_TBL

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

Prompt Table: LOCATION_TBL

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

Prompt Table: COMPANY_TBL

17 SAL_ADMIN_PLAN Character(4) VARCHAR2(4) NOT NULL Salary Administration Plan
18 GRADE Character(3) VARCHAR2(3) NOT NULL Salary Grade

Prompt Table: SAL_GRADE_TBL

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