JPM_PERS_PRF_VW

(SQL View)
 Index Back

Active person profiles


SELECT JPM_PROFILE_ID , EMPLID , JPM_JP_TYPE FROM PS_JPM_PROFILE WHERE JPM_JP_PRFL_STATUS = 'A' AND jpm_profile_usage = 'P'

# 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 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: %EDITTABLE2

3 JPM_JP_TYPE Character(12) VARCHAR2(12) NOT NULL Profile Type name for a JPM Profile Type

Prompt Table: %EDITTABLE