JPM_APRNAME_VW (SQL View)	Index Back
Profile Approval Name Profile Approval Transaction Header record.

JPM_APRNAME_VW

(SQL View)

Profile Approval Name

Profile Approval Transaction Header record.

SELECT HDR.JPM_PROFILE_ID , HDR.JPM_JP_TRAN_NUM , PRF.EMPLID , NAM.NAME_DISPLAY FROM PS_JPM_JP_WF_HDR HDR , PS_JPM_PROFILE PRF , PS_NAMES NAM WHERE PRF.JPM_PROFILE_ID = HDR.JPM_PROFILE_ID AND NAM.EMPLID = PRF.EMPLID AND NAM.NAME_TYPE = 'PRI' AND NAM.EFFDT = ( SELECT MAX(NAM1.EFFDT) FROM PS_NAMES NAM1 WHERE NAM1.EMPLID = NAM.EMPLID AND NAM1.NAME_TYPE = NAM.NAME_TYPE AND NAM1.EFFDT <= %CurrentDateIn )

Related Language Record: JPM_APRNAME_LVW

# 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 NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Display Name - name formatted for Display based on the Country

#	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	NAME_DISPLAY	Character(50)	VARCHAR2(50) NOT NULL	Display Name - name formatted for Display based on the Country