JOB_OTH_VW (SQL View)	Index Back
Other Job Records JOB_OTH_VW is used within Job Data to screen on Multiple Jobs. It selects all 'other' Concurrent Job records for the 'active' Employment record. Only the highest Sequence Numbers by Effective Date are considered.

JOB_OTH_VW

(SQL View)

Other Job Records

JOB_OTH_VW is used within Job Data to screen on Multiple Jobs. It selects all 'other' Concurrent Job records for the 'active' Employment record. Only the highest Sequence Numbers by Effective Date are considered.

SELECT A.EMPLID , A.EMPL_RCD , B.EMPL_RCD , B.EFFDT , B.EMPL_STATUS , B.JOB_INDICATOR , B.STD_HOURS , B.STD_HRS_FREQUENCY , B.FTE , B.ACTION , B.APPT_TYPE , B.COMPANY , B.BUSINESS_UNIT , B.SAL_ADMIN_PLAN , B.ACTION_REASON FROM PS_PER_ORG_ASGN A , PS_JOB B WHERE A.EMPLID = B.EMPLID AND A.EMPL_RCD <> B.EMPL_RCD AND B.EFFSEQ = ( SELECT MAX(EFFSEQ) FROM PS_JOB WHERE EMPLID = B.EMPLID AND EMPL_RCD = B.EMPL_RCD AND EFFDT = B.EFFDT)

Parent record: PER_ORG_ASGN_VW

# 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 EMPL_RCD_OTH Number(3,0) SMALLINT NOT NULL Other Employment Rcd Nbr

4 EFFDT_OTH Date(10) DATE Other Effective Date

5 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

6 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

7 STD_HOURS Number(7,2) DECIMAL(6,2) NOT NULL Standard Hours

8 STD_HRS_FREQUENCY Character(5) VARCHAR2(5) NOT NULL Standard Work Period

9 FTE Number(8,6) DECIMAL(7,6) NOT NULL This field represent Full Time Equivalence

10 ACTION Character(3) VARCHAR2(3) NOT NULL Action
Prompt Table: ACTION_TBL

11 APPT_TYPE Character(1) VARCHAR2(1) NOT NULL This field tracks whether a row is a Main Appointment (which all rows outside Japan are), or an Additional Appointment, which is a feature only used by Japanese customers.
0=Core Appointment
1=Japan Kenmu Appointment
2=French Public Sector Appt
3=Staffing

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

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

14 SAL_ADMIN_PLAN Character(4) VARCHAR2(4) NOT NULL Salary Administration Plan

15 ACTION_REASON Character(3) VARCHAR2(3) NOT NULL Reason Code

#	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	EMPL_RCD_OTH	Number(3,0)	SMALLINT NOT NULL	Other Employment Rcd Nbr
4	EFFDT_OTH	Date(10)	DATE	Other Effective Date
5	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
6	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
7	STD_HOURS	Number(7,2)	DECIMAL(6,2) NOT NULL	Standard Hours
8	STD_HRS_FREQUENCY	Character(5)	VARCHAR2(5) NOT NULL	Standard Work Period
9	FTE	Number(8,6)	DECIMAL(7,6) NOT NULL	This field represent Full Time Equivalence
10	ACTION	Character(3)	VARCHAR2(3) NOT NULL	Action Prompt Table: ACTION_TBL
11	APPT_TYPE	Character(1)	VARCHAR2(1) NOT NULL	This field tracks whether a row is a Main Appointment (which all rows outside Japan are), or an Additional Appointment, which is a feature only used by Japanese customers. 0=Core Appointment 1=Japan Kenmu Appointment 2=French Public Sector Appt 3=Staffing
12	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
13	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
14	SAL_ADMIN_PLAN	Character(4)	VARCHAR2(4) NOT NULL	Salary Administration Plan
15	ACTION_REASON	Character(3)	VARCHAR2(3) NOT NULL	Reason Code