HRS_PRI_JOB_I (SQL View)	Index Back
Primary Job View - HR HRS_PRI_JOB_I IS THE INTERFACE VIEW FOR PRIMARY_JOB_VW and is used to return the most current Primary Job information at a certain Effective Date for an Employee . This view is for use only by ERP

HRS_PRI_JOB_I

(SQL View)

Primary Job View - HR

HRS_PRI_JOB_I IS THE INTERFACE VIEW FOR PRIMARY_JOB_VW and is used to return the most current Primary Job information at a certain Effective Date for an Employee . This view is for use only by ERP

SELECT EMPLID ,EFFDT ,EMPL_RCD ,EFFSEQ ,DEPTID ,JOBCODE ,POSITION_NBR ,EMPL_STATUS ,LOCATION ,BUSINESS_UNIT ,JOB_INDICATOR ,COMPANY ,PAYGROUP ,TAX_LOCATION_CD ,REG_TEMP ,FULL_PART_TIME FROM PS_PRIMARY_JOB_VW

Parent record: JOB_DATE_VW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

2 EFFDT Date(10) DATE Effective Date

3 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr

4 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence

5 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

6 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code

7 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number

8 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

9 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

10 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

11 JOB_INDICATOR Character(1) VARCHAR2(1) NOT NULL This Indicator is used on JOB to specify which employment record is considered to be the primary one for an employee. In case of Multiple Jobs per Employee, this property is being used to make a conscious decision in related features where only 1 Employment Record per Employee needs to be returned.
N=Not Applicable
P=Primary Job
S=Secondary Job

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

13 PAYGROUP Character(3) VARCHAR2(3) NOT NULL Pay Group

14 TAX_LOCATION_CD Character(10) VARCHAR2(10) NOT NULL Tax Location Code

15 REG_TEMP Character(1) VARCHAR2(1) NOT NULL Regular/Temporary
R=Regular
T=Temporary

16 FULL_PART_TIME Character(1) VARCHAR2(1) NOT NULL Full/Part Time
D=On Demand
F=Full-Time
P=Part-Time

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	EFFDT	Date(10)	DATE	Effective Date
3	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
4	EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Effective Sequence
5	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
6	JOBCODE	Character(6)	VARCHAR2(6) NOT NULL	Job Code
7	POSITION_NBR	Character(8)	VARCHAR2(8) NOT NULL	Position Number
8	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
9	LOCATION	Character(10)	VARCHAR2(10) NOT NULL	Location Code
10	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
11	JOB_INDICATOR	Character(1)	VARCHAR2(1) NOT NULL	This Indicator is used on JOB to specify which employment record is considered to be the primary one for an employee. In case of Multiple Jobs per Employee, this property is being used to make a conscious decision in related features where only 1 Employment Record per Employee needs to be returned. N=Not Applicable P=Primary Job S=Secondary Job
12	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
13	PAYGROUP	Character(3)	VARCHAR2(3) NOT NULL	Pay Group
14	TAX_LOCATION_CD	Character(10)	VARCHAR2(10) NOT NULL	Tax Location Code
15	REG_TEMP	Character(1)	VARCHAR2(1) NOT NULL	Regular/Temporary R=Regular T=Temporary
16	FULL_PART_TIME	Character(1)	VARCHAR2(1) NOT NULL	Full/Part Time D=On Demand F=Full-Time P=Part-Time