FPAPTIM_VW2 (SQL View)	Index Back
Aptitude Image View (Red)

FPAPTIM_VW2

(SQL View)

Aptitude Image View (Red)

SELECT A.CAPABILITY_CD_FRA , B.FP_IMAGE_KEY , B.FP_IMAGE FROM PS_PHYSICAL_EXAM A , PS_FPM_IMAGE_TBL B WHERE B.FP_IMAGE_KEY = 'IM006'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 FP_SKLCATG_SKL Character(1) VARCHAR2(1) NOT NULL Comptncies Categ Capture Comp

2 FP_IMAGE_KEY Character(5) VARCHAR2(5) NOT NULL Image Key

3 FP_IMAGE Image / Attachment CLOB Competencies Image

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	FP_SKLCATG_SKL	Character(1)	VARCHAR2(1) NOT NULL	Comptncies Categ Capture Comp
2	FP_IMAGE_KEY	Character(5)	VARCHAR2(5) NOT NULL	Image Key
3	FP_IMAGE	Image / Attachment	CLOB	Competencies Image