JPM_PRF_JOBCD_I (SQL View)	Index Back
Job Code Profile Identifier Vw Returns all active and end non-person profiles having an active JOB_CODE profile identifier.

JPM_PRF_JOBCD_I

(SQL View)

Job Code Profile Identifier Vw

Returns all active and end non-person profiles having an active JOB_CODE profile identifier.

SELECT X.JPM_CAT_SETID , %Substring( X.JPM_RLAT_KEY1, 1,6) , P.JPM_JP_TYPE , X.JPM_PROFILE_ID FROM PS_JPM_JP_X_RLAT X , PS_JPM_PROFILE P , PS_JPM_JP_TYPES T WHERE X.JPM_RLAT_NAME = 'JOB_CODE' AND %EffdtCheck(JPM_JP_X_RLAT X1, X, %Currentdatein) AND X.EFF_STATUS = 'A' AND P.JPM_PROFILE_ID = X.JPM_PROFILE_ID AND P.JPM_JP_PRFL_STATUS = 'A' AND T.JPM_JP_TYPE = P.JPM_JP_TYPE AND %EffdtCheck(JPM_JP_TYPES T1, T, %Currentdatein) AND T.JPM_JP_END_PROFILE = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

2 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code

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

4 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.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
2	JOBCODE	Character(6)	VARCHAR2(6) NOT NULL	Job Code
3	JPM_JP_TYPE	Character(12)	VARCHAR2(12) NOT NULL	Profile Type name for a JPM Profile Type
4	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.