EMPL_TUT_ESP_VW (SQL View)	Index Back
Employee Tutor VW ESP Employee Tutor VW ESP

EMPL_TUT_ESP_VW

(SQL View)

Employee Tutor VW ESP

SELECT A.EMPLID , A.CONTRACT_NUM , A.EFFDT , A.TUTOR_ID_ESP , B.NAME , A.REPRESNT_ROLE_ESP FROM PS_WKF_CNT_TYP_ESP A , PS_PERSON_NAME B WHERE A.TUTOR_ID_ESP = B.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 TUTOR_ID_ESP Character(11) VARCHAR2(11) NOT NULL Tutor ID

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

6 REPRESNT_ROLE_ESP Character(50) VARCHAR2(50) NOT NULL Representative Role

#	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	TUTOR_ID_ESP	Character(11)	VARCHAR2(11) NOT NULL	Tutor ID
5	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
6	REPRESNT_ROLE_ESP	Character(50)	VARCHAR2(50) NOT NULL	Representative Role