JPM_APRPTYP_LVW (SQL View)	Index Back
Profile Approval Profile Type Profile Approval Transaction Header record.

JPM_APRPTYP_LVW

(SQL View)

Profile Approval Profile Type

Profile Approval Transaction Header record.

SELECT HDR.JPM_PROFILE_ID , HDR.JPM_JP_TRAN_NUM , TYP.LANGUAGE_CD , TYP.DESCR FROM PS_JPM_JP_WF_HDR HDR , PS_JPM_PROFILE PRF , PS_JPM_JP_TYPE_LNG TYP WHERE PRF.JPM_PROFILE_ID = HDR.JPM_PROFILE_ID AND TYP.JPM_JP_TYPE = PRF.JPM_JP_TYPE AND %EffdtCheck(JPM_JP_TYPES T1, TYP, %CurrentDateIn)

Related Language Record for JPM_APRPTYP_VW

# 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

4 JPM_PROFTYPE_DESCR Character(30) VARCHAR2(30) NOT NULL Profile Type

#	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	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
4	JPM_PROFTYPE_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Profile Type