FMLA_EMPLMNT_VW (SQL View)	Index Back
Vw-Employment data for FMLA This view of Employment is used in the FMLA module as the source for a hidden work scroll. The view assists in retrieving information about all active job positions for an employee for use in the determination of eligibility for FMLA protected leave.

FMLA_EMPLMNT_VW

(SQL View)

Vw-Employment data for FMLA

This view of Employment is used in the FMLA module as the source for a hidden work scroll. The view assists in retrieving information about all active job positions for an employee for use in the determination of eligibility for FMLA protected leave.

SELECT EMPLID ,EMPL_RCD ,'A' FROM PS_PER_ORG_ASGN WHERE PER_ORG = 'EMP'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Default Value: PERSON.EMPLID
Prompt Table: PERSON

2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr

3 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