EMPLIDEMPL_RCD0=Core Appointment
1=Japan Kenmu Appointment
2=French Public Sector Appt
3=Staffing
D=On Demand
F=Full-Time
P=Part-Time
POSN_INCUMB_WS1(SQL View) |
Index Back |
|---|---|
Posn Incumbents-Wrk ScrollPOSN_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.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 |
| # | 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 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
| 4 | POSITION_OVERRIDE | Character(1) | VARCHAR2(1) NOT NULL | Override Position Data |
| 5 | POSITION_NBR | Character(8) | VARCHAR2(8) NOT NULL | Position Number |
| 6 | 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 |
| 7 | STD_HOURS | Number(7,2) | DECIMAL(6,2) NOT NULL | Standard Hours |
| 8 | FULL_PART_TIME | Character(1) | VARCHAR2(1) NOT NULL |
Full/Part Time
D=On Demand F=Full-Time P=Part-Time |