POSN_INCUMB_WS2

(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.

SELECT A.EMPLID, A.EMPL_RCD, B.NAME, A.EFFDT, A.ACTION, A.ACTION_REASON, A.POSITION_OVERRIDE, A.POSITION_NBR, A.APPT_TYPE, A.STD_HOURS, A.FULL_PART_TIME, A.HR_STATUS FROM PS_JOB A, PS_PERSON_NAME B WHERE A.EMPLID = B.EMPLID AND A.POSITION_NBR <> ' ' 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 NAME Character(50) VARCHAR2(50) NOT NULL Name
4 EFFDT Date(10) DATE Effective Date

Default Value: %date

5 ACTION Character(3) VARCHAR2(3) NOT NULL Action
6 ACTION_REASON Character(3) VARCHAR2(3) NOT NULL Reason Code
7 POSITION_OVERRIDE Character(1) VARCHAR2(1) NOT NULL Override Position Data
8 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number
9 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
10 STD_HOURS Number(7,2) DECIMAL(6,2) NOT NULL Standard Hours
11 FULL_PART_TIME Character(1) VARCHAR2(1) NOT NULL Full/Part Time
D=On Demand
F=Full-Time
P=Part-Time
12 HR_STATUS Character(1) VARCHAR2(1) NOT NULL HR Status
A=Active
I=Inactive