JPM_APRFOTO_VW (SQL View)	Index Back
Profile Approval Photo Profile Approval Transaction Header record.

JPM_APRFOTO_VW

(SQL View)

Profile Approval Photo

Profile Approval Transaction Header record.

SELECT HDR.JPM_PROFILE_ID , HDR.JPM_JP_TRAN_NUM , PRF.EMPLID , PH.EMPLOYEE_PHOTO FROM PS_JPM_JP_WF_HDR HDR , PS_JPM_PROFILE PRF , PS_USER_PH_LIST_FL PH WHERE PRF.JPM_PROFILE_ID = HDR.JPM_PROFILE_ID AND PH.EMPLID=PRF.EMPLID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 JPM_PROFILE_ID Character(12) VARCHAR2(12) NOT NULL The id, autoassigned or user assigned of the profile. This id is used to group items and other related material together into one coherent profile.

2 JPM_JP_TRAN_NUM Number(12,0) DECIMAL(12) NOT NULL Transaction Number assigned by JPM when Profile updates are submitted for approval.

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

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	JPM_PROFILE_ID	Character(12)	VARCHAR2(12) NOT NULL	The id, autoassigned or user assigned of the profile. This id is used to group items and other related material together into one coherent profile.
2	JPM_JP_TRAN_NUM	Number(12,0)	DECIMAL(12) NOT NULL	Transaction Number assigned by JPM when Profile updates are submitted for approval.
3	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
4	EMPLOYEE_PHOTO	Image / Attachment(256)	VARCHAR2(256)	Employee Photograph