POSN_INCUMB_WS (SQL View)	Index Back
Posn Incumbents-Wrk Scroll POSN_INCUMB_WS is a view which retrieves the current incumbents of a position by EmplID. This view is used in a work scroll on the Position Data 1 panel to support the cross-update to Job and Employment for current incumbents.

POSN_INCUMB_WS

(SQL View)

Posn Incumbents-Wrk Scroll

POSN_INCUMB_WS is a view which retrieves the current incumbents of a position by EmplID. This view is used in a work scroll on the Position Data 1 panel to support the cross-update to Job and Employment for current incumbents.

SELECT A.Emplid ,A.EMPL_RCD ,A.POSITION_NBR ,A.APPT_TYPE ,A.POSITION_OVERRIDE ,A.STD_HOURS ,A.FULL_PART_TIME FROM PS_JOB A WHERE A.HR_STATUS = 'A' AND A.Position_Nbr <> ' ' AND A.Effdt = ( SELECT MAX(C.EffDt) FROM PS_JOB C WHERE C.Emplid = A.Emplid AND C.EMPL_RCD = A.EMPL_RCD AND C.EffDt <= %CurrentDateIn) AND 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)

# 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 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number

4 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

5 POSITION_OVERRIDE Character(1) VARCHAR2(1) NOT NULL Override Position Data

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

7 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	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
3	POSITION_NBR	Character(8)	VARCHAR2(8) NOT NULL	Position Number
4	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
5	POSITION_OVERRIDE	Character(1)	VARCHAR2(1) NOT NULL	Override Position Data
6	STD_HOURS	Number(7,2)	DECIMAL(6,2) NOT NULL	Standard Hours
7	FULL_PART_TIME	Character(1)	VARCHAR2(1) NOT NULL	Full/Part Time D=On Demand F=Full-Time P=Part-Time