JPM_PRFL_LNG_VW

(SQL View)
 Index Back

JPM Profile alias lang descr

The profile ID and other header information for a profile but uses the language field descr. It is used for the Find Non-Person Profiles component.

SELECT A.JPM_PROFILE_ID ,B.DESCR ,A.JPM_JP_PRFL_STATUS ,A.JPM_PROFILE_USAGE ,A.EMPLID ,A.JPM_LGCY_PRFL_ID ,A.JPM_JP_TYPE ,A.JPM_OWNER_EMPLID ,A.STATUS_DT ,A.JPM_SUBSCRIBE ,B.LANGUAGE_CD FROM PS_JPM_PROFILE A , PS_JPM_PROFILE_LNG B WHERE A.JPM_PROFILE_ID = B.JPM_PROFILE_ID

# 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 DESCR1 Character(30) VARCHAR2(30) NOT NULL Descr
3 JPM_JP_PRFL_STATUS Character(1) VARCHAR2(1) NOT NULL Status of JPM Profile
A=Active
I=Inactive

Default Value: A

4 JPM_PROFILE_USAGE Character(1) VARCHAR2(1) NOT NULL Value used to specify how the profile is used in business logic. This profile may represent a person profile, a profile in progress and not available for use, a job profile, etc.
J=Non-Person
P=Person
5 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
6 JPM_LGCY_PRFL_ID Character(12) VARCHAR2(12) NOT NULL Previous Profile ID that has been carried across during upgrade of Profiles to JPM
7 JPM_JP_TYPE Character(12) VARCHAR2(12) NOT NULL Profile Type name for a JPM Profile Type
8 JPM_OWNER_EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID (or person id) of the owner of the profile.
9 STATUS_DT Date(10) DATE Status Date

Default Value: %date

10 JPM_SUBSCRIBE Character(1) VARCHAR2(1) NOT NULL JPM Subscribe field

Y/N Table Edit

Default Value: N

11 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code