TL_TCD_SUPRV_VW (SQL View)	Index Back
TCD Supervisor Prompt View Prompt to assign Supe

TL_TCD_SUPRV_VW

(SQL View)

TCD Supervisor Prompt View

Prompt to assign Supe

SELECT DISTINCT A.TCD_SUPERVISR_ID , A.EMPLID , B.NAME FROM PS_TL_TCD_SUPERV A , PS_PERSON_NAME B WHERE A.EMPLID = B.EMPLID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 TCD_SUPERVISR_ID Character(20) VARCHAR2(20) NOT NULL TCD Supervisor ID

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

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	TCD_SUPERVISR_ID	Character(20)	VARCHAR2(20) NOT NULL	TCD Supervisor ID
2	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
3	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name