EMPL_RLV_ESP_VW (SQL View)	Index Back
Employee Relieve VW ESP This view retrieves the Substitution data for Contracts

EMPL_RLV_ESP_VW

(SQL View)

Employee Relieve VW ESP

This view retrieves the Substitution data for Contracts

SELECT A.EMPLID , A.CONTRACT_NUM , A.EFFDT , A.SUBSTN_EMPLID_ESP , C.NAME FROM PS_WKF_CNT_TYP_ESP A LEFT OUTER JOIN PS_PERSON_NAME C ON A.SUBSTN_EMPLID_ESP = C.EMPLID

Parent record: EMPL_CTG_L2

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract Number

3 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

4 SUBSTN_EMPLID_ESP Character(11) VARCHAR2(11) NOT NULL Replaced Empl ID

5 NAME Character(50) VARCHAR2(50) NOT NULL Name

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	CONTRACT_NUM	Character(25)	VARCHAR2(25) NOT NULL	Contract Number
3	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
4	SUBSTN_EMPLID_ESP	Character(11)	VARCHAR2(11) NOT NULL	Replaced Empl ID
5	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name