POSN_INCUMBENTS

(SQL View)
 Index Back

Posn Incumbents - Comp Data

POSN_INCUMBENTS is a view which retrieves compensation information for the current incumbent(s) of a position. It is used in the Position Management application.

SELECT A.POSITION_NBR ,A.EMPLID ,A.EMPL_RCD ,A.EFFSEQ ,A.EMPL_STATUS ,A.BUSINESS_UNIT ,A.SAL_ADMIN_PLAN ,A.GRADE ,A.STEP ,A.POSITION_ENTRY_DT ,A.STD_HOURS ,A.ANNUAL_RT ,A.CURRENCY_CD ,A.FULL_PART_TIME ,A.REG_TEMP ,A.FTE ,A.EFFDT ,A.COMP_FREQUENCY ,A.COMPRATE 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 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number

Prompt Table: POSITION_DATA

2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: PERSON

3 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
4 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence
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 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
7 SAL_ADMIN_PLAN Character(4) VARCHAR2(4) NOT NULL Salary Administration Plan
8 GRADE Character(3) VARCHAR2(3) NOT NULL Salary Grade
9 STEP Number(2,0) SMALLINT NOT NULL Step
10 POSITION_ENTRY_DT Date(10) DATE Position Entry Date
11 STD_HOURS Number(7,2) DECIMAL(6,2) NOT NULL Standard Hours
12 ANNUAL_RT Number(19,3) DECIMAL(18,3) NOT NULL Annual Rate
13 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

Default Value: OPR_DEF_TBL_HR.EXCHNG_TO_CURRENCY

Prompt Table: CURRENCY_CD_TBL

14 FULL_PART_TIME Character(1) VARCHAR2(1) NOT NULL Full/Part Time
D=On Demand
F=Full-Time
P=Part-Time
15 REG_TEMP Character(1) VARCHAR2(1) NOT NULL Regular/Temporary
R=Regular
T=Temporary
16 FTE Number(8,6) DECIMAL(7,6) NOT NULL This field represent Full Time Equivalence
17 EFFDT Date(10) DATE Effective Date

Default Value: %date

18 COMP_FREQUENCY Character(5) VARCHAR2(5) NOT NULL Compensation Frequency
A=Annual
B=Biweekly
C=Contract
D=Daily
H=Hourly
M=Monthly
S=Semimonthly
W=Weekly
19 COMPRATE Number(19,6) DECIMAL(18,6) NOT NULL Compensation Rate