POSN_INCUMB_WS1

(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 FROM PS_JOB A , PS_PERSON_NAME B 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) AND B.EMPLID = A.EMPLID

  • Related Language Record: PERSON_NAME_LNG

    • # 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