CM_JPM_EPRFL_LV (SQL View)	Index Back
Active person profiles

CM_JPM_EPRFL_LV

(SQL View)

Active person profiles

SELECT A.JPM_PROFILE_ID ,B.LANGUAGE_CD ,B.NAME_DISPLAY FROM PS_JPM_PROFILE A , PS_NAMES_LNG B WHERE B.EMPLID = A.EMPLID AND B.NAME_TYPE = 'PRI' AND %EffdtCheck(NAMES_LNG, B, %CurrentDateIn)

Related Language Record for CM_JPM_EPRFL_VW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

3 NAME Character(50) VARCHAR2(50) NOT NULL Name

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CM_JP_PER_PRFL_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	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
3	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name