TL_OT_EPHOTO_VW (SQL View)	Index Back
OT Employee Photo TL OT Employee Photo used in Fluid Approval

TL_OT_EPHOTO_VW

(SQL View)

OT Employee Photo

TL OT Employee Photo used in Fluid Approval

SELECT A.EMPLID , A.EMPL_RCD ,A.TL_SEQ_NUM , B.EMPLOYEE_PHOTO FROM %Table(TL_OT_DATA) A , %Table(USER_PH_LIST_FL) B WHERE A.EMPLID = B.EMPLID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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

3 TL_SEQ_NUM Number(5,0) INTEGER NOT NULL Table Lookup Sequence Number

4 EMPLOYEE_PHOTO Image / Attachment(256) VARCHAR2(256) Employee Photograph

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
3	TL_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Table Lookup Sequence Number
4	EMPLOYEE_PHOTO	Image / Attachment(256)	VARCHAR2(256)	Employee Photograph